[01/19/2024 01:00:01], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:00:01' WHERE id= '309';
[01/19/2024 01:00:01], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:00:01' WHERE id= '309';
[01/19/2024 01:05:36], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:05:36' WHERE id= '309';
[01/19/2024 01:05:36], [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/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :13:05:36',  nationality='',  additional_markup='',  selected_currency='AED',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 01:05: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, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/19_01_2024/request_availability_Viator_test_13_05_36_1705669536.json', 'v1/19_01_2024/response_availability_Viator_test_13_05_36_1705669536.json', 'v1/19_01_2024/response_header_availability_Viator_test_13_05_36_1705669536.json', 'viator', '2024-01-19 01:05:37', '', '', '1044');
[01/19/2024 01:05:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:05:39' WHERE id= '309';
[01/19/2024 01:05:40], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:05:40' WHERE id= '309';
[01/19/2024 01:16:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:16:18' WHERE id= '309';
[01/19/2024 01:16:18], [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/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :13:16:18',  nationality='',  additional_markup='',  selected_currency='AED',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 01:16:19], [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, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/19_01_2024/request_availability_Viator_test_13_16_18_1705670178.json', 'v1/19_01_2024/response_availability_Viator_test_13_16_18_1705670178.json', 'v1/19_01_2024/response_header_availability_Viator_test_13_16_18_1705670178.json', 'viator', '2024-01-19 01:16:19', '', '', '1045');
[01/19/2024 01:16:21], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:16:21' WHERE id= '309';
[01/19/2024 01:16:21], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:16:21' WHERE id= '309';
[01/19/2024 01:16:23], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:16:23' WHERE id= '309';
[01/19/2024 01:16:28], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:16:28' WHERE id= '309';
[01/19/2024 01:16:33], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:16:33' WHERE id= '309';
[01/19/2024 01:16:33], [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/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :13:16:33',  nationality='',  additional_markup='',  selected_currency='AUD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 01:16:34], [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, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/19_01_2024/request_availability_Viator_test_13_16_33_1705670193.json', 'v1/19_01_2024/response_availability_Viator_test_13_16_33_1705670193.json', 'v1/19_01_2024/response_header_availability_Viator_test_13_16_33_1705670193.json', 'viator', '2024-01-19 01:16:34', '', '', '1046');
[01/19/2024 01:16:35], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:16:35' WHERE id= '309';
[01/19/2024 01:16:36], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:16:36' WHERE id= '309';
[01/19/2024 01:17:02], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:17:02' WHERE id= '309';
[01/19/2024 01:17:09], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:17:09' WHERE id= '309';
[01/19/2024 01:17:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:17:20' WHERE id= '309';
[01/19/2024 01:17:20], [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 = 'lucca' , arrival_date='2024/01/22',  departure_date='2024/01/22',  nights='1',  create_date='2024-01-19 :13:17:20',  nationality='',  additional_markup='',  selected_currency='AUD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 01:17:21], [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, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/19_01_2024/request_availability_Viator_test_13_17_20_1705670240.json', 'v1/19_01_2024/response_availability_Viator_test_13_17_20_1705670240.json', 'v1/19_01_2024/response_header_availability_Viator_test_13_17_20_1705670240.json', 'viator', '2024-01-19 01:17:21', '', '', '1047');
[01/19/2024 01:17:23], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:17:23' WHERE id= '309';
[01/19/2024 01:17:23], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:17:23' WHERE id= '309';
[01/19/2024 01:17:29], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:17:29' WHERE id= '309';
[01/19/2024 01:17:30], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_17_29_1705670249.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_17_29_1705670249.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_17_29_1705670249.json', 'viator', '2024-01-19 01:17:30', '', '', '1047');
[01/19/2024 01:17:37], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:17:37' WHERE id= '309';
[01/19/2024 01:17:37], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_17_37_1705670257.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_17_37_1705670257.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_17_37_1705670257.json', 'viator', '2024-01-19 01:17:37', '', '', '1047');
[01/19/2024 01:17:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:17:41' WHERE id= '309';
[01/19/2024 01:17:41], [file name :-/home/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)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_Viator_test_13_17_41_1705670261.json', 'v1/19_01_2024/response_check_availability_Viator_test_13_17_41_1705670261.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_13_17_41_1705670261.json', 'viator', '2024-01-19 01:17:41', '', '', '1047');
[01/19/2024 01:17:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:17:49' WHERE id= '309';
[01/19/2024 01:17:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705670269','43.239.53.130');
[01/19/2024 01:18:42], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:18:42' WHERE id= '309';
[01/19/2024 01:18:44], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:18:44' WHERE id= '309';
[01/19/2024 01:18:50], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:18:50' WHERE id= '309';
[01/19/2024 01:18:53], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:18:53' WHERE id= '309';
[01/19/2024 01:18:56], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:18:56' WHERE id= '309';
[01/19/2024 01:18:59], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:18:59' WHERE id= '309';
[01/19/2024 01:19:03], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:19:03' WHERE id= '309';
[01/19/2024 01:19:07], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:19:07' WHERE id= '309';
[01/19/2024 01:19:12], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:19:12' WHERE id= '309';
[01/19/2024 01:19:19], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:19:19' WHERE id= '309';
[01/19/2024 01:19:25], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:19:25' WHERE id= '309';
[01/19/2024 01:19:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:19:27' WHERE id= '309';
[01/19/2024 01:19:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:19:49' WHERE id= '309';
[01/19/2024 01:19:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705670389','43.239.53.130');
[01/19/2024 01:19:49], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:19:49' WHERE id= '309';
[01/19/2024 01:19:49], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1906',agent_id='7851',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='lucca',country_id='68',nationality='Italian',display_room_rate='574.86',display_currency_code='AUD',native_room_rate='397.85',consultant_id='SUJAY_QTECH',native_currency_code='EUR',cancellation_policy='Cancellation Charges will be applicable if cancelled after 07 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>574.86 AUDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-19 13:19:49',source_type='viator',expiration_date= '2023-12-07 09:00:00',applied_multiplier='1.44492',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.94245',basecurrency_multiplier_native='1.36177',admin_booked='0',service_date='2024-01-22',sub_user_id='',check_out_date='2024-01-22',supplier_profile_id='',agent_currency_multiplier='3.53484', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/19/2024 01:19:49], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='316',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:397.85000000000002;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:574.86000000000001;s:25:\"displayNightlyRateDisplay\";s:134:\"Rate - 397.85 EUR, Currency Multiplier (EUR-AUD) - 1.44492, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:135:\"Rate - 397.85 EUR, Currency Multiplier (EUR-AUD) - 1.44492, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='AUD',native_currency_code='EUR',sight_id='184864P1',sight_name='PRIVATE WINE TASTING IN LUCCA - 5 WINES AND A TASTE OF LOCAL PRODUCTS- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive='<br/>',meeting_point='',tour_dep_point=' ',tour_language='it/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='1 hours 30 minutes<br> Start Time: ',arrival_date='2024-01-22',total_adults='5',total_children='',total_infants='',gta_city_code='22436',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/19/2024 01:19:49], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1906','2024-01-19 13:19:49',0);
[01/19/2024 01:19:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation_sight', 'v1/19_01_2024/request_reservation_sight_Viator_test_13_19_49_1705670389.json', 'v1/19_01_2024/response_reservation_sight_Viator_test_13_19_49_1705670389.json', 'v1/19_01_2024/response_header_reservation_sight_Viator_test_13_19_49_1705670389.json', 'viator', '2024-01-19 01:19:56', '', '', '1047');
[01/19/2024 01:19:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '153';
[01/19/2024 01:19:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7851', applicable_service_tax='0', sub_agent_rate='0', agent_rate='574.86', supplier_rate='397.85', uid='', itenirary_id='1906223', confirmation_number='BR-595211493', comment_contract='', current_status='confirmed', original_source='' where id='316';
[01/19/2024 01:19:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',tour_supplier='',textaddition_activities='N;' where booking_id='316';
[01/19/2024 01:19:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','316','confirmed','2024-01-19 13:19:56','Sightseeing Booking confirmed by Agent..7851','7851','43.239.53.130','','','');
[01/19/2024 01:19:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('316','Mr','1','shiv','chauhan','adult','0');
[01/19/2024 01:19:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('316','Mr','1','Jai','Maharaj','adult','0');
[01/19/2024 01:19:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('316','Mr','1','Dev','Annad','adult','0');
[01/19/2024 01:19:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('316','Mr','1','sakti','kapoor','adult','0');
[01/19/2024 01:19:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('316','Mr','1','rahul','kejariwal','adult','0');
[01/19/2024 01:19:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='316' where agent_logs_id='1047' and source_type='viator';
[01/19/2024 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set invoice_number= 'INV19012400002', voucher_id='1901132001',status_date='2024-01-19 13:20:01',current_status='vouchered',voucher_hashcode='392d52dcc08baf044d245799f34d4dc481512316',vouchered_by ='' where id='316';
[01/19/2024 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set is_invoiced='yes',invoice_number= 'INV19012400002' where id='316' and is_invoiced!='yes';
[01/19/2024 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE agents SET credit_usage=credit_usage+('2032.0381224'),   credit_value= credit_value-('2032.0381224') ,  cd_credit_usage=cd_credit_usage+('2032.0381224') , cd_credit_value=cd_credit_value-('2032.0381224')  WHERE id = '7851';
[01/19/2024 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into  agent_credit_log SET agent_id= '7851',credit_value= '4244.658',credit_usage= '5755.342',credit_limit= '10000.000',receipt_id= '',amount= '2032.0381224',booking_id='316',booking_cost= '',receipt_allocation= '',balance= '',ip='43.239.53.130',user_type='User',admin_id='Agent - Viator  Viator(CD7851)',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2024-01-19 13:01:01';
[01/19/2024 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php], insert into booking_rate_info set  booking_id = '316', booking_log = 'Booking Vouchered', create_date = '2024-01-19 13:20:01', supplier_currency ='EUR', type = 'Sale', agent_price = '574.86', sub_agent_price ='', supplier_price = '397.850', supplier_id = 'viator', supplier_type = 'online';
[01/19/2024 01:20:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','316','vouchered-invoiced','2024-01-19 13:20:03','Booking invoiced by Back Office v3alpha on behalf of Agent - Viator  Viator(CD7851)','7851','43.239.53.130','','','');
[01/19/2024 01:20:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO agent_commission SET booking_id ='316',booking_detail_id ='316',agent_id ='7851',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='AUD',paid ='N',type ='sightseeing',description ='Agent Mark Up Percentage is 0 %',create_date ='2024-01-19 13:20:03';
[01/19/2024 01:20:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','316','vouchered','2024-01-19 13:20:03','Voucherd by Back Office v3alpha on behalf of Agent - Viator  Viator(CD7851)','7851','43.239.53.130','','','');
[01/19/2024 01:24:19], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:24:19' WHERE id= '309';
[01/19/2024 01:24:19], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-01-19 01:24:19',login_attempt=0 where id = '7851';
[01/19/2024 01:24:19], [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-01-19 13:24:19', ip = '43.239.53.130', action = 'Login' ;
[01/19/2024 01:24:19], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:24:19' WHERE id= '309';
[01/19/2024 01:24:23], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:24:23' WHERE id= '309';
[01/19/2024 01:24:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:24:27' WHERE id= '309';
[01/19/2024 01:24:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:24:39' WHERE id= '309';
[01/19/2024 01:24:39], [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/01/23',  departure_date='2024/01/23',  nights='1',  create_date='2024-01-19 :13:24:39',  nationality='',  additional_markup='',  selected_currency='AUD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 01:24:39], [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, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/19_01_2024/request_availability_Viator_test_13_24_39_1705670679.json', 'v1/19_01_2024/response_availability_Viator_test_13_24_39_1705670679.json', 'v1/19_01_2024/response_header_availability_Viator_test_13_24_39_1705670679.json', 'viator', '2024-01-19 01:24:39', '', '', '1048');
[01/19/2024 01:24:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:24:41' WHERE id= '309';
[01/19/2024 01:24:41], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:24:41' WHERE id= '309';
[01/19/2024 01:25:18], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:18' WHERE id= '309';
[01/19/2024 01:25:18], [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/01/23',  departure_date='2024/01/23',  nights='1',  create_date='2024-01-19 :13:25:18',  nationality='',  additional_markup='',  selected_currency='AUD',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[01/19/2024 01:25:18], [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, session_id, agent_logs_id)
                VALUE ('', 'availability', 'v1/19_01_2024/request_availability_Viator_test_13_25_18_1705670718.json', 'v1/19_01_2024/response_availability_Viator_test_13_25_18_1705670718.json', 'v1/19_01_2024/response_header_availability_Viator_test_13_25_18_1705670718.json', 'viator', '2024-01-19 01:25:18', '', '', '1049');
[01/19/2024 01:25:20], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:20' WHERE id= '309';
[01/19/2024 01:25:20], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:20' WHERE id= '309';
[01/19/2024 01:25:24], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:24' WHERE id= '309';
[01/19/2024 01:25:24], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_25_24_1705670724.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_25_24_1705670724.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_25_24_1705670724.json', 'viator', '2024-01-19 01:25:24', '', '', '1049');
[01/19/2024 01:25:27], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:27' WHERE id= '309';
[01/19/2024 01:25:28], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_25_27_1705670727.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_25_27_1705670727.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_25_27_1705670727.json', 'viator', '2024-01-19 01:25:28', '', '', '1049');
[01/19/2024 01:25:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:32' WHERE id= '309';
[01/19/2024 01:25:32], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_25_32_1705670732.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_25_32_1705670732.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_25_32_1705670732.json', 'viator', '2024-01-19 01:25:32', '', '', '1049');
[01/19/2024 01:25:35], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:35' WHERE id= '309';
[01/19/2024 01:25:36], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_25_35_1705670735.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_25_35_1705670735.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_25_35_1705670735.json', 'viator', '2024-01-19 01:25:36', '', '', '1049');
[01/19/2024 01:25:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:38' WHERE id= '309';
[01/19/2024 01:25:39], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_25_38_1705670738.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_25_38_1705670738.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_25_38_1705670738.json', 'viator', '2024-01-19 01:25:39', '', '', '1049');
[01/19/2024 01:25:41], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:41' WHERE id= '309';
[01/19/2024 01:25:41], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_25_41_1705670741.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_25_41_1705670741.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_25_41_1705670741.json', 'viator', '2024-01-19 01:25:41', '', '', '1049');
[01/19/2024 01:25:50], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:50' WHERE id= '309';
[01/19/2024 01:25:51], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_25_50_1705670750.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_25_50_1705670750.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_25_50_1705670750.json', 'viator', '2024-01-19 01:25:51', '', '', '1049');
[01/19/2024 01:25:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:53' WHERE id= '309';
[01/19/2024 01:25:53], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_25_53_1705670753.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_25_53_1705670753.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_25_53_1705670753.json', 'viator', '2024-01-19 01:25:53', '', '', '1049');
[01/19/2024 01:25:59], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:25:59' WHERE id= '309';
[01/19/2024 01:25:59], [file name :-/home/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)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_Viator_test_13_25_59_1705670759.json', 'v1/19_01_2024/response_check_availability_Viator_test_13_25_59_1705670759.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_13_25_59_1705670759.json', 'viator', '2024-01-19 01:25:59', '', '', '1049');
[01/19/2024 01:26:13], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:26:13' WHERE id= '309';
[01/19/2024 01:26:14], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_26_13_1705670773.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_26_13_1705670773.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_26_13_1705670773.json', 'viator', '2024-01-19 01:26:14', '', '', '1049');
[01/19/2024 01:26:16], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:26:16' WHERE id= '309';
[01/19/2024 01:26:16], [file name :-/home/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)
                VALUE ('', 'sight_details', 'v1/19_01_2024/request_sight_details_Viator_test_13_26_16_1705670776.json', 'v1/19_01_2024/response_sight_details_Viator_test_13_26_16_1705670776.json', 'v1/19_01_2024/response_header_sight_details_Viator_test_13_26_16_1705670776.json', 'viator', '2024-01-19 01:26:16', '', '', '1049');
[01/19/2024 01:26:32], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:26:32' WHERE id= '309';
[01/19/2024 01:26:33], [file name :-/home/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)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_Viator_test_13_26_32_1705670792.json', 'v1/19_01_2024/response_check_availability_Viator_test_13_26_32_1705670792.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_13_26_32_1705670792.json', 'viator', '2024-01-19 01:26:33', '', '', '1049');
[01/19/2024 01:26:38], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:26:38' WHERE id= '309';
[01/19/2024 01:26:38], [file name :-/home/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)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_Viator_test_13_26_38_1705670798.json', 'v1/19_01_2024/response_check_availability_Viator_test_13_26_38_1705670798.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_13_26_38_1705670798.json', 'viator', '2024-01-19 01:26:38', '', '', '1049');
[01/19/2024 01:26:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:26:45' WHERE id= '309';
[01/19/2024 01:26:45], [file name :-/home/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)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_Viator_test_13_26_45_1705670805.json', 'v1/19_01_2024/response_check_availability_Viator_test_13_26_45_1705670805.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_13_26_45_1705670805.json', 'viator', '2024-01-19 01:26:45', '', '', '1049');
[01/19/2024 01:26:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:26:49' WHERE id= '309';
[01/19/2024 01:26:49], [file name :-/home/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)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_Viator_test_13_26_49_1705670809.json', 'v1/19_01_2024/response_check_availability_Viator_test_13_26_49_1705670809.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_13_26_49_1705670809.json', 'viator', '2024-01-19 01:26:49', '', '', '1049');
[01/19/2024 01:26:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:26:55' WHERE id= '309';
[01/19/2024 01:26:55], [file name :-/home/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)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_Viator_test_13_26_55_1705670815.json', 'v1/19_01_2024/response_check_availability_Viator_test_13_26_55_1705670815.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_13_26_55_1705670815.json', 'viator', '2024-01-19 01:26:55', '', '', '1049');
[01/19/2024 01:27:08], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:27:08' WHERE id= '309';
[01/19/2024 01:27:09], [file name :-/home/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)
                VALUE ('', 'check_availability', 'v1/19_01_2024/request_check_availability_Viator_test_13_27_08_1705670828.json', 'v1/19_01_2024/response_check_availability_Viator_test_13_27_08_1705670828.json', 'v1/19_01_2024/response_header_check_availability_Viator_test_13_27_08_1705670828.json', 'viator', '2024-01-19 01:27:09', '', '', '1049');
[01/19/2024 01:27:13], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:27:13' WHERE id= '309';
[01/19/2024 01:27:13], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705670833','43.239.53.130');
[01/19/2024 01:28:13], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:28:13' WHERE id= '309';
[01/19/2024 01:28:15], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:28:15' WHERE id= '309';
[01/19/2024 01:28:17], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:28:17' WHERE id= '309';
[01/19/2024 01:28:21], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:28:21' WHERE id= '309';
[01/19/2024 01:30:55], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:30:55' WHERE id= '309';
[01/19/2024 01:30:55], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1705671055','43.239.53.130');
[01/19/2024 01:30:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:30:56' WHERE id= '309';
[01/19/2024 01:30:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1908',agent_id='7851',leader_title='Ms',leader_first_name='shiv',leader_last_name='sdhs',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='80.73',display_currency_code='AUD',native_room_rate='76.08',consultant_id='SUJAY_QTECH',native_currency_code='',cancellation_policy='Cancellation Charges will be applicable if cancelled after 07 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>80.73 AUDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-19 13:30:56',source_type='viator',expiration_date= '2023-12-07 09:00:00',applied_multiplier='',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.94245',basecurrency_multiplier_native='',admin_booked='0',service_date='2024-01-23',sub_user_id='',check_out_date='2024-01-23',supplier_profile_id='',agent_currency_multiplier='3.53484', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/19/2024 01:30:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='317',native_nightly_rates='a:1:{s:17:\"nativeNightlyRate\";d:76.079999999999998;}',rate_description='',display_nightly_rates='a:3:{s:18:\"displayNightlyRate\";d:80.730000000000004;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 76.08 USD, Currency Multiplier (USD-AUD) - 1.06107, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 76.08 USD, Currency Multiplier (USD-AUD) - 1.06107, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='AUD',native_currency_code='',sight_id='386596P1',sight_name='DESERT SAFARI, 60-MIN SELF-DRIVE ATV, CAMEL RIDE, SHOWS, DINNER- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-23',total_adults='2',total_children='',total_infants='1',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/19/2024 01:30:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1908','2024-01-19 13:30:56',0);
[01/19/2024 01:31:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:31:59' WHERE id= '309';
[01/19/2024 01:31:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1908',agent_id='7851',leader_title='Ms',leader_first_name='shiv',leader_last_name='sdhs',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='80.73',display_currency_code='AUD',native_room_rate='76.08',consultant_id='SUJAY_QTECH',native_currency_code='',cancellation_policy='Cancellation Charges will be applicable if cancelled after 07 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>80.73 AUDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-19 13:31:59',source_type='viator',expiration_date= '2023-12-07 09:00:00',applied_multiplier='',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.94245',basecurrency_multiplier_native='',admin_booked='0',service_date='2024-01-23',sub_user_id='',check_out_date='2024-01-23',supplier_profile_id='',agent_currency_multiplier='3.53484', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/19/2024 01:31:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='318',native_nightly_rates='a:1:{s:17:\"nativeNightlyRate\";d:76.079999999999998;}',rate_description='',display_nightly_rates='a:3:{s:18:\"displayNightlyRate\";d:80.730000000000004;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 76.08 USD, Currency Multiplier (USD-AUD) - 1.06107, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 76.08 USD, Currency Multiplier (USD-AUD) - 1.06107, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='AUD',native_currency_code='',sight_id='386596P1',sight_name='DESERT SAFARI, 60-MIN SELF-DRIVE ATV, CAMEL RIDE, SHOWS, DINNER- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-23',total_adults='2',total_children='',total_infants='1',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/19/2024 01:31:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1908','2024-01-19 13:31:59',0);
[01/19/2024 01:32:00], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation_sight', 'v1/19_01_2024/request_reservation_sight_Viator_test_13_31_59_1705671119.json', 'v1/19_01_2024/response_reservation_sight_Viator_test_13_31_59_1705671119.json', 'v1/19_01_2024/response_header_reservation_sight_Viator_test_13_31_59_1705671119.json', 'viator', '2024-01-19 01:32:00', '', '', '1049');
[01/19/2024 01:35:25], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-01-19 01:35:25' WHERE id= '309';
[01/19/2024 01:35:25], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='1908',agent_id='7851',leader_title='Ms',leader_first_name='shiv',leader_last_name='sdhs',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='80.73',display_currency_code='AUD',native_room_rate='76.08',consultant_id='SUJAY_QTECH',native_currency_code='',cancellation_policy='Cancellation Charges will be applicable if cancelled after 07 Dec 2023 12:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>80.73 AUDCharges - 100% applicable from time of Booking (Full Cancellation Charges applicable immediately)',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-01-19 13:35:25',source_type='viator',expiration_date= '2023-12-07 09:00:00',applied_multiplier='',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.94245',basecurrency_multiplier_native='',admin_booked='0',service_date='2024-01-23',sub_user_id='',check_out_date='2024-01-23',supplier_profile_id='',agent_currency_multiplier='3.53484', booking_branch_id = '27',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[01/19/2024 01:35:25], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='319',native_nightly_rates='a:1:{s:17:\"nativeNightlyRate\";d:76.079999999999998;}',rate_description='',display_nightly_rates='a:3:{s:18:\"displayNightlyRate\";d:80.730000000000004;s:25:\"displayNightlyRateDisplay\";s:133:\"Rate - 76.08 USD, Currency Multiplier (USD-AUD) - 1.06107, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:134:\"Rate - 76.08 USD, Currency Multiplier (USD-AUD) - 1.06107, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='AUD',native_currency_code='',sight_id='386596P1',sight_name='DESERT SAFARI, 60-MIN SELF-DRIVE ATV, CAMEL RIDE, SHOWS, DINNER- V2',tour_time='',tour_details='',tour_inclusive='<br/>',tour_exclusive=',<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='7 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-01-23',total_adults='2',total_children='',total_infants='1',gta_city_code='828',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[01/19/2024 01:35:25], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO posted_bookings(id,source_type,reservation_id,create_date,status) values ('','viator','1908','2024-01-19 13:35:25',0);
[01/19/2024 01:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation_sight', 'v1/19_01_2024/request_reservation_sight_Viator_test_13_35_25_1705671325.json', 'v1/19_01_2024/response_reservation_sight_Viator_test_13_35_25_1705671325.json', 'v1/19_01_2024/response_header_reservation_sight_Viator_test_13_35_25_1705671325.json', 'viator', '2024-01-19 01:35:26', '', '', '1049');
[01/19/2024 01:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '156';
[01/19/2024 01:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7851', applicable_service_tax='0', sub_agent_rate='0', agent_rate='80.73', supplier_rate='76.08', uid='', itenirary_id='', confirmation_number='', comment_contract='', current_status='failed', original_source='' where id='319';
[01/19/2024 01:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',tour_supplier='',textaddition_activities='N;' where booking_id='319';
[01/19/2024 01:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','319','failed','2024-01-19 13:35:26','Sightseeing Booking failed by Agent..7851','7851','43.239.53.130','','','');
[01/19/2024 01:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('319','Ms','1','shiv','sdhs','adult','0');
[01/19/2024 01:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('319','Mrs','1','sddfa','dsf','adult','0');
[01/19/2024 01:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],insert into sight_passangers(booking_id,salutations,tour,first_name,last_name,passenger_type,age)values('319','Baby','1','zzzzzzz','vxzgdf','infant','2');
[01/19/2024 01:35:26], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='319' where agent_logs_id='1049' and source_type='viator';
[01/19/2024 01:35:31], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set admin_booked='1' where id='319';
