[06/24/2024 07:11:44], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-06-24 07:11:44',login_attempt=0 where id = '7857';
[06/24/2024 07:11:44], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '23', login_datetime = '2024-06-24 07:11:44', ip = '43.239.53.130', action = 'Login' ;
[06/24/2024 07:49:26], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-06-24 07:49:26',login_attempt=0 where id = '7851';
[06/24/2024 07:49:26], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-06-24 07:49:26', ip = '43.239.53.130', action = 'Login' ;
[06/24/2024 07:50:00], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'jaipur' , arrival_date='2024/08/31',  departure_date='2024/08/31',  nights='1',  create_date='2024-06-24 :07:50:00',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[06/24/2024 07:50:02], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'v1/24_06_2024/request_availability_Viator_test_07_50_00_1719215400.json', 'v1/24_06_2024/response_availability_Viator_test_07_50_00_1719215400.json', 'v1/24_06_2024/response_header_availability_Viator_test_07_50_00_1719215400.json', 'viator', '2024-06-24 07:50:02', '', '', '2395', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/24_06_2024/response_availability_Viator_test_07_50_00_1719215400.json');
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '67' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '52' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '80' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '24' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '64' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '65' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '34' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '20' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '55' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '62' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '53' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '16' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '81' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '78' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '75' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '18' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '19' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '71' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '69' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '68' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '35' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '70' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '59' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '32' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '58' ,status = '1' ,priority = '7' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '7';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '56' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:54], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '61' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '63' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '54' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '7851',supplier_id = '45' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[06/24/2024 07:54:55], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'v3alpha',`create_date`= '2024-06-24 07:54:55',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 52 ,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;7851\&#039;,supplier_id = 80 ,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;7851\&#039;,supplier_id = 76 ,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;7851\&#039;,supplier_id = 24 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#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;7851\&#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;7851\&#039;,supplier_id = 34 ,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;7851\&#039;,supplier_id = 20 ,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;7851\&#039;,supplier_id = 55 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 62 ,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;7851\&#039;,supplier_id = 53 ,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;7851\&#039;,supplier_id = 16 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#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;7851\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 60 ,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;7851\&#039;,supplier_id = 18 ,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;7851\&#039;,supplier_id = 19 ,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;7851\&#039;,supplier_id = 73 ,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;7851\&#039;,supplier_id = 71 ,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;7851\&#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;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#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;7851\&#039;,supplier_id = 74 ,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;7851\&#039;,supplier_id = 35 ,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;7851\&#039;,supplier_id = 70 ,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;7851\&#039;,supplier_id = 59 ,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;7851\&#039;,supplier_id = 32 ,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;7851\&#039;,supplier_id = 58 ,status = \&#039;1\&#039; ,priority = \&#039;7\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;7\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;7851\&#039;,supplier_id = 56 ,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;7851\&#039;,supplier_id = 57 ,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;7851\&#039;,supplier_id = 61 ,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;7851\&#039;,supplier_id = 63 ,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;7851\&#039;,supplier_id = 54 ,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;7851\&#039;,supplier_id = 45 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-7851 ## supplier_id- 58 ## company_name - Viator (SightSeeing) ## supplier_code-viator  ## percentage - 0.00 ## lead_time - 96 ',`ip`= '43.239.53.130';
[06/24/2024 07:54:58], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-06-24 07:54:58',login_attempt=0 where id = '7851';
[06/24/2024 07:54:58], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Viator_test', user_type = 'A', branch_id = '27', login_datetime = '2024-06-24 07:54:58', ip = '43.239.53.130', action = 'Login' ;
[06/24/2024 07:55:16], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'jaipur' , arrival_date='2024/08/15',  departure_date='2024/08/15',  nights='1',  create_date='2024-06-24 :07:55:16',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[06/24/2024 07:55:17], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'v1/24_06_2024/request_availability_Viator_test_07_55_16_1719215716.json', 'v1/24_06_2024/response_availability_Viator_test_07_55_16_1719215716.json', 'v1/24_06_2024/response_header_availability_Viator_test_07_55_16_1719215716.json', 'viator', '2024-06-24 07:55:17', '', '', '2396', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/24_06_2024/response_availability_Viator_test_07_55_16_1719215716.json');
[06/24/2024 07:55:33], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'raipur' , arrival_date='2024/09/12',  departure_date='2024/09/12',  nights='1',  create_date='2024-06-24 :07:55:33',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[06/24/2024 07:55:46], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7851' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '27' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/09/27',  departure_date='2024/09/27',  nights='1',  create_date='2024-06-24 :07:55:46',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[06/24/2024 07:55:48], [file name :-/efsdata/otrams/public_html/beta/sight_search_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id,file_path) VALUE ('', 'AVAILABILITY', 'v1/24_06_2024/request_availability_Viator_test_07_55_46_1719215746.json', 'v1/24_06_2024/response_availability_Viator_test_07_55_46_1719215746.json', 'v1/24_06_2024/response_header_availability_Viator_test_07_55_46_1719215746.json', 'viator', '2024-06-24 07:55:48', '', '', '2398', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/24_06_2024/response_availability_Viator_test_07_55_46_1719215746.json');
