[04/11/2024 10:20:14], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-04-11 10:20:14',login_attempt=0 where id = '7851';
[04/11/2024 10:20:14], [file name :-/home/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-04-11 10:20:14', ip = '43.239.53.130', action = 'Login' ;
[04/11/2024 10:20:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-11 10:20:14' WHERE id= '765';
[04/11/2024 10:20:16], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-04-11 10:20:16' WHERE id= '765';
[04/11/2024 10:20:22], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-11 10:20:22' WHERE id= '765';
[04/11/2024 10:20:28], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-11 10:20:28' WHERE id= '765';
[04/11/2024 10:20:28], [file name :-/home/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/04/25',  departure_date='2024/04/25',  nights='1',  create_date='2024-04-11 :10:20:28',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/11/2024 10:20:28], [file name :-/home/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)
                    VALUE('10', 'sight_cancellation_reason', 'v1/11_04_2024/request_sight_cancellation_reason_Viator_test_10_20_28_1712830828.json', 'v1/11_04_2024/response_sight_cancellation_reason_Viator_test_10_20_28_1712830828.json', 'v1/11_04_2024/response_header_sight_cancellation_reason_Viator_test_10_20_28_1712830828.json', 'viator', '2024-04-11 10:20:28', '');
[04/11/2024 10:21:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-11 10:21:37' WHERE id= '765';
[04/11/2024 10:21:37], [file name :-/home/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/04/25',  departure_date='2024/04/25',  nights='1',  create_date='2024-04-11 :10:21:37',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/11/2024 10:21:37], [file name :-/home/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)
                    VALUE('10', 'sight_cancellation_reason', 'v1/11_04_2024/request_sight_cancellation_reason_Viator_test_10_21_37_1712830897.json', 'v1/11_04_2024/response_sight_cancellation_reason_Viator_test_10_21_37_1712830897.json', 'v1/11_04_2024/response_header_sight_cancellation_reason_Viator_test_10_21_37_1712830897.json', 'viator', '2024-04-11 10:21:37', '');
[04/11/2024 10:21:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Chose a different/cheaper tour',cancellation_reasoncode='Customer_Service.Chose_a_different_cheaper_tour';
[04/11/2024 10:21:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Unexpected/medical circumstances',cancellation_reasoncode='Customer_Service.Unexpected_medical_circumstances';
[04/11/2024 10:21:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Weather',cancellation_reasoncode='Customer_Service.Weather';
[04/11/2024 10:21:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='I canceled my entire trip',cancellation_reasoncode='Customer_Service.I_canceled_my_entire_trip';
[04/11/2024 10:21:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='The guide or driver didn't show up',cancellation_reasoncode='Customer_Service.Supplier_no_show';
[04/11/2024 10:21:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Duplicate Booking',cancellation_reasoncode='Customer_Service.Duplicate_Booking';
[04/11/2024 10:21:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Booked wrong tour/date',cancellation_reasoncode='Customer_Service.Booked_wrong_tour_date';
[04/11/2024 10:21:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Significant global event/force Majeure',cancellation_reasoncode='Customer_Service.Significant_global_event';
[04/11/2024 10:31:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-11 10:31:59' WHERE id= '765';
[04/11/2024 10:31:59], [file name :-/home/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/04/25',  departure_date='2024/04/25',  nights='1',  create_date='2024-04-11 :10:31:59',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/11/2024 10:31:59], [file name :-/home/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)
                    VALUE('10', 'sight_cancellation_reason', 'v1/11_04_2024/request_sight_cancellation_reason_Viator_test_10_31_59_1712831519.json', 'v1/11_04_2024/response_sight_cancellation_reason_Viator_test_10_31_59_1712831519.json', 'v1/11_04_2024/response_header_sight_cancellation_reason_Viator_test_10_31_59_1712831519.json', 'viator', '2024-04-11 10:31:59', '');
[04/11/2024 10:31:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Booked wrong tour/date',cancellation_reasoncode='Customer_Service.Booked_wrong_tour_date';
[04/11/2024 10:31:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Chose a different/cheaper tour',cancellation_reasoncode='Customer_Service.Chose_a_different_cheaper_tour';
[04/11/2024 10:31:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Duplicate Booking',cancellation_reasoncode='Customer_Service.Duplicate_Booking';
[04/11/2024 10:31:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Unexpected/medical circumstances',cancellation_reasoncode='Customer_Service.Unexpected_medical_circumstances';
[04/11/2024 10:31:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Significant global event/force Majeure',cancellation_reasoncode='Customer_Service.Significant_global_event';
[04/11/2024 10:31:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='The guide or driver didn\'t show up',cancellation_reasoncode='Customer_Service.Supplier_no_show';
[04/11/2024 10:31:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Weather',cancellation_reasoncode='Customer_Service.Weather';
[04/11/2024 10:31:59], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='I canceled my entire trip',cancellation_reasoncode='Customer_Service.I_canceled_my_entire_trip';
[04/11/2024 10:32:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-04-11 10:32:42' WHERE id= '765';
[04/11/2024 10:32:42], [file name :-/home/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/04/25',  departure_date='2024/04/25',  nights='1',  create_date='2024-04-11 :10:32:42',  nationality='',  additional_markup='',  selected_currency='USD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[04/11/2024 10:32:42], [file name :-/home/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)
                    VALUE('10', 'sight_cancellation_reason', 'v1/11_04_2024/request_sight_cancellation_reason_Viator_test_10_32_42_1712831562.json', 'v1/11_04_2024/response_sight_cancellation_reason_Viator_test_10_32_42_1712831562.json', 'v1/11_04_2024/response_header_sight_cancellation_reason_Viator_test_10_32_42_1712831562.json', 'viator', '2024-04-11 10:32:42', '');
[04/11/2024 10:32:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Booked wrong tour/date',cancellation_reasoncode='Customer_Service.Booked_wrong_tour_date';
[04/11/2024 10:32:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Chose a different/cheaper tour',cancellation_reasoncode='Customer_Service.Chose_a_different_cheaper_tour';
[04/11/2024 10:32:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Duplicate Booking',cancellation_reasoncode='Customer_Service.Duplicate_Booking';
[04/11/2024 10:32:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Unexpected/medical circumstances',cancellation_reasoncode='Customer_Service.Unexpected_medical_circumstances';
[04/11/2024 10:32:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Significant global event/force Majeure',cancellation_reasoncode='Customer_Service.Significant_global_event';
[04/11/2024 10:32:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='The guide or driver didn\'t show up',cancellation_reasoncode='Customer_Service.Supplier_no_show';
[04/11/2024 10:32:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='Weather',cancellation_reasoncode='Customer_Service.Weather';
[04/11/2024 10:32:42], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO cancel_reason_viator SET cancellation_reason_text='I canceled my entire trip',cancellation_reasoncode='Customer_Service.I_canceled_my_entire_trip';
