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
(4527, 1, 77, 1, 0, NULL, 0, '2024-02-05 10:56:50', '2024-02-05 10:56:50', '2024-02-05', 'P4238', '', '', 0.00, 38.61, 8.11, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 46.72, 0, '2024-02-05 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050224-MUCE/2V8gtJzH-173', '607a10e1-0980-4554-8855-adc4d949edc8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050224-MUCE%2F2V8gtJzH-173&s=KOL2024&nf=P4238&i=46.72&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4528, 1, 67, 2, 0, NULL, 0, '2024-02-05 11:07:50', '2024-02-05 13:20:08', '2024-02-05', 'P4240', '24-05815-02-05', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Fragoso 36 bis ,bajo 4', 'Vigo', 'Pontevedra', '36210', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-050224-a5LRn0X10gyik-129', 'bed30971-437f-497c-a21f-822d15272fb4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050224-a5LRn0X10gyik-129&s=KOL2024&nf=P4240&i=206.91&cr=030', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4529, 1, 933, 2, 0, NULL, 0, '2024-02-05 15:14:30', '2024-02-06 09:26:51', '2024-02-05', 'P4241', '24-05816-02-05', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Mayor, 4A', 'Manises', 'Valencia', '46940', 'España', 30.61, 0, '2024-02-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050224-Y5sXa5JtRBQ1O-137', '2da1fe37-5f29-4967-a6c7-8e936608b84b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050224-Y5sXa5JtRBQ1O-137&s=KOL2024&nf=P4241&i=30.61&cr=164', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4530, 1, 246, 2, 0, NULL, 0, '2024-02-05 16:43:25', '2024-02-06 10:32:24', '2024-02-05', 'P4242', '24-05817-02-05', 'peluqueria alberto hidalgo atelier', 0.00, 81.42, 17.10, 0.00, 0, 0.00, 0.00, 'Iparragirre 9, bis. ', 'Bilbao', 'BIZKAIA', '48009', 'ESPAÑA', 98.52, 0, '2024-02-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050224-LD8odcrDLmy2v-004', 'ade5e6ae-0b8b-483a-a202-97fd044d7289', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050224-LD8odcrDLmy2v-004&s=KOL2024&nf=P4242&i=98.52&cr=062', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4531, 1, 884, 2, 0, NULL, 0, '2024-02-05 22:43:50', '2024-02-06 09:27:32', '2024-02-05', 'P4243', '24-05818-02-05', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Lapurdi kalea 31 2b', 'Zarautz', 'Gipuzkoa', '20800', 'España', 65.52, 0, '2024-02-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-050224-YzYBvPAjgkeRE-179', '5c2ee90b-f397-4853-88e0-81b1811ac9c5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-050224-YzYBvPAjgkeRE-179&s=KOL2024&nf=P4243&i=65.52&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4532, 1, 1157, 2, 0, NULL, 0, '2024-02-06 01:58:35', '2024-02-06 09:27:47', '2024-02-06', 'P4244', '24-05819-02-06', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Francisco Aritio 62 local', 'Guadalajara', 'Guadalajara', '19004', 'España', 17.50, 0, '2024-02-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060224-OnYjPdCm1/+4x-121', '213cf235-359d-41bc-83e1-ea0c9a8388a4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060224-OnYjPdCm1%2F%2B4x-121&s=KOL2024&nf=P4244&i=17.50&cr=038', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(4533, 1, 388, 2, 0, NULL, 0, '2024-02-06 09:05:33', '2024-02-06 10:41:35', '2024-02-06', 'P4245', '24-05820-02-06', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'C/ León Felipe, 27, 7ºE', 'Zaragoza', 'Zaragoza', '50018', 'España', 52.39, 0, '2024-02-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060224-POMkbGIP94TNU-168', '77801617-ade0-4501-8d0a-a7650894f20a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060224-POMkbGIP94TNU-168&s=KOL2024&nf=P4245&i=52.39&cr=012', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4534, 1, 1158, 2, 0, NULL, 0, '2024-02-06 09:24:28', '2024-02-06 10:46:34', '2024-02-06', 'P4246', '24-05821-02-06', 'Horario de apertura martes a jueves 15:30 y viernes hasta 17:30', 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Republica Argentina 3, bajo 2', 'Irun', 'Gipuzkoa', '20302', 'España', 196.56, 0, '2024-02-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060224-NEy4AXgiZWegq-238', '6278197b-cc48-4d16-ab37-9a4553619d6a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060224-NEy4AXgiZWegq-238&s=KOL2024&nf=P4246&i=196.56&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4535, 1, 1159, 2, 0, NULL, 0, '2024-02-06 10:19:29', '2024-02-06 10:19:29', '2024-02-06', '', '24-05822-02-06', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Avd el Trapiche torre 6 local A', 'Marbella', 'Málaga', '29601', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4536, 1, 259, 2, 0, NULL, 0, '2024-02-06 10:51:28', '2024-02-06 11:56:01', '2024-02-06', 'P4247', '24-05823-02-06', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'GIPUZKOA KALEA 53  BAJO', 'Zarautz', 'Gipuzkoa', '20800', 'España', 206.91, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060224-LAOtJydANySwR-034', 'd804ae1e-6297-4c1c-a4f6-ccd88a36cb05', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060224-LAOtJydANySwR-034&s=KOL2024&nf=P4247&i=206.91&cr=123', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4537, 1, 253, 2, 0, NULL, 0, '2024-02-06 11:31:29', '2024-02-06 12:42:42', '2024-02-06', 'P4248', '24-05824-02-06', 'Llamar para instrucciones de la dirección ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Camino del molino s/n', 'Villamayor de Gálleg', 'Zaragoza', '50162', 'España', 28.39, 0, '2024-02-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-060224-mzW8ZdrW5DqEE-107', '47592aaa-c641-4a01-a9dd-7e9ae2e37915', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060224-mzW8ZdrW5DqEE-107&s=KOL2024&nf=P4248&i=28.39&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4538, 1, 397, 2, 0, NULL, 0, '2024-02-06 17:00:47', '2024-02-07 09:17:37', '2024-02-06', 'P4249', '24-05827-02-06', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Alberga 69 1° Izda', 'Errenteria', 'Gipuzkoa', '20100', 'España', 43.71, 0, '2024-02-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060224-XEYf39KSJCjdo-086', '942dea99-551b-4f17-bd94-053377187aa7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060224-XEYf39KSJCjdo-086&s=KOL2024&nf=P4249&i=43.71&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4539, 1, 71, 2, 0, NULL, 0, '2024-02-06 17:21:36', '2024-02-07 09:22:49', '2024-02-06', 'P4251', '24-05828-02-06', '', 0.00, 118.06, 24.79, 0.00, 0, 0.00, 0.00, 'Casiano martinez 40 4I', 'Vigo', 'Pontevedra', '36208', 'España', 142.85, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060224-LUMDfRRlF4yCV-192', '78bc1ff1-7040-459f-b584-c67d203aaa3d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060224-LUMDfRRlF4yCV-192&s=KOL2024&nf=P4251&i=142.85&cr=132', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(4540, 1, 765, 2, 0, NULL, 0, '2024-02-06 21:06:14', '2024-02-07 09:28:07', '2024-02-06', 'P4252', '24-05829-02-06', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Koldo Mitxelena plaza  9  bajo', 'Errenteria', 'Gipuzkoa', '20100', 'España', 344.85, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060224-V9dUEy+KCiNg8-140', '2de6cb69-0751-40ab-80c7-f73b56386f6e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060224-V9dUEy%2BKCiNg8-140&s=KOL2024&nf=P4252&i=344.85&cr=006', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4541, 1, 1160, 2, 0, NULL, 0, '2024-02-06 21:51:37', '2024-02-07 09:33:45', '2024-02-06', 'P4250', '24-05830-02-06', 'Si no hay nadie, dejar en 3°C o llamar ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ Fragua N°22, 3°D', 'Cistérniga', 'Valladolid', '47193', 'España', 30.61, 0, '2024-02-06 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-060224-Q0XHBq4J5SLzg-027', '72334761-3b28-4d54-8bce-471137e6ccd8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060224-Q0XHBq4J5SLzg-027&s=KOL2024&nf=P4250&i=30.61&cr=139', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4542, 1, 1161, 2, 0, NULL, 0, '2024-02-07 09:35:04', '2024-02-07 09:35:04', '2024-02-07', '', '24-05831-02-07', NULL, 0.00, 162.45, 34.11, 0.00, 0, 0.00, 0.00, 'Plaza Aldabe 6, bajo. Gasteiz.', 'Vitoria-Gasteiz', 'Álava', '01012', 'España', 196.56, 0, '0000-00-00 00:00:00', '', '', 1, 3, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(4543, 1, 1161, 2, 0, NULL, 0, '2024-02-07 09:36:48', '2024-02-07 10:37:44', '2024-02-07', 'P4253', '24-05832-02-07', '', 0.00, 57.00, 12.40, 0.00, 0, 0.00, 2.50, 'Plaza Aldabe 6, bajo. Gasteiz.', 'Vitoria-Gasteiz', 'Álava', '01012', 'España', 71.47, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-070224-GMw/dptUx/ZJG-168', '2b675aab-3c3d-4955-bbf5-ec0173dcd39e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070224-GMw%2FdptUx%2FZJG-168&s=KOL2024&nf=P4253&i=71.47&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4544, 1, 30, 2, 0, NULL, 0, '2024-02-07 10:32:12', '2024-02-07 11:56:51', '2024-02-07', 'P4254', '24-05833-02-07', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Calle González tablas, 3 bajo', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 275.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-070224-Ht/EgizRt1Yej-237', '4a5be112-3b41-4378-8a96-57afa1f248bc', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070224-Ht%2FEgizRt1Yej-237&s=KOL2024&nf=P4254&i=275.88&cr=085', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4545, 1, 152, 1, 0, NULL, 0, '2024-02-07 12:23:47', '2024-02-07 12:24:01', '2024-02-07', 'P4255', '2024-02-07', '', 0.00, 85.80, 18.02, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 103.82, 0, '2024-02-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070224-GQsXECN6c7qj0-178', '3e4036dc-f4b9-4177-8e09-151881d4e050', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070224-GQsXECN6c7qj0-178&s=KOL2024&nf=P4255&i=103.82&cr=206', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4546, 1, 190, 3, 0, NULL, 0, '2024-02-07 13:22:47', '2024-02-08 09:39:05', '2024-02-07', '', 'consumo interno', '', 0.00, 1526.70, 320.61, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 1847.31, 0, '2024-02-07 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4547, 1, 1162, 2, 0, NULL, 0, '2024-02-08 10:57:46', '2024-02-08 12:24:46', '2024-02-08', 'P4256', '24-05834-02-08', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle del Pilar 27', 'Casinos', 'Valencia', '46171', 'España', 28.39, 0, '2024-02-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080224-nMQhvuZIcgkr0-066', 'd8fe5411-4284-4afa-b055-db2e8e5f3da6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080224-nMQhvuZIcgkr0-066&s=KOL2024&nf=P4256&i=28.39&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(4548, 1, 381, 2, 0, NULL, 0, '2024-02-08 13:10:33', '2024-02-09 09:33:43', '2024-02-08', 'P4257', '24-05838-02-08', 'Por favor, avisar antes de la entrega al teléfono móvil 610684114. Gracias.', 0.00, 81.15, 17.04, 0.00, 0, 0.00, 0.00, 'C/ Felipe Abad León Nº 51, Embutidos Mariano Martínez', 'Santa Coloma', 'La Rioja', '26315', 'España', 98.19, 0, '2024-02-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080224-dxfy91d71st1e-072', 'bd353029-8905-4646-bb4e-1c3bfa2da4aa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080224-dxfy91d71st1e-072&s=KOL2024&nf=P4257&i=98.19&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4549, 1, 932, 2, 0, NULL, 0, '2024-02-08 14:25:40', '2024-02-09 09:33:57', '2024-02-08', 'P4258', '24-05839-02-08', 'Hola, me podrías mandar algún póster publicitario, gracias ', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Acera del Pilar, edificio Residencial casa Fuerte Local 2 peluquería ', 'Almuñécar', 'Granada', '18697', 'España', 103.46, 0, '2024-02-08 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-080224-TeAaj0fw6LKnI-064', '902a44ba-1485-4e3f-8d4f-102c33ee52b4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080224-TeAaj0fw6LKnI-064&s=KOL2024&nf=P4258&i=103.46&cr=083', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4550, 1, 1163, 2, 0, NULL, 0, '2024-02-08 16:40:02', '2024-02-09 09:34:10', '2024-02-08', 'P4259', '24-05840-02-08', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Averroes 3', 'Madrid', 'Madrid', '28007', 'España', 28.39, 0, '2024-02-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080224-aVSeagTIwbRzF-206', '8e226b41-2d56-4acf-88ed-861860ac3a63', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080224-aVSeagTIwbRzF-206&s=KOL2024&nf=P4259&i=28.39&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4551, 1, 1159, 2, 0, NULL, 0, '2024-02-08 18:34:41', '2024-02-09 09:34:28', '2024-02-08', 'P4260', '24-05841-02-08', 'Si no estoy entregar en peluquería Joaquín ', 0.00, 32.56, 7.60, 0.00, 0, 0.00, 4.40, 'Avd el Trapiche torre 6 local A', 'Marbella', 'Málaga', '29601', 'España', 43.80, 0, '2024-02-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080224-J5i8a3BnG4P0w-104', '1bd36220-bf68-47c4-93dd-29818ad26548', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080224-J5i8a3BnG4P0w-104&s=KOL2024&nf=P4260&i=43.80&cr=057', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4552, 1, 111, 2, 0, NULL, 0, '2024-02-09 07:50:49', '2024-02-09 09:34:51', '2024-02-09', 'P4261', '24-05842-02-09', '', 0.00, 158.78, 33.34, 0.00, 0, 0.00, 0.00, 'c/ Loza, nº1 piso 7b', 'Ansoáin', 'Navarra', '31013', 'España', 192.12, 0, '2024-02-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090224-VaT+hVOavW88+-080', 'e61f06a2-51ad-4d16-b9fd-a2ad8f484d24', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090224-VaT%2BhVOavW88%2B-080&s=KOL2024&nf=P4261&i=192.12&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4553, 1, 166, 1, 0, NULL, 0, '2024-02-09 10:44:03', '2024-02-09 10:47:11', '2024-02-09', 'P4262', '2024-02-09', '', 0.00, 261.69, 54.95, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 316.64, 0, '2024-02-09 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090224-W4Ci5H4I+a5WW-062', 'ecd70c54-e32c-4863-bb21-e0617cb41cde', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090224-W4Ci5H4I%2Ba5WW-062&s=KOL2024&nf=P4262&i=316.64&cr=054', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(4554, 1, 1164, 2, 0, NULL, 0, '2024-02-09 14:16:13', '2024-02-12 10:02:55', '2024-02-09', 'P4263', '24-05843-02-09', 'si no contestan dejar al 5 b', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'jabier de barkaiztegui 17, 5a', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 30.61, 0, '2024-02-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090224-VoRAPpv/bJuvG-193', '066f6e9a-5f2b-4521-81d6-372c5f3911af', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090224-VoRAPpv%2FbJuvG-193&s=KOL2024&nf=P4263&i=30.61&cr=245', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4555, 1, 23, 2, 0, NULL, 0, '2024-02-09 14:26:22', '2024-02-12 10:05:38', '2024-02-09', 'P4264', '24-05844-02-09', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 172.43, 0, '2024-02-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090224-IZPybskZgC3r5-153', 'a01d44af-beb4-4794-8ecd-f2bd64a851b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090224-IZPybskZgC3r5-153&s=KOL2024&nf=P4264&i=172.43&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4556, 1, 453, 2, 0, NULL, 0, '2024-02-09 17:31:55', '2024-02-12 10:07:17', '2024-02-09', 'P4265', '24-05845-02-09', '', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'Plaza Fray Luis Colomer Numero 10 puerta 13', 'Valencia', 'Valencia', '46021', 'España', 56.82, 0, '2024-02-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090224-mYjO0YpvD0LXW-012', '7aeeccd8-cc34-4e6c-8b24-e39ab84f30b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090224-mYjO0YpvD0LXW-012&s=KOL2024&nf=P4265&i=56.82&cr=253', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4557, 1, 1165, 2, 0, NULL, 0, '2024-02-09 23:33:07', '2024-02-12 10:08:55', '2024-02-09', 'P4266', '24-05846-02-09', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Tomas Gros, 3 - 6° izq.', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 61.09, 0, '2024-02-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090224-UoPXqKxITiEH6-082', '5a248433-22b1-4b9c-ae2b-384424140898', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090224-UoPXqKxITiEH6-082&s=KOL2024&nf=P4266&i=61.09&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4558, 1, 248, 2, 0, NULL, 0, '2024-02-10 08:36:34', '2024-02-12 10:13:54', '2024-02-10', 'P4267', '24-05847-02-10', 'Cerrado el miércoles ', 0.00, 73.26, 15.39, 0.00, 0, 0.00, 0.00, 'Rúa Otero pedraio bajo 1', 'Cambre', 'A Coruña', '15679', 'España', 88.64, 0, '2024-02-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100224-ZQa6a+qUl8T2x-180', '34582981-e350-4c13-bf4d-edc5be1ff937', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100224-ZQa6a%2BqUl8T2x-180&s=KOL2024&nf=P4267&i=88.64&cr=227', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4559, 1, 1166, 2, 0, NULL, 0, '2024-02-10 17:48:17', '2024-02-12 10:16:01', '2024-02-10', 'P4268', '24-05848-02-10', 'Por favor llamar al 629294057 para recoger el pedido.', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Saint Tropez, 13 Bloque A, n° 407 ', 'Jávea/Xàbia', 'Alicante', '03730', 'España', 28.39, 0, '2024-02-10 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-100224-nNQUWP4kf1ZP9-240', 'f9a25ef2-b322-446c-b9e4-9da19c3733ea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100224-nNQUWP4kf1ZP9-240&s=KOL2024&nf=P4268&i=28.39&cr=160', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(4560, 1, 1167, 2, 0, NULL, 0, '2024-02-10 18:23:38', '2024-02-12 10:19:15', '2024-02-10', 'P4269', '24-05849-02-10', 'Colegio. Horario de mañanas.', 0.00, 43.32, 9.86, 0.00, 0, 0.00, 4.40, 'C/ Pablo Ruiz Picasso, 9', 'Utebo', 'Zaragoza', '50180', 'España', 56.82, 0, '2024-02-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100224-P/vCN3AmlVS1X-123', '3b8e55b3-0edf-4b8e-bc44-f9545204c4df', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100224-P%2FvCN3AmlVS1X-123&s=KOL2024&nf=P4269&i=56.82&cr=188', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4561, 1, 1125, 2, 0, NULL, 0, '2024-02-10 18:57:36', '2024-02-12 10:21:11', '2024-02-10', 'P4270', '24-05850-02-10', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Paseo lormont 15 4 - 2', 'Castelldefels', 'Barcelona', '08860', 'España', 30.61, 0, '2024-02-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100224-n8UEE+JUJAEx0-146', '660a0eea-99b0-49c0-9b8a-820d0bb8441a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100224-n8UEE%2BJUJAEx0-146&s=KOL2024&nf=P4270&i=30.61&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4562, 1, 630, 2, 0, NULL, 0, '2024-02-11 12:27:06', '2024-02-12 10:23:42', '2024-02-11', 'P4271', '24-05851-02-11', 'VIAJES AZULMARINO (ANTES VIAJES EROSKI)', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'AVENIDA DE NAVARRA 9 .BAJO', 'Beasain', 'Gipuzkoa', '20200', 'España', 52.39, 0, '2024-02-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-110224-ch0AkWBlwSQfN-191', '4a45f8c2-c399-414e-9857-9c94d03c7693', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-110224-ch0AkWBlwSQfN-191&s=KOL2024&nf=P4271&i=52.39&cr=013', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4563, 1, 4, 2, 0, NULL, 0, '2024-02-12 09:16:07', '2024-02-12 10:26:27', '2024-02-12', 'P4272', '24-05852-02-12', '', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 379.34, 0, '2024-02-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120224-E7yZ2UcAwnviu-190', 'bb18ef23-9db5-4ccd-bb72-d6183053f803', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120224-E7yZ2UcAwnviu-190&s=KOL2024&nf=P4272&i=379.34&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4564, 1, 1134, 2, 0, NULL, 0, '2024-02-12 10:37:57', '2024-02-12 11:39:34', '2024-02-12', 'P4273', '24-05853-02-12', '', 0.00, 61.06, 12.82, 0.00, 0, 0.00, 0.00, 'Aoiz 14, bajo. Pamplona 31003', 'Pamplona/Iruña', 'Navarra', '31003', 'España', 73.88, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120224-duxmlqkaZsRmT-225', '7cf322c0-2522-4ecd-a851-eea54ce8c348', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120224-duxmlqkaZsRmT-225&s=KOL2024&nf=P4273&i=73.88&cr=242', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4565, 1, 77, 1, 1, 'Diferencias con Hacienda, no se ha cargado bien el producto  ptd15, 30 unidades 155,73€', 3517, '2024-02-12 13:17:52', '2024-02-12 13:17:52', '2024-02-12', 'R66', 'P3302 RECT.', '', 0.00, 579.15, 121.62, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 700.77, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-120224-cMXT3cG5SFzp+-092', 'bde23ebd-3891-46b7-a51d-0da25492302c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120224-cMXT3cG5SFzp%2B-092&s=KOL2024&nf=R66&i=-700.77&cr=144', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 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
(4566, 1, 77, 1, 0, NULL, 0, '2024-02-12 13:25:00', '2024-02-12 13:25:00', '2024-02-12', 'P4274', '2024-02-12', '<p>relativa a P3302 abonada en su día por Montse en 1 factura ahora creada en 2 facturas diferentes.</p><p>En los datos que llegan a hacienda consta un total de 700.77€</p>', 0.00, 450.45, 94.59, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 545.04, 0, '2024-02-12 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120224-c9Dws0dV2CJlj-083', '5fa15415-19ad-4ed0-a297-245eeb72cf7d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120224-c9Dws0dV2CJlj-083&s=KOL2024&nf=P4274&i=545.04&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(4567, 1, 77, 1, 0, NULL, 0, '2024-02-12 13:27:28', '2024-02-12 13:27:28', '2024-02-12', 'P4275', '2024-02-12', '<p>relativa a P3302 segunda factura efectuada para cuadrar el pago de P3302.</p>', 0.00, 128.70, 27.03, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 155.73, 0, '2024-02-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120224-aT9QGGN2qOZnx-011', 'dfedfaff-b97f-46be-8582-d91cd08242f8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120224-aT9QGGN2qOZnx-011&s=KOL2024&nf=P4275&i=155.72&cr=120', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 0, 0),
(4568, 1, 696, 1, 0, NULL, 0, '2024-02-12 15:29:11', '2024-02-12 15:30:21', '2024-02-12', 'P4276', '2024-02-12', '', 0.00, 334.62, 70.27, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 404.89, 0, '2024-02-12 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-120224-ogEyeqXew9Sl+-117', '041e86b3-3319-40a6-be85-32a191bec999', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120224-ogEyeqXew9Sl%2B-117&s=KOL2024&nf=P4276&i=404.89&cr=084', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4569, 1, 915, 2, 0, NULL, 0, '2024-02-12 14:40:31', '2024-02-13 09:28:46', '2024-02-12', 'P4277', '24-05854-02-12', '', 0.00, 59.49, 12.49, 0.00, 0, 0.00, 0.00, 'Calle Nube de Magallanes 61', 'Valladolid', 'Valladolid', '47011', 'España', 71.98, 0, '2024-02-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120224-d0JpRIHTcxcGa-166', '9a62f790-7b4b-49c1-b981-bb3dfd7491a9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120224-d0JpRIHTcxcGa-166&s=KOL2024&nf=P4277&i=71.98&cr=185', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4570, 1, 1168, 2, 0, NULL, 0, '2024-02-12 15:10:46', '2024-02-13 09:28:57', '2024-02-12', 'P4278', '24-05855-02-12', 'Es un casa .', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ Masquefa num. 49 ', 'Igualada', 'Barcelona', '08700', 'España', 30.61, 0, '2024-02-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120224-MHIoIoASaGl4F-231', 'c1a275ee-6812-44b2-b971-07f8345616fd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120224-MHIoIoASaGl4F-231&s=KOL2024&nf=P4278&i=30.61&cr=141', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4571, 1, 872, 2, 0, NULL, 0, '2024-02-12 23:15:26', '2024-02-13 09:29:06', '2024-02-12', 'P4279', '24-05856-02-12', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Antonio Machado N ° 7  . 3- C', 'Caudete', 'Albacete', '02660', 'España', 17.50, 0, '2024-02-12 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-120224-Dir/07XOPyeVr-051', 'bc712ea0-a9f8-4cf7-a241-5641ba2c76a6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-120224-Dir%2F07XOPyeVr-051&s=KOL2024&nf=P4279&i=17.50&cr=074', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(4572, 1, 166, 1, 1, 'Falta recargo de equivalencia', 4553, '2024-02-13 09:40:55', '2024-02-13 09:40:55', '2024-02-13', 'R67', 'P4262 RECT.', '', 0.00, 261.69, 54.95, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 316.64, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-130224-Pb6/czoq2653Q-127', '9a90eb7c-d6d8-4ca1-9b3c-3530c20d8756', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130224-Pb6%2Fczoq2653Q-127&s=KOL2024&nf=R67&i=-316.64&cr=052', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4573, 1, 166, 1, 0, NULL, 0, '2024-02-13 09:42:48', '2024-02-13 09:50:04', '2024-02-13', 'P4280', '2024-02-13', '', 0.00, 261.69, 54.95, 0.00, 1, 13.61, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 330.25, 0, '2024-02-13 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130224-KQRKTzXU687ww-208', '9c0ecf4e-ec62-47e3-801b-8b944104a059', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130224-KQRKTzXU687ww-208&s=KOL2024&nf=P4280&i=330.25&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4574, 1, 65, 2, 0, NULL, 0, '2024-02-13 11:02:25', '2024-07-17 13:17:25', '2024-02-13', 'P4281', '24-05857-02-13', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 344.85, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130224-gb/+Z4fnTC8p7-053', 'd8671690-9ab9-4f91-bc79-c50c82adb268', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130224-gb%2F%2BZ4fnTC8p7-053&s=KOL2024&nf=P4281&i=344.85&cr=240', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4575, 1, 1017, 2, 1, 'problemas con el cálculo de gastos de envío desde la página web', 4008, '2024-02-13 12:54:48', '2024-02-13 12:55:14', '2024-02-13', 'R68', 'P3764 RECT.', '', 0.00, 54.15, 13.97, 0.00, 0, 0.00, 15.00, '', '', '', '', '', 81.29, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-130224-UvdHYr6mET5SJ-183', 'dbe9f8c5-e8b1-4b56-aafa-01fd5973cf33', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130224-UvdHYr6mET5SJ-183&s=KOL2024&nf=R68&i=-81.29&cr=129', '[BLOB]', 1, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4576, 1, 1017, 1, 0, NULL, 0, '2024-02-13 12:58:28', '2024-02-13 13:12:48', '2024-02-13', 'P4282', '2024-02-13', '', 0.00, 54.15, 13.97, 0.00, 0, 0.00, 15.00, '13 rue travot', 'Cholet', 'Maine-et-Loire', '49300', 'Francia', 80.52, 0, '2024-02-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130224-Rn3AJjvVLoQID-097', '02db843c-05a0-4881-8dd0-8c54680bb1b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130224-Rn3AJjvVLoQID-097&s=KOL2024&nf=P4282&i=80.52&cr=093', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4577, 1, 925, 2, 0, NULL, 0, '2024-02-13 12:42:16', '2024-02-14 09:07:41', '2024-02-13', 'P4283', '24-05858-02-13', '', 0.00, 171.00, 35.91, 0.00, 1, 8.89, 0.00, 'Perú número 16 Bloq 2 Bajo DCH', 'ALICANTE', 'ALICANTE', '03008', 'ESPAÑA', 215.80, 0, '2024-02-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130224-lSiTXLp6yUOW/-111', 'd112baa6-a9bb-4099-b294-be16a5038dab', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130224-lSiTXLp6yUOW%2F-111&s=KOL2024&nf=P4283&i=215.80&cr=172', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 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
(4578, 1, 244, 2, 0, NULL, 0, '2024-02-13 17:48:10', '2024-02-14 09:10:32', '2024-02-13', 'P4284', '24-05859-02-13', 'Peluquería Maimar. Si no estoy, entregar en la Barbería de al lado', 0.00, 73.28, 15.39, 0.00, 0, 0.00, 0.00, 'C/ Balmes 79 Local 3 ', 'Calella', 'Barcelona', '08370', 'España', 88.67, 0, '2024-02-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130224-Mrf5GbVHwqAkz-137', '9d768193-a4c7-4148-a24d-eb7dbcce604c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130224-Mrf5GbVHwqAkz-137&s=KOL2024&nf=P4284&i=88.67&cr=205', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4579, 1, 689, 2, 0, NULL, 0, '2024-02-13 18:13:04', '2024-02-14 09:13:11', '2024-02-13', 'P4285', '24-05860-02-13', 'mediodía cerrado', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Dr Espinosa Oribe 19 bajo', 'Bilbao', 'Bizkaia', '48003', 'España', 30.61, 0, '2024-02-13 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-130224-R6VqJkq5JR3SP-084', '4e1d7128-7f43-45a0-b37f-35f2d04080a3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130224-R6VqJkq5JR3SP-084&s=KOL2024&nf=P4285&i=30.61&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4580, 1, 144, 2, 0, NULL, 0, '2024-02-13 19:36:42', '2024-02-14 09:15:58', '2024-02-13', 'P4286', '24-05861-02-13', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 137.94, 0, '2024-02-13 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130224-LxU3VqC3ZgGBs-023', 'a3c85ebd-1338-4d7a-b021-8e9d199c4513', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130224-LxU3VqC3ZgGBs-023&s=KOL2024&nf=P4286&i=137.94&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4581, 1, 1170, 2, 0, NULL, 0, '2024-02-14 08:58:04', '2024-02-14 10:05:30', '2024-02-14', 'P4287', '24-05865-02-14', '', 0.00, 21.66, 5.75, 0.00, 0, 0.00, 6.90, 'Calle mossen jacint Verdaguer 8 1-1', 'Sant Boi de Llobrega', 'Barcelona', '08830', 'España', 33.11, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-140224-Pt3o3u6kwkrHF-104', '2586f6a6-05f9-4fb3-969a-54e5ca10f4ae', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140224-Pt3o3u6kwkrHF-104&s=KOL2024&nf=P4287&i=33.11&cr=252', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4582, 1, 976, 2, 0, NULL, 0, '2024-02-14 09:42:35', '2024-02-14 10:51:12', '2024-02-14', 'P4288', '24-05868-02-14', 'Se accede al local por avenida de arteixo', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Calle Bolivia n1 bajo puerta 3', 'Coruña (A)', 'A Coruña', '15004', 'España', 103.46, 0, '2024-02-14 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-140224-MyGp6EDbEhuRo-171', 'aa4a1dcf-0175-4d8c-9006-f75778ea99e0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140224-MyGp6EDbEhuRo-171&s=KOL2024&nf=P4288&i=103.46&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4583, 1, 976, 1, 0, NULL, 0, '2024-02-14 10:52:09', '2024-02-14 10:52:09', '2024-02-14', 'P4289', '2024-02-14', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'calle bolivia n 1 bajo puerta 3', 'Coruña (A)', 'A Coruña', '15004', 'España', 34.48, 0, '2024-02-14 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-140224-G/HddX4QaSdRm-049', '3b993536-394e-484e-9c4a-94ef03f83686', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-140224-G%2FHddX4QaSdRm-049&s=KOL2024&nf=P4289&i=34.47&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
