Database Leaked - Makebookingsonline.com Sql © Chucky Credits

Chucky · Jun 12, 2023

Database Leaked makebookingsonline.com

INSERT INTO `vj_mbo_hbed_roomwise_service` (`id`, `rechecked`, `room_code`, `room_name`, `room_index`, `booking_option`, `room_rate_index`, `room_rate_key`, `room_rate_class`, `room_rate_type`, `room_unit_net_price`, `room_available`, `comment_id`, `payment_type`, `cancellation_policy`, `child_occupancy`, `adult_occupancy`, `promotions`, `offers`, `daily_rates`, `miscellaneous`, `inclusions`, `eligibile_room`, `vj_supplier_id`, `requirement_id`, `guest_children_age`, `rate_comment`, `added_on`, `have_breakfast`) VALUES

INSERT INTO `vj_mbo_booking_guest` (`id`, `booking_id`, `itineary_id`, `room_id`, `guest_type`, `primary_guest`, `salutation`, `name`, `surname`, `created_at`, `updated_at`, `child_age`, `deleted`, `dob`, `address`, `country`, `language`, `email`, `phone`, `mobile`, `nationality`, `passport`, `passport_expiry`, `passport_issue_date`, `product_id`, `note_for_operator`, `note_for_passenger`, `flight_no`, `gender`, `title`, `covid_document`) VALUES

INSERT INTO `vj_email_log` (`id`, `mail_from`, `mail_to`, `cc`, `bcc`, `itinerary_id`, `type`, `itinerary_service_id`, `supplier_id`, `agent_id`, `agent_user_id`, `attachment`, `subject`, `mail_body`, `additional_info`, `sent_on`, `sent_by`, `status`) VALUES

Format - .SQL
Size sql file - 3.5GB
Date - 2023
All Rows - 2.5kk
Website - makebookingsonline.com

HTML:

(1099479, 0, 'DBL.KG', 'Superior Room King-Size Bed', 0, 1, 0, '20230604|20230605|W|283|124059|DBL.KG|ID_B2B_20|RO|RA1B2BHB|1~2~0||N@06~A-SIC~200d1~-1336988513~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807246b8', 'NOR', 'RECHECK', '184.70', 7, '', 'AT_WEB', '[{\"amount\":\"184.70\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"184.70\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099480, 0, 'DBL.KG', 'Superior Room King-Size Bed', 0, 2, 1, '20230604|20230605|W|283|124059|DBL.KG|ID_B2B_20|BB|RA1BB2BHB|1~2~0||N@06~A-SIC~200103~-262256333~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807258e4', 'NOR', 'RECHECK', '228.88', 7, '', 'AT_WEB', '[{\"amount\":\"228.88\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"228.88\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099481, 0, 'DBL.2D-SU', 'Superior Room 2 Queen Beds', 1, 3, 0, '20230604|20230605|W|283|124059|DBL.2D-SU|ID_B2B_20|RO|RA1B2BHB|1~2~0||N@06~A-SIC~200db~430041241~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807235c1', 'NOR', 'RECHECK', '193.53', 7, '', 'AT_WEB', '[{\"amount\":\"193.53\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"193.53\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099482, 0, 'DBL.2D-SU', 'Superior Room 2 Queen Beds', 1, 4, 1, '20230604|20230605|W|283|124059|DBL.2D-SU|ID_B2B_20|BB|RA1BB2BHB|1~2~0||N@06~A-SIC~20010d~824199366~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807248ed', 'NOR', 'RECHECK', '237.72', 7, '', 'AT_WEB', '[{\"amount\":\"237.72\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"237.72\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099483, 0, 'DBL.EJ-KG', 'Executive Room King Bed', 2, 5, 0, '20230604|20230605|W|283|124059|DBL.EJ-KG|ID_B2B_20|RO|RA1B2BHB|1~2~0||N@06~A-SIC~200ef~-325164762~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807215d3', 'NOR', 'RECHECK', '211.21', 7, '', 'AT_WEB', '[{\"amount\":\"211.21\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"211.21\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099484, 0, 'DBL.EJ-KG', 'Executive Room King Bed', 2, 6, 1, '20230604|20230605|W|283|124059|DBL.EJ-KG|ID_B2B_20|BB|RA1BB2BHB|1~2~0||N@06~A-SIC~200121~-1384984197~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807228ff', 'NOR', 'RECHECK', '255.40', 7, '', 'AT_WEB', '[{\"amount\":\"255.40\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"255.40\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099485, 0, 'DBL.KG-SU', 'Superior King', 0, 1, 0, '20230604|20230605|W|283|86997|DBL.KG-SU|ID_B2B_44|RO|B2BPAQNRF|1~2~0||P@06~A-SIC~223b9~-1722664078~N~~~NRF~CEABF044D44C412168570721486404AANZ00000210019000807223b9', 'NRF', 'RECHECK', '185.35', 30, '', 'AT_WEB', '[{\"amount\":\"185.35\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[{\"code\":\"073\",\"name\":\"Non-refundable rate. No amendments permitted\"}]', '[]', '[{\"offset\":1,\"dailyNet\":\"185.35\"}]', '{\"packaging\":true,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099486, 0, 'DBL.KG-SU', 'Superior King', 0, 2, 1, '20230604|20230605|W|283|86997|DBL.KG-SU|ID_B2B_44|RO|B2B2C|1~2~0||N@06~A-SIC~252bd~-1382375102~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807252bd', 'NOR', 'RECHECK', '189.82', 30, '', 'AT_WEB', '[{\"amount\":\"189.82\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"189.82\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099487, 0, 'DBL.KG-SU', 'Superior King', 0, 3, 2, '20230604|20230605|W|283|86997|DBL.KG-SU|BAR-ALL1|RO||1~2~0||P@06~A-SIC~205d0~362509631~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807243c2', 'NOR', 'BOOKABLE', '194.67', 4, '', 'AT_WEB', '[{\"amount\":\"194.67\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[{\"code\":\"9005\",\"name\":\"Exclusive discount\",\"amount\":\"-10.25\"}]', '[{\"offset\":1,\"dailyNet\":\"194.67\"}]', '{\"packaging\":true,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099488, 0, 'DBL.KG-SU', 'Superior King', 0, 4, 3, '20230604|20230605|W|283|86997|DBL.KG-SU|ID_B2B_44|DB|B2B2C|1~2~0||N@06~A-SIC~22a101~-268179925~N~~~NOR~CEABF044D44C412168570721486404AANZ0000021001900080722a101', 'NOR', 'RECHECK', '257.42', 30, '', 'AT_WEB', '[{\"amount\":\"257.42\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"257.42\"}]', '{\"packaging\":false,\"boardCode\":\"DB\",\"boardName\":\"BUFFET BREAKFAST\"}', '{\"boardName\":\"BUFFET BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099489, 0, 'DBL.KG-SU', 'Superior King', 0, 5, 4, '20230604|20230605|W|283|86997|DBL.KG-SU|BAR-ALL-BB|BB||1~2~0||P@06~A-SIC~20f11a~-739849268~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807201108', 'NOR', 'BOOKABLE', '264.01', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"264.01\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[{\"code\":\"9005\",\"name\":\"Exclusive discount\",\"amount\":\"-13.89\"}]', '[{\"offset\":1,\"dailyNet\":\"264.01\"}]', '{\"packaging\":true,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099490, 0, 'DBL.KG-SU', 'Superior King', 0, 6, 5, '20230604|20230605|W|283|86997|DBL.KG-SU|BAR-ALL-BB|BB||1~2~0||N@06~A-SIC~200129~-651253902~N~~~NOR~CEABF044D44C412168570721486404AANZ0000021001900080725a115', 'NOR', 'BOOKABLE', '277.90', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"277.90\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"277.90\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099491, 0, 'ROO.RO-2', 'Room RUN OF HOUSE', 1, 7, 0, '20230604|20230605|W|283|86997|ROO.RO-2|ID_B2B_44|RO|B2BPAQNRF|1~2~0||P@06~A-SIC~223b9~-478185125~N~~~NRF~CEABF044D44C412168570721486404AANZ00000210019000807223b9', 'NRF', 'RECHECK', '185.35', 30, '', 'AT_WEB', '[{\"amount\":\"185.35\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[{\"code\":\"073\",\"name\":\"Non-refundable rate. No amendments permitted\"}]', '[]', '[{\"offset\":1,\"dailyNet\":\"185.35\"}]', '{\"packaging\":true,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099492, 0, 'ROO.RO-2', 'Room RUN OF HOUSE', 1, 8, 1, '20230604|20230605|W|283|86997|ROO.RO-2|ID_B2B_44|RO|B2B2C|1~2~0||N@06~A-SIC~252bd~-388154453~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807252bd', 'NOR', 'RECHECK', '189.82', 30, '', 'AT_WEB', '[{\"amount\":\"189.82\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"189.82\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099493, 0, 'TWN.SU', 'Superior 2 King Singles', 2, 9, 0, '20230604|20230605|W|283|86997|TWN.SU|BAR-ALL1|RO||1~2~0||P@06~A-SIC~205d0~-395331231~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807243c2', 'NOR', 'BOOKABLE', '194.67', 4, '', 'AT_WEB', '[{\"amount\":\"194.67\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[{\"code\":\"9005\",\"name\":\"Exclusive discount\",\"amount\":\"-10.25\"}]', '[{\"offset\":1,\"dailyNet\":\"194.67\"}]', '{\"packaging\":true,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099494, 0, 'TWN.SU', 'Superior 2 King Singles', 2, 10, 1, '20230604|20230605|W|283|86997|TWN.SU|BAR-ALL1|RO||1~2~0||N@06~A-SIC~200db~-1069519856~N~~~NOR~CEABF044D44C412168570721486404AANZ0000021001900080725ccc', 'NOR', 'BOOKABLE', '204.92', 4, '', 'AT_WEB', '[{\"amount\":\"204.92\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"204.92\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099495, 0, 'TWN.SU', 'Superior 2 King Singles', 2, 11, 2, '20230604|20230605|W|283|86997|TWN.SU|BAR-ALL-BB|BB||1~2~0||P@06~A-SIC~20f11a~-589811986~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807201108', 'NOR', 'BOOKABLE', '264.01', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"264.01\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[{\"code\":\"9005\",\"name\":\"Exclusive discount\",\"amount\":\"-13.89\"}]', '[{\"offset\":1,\"dailyNet\":\"264.01\"}]', '{\"packaging\":true,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099496, 0, 'TWN.SU', 'Superior 2 King Singles', 2, 12, 3, '20230604|20230605|W|283|86997|TWN.SU|BAR-ALL-BB|BB||1~2~0||N@06~A-SIC~200129~-501216620~N~~~NOR~CEABF044D44C412168570721486404AANZ0000021001900080725a115', 'NOR', 'BOOKABLE', '277.90', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"277.90\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"277.90\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099497, 0, 'DBL.DX', 'Deluxe King', 3, 13, 0, '20230604|20230605|W|283|86997|DBL.DX|ID_B2B_44|RO|B2BPAQ|1~2~0||P@06~A-SIC~249d2~-653945526~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807249d2', 'NOR', 'RECHECK', '210.73', 30, '', 'AT_WEB', '[]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"210.73\"}]', '{\"packaging\":true,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099498, 0, 'DBL.DX', 'Deluxe King', 3, 14, 1, '20230604|20230605|W|283|86997|DBL.DX|ID_B2B_44|RO|B2B2C|1~2~0||N@06~A-SIC~251d7~613030645~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807251d7', 'NOR', 'RECHECK', '215.81', 30, '', 'AT_WEB', '[{\"amount\":\"215.81\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"215.81\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099499, 0, 'DBL.DX', 'Deluxe King', 3, 15, 2, '20230604|20230605|W|283|86997|DBL.DX|BAR-ALL-BB|BB||1~2~0||P@06~A-SIC~241136~-1646755155~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807243122', 'NOR', 'BOOKABLE', '290.67', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"290.67\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[{\"code\":\"9005\",\"name\":\"Exclusive discount\",\"amount\":\"-15.30\"}]', '[{\"offset\":1,\"dailyNet\":\"290.67\"}]', '{\"packaging\":true,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099500, 0, 'DBL.DX', 'Deluxe King', 3, 16, 3, '20230604|20230605|W|283|86997|DBL.DX|BAR-ALL-BB|BB||1~2~0||N@06~A-SIC~200147~-1352789644~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807261131', 'NOR', 'BOOKABLE', '305.97', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"305.97\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"305.97\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),


(15390, 5053, '', 'Fuel', 'EXCLUSION', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15391, 5053, '', 'Optional extras', 'EXCLUSION', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15392, 5053, '', 'Credit Card Surcharge', 'EXCLUSION', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15393, 5053, '', 'Road Tolls, Infringements, Parking Charges', 'EXCLUSION', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15394, 5053, '', 'If a customer returns a vehicle early no refunds will be given on unused days.', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15395, 5053, '', 'If a Customer wish to extend a rental once the vehicle has been collected, this is permitted and will be charged to the customer/renter direct at counter at the applicable daily rate.', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15396, 5053, '', 'Minimum 18 years old. No maximum age limit providing the client is still carrying a valid and full license.', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15397, 5053, '', 'IT IS ADVISABLE FOR EVERYONE TO USE SNOW CHAINS FROM THE MONTH OF JUNE TO SEPTEMBER IN SOUTH ISLAND', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15398, 5053, '', 'On Self-drive, the client will need to carry a valid credit card for bond and extras to pick up the rental car.', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15399, 5053, '', 'Credit cards MUST be under the name of the customer. Any third person credit Â card will not be accepted. Customer\'s name MUST be printed on the credit card.', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15400, 5053, '', 'Clients will need to carry a valid credit card with enough funds for bond (Cash bond will not be acceptable by rental car company), also need to carry valid full driving licence (should be in clear English).', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15401, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'CheckIn Time: 14:00', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15402, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', ' CheckOut Time: 10:00', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15403, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'All children are welcome. 4 children under 3 years stay free of charge when using existing beds.There is no capacity for extra beds in the room.The maximum number of total guests in a room is 6.There is no capacity for cots in the room.', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15404, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'WiFi is available in all areas and charges are applicable. ', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15405, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'No parking available. ', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15406, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'Pets are not allowed. ', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15407, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'The property reserves the right to pre-authorise credit cards prior to arrival.', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15408, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'Important Information : Guests are required to show a photo identification and credit card upon check-in. Please note that all Special Requests are subject to availability and additional charges may apply. This property will not accommodate hen, stag or similar parties. A damage deposit of NZD 200 is required on arrival. This will be collected by credit card. You should be reimbursed on check-out. Your deposit will be refunded in full via credit card, subject to an inspection of the property. Please not that this property is not wheelchair accessible. Guests with wheelchairs may find it difficult to maneuver within the complex and the apartments. Please note that there is a 2% charge when you pay with a credit card. Reception will request $200 security deposit. Guests aged 0-17 can only check in with a parent or official guardian. The legal guardian must provide a current photo ID or proof and guardianship if requested upon check-in. Please note that the property is accessible via 10 steps. Please note that when booking more than 3 rooms, different policies and additional supplements may apply. If you come for self isolation, please do not book the shared room/apartment. You\'ll have to book the whole apartment. Otherwise you will not be able to check in due to the health and safety issue. All guests must present vaccine pass. Reception closes at 9pm. After-hour check-in is not available.', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15409, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'Early check out will attract full cancellation charge unless otherwise specified', 'DefaultPolicy', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15410, 5055, 'room_1', 'Room only', 'aInclusion', 'HBED', '2022-09-15 05:41:33', 2512, NULL),
(15411, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'CheckIn Time-Begin: 3:00 PM ', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15412, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', ' CheckIn Time-End: anytime', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15413, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'CheckOut Time: 11:00 AM', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15414, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'CheckIn Instructions: &amp;lt;ul&amp;gt;  &amp;lt;li&amp;gt;Extra-person charges may apply and vary depending on property policy&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;This property accepts credit cards, debit cards, and cash&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Safety features at this property include a smoke detector&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Be prepared: check the latest COVID-19 travel requirements and measures in place for this destination before you travel.&amp;lt;/li&amp;gt;  &amp;lt;/ul&amp;gt; ', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15415, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', ' Special Instructions : Front desk staff will greet guests on arrival.', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15416, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'Minimum CheckIn Age : 18', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15417, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', ' Optional Fees: &amp;lt;ul&amp;gt; &amp;lt;li&amp;gt;Breakfast fee: between NZD 35 and NZD 35 for adults, NZD 19 and NZD 19 for children (approximately)&amp;lt;/li&amp;gt;       &amp;lt;li&amp;gt;Covered self parking fee: NZD 35 per day&amp;lt;/li&amp;gt; &amp;lt;li&amp;gt;Covered valet parking fee: NZD 55.00 per night (in/out privileges)&amp;lt;/li&amp;gt;          &amp;lt;li&amp;gt;Rollaway bed fee: NZD 40 per night&amp;lt;/li&amp;gt;          &amp;lt;li&amp;gt;Credit card charges are subject to a surcharge of 2.5 percent &amp;lt;/li&amp;gt;  &amp;lt;/ul&amp;gt; &amp;lt;p&amp;gt;The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change. &amp;lt;/p&amp;gt;', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15418, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'Cards Accepted: Visa,Debit cards,American Express,Cash,Mastercard,UnionPay', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15419, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', '&amp;lt;ul&amp;gt;  &amp;lt;li&amp;gt;The property has connecting/adjoining rooms, which are subject to availability and can be requested by contact @fbi_gov ing the property using the number on the booking confirmation. &amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;This property advises that enhanced cleaning and guest safety measures are currently in place.&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Disinfectant is used to clean the property; commonly-touched surfaces are cleaned with disinfectant between stays; bed sheets and towels are laundered at a temperature of at least 60Â°C/140Â°F.&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Social distancing measures are in place and guests are provided with hand sanitizer.&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt; This property welcomes guests of all sexual orientations and gender identities (LGBTQ friendly). &amp;lt;/li&amp;gt; &amp;lt;/ul&amp;gt;,Pets not allowed,Property does not require health documentation at check-in,LGBTQ friendly,Property confirms they are implementing guest safety measures,Social distancing measures are in place,Property is cleaned with disinfectant,Guests are provided with free hand sanitizer,Property confirms they are implementing enhanced cleaning measures,Bed sheets and towels are washed at a temperature of at least 60Â°C/140Â°F,Essential workers only - NO,Commonly-touched surfaces are cleaned with disinfectant,Qualmark Sustainable Tourism Business Award', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15420, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'Please refer to the following Terms of Use - http://mytravelagent.online/termsofuse.pdf', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15421, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'Early check out will attract full cancellation charge unless otherwise specified', 'DefaultPolicy', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15422, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'Hotel Destination Local Date and Time:04-Oct-2022 , 21:30:00', 'AutoCancellationText', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15423, 5059, 'room_1', 'Continental breakfast', 'aInclusion', 'HBED', '2022-09-15 20:46:07', 2745, NULL),

(4043, 8787, NULL, 1, 'Adult', 0, 'Mr', 'Vedant Hemant', 'Bajaj', '2023-02-14 04:37:53', '2023-02-14 04:37:53', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4044, 8787, NULL, 1, 'Adult', 0, 'Ms', 'Shivangi', 'Gupta', '2023-02-14 04:37:53', '2023-02-14 04:37:53', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4045, 8790, NULL, 1, 'Adult', 0, 'Mr', 'Vishesh', 'Kedia', '2023-02-14 21:17:25', '2023-02-14 21:17:25', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4046, 8792, NULL, 1, 'Adult', 0, 'Mr', 'NITISH', 'GUPTA', '2023-02-14 23:07:15', '2023-02-14 23:07:15', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4047, 8794, NULL, 1, 'Adult', 0, 'Mr', 'JITENDRA', 'JAIN', '2023-02-14 23:11:59', '2023-02-14 23:11:59', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4048, 8795, NULL, 1, 'Adult', 0, 'Mr', 'JITENDRA', 'JAIN', '2023-02-14 23:15:39', '2023-02-14 23:15:39', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4049, 8798, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 00:15:19', '2023-02-15 00:15:19', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 9295, NULL, NULL, NULL, NULL, NULL, NULL),
(4050, 8799, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 00:26:31', '2023-02-15 00:26:31', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 384, NULL, NULL, NULL, NULL, NULL, NULL),
(4051, 8800, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 00:32:18', '2023-02-15 00:32:18', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 9306, NULL, NULL, NULL, NULL, NULL, NULL),
(4052, 8801, NULL, 1, 'Adult', 0, 'Mrs', 'PARIDHI', 'AGRAWAL', '2023-02-15 00:55:12', '2023-02-26 14:18:38', 0, 0, NULL, NULL, NULL, NULL, 'tailormadetandt@gmail.com', '+918286010060', NULL, NULL, NULL, NULL, NULL, 9908, NULL, NULL, NULL, NULL, NULL, NULL),
(4053, 8802, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 00:55:30', '2023-02-15 00:55:30', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 432, NULL, NULL, NULL, NULL, NULL, NULL),
(4054, 8803, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 01:03:29', '2023-02-15 01:03:29', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 699, NULL, NULL, NULL, NULL, NULL, NULL),
(4055, 8804, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 01:58:39', '2023-02-15 01:58:39', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 18186, NULL, NULL, NULL, NULL, NULL, NULL),
(4056, 8806, NULL, 1, 'Adult', 0, 'Mr', 'Rahul', 'aggarwal', '2023-02-15 12:36:14', '2023-02-15 12:36:14', 0, 0, NULL, NULL, NULL, NULL, 'arg.rahul@gmail.com', '0220382451', NULL, NULL, NULL, NULL, NULL, 373, NULL, NULL, NULL, NULL, NULL, NULL),
(4057, 8809, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:44:26', '2023-02-15 21:44:26', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4058, 8810, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:44:42', '2023-02-15 21:44:42', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 9306, NULL, NULL, NULL, NULL, NULL, NULL),
(4059, 8811, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:44:57', '2023-02-15 21:44:57', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 264083, NULL, NULL, NULL, NULL, NULL, NULL),
(4060, 8812, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:45:13', '2023-02-15 21:45:13', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 18582, NULL, NULL, NULL, NULL, NULL, NULL),
(4061, 8813, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:45:26', '2023-02-15 21:45:26', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 1176, NULL, NULL, NULL, NULL, NULL, NULL),
(4062, 8814, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:45:44', '2023-02-15 21:45:44', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 2598, NULL, NULL, NULL, NULL, NULL, NULL),
(4063, 8815, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:46:02', '2023-02-15 21:46:02', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 2135, NULL, NULL, NULL, NULL, NULL, NULL),
(4064, 8816, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:46:22', '2023-02-15 21:46:22', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 900, NULL, NULL, NULL, NULL, NULL, NULL),
(4065, 8817, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:46:36', '2023-02-15 21:46:36', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 394, NULL, NULL, NULL, NULL, NULL, NULL),
(4066, 8818, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:46:58', '2023-02-15 21:46:58', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 440, NULL, NULL, NULL, NULL, NULL, NULL),
(4067, 8819, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:47:40', '2023-02-15 21:47:40', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 2303, NULL, NULL, NULL, NULL, NULL, NULL),
(4068, 8820, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:48:03', '2023-02-15 21:48:03', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 2309, NULL, NULL, NULL, NULL, NULL, NULL),



(2014, 'mail@vyomjourneys.co.nz', 'enquiries@fullers.co.nz', 'mail@vyomjourneys.co.nz', NULL, 4071, 'REJECTION_MESSAGE_SUPPLIER', 0, 452, 0, 0, '', 'REJECT CONFIRMATION FOR MR SANJAY PODDAR X 4 -FAMILY-27SEP', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Fullers Auckland,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys confirm the reject of the services listed below .</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4071 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Rejection Request for Waiheke Explorer Hop-on-hop-off Tour (Return Ferry Tickets Included)</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72630</td>\r\n                            <td  style=\"      font-size: 15px !important;\"></td>\r\n                            <td  style=\"      font-size: 15px !important;\">28 Sep, 2022  @09:45 AM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">28 Sep, 2022 </td>\r\n                            <td  style=\"      font-size: 15px !important;\">0</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Pranali  Desai<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : mail@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"4071\",\"supplier_id\":\"452\",\"aItineraryServiceID\":[\"122970\"],\"type\":\"REJECTION_MESSAGE_SUPPLIER\",\"is_group\":false}', '2022-09-18 08:35:44', NULL, 'SUCCESS'),
(2015, 'info@vyomjourneys.co.nz', 'mail@vyomjourneys.co.nz', '', NULL, 4071, 'SEND_CONFIRMATION_MAIL_TO_OPS_USER', 0, 803, 0, 0, '', 'BOOKING CONFIRMED - Christchurch Tram ', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Pranali  Desai,</span>\r\n                          <br>\r\n                         <p >Your Requested service is confirmed by Christchurch Tram confirmed services are listed below.</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4071 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Confirmed Request for Christchurch Tram City Tour</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72625</td>\r\n                            <td  style=\"      font-size: 15px !important;\">CH049392</td>\r\n                            <td  style=\"      font-size: 15px !important;\">09 Oct, 2022  @09:00 AM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">09 Oct, 2022 </td>\r\n                            <td  style=\"      font-size: 15px !important;\">4</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/create?itinid=4071&action=view&tsection=booking\" target=\"_blank\">view itinerary booking</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Vyom Journeys Ltd.<br/>192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>Email : info@vyomjourneys.co.nz<br/>Web : http://www.vyomjourneys.co.nz<br/>Pranali  Desai<br/></td></tr></table>', '{\"itinerary_id\":\"4071\",\"supplier_id\":\"803\",\"type\":\"SEND_CONFIRMATION_MAIL_TO_OPS_USER\",\"is_group\":false}', '2022-09-18 21:39:53', NULL, 'SUCCESS'),
(2016, 'info@vyomjourneys.co.nz', 'mail@vyomjourneys.co.nz', '', NULL, 4071, 'SEND_CONFIRMATION_MAIL_TO_OPS_USER', 0, 1219, 0, 0, '', 'BOOKING CONFIRMED - Redwood Treewalk ', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Pranali  Desai,</span>\r\n                          <br>\r\n                         <p >Your Requested service is confirmed by Redwood Treewalk confirmed services are listed below.</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4071 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Confirmed Request for Redwood Nightlights from dusk till late</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72612</td>\r\n                            <td  style=\"      font-size: 15px !important;\">19092022a</td>\r\n                            <td  style=\"      font-size: 15px !important;\">29 Sep, 2022  @06:00 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">29 Sep, 2022  @11:00 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">4</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/create?itinid=4071&action=view&tsection=booking\" target=\"_blank\">view itinerary booking</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Vyom Journeys Ltd.<br/>192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>Email : info@vyomjourneys.co.nz<br/>Web : http://www.vyomjourneys.co.nz<br/>Pranali  Desai<br/></td></tr></table>', '{\"itinerary_id\":\"4071\",\"supplier_id\":\"1219\",\"type\":\"SEND_CONFIRMATION_MAIL_TO_OPS_USER\",\"is_group\":false}', '2022-09-18 22:48:40', NULL, 'SUCCESS'),
(2017, 'info@vyomjourneys.co.nz', 'mail@vyomjourneys.co.nz', '', NULL, 4071, 'SEND_CONFIRMATION_MAIL_TO_OPS_USER', 0, 215, 0, 0, '', 'BOOKING CONFIRMED - Tamaki Maori Village, Rotorua ', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Pranali  Desai,</span>\r\n                          <br>\r\n                         <p >Your Requested service is confirmed by Tamaki Maori Village, Rotorua confirmed services are listed below.</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4071 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Confirmed Request for Tamaki Maori Village Experience (Incl: 3.5 hr Maori Cultural Experience + Buffet dinner feast)</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72615</td>\r\n                            <td  style=\"      font-size: 15px !important;\">TPT002725</td>\r\n                            <td  style=\"      font-size: 15px !important;\">30 Sep, 2022  @05:00 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">30 Sep, 2022  @08:00 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">4</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/create?itinid=4071&action=view&tsection=booking\" target=\"_blank\">view itinerary booking</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Vyom Journeys Ltd.<br/>192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>Email : info@vyomjourneys.co.nz<br/>Web : http://www.vyomjourneys.co.nz<br/>Pranali  Desai<br/></td></tr></table>', '{\"itinerary_id\":\"4071\",\"supplier_id\":\"215\",\"type\":\"SEND_CONFIRMATION_MAIL_TO_OPS_USER\",\"is_group\":false}', '2022-09-18 22:54:37', NULL, 'SUCCESS'),
(2018, 'info@vyomjourneys.co.nz', 'mail@vyomjourneys.co.nz', '', NULL, 4071, 'SEND_CONFIRMATION_MAIL_TO_OPS_USER', 0, 70, 0, 0, '', 'BOOKING CONFIRMED - Canterbury Leisure Tours ', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Pranali  Desai,</span>\r\n                          <br>\r\n                         <p >Your Requested service is confirmed by Canterbury Leisure Tours confirmed services are listed below.</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4071 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Confirmed Request for Kaikoura Whale Watch tour CLT08</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72624</td>\r\n                            <td  style=\"      font-size: 15px !important;\">LT08081022</td>\r\n                            <td  style=\"      font-size: 15px !important;\">08 Oct, 2022  @07:30 AM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">08 Oct, 2022  @05:30 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">4</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/create?itinid=4071&action=view&tsection=booking\" target=\"_blank\">view itinerary booking</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Vyom Journeys Ltd.<br/>192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>Email : info@vyomjourneys.co.nz<br/>Web : http://www.vyomjourneys.co.nz<br/>Pranali  Desai<br/></td></tr></table>', '{\"itinerary_id\":\"4071\",\"supplier_id\":\"70\",\"type\":\"SEND_CONFIRMATION_MAIL_TO_OPS_USER\",\"is_group\":false}', '2022-09-18 23:15:07', NULL, 'SUCCESS'),
(2019, 'mail@vyomjourneys.co.nz', 'reservations_rydgesrotorua@evt.com', 'mail@vyomjourneys.co.nz', NULL, 4067, 'CANCELLATION_MESSAGE_SUPPLIER', 0, 31, 0, 0, '', ' CANCELLATION REQUEST FOR SMALL GROUP PRIVATE TOUR OF NZD- BOOKING', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Rydges Rotorua,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys want cancelled of the services listed below .</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4067 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Cancellation Request for Standard Room- Asian Group BB Rates</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Check-In</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Check-Out</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72538</td>\r\n                            <td  style=\"      font-size: 15px !important;\">ZN6</td>\r\n                            <td  style=\"      font-size: 15px !important;\">02 Feb, 2023  @03:00 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">04 Feb, 2023 </td>\r\n                            <td  style=\"      font-size: 15px !important;\">8</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Pranali  Desai<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : mail@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"4067\",\"supplier_id\":\"31\",\"aItineraryServiceID\":[\"122860\"],\"type\":\"CANCELLATION_MESSAGE_SUPPLIER\",\"is_group\":true}', '2022-09-19 13:07:00', NULL, 'SUCCESS'),
(2020, 'operations@vyomjourneys.co.nz', 'sales@kellytarltons.co.nz', 'operations@vyomjourneys.co.nz', NULL, 3658, 'CONFIRMATION_TIME_REQUEST_TO_SUPPLIER', 0, 87, 0, 0, '', ' BOOKING REQUEST FOR GROUP/TULIP HOLIDAYS/TANZ271022 / NZ UPDATED 22 JUNE', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Kelly Tarltons,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys request you to confirm services listed below . Kindly update the status by clicking on the link below.</p>  </td></tr><tr><td ><p> <span style=\"color:#1e546b\">Guest Details :Group/Tulip Holidays/TANZ271022 / NZ updated 22 June </span></p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :3658 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  >Booking Request for Kelly Tarltons Entry / Admission</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:40%;\"  >Booking Request Remark</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">62931</td>\r\n                            <td  style=\"      font-size: 15px !important;\">05 Nov, 2022  @04:00 PM<br></td>\r\n                            <td  style=\"      font-size: 15px !important;\">05 Nov, 2022 <br></td>\r\n                            <td  style=\"      font-size: 15px !important;\"><div>Paid : 39</div>\r\n                       <div>FOC : 2</div>\r\n                       </td>\r\n                            <td  style=\"      font-size: 15px !important;\">Please book 3.30 Pm Slot</td>\r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/status?itinid=3658&action=view&tsection=documenttab&supplier_id=87&booked_id=62931\" target=\"_blank\">Click To Update Status</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Avanti Patil<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : operations@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"3658\",\"supplier_id\":\"87\",\"aItineraryServiceID\":[\"106850\"],\"type\":\"CONFIRMATION_TIME_REQUEST_TO_SUPPLIER\",\"is_group\":true}', '2022-09-19 13:27:08', NULL, 'SUCCESS'),
(2021, 'operations@vyomjourneys.co.nz', 'skytower@skycity.co.nz', 'operations@vyomjourneys.co.nz', NULL, 3658, 'CONFIRMATION_TIME_REQUEST_TO_SUPPLIER', 0, 66, 0, 0, '', ' BOOKING REQUEST FOR GROUP/TULIP HOLIDAYS/TANZ271022 / NZ UPDATED 22 JUNE', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Sky Tower Auckland,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys request you to confirm services listed below . Kindly update the status by clicking on the link below.</p>  </td></tr><tr><td ><p> <span style=\"color:#1e546b\">Guest Details :Group/Tulip Holidays/TANZ271022 / NZ updated 22 June </span></p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :3658 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  >Booking Request for Total Tower Experience Pass</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:40%;\"  >Booking Request Remark</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">62932</td>\r\n                            <td  style=\"      font-size: 15px !important;\">06 Nov, 2022  @09:15 AM<br></td>\r\n                            <td  style=\"      font-size: 15px !important;\">06 Nov, 2022 <br></td>\r\n                            <td  style=\"      font-size: 15px !important;\"><div>Paid : 39</div>\r\n                       <div>FOC : 2</div>\r\n                       </td>\r\n                            <td  style=\"      font-size: 15px !important;\"></td>\r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/status?itinid=3658&action=view&tsection=documenttab&supplier_id=66&booked_id=62932\" target=\"_blank\">Click To Update Status</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Avanti Patil<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : operations@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"3658\",\"supplier_id\":\"66\",\"aItineraryServiceID\":[\"106851\"],\"type\":\"CONFIRMATION_TIME_REQUEST_TO_SUPPLIER\",\"is_group\":true}', '2022-09-19 13:27:13', NULL, 'SUCCESS'),
(2022, 'operations@vyomjourneys.co.nz', 'caveinfo@waitomo.com', 'operations@vyomjourneys.co.nz', NULL, 3658, 'CONFIRMATION_TIME_REQUEST_TO_SUPPLIER', 0, 55, 0, 0, '', ' BOOKING REQUEST FOR GROUP/TULIP HOLIDAYS/TANZ271022 / NZ UPDATED 22 JUNE', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Waitomo Caves,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys request you to confirm services listed below . Kindly update the status by clicking on the link below.</p>  </td></tr><tr><td ><p> <span style=\"color:#1e546b\">Guest Details :Group/Tulip Holidays/TANZ271022 / NZ updated 22 June </span></p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :3658 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  >Booking Request for Waitomo Glowworm Caves + Indian Buffet (Minimum 10 pax)</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:40%;\"  >Booking Request Remark</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">62935</td>\r\n                            <td  style=\"      font-size: 15px !important;\">05 Nov, 2022  @09:30 AM<br></td>\r\n                            <td  style=\"      font-size: 15px !important;\">05 Nov, 2022  @10:30 AM<br></td>\r\n                            <td  style=\"      font-size: 15px !important;\"><div>Paid : 39</div>\r\n                       <div>FOC : 2</div>\r\n                       </td>\r\n                            <td  style=\"      font-size: 15px !important;\"></td>\r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/status?itinid=3658&action=view&tsection=documenttab&supplier_id=55&booked_id=62935\" target=\"_blank\">Click To Update Status</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Avanti Patil<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : operations@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"3658\",\"supplier_id\":\"55\",\"aItineraryServiceID\":[\"106854\"],\"type\":\"CONFIRMATION_TIME_REQUEST_TO_SUPPLIER\",\"is_group\":true}', '2022-09-19 13:27:18', NULL, 'SUCCESS'),
(2023, 'operations@vyomjourneys.co.nz', 'queenstown.tourgroups@skyline.co.nz', 'operations@vyomjourneys.co.nz', NULL, 3658, 'CONFIRMATION_TIME_REQUEST_TO_SUPPLIER', 0, 59, 0, 0, '', ' BOOKING REQUEST FOR GROUP/TULIP HOLIDAYS/TANZ271022 / NZ UPDATED 22 JUNE', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Skyline Queenstown,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys request you to confirm services listed below . Kindly update the status by clicking on the link below.</p>  </td></tr><tr><td ><p> <span style=\"color:#1e546b\">Guest Details :Group/Tulip Holidays/TANZ271022 / NZ updated 22 June </span></p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :3658 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  >Booking Request for Gondola ride</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:40%;\"  >Booking Request Remark</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">62942</td>\r\n                            <td  style=\"      font-size: 15px !important;\">06 Nov, 2022  @06:30 PM<br></td>\r\n                            <td  style=\"      font-size: 15px !important;\">06 Nov, 2022 <br></td>\r\n                            <td  style=\"      font-size: 15px !important;\"><div>Paid : 39</div>\r\n                       <div>FOC : 2</div>\r\n                       </td>\r\n                            <td  style=\"      font-size: 15px !important;\">Book 06 pm Slot</td>\r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/status?itinid=3658&action=view&tsection=documenttab&supplier_id=59&booked_id=62942\" target=\"_blank\">Click To Update Status</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Avanti Patil<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : operations@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"3658\",\"supplier_id\":\"59\",\"aItineraryServiceID\":[\"106862\"],\"type\":\"CONFIRMATION_TIME_REQUEST_TO_SUPPLIER\",\"is_group\":true}', '2022-09-19 13:27:22', NULL, 'SUCCESS'),

DOWNLOAD LINK:
--------

Удалённый пользователь 3691 · Jun 12, 2023

thanks for the share chucky

nopbcvlq · Jun 13, 2023

oh yes thank you a lot !

drudown500 · Jun 13, 2023

very nice one thank you so much for this one. This is going to be so nice! Much appreciated.

gruquira · Jun 13, 2023

wonderful this is really great. awesome work.

hqrish · Jun 26, 2023

Chucky said:

[IMG width="454px"]https://www.makebookingsonline.com/assets/index-assets/images/blue-logo.png[/IMG]

Database Leaked makebookingsonline.com

Format - .SQL
Size sql file - 3.5GB
Date - 2023
All Rows - 2.5kk
Website - makebookingsonline.com

HTML:

(1099479, 0, 'DBL.KG', 'Superior Room King-Size Bed', 0, 1, 0, '20230604|20230605|W|283|124059|DBL.KG|ID_B2B_20|RO|RA1B2BHB|1~2~0||N@06~A-SIC~200d1~-1336988513~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807246b8', 'NOR', 'RECHECK', '184.70', 7, '', 'AT_WEB', '[{\"amount\":\"184.70\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"184.70\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099480, 0, 'DBL.KG', 'Superior Room King-Size Bed', 0, 2, 1, '20230604|20230605|W|283|124059|DBL.KG|ID_B2B_20|BB|RA1BB2BHB|1~2~0||N@06~A-SIC~200103~-262256333~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807258e4', 'NOR', 'RECHECK', '228.88', 7, '', 'AT_WEB', '[{\"amount\":\"228.88\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"228.88\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099481, 0, 'DBL.2D-SU', 'Superior Room 2 Queen Beds', 1, 3, 0, '20230604|20230605|W|283|124059|DBL.2D-SU|ID_B2B_20|RO|RA1B2BHB|1~2~0||N@06~A-SIC~200db~430041241~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807235c1', 'NOR', 'RECHECK', '193.53', 7, '', 'AT_WEB', '[{\"amount\":\"193.53\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"193.53\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099482, 0, 'DBL.2D-SU', 'Superior Room 2 Queen Beds', 1, 4, 1, '20230604|20230605|W|283|124059|DBL.2D-SU|ID_B2B_20|BB|RA1BB2BHB|1~2~0||N@06~A-SIC~20010d~824199366~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807248ed', 'NOR', 'RECHECK', '237.72', 7, '', 'AT_WEB', '[{\"amount\":\"237.72\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"237.72\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099483, 0, 'DBL.EJ-KG', 'Executive Room King Bed', 2, 5, 0, '20230604|20230605|W|283|124059|DBL.EJ-KG|ID_B2B_20|RO|RA1B2BHB|1~2~0||N@06~A-SIC~200ef~-325164762~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807215d3', 'NOR', 'RECHECK', '211.21', 7, '', 'AT_WEB', '[{\"amount\":\"211.21\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"211.21\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099484, 0, 'DBL.EJ-KG', 'Executive Room King Bed', 2, 6, 1, '20230604|20230605|W|283|124059|DBL.EJ-KG|ID_B2B_20|BB|RA1BB2BHB|1~2~0||N@06~A-SIC~200121~-1384984197~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807228ff', 'NOR', 'RECHECK', '255.40', 7, '', 'AT_WEB', '[{\"amount\":\"255.40\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"255.40\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 831, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099485, 0, 'DBL.KG-SU', 'Superior King', 0, 1, 0, '20230604|20230605|W|283|86997|DBL.KG-SU|ID_B2B_44|RO|B2BPAQNRF|1~2~0||P@06~A-SIC~223b9~-1722664078~N~~~NRF~CEABF044D44C412168570721486404AANZ00000210019000807223b9', 'NRF', 'RECHECK', '185.35', 30, '', 'AT_WEB', '[{\"amount\":\"185.35\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[{\"code\":\"073\",\"name\":\"Non-refundable rate. No amendments permitted\"}]', '[]', '[{\"offset\":1,\"dailyNet\":\"185.35\"}]', '{\"packaging\":true,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099486, 0, 'DBL.KG-SU', 'Superior King', 0, 2, 1, '20230604|20230605|W|283|86997|DBL.KG-SU|ID_B2B_44|RO|B2B2C|1~2~0||N@06~A-SIC~252bd~-1382375102~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807252bd', 'NOR', 'RECHECK', '189.82', 30, '', 'AT_WEB', '[{\"amount\":\"189.82\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"189.82\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099487, 0, 'DBL.KG-SU', 'Superior King', 0, 3, 2, '20230604|20230605|W|283|86997|DBL.KG-SU|BAR-ALL1|RO||1~2~0||P@06~A-SIC~205d0~362509631~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807243c2', 'NOR', 'BOOKABLE', '194.67', 4, '', 'AT_WEB', '[{\"amount\":\"194.67\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[{\"code\":\"9005\",\"name\":\"Exclusive discount\",\"amount\":\"-10.25\"}]', '[{\"offset\":1,\"dailyNet\":\"194.67\"}]', '{\"packaging\":true,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099488, 0, 'DBL.KG-SU', 'Superior King', 0, 4, 3, '20230604|20230605|W|283|86997|DBL.KG-SU|ID_B2B_44|DB|B2B2C|1~2~0||N@06~A-SIC~22a101~-268179925~N~~~NOR~CEABF044D44C412168570721486404AANZ0000021001900080722a101', 'NOR', 'RECHECK', '257.42', 30, '', 'AT_WEB', '[{\"amount\":\"257.42\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"257.42\"}]', '{\"packaging\":false,\"boardCode\":\"DB\",\"boardName\":\"BUFFET BREAKFAST\"}', '{\"boardName\":\"BUFFET BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099489, 0, 'DBL.KG-SU', 'Superior King', 0, 5, 4, '20230604|20230605|W|283|86997|DBL.KG-SU|BAR-ALL-BB|BB||1~2~0||P@06~A-SIC~20f11a~-739849268~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807201108', 'NOR', 'BOOKABLE', '264.01', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"264.01\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[{\"code\":\"9005\",\"name\":\"Exclusive discount\",\"amount\":\"-13.89\"}]', '[{\"offset\":1,\"dailyNet\":\"264.01\"}]', '{\"packaging\":true,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099490, 0, 'DBL.KG-SU', 'Superior King', 0, 6, 5, '20230604|20230605|W|283|86997|DBL.KG-SU|BAR-ALL-BB|BB||1~2~0||N@06~A-SIC~200129~-651253902~N~~~NOR~CEABF044D44C412168570721486404AANZ0000021001900080725a115', 'NOR', 'BOOKABLE', '277.90', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"277.90\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"277.90\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099491, 0, 'ROO.RO-2', 'Room RUN OF HOUSE', 1, 7, 0, '20230604|20230605|W|283|86997|ROO.RO-2|ID_B2B_44|RO|B2BPAQNRF|1~2~0||P@06~A-SIC~223b9~-478185125~N~~~NRF~CEABF044D44C412168570721486404AANZ00000210019000807223b9', 'NRF', 'RECHECK', '185.35', 30, '', 'AT_WEB', '[{\"amount\":\"185.35\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[{\"code\":\"073\",\"name\":\"Non-refundable rate. No amendments permitted\"}]', '[]', '[{\"offset\":1,\"dailyNet\":\"185.35\"}]', '{\"packaging\":true,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099492, 0, 'ROO.RO-2', 'Room RUN OF HOUSE', 1, 8, 1, '20230604|20230605|W|283|86997|ROO.RO-2|ID_B2B_44|RO|B2B2C|1~2~0||N@06~A-SIC~252bd~-388154453~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807252bd', 'NOR', 'RECHECK', '189.82', 30, '', 'AT_WEB', '[{\"amount\":\"189.82\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"189.82\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099493, 0, 'TWN.SU', 'Superior 2 King Singles', 2, 9, 0, '20230604|20230605|W|283|86997|TWN.SU|BAR-ALL1|RO||1~2~0||P@06~A-SIC~205d0~-395331231~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807243c2', 'NOR', 'BOOKABLE', '194.67', 4, '', 'AT_WEB', '[{\"amount\":\"194.67\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[{\"code\":\"9005\",\"name\":\"Exclusive discount\",\"amount\":\"-10.25\"}]', '[{\"offset\":1,\"dailyNet\":\"194.67\"}]', '{\"packaging\":true,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099494, 0, 'TWN.SU', 'Superior 2 King Singles', 2, 10, 1, '20230604|20230605|W|283|86997|TWN.SU|BAR-ALL1|RO||1~2~0||N@06~A-SIC~200db~-1069519856~N~~~NOR~CEABF044D44C412168570721486404AANZ0000021001900080725ccc', 'NOR', 'BOOKABLE', '204.92', 4, '', 'AT_WEB', '[{\"amount\":\"204.92\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"204.92\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099495, 0, 'TWN.SU', 'Superior 2 King Singles', 2, 11, 2, '20230604|20230605|W|283|86997|TWN.SU|BAR-ALL-BB|BB||1~2~0||P@06~A-SIC~20f11a~-589811986~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807201108', 'NOR', 'BOOKABLE', '264.01', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"264.01\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[{\"code\":\"9005\",\"name\":\"Exclusive discount\",\"amount\":\"-13.89\"}]', '[{\"offset\":1,\"dailyNet\":\"264.01\"}]', '{\"packaging\":true,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099496, 0, 'TWN.SU', 'Superior 2 King Singles', 2, 12, 3, '20230604|20230605|W|283|86997|TWN.SU|BAR-ALL-BB|BB||1~2~0||N@06~A-SIC~200129~-501216620~N~~~NOR~CEABF044D44C412168570721486404AANZ0000021001900080725a115', 'NOR', 'BOOKABLE', '277.90', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"277.90\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"277.90\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099497, 0, 'DBL.DX', 'Deluxe King', 3, 13, 0, '20230604|20230605|W|283|86997|DBL.DX|ID_B2B_44|RO|B2BPAQ|1~2~0||P@06~A-SIC~249d2~-653945526~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807249d2', 'NOR', 'RECHECK', '210.73', 30, '', 'AT_WEB', '[]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"210.73\"}]', '{\"packaging\":true,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099498, 0, 'DBL.DX', 'Deluxe King', 3, 14, 1, '20230604|20230605|W|283|86997|DBL.DX|ID_B2B_44|RO|B2B2C|1~2~0||N@06~A-SIC~251d7~613030645~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807251d7', 'NOR', 'RECHECK', '215.81', 30, '', 'AT_WEB', '[{\"amount\":\"215.81\",\"from\":\"2023-06-02T23:59:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"215.81\"}]', '{\"packaging\":false,\"boardCode\":\"RO\",\"boardName\":\"ROOM ONLY\"}', '{\"boardName\":\"ROOM ONLY\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 0),
(1099499, 0, 'DBL.DX', 'Deluxe King', 3, 15, 2, '20230604|20230605|W|283|86997|DBL.DX|BAR-ALL-BB|BB||1~2~0||P@06~A-SIC~241136~-1646755155~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807243122', 'NOR', 'BOOKABLE', '290.67', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"290.67\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[{\"code\":\"9005\",\"name\":\"Exclusive discount\",\"amount\":\"-15.30\"}]', '[{\"offset\":1,\"dailyNet\":\"290.67\"}]', '{\"packaging\":true,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),
(1099500, 0, 'DBL.DX', 'Deluxe King', 3, 16, 3, '20230604|20230605|W|283|86997|DBL.DX|BAR-ALL-BB|BB||1~2~0||N@06~A-SIC~200147~-1352789644~N~~~NOR~CEABF044D44C412168570721486404AANZ00000210019000807261131', 'NOR', 'BOOKABLE', '305.97', 4, '283|2995|0', 'AT_WEB', '[{\"amount\":\"305.97\",\"from\":\"2023-06-03T14:00:00+12:00\"}]', 0, 2, '[]', '[]', '[{\"offset\":1,\"dailyNet\":\"305.97\"}]', '{\"packaging\":false,\"boardCode\":\"BB\",\"boardName\":\"BED AND BREAKFAST\"}', '{\"boardName\":\"BED AND BREAKFAST\"}', '[1]', 1119, '859', NULL, NULL, '2023-06-03 00:00:15', 1),


(15390, 5053, '', 'Fuel', 'EXCLUSION', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15391, 5053, '', 'Optional extras', 'EXCLUSION', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15392, 5053, '', 'Credit Card Surcharge', 'EXCLUSION', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15393, 5053, '', 'Road Tolls, Infringements, Parking Charges', 'EXCLUSION', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15394, 5053, '', 'If a customer returns a vehicle early no refunds will be given on unused days.', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15395, 5053, '', 'If a Customer wish to extend a rental once the vehicle has been collected, this is permitted and will be charged to the customer/renter direct at counter at the applicable daily rate.', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15396, 5053, '', 'Minimum 18 years old. No maximum age limit providing the client is still carrying a valid and full license.', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15397, 5053, '', 'IT IS ADVISABLE FOR EVERYONE TO USE SNOW CHAINS FROM THE MONTH OF JUNE TO SEPTEMBER IN SOUTH ISLAND', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15398, 5053, '', 'On Self-drive, the client will need to carry a valid credit card for bond and extras to pick up the rental car.', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15399, 5053, '', 'Credit cards MUST be under the name of the customer. Any third person credit Â card will not be accepted. Customer\'s name MUST be printed on the credit card.', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15400, 5053, '', 'Clients will need to carry a valid credit card with enough funds for bond (Cash bond will not be acceptable by rental car company), also need to carry valid full driving licence (should be in clear English).', 'INFO_MESSAGE', 'HERTZ', '2022-09-15 04:40:56', 2512, NULL),
(15401, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'CheckIn Time: 14:00', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15402, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', ' CheckOut Time: 10:00', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15403, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'All children are welcome. 4 children under 3 years stay free of charge when using existing beds.There is no capacity for extra beds in the room.The maximum number of total guests in a room is 6.There is no capacity for cots in the room.', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15404, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'WiFi is available in all areas and charges are applicable. ', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15405, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'No parking available. ', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15406, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'Pets are not allowed. ', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15407, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'The property reserves the right to pre-authorise credit cards prior to arrival.', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15408, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'Important Information : Guests are required to show a photo identification and credit card upon check-in. Please note that all Special Requests are subject to availability and additional charges may apply. This property will not accommodate hen, stag or similar parties. A damage deposit of NZD 200 is required on arrival. This will be collected by credit card. You should be reimbursed on check-out. Your deposit will be refunded in full via credit card, subject to an inspection of the property. Please not that this property is not wheelchair accessible. Guests with wheelchairs may find it difficult to maneuver within the complex and the apartments. Please note that there is a 2% charge when you pay with a credit card. Reception will request $200 security deposit. Guests aged 0-17 can only check in with a parent or official guardian. The legal guardian must provide a current photo ID or proof and guardianship if requested upon check-in. Please note that the property is accessible via 10 steps. Please note that when booking more than 3 rooms, different policies and additional supplements may apply. If you come for self isolation, please do not book the shared room/apartment. You\'ll have to book the whole apartment. Otherwise you will not be able to check in due to the health and safety issue. All guests must present vaccine pass. Reception closes at 9pm. After-hour check-in is not available.', 'HotelNorms_string', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15409, 5054, '5e8d0e3f-5296-4c5b-ab5d-ff3198603636', 'Early check out will attract full cancellation charge unless otherwise specified', 'DefaultPolicy', 'TBO', '2022-09-15 05:39:58', 2512, NULL),
(15410, 5055, 'room_1', 'Room only', 'aInclusion', 'HBED', '2022-09-15 05:41:33', 2512, NULL),
(15411, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'CheckIn Time-Begin: 3:00 PM ', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15412, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', ' CheckIn Time-End: anytime', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15413, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'CheckOut Time: 11:00 AM', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15414, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'CheckIn Instructions: &amp;lt;ul&amp;gt;  &amp;lt;li&amp;gt;Extra-person charges may apply and vary depending on property policy&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;This property accepts credit cards, debit cards, and cash&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Safety features at this property include a smoke detector&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Be prepared: check the latest COVID-19 travel requirements and measures in place for this destination before you travel.&amp;lt;/li&amp;gt;  &amp;lt;/ul&amp;gt; ', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15415, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', ' Special Instructions : Front desk staff will greet guests on arrival.', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15416, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'Minimum CheckIn Age : 18', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15417, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', ' Optional Fees: &amp;lt;ul&amp;gt; &amp;lt;li&amp;gt;Breakfast fee: between NZD 35 and NZD 35 for adults, NZD 19 and NZD 19 for children (approximately)&amp;lt;/li&amp;gt;       &amp;lt;li&amp;gt;Covered self parking fee: NZD 35 per day&amp;lt;/li&amp;gt; &amp;lt;li&amp;gt;Covered valet parking fee: NZD 55.00 per night (in/out privileges)&amp;lt;/li&amp;gt;          &amp;lt;li&amp;gt;Rollaway bed fee: NZD 40 per night&amp;lt;/li&amp;gt;          &amp;lt;li&amp;gt;Credit card charges are subject to a surcharge of 2.5 percent &amp;lt;/li&amp;gt;  &amp;lt;/ul&amp;gt; &amp;lt;p&amp;gt;The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change. &amp;lt;/p&amp;gt;', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15418, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'Cards Accepted: Visa,Debit cards,American Express,Cash,Mastercard,UnionPay', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15419, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', '&amp;lt;ul&amp;gt;  &amp;lt;li&amp;gt;The property has connecting/adjoining rooms, which are subject to availability and can be requested by contact @fbi_gov ing the property using the number on the booking confirmation. &amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;This property advises that enhanced cleaning and guest safety measures are currently in place.&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Disinfectant is used to clean the property; commonly-touched surfaces are cleaned with disinfectant between stays; bed sheets and towels are laundered at a temperature of at least 60Â°C/140Â°F.&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt;Social distancing measures are in place and guests are provided with hand sanitizer.&amp;lt;/li&amp;gt;&amp;lt;li&amp;gt; This property welcomes guests of all sexual orientations and gender identities (LGBTQ friendly). &amp;lt;/li&amp;gt; &amp;lt;/ul&amp;gt;,Pets not allowed,Property does not require health documentation at check-in,LGBTQ friendly,Property confirms they are implementing guest safety measures,Social distancing measures are in place,Property is cleaned with disinfectant,Guests are provided with free hand sanitizer,Property confirms they are implementing enhanced cleaning measures,Bed sheets and towels are washed at a temperature of at least 60Â°C/140Â°F,Essential workers only - NO,Commonly-touched surfaces are cleaned with disinfectant,Qualmark Sustainable Tourism Business Award', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15420, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'Please refer to the following Terms of Use - http://mytravelagent.online/termsofuse.pdf', 'HotelNorms_string', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15421, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'Early check out will attract full cancellation charge unless otherwise specified', 'DefaultPolicy', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15422, 5057, '5f91d1b3-9bda-4dae-8ee4-69496114a253', 'Hotel Destination Local Date and Time:04-Oct-2022 , 21:30:00', 'AutoCancellationText', 'TBO', '2022-09-15 10:41:10', 2330, NULL),
(15423, 5059, 'room_1', 'Continental breakfast', 'aInclusion', 'HBED', '2022-09-15 20:46:07', 2745, NULL),

(4043, 8787, NULL, 1, 'Adult', 0, 'Mr', 'Vedant Hemant', 'Bajaj', '2023-02-14 04:37:53', '2023-02-14 04:37:53', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4044, 8787, NULL, 1, 'Adult', 0, 'Ms', 'Shivangi', 'Gupta', '2023-02-14 04:37:53', '2023-02-14 04:37:53', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4045, 8790, NULL, 1, 'Adult', 0, 'Mr', 'Vishesh', 'Kedia', '2023-02-14 21:17:25', '2023-02-14 21:17:25', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4046, 8792, NULL, 1, 'Adult', 0, 'Mr', 'NITISH', 'GUPTA', '2023-02-14 23:07:15', '2023-02-14 23:07:15', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4047, 8794, NULL, 1, 'Adult', 0, 'Mr', 'JITENDRA', 'JAIN', '2023-02-14 23:11:59', '2023-02-14 23:11:59', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4048, 8795, NULL, 1, 'Adult', 0, 'Mr', 'JITENDRA', 'JAIN', '2023-02-14 23:15:39', '2023-02-14 23:15:39', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4049, 8798, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 00:15:19', '2023-02-15 00:15:19', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 9295, NULL, NULL, NULL, NULL, NULL, NULL),
(4050, 8799, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 00:26:31', '2023-02-15 00:26:31', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 384, NULL, NULL, NULL, NULL, NULL, NULL),
(4051, 8800, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 00:32:18', '2023-02-15 00:32:18', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 9306, NULL, NULL, NULL, NULL, NULL, NULL),
(4052, 8801, NULL, 1, 'Adult', 0, 'Mrs', 'PARIDHI', 'AGRAWAL', '2023-02-15 00:55:12', '2023-02-26 14:18:38', 0, 0, NULL, NULL, NULL, NULL, 'tailormadetandt@gmail.com', '+918286010060', NULL, NULL, NULL, NULL, NULL, 9908, NULL, NULL, NULL, NULL, NULL, NULL),
(4053, 8802, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 00:55:30', '2023-02-15 00:55:30', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 432, NULL, NULL, NULL, NULL, NULL, NULL),
(4054, 8803, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 01:03:29', '2023-02-15 01:03:29', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 699, NULL, NULL, NULL, NULL, NULL, NULL),
(4055, 8804, NULL, 1, 'Adult', 0, 'Mr', 'Hitesh', 'Oswal', '2023-02-15 01:58:39', '2023-02-15 01:58:39', 0, 0, NULL, NULL, NULL, NULL, 'ops2@jigsawtravels.com', '9763720451', NULL, NULL, NULL, NULL, NULL, 18186, NULL, NULL, NULL, NULL, NULL, NULL),
(4056, 8806, NULL, 1, 'Adult', 0, 'Mr', 'Rahul', 'aggarwal', '2023-02-15 12:36:14', '2023-02-15 12:36:14', 0, 0, NULL, NULL, NULL, NULL, 'arg.rahul@gmail.com', '0220382451', NULL, NULL, NULL, NULL, NULL, 373, NULL, NULL, NULL, NULL, NULL, NULL),
(4057, 8809, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:44:26', '2023-02-15 21:44:26', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, '', NULL, NULL, NULL),
(4058, 8810, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:44:42', '2023-02-15 21:44:42', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 9306, NULL, NULL, NULL, NULL, NULL, NULL),
(4059, 8811, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:44:57', '2023-02-15 21:44:57', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 264083, NULL, NULL, NULL, NULL, NULL, NULL),
(4060, 8812, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:45:13', '2023-02-15 21:45:13', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 18582, NULL, NULL, NULL, NULL, NULL, NULL),
(4061, 8813, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:45:26', '2023-02-15 21:45:26', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 1176, NULL, NULL, NULL, NULL, NULL, NULL),
(4062, 8814, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:45:44', '2023-02-15 21:45:44', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 2598, NULL, NULL, NULL, NULL, NULL, NULL),
(4063, 8815, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:46:02', '2023-02-15 21:46:02', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 2135, NULL, NULL, NULL, NULL, NULL, NULL),
(4064, 8816, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:46:22', '2023-02-15 21:46:22', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 900, NULL, NULL, NULL, NULL, NULL, NULL),
(4065, 8817, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:46:36', '2023-02-15 21:46:36', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 394, NULL, NULL, NULL, NULL, NULL, NULL),
(4066, 8818, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:46:58', '2023-02-15 21:46:58', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 440, NULL, NULL, NULL, NULL, NULL, NULL),
(4067, 8819, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:47:40', '2023-02-15 21:47:40', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 2303, NULL, NULL, NULL, NULL, NULL, NULL),
(4068, 8820, NULL, 1, 'Adult', 0, 'Mr', 'YASH', 'SANGHVI', '2023-02-15 21:48:03', '2023-02-15 21:48:03', 0, 0, NULL, NULL, NULL, NULL, 'unmappedtrails99@gmail.com', '+917738334445', NULL, NULL, NULL, NULL, NULL, 2309, NULL, NULL, NULL, NULL, NULL, NULL),



(2014, 'mail@vyomjourneys.co.nz', 'enquiries@fullers.co.nz', 'mail@vyomjourneys.co.nz', NULL, 4071, 'REJECTION_MESSAGE_SUPPLIER', 0, 452, 0, 0, '', 'REJECT CONFIRMATION FOR MR SANJAY PODDAR X 4 -FAMILY-27SEP', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Fullers Auckland,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys confirm the reject of the services listed below .</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4071 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Rejection Request for Waiheke Explorer Hop-on-hop-off Tour (Return Ferry Tickets Included)</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72630</td>\r\n                            <td  style=\"      font-size: 15px !important;\"></td>\r\n                            <td  style=\"      font-size: 15px !important;\">28 Sep, 2022  @09:45 AM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">28 Sep, 2022 </td>\r\n                            <td  style=\"      font-size: 15px !important;\">0</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Pranali  Desai<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : mail@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"4071\",\"supplier_id\":\"452\",\"aItineraryServiceID\":[\"122970\"],\"type\":\"REJECTION_MESSAGE_SUPPLIER\",\"is_group\":false}', '2022-09-18 08:35:44', NULL, 'SUCCESS'),
(2015, 'info@vyomjourneys.co.nz', 'mail@vyomjourneys.co.nz', '', NULL, 4071, 'SEND_CONFIRMATION_MAIL_TO_OPS_USER', 0, 803, 0, 0, '', 'BOOKING CONFIRMED - Christchurch Tram ', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Pranali  Desai,</span>\r\n                          <br>\r\n                         <p >Your Requested service is confirmed by Christchurch Tram confirmed services are listed below.</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4071 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Confirmed Request for Christchurch Tram City Tour</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72625</td>\r\n                            <td  style=\"      font-size: 15px !important;\">CH049392</td>\r\n                            <td  style=\"      font-size: 15px !important;\">09 Oct, 2022  @09:00 AM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">09 Oct, 2022 </td>\r\n                            <td  style=\"      font-size: 15px !important;\">4</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/create?itinid=4071&action=view&tsection=booking\" target=\"_blank\">view itinerary booking</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Vyom Journeys Ltd.<br/>192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>Email : info@vyomjourneys.co.nz<br/>Web : http://www.vyomjourneys.co.nz<br/>Pranali  Desai<br/></td></tr></table>', '{\"itinerary_id\":\"4071\",\"supplier_id\":\"803\",\"type\":\"SEND_CONFIRMATION_MAIL_TO_OPS_USER\",\"is_group\":false}', '2022-09-18 21:39:53', NULL, 'SUCCESS'),
(2016, 'info@vyomjourneys.co.nz', 'mail@vyomjourneys.co.nz', '', NULL, 4071, 'SEND_CONFIRMATION_MAIL_TO_OPS_USER', 0, 1219, 0, 0, '', 'BOOKING CONFIRMED - Redwood Treewalk ', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Pranali  Desai,</span>\r\n                          <br>\r\n                         <p >Your Requested service is confirmed by Redwood Treewalk confirmed services are listed below.</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4071 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Confirmed Request for Redwood Nightlights from dusk till late</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72612</td>\r\n                            <td  style=\"      font-size: 15px !important;\">19092022a</td>\r\n                            <td  style=\"      font-size: 15px !important;\">29 Sep, 2022  @06:00 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">29 Sep, 2022  @11:00 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">4</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/create?itinid=4071&action=view&tsection=booking\" target=\"_blank\">view itinerary booking</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Vyom Journeys Ltd.<br/>192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>Email : info@vyomjourneys.co.nz<br/>Web : http://www.vyomjourneys.co.nz<br/>Pranali  Desai<br/></td></tr></table>', '{\"itinerary_id\":\"4071\",\"supplier_id\":\"1219\",\"type\":\"SEND_CONFIRMATION_MAIL_TO_OPS_USER\",\"is_group\":false}', '2022-09-18 22:48:40', NULL, 'SUCCESS'),
(2017, 'info@vyomjourneys.co.nz', 'mail@vyomjourneys.co.nz', '', NULL, 4071, 'SEND_CONFIRMATION_MAIL_TO_OPS_USER', 0, 215, 0, 0, '', 'BOOKING CONFIRMED - Tamaki Maori Village, Rotorua ', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Pranali  Desai,</span>\r\n                          <br>\r\n                         <p >Your Requested service is confirmed by Tamaki Maori Village, Rotorua confirmed services are listed below.</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4071 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Confirmed Request for Tamaki Maori Village Experience (Incl: 3.5 hr Maori Cultural Experience + Buffet dinner feast)</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72615</td>\r\n                            <td  style=\"      font-size: 15px !important;\">TPT002725</td>\r\n                            <td  style=\"      font-size: 15px !important;\">30 Sep, 2022  @05:00 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">30 Sep, 2022  @08:00 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">4</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/create?itinid=4071&action=view&tsection=booking\" target=\"_blank\">view itinerary booking</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Vyom Journeys Ltd.<br/>192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>Email : info@vyomjourneys.co.nz<br/>Web : http://www.vyomjourneys.co.nz<br/>Pranali  Desai<br/></td></tr></table>', '{\"itinerary_id\":\"4071\",\"supplier_id\":\"215\",\"type\":\"SEND_CONFIRMATION_MAIL_TO_OPS_USER\",\"is_group\":false}', '2022-09-18 22:54:37', NULL, 'SUCCESS'),
(2018, 'info@vyomjourneys.co.nz', 'mail@vyomjourneys.co.nz', '', NULL, 4071, 'SEND_CONFIRMATION_MAIL_TO_OPS_USER', 0, 70, 0, 0, '', 'BOOKING CONFIRMED - Canterbury Leisure Tours ', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Pranali  Desai,</span>\r\n                          <br>\r\n                         <p >Your Requested service is confirmed by Canterbury Leisure Tours confirmed services are listed below.</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4071 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Confirmed Request for Kaikoura Whale Watch tour CLT08</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72624</td>\r\n                            <td  style=\"      font-size: 15px !important;\">LT08081022</td>\r\n                            <td  style=\"      font-size: 15px !important;\">08 Oct, 2022  @07:30 AM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">08 Oct, 2022  @05:30 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">4</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/create?itinid=4071&action=view&tsection=booking\" target=\"_blank\">view itinerary booking</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Vyom Journeys Ltd.<br/>192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>Email : info@vyomjourneys.co.nz<br/>Web : http://www.vyomjourneys.co.nz<br/>Pranali  Desai<br/></td></tr></table>', '{\"itinerary_id\":\"4071\",\"supplier_id\":\"70\",\"type\":\"SEND_CONFIRMATION_MAIL_TO_OPS_USER\",\"is_group\":false}', '2022-09-18 23:15:07', NULL, 'SUCCESS'),
(2019, 'mail@vyomjourneys.co.nz', 'reservations_rydgesrotorua@evt.com', 'mail@vyomjourneys.co.nz', NULL, 4067, 'CANCELLATION_MESSAGE_SUPPLIER', 0, 31, 0, 0, '', ' CANCELLATION REQUEST FOR SMALL GROUP PRIVATE TOUR OF NZD- BOOKING', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Rydges Rotorua,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys want cancelled of the services listed below .</p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :4067 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  > Cancellation Request for Standard Room- Asian Group BB Rates</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Reference No</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Check-In</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Check-Out</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">72538</td>\r\n                            <td  style=\"      font-size: 15px !important;\">ZN6</td>\r\n                            <td  style=\"      font-size: 15px !important;\">02 Feb, 2023  @03:00 PM</td>\r\n                            <td  style=\"      font-size: 15px !important;\">04 Feb, 2023 </td>\r\n                            <td  style=\"      font-size: 15px !important;\">8</td>\r\n                            \r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Pranali  Desai<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : mail@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"4067\",\"supplier_id\":\"31\",\"aItineraryServiceID\":[\"122860\"],\"type\":\"CANCELLATION_MESSAGE_SUPPLIER\",\"is_group\":true}', '2022-09-19 13:07:00', NULL, 'SUCCESS'),
(2020, 'operations@vyomjourneys.co.nz', 'sales@kellytarltons.co.nz', 'operations@vyomjourneys.co.nz', NULL, 3658, 'CONFIRMATION_TIME_REQUEST_TO_SUPPLIER', 0, 87, 0, 0, '', ' BOOKING REQUEST FOR GROUP/TULIP HOLIDAYS/TANZ271022 / NZ UPDATED 22 JUNE', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Kelly Tarltons,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys request you to confirm services listed below . Kindly update the status by clicking on the link below.</p>  </td></tr><tr><td ><p> <span style=\"color:#1e546b\">Guest Details :Group/Tulip Holidays/TANZ271022 / NZ updated 22 June </span></p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :3658 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  >Booking Request for Kelly Tarltons Entry / Admission</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:40%;\"  >Booking Request Remark</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">62931</td>\r\n                            <td  style=\"      font-size: 15px !important;\">05 Nov, 2022  @04:00 PM<br></td>\r\n                            <td  style=\"      font-size: 15px !important;\">05 Nov, 2022 <br></td>\r\n                            <td  style=\"      font-size: 15px !important;\"><div>Paid : 39</div>\r\n                       <div>FOC : 2</div>\r\n                       </td>\r\n                            <td  style=\"      font-size: 15px !important;\">Please book 3.30 Pm Slot</td>\r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/status?itinid=3658&action=view&tsection=documenttab&supplier_id=87&booked_id=62931\" target=\"_blank\">Click To Update Status</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Avanti Patil<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : operations@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"3658\",\"supplier_id\":\"87\",\"aItineraryServiceID\":[\"106850\"],\"type\":\"CONFIRMATION_TIME_REQUEST_TO_SUPPLIER\",\"is_group\":true}', '2022-09-19 13:27:08', NULL, 'SUCCESS'),
(2021, 'operations@vyomjourneys.co.nz', 'skytower@skycity.co.nz', 'operations@vyomjourneys.co.nz', NULL, 3658, 'CONFIRMATION_TIME_REQUEST_TO_SUPPLIER', 0, 66, 0, 0, '', ' BOOKING REQUEST FOR GROUP/TULIP HOLIDAYS/TANZ271022 / NZ UPDATED 22 JUNE', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Sky Tower Auckland,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys request you to confirm services listed below . Kindly update the status by clicking on the link below.</p>  </td></tr><tr><td ><p> <span style=\"color:#1e546b\">Guest Details :Group/Tulip Holidays/TANZ271022 / NZ updated 22 June </span></p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :3658 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  >Booking Request for Total Tower Experience Pass</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:40%;\"  >Booking Request Remark</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">62932</td>\r\n                            <td  style=\"      font-size: 15px !important;\">06 Nov, 2022  @09:15 AM<br></td>\r\n                            <td  style=\"      font-size: 15px !important;\">06 Nov, 2022 <br></td>\r\n                            <td  style=\"      font-size: 15px !important;\"><div>Paid : 39</div>\r\n                       <div>FOC : 2</div>\r\n                       </td>\r\n                            <td  style=\"      font-size: 15px !important;\"></td>\r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/status?itinid=3658&action=view&tsection=documenttab&supplier_id=66&booked_id=62932\" target=\"_blank\">Click To Update Status</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Avanti Patil<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : operations@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"3658\",\"supplier_id\":\"66\",\"aItineraryServiceID\":[\"106851\"],\"type\":\"CONFIRMATION_TIME_REQUEST_TO_SUPPLIER\",\"is_group\":true}', '2022-09-19 13:27:13', NULL, 'SUCCESS'),
(2022, 'operations@vyomjourneys.co.nz', 'caveinfo@waitomo.com', 'operations@vyomjourneys.co.nz', NULL, 3658, 'CONFIRMATION_TIME_REQUEST_TO_SUPPLIER', 0, 55, 0, 0, '', ' BOOKING REQUEST FOR GROUP/TULIP HOLIDAYS/TANZ271022 / NZ UPDATED 22 JUNE', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Waitomo Caves,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys request you to confirm services listed below . Kindly update the status by clicking on the link below.</p>  </td></tr><tr><td ><p> <span style=\"color:#1e546b\">Guest Details :Group/Tulip Holidays/TANZ271022 / NZ updated 22 June </span></p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :3658 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  >Booking Request for Waitomo Glowworm Caves + Indian Buffet (Minimum 10 pax)</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:40%;\"  >Booking Request Remark</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">62935</td>\r\n                            <td  style=\"      font-size: 15px !important;\">05 Nov, 2022  @09:30 AM<br></td>\r\n                            <td  style=\"      font-size: 15px !important;\">05 Nov, 2022  @10:30 AM<br></td>\r\n                            <td  style=\"      font-size: 15px !important;\"><div>Paid : 39</div>\r\n                       <div>FOC : 2</div>\r\n                       </td>\r\n                            <td  style=\"      font-size: 15px !important;\"></td>\r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/status?itinid=3658&action=view&tsection=documenttab&supplier_id=55&booked_id=62935\" target=\"_blank\">Click To Update Status</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Avanti Patil<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : operations@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"3658\",\"supplier_id\":\"55\",\"aItineraryServiceID\":[\"106854\"],\"type\":\"CONFIRMATION_TIME_REQUEST_TO_SUPPLIER\",\"is_group\":true}', '2022-09-19 13:27:18', NULL, 'SUCCESS'),
(2023, 'operations@vyomjourneys.co.nz', 'queenstown.tourgroups@skyline.co.nz', 'operations@vyomjourneys.co.nz', NULL, 3658, 'CONFIRMATION_TIME_REQUEST_TO_SUPPLIER', 0, 59, 0, 0, '', ' BOOKING REQUEST FOR GROUP/TULIP HOLIDAYS/TANZ271022 / NZ UPDATED 22 JUNE', '<table><tr style=\"background-color:#1e546b;\"><td style=\"text-align:center;\" ><a href=\"https://nzplanner.vyomjourneys.co.nz/\" target=\"_blank\" ><img src=\"https://nzplanner.vyomjourneys.co.nz/assets/images/logo-vyom.png\"></a></td></tr><tr><td ><span >Dear Skyline Queenstown,</span>\r\n                          <br>\r\n                         <p > Vyomjourneys request you to confirm services listed below . Kindly update the status by clicking on the link below.</p>  </td></tr><tr><td ><p> <span style=\"color:#1e546b\">Guest Details :Group/Tulip Holidays/TANZ271022 / NZ updated 22 June </span></p></td></tr><tr><td ><p> <span style=\"color:#1e546b\">Itinerary Id :3658 </span></p></td></tr><tr><td  ><table style=\"    background-color: #fff; border-spacing: 0; border-collapse: collapse;width:100%;\"  ><tr><th colspan=\"5\"  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;\"  >Booking Request for Gondola ride</th></tr>\r\n                                    <tr>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:12%;\" >Booking Id</th>\r\n                                        <th style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >Start Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:25%;\" >End Date</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:10%;\" >Unit</th>\r\n                                        <th  style=\"   color:#1e546b;text-align:left; border: 1px solid #ddd; line-height: 1.42857143;  vertical-align: top;color:#1e546b;text-align:left; display: table-cell;width:40%;\"  >Booking Request Remark</th>\r\n                                    </tr>\r\n                                     <tr  style=\"  display: table-row; vertical-align: inherit;  border-color: inherit;\" >\r\n                            <td  style=\"      font-size: 15px !important;\">62942</td>\r\n                            <td  style=\"      font-size: 15px !important;\">06 Nov, 2022  @06:30 PM<br></td>\r\n                            <td  style=\"      font-size: 15px !important;\">06 Nov, 2022 <br></td>\r\n                            <td  style=\"      font-size: 15px !important;\"><div>Paid : 39</div>\r\n                       <div>FOC : 2</div>\r\n                       </td>\r\n                            <td  style=\"      font-size: 15px !important;\">Book 06 pm Slot</td>\r\n                         </tr></table></td></tr><tr style=\"background-color:#1e546b; height:50px;margin-top:20px;\"><td  style=\"text-align: center;   font-size: 23px;  \"><a style=\"color:#eac664; text-align:center;padding-top:10px;padding-bottom:10px;\" href=\"https://nzplanner.vyomjourneys.co.nz/itineary/status?itinid=3658&action=view&tsection=documenttab&supplier_id=59&booked_id=62942\" target=\"_blank\">Click To Update Status</a></td></tr><tr ><td  ><br>Thanks & Regards,<br/> \r\n                          Avanti Patil<br/>\r\n                          Vyom Journeys Ltd.<br/>\r\n                          192 Stoddard Road Mount Roskill, Auckland, New Zealand 1041<br/>\r\n                          Email : operations@vyomjourneys.co.nz<br/>\r\n                          Web : http://www.vyomjourneys.co.nz</td></tr></table>', '{\"itinerary_id\":\"3658\",\"supplier_id\":\"59\",\"aItineraryServiceID\":[\"106862\"],\"type\":\"CONFIRMATION_TIME_REQUEST_TO_SUPPLIER\",\"is_group\":true}', '2022-09-19 13:27:22', NULL, 'SUCCESS'),

Thank you for posting this

Shield · Jun 26, 2023

file size is 75 mb only

blaze · Jun 29, 2023

was looking for somethin like this, thank you sir

coolworker33 · Aug 3, 2023

was looking for somethin like this, thank you sir

Удалённый пользователь 3691 · Aug 3, 2023

Thanks for the share

coolworker33 · Aug 5, 2023

thanks a lot

boundary666 · Aug 5, 2023

thanks, it is useful!

mido789 · Sep 12, 2023

tdhf dfsjg gjhk jhg sfgs

data5858 · Sep 13, 2023

Thank you so much

Database Leaked - Makebookingsonline.com Sql © Chucky Credits

Chucky

Удалённый пользователь 3691

nopbcvlq

drudown500

gruquira

hqrish

Shield

blaze

coolworker33

Удалённый пользователь 3691

coolworker33

boundary666

mido789

data5858

Users who are viewing this thread

Similar threads