[11/27/2023 01:02:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:02:08' WHERE id= '155';
[11/27/2023 01:02:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:02:18' WHERE id= '155';
[11/27/2023 01:02:18], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/01/07' , departure_date = '2024/01/08' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-11-27 13:02:18' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/27/2023 01:02:19], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:02:19' WHERE id= '155';
[11/27/2023 01:02:20], [file name :-/home/otrams/public_html/beta/call.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', 'e1/27_11_2023/request_availability_Baysan_Tourism_wh_13_02_19_1701090139_79.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_13_02_19_1701090139_79.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_02_19_1701090139_79.json', 'expedia', '2023-11-27 01:02:20', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:02:20], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/27_11_2023/request_availability_Baysan_Tourism_wh_13_02_19_1701090139_30.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_13_02_19_1701090139_30.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_02_19_1701090139_30.json', 'expediapackage', '2023-11-27 01:02:20', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:02:20], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/27_11_2023/request_availability_Baysan_Tourism_wh_13_02_19_1701090139_68.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_13_02_19_1701090139_68.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_02_19_1701090139_68.json', 'expediapackage', '2023-11-27 01:02:20', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:02:20], [file name :-/home/otrams/public_html/beta/call.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', 'e1/27_11_2023/request_availability_Baysan_Tourism_wh_13_02_19_1701090139_20.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_13_02_19_1701090139_20.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_02_19_1701090139_20.json', 'expedia', '2023-11-27 01:02:20', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:02:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:02:19.222'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.154'
            , error_description = ''
            , memory_used = '14399792'
            WHERE id = '14594';
[11/27/2023 01:02:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:02:19.222'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.166'
            , error_description = ''
            , memory_used = '14570984'
            WHERE id = '14595';
[11/27/2023 01:02:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:02:19.222'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.409'
            , error_description = ''
            , memory_used = '33951640'
            WHERE id = '14596';
[11/27/2023 01:02:20], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:02:19.222'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.446'
            , error_description = ''
            , memory_used = '32483160'
            WHERE id = '14597';
[11/27/2023 01:02:21], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:02:21' WHERE id= '155';
[11/27/2023 01:02:31], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:02:31' WHERE id= '155';
[11/27/2023 01:02:31], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:02:31' WHERE id= '155';
[11/27/2023 01:02:31], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701090151','43.239.53.130');
[11/27/2023 01:02:32], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/27_11_2023/request_valuation_Baysan_Tourism_wh_13_02_31_1701090151_90.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_13_02_31_1701090151_90.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_13_02_31_1701090151_90.json', 'expediapackage', '2023-11-27 01:02:32', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:02:34], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:02:34' WHERE id= '155';
[11/27/2023 01:02:35], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:02:35' WHERE id= '155';
[11/27/2023 01:02:35], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701090155','43.239.53.130');
[11/27/2023 01:02:35], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/27_11_2023/request_valuation_Baysan_Tourism_wh_13_02_35_1701090155_70.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_13_02_35_1701090155_70.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_13_02_35_1701090155_70.json', 'expediapackage', '2023-11-27 01:02:35', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:02:36], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:02:36' WHERE id= '155';
[11/27/2023 01:02:37], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:02:37' WHERE id= '155';
[11/27/2023 01:02:37], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701090157','43.239.53.130');
[11/27/2023 01:02:37], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/27_11_2023/request_valuation_Baysan_Tourism_wh_13_02_37_1701090157_76.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_13_02_37_1701090157_76.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_13_02_37_1701090157_76.json', 'expediapackage', '2023-11-27 01:02:37', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:02:47], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:02:47' WHERE id= '155';
[11/27/2023 01:03:03], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:03:03' WHERE id= '155';
[11/27/2023 01:03:03], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701090183','43.239.53.130');
[11/27/2023 01:03:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:03:03' WHERE id= '155';
[11/27/2023 01:03:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '992', create_date = '2023-11-27 13:03:03', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '20.42', display_currency_code = 'USD', native_room_rate = '20.42', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/07', check_out_date = '2024/01/08', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'TestC', leader_last_name = 'demo', status_date = '2023-11-27 13:03:03';
[11/27/2023 01:03:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('86','MILAN INTERNATIONAL','Hotel Milan International','2567146','OT000157297','mumbai','expediapackage',NOW());
[11/27/2023 01:03:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='86'
		;
[11/27/2023 01:03:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('86','992','','1','1','0','-','','','2567146','Hotel Milan International','First Road near Milan Subway Santacruz West','+912265608943','3.0','1','2024/01/07','2024/01/08','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzMwMDAwMDAvMjU3MDAwMC8yNTY3MjAwLzI1NjcxNDYvMThmZDM2NThfYi5qcGc=');
[11/27/2023 01:03:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '86', booking_detail_id = '1', room_type_code = '', room_name = 'single', room_type_description = 'QueenBed Economy Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Members exclusive price)</font></b><br>(1 Queen Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:20.420000000000002;s:25:"displayNightlyRateDisplay";s:154:"Rate - 20.42,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.75 USD, Marketing Fee - 1.75  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:20.52;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:20.420000000000002;}}', native_room_rate_total = '20.42', wh_room_rate_total = '20.52', display_room_rate_total = '20.42', number_of_rooms = '1';
[11/27/2023 01:03:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '86', booking_detail_id = '1', rid = '95', room = '0', salutations = 'Mr', first_name = 'TestC', last_name = 'demo', passenger_type = 'adult', age = '';
[11/27/2023 01:03:04], [file name :-/home/otrams/public_html/beta/confirm_booking.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', 'e1p/27_11_2023/request_reservation_Baysan_Tourism_wh_13_03_03_1701090183_43.json', 'e1p/27_11_2023/response_reservation_Baysan_Tourism_wh_13_03_03_1701090183_43.json', 'e1p/27_11_2023/response_header_reservation_Baysan_Tourism_wh_13_03_03_1701090183_43.json', 'expediapackage', '2023-11-27 01:03:04', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:03:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7161629911082', confirmation_number = '7161629911082', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-01-05<br>If you cancel between 2024-01-05 12:30:00 and 2024-01-07 00:00:00 , you will be charged 20.52 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 12:30 on 5th of January 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-01-05 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free valet parking, Free parking, Free WiFi<br><br><b>Deal:</b> Members exclusive price,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free valet parking, Free parking, Free WiFi<br><br><b>Deal:</b> Members exclusive price,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='20.52',  wh_sub_agent_rate='0',  wh_parent_agent_id='7865',  wh_agent_id='7865',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='20.42',  applicable_service_tax='0',  supplier_rate='20.42',  uid='c4d9c48848a0f8b6de0f7c3f61f6196b'  where id='86';
[11/27/2023 01:03:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='86';
[11/27/2023 01:03:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('86','19.08871958','72.84189124');
[11/27/2023 01:03:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-27 13:03:04',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;86\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -86 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/27/2023 01:03:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='319', `entity`='BookingId', `value`='86' ;
[11/27/2023 01:03:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('992','86','confirmed','2023-11-27 13:03:04','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/27/2023 01:07:36], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:07:36' WHERE id= '155';
[11/27/2023 01:07:59], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:07:59' WHERE id= '155';
[11/27/2023 01:08:03], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:03' WHERE id= '155';
[11/27/2023 01:08:03], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-27 01:08:03',login_attempt=0 where id = '7865';
[11/27/2023 01:08:03], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-27 13:08:03', ip = '43.239.53.130', action = 'Login' ;
[11/27/2023 01:08:03], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:03' WHERE id= '155';
[11/27/2023 01:08:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:08' WHERE id= '155';
[11/27/2023 01:08:13], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:13' WHERE id= '155';
[11/27/2023 01:08:13], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/01' , departure_date = '2024/02/02' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-27 13:08:13' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/27/2023 01:08:14], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:14' WHERE id= '155';
[11/27/2023 01:08:15], [file name :-/home/otrams/public_html/beta/call.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', 'e1/27_11_2023/request_availability_Baysan_Tourism_wh_13_08_14_1701090494_24.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_13_08_14_1701090494_24.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_08_14_1701090494_24.json', 'expedia', '2023-11-27 01:08:15', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:08:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:08:14.446'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.716'
            , error_description = ''
            , memory_used = '13571880'
            WHERE id = '14602';
[11/27/2023 01:08:15], [file name :-/home/otrams/public_html/beta/call.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', 'e1/27_11_2023/request_availability_Baysan_Tourism_wh_13_08_14_1701090494_47.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_13_08_14_1701090494_47.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_08_14_1701090494_47.json', 'expedia', '2023-11-27 01:08:15', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:08:15], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/27_11_2023/request_availability_Baysan_Tourism_wh_13_08_14_1701090494_33.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_13_08_14_1701090494_33.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_08_14_1701090494_33.json', 'expediapackage', '2023-11-27 01:08:15', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:08:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:08:14.446'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.208'
            , error_description = ''
            , memory_used = '13782928'
            WHERE id = '14604';
[11/27/2023 01:08:15], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:08:14.446'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.358'
            , error_description = ''
            , memory_used = '31290888'
            WHERE id = '14603';
[11/27/2023 01:08:15], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/27_11_2023/request_availability_Baysan_Tourism_wh_13_08_14_1701090494_21.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_13_08_14_1701090494_21.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_08_14_1701090494_21.json', 'expediapackage', '2023-11-27 01:08:15', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:08:16], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:08:14.446'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.733'
            , error_description = ''
            , memory_used = '32020944'
            WHERE id = '14605';
[11/27/2023 01:08:16], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:16' WHERE id= '155';
[11/27/2023 01:08:24], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:24' WHERE id= '155';
[11/27/2023 01:08:24], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:24' WHERE id= '155';
[11/27/2023 01:08:24], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701090504','43.239.53.130');
[11/27/2023 01:08:25], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/27_11_2023/request_valuation_Baysan_Tourism_wh_13_08_24_1701090504_26.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_13_08_24_1701090504_26.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_13_08_24_1701090504_26.json', 'expediapackage', '2023-11-27 01:08:25', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:08:26], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:26' WHERE id= '155';
[11/27/2023 01:08:27], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:27' WHERE id= '155';
[11/27/2023 01:08:27], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701090507','43.239.53.130');
[11/27/2023 01:08:27], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/27_11_2023/request_valuation_Baysan_Tourism_wh_13_08_27_1701090507_30.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_13_08_27_1701090507_30.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_13_08_27_1701090507_30.json', 'expediapackage', '2023-11-27 01:08:27', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:08:37], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:37' WHERE id= '155';
[11/27/2023 01:08:47], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:47' WHERE id= '155';
[11/27/2023 01:08:47], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701090527','43.239.53.130');
[11/27/2023 01:08:47], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:08:47' WHERE id= '155';
[11/27/2023 01:08:48], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '995', create_date = '2023-11-27 13:08:48', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '18.35', display_currency_code = 'USD', native_room_rate = '18.35', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/02/01', check_out_date = '2024/02/02', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'TestE', leader_last_name = 'demo', status_date = '2023-11-27 13:08:48';
[11/27/2023 01:08:48], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('87','HOTEL RELAX','Relax Guest House','24311990','OT000812803','mumbai','expediapackage',NOW());
[11/27/2023 01:08:48], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='87'
		;
[11/27/2023 01:08:48], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('87','995','','1','2','0','-','','','24311990','Relax Guest House','0911, Syed Mukhri Street Katha Bazar, Masijd Bunder','91-0-9022952250','3.0','1','2024/02/01','2024/02/02','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0MzIwMDAwLzI0MzEyMDAwLzI0MzExOTkwLzY0M2RhMjhjX2IuanBn');
[11/27/2023 01:08:48], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '87', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Deluxe Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:18.350000000000001;s:25:"displayNightlyRateDisplay";s:154:"Rate - 18.35,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 0.91 USD, Marketing Fee - 0.91  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:18.440000000000001;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:18.350000000000001;}}', native_room_rate_total = '18.35', wh_room_rate_total = '18.44', display_room_rate_total = '18.35', number_of_rooms = '1';
[11/27/2023 01:08:48], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '87', booking_detail_id = '1', rid = '96', room = '0', salutations = 'Mr', first_name = 'TestE', last_name = 'demo', passenger_type = 'adult', age = '';
[11/27/2023 01:08:48], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '87', booking_detail_id = '1', rid = '96', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/27/2023 01:08:49], [file name :-/home/otrams/public_html/beta/confirm_booking.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', 'e1p/27_11_2023/request_reservation_Baysan_Tourism_wh_13_08_48_1701090528_53.json', 'e1p/27_11_2023/response_reservation_Baysan_Tourism_wh_13_08_48_1701090528_53.json', 'e1p/27_11_2023/response_header_reservation_Baysan_Tourism_wh_13_08_48_1701090528_53.json', 'expediapackage', '2023-11-27 01:08:49', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:08:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7427027650321', confirmation_number = '7427027650321', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-01-30<br>If you cancel between 2024-01-30 12:30:00 and 2024-02-01 00:00:00 , you will be charged 18.44 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 12:30 on 30th of January 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-01-30 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543213', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='18.44',  wh_sub_agent_rate='0',  wh_parent_agent_id='7865',  wh_agent_id='7865',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='18.35',  applicable_service_tax='0',  supplier_rate='18.35',  uid='8671b36bd3ce4b6ebea44847fc80b736'  where id='87';
[11/27/2023 01:08:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='87';
[11/27/2023 01:08:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('87','18.95112099','72.83793084');
[11/27/2023 01:08:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-27 13:08:49',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;87\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -87 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/27/2023 01:08:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='320', `entity`='BookingId', `value`='87' ;
[11/27/2023 01:08:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('995','87','confirmed','2023-11-27 13:08:49','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/27/2023 01:08:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('87','2024-01-30 12:30:00','2024-01-30 12:30:00','2024-02-01 00:00:00','2024-02-01 00:00:00','18.35','18.44','0','2023-11-27 13:08:49','18.44');
[11/27/2023 01:08:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='87',status='1' where reservation_id='995' and booking_id ='0';
[11/27/2023 01:08:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='87' where agent_logs_id='0' and source_type='expediapackage';
[11/27/2023 01:08:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='0.91',  commission_tax='',  booking_id ='87',  supplier_tax='2.12',  supplier_base_fare='16.23',  supplier_commissionable_fare='0.91'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-27 13:08:49';
[11/27/2023 01:15:17], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:17' WHERE id= '155';
[11/27/2023 01:15:17], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-27 01:15:17',login_attempt=0 where id = '7865';
[11/27/2023 01:15:17], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-27 13:15:17', ip = '43.239.53.130', action = 'Login' ;
[11/27/2023 01:15:17], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:17' WHERE id= '155';
[11/27/2023 01:15:23], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:23' WHERE id= '155';
[11/27/2023 01:15:23], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:23' WHERE id= '155';
[11/27/2023 01:15:25], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:25' WHERE id= '155';
[11/27/2023 01:15:28], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:28' WHERE id= '155';
[11/27/2023 01:15:28], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:28' WHERE id= '155';
[11/27/2023 01:15:43], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:43' WHERE id= '155';
[11/27/2023 01:15:43], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/07' , departure_date = '2024/02/08' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-27 13:15:43' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/27/2023 01:15:44], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:44' WHERE id= '155';
[11/27/2023 01:15:45], [file name :-/home/otrams/public_html/beta/call.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', 'e1/27_11_2023/request_availability_Baysan_Tourism_wh_13_15_44_1701090944_3.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_13_15_44_1701090944_3.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_15_44_1701090944_3.json', 'expedia', '2023-11-27 01:15:45', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:15:45], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/27_11_2023/request_availability_Baysan_Tourism_wh_13_15_44_1701090944_82.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_13_15_44_1701090944_82.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_15_44_1701090944_82.json', 'expediapackage', '2023-11-27 01:15:45', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:15:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:15:44.417'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.029'
            , error_description = ''
            , memory_used = '31001752'
            WHERE id = '14613';
[11/27/2023 01:15:45], [file name :-/home/otrams/public_html/beta/call.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', 'e1/27_11_2023/request_availability_Baysan_Tourism_wh_13_15_44_1701090944_55.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_13_15_44_1701090944_55.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_15_44_1701090944_55.json', 'expedia', '2023-11-27 01:15:45', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:15:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:15:44.417'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.119'
            , error_description = ''
            , memory_used = '13499680'
            WHERE id = '14614';
[11/27/2023 01:15:45], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:15:44.417'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.143'
            , error_description = ''
            , memory_used = '13324248'
            WHERE id = '14615';
[11/27/2023 01:15:46], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/27_11_2023/request_availability_Baysan_Tourism_wh_13_15_44_1701090944_52.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_13_15_44_1701090944_52.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_15_44_1701090944_52.json', 'expediapackage', '2023-11-27 01:15:46', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:15:46], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:15:44.417'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.103'
            , error_description = ''
            , memory_used = '32073704'
            WHERE id = '14616';
[11/27/2023 01:15:46], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:46' WHERE id= '155';
[11/27/2023 01:15:59], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:59' WHERE id= '155';
[11/27/2023 01:15:59], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:15:59' WHERE id= '155';
[11/27/2023 01:15:59], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701090959','43.239.53.130');
[11/27/2023 01:16:00], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/27_11_2023/request_valuation_Baysan_Tourism_wh_13_15_59_1701090959_33.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_13_15_59_1701090959_33.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_13_15_59_1701090959_33.json', 'expediapackage', '2023-11-27 01:16:00', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:16:02], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:16:02' WHERE id= '155';
[11/27/2023 01:16:03], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:16:03' WHERE id= '155';
[11/27/2023 01:16:03], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701090963','43.239.53.130');
[11/27/2023 01:16:03], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/27_11_2023/request_valuation_Baysan_Tourism_wh_13_16_03_1701090963_95.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_13_16_03_1701090963_95.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_13_16_03_1701090963_95.json', 'expediapackage', '2023-11-27 01:16:03', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:16:13], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:16:13' WHERE id= '155';
[11/27/2023 01:16:14], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:16:14' WHERE id= '155';
[11/27/2023 01:16:29], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:16:29' WHERE id= '155';
[11/27/2023 01:16:29], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701090989','43.239.53.130');
[11/27/2023 01:16:29], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:16:29' WHERE id= '155';
[11/27/2023 01:16:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '998', create_date = '2023-11-27 13:16:30', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '19.7', display_currency_code = 'USD', native_room_rate = '19.7', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/02/07', check_out_date = '2024/02/08', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'TestF', leader_last_name = 'demo', status_date = '2023-11-27 13:16:30';
[11/27/2023 01:16:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('88','HOTEL RELAX','Relax Guest House','24311990','OT000812803','mumbai','expediapackage',NOW());
[11/27/2023 01:16:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='88'
		;
[11/27/2023 01:16:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('88','998','','1','2','0','-','','','24311990','Relax Guest House','0911, Syed Mukhri Street Katha Bazar, Masijd Bunder','91-0-9022952250','3.0','1','2024/02/07','2024/02/08','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0MzIwMDAwLzI0MzEyMDAwLzI0MzExOTkwLzY0M2RhMjhjX2IuanBn');
[11/27/2023 01:16:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '88', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Deluxe Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:19.699999999999999;s:25:"displayNightlyRateDisplay";s:153:"Rate - 19.7,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.58 USD, Marketing Fee - 1.58  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:19.800000000000001;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:19.699999999999999;}}', native_room_rate_total = '19.7', wh_room_rate_total = '19.8', display_room_rate_total = '19.7', number_of_rooms = '1';
[11/27/2023 01:16:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '88', booking_detail_id = '1', rid = '97', room = '0', salutations = 'Mr', first_name = 'TestF', last_name = 'demo', passenger_type = 'adult', age = '';
[11/27/2023 01:16:30], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '88', booking_detail_id = '1', rid = '97', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/27/2023 01:16:31], [file name :-/home/otrams/public_html/beta/confirm_booking.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', 'e1p/27_11_2023/request_reservation_Baysan_Tourism_wh_13_16_30_1701090990_37.json', 'e1p/27_11_2023/response_reservation_Baysan_Tourism_wh_13_16_30_1701090990_37.json', 'e1p/27_11_2023/response_header_reservation_Baysan_Tourism_wh_13_16_30_1701090990_37.json', 'expediapackage', '2023-11-27 01:16:31', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:16:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7710487497577', confirmation_number = '7710487497577', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-02-05<br>If you cancel between 2024-02-05 12:30:00 and 2024-02-07 00:00:00 , you will be charged 19.8 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 12:30 on 5th of February 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-02-05 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='19.8',  wh_sub_agent_rate='0',  wh_parent_agent_id='7865',  wh_agent_id='7865',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='19.7',  applicable_service_tax='0',  supplier_rate='19.7',  uid='ae2a49591ef5033e2c5d9adbb60ae035'  where id='88';
[11/27/2023 01:16:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='88';
[11/27/2023 01:16:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('88','18.95112099','72.83793084');
[11/27/2023 01:16:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-27 13:16:31',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;88\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -88 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/27/2023 01:16:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='321', `entity`='BookingId', `value`='88' ;
[11/27/2023 01:16:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('998','88','confirmed','2023-11-27 13:16:31','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/27/2023 01:16:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('88','2024-02-05 12:30:00','2024-02-05 12:30:00','2024-02-07 00:00:00','2024-02-07 00:00:00','19.7','19.8','0','2023-11-27 13:16:31','19.8');
[11/27/2023 01:16:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='88',status='1' where reservation_id='998' and booking_id ='0';
[11/27/2023 01:16:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='88' where agent_logs_id='0' and source_type='expediapackage';
[11/27/2023 01:16:31], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.58',  commission_tax='',  booking_id ='88',  supplier_tax='2.15',  supplier_base_fare='17.55',  supplier_commissionable_fare='1.58'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-27 13:16:31';
[11/27/2023 01:19:04], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:19:04' WHERE id= '155';
[11/27/2023 01:19:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-27 01:19:04',login_attempt=0 where id = '7865';
[11/27/2023 01:19:04], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'test_Whitelable', user_type = 'A', branch_id = '31', login_datetime = '2023-11-27 13:19:04', ip = '43.239.53.130', action = 'Login' ;
[11/27/2023 01:19:04], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:19:04' WHERE id= '155';
[11/27/2023 01:19:10], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:19:10' WHERE id= '155';
[11/27/2023 01:19:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:19:27' WHERE id= '155';
[11/27/2023 01:19:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/13' , departure_date = '2024/02/14' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-27 13:19:27' , site_id = '20' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/27/2023 01:19:27], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:19:27' WHERE id= '155';
[11/27/2023 01:19:28], [file name :-/home/otrams/public_html/beta/call.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', 'e1/27_11_2023/request_availability_Baysan_Tourism_wh_13_19_27_1701091167_52.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_13_19_27_1701091167_52.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_19_27_1701091167_52.json', 'expedia', '2023-11-27 01:19:28', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:19:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:19:27.765'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.802'
            , error_description = ''
            , memory_used = '12573544'
            WHERE id = '14620';
[11/27/2023 01:19:28], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/27_11_2023/request_availability_Baysan_Tourism_wh_13_19_27_1701091167_3.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_13_19_27_1701091167_3.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_19_27_1701091167_3.json', 'expediapackage', '2023-11-27 01:19:28', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:19:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:19:27.766'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.075'
            , error_description = ''
            , memory_used = '12928560'
            WHERE id = '14621';
[11/27/2023 01:19:28], [file name :-/home/otrams/public_html/beta/call.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', 'e1/27_11_2023/request_availability_Baysan_Tourism_wh_13_19_27_1701091167_1.json', 'e1/27_11_2023/response_availability_Baysan_Tourism_wh_13_19_27_1701091167_1.json', 'e1/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_19_27_1701091167_1.json', 'expedia', '2023-11-27 01:19:28', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:19:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:19:27.765'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.343'
            , error_description = ''
            , memory_used = '30255752'
            WHERE id = '14622';
[11/27/2023 01:19:29], [file name :-/home/otrams/public_html/beta/call.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', 'e1p/27_11_2023/request_availability_Baysan_Tourism_wh_13_19_27_1701091167_41.json', 'e1p/27_11_2023/response_availability_Baysan_Tourism_wh_13_19_27_1701091167_41.json', 'e1p/27_11_2023/response_header_availability_Baysan_Tourism_wh_13_19_27_1701091167_41.json', 'expediapackage', '2023-11-27 01:19:29', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:19:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58&xml_user_id=7863&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-27 13:19:27.765'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.692'
            , error_description = ''
            , memory_used = '31049960'
            WHERE id = '14623';
[11/27/2023 01:19:29], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:19:29' WHERE id= '155';
[11/27/2023 01:19:37], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:19:37' WHERE id= '155';
[11/27/2023 01:19:37], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:19:37' WHERE id= '155';
[11/27/2023 01:19:37], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701091177','43.239.53.130');
[11/27/2023 01:19:38], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/27_11_2023/request_valuation_Baysan_Tourism_wh_13_19_37_1701091177_45.json', 'e1p/27_11_2023/response_valuation_Baysan_Tourism_wh_13_19_37_1701091177_45.json', 'e1p/27_11_2023/response_header_valuation_Baysan_Tourism_wh_13_19_37_1701091177_45.json', 'expediapackage', '2023-11-27 01:19:38', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:19:44], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:19:44' WHERE id= '155';
[11/27/2023 01:19:59], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:19:59' WHERE id= '155';
[11/27/2023 01:19:59], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701091199','43.239.53.130');
[11/27/2023 01:19:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:19:59' WHERE id= '155';
[11/27/2023 01:19:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1000', create_date = '2023-11-27 13:19:59', agent_id = '7863', parent_agent_id = '7863', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '19.97', display_currency_code = 'USD', native_room_rate = '19.97', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/02/13', check_out_date = '2024/02/14', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'testG', leader_last_name = 'demo', status_date = '2023-11-27 13:19:59';
[11/27/2023 01:19:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('89','HOTEL RELAX','Relax Guest House','24311990','OT000812803','mumbai','expediapackage',NOW());
[11/27/2023 01:19:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='89'
		;
[11/27/2023 01:19:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('89','1000','','1','2','0','-','','','24311990','Relax Guest House','0911, Syed Mukhri Street Katha Bazar, Masijd Bunder','91-0-9022952250','3.0','1','2024/02/13','2024/02/14','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0MzIwMDAwLzI0MzEyMDAwLzI0MzExOTkwLzY0M2RhMjhjX2IuanBn');
[11/27/2023 01:19:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '89', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Deluxe Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:19.969999999999999;s:25:"displayNightlyRateDisplay";s:154:"Rate - 19.97,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.71 USD, Marketing Fee - 1.71  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:20.07;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:19.969999999999999;}}', native_room_rate_total = '19.97', wh_room_rate_total = '20.07', display_room_rate_total = '19.97', number_of_rooms = '1';
[11/27/2023 01:19:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '89', booking_detail_id = '1', rid = '98', room = '0', salutations = 'Mr', first_name = 'testG', last_name = 'demo', passenger_type = 'adult', age = '';
[11/27/2023 01:19:59], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '89', booking_detail_id = '1', rid = '98', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/27/2023 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking.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', 'e1p/27_11_2023/request_reservation_Baysan_Tourism_wh_13_19_59_1701091199_11.json', 'e1p/27_11_2023/response_reservation_Baysan_Tourism_wh_13_19_59_1701091199_11.json', 'e1p/27_11_2023/response_header_reservation_Baysan_Tourism_wh_13_19_59_1701091199_11.json', 'expediapackage', '2023-11-27 01:20:01', '', '88067a7008db7e7fb25f724aae8253a014db6b42fbed2e4d72f5f9d94c686e58', '0');
[11/27/2023 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7136882102519', confirmation_number = '7136882102519', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-02-11<br>If you cancel between 2024-02-11 12:30:00 and 2024-02-13 00:00:00 , you will be charged 20.07 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 12:30 on 11th of February 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2024-02-11 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='20.07',  wh_sub_agent_rate='0',  wh_parent_agent_id='7865',  wh_agent_id='7865',  wh_basecurrency_multiplier_native='1.00000',  wh_basecurrency_multiplier='1.00000',  site_id='20',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7863',  sub_agent_rate='0',  agent_rate='19.97',  applicable_service_tax='0',  supplier_rate='19.97',  uid='710e13df781c65799dfa46af57f1ea93'  where id='89';
[11/27/2023 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='89';
[11/27/2023 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('89','18.95112099','72.83793084');
[11/27/2023 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-27 13:20:01',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;89\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -89 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/27/2023 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='322', `entity`='BookingId', `value`='89' ;
[11/27/2023 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('1000','89','confirmed','2023-11-27 13:20:01','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/27/2023 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('89','2024-02-11 12:30:00','2024-02-11 12:30:00','2024-02-13 00:00:00','2024-02-13 00:00:00','19.97','20.07','0','2023-11-27 13:20:01','20.07');
[11/27/2023 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='89',status='1' where reservation_id='1000' and booking_id ='0';
[11/27/2023 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='89' where agent_logs_id='0' and source_type='expediapackage';
[11/27/2023 01:20:01], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.71',  commission_tax='',  booking_id ='89',  supplier_tax='2.16',  supplier_base_fare='17.81',  supplier_commissionable_fare='1.71'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-27 13:20:01';
[11/27/2023 01:27:37], [file name :-/home/otrams/public_html/beta/hotel_search.php],INSERT INTO psa_login_log  SET username = '', user_type = 'A', branch_id = '7', login_datetime = '2023-11-27 13:27:37', ip = '95.108.213.125', action = 'Login' ;
[11/27/2023 01:32:48], [file name :-/home/otrams/public_html/beta/test_definer.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:32:48' WHERE id= '155';
[11/27/2023 01:33:32], [file name :-/home/otrams/public_html/beta/test_definer.php],UPDATE user_sessions_ip SET update_date = '2023-11-27 01:33:32' WHERE id= '155';
