[08/01/2025 05:52:15], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],UPDATE suppliers SET status='A',modify_date='2'110'25-'110'8-'110'1 '110'5:52:15' WHERE id= ?;
[08/01/2025 05:52:15], [file name :-/efsdata/otrams/public_html/beta/tms/edit_supplier.php],insert into user_logs set username= 'pranay_qtech',create_date= '2025-08-01 05:52:15',log_type= 'Supplier Activated',sql_query= '',log_description= 'Activated Supplier : yalago, Date of modification : 2025-08-01 05:52:15',ip= '103.104.226.130';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '77' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '89' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '108' ,status = '1' ,priority = '5' ,lead_time = '94',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '102' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '76' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '98' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '58' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '99' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '106' ,status = '1' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '74' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '75' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '56' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '60' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '84' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '67' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '1' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '104' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '101' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '73' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '85' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '103' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '100' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '93' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '107' ,status = '1' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '57' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '97' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '105' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '110' ,status = '1' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '81' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '78' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '83' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '68' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '90' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '66' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '64' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '65' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '69' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:52:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into user_logs set username= 'pranay_qtech',create_date= '2025-08-01 05:52:31',log_type= 'Agent Supplier settings',sql_query= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 89 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 108 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;94\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 102 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 76 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 98 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 58 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 99 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 106 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 74 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 75 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 56 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 60 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 84 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 67 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 1 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 104 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 101 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 73 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 103 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 100 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 93 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 107 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 57 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 97 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 105 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 110 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 81 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 78 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 83 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 68 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 66 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 64 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 69 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;',log_description= 'Supplier setting updated  Previous data-- agent_id-2633 ## supplier_id- 110 ## company_name - Yalago Live ## supplier_code-yalago  ## percentage - 0.00 ## lead_time - 0 ',ip= '103.104.226.130';
[08/01/2025 05:52:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET agency_name= 'Jaison Qtech (DONTBOOK)',other_language_agency_name= '',search_merging_method= '',accounting_name= '',first_name= 'JAISON',middle_name= '',last_name= 'JAMES',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '1000.000',credit_limit= '1000.000',credit_distribution= '0',temp_credit_limit= '',address= 'QTECH',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '0',enable_dst= '',branch_id='26',phone= '91-123456789',mobile= '91-123456789',fax= '',currency= '6',email= 'rohit.sapkota@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '1',allow_book_under_cancellation='0',modify_date='2025-08-01 05:52:55',consultant_id= 'jaison_qtech',agency_email= '',acc_name= 'JAISON',acc_email= 'jaisonvjames@gmail.com',acc_phone= '',man_name= '',man_email= '',man_phone= '',res_name= '',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '', allow_login_otp= '', allow_booking_otp= '',allow_credit_use= '1' WHERE id= '2633';
[08/01/2025 05:52:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into user_logs set username= 'pranay_qtech',create_date= '2025-08-01 05:52:55',log_type= 'Agent Updated',sql_query= 'UPDATE agents SET agency_name= \&#039;Jaison Qtech (DONTBOOK)\&#039;,other_language_agency_name= \&#039;\&#039;,search_merging_method= ,accounting_name= \&#039;\&#039;,first_name= \&#039;JAISON\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;JAMES\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;1000.000\&#039;,credit_limit= \&#039;1000.000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;QTECH\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;0\&#039;,enable_dst= 0,branch_id=\&#039;26\&#039;,phone= \&#039;91-123456789\&#039;,mobile= \&#039;91-123456789\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;rohit.sapkota@qtechsoftware.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= \&#039;1\&#039;,debug= \&#039;1\&#039;,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= 1,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2025-08-01 05:52:55\&#039;,consultant_id= \&#039;jaison_qtech\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;JAISON\&#039;,acc_email= \&#039;jaisonvjames@gmail.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= ,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0, allow_login_otp= 0, allow_booking_otp= 0,allow_credit_use= 1 WHERE id= \&#039;2633\&#039;',log_description= 'Agent 2633 updated For  - modify_date=2025-07-30+11%3A45%3A33 changed to - modify_date=2025-08-01+05%3A52%3A55',ip= '103.104.226.130';
[08/01/2025 05:52:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'2633' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[08/01/2025 05:52:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into  agent_credit_log SET agent_id= '2633',credit_value= '1007.770',credit_usage= '-7.770',credit_limit= '1000.000',receipt_id= '',amount= '',ip='103.104.226.130',user_type='admin',admin_id='pranay_qtech',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by pranay_qtech',create_date='2025-08-01 05:08:55';
[08/01/2025 05:52:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '26',consultant_id= 'jaison_qtech',sales_manager_id= '',profile= '', agent_type= 'CC' WHERE parent_agent= '2633';
[08/01/2025 05:52:59], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2025-08-01 05:52:59',login_attempt=0 where id = '2633';
[08/01/2025 05:52:59], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_test_2025', user_type = 'A', branch_id = '26', login_datetime = '2025-08-01 05:52:59', ip = '103.104.226.130', action = 'Login' ;
[08/01/2025 05:53:53], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2633' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/10/25' , departure_date = '2025/10/26' , nights = '1' , nationality = '106' , room_types = '3.1, 2.2, 1.3' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"1"},{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"1,1"},{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,1"}]' , available='0' , create_date = '2025-08-01 05:53:53' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , merging_type = 'old' , web_service = '0' ;
[08/01/2025 05:53:54], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2633_26330120250805535310955264288', session_id='26330120250805535310955264288', Collection_create_time='2025-08-01 05:53:54';
[08/01/2025 05:53:56], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2633&sessionid=26330120250805535310955264288',
        duration = '2.097',
        merge_duration = '0.009',
        assigned_supplier_count = '27',
        searched_supplier_count = '1',
        system_load_1_min = '1.76',
        system_load_5_min = '1.80',
        system_load_15_min = '1.78',
        system_memory_usage = '20.90',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '54324041') + '2574912',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '54324041';
[08/01/2025 05:54:12], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2633' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/10/25' , departure_date = '2025/10/26' , nights = '1' , nationality = '106' , room_types = '3.1, 2.2, 1.3' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"1"},{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"1,1"},{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,1"}]' , available='0' , create_date = '2025-08-01 05:54:12' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , merging_type = 'old' , web_service = '0' ;
[08/01/2025 05:54:12], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2633_26330120250805541249794042348', session_id='26330120250805541249794042348', Collection_create_time='2025-08-01 05:54:12';
[08/01/2025 05:54:14], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2633&sessionid=26330120250805541249794042348',
        duration = '2.052',
        merge_duration = '0.010',
        assigned_supplier_count = '27',
        searched_supplier_count = '1',
        system_load_1_min = '1.59',
        system_load_5_min = '1.76',
        system_load_15_min = '1.77',
        system_memory_usage = '20.89',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '54324168') + '2490968',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '54324168';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '77' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '89' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '108' ,status = '1' ,priority = '5' ,lead_time = '94',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '102' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '76' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '98' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '58' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '99' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '106' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '74' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '75' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '56' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '60' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '84' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '67' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '1' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '104' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '101' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '73' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '85' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '103' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '100' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '93' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '107' ,status = '1' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '57' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '97' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '105' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '110' ,status = '1' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '81' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '78' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '83' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '68' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '90' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '66' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '64' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '65' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '69' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:55:08], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into user_logs set username= 'pranay_qtech',create_date= '2025-08-01 05:55:08',log_type= 'Agent Supplier settings',sql_query= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 108 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;94\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 98 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 58 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 99 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 106 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 74 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 75 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 56 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 60 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 84 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 104 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 100 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 93 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 107 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 57 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 97 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 105 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 110 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;',log_description= 'Supplier setting updated  Previous data-- agent_id-2633 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 89 ## company_name - Aos Connect ## supplier_code-aosc  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 108 ## company_name - astrajuniper ## supplier_code-astrajuniper  ## percentage - 0.00 ## lead_time - 94 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 102 ## company_name - Bedzinn ## supplier_code-bedzinn  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 76 ## company_name - Darina ## supplier_code-darina  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 98 ## company_name - Dida ## supplier_code-dida  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 58 ## company_name - Destinations of the world (DOTW) ## supplier_code-dotw  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 106 ## company_name - Elevate ## supplier_code-elevate  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 74 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 75 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 56 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 60 ## company_name - Hotelspro ## supplier_code-hotelspro  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 84 ## company_name - Jumbotours ## supplier_code-jumbotours  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 67 ## company_name - Local System ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 1 ## company_name - Miki ## supplier_code-miki  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 104 ## company_name - Moonline ## supplier_code-moonline  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 101 ## company_name - Ratehawk ## supplier_code-ratehawk  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 73 ## company_name - Restel ## supplier_code-restel  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 103 ## company_name - Rooms Xml (Stuba) ## supplier_code-roomsxml  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 100 ## company_name - Sun Hotels ## supplier_code-sunhotels  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 93 ## company_name - TBO Holidays ## supplier_code-tboholidays  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 107 ## company_name - thetravelhub ## supplier_code-thetravelhub  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 57 ## company_name - Travco ## supplier_code-travco  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 97 ## company_name - Tripathon - XML ## supplier_code-tripathonxml  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 105 ## company_name - TTB UK ## supplier_code-ttb  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 110 ## company_name - Yalago Live ## supplier_code-yalago  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 81 ## company_name - Amadeus Flight ## supplier_code-amadeus  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 78 ## company_name - Pyton ## supplier_code-pyton  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 83 ## company_name - Hotelbeds Transfer ## supplier_code-hotelbedstransfer  ## percen',ip= '103.104.226.130';
[08/01/2025 05:55:12], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2025-08-01 05:55:12',login_attempt=0 where id = '2633';
[08/01/2025 05:55:12], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_test_2025', user_type = 'A', branch_id = '26', login_datetime = '2025-08-01 05:55:12', ip = '103.104.226.130', action = 'Login' ;
[08/01/2025 05:55:50], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2633' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/10/25' , departure_date = '2025/10/26' , nights = '1' , nationality = '106' , room_types = '3.1, 2.2, 1.3' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"1"},{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"1,1"},{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,1"}]' , available='0' , create_date = '2025-08-01 05:55:50' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , merging_type = 'old' , web_service = '0' ;
[08/01/2025 05:55:51], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2633_2633012025080555506466485802', session_id='2633012025080555506466485802', Collection_create_time='2025-08-01 05:55:51';
[08/01/2025 05:55:53], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2633&sessionid=2633012025080555506466485802',
        duration = '2.072',
        merge_duration = '0.017',
        assigned_supplier_count = '16',
        searched_supplier_count = '1',
        system_load_1_min = '1.44',
        system_load_5_min = '1.65',
        system_load_15_min = '1.73',
        system_memory_usage = '21.46',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '54324809') + '2460712',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '54324809';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '77' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '89' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '108' ,status = '1' ,priority = '5' ,lead_time = '94',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '102' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '76' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '98' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '58' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '99' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '106' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '56' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '60' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '84' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '67' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '1' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '104' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '101' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '73' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '85' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '103' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '100' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '93' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:17], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '107' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '57' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '97' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '105' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '110' ,status = '1' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '81' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '78' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '83' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '68' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '90' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '66' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '64' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '65' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '69' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:56:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into user_logs set username= 'pranay_qtech',create_date= '2025-08-01 05:56:18',log_type= 'Agent Supplier settings',sql_query= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 108 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;94\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 99 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 106 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 104 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 107 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 105 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 110 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;',log_description= 'Supplier setting updated  Previous data-- agent_id-2633 ## supplier_id- 108 ## company_name - astrajuniper ## supplier_code-astrajuniper  ## percentage - 0.00 ## lead_time - 94 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 98 ## company_name - Dida ## supplier_code-dida  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 58 ## company_name - Destinations of the world (DOTW) ## supplier_code-dotw  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 74 ## company_name - Expedia ## supplier_code-expedia  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 75 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 56 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 60 ## company_name - Hotelspro ## supplier_code-hotelspro  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 84 ## company_name - Jumbotours ## supplier_code-jumbotours  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 104 ## company_name - Moonline ## supplier_code-moonline  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 100 ## company_name - Sun Hotels ## supplier_code-sunhotels  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 93 ## company_name - TBO Holidays ## supplier_code-tboholidays  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 107 ## company_name - thetravelhub ## supplier_code-thetravelhub  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 57 ## company_name - Travco ## supplier_code-travco  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 97 ## company_name - Tripathon - XML ## supplier_code-tripathonxml  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 110 ## company_name - Yalago Live ## supplier_code-yalago  ## percentage - 0.00 ## lead_time - 0 ',ip= '103.104.226.130';
[08/01/2025 05:56:31], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2633' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/10/25' , departure_date = '2025/10/26' , nights = '1' , nationality = '106' , room_types = '3.1, 2.2, 1.3' , room_type='[{"numberOfAdults":3,"numberOfChild":1,"ChildAge":"1"},{"numberOfAdults":2,"numberOfChild":2,"ChildAge":"1,1"},{"numberOfAdults":1,"numberOfChild":3,"ChildAge":"1,1,1"}]' , available='0' , create_date = '2025-08-01 05:56:31' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , merging_type = 'old' , web_service = '0' ;
[08/01/2025 05:56:31], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2633_26330120250805563123758728902', session_id='26330120250805563123758728902', Collection_create_time='2025-08-01 05:56:31';
[08/01/2025 05:56:33], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2633&sessionid=26330120250805563123758728902',
        duration = '2.053',
        merge_duration = '0.010',
        assigned_supplier_count = '3',
        searched_supplier_count = '1',
        system_load_1_min = '1.66',
        system_load_5_min = '1.68',
        system_load_15_min = '1.74',
        system_memory_usage = '21.53',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '54325109') + '2461560',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '54325109';
[08/01/2025 05:56:49], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2633' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/10/25' , departure_date = '2025/10/26' , nights = '1' , nationality = '106' , room_types = '2, 2, 2' , room_type='[{"numberOfAdults":2},{"numberOfAdults":2},{"numberOfAdults":2}]' , available='0' , create_date = '2025-08-01 05:56:49' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , merging_type = 'old' , web_service = '0' ;
[08/01/2025 05:56:50], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2633_26330120250805564946745930291', session_id='26330120250805564946745930291', Collection_create_time='2025-08-01 05:56:50';
[08/01/2025 05:56:52], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2633&sessionid=26330120250805564946745930291',
        duration = '2.071',
        merge_duration = '0.018',
        assigned_supplier_count = '3',
        searched_supplier_count = '1',
        system_load_1_min = '1.55',
        system_load_5_min = '1.65',
        system_load_15_min = '1.73',
        system_memory_usage = '21.54',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '54325269') + '2458496',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '54325269';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '77' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '89' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '108' ,status = '' ,priority = '5' ,lead_time = '94',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '102' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '76' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '98' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '58' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '99' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '106' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '56' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '60' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '84' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '67' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '1' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '104' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '101' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '73' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '85' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '103' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '100' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '93' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '107' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '57' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '97' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '105' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '110' ,status = '1' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '81' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '78' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '83' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '68' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '90' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '66' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '64' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '65' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2633',supplier_id = '69' ,status = '' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[08/01/2025 05:57:31], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into user_logs set username= 'pranay_qtech',create_date= '2025-08-01 05:57:31',log_type= 'Agent Supplier settings',sql_query= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 108 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;94\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 106 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 104 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 107 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 105 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 110 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2633\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;',log_description= 'Supplier setting updated  Previous data-- agent_id-2633 ## supplier_id- 108 ## company_name - astrajuniper ## supplier_code-astrajuniper  ## percentage - 0.00 ## lead_time - 94 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-2633 ## supplier_id- 110 ## company_name - Yalago Live ## supplier_code-yalago  ## percentage - 0.00 ## lead_time - 0 ',ip= '103.104.226.130';
[08/01/2025 05:57:41], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '2633' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2025/10/25' , departure_date = '2025/10/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2025-08-01 05:57:41' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0' , selected_currency = 'USD' , currency_code = 'USD' , merging_type = 'old' , web_service = '0' ;
[08/01/2025 05:57:42], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_2633_2633012025080557419817451201', session_id='2633012025080557419817451201', Collection_create_time='2025-08-01 05:57:42';
[08/01/2025 05:57:44], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '',
        request_path = '/xml_all.php?userid=2633&sessionid=2633012025080557419817451201',
        duration = '2.054',
        merge_duration = '0.009',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.70',
        system_load_5_min = '1.67',
        system_load_15_min = '1.73',
        system_memory_usage = '21.78',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '54325787') + '2458504',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '54325787';
