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
(6318, 1, 166, 1, 0, NULL, 0, '2024-12-19 09:31:56', '2024-12-19 09:44:52', '2024-12-19', 'P5939', '', '', 0.00, 101.43, 21.30, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 122.73, 0, '2024-12-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-191224-Dsr6wUmBVHEKK-139', 'e784122a-e5f8-4e3d-b94b-9841dfe06dc8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-Dsr6wUmBVHEKK-139&s=KOL2024&nf=P5939&i=122.73&cr=190', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6319, 1, 166, 1, 1, 'error en el cálculo total', 6318, '2024-12-19 09:48:51', '2024-12-19 09:48:51', '2024-12-19', 'R96', 'P5939 RECT.', '', 0.00, 101.43, 21.30, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 122.73, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-191224-AHuLXWMFP1HQ/-025', 'c935e551-dd3c-4a39-9c53-43fc8c3a10c8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-AHuLXWMFP1HQ%2F-025&s=KOL2024&nf=R96&i=-122.73&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', NULL, 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(6320, 1, 166, 1, 0, NULL, 0, '2024-12-19 09:51:46', '2024-12-19 09:57:13', '2024-12-19', 'P5940', '', '', 0.00, 72.93, 15.32, 0.00, 0, 0.00, 0.00, 'CALLE PARQUE DEL TEIDE NUMERO 27', 'Alcorcón', 'Madrid', '28924', 'España', 88.25, 0, '2024-12-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-191224-XQz8qGdboCPye-236', 'd7036bcc-3b33-4a3f-b322-111eff178d15', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-XQz8qGdboCPye-236&s=KOL2024&nf=P5940&i=88.25&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6321, 1, 1144, 2, 0, NULL, 0, '2024-12-19 09:17:00', '2024-12-19 10:18:18', '2024-12-19', 'P5941', '24-07756-12-19', 'Llamar al seis tres siete cinco uno seis ocho cinco cinco cinco para la entrega', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Alejandro Rodríguez de valcárcel 20. 2-A.', 'Villarcayo de Merind', 'Burgos', '09550', 'España', 65.52, 0, '2024-12-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-191224-Cp7umtIKsNNss-132', '36b61759-fc01-444a-b9ee-807e46f33525', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-Cp7umtIKsNNss-132&s=KOL2024&nf=P5941&i=65.52&cr=099', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6322, 1, 154, 2, 0, NULL, 0, '2024-12-19 09:21:06', '2024-12-19 10:23:47', '2024-12-19', 'P5942', '24-07757-12-19', '', 0.00, 207.64, 43.60, 0.00, 0, 0.00, 0.00, 'c/alta 90 - bajo', 'Santander', 'Cantabria', '39008', 'España', 251.24, 0, '2024-12-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191224-PpXno1++qdS0p-104', '5f31b9f1-2473-459b-8ed0-c350216a8116', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-PpXno1%2B%2BqdS0p-104&s=KOL2024&nf=P5942&i=251.24&cr=068', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6323, 1, 754, 2, 0, NULL, 0, '2024-12-19 10:26:41', '2024-12-19 11:31:29', '2024-12-19', 'P5943', '24-07758-12-19', '6+1 GRATIS PRECOLOR DORADO', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-12-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191224-dTytEOuIx1kJo-134', 'd8eba335-1b0d-4b64-b632-ace4c0500756', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-dTytEOuIx1kJo-134&s=KOL2024&nf=P5943&i=61.64&cr=236', '[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
(6324, 1, 1000, 2, 0, NULL, 0, '2024-12-19 11:08:31', '2024-12-19 12:45:01', '2024-12-19', 'P5944', '24-07760-12-19', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/ Del Abanico , 34', 'Cartagena', 'Murcia', '30330', 'España', 17.50, 0, '2024-12-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191224-ZvuEBvHm8NwR3-017', '3ba9c87c-2f8d-49e4-b4d5-b071e227672f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-ZvuEBvHm8NwR3-017&s=KOL2024&nf=P5944&i=17.50&cr=140', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6325, 1, 1110, 2, 0, NULL, 0, '2024-12-19 11:36:56', '2024-12-19 12:44:32', '2024-12-19', 'P5945', '24-07761-12-19', '', 0.00, 44.78, 10.17, 0.00, 0, 0.00, 4.40, 'C/unió N015', 'Lleida', 'Lleida', '25002', 'España', 58.58, 0, '2024-12-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-191224-A8RjgXprafJRz-153', '8e3d134b-1905-4ad1-afdd-bd4186471c3f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-A8RjgXprafJRz-153&s=KOL2024&nf=P5945&i=58.58&cr=200', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6326, 1, 1094, 1, 0, NULL, 0, '2024-12-19 12:42:19', '2024-12-19 12:43:22', '2024-12-19', 'P5946', '', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carrer sant Jaume, 37', 'Sant Iscle de Vallal', 'Barcelona', '08359', 'España', 30.61, 0, '2024-12-19 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-191224-bXUQE9Ho5RgPY-062', 'aa04d78f-9418-442f-af47-6aa2549cd755', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-bXUQE9Ho5RgPY-062&s=KOL2024&nf=P5946&i=30.61&cr=137', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6327, 1, 468, 2, 0, NULL, 0, '2024-12-19 11:46:14', '2024-12-19 12:51:53', '2024-12-19', 'P5947', '24-07762-12-19', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Rof Carballo 1, kimera estilistas', 'Lugo', 'Lugo', '27002', 'España', 103.46, 0, '2024-12-19 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-191224-abywr/0QB+zgO-118', 'cfcae000-650d-477c-bdba-1d0bf515843f', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-abywr%2F0QB%2BzgO-118&s=KOL2024&nf=P5947&i=103.46&cr=230', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6328, 1, 1576, 2, 0, NULL, 0, '2024-12-19 11:51:18', '2024-12-19 12:55:24', '2024-12-19', 'P5948', '24-07763-12-19', '', 0.00, 10.83, 3.47, 0.00, 0, 0.00, 6.90, 'Magdalena n°5 2° izquierda ', 'Mutriku', 'Gipuzkoa', '20830', 'España', 20.00, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-191224-TtJwPs+HelVwi-080', 'dccecbec-a874-4e8e-a617-00d7fe4580ef', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-TtJwPs%2BHelVwi-080&s=KOL2024&nf=P5948&i=20.00&cr=067', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6329, 1, 11, 2, 0, NULL, 0, '2024-12-19 11:57:30', '2024-12-19 13:10:55', '2024-12-19', 'P5949', '24-07764-12-19', '', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'calle Colomeres 36 local 2', 'Gavà', 'Barcelona', '08840', 'España', 103.46, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-191224-KqX6wcGEW+dOe-147', 'cc61ce15-2e0a-40fa-be05-8579c6bb6f50', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-191224-KqX6wcGEW%2BdOe-147&s=KOL2024&nf=P5949&i=103.46&cr=186', '[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
(6330, 1, 783, 2, 0, NULL, 0, '2024-12-19 17:14:22', '2024-12-20 07:54:16', '2024-12-20', 'P5950', '24-07768-12-19', '', 0.00, 61.32, 12.88, 0.00, 0, 0.00, 0.00, 'Alvaro Cunqueiro, nº 15, 7º A', 'Vigo', 'Pontevedra', '36211', 'España', 74.20, 0, '2024-12-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201224-HKcAEd6dY1A15-020', '22047f4b-833d-413c-8ea6-6019a181eb19', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201224-HKcAEd6dY1A15-020&s=KOL2024&nf=P5950&i=74.20&cr=179', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6331, 1, 1577, 2, 0, NULL, 0, '2024-12-19 21:19:06', '2024-12-20 09:52:54', '2024-12-20', 'P5951', '24-07769-12-19', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Rúa Río Tambre, 30', 'Oleiros', 'A Coruña', '15173', 'España', 17.50, 0, '2024-12-19 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-201224-aRriMeQepNz0R-233', '98a9c095-f10a-44b2-8473-f161509a94fa', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201224-aRriMeQepNz0R-233&s=KOL2024&nf=P5951&i=17.50&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '2024-12-20', 'S0133', 10, 20, 5, 0, 0, '', 1, 1),
(6332, 1, 1578, 2, 0, NULL, 0, '2024-12-20 09:20:40', '2024-12-20 10:21:24', '2024-12-20', 'P5952', '24-07766-12-19', 'voy a casa de mi madre solo unos dias desde el 31  Dic hasta el 11 de Enero, si envío no posble en este plazo cancelar. telefono proporcionado es el de mi madre x ke yo fuera de península. Gracias', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'c/ Los Cooperantes 10', 'Alhaurín de la Torre', 'Málaga', '29130', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-201224-Ej5kbEYzAERWY-241', '100c72ad-eddb-4657-80f8-a0e0b152b8f8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-201224-Ej5kbEYzAERWY-241&s=KOL2024&nf=P5952&i=30.61&cr=115', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6333, 1, 1579, 2, 0, NULL, 0, '2024-12-20 16:11:49', '2024-12-23 08:16:44', '2024-12-23', 'P5953', '24-07770-12-20', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Carrer Santa Eulalia, 5 1º 1ª', 'Rubí', 'Barcelona', '08191', 'España', 30.61, 0, '2024-12-20 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231224-YBv4DkDFyxxWC-003', '90e59ba9-613c-407f-a9a4-32c15f6c8a35', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-YBv4DkDFyxxWC-003&s=KOL2024&nf=P5953&i=30.61&cr=178', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6334, 1, 838, 2, 0, NULL, 0, '2024-12-21 07:40:35', '2024-12-23 08:18:16', '2024-12-23', 'P5954', '24-07772-12-21', 'Llamar antes o entregar en punto de recogida cercano', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Almirante Antonio Gaztañeta 1, 2d', 'Bilbao', 'Bizkaia', '48012', 'España', 61.09, 0, '2024-12-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231224-Nue0mWVXNLcpM-121', 'fbbb694d-b81b-4535-8f63-2f994b741433', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-Nue0mWVXNLcpM-121&s=KOL2024&nf=P5954&i=61.09&cr=162', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6335, 1, 1580, 2, 0, NULL, 0, '2024-12-21 11:59:23', '2024-12-23 08:45:11', '2024-12-23', 'P5955', '24-07773-12-21', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ Pintor Ribalta, 4G', 'Torrent', 'Valencia', '46901', 'España', 30.61, 0, '2024-12-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231224-RwdYgYjidDrkD-222', '19cfb7da-7116-4459-b18a-aac443917038', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-RwdYgYjidDrkD-222&s=KOL2024&nf=P5955&i=30.61&cr=200', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '2024-12-23', 'S0133', 10, 20, 5, 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
(6336, 1, 137, 2, 0, NULL, 0, '2024-12-21 13:03:16', '2024-12-23 08:31:09', '2024-12-23', 'P5956', '24-07775-12-21', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Pº ERMITA, 10', 'Madrid', 'Madrid', '28023', 'España', 310.37, 0, '2024-12-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231224-JSZXyeXalK3MQ-026', 'eee30a73-b781-46b6-9e3a-cffa0fcf771a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-JSZXyeXalK3MQ-026&s=KOL2024&nf=P5956&i=310.37&cr=133', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6337, 1, 442, 2, 0, NULL, 0, '2024-12-21 15:07:11', '2024-12-23 08:33:04', '2024-12-23', 'P5957', '24-07776-12-21', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'TRAVESÍA DEL TORNADO 7, 4N', 'Tres Cantos', 'Madrid', '28760', 'España', 17.50, 0, '2024-12-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231224-ItB3xu4uvxJT6-045', '4c50265e-8295-4259-a3b4-38fce7969777', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-ItB3xu4uvxJT6-045&s=KOL2024&nf=P5957&i=17.50&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6338, 1, 1581, 2, 0, NULL, 0, '2024-12-21 17:25:29', '2024-12-23 08:33:50', '2024-12-23', 'P5958', '24-07777-12-21', 'Llamar antes de entregar porfavor. Gracias ', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Río Almanzora n°12', 'Mijas', 'Málaga', '29.651', 'España', 30.61, 0, '2024-12-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231224-X+9Lp3I+/Yxdg-058', 'af56fcba-91b0-4a91-a2ca-d9aada89e5da', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-X%2B9Lp3I%2B%2FYxdg-058&s=KOL2024&nf=P5958&i=30.61&cr=153', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6339, 1, 1156, 2, 0, NULL, 0, '2024-12-21 19:01:42', '2024-12-23 08:34:28', '2024-12-23', 'P5959', '24-07778-12-21', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Paseo de Lazkano 49, 1 izda', 'Donostia-San Sebasti', 'Gipuzkoa', '20009', 'España', 30.61, 0, '2024-12-21 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231224-XxyZuWPmOsnLn-211', '6ebc58c1-2083-4682-b47f-f96cfa7d4836', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-XxyZuWPmOsnLn-211&s=KOL2024&nf=P5959&i=30.61&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6340, 1, 121, 1, 0, NULL, 0, '2024-12-23 08:35:22', '2024-12-23 08:35:22', '2024-12-23', 'P5960', '', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'Blas de Otero, 19 bajo', 'Bilbao', 'Bizkaia', '48014', 'España', 68.97, 0, '2024-12-23 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-231224-SWn78zdXgL3Qi-138', 'a88cb339-b5c4-4ef6-ba2e-faf43458cf42', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-SWn78zdXgL3Qi-138&s=KOL2024&nf=P5960&i=68.97&cr=177', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6341, 1, 23, 2, 0, NULL, 0, '2024-12-23 09:45:07', '2024-12-23 10:50:39', '2024-12-23', 'P5961', '24-07780-12-23', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'vistabella n2', 'Alcoy/Alcoi', 'Alicante', '03802', 'España', 206.91, 0, '2024-12-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231224-TQG+ieqLxNKD4-134', 'e8df9750-ce62-49e7-8102-61c42014221b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-TQG%2BieqLxNKD4-134&s=KOL2024&nf=P5961&i=206.91&cr=218', '[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
(6342, 1, 1582, 2, 0, NULL, 0, '2024-12-23 11:28:10', '2024-12-23 12:28:38', '2024-12-23', 'P5962', '24-07781-12-23', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle Tunel de Oural Nº28-2º Izda', 'Lugo', 'Lugo', '27003', 'España', 65.52, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-231224-aPqaQFvKTH7WU-206', '3e3737b3-0e91-4f54-bd86-7673b33988ea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-aPqaQFvKTH7WU-206&s=KOL2024&nf=P5962&i=65.52&cr=193', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6343, 1, 4, 2, 0, NULL, 0, '2024-12-23 12:24:02', '2024-12-23 13:26:33', '2024-12-23', 'P5963', '24-07782-12-23', '', 0.00, 232.06, 48.73, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 280.79, 0, '2024-12-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231224-VpzI/C/geOjQC-229', 'e9473cc8-3796-429c-b6c9-2dfda320435e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-VpzI%2FC%2FgeOjQC-229&s=KOL2024&nf=P5963&i=280.79&cr=014', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6344, 1, 262, 2, 0, NULL, 0, '2024-12-23 12:25:33', '2024-12-23 13:27:22', '2024-12-23', 'P5964', '24-07783-12-23', '', 0.00, 61.06, 12.82, 0.00, 0, 0.00, 0.00, 'C/ Riera Buganto 12 (local Homenatura), Local', 'Girona', 'Girona', '17003', 'España', 73.88, 0, '2024-12-23 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-231224-WeyZbfrW5X1hG-135', 'dcaa9c3d-86cd-4275-8b4e-d7403de09369', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-231224-WeyZbfrW5X1hG-135&s=KOL2024&nf=P5964&i=73.88&cr=159', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6345, 1, 28, 2, 0, NULL, 0, '2024-12-23 14:48:14', '2024-12-23 16:51:05', '2024-12-24', 'P5965', '24-07787-12-23', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'gorbea n 8', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 206.91, 0, '2024-12-23 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-241224-TyMqXTgoflj7i-106', '650d13ed-e95b-4fa1-b1b9-042086927e0b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241224-TyMqXTgoflj7i-106&s=KOL2024&nf=P5965&i=206.91&cr=003', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6346, 1, 1254, 1, 0, NULL, 0, '2024-12-24 11:17:56', '2024-12-24 11:49:47', '2024-12-24', 'P5967', '', '', 0.00, 21.66, 7.12, 0.00, 1, 1.76, 14.81, '36 Waterford Circle', 'Dighton ', 'Massachusetts ', '02715', 'España', 42.78, 0, '2024-12-24 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-241224-T+73/HuMe2UNy-237', 'e72e8419-4ea6-4505-b9a2-0dbdc6d4bb93', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241224-T%2B73%2FHuMe2UNy-237&s=KOL2024&nf=P5967&i=42.78&cr=113', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6347, 1, 1583, 2, 0, NULL, 0, '2024-12-24 10:33:03', '2024-12-24 11:48:12', '2024-12-24', 'P5966', '24-07793-12-24', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Libertad 18', 'Álamo (El)', 'Madrid', '28607', 'España', 30.61, 0, '2024-12-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241224-YsMDAUcTlnJnZ-118', '59031ccd-30de-4236-bec2-f1f9d38a65b7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241224-YsMDAUcTlnJnZ-118&s=KOL2024&nf=P5966&i=30.61&cr=066', '[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
(6348, 1, 1280, 2, 0, NULL, 0, '2024-12-24 11:15:57', '2024-12-24 12:17:55', '2024-12-24', 'P5968', '24-07796-12-24', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Carrer de Joan Alsina, 27 bxs 2a', 'Girona', 'Girona', '17003', 'España', 52.39, 0, '2024-12-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241224-YwzbgikkmlyI9-065', '0bfdeb38-d716-4842-80c1-d923c305a236', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241224-YwzbgikkmlyI9-065&s=KOL2024&nf=P5968&i=52.39&cr=109', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6349, 1, 1319, 2, 0, NULL, 0, '2024-12-24 12:33:49', '2024-12-24 13:34:23', '2024-12-24', 'P5969', '24-07798-12-24', '', 0.00, 50.49, 10.60, 0.00, 0, 0.00, 0.00, 'Miguel de Unamuno 13', 'Torres de la Alameda', 'Madrid', '28813', 'España', 61.09, 0, '2024-12-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-241224-EPuBGi+aLUEt6-122', '0cf826f7-114e-4a95-9280-da39ee752b9b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-241224-EPuBGi%2BaLUEt6-122&s=KOL2024&nf=P5969&i=61.09&cr=024', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6350, 1, 40, 2, 0, NULL, 0, '2024-12-24 13:39:12', '2024-12-26 07:05:41', '2024-12-26', 'P5970', '24-07800-12-24', '', 0.00, 57.00, 11.97, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 68.97, 0, '2024-12-24 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261224-ERg5TV9tA0+N8-043', '1de1007b-d472-40d4-97f3-7b03c0a21f73', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261224-ERg5TV9tA0%2BN8-043&s=KOL2024&nf=P5970&i=68.97&cr=161', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6351, 1, 1005, 2, 0, NULL, 0, '2024-12-25 10:38:09', '2024-12-26 07:06:35', '2024-12-26', 'P5971', '24-07801-12-25', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'San Isidro Labrador 19, Local A', 'Madrid', 'Madrid', '28005', 'España', 30.61, 0, '2024-12-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261224-OxxMleCN4hnk+-094', '8629838c-0d38-43f6-ab9a-c875d2ae3a07', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261224-OxxMleCN4hnk%2B-094&s=KOL2024&nf=P5971&i=30.61&cr=210', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6352, 1, 1584, 2, 0, NULL, 0, '2024-12-25 11:57:47', '2024-12-26 07:07:37', '2024-12-26', 'P5972', '24-07802-12-25', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Pascual Veiga,24-4ºD', 'Lugo', 'Lugo', '27002', 'España', 28.39, 0, '2024-12-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261224-fh/jgG05RLgxj-097', 'fa16b9e2-c031-43b4-aad6-d294d3723949', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261224-fh%2FjgG05RLgxj-097&s=KOL2024&nf=P5972&i=28.39&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6353, 1, 754, 2, 0, NULL, 0, '2024-12-25 19:04:30', '2024-12-26 07:09:06', '2024-12-26', 'P5973', '24-07803-12-25', '6+1 REGALO CASTAÑO CLARO\r\nDE FORMA PUNTUAL ENVIAR A LA CALLE MALLORCA NÚMERO 5 LOCAL\r\n43870 AMPOSTA', 0.00, 48.84, 10.26, 0.00, 1, 2.54, 0.00, 'Josep Tarradellas 166 2º1º', 'Amposta', 'Tarragona', '43870', 'España', 61.64, 0, '2024-12-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261224-EstT9j6M2DED0-166', '9c405602-c4bb-4b5d-9800-8349a2f47608', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261224-EstT9j6M2DED0-166&s=KOL2024&nf=P5973&i=61.64&cr=091', '[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
(6354, 1, 617, 2, 0, NULL, 0, '2024-12-25 22:39:34', '2024-12-26 07:10:46', '2024-12-26', 'P5974', '24-07804-12-25', 'Factura ', 0.00, 313.50, 65.84, 0.00, 0, 0.00, 0.00, 'Riestra 14', 'Pontevedra', 'Pontevedra', '36001', 'España', 379.34, 0, '2024-12-25 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-261224-Dvu9Jfz07FgZR-155', '3a15977d-6998-4da0-b199-dd7912606329', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-261224-Dvu9Jfz07FgZR-155&s=KOL2024&nf=P5974&i=379.34&cr=145', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6355, 1, 1585, 2, 0, NULL, 0, '2024-12-26 13:54:34', '2024-12-27 09:34:33', '2024-12-27', 'P5975', '24-07805-12-26', 'La direccion correcta es:\r\n\r\nC/ San Pedro Nº 3 ---- Código Postal 14547 ---- LA GUIJARROSA\r\n\r\nLo que ocurre es que en el desplegable de la localidad no sale', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'C/ San Pedro Nº 3', 'Santaella', 'Córdoba', '14547', 'España', 28.39, 0, '2024-12-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271224-OpquO2tzcY0us-201', '9435cacf-85f7-43ec-8180-8d3dadee1818', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271224-OpquO2tzcY0us-201&s=KOL2024&nf=P5975&i=28.39&cr=189', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6356, 1, 1586, 2, 0, NULL, 0, '2024-12-26 16:25:41', '2024-12-27 09:34:49', '2024-12-27', 'P5976', '24-07806-12-26', 'Horario Comercial', 0.00, 64.98, 13.65, 0.00, 0, 0.00, 0.00, 'ESTANCO.Calle San Francisco nº 32', 'Elgoibar', 'Gipuzkoa', '20870', 'España', 78.63, 0, '2024-12-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-271224-gTt9UXa10ZUfC-153', '9201edeb-e010-4978-87c4-e8830e509dab', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271224-gTt9UXa10ZUfC-153&s=KOL2024&nf=P5976&i=78.63&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6357, 1, 350, 2, 0, NULL, 0, '2024-12-27 09:13:32', '2024-12-27 10:16:00', '2024-12-27', 'P5977', '24-07808-12-27', '', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle Balleneros 19 Bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 172.43, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-271224-HuMIsv1NBRn+h-156', 'abc21f26-1b8e-44eb-9025-f446640b6c4c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271224-HuMIsv1NBRn%2Bh-156&s=KOL2024&nf=P5977&i=172.43&cr=023', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6358, 1, 687, 1, 0, NULL, 0, '2024-12-27 10:20:36', '2024-12-27 10:20:36', '2024-12-27', 'P5978', '', '', 0.00, 65.14, 13.68, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 78.82, 0, '2024-12-27 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-271224-OA4gHaHPT2UUT-158', 'd137acf7-f20d-4a74-b0a1-12f8c0b6e5ec', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271224-OA4gHaHPT2UUT-158&s=KOL2024&nf=P5978&i=78.81&cr=086', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6359, 1, 53, 2, 0, NULL, 0, '2024-12-27 12:04:42', '2024-12-27 13:24:21', '2024-12-27', 'P5979', '24-07809-12-27', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'entremurallas nº5 - 1º', 'Santiago de Composte', 'A Coruña', '15702', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-271224-I7ZOCGd9vvS+5-056', '0768a4a4-0d11-41d2-8db5-30b6ff62bede', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-271224-I7ZOCGd9vvS%2B5-056&s=KOL2024&nf=P5979&i=174.93&cr=142', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6360, 1, 0, 5, 0, NULL, 0, '2024-12-27 13:16:42', '2024-12-27 13:16:42', '2024-12-27', '', 'muestroteca', '', 0.00, 10.83, 2.27, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 13.10, 0, '2024-12-27 00:00:00', '', '', 1, 1, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 0, 0),
(6361, 1, 0, 5, 0, NULL, 0, '2024-12-27 13:22:26', '2024-12-27 13:23:15', '2024-12-27', '', 'muestroteca', '', 0.00, 477.51, 100.28, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 577.79, 0, '2024-12-27 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 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
(6362, 1, 1587, 2, 0, NULL, 0, '2024-12-27 13:16:24', '2024-12-30 06:35:20', '2024-12-30', 'P5980', '24-07810-12-27', 'En caso de no estar en casa por favor timbren a un vecino de planta y dejen el paquete delante de mi puerta. Gracias', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Rua María Casares 5 - 5°A', 'Santiago de Composte', 'A Coruña', '15706', 'España', 28.39, 0, '2024-12-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301224-AIT/Ft+XND97u-217', 'fdfc86f4-4862-4575-9478-7967de6b2a94', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301224-AIT%2FFt%2BXND97u-217&s=KOL2024&nf=P5980&i=28.39&cr=018', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6363, 1, 340, 2, 0, NULL, 0, '2024-12-27 18:40:26', '2024-12-30 06:36:55', '2024-12-30', 'P5981', '24-07811-12-27', 'horario 9.30 a 1.30  y 4.30 a 7.30 miercoles cerrado...para otro horario ponerse en contacto por telefono para quedar', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'juan carlos 1 17', 'Sesma', 'Navarra', '31293', 'España', 172.43, 0, '2024-12-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301224-ZJW/6v9JPtQe6-150', '964cf24e-cbf2-46d4-9086-2df5d6074418', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301224-ZJW%2F6v9JPtQe6-150&s=KOL2024&nf=P5981&i=172.43&cr=237', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6364, 1, 1332, 2, 0, NULL, 0, '2024-12-28 10:18:46', '2024-12-30 06:38:02', '2024-12-30', 'P5982', '24-07812-12-28', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'C/Domingo García de la Fuente 7, 3B', 'Gijón', 'Asturias', '33205', 'España', 65.52, 0, '2024-12-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301224-OW4vFstYoKtOs-197', '58d484fd-8560-42eb-b336-3a805e2fd4ba', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301224-OW4vFstYoKtOs-197&s=KOL2024&nf=P5982&i=65.52&cr=111', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6365, 1, 1588, 2, 0, NULL, 0, '2024-12-28 11:42:30', '2024-12-30 06:39:14', '2024-12-30', 'P5987', '24-07813-12-28', '', 0.00, 64.98, 14.08, 0.00, 0, 0.00, 2.50, 'Vitoria 23 primero ', 'Miranda de Ebro', 'Burgos', '09200', 'España', 81.13, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-301224-chSgnf8qUaIz9-025', '15a385d5-e8b1-4503-ba94-55e76123479a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301224-chSgnf8qUaIz9-025&s=KOL2024&nf=P5987&i=81.13&cr=195', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6366, 1, 898, 2, 0, NULL, 0, '2024-12-28 18:13:13', '2024-12-30 06:40:06', '2024-12-30', 'P5983', '24-07814-12-28', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'beato tomas de zumarraga nº2 3C', 'Vitoria-Gasteiz', 'Álava', '01008', 'España', 30.61, 0, '2024-12-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301224-MP0ndR7Tvetd/-046', '582abc93-4498-4988-b718-6a0b8152e537', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301224-MP0ndR7Tvetd%2F-046&s=KOL2024&nf=P5983&i=30.61&cr=105', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6367, 1, 601, 2, 0, NULL, 0, '2024-12-28 22:23:22', '2024-12-30 06:41:07', '2024-12-30', 'P5984', '24-07816-12-28', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Iturribarri, 11,-1 (puerta granate)', 'Ondarroa', 'Bizkaia', '48700', 'España', 65.52, 0, '2024-12-28 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301224-CA9S29xWGgpCQ-002', 'b1899ca9-e4e9-42d0-bf9b-9d2bbe43816d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301224-CA9S29xWGgpCQ-002&s=KOL2024&nf=P5984&i=65.52&cr=190', '[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
(6368, 1, 1589, 2, 0, NULL, 0, '2024-12-29 12:43:15', '2024-12-30 06:42:08', '2024-12-30', 'P5985', '24-07817-12-29', '', 0.00, 32.49, 7.59, 0.00, 0, 0.00, 4.40, 'Paseo Buztintxuri 11-5C', 'Pamplona/Iruña', 'Navarra', '31012', 'España', 43.71, 0, '2024-12-29 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-301224-cqK1JwVyJlB+V-216', 'fa11dd78-303e-48c1-afc0-bd8d23683ae0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301224-cqK1JwVyJlB%2BV-216&s=KOL2024&nf=P5985&i=43.71&cr=134', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6369, 1, 1036, 2, 0, NULL, 0, '2024-12-29 19:39:09', '2024-12-30 06:43:10', '2024-12-30', 'P5986', '24-07819-12-29', '', 0.00, 54.15, 11.37, 0.00, 0, 0.00, 0.00, 'Calle Gurmendi 10 1°A', 'Zarautz', 'Gipuzkoa', '20800', 'España', 65.52, 0, '2024-12-29 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-301224-fgAU7QZL/ExGB-005', '7c39bb68-2d42-400e-b6d8-d58529b9dd95', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301224-fgAU7QZL%2FExGB-005&s=KOL2024&nf=P5986&i=65.52&cr=049', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6370, 1, 1590, 2, 0, NULL, 0, '2024-12-29 21:41:07', '2024-12-30 06:45:35', '2024-12-30', 'P5988', '24-07820-12-29', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Albaida 72, 2°A', 'Madrid', 'Madrid', '28037', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-301224-c7yEJcs5TWkvY-088', 'c5648e72-8ccc-41e4-8ad8-9cd01cf83c11', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301224-c7yEJcs5TWkvY-088&s=KOL2024&nf=P5988&i=30.61&cr=004', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6371, 1, 1591, 2, 0, NULL, 0, '2024-12-30 10:00:04', '2024-12-30 11:04:45', '2024-12-30', 'P5989', '24-07821-12-30', 'Por las tardes', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Chirivella 4B-4', 'Torrent', 'Valencia', '46900', 'España', 28.39, 0, '2024-12-30 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-301224-PGrD+u+bzDSo+-234', 'ec7457f3-7e06-44a6-a396-c0457403079a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301224-PGrD%2Bu%2BbzDSo%2B-234&s=KOL2024&nf=P5989&i=28.39&cr=173', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6372, 1, 65, 2, 0, NULL, 0, '2024-12-30 11:11:49', '2024-12-30 12:44:55', '2024-12-30', 'P5990', '24-07822-12-30', '', 0.00, 741.00, 155.61, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 896.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-301224-YVwnyaqbc4eat-183', '5fc9e9df-1a47-4a96-a8ce-f636b14d9694', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-301224-YVwnyaqbc4eat-183&s=KOL2024&nf=P5990&i=896.61&cr=091', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6373, 1, 1592, 2, 0, NULL, 0, '2024-12-30 21:59:04', '2025-01-02 08:50:45', '2025-01-02', 'P5991', '24-07823-12-30', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'C/ MAQUINILLA, 13, PORTAL C, PISO 8-3', 'Madrid', 'Madrid', '28031', 'España', 30.61, 0, '2024-12-30 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-020125-H3lwehyy1+QFt-155', '370cafe4-717c-4f78-99a8-61c91889d955', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-020125-H3lwehyy1%2BQFt-155&s=KOL2025&nf=P5991&i=30.61&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
