[07/18/2024 09:19:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/18/2024 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [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 09:19:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-07-18 09:19:53',`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 09:19:59], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 09:19:59',login_attempt=0 where id = '7857';
[07/18/2024 09:19:59], [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 09:19:59', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 09:20:21], [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/07/25' , departure_date = '2024/07/26' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-07-18 09:20:21' , 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 09:20:27], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '374',
        request_path = '/xml_all.php?userid=7857&sessionid=78571820240709202137226356432',
        duration = '5.356',
        merge_duration = '0.859',
        assigned_supplier_count = '2',
        searched_supplier_count = '1',
        system_load_1_min = '7.75',
        system_load_5_min = '15.98',
        system_load_15_min = '16.02',
        system_memory_usage = '83.59',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2609') + '25441608',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2609';
[07/18/2024 09:20:35], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721294435','43.239.53.130');
[07/18/2024 09:20:35], [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_2609_1721294435_43.json', 'e1p/18_07_2024/response_availability_Deepak_T_2609_1721294435_43.json', 'e1p/18_07_2024/response_header_availability_Deepak_T_2609_1721294435_43.json', 'expediapackage', '2024-07-18 09:20:35', '', '78571820240709202137226356432', '2609', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1p/18_07_2024/response_availability_Deepak_T_2609_1721294435_43.json');
[07/18/2024 09:20:36], [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_2609_1721294435_62.json', 'e1p/18_07_2024/response_valuation_Deepak_T_2609_1721294435_62.json', 'e1p/18_07_2024/response_header_valuation_Deepak_T_2609_1721294435_62.json', 'expediapackage', '2024-07-18 09:20:36', '', '78571820240709202137226356432', '2609', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1p/18_07_2024/response_valuation_Deepak_T_2609_1721294435_62.json');
[07/18/2024 09:22:31], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721294551','43.239.53.130');
[07/18/2024 09:22:35], [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','42.23','2024-07-18 09:22:35','43.239.53.130','17212945559854','20240718092235','4899','uid_7857##fname_pranali##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_pranali.mhatre@qtechsoftware.com##phone_9898989789##siteurl_beta.astrabookings.com','4899_1721294555_hotel','HP','on_selection','EUR');
[07/18/2024 09:22:36], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721294556','43.239.53.130');
[07/18/2024 09:22:39], [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','56.38','2024-07-18 09:22:39','43.239.53.130','17212945595735','20240718092239','4899','uid_7857##fname_pranali##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_pranali.mhatre@qtechsoftware.com##phone_9898989789##siteurl_beta.astrabookings.com','4899_1721294559_hotel','HP','on_selection','USD');
[07/18/2024 09:22:41], [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=56&currency=EUR&merchantTransactionId=20240718092239&customer.email=pranali.mhatre@qtechsoftware.com&customParameters[SHOPPER_customerId]=7857\";',pg_markup='2' where unique_ref_id='4899_1721294559_hotel' and gateway_code='HP';
[07/18/2024 09:22:42], [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=56&currency=EUR&merchantTransactionId=20240718092239&customer.email=pranali.mhatre@qtechsoftware.com&customParameters[SHOPPER_customerId]=7857\";',pg_markup='2' where unique_ref_id='4899_1721294559_hotel' and gateway_code='HP';
[07/18/2024 09:22:52], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721294572','43.239.53.130');
[07/18/2024 09:22: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_2609_1721294572_10.json', 'e1p/18_07_2024/response_availability_Deepak_T_2609_1721294572_10.json', 'e1p/18_07_2024/response_header_availability_Deepak_T_2609_1721294572_10.json', 'expediapackage', '2024-07-18 09:22:52', '', '78571820240709202137226356432', '2609', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1p/18_07_2024/response_availability_Deepak_T_2609_1721294572_10.json');
[07/18/2024 09:22: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 ('', 'VALUATION', 'e1p/18_07_2024/request_valuation_Deepak_T_2609_1721294572_67.json', 'e1p/18_07_2024/response_valuation_Deepak_T_2609_1721294572_67.json', 'e1p/18_07_2024/response_header_valuation_Deepak_T_2609_1721294572_67.json', 'expediapackage', '2024-07-18 09:22:52', '', '78571820240709202137226356432', '2609', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1p/18_07_2024/response_valuation_Deepak_T_2609_1721294572_67.json');
[07/18/2024 09:23:18], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721294598','43.239.53.130');
[07/18/2024 09:23:19], [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','42.23','2024-07-18 09:23:19','43.239.53.130','17212945995132','20240718092319','4902','uid_7857##fname_pranali##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_pranali.mhatre@qtechsoftware.com##phone_9898989898##siteurl_beta.astrabookings.com','4902_1721294599_hotel','HP','on_selection','EUR');
[07/18/2024 09:23:24], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721294604','43.239.53.130');
[07/18/2024 09:23: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','56.38','2024-07-18 09:23:25','43.239.53.130','17212946058682','20240718092325','4902','uid_7857##fname_pranali##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_pranali.mhatre@qtechsoftware.com##phone_9898989898##siteurl_beta.astrabookings.com','4902_1721294605_hotel','HP','on_selection','USD');
[07/18/2024 09:23:27], [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=56&currency=EUR&merchantTransactionId=20240718092325&customer.email=pranali.mhatre@qtechsoftware.com&customParameters[SHOPPER_customerId]=7857\";',pg_markup='2' where unique_ref_id='4902_1721294605_hotel' and gateway_code='HP';
[07/18/2024 09:33:46], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.php],update payment_log set payment_gateway_response='a:11:{s:2:\"id\";s:32:\"8ac7a4a190c3c57c0190c527f533040c\";s:11:\"paymentType\";s:2:\"DB\";s:12:\"paymentBrand\";s:6:\"MASTER\";s:21:\"merchantTransactionId\";s:14:\"20240718092325\";s:6:\"result\";a:2:{s:4:\"code\";s:11:\"600.200.500\";s:11:\"description\";s:93:\"Invalid payment data. You are not configured for this currency or sub type (country or brand)\";}s:4:\"card\";a:13:{s:3:\"bin\";s:6:\"512345\";s:10:\"binCountry\";s:2:\"LR\";s:11:\"last4Digits\";s:4:\"0008\";s:6:\"holder\";s:7:\"pranali\";s:11:\"expiryMonth\";s:2:\"11\";s:10:\"expiryYear\";s:4:\"2024\";s:6:\"issuer\";a:1:{s:4:\"bank\";s:19:\"AFRILAND FIRST BANK\";}s:4:\"type\";s:6:\"CREDIT\";s:5:\"level\";s:8:\"STANDARD\";s:7:\"country\";s:2:\"LR\";s:12:\"maxPanLength\";s:2:\"16\";s:7:\"binType\";s:8:\"PERSONAL\";s:13:\"regulatedFlag\";s:1:\"N\";}s:8:\"customer\";a:3:{s:5:\"email\";s:32:\"pranali.mhatre@qtechsoftware.com\";s:2:\"ip\";s:15:\"103.104.226.130\";s:9:\"ipCountry\";s:2:\"IN\";}s:16:\"customParameters\";a:2:{s:24:\"SHOPPER_EndToEndIdentity\";s:64:\"474d8bca1277209596d71a8b9eb0f8aff51eb89ace1348e20b3a868294c89d3f\";s:18:\"SHOPPER_customerId\";s:4:\"7857\";}s:11:\"buildNumber\";s:66:\"3061801254dc61c68da9c0ff3741d3eb7fff8b14@2024-07-17 00:42:32 +0000\";s:9:\"timestamp\";s:24:\"2024-07-18 09:24:08+0000\";s:3:\"ndc\";s:46:\"85B700485CC9C0003F3F094A729EFEF6.uat01-vm-tx01\";}',return_date='1721295226',payment_status='Transaction Unsuccessful',gateway_point='on_readresponse',orderID= '20240718092325' where unique_ref_id='' and gateway_code='HP';
[07/18/2024 09:33:46], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.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','0','2024-07-18 09:33:46','43.239.53.130','17212952261742','','','uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_##mob_0##email_##phone_##siteurl_beta.astrabookings.com','','HP','on_selection','EUR');
[07/18/2024 09:33:48], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:33:48',track_id='17212952286997',voucher_id='20240718093348',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='EUR' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:34:06], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:34:06',track_id='17212952461994',voucher_id='20240718093406',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='USD' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:34:09], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:34:09',track_id='17212952495910',voucher_id='20240718093409',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='EUR' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:34:20], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:34:20',track_id='17212952601579',voucher_id='20240718093420',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='USD' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:34:22], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:34:22',track_id='17212952627032',voucher_id='20240718093422',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='JOD' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:34:28], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:34:28',track_id='17212952689012',voucher_id='20240718093428',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='USD' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:34:30], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:34:30',track_id='17212952709026',voucher_id='20240718093430',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='JOD' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:34:35], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:34:35',track_id='17212952756563',voucher_id='20240718093435',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='USD' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:34:37], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:34:37',track_id='17212952776781',voucher_id='20240718093437',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='EUR' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:34:39], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:34:39',track_id='17212952795970',voucher_id='20240718093439',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='USD' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:34:42], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:34:42',track_id='17212952821217',voucher_id='20240718093442',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='JOD' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:35:14], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.php],update payment_log set payment_gateway_response='a:4:{s:6:\"result\";a:2:{s:4:\"code\";s:11:\"200.300.404\";s:11:\"description\";s:155:\"invalid or missing parameter - (opp) No payment session found for the requested id - are you mixing test/live servers or have you paid more than 30min ago?\";}s:11:\"buildNumber\";s:66:\"3061801254dc61c68da9c0ff3741d3eb7fff8b14@2024-07-17 00:42:32 +0000\";s:9:\"timestamp\";s:24:\"2024-07-18 09:35:14+0000\";s:3:\"ndc\";s:65:\"8a8294174f4f8b3f014f5efca5c40940_4996dc9bfd56444ba59f83e599a8aa9b\";}',return_date='1721295314',payment_status='Transaction Unsuccessful',gateway_point='on_readresponse',orderID= '' where unique_ref_id='' and gateway_code='HP';
[07/18/2024 09:35:14], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.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','0','2024-07-18 09:35:14','43.239.53.130','17212953146323','20240718093442','','uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com','','HP','on_selection','EUR');
[07/18/2024 09:35:15], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:35:15',track_id='17212953156333',voucher_id='20240718093515',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='EUR' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:35:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/18/2024 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '65' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[07/18/2024 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [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 09:35:53], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-07-18 09:35:53',`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;\&#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 09:35:57], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 09:35:57',login_attempt=0 where id = '7857';
[07/18/2024 09:35:57], [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 09:35:57', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 09:36:20], [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/07/19' , departure_date = '2024/07/20' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-18 09:36:20' , 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 09:36:22], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '367',
        request_path = '/xml_all.php?userid=7857&sessionid=78571820240709362018477502100',
        duration = '1.685',
        merge_duration = '0.004',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '5.29',
        system_load_5_min = '6.39',
        system_load_15_min = '9.43',
        system_memory_usage = '89.20',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2610') + '2221584',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2610';
[07/18/2024 09:36:33], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721295393','43.239.53.130');
[07/18/2024 09:36:33], [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', 'e1/18_07_2024/request_availability_Deepak_T_2610_1721295393_69.json', 'e1/18_07_2024/response_availability_Deepak_T_2610_1721295393_69.json', 'e1/18_07_2024/response_header_availability_Deepak_T_2610_1721295393_69.json', 'expedia', '2024-07-18 09:36:33', '', '78571820240709362018477502100', '2610', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_availability_Deepak_T_2610_1721295393_69.json');
[07/18/2024 09:36: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', 'e1/18_07_2024/request_valuation_Deepak_T_2610_1721295393_22.json', 'e1/18_07_2024/response_valuation_Deepak_T_2610_1721295393_22.json', 'e1/18_07_2024/response_header_valuation_Deepak_T_2610_1721295393_22.json', 'expedia', '2024-07-18 09:36:34', '', '78571820240709362018477502100', '2610', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_valuation_Deepak_T_2610_1721295393_22.json');
[07/18/2024 09:36:34], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='expedia Rate Change on Book Now Astra',  message='On Book Now page, Rate Change has been found for Supplier expedia:<br><br>Old Supplier  Rate:29.78 USD<br><font color=\'red\'><b>New Supplier rate:31.09 USD</b></font><br>Old Agent  Rate:57.63 USD<br><font color=\'red\'><b>Agent New rate:60.17 </b></font><br>Agency Name:Qtech<br>Agent Name:Deepak&nbsp;trivedi<br>City:dubai<br>Arrival Date:2024/07/19<br>Departure Date:2024/07/20<br>Supplier - expedia<br>Hotel:NIHAL HOTEL<br>Total Nights:1<br>Date :18-07-2024<br><b>Room Info</b><br><hr><b> Room Type </b>:Deluxe Room , 2 Twin Beds or 1 Double Bed , Room Only (Private sale: save 5%) <br> <b>Number of Rooms </b>:1 <b>Room Name </b>:double<br><br> ',  email_sent ='yes', create_date ='2024-07-18 09:36:34', email_sent_to ='rohan.vartak@qtechsoftware.com,rohan.vartak@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[07/18/2024 09:36:34], [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 ('Nihal Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelratechange', '2024-07-18 :09:36:34','');
[07/18/2024 09:37:13], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721295433','43.239.53.130');
[07/18/2024 09:37:17], [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','45.97','2024-07-18 09:37:17','43.239.53.130','17212954373075','20240718093717','4905','uid_7857##fname_sup##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_supriya@gmail.com##phone_9987204292##siteurl_beta.astrabookings.com','4905_1721295437_hotel','HP','on_selection','EUR');
[07/18/2024 09:37:23], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721295443','43.239.53.130');
[07/18/2024 09:37:24], [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','61.37','2024-07-18 09:37:24','43.239.53.130','17212954444995','20240718093724','4905','uid_7857##fname_sup##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_supriya@gmail.com##phone_9987204292##siteurl_beta.astrabookings.com','4905_1721295444_hotel','HP','on_selection','USD');
[07/18/2024 09:37:26], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721295446','43.239.53.130');
[07/18/2024 09:37:27], [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','43.5','2024-07-18 09:37:27','43.239.53.130','17212954478718','20240718093727','4905','uid_7857##fname_sup##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_supriya@gmail.com##phone_9987204292##siteurl_beta.astrabookings.com','4905_1721295447_hotel','HP','on_selection','JOD');
[07/18/2024 09:38:02], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set gateway_point='on_transfer',payment_gateway_request='s:191:\"entityId=8a8294174f4f8b3f014f5efca5c40940&paymentType=DB&amount=44&currency=JOD&merchantTransactionId=20240718093727&customer.email=supriya@gmail.com&customParameters[SHOPPER_customerId]=7857\";',pg_markup='2' where unique_ref_id='4905_1721295447_hotel' and gateway_code='HP';
[07/18/2024 09:38:37], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.php],update payment_log set payment_gateway_response='a:4:{s:6:\"result\";a:3:{s:4:\"code\";s:11:\"200.300.404\";s:11:\"description\";s:28:\"invalid or missing parameter\";s:15:\"parameterErrors\";a:1:{i:0;a:3:{s:4:\"name\";s:8:\"entityId\";s:5:\"value\";N;s:7:\"message\";s:28:\"invalid or missing parameter\";}}}s:11:\"buildNumber\";s:66:\"3061801254dc61c68da9c0ff3741d3eb7fff8b14@2024-07-17 00:42:32 +0000\";s:9:\"timestamp\";s:24:\"2024-07-18 09:38:37+0000\";s:3:\"ndc\";s:46:\"CFACCF9867F132935A0787C6E016B830.uat01-vm-tx01\";}',return_date='1721295516',payment_status='Transaction Unsuccessful',gateway_point='on_readresponse',orderID= '' where unique_ref_id='' and gateway_code='HP';
[07/18/2024 09:38:37], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.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','0','2024-07-18 09:38:37','43.239.53.130','17212955174488','','','uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_##mob_0##email_##phone_##siteurl_beta.astrabookings.com','','HP','on_selection','EUR');
[07/18/2024 09:38:39], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:38:39',track_id='17212955191863',voucher_id='20240718093839',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='EUR' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:39:05], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:39:05',track_id='17212955451982',voucher_id='20240718093905',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='USD' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:39:07], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:39:07',track_id='17212955472732',voucher_id='20240718093907',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='JOD' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:41:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/18/2024 09:41:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '102' ,status = '' ,priority = '12' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/18/2024 09:41:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '98' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[07/18/2024 09:41:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/18/2024 09:41:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '99' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '74' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/18/2024 09:41:16], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '75' ,status = '' ,priority = '9' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '84' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '101' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '103' ,status = '' ,priority = '5' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '1200',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '81' ,status = '1' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/18/2024 09:41:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'SUJAY_QTECH',`create_date`= '2024-07-18 09:41:17',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 77 ,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;949\&#039;,supplier_id = 89 ,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;949\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 76 ,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;949\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 99 ,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;949\&#039;,supplier_id = 86 ,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;949\&#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;949\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 96 ,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;949\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 60 ,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;949\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 1 ,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;949\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#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;949\&#039;,supplier_id = 73 ,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;949\&#039;,supplier_id = 85 ,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;949\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 100 ,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;949\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;1200\&#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;949\&#039;,supplier_id = 57 ,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;949\&#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;949\&#039;,supplier_id = 81 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#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;949\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-949 ## supplier_id- 81 ## company_name - Amadeus Flight ## supplier_code-amadeus  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '43.239.53.130';
[07/18/2024 09:41:20], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 09:41:20',login_attempt=0 where id = '949';
[07/18/2024 09:41:20], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-18 09:41:20', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 09:41:38], [file name :-/efsdata/otrams/public_html/beta/m1_flight_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '43.239.53.130' , service_type = 'Airline' , arrival_date = '2024/07/31' , departure_date = '2024/08/01' , create_date = '2024-07-18 :09:41:38' , origin = 'DCG' , destination = 'BOM' , site_id = '' ;
[07/18/2024 09:41:48], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set gateway_point='on_transfer',payment_gateway_request='s:173:\"entityId=8a8294174f4f8b3f014f5efca5c40940&paymentType=DB&amount=0&currency=JOD&merchantTransactionId=20240718093907&customer.email=&customParameters[SHOPPER_customerId]=7857\";',pg_markup='2' where unique_ref_id='' and gateway_code='HP';
[07/18/2024 09:42:46], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.php],update payment_log set payment_gateway_response='a:4:{s:6:\"result\";a:3:{s:4:\"code\";s:11:\"200.300.404\";s:11:\"description\";s:28:\"invalid or missing parameter\";s:15:\"parameterErrors\";a:1:{i:0;a:3:{s:4:\"name\";s:6:\"amount\";s:5:\"value\";N;s:7:\"message\";s:66:\"must be greater than 0.00 for paymentBrand VISA and paymentType DB\";}}}s:11:\"buildNumber\";s:66:\"3061801254dc61c68da9c0ff3741d3eb7fff8b14@2024-07-17 00:42:32 +0000\";s:9:\"timestamp\";s:24:\"2024-07-18 09:42:45+0000\";s:3:\"ndc\";s:46:\"F0E142290286DC17F862FB112A127842.uat01-vm-tx02\";}',return_date='1721295766',payment_status='Transaction Unsuccessful',gateway_point='on_readresponse',orderID= '' where unique_ref_id='' and gateway_code='HP';
[07/18/2024 09:42:46], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_response.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','0','2024-07-18 09:42:46','43.239.53.130','17212957664147','20240718093907','','uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com','','HP','on_selection','EUR');
[07/18/2024 09:42:48], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set created_date='2024-07-18 09:42:48',track_id='17212957681978',voucher_id='20240718094248',payment_track='uid_7857##fname_##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_##phone_##siteurl_beta.astrabookings.com',unique_ref_id='',gateway_point='on_selection',currency='EUR' where agent_id='7857'and booking_amount='0' and ip_address='43.239.53.130' and reservation_id='' and gateway_code='HP' and (payment_status=''  OR payment_status IS NULL);
[07/18/2024 09:48:14], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_09_48_14_1721296094.xml','amadeus','2024-07-18 09:48:14','13551424');
[07/18/2024 09:48:15], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_09_48_14_1721296094.xml','Amadeus','2024-07-18 09:48:15','13551424');
[07/18/2024 09:53:56], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 09:53:56',login_attempt=0 where id = '7857';
[07/18/2024 09:53:56], [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 09:53:56', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 09:54:16], [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/07/19' , departure_date = '2024/07/20' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-18 09:54: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' ;
[07/18/2024 09:54:19], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '367',
        request_path = '/xml_all.php?userid=7857&sessionid=78571820240709541683463495459',
        duration = '2.768',
        merge_duration = '0.005',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '27.61',
        system_load_5_min = '20.32',
        system_load_15_min = '16.61',
        system_memory_usage = '87.11',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2611') + '2221272',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2611';
[07/18/2024 09:54:44], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721296484','43.239.53.130');
[07/18/2024 09:54:44], [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', 'e1/18_07_2024/request_availability_Deepak_T_2611_1721296484_96.json', 'e1/18_07_2024/response_availability_Deepak_T_2611_1721296484_96.json', 'e1/18_07_2024/response_header_availability_Deepak_T_2611_1721296484_96.json', 'expedia', '2024-07-18 09:54:44', '', '78571820240709541683463495459', '2611', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_availability_Deepak_T_2611_1721296484_96.json');
[07/18/2024 09:54:45], [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', 'e1/18_07_2024/request_valuation_Deepak_T_2611_1721296484_46.json', 'e1/18_07_2024/response_valuation_Deepak_T_2611_1721296484_46.json', 'e1/18_07_2024/response_header_valuation_Deepak_T_2611_1721296484_46.json', 'expedia', '2024-07-18 09:54:45', '', '78571820240709541683463495459', '2611', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/e1/18_07_2024/response_valuation_Deepak_T_2611_1721296484_46.json');
[07/18/2024 09:54:46], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='expedia Rate Change on Book Now Astra',  message='On Book Now page, Rate Change has been found for Supplier expedia:<br><br>Old Supplier  Rate:29.78 USD<br><font color=\'red\'><b>New Supplier rate:31.09 USD</b></font><br>Old Agent  Rate:57.63 USD<br><font color=\'red\'><b>Agent New rate:60.17 </b></font><br>Agency Name:Qtech<br>Agent Name:Deepak&nbsp;trivedi<br>City:dubai<br>Arrival Date:2024/07/19<br>Departure Date:2024/07/20<br>Supplier - expedia<br>Hotel:NIHAL HOTEL<br>Total Nights:1<br>Date :18-07-2024<br><b>Room Info</b><br><hr><b> Room Type </b>:Deluxe Room , 1 Double Bed or 2 Twin Beds , Room Only (Private sale: save 5%) <br> <b>Number of Rooms </b>:1 <b>Room Name </b>:double<br><br> ',  email_sent ='yes', create_date ='2024-07-18 09:54:46', email_sent_to ='rohan.vartak@qtechsoftware.com,rohan.vartak@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[07/18/2024 09:54:46], [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 ('Nihal Hotel', 'dubai', '138', '7857', '', '23', '', 'hotelratechange', '2024-07-18 :09:54:46','');
[07/18/2024 09:56:03], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721296563','43.239.53.130');
[07/18/2024 09:56:05], [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','45.97','2024-07-18 09:56:05','43.239.53.130','17212965652127','20240718095605','4909','uid_7857##fname_supriya##bid_652##route_bookflow##type_B2B##pg_HP##mob_0##email_supriya@gmail.com##phone_9987204292##siteurl_beta.astrabookings.com','4909_1721296565_hotel','HP','on_selection','EUR');
[07/18/2024 09:56:34], [file name :-/efsdata/otrams/public_html/beta/payment_gateway_step1.php],update payment_log set gateway_point='on_transfer',payment_gateway_request='s:191:\"entityId=8a829418537b334501537ebdbd6f03a9&paymentType=DB&amount=46&currency=EUR&merchantTransactionId=20240718095605&customer.email=supriya@gmail.com&customParameters[SHOPPER_customerId]=7857\";',pg_markup='2' where unique_ref_id='4909_1721296565_hotel' and gateway_code='HP';
[07/18/2024 09:58:51], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-18 09:58:51',login_attempt=0 where id = '7857';
[07/18/2024 09:58:56], [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 09:58:56', ip = '43.239.53.130', action = 'Login' ;
[07/18/2024 09:59:34], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/18_07_2024/request_Availability_yogeshqtech_09_59_34_1721296774.xml','amadeus','2024-07-18 09:59:34','13551424');
[07/18/2024 09:59:34], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/18_07_2024/response_Availability_yogeshqtech_09_59_34_1721296774.xml','Amadeus','2024-07-18 09:59:34','13551424');
