[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '67' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '52' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '80' ,status = '' ,priority = '7' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '76' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '24' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '77' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '64' ,status = '1' ,priority = '7' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '65' ,status = '1' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '34' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '20' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '55' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '62' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '53' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '16' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '81' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '78' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '75' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '60' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '18' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '19' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '73' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '71' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '69' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '68' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '74' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '35' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '70' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '59' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '32' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '58' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '56' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '57' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '61' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '63' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '54' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '45' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 06:08:46], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-07-18 06:08:46',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 80 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 65 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7857 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-7857 ## supplier_id- 65 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/18/2024 06:08:49], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 06:08:49',login_attempt=0 where id = '7857';
[07/18/2024 06:08:49], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-07-18 06:08:49', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 06:09:07], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/08/15' , departure_date = '2024/08/16' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-07-18 06:09:07' , 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' ;
[07/18/2024 06:09:14], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '371',
        request_path = '/xml_all.php?userid=7857&sessionid=78571820240706090718078340551',
        duration = '6.203',
        merge_duration = '0.851',
        assigned_supplier_count = '2',
        searched_supplier_count = '1',
        system_load_1_min = '1.59',
        system_load_5_min = '1.25',
        system_load_15_min = '1.48',
        system_memory_usage = '64.47',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2606') + '28265216',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2606';
[07/18/2024 06:09:51], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721282991','43.239.53.130');
[07/18/2024 06:09:52], [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 ('', 'AVAILABILITY', 'e1p/18_07_2024/request_availability_Deepak_T_2606_1721282991_66.json', 'e1p/18_07_2024/response_availability_Deepak_T_2606_1721282991_66.json', 'e1p/18_07_2024/response_header_availability_Deepak_T_2606_1721282991_66.json', 'expediapackage', '2024-07-18 06:09:52', '', '78571820240706090718078340551', '2606', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1p/18_07_2024/response_availability_Deepak_T_2606_1721282991_66.json');
[07/18/2024 06:09:52], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Landmark Hotel Baniyas', 'dubai', '138', '7857', '', '23', '', 'hotelstopbooking', '2024-07-18 :06:09:52','');
[07/18/2024 06:09:52], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Landmark Hotel Baniyas', 'dubai', '138', '7857', '', '23', '', 'hotelcancellationpolicy', '2024-07-18 :06:09:52','');
[07/18/2024 06:09:58], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721282998','43.239.53.130');
[07/18/2024 06:09: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 ('', 'AVAILABILITY', 'e1p/18_07_2024/request_availability_Deepak_T_2606_1721282998_95.json', 'e1p/18_07_2024/response_availability_Deepak_T_2606_1721282998_95.json', 'e1p/18_07_2024/response_header_availability_Deepak_T_2606_1721282998_95.json', 'expediapackage', '2024-07-18 06:09:59', '', '78571820240706090718078340551', '2606', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1p/18_07_2024/response_availability_Deepak_T_2606_1721282998_95.json');
[07/18/2024 06:09: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', 'e1p/18_07_2024/request_valuation_Deepak_T_2606_1721282999_16.json', 'e1p/18_07_2024/response_valuation_Deepak_T_2606_1721282999_16.json', 'e1p/18_07_2024/response_header_valuation_Deepak_T_2606_1721282999_16.json', 'expediapackage', '2024-07-18 06:09:59', '', '78571820240706090718078340551', '2606', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1p/18_07_2024/response_valuation_Deepak_T_2606_1721282999_16.json');
[07/18/2024 06:09:59], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Premier Inn Dubai International Airport', 'dubai', '138', '7857', '', '23', '', 'hotelcancellationpolicy', '2024-07-18 :06:09:59','');
[07/18/2024 06:10:02], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721283002','43.239.53.130');
[07/18/2024 06:10:03], [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 ('', 'AVAILABILITY', 'e1p/18_07_2024/request_availability_Deepak_T_2606_1721283002_79.json', 'e1p/18_07_2024/response_availability_Deepak_T_2606_1721283002_79.json', 'e1p/18_07_2024/response_header_availability_Deepak_T_2606_1721283002_79.json', 'expediapackage', '2024-07-18 06:10:03', '', '78571820240706090718078340551', '2606', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1p/18_07_2024/response_availability_Deepak_T_2606_1721283002_79.json');
[07/18/2024 06:10:03], [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', 'e1p/18_07_2024/request_valuation_Deepak_T_2606_1721283003_87.json', 'e1p/18_07_2024/response_valuation_Deepak_T_2606_1721283003_87.json', 'e1p/18_07_2024/response_header_valuation_Deepak_T_2606_1721283003_87.json', 'expediapackage', '2024-07-18 06:10:03', '', '78571820240706090718078340551', '2606', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1p/18_07_2024/response_valuation_Deepak_T_2606_1721283003_87.json');
[07/18/2024 06:10:29], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721283029','43.239.53.130');
[07/18/2024 06:10:30], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('7857','46.84','2024-07-18 06:10:30','43.239.53.130','17212830308425','20240718061030','4885','uid_7857##fname_Pranali##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_pranali.mhatre@qtechsoftware.com##phone_9898989098##siteurl_beta.astrabookings.com','4885_1721283030_hotel','HP','on_selection','EUR');
[07/18/2024 06:11:24], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721283084','43.239.53.130');
[07/18/2024 06:11:25], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('7857','62.53','2024-07-18 06:11:25','43.239.53.130','17212830857413','20240718061125','4885','uid_7857##fname_Pranali##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_pranali.mhatre@qtechsoftware.com##phone_9898989098##siteurl_beta.astrabookings.com','4885_1721283085_hotel','HP','on_selection','USD');
[07/18/2024 06:11:28], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set gateway_point='on_transfer',payment_gateway_request='s:206:\"entityId=8a8294174f4f8b3f014f5f09522d0996&paymentType=DB&amount=63&currency=EUR&merchantTransactionId=20240718061125&customer.email=pranali.mhatre@qtechsoftware.com&customParameters[SHOPPER_customerId]=7857\";',pg_markup='2' where unique_ref_id='4885_1721283085_hotel' and gateway_code='HP';
[07/18/2024 06:13:07], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721283187','43.239.53.130');
[07/18/2024 06:13:08], [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 ('', 'AVAILABILITY', 'e1p/18_07_2024/request_availability_Deepak_T_2606_1721283187_99.json', 'e1p/18_07_2024/response_availability_Deepak_T_2606_1721283187_99.json', 'e1p/18_07_2024/response_header_availability_Deepak_T_2606_1721283187_99.json', 'expediapackage', '2024-07-18 06:13:08', '', '78571820240706090718078340551', '2606', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1p/18_07_2024/response_availability_Deepak_T_2606_1721283187_99.json');
[07/18/2024 06:13:08], [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', 'e1p/18_07_2024/request_valuation_Deepak_T_2606_1721283188_68.json', 'e1p/18_07_2024/response_valuation_Deepak_T_2606_1721283188_68.json', 'e1p/18_07_2024/response_header_valuation_Deepak_T_2606_1721283188_68.json', 'expediapackage', '2024-07-18 06:13:08', '', '78571820240706090718078340551', '2606', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1p/18_07_2024/response_valuation_Deepak_T_2606_1721283188_68.json');
[07/18/2024 06:13:42], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721283222','43.239.53.130');
[07/18/2024 06:13:43], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('7857','46.84','2024-07-18 06:13:43','43.239.53.130','17212832238662','20240718061343','4888','uid_7857##fname_pranali##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_pranali.mhatre@qtechsoftware.com##phone_9898989890##siteurl_beta.astrabookings.com','4888_1721283223_hotel','HP','on_selection','EUR');
[07/18/2024 06:13:43], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721283223','43.239.53.130');
[07/18/2024 06:13:44], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],insert into payment_log(agent_id,booking_amount,created_date,ip_address,track_id,voucher_id,reservation_id,payment_track,unique_ref_id,gateway_code,gateway_point,currency)
		values('7857','62.53','2024-07-18 06:13:44','43.239.53.130','17212832248732','20240718061344','4888','uid_7857##fname_pranali##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_pranali.mhatre@qtechsoftware.com##phone_9898989890##siteurl_beta.astrabookings.com','4888_1721283224_hotel','HP','on_selection','USD');
