[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '77' ,status = '' ,priority = '9' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '89' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '102' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '76' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '98' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '58' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '99' ,status = '1' ,priority = '9' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '74' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '75' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '96' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '56' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '60' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '84' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '67' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '1' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '101' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '73' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '85' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '103' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '100' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '93' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '57' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '81' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '78' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '83' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '68' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '90' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '66' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '64' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '65' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '2484',supplier_id = '69' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[12/18/2024 07:31:45], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'supriya',`create_date`= '2024-12-18 07:31:45',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 99 ,status = \&#039;1\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 84 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;2484\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-2484 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 48 ',`ip`= '103.104.226.130';
[12/18/2024 07:31:49], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-18 07:31:49',login_attempt=0 where id = '2484';
[12/18/2024 07:31:49], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_Goagent', user_type = 'A', branch_id = '26', login_datetime = '2024-12-18 07:31:49', ip = '103.104.226.130', action = 'Login' ;
[12/18/2024 07:31:56], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-18 07:31:56',login_attempt=0 where id = '2484';
[12/18/2024 07:31:56], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Qtech_Goagent', user_type = 'A', branch_id = '26', login_datetime = '2024-12-18 07:31:56', ip = '103.104.226.130', action = 'Login' ;
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '77' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '89' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '102' ,status = '1' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '76' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '98' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '99' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '96' ,status = '' ,priority = '14' ,lead_time = '120',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '60' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '84' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '67' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '1' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '101' ,status = '' ,priority = '14' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '73' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '85' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '103' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '100' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '93' ,status = '' ,priority = '14' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '57' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '97' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1089',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'supriya',`create_date`= '2024-12-18 07:32:32',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#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;1089\&#039;,supplier_id = 89 ,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;1089\&#039;,supplier_id = 102 ,status = \&#039;1\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 76 ,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;1089\&#039;,supplier_id = 98 ,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;1089\&#039;,supplier_id = 58 ,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;1089\&#039;,supplier_id = 99 ,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;1089\&#039;,supplier_id = 74 ,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;1089\&#039;,supplier_id = 75 ,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;1089\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;120\&#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;1089\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 60 ,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;1089\&#039;,supplier_id = 84 ,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;1089\&#039;,supplier_id = 67 ,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;1089\&#039;,supplier_id = 1 ,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;1089\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;72\&#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;1089\&#039;,supplier_id = 73 ,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;1089\&#039;,supplier_id = 85 ,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;1089\&#039;,supplier_id = 103 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1089\&#039;,supplier_id = 100 ,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;1089\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;72\&#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;1089\&#039;,supplier_id = 57 ,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;1089\&#039;,supplier_id = 97 ,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;1089\&#039;,supplier_id = 81 ,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;1089\&#039;,supplier_id = 78 ,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;1089\&#039;,supplier_id = 83 ,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;1089\&#039;,supplier_id = 68 ,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;1089\&#039;,supplier_id = 90 ,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;1089\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;48\&#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;1089\&#039;,supplier_id = 64 ,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;1089\&#039;,supplier_id = 65 ,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;1089\&#039;,supplier_id = 69 ,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;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1089 ## supplier_id- 102 ## company_name - Bedzinn ## supplier_code-bedzinn  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '103.104.226.130';
[12/18/2024 07:32:36], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-18 07:32:36',login_attempt=0 where id = '1089';
[12/18/2024 07:32:36], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Test_DoNotUse', user_type = 'A', branch_id = '26', login_datetime = '2024-12-18 07:32:36', ip = '103.104.226.130', action = 'Login' ;
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '77' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '89' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '102' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '76' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '98' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '99' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '96' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '60' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '84' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '67' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '1' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '101' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '73' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '85' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '103' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '100' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '93' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '57' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '97' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:32:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'supriya',`create_date`= '2024-12-18 07:32:55',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 77 ,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;1284\&#039;,supplier_id = 89 ,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;1284\&#039;,supplier_id = 102 ,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;1284\&#039;,supplier_id = 76 ,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;1284\&#039;,supplier_id = 98 ,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;1284\&#039;,supplier_id = 58 ,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;1284\&#039;,supplier_id = 99 ,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;1284\&#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;1284\&#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;1284\&#039;,supplier_id = 96 ,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;1284\&#039;,supplier_id = 56 ,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;1284\&#039;,supplier_id = 60 ,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;1284\&#039;,supplier_id = 84 ,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;1284\&#039;,supplier_id = 67 ,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;1284\&#039;,supplier_id = 1 ,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;1284\&#039;,supplier_id = 101 ,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;1284\&#039;,supplier_id = 73 ,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;1284\&#039;,supplier_id = 85 ,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;1284\&#039;,supplier_id = 103 ,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;1284\&#039;,supplier_id = 100 ,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;1284\&#039;,supplier_id = 93 ,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;1284\&#039;,supplier_id = 57 ,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;1284\&#039;,supplier_id = 97 ,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;1284\&#039;,supplier_id = 81 ,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;1284\&#039;,supplier_id = 78 ,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;1284\&#039;,supplier_id = 83 ,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;1284\&#039;,supplier_id = 68 ,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;1284\&#039;,supplier_id = 90 ,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;1284\&#039;,supplier_id = 66 ,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;1284\&#039;,supplier_id = 64 ,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;1284\&#039;,supplier_id = 65 ,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;1284\&#039;,supplier_id = 69 ,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;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1284 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 24 ',`ip`= '103.104.226.130';
[12/18/2024 07:32:59], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-18 07:32:59',login_attempt=0 where id = '1284';
[12/18/2024 07:32:59], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_agent', user_type = 'A', branch_id = '26', login_datetime = '2024-12-18 07:32:59', ip = '103.104.226.130', action = 'Login' ;
[12/18/2024 07:33:09], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , 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 = '129' , service_type = 'hotel' , arrival_date = '2024/12/19' , departure_date = '2024/12/20' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-12-18 07:33:09' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[12/18/2024 07:33:10], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12841820241207330947040120191', session_id='12841820241207330947040120191', Collection_create_time='2024-12-18 07:33:10';
[12/18/2024 07:33:16], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '649',
        request_path = '/xml_all.php?userid=1284&sessionid=12841820241207330947040120191',
        duration = '6.089',
        merge_duration = '0.010',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.79',
        system_load_5_min = '0.46',
        system_load_15_min = '0.39',
        system_memory_usage = '53.67',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18485286') + '2233704',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '18485286';
[12/18/2024 07:45:02], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734507902','103.104.226.130');
[12/18/2024 07:45:02], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/18_12_2024/request_valuation_qtech_agent_07_45_02_1734507902_.json', 'a5/18_12_2024/response_valuation_qtech_agent_07_45_02_1734507902_.json', 'a5/18_12_2024/response_header_valuation_qtech_agent_07_45_02_1734507902_.json', 'agoda', '2024-12-18 07:45:02', '', '12841820241207330947040120191', '18485286', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/18_12_2024/response_valuation_qtech_agent_07_45_02_1734507902_.json');
[12/18/2024 07:45:03], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:dubai<br><br>Arrival Date:19/12/2024<br><br>Departure Date:20/12/2024<br><br>Supplier:agoda<br><br>Hotel:DREAM INN APARTMENTS - ADDRESS DUBAI MARINA<br><br>Room:Studio Studio Standard , Room Only
',  email_sent ='yes', create_date ='2024-12-18 07:45:03', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[12/18/2024 07:45:13], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-18 07:45:13',login_attempt=0 where id = '1284';
[12/18/2024 07:45:13], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_agent', user_type = 'A', branch_id = '26', login_datetime = '2024-12-18 07:45:13', ip = '103.104.226.130', action = 'Login' ;
[12/18/2024 07:46:23], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , 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 = '129' , service_type = 'hotel' , arrival_date = '2024/12/27' , departure_date = '2024/12/28' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-12-18 07:46:23' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[12/18/2024 07:46:23], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12841820241207462368066780644', session_id='12841820241207462368066780644', Collection_create_time='2024-12-18 07:46:23';
[12/18/2024 07:46:27], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '593',
        request_path = '/xml_all.php?userid=1284&sessionid=12841820241207462368066780644',
        duration = '3.060',
        merge_duration = '0.011',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.50',
        system_load_5_min = '0.41',
        system_load_15_min = '0.37',
        system_memory_usage = '55.93',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18485556') + '2032280',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '18485556';
[12/18/2024 07:46:44], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508004','103.104.226.130');
[12/18/2024 07:46:45], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/18_12_2024/request_valuation_qtech_agent_07_46_44_1734508004_.json', 'a5/18_12_2024/response_valuation_qtech_agent_07_46_44_1734508004_.json', 'a5/18_12_2024/response_header_valuation_qtech_agent_07_46_44_1734508004_.json', 'agoda', '2024-12-18 07:46:45', '', '12841820241207462368066780644', '18485556', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/18_12_2024/response_valuation_qtech_agent_07_46_44_1734508004_.json');
[12/18/2024 07:46:45], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:dubai<br><br>Arrival Date:27/12/2024<br><br>Departure Date:28/12/2024<br><br>Supplier:agoda<br><br>Hotel:THE S HOLIDAY HOMES AT THE ADDRESS DUBAI MALL<br><br>Room:Studio with Zabeel View , Room Only
',  email_sent ='yes', create_date ='2024-12-18 07:46:45', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[12/18/2024 07:47:36], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508056','103.104.226.130');
[12/18/2024 07:47:36], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/18_12_2024/request_valuation_qtech_agent_07_47_36_1734508056_.json', 'a5/18_12_2024/response_valuation_qtech_agent_07_47_36_1734508056_.json', 'a5/18_12_2024/response_header_valuation_qtech_agent_07_47_36_1734508056_.json', 'agoda', '2024-12-18 07:47:36', '', '12841820241207462368066780644', '18485556', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/18_12_2024/response_valuation_qtech_agent_07_47_36_1734508056_.json');
[12/18/2024 07:47:37], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:dubai<br><br>Arrival Date:27/12/2024<br><br>Departure Date:28/12/2024<br><br>Supplier:agoda<br><br>Hotel:AL KHOORY ATRIUM HOTEL<br><br>Room:Superior  Double or Twin Room  , Room Only | Amenities:Free WiFi , Free fitness center access , 
',  email_sent ='yes', create_date ='2024-12-18 07:47:37', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[12/18/2024 07:48:03], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508083','103.104.226.130');
[12/18/2024 07:48:04], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/18_12_2024/request_valuation_qtech_agent_07_48_03_1734508083_.json', 'a5/18_12_2024/response_valuation_qtech_agent_07_48_03_1734508083_.json', 'a5/18_12_2024/response_header_valuation_qtech_agent_07_48_03_1734508083_.json', 'agoda', '2024-12-18 07:48:04', '', '12841820241207462368066780644', '18485556', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/18_12_2024/response_valuation_qtech_agent_07_48_03_1734508083_.json');
[12/18/2024 07:48:04], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:dubai<br><br>Arrival Date:27/12/2024<br><br>Departure Date:28/12/2024<br><br>Supplier:agoda<br><br>Hotel:ATLANTIS THE ROYAL<br><br>Room:Room, 2 Queen Beds (Seascape), 2 Queen Beds , Bed and Breakfast | Amenities:Breakfast , Parking , Express check-in , Free WiFi , 
',  email_sent ='yes', create_date ='2024-12-18 07:48:04', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[12/18/2024 07:48:26], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508106','103.104.226.130');
[12/18/2024 07:48:26], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/18_12_2024/request_valuation_qtech_agent_07_48_26_1734508106_.json', 'a5/18_12_2024/response_valuation_qtech_agent_07_48_26_1734508106_.json', 'a5/18_12_2024/response_header_valuation_qtech_agent_07_48_26_1734508106_.json', 'agoda', '2024-12-18 07:48:26', '', '12841820241207462368066780644', '18485556', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/18_12_2024/response_valuation_qtech_agent_07_48_26_1734508106_.json');
[12/18/2024 07:48:27], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:dubai<br><br>Arrival Date:27/12/2024<br><br>Departure Date:28/12/2024<br><br>Supplier:agoda<br><br>Hotel:DREAM PLAZA HOTEL APARTMENTS<br><br>Room:Studio , Room Only | Amenities:Coffee & tea , Express check-in , Free WiFi , Drinking water , Couple Friendly , 
',  email_sent ='yes', create_date ='2024-12-18 07:48:27', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[12/18/2024 07:49:07], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508147','103.104.226.130');
[12/18/2024 07:49:07], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/18_12_2024/request_valuation_qtech_agent_07_49_07_1734508147_.json', 'a5/18_12_2024/response_valuation_qtech_agent_07_49_07_1734508147_.json', 'a5/18_12_2024/response_header_valuation_qtech_agent_07_49_07_1734508147_.json', 'agoda', '2024-12-18 07:49:07', '', '12841820241207462368066780644', '18485556', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/18_12_2024/response_valuation_qtech_agent_07_49_07_1734508147_.json');
[12/18/2024 07:49:08], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:dubai<br><br>Arrival Date:27/12/2024<br><br>Departure Date:28/12/2024<br><br>Supplier:agoda<br><br>Hotel:HOLIDAY INN EXPRESS DUBAI - JUMEIRAH<br><br>Room:1 King Bed Standard Accessible , Bed and Breakfast | Amenities:Breakfast , Free WiFi , 
',  email_sent ='yes', create_date ='2024-12-18 07:49:08', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[12/18/2024 07:49:38], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508178','103.104.226.130');
[12/18/2024 07:49:39], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/18_12_2024/request_valuation_qtech_agent_07_49_38_1734508178_.json', 'a5/18_12_2024/response_valuation_qtech_agent_07_49_38_1734508178_.json', 'a5/18_12_2024/response_header_valuation_qtech_agent_07_49_38_1734508178_.json', 'agoda', '2024-12-18 07:49:39', '', '12841820241207462368066780644', '18485556', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/18_12_2024/response_valuation_qtech_agent_07_49_38_1734508178_.json');
[12/18/2024 07:49:40], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:dubai<br><br>Arrival Date:27/12/2024<br><br>Departure Date:28/12/2024<br><br>Supplier:agoda<br><br>Hotel:PEARL MARINA HOTEL APARTMENTS<br><br>Room:1 Bedroom Premier , Bed and Breakfast | Amenities:Breakfast , Free WiFi , Free fitness center access , 
',  email_sent ='yes', create_date ='2024-12-18 07:49:40', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[12/18/2024 07:50:02], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '26' , ip = '103.104.226.130' , city = 'phuket' , service_name = '' , country_of_residence = '129' , service_type = 'hotel' , arrival_date = '2024/12/31' , departure_date = '2025/01/01' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-12-18 07:50:02' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[12/18/2024 07:50:03], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12841820241207500213374848253', session_id='12841820241207500213374848253', Collection_create_time='2024-12-18 07:50:03';
[12/18/2024 07:50:05], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '378',
        request_path = '/xml_all.php?userid=1284&sessionid=12841820241207500213374848253',
        duration = '2.159',
        merge_duration = '0.009',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '0.63',
        system_load_5_min = '0.38',
        system_load_15_min = '0.35',
        system_memory_usage = '57.25',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18485755') + '2033120',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '18485755';
[12/18/2024 07:50:33], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508233','103.104.226.130');
[12/18/2024 07:50:33], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/18_12_2024/request_valuation_qtech_agent_07_50_33_1734508233_.json', 'a5/18_12_2024/response_valuation_qtech_agent_07_50_33_1734508233_.json', 'a5/18_12_2024/response_header_valuation_qtech_agent_07_50_33_1734508233_.json', 'agoda', '2024-12-18 07:50:33', '', '12841820241207500213374848253', '18485755', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/18_12_2024/response_valuation_qtech_agent_07_50_33_1734508233_.json');
[12/18/2024 07:50:34], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:phuket<br><br>Arrival Date:31/12/2024<br><br>Departure Date:01/01/2025<br><br>Supplier:agoda<br><br>Hotel:R-MAR RESORT & SPA<br><br>Room:Superior Garden , Room Only | Amenities:Food & Beverage discount (%) , Free mini bar , Parking , Welcome drink , Coffee & tea , Free WiFi , Drinking water , Free fitness center access , 
',  email_sent ='yes', create_date ='2024-12-18 07:50:34', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[12/18/2024 07:50:54], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508254','103.104.226.130');
[12/18/2024 07:50:54], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 'a5/18_12_2024/request_valuation_qtech_agent_07_50_54_1734508254_.json', 'a5/18_12_2024/response_valuation_qtech_agent_07_50_54_1734508254_.json', 'a5/18_12_2024/response_header_valuation_qtech_agent_07_50_54_1734508254_.json', 'agoda', '2024-12-18 07:50:54', '', '12841820241207500213374848253', '18485755', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/a5/18_12_2024/response_valuation_qtech_agent_07_50_54_1734508254_.json');
[12/18/2024 07:50:55], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:phuket<br><br>Arrival Date:31/12/2024<br><br>Departure Date:01/01/2025<br><br>Supplier:agoda<br><br>Hotel:BEL AIRE PATONG PHUKET<br><br>Room:Grand Superior Room , Bed and Breakfast | Amenities:Breakfast , Parking , Free WiFi , Drinking water , 
',  email_sent ='yes', create_date ='2024-12-18 07:50:55', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[12/18/2024 07:51:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[12/18/2024 07:51:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '77' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '89' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '102' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '76' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '98' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '99' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:32], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '96' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '60' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '84' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '67' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '1' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '101' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '73' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '85' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '103' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '100' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '93' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '57' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '97' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:51:33], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'supriya',`create_date`= '2024-12-18 07:51:33',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 77 ,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;1284\&#039;,supplier_id = 89 ,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;1284\&#039;,supplier_id = 102 ,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;1284\&#039;,supplier_id = 76 ,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;1284\&#039;,supplier_id = 98 ,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;1284\&#039;,supplier_id = 58 ,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;1284\&#039;,supplier_id = 99 ,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;1284\&#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;1284\&#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;1284\&#039;,supplier_id = 96 ,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;1284\&#039;,supplier_id = 56 ,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;1284\&#039;,supplier_id = 60 ,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;1284\&#039;,supplier_id = 84 ,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;1284\&#039;,supplier_id = 67 ,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;1284\&#039;,supplier_id = 1 ,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;1284\&#039;,supplier_id = 101 ,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;1284\&#039;,supplier_id = 73 ,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;1284\&#039;,supplier_id = 85 ,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;1284\&#039;,supplier_id = 103 ,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;1284\&#039;,supplier_id = 100 ,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;1284\&#039;,supplier_id = 93 ,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;1284\&#039;,supplier_id = 57 ,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;1284\&#039;,supplier_id = 97 ,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;1284\&#039;,supplier_id = 81 ,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;1284\&#039;,supplier_id = 78 ,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;1284\&#039;,supplier_id = 83 ,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;1284\&#039;,supplier_id = 68 ,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;1284\&#039;,supplier_id = 90 ,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;1284\&#039;,supplier_id = 66 ,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;1284\&#039;,supplier_id = 64 ,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;1284\&#039;,supplier_id = 65 ,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;1284\&#039;,supplier_id = 69 ,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;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1284 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 24 ',`ip`= '103.104.226.130';
[12/18/2024 07:51:38], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-18 07:51:38',login_attempt=0 where id = '1284';
[12/18/2024 07:51:38], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_agent', user_type = 'A', branch_id = '26', login_datetime = '2024-12-18 07:51:38', ip = '103.104.226.130', action = 'Login' ;
[12/18/2024 07:51:53], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , 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 = '129' , service_type = 'hotel' , arrival_date = '2025/01/02' , departure_date = '2025/01/03' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-12-18 07:51:53' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[12/18/2024 07:51:53], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12841820241207515350785187683', session_id='12841820241207515350785187683', Collection_create_time='2024-12-18 07:51:53';
[12/18/2024 07:52:17], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '743',
        request_path = '/xml_all.php?userid=1284&sessionid=12841820241207515350785187683',
        duration = '23.500',
        merge_duration = '0.361',
        assigned_supplier_count = '2',
        searched_supplier_count = '1',
        system_load_1_min = '0.39',
        system_load_5_min = '0.38',
        system_load_15_min = '0.35',
        system_memory_usage = '57.99',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18485776') + '2038264',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '18485776';
[12/18/2024 07:52:29], [file name :-/efsdata/otrams/public_html/beta/method_call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/18_12_2024/request_availability_qtech_agent_07_52_25_1734508345.json', 'rh/18_12_2024/response_availability_qtech_agent_07_52_25_1734508345.json', 'rh/18_12_2024/response_header_availability_qtech_agent_07_52_25_1734508345.json', 'ratehawk', '2024-12-18 07:52:29', '', '12841820241207515350785187683', '18485776', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/18_12_2024/response_availability_qtech_agent_07_52_25_1734508345.json');
[12/18/2024 07:52:34], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508354','103.104.226.130');
[12/18/2024 07:53:19], [file name :-/efsdata/otrams/public_html/beta/method_call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/18_12_2024/request_availability_qtech_agent_07_53_16_1734508396.json', 'rh/18_12_2024/response_availability_qtech_agent_07_53_16_1734508396.json', 'rh/18_12_2024/response_header_availability_qtech_agent_07_53_16_1734508396.json', 'ratehawk', '2024-12-18 07:53:19', '', '12841820241207515350785187683', '18485776', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/18_12_2024/response_availability_qtech_agent_07_53_16_1734508396.json');
[12/18/2024 07:53:31], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508411','103.104.226.130');
[12/18/2024 07:53:31], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 't7/18_12_2024/request_Valuation__qtech_agent_07_53_31_1734508411.xml', 't7/18_12_2024/response_Valuation__qtech_agent_07_53_31_1734508411.xml', 't7/18_12_2024/response_header_Valuation__qtech_agent_07_53_31_1734508411.xml', 'tboholidays', '2024-12-18 07:53:31', '', '12841820241207515350785187683', '18485776', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/t7/18_12_2024/response_Valuation__qtech_agent_07_53_31_1734508411.xml');
[12/18/2024 07:53:32], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:dubai<br><br>Arrival Date:02/01/2025<br><br>Departure Date:03/01/2025<br><br>Supplier:tboholidays<br><br>Hotel:THE APARTMENTS DUBAI WORLD TRADE CENTRE<br><br>Room:superior , Room_Only
',  email_sent ='yes', create_date ='2024-12-18 07:53:32', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[12/18/2024 07:54:15], [file name :-/efsdata/otrams/public_html/beta/method_call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/18_12_2024/request_availability_qtech_agent_07_54_14_1734508454.json', 'rh/18_12_2024/response_availability_qtech_agent_07_54_14_1734508454.json', 'rh/18_12_2024/response_header_availability_qtech_agent_07_54_14_1734508454.json', 'ratehawk', '2024-12-18 07:54:15', '', '12841820241207515350785187683', '18485776', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/18_12_2024/response_availability_qtech_agent_07_54_14_1734508454.json');
[12/18/2024 07:54:39], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508479','103.104.226.130');
[12/18/2024 07:54:39], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'VALUATION', 't7/18_12_2024/request_Valuation__qtech_agent_07_54_39_1734508479.xml', 't7/18_12_2024/response_Valuation__qtech_agent_07_54_39_1734508479.xml', 't7/18_12_2024/response_header_Valuation__qtech_agent_07_54_39_1734508479.xml', 'tboholidays', '2024-12-18 07:54:39', '', '12841820241207515350785187683', '18485776', 'https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/t7/18_12_2024/response_Valuation__qtech_agent_07_54_39_1734508479.xml');
[12/18/2024 07:54:40], [file name :-/efsdata/otrams/public_html/beta/book_now.php], insert into email_trigger set  subject ='Stop Booking in Astra Bookings',  message='The below agent was restricted from doing the booking as the rate might have changed or the room is not available. You are adviced to call the agent and follow up offline by suggesting alternatives.<br><br>Agent:Qtech (Username: qtech_agent)<br><br>City:dubai<br><br>Arrival Date:02/01/2025<br><br>Departure Date:03/01/2025<br><br>Supplier:tboholidays<br><br>Hotel:HOLIDAY INN EXPRESS DUBAI - JUMEIRAH<br><br>Room:1 King Bed Standard Sofa Bed , BreakFast
',  email_sent ='yes', create_date ='2024-12-18 07:54:40', email_sent_to ='astra@qtechsoftware.com', email_type ='RATE_CHANGE_EMAIL';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '77' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '89' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '102' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '76' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '98' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '99' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '74' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '96' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '60' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '84' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '67' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '1' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '101' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '73' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '85' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '103' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '100' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '93' ,status = '1' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '57' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '97' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '1284',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[12/18/2024 07:54:56], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'supriya',`create_date`= '2024-12-18 07:54:56',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;1284\&#039;,supplier_id = 77 ,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;1284\&#039;,supplier_id = 89 ,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;1284\&#039;,supplier_id = 102 ,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;1284\&#039;,supplier_id = 76 ,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;1284\&#039;,supplier_id = 98 ,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;1284\&#039;,supplier_id = 58 ,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;1284\&#039;,supplier_id = 99 ,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;1284\&#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;1284\&#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;1284\&#039;,supplier_id = 96 ,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;1284\&#039;,supplier_id = 56 ,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;1284\&#039;,supplier_id = 60 ,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;1284\&#039;,supplier_id = 84 ,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;1284\&#039;,supplier_id = 67 ,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;1284\&#039;,supplier_id = 1 ,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;1284\&#039;,supplier_id = 101 ,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;1284\&#039;,supplier_id = 73 ,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;1284\&#039;,supplier_id = 85 ,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;1284\&#039;,supplier_id = 103 ,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;1284\&#039;,supplier_id = 100 ,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;1284\&#039;,supplier_id = 93 ,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;1284\&#039;,supplier_id = 57 ,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;1284\&#039;,supplier_id = 97 ,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;1284\&#039;,supplier_id = 81 ,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;1284\&#039;,supplier_id = 78 ,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;1284\&#039;,supplier_id = 83 ,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;1284\&#039;,supplier_id = 68 ,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;1284\&#039;,supplier_id = 90 ,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;1284\&#039;,supplier_id = 66 ,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;1284\&#039;,supplier_id = 64 ,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;1284\&#039;,supplier_id = 65 ,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;1284\&#039;,supplier_id = 69 ,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;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-1284 ## supplier_id- 101 ## company_name - Ratehawk ## supplier_code-ratehawk  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-1284 ## supplier_id- 85 ## company_name - rooms24x7xml ## supplier_code-rooms24x7xml  ## percentage - 0.00 ## lead_time - 24 ==&lt;br&gt;== agent_id-1284 ## supplier_id- 93 ## company_name - TBO Holidays ## supplier_code-tboholidays  ## percentage - 0.00 ## lead_time - 24 ',`ip`= '103.104.226.130';
[12/18/2024 07:55:05], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-12-18 07:55:05',login_attempt=0 where id = '1284';
[12/18/2024 07:55:05], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'qtech_agent', user_type = 'A', branch_id = '26', login_datetime = '2024-12-18 07:55:05', ip = '103.104.226.130', action = 'Login' ;
[12/18/2024 07:55:17], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '1284' , 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 = '129' , service_type = 'hotel' , arrival_date = '2025/01/01' , departure_date = '2025/01/02' , nights = '1' , nationality = '129' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-12-18 07:55:17' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'INR' , currency_code = 'INR' , web_service = '0' ;
[12/18/2024 07:55:18], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],INSERT INTO collection_info SET mongo_dbname='L_AST_1284_12841820241207551718586560486', session_id='12841820241207551718586560486', Collection_create_time='2024-12-18 07:55:18';
[12/18/2024 07:55:40], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '690',
        request_path = '/xml_all.php?userid=1284&sessionid=12841820241207551718586560486',
        duration = '22.164',
        merge_duration = '0.012',
        assigned_supplier_count = '2',
        searched_supplier_count = '1',
        system_load_1_min = '0.11',
        system_load_5_min = '0.28',
        system_load_15_min = '0.32',
        system_memory_usage = '58.57',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '18485849') + '2038264',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = '',
        is_cached = 'no'
        WHERE id = '18485849';
[12/18/2024 07:55:58], [file name :-/efsdata/otrams/public_html/beta/method_call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/18_12_2024/request_availability_qtech_agent_07_55_50_1734508550.json', 'rh/18_12_2024/response_availability_qtech_agent_07_55_50_1734508550.json', 'rh/18_12_2024/response_header_availability_qtech_agent_07_55_50_1734508550.json', 'ratehawk', '2024-12-18 07:55:58', '', '12841820241207551718586560486', '18485849', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/18_12_2024/response_availability_qtech_agent_07_55_50_1734508550.json');
[12/18/2024 07:56:08], [file name :-/efsdata/otrams/public_html/beta/method_call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'rh/18_12_2024/request_availability_qtech_agent_07_56_00_1734508560.json', 'rh/18_12_2024/response_availability_qtech_agent_07_56_00_1734508560.json', 'rh/18_12_2024/response_header_availability_qtech_agent_07_56_00_1734508560.json', 'ratehawk', '2024-12-18 07:56:08', '', '12841820241207551718586560486', '18485849', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/rh/18_12_2024/response_availability_qtech_agent_07_56_00_1734508560.json');
[12/18/2024 07:56:12], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1734508572','103.104.226.130');
