[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hotel Blue Pearl Residency', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hotel Relax', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Highway Residency', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Fabhotel Aksa International Andheri East', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hotel Residency Park', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hotel Sunshine Airport', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Liberty Plaza', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Milan International', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hotel Leafio Mumbai', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Oyo 73696 Hotel Orient Palace', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Adore Inn By Fabhotels', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hotel Kamran Residency', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Fabhotel Aksa International Andheri East', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Sweet Home', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Hotel Bombay International', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Landmark Suites', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Nest Inn', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('The Royal Orchid', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Istay Hotels Andheri Midc', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:44:26], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Flora Fountain Hotel', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:44:26','');
[06/04/2024 01:46:30], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Taj Qtech', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:46:30','');
[06/04/2024 01:46:30], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Qtech_test', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:46:30','');
[06/04/2024 01:46:30], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Qtech_test1', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:46:30','');
[06/04/2024 01:56:38], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Taj Qtech', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:56:38','');
[06/04/2024 01:56:38], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Qtech_test', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:56:38','');
[06/04/2024 01:56:38], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Qtech_test1', 'mumbai', '106', '7857', '', '23', '', 'hotelfiltername', '2024-06-04 :13:56:38','');
[06/04/2024 01:58:40], [file name :-/efsdata/otrams/public_html/beta/m1_paging_information.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Rambler Oasis', 'hong kong', '105', '7864', '', '28', '', 'hotelfiltername', '2024-06-04 :13:58:40','');
[06/04/2024 01:28:43], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-06-04 01:28:43',login_attempt=0 where id = '7864';
[06/04/2024 01:28:43], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'gajju', user_type = 'A', branch_id = '28', login_datetime = '2024-06-04 13:28:43', ip = '43.239.53.130', action = 'Login' ;
[06/04/2024 01:29:14], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7864' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '28' , ip = '43.239.53.130' , city = 'hong kong' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/20' , departure_date = '2024/06/21' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-06-04 13:29:14' , site_id = '' , country_code = '105' , city_code = '64436' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[06/04/2024 01:29:16], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7864&sessionid=71cbe4be5f1e506c243940ce3442f2a1cd6a77df5803860e3f7698a1d94b2c05',
        duration = '1.202',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.19',
        system_load_5_min = '5.80',
        system_load_15_min = '11.60',
        system_memory_usage = '94.43',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2107') + '2016296',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2107';
[06/04/2024 01:29:29], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1717507769','43.239.53.130');
[06/04/2024 01:45:07], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7864' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '28' , ip = '43.239.53.130' , city = 'hong kong' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/20' , departure_date = '2024/06/21' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-06-04 13:45:07' , site_id = '' , country_code = '105' , city_code = '64436' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[06/04/2024 01:45:09], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7864&sessionid=71cbe4be5f1e506c243940ce3442f2a1cd6a77df5803860e3f7698a1d94b2c05',
        duration = '1.440',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '6.32',
        system_load_5_min = '12.55',
        system_load_15_min = '11.30',
        system_memory_usage = '95.23',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2108') + '2016952',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2108';
[06/04/2024 01:45:45], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7864' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '28' , ip = '43.239.53.130' , city = 'hong kong' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/06/20' , departure_date = '2024/06/21' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-06-04 13:45:45' , site_id = '' , country_code = '105' , city_code = '64436' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[06/04/2024 01:45:47], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7864&sessionid=71cbe4be5f1e506c243940ce3442f2a1cd6a77df5803860e3f7698a1d94b2c05',
        duration = '1.105',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '6.44',
        system_load_5_min = '11.75',
        system_load_15_min = '11.08',
        system_memory_usage = '95.46',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2109') + '2017496',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2109';
[06/04/2024 01:46:56], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1717508816','43.239.53.130');
[06/04/2024 01:46:57], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/04_06_2024/request_valuation_gajju_13_46_56_1717508816_.xml', 'a5/04_06_2024/response_valuation_gajju_13_46_56_1717508816_.xml', 'a5/04_06_2024/response_header_valuation_gajju_13_46_56_1717508816_.xml', 'agoda', '2024-06-04 01:46:57', '', '71cbe4be5f1e506c243940ce3442f2a1cd6a77df5803860e3f7698a1d94b2c05', '2109', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/04_06_2024/response_valuation_gajju_13_46_56_1717508816_.xml');
[06/04/2024 01:46:59], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'PRECHECK', 'a5/04_06_2024/request_precheck_gajju_13_46_59_1717508819_.xml', 'a5/04_06_2024/response_precheck_gajju_13_46_59_1717508819_.xml', 'a5/04_06_2024/response_header_precheck_gajju_13_46_59_1717508819_.xml', 'agoda', '2024-06-04 01:46:59', '', '71cbe4be5f1e506c243940ce3442f2a1cd6a77df5803860e3f7698a1d94b2c05', '2109', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/04_06_2024/response_precheck_gajju_13_46_59_1717508819_.xml');
[06/04/2024 01:48:05], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1717508885','43.239.53.130');
[06/04/2024 01:48:07], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'agoda', reservation_id = '4617', create_date = '2024-06-04 13:48:07', agent_id = '7864', parent_agent_id = '7864', agent_ref_no = '', nationality = 'Indian', city_id = 'hong kong', country_id = '105', current_status = 'inprocess-booking', booking_branch_id = '28', is_xml = '0', display_room_rate = '2604.41', display_currency_code = 'INR', native_room_rate = '43.28', native_currency_code = 'USD', supplier_profile_id = '24', service_type = 'hotel', service_date = '2024/06/20', check_out_date = '2024/06/21', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'gaju', leader_last_name = 'test', status_date = '2024-06-04 13:48:07';
[06/04/2024 01:48:07], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date) VALUES ('617','RAMBLER OASIS','NA','90772','OT000094096','hong kong','agoda',NOW());
[06/04/2024 01:48:07], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '28'
		WHERE
		id='617'
		;
[06/04/2024 01:48:07], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('617','4617','','1','2','0','-','','','90772','RAMBLER OASIS','No. 1 Tsing Yi Road Tsing Yi','+8528685221291188','5.0','1','2024/06/20','2024/06/21','','https://beta.astrabookings.com/cpfv3/images/?image=aHR0cHM6Ly9waXg4LmFnb2RhLm5ldC9ob3RlbEltYWdlcy8xNDkvMTQ5MTQzLzE0OTE0M18xNTA3MTMxNzA5MDAzMjIwMDMwMi5qcGc/Y2E9NCZjZT0xJnM9MzEyeA==');
[06/04/2024 01:48:07], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '617', booking_detail_id = '1', room_type_code = 'N2JiODE4MzAtZTk5ZS1jOWNiLTkyODUtYzM1YjQyMjJkMThiOjMzMg==', room_name = 'double', room_type_description = 'Superior With Wifi , Room Only | Amenities:Free WiFi , Free fitness center access , ', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:2604.4099999999999;s:25:"displayNightlyRateDisplay";s:202:"Supplier Rate - 43.28;; Currency Multiplier (USD - INR) - 60.175800; Markup Policy : ; Markup Amount : 0.000000; Applied Markup Amount : 0.000000; Markup in % : 0.000000; Golang : yes ; Supplier : agoda";s:13:"whNightlyRate";d:2604.4099999999999;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:43.280000000000001;}}', native_room_rate_total = '43.28', display_room_rate_total = '2604.41', number_of_rooms = '1', room_category = 'Superior With Wifi', meal_basis = 'Room Only';
[06/04/2024 01:48:07], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '617', booking_detail_id = '1', rid = '378', room = '0', salutations = 'Mr', first_name = 'gaju', last_name = 'test', passenger_type = 'adult', age = '';
[06/04/2024 01:48:07], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '617', booking_detail_id = '1', rid = '378', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[06/04/2024 01:48:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'RESERVATION', 'a5/04_06_2024/request_reservation_gajju_13_48_07_1717508887_.xml', 'a5/04_06_2024/response_reservation_gajju_13_48_07_1717508887_.xml', 'a5/04_06_2024/response_header_reservation_gajju_13_48_07_1717508887_.xml', 'agoda', '2024-06-04 01:48:08', '', '71cbe4be5f1e506c243940ce3442f2a1cd6a77df5803860e3f7698a1d94b2c05', '2109', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/04_06_2024/response_reservation_gajju_13_48_07_1717508887_.xml');
[06/04/2024 01:48:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', cancellation_policy = 'The latest deadline to cancel this booking without charges is 26 Feb 2024 05:30.<BR>Late amendment charges may apply.<BR><BR>100% charges will be applicable if cancelled after 26 Feb 2024 05:30<BR> The property makes no refunds for no shows or early checkouts.<BR>', supplier_cancellation_policy = '', current_status = 'on_request', expiration_date = '2024-06-03 00:00:00', comment_contract = ' <br/><strong>Hotel Remark:<br>In accordance with the guidelines outlined in the draft amendment to the Product Eco-responsibility Ordinance of 2023, Hong Kong hotels will no longer offer complimentary disposable plastic products to guests. For specific inquiries, please consult the official website of the hotel. <br/> Please note that the opening of the hotel\'s swimming pool is seasonal and use of the swimming pool is subject to admission. <br/> The property allows the bookings under the same guest name up to 2 rooms. <br/> Outdoor Swimming Pool - At 200 meters long, it is the longest outdoor swimming pool in Hong Kong. (Pool entrance fee applies)<br>Swimming pool opening hours - 07:00-12:00 and 13:00-18:00 from May 1, 2023 to September 30, 2023<br>The swimming pool will be closed on Monday and Tuesday afternoons from May 1, 2023 to September 30, 2023<br>If Monday is a public holiday, the swimming pool will be closed all day on Tuesday and afternoon on Wednesday.<br>The swimming pool will be closed from October 1, 2023 to April 30, 2024<br></strong><strong><br><br>Child and extra bed policy : <br><br> Infant 0-0 year(s) stay for free if using existing bedding. Note if you need a cot there may be an extra charge.<br><br>Children 0-12 year(s) old stay for free if using existing bedding, extra bed and meals are not included.<br><br>Guests over 12 years old are considered as an adults.<br>Extra beds are depend on the room you choose,please check the individual room policy for more details.</strong><br/>', consultant_id = 'SUJAY_QTECH', sales_manager_id = '0', admin_booked = '1', email_id = 'gajendra.rajpurohit@qtechsoftware.com', leader_phone = '1234567890', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' <br/><strong>Hotel Remark:<br>In accordance with the guidelines outlined in the draft amendment to the Product Eco-responsibility Ordinance of 2023, Hong Kong hotels will no longer offer complimentary disposable plastic products to guests. For specific inquiries, please consult the official website of the hotel. <br/> Please note that the opening of the hotel\'s swimming pool is seasonal and use of the swimming pool is subject to admission. <br/> The property allows the bookings under the same guest name up to 2 rooms. <br/> Outdoor Swimming Pool - At 200 meters long, it is the longest outdoor swimming pool in Hong Kong. (Pool entrance fee applies)<br>Swimming pool opening hours - 07:00-12:00 and 13:00-18:00 from May 1, 2023 to September 30, 2023<br>The swimming pool will be closed on Monday and Tuesday afternoons from May 1, 2023 to September 30, 2023<br>If Monday is a public holiday, the swimming pool will be closed all day on Tuesday and afternoon on Wednesday.<br>The swimming pool will be closed from October 1, 2023 to April 30, 2024<br></strong><strong><br><br>Child and extra bed policy : <br><br> Infant 0-0 year(s) stay for free if using existing bedding. Note if you need a cot there may be an extra charge.<br><br>Children 0-12 year(s) old stay for free if using existing bedding, extra bed and meals are not included.<br><br>Guests over 12 years old are considered as an adults.<br>Extra beds are depend on the room you choose,please check the individual room policy for more details.</strong><br/>', backoffice_user = 'v3alpha', customer_id = '', applied_multiplier='60.1758',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='0.01662',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7864',  sub_agent_rate='0',  agent_rate='2604.41',  applicable_service_tax='0',  supplier_rate='43.28',  uid='42d7c22b42fbe7579ec5478c146c299d'  where id='617';
[06/04/2024 01:48:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='617';
[06/04/2024 01:48:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('617','22.342386','114.109794');
[06/04/2024 01:48:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings set admin_booked='1' where id='617';
[06/04/2024 01:48:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('4617','617','on_request','2024-06-04 13:48:08','Booking on_request Error: Failed. Booked by Back Office v3alpha on behalf of Agent - Gajendra singh Rajpurohit(CD7864)','7864','43.239.53.130','1','7864');
[06/04/2024 01:48:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,applied_agent_charges)  VALUES('617','2604.41');
[06/04/2024 01:48:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='617',status='1' where reservation_id='4617' and booking_id ='0';
[06/04/2024 01:48:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='617' where agent_logs_id='2109' and source_type='agoda';
[06/04/2024 01:48:43], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1717508923','43.239.53.130');
