[11/28/2023 04:07:16], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2023-11-28 04:07:16', ip = '205.210.31.157', action = 'Login' ;
[11/28/2023 04:34:33], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 04:34:33',login_attempt=0 where id = '7865';
[11/28/2023 04:34:33], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-28 04:34:33', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 04:34:33], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007',create_date='2023-11-28 04:34:33', update_date='2023-11-28 04:34:33',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[11/28/2023 04:35:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:35:09' WHERE id= '158';
[11/28/2023 04:35:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:35:40' WHERE id= '158';
[11/28/2023 04:35:40], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/10' , departure_date = '2024/01/11' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 04:35:40' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/28/2023 04:35:41], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:35:41' WHERE id= '158';
[11/28/2023 04:35:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_04_35_41_1701146141_57.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_04_35_41_1701146141_57.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_35_41_1701146141_57.json', 'expedia', '2023-11-28 04:35:42', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:35:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_04_35_41_1701146141_91.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_04_35_41_1701146141_91.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_35_41_1701146141_91.json', 'expedia', '2023-11-28 04:35:42', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:35:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:35:41.746'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.912'
            , error_description = ''
            , memory_used = '14145096'
            WHERE id = '14705';
[11/28/2023 04:35:42], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_04_35_41_1701146141_4.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_04_35_41_1701146141_4.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_35_41_1701146141_4.json', 'expediapackage', '2023-11-28 04:35:42', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:35:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:35:41.746'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.193'
            , error_description = ''
            , memory_used = '30290576'
            WHERE id = '14706';
[11/28/2023 04:35:42], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:35:41.746'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.216'
            , error_description = ''
            , memory_used = '14299640'
            WHERE id = '14707';
[11/28/2023 04:35:43], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_04_35_41_1701146141_93.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_04_35_41_1701146141_93.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_35_41_1701146141_93.json', 'expediapackage', '2023-11-28 04:35:43', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:35:43], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:35:41.746'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.585'
            , error_description = ''
            , memory_used = '31791112'
            WHERE id = '14708';
[11/28/2023 04:35:43], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:35:43' WHERE id= '158';
[11/28/2023 04:36:12], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:36:12' WHERE id= '158';
[11/28/2023 04:36:12], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:36:12' WHERE id= '158';
[11/28/2023 04:36:12], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701146172','43.239.53.130');
[11/28/2023 04:36:13], [file name :-/home/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)
                VALUE ('', 'valuation', 'e1p/28_11_2023/request_valuation_Baysan_Tourism_wh_04_36_12_1701146172_88.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_04_36_12_1701146172_88.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_04_36_12_1701146172_88.json', 'expediapackage', '2023-11-28 04:36:13', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:49:29], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 04:49:29',login_attempt=0 where id = '7865';
[11/28/2023 04:49:29], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-28 04:49:29', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 04:49:29], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7863', session_id='5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b',create_date='2023-11-28 04:49:29', update_date='2023-11-28 04:49:29',domain='baysantravel.astrabookings.com',sub_agent_id='',sub_user_id='';
[11/28/2023 04:50:38], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:50:38' WHERE id= '158';
[11/28/2023 04:50:43], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:50:43' WHERE id= '158';
[11/28/2023 04:51:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:51:09' WHERE id= '158';
[11/28/2023 04:51:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/10' , departure_date = '2024/01/11' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 04:51:09' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/28/2023 04:51:10], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:51:10' WHERE id= '158';
[11/28/2023 04:51:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_04_51_10_1701147070_86.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_04_51_10_1701147070_86.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_51_10_1701147070_86.json', 'expedia', '2023-11-28 04:51:11', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:51:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:51:10.736'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.707'
            , error_description = ''
            , memory_used = '14050096'
            WHERE id = '14710';
[11/28/2023 04:51:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_04_51_10_1701147070_78.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_04_51_10_1701147070_78.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_51_10_1701147070_78.json', 'expedia', '2023-11-28 04:51:11', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:51:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_04_51_10_1701147070_92.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_04_51_10_1701147070_92.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_51_10_1701147070_92.json', 'expediapackage', '2023-11-28 04:51:11', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:51:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:51:10.736'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.925'
            , error_description = ''
            , memory_used = '14288824'
            WHERE id = '14712';
[11/28/2023 04:51:11], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:51:10.736'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.054'
            , error_description = ''
            , memory_used = '30270264'
            WHERE id = '14711';
[11/28/2023 04:51:11], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_04_51_10_1701147070_96.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_04_51_10_1701147070_96.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_51_10_1701147070_96.json', 'expediapackage', '2023-11-28 04:51:11', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:51:12], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:51:10.736'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.371'
            , error_description = ''
            , memory_used = '31767672'
            WHERE id = '14713';
[11/28/2023 04:51:12], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:51:12' WHERE id= '158';
[11/28/2023 04:51:19], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:51:19' WHERE id= '158';
[11/28/2023 04:51:19], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:51:19' WHERE id= '158';
[11/28/2023 04:51:19], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701147079','43.239.53.130');
[11/28/2023 04:51:20], [file name :-/home/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)
                VALUE ('', 'valuation', 'e1p/28_11_2023/request_valuation_Baysan_Tourism_wh_04_51_19_1701147079_8.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_04_51_19_1701147079_8.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_04_51_19_1701147079_8.json', 'expediapackage', '2023-11-28 04:51:20', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:51:26], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:51:26' WHERE id= '158';
[11/28/2023 04:51:31], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:51:31' WHERE id= '158';
[11/28/2023 04:51:44], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:51:44' WHERE id= '158';
[11/28/2023 04:51:44], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701147104','43.239.53.130');
[11/28/2023 04:51:44], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:51:44' WHERE id= '158';
[11/28/2023 04:51:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1003', create_date = '2023-11-28 04:51:45', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '22.07', display_currency_code = 'USD', native_room_rate = '22.07', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/10', check_out_date = '2024/01/11', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'TestJ', leader_last_name = 'demo', status_date = '2023-11-28 04:51:45';
[11/28/2023 04:51:45], [file name :-/home/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 ('90','HOTEL NIRMAL LODGING','Hotel Nirmal Lodging','24458893','OT000874159','mumbai','expediapackage',NOW());
[11/28/2023 04:51:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='90'
		;
[11/28/2023 04:51:45], [file name :-/home/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('90','1003','','1','2','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','1','2024/01/10','2024/01/11','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/28/2023 04:51:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '90', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Double Room, Non Smoking(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Private sale)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:22.07;s:25:"displayNightlyRateDisplay";s:154:"Rate - 22.07,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 2.01 USD, Marketing Fee - 2.01  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:22.18;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:22.07;}}', native_room_rate_total = '22.07', wh_room_rate_total = '22.18', display_room_rate_total = '22.07', number_of_rooms = '1';
[11/28/2023 04:51:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '90', booking_detail_id = '1', rid = '99', room = '0', salutations = 'Mr', first_name = 'TestJ', last_name = 'demo', passenger_type = 'adult', age = '';
[11/28/2023 04:51:45], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '90', booking_detail_id = '1', rid = '99', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 04:51:46], [file name :-/home/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)
                VALUE ('', 'reservation', 'e1p/28_11_2023/request_reservation_Baysan_Tourism_wh_04_51_45_1701147105_12.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_04_51_45_1701147105_12.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_04_51_45_1701147105_12.json', 'expediapackage', '2023-11-28 04:51:46', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:51:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7115375389360', confirmation_number = '7115375389360', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-01-08<br>If you cancel between 2024-01-08 12:30:00 and 2024-01-10 00:00:00 , you will be charged 22.18 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 12:30 on 8th of January 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-01-08 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Private sale,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Private sale,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='22.18',  wh_sub_agent_rate='0',  wh_parent_agent_id='7865',  wh_agent_id='7865',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='22.07',  applicable_service_tax='0',  supplier_rate='22.07',  uid='d9fa48a8f0b3328a39bccfb914431f04'  where id='90';
[11/28/2023 04:51:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='90';
[11/28/2023 04:51:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('90','19.0727','72.8561');
[11/28/2023 04:51:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 04:51:46',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;90\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -90 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 04:51:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='323', `entity`='BookingId', `value`='90' ;
[11/28/2023 04:51:46], [file name :-/home/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 ('1003','90','confirmed','2023-11-28 04:51:46','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 04:51:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('90','2024-01-08 12:30:00','2024-01-08 12:30:00','2024-01-10 00:00:00','2024-01-10 00:00:00','22.07','22.18','0','2023-11-28 04:51:46','22.18');
[11/28/2023 04:51:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='90',status='1' where reservation_id='1003' and booking_id ='0';
[11/28/2023 04:51:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='90' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 04:51:46], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='2.01',  commission_tax='',  booking_id ='90',  supplier_tax='2.36',  supplier_base_fare='19.71',  supplier_commissionable_fare='2.01'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 04:51:46';
[11/28/2023 04:56:34], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:56:34' WHERE id= '159';
[11/28/2023 04:56:42], [file name :-/home/otrams/public_html/beta/flight_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:56:42' WHERE id= '159';
[11/28/2023 04:56:51], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:56:51' WHERE id= '159';
[11/28/2023 04:58:18], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:58:18' WHERE id= '159';
[11/28/2023 04:58:41], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:58:41' WHERE id= '159';
[11/28/2023 04:58:56], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:58:56' WHERE id= '158';
[11/28/2023 04:59:00], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:59:00' WHERE id= '158';
[11/28/2023 04:59:36], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:59:36' WHERE id= '158';
[11/28/2023 04:59:37], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:59:37' WHERE id= '158';
[11/28/2023 04:59:37], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701147577','43.239.53.130');
[11/28/2023 04:59:38], [file name :-/home/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)
                VALUE ('', 'valuation', 'e1p/28_11_2023/request_valuation_Baysan_Tourism_wh_04_59_37_1701147577_87.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_04_59_37_1701147577_87.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_04_59_37_1701147577_87.json', 'expediapackage', '2023-11-28 04:59:38', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:59:46], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:59:46' WHERE id= '158';
[11/28/2023 04:59:46], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:59:46' WHERE id= '158';
[11/28/2023 04:59:55], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:59:55' WHERE id= '158';
[11/28/2023 04:59:55], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/26' , departure_date = '2024/01/27' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 04:59:55' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/28/2023 04:59:55], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:59:55' WHERE id= '158';
[11/28/2023 04:59:56], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_04_59_56_1701147596_44.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_04_59_56_1701147596_44.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_59_56_1701147596_44.json', 'expedia', '2023-11-28 04:59:56', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:59:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:59:56.97'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.102'
            , error_description = ''
            , memory_used = '30641952'
            WHERE id = '14717';
[11/28/2023 04:59:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_04_59_56_1701147596_64.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_04_59_56_1701147596_64.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_59_56_1701147596_64.json', 'expedia', '2023-11-28 04:59:57', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:59:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:59:56.97'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.430'
            , error_description = ''
            , memory_used = '14659464'
            WHERE id = '14718';
[11/28/2023 04:59:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_04_59_56_1701147596_52.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_04_59_56_1701147596_52.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_59_56_1701147596_52.json', 'expediapackage', '2023-11-28 04:59:57', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:59:57], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_04_59_56_1701147596_31.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_04_59_56_1701147596_31.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_04_59_56_1701147596_31.json', 'expediapackage', '2023-11-28 04:59:57', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 04:59:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:59:56.97'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.558'
            , error_description = ''
            , memory_used = '14810120'
            WHERE id = '14719';
[11/28/2023 04:59:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 04:59:56.97'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.772'
            , error_description = ''
            , memory_used = '32131936'
            WHERE id = '14720';
[11/28/2023 04:59:58], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 04:59:58' WHERE id= '158';
