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
(6785, 1, 1695, 2, 0, NULL, 0, '2025-02-26 14:01:01', '2025-02-27 07:45:48', '2025-02-27', 'P6377', '25-08271-02-26', '', 0.00, 11.20, 3.42, 0.00, 0, 0.00, 6.17, 'Orape 8 bajo', 'Zarautz', 'Gipuzkoa', '20800', 'España', 19.72, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-270225-HKBk8XYPVgKkB-191', '616de863-e1d4-4f49-a214-60705274491c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270225-HKBk8XYPVgKkB-191&s=KOL2025&nf=P6377&i=19.72&cr=243', '[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
(6786, 1, 4, 2, 0, NULL, 0, '2025-02-26 18:11:19', '2025-02-27 08:39:34', '2025-02-27', 'P6376', '25-08273-02-26', '', 0.00, 117.88, 24.76, 0.00, 0, 0.00, 0.00, 'Plaza San Martin de Abendaño 4, bajo', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 142.63, 0, '2025-02-26 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270225-ObQw3ID42+++Y-075', '89fef3ea-2b9b-4010-8398-6e0797e93d79', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270225-ObQw3ID42%2B%2B%2BY-075&s=KOL2025&nf=P6376&i=142.63&cr=176', '[BLOB]', 0, 'PKANHY071000484H', '2025-02-27 08:39:38', '[BLOB]', 2, '', '2025-02-27', 'S0235', 10, 5, 20, 1600, 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
(6787, 1, 566, 2, 0, NULL, 0, '2025-02-27 10:09:42', '2025-02-27 11:12:43', '2025-02-27', 'P6378', '25-08275-02-27', '', 0.00, 147.35, 30.94, 0.00, 0, 0.00, 0.00, 'C/SANT CUGAT 29 (LOCAL)', 'Mataró', 'Barcelona', '08302', 'España', 178.29, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-270225-ebX6XUeOHt79X-033', '99a99ada-91ca-40eb-b099-a302b8330e92', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270225-ebX6XUeOHt79X-033&s=KOL2025&nf=P6378&i=178.29&cr=235', '[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
(6788, 1, 1248, 2, 0, NULL, 0, '2025-02-27 10:40:26', '2025-02-27 11:52:54', '2025-02-27', 'P6379', '25-08276-02-27', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'Sardenya 398 5º2ª', 'Barcelona', 'Barcelona', '08025', 'España', 17.72, 0, '2025-02-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-270225-KCF5VVAz6VG2Y-089', 'f377e105-ccf0-49ec-b91e-1071b8a2fc83', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-270225-KCF5VVAz6VG2Y-089&s=KOL2025&nf=P6379&i=17.72&cr=237', '[BLOB]', 0, 'PKANHY071000487K', '2025-02-27 11:53:02', '[BLOB]', 2, '', '2025-02-27', 'S0235', 20, 5, 10, 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
(6789, 1, 1696, 2, 0, NULL, 0, '2025-02-27 12:38:42', '2025-02-28 09:11:03', '2025-02-28', 'P6380', '25-08277-02-27', '', 0.00, 11.20, 3.08, 0.00, 0, 0.00, 4.17, 'Teodoro Llorent, 3', 'Torrent', 'Valencia', '46901', 'España', 17.72, 0, '2025-02-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280225-MRFGJX8SpJF85-062', '812c002f-a8af-413c-8451-bfc0e07e726b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280225-MRFGJX8SpJF85-062&s=KOL2025&nf=P6380&i=17.72&cr=199', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6790, 1, 110, 2, 0, NULL, 0, '2025-02-27 12:42:36', '2025-02-28 09:12:24', '2025-02-28', 'P6381', '25-08278-02-27', '', 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'calle portugal 40 ', 'Don Benito', 'Badajoz', '06400', 'España', 213.95, 0, '2025-02-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280225-AffJKZpQK61NN-202', '0143e9a2-90f9-48df-b62e-7c3c30af256e', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280225-AffJKZpQK61NN-202&s=KOL2025&nf=P6381&i=213.95&cr=149', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6791, 1, 1697, 2, 0, NULL, 0, '2025-02-27 13:58:31', '2025-02-28 09:13:31', '2025-02-28', 'P6382', '25-08280-02-27', 'Es la única casa terminada en esa calle, detrás de otras en construcción. ', 0.00, 22.40, 5.43, 0.00, 0, 0.00, 4.17, 'Avenida José González Luque, 1-1', 'Dos Hermanas', 'Sevilla', '41704', 'España', 31.27, 0, '2025-02-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280225-GyS2jMBlHyt5s-221', '809e14e7-5f0b-4a90-af7b-5495069b5b27', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280225-GyS2jMBlHyt5s-221&s=KOL2025&nf=P6382&i=31.27&cr=228', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6792, 1, 522, 2, 0, NULL, 0, '2025-02-27 14:16:58', '2025-02-28 09:14:11', '2025-02-28', 'P6383', '25-08281-02-27', '', 0.00, 147.35, 30.95, 0.00, 0, 0.00, 0.00, 'Paseo de los hoteles nº12', 'Valdemoro', 'Madrid', '28341', 'España', 178.29, 0, '2025-02-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280225-PLrnA7YogL3vn-208', '52c47f17-e955-4862-b5ea-a2be77b059c5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280225-PLrnA7YogL3vn-208&s=KOL2025&nf=P6383&i=178.29&cr=020', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6793, 1, 57, 2, 0, NULL, 0, '2025-02-27 14:59:52', '2025-02-28 09:14:56', '2025-02-28', 'P6384', '25-08282-02-27', '', 0.00, 176.82, 37.13, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 213.95, 0, '2025-02-27 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-280225-LmsEDubXpuPZv-250', '4dcfb4cb-a857-4cb0-99fa-af33fc2d2227', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280225-LmsEDubXpuPZv-250&s=KOL2025&nf=P6384&i=213.95&cr=181', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1),
(6794, 1, 653, 2, 0, NULL, 0, '2025-02-27 17:22:43', '2025-02-28 09:15:51', '2025-02-28', 'P6385', '25-08283-02-27', '', 0.00, 31.70, 7.38, 0.00, 0, 0.00, 4.17, 'C. de Juan María Gelbentzu Kalea, 4-3.ezk', 'Pamplona/Iruña', 'Navarra', '31005', 'España', 42.53, 0, '2025-02-27 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-280225-UUOIxBH7RyjPz-237', '51d89a0f-a4f7-486d-9b9b-e90bd1dfc624', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-280225-UUOIxBH7RyjPz-237&s=KOL2025&nf=P6385&i=42.53&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', 'S0133', 0, 0, 0, 0, 0, '', 1, 1);
