[11/28/2023 05:00:09], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:00:09' WHERE id= '158';
[11/28/2023 05:00:09], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:00:09' WHERE id= '158';
[11/28/2023 05:00:09], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701147609','43.239.53.130');
[11/28/2023 05:00:10], [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/28_11_2023/request_valuation_Baysan_Tourism_wh_05_00_09_1701147609_19.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_05_00_09_1701147609_19.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_05_00_09_1701147609_19.json', 'expediapackage', '2023-11-28 05:00:10', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:00:12], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:00:12' WHERE id= '158';
[11/28/2023 05:00:12], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:00:12' WHERE id= '158';
[11/28/2023 05:00:12], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701147612','43.239.53.130');
[11/28/2023 05:00:13], [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/28_11_2023/request_valuation_Baysan_Tourism_wh_05_00_12_1701147612_98.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_05_00_12_1701147612_98.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_05_00_12_1701147612_98.json', 'expediapackage', '2023-11-28 05:00:13', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:00:20], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:00:20' WHERE id= '158';
[11/28/2023 05:00:26], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:00:26' WHERE id= '158';
[11/28/2023 05:00:39], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:00:39' WHERE id= '158';
[11/28/2023 05:00:39], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701147639','43.239.53.130');
[11/28/2023 05:00:39], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:00:39' WHERE id= '158';
[11/28/2023 05:00:40], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1007', create_date = '2023-11-28 05:00:40', 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 = '21.52', display_currency_code = 'USD', native_room_rate = '21.52', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/26', check_out_date = '2024/01/27', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'TestI', leader_last_name = 'demo', status_date = '2023-11-28 05:00:40';
[11/28/2023 05:00:40], [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 ('91','HOTEL NIRMAL LODGING','Hotel Nirmal Lodging','24458893','OT000874159','mumbai','expediapackage',NOW());
[11/28/2023 05:00:40], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='91'
		;
[11/28/2023 05:00:40], [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('91','1007','','1','2','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','1','2024/01/26','2024/01/27','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/28/2023 05:00:40], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '91', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Double Room, Non Smoking(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Private sale)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:21.52;s:25:"displayNightlyRateDisplay";s:154:"Rate - 21.52,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.74 USD, Marketing Fee - 1.74  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:21.629999999999999;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:21.52;}}', native_room_rate_total = '21.52', wh_room_rate_total = '21.63', display_room_rate_total = '21.52', number_of_rooms = '1';
[11/28/2023 05:00:40], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '91', booking_detail_id = '1', rid = '100', room = '0', salutations = 'Mr', first_name = 'TestI', last_name = 'demo', passenger_type = 'adult', age = '';
[11/28/2023 05:00:40], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '91', booking_detail_id = '1', rid = '100', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 05:00:41], [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/28_11_2023/request_reservation_Baysan_Tourism_wh_05_00_40_1701147640_61.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_05_00_40_1701147640_61.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_05_00_40_1701147640_61.json', 'expediapackage', '2023-11-28 05:00:41', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:00:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7361606773669', confirmation_number = '7361606773669', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-01-24<br>If you cancel between 2024-01-24 12:30:00 and 2024-01-26 00:00:00 , you will be charged 21.63 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 24th 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-24 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> Private sale,<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> Private sale,<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='21.63',  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='21.52',  applicable_service_tax='0',  supplier_rate='21.52',  uid='9ac04eb350433863b1737fddfddd6a1c'  where id='91';
[11/28/2023 05:00:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='91';
[11/28/2023 05:00:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('91','19.0727','72.8561');
[11/28/2023 05:00:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 05:00:41',`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;91\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -91 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 05:00:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='324', `entity`='BookingId', `value`='91' ;
[11/28/2023 05:00:41], [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 ('1007','91','confirmed','2023-11-28 05:00:41','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 05:00:41], [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('91','2024-01-24 12:30:00','2024-01-24 12:30:00','2024-01-26 00:00:00','2024-01-26 00:00:00','21.52','21.63','0','2023-11-28 05:00:41','21.63');
[11/28/2023 05:00:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='91',status='1' where reservation_id='1007' and booking_id ='0';
[11/28/2023 05:00:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='91' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 05:00:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.74',  commission_tax='',  booking_id ='91',  supplier_tax='2.35',  supplier_base_fare='19.17',  supplier_commissionable_fare='1.74'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 05:00:41';
[11/28/2023 05:02:48], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:02:48' WHERE id= '159';
[11/28/2023 05:02:59], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:02:59' WHERE id= '159';
[11/28/2023 05:03:02], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:03:02' WHERE id= '159';
[11/28/2023 05:03:03], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:03:03' WHERE id= '159';
[11/28/2023 05:03:06], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:03:06' WHERE id= '159';
[11/28/2023 05:05:00], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:05:00' WHERE id= '159';
[11/28/2023 05:05:04], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:05:04' WHERE id= '159';
[11/28/2023 05:05:07], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:05:07' WHERE id= '159';
[11/28/2023 05:05:25], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:05:25' WHERE id= '159';
[11/28/2023 05:05:46], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:05:46' WHERE id= '158';
[11/28/2023 05:05:46], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 05:05:46',login_attempt=0 where id = '7865';
[11/28/2023 05:05:46], [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-28 05:05:46', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 05:05:47], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:05:47' WHERE id= '158';
[11/28/2023 05:05:53], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:05:53' WHERE id= '158';
[11/28/2023 05:06:05], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:06:05' WHERE id= '158';
[11/28/2023 05:06:05], [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/11' , departure_date = '2024/01/12' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-11-28 05:06:05' , 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/28/2023 05:06:06], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:06:06' WHERE id= '158';
[11/28/2023 05:06:06], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_06_06_1701147966_17.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_06_06_1701147966_17.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_06_06_1701147966_17.json', 'expedia', '2023-11-28 05:06:06', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:06:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:06:06.274'
            , 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.754'
            , error_description = ''
            , memory_used = '14547816'
            WHERE id = '14724';
[11/28/2023 05:06:07], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_06_06_1701147966_85.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_06_06_1701147966_85.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_06_06_1701147966_85.json', 'expedia', '2023-11-28 05:06:07', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:06:07], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_06_06_1701147966_59.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_06_06_1701147966_59.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_06_06_1701147966_59.json', 'expediapackage', '2023-11-28 05:06:07', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:06:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:06:06.274'
            , 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.060'
            , error_description = ''
            , memory_used = '32557608'
            WHERE id = '14725';
[11/28/2023 05:06:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:06:06.274'
            , 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.130'
            , error_description = ''
            , memory_used = '14833296'
            WHERE id = '14726';
[11/28/2023 05:06:07], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_06_06_1701147966_20.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_06_06_1701147966_20.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_06_06_1701147966_20.json', 'expediapackage', '2023-11-28 05:06:07', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:06:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:06:06.274'
            , 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.667'
            , error_description = ''
            , memory_used = '34053376'
            WHERE id = '14727';
[11/28/2023 05:06:08], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:06:08' WHERE id= '158';
[11/28/2023 05:06:14], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:06:14' WHERE id= '159';
[11/28/2023 05:06:24], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:06:24' WHERE id= '158';
[11/28/2023 05:06:25], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:06:25' WHERE id= '158';
[11/28/2023 05:06:25], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701147985','43.239.53.130');
[11/28/2023 05:06: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/28_11_2023/request_valuation_Baysan_Tourism_wh_05_06_25_1701147985_18.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_05_06_25_1701147985_18.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_05_06_25_1701147985_18.json', 'expediapackage', '2023-11-28 05:06:25', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:06:47], [file name :-/home/otrams/public_html/beta/edit_profile.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:06:47' WHERE id= '159';
[11/28/2023 05:06:58], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:06:58' WHERE id= '159';
[11/28/2023 05:07:01], [file name :-/home/otrams/public_html/beta/change_password.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:07:01' WHERE id= '159';
[11/28/2023 05:07:05], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:07:05' WHERE id= '159';
[11/28/2023 05:07:08], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:07:08' WHERE id= '159';
[11/28/2023 05:07:10], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:07:10' WHERE id= '159';
[11/28/2023 05:07:53], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:07:53' WHERE id= '158';
[11/28/2023 05:07:56], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:07:56' WHERE id= '158';
[11/28/2023 05:07:57], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:07:57' WHERE id= '158';
[11/28/2023 05:08:18], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:08:18' WHERE id= '158';
[11/28/2023 05:08:18], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701148098','43.239.53.130');
[11/28/2023 05:08:18], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:08:18' WHERE id= '158';
[11/28/2023 05:08:19], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1009', create_date = '2023-11-28 05:08:19', 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.98', display_currency_code = 'USD', native_room_rate = '19.98', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/11', check_out_date = '2024/01/12', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'TestK', leader_last_name = 'demo', status_date = '2023-11-28 05:08:19';
[11/28/2023 05:08:19], [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 ('92','MILAN INTERNATIONAL','Hotel Milan International','2567146','OT000157297','mumbai','expediapackage',NOW());
[11/28/2023 05:08:19], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='92'
		;
[11/28/2023 05:08:19], [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('92','1009','','1','1','0','-','','','2567146','Hotel Milan International','First Road near Milan Subway Santacruz West','+912265608943','3.0','1','2024/01/11','2024/01/12','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzMwMDAwMDAvMjU3MDAwMC8yNTY3MjAwLzI1NjcxNDYvMThmZDM2NThfYi5qcGc=');
[11/28/2023 05:08:19], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '92', 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:19.98;s:25:"displayNightlyRateDisplay";s:154:"Rate - 19.98,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.54 USD, Marketing Fee - 1.54  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:20.079999999999998;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:19.98;}}', native_room_rate_total = '19.98', wh_room_rate_total = '20.08', display_room_rate_total = '19.98', number_of_rooms = '1';
[11/28/2023 05:08:19], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '92', booking_detail_id = '1', rid = '101', room = '0', salutations = 'Mr', first_name = 'TestK', last_name = 'demo', passenger_type = 'adult', age = '';
[11/28/2023 05:08:20], [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/28_11_2023/request_reservation_Baysan_Tourism_wh_05_08_19_1701148099_21.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_05_08_19_1701148099_21.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_05_08_19_1701148099_21.json', 'expediapackage', '2023-11-28 05:08:20', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:08:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7900118178266', confirmation_number = '7900118178266', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-01-09<br>If you cancel between 2024-01-09 12:30:00 and 2024-01-11 00:00:00 , you will be charged 20.08 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 9th 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-09 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.08',  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.98',  applicable_service_tax='0',  supplier_rate='19.98',  uid='75850e0e2cccdf8d7eec29bdb9703e08'  where id='92';
[11/28/2023 05:08:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='92';
[11/28/2023 05:08:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('92','19.08871958','72.84189124');
[11/28/2023 05:08:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 05:08:20',`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;92\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -92 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 05:08:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='325', `entity`='BookingId', `value`='92' ;
[11/28/2023 05:08:20], [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 ('1009','92','confirmed','2023-11-28 05:08:20','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 05:08:20], [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('92','2024-01-09 12:30:00','2024-01-09 12:30:00','2024-01-11 00:00:00','2024-01-11 00:00:00','19.98','20.08','0','2023-11-28 05:08:20','20.08');
[11/28/2023 05:08:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='92',status='1' where reservation_id='1009' and booking_id ='0';
[11/28/2023 05:08:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='92' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 05:08:20], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.54',  commission_tax='',  booking_id ='92',  supplier_tax='2.2',  supplier_base_fare='17.78',  supplier_commissionable_fare='1.54'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 05:08:20';
[11/28/2023 05:11:16], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:11:16' WHERE id= '159';
[11/28/2023 05:11:26], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:11:26' WHERE id= '159';
[11/28/2023 05:11:31], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:11:31' WHERE id= '159';
[11/28/2023 05:11:34], [file name :-/home/otrams/public_html/beta/change_password.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:11:34' WHERE id= '159';
[11/28/2023 05:11:35], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 05:11:35',login_attempt=0 where id = '7857';
[11/28/2023 05:11:35], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'Deepak_T', user_type = 'A', branch_id = '28', login_datetime = '2023-11-28 05:11:35', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 05:11:35], [file name :-/home/otrams/public_html/beta/hotel_search.php],insert into user_sessions_ip SET ip_addr='43.239.53.130', agent_id='7857', session_id='23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a',create_date='2023-11-28 05:11:35', update_date='2023-11-28 05:11:35',domain='beta.astrabookings.com',sub_agent_id='',sub_user_id='';
[11/28/2023 05:11:38], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:11:38' WHERE id= '159';
[11/28/2023 05:11:41], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:11:41' WHERE id= '159';
[11/28/2023 05:11:45], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:11:45' WHERE id= '159';
[11/28/2023 05:11:46], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:11:46' WHERE id= '160';
[11/28/2023 05:11:49], [file name :-/home/otrams/public_html/beta/manage_sub_user.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:11:49' WHERE id= '159';
[11/28/2023 05:11:52], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:11:52' WHERE id= '159';
[11/28/2023 05:11:59], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:11:59' WHERE id= '159';
[11/28/2023 05:12:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:00' WHERE id= '160';
[11/28/2023 05:12:01], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:01' WHERE id= '160';
[11/28/2023 05:12:01], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:01' WHERE id= '160';
[11/28/2023 05:12:01], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:01' WHERE id= '160';
[11/28/2023 05:12:05], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:05' WHERE id= '159';
[11/28/2023 05:12:08], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:08' WHERE id= '160';
[11/28/2023 05:12:21], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:21' WHERE id= '160';
[11/28/2023 05:12:22], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:22' WHERE id= '160';
[11/28/2023 05:12:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:27' WHERE id= '160';
[11/28/2023 05:12:27], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7857' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/08' , departure_date = '2024/02/09' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 05:12:27' , site_id = '' , country_code = '106' , city_code = '64440' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/28/2023 05:12:27], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:27' WHERE id= '160';
[11/28/2023 05:12: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', 'e1/28_11_2023/request_availability_Deepak_T_05_12_27_1701148347_96.json', 'e1/28_11_2023/response_availability_Deepak_T_05_12_27_1701148347_96.json', 'e1/28_11_2023/response_header_availability_Deepak_T_05_12_27_1701148347_96.json', 'expedia', '2023-11-28 05:12:29', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 05:12:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a&xml_user_id=7857&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:12:27.951'
            , 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.391'
            , error_description = ''
            , memory_used = '13072752'
            WHERE id = '14730';
[11/28/2023 05:12: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', 'e1/28_11_2023/request_availability_Deepak_T_05_12_27_1701148347_58.json', 'e1/28_11_2023/response_availability_Deepak_T_05_12_27_1701148347_58.json', 'e1/28_11_2023/response_header_availability_Deepak_T_05_12_27_1701148347_58.json', 'expedia', '2023-11-28 05:12:29', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 05:12:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a&xml_user_id=7857&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:12:27.951'
            , 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 = '30822360'
            WHERE id = '14731';
[11/28/2023 05:12: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/28_11_2023/request_availability_Deepak_T_05_12_27_1701148347_33.json', 'e1p/28_11_2023/response_availability_Deepak_T_05_12_27_1701148347_33.json', 'e1p/28_11_2023/response_header_availability_Deepak_T_05_12_27_1701148347_33.json', 'expediapackage', '2023-11-28 05:12:29', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 05:12:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a&xml_user_id=7857&db_caching=1&erequest=1&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:12:27.951'
            , 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.985'
            , error_description = ''
            , memory_used = '13516608'
            WHERE id = '14732';
[11/28/2023 05:12:30], [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/28_11_2023/request_availability_Deepak_T_05_12_27_1701148347_69.json', 'e1p/28_11_2023/response_availability_Deepak_T_05_12_27_1701148347_69.json', 'e1p/28_11_2023/response_header_availability_Deepak_T_05_12_27_1701148347_69.json', 'expediapackage', '2023-11-28 05:12:30', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 05:12:30], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a&xml_user_id=7857&db_caching=1&erequest=0&total_request=2&web_service=no&ip=43.239.53.130&browser=MozillaFirefox%2F120.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:12:27.951'
            , 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.378'
            , error_description = ''
            , memory_used = '31671224'
            WHERE id = '14733';
[11/28/2023 05:12:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:30' WHERE id= '160';
[11/28/2023 05:12:32], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:32' WHERE id= '160';
[11/28/2023 05:12:39], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:39' WHERE id= '160';
[11/28/2023 05:12:40], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:40' WHERE id= '160';
[11/28/2023 05:12:40], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701148360','43.239.53.130');
[11/28/2023 05:12:40], [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/28_11_2023/request_valuation_Deepak_T_05_12_40_1701148360_88.json', 'e1p/28_11_2023/response_valuation_Deepak_T_05_12_40_1701148360_88.json', 'e1p/28_11_2023/response_header_valuation_Deepak_T_05_12_40_1701148360_88.json', 'expediapackage', '2023-11-28 05:12:40', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 05:12:48], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:48' WHERE id= '159';
[11/28/2023 05:12:49], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:49' WHERE id= '160';
[11/28/2023 05:12:52], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:52' WHERE id= '160';
[11/28/2023 05:12:54], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:54' WHERE id= '160';
[11/28/2023 05:12:54], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:12:54' WHERE id= '159';
[11/28/2023 05:13:01], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:13:01' WHERE id= '159';
[11/28/2023 05:13:06], [file name :-/home/otrams/public_html/beta/booking_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:13:06' WHERE id= '159';
[11/28/2023 05:13:08], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:13:08' WHERE id= '160';
[11/28/2023 05:13:08], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701148388','43.239.53.130');
[11/28/2023 05:13:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:13:09' WHERE id= '160';
[11/28/2023 05:13:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1011', create_date = '2023-11-28 05:13:09', agent_id = '7857', parent_agent_id = '7857', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '47.15', display_currency_code = 'USD', native_room_rate = '19.7', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/02/08', check_out_date = '2024/02/09', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Testz', leader_last_name = 'demo', status_date = '2023-11-28 05:13:09';
[11/28/2023 05:13:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '28'
		WHERE
		id='93'
		;
[11/28/2023 05:13:09], [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('93','1011','','1','2','0','-','','','24311990','Relax Guest House','0911, Syed Mukhri Street Katha Bazar, Masijd Bunder','91-0-9022952250','3.0','1','2024/02/08','2024/02/09','','https://beta.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0MzIwMDAwLzI0MzEyMDAwLzI0MzExOTkwLzY0M2RhMjhjX2IuanBn');
[11/28/2023 05:13:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '93', 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:2:{s:18:"displayNightlyRate";d:47.149999999999999;s:25:"displayNightlyRateDisplay";s:202:"Rate - 19.7, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 4.00%, Markup Amount - 26.662, Markup Amount in SAR- 100.00, Supplier Commission - 1.58 USD, Marketing Fee - 1.58  USD #expediapackage";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:19.699999999999999;}}', native_room_rate_total = '19.7', display_room_rate_total = '47.15', number_of_rooms = '1', room_category = '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)', meal_basis = 'Room Only';
[11/28/2023 05:13:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '93', booking_detail_id = '1', rid = '102', room = '0', salutations = 'Mr', first_name = 'Testz', last_name = 'demo', passenger_type = 'adult', age = '';
[11/28/2023 05:13:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '93', booking_detail_id = '1', rid = '102', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 05:13:10], [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/28_11_2023/request_reservation_Deepak_T_05_13_10_1701148390_7.json', 'e1p/28_11_2023/response_reservation_Deepak_T_05_13_10_1701148390_7.json', 'e1p/28_11_2023/response_header_reservation_Deepak_T_05_13_10_1701148390_7.json', 'expediapackage', '2023-11-28 05:13:10', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 05:13:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7385909117930', confirmation_number = '7385909117930', display_discount = '0', cancellation_policy = 'Free cancellation up to  15:29:59 on  2024-02-06<br>If you cancel between 2024-02-06 15:30:00 and 2024-02-08 00:00:00 , you will be charged 47.15 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 15:30 on 6th 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-06 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 = 'b2btravel', sales_manager_id = '0', admin_booked = '0', email_id = 'bhavesh.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 = 'v3alpha', customer_id = '', applied_multiplier='1.00000',  applied_markup='139.34',  agent_markup='139.34',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7857',  sub_agent_rate='0',  agent_rate='47.15',  applicable_service_tax='0',  supplier_rate='19.7',  uid='2f9cd7bfb9e87030674217a115de697f'  where id='93';
[11/28/2023 05:13:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='93';
[11/28/2023 05:13:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('93','18.950835','72.837922');
[11/28/2023 05:13:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Deepak_T',`create_date`= '2023-11-28 05:13:10',`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;93\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -93 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 05:13:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='326', `entity`='BookingId', `value`='93' ;
[11/28/2023 05:13:10], [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 ('1011','93','confirmed','2023-11-28 05:13:10','Booking confirmed. Booked by Back Office v3alpha on behalf of Agent - Deepak  trivedi(CA7857)','7857','43.239.53.130','0','7857');
[11/28/2023 05:13:10], [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('93','2024-02-06 15:30:00','2024-02-06 15:30:00','2024-02-08 00:00:00','2024-02-08 00:00:00','19.7','47.15','0','2023-11-28 05:13:10','47.15');
[11/28/2023 05:13:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='93',status='1' where reservation_id='1011' and booking_id ='0';
[11/28/2023 05:13:11], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='93' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 05:13:11], [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 ='93',  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-28 05:13:11';
[11/28/2023 05:13:13], [file name :-/home/otrams/public_html/beta/my_accounts.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:13:13' WHERE id= '159';
[11/28/2023 05:13:19], [file name :-/home/otrams/public_html/beta/contact_us.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:13:19' WHERE id= '159';
[11/28/2023 05:13:25], [file name :-/home/otrams/public_html/beta/about_us.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:13:25' WHERE id= '159';
[11/28/2023 05:13:29], [file name :-/home/otrams/public_html/beta/terms.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:13:29' WHERE id= '159';
[11/28/2023 05:17:01], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:17:01' WHERE id= '159';
[11/28/2023 05:17:06], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:17:06' WHERE id= '159';
[11/28/2023 05:17:19], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:17:19' WHERE id= '159';
[11/28/2023 05:17:22], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:17:22' WHERE id= '159';
[11/28/2023 05:17:22], [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 = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/28' , departure_date = '2023/11/29' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 05:17:22' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/28/2023 05:17:22], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:17:22' WHERE id= '159';
[11/28/2023 05:17:23], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_17_23_1701148643_67.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_17_23_1701148643_67.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_17_23_1701148643_67.json', 'expediapackage', '2023-11-28 05:17:23', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:17:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:17:23.66'
            , 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.366'
            , error_description = ''
            , memory_used = '1377312'
            WHERE id = '14736';
[11/28/2023 05:17:23], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_17_23_1701148643_8.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_17_23_1701148643_8.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_17_23_1701148643_8.json', 'expedia', '2023-11-28 05:17:23', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:17:23], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:17:23.66'
            , 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.738'
            , error_description = ''
            , memory_used = '1376528'
            WHERE id = '14737';
[11/28/2023 05:17:24], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_17_23_1701148643_88.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_17_23_1701148643_88.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_17_23_1701148643_88.json', 'expedia', '2023-11-28 05:17:24', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:17:24], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_17_23_1701148643_48.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_17_23_1701148643_48.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_17_23_1701148643_48.json', 'expedia', '2023-11-28 05:17:24', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:17:25], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_17_23_1701148643_47.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_17_23_1701148643_47.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_17_23_1701148643_47.json', 'expediapackage', '2023-11-28 05:17:25', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:17:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:17:23.66'
            , 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.202'
            , error_description = ''
            , memory_used = '103187464'
            WHERE id = '14738';
[11/28/2023 05:17:25], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_17_23_1701148643_67.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_17_23_1701148643_67.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_17_23_1701148643_67.json', 'expediapackage', '2023-11-28 05:17:25', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:17:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:17:23.66'
            , 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.397'
            , error_description = ''
            , memory_used = '90080224'
            WHERE id = '14739';
[11/28/2023 05:17:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:17:23.66'
            , 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 = '3.048'
            , error_description = ''
            , memory_used = '114440792'
            WHERE id = '14740';
[11/28/2023 05:17:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:17:23.66'
            , 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 = '3.116'
            , error_description = ''
            , memory_used = '99393272'
            WHERE id = '14741';
[11/28/2023 05:17:27], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:17:27' WHERE id= '159';
[11/28/2023 05:18:25], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:18:25' WHERE id= '159';
[11/28/2023 05:19:29], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:19:29' WHERE id= '159';
[11/28/2023 05:19:29], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:19:29' WHERE id= '159';
[11/28/2023 05:19:39], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:19:39' WHERE id= '159';
[11/28/2023 05:19:44], [file name :-/home/otrams/public_html/beta/flight_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:19:44' WHERE id= '159';
[11/28/2023 05:19:49], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:19:49' WHERE id= '159';
[11/28/2023 05:19:53], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:19:53' WHERE id= '159';
[11/28/2023 05:19:53], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:19:53' WHERE id= '159';
[11/28/2023 05:19:57], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:19:57' WHERE id= '159';
[11/28/2023 05:19:57], [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 = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/11/28' , departure_date = '2023/11/29' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 05:19:57' , site_id = '20' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[11/28/2023 05:19:57], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:19:57' WHERE id= '159';
[11/28/2023 05:19:57], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_19_57_1701148797_90.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_19_57_1701148797_90.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_19_57_1701148797_90.json', 'expediapackage', '2023-11-28 05:19:57', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:19:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:19:57.734'
            , 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.185'
            , error_description = ''
            , memory_used = '1377312'
            WHERE id = '14742';
[11/28/2023 05:19:57], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_19_57_1701148797_35.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_19_57_1701148797_35.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_19_57_1701148797_35.json', 'expedia', '2023-11-28 05:19:57', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:19:57], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=2&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:19:57.734'
            , 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.196'
            , error_description = ''
            , memory_used = '1376528'
            WHERE id = '14743';
[11/28/2023 05:19:58], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_19_57_1701148797_61.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_19_57_1701148797_61.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_19_57_1701148797_61.json', 'expedia', '2023-11-28 05:19:58', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:19:58], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_19_57_1701148797_20.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_19_57_1701148797_20.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_19_57_1701148797_20.json', 'expedia', '2023-11-28 05:19:58', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:19:59], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_19_57_1701148797_79.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_19_57_1701148797_79.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_19_57_1701148797_79.json', 'expediapackage', '2023-11-28 05:19:59', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:19:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:19:57.734'
            , 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.969'
            , error_description = ''
            , memory_used = '90078464'
            WHERE id = '14745';
[11/28/2023 05:19:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:19:57.734'
            , 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.974'
            , error_description = ''
            , memory_used = '103148024'
            WHERE id = '14744';
[11/28/2023 05:19:59], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_19_57_1701148797_29.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_19_57_1701148797_29.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_19_57_1701148797_29.json', 'expediapackage', '2023-11-28 05:19:59', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:19:59], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=1&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:19:57.734'
            , 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.237'
            , error_description = ''
            , memory_used = '98920584'
            WHERE id = '14746';
[11/28/2023 05:20:00], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b&xml_user_id=7863&db_caching=1&erequest=0&total_request=3&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F119.0.0.0%28windows%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-11-28 05:19:57.734'
            , 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 = '3.021'
            , error_description = ''
            , memory_used = '114436344'
            WHERE id = '14747';
[11/28/2023 05:20:01], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:01' WHERE id= '159';
[11/28/2023 05:20:04], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:04' WHERE id= '158';
[11/28/2023 05:20:04], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 05:20:04',login_attempt=0 where id = '7865';
[11/28/2023 05:20: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-28 05:20:04', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 05:20:05], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:05' WHERE id= '158';
[11/28/2023 05:20:05], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:05' WHERE id= '159';
[11/28/2023 05:20:05], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:05' WHERE id= '159';
[11/28/2023 05:20:13], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:13' WHERE id= '158';
[11/28/2023 05:20:25], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:25' WHERE id= '158';
[11/28/2023 05:20:25], [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/04' , departure_date = '2024/01/05' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-11-28 05:20:25' , 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/28/2023 05:20:26], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:26' WHERE id= '158';
[11/28/2023 05:20:27], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_20_26_1701148826_39.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_20_26_1701148826_39.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_20_26_1701148826_39.json', 'expedia', '2023-11-28 05:20:27', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:20:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:20:26.640'
            , 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.747'
            , error_description = ''
            , memory_used = '13611552'
            WHERE id = '14748';
[11/28/2023 05:20:27], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_20_26_1701148826_13.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_20_26_1701148826_13.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_20_26_1701148826_13.json', 'expedia', '2023-11-28 05:20:27', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:20:27], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_20_26_1701148826_63.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_20_26_1701148826_63.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_20_26_1701148826_63.json', 'expediapackage', '2023-11-28 05:20:27', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:20:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:20:26.640'
            , 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.308'
            , error_description = ''
            , memory_used = '30647168'
            WHERE id = '14749';
[11/28/2023 05:20:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:20:26.640'
            , 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.408'
            , error_description = ''
            , memory_used = '13482960'
            WHERE id = '14750';
[11/28/2023 05:20: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/28_11_2023/request_availability_Baysan_Tourism_wh_05_20_26_1701148826_33.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_20_26_1701148826_33.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_20_26_1701148826_33.json', 'expediapackage', '2023-11-28 05:20:28', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:20:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:20:26.640'
            , 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.756'
            , error_description = ''
            , memory_used = '32078056'
            WHERE id = '14751';
[11/28/2023 05:20:28], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:28' WHERE id= '158';
[11/28/2023 05:20:35], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:35' WHERE id= '158';
[11/28/2023 05:20:35], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:35' WHERE id= '158';
[11/28/2023 05:20:35], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701148835','43.239.53.130');
[11/28/2023 05:20:36], [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/28_11_2023/request_valuation_Baysan_Tourism_wh_05_20_35_1701148835_45.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_05_20_35_1701148835_45.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_05_20_35_1701148835_45.json', 'expediapackage', '2023-11-28 05:20:36', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:20:41], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:41' WHERE id= '158';
[11/28/2023 05:20:54], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:54' WHERE id= '158';
[11/28/2023 05:20:54], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701148854','43.239.53.130');
[11/28/2023 05:20:54], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:54' WHERE id= '158';
[11/28/2023 05:20:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1013', create_date = '2023-11-28 05:20:55', 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.69', display_currency_code = 'USD', native_room_rate = '20.69', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/04', check_out_date = '2024/01/05', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'testL', leader_last_name = 'demo', status_date = '2023-11-28 05:20:55';
[11/28/2023 05:20:55], [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 ('94','HOTEL NIRMAL LODGING','Hotel Nirmal Lodging','24458893','OT000874159','mumbai','expediapackage',NOW());
[11/28/2023 05:20:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='94'
		;
[11/28/2023 05:20:55], [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('94','1013','','1','1','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','1','2024/01/04','2024/01/05','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/28/2023 05:20:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '94', booking_detail_id = '1', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Double Room, Non Smoking(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Private sale)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:20.690000000000001;s:25:"displayNightlyRateDisplay";s:154:"Rate - 20.69,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.78 USD, Marketing Fee - 1.78  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:20.789999999999999;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:20.690000000000001;}}', native_room_rate_total = '20.69', wh_room_rate_total = '20.79', display_room_rate_total = '20.69', number_of_rooms = '1';
[11/28/2023 05:20:55], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '94', booking_detail_id = '1', rid = '103', room = '0', salutations = 'Mr', first_name = 'testL', last_name = 'demo', passenger_type = 'adult', age = '';
[11/28/2023 05:20:56], [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/28_11_2023/request_reservation_Baysan_Tourism_wh_05_20_55_1701148855_50.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_05_20_55_1701148855_50.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_05_20_55_1701148855_50.json', 'expediapackage', '2023-11-28 05:20:56', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:20:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7902611590043', confirmation_number = '7902611590043', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-01-02<br>If you cancel between 2024-01-02 12:30:00 and 2024-01-04 00:00:00 , you will be charged 20.79 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 2nd 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-02 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> Private sale,<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> Private sale,<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.79',  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.69',  applicable_service_tax='0',  supplier_rate='20.69',  uid='2b10db0691717b9dfaa1449c4da91c78'  where id='94';
[11/28/2023 05:20:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='94';
[11/28/2023 05:20:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('94','19.0727','72.8561');
[11/28/2023 05:20:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 05:20:56',`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;94\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -94 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 05:20:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='327', `entity`='BookingId', `value`='94' ;
[11/28/2023 05:20:56], [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 ('1013','94','confirmed','2023-11-28 05:20:56','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 05:20:56], [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('94','2024-01-02 12:30:00','2024-01-02 12:30:00','2024-01-04 00:00:00','2024-01-04 00:00:00','20.69','20.79','0','2023-11-28 05:20:56','20.79');
[11/28/2023 05:20:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='94',status='1' where reservation_id='1013' and booking_id ='0';
[11/28/2023 05:20:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='94' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 05:20:56], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.78',  commission_tax='',  booking_id ='94',  supplier_tax='2.24',  supplier_base_fare='18.45',  supplier_commissionable_fare='1.78'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 05:20:56';
[11/28/2023 05:20:57], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:20:57' WHERE id= '159';
[11/28/2023 05:21:01], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:21:01' WHERE id= '159';
[11/28/2023 05:21:01], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:21:01' WHERE id= '159';
[11/28/2023 05:23:35], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:23:35' WHERE id= '159';
[11/28/2023 05:23:43], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:23:43' WHERE id= '159';
[11/28/2023 05:23:49], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:23:49' WHERE id= '159';
[11/28/2023 05:23:49], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:23:49' WHERE id= '159';
[11/28/2023 05:23:56], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:23:56' WHERE id= '159';
[11/28/2023 05:24:01], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:24:01' WHERE id= '159';
[11/28/2023 05:24:01], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:24:01' WHERE id= '159';
[11/28/2023 05:30:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:30:53' WHERE id= '159';
[11/28/2023 05:30:57], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:30:57' WHERE id= '159';
[11/28/2023 05:30:57], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:30:57' WHERE id= '159';
[11/28/2023 05:35:06], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:35:06' WHERE id= '159';
[11/28/2023 05:35:10], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:35:10' WHERE id= '159';
[11/28/2023 05:35:10], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:35:10' WHERE id= '159';
[11/28/2023 05:35:13], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:35:13' WHERE id= '159';
[11/28/2023 05:35:18], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:35:18' WHERE id= '159';
[11/28/2023 05:35:18], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:35:18' WHERE id= '159';
[11/28/2023 05:35:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:35:30' WHERE id= '159';
[11/28/2023 05:35:36], [file name :-/home/otrams/public_html/beta/show_hotel_details.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:35:36' WHERE id= '159';
[11/28/2023 05:35:36], [file name :-/home/otrams/public_html/beta/view_map.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:35:36' WHERE id= '159';
[11/28/2023 05:35:57], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:35:57' WHERE id= '159';
[11/28/2023 05:35:58], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:35:58' WHERE id= '159';
[11/28/2023 05:35:58], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701149758','43.239.53.130');
[11/28/2023 05:35:58], [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/28_11_2023/request_valuation_Baysan_Tourism_wh_05_35_58_1701149758_98.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_05_35_58_1701149758_98.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_05_35_58_1701149758_98.json', 'expediapackage', '2023-11-28 05:35:58', '', '5728b65ab9231509078205c80b31634638cc89f2e83abdc933ff7b8fd846113b', '0');
[11/28/2023 05:36:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:36:13' WHERE id= '159';
[11/28/2023 05:38:50], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:38:50' WHERE id= '158';
[11/28/2023 05:40:21], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:21' WHERE id= '158';
[11/28/2023 05:40:21], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 05:40:21',login_attempt=0 where id = '7865';
[11/28/2023 05:40:21], [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-28 05:40:21', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 05:40:21], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:21' WHERE id= '158';
[11/28/2023 05:40:26], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:26' WHERE id= '158';
[11/28/2023 05:40:27], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:27' WHERE id= '158';
[11/28/2023 05:40:29], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:29' WHERE id= '158';
[11/28/2023 05:40:29], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:29' WHERE id= '158';
[11/28/2023 05:40:36], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:36' WHERE id= '158';
[11/28/2023 05:40:36], [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/10' , departure_date = '2024/01/11' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-11-28 05:40:36' , 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/28/2023 05:40:37], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:37' WHERE id= '158';
[11/28/2023 05:40:37], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_40_37_1701150037_83.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_40_37_1701150037_83.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_40_37_1701150037_83.json', 'expedia', '2023-11-28 05:40:37', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:40:37], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:40:37.123'
            , 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.866'
            , error_description = ''
            , memory_used = '14565256'
            WHERE id = '14759';
[11/28/2023 05:40:38], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_40_37_1701150037_2.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_05_40_37_1701150037_2.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_40_37_1701150037_2.json', 'expedia', '2023-11-28 05:40:38', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:40:38], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_40_37_1701150037_54.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_40_37_1701150037_54.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_40_37_1701150037_54.json', 'expediapackage', '2023-11-28 05:40:38', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:40:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:40:37.123'
            , 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.248'
            , error_description = ''
            , memory_used = '31653312'
            WHERE id = '14760';
[11/28/2023 05:40:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:40:37.123'
            , 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.259'
            , error_description = ''
            , memory_used = '14620112'
            WHERE id = '14761';
[11/28/2023 05:40:38], [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/28_11_2023/request_availability_Baysan_Tourism_wh_05_40_37_1701150037_91.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_05_40_37_1701150037_91.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_05_40_37_1701150037_91.json', 'expediapackage', '2023-11-28 05:40:38', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:40:38], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007&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-28 05:40:37.123'
            , 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.799'
            , error_description = ''
            , memory_used = '33245896'
            WHERE id = '14762';
[11/28/2023 05:40:39], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:39' WHERE id= '158';
[11/28/2023 05:40:48], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:48' WHERE id= '158';
[11/28/2023 05:40:48], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:48' WHERE id= '158';
[11/28/2023 05:40:48], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701150048','43.239.53.130');
[11/28/2023 05:40:48], [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/28_11_2023/request_valuation_Baysan_Tourism_wh_05_40_48_1701150048_33.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_05_40_48_1701150048_33.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_05_40_48_1701150048_33.json', 'expediapackage', '2023-11-28 05:40:48', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:40:56], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:40:56' WHERE id= '158';
[11/28/2023 05:41:12], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:41:12' WHERE id= '158';
[11/28/2023 05:41:12], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701150072','43.239.53.130');
[11/28/2023 05:41:12], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:41:12' WHERE id= '158';
[11/28/2023 05:41:13], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1016', create_date = '2023-11-28 05:41:13', 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.36', display_currency_code = 'USD', native_room_rate = '20.36', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/01/10', check_out_date = '2024/01/11', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'testM', leader_last_name = 'demo', status_date = '2023-11-28 05:41:13';
[11/28/2023 05:41:13], [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 ('95','MILAN INTERNATIONAL','Hotel Milan International','2567146','OT000157297','mumbai','expediapackage',NOW());
[11/28/2023 05:41:13], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='95'
		;
[11/28/2023 05:41:13], [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('95','1016','','1','1','0','-','','','2567146','Hotel Milan International','First Road near Milan Subway Santacruz West','+912265608943','3.0','1','2024/01/10','2024/01/11','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzMwMDAwMDAvMjU3MDAwMC8yNTY3MjAwLzI1NjcxNDYvMThmZDM2NThfYi5qcGc=');
[11/28/2023 05:41:13], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '95', 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.359999999999999;s:25:"displayNightlyRateDisplay";s:154:"Rate - 20.36,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.72 USD, Marketing Fee - 1.72  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:20.460000000000001;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:20.359999999999999;}}', native_room_rate_total = '20.36', wh_room_rate_total = '20.46', display_room_rate_total = '20.36', number_of_rooms = '1';
[11/28/2023 05:41:13], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '95', booking_detail_id = '1', rid = '104', room = '0', salutations = 'Mr', first_name = 'testM', last_name = 'demo', passenger_type = 'adult', age = '';
[11/28/2023 05:41:15], [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/28_11_2023/request_reservation_Baysan_Tourism_wh_05_41_13_1701150073_62.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_05_41_13_1701150073_62.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_05_41_13_1701150073_62.json', 'expediapackage', '2023-11-28 05:41:15', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 05:41:15], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7616419338600', confirmation_number = '7616419338600', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-01-08<br>If you cancel between 2024-01-08 12:30:00 and 2024-01-10 00:00:00 , you will be charged 20.46 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 8th 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-08 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.46',  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.36',  applicable_service_tax='0',  supplier_rate='20.36',  uid='8089bac703875b6f4a6a2045be4625d3'  where id='95';
[11/28/2023 05:41:15], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='95';
[11/28/2023 05:41:15], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('95','19.08871958','72.84189124');
[11/28/2023 05:41:15], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 05:41:15',`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;95\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -95 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 05:41:15], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='328', `entity`='BookingId', `value`='95' ;
[11/28/2023 05:41:15], [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 ('1016','95','confirmed','2023-11-28 05:41:15','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 05:41:15], [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('95','2024-01-08 12:30:00','2024-01-08 12:30:00','2024-01-10 00:00:00','2024-01-10 00:00:00','20.36','20.46','0','2023-11-28 05:41:15','20.46');
[11/28/2023 05:41:15], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='95',status='1' where reservation_id='1016' and booking_id ='0';
[11/28/2023 05:41:15], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='95' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 05:41:15], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.72',  commission_tax='',  booking_id ='95',  supplier_tax='2.21',  supplier_base_fare='18.15',  supplier_commissionable_fare='1.72'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 05:41:15';
[11/28/2023 05:44:42], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 05:44:42' WHERE id= '159';
