[01/20/2023 12:57:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[01/20/2023 12:57:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '1' ,status = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/20/2023 12:57:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '6' ,status = '' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/20/2023 12:57:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '3' ,status = '' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/20/2023 12:57:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '2' ,status = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/20/2023 12:57:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '4' ,status = '' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/20/2023 12:57:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '28',supplier_id = '5' ,status = '' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[01/20/2023 12:57:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2023-01-20 12:57:03',`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-28 ## supplier_id- 1 ## company_name - Contracted Hotels ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-28 ## supplier_id- 2 ## company_name - Contracted Sightseeing ## supplier_code-localsightseeing  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '59.88.92.104';
[01/20/2023 12:57:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='4210', `entity`='Agents', `value`='28' ;
[01/20/2023 12:57:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2023-01-20 12:57:09',login_attempt=0 where id = '28';
[01/20/2023 12:57:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'altaf', user_type = 'A', branch_id = '1', login_datetime = '2023-01-20 12:57:09', ip = '59.88.92.104', action = 'Login' ;
