[02/05/2025 01:00:34], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1738760434','103.104.226.130');
[02/05/2025 01:00:34], [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/05_02_2025/request_valuation_Qtech_Goagent_13_00_34_1738760434_.json', 'a5/05_02_2025/response_valuation_Qtech_Goagent_13_00_34_1738760434_.json', 'a5/05_02_2025/response_header_valuation_Qtech_Goagent_13_00_34_1738760434_.json', 'agoda', '2025-02-05 01:00:34', '', '24840520250212555198875783244', '20836994', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/05_02_2025/response_valuation_Qtech_Goagent_13_00_34_1738760434_.json');
[02/05/2025 01:00:35], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Golang_qtech (Username: Qtech_Goagent)<br><br>City:phuket<br><br>Arrival Date:27/02/2025<br><br>Departure Date:28/02/2025<br><br>Supplier:agoda<br><br>Hotel:THE LALIT NEW DELHI<br><br>Room:Executive Club King , Room Only | Amenities:Food & Beverage Discount 10% , Laundry Discount 10% , Parking , Express check-in , Free WiFi , Drinking water , Free fitness center access , 
',  email_sent ='yes', create_date ='2025-02-05 13:00:35', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[02/05/2025 01:05:59], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1738760759','103.104.226.130');
[02/05/2025 01:05:59], [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/05_02_2025/request_valuation_Qtech_Goagent_13_05_59_1738760759_.json', 'a5/05_02_2025/response_valuation_Qtech_Goagent_13_05_59_1738760759_.json', 'a5/05_02_2025/response_header_valuation_Qtech_Goagent_13_05_59_1738760759_.json', 'agoda', '2025-02-05 01:05:59', '', '24840520250212555198875783244', '20836994', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/05_02_2025/response_valuation_Qtech_Goagent_13_05_59_1738760759_.json');
[02/05/2025 01:06:00], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Golang_qtech (Username: Qtech_Goagent)<br><br>City:phuket<br><br>Arrival Date:27/02/2025<br><br>Departure Date:28/02/2025<br><br>Supplier:agoda<br><br>Hotel:THE LALIT NEW DELHI<br><br>Room:Premier King Room , Bed and Breakfast | Amenities:Breakfast , Food & Beverage Discount 10% , Laundry Discount 10% , Parking , Express check-in , Free WiFi , Drinking water , Free fitness center access , 
',  email_sent ='yes', create_date ='2025-02-05 13:06:00', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[02/05/2025 01:06:13], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1738760773','103.104.226.130');
[02/05/2025 01:06:13], [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/05_02_2025/request_valuation_Qtech_Goagent_13_06_13_1738760773_.json', 'a5/05_02_2025/response_valuation_Qtech_Goagent_13_06_13_1738760773_.json', 'a5/05_02_2025/response_header_valuation_Qtech_Goagent_13_06_13_1738760773_.json', 'agoda', '2025-02-05 01:06:13', '', '24840520250212555198875783244', '20836994', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/05_02_2025/response_valuation_Qtech_Goagent_13_06_13_1738760773_.json');
[02/05/2025 01:06:14], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Golang_qtech (Username: Qtech_Goagent)<br><br>City:phuket<br><br>Arrival Date:27/02/2025<br><br>Departure Date:28/02/2025<br><br>Supplier:agoda<br><br>Hotel:THE LALIT NEW DELHI<br><br>Room:Premier King Room , Room Only | Amenities:Food & Beverage Discount 10% , Laundry Discount 10% , Parking , Express check-in , Free WiFi , Drinking water , Free fitness center access , 
',  email_sent ='yes', create_date ='2025-02-05 13:06:14', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[02/05/2025 01:11:20], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2484' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'phuket' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/02/27' , departure_date = '2025/02/28' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2025-02-05 13:11:20' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[02/05/2025 01:11:20], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2484_24840520250213112043888924090', session_id='24840520250213112043888924090', Collection_create_time='2025-02-05 13:11:20';
[02/05/2025 01:11:23], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=2484&sessionid=24840520250213112043888924090',
        duration = '2.059',
        merge_duration = '0.000',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.50',
        system_load_5_min = '0.31',
        system_load_15_min = '0.33',
        system_memory_usage = '59.07',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '20838290') + '3723704',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '20838290';
[02/05/2025 01:11:35], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2025-02-05 01:11:35',login_attempt=0 where id = '2484';
[02/05/2025 01:11:35], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_Goagent', user_type = 'A', branch_id = '26', login_datetime = '2025-02-05 13:11:35', ip = '103.104.226.130', action = 'Login' ;
[02/05/2025 01:11:53], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2484' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/03/27' , departure_date = '2025/03/28' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2025-02-05 13:11:53' , 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' ;
[02/05/2025 01:11:53], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2484_24840520250213115362215265169', session_id='24840520250213115362215265169', Collection_create_time='2025-02-05 13:11:53';
[02/05/2025 01:11:55], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=2484&sessionid=24840520250213115362215265169',
        duration = '2.063',
        merge_duration = '0.000',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.31',
        system_load_5_min = '0.28',
        system_load_15_min = '0.32',
        system_memory_usage = '58.58',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '20838297') + '3723192',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '20838297';
[02/05/2025 01:13:40], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2484' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/03/27' , departure_date = '2025/03/28' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2025-02-05 13:13:40' , 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' ;
[02/05/2025 01:13:40], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2484_24840520250213134054331738692', session_id='24840520250213134054331738692', Collection_create_time='2025-02-05 13:13:40';
[02/05/2025 01:13:43], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=2484&sessionid=24840520250213134054331738692',
        duration = '2.064',
        merge_duration = '0.000',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.52',
        system_load_5_min = '0.36',
        system_load_15_min = '0.34',
        system_memory_usage = '58.32',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '20838718') + '3723704',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '20838718';
[02/05/2025 01:13:50], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2025-02-05 01:13:50',login_attempt=0 where id = '2484';
[02/05/2025 01:13:51], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_Goagent', user_type = 'A', branch_id = '26', login_datetime = '2025-02-05 13:13:51', ip = '103.104.226.130', action = 'Login' ;
[02/05/2025 01:14:02], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2484' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/03/20' , departure_date = '2025/03/21' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2025-02-05 13:14:02' , 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' ;
[02/05/2025 01:14:03], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2484_24840520250213140270892952851', session_id='24840520250213140270892952851', Collection_create_time='2025-02-05 13:14:03';
[02/05/2025 01:14:05], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=2484&sessionid=24840520250213140270892952851',
        duration = '2.048',
        merge_duration = '0.000',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.51',
        system_load_5_min = '0.37',
        system_load_15_min = '0.35',
        system_memory_usage = '58.51',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '20838815') + '3723192',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '20838815';
[02/05/2025 01:15:17], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2025-02-05 01:15:17',login_attempt=0 where id = '2484';
[02/05/2025 01:15:17], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_Goagent', user_type = 'A', branch_id = '26', login_datetime = '2025-02-05 13:15:17', ip = '103.104.226.130', action = 'Login' ;
[02/05/2025 01:15:34], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2484' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/04/30' , departure_date = '2025/05/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2025-02-05 13:15:34' , 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' ;
[02/05/2025 01:15:35], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2484_24840520250213153486904048362', session_id='24840520250213153486904048362', Collection_create_time='2025-02-05 13:15:35';
[02/05/2025 01:15:37], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=2484&sessionid=24840520250213153486904048362',
        duration = '2.064',
        merge_duration = '0.000',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.40',
        system_load_5_min = '0.37',
        system_load_15_min = '0.35',
        system_memory_usage = '58.96',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '20838936') + '3723192',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '20838936';
[02/05/2025 01:16:14], [file name :-/efsdata/otrams/public_html/beta/tms/logout.php],INSERT INTO psa_login_log set username = 'shiv_qtech' , user_type = 'shiv_qtech'_type , branch_id = '' , login_datetime = '2025-02-05 13:16:14' , ip = '103.104.226.130' , action = 'Logout'  ;
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '77' ,status = '1' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '89' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '102' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '76' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '98' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '58' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '99' ,status = '' ,priority = '9' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '74' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '75' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '96' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '56' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '60' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '84' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '67' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '1' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '104' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '101' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '73' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '85' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '103' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '100' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '93' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '57' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '81' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '78' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '83' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '68' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '90' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '66' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '64' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '65' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '69' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[02/05/2025 01:16:37], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into user_logs set username= 'shiv_qtech',create_date= '2025-02-05 13:16:37',log_type= 'Agent Supplier settings',sql_query= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 104 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;',log_description= 'Supplier setting updated  Previous data-- agent_id-2484 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 0 ',ip= '103.104.226.130';
[02/05/2025 01:16:40], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2025-02-05 01:16:40',login_attempt=0 where id = '2484';
[02/05/2025 01:16:40], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_Goagent', user_type = 'A', branch_id = '26', login_datetime = '2025-02-05 13:16:40', ip = '103.104.226.130', action = 'Login' ;
[02/05/2025 01:18:16], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2484' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/04/24' , departure_date = '2025/04/25' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2025-02-05 13:18:16' , 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' ;
[02/05/2025 01:18:17], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2484_24840520250213181656077780858', session_id='24840520250213181656077780858', Collection_create_time='2025-02-05 13:18:17';
[02/05/2025 01:18:19], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=2484&sessionid=24840520250213181656077780858',
        duration = '2.158',
        merge_duration = '0.000',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.17',
        system_load_5_min = '0.29',
        system_load_15_min = '0.32',
        system_memory_usage = '58.81',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '20839114') + '3723192',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '20839114';
[02/05/2025 01:59:56], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2484' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/04/16' , departure_date = '2025/04/17' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2025-02-05 13:59:56' , 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' ;
[02/05/2025 01:59:57], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2484_24840520250213595693546541454', session_id='24840520250213595693546541454', Collection_create_time='2025-02-05 13:59:57';
[02/05/2025 01:59:59], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=2484&sessionid=24840520250213595693546541454',
        duration = '2.146',
        merge_duration = '0.000',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.57',
        system_load_5_min = '0.37',
        system_load_15_min = '0.28',
        system_memory_usage = '60.54',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '20841911') + '3723952',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '20841911';
