[05/21/2024 11:30:25], [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-05-21 11:30:25', ip = '157.55.39.15', action = 'Login' ;
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '52' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '80' ,status = '' ,priority = '7' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '76' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '64' ,status = '' ,priority = '12' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '65' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '34' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '20' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '62' ,status = '1' ,priority = '8' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '8';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '53' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '81' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '60' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '18' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '19' ,status = '' ,priority = '12' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '73' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '71' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '69' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '68' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '74' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '35' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '70' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '59' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '32' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '58' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '56' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '57' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '61' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '63' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '54' ,status = '' ,priority = '7' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7857',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[05/21/2024 11:37:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-05-21 11:37:50',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 52 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 80 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;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;7857\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;24\&#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;7857\&#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;7857\&#039;,supplier_id = 34 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 20 ,status = \&#039;\&#039; ,priority = \&#039;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;7857\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 62 ,status = \&#039;1\&#039; ,priority = \&#039;8\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;8\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 53 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#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;7857\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 18 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 19 ,status = \&#039;\&#039; ,priority = \&#039;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;7857\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 71 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 35 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 70 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 59 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 32 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 61 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 63 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 54 ,status = \&#039;\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7857\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#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-7857 ## supplier_id- 55 ## company_name - Hotels Pro ## supplier_code-hotelspro  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7857 ## supplier_id- 62 ## company_name - local_system ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-7857 ## supplier_id- 58 ## company_name - Viator (SightSeeing) ## supplier_code-viator  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '43.239.53.130';
[05/21/2024 11:38:00], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-21 11:38:00',login_attempt=0 where id = '7857';
[05/21/2024 11:38:00], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-05-21 11:38:00', ip = '43.239.53.130', action = 'Login' ;
[05/21/2024 11:38:25], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/22' , departure_date = '2024/05/23' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 11:38:25' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 11:38:27], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 11:38:27', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1827');
[05/21/2024 11:38:27], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 11:38:27.487'
        , request_start_time = '0.053'
        , parsing_start_time = '0.030'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.242'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5499496'
        WHERE id = '554782';
[05/21/2024 11:38:27], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.475',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '8.34',
        system_load_5_min = '8.13',
        system_load_15_min = '8.28',
        system_memory_usage = '95.26',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1827') + '6446888',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1827';
[05/21/2024 11:40:08], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],update supplier set hash='0cb4deba607f8244c02997a42665a6d5' where SupplierId = '';
[05/21/2024 11:41:51], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/25' , departure_date = '2024/05/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 11:41:51' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 11:41:52], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 11:41:52', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1828');
[05/21/2024 11:41:52], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 11:41:52.281'
        , request_start_time = '0.041'
        , parsing_start_time = '0.018'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.206'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5497856'
        WHERE id = '554783';
[05/21/2024 11:41:52], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.397',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '22.08',
        system_load_5_min = '12.93',
        system_load_15_min = '10.03',
        system_memory_usage = '92.68',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1828') + '6448264',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1828';
[05/21/2024 11:42:18], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/25' , departure_date = '2024/05/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 11:42:18' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 11:42:19], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 11:42:19', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1829');
[05/21/2024 11:42:19], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 11:42:19.635'
        , request_start_time = '0.029'
        , parsing_start_time = '0.015'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.096'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5498736'
        WHERE id = '554784';
[05/21/2024 11:42:19], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.270',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '14.94',
        system_load_5_min = '11.99',
        system_load_15_min = '9.80',
        system_memory_usage = '92.62',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1829') + '6448480',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1829';
[05/21/2024 11:42:44], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/27' , departure_date = '2024/05/28' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 11:42:44' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 11:42:45], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 11:42:45', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1830');
[05/21/2024 11:42:45], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 11:42:45.584'
        , request_start_time = '0.026'
        , parsing_start_time = '0.018'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.165'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5498624'
        WHERE id = '554785';
[05/21/2024 11:42:45], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.316',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '9.98',
        system_load_5_min = '11.06',
        system_load_15_min = '9.55',
        system_memory_usage = '92.96',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1830') + '6448488',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1830';
[05/21/2024 11:43:46], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('4@S000000002@2024-05-21@2024-05-21@@497@2@19@@@0','21-05-2024~21-05-2024','4','S000000002','2024-05-21','2024-05-21','497','2','43.239.53.130','0','0','89457bcf58e8aeaa2b9e54ce12ca44af','Sa,Su','19','Supplier','26','A','20','20','INR','0','2','24','0','','','0','4ed55f9883f52da327bbe0bd3474e234','2024-03-05 10:06:26','2024-03-05','Supplier','Supplier','2024-05-21','2024-05-21 11:43:46','Supplier','0','');
[05/21/2024 11:43:46], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('689');
[05/21/2024 11:43:46], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 11:43:46',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For TAJ Qtech Rate:- 20 Room Category :- Delux_taj - Double (Room Only) Market :- localsystem From:- 21-05-2024 To:- 20-06-2024',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000002';
[05/21/2024 11:43:46], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3384', `entity`='Hotels', `value`='4' ;
[05/21/2024 11:43:46], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3384', `entity`='Suppliers', `value`='S000000002' ;
[05/21/2024 11:43:46], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3384', `entity`='Inventory', `value`='26' ;
[05/21/2024 11:43:47], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3384', `entity`='Room', `value`='497' ;
[05/21/2024 11:43:47], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3384', `entity`='Market', `value`='19' ;
[05/21/2024 11:43:47], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('4@S000000002@2024-05-22@2024-05-22@@497@2@19@@@0','22-05-2024~22-05-2024','4','S000000002','2024-05-22','2024-05-22','497','2','43.239.53.130','0','0','89a48d41b108c4be89f574c036b2eb11','Sa,Su','19','Supplier','26','A','20','20','INR','0','2','24','0','','','0','9b18d668320c32db783b30b973d12824','2024-03-05 10:06:26','2024-03-05','Supplier','Supplier','2024-05-21','2024-05-21 11:43:46','Supplier','0',''),('4@S000000002@2024-05-23@2024-05-23@@497@2@19@@@0','23-05-2024~23-05-2024','4','S000000002','2024-05-23','2024-05-23','497','2','43.239.53.130','0','0','415d25195dcba31a6ac3e2b0419ac989','Sa,Su','19','Supplier','26','A','20','20','INR','0','2','24','0','','','0','d792a0d1c0d05e453f2b565ccce14cb9','2024-03-05 10:06:26','2024-03-05','Supplier','Supplier','2024-05-21','2024-05-21 11:43:46','Supplier','0',''),('4@S000000002@2024-05-24@2024-05-24@@497@2@19@@@0','24-05-2024~24-05-2024','4','S000000002','2024-05-24','2024-05-24','497','2','43.239.53.130','0','0','7ea7c49d7182a0d7b0687fbf4c90114c','Sa,Su','19','Supplier','26','A','20','20','INR','0','2','24','0','','','0','9c02828ecd9eafa18814d24b2de33ba4','2024-03-05 10:06:26','2024-03-05','Supplier','Supplier','2024-05-21','2024-05-21 11:43:46','Supplier','0',''),('4@S000000002@2024-05-25@2024-05-25@@497@2@19@@@0','25-05-2024~25-05-2024','4','S000000002','2024-05-25','2024-05-25','497','2','43.239.53.130','0','0','02b88eef420700da3c08cc9c02746227','Sa,Su','19','Supplier','26','A','20','20','INR','0','1','24','0','','','0','c2c944ff066c5a50de68e17705c8dd35','2024-03-05 10:06:26','2024-03-05','Supplier','Supplier','2024-05-21','2024-05-21 11:43:46','Supplier','0',''),('4@S000000002@2024-05-26@2024-05-26@@497@2@19@@@0','26-05-2024~26-05-2024','4','S000000002','2024-05-26','2024-05-26','497','2','43.239.53.130','0','0','825ed3604352ff816a2c74535eff6bf3','Sa,Su','19','Supplier','26','A','20','20','INR','0','1','24','0','','','0','6788e14775b956cf322fa5b4754d469a','2024-03-05 10:06:26','2024-03-05','Supplier','Supplier','2024-05-21','2024-05-21 11:43:46','Supplier','0',''),('4@S000000002@2024-05-27@2024-05-27@@497@2@19@@@0','27-05-2024~27-05-2024','4','S000000002','2024-05-27','2024-05-27','497','2','43.239.53.130','0','0','9351c7879703823e87b94d58fdd275c2','Sa,Su','19','Supplier','26','A','20','20','INR','0','2','24','0','','','0','cc2925aaa5f16add7d08ac91908c6cb0','2024-03-05 10:06:26','2024-03-05','Supplier','Supplier','2024-05-21','2024-05-21 11:43:46','Supplier','0',''),('4@S000000002@2024-05-28@2024-05-28@@497@2@19@@@0','28-05-2024~28-05-2024','4','S000000002','2024-05-28','2024-05-28','497','2','43.239.53.130','0','0','4e0d0c2559037a86ebffe1b3f0ad1c80','Sa,Su','19','Supplier','26','A','20','20','INR','0','2','24','0','','','0','0a188a2e12226a3f37558c710af9eda3','2024-03-05 10:06:26','2024-03-05','Supplier','Supplier','2024-05-21','2024-05-21 11:43:46','Supplier','0',''),('4@S000000002@2024-05-29@2024-05-29@@497@2@19@@@0','29-05-2024~29-05-2024','4','S000000002','2024-05-29','2024-05-29','497','2','43.239.53.130','0','0','20d6ef3c6a8d13d5728d637e271ea2dc','Sa,Su','19','Supplier','26','A','20','20','INR','0','2','24','0','','','0','7d6e8a6235b9960cb494df98187f007a','2024-03-05 10:06:26','2024-03-05','Supplier','Supplier','2024-05-21','2024-05-21 11:43:46','Supplier','0',''),('4@S000000002@2024-05-30@2024-05-30@@497@2@19@@@0','30-05-2024~30-05-2024','4','S000000002','2024-05-30','2024-05-30','497','2','43.239.53.130','0','0','92697ae3d5a0a9b5f5df854f699cb8b0','Sa,Su','19','Supplier','26','A','20','20','INR','0','2','24','0','','','0','a64ffee0f97470871ce9f4070747392d','2024-03-05 10:06:26','2024-03-05','Supplier','Supplier','2024-05-21','2024-05-21 11:43:46','Supplier','0',''),('4@S000000002@2024-05-31@2024-05-31@@497@2@19@@@0','31-05-2024~31-05-2024','4','S000000002','2024-05-31','2024-05-31','497','2','43.239.53.130','0','0','776696dbc36debffb1bfb89eac24db22','Sa,Su','19','Supplier','26','A','20','20','INR','0','2','24','0','','','0','0a4cb0ad3897627f4396e785b0d83c60','2024-03-05 10:06:26','2024-03-05','Supplier','Supplier','2024-05-21','2024-05-21 11:43:46','Supplier','0',''),('4@S000000002@2024-06-01@2024-06-01@@497@2@19@@@0','01-06-2024~01-06-2024','4','S000000002','2024-06-01','2024-06-01','497','2','43.239.53.130','0','0','9e2c9f0a015bfdcaedbe7152345b3689','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','9e2c9f0a015bfdcaedbe7152345b3689','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-02@2024-06-02@@497@2@19@@@0','02-06-2024~02-06-2024','4','S000000002','2024-06-02','2024-06-02','497','2','43.239.53.130','0','0','c6598c5878a0b4b6b74ba122445f59e6','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','c6598c5878a0b4b6b74ba122445f59e6','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-03@2024-06-03@@497@2@19@@@0','03-06-2024~03-06-2024','4','S000000002','2024-06-03','2024-06-03','497','2','43.239.53.130','0','0','2c08a4cc820d8747bb145066fcb6a04b','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','2c08a4cc820d8747bb145066fcb6a04b','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-04@2024-06-04@@497@2@19@@@0','04-06-2024~04-06-2024','4','S000000002','2024-06-04','2024-06-04','497','2','43.239.53.130','0','0','7c55033d973982bd10163e3b5ae952ec','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','7c55033d973982bd10163e3b5ae952ec','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-05@2024-06-05@@497@2@19@@@0','05-06-2024~05-06-2024','4','S000000002','2024-06-05','2024-06-05','497','2','43.239.53.130','0','0','5781837233f371bb1df08e12add57faf','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','5781837233f371bb1df08e12add57faf','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-06@2024-06-06@@497@2@19@@@0','06-06-2024~06-06-2024','4','S000000002','2024-06-06','2024-06-06','497','2','43.239.53.130','0','0','a72afbe418c68f89a502d165dae2067d','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','a72afbe418c68f89a502d165dae2067d','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-07@2024-06-07@@497@2@19@@@0','07-06-2024~07-06-2024','4','S000000002','2024-06-07','2024-06-07','497','2','43.239.53.130','0','0','0651f882c1ac555dbec1144a1494884a','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','0651f882c1ac555dbec1144a1494884a','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-08@2024-06-08@@497@2@19@@@0','08-06-2024~08-06-2024','4','S000000002','2024-06-08','2024-06-08','497','2','43.239.53.130','0','0','71b0d035afa443029d1f407e5a6e312a','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','71b0d035afa443029d1f407e5a6e312a','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-09@2024-06-09@@497@2@19@@@0','09-06-2024~09-06-2024','4','S000000002','2024-06-09','2024-06-09','497','2','43.239.53.130','0','0','5e55f8d6cbee95677dd12139da33778d','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','5e55f8d6cbee95677dd12139da33778d','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-10@2024-06-10@@497@2@19@@@0','10-06-2024~10-06-2024','4','S000000002','2024-06-10','2024-06-10','497','2','43.239.53.130','0','0','a86b8875ee529540e7b2e0a1d5a7c60c','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','a86b8875ee529540e7b2e0a1d5a7c60c','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-11@2024-06-11@@497@2@19@@@0','11-06-2024~11-06-2024','4','S000000002','2024-06-11','2024-06-11','497','2','43.239.53.130','0','0','5231198620e2e628dc03987c4707f7d2','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','5231198620e2e628dc03987c4707f7d2','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-12@2024-06-12@@497@2@19@@@0','12-06-2024~12-06-2024','4','S000000002','2024-06-12','2024-06-12','497','2','43.239.53.130','0','0','06f9c2c2aa4216a97bbf3e71a2fda6c7','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','06f9c2c2aa4216a97bbf3e71a2fda6c7','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-13@2024-06-13@@497@2@19@@@0','13-06-2024~13-06-2024','4','S000000002','2024-06-13','2024-06-13','497','2','43.239.53.130','0','0','55aa2844b02c40472fe955151d5999ad','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','55aa2844b02c40472fe955151d5999ad','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-14@2024-06-14@@497@2@19@@@0','14-06-2024~14-06-2024','4','S000000002','2024-06-14','2024-06-14','497','2','43.239.53.130','0','0','7bbb2ab8602fa0ce586bb475ae2e9140','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','7bbb2ab8602fa0ce586bb475ae2e9140','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-15@2024-06-15@@497@2@19@@@0','15-06-2024~15-06-2024','4','S000000002','2024-06-15','2024-06-15','497','2','43.239.53.130','0','0','ecceb3002d3f3fe255779d75f72aafd8','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','ecceb3002d3f3fe255779d75f72aafd8','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-16@2024-06-16@@497@2@19@@@0','16-06-2024~16-06-2024','4','S000000002','2024-06-16','2024-06-16','497','2','43.239.53.130','0','0','5cf6cd87587cd41dcfc0d1f608cf47c0','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','5cf6cd87587cd41dcfc0d1f608cf47c0','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-17@2024-06-17@@497@2@19@@@0','17-06-2024~17-06-2024','4','S000000002','2024-06-17','2024-06-17','497','2','43.239.53.130','0','0','1f14c370d19df07d51a6dc1ec935098b','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','1f14c370d19df07d51a6dc1ec935098b','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-18@2024-06-18@@497@2@19@@@0','18-06-2024~18-06-2024','4','S000000002','2024-06-18','2024-06-18','497','2','43.239.53.130','0','0','300b0e7528a9fde949a4f1af0ee5fdd0','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','300b0e7528a9fde949a4f1af0ee5fdd0','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-19@2024-06-19@@497@2@19@@@0','19-06-2024~19-06-2024','4','S000000002','2024-06-19','2024-06-19','497','2','43.239.53.130','0','0','587a7f0ee29251f55183b4d697f136de','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','587a7f0ee29251f55183b4d697f136de','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0',''),('4@S000000002@2024-06-20@2024-06-20@@497@2@19@@@0','20-06-2024~20-06-2024','4','S000000002','2024-06-20','2024-06-20','497','2','43.239.53.130','0','0','4c7206ae63ef3de2ba284083d2e142af','Sa,Su','19','Supplier','26','A','20','20','INR','0','0','24','0','','','0','4c7206ae63ef3de2ba284083d2e142af','2024-05-21 11:43:46','2024-05-21','Supplier','','','','','0','');
[05/21/2024 11:43:47], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('690','691','692','693','694','695','696','697','698','699');
[05/21/2024 11:43:47], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO room_rate_profile (rate_profile,time_stamp) values(19,'9e2c9f0a015bfdcaedbe7152345b3689'),(19,'c6598c5878a0b4b6b74ba122445f59e6'),(19,'2c08a4cc820d8747bb145066fcb6a04b'),(19,'7c55033d973982bd10163e3b5ae952ec'),(19,'5781837233f371bb1df08e12add57faf'),(19,'a72afbe418c68f89a502d165dae2067d'),(19,'0651f882c1ac555dbec1144a1494884a'),(19,'71b0d035afa443029d1f407e5a6e312a'),(19,'5e55f8d6cbee95677dd12139da33778d'),(19,'a86b8875ee529540e7b2e0a1d5a7c60c'),(19,'5231198620e2e628dc03987c4707f7d2'),(19,'06f9c2c2aa4216a97bbf3e71a2fda6c7'),(19,'55aa2844b02c40472fe955151d5999ad'),(19,'7bbb2ab8602fa0ce586bb475ae2e9140'),(19,'ecceb3002d3f3fe255779d75f72aafd8'),(19,'5cf6cd87587cd41dcfc0d1f608cf47c0'),(19,'1f14c370d19df07d51a6dc1ec935098b'),(19,'300b0e7528a9fde949a4f1af0ee5fdd0'),(19,'587a7f0ee29251f55183b4d697f136de'),(19,'4c7206ae63ef3de2ba284083d2e142af');
[05/21/2024 11:45:43], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/27' , departure_date = '2024/05/28' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 11:45:43' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 11:45:46], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 11:45:46', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1831');
[05/21/2024 11:45:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 11:45:45.583'
        , request_start_time = '0.301'
        , parsing_start_time = '0.150'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '1.115'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5498608'
        WHERE id = '554786';
[05/21/2024 11:45:46], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '1.837',
        merge_duration = '0.031',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '50.92',
        system_load_5_min = '25.11',
        system_load_15_min = '15.01',
        system_memory_usage = '94.33',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1831') + '6448424',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1831';
[05/21/2024 11:46:51], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],update room_rates set  availability='2', consumed_inventory='0' where supplier_id='S000000002' AND hotel_id='4' AND inventory_class_id='26'  AND date_from >='2024-05-21' AND date_from <='2024-06-20' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')='0';
[05/21/2024 11:46:51], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],update room_rates set  availability='3', consumed_inventory='0' where supplier_id='S000000002' AND hotel_id='4' AND inventory_class_id='26'  AND date_from >='2024-05-21' AND date_from <='2024-06-20' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')>'0';
[05/21/2024 11:46:51], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 11:46:51',`log_type`= 'Inventory Allocation',`sql_query`= 'update room_rates set  availability=\&#039;2\&#039;, consumed_inventory=\&#039;0\&#039; where supplier_id=\&#039;S000000002\&#039; AND hotel_id=\&#039;4\&#039; AND inventory_class_id=\&#039;26\&#039;  AND date_from &gt;=\&#039;2024-05-21\&#039; AND date_from &lt;=\&#039;2024-06-20\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)=\&#039;0\&#039;&lt;br&gt;update room_rates set  availability=\&#039;3\&#039;, consumed_inventory=\&#039;0\&#039; where supplier_id=\&#039;S000000002\&#039; AND hotel_id=\&#039;4\&#039; AND inventory_class_id=\&#039;26\&#039;  AND date_from &gt;=\&#039;2024-05-21\&#039; AND date_from &lt;=\&#039;2024-06-20\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)&gt;\&#039;0\&#039;',`log_description`= 'Upadated Inventory Allocation For hotel TAJ Qtech- Inventory:-Delux_taj From:-21-05-2024 To:-20-06-2024 Weekday Inventory Allocation:-2 Weekend Inventory Allocation:-3',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000002';
[05/21/2024 11:46:51], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3385', `entity`='Hotels', `value`='4' ;
[05/21/2024 11:46:51], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3385', `entity`='Suppliers', `value`='S000000002' ;
[05/21/2024 11:46:51], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3385', `entity`='Inventory', `value`='26' ;
[05/21/2024 11:47:28], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/27' , departure_date = '2024/05/28' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 11:47:28' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 11:47:29], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 11:47:29', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1832');
[05/21/2024 11:47:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 11:47:29.782'
        , request_start_time = '0.030'
        , parsing_start_time = '0.018'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.102'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5498608'
        WHERE id = '554787';
[05/21/2024 11:47:29], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.283',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '20.44',
        system_load_5_min = '22.11',
        system_load_15_min = '15.04',
        system_memory_usage = '93.27',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1832') + '6448488',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1832';
[05/21/2024 11:47:51], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-05-21 11:47:51',login_attempt=0 where id = '7857';
[05/21/2024 11:47:51], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-05-21 11:47:51', ip = '43.239.53.130', action = 'Login' ;
[05/21/2024 11:48:08], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/29' , departure_date = '2024/05/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 11:48:08' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 11:48:12], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 11:48:12', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1833');
[05/21/2024 11:48:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 11:48:12.329'
        , request_start_time = '0.249'
        , parsing_start_time = '0.104'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.723'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5497856'
        WHERE id = '554788';
[05/21/2024 11:48:13], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '1.907',
        merge_duration = '0.041',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '45.57',
        system_load_5_min = '28.50',
        system_load_15_min = '17.54',
        system_memory_usage = '95.90',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1833') + '6448352',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1833';
[05/21/2024 11:49:22], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT INTO localsystem_cancellation_policy SET hotel_id='4',duration_type='days',from_duration='0',to_duration='1',amount_type='percentage',amount_value='5',from_date='2024-05-21',to_date='2024-05-31',supplier_id='S000000002',added_by='supplier';
[05/21/2024 11:49:22], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 11:49:22',`log_type`= 'Cancellation Policy',`sql_query`= 'INSERT INTO localsystem_cancellation_policy SET hotel_id=\&#039;4\&#039;,duration_type=\&#039;days\&#039;,from_duration=\&#039;0\&#039;,to_duration=\&#039;1\&#039;,amount_type=\&#039;percentage\&#039;,amount_value=\&#039;5\&#039;,from_date=\&#039;2024-05-21\&#039;,to_date=\&#039;2024-05-31\&#039;,supplier_id=\&#039;S000000002\&#039;,added_by=\&#039;supplier\&#039;',`log_description`= 'New cancellation policy added for TAJ Qtech by- Test_india supplier',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000002';
[05/21/2024 11:49:22], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3386', `entity`='Hotels', `value`='4' ;
[05/21/2024 11:49:22], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3386', `entity`='Suppliers', `value`='S000000002' ;
[05/21/2024 11:49:28], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/29' , departure_date = '2024/05/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 11:49:28' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 11:49:29], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 11:49:29', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1834');
[05/21/2024 11:49:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 11:49:29.249'
        , request_start_time = '0.031'
        , parsing_start_time = '0.019'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.234'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5497856'
        WHERE id = '554789';
[05/21/2024 11:49:29], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.429',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '21.51',
        system_load_5_min = '26.14',
        system_load_15_min = '17.65',
        system_memory_usage = '94.42',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1834') + '6448368',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1834';
[05/21/2024 11:51:12], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/29' , departure_date = '2024/05/30' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2024-05-21 11:51:12' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 11:51:13], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 11:51:13', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1835');
[05/21/2024 11:51:13], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 11:51:13.151'
        , request_start_time = '0.033'
        , parsing_start_time = '0.015'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.104'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5453472'
        WHERE id = '554790';
[05/21/2024 11:51:13], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.308',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '14.13',
        system_load_5_min = '21.93',
        system_load_15_min = '17.03',
        system_memory_usage = '94.80',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1835') + '6448360',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1835';
[05/21/2024 11:51:28], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/29' , departure_date = '2024/05/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 11:51:28' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 11:51:29], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 11:51:29', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1836');
[05/21/2024 11:51:29], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 11:51:29.614'
        , request_start_time = '0.028'
        , parsing_start_time = '0.016'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.217'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5496544'
        WHERE id = '554791';
[05/21/2024 11:51:29], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.372',
        merge_duration = '0.001',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '12.65',
        system_load_5_min = '21.24',
        system_load_15_min = '16.88',
        system_memory_usage = '95.08',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1836') + '6448056',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1836';
[05/21/2024 11:51:49], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '23' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/05/29' , departure_date = '2024/05/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-05-21 11:51:49' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[05/21/2024 11:51:50], [file name :-/efsdata/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2024-05-21 11:51:50', '', '681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487', '1837');
[05/21/2024 11:51:50], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=localsystem&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487&xml_user_id=7857&request_no=0&local_hotel_code=4&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-05-21 11:51:50.460'
        , request_start_time = '0.030'
        , parsing_start_time = '0.016'
        , mapping_complete_time = '0.000'
        , mongo_start_time = '0.000'
        , search_end_time = '0.000'
        , total_duration = '0.148'
        , error_description = ' Unsupported operand types | 1 | /efsdata/otrams/public_html/beta/common/functions/site.func.php:984'
        , memory_used = '5498296'
        WHERE id = '554792';
[05/21/2024 11:51:50], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=7857&sessionid=681fa1795a44c3af6a3c6e7b94cbd3d87942f201796487ae17f2cc0615e30487',
        duration = '0.243',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '9.58',
        system_load_5_min = '19.98',
        system_load_15_min = '16.56',
        system_memory_usage = '94.64',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '1837') + '6448488',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '1837';
[05/21/2024 11:53:33], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],UPDATE hotels SET weekend='6,7', infant_lower_limit='0', infant_upper_limit='1', tiny_child_lower_limit='2', tiny_child_upper_limit='5', child_lower_limit='6', child_upper_limit=NULL, teen_child_lower_limit=NULL, teen_child_upper_limit=NULL WHERE id='4';
[05/21/2024 11:53:33], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 11:53:33',`log_type`= 'Hotel',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;, infant_lower_limit=\&#039;0\&#039;, infant_upper_limit=\&#039;1\&#039;, tiny_child_lower_limit=\&#039;2\&#039;, tiny_child_upper_limit=\&#039;5\&#039;, child_lower_limit=\&#039;6\&#039;, child_upper_limit=NULL, teen_child_lower_limit=NULL, teen_child_upper_limit=NULL WHERE id=\&#039;4\&#039;',`log_description`= 'Hotel Setting of TAJ Qtech Updated By Test_india supplier',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000002';
[05/21/2024 11:53:33], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3387', `entity`='Hotels', `value`='4' ;
[05/21/2024 11:53:33], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3387', `entity`='Suppliers', `value`='S000000002' ;
[05/21/2024 11:53:53], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='4' AND supplier_id='S000000002';
[05/21/2024 11:53:53], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],INSERT into hotel_room_class_mapping SET hotel_id='4', supplier_id='S000000002', class_id='497';
[05/21/2024 11:53:53], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2024-05-21 11:53:53',`log_type`= 'Hotel Room Class Mapping',`sql_query`= 'INSERT into hotel_room_class_mapping SET hotel_id=\&#039;4\&#039;, supplier_id=\&#039;S000000002\&#039;, class_id=\&#039;497\&#039;',`log_description`= 'Hotel Room Class Mapping for hotel TAJ QtechRoom Category :-Double',`ip`= '43.239.53.130',`username`= 'v3alpha',`user_id`= 'S000000002';
[05/21/2024 11:53:53], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3388', `entity`='Suppliers', `value`='S000000002' ;
[05/21/2024 11:53:53], [file name :-/efsdata/otrams/public_html/beta/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3388', `entity`='Roomclass', `value`='497' ;
