[01/23/2023 10:02:58], [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 10:02:58], [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 = '' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:02:58], [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 = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:02:58], [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 = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:02:58], [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 = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:02:58], [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 = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:02:58], [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 = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2023-01-23 10:02:58',`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  Previous data-- agent_id-29 ## supplier_id- 1 ## company_name - Contracted Hotels ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '157.34.90.207';
[01/23/2023 10:02:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='4213', `entity`='Agents', `value`='29' ;
[01/23/2023 10:04:04], [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 10:04:04], [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 = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:04:04], [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 = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:04:04], [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 = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:04:05], [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 = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:04:05], [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 = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:04:05], [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 = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/23/2023 10:04:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2023-01-23 10:04:05',`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  Previous data-- agent_id-29 ## supplier_id- 5 ## company_name - Misc Services ## supplier_code-misc  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '157.34.90.207';
[01/23/2023 10:04:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='4214', `entity`='Agents', `value`='29' ;
[01/23/2023 10:05:12], [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 = '157.34.90.207' , city = 'dubai' , service_name = '' , service_type = 'hotel' , arrival_date = '2023/01/23' , departure_date = '2023/01/24' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2023-01-23 10:05:12' , site_id = '' , country_code = '138' , web_service = '' ;
[01/23/2023 10:05:13], [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 = '2.68',
  system_load_5_min = '2.28',
  system_load_15_min = '1.96',
  system_memory_usage = '98.54',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '17') + '3504152',
  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 = '17';
[01/23/2023 10:25:05], [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 10:25:05' , ip = '59.88.85.229' , action = 'Logout'  ;
[01/23/2023 10:28:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2023-01-23 10:28:42',login_attempt=0 where id = '21';
[01/23/2023 10:28:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'ankita', user_type = 'A', branch_id = '3', login_datetime = '2023-01-23 10:28:42', ip = '59.88.85.229', action = 'Login' ;
[01/23/2023 10:28:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '59.88.85.229' , city = 'dubai' , service_name = '' , service_type = 'hotel' , arrival_date = '2023/01/30' , departure_date = '2023/01/31' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2023-01-23 10:28:57' , site_id = '' , country_code = '138' , web_service = '' ;
[01/23/2023 10:28:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=a9e8b26ffba3399a623a53c8880d79e26f0ac07930dbb6d4b8f0d7decc65814f',
  duration = '',
  merge_duration = '',
  assigned_supplier_count = '',
  searched_supplier_count = '',
  system_load_1_min = '1.26',
  system_load_5_min = '1.25',
  system_load_15_min = '1.41',
  system_memory_usage = '95.65',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18') + '3508792',
  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 = '18';
