[10/02/2024 06:00:14], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727848814','43.239.53.130');
[10/02/2024 06:00:14], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/02_10_2024/request_valuation_Test_DoNotUse_06_00_14_1727848814_.json', 'a5/02_10_2024/response_valuation_Test_DoNotUse_06_00_14_1727848814_.json', 'a5/02_10_2024/response_header_valuation_Test_DoNotUse_06_00_14_1727848814_.json', 'agoda', '2024-10-02 06:00:14', '', '10890220241005593923780868675', '16645286', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/02_10_2024/response_valuation_Test_DoNotUse_06_00_14_1727848814_.json');
[10/02/2024 06:15:43], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/10/03' , departure_date = '2024/10/04' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-02 06:15:43' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/02/2024 06:15:45], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890220241006154333507689234', session_id='10890220241006154333507689234', Collection_create_time='2024-10-02 06:15:45';
[10/02/2024 06:15:48], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '590',
        request_path = '/xml_all.php?userid=1089&sessionid=10890220241006154333507689234',
        duration = '3.075',
        merge_duration = '0.019',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.85',
        system_load_5_min = '0.73',
        system_load_15_min = '0.62',
        system_memory_usage = '50.08',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16645356') + '2506048',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16645356';
[10/02/2024 06:16:00], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727849760','43.239.53.130');
[10/02/2024 06:16:00], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/02_10_2024/request_valuation_Test_DoNotUse_06_16_00_1727849760_.json', 'a5/02_10_2024/response_valuation_Test_DoNotUse_06_16_00_1727849760_.json', 'a5/02_10_2024/response_header_valuation_Test_DoNotUse_06_16_00_1727849760_.json', 'agoda', '2024-10-02 06:16:00', '', '10890220241006154333507689234', '16645356', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/02_10_2024/response_valuation_Test_DoNotUse_06_16_00_1727849760_.json');
[10/02/2024 06:16:42], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727849802','43.239.53.130');
[10/02/2024 06:16:43], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/02_10_2024/request_valuation_Test_DoNotUse_06_16_42_1727849802_.json', 'a5/02_10_2024/response_valuation_Test_DoNotUse_06_16_42_1727849802_.json', 'a5/02_10_2024/response_header_valuation_Test_DoNotUse_06_16_42_1727849802_.json', 'agoda', '2024-10-02 06:16:43', '', '10890220241006154333507689234', '16645356', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/02_10_2024/response_valuation_Test_DoNotUse_06_16_42_1727849802_.json');
[10/02/2024 06:17:06], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727849826','43.239.53.130');
[10/02/2024 06:17:07], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/02_10_2024/request_valuation_Test_DoNotUse_06_17_06_1727849826_.json', 'a5/02_10_2024/response_valuation_Test_DoNotUse_06_17_06_1727849826_.json', 'a5/02_10_2024/response_header_valuation_Test_DoNotUse_06_17_06_1727849826_.json', 'agoda', '2024-10-02 06:17:07', '', '10890220241006154333507689234', '16645356', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/02_10_2024/response_valuation_Test_DoNotUse_06_17_06_1727849826_.json');
[10/02/2024 06:17:07], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727849827','43.239.53.130');
[10/02/2024 06:17:07], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/02_10_2024/request_valuation_Test_DoNotUse_06_17_07_1727849827_.json', 'a5/02_10_2024/response_valuation_Test_DoNotUse_06_17_07_1727849827_.json', 'a5/02_10_2024/response_header_valuation_Test_DoNotUse_06_17_07_1727849827_.json', 'agoda', '2024-10-02 06:17:07', '', '10890220241006154333507689234', '16645356', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/02_10_2024/response_valuation_Test_DoNotUse_06_17_07_1727849827_.json');
[10/02/2024 06:17:10], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/10/03' , departure_date = '2024/10/04' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-02 06:17:10' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/02/2024 06:17:12], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890220241006171046631914149', session_id='10890220241006171046631914149', Collection_create_time='2024-10-02 06:17:12';
[10/02/2024 06:17:15], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '591',
        request_path = '/xml_all.php?userid=1089&sessionid=10890220241006171046631914149',
        duration = '3.087',
        merge_duration = '0.018',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.54',
        system_load_5_min = '1.57',
        system_load_15_min = '0.91',
        system_memory_usage = '56.00',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16645359') + '2353160',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16645359';
[10/02/2024 06:17:26], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727849846','43.239.53.130');
[10/02/2024 06:17:26], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/02_10_2024/request_valuation_Test_DoNotUse_06_17_26_1727849846_.json', 'a5/02_10_2024/response_valuation_Test_DoNotUse_06_17_26_1727849846_.json', 'a5/02_10_2024/response_header_valuation_Test_DoNotUse_06_17_26_1727849846_.json', 'agoda', '2024-10-02 06:17:26', '', '10890220241006171046631914149', '16645359', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/02_10_2024/response_valuation_Test_DoNotUse_06_17_26_1727849846_.json');
[10/02/2024 06:20:33], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/10/03' , departure_date = '2024/10/04' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-02 06:20:33' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/02/2024 06:20:34], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_1089022024100620335756271313', session_id='1089022024100620335756271313', Collection_create_time='2024-10-02 06:20:34';
[10/02/2024 06:20:37], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '588',
        request_path = '/xml_all.php?userid=1089&sessionid=1089022024100620335756271313',
        duration = '3.083',
        merge_duration = '0.018',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.03',
        system_load_5_min = '1.58',
        system_load_15_min = '1.07',
        system_memory_usage = '51.02',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16645397') + '2483984',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16645397';
[10/02/2024 06:20:50], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727850050','43.239.53.130');
[10/02/2024 06:20:50], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/02_10_2024/request_valuation_Test_DoNotUse_06_20_50_1727850050_.json', 'a5/02_10_2024/response_valuation_Test_DoNotUse_06_20_50_1727850050_.json', 'a5/02_10_2024/response_header_valuation_Test_DoNotUse_06_20_50_1727850050_.json', 'agoda', '2024-10-02 06:20:50', '', '1089022024100620335756271313', '16645397', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/02_10_2024/response_valuation_Test_DoNotUse_06_20_50_1727850050_.json');
[10/02/2024 06:21:24], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727850084','43.239.53.130');
[10/02/2024 06:21:24], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/02_10_2024/request_valuation_Test_DoNotUse_06_21_24_1727850084_.json', 'a5/02_10_2024/response_valuation_Test_DoNotUse_06_21_24_1727850084_.json', 'a5/02_10_2024/response_header_valuation_Test_DoNotUse_06_21_24_1727850084_.json', 'agoda', '2024-10-02 06:21:24', '', '1089022024100620335756271313', '16645397', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/02_10_2024/response_valuation_Test_DoNotUse_06_21_24_1727850084_.json');
[10/02/2024 06:21:25], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'PRECHECK', 'a5/02_10_2024/request_precheck_Test_DoNotUse_06_21_24_1727850084_.json', 'a5/02_10_2024/response_precheck_Test_DoNotUse_06_21_24_1727850084_.json', 'a5/02_10_2024/response_header_precheck_Test_DoNotUse_06_21_24_1727850084_.json', 'agoda', '2024-10-02 06:21:25', '', '1089022024100620335756271313', '16645397', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/02_10_2024/response_precheck_Test_DoNotUse_06_21_24_1727850084_.json');
[10/02/2024 06:22:24], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727850144','43.239.53.130');
[10/02/2024 06:22:25], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('1089','15.33','2024-10-02 06:22:25','43.239.53.130','17278501452544','20241002062225','2052830','uid_1089##fname_gajju##bid_142660##route_bookflow##type_B2B##pg_HP##mob_0##email_gajendra.rajpurohit@qtechsoftware.com##phone_9876543220##siteurl_betalive.astrabookings.com','2052830_1727850145_hotel','HP','on_selection','EUR');
[10/02/2024 06:22:49], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1089' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '138' , service_type = 'hotel' , arrival_date = '2024/12/05' , departure_date = '2024/12/06' , nights = '1' , nationality = '138' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-10-02 06:22:49' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[10/02/2024 06:22:52], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1089_10890220241006224942248441936', session_id='10890220241006224942248441936', Collection_create_time='2024-10-02 06:22:52';
[10/02/2024 06:22:55], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '556',
        request_path = '/xml_all.php?userid=1089&sessionid=10890220241006224942248441936',
        duration = '3.069',
        merge_duration = '0.017',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.13',
        system_load_5_min = '1.02',
        system_load_15_min = '0.93',
        system_memory_usage = '50.80',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16645455') + '2039968',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16645455';
[10/02/2024 06:23:40], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],UPDATE suppliers SET status='I',modify_date='2'77'24-1'77'-'77'2 '77'6:23:4'77'' WHERE id= ?;
[10/02/2024 06:23:40], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],insert into `user_logs` set `username`= 'gajendra_qtech',`create_date`= '2024-10-02 06:23:40',`log_type`= 'Supplier Deactivated',`sql_query`= '',`log_description`= 'Deactivated Supplier : agoda, Date of modification : 2024-10-02 06:23:40',`ip`= '43.239.53.130';
[10/02/2024 06:23:41], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php], insert into email_trigger set  subject ='Supplier code agoda Deactivate',  message='Dear Astra Bookings Team,<br/><br/>
		Your Supplier has been Deactivated By <b>gajendra_qtech</b><br/><br/>
		Please find below details.<br/><br/>
		<b>Company_name</b> : Agoda<br/>
		<b>Supplier_code</b> : agoda<br/>
		<b>Supplier type</b> : Hotel<br/><br/>
		<b>This is computer generated mail.</b>',  email_sent ='yes', create_date ='2024-10-02 06:23:41', email_sent_to ='astra@qtechsoftware.com,astra@qtechsoftware.com', email_type ='ONLINE_SUPPLIER_EMAIL';
