[02/12/2024 02:05:03], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:05:03' WHERE id= '546';
[02/12/2024 02:05:15], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:05:15' WHERE id= '546';
[02/12/2024 02:05:27], [file name :-/home/otrams/public_html/beta/about_us.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:05:27' WHERE id= '546';
[02/12/2024 02:07:01], [file name :-/home/otrams/public_html/beta/print_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:07:01' WHERE id= '546';
[02/12/2024 02:14:20], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:14:20' WHERE id= '546';
[02/12/2024 02:14:24], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:14:24' WHERE id= '546';
[02/12/2024 02:14:24], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/20',  departure_date='2024/03/20',  nights='1',  create_date='2024-02-12 :14:14:24',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/12/2024 02:14:32], [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/12_02_2024/request_availability_shiv_qtech_14_14_24_1707747264.json', 'v1/12_02_2024/response_availability_shiv_qtech_14_14_24_1707747264.json', 'v1/12_02_2024/response_header_availability_shiv_qtech_14_14_24_1707747264.json', 'viator', '2024-02-12 02:14:32', '', '', '1391');
[02/12/2024 02:14:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:14:37' WHERE id= '546';
[02/12/2024 02:14:39], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:14:39' WHERE id= '546';
[02/12/2024 02:14:44], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:14:44' WHERE id= '546';
[02/12/2024 02:14: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 ('', 'sight_details', 'v1/12_02_2024/request_sight_details_shiv_qtech_14_14_44_1707747284.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_14_14_44_1707747284.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_14_14_44_1707747284.json', 'viator', '2024-02-12 02:14:45', '', '', '1391');
[02/12/2024 02:14: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 ('', 'sight_details', 'v1/12_02_2024/request_sight_details_shiv_qtech_14_14_45_1707747285.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_14_14_45_1707747285.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_14_14_45_1707747285.json', 'viator', '2024-02-12 02:14:45', '', '', '1391');
[02/12/2024 02:14:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:14:53' WHERE id= '546';
[02/12/2024 02:14: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 ('', 'check_availability', 'v1/12_02_2024/request_check_availability_shiv_qtech_14_14_53_1707747293.json', 'v1/12_02_2024/response_check_availability_shiv_qtech_14_14_53_1707747293.json', 'v1/12_02_2024/response_header_check_availability_shiv_qtech_14_14_53_1707747293.json', 'viator', '2024-02-12 02:14:53', '', '', '1391');
[02/12/2024 02:15:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:15:10' WHERE id= '546';
[02/12/2024 02:15:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707747310','43.239.53.130');
[02/12/2024 02:15:19], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:15:19' WHERE id= '546';
[02/12/2024 02:15:24], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:15:24' WHERE id= '546';
[02/12/2024 02:15:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:15:27' WHERE id= '546';
[02/12/2024 02:16:16], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:16:16' WHERE id= '546';
[02/12/2024 02:16:16], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707747376','43.239.53.130');
[02/12/2024 02:16:17], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:16:17' WHERE id= '546';
[02/12/2024 02:16:17], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2655',agent_id='7849',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='447314.4',display_currency_code='INR',native_room_rate='7433.46',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 447314.4  applicable if cancelled after 18 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-12 14:16:17',source_type='viator',expiration_date= '2024-03-18 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-20',sub_user_id='',check_out_date='2024-03-20',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/12/2024 02:16:17], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='391',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:7433.46;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:447314.40000000002;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-20',total_adults='2',total_children='',total_infants='',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='';
[02/12/2024 02:16:17], [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','2655','2024-02-12 14:16:17',0);
[02/12/2024 02:21:37], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:21:37' WHERE id= '546';
[02/12/2024 02:21:37], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2655',agent_id='7849',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='447314.4',display_currency_code='INR',native_room_rate='7433.46',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 447314.4  applicable if cancelled after 18 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-12 14:21:37',source_type='viator',expiration_date= '2024-03-18 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-20',sub_user_id='',check_out_date='2024-03-20',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/12/2024 02:21:37], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='392',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:7433.46;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:447314.40000000002;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-20',total_adults='2',total_children='',total_infants='',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='';
[02/12/2024 02:21:37], [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','2655','2024-02-12 14:21:37',0);
[02/12/2024 02:22:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:22:40' WHERE id= '546';
[02/12/2024 02:22:40], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707747760','43.239.53.130');
[02/12/2024 02:22:40], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:22:40' WHERE id= '546';
[02/12/2024 02:22:40], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2655',agent_id='7849',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='447314.4',display_currency_code='INR',native_room_rate='7433.46',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 447314.4  applicable if cancelled after 18 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-12 14:22:40',source_type='viator',expiration_date= '2024-03-18 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-20',sub_user_id='',check_out_date='2024-03-20',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/12/2024 02:22:40], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='393',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:7433.46;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:447314.40000000002;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-20',total_adults='2',total_children='',total_infants='',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='';
[02/12/2024 02:22:40], [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','2655','2024-02-12 14:22:40',0);
[02/12/2024 02:22:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:22:46' WHERE id= '546';
[02/12/2024 02:22:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707747766','43.239.53.130');
[02/12/2024 02:22:46], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:22:46' WHERE id= '546';
[02/12/2024 02:22:46], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2655',agent_id='7849',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='447314.4',display_currency_code='INR',native_room_rate='7433.46',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 447314.4  applicable if cancelled after 18 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-12 14:22:46',source_type='viator',expiration_date= '2024-03-18 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-20',sub_user_id='',check_out_date='2024-03-20',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/12/2024 02:22:46], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='394',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:7433.46;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:447314.40000000002;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-20',total_adults='2',total_children='',total_infants='',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='';
[02/12/2024 02:22:46], [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','2655','2024-02-12 14:22:46',0);
[02/12/2024 02:22:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:22:49' WHERE id= '546';
[02/12/2024 02:22:49], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707747769','43.239.53.130');
[02/12/2024 02:22:56], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:22:56' WHERE id= '546';
[02/12/2024 02:22:58], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:22:58' WHERE id= '546';
[02/12/2024 02:23:00], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:23:00' WHERE id= '546';
[02/12/2024 02:23:01], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:23:01' WHERE id= '546';
[02/12/2024 02:23:08], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:23:08' WHERE id= '546';
[02/12/2024 02:23:11], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:23:11' WHERE id= '546';
[02/12/2024 02:23:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:23:37' WHERE id= '546';
[02/12/2024 02:23:37], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707747817','43.239.53.130');
[02/12/2024 02:23:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:23:38' WHERE id= '546';
[02/12/2024 02:23:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2659',agent_id='7849',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='447314.4',display_currency_code='INR',native_room_rate='7433.46',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 447314.4  applicable if cancelled after 18 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-12 14:23:38',source_type='viator',expiration_date= '2024-03-18 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-20',sub_user_id='',check_out_date='2024-03-20',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/12/2024 02:23:38], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='395',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:7433.46;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:447314.40000000002;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-20',total_adults='2',total_children='',total_infants='',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='';
[02/12/2024 02:23:38], [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','2659','2024-02-12 14:23:38',0);
[02/12/2024 02:26:38], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:26:38' WHERE id= '546';
[02/12/2024 02:26:38], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707747998','43.239.53.130');
[02/12/2024 02:26:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:26:39' WHERE id= '546';
[02/12/2024 02:26:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2659',agent_id='7849',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='447314.4',display_currency_code='INR',native_room_rate='7433.46',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 18 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 447314.4  applicable if cancelled after 18 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-12 14:26:39',source_type='viator',expiration_date= '2024-03-18 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-20',sub_user_id='',check_out_date='2024-03-20',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/12/2024 02:26:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='396',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:7433.46;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:447314.40000000002;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-20',total_adults='2',total_children='',total_infants='',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='';
[02/12/2024 02:26:39], [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','2659','2024-02-12 14:26:39',0);
[02/12/2024 02:26:40], [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/12_02_2024/request_reservation_sight_shiv_qtech_14_26_39_1707747999.json', 'v1/12_02_2024/response_reservation_sight_shiv_qtech_14_26_39_1707747999.json', 'v1/12_02_2024/response_header_reservation_sight_shiv_qtech_14_26_39_1707747999.json', 'viator', '2024-02-12 02:26:40', '', '', '1391');
[02/12/2024 02:26:40], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '213';
[02/12/2024 02:26:40], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7849', applicable_service_tax='0', sub_agent_rate='0', agent_rate='447314.4', supplier_rate='7433.46', uid='', itenirary_id='', confirmation_number='', comment_contract='', current_status='failed', original_source='' where id='396';
[02/12/2024 02:26:40], [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='396';
[02/12/2024 02:26:40], [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
		('','','396','failed','2024-02-12 14:26:40','Sightseeing Booking failed by Agent..7849','7849','43.239.53.130','','','');
[02/12/2024 02:26:40], [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('396','Mr','1','shiv','chauhan','adult','0');
[02/12/2024 02:26:40], [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('396','Mr','1','jai','Singh','adult','0');
[02/12/2024 02:26:40], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='396' where agent_logs_id='1391' and source_type='viator';
[02/12/2024 02:28:13], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:28:13' WHERE id= '546';
[02/12/2024 02:28:13], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 02:28:13',login_attempt=0 where id = '7849';
[02/12/2024 02:28:13], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'shiv_qtech', user_type = 'A', branch_id = '24', login_datetime = '2024-02-12 14:28:13', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 02:28:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:28:13' WHERE id= '546';
[02/12/2024 02:28:16], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:28:16' WHERE id= '546';
[02/12/2024 02:28:23], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:28:23' WHERE id= '546';
[02/12/2024 02:28:32], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:28:32' WHERE id= '546';
[02/12/2024 02:28:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:28:37' WHERE id= '546';
[02/12/2024 02:28:37], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/27',  departure_date='2024/03/27',  nights='1',  create_date='2024-02-12 :14:28:37',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/12/2024 02:28:41], [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/12_02_2024/request_availability_shiv_qtech_14_28_37_1707748117.json', 'v1/12_02_2024/response_availability_shiv_qtech_14_28_37_1707748117.json', 'v1/12_02_2024/response_header_availability_shiv_qtech_14_28_37_1707748117.json', 'viator', '2024-02-12 02:28:41', '', '', '1392');
[02/12/2024 02:28:43], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:28:43' WHERE id= '546';
[02/12/2024 02:28:44], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:28:44' WHERE id= '546';
[02/12/2024 02:28:46], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:28:46' WHERE id= '546';
[02/12/2024 02:28:46], [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/12_02_2024/request_sight_details_shiv_qtech_14_28_46_1707748126.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_14_28_46_1707748126.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_14_28_46_1707748126.json', 'viator', '2024-02-12 02:28:46', '', '', '1392');
[02/12/2024 02:28:47], [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/12_02_2024/request_sight_details_shiv_qtech_14_28_46_1707748126.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_14_28_46_1707748126.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_14_28_46_1707748126.json', 'viator', '2024-02-12 02:28:47', '', '', '1392');
[02/12/2024 02:28:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:28:49' WHERE id= '546';
[02/12/2024 02:28:50], [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/12_02_2024/request_sight_details_shiv_qtech_14_28_49_1707748129.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_14_28_49_1707748129.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_14_28_49_1707748129.json', 'viator', '2024-02-12 02:28:50', '', '', '1392');
[02/12/2024 02:28:50], [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/12_02_2024/request_sight_details_shiv_qtech_14_28_50_1707748130.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_14_28_50_1707748130.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_14_28_50_1707748130.json', 'viator', '2024-02-12 02:28:50', '', '', '1392');
[02/12/2024 02:28:53], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:28:53' WHERE id= '546';
[02/12/2024 02:28:54], [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/12_02_2024/request_check_availability_shiv_qtech_14_28_53_1707748133.json', 'v1/12_02_2024/response_check_availability_shiv_qtech_14_28_53_1707748133.json', 'v1/12_02_2024/response_header_check_availability_shiv_qtech_14_28_53_1707748133.json', 'viator', '2024-02-12 02:28:54', '', '', '1392');
[02/12/2024 02:29:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:29:09' WHERE id= '546';
[02/12/2024 02:29:09], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707748149','43.239.53.130');
[02/12/2024 02:29:37], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:29:37' WHERE id= '546';
[02/12/2024 02:29:56], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:29:56' WHERE id= '546';
[02/12/2024 02:29:56], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707748196','43.239.53.130');
[02/12/2024 02:29:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:29:57' WHERE id= '546';
[02/12/2024 02:29:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2662',agent_id='7849',leader_title='Mr',leader_first_name='Shiv',leader_last_name='Chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='447314.4',display_currency_code='INR',native_room_rate='7433.46',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 25 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 447314.4  applicable if cancelled after 25 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-12 14:29:57',source_type='viator',expiration_date= '2024-03-25 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-27',sub_user_id='',check_out_date='2024-03-27',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/12/2024 02:29:57], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='397',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:7433.46;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:447314.40000000002;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-27',total_adults='2',total_children='',total_infants='',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='';
[02/12/2024 02:29:57], [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','2662','2024-02-12 14:29:57',0);
[02/12/2024 02:29:59], [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/12_02_2024/request_reservation_sight_shiv_qtech_14_29_57_1707748197.json', 'v1/12_02_2024/response_reservation_sight_shiv_qtech_14_29_57_1707748197.json', 'v1/12_02_2024/response_header_reservation_sight_shiv_qtech_14_29_57_1707748197.json', 'viator', '2024-02-12 02:29:59', '', '', '1392');
[02/12/2024 02:29:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '214';
[02/12/2024 02:29:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7849', applicable_service_tax='0', sub_agent_rate='0', agent_rate='447314.4', supplier_rate='7433.46', uid='', itenirary_id='2662355', confirmation_number='BR-595561147', comment_contract='', current_status='confirmed', original_source='' where id='397';
[02/12/2024 02:29:59], [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='397';
[02/12/2024 02:29:59], [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
		('','','397','confirmed','2024-02-12 14:29:59','Sightseeing Booking confirmed by Agent..7849','7849','43.239.53.130','','','');
[02/12/2024 02:29:59], [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('397','Mr','1','Shiv','Chauhan','adult','0');
[02/12/2024 02:29:59], [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('397','Mr','1','Jai','SIngh','adult','0');
[02/12/2024 02:29:59], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='397' where agent_logs_id='1392' and source_type='viator';
[02/12/2024 02:44:14], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:44:14' WHERE id= '546';
[02/12/2024 02:44:14], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 02:44:14',login_attempt=0 where id = '7849';
[02/12/2024 02:44:14], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'shiv_qtech', user_type = 'A', branch_id = '24', login_datetime = '2024-02-12 14:44:14', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 02:44:14], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:44:14' WHERE id= '546';
[02/12/2024 02:44:18], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:44:18' WHERE id= '546';
[02/12/2024 02:44:25], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:44:25' WHERE id= '546';
[02/12/2024 02:44:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:44:31' WHERE id= '546';
[02/12/2024 02:44:31], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/27',  departure_date='2024/03/27',  nights='1',  create_date='2024-02-12 :14:44:31',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/12/2024 02:44: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/12_02_2024/request_availability_shiv_qtech_14_44_31_1707749071.json', 'v1/12_02_2024/response_availability_shiv_qtech_14_44_31_1707749071.json', 'v1/12_02_2024/response_header_availability_shiv_qtech_14_44_31_1707749071.json', 'viator', '2024-02-12 02:44:39', '', '', '1393');
[02/12/2024 02:44:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:44:41' WHERE id= '546';
[02/12/2024 02:44:41], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:44:41' WHERE id= '546';
[02/12/2024 02:44:45], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:44:45' WHERE id= '546';
[02/12/2024 02:44: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 ('', 'sight_details', 'v1/12_02_2024/request_sight_details_shiv_qtech_14_44_45_1707749085.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_14_44_45_1707749085.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_14_44_45_1707749085.json', 'viator', '2024-02-12 02:44:45', '', '', '1393');
[02/12/2024 02:44:46], [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/12_02_2024/request_sight_details_shiv_qtech_14_44_45_1707749085.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_14_44_45_1707749085.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_14_44_45_1707749085.json', 'viator', '2024-02-12 02:44:46', '', '', '1393');
[02/12/2024 02:44:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:44:49' WHERE id= '546';
[02/12/2024 02:44:50], [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/12_02_2024/request_check_availability_shiv_qtech_14_44_49_1707749089.json', 'v1/12_02_2024/response_check_availability_shiv_qtech_14_44_49_1707749089.json', 'v1/12_02_2024/response_header_check_availability_shiv_qtech_14_44_49_1707749089.json', 'viator', '2024-02-12 02:44:50', '', '', '1393');
[02/12/2024 02:44:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:44:59' WHERE id= '546';
[02/12/2024 02:44:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707749099','43.239.53.130');
[02/12/2024 02:45:04], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:45:04' WHERE id= '546';
[02/12/2024 02:45:09], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:45:09' WHERE id= '546';
[02/12/2024 02:45:13], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:45:13' WHERE id= '546';
[02/12/2024 02:45:39], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:45:39' WHERE id= '546';
[02/12/2024 02:45:55], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:45:55' WHERE id= '546';
[02/12/2024 02:45:55], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707749155','43.239.53.130');
[02/12/2024 02:45:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:45:56' WHERE id= '546';
[02/12/2024 02:45:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2664',agent_id='7849',leader_title='Mr',leader_first_name='shiv',leader_last_name='chauhan',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='447314.4',display_currency_code='INR',native_room_rate='7433.46',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 25 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 447314.4  applicable if cancelled after 25 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-12 14:45:56',source_type='viator',expiration_date= '2024-03-25 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-27',sub_user_id='',check_out_date='2024-03-27',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/12/2024 02:45:56], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='398',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:7433.46;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:447314.40000000002;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 7433.46 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-27',total_adults='2',total_children='',total_infants='',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='';
[02/12/2024 02:45: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','2664','2024-02-12 14:45:56',0);
[02/12/2024 02:46:01], [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/12_02_2024/request_reservation_sight_shiv_qtech_14_45_56_1707749156.json', 'v1/12_02_2024/response_reservation_sight_shiv_qtech_14_45_56_1707749156.json', 'v1/12_02_2024/response_header_reservation_sight_shiv_qtech_14_45_56_1707749156.json', 'viator', '2024-02-12 02:46:01', '', '', '1393');
[02/12/2024 02:46:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '215';
[02/12/2024 02:46:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7849', applicable_service_tax='0', sub_agent_rate='0', agent_rate='447314.4', supplier_rate='7433.46', uid='', itenirary_id='2664809', confirmation_number='BR-595561315', comment_contract='', current_status='confirmed', original_source='' where id='398';
[02/12/2024 02:46:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',viator_item_ref='BR-595561315',viator_ref='BR-595561315',viator_item_id='',viator_voucherKey='B',tour_supplier='',textaddition_activities='N;' where booking_id='398';
[02/12/2024 02:46:01], [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
		('','','398','confirmed','2024-02-12 14:46:01','Sightseeing Booking confirmed by Agent..7849','7849','43.239.53.130','','','');
[02/12/2024 02:46:01], [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('398','Mr','1','shiv','chauhan','adult','0');
[02/12/2024 02:46:01], [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('398','Mr','1','Jai','Singh','adult','0');
[02/12/2024 02:46:01], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='398' where agent_logs_id='1393' and source_type='viator';
[02/12/2024 02:48:43], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:48:43' WHERE id= '546';
[02/12/2024 02:48:43], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-12 02:48:43',login_attempt=0 where id = '7849';
[02/12/2024 02:48:43], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'shiv_qtech', user_type = 'A', branch_id = '24', login_datetime = '2024-02-12 14:48:43', ip = '43.239.53.130', action = 'Login' ;
[02/12/2024 02:48:44], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:48:44' WHERE id= '546';
[02/12/2024 02:48:47], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:48:47' WHERE id= '546';
[02/12/2024 02:48:51], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:48:51' WHERE id= '546';
[02/12/2024 02:48:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:48:57' WHERE id= '546';
[02/12/2024 02:48:57], [file name :-/home/otrams/public_html/beta/sight_search_list.php],INSERT INTO agent_logs SET  agent_id = '7849' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '24' , ip = '43.239.53.130' , city = 'dubai' , arrival_date='2024/03/27',  departure_date='2024/03/27',  nights='1',  create_date='2024-02-12 :14:48:57',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/12/2024 02:49:04], [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/12_02_2024/request_availability_shiv_qtech_14_48_57_1707749337.json', 'v1/12_02_2024/response_availability_shiv_qtech_14_48_57_1707749337.json', 'v1/12_02_2024/response_header_availability_shiv_qtech_14_48_57_1707749337.json', 'viator', '2024-02-12 02:49:04', '', '', '1394');
[02/12/2024 02:49:07], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:49:07' WHERE id= '546';
[02/12/2024 02:49:07], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:49:07' WHERE id= '546';
[02/12/2024 02:49:09], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:49:09' WHERE id= '546';
[02/12/2024 02:49: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 ('', 'sight_details', 'v1/12_02_2024/request_sight_details_shiv_qtech_14_49_09_1707749349.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_14_49_09_1707749349.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_14_49_09_1707749349.json', 'viator', '2024-02-12 02:49:09', '', '', '1394');
[02/12/2024 02:49:10], [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/12_02_2024/request_sight_details_shiv_qtech_14_49_09_1707749349.json', 'v1/12_02_2024/response_sight_details_shiv_qtech_14_49_09_1707749349.json', 'v1/12_02_2024/response_header_sight_details_shiv_qtech_14_49_09_1707749349.json', 'viator', '2024-02-12 02:49:10', '', '', '1394');
[02/12/2024 02:49:14], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:49:14' WHERE id= '546';
[02/12/2024 02:49:15], [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/12_02_2024/request_check_availability_shiv_qtech_14_49_14_1707749354.json', 'v1/12_02_2024/response_check_availability_shiv_qtech_14_49_14_1707749354.json', 'v1/12_02_2024/response_header_check_availability_shiv_qtech_14_49_14_1707749354.json', 'viator', '2024-02-12 02:49:15', '', '', '1394');
[02/12/2024 02:49:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:49:23' WHERE id= '546';
[02/12/2024 02:49:23], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707749363','43.239.53.130');
[02/12/2024 02:49:31], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:49:31' WHERE id= '546';
[02/12/2024 02:50:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:50:02' WHERE id= '546';
[02/12/2024 02:50:02], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707749402','43.239.53.130');
[02/12/2024 02:50:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:50:03' WHERE id= '546';
[02/12/2024 02:50:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2666',agent_id='7849',leader_title='Mr',leader_first_name='SHII',leader_last_name='CHAUHAN',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='223657.2',display_currency_code='INR',native_room_rate='3716.73',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 25 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 223657.2  applicable if cancelled after 25 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-12 14:50:03',source_type='viator',expiration_date= '2024-03-25 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-27',sub_user_id='',check_out_date='2024-03-27',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/12/2024 02:50:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='399',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:3716.73;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:223657.20000000001;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 3716.73 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 3716.73 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-27',total_adults='1',total_children='',total_infants='',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='';
[02/12/2024 02:50:03], [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','2666','2024-02-12 14:50:03',0);
[02/12/2024 02:50:06], [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/12_02_2024/request_reservation_sight_shiv_qtech_14_50_03_1707749403.json', 'v1/12_02_2024/response_reservation_sight_shiv_qtech_14_50_03_1707749403.json', 'v1/12_02_2024/response_header_reservation_sight_shiv_qtech_14_50_03_1707749403.json', 'viator', '2024-02-12 02:50:06', '', '', '1394');
[02/12/2024 02:50:06], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '216';
[02/12/2024 02:50:06], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7849', applicable_service_tax='0', sub_agent_rate='0', agent_rate='223657.2', supplier_rate='3716.73', uid='', itenirary_id='2666159', confirmation_number='BR-595561341', comment_contract='', current_status='confirmed', original_source='' where id='399';
[02/12/2024 02:51:11], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:51:11' WHERE id= '546';
[02/12/2024 02:51:11], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2666',agent_id='7849',leader_title='Mr',leader_first_name='SHII',leader_last_name='CHAUHAN',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='223657.2',display_currency_code='INR',native_room_rate='3716.73',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 25 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 223657.2  applicable if cancelled after 25 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-12 14:51:11',source_type='viator',expiration_date= '2024-03-25 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-27',sub_user_id='',check_out_date='2024-03-27',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/12/2024 02:51:11], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='400',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:3716.73;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:223657.20000000001;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 3716.73 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 3716.73 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-27',total_adults='1',total_children='',total_infants='',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='';
[02/12/2024 02:51:11], [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','2666','2024-02-12 14:51:11',0);
[02/12/2024 02:51:14], [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/12_02_2024/request_reservation_sight_shiv_qtech_14_51_11_1707749471.json', 'v1/12_02_2024/response_reservation_sight_shiv_qtech_14_51_11_1707749471.json', 'v1/12_02_2024/response_header_reservation_sight_shiv_qtech_14_51_11_1707749471.json', 'viator', '2024-02-12 02:51:14', '', '', '1394');
[02/12/2024 02:51:14], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '217';
[02/12/2024 02:51:14], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7849', applicable_service_tax='0', sub_agent_rate='0', agent_rate='223657.2', supplier_rate='3716.73', uid='', itenirary_id='2666107', confirmation_number='BR-595561343', comment_contract='', current_status='confirmed', original_source='' where id='400';
[02/12/2024 02:51:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:51:39' WHERE id= '546';
[02/12/2024 02:51:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2666',agent_id='7849',leader_title='Mr',leader_first_name='SHII',leader_last_name='CHAUHAN',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='223657.2',display_currency_code='INR',native_room_rate='3716.73',consultant_id='b2btravel',native_currency_code='USD',cancellation_policy='Cancellation Charges will be applicable if cancelled after 25 Mar 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 223657.2  applicable if cancelled after 25 Mar 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-12 14:51:39',source_type='viator',expiration_date= '2024-03-25 00:00:00',applied_multiplier='60.1758',applied_markup='0',agent_markup='0',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-03-27',sub_user_id='',check_out_date='2024-03-27',supplier_profile_id='',agent_currency_multiplier='1.00000', booking_branch_id = '24',site_url = 'https://beta.astrabookings.com/',ip_addr='43.239.53.130',leader_phone=' 9823860012',email_id='shiv.chauhan@qtechsoftware.com',service_type='sightseeing';
[02/12/2024 02:51:39], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='401',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:3716.73;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:223657.20000000001;s:25:\"displayNightlyRateDisplay\";s:135:\"Rate - 3716.73 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  - ,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:136:\"Rate - 3716.73 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - %, Markup Amount - , Markup Amount in  -  ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='USD',sight_id='333273P2',sight_name='DUBAI LONG SELF-DRIVE QUADBIKE WITH CAMEL AND FALCON- V2',tour_time='',tour_details='',tour_inclusive='0<br/>',tour_exclusive='D<br/>',meeting_point='',tour_dep_point=' ',tour_language='en/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='4 hours 0 minutes<br> Start Time: 07:00',arrival_date='2024-03-27',total_adults='1',total_children='',total_infants='',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='';
[02/12/2024 02:51:39], [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','2666','2024-02-12 14:51:39',0);
[02/12/2024 02:51:42], [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/12_02_2024/request_reservation_sight_shiv_qtech_14_51_39_1707749499.json', 'v1/12_02_2024/response_reservation_sight_shiv_qtech_14_51_39_1707749499.json', 'v1/12_02_2024/response_header_reservation_sight_shiv_qtech_14_51_39_1707749499.json', 'viator', '2024-02-12 02:51:42', '', '', '1394');
[02/12/2024 02:51:42], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '218';
[02/12/2024 02:51:42], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update bookings set  parent_agent_id='7849', applicable_service_tax='0', sub_agent_rate='0', agent_rate='223657.2', supplier_rate='3716.73', uid='', itenirary_id='2666766', confirmation_number='BR-595561365', comment_contract='', current_status='confirmed', original_source='' where id='401';
[02/12/2024 02:51:42], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',viator_item_ref='BR-595561365',viator_ref='BR-595561365',viator_item_id='',viator_voucherKey='https://shop.live.rc.viator.com/ticket?code=1020233853:049958afac3ca7f22a7e57c87957293f3a0d4fc7dd455bc5e565ca7d1fc5c2f9:595561365',tour_supplier='',textaddition_activities='N;' where booking_id='401';
[02/12/2024 02:51:42], [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
		('','','401','confirmed','2024-02-12 14:51:42','Sightseeing Booking confirmed by Agent..7849','7849','43.239.53.130','','','');
[02/12/2024 02:51:42], [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('401','Mr','1','SHII','CHAUHAN','adult','0');
[02/12/2024 02:51:42], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='401' where agent_logs_id='1394' and source_type='viator';
[02/12/2024 02:52:39], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:52:39' WHERE id= '546';
[02/12/2024 02:52:47], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:52:47' WHERE id= '546';
[02/12/2024 02:52:53], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:52:53' WHERE id= '546';
[02/12/2024 02:53:01], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:53:01' WHERE id= '546';
[02/12/2024 02:53:11], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:53:11' WHERE id= '546';
[02/12/2024 02:53:13], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:53:13' WHERE id= '546';
[02/12/2024 02:58:38], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:58:38' WHERE id= '546';
[02/12/2024 02:58:46], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:58:46' WHERE id= '546';
[02/12/2024 02:58:54], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:58:54' WHERE id= '546';
[02/12/2024 02:59:00], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:59:00' WHERE id= '546';
[02/12/2024 02:59:02], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:59:02' WHERE id= '546';
[02/12/2024 02:59:06], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:59:06' WHERE id= '546';
[02/12/2024 02:59:11], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:59:11' WHERE id= '546';
[02/12/2024 02:59:40], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:59:40' WHERE id= '546';
[02/12/2024 02:59:44], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:59:44' WHERE id= '546';
[02/12/2024 02:59:50], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:59:50' WHERE id= '546';
[02/12/2024 02:59:50], [file name :-/home/otrams/public_html/beta/booking_list_sight.php],UPDATE user_sessions_ip SET update_date = '2024-02-12 02:59:50' WHERE id= '546';
