INSERT INTO `packages` (`id`, `routing_id`, `parent_package_id`, `name`, `package_type`, `type`, `countries`, `states`, `cities`, `days`, `nights`, `start_date`, `end_date`, `pickup`, `drop`, `pickup_location`, `drop_location`, `pickup_drop_notes`, `customer_id`, `b2bpartenr`, `kids`, `adults`, `hotel_rating`, `amenities`, `description`, `main_image`, `attraction_total`, `per_person_cost`, `per_person_markup`, `per_child_cost`, `per_child_markup`, `per_child_cost_bed`, `per_child_bed_markup`, `show_split_cost`, `created_by`, `updated_by`, `approved_by`, `tags`, `inclusions`, `exclusions`, `air_itinerary`, `air_adult`, `air_child`, `air_infant`, `validity`, `status`, `created_at`, `updated_at`, `accomodation_total`, `conveyance_total`, `buying_price`, `buying_price_markup`, `grand_total`, `deleted_at`, `deleted_by`) VALUES
(125, 39, 0, 'test six', '1', '1', NULL, NULL, NULL, 3, 2, '2025-09-11', '2025-09-14', '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, 2550.00, 100.00, 100.00, 200.00, 200.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"test one\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"test\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"attributes\":{\"alt\":\"Electronic ticket - Wikipedia\"},\"insert\":{\"image\":\"data:image/jpeg;base64,[encoded data, 16764 characters]\"}},{\"insert\":{\"image\":\"data:image/png;base64,[encoded data, 67460 characters]\"}},{\"insert\":\"\\n\\nCompulsory tipping for guide and driver (Exclude from the tour price)\\nKindly prepare it in advance on your own in cash and give it directly to the guides and drivers:\\nGroup from 1 guest – 5 guests: Minimum USD 5/guest/day\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Group from 6 guests – 9 guests: Minimum USD 4/guest/day\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Group from 10 guests up: Minimum USD 3/guest/day\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, '', '3', '2024-12-10 06:07:33', '2025-01-03 05:56:30', 1200.00, 7600.00, 11350.00, 0.00, 0.00, NULL, NULL);
INSERT INTO `packages` (`id`, `routing_id`, `parent_package_id`, `name`, `package_type`, `type`, `countries`, `states`, `cities`, `days`, `nights`, `start_date`, `end_date`, `pickup`, `drop`, `pickup_location`, `drop_location`, `pickup_drop_notes`, `customer_id`, `b2bpartenr`, `kids`, `adults`, `hotel_rating`, `amenities`, `description`, `main_image`, `attraction_total`, `per_person_cost`, `per_person_markup`, `per_child_cost`, `per_child_markup`, `per_child_cost_bed`, `per_child_bed_markup`, `show_split_cost`, `created_by`, `updated_by`, `approved_by`, `tags`, `inclusions`, `exclusions`, `air_itinerary`, `air_adult`, `air_child`, `air_infant`, `validity`, `status`, `created_at`, `updated_at`, `accomodation_total`, `conveyance_total`, `buying_price`, `buying_price_markup`, `grand_total`, `deleted_at`, `deleted_by`) VALUES
(126, 39, 0, 'test six Package one', '1', '1', NULL, NULL, NULL, 3, 2, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 350.00, 200.00, 100.00, 0.00, 0.00, 0.00, 0.00, '1', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":{\"image\":\"/storage/images/MxNbIY6MjqO3qsUqHiQDC3kBbGnipe31jAcUTgbQ.png\"}},{\"insert\":{\"image\":\"/storage/images/aamxV5F3JuT7fVCm5BE2QgQ1GPUNc5OrfkGobVfV.jpg\"}},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, NULL, '3', '2024-12-10 07:47:19', '2024-12-10 10:28:42', 2700.00, 7600.00, 10650.00, 0.00, 20000.00, NULL, NULL),
(127, 38, 0, 'test five (Copy) Package one', '1', '1', NULL, NULL, NULL, 2, 1, NULL, NULL, '1', '1', '4', '7', NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, 0.00, 200.00, 100.00, 100.00, 50.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, NULL, '3', '2024-12-10 08:43:29', '2025-02-03 17:11:17', 3000.00, 2300.00, 5300.00, 0.00, 34000.00, '2025-02-03 17:11:17', 3),
(128, 11, 0, 'Misty Munnar', '1', '1', NULL, NULL, NULL, 3, 2, NULL, NULL, '1', '1', '39', '39', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 2775.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '1', NULL, NULL, NULL, NULL, '{\"ops\":[{\"insert\":\"Airfare\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":{\"image\":\"/storage/images/yHHQgzKmaF7F0AzqNWOdrRjovk8eDyuHKiRK3nWg.jpg\"}},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, '', '3', '2024-12-10 11:09:48', '2024-12-11 16:17:12', 0.00, 8400.00, 11175.00, 3500.00, 22175.00, NULL, NULL),
(129, 31, 0, 'Affordable Goa: The Budget Explorer\'s Tour', '1', '1', NULL, NULL, NULL, 4, 3, NULL, NULL, '1', '1', '49', '49', NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, '{\"ops\":[{\"insert\":\"Airfare\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-10 11:14:47', '2024-12-10 11:14:47', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(130, 31, 0, 'Affordable Goa: The Budget Explorer\'s Tour', '1', '1', NULL, NULL, NULL, 4, 3, NULL, NULL, '1', '1', '49', '49', NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, 550.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"insert\":\"Airfare\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":{\"image\":\"/storage/images/6P0o0hFt8ASWjXLOzsBwpK31FURYHrJQpz1xxsna.png\"}},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, NULL, '3', '2024-12-10 11:18:38', '2024-12-10 11:31:17', 15000.00, 4300.00, 19850.00, 3000.00, 22850.00, NULL, NULL),
(131, 36, 0, 'test four one', '1', '0', NULL, NULL, NULL, 3, 2, NULL, NULL, '1', '1', '24', '8', NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, 2300.00, 1000.00, 500.00, 200.00, 100.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":{\"image\":\"/storage/images/iTtUyuQj1QzjKc4Yx57QN4XkVdcxoAh5eD1AOTNZ.jpg\"}},{\"insert\":{\"image\":\"/storage/images/bmmgwyTAYy3cBRf49AGuDU4PRn1is2xNRIiRJdH2.jpg\"}},{\"insert\":\"\\n\\n\\n\\n\\n\"}]}', 0.00, 0.00, 0.00, '', '3', '2024-12-10 12:03:01', '2024-12-11 06:05:51', 0.00, 1200.00, 3500.00, 0.00, 0.00, NULL, NULL),
(132, 37, 0, 'test five', '1', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, 13, NULL, NULL, NULL, NULL, NULL, NULL, 3650.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":{\"image\":\"/storage/images/O9W99wY80zsaV70sfoMsf6LtatmSLPVkiKnltUCJ.png\"}},{\"insert\":{\"image\":\"/storage/images/sxETtrkAS4Mv2ixwRP422OFz3AVw8vl8JBNSVBKe.jpg\"}},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, '', '3', '2024-12-10 12:47:48', '2024-12-11 06:55:48', 0.00, 2300.00, 5950.00, 0.00, 0.00, NULL, NULL),
(133, 33, 0, 'test', '1', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '1', '1', '24', '8', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '1', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":{\"image\":\"/storage/images/KTG1V5n2GyXfPPu3FBgcjHptQv0mdH6l0RKwG8Jx.jpg\"}},{\"insert\":{\"image\":\"/storage/images/gHMHZVWhOBb1MDvkDt7WAiLjrZDBvdM3IXIFyzmH.jpg\"}},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, '2 days', '3', '2024-12-10 13:04:03', '2024-12-12 11:21:33', 6000.00, 3700.00, 12200.00, 0.00, 13000.00, NULL, NULL),
(134, 40, 0, 'Goa Rush: An Escape to the Coast', '0', '0', NULL, NULL, NULL, 3, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-10 13:09:01', '2024-12-10 13:09:19', 0.00, 78700.00, 0.00, 0.00, 0.00, NULL, NULL);
INSERT INTO `packages` (`id`, `routing_id`, `parent_package_id`, `name`, `package_type`, `type`, `countries`, `states`, `cities`, `days`, `nights`, `start_date`, `end_date`, `pickup`, `drop`, `pickup_location`, `drop_location`, `pickup_drop_notes`, `customer_id`, `b2bpartenr`, `kids`, `adults`, `hotel_rating`, `amenities`, `description`, `main_image`, `attraction_total`, `per_person_cost`, `per_person_markup`, `per_child_cost`, `per_child_markup`, `per_child_cost_bed`, `per_child_bed_markup`, `show_split_cost`, `created_by`, `updated_by`, `approved_by`, `tags`, `inclusions`, `exclusions`, `air_itinerary`, `air_adult`, `air_child`, `air_infant`, `validity`, `status`, `created_at`, `updated_at`, `accomodation_total`, `conveyance_total`, `buying_price`, `buying_price_markup`, `grand_total`, `deleted_at`, `deleted_by`) VALUES
(135, 40, 0, 'Goa Rush: An Escape to the Coast', '1', '1', NULL, NULL, NULL, 3, 2, NULL, NULL, '1', '1', '49', '49', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 50.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"insert\":\"Airfare from Kochi\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":{\"image\":\"data:image/png;base64,[encoded data, 67460 characters]\"}},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, '', '3', '2024-12-10 15:50:39', '2024-12-11 07:03:41', 5600.00, 7900.00, 13550.00, 7000.00, 20550.00, NULL, NULL);
INSERT INTO `packages` (`id`, `routing_id`, `parent_package_id`, `name`, `package_type`, `type`, `countries`, `states`, `cities`, `days`, `nights`, `start_date`, `end_date`, `pickup`, `drop`, `pickup_location`, `drop_location`, `pickup_drop_notes`, `customer_id`, `b2bpartenr`, `kids`, `adults`, `hotel_rating`, `amenities`, `description`, `main_image`, `attraction_total`, `per_person_cost`, `per_person_markup`, `per_child_cost`, `per_child_markup`, `per_child_cost_bed`, `per_child_bed_markup`, `show_split_cost`, `created_by`, `updated_by`, `approved_by`, `tags`, `inclusions`, `exclusions`, `air_itinerary`, `air_adult`, `air_child`, `air_infant`, `validity`, `status`, `created_at`, `updated_at`, `accomodation_total`, `conveyance_total`, `buying_price`, `buying_price_markup`, `grand_total`, `deleted_at`, `deleted_by`) VALUES
(136, 33, 0, 'test11', '1', '0', NULL, NULL, NULL, 2, 1, '2025-03-28', '2025-03-29', '1', '1', '24', '4', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 2500.00, 4350.00, 200.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '', '3', '2024-12-11 07:09:38', '2025-01-17 04:42:15', 0.00, 3700.00, 8700.00, 0.00, 45000.00, NULL, NULL),
(137, 41, 0, 'Test seven', '0', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2630.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-11 08:48:33', '2024-12-11 08:48:38', 0.00, 3400.00, 0.00, 0.00, 0.00, NULL, NULL),
(138, 23, 0, 'Maafushi Beach Escape', '1', '0', NULL, NULL, NULL, 4, 3, NULL, NULL, '1', '1', '98', '98', NULL, NULL, NULL, 2, 4, NULL, NULL, NULL, NULL, 90.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":{\"image\":\"/storage/images/2NbTcC4hrn3qH1jP9NxjwRu0gecHeuN5J6QRQoJh.jpg\"}},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, '', '1', '2024-12-11 10:15:28', '2024-12-11 12:09:00', 339.00, 0.00, 429.00, 100.00, 529.00, NULL, NULL),
(139, 33, 0, 'test', '3', '0', NULL, NULL, NULL, 2, 1, '2025-01-30', '2025-01-31', '0', '0', NULL, NULL, NULL, NULL, NULL, 1, 4, NULL, NULL, NULL, NULL, 2300.00, 4725.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '', '1', '2024-12-11 12:53:05', '2025-01-17 05:44:27', 1500.00, 3700.00, 18900.00, 0.00, 0.00, NULL, NULL),
(140, 35, 0, 'test one 1.2', '3', '0', NULL, NULL, NULL, 3, 2, '2025-01-08', '2025-01-10', '1', '1', '24', '4', NULL, NULL, NULL, 2, 2, NULL, NULL, NULL, NULL, 3200.00, 100.00, 200.00, 200.00, 100.00, 300.00, 100.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '567877878', '3', '2024-12-12 05:19:45', '2025-01-08 05:25:14', 6000.00, 0.00, 9200.00, 0.00, 34000.00, NULL, NULL),
(141, 37, 0, 'test five', '3', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3650.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '12/09/24', '1', '2024-12-12 05:49:32', '2024-12-12 05:52:36', 4800.00, 2300.00, 10750.00, 0.00, 0.00, NULL, NULL),
(142, 42, 0, 'Test Eight', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-12 06:24:04', '2024-12-12 10:59:09', 0.00, 5000.00, 0.00, 0.00, 0.00, NULL, NULL),
(143, 42, 0, 'Test Eight', '3', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, NULL, 3300.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '1', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 100.00, 200.00, 300.00, '6/12/24', '3', '2024-12-12 06:25:43', '2024-12-12 06:30:09', 0.00, 5000.00, 8900.00, 0.00, 10000.00, NULL, NULL),
(144, 37, 0, 'test five', '3', '0', NULL, NULL, NULL, 2, 1, '2025-01-08', '2025-01-09', '1', '1', '8', '24', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 0.00, 6500.00, 0.00, 0.00, 0.00, 0.00, 0.00, '1', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 3000.00, 1000.00, 0.00, '', '3', '2024-12-12 06:46:56', '2025-02-05 12:11:22', 3500.00, 0.00, 15000.00, 0.00, 23000.00, NULL, NULL),
(145, 42, 0, 'Test Eight Package one', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '8', NULL, NULL, NULL, 1, 2, NULL, NULL, NULL, NULL, 3300.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '', '3', '2024-12-12 10:44:40', '2025-01-01 08:18:44', 0.00, 5000.00, 8300.00, 0.00, 0.00, NULL, NULL),
(146, 33, 0, 'test', '3', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-12 11:15:20', '2024-12-12 11:15:20', 0.00, 3700.00, 0.00, 0.00, 0.00, NULL, NULL),
(147, 35, 0, 'test one', '3', '0', NULL, NULL, NULL, 3, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3200.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-12 11:26:14', '2024-12-12 11:26:14', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(148, 35, 0, 'test one', '3', '0', NULL, NULL, NULL, 3, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3200.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-12 11:34:25', '2024-12-12 11:34:25', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(149, 33, 0, 'test', '3', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-12 11:39:59', '2024-12-12 11:39:59', 0.00, 3700.00, 0.00, 0.00, 0.00, NULL, NULL),
(150, 33, 0, 'test', '3', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-12 11:40:31', '2024-12-12 11:40:31', 0.00, 3700.00, 0.00, 0.00, 0.00, NULL, NULL),
(151, 42, 0, 'Test Eight', '3', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"attributes\":{\"alt\":\"99,000+ Airplane Ticket Stock Photos ...\"},\"insert\":{\"image\":\"data:image/jpeg;base64,[encoded data, 9816 characters]\"}},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, '', '3', '2024-12-12 11:55:23', '2024-12-12 12:44:35', 0.00, 5000.00, 5000.00, 0.00, 0.00, NULL, NULL),
(152, 33, 0, 'test', '3', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-12 11:55:40', '2024-12-12 11:55:40', 0.00, 3700.00, 0.00, 0.00, 0.00, NULL, NULL),
(153, 33, 0, 'test', '3', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-12 12:01:15', '2024-12-12 12:01:15', 0.00, 3700.00, 0.00, 0.00, 0.00, NULL, NULL),
(154, 33, 0, 'test', '3', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-12 12:01:38', '2024-12-12 12:01:38', 0.00, 3700.00, 0.00, 0.00, 0.00, NULL, NULL),
(155, 33, 0, 'test', '3', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-12 12:02:24', '2024-12-12 12:02:24', 0.00, 3700.00, 0.00, 0.00, 0.00, NULL, NULL),
(156, 42, 0, 'Test Eight', '3', '0', NULL, NULL, NULL, 2, 2, '2025-01-08', '2025-01-10', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"attributes\":{\"alt\":\"99,000+ Airplane Ticket Stock Photos ...\"},\"insert\":{\"image\":\"data:image/jpeg;base64,[encoded data, 9816 characters]\"}},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, '', '3', '2024-12-12 12:20:08', '2025-01-08 05:27:38', 0.00, 5000.00, 5000.00, 0.00, 0.00, NULL, NULL),
(157, 31, 0, 'Affordable Goa: The Budget Explorer\'s Tour', '1', '1', NULL, NULL, NULL, 4, 3, NULL, NULL, '1', '1', '49', '49', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 550.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Airfare/Train\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '', '3', '2024-12-13 06:10:51', '2024-12-13 06:18:01', 8400.00, 3600.00, 12550.00, 0.00, 7850.00, NULL, NULL),
(158, 14, 0, 'Tranquil Kerala Escape', '1', '1', NULL, NULL, NULL, 5, 4, NULL, NULL, '1', '1', '39', '39', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 2045.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Airfare/Train\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '', '3', '2024-12-13 06:49:50', '2024-12-13 07:06:23', 14800.00, 10500.00, 27345.00, 0.00, 14999.00, NULL, NULL),
(159, 42, 0, 'Test Eight Package one', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '8', NULL, NULL, 47, NULL, 4, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, 'fdff', '3', '2024-12-13 08:26:41', '2024-12-13 09:03:24', 0.00, 5000.00, 5000.00, 0.00, 0.00, NULL, NULL),
(160, 43, 0, 'test ten', '0', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-13 08:50:00', '2024-12-13 08:50:03', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(161, 43, 0, 'test ten', '1', '1', NULL, NULL, NULL, 2, 1, NULL, NULL, '1', '1', '4', '8', NULL, NULL, 47, NULL, NULL, NULL, NULL, NULL, NULL, 1000.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '', '3', '2024-12-13 08:50:29', '2024-12-13 08:54:13', 6668.00, 0.00, 7668.00, 0.00, 60000.00, NULL, NULL),
(162, 44, 0, 'Charming Ooty Escape', '0', '0', NULL, NULL, NULL, 3, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 200.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-13 08:56:40', '2024-12-13 08:56:43', 0.00, 13500.00, 0.00, 0.00, 0.00, NULL, NULL),
(163, 35, 0, 'test one enquiry', '3', '0', NULL, NULL, NULL, 3, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3200.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 47, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '', '2', '2024-12-13 10:56:02', '2024-12-13 10:56:51', 0.00, 0.00, 3200.00, 0.00, 0.00, NULL, NULL);
INSERT INTO `packages` (`id`, `routing_id`, `parent_package_id`, `name`, `package_type`, `type`, `countries`, `states`, `cities`, `days`, `nights`, `start_date`, `end_date`, `pickup`, `drop`, `pickup_location`, `drop_location`, `pickup_drop_notes`, `customer_id`, `b2bpartenr`, `kids`, `adults`, `hotel_rating`, `amenities`, `description`, `main_image`, `attraction_total`, `per_person_cost`, `per_person_markup`, `per_child_cost`, `per_child_markup`, `per_child_cost_bed`, `per_child_bed_markup`, `show_split_cost`, `created_by`, `updated_by`, `approved_by`, `tags`, `inclusions`, `exclusions`, `air_itinerary`, `air_adult`, `air_child`, `air_infant`, `validity`, `status`, `created_at`, `updated_at`, `accomodation_total`, `conveyance_total`, `buying_price`, `buying_price_markup`, `grand_total`, `deleted_at`, `deleted_by`) VALUES
(164, 43, 0, 'test ten Package one', '1', '1', NULL, NULL, NULL, 2, 1, NULL, NULL, '1', '1', '4', '8', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '', '1', '2024-12-13 13:13:51', '2024-12-13 13:17:08', 6668.00, 0.00, 6668.00, 0.00, 54000.00, NULL, NULL),
(165, 37, 0, 'test five', '3', '0', NULL, NULL, NULL, 2, 1, '2025-03-25', '2025-03-26', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 3, NULL, NULL, NULL, NULL, 3650.00, 4416.67, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, 3, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '12/9/2024', '3', '2024-12-13 13:18:18', '2025-01-23 12:01:34', 0.00, 2300.00, 13250.00, 0.00, 4000.00, NULL, NULL),
(166, 43, 0, 'test ten', '1', '1', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', '4', '8', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1000.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '', 0.00, 0.00, 0.00, '', '1', '2024-12-13 14:01:40', '2024-12-13 14:01:55', 0.00, 0.00, 1000.00, 0.00, 0.00, NULL, NULL),
(167, 45, 0, 'Pattaya & Bangkok: A Magical Thai Experience', '0', '0', NULL, NULL, NULL, 5, 4, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3410.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-14 19:38:37', '2024-12-14 19:38:43', 0.00, 65300.00, 0.00, 0.00, 0.00, NULL, NULL);
INSERT INTO `packages` (`id`, `routing_id`, `parent_package_id`, `name`, `package_type`, `type`, `countries`, `states`, `cities`, `days`, `nights`, `start_date`, `end_date`, `pickup`, `drop`, `pickup_location`, `drop_location`, `pickup_drop_notes`, `customer_id`, `b2bpartenr`, `kids`, `adults`, `hotel_rating`, `amenities`, `description`, `main_image`, `attraction_total`, `per_person_cost`, `per_person_markup`, `per_child_cost`, `per_child_markup`, `per_child_cost_bed`, `per_child_bed_markup`, `show_split_cost`, `created_by`, `updated_by`, `approved_by`, `tags`, `inclusions`, `exclusions`, `air_itinerary`, `air_adult`, `air_child`, `air_infant`, `validity`, `status`, `created_at`, `updated_at`, `accomodation_total`, `conveyance_total`, `buying_price`, `buying_price_markup`, `grand_total`, `deleted_at`, `deleted_by`) VALUES
(168, 45, 0, 'Pattaya & Bangkok: A Magical Thai Experience', '1', '0', NULL, NULL, NULL, 5, 4, NULL, NULL, '1', '1', '138', '138', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 3410.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '1', NULL, NULL, NULL, NULL, '{\"ops\":[{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Transfers & Sightseeing in A/C vehicle as per the itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Hotel stays as mentioned in itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal plan as mentioned in Itinerary\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"Fuel Expense  and Driver Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Meal other than specified.\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Adventure, Rides or Activities not mention in itinerary. \"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"Any personal Expense\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"GST\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', '{\"ops\":[{\"insert\":{\"image\":\"data:image/png;base64,[encoded data, 56864 characters]\"}},{\"insert\":\"\\nsss\"},{\"insert\":{\"image\":\"data:image/png;base64,[encoded data, 36924 characters]\"}},{\"insert\":\"\\n\"},{\"insert\":{\"image\":\"data:image/png;base64,[encoded data, 80084 characters]\"}},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, '12/dec', '1', '2024-12-14 19:39:09', '2024-12-15 06:46:50', 0.00, 8800.00, 12210.00, 5000.00, 17210.00, NULL, NULL);
