[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '67' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '52' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '80' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '76' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '24' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '77' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '64' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '65' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '34' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '20' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '55' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '62' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '53' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '16' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '81' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '78' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '75' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '60' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '18' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '19' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '73' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '71' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '69' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '68' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '74' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '35' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '70' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '59' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '32' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '58' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '56' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '57' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '61' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '63' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '54' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/01/2024 05:03:05], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-07-01 05:03:05',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 80 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 45 ,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;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7873 ## supplier_id- 67 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7873 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/01/2024 05:03:09], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-01 05:03:09',login_attempt=0 where id = '7873';
[07/01/2024 05:03:09], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-07-01 05:03:09', ip = '43.239.53.130', action = 'Login' ;
[07/01/2024 05:03:21], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/02' , departure_date = '2024/07/03' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-01 05:03: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/01/2024 05:03:23], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '348',
        request_path = '/xml_all.php?userid=7873&sessionid=7873012024070503217249201703',
        duration = '1.537',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.15',
        system_load_5_min = '1.13',
        system_load_15_min = '1.14',
        system_memory_usage = '23.51',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2484') + '2222576',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2484';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '67' ,status = '1' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '52' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '80' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '76' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '24' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '77' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '64' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '65' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '34' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '20' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '55' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '62' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '53' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '16' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '81' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '78' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '75' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '60' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '18' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '19' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '73' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '71' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '69' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '68' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '74' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '35' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '70' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '59' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '32' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '58' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '56' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '57' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '61' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '63' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '54' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7873',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/01/2024 05:09:57], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-07-01 05:09:57',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7873\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 80 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 62 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;0\&#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;7873\&#039;,supplier_id = 45 ,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;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7873 ## supplier_id- 64 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[07/01/2024 05:10:11], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-01 05:10:11',login_attempt=0 where id = '7873';
[07/01/2024 05:10:11], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Gajendra', user_type = 'A', branch_id = '1', login_datetime = '2024-07-01 05:10:11', ip = '43.239.53.130', action = 'Login' ;
[07/01/2024 05:10:23], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7873' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '43.239.53.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/02' , departure_date = '2024/07/03' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-01 05:10:23' , 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/01/2024 05:10:24], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '1',
        request_path = '/xml_all.php?userid=7873&sessionid=78730120240705102394230765523',
        duration = '0.999',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.40',
        system_load_5_min = '1.26',
        system_load_15_min = '1.19',
        system_memory_usage = '39.63',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '2485') + '2222336',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '2485';
[07/01/2024 05:31:55], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-01 05:31:55',login_attempt=0 where id = '7851';
[07/01/2024 05:31:56], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-07-01 05:31:56', ip = '43.239.53.130', action = 'Login' ;
[07/01/2024 05:33:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/07/24',  departure_date='2024/07/24',  nights='1',  create_date='2024-07-01 :05:33:13',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[07/01/2024 05:33:59], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'jaipur' , arrival_date='2024/07/24',  departure_date='2024/07/24',  nights='1',  create_date='2024-07-01 :05:33:59',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[07/01/2024 05:34:05], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_33_59_1719812039.json', 'v1/01_07_2024/response_availability_Viator_test_05_33_59_1719812039.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_33_59_1719812039.json', 'viator', '2024-07-01 05:34:05', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_33_59_1719812039.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:12], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:12', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:13], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:13', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:14], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:14', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:14], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:14', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:14], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:14', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:14], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:14', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:14], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:14', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:14], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:14', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:14], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:14', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:14], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.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', 'v1/01_07_2024/request_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json', 'v1/01_07_2024/response_header_availability_Viator_test_05_34_06_1719812046_29.json', 'viator', '2024-07-01 05:34:14', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_availability_Viator_test_05_34_06_1719812046_29.json');
[07/01/2024 05:34:21], [file name :-/efsdata/otrams/public_html/beta/user_sight_details.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 ('', 'SIGHT_DETAILS', 'v1/01_07_2024/request_sight_details_Viator_test_05_34_21_1719812061.json', 'v1/01_07_2024/response_sight_details_Viator_test_05_34_21_1719812061.json', 'v1/01_07_2024/response_header_sight_details_Viator_test_05_34_21_1719812061.json', 'viator', '2024-07-01 05:34:21', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_sight_details_Viator_test_05_34_21_1719812061.json');
[07/01/2024 05:34:21], [file name :-/efsdata/otrams/public_html/beta/user_sight_details.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 ('', 'SIGHT_DETAILS', 'v1/01_07_2024/request_sight_details_Viator_test_05_34_21_1719812061.json', 'v1/01_07_2024/response_sight_details_Viator_test_05_34_21_1719812061.json', 'v1/01_07_2024/response_header_sight_details_Viator_test_05_34_21_1719812061.json', 'viator', '2024-07-01 05:34:21', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_sight_details_Viator_test_05_34_21_1719812061.json');
[07/01/2024 05:34:27], [file name :-/efsdata/otrams/public_html/beta/user_sight_details.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 ('', 'CHECK_AVAILABILITY', 'v1/01_07_2024/request_check_availability_Viator_test_05_34_27_1719812067.json', 'v1/01_07_2024/response_check_availability_Viator_test_05_34_27_1719812067.json', 'v1/01_07_2024/response_header_check_availability_Viator_test_05_34_27_1719812067.json', 'viator', '2024-07-01 05:34:27', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_check_availability_Viator_test_05_34_27_1719812067.json');
[07/01/2024 05:34:44], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-01 05:34:44', ip = '205.210.31.56', action = 'Login' ;
[07/01/2024 05:34:50], [file name :-/efsdata/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1719812090','43.239.53.130');
[07/01/2024 05:36:19], [file name :-/efsdata/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1719812179','43.239.53.130');
[07/01/2024 05:36:20], [file name :-/efsdata/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='4754',agent_id='7851',leader_title='Mr',leader_first_name='Shiv',leader_last_name='tez',city_id='jaipur',country_id='106',nationality='Indian',display_room_rate='29.64',display_currency_code='USD',native_room_rate='2.86',consultant_id='SUJAY_QTECH',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Jul 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 29.64  applicable if cancelled after 18 Jul 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-07-01 05:36:20',source_type='viator',expiration_date= '2024-07-23 21:00:00',applied_multiplier='1.00000',applied_markup='936.36363636364',agent_markup='936.36363636364',basecurrency_multiplier='1.00000',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-07-24',sub_user_id='',check_out_date='2024-07-24',supplier_profile_id='',agent_currency_multiplier='3.7507', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9876543210',service_type='sightseeing';
[07/01/2024 05:36:20], [file name :-/efsdata/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='633',reservation_id='4753',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:2.8599999999999999;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:29.640000000000001;s:25:\"displayNightlyRateDisplay\";s:151:\"Rate - 2.86 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR - 100.00,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:152:\"Rate - 2.86 USD, Currency Multiplier (USD-USD) - 1.00000, Markup  in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR - 100.00 ,Other Markup - 0%\";}',display_currency_code='USD',native_currency_code='USD',sight_id='414099P8',sight_name='PRIVATE GUIDED HALF DAY TOUR JAIPUR  - V2',tour_time='',tour_details='',tour_inclusive='P<br/>',tour_exclusive='M<br/>',meeting_point='',tour_dep_point=' ',tour_language='fr/SERVICE_GUIDE',tour_supplier_phone='',booking_remark='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 10:00',arrival_date='2024-07-24',total_adults='1',total_children='0',total_infants='',gta_city_code='4627',supplier_id='414099P8',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',terms_n_condition='';
[07/01/2024 05:36:20], [file name :-/efsdata/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','4753','2024-07-01 05:36:20',0);
[07/01/2024 05:36:23], [file name :-/efsdata/otrams/public_html/beta/confirm_booking_sightseeing.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 ('', 'RESERVATION_SIGHT', 'v1/01_07_2024/request_reservation_sight_Viator_test_05_36_20_1719812180.json', 'v1/01_07_2024/response_reservation_sight_Viator_test_05_36_20_1719812180.json', 'v1/01_07_2024/response_header_reservation_sight_Viator_test_05_36_20_1719812180.json', 'viator', '2024-07-01 05:36:23', '', '', '2490', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_reservation_sight_Viator_test_05_36_20_1719812180.json');
[07/01/2024 05:36:23], [file name :-/efsdata/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '528';
[07/01/2024 05:36:23], [file name :-/efsdata/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7851', applicable_service_tax='0', sub_agent_rate='0', agent_rate='29.64', supplier_rate='2.86', uid='', itenirary_id='4753791', confirmation_number='BR-596750613', comment_contract='', current_status='confirmed', original_source='' where id='633';
[07/01/2024 05:36:23], [file name :-/efsdata/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',viator_item_ref='BR-596750613',viator_ref='BR-596750613',viator_item_id='',viator_voucherKey='https://api.sandbox.viator.com/ticket?code=1021658977:c77a1141ba14a8e4213a89721d05cd6a46b6f514b702aeb29fad1b74de373dd3:596750613',tour_supplier='' where booking_id='633';
[07/01/2024 05:36:23], [file name :-/efsdata/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','633','confirmed','2024-07-01 05:36:23','Sightseeing Booking confirmed by Agent..7851','7851','43.239.53.130','','','');
[07/01/2024 05:36:23], [file name :-/efsdata/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('633','Mr','1','Shiv','tez','adult','0');
[07/01/2024 05:36:23], [file name :-/efsdata/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='633' where agent_logs_id='2490' and source_type='viator';
[07/01/2024 05:51:41], [file name :-/efsdata/otrams/public_html/beta/get_cancellation_fee_sight.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('633', 'SIGHT_CANCELLATION_FEE', 'v1/01_07_2024/request_sight_cancellation_fee_Viator_test_633_05_51_40_1719813100.json', 'v1/01_07_2024/response_sight_cancellation_fee_Viator_test_633_05_51_40_1719813100.json', 'v1/01_07_2024/response_header_sight_cancellation_fee_Viator_test_633_05_51_40_1719813100.json', 'viator', '2024-07-01 05:51:41', '','https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/01_07_2024/response_sight_cancellation_fee_Viator_test_633_05_51_40_1719813100.json');
