[07/19/2024 06:25:42], [file name :-/efsdata/otrams/public_html/beta/index.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2024-07-19 06:25:42', ip = '40.77.167.21', action = 'Login' ;
[07/19/2024 06:49:39], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-19 06:49:39',login_attempt=0 where id = '7851';
[07/19/2024 06:49:40], [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-07-19 06:49:40', ip = '43.239.53.130', action = 'Login' ;
[07/19/2024 06:51: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 = 'koh phangan' , arrival_date='2024/07/30',  departure_date='2024/07/30',  nights='1',  create_date='2024-07-19 :06:51:46',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[07/19/2024 06:51:47], [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/19_07_2024/request_availability_Viator_test_06_51_46_1721371906.json', 'v1/19_07_2024/response_availability_Viator_test_06_51_46_1721371906.json', 'v1/19_07_2024/response_header_availability_Viator_test_06_51_46_1721371906.json', 'viator', '2024-07-19 06:51:47', '', '', '2630', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/19_07_2024/response_availability_Viator_test_06_51_46_1721371906.json');
[07/19/2024 06:51:50], [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/19_07_2024/request_availability_Viator_test_06_51_47_1721371907_43.json', 'v1/19_07_2024/response_availability_Viator_test_06_51_47_1721371907_43.json', 'v1/19_07_2024/response_header_availability_Viator_test_06_51_47_1721371907_43.json', 'viator', '2024-07-19 06:51:50', '', '', '2630', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/19_07_2024/response_availability_Viator_test_06_51_47_1721371907_43.json');
[07/19/2024 06:51:50], [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/19_07_2024/request_availability_Viator_test_06_51_47_1721371907_43.json', 'v1/19_07_2024/response_availability_Viator_test_06_51_47_1721371907_43.json', 'v1/19_07_2024/response_header_availability_Viator_test_06_51_47_1721371907_43.json', 'viator', '2024-07-19 06:51:50', '', '', '2630', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/19_07_2024/response_availability_Viator_test_06_51_47_1721371907_43.json');
[07/19/2024 06:51:59], [file name :-/efsdata/otrams/public_html/beta/user_sight_details.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 ('', 'SIGHT_DETAILS', 'v1/19_07_2024/request_sight_details_Viator_test_06_51_59_1721371919.json', 'v1/19_07_2024/response_sight_details_Viator_test_06_51_59_1721371919.json', 'v1/19_07_2024/response_header_sight_details_Viator_test_06_51_59_1721371919.json', 'viator', '2024-07-19 06:51:59', '', '', '2630', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/19_07_2024/response_sight_details_Viator_test_06_51_59_1721371919.json');
[07/19/2024 06:51:59], [file name :-/efsdata/otrams/public_html/beta/user_sight_details.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 ('', 'SIGHT_DETAILS', 'v1/19_07_2024/request_sight_details_Viator_test_06_51_59_1721371919.json', 'v1/19_07_2024/response_sight_details_Viator_test_06_51_59_1721371919.json', 'v1/19_07_2024/response_header_sight_details_Viator_test_06_51_59_1721371919.json', 'viator', '2024-07-19 06:51:59', '', '', '2630', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/19_07_2024/response_sight_details_Viator_test_06_51_59_1721371919.json');
[07/19/2024 06:52:02], [file name :-/efsdata/otrams/public_html/beta/user_sight_details.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 ('', 'CHECK_AVAILABILITY', 'v1/19_07_2024/request_check_availability_Viator_test_06_52_02_1721371922.json', 'v1/19_07_2024/response_check_availability_Viator_test_06_52_02_1721371922.json', 'v1/19_07_2024/response_header_check_availability_Viator_test_06_52_02_1721371922.json', 'viator', '2024-07-19 06:52:02', '', '', '2630', 'https://beta.astrabookings.com/project_folder/astra_protected/supplier_logs/v1/19_07_2024/response_check_availability_Viator_test_06_52_02_1721371922.json');
[07/19/2024 06:52:08], [file name :-/efsdata/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1721371928','43.239.53.130');
[07/19/2024 06:59:10], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_REQUEST','/efsdata/otrams/public_html/beta/project_folder/astra_protected//supplier_logs/amadeus_flight/19_07_2024/request_Availability_yogeshqtech_06_59_10_1721372350.xml','amadeus','2024-07-19 06:59:10','');
[07/19/2024 06:59:10], [file name :-/efsdata/otrams/public_html/beta/flight_call.php],insert into xmllogs(reservation_id,type,file_path,source_type,create_date,agent_logs_id) value('','AVAILABILITY_RESPONSE','https://betalive.astrabookings.com/project_folder/astra_protected/supplier_logs/amadeus_flight/19_07_2024/response_Availability_yogeshqtech_06_59_10_1721372350.xml','Amadeus','2024-07-19 06:59:10','');
