[06/12/2023 01:25:34], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7737' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '3.128.191.50' , city = 'Dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2023/06/21' , departure_date = '2023/06/22' , nights = '1' , nationality = '138' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-06-12 13:25:34' , site_id = '' , country_code = '138' , city_code = '' , ratings = '4.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[06/12/2023 01:25: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/12_06_2023/request_availability_24X7rooms_13_25_34_1686576334_13.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_25_34_1686576334_13.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_25_34_1686576334_13.json', 'expediapackage', '2023-06-12 01:25:36', '', '77371220230613253482600736247', '0');
[06/12/2023 01:25:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=77371220230613253482600736247&xml_user_id=7737&db_caching=1&erequest=0&total_request=1&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-12 13:25:34.155'
            , 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 = '3.348'
            , error_description = ''
            , memory_used = '89719928'
            WHERE id = '273';
[06/12/2023 01:25:37], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_search_24X7rooms_13_25_37_1686576337_2158642.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_search_24X7rooms_13_25_37_1686576337_2158642.txt','7737','77371220230613253482600736247','0','2023-06-12 13:25:34','2023-06-12 13:25:37','hotel_search','','','3','0');
[06/12/2023 01:27:30], [file name :-/home/otrams/public_html/beta/ws/index.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/12_06_2023/request_valuation_24X7rooms_13_27_29_1686576449_54.json', 'e1p/12_06_2023/response_valuation_24X7rooms_13_27_29_1686576449_54.json', 'e1p/12_06_2023/response_header_valuation_24X7rooms_13_27_29_1686576449_54.json', 'expediapackage', '2023-06-12 01:27:30', '', '77371220230613253482600736247', '0');
[06/12/2023 01:27:30], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_cancellation_policy_24X7rooms_13_27_30_1686576450_1_906456-91_91681_7369256.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_cancellation_policy_24X7rooms_13_27_30_1686576450_1_906456-91_91681_7369256.txt','7737','77371220230613253482600736247','0','2023-06-12 13:27:29','2023-06-12 13:27:30','hotel_cancellation_policy','','','1','');
[06/12/2023 01:29:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= '24X7 Rooms',other_language_agency_name= '',accounting_name= '',first_name= 'Bhargavi',middle_name= '',last_name= 'Pise',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '500000.000',credit_limit= '500000.000',credit_distribution= '0',temp_credit_limit= '',address= 'Dubai',other_language_address= '',city= '71649',pincode= '400055',country= '138',time_zone_offset= '-12',enable_dst= '',branch_id='1',phone= '91-9854425422440',mobile= '91-98354534524',fax= '',currency= '608',email= 'bhargavi.pise@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '',can_voucher= '',allow_book_under_cancellation='0',modify_date='2023-06-12 13:29:27',consultant_id= 'b2btravel',agency_email= '',acc_name= 'BHARGAVI',acc_email= 'bhargavi.pise@qtechsoftware.com',acc_phone= '9854425422435',man_name= 'BHARGAVI',man_email= 'bhargavi.pise@qtechsoftware.com',man_phone= '9854425422435',res_name= 'BHARGAVI',res_email= 'bhargavi.pise@qtechsoftware.com',res_phone= '9854425422435',remarks= '',apply_service_tax= 'no',allow_ticketing= '',allow_credit_use= '' WHERE id= '7737';
[06/12/2023 01:29:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2023-06-12 13:29:27',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;24X7 Rooms\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Bhargavi\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Pise\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;500000.000\&#039;,credit_limit= \&#039;500000.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;Dubai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;71649\&#039;,pincode= \&#039;400055\&#039;,country= \&#039;138\&#039;,time_zone_offset= \&#039;-12\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;91-9854425422440\&#039;,mobile= \&#039;91-98354534524\&#039;,fax= \&#039;\&#039;,currency= \&#039;608\&#039;,email= \&#039;bhargavi.pise@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= 0,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= ,can_voucher= ,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2023-06-12 13:29:27\&#039;,consultant_id= \&#039;b2btravel\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;BHARGAVI\&#039;,acc_email= \&#039;bhargavi.pise@qtechsoftware.com\&#039;,acc_phone= \&#039;9854425422435\&#039;,man_name= \&#039;BHARGAVI\&#039;,man_email= \&#039;bhargavi.pise@qtechsoftware.com\&#039;,man_phone= \&#039;9854425422435\&#039;,res_name= \&#039;BHARGAVI\&#039;,res_email= \&#039;bhargavi.pise@qtechsoftware.com\&#039;,res_phone= \&#039;9854425422435\&#039;,remarks= ,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,allow_credit_use= 0 WHERE id= \&#039;7737\&#039;',`log_description`= 'Agent 7737 updated For  - time_zone_offset=&phone=91-9.85442542244E%2B12&modify_date=0000-00-00+00%3A00%3A00&can_voucher=1&consultant_id=Bawadi_sandbox&allow_book_under_cancellation=1&man_name=Bhargavi&allow_credit_use=1 changed to - time_zone_offset=-12&phone=91-9854425422440&modify_date=2023-06-12+13%3A29%3A27&can_voucher=&consultant_id=b2btravel&allow_book_under_cancellation=0&man_name=BHARGAVI&allow_credit_use=',`ip`= '43.239.53.130';
[06/12/2023 01:29:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'7737' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[06/12/2023 01:29:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '7737',credit_value= '500000.000',credit_usage= '0.000',credit_limit= '500000.000',receipt_id= '',amount= '',ip='43.239.53.130',user_type='admin',admin_id='v3alpha',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by v3alpha',create_date='2023-06-12 13:06:27';
[06/12/2023 01:29:27], [file name :-/home/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '608',branch_id= '1',consultant_id= 'b2btravel',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '7737';
[06/12/2023 01:30:36], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_reservation_24X7rooms_13_30_36_1686576636_6117120.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_reservation_24X7rooms_13_30_36_1686576636_6117120.txt','7737','77371220230613253482600736247','0','2023-06-12 13:30:36','2023-06-12 13:30:36','hotel_reservation','Booking cannot be confirmed as there is a price change.','','0','');
[06/12/2023 01:30:36], [file name :-/home/otrams/public_html/beta/ws/index.php],update ws_logs set booking_id='0' where search_unique_id='77371220230613253482600736247';
[06/12/2023 01:31:48], [file name :-/home/otrams/public_html/beta/ws/index.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/12_06_2023/request_valuation_24X7rooms_13_31_47_1686576707_11.json', 'e1p/12_06_2023/response_valuation_24X7rooms_13_31_47_1686576707_11.json', 'e1p/12_06_2023/response_header_valuation_24X7rooms_13_31_47_1686576707_11.json', 'expediapackage', '2023-06-12 01:31:48', '', '77371220230613253482600736247', '0');
[06/12/2023 01:31:48], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_cancellation_policy_24X7rooms_13_31_48_1686576708_1_8836227-113_50498_7358117.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_cancellation_policy_24X7rooms_13_31_48_1686576708_1_8836227-113_50498_7358117.txt','7737','77371220230613253482600736247','0','2023-06-12 13:31:47','2023-06-12 13:31:48','hotel_cancellation_policy','You cannot proceed with the booking as you do not have the booking rights within cancellation policy.','','1','');
[06/12/2023 01:31:54], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog//12_06_2023/request_hotel_cancellation_policy__13_31_54_1686576714__6190596.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog//12_06_2023/response_hotel_cancellation_policy__13_31_54_1686576714__6190596.txt','','','0','2023-06-12 13:31:54','2023-06-12 13:31:54','hotel_cancellation_policy','Username and Password must Required ','','0','');
[06/12/2023 01:32:00], [file name :-/home/otrams/public_html/beta/ws/index.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/12_06_2023/request_valuation_24X7rooms_13_32_00_1686576720_53.json', 'e1p/12_06_2023/response_valuation_24X7rooms_13_32_00_1686576720_53.json', 'e1p/12_06_2023/response_header_valuation_24X7rooms_13_32_00_1686576720_53.json', 'expediapackage', '2023-06-12 01:32:00', '', '77371220230613253482600736247', '0');
[06/12/2023 01:32:00], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_cancellation_policy_24X7rooms_13_32_00_1686576720_1_8836227-113_50498_2370325.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_cancellation_policy_24X7rooms_13_32_00_1686576720_1_8836227-113_50498_2370325.txt','7737','77371220230613253482600736247','0','2023-06-12 13:32:00','2023-06-12 13:32:00','hotel_cancellation_policy','You cannot proceed with the booking as you do not have the booking rights within cancellation policy.','','0','');
[06/12/2023 01:32:30], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog//12_06_2023/request_hotel_cancellation_policy__13_32_30_1686576750_1_27507087-16_80367_9910173.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog//12_06_2023/response_hotel_cancellation_policy__13_32_30_1686576750_1_27507087-16_80367_9910173.txt','','','0','2023-06-12 13:32:30','2023-06-12 13:32:30','hotel_cancellation_policy','Username and Password must Required ','','0','');
[06/12/2023 01:33:00], [file name :-/home/otrams/public_html/beta/ws/index.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/12_06_2023/request_valuation_24X7rooms_13_32_59_1686576779_43.json', 'e1p/12_06_2023/response_valuation_24X7rooms_13_32_59_1686576779_43.json', 'e1p/12_06_2023/response_header_valuation_24X7rooms_13_32_59_1686576779_43.json', 'expediapackage', '2023-06-12 01:33:00', '', '77371220230613253482600736247', '0');
[06/12/2023 01:33:00], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_cancellation_policy_24X7rooms_13_33_00_1686576780_1_27507087-16_80367_9013991.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_cancellation_policy_24X7rooms_13_33_00_1686576780_1_27507087-16_80367_9013991.txt','7737','77371220230613253482600736247','0','2023-06-12 13:32:59','2023-06-12 13:33:00','hotel_cancellation_policy','','','1','');
[06/12/2023 01:34:50], [file name :-/home/otrams/public_html/beta/ws/index.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/12_06_2023/request_valuation_24X7rooms_13_34_49_1686576889_65.json', 'e1p/12_06_2023/response_valuation_24X7rooms_13_34_49_1686576889_65.json', 'e1p/12_06_2023/response_header_valuation_24X7rooms_13_34_49_1686576889_65.json', 'expediapackage', '2023-06-12 01:34:50', '', '77371220230613253482600736247', '0');
[06/12/2023 01:34:50], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_cancellation_policy_24X7rooms_13_34_50_1686576890_1_27507087-16_80367_9005182.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_cancellation_policy_24X7rooms_13_34_50_1686576890_1_27507087-16_80367_9005182.txt','7737','77371220230613253482600736247','0','2023-06-12 13:34:49','2023-06-12 13:34:50','hotel_cancellation_policy','','','1','');
[06/12/2023 01:35:45], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_reservation_24X7rooms_13_35_45_1686576945_5200511.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_reservation_24X7rooms_13_35_45_1686576945_5200511.txt','7737','77371220230613253482600736247','0','2023-06-12 13:35:45','2023-06-12 13:35:45','hotel_reservation','Booking cannot be confirmed as there is a price change.','','0','');
[06/12/2023 01:35:45], [file name :-/home/otrams/public_html/beta/ws/index.php],update ws_logs set booking_id='0' where search_unique_id='77371220230613253482600736247';
[06/12/2023 01:36:03], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-06-12 01:36:03',login_attempt=0 where id = '7737';
[06/12/2023 01:36:03], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = '24X7rooms', user_type = 'A', branch_id = '1', login_datetime = '2023-06-12 13:36:03', ip = '43.239.53.130', action = 'Login' ;
[06/12/2023 01:36:03], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7737', session_id='27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c',create_date='2023-06-12 01:36:03', update_date='2023-06-12 01:36:03',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[06/12/2023 01:36:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:36:08' WHERE id= '22';
[06/12/2023 01:36:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:36:12' WHERE id= '22';
[06/12/2023 01:36:12], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7737' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2023/06/28' , departure_date = '2023/06/29' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-06-12 13:36:12' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[06/12/2023 01:36:13], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:36:13' WHERE id= '22';
[06/12/2023 01:36:14], [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/12_06_2023/request_availability_24X7rooms_13_36_14_1686576974_4.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_36_14_1686576974_4.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_36_14_1686576974_4.json', 'expediapackage', '2023-06-12 01:36:14', '', '27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c', '0');
[06/12/2023 01:36:14], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c&xml_user_id=7737&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F114.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2023-06-12 13:36:14.40'
            , 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.861'
            , error_description = ''
            , memory_used = '9250560'
            WHERE id = '279';
[06/12/2023 01:36:16], [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/12_06_2023/request_availability_24X7rooms_13_36_14_1686576974_97.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_36_14_1686576974_97.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_36_14_1686576974_97.json', 'expediapackage', '2023-06-12 01:36:16', '', '27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c', '0');
[06/12/2023 01:36:16], [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/12_06_2023/request_availability_24X7rooms_13_36_14_1686576974_76.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_36_14_1686576974_76.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_36_14_1686576974_76.json', 'expediapackage', '2023-06-12 01:36:16', '', '27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c', '0');
[06/12/2023 01:36:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c&xml_user_id=7737&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F114.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2023-06-12 13:36:14.41'
            , 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 = '3.171'
            , error_description = ''
            , memory_used = '46525752'
            WHERE id = '280';
[06/12/2023 01:36:17], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c&xml_user_id=7737&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F114.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2023-06-12 13:36:14.40'
            , 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 = '3.195'
            , error_description = ''
            , memory_used = '54511120'
            WHERE id = '281';
[06/12/2023 01:36:17], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:36:17' WHERE id= '22';
[06/12/2023 01:36:32], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:36:32' WHERE id= '22';
[06/12/2023 01:36:33], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:36:33' WHERE id= '22';
[06/12/2023 01:36:33], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1686576993','43.239.53.130');
[06/12/2023 01:36:33], [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/12_06_2023/request_valuation_24X7rooms_13_36_33_1686576993_79.json', 'e1p/12_06_2023/response_valuation_24X7rooms_13_36_33_1686576993_79.json', 'e1p/12_06_2023/response_header_valuation_24X7rooms_13_36_33_1686576993_79.json', 'expediapackage', '2023-06-12 01:36:33', '', '27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c', '0');
[06/12/2023 01:36:33], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Must Sea Hotel Kata', 'phuket', '136', '7737', '', '1', '', 'hotelcancellationpolicy', '2023-06-12 :13:36:33','');
[06/12/2023 01:36:49], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:36:49' WHERE id= '22';
[06/12/2023 01:36:49], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7737' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2023/06/13' , departure_date = '2023/06/14' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-06-12 13:36:49' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[06/12/2023 01:36:49], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:36:49' WHERE id= '22';
[06/12/2023 01:36:50], [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/12_06_2023/request_availability_24X7rooms_13_36_49_1686577009_93.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_36_49_1686577009_93.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_36_49_1686577009_93.json', 'expediapackage', '2023-06-12 01:36:50', '', '27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c', '0');
[06/12/2023 01:36:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c&xml_user_id=7737&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F114.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2023-06-12 13:36:49.970'
            , 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.667'
            , error_description = ''
            , memory_used = '8202248'
            WHERE id = '283';
[06/12/2023 01:36:51], [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/12_06_2023/request_availability_24X7rooms_13_36_49_1686577009_71.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_36_49_1686577009_71.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_36_49_1686577009_71.json', 'expediapackage', '2023-06-12 01:36:51', '', '27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c', '0');
[06/12/2023 01:36:51], [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/12_06_2023/request_availability_24X7rooms_13_36_49_1686577009_17.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_36_49_1686577009_17.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_36_49_1686577009_17.json', 'expediapackage', '2023-06-12 01:36:51', '', '27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c', '0');
[06/12/2023 01:36:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c&xml_user_id=7737&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F114.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2023-06-12 13:36:49.968'
            , 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.860'
            , error_description = ''
            , memory_used = '54188512'
            WHERE id = '285';
[06/12/2023 01:36:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c&xml_user_id=7737&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F114.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=138'
            , http_hit_time = '2023-06-12 13:36:49.968'
            , 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.956'
            , error_description = ''
            , memory_used = '46082112'
            WHERE id = '284';
[06/12/2023 01:36:52], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:36:52' WHERE id= '22';
[06/12/2023 01:36:58], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:36:58' WHERE id= '22';
[06/12/2023 01:36:58], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:36:58' WHERE id= '22';
[06/12/2023 01:36:58], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1686577018','43.239.53.130');
[06/12/2023 01:36:58], [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/12_06_2023/request_valuation_24X7rooms_13_36_58_1686577018_59.json', 'e1p/12_06_2023/response_valuation_24X7rooms_13_36_58_1686577018_59.json', 'e1p/12_06_2023/response_header_valuation_24X7rooms_13_36_58_1686577018_59.json', 'expediapackage', '2023-06-12 01:36:58', '', '27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c', '0');
[06/12/2023 01:36:58], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Must Sea Hotel Kata', 'phuket', '136', '7737', '', '1', '', 'hotelcancellationpolicy', '2023-06-12 :13:36:58','');
[06/12/2023 01:37:05], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:37:05' WHERE id= '22';
[06/12/2023 01:37:05], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-06-12 01:37:05' WHERE id= '22';
[06/12/2023 01:37:05], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1686577025','43.239.53.130');
[06/12/2023 01:37:05], [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/12_06_2023/request_valuation_24X7rooms_13_37_05_1686577025_11.json', 'e1p/12_06_2023/response_valuation_24X7rooms_13_37_05_1686577025_11.json', 'e1p/12_06_2023/response_header_valuation_24X7rooms_13_37_05_1686577025_11.json', 'expediapackage', '2023-06-12 01:37:05', '', '27bfe02639ddc25dc01e24d6f4e79ed742c0623f7b5bb6347a99be59c87e326c', '0');
[06/12/2023 01:37:05], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Must Sea Hotel Kata', 'phuket', '136', '7737', '', '1', '', 'hotelcancellationpolicy', '2023-06-12 :13:37:05','');
[06/12/2023 01:38:26], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7737' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '3.128.191.50' , city = 'Phuket' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2023/06/13' , departure_date = '2023/06/14' , nights = '1' , nationality = '138' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-06-12 13:38:26' , site_id = '' , country_code = '136' , city_code = '' , ratings = '3.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[06/12/2023 01:38:27], [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/12_06_2023/request_availability_24X7rooms_13_38_26_1686577106_86.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_38_26_1686577106_86.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_38_26_1686577106_86.json', 'expediapackage', '2023-06-12 01:38:27', '', '77371220230613382662991943493', '0');
[06/12/2023 01:38:27], [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/12_06_2023/request_availability_24X7rooms_13_38_26_1686577106_41.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_38_26_1686577106_41.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_38_26_1686577106_41.json', 'expediapackage', '2023-06-12 01:38:27', '', '77371220230613382662991943493', '0');
[06/12/2023 01:38:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=77371220230613382662991943493&xml_user_id=7737&db_caching=1&erequest=1&total_request=2&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-12 13:38:26.691'
            , 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.969'
            , error_description = ''
            , memory_used = '11938680'
            WHERE id = '288';
[06/12/2023 01:38:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=77371220230613382662991943493&xml_user_id=7737&db_caching=1&erequest=0&total_request=2&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-12 13:38:26.691'
            , 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.181'
            , error_description = ''
            , memory_used = '25830824'
            WHERE id = '289';
[06/12/2023 01:38:27], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_search_24X7rooms_13_38_27_1686577107_3991683.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_search_24X7rooms_13_38_27_1686577107_3991683.txt','7737','77371220230613382662991943493','0','2023-06-12 13:38:26','2023-06-12 13:38:27','hotel_search','','','1','0');
[06/12/2023 01:39:40], [file name :-/home/otrams/public_html/beta/ws/index.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/12_06_2023/request_valuation_24X7rooms_13_39_39_1686577179_4.json', 'e1p/12_06_2023/response_valuation_24X7rooms_13_39_39_1686577179_4.json', 'e1p/12_06_2023/response_header_valuation_24X7rooms_13_39_39_1686577179_4.json', 'expediapackage', '2023-06-12 01:39:40', '', '77371220230613382662991943493', '0');
[06/12/2023 01:39:40], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_cancellation_policy_24X7rooms_13_39_40_1686577180_1_5483615-105_14726_5210112.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_cancellation_policy_24X7rooms_13_39_40_1686577180_1_5483615-105_14726_5210112.txt','7737','77371220230613382662991943493','0','2023-06-12 13:39:39','2023-06-12 13:39:40','hotel_cancellation_policy','You cannot proceed with the booking as you do not have the booking rights within cancellation policy.','','1','');
[06/12/2023 01:41:08], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_reservation_24X7rooms_13_41_08_1686577268_7034076.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_reservation_24X7rooms_13_41_08_1686577268_7034076.txt','7737','77371220230613382662991943493','0','2023-06-12 13:41:08','2023-06-12 13:41:08','hotel_reservation','Booking cannot be confirmed as there is a price change.','','0','');
[06/12/2023 01:41:08], [file name :-/home/otrams/public_html/beta/ws/index.php],update ws_logs set booking_id='0' where search_unique_id='77371220230613382662991943493';
[06/12/2023 01:42:05], [file name :-/home/otrams/public_html/beta/ws/index.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/12_06_2023/request_valuation_24X7rooms_13_42_05_1686577325_51.json', 'e1p/12_06_2023/response_valuation_24X7rooms_13_42_05_1686577325_51.json', 'e1p/12_06_2023/response_header_valuation_24X7rooms_13_42_05_1686577325_51.json', 'expediapackage', '2023-06-12 01:42:05', '', '77371220230613382662991943493', '0');
[06/12/2023 01:42:05], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_cancellation_policy_24X7rooms_13_42_05_1686577325_1_5483615-105_19226_6754944.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_cancellation_policy_24X7rooms_13_42_05_1686577325_1_5483615-105_19226_6754944.txt','7737','77371220230613382662991943493','0','2023-06-12 13:42:05','2023-06-12 13:42:05','hotel_cancellation_policy','You cannot proceed with the booking as you do not have the booking rights within cancellation policy.','','0','');
[06/12/2023 01:43:15], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_reservation_24X7rooms_13_43_15_1686577395_5479875.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_reservation_24X7rooms_13_43_15_1686577395_5479875.txt','7737','77371220230613382662991943493','0','2023-06-12 13:43:15','2023-06-12 13:43:15','hotel_reservation','Section Unique Id is incorrect or different. Please check Hotel Search Response','','0','');
[06/12/2023 01:43:15], [file name :-/home/otrams/public_html/beta/ws/index.php],update ws_logs set booking_id='0' where search_unique_id='77371220230613382662991943493';
[06/12/2023 01:44:09], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_reservation_24X7rooms_13_44_09_1686577449_1786781.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_reservation_24X7rooms_13_44_09_1686577449_1786781.txt','7737','77371220230613382662991943493','0','2023-06-12 13:44:09','2023-06-12 13:44:09','hotel_reservation','','','0','');
[06/12/2023 01:44:09], [file name :-/home/otrams/public_html/beta/ws/index.php],update ws_logs set booking_id='0' where search_unique_id='77371220230613382662991943493';
[06/12/2023 01:45:01], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_reservation_24X7rooms_13_45_01_1686577501_5246200.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_reservation_24X7rooms_13_45_01_1686577501_5246200.txt','7737','77371220230613382662991943493','0','2023-06-12 13:45:01','2023-06-12 13:45:01','hotel_reservation','Section Unique Id is incorrect or different. Please check Hotel Search Response','','0','');
[06/12/2023 01:45:01], [file name :-/home/otrams/public_html/beta/ws/index.php],update ws_logs set booking_id='0' where search_unique_id='77371220230613382662991943493';
[06/12/2023 01:46:15], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_reservation_24X7rooms_13_46_15_1686577575_4192431.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_reservation_24X7rooms_13_46_15_1686577575_4192431.txt','7737','77371220230613382662991943493','0','2023-06-12 13:46:15','2023-06-12 13:46:15','hotel_reservation','Hotel Id is incorrect or different. Please check Hotel Search Response','','0','');
[06/12/2023 01:46:15], [file name :-/home/otrams/public_html/beta/ws/index.php],update ws_logs set booking_id='0' where search_unique_id='77371220230613382662991943493';
[06/12/2023 01:47:18], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_reservation_24X7rooms_13_47_18_1686577638_5132188.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_reservation_24X7rooms_13_47_18_1686577638_5132188.txt','7737','77371220230613382662991943493','0','2023-06-12 13:47:18','2023-06-12 13:47:18','hotel_reservation','Hotel Id is incorrect or different. Please check Hotel Search Response','','0','');
[06/12/2023 01:47:18], [file name :-/home/otrams/public_html/beta/ws/index.php],update ws_logs set booking_id='0' where search_unique_id='77371220230613382662991943493';
[06/12/2023 01:47:44], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7737' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '3.128.191.50' , city = 'Phuket' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2023/06/13' , departure_date = '2023/06/14' , nights = '1' , nationality = '138' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-06-12 13:47:44' , site_id = '' , country_code = '136' , city_code = '' , ratings = '3.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[06/12/2023 01:47: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/12_06_2023/request_availability_24X7rooms_13_47_44_1686577664_57.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_47_44_1686577664_57.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_47_44_1686577664_57.json', 'expediapackage', '2023-06-12 01:47:45', '', '7737122023061347447302575008', '0');
[06/12/2023 01:47: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/12_06_2023/request_availability_24X7rooms_13_47_44_1686577664_41.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_47_44_1686577664_41.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_47_44_1686577664_41.json', 'expediapackage', '2023-06-12 01:47:45', '', '7737122023061347447302575008', '0');
[06/12/2023 01:47:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7737122023061347447302575008&xml_user_id=7737&db_caching=1&erequest=1&total_request=2&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-12 13:47:44.702'
            , 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.352'
            , error_description = ''
            , memory_used = '11938304'
            WHERE id = '293';
[06/12/2023 01:47:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=7737122023061347447302575008&xml_user_id=7737&db_caching=1&erequest=0&total_request=2&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-12 13:47:44.702'
            , 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.377'
            , error_description = ''
            , memory_used = '25830824'
            WHERE id = '292';
[06/12/2023 01:47:46], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_search_24X7rooms_13_47_46_1686577666_8150098.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_search_24X7rooms_13_47_46_1686577666_8150098.txt','7737','7737122023061347447302575008','0','2023-06-12 13:47:44','2023-06-12 13:47:46','hotel_search','','','2','0');
[06/12/2023 01:48:47], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_reservation_24X7rooms_13_48_47_1686577727_8618511.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_reservation_24X7rooms_13_48_47_1686577727_8618511.txt','7737','7737122023061347447302575008','0','2023-06-12 13:48:47','2023-06-12 13:48:47','hotel_reservation','Hotel Id is incorrect or different. Please check Hotel Search Response','','0','');
[06/12/2023 01:48:47], [file name :-/home/otrams/public_html/beta/ws/index.php],update ws_logs set booking_id='0' where search_unique_id='7737122023061347447302575008';
[06/12/2023 01:49:26], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO agent_logs SET  agent_id = '7737' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '3.128.191.50' , city = 'Bangkok' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2023/06/14' , departure_date = '2023/06/15' , nights = '1' , nationality = '138' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='1' , create_date = '2023-06-12 13:49:26' , site_id = '' , country_code = '136' , city_code = '' , ratings = '3.0' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '1' ;
[06/12/2023 01:49:26], [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/12_06_2023/request_availability_24X7rooms_13_49_26_1686577766_78.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_49_26_1686577766_78.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_49_26_1686577766_78.json', 'expediapackage', '2023-06-12 01:49:26', '', '77371220230613492670796672071', '0');
[06/12/2023 01:49:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=77371220230613492670796672071&xml_user_id=7737&db_caching=1&erequest=4&total_request=5&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-12 13:49:26.727'
            , 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.269'
            , error_description = ''
            , memory_used = '2302248'
            WHERE id = '294';
[06/12/2023 01:49:28], [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/12_06_2023/request_availability_24X7rooms_13_49_26_1686577766_77.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_49_26_1686577766_77.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_49_26_1686577766_77.json', 'expediapackage', '2023-06-12 01:49:28', '', '77371220230613492670796672071', '0');
[06/12/2023 01:49:28], [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/12_06_2023/request_availability_24X7rooms_13_49_26_1686577766_48.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_49_26_1686577766_48.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_49_26_1686577766_48.json', 'expediapackage', '2023-06-12 01:49:28', '', '77371220230613492670796672071', '0');
[06/12/2023 01:49:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=77371220230613492670796672071&xml_user_id=7737&db_caching=1&erequest=2&total_request=5&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-12 13:49:26.727'
            , 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.575'
            , error_description = ''
            , memory_used = '31299688'
            WHERE id = '295';
[06/12/2023 01:49:28], [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/12_06_2023/request_availability_24X7rooms_13_49_26_1686577766_17.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_49_26_1686577766_17.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_49_26_1686577766_17.json', 'expediapackage', '2023-06-12 01:49:28', '', '77371220230613492670796672071', '0');
[06/12/2023 01:49:28], [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/12_06_2023/request_availability_24X7rooms_13_49_26_1686577766_60.json', 'e1p/12_06_2023/response_availability_24X7rooms_13_49_26_1686577766_60.json', 'e1p/12_06_2023/response_header_availability_24X7rooms_13_49_26_1686577766_60.json', 'expediapackage', '2023-06-12 01:49:28', '', '77371220230613492670796672071', '0');
[06/12/2023 01:49:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=77371220230613492670796672071&xml_user_id=7737&db_caching=1&erequest=0&total_request=5&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-12 13:49:26.727'
            , 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.768'
            , error_description = ''
            , memory_used = '37992352'
            WHERE id = '296';
[06/12/2023 01:49:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=77371220230613492670796672071&xml_user_id=7737&db_caching=1&erequest=3&total_request=5&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-12 13:49:26.727'
            , 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.911'
            , error_description = ''
            , memory_used = '23386632'
            WHERE id = '298';
[06/12/2023 01:49:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=77371220230613492670796672071&xml_user_id=7737&db_caching=1&erequest=1&total_request=5&web_service=yes&time_out=24&ip=3.128.191.50&browser=IE&hotels_ids=&expediaRapidApi=&agent_country='
            , http_hit_time = '2023-06-12 13:49:26.726'
            , 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.157'
            , error_description = ''
            , memory_used = '40754936'
            WHERE id = '297';
[06/12/2023 01:49:29], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_search_24X7rooms_13_49_29_1686577769_8249694.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_search_24X7rooms_13_49_29_1686577769_8249694.txt','7737','77371220230613492670796672071','0','2023-06-12 13:49:26','2023-06-12 13:49:29','hotel_search','','','3','0');
[06/12/2023 01:50:52], [file name :-/home/otrams/public_html/beta/ws/index.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/12_06_2023/request_valuation_24X7rooms_13_50_52_1686577852_14.json', 'e1p/12_06_2023/response_valuation_24X7rooms_13_50_52_1686577852_14.json', 'e1p/12_06_2023/response_header_valuation_24X7rooms_13_50_52_1686577852_14.json', 'expediapackage', '2023-06-12 01:50:52', '', '77371220230613492670796672071', '0');
[06/12/2023 01:50:52], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_cancellation_policy_24X7rooms_13_50_52_1686577852_1_18249874-7_86482_8765766.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_cancellation_policy_24X7rooms_13_50_52_1686577852_1_18249874-7_86482_8765766.txt','7737','77371220230613492670796672071','0','2023-06-12 13:50:52','2023-06-12 13:50:52','hotel_cancellation_policy','You cannot proceed with the booking as you do not have the booking rights within cancellation policy.','','0','');
[06/12/2023 01:52:20], [file name :-/home/otrams/public_html/beta/ws/index.php],INSERT INTO ws_logs(request_path,response_path,userid,search_unique_id,booking_id,log_date_time,end_time,action_type,error_description,error_code,response_time,agent_log_id)
		VALUES('https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/request_hotel_reservation_24X7rooms_13_52_20_1686577940_6726820.txt','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/wslog/24X7rooms/12_06_2023/response_hotel_reservation_24X7rooms_13_52_20_1686577940_6726820.txt','7737','77371220230613492670796672071','0','2023-06-12 13:52:20','2023-06-12 13:52:20','hotel_reservation','You cannot proceed with this booking as you do not have the booking rights within cancellation policy.','','0','');
[06/12/2023 01:52:20], [file name :-/home/otrams/public_html/beta/ws/index.php],update ws_logs set booking_id='0' where search_unique_id='77371220230613492670796672071';
[06/12/2023 01:56:04], [file name :-/home/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '12', login_datetime = '2023-06-12 13:56:04', ip = '205.210.31.7', action = 'Login' ;
