[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '77' ,status = '1' ,priority = '5' ,lead_time = '4320',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '58' ,status = '1' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '74' ,status = '1' ,priority = '' ,lead_time = '',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '75' ,status = '1' ,priority = '14' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '56' ,status = '1' ,priority = '25' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '93' ,status = '1' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '81' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '78' ,status = '' ,priority = '24' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '24';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '83' ,status = '' ,priority = '16' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '16';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '90' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '66' ,status = '' ,priority = '20' ,lead_time = '48',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '20';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '94',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[09/05/2024 10:32:18], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-09-05 10:32:18',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 77 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;4320\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 58 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 74 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 75 ,status = \&#039;1\&#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;94\&#039;,supplier_id = 56 ,status = \&#039;1\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 93 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;24\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;24\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;16\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;16\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;20\&#039; ,lead_time = \&#039;48\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;20\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;94\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-94 ## supplier_id- 58 ## company_name - Destinations of the world (DOTW) ## supplier_code-dotw  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 75 ## company_name - Expedia Package ## supplier_code-expediapackage  ## percentage - 0.00 ## lead_time - 48 ==&lt;br&gt;== agent_id-94 ## supplier_id- 56 ## company_name - Hotelbeds ## supplier_code-hotelbeds  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-94 ## supplier_id- 67 ## company_name - Local System ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 72 ==&lt;br&gt;== agent_id-94 ## supplier_id- 1 ## company_name - Miki ## supplier_code-miki  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 100 ## company_name - Sun Hotels ## supplier_code-sunhotels  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 81 ## company_name - Amadeus Flight ## supplier_code-amadeus  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 78 ## company_name - Pyton ## supplier_code-pyton  ## percentage - 0.00 ## lead_time - 72 ==&lt;br&gt;== agent_id-94 ## supplier_id- 83 ## company_name - Hotelbeds Transfer ## supplier_code-hotelbedstransfer  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 68 ## company_name - Local Transfer System ## supplier_code-localtransfer  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 90 ## company_name - Local Sightseeing ## supplier_code-localsightseeing  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 66 ## company_name - Viator Sight Seeing - Live ## supplier_code-viator  ## percentage - 0.00 ## lead_time - 48 ==&lt;br&gt;== agent_id-94 ## supplier_id- 64 ## company_name - Groups ## supplier_code-groups  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 65 ## company_name - Event ## supplier_code-event  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 69 ## company_name - Visa ## supplier_code-visa  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 98 ## company_name - Dida ## supplier_code-dida  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 77 ## company_name - Agoda ## supplier_code-agoda  ## percentage - 0.00 ## lead_time - 4320 ==&lt;br&gt;== agent_id-94 ## supplier_id- 102 ## company_name - Bedzinn ## supplier_code-bedzinn  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-94 ## supplier_id- 101 ## company_name - Ratehawk ## supplier_code-ratehawk  ## percentage - 0.00 ## lead_time - 72 ==&lt;br&gt;== agent_id-94 ## supplier_id- 97 ## company_name - Tripathon - XML ## supplier_code-tripathonxml  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-94 ## supplier_id- 93 ## company_name - TBO Holidays ## supplier_code-tboholidays  ## percentage - 0.00 ## lead_time - 72 ==&lt;br&gt;== agent_id-94 ## supplier_id- 103 ## company_name - Rooms Xml (Stuba) ## supplier_code-roomsxml  ## percentage - 0.00 ## lead_time - 96 ==&lt;br&gt;== agent_id-94 ## supplier_id- 84 ## company_name - Jumbotours ## supplier_code-jumbotours  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-94 ## supplier_id- 99 ## company_name - EBooking Center ## supplier_code-ebookingcenter  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '43.239.53.130';
[09/05/2024 10:32:29], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-09-05 10:32:29',login_attempt=0 where id = '94';
[09/05/2024 10:32:29], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'mob_test', user_type = 'A', branch_id = '1', login_datetime = '2024-09-05 10:32:29', ip = '43.239.53.130', action = 'Login' ;
