INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6406, 1, 145, 2, 0, NULL, 0, '2025-01-07 07:03:36', '2025-01-07 09:18:25', '2025-01-07', 'P6023', '25-07857-01-07', '', 0.00, 171.00, 36.34, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 209.41, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-070125-Mxw5qtTij7vbc-074', 'da78f529-4e16-496c-83fa-a33e60bff842', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-Mxw5qtTij7vbc-074&s=KOL2025&nf=P6023&i=209.41&cr=056', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6407, 1, 932, 1, 0, NULL, 0, '2025-01-07 10:58:04', '2025-01-07 10:58:04', '2025-01-07', 'P6024', '', '', 0.00, 85.50, 18.38, 0.00, 0, 0.00, 2.50, 'Calle Acera del Pilar, edificio residencial casa fuerte local 2 ', 'Almuñécar', 'Granada', '18697 ', 'España', 105.95, 0, '2025-01-07 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-070125-CQe2MhgSUMxFc-050', 'fa5ad45d-5c41-47cc-961e-3f28ce1a8bb1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-CQe2MhgSUMxFc-050&s=KOL2025&nf=P6024&i=105.95&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6408, 1, 1601, 2, 0, NULL, 0, '2025-01-07 13:19:48', '2025-01-07 15:20:37', '2025-01-07', 'P6025', '25-07858-01-07', 'Es un edificio de oficinas. Entregar en recepción. Horario de lunes a viernes de 8:00 a 18:00 ininterrumpido ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Recepción de edificio CEIN, Polígono Mocholi, n°5', 'Noáin (Valle de Elor', 'Navarra', '31110', 'España', 28.39, 0, '2025-01-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-070125-ekd0oEIuwqoMI-223', 'f26975dc-72f4-4396-8638-913758dee8a2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-ekd0oEIuwqoMI-223&s=KOL2025&nf=P6025&i=28.39&cr=033', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6409, 1, 521, 2, 0, NULL, 0, '2025-01-07 13:39:21', '2025-01-07 15:21:25', '2025-01-07', 'P6026', '25-07859-01-07', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/ Vidangoz 7 4 izd ', 'Pamplona/Iruña', 'Navarra', '31014', 'España', 65.52, 0, '2025-01-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-070125-V3WHCaJ26zx4z-241', 'dc59ee5b-707e-41ac-ac86-e8c2b8b7c2f3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-V3WHCaJ26zx4z-241&s=KOL2025&nf=P6026&i=65.52&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6410, 1, 166, 1, 0, NULL, 0, '2025-01-07 15:24:49', '2025-01-07 15:25:03', '2025-01-07', 'P6027', '', '', 0.00, 145.86, 30.63, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 176.49, 0, '2025-01-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070125-MsGuP6PJ1M88Q-090', 'f363c6df-b3d0-4507-b417-fda19f02a4e2', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-MsGuP6PJ1M88Q-090&s=KOL2025&nf=P6027&i=176.49&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6411, 1, 166, 1, 0, NULL, 0, '2025-01-07 15:26:41', '2025-01-07 15:26:41', '2025-01-10', 'P6028', '', '', 0.00, 85.80, 18.02, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 103.82, 0, '2025-01-07 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100125-b2atKhqE7IIiT-245', 'aa9bbea3-25a3-4210-9691-7cec6d7689f9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100125-b2atKhqE7IIiT-245&s=KOL2025&nf=P6028&i=103.82&cr=088', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6412, 1, 4, 2, 0, NULL, 0, '2025-01-07 15:44:56', '2025-01-07 17:23:43', '2025-01-07', 'P6029', '25-07861-01-07', '', 0.00, 244.28, 51.30, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 295.58, 0, '2025-01-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070125-eH6yj3p2Zj8MZ-182', '0a3e694d-2bb8-47d4-aa88-a23be867d11d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070125-eH6yj3p2Zj8MZ-182&s=KOL2025&nf=P6029&i=295.58&cr=016', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6413, 1, 1602, 2, 0, NULL, 0, '2025-01-07 18:27:37', '2025-01-08 12:22:37', '2025-01-08', 'P6030', '25-07862-01-07', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Antziola, 1B, A', 'Hernani', 'Gipuzkoa', '20120', 'España', 17.50, 0, '2025-01-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-080125-TLhzPHdWa/v9h-241', 'a481f126-c518-409a-972a-142ec06b296e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-TLhzPHdWa%2Fv9h-241&s=KOL2025&nf=P6030&i=17.50&cr=232', '[BLOB]', 0, 'PRANHY071000001X', '2025-01-08 09:51:24', '[BLOB]', 2, '', '2025-01-08', 'S0133', 20, 10, 15, 100, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6414, 1, 174, 2, 0, NULL, 0, '2025-01-07 20:00:35', '2025-01-08 09:20:03', '2025-01-08', 'P6031', '25-07863-01-07', 'Hola ,he visto que continuáis sin stock del rubio extra claro ,\r\nya me dices si es así.\r\nun saludo', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 172.43, 0, '2025-01-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080125-bHQeRPg8le4nk-019', '10919b58-8f4f-4c2f-8064-f1d3de60a250', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-bHQeRPg8le4nk-019&s=KOL2025&nf=P6031&i=172.43&cr=162', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6415, 1, 1603, 2, 0, NULL, 0, '2025-01-07 21:11:05', '2025-01-08 16:09:43', '2025-01-08', 'P6042', '25-07864-01-07', '', 0.00, 41.49, 9.48, 0.00, 0, 0.00, 4.40, 'Carrer major 53 (capicua)', 'Seu d\'Urgell (La)', 'Lleida', '25700', 'España', 54.60, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080125-TGXotqL3pSinm-146', '0cfd2044-2b61-48a1-b6fb-cb2be3d1135c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-TGXotqL3pSinm-146&s=KOL2025&nf=P6042&i=54.60&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(6416, 1, 525, 2, 0, NULL, 0, '2025-01-07 21:43:10', '2025-01-08 12:17:56', '2025-01-08', 'P6032', '25-07865-01-07', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Paseo del prior 73 3 B', 'Logroño', 'La Rioja', '26004', 'España', 65.52, 0, '2025-01-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080125-NRRMAdIN0C33A-172', '854fb474-2279-43c3-870f-d0083b5bacdf', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080125-NRRMAdIN0C33A-172&s=KOL2025&nf=P6032&i=65.52&cr=244', '[BLOB]', 0, 'PRANHY071000002B', '2025-01-08 12:18:13', '[BLOB]', 2, '', '2025-01-08', 'S0133', 20, 10, 15, 500, 0, '', 1, 1);
