[09/25/2024 11:00:14], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727262014','43.239.53.130');
[09/25/2024 11: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/25_09_2024/request_valuation_Qtech_pranali_11_00_14_1727262014_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_00_14_1727262014_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_00_14_1727262014_.json', 'agoda', '2024-09-25 11:00:14', '', '24062520240910594296440393524', '16517132', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_00_14_1727262014_.json');
[09/25/2024 11:00:27], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'cologne' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/31' , departure_date = '2024/11/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-25 11:00:27' , site_id = '' , country_code = '60' , city_code = '60_2690-CGN_3991' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[09/25/2024 11:00:28], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062520240911002752233021059', session_id='24062520240911002752233021059', Collection_create_time='2024-09-25 11:00:28';
[09/25/2024 11:00:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '108',
        request_path = '/xml_all.php?userid=2406&sessionid=24062520240911002752233021059',
        duration = '2.077',
        merge_duration = '0.022',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.24',
        system_load_5_min = '9.06',
        system_load_15_min = '10.69',
        system_memory_usage = '39.72',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16517161') + '3240880',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16517161';
[09/25/2024 11:00:41], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727262041','43.239.53.130');
[09/25/2024 11:00:41], [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/25_09_2024/request_valuation_Qtech_pranali_11_00_41_1727262041_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_00_41_1727262041_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_00_41_1727262041_.json', 'agoda', '2024-09-25 11:00:41', '', '24062520240911002752233021059', '16517161', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_00_41_1727262041_.json');
[09/25/2024 11:03:28], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727262208','43.239.53.130');
[09/25/2024 11:03:28], [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/25_09_2024/request_valuation_Qtech_pranali_11_03_28_1727262208_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_03_28_1727262208_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_03_28_1727262208_.json', 'agoda', '2024-09-25 11:03:28', '', '24062520240911002752233021059', '16517161', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_03_28_1727262208_.json');
[09/25/2024 11:03:37], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727262217','43.239.53.130');
[09/25/2024 11:03:37], [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/25_09_2024/request_valuation_Qtech_pranali_11_03_37_1727262217_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_03_37_1727262217_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_03_37_1727262217_.json', 'agoda', '2024-09-25 11:03:37', '', '24062520240911002752233021059', '16517161', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_03_37_1727262217_.json');
[09/25/2024 11:04:04], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727262244','43.239.53.130');
[09/25/2024 11:04:04], [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/25_09_2024/request_valuation_Qtech_pranali_11_04_04_1727262244_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_04_04_1727262244_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_04_04_1727262244_.json', 'agoda', '2024-09-25 11:04:04', '', '24062520240911002752233021059', '16517161', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_04_04_1727262244_.json');
[09/25/2024 11:04:04], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727262244','43.239.53.130');
[09/25/2024 11:04:05], [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/25_09_2024/request_valuation_Qtech_pranali_11_04_04_1727262244_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_04_04_1727262244_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_04_04_1727262244_.json', 'agoda', '2024-09-25 11:04:05', '', '24062520240911002752233021059', '16517161', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_04_04_1727262244_.json');
[09/25/2024 11:04:10], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727262250','43.239.53.130');
[09/25/2024 11:04:11], [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/25_09_2024/request_valuation_Qtech_pranali_11_04_10_1727262250_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_04_10_1727262250_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_04_10_1727262250_.json', 'agoda', '2024-09-25 11:04:11', '', '24062520240911002752233021059', '16517161', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_04_10_1727262250_.json');
[09/25/2024 11:04:11], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727262251','43.239.53.130');
[09/25/2024 11:04:12], [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/25_09_2024/request_valuation_Qtech_pranali_11_04_12_1727262252_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_04_12_1727262252_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_04_12_1727262252_.json', 'agoda', '2024-09-25 11:04:12', '', '24062520240911002752233021059', '16517161', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_04_12_1727262252_.json');
[09/25/2024 11:16:06], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'cologne' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/31' , departure_date = '2024/11/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-25 11:16:06' , site_id = '' , country_code = '60' , city_code = '60_2690-CGN_3991' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[09/25/2024 11:16:07], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062520240911160627036584315', session_id='24062520240911160627036584315', Collection_create_time='2024-09-25 11:16:07';
[09/25/2024 11:16:09], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '114',
        request_path = '/xml_all.php?userid=2406&sessionid=24062520240911160627036584315',
        duration = '2.068',
        merge_duration = '0.014',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '6.16',
        system_load_5_min = '11.75',
        system_load_15_min = '11.72',
        system_memory_usage = '38.84',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16517492') + '3240880',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16517492';
[09/25/2024 11:16:37], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727262997','43.239.53.130');
[09/25/2024 11:16:38], [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/25_09_2024/request_valuation_Qtech_pranali_11_16_37_1727262997_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_16_37_1727262997_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_16_37_1727262997_.json', 'agoda', '2024-09-25 11:16:38', '', '24062520240911160627036584315', '16517492', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_16_37_1727262997_.json');
[09/25/2024 11:17:00], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727263020','43.239.53.130');
[09/25/2024 11:17: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/25_09_2024/request_valuation_Qtech_pranali_11_17_00_1727263020_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_17_00_1727263020_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_17_00_1727263020_.json', 'agoda', '2024-09-25 11:17:00', '', '24062520240911160627036584315', '16517492', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_17_00_1727263020_.json');
[09/25/2024 11:17:04], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727263024','43.239.53.130');
[09/25/2024 11:17:04], [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/25_09_2024/request_valuation_Qtech_pranali_11_17_04_1727263024_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_17_04_1727263024_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_17_04_1727263024_.json', 'agoda', '2024-09-25 11:17:04', '', '24062520240911160627036584315', '16517492', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_17_04_1727263024_.json');
[09/25/2024 11:17:14], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727263034','43.239.53.130');
[09/25/2024 11:17: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/25_09_2024/request_valuation_Qtech_pranali_11_17_14_1727263034_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_17_14_1727263034_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_17_14_1727263034_.json', 'agoda', '2024-09-25 11:17:14', '', '24062520240911160627036584315', '16517492', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_17_14_1727263034_.json');
[09/25/2024 11:24:27], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2406' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '43.239.53.130' , city = 'cologne' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/10/31' , departure_date = '2024/11/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-09-25 11:24:27' , site_id = '' , country_code = '60' , city_code = '60_2690-CGN_3991' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[09/25/2024 11:24:28], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2406_24062520240911242794414011994', session_id='24062520240911242794414011994', Collection_create_time='2024-09-25 11:24:28';
[09/25/2024 11:24:30], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '111',
        request_path = '/xml_all.php?userid=2406&sessionid=24062520240911242794414011994',
        duration = '2.066',
        merge_duration = '0.015',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '25.46',
        system_load_5_min = '18.23',
        system_load_15_min = '13.82',
        system_memory_usage = '36.86',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16517629') + '3240880',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '16517629';
[09/25/2024 11:24:57], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1727263497','43.239.53.130');
[09/25/2024 11:24:57], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/25_09_2024/request_valuation_Qtech_pranali_11_24_57_1727263497_.json', 'a5/25_09_2024/response_valuation_Qtech_pranali_11_24_57_1727263497_.json', 'a5/25_09_2024/response_header_valuation_Qtech_pranali_11_24_57_1727263497_.json', 'agoda', '2024-09-25 11:24:57', '', '24062520240911242794414011994', '16517629', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/25_09_2024/response_valuation_Qtech_pranali_11_24_57_1727263497_.json');
[09/25/2024 11:27:15], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],UPDATE suppliers SET status='I',modify_date='2'77'24-'77'9-25 11:27:15' WHERE id= ?;
[09/25/2024 11:27:15], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],insert into `user_logs` set `username`= 'Bhavesh_qtech',`create_date`= '2024-09-25 11:27:15',`log_type`= 'Supplier Deactivated',`sql_query`= '',`log_description`= 'Deactivated Supplier : agoda, Date of modification : 2024-09-25 11:27:15',`ip`= '43.239.53.130';
[09/25/2024 11:27:16], [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>Bhavesh_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-09-25 11:27:16', email_sent_to ='astra@qtechsoftware.com,astra@qtechsoftware.com', email_type ='ONLINE_SUPPLIER_EMAIL';
