[02/13/2024 11:48:10], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-13 11:48:10',login_attempt=0 where id = '7849';
[02/13/2024 11:48:10], [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-13 11:48:10', ip = '43.239.53.130', action = 'Login' ;
[02/13/2024 11:48:11], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:48:11' WHERE id= '541';
[02/13/2024 11:48:14], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:48:14' WHERE id= '541';
[02/13/2024 11:48:18], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:48:18' WHERE id= '541';
[02/13/2024 11:48:22], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:48:22' WHERE id= '541';
[02/13/2024 11:48:22], [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/02/29',  departure_date='2024/02/29',  nights='1',  create_date='2024-02-13 :11:48:22',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/13/2024 11:48: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/13_02_2024/request_availability_shiv_qtech_11_48_22_1707824902.json', 'v1/13_02_2024/response_availability_shiv_qtech_11_48_22_1707824902.json', 'v1/13_02_2024/response_header_availability_shiv_qtech_11_48_22_1707824902.json', 'viator', '2024-02-13 11:48:37', '', '', '1403');
[02/13/2024 11:48:39], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:48:39' WHERE id= '541';
[02/13/2024 11:48:40], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:48:40' WHERE id= '541';
[02/13/2024 11:48:42], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:48:42' WHERE id= '541';
[02/13/2024 11:48:43], [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/13_02_2024/request_sight_details_shiv_qtech_11_48_42_1707824922.json', 'v1/13_02_2024/response_sight_details_shiv_qtech_11_48_42_1707824922.json', 'v1/13_02_2024/response_header_sight_details_shiv_qtech_11_48_42_1707824922.json', 'viator', '2024-02-13 11:48:43', '', '', '1403');
[02/13/2024 11:48:43], [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/13_02_2024/request_sight_details_shiv_qtech_11_48_43_1707824923.json', 'v1/13_02_2024/response_sight_details_shiv_qtech_11_48_43_1707824923.json', 'v1/13_02_2024/response_header_sight_details_shiv_qtech_11_48_43_1707824923.json', 'viator', '2024-02-13 11:48:43', '', '', '1403');
[02/13/2024 11:48:49], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:48:49' WHERE id= '541';
[02/13/2024 11:48: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 ('', 'check_availability', 'v1/13_02_2024/request_check_availability_shiv_qtech_11_48_49_1707824929.json', 'v1/13_02_2024/response_check_availability_shiv_qtech_11_48_49_1707824929.json', 'v1/13_02_2024/response_header_check_availability_shiv_qtech_11_48_49_1707824929.json', 'viator', '2024-02-13 11:48:51', '', '', '1403');
[02/13/2024 11:49:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:49:10' WHERE id= '541';
[02/13/2024 11:49:10], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707824950','43.239.53.130');
[02/13/2024 11:49:24], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:49:24' WHERE id= '541';
[02/13/2024 11:49:25], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:49:25' WHERE id= '541';
[02/13/2024 11:49:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:49:27' WHERE id= '541';
[02/13/2024 11:49:30], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:49:30' WHERE id= '541';
[02/13/2024 11:49:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:49:59' WHERE id= '541';
[02/13/2024 11:49:59], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707824999','43.239.53.130');
[02/13/2024 11:50:00], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:50:00' WHERE id= '541';
[02/13/2024 11:50:00], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2685',agent_id='7849',leader_title='Mr',leader_first_name='qtecttest',leader_last_name='donocharge',city_id='dubai',country_id='138',nationality='Emirati',display_room_rate='233721.78',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 27 Feb 2024 03:00 hrs.<BR>Late amendment charge may apply.<Br><Br><B><U>Detailed Cancellation Policy:</U></B><Br>Charges - 233721.78  applicable if cancelled after 27 Feb 2024 at 03:00 hrs',current_status='inprocess-booking',booking_status='1',sales_manager_id='0',create_date='2024-02-13 11:50:00',source_type='viator',expiration_date= '2024-02-27 00:00:00',applied_multiplier='60.1758',applied_markup='4.5000026826769',agent_markup='4.5000026826769',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.00000',admin_booked='0',service_date='2024-02-29',sub_user_id='',check_out_date='2024-02-29',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=' 977678968',email_id='dipsi.chawan@qtechsoftware.com',service_type='sightseeing';
[02/13/2024 11:50:00], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='407',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:233721.78;s:25:\"displayNightlyRateDisplay\";s:147:\"Rate - 3716.73 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - 4.50%, Markup Amount - 0, Markup Amount in SAR - 0.00,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:148:\"Rate - 3716.73 USD, Currency Multiplier (USD-INR) - 60.1758, Markup  in % - 4.50%, Markup Amount - 0, Markup Amount in SAR - 0.00 ,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-02-29',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/13/2024 11:50:00], [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','2685','2024-02-13 11:50:00',0);
[02/13/2024 11:50:03], [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/13_02_2024/request_reservation_sight_shiv_qtech_11_50_00_1707825000.json', 'v1/13_02_2024/response_reservation_sight_shiv_qtech_11_50_00_1707825000.json', 'v1/13_02_2024/response_header_reservation_sight_shiv_qtech_11_50_00_1707825000.json', 'viator', '2024-02-13 11:50:03', '', '', '1403');
[02/13/2024 11:50:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '224';
[02/13/2024 11:50:03], [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='233721.78', supplier_rate='3716.73', uid='', itenirary_id='2685270', confirmation_number='BR-595571319', comment_contract='', current_status='confirmed', original_source='' where id='407';
[02/13/2024 11:50:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',viator_item_ref='BR-595571319',viator_ref='BR-595571319',viator_item_id='',viator_voucherKey='https://shop.live.rc.viator.com/ticket?code=1020246215:9de99efcb9bffd1b80e6bd96398c3d605524cc1dd028155b1fa1a137979408cd:595571319',tour_supplier='',textaddition_activities='N;' where booking_id='407';
[02/13/2024 11:50: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
		('','','407','confirmed','2024-02-13 11:50:03','Sightseeing Booking confirmed by Agent..7849','7849','43.239.53.130','','','');
[02/13/2024 11:50:03], [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('407','Mr','1','qtecttest','donocharge','adult','0');
[02/13/2024 11:50:03], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='407' where agent_logs_id='1403' and source_type='viator';
[02/13/2024 11:53:41], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:53:41' WHERE id= '541';
[02/13/2024 11:53:47], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:53:47' WHERE id= '541';
[02/13/2024 11:53:47], [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/02/29',  departure_date='2024/02/29',  nights='1',  create_date='2024-02-13 :11:53:47',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/13/2024 11:53:48], [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/13_02_2024/request_availability_shiv_qtech_11_53_47_1707825227.json', 'v1/13_02_2024/response_availability_shiv_qtech_11_53_47_1707825227.json', 'v1/13_02_2024/response_header_availability_shiv_qtech_11_53_47_1707825227.json', 'viator', '2024-02-13 11:53:48', '', '', '1404');
[02/13/2024 11:53:50], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:53:50' WHERE id= '541';
[02/13/2024 11:53:50], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:53:50' WHERE id= '541';
[02/13/2024 11:54:31], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:54:31' WHERE id= '541';
[02/13/2024 11:54: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/13_02_2024/request_sight_details_shiv_qtech_11_54_31_1707825271.json', 'v1/13_02_2024/response_sight_details_shiv_qtech_11_54_31_1707825271.json', 'v1/13_02_2024/response_header_sight_details_shiv_qtech_11_54_31_1707825271.json', 'viator', '2024-02-13 11:54:36', '', '', '1404');
[02/13/2024 11:54: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/13_02_2024/request_sight_details_shiv_qtech_11_54_36_1707825276.json', 'v1/13_02_2024/response_sight_details_shiv_qtech_11_54_36_1707825276.json', 'v1/13_02_2024/response_header_sight_details_shiv_qtech_11_54_36_1707825276.json', 'viator', '2024-02-13 11:54:36', '', '', '1404');
[02/13/2024 11:54:39], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:54:39' WHERE id= '541';
[02/13/2024 11:54:40], [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/13_02_2024/request_check_availability_shiv_qtech_11_54_39_1707825279.json', 'v1/13_02_2024/response_check_availability_shiv_qtech_11_54_39_1707825279.json', 'v1/13_02_2024/response_header_check_availability_shiv_qtech_11_54_39_1707825279.json', 'viator', '2024-02-13 11:54:40', '', '', '1404');
[02/13/2024 11:54:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:54:45' WHERE id= '541';
[02/13/2024 11:54:45], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707825285','43.239.53.130');
[02/13/2024 11:54:54], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:54:54' WHERE id= '541';
[02/13/2024 11:54:56], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:54:56' WHERE id= '541';
[02/13/2024 11:55:05], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:55:05' WHERE id= '541';
[02/13/2024 11:55:06], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:55:06' WHERE id= '541';
[02/13/2024 11:55:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 11:55:27' WHERE id= '541';
[02/13/2024 11:55:27], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707825327','43.239.53.130');
