[02/16/2024 01:00:24], [file name :-/home/otrams/public_html/beta/sight_search_list.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:00:24' WHERE id= '563';
[02/16/2024 01:00:28], [file name :-/home/otrams/public_html/beta/ajax/ajax_categories.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:00:28' WHERE id= '563';
[02/16/2024 01:00:45], [file name :-/home/otrams/public_html/beta/quotation.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:00:45' WHERE id= '563';
[02/16/2024 01:03:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:03:35' WHERE id= '541';
[02/16/2024 01:03:35], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708088615','43.239.53.130');
[02/16/2024 01:06:33], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:06:33' WHERE id= '541';
[02/16/2024 01:06:34], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:06:34' WHERE id= '541';
[02/16/2024 01:07:14], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:07:14' WHERE id= '541';
[02/16/2024 01:08:25], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:25' WHERE id= '541';
[02/16/2024 01:08:26], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:26' WHERE id= '541';
[02/16/2024 01:08:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:27' WHERE id= '541';
[02/16/2024 01:08:31], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:31' WHERE id= '541';
[02/16/2024 01:08:33], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:33' WHERE id= '541';
[02/16/2024 01:08:34], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:34' WHERE id= '541';
[02/16/2024 01:08:38], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:38' WHERE id= '541';
[02/16/2024 01:08:40], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:40' WHERE id= '541';
[02/16/2024 01:08:42], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:42' WHERE id= '541';
[02/16/2024 01:08:46], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:46' WHERE id= '541';
[02/16/2024 01:08:48], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:48' WHERE id= '541';
[02/16/2024 01:08:50], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:50' WHERE id= '541';
[02/16/2024 01:08:53], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:53' WHERE id= '541';
[02/16/2024 01:08:54], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:54' WHERE id= '541';
[02/16/2024 01:08:56], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:56' WHERE id= '541';
[02/16/2024 01:08:57], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:57' WHERE id= '541';
[02/16/2024 01:08:58], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:08:58' WHERE id= '541';
[02/16/2024 01:09:03], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:09:03' WHERE id= '541';
[02/16/2024 01:12:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:12:46' WHERE id= '541';
[02/16/2024 01:12:46], [file name :-/home/otrams/public_html/beta/book_sightseeing.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1708089166','43.239.53.130');
[02/16/2024 01:12:47], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:12:47' WHERE id= '541';
[02/16/2024 01:12:47], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO bookings set reservation_id='2862',agent_id='7849',leader_title='Mr',leader_first_name='qtechtestone',leader_last_name='donotcharge',city_id='lucca',country_id='68',nationality='Italian',display_room_rate='1525899.35',display_currency_code='INR',native_room_rate='17300.08',consultant_id='b2btravel',native_currency_code='EUR',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 - 1525899.35  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-16 13:12:47',source_type='viator',expiration_date= '2024-02-27 00:00:00',applied_multiplier='84.4037002',applied_markup='4.4999996815485',agent_markup='4.4999996815485',basecurrency_multiplier='0.01662',basecurrency_multiplier_native='1.36177',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=' 3435345',email_id='test@gmail.com',service_type='sightseeing';
[02/16/2024 01:12:47], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],INSERT INTO sight_bookings set booking_id='447',native_nightly_rates='a:2:{s:4:\"size\";i:1;s:17:\"nativeNightlyRate\";d:17300.080000000002;}',rate_description='',display_nightly_rates='a:4:{s:4:\"size\";i:1;s:18:\"displayNightlyRate\";d:1525899.3500000001;s:25:\"displayNightlyRateDisplay\";s:151:\"Rate - 17300.08 EUR, Currency Multiplier (EUR-INR) - 84.4037002, Markup  in % - 4.50%, Markup Amount - 0, Markup Amount in SAR - 0.00,Other Markup - 0%\";s:23:\"displayNightlyRateStore\";s:152:\"Rate - 17300.08 EUR, Currency Multiplier (EUR-INR) - 84.4037002, Markup  in % - 4.50%, Markup Amount - 0, Markup Amount in SAR - 0.00 ,Other Markup - 0%\";}',display_currency_code='INR',native_currency_code='EUR',sight_id='184864P1',sight_name='PRIVATE WINE TASTING IN LUCCA - 5 WINES AND A TASTE OF LOCAL PRODUCTS- V2',tour_time='',tour_details='',tour_inclusive='C<br/>',tour_exclusive='<br/>',meeting_point='',tour_dep_point=' ',tour_language='it/SERVICE_GUIDE',tour_supplier_phone='',additional_tour_dep_point='',tour_duration='1 hours 30 minutes<br> Start Time: ',arrival_date='2024-02-29',total_adults='4',total_children='',total_infants='',gta_city_code='22436',supplier_id='',pick_up_point='',drop_off_point='',from_slot='',to_slot='',total_adult_rate='',total_child_rate='',adult_rate='',child_rate='',display_total_adult_rate='',display_total_child_rate='',display_adult_rate='',display_child_rate='0',additional_service_rate='0',booking_remark='',emergency_cont_no='',terms_n_condition='';
[02/16/2024 01:12:47], [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','2862','2024-02-16 13:12:47',0);
[02/16/2024 01:12:51], [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/16_02_2024/request_reservation_sight_shiv_qtech_13_12_47_1708089167.json', 'v1/16_02_2024/response_reservation_sight_shiv_qtech_13_12_47_1708089167.json', 'v1/16_02_2024/response_header_reservation_sight_shiv_qtech_13_12_47_1708089167.json', 'viator', '2024-02-16 01:12:51', '', '', '1643');
[02/16/2024 01:12:51], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE posted_bookings set status=1 where id= '264';
[02/16/2024 01:12:51], [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='1525899.35', supplier_rate='17300.08', uid='', itenirary_id='2862943', confirmation_number='BR-595604413', comment_contract='', current_status='confirmed', original_source='' where id='447';
[02/16/2024 01:12:51], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update sight_bookings set gtaToken='',gta_item_confirm_ref='',viator_item_ref='BR-595604413',viator_ref='BR-595604413',viator_item_id='',viator_voucherKey='https://shop.live.rc.viator.com/ticket?code=1020288069:018f0ab501ed2c78b30fcc87e00e3dd2565b9edd678dd5029b8fba9920649d86:595604413',tour_supplier='',textaddition_activities='N;' where booking_id='447';
[02/16/2024 01:12:51], [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
		('','','447','confirmed','2024-02-16 13:12:51','Sightseeing Booking confirmed by Agent..7849','7849','43.239.53.130','','','');
[02/16/2024 01:12:51], [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('447','Mr','1','qtechtestone','donotcharge','adult','0');
[02/16/2024 01:12:51], [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('447','Mr','1','qtechtesttwo','donotcharge','adult','0');
[02/16/2024 01:12:51], [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('447','Mr','1','qtechtestthree','donotcharge','adult','0');
[02/16/2024 01:12:51], [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('447','Mr','1','qtechtestfour','donotcharge','adult','0');
[02/16/2024 01:12:51], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],update xmllogs set reservation_id='447' where agent_logs_id='1643' and source_type='viator';
[02/16/2024 01:13:11], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:13:11' WHERE id= '541';
[02/16/2024 01:13:24], [file name :-/home/otrams/public_html/beta/add_voucher.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:13:24' WHERE id= '541';
[02/16/2024 01:13:24], [file name :-/home/otrams/public_html/beta/confirm_booking_sightseeing.php],UPDATE user_sessions_ip SET update_date = '2024-02-16 01:13:24' WHERE id= '541';
