[02/13/2024 10:26:18], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-02-13 10:26:18',login_attempt=0 where id = '7849';
[02/13/2024 10:26:18], [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 10:26:18', ip = '43.239.53.130', action = 'Login' ;
[02/13/2024 10:26:19], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:26:19' WHERE id= '541';
[02/13/2024 10:26:22], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:26:22' WHERE id= '541';
[02/13/2024 10:26:25], [file name :-/home/otrams/public_html/beta/sight_search.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:26:25' WHERE id= '541';
[02/13/2024 10:26:29], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:26:29' WHERE id= '541';
[02/13/2024 10:26:36], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:26:36' WHERE id= '541';
[02/13/2024 10:26: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/02/29',  departure_date='2024/02/29',  nights='1',  create_date='2024-02-13 :10:26:37',  nationality='',  additional_markup='',  selected_currency='INR',  service_type='sightseeing',  total_adult='',  total_children='',  site_id = '' ;
[02/13/2024 10:26: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/13_02_2024/request_availability_shiv_qtech_10_26_37_1707819997.json', 'v1/13_02_2024/response_availability_shiv_qtech_10_26_37_1707819997.json', 'v1/13_02_2024/response_header_availability_shiv_qtech_10_26_37_1707819997.json', 'viator', '2024-02-13 10:26:39', '', '', '1402');
[02/13/2024 10:26:41], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:26:41' WHERE id= '541';
[02/13/2024 10:26:41], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:26:41' WHERE id= '541';
[02/13/2024 10:26:51], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:26:51' WHERE id= '541';
[02/13/2024 10:26:51], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/13_02_2024/request_sight_details_shiv_qtech_10_26_51_1707820011.json', 'v1/13_02_2024/response_sight_details_shiv_qtech_10_26_51_1707820011.json', 'v1/13_02_2024/response_header_sight_details_shiv_qtech_10_26_51_1707820011.json', 'viator', '2024-02-13 10:26:51', '', '', '1402');
[02/13/2024 10:26:51], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/13_02_2024/request_sight_details_shiv_qtech_10_26_51_1707820011.json', 'v1/13_02_2024/response_sight_details_shiv_qtech_10_26_51_1707820011.json', 'v1/13_02_2024/response_header_sight_details_shiv_qtech_10_26_51_1707820011.json', 'viator', '2024-02-13 10:26:51', '', '', '1402');
[02/13/2024 10:26:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:26:55' WHERE id= '541';
[02/13/2024 10:26:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/13_02_2024/request_sight_details_shiv_qtech_10_26_55_1707820015.json', 'v1/13_02_2024/response_sight_details_shiv_qtech_10_26_55_1707820015.json', 'v1/13_02_2024/response_header_sight_details_shiv_qtech_10_26_55_1707820015.json', 'viator', '2024-02-13 10:26:55', '', '', '1402');
[02/13/2024 10:26:55], [file name :-/home/otrams/public_html/beta/user_sight_details.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'sight_details', 'v1/13_02_2024/request_sight_details_shiv_qtech_10_26_55_1707820015.json', 'v1/13_02_2024/response_sight_details_shiv_qtech_10_26_55_1707820015.json', 'v1/13_02_2024/response_header_sight_details_shiv_qtech_10_26_55_1707820015.json', 'viator', '2024-02-13 10:26:55', '', '', '1402');
[02/13/2024 10:27:00], [file name :-/home/otrams/public_html/beta/user_sight_details.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:27:00' WHERE id= '541';
[02/13/2024 10:27:00], [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_10_27_00_1707820020.json', 'v1/13_02_2024/response_check_availability_shiv_qtech_10_27_00_1707820020.json', 'v1/13_02_2024/response_header_check_availability_shiv_qtech_10_27_00_1707820020.json', 'viator', '2024-02-13 10:27:00', '', '', '1402');
[02/13/2024 10:27:05], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:27:05' WHERE id= '541';
[02/13/2024 10:27:05], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707820025','43.239.53.130');
[02/13/2024 10:27:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:27:43' WHERE id= '541';
[02/13/2024 10:27:43], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707820063','43.239.53.130');
[02/13/2024 10:40:58], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:40:58' WHERE id= '541';
[02/13/2024 10:41:03], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:41:03' WHERE id= '541';
[02/13/2024 10:41:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:41:15' WHERE id= '541';
[02/13/2024 10:41:15], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707820875','43.239.53.130');
[02/13/2024 10:41:18], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:41:18' WHERE id= '541';
[02/13/2024 10:41:18], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2682',agent_id='7849',leader_title='Mr',leader_first_name='astratest',leader_last_name='donotcharge',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 10:41:18',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=' 234245',email_id='test@gmail.com',service_type='sightseeing';
[02/13/2024 10:41:18], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='406',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 10:41:18], [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','2682','2024-02-13 10:41:18',0);
[02/13/2024 10:41:21], [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_10_41_18_1707820878.json', 'v1/13_02_2024/response_reservation_sight_shiv_qtech_10_41_18_1707820878.json', 'v1/13_02_2024/response_header_reservation_sight_shiv_qtech_10_41_18_1707820878.json', 'viator', '2024-02-13 10:41:21', '', '', '1402');
[02/13/2024 10:41:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '223';
[02/13/2024 10:41:21], [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='2682112', confirmation_number='BR-595570801', comment_contract='', current_status='confirmed', original_source='' where id='406';
[02/13/2024 10:41:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',viator_item_ref='BR-595570801',viator_ref='BR-595570801',viator_item_id='',viator_voucherKey='https://shop.live.rc.viator.com/ticket?code=1020245531:56296ea7bd71e54a139bcd54aeb9489126ca134c964bcfb2635eb0f59b3a4ffc:595570801',tour_supplier='',textaddition_activities='N;' where booking_id='406';
[02/13/2024 10:41:21], [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
		('','','406','confirmed','2024-02-13 10:41:21','Sightseeing Booking confirmed by Agent..7849','7849','43.239.53.130','','','');
[02/13/2024 10:41:21], [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('406','Mr','1','astratest','donotcharge','adult','0');
[02/13/2024 10:41:21], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='406' where agent_logs_id='1402' and source_type='viator';
[02/13/2024 10:41:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-13 10:41:39' WHERE id= '541';
[02/13/2024 10:41:39], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1707820899','43.239.53.130');
