[01/23/2023 09:51:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[01/23/2023 09:51:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '29',supplier_id = '1' ,status = '1' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[01/23/2023 09:51:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '29',supplier_id = '6' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[01/23/2023 09:51:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '29',supplier_id = '3' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[01/23/2023 09:51:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '29',supplier_id = '2' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[01/23/2023 09:51:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '29',supplier_id = '4' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[01/23/2023 09:51:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '29',supplier_id = '5' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[01/23/2023 09:51:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2023-01-23 09:51:52',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time======INSERT INTO agent_supplier_settings SET agent_id = :agent_id,supplier_id = :supplier_id ,status = :status ,priority = :priority ,branch_id = :branch_id,percentage = :percentage,visible_supplier_on_voucher = :visible_supplier_on_voucher,lead_time = :lead_time',`log_description`= 'Supplier setting updated  ',`ip`= '117.248.184.207';
[01/23/2023 09:51:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='4212', `entity`='Agents', `value`='29' ;
[01/23/2023 09:52:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logout.php],INSERT INTO psa_login_log set username = 'tfg' , user_type = 'tfg'_type , branch_id = '' , login_datetime = '2023-01-23 09:52:34' , ip = '117.248.184.207' , action = 'Logout'  ;
[01/23/2023 09:53:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2023-01-23 09:53:23',login_attempt=0 where id = '29';
[01/23/2023 09:53:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'Altaf_test', user_type = 'A', branch_id = '1', login_datetime = '2023-01-23 09:53:23', ip = '117.248.184.207', action = 'Login' ;
[01/23/2023 09:53:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '29' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '117.248.184.207' , city = 'dubai' , service_name = '' , service_type = 'hotel' , arrival_date = '2023/01/30' , departure_date = '2023/01/31' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2023-01-23 09:53:55' , site_id = '' , country_code = '138' , web_service = '' ;
[01/23/2023 09:53:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=29&sessionid=a9e8b26ffba3399a623a53c8880d79e26f0ac07930dbb6d4b8f0d7decc65814f',
  duration = '',
  merge_duration = '',
  assigned_supplier_count = '',
  searched_supplier_count = '',
  system_load_1_min = '1.14',
  system_load_5_min = '1.60',
  system_load_15_min = '1.66',
  system_memory_usage = '94.55',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '16') + '3511224',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/classes/Supplier.php:620
Class &#039;MongoDB\Collection&#039; not found',
  is_cached = 'no'
WHERE id = '16';
