[01/28/2024 12:00:09], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-28 12:00:09',login_attempt=0 where id = '7868';
[01/28/2024 12:00:09], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards', user_type = 'A', branch_id = '1', login_datetime = '2024-01-28 12:00:09', ip = '123.253.233.242', action = 'Login' ;
[01/28/2024 12:00:09], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:00:09' WHERE id= '457';
[01/28/2024 12:00:22], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:00:22' WHERE id= '457';
[01/28/2024 12:00:24], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:00:24' WHERE id= '457';
[01/28/2024 12:00:35], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:00:35' WHERE id= '457';
[01/28/2024 12:00:40], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:00:40' WHERE id= '457';
[01/28/2024 12:00:54], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:00:54' WHERE id= '457';
[01/28/2024 12:00:54], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/28/2024 12:00:54], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:00:54' WHERE id= '457';
[01/28/2024 12:00:54], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:00:54' WHERE id= '457';
[01/28/2024 12:01:02], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:01:02' WHERE id= '457';
[01/28/2024 12:01:02], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/28/2024 12:01:02], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:01:02' WHERE id= '457';
[01/28/2024 12:01:02], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:01:02' WHERE id= '457';
[01/28/2024 12:01:11], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:01:11' WHERE id= '457';
[01/28/2024 12:01:21], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:01:21' WHERE id= '457';
[01/28/2024 12:01:21], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '123.253.233.242' , city = 'singapore' , service_name = '' , country_of_residence = '107' , service_type = 'hotel' , arrival_date = '2024/02/10' , departure_date = '2024/02/12' , nights = '2' , nationality = '107' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-01-28 12:01:21' , site_id = '21' , country_code = '130' , city_code = '70983' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/28/2024 12:01:21], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:01:21' WHERE id= '457';
[01/28/2024 12:01:22], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:01:22' WHERE id= '457';
[01/28/2024 12:01:30], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:01:30' WHERE id= '457';
[01/28/2024 12:01:43], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:01:43' WHERE id= '457';
[01/28/2024 12:07:35], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-28 12:07:35',login_attempt=0 where id = '7868';
[01/28/2024 12:07:35], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'hotelyards', user_type = 'A', branch_id = '1', login_datetime = '2024-01-28 12:07:35', ip = '123.253.233.242', action = 'Login' ;
[01/28/2024 12:07:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='123.253.233.242', agent_id='7842', session_id='7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98',create_date='2024-01-28 12:07:35', update_date='2024-01-28 12:07:35',domain='straightline.astrabookings.com',sub_agent_id='',sub_user_id='';
[01/28/2024 12:07:41], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:07:41' WHERE id= '459';
[01/28/2024 12:07:41], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:07:41' WHERE id= '459';
[01/28/2024 12:07:41], [file name :-/home/otrams/public_html/beta/ajax/ajax_child_structure.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:07:41' WHERE id= '459';
[01/28/2024 12:07:48], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:07:48' WHERE id= '459';
[01/28/2024 12:07:54], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:07:54' WHERE id= '459';
[01/28/2024 12:07:55], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '123.253.233.242' , city = 'surabaya' , service_name = '' , country_of_residence = 'default' , service_type = 'hotel' , arrival_date = '2024/02/09' , departure_date = '2024/02/10' , nights = '1' , nationality = '107' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-28 12:07:55' , site_id = '21' , country_code = '107' , city_code = '67327' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/28/2024 12:07:55], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:07:55' WHERE id= '459';
[01/28/2024 12:07: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_01_2024/request_availability_straightline_wh_12_07_55_1706443675_81.json', 'e1/28_01_2024/response_availability_straightline_wh_12_07_55_1706443675_81.json', 'e1/28_01_2024/response_header_availability_straightline_wh_12_07_55_1706443675_81.json', 'expedia', '2024-01-28 12:07:56', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:07:56], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=1&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:07:55.485'
            , 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.145'
            , error_description = ''
            , memory_used = '23041480'
            WHERE id = '30014';
[01/28/2024 12:07: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_01_2024/request_availability_straightline_wh_12_07_55_1706443675_86.json', 'e1p/28_01_2024/response_availability_straightline_wh_12_07_55_1706443675_86.json', 'e1p/28_01_2024/response_header_availability_straightline_wh_12_07_55_1706443675_86.json', 'expediapackage', '2024-01-28 12:07:57', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:07:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=1&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:07:55.485'
            , 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.727'
            , error_description = ''
            , memory_used = '24561968'
            WHERE id = '30015';
[01/28/2024 12:07:57], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:07:57' WHERE id= '459';
[01/28/2024 12:08:08], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:08:08' WHERE id= '459';
[01/28/2024 12:08:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:08:09' WHERE id= '459';
[01/28/2024 12:08:18], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:08:18' WHERE id= '459';
[01/28/2024 12:08:20], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:08:20' WHERE id= '459';
[01/28/2024 12:08:25], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:08:25' WHERE id= '459';
[01/28/2024 12:08:28], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:08:28' WHERE id= '459';
[01/28/2024 12:08:28], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/28/2024 12:08:28], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:08:28' WHERE id= '459';
[01/28/2024 12:08:28], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:08:28' WHERE id= '459';
[01/28/2024 12:08:43], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:08:43' WHERE id= '459';
[01/28/2024 12:08:43], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '123.253.233.242' , city = 'surabaya' , service_name = '' , country_of_residence = '107' , service_type = 'hotel' , arrival_date = '2024/02/09' , departure_date = '2024/02/10' , nights = '1' , nationality = '107' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-28 12:08:43' , site_id = '21' , country_code = '107' , city_code = '67327' , ratings = '1.0,2.0,3.0,4.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/28/2024 12:08:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:08:44' WHERE id= '459';
[01/28/2024 12:08:44], [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_01_2024/request_availability_straightline_wh_12_08_44_1706443724_86.json', 'e1/28_01_2024/response_availability_straightline_wh_12_08_44_1706443724_86.json', 'e1/28_01_2024/response_header_availability_straightline_wh_12_08_44_1706443724_86.json', 'expedia', '2024-01-28 12:08:44', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:08:44], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=1&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:08:44.100'
            , 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.832'
            , error_description = ''
            , memory_used = '18763944'
            WHERE id = '30016';
[01/28/2024 12:08:45], [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_01_2024/request_availability_straightline_wh_12_08_44_1706443724_76.json', 'e1p/28_01_2024/response_availability_straightline_wh_12_08_44_1706443724_76.json', 'e1p/28_01_2024/response_header_availability_straightline_wh_12_08_44_1706443724_76.json', 'expediapackage', '2024-01-28 12:08:45', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:08:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=1&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:08:44.101'
            , 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.244'
            , error_description = ''
            , memory_used = '20025600'
            WHERE id = '30017';
[01/28/2024 12:08:45], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:08:45' WHERE id= '459';
[01/28/2024 12:10:20], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:10:20' WHERE id= '459';
[01/28/2024 12:10:25], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:10:25' WHERE id= '459';
[01/28/2024 12:10:26], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:10:26' WHERE id= '459';
[01/28/2024 12:10:33], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:10:33' WHERE id= '459';
[01/28/2024 12:10:33], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7868' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '123.253.233.242' , city = 'jakarta' , service_name = '' , country_of_residence = '107' , service_type = 'hotel' , arrival_date = '2024/02/02' , departure_date = '2024/02/04' , nights = '2' , nationality = '107' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-01-28 12:10:33' , site_id = '21' , country_code = '107' , city_code = '67326' , ratings = '1.0,2.0,3.0,4.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[01/28/2024 12:10:33], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:10:33' WHERE id= '459';
[01/28/2024 12:10:34], [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_01_2024/request_availability_straightline_wh_12_10_34_1706443834_55.json', 'e1p/28_01_2024/response_availability_straightline_wh_12_10_34_1706443834_55.json', 'e1p/28_01_2024/response_header_availability_straightline_wh_12_10_34_1706443834_55.json', 'expediapackage', '2024-01-28 12:10:34', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:10:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=4&total_request=5&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:10:34.225'
            , 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.379'
            , error_description = ''
            , memory_used = '2342384'
            WHERE id = '30018';
[01/28/2024 12:10:34], [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_01_2024/request_availability_straightline_wh_12_10_34_1706443834_32.json', 'e1/28_01_2024/response_availability_straightline_wh_12_10_34_1706443834_32.json', 'e1/28_01_2024/response_header_availability_straightline_wh_12_10_34_1706443834_32.json', 'expedia', '2024-01-28 12:10:34', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:10:34], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=3&total_request=5&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:10:34.225'
            , 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.760'
            , error_description = ''
            , memory_used = '8465560'
            WHERE id = '30019';
[01/28/2024 12:10:35], [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_01_2024/request_availability_straightline_wh_12_10_34_1706443834_30.json', 'e1/28_01_2024/response_availability_straightline_wh_12_10_34_1706443834_30.json', 'e1/28_01_2024/response_header_availability_straightline_wh_12_10_34_1706443834_30.json', 'expedia', '2024-01-28 12:10:35', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:10:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=4&total_request=5&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:10:34.225'
            , 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.843'
            , error_description = ''
            , memory_used = '2341040'
            WHERE id = '30020';
[01/28/2024 12:10:35], [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_01_2024/request_availability_straightline_wh_12_10_34_1706443834_9.json', 'e1p/28_01_2024/response_availability_straightline_wh_12_10_34_1706443834_9.json', 'e1p/28_01_2024/response_header_availability_straightline_wh_12_10_34_1706443834_9.json', 'expediapackage', '2024-01-28 12:10:35', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:10:35], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=3&total_request=5&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:10:34.225'
            , 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.271'
            , error_description = ''
            , memory_used = '8791304'
            WHERE id = '30021';
[01/28/2024 12:10:35], [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_01_2024/request_availability_straightline_wh_12_10_34_1706443834_37.json', 'e1/28_01_2024/response_availability_straightline_wh_12_10_34_1706443834_37.json', 'e1/28_01_2024/response_header_availability_straightline_wh_12_10_34_1706443834_37.json', 'expedia', '2024-01-28 12:10:35', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:10:35], [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_01_2024/request_availability_straightline_wh_12_10_34_1706443834_5.json', 'e1p/28_01_2024/response_availability_straightline_wh_12_10_34_1706443834_5.json', 'e1p/28_01_2024/response_header_availability_straightline_wh_12_10_34_1706443834_5.json', 'expediapackage', '2024-01-28 12:10:35', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:10:35], [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_01_2024/request_availability_straightline_wh_12_10_34_1706443834_52.json', 'e1/28_01_2024/response_availability_straightline_wh_12_10_34_1706443834_52.json', 'e1/28_01_2024/response_header_availability_straightline_wh_12_10_34_1706443834_52.json', 'expedia', '2024-01-28 12:10:35', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:10:36], [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_01_2024/request_availability_straightline_wh_12_10_34_1706443834_86.json', 'e1/28_01_2024/response_availability_straightline_wh_12_10_34_1706443834_86.json', 'e1/28_01_2024/response_header_availability_straightline_wh_12_10_34_1706443834_86.json', 'expedia', '2024-01-28 12:10:36', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:10:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=2&total_request=5&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:10:34.225'
            , 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.913'
            , error_description = ''
            , memory_used = '38078008'
            WHERE id = '30023';
[01/28/2024 12:10:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=2&total_request=5&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:10:34.225'
            , 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.946'
            , error_description = ''
            , memory_used = '36048720'
            WHERE id = '30022';
[01/28/2024 12:10:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=5&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:10:34.225'
            , 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 = '2.084'
            , error_description = ''
            , memory_used = '28772016'
            WHERE id = '30025';
[01/28/2024 12:10:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=1&total_request=5&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:10:34.225'
            , 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 = '2.091'
            , error_description = ''
            , memory_used = '34838128'
            WHERE id = '30024';
[01/28/2024 12:10:36], [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_01_2024/request_availability_straightline_wh_12_10_34_1706443834_80.json', 'e1p/28_01_2024/response_availability_straightline_wh_12_10_34_1706443834_80.json', 'e1p/28_01_2024/response_header_availability_straightline_wh_12_10_34_1706443834_80.json', 'expediapackage', '2024-01-28 12:10:36', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:10:36], [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_01_2024/request_availability_straightline_wh_12_10_34_1706443834_64.json', 'e1p/28_01_2024/response_availability_straightline_wh_12_10_34_1706443834_64.json', 'e1p/28_01_2024/response_header_availability_straightline_wh_12_10_34_1706443834_64.json', 'expediapackage', '2024-01-28 12:10:36', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:10:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=1&total_request=5&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:10:34.225'
            , 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 = '2.382'
            , error_description = ''
            , memory_used = '36653992'
            WHERE id = '30026';
[01/28/2024 12:10:36], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98&xml_user_id=7842&db_caching=1&erequest=0&total_request=5&web_service=no&ip=123.253.233.242&browser=GoogleChrome%2F120.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2024-01-28 12:10:34.225'
            , 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 = '2.387'
            , error_description = ''
            , memory_used = '30554728'
            WHERE id = '30027';
[01/28/2024 12:10:37], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:10:37' WHERE id= '459';
[01/28/2024 12:11:31], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:11:31' WHERE id= '459';
[01/28/2024 12:11:31], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:11:31' WHERE id= '459';
[01/28/2024 12:11:31], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706443891','123.253.233.242');
[01/28/2024 12:11:32], [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_01_2024/request_valuation_straightline_wh_12_11_31_1706443891_43.json', 'e1p/28_01_2024/response_valuation_straightline_wh_12_11_31_1706443891_43.json', 'e1p/28_01_2024/response_header_valuation_straightline_wh_12_11_31_1706443891_43.json', 'expediapackage', '2024-01-28 12:11:32', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:11:52], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:11:52' WHERE id= '459';
[01/28/2024 12:11:52], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1706443912','123.253.233.242');
[01/28/2024 12:11:54], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:11:54' WHERE id= '459';
[01/28/2024 12:11:54], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '2326', create_date = '2024-01-28 12:11:54', agent_id = '7842', parent_agent_id = '7842', agent_ref_no = '', nationality = 'Indonesian', city_id = 'jakarta', country_id = '107', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '354.3', display_currency_code = 'USD', native_room_rate = '354.3', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/02/02', check_out_date = '2024/02/04', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Ahmad', leader_last_name = 'Baehaki', status_date = '2024-01-28 12:11:54';
[01/28/2024 12:11:54], [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 ('368','AVIARY HOTEL BINTARO','Aviary Bintaro - CHSE Certified','17864650','OT000716951','jakarta','expediapackage',NOW());
[01/28/2024 12:11:54], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='368'
		;
[01/28/2024 12:11:54], [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('368','2326','','1','1','0','-','','','17864650','Aviary Bintaro - CHSE Certified','CBD Bintaro Sektor 7, Block B7 No. D3-3A, Jalan HR Rasuna Said','+622180828384','3.0','2','2024/02/02','2024/02/04','','https://straightline.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzE4MDAwMDAwLzE3ODcwMDAwLzE3ODY0NzAwLzE3ODY0NjUwLzQ3ODE5ODk0X2IuanBn');
[01/28/2024 12:11:54], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '368', booking_detail_id = '1', room_type_code = '', room_name = 'single', room_type_description = 'KingBed OR TwinBed Executive Suite, 2 Bedrooms(Free breakfast)- <font color=\'red\'>Package Deal</font> <br>(1 King Bed and 1 Twin Bed)', display_nightly_rates = 'a:2:{i:0;a:3:{s:18:"displayNightlyRate";d:177.15000000000001;s:25:"displayNightlyRateDisplay";s:157:"Rate - 177.15,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 12.75 USD, Marketing Fee - 12.75  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:178.03999999999999;}i:1;a:3:{s:18:"displayNightlyRate";d:177.15000000000001;s:25:"displayNightlyRateDisplay";s:157:"Rate - 177.15,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 12.75 USD, Marketing Fee - 12.75  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:178.03999999999999;}}', native_nightly_rates = 'a:2:{i:0;a:1:{s:17:"nativeNightlyRate";d:177.15000000000001;}i:1;a:1:{s:17:"nativeNightlyRate";d:177.15000000000001;}}', native_room_rate_total = '354.3', wh_room_rate_total = '356.08', display_room_rate_total = '354.3', number_of_rooms = '1';
[01/28/2024 12:11:54], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '368', booking_detail_id = '1', rid = '172', room = '0', salutations = 'Mr', first_name = 'Ahmad', last_name = 'Baehaki', passenger_type = 'adult', age = '';
[01/28/2024 12:11:55], [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_01_2024/request_reservation_straightline_wh_12_11_54_1706443914_73.json', 'e1p/28_01_2024/response_reservation_straightline_wh_12_11_54_1706443914_73.json', 'e1p/28_01_2024/response_header_reservation_straightline_wh_12_11_54_1706443914_73.json', 'expediapackage', '2024-01-28 12:11:55', '', '7bc96d053c8222c9dea2c1f314ab9cb17afa914c93518ba98af2ed370315ca98', '0');
[01/28/2024 12:11:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7579782412905', confirmation_number = '7579782412905', display_discount = '0', cancellation_policy = 'Free cancellation up to  22:59:59 on  2024-01-30<br>If you cancel between 2024-01-30 23:00:00 and 2024-02-02 00:00:00 , you will be charged 356.07 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 23:00 on 30th 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-31 11:00: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 breakfast, Free self parking, Free WiFi<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 = 'hotelyards', sales_manager_id = '0', admin_booked = '0', email_id = 'shejoh2022@gmail.com', leader_phone = '9883435232', agent_currency_multiplier = '1.00000', ip_addr = '123.253.233.242', 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 breakfast, Free self parking, Free WiFi<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 = '', 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='356.08',  wh_sub_agent_rate='0',  wh_parent_agent_id='7868',  wh_agent_id='7868',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='21',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7842',  sub_agent_rate='0',  agent_rate='354.3',  applicable_service_tax='0',  supplier_rate='354.3',  uid='8e9285291d60f4a7e23d3636e0b65975'  where id='368';
[01/28/2024 12:11:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='368';
[01/28/2024 12:11:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('368','-6.272225','106.71277097');
[01/28/2024 12:11:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'straightline_wh',`create_date`= '2024-01-28 12:11:55',`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;368\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -368 And Booking Status - confirmed',`ip`= '123.253.233.242';
[01/28/2024 12:11:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='658', `entity`='BookingId', `value`='368' ;
[01/28/2024 12:11:55], [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 ('2326','368','confirmed','2024-01-28 12:11:55','Booking confirmed','7842','123.253.233.242','0','7842');
[01/28/2024 12:11:55], [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('368','2024-01-30 23:00:00','2024-01-30 23:00:00','2024-02-02 00:00:00','2024-02-02 00:00:00','354.3','356.07','','2024-01-28 12:11:55','356.07');
[01/28/2024 12:11:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='368',status='1' where reservation_id='2326' and booking_id ='0';
[01/28/2024 12:11:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='368' where agent_logs_id='0' and source_type='expediapackage';
[01/28/2024 12:11:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='25.5',  commission_tax='',  booking_id ='368',  supplier_tax='62.7',  supplier_base_fare='291.6',  supplier_commissionable_fare='25.5'able_fare,  retension='100',  commission_percent='0',  create_date ='2024-01-28 12:11:55';
[01/28/2024 12:11:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('368','deepak.trivedi@qtechsoftware.com');
[01/28/2024 12:11:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('368','rohan.vartak@qtechsoftware.com');
[01/28/2024 12:11:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('368','deepak.trivedi@qtechsoftware.com');
[01/28/2024 12:11:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('368','deepak.trivedi@qtechsoftware.com');
[01/28/2024 12:11:57], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('368','gajendra.rajpurohit@qtechsoftware.com');
[01/28/2024 12:11:57], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('368','email@hotelyards.com');
[01/28/2024 12:11:58], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('368','nisha@qtechsoftware.com');
[01/28/2024 12:13:25], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:13:25' WHERE id= '459';
[01/28/2024 12:13:29], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:13:29' WHERE id= '459';
[01/28/2024 12:14:47], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:14:47' WHERE id= '459';
[01/28/2024 12:14:50], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:14:50' WHERE id= '459';
[01/28/2024 12:14:56], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:14:56' WHERE id= '459';
[01/28/2024 12:14:56], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/28/2024 12:15:35], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:15:35' WHERE id= '459';
[01/28/2024 12:16:55], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:16:55' WHERE id= '459';
[01/28/2024 12:16:55], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/28/2024 12:17:25], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:17:25' WHERE id= '459';
[01/28/2024 12:17:43], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:17:43' WHERE id= '459';
[01/28/2024 12:17:58], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:17:58' WHERE id= '459';
[01/28/2024 12:18:00], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:18:00' WHERE id= '459';
[01/28/2024 12:18:00], [file name :-/home/otrams/public_html/beta/add_voucher.php],update bookings set invoice_number= '2024/00013', voucher_id='HTL00368',status_date='2024-01-28 12:18:00',current_status='vouchered',voucher_hashcode='e4fe8194e84b94534f45ce688e0e60eb94575368',vouchered_by ='' where id='368';
[01/28/2024 12:18:00], [file name :-/home/otrams/public_html/beta/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2024/00014' where id='368' and is_invoiced!='yes';
[01/28/2024 12:18:00], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('354.3'),   credit_value= credit_value-('354.3') ,  cd_credit_usage=cd_credit_usage+('354.3') , cd_credit_value=cd_credit_value-('354.3')  WHERE id = '7842';
[01/28/2024 12:18:00], [file name :-/home/otrams/public_html/beta/add_voucher.php],insert into  agent_credit_log SET agent_id= '7842',credit_value= '996523.810',credit_usage= '3475.190',credit_limit= '999999.000',receipt_id= '',amount= '354.3',booking_id='368',booking_cost= '354.3',receipt_allocation= '',balance= '354.3',ip='123.253.233.242',user_type='User',admin_id='Agent - straightline  (do not use)(CD7842)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-01-28 12:01:00';
[01/28/2024 12:18:00], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE agents  SET credit_usage=credit_usage+('356.08'),   credit_value= credit_value-('356.08') ,  cd_credit_usage=cd_credit_usage+('356.08') , cd_credit_value=cd_credit_value-('356.08')  WHERE id = '7868';
[01/28/2024 12:18:00], [file name :-/home/otrams/public_html/beta/add_voucher.php],insert into  agent_credit_log SET agent_id= '7868',credit_value= '6666169.590',credit_usage= '496.410',credit_limit= '6666666.000',receipt_id= '',amount= '356.08',booking_id='368',booking_cost= '354.3',receipt_allocation= '',balance= '354.3',ip='123.253.233.242',user_type='User',admin_id='Agent - straightline  (do not use)(CD7842)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-01-28 12:01:00';
[01/28/2024 12:18:00], [file name :-/home/otrams/public_html/beta/add_voucher.php], insert into wh_booking_rate_info set  booking_id = '368', booking_log = 'Booking Vouchered', create_date = '2024-01-28 12:18:00', type = 'Sale', agent_price = '356.080', sub_agent_price = '0.000', supplier_price = '354.300';
[01/28/2024 12:18:00], [file name :-/home/otrams/public_html/beta/add_voucher.php], insert into booking_rate_info set  booking_id = '368', booking_log = 'Booking Vouchered', create_date = '2024-01-28 12:18:00', supplier_currency ='USD', type = 'Sale', agent_price = '354.3', sub_agent_price ='', supplier_price = '354.300', supplier_id = 'expediapackage', supplier_type = 'online';
[01/28/2024 12:18:05], [file name :-/home/otrams/public_html/beta/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','368','vouchered-invoiced','2024-01-28 12:18:05','Booking invoice by user id -7842','7842','123.253.233.242','','','');
[01/28/2024 12:18:05], [file name :-/home/otrams/public_html/beta/add_voucher.php],INSERT INTO agent_commission SET booking_id ='368',booking_detail_id ='368',agent_id ='7842',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='USD',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 0 %',create_date ='2024-01-28 12:18:05';
[01/28/2024 12:18:05], [file name :-/home/otrams/public_html/beta/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','368','vouchered','2024-01-28 12:18:05','Vouchered By Agent7842','7842','123.253.233.242','','','');
[01/28/2024 12:18:06], [file name :-/home/otrams/public_html/beta/add_voucher.php],insert into temp(booking_id,mail_send_to)values('368','gajendra.rajpurohit@qtechsoftware.com');
[01/28/2024 12:18:06], [file name :-/home/otrams/public_html/beta/add_voucher.php],insert into temp(booking_id,mail_send_to)values('368','email@hotelyards.com');
[01/28/2024 12:18:07], [file name :-/home/otrams/public_html/beta/add_voucher.php],insert into temp(booking_id,mail_send_to)values('368','deepak.trivedi@qtechsoftware.com');
[01/28/2024 12:18:07], [file name :-/home/otrams/public_html/beta/add_voucher.php],insert into temp(booking_id,mail_send_to)values('368','rohan.vartak@qtechsoftware.com');
[01/28/2024 12:18:07], [file name :-/home/otrams/public_html/beta/add_voucher.php],insert into temp(booking_id,mail_send_to)values('368','deepak.trivedi@qtechsoftware.com');
[01/28/2024 12:18:07], [file name :-/home/otrams/public_html/beta/add_voucher.php],insert into temp(booking_id,mail_send_to)values('368','deepak.trivedi@qtechsoftware.com');
[01/28/2024 12:18:09], [file name :-/home/otrams/public_html/beta/add_voucher.php],insert into temp(booking_id,mail_send_to)values('368','nisha@qtechsoftware.com');
[01/28/2024 12:18:09], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:18:09' WHERE id= '459';
[01/28/2024 12:18:09], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/28/2024 12:18:36], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:18:36' WHERE id= '459';
[01/28/2024 12:21:07], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:21:07' WHERE id= '459';
[01/28/2024 12:21:49], [file name :-/home/otrams/public_html/beta/print_invoice.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:21:49' WHERE id= '459';
[01/28/2024 12:22:06], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:22:06' WHERE id= '459';
[01/28/2024 12:22:14], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:22:14' WHERE id= '459';
[01/28/2024 12:22:37], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:22:37' WHERE id= '459';
[01/28/2024 12:22:44], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:22:44' WHERE id= '459';
[01/28/2024 12:23:00], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:23:00' WHERE id= '459';
[01/28/2024 12:23:00], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/28/2024 12:23:32], [file name :-/home/otrams/public_html/beta/booking_request.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:23:32' WHERE id= '459';
[01/28/2024 12:23:42], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:23:42' WHERE id= '459';
[01/28/2024 12:26:06], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:26:06' WHERE id= '459';
[01/28/2024 12:26:06], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/28/2024 12:26:13], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:26:13' WHERE id= '459';
[01/28/2024 12:26:16], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:26:16' WHERE id= '459';
[01/28/2024 12:26:23], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:26:23' WHERE id= '459';
[01/28/2024 12:26:23], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/28/2024 12:27:24], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:27:24' WHERE id= '459';
[01/28/2024 12:48:29], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:48:29' WHERE id= '459';
[01/28/2024 12:48:29], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[01/28/2024 12:48:37], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:48:37' WHERE id= '459';
[01/28/2024 12:51:49], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:51:49' WHERE id= '459';
[01/28/2024 12:52:11], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-28 12:52:11' WHERE id= '459';
[01/28/2024 12:52:11], [file name :-/home/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
