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
(169, 35, 0, 'test one  new', '3', '0', NULL, NULL, NULL, 3, 2, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, 47, NULL, 3, NULL, NULL, NULL, NULL, 3200.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, '31/12', '3', '2024-12-16 07:49:22', '2024-12-16 07:50:45', 0.00, 32000.00, 35200.00, 0.00, 0.00, NULL, NULL),
(170, 46, 0, 'test 12', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3800.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-16 12:13:52', '2024-12-16 12:13:55', 0.00, 1300.00, 0.00, 0.00, 0.00, NULL, NULL),
(171, 46, 0, 'test 12', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '7', NULL, NULL, 47, NULL, 4, NULL, NULL, NULL, NULL, 3800.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, '4/04/2024', '3', '2024-12-16 12:14:18', '2024-12-16 12:15:46', 1500.00, 1300.00, 6600.00, 0.00, 0.00, NULL, NULL),
(172, 11, 0, 'Misty Munnar', '1', '1', NULL, NULL, NULL, 3, 2, NULL, NULL, '0', '0', '39', '39', 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, '{\"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\"}]}', NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-17 09:09:14', '2024-12-17 09:09:14', 0.00, 0.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
(173, 14, 0, 'Tranquil Kerala Escape:', '3', '0', NULL, NULL, NULL, 5, 4, '2025-03-29', '2025-04-02', '1', '1', '39', '39', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 2045.00, 29395.00, 0.00, 10185.00, 0.00, 9385.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\":\"data:image/png;base64,[encoded data, 138812 characters]\"}},{\"insert\":\"\\n\"}]}', 14900.00, 0.00, 0.00, '', '3', '2024-12-17 14:49:06', '2025-01-15 07:36:15', 22100.00, 10500.00, 58790.00, 7500.00, 49995.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
(174, 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, '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, '19/Dec', '1', '2024-12-19 04:57:37', '2024-12-19 04:58:55', 5000.00, 9000.00, 16775.00, 0.00, 19800.00, NULL, NULL),
(175, 47, 0, 'Whispers of Meghalaya: Hills and Valleys Exploration', '0', '0', NULL, NULL, NULL, 5, 4, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 990.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-19 09:05:39', '2024-12-19 09:05:44', 0.00, 173000.00, 0.00, 0.00, 0.00, NULL, NULL),
(176, 48, 0, 'Tranquil Kerala Escape with Cochin Retreat', '0', '0', NULL, NULL, NULL, 6, 5, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1715.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-19 16:08:55', '2024-12-19 16:08:58', 0.00, 66400.00, 0.00, 0.00, 0.00, NULL, NULL),
(177, 48, 0, 'Tranquil Kerala Escape with Cochin Retreat', '1', '1', NULL, NULL, NULL, 6, 5, NULL, NULL, '1', '1', '39', '39', NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, 1715.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\":\"Air fare \"},{\"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, '20/12/2024', '1', '2024-12-19 18:23:27', '2024-12-19 18:45:23', 26800.00, 12500.00, 41015.00, 0.00, 61500.00, NULL, NULL),
(178, 49, 0, 'test 11', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4290.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-20 06:50:13', '2024-12-31 09:09:53', 0.00, 4950.00, 0.00, 0.00, 0.00, NULL, NULL),
(179, 49, 0, 'test 11', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '24', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 5740.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/12/24', '3', '2024-12-20 06:52:15', '2024-12-20 09:09:57', 2500.00, 4550.00, 12790.00, 0.00, 0.00, NULL, NULL),
(180, 51, 0, 'test 12.1', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1520.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-20 07:52:08', '2024-12-20 10:27:45', 0.00, 14500.00, 0.00, 0.00, 0.00, '2024-12-20 10:27:45', NULL),
(181, 52, 0, 'test 13', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2700.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-20 08:08:38', '2024-12-20 08:08:42', 0.00, 5600.00, 0.00, 0.00, 0.00, NULL, NULL),
(182, 52, 0, 'test 13', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2700.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-20 08:09:41', '2024-12-20 08:10:22', 0.00, 3500.00, 6200.00, 0.00, 0.00, NULL, NULL),
(183, 53, 0, 'test12.2', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2120.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-20 10:24:35', '2024-12-20 10:27:29', 0.00, 7200.00, 0.00, 0.00, 0.00, '2024-12-20 10:27:29', NULL),
(184, 54, 0, 'test14', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 400.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-20 10:30:02', '2024-12-20 10:30:05', 0.00, 6500.00, 0.00, 0.00, 0.00, NULL, NULL),
(185, 54, 0, 'test14', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '8', NULL, NULL, NULL, 2, 2, NULL, NULL, NULL, NULL, 3370.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-20 10:34:22', '2024-12-20 13:21:45', 12250.00, 4000.00, 19620.00, 0.00, 0.00, NULL, NULL),
(186, 54, 0, 'test14 Package1', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '8', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 1300.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-20 11:51:47', '2024-12-20 13:17:11', 0.00, 6500.00, 7800.00, 0.00, 0.00, NULL, NULL),
(187, 55, 0, 'test 15', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2560.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-20 12:03:22', '2024-12-20 12:03:25', 0.00, 11500.00, 0.00, 0.00, 0.00, NULL, NULL),
(188, 55, 0, 'test 15', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 3770.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-20 12:05:45', '2024-12-20 12:35:16', 0.00, 6000.00, 9770.00, 0.00, 0.00, NULL, NULL),
(189, 54, 185, 'test14', '2', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '8', NULL, NULL, NULL, 2, 2, NULL, NULL, NULL, NULL, 3970.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, '', '1', '2024-12-20 13:00:30', '2024-12-20 13:00:30', 12250.00, 5300.00, 21520.00, 0.00, 0.00, NULL, NULL),
(190, 56, 0, 'Trio of Temples: Madurai-Rameshwaram-Kanyakumari', '0', '0', NULL, NULL, NULL, 3, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 250.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-21 09:59:15', '2024-12-26 15:41:20', 0.00, 33650.00, 0.00, 0.00, 0.00, NULL, NULL),
(191, 56, 0, 'Trio of Temples: Madurai-Rameshwaram-Kanyakumari', '1', '1', NULL, NULL, NULL, 3, 2, NULL, NULL, '0', '0', '158', '158', NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, 250.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\"}]}', '', 0.00, 0.00, 0.00, '', '1', '2024-12-21 10:10:45', '2024-12-24 13:27:02', 0.00, 18800.00, 19050.00, 4000.00, 23050.00, NULL, NULL),
(192, 57, 0, 'Test without roundtrip', '0', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 20.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-25 01:18:12', '2024-12-25 01:18:15', 0.00, 3700.00, 0.00, 0.00, 0.00, NULL, NULL),
(193, 58, 0, 'Test with roundtrip', '0', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 400.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-25 01:20:42', '2024-12-25 01:20:44', 0.00, 3300.00, 0.00, 0.00, 0.00, NULL, NULL),
(194, 57, 0, 'Test without roundtrip', '1', '1', NULL, NULL, NULL, 2, 1, '2025-09-22', '2025-09-23', '0', '0', '24', '24', NULL, NULL, NULL, 2, 4, NULL, NULL, NULL, NULL, 20.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-25 01:22:11', '2025-01-13 11:57:52', 0.00, 6500.00, 6520.00, 0.00, 0.00, NULL, NULL),
(195, 58, 0, 'Test with roundtrip', '1', '1', NULL, NULL, NULL, 2, 1, '2025-10-26', '2025-10-27', '0', '0', '24', '24', NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, 400.00, 2120.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-25 01:28:14', '2025-01-21 08:01:57', 0.00, 8600.00, 10600.00, 0.00, 0.00, NULL, NULL),
(196, 59, 0, 'Kashmir Bliss: 6-Days Exploration of Wonderland', '0', '0', NULL, NULL, NULL, 6, 5, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1950.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-26 16:12:54', '2024-12-26 16:12:57', 0.00, 49200.00, 0.00, 0.00, 0.00, NULL, NULL),
(197, 60, 0, 'Serenity Awaits: 5 Days in the Heart of Kashmir', '0', '0', NULL, NULL, NULL, 5, 4, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2450.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-26 16:27:36', '2024-12-26 16:27:49', 0.00, 41000.00, 0.00, 0.00, 0.00, NULL, NULL),
(198, 61, 0, 'Enchanting Kashmir- Srinagar, Pahalgam & Sonamarg', '0', '0', NULL, NULL, NULL, 4, 3, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 650.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-26 16:31:02', '2024-12-26 17:45:53', 0.00, 32800.00, 0.00, 0.00, 0.00, NULL, NULL),
(199, 61, 0, 'Enchanting 4-Day Kashmir', '1', '1', NULL, NULL, NULL, 4, 3, NULL, NULL, '1', '1', '107', '107', 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\":\"Local Taxi / Pony/ gondola in Gulmarg/pahalgam/sonamarg Extra \"},{\"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\"}]}', NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-26 16:34:06', '2024-12-26 16:34:06', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(200, 62, 0, 'Serene Kerala Escape', '0', '0', NULL, NULL, NULL, 6, 5, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1640.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-26 18:59:39', '2024-12-26 18:59:42', 0.00, 149700.00, 0.00, 0.00, 0.00, NULL, NULL),
(201, 11, 0, 'Misty Munnar', '1', '1', NULL, NULL, NULL, 3, 2, NULL, NULL, '1', '1', '39', '39', NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, 3715.00, 10025.00, 0.00, 6225.00, 0.00, 5825.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-26 19:03:31', '2024-12-26 19:11:23', 5000.00, 9000.00, 40100.00, 50000.00, 90100.00, NULL, NULL),
(202, 63, 0, '2daystest12', '0', '0', NULL, NULL, NULL, 2, 1, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2550.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-27 03:58:55', '2024-12-27 03:58:59', 0.00, 3500.00, 0.00, 0.00, 0.00, NULL, NULL),
(203, 63, 0, '2daystest12', '1', '1', NULL, NULL, NULL, 2, 1, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 3390.00, 6140.00, 0.00, 3875.00, 0.00, 3875.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\"}]}', '', 1000.00, 1200.00, 0.00, '', '3', '2024-12-27 03:59:34', '2024-12-27 06:37:16', 1000.00, 3500.00, 12280.00, 0.00, 0.00, NULL, NULL),
(204, 63, 0, '2daystest12 Package one', '1', '1', NULL, NULL, NULL, 2, 1, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, 0, 2, NULL, NULL, NULL, NULL, 4050.00, 7800.00, 0.00, 5150.00, 0.00, 5150.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-27 04:25:50', '2024-12-27 08:33:30', 2000.00, 3500.00, 15600.00, 0.00, 0.00, NULL, NULL),
(205, 17, 0, 'Kerala’s Essence: Hills, Wildlife, Backwaters & Beaches', '3', '0', NULL, NULL, NULL, 6, 5, '2025-03-28', '2025-04-02', '1', '1', '39', '23', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 2090.00, 33990.00, 0.00, 13070.00, 0.00, 11570.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\"}]}', '', 0.00, 0.00, 0.00, '', '3', '2024-12-27 04:56:24', '2025-01-15 07:38:52', 23400.00, 17000.00, 67980.00, 2000.00, 69980.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
(206, 48, 0, 'Tranquil Kerala Escape with Cochin Retreat', '3', '1', NULL, NULL, NULL, 6, 5, NULL, NULL, '1', '1', '24', '24', NULL, NULL, NULL, 0, 2, NULL, NULL, NULL, NULL, 1715.00, 28640.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, '{\"ops\":[{\"insert\":\"Flight from Chennai (Roundtrip)\"},{\"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, 86572 characters]\"}},{\"insert\":\"\\n\"}]}', 7100.00, 0.00, 0.00, 'Jan 4th', '2', '2024-12-27 05:03:29', '2025-01-02 06:41:24', 13575.00, 12500.00, 57280.00, 0.00, 57280.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
(207, 15, 0, 'Kerala Splendor: Hills, Wildlife, Backwaters & Heritage', '3', '1', NULL, NULL, NULL, 6, 5, NULL, NULL, '1', '1', '36', '24', NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, NULL, 1875.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\"}]}', NULL, 0.00, 0.00, 0.00, NULL, '2', '2024-12-27 05:17:31', '2024-12-27 05:18:22', 0.00, 127500.00, 0.00, 0.00, 129375.00, NULL, NULL),
(208, 63, 0, '2daystest12 Package two', '1', '1', NULL, NULL, NULL, 2, 1, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, 4, 2, NULL, NULL, NULL, NULL, 2550.00, 4133.33, 0.00, 2583.33, 0.00, 2583.33, 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/12/2035', '3', '2024-12-27 06:56:53', '2024-12-30 04:11:41', 1000.00, 3500.00, 18600.00, 100.00, 10700.00, NULL, NULL),
(209, 63, 0, '2daystest12', '1', '1', NULL, NULL, NULL, 2, 1, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, 2, 2, NULL, NULL, NULL, NULL, 3000.00, 4875.00, 0.00, 3275.00, 0.00, 3275.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-27 09:19:34', '2024-12-30 04:08:48', 1000.00, 3500.00, 16300.00, 100.00, 16400.00, NULL, NULL),
(210, 64, 0, 'Girls\' Trip to Goa: Beaches, Parties, and Memories', '0', '0', NULL, NULL, NULL, 3, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1250.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-28 07:00:17', '2024-12-28 07:00:28', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(211, 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, 22095.00, 0.00, 9285.00, 0.00, 8285.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\"}]}', '', 0.00, 0.00, 0.00, 'Jan - April 2025', '1', '2024-12-28 10:28:01', '2024-12-28 10:31:30', 14800.00, 10500.00, 44190.00, 0.00, 15999.00, NULL, NULL),
(212, 30, 0, 'Kashmir Essence: Tour of Srinagar, Pahalgam & Gulmarg', '1', '1', NULL, NULL, NULL, 4, 3, NULL, NULL, '1', '1', '107', '107', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 2450.00, 17350.00, 0.00, 9490.00, 0.00, 8890.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-29 13:41:00', '2024-12-29 13:53:29', 10500.00, 8800.00, 34700.00, 0.00, 11110.00, NULL, NULL),
(213, 65, 0, '2days 3days test 11', '0', '0', NULL, NULL, NULL, 3, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 680.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-30 04:38:30', '2024-12-30 04:38:34', 0.00, 5000.00, 0.00, 0.00, 0.00, NULL, NULL),
(214, 65, 0, '2days 3days test 11', '1', '1', NULL, NULL, NULL, 3, 2, NULL, NULL, '1', '1', '36', '20', NULL, NULL, NULL, 3, 2, NULL, NULL, NULL, NULL, 680.00, 10280.00, 0.00, 2756.00, 0.00, 2430.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-30 04:39:10', '2024-12-31 09:30:54', 11400.00, 7000.00, 28828.00, 0.00, 0.00, '2024-12-31 09:30:54', 3),
(215, 65, 0, '2days 3days test 11', '1', '1', NULL, NULL, NULL, 3, 2, NULL, NULL, '1', '1', '36', '20', NULL, NULL, NULL, 0, 3, NULL, NULL, NULL, NULL, 680.00, 2346.67, 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-30 10:02:01', '2024-12-31 09:29:52', 0.00, 5000.00, 7040.00, 0.00, 0.00, '2024-12-31 09:29:52', 3),
(216, 66, 0, 'test 12', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 210.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\"}]}', NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-30 10:05:49', '2025-01-01 08:05:11', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(217, 66, 0, 'test 12 Package one', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '20', NULL, NULL, NULL, 2, 3, NULL, NULL, NULL, NULL, 210.00, 210.00, 0.00, 110.00, 0.00, 110.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-30 10:06:32', '2024-12-30 10:12:22', 0.00, 0.00, 850.00, 0.00, 0.00, NULL, NULL),
(218, 67, 0, 'test  free', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 515.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, '{\"ops\":[{\"insert\":\"heading\"},{\"attributes\":{\"header\":1},\"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\"},{\"attributes\":{\"background\":\"transparent\",\"color\":\"#000000\"},\"insert\":\"test one\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\\n\"}]}', '{\"ops\":[{\"insert\":\"Monument entrance fee / Camera fees.\"},{\"attributes\":{\"align\":\"center\",\"header\":1},\"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 two\"},{\"attributes\":{\"list\":\"bullet\"},\"insert\":\"\\n\"},{\"insert\":\"\\n\"}]}', NULL, 0.00, 0.00, 0.00, NULL, '1', '2024-12-30 10:18:47', '2025-01-24 14:39:30', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(219, 67, 0, 'test  free', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '3', '24', NULL, NULL, NULL, 1, 3, NULL, NULL, NULL, NULL, 515.00, 515.00, 0.00, 915.00, 0.00, 915.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, '23/12/24', '3', '2024-12-30 10:19:12', '2025-01-01 07:25:19', 0.00, 0.00, 1545.00, 0.00, 0.00, NULL, NULL),
(220, 68, 0, '2 days  test 1.56', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2600.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-31 05:56:11', '2024-12-31 09:00:26', 0.00, 3000.00, 0.00, 0.00, 0.00, NULL, NULL),
(221, 68, 0, '2 days  test 1.56 Package 2', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '8', NULL, NULL, NULL, 3, 4, NULL, NULL, NULL, NULL, 2600.00, 4100.00, 0.00, 2950.00, 0.00, 2950.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-31 05:58:46', '2024-12-31 06:23:43', 750.00, 3000.00, 14100.00, 0.00, 0.00, NULL, NULL),
(222, 68, 0, '2 days  test 1.56 package 34', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '8', NULL, NULL, NULL, 2, 6, NULL, NULL, NULL, NULL, 2600.00, 2975.00, 0.00, 2575.00, 0.00, 2575.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-31 08:17:21', '2024-12-31 08:18:11', 0.00, 3000.00, 17850.00, 0.00, 0.00, NULL, NULL),
(223, 68, 0, '2 days  test 1.56 three', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '8', NULL, NULL, NULL, 1, 5, NULL, NULL, NULL, NULL, 2600.00, 3100.00, 0.00, 2700.00, 0.00, 2700.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-31 09:02:09', '2024-12-31 09:03:16', 0.00, 3000.00, 15500.00, 0.00, 0.00, NULL, NULL),
(224, 49, 0, 'test 11', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '24', NULL, NULL, NULL, 3, 5, NULL, NULL, NULL, NULL, 4290.00, 4908.75, 0.00, 3678.75, 0.00, 3678.75, 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-31 09:10:17', '2024-12-31 09:11:25', 0.00, 4950.00, 24543.75, 0.00, 0.00, NULL, NULL),
(225, 69, 0, 'test seven 1', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2200.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-31 09:37:28', '2024-12-31 09:37:32', 0.00, 5500.00, 0.00, 0.00, 0.00, NULL, NULL),
(226, 69, 0, 'test seven 1', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '8', NULL, NULL, NULL, NULL, 8, NULL, NULL, NULL, NULL, 2200.00, 2887.50, 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-31 09:38:17', '2024-12-31 09:39:24', 0.00, 5500.00, 23100.00, 0.00, 0.00, NULL, NULL),
(227, 70, 0, 'test 16', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1810.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-31 09:43:57', '2024-12-31 09:44:01', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(228, 70, 0, 'test 16', '1', '1', NULL, NULL, NULL, 2, 2, '2025-01-03', '2025-01-05', '1', '1', '36', '133', NULL, NULL, NULL, 4, 4, NULL, NULL, NULL, NULL, 1810.00, 1810.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\"}]}', '', 0.00, 0.00, 1000.00, '', '3', '2024-12-31 09:44:32', '2025-01-03 11:52:56', 0.00, 0.00, 13880.00, 0.00, 13880.00, NULL, NULL),
(229, 71, 0, 'test 18.1', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2700.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-31 10:36:32', '2024-12-31 10:36:35', 0.00, 5000.00, 0.00, 0.00, 0.00, NULL, NULL),
(230, 71, 0, 'test 18.1', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, NULL, 2, 5, NULL, NULL, NULL, NULL, 2700.00, 4814.29, 0.00, 3714.29, 0.00, 4264.29, 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-31 10:37:31', '2025-01-01 04:22:12', 1400.00, 5000.00, 32050.00, 100.00, 32150.00, NULL, NULL),
(231, 71, 0, 'test 18.2', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '8', NULL, NULL, NULL, 6, 12, NULL, NULL, NULL, NULL, 2700.00, 5802.78, 0.00, 5077.78, 0.00, 5177.78, 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/lglfgMXr3OTXTunyHgjqQRvg3VPpIIQSfZGaYt10.jpg\"}},{\"insert\":\"\\n\"}]}', 1000.00, 2000.00, 3000.00, '', '3', '2024-12-31 10:38:11', '2025-01-02 08:33:13', 1825.00, 5000.00, 5138900.00, 0.00, 5138900.00, NULL, NULL),
(232, 70, 0, 'test 16 package one', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '133', NULL, NULL, NULL, 2, 4, NULL, NULL, NULL, NULL, 1810.00, 1810.00, 0.00, 1410.00, 0.00, 1410.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-31 11:40:26', '2024-12-31 11:41:57', 0.00, 0.00, 7240.00, 0.00, 0.00, NULL, NULL),
(233, 72, 0, '2days test 16', '0', '0', NULL, NULL, NULL, 3, 3, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2475.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-31 12:10:22', '2024-12-31 12:10:27', 0.00, 7500.00, 0.00, 0.00, 0.00, NULL, NULL),
(234, 72, 0, '2days test 16', '1', '1', NULL, NULL, NULL, 3, 3, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, 3, 5, NULL, NULL, NULL, NULL, 2575.00, 8512.50, 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-31 12:10:54', '2025-01-02 11:28:41', 5000.00, 7500.00, 51270.00, 0.00, 51270.00, NULL, NULL),
(235, 73, 0, 'test 20', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1600.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', '2025-01-01 06:42:32', '2025-01-01 06:42:36', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(236, 73, 0, 'test 20', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '18', '33', NULL, NULL, NULL, 1, 2, NULL, NULL, NULL, NULL, 1600.00, 4600.78, 0.00, 3380.00, 0.00, 3380.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\"}]}', '', 3000.78, 2000.00, 1345.78, '', '3', '2025-01-01 06:43:04', '2025-01-01 07:07:36', 0.00, 0.00, 9201.56, 0.00, 9201.56, NULL, NULL),
(237, 68, 0, '2 days  test 1.56 new enquiry', '3', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2500.00, 4000.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', '2025-01-01 13:05:21', '2025-01-01 13:20:59', 500.00, 3000.00, 12000.00, 0.00, 0.00, NULL, NULL),
(238, 74, 0, '2days test 19', '0', '0', NULL, NULL, NULL, 2, 2, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 3050.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', '2025-01-02 04:22:25', '2025-01-02 04:23:13', 0.00, 6000.00, 0.00, 0.00, 0.00, NULL, NULL),
(239, 74, 0, '2days test 19', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, 3, 5, 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\"}]}', NULL, 0.00, 0.00, 0.00, NULL, '1', '2025-01-02 04:25:58', '2025-01-02 04:25:58', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(240, 74, 0, '2days test 19', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, 4, 8, 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\"}]}', NULL, 0.00, 0.00, 0.00, NULL, '1', '2025-01-02 04:47:50', '2025-01-02 04:47:50', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(241, 74, 0, '2days test 19', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, 5, 10, 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\"}]}', NULL, 0.00, 0.00, 0.00, NULL, '1', '2025-01-02 04:54:42', '2025-01-02 04:54:42', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(242, 74, 0, '2days test 19 one', '1', '1', NULL, NULL, NULL, 2, 2, NULL, NULL, '1', '1', '36', '7', NULL, NULL, NULL, 6, 12, 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\"}]}', NULL, 0.00, 0.00, 0.00, NULL, '1', '2025-01-02 05:39:32', '2025-01-02 05:39:32', 0.00, 0.00, 0.00, 0.00, 0.00, NULL, NULL),
(243, 74, 0, '2days test 19 one', '1', '1', NULL, NULL, NULL, 2, 2, '2025-01-02', '2025-01-04', '1', '1', '36', '7', NULL, NULL, NULL, 6, 12, NULL, NULL, NULL, NULL, 3050.00, 3383.33, 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', '2025-01-02 05:59:47', '2025-01-02 12:10:43', 0.00, 6000.00, 57900.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
(244, 68, 0, '2 days  test 1.56', '3', '0', NULL, NULL, NULL, 2, 2, '2025-01-10', '2025-01-12', '0', '0', NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, 2500.00, 3100.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, 2000.00, '', '1', '2025-01-02 06:53:20', '2025-01-10 13:43:36', 0.00, 3000.00, 17500.00, 0.00, 17500.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
(245, 12, 0, 'Kerala Hill Station and Backwaters', '3', '0', NULL, NULL, NULL, 4, 3, NULL, NULL, '1', '1', '39', '39', NULL, NULL, NULL, NULL, 2, NULL, NULL, NULL, NULL, 3065.00, 14065.00, 2000.00, 0.00, 0.00, 0.00, 0.00, '0', NULL, NULL, NULL, NULL, '{\"ops\":[{\"insert\":\"Airfare from Chennai\"},{\"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, 118656 characters]\"}},{\"insert\":\"\\n\"}]}', 0.00, 0.00, 0.00, '', '2', '2025-01-02 07:01:15', '2025-01-02 07:55:33', 6250.00, 9500.00, 28130.00, 0.00, 28130.00, NULL, NULL);
