[11/28/2023 07:06:56], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:06:56' WHERE id= '158';
[11/28/2023 07:06:56], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 07:06:56',login_attempt=0 where id = '7865';
[11/28/2023 07:06:56], [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 07:06:56', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 07:06:56], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:06:56' WHERE id= '158';
[11/28/2023 07:07:03], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:07:03' WHERE id= '158';
[11/28/2023 07:07:09], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:07:09' WHERE id= '158';
[11/28/2023 07:07:09], [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/25' , departure_date = '2024/01/26' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 07:07:09' , 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 07:07:10], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:07:10' WHERE id= '158';
[11/28/2023 07:07:11], [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_07_07_10_1701155230_98.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_07_07_10_1701155230_98.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_07_10_1701155230_98.json', 'expedia', '2023-11-28 07:07:11', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:07:11], [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 07:07:10.371'
            , 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.977'
            , error_description = ''
            , memory_used = '17210664'
            WHERE id = '14795';
[11/28/2023 07:07:11], [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_07_07_10_1701155230_1.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_07_07_10_1701155230_1.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_07_10_1701155230_1.json', 'expedia', '2023-11-28 07:07:11', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:07:11], [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_07_07_10_1701155230_29.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_07_07_10_1701155230_29.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_07_10_1701155230_29.json', 'expediapackage', '2023-11-28 07:07:11', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:07:11], [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_07_07_10_1701155230_38.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_07_07_10_1701155230_38.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_07_10_1701155230_38.json', 'expediapackage', '2023-11-28 07:07:11', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:07:11], [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 07:07:10.371'
            , 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.355'
            , error_description = ''
            , memory_used = '17174528'
            WHERE id = '14797';
[11/28/2023 07:07:11], [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 07:07:10.371'
            , 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.475'
            , error_description = ''
            , memory_used = '33274480'
            WHERE id = '14796';
[11/28/2023 07:07:11], [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 07:07:10.371'
            , 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.550'
            , error_description = ''
            , memory_used = '34632016'
            WHERE id = '14798';
[11/28/2023 07:07:12], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:07:12' WHERE id= '158';
[11/28/2023 07:07:22], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:07:22' WHERE id= '158';
[11/28/2023 07:07:22], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:07:22' WHERE id= '158';
[11/28/2023 07:07:22], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701155242','43.239.53.130');
[11/28/2023 07:07:22], [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_07_07_22_1701155242_24.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_07_07_22_1701155242_24.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_07_07_22_1701155242_24.json', 'expediapackage', '2023-11-28 07:07:22', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:07:31], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:07:31' WHERE id= '158';
[11/28/2023 07:07:37], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:07:37' WHERE id= '158';
[11/28/2023 07:07:51], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:07:51' WHERE id= '158';
[11/28/2023 07:07:51], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701155271','43.239.53.130');
[11/28/2023 07:07:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:07:52' WHERE id= '158';
[11/28/2023 07:07:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1028', create_date = '2023-11-28 07:07:52', 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/25', check_out_date = '2024/01/26', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'testE', leader_last_name = 'd', status_date = '2023-11-28 07:07:52';
[11/28/2023 07:07:52], [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 ('101','HOTEL NIRMAL LODGING','Hotel Nirmal Lodging','24458893','OT000874159','mumbai','expediapackage',NOW());
[11/28/2023 07:07:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='101'
		;
[11/28/2023 07:07:52], [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('101','1028','','1','2','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','1','2024/01/25','2024/01/26','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/28/2023 07:07:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '101', 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 07:07:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '101', booking_detail_id = '1', rid = '110', room = '0', salutations = 'Mr', first_name = 'testE', last_name = 'd', passenger_type = 'adult', age = '';
[11/28/2023 07:07:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '101', booking_detail_id = '1', rid = '110', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 07:07:53], [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_07_07_52_1701155272_62.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_07_07_52_1701155272_62.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_07_07_52_1701155272_62.json', 'expediapackage', '2023-11-28 07:07:53', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:07:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7855613568027', confirmation_number = '7855613568027', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-01-23<br>If you cancel between 2024-01-23 12:30:00 and 2024-01-25 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 23rd 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-23 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='1465692cc4f3bc8fa44fc0369cce8c5d'  where id='101';
[11/28/2023 07:07:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='101';
[11/28/2023 07:07:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('101','19.0727','72.8561');
[11/28/2023 07:07:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 07:07:53',`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;101\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -101 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 07:07:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='335', `entity`='BookingId', `value`='101' ;
[11/28/2023 07:07:53], [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 ('1028','101','confirmed','2023-11-28 07:07:53','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 07:07:53], [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('101','2024-01-23 12:30:00','2024-01-23 12:30:00','2024-01-25 00:00:00','2024-01-25 00:00:00','21.52','21.63','0','2023-11-28 07:07:53','21.63');
[11/28/2023 07:07:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='101',status='1' where reservation_id='1028' and booking_id ='0';
[11/28/2023 07:07:53], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='101' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 07:07:53], [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 ='101',  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 07:07:53';
[11/28/2023 07:13:12], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:13:12' WHERE id= '158';
[11/28/2023 07:13:12], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 07:13:12',login_attempt=0 where id = '7865';
[11/28/2023 07:13:12], [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 07:13:12', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 07:13:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:13:12' WHERE id= '158';
[11/28/2023 07:13:29], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:13:29' WHERE id= '158';
[11/28/2023 07:13:36], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:13:36' WHERE id= '158';
[11/28/2023 07:13: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/02/15' , departure_date = '2024/02/16' , nights = '1' , nationality = '106' , room_types = '1' , room_type='[{"numberOfAdults":1}]' , available='0' , create_date = '2023-11-28 07:13: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 07:13:36], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:13:36' WHERE id= '158';
[11/28/2023 07:13: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_07_13_37_1701155617_25.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_07_13_37_1701155617_25.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_13_37_1701155617_25.json', 'expedia', '2023-11-28 07:13:37', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:13: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 07:13:37.41'
            , 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.699'
            , error_description = ''
            , memory_used = '15618592'
            WHERE id = '14803';
[11/28/2023 07:13: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_07_13_37_1701155617_66.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_07_13_37_1701155617_66.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_13_37_1701155617_66.json', 'expedia', '2023-11-28 07:13:37', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:13: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_07_13_37_1701155617_78.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_07_13_37_1701155617_78.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_13_37_1701155617_78.json', 'expediapackage', '2023-11-28 07:13:38', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:13: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 07:13:37.41'
            , 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 = '33948960'
            WHERE id = '14804';
[11/28/2023 07:13: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 07:13:37.41'
            , 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.123'
            , error_description = ''
            , memory_used = '15887392'
            WHERE id = '14805';
[11/28/2023 07:13: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_07_13_37_1701155617_35.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_07_13_37_1701155617_35.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_13_37_1701155617_35.json', 'expediapackage', '2023-11-28 07:13:38', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:13: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 07:13:37.41'
            , 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.586'
            , error_description = ''
            , memory_used = '35031584'
            WHERE id = '14806';
[11/28/2023 07:13:39], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:13:39' WHERE id= '158';
[11/28/2023 07:13:46], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:13:46' WHERE id= '158';
[11/28/2023 07:13:46], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:13:46' WHERE id= '158';
[11/28/2023 07:13:46], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701155626','43.239.53.130');
[11/28/2023 07:13:47], [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_07_13_46_1701155626_17.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_07_13_46_1701155626_17.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_07_13_46_1701155626_17.json', 'expediapackage', '2023-11-28 07:13:47', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:13:53], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:13:53' WHERE id= '158';
[11/28/2023 07:14:03], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:14:03' WHERE id= '158';
[11/28/2023 07:14:03], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701155643','43.239.53.130');
[11/28/2023 07:14:03], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:14:03' WHERE id= '158';
[11/28/2023 07:14:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1030', create_date = '2023-11-28 07:14:04', 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.18', display_currency_code = 'USD', native_room_rate = '19.18', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/02/15', check_out_date = '2024/02/16', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'test', leader_last_name = 'test', status_date = '2023-11-28 07:14:04';
[11/28/2023 07:14:04], [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 ('102','HOTEL RELAX','Relax Guest House','24311990','OT000812803','mumbai','expediapackage',NOW());
[11/28/2023 07:14:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='102'
		;
[11/28/2023 07:14:04], [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('102','1030','','1','1','0','-','','','24311990','Relax Guest House','0911, Syed Mukhri Street Katha Bazar, Masijd Bunder','91-0-9022952250','3.0','1','2024/02/15','2024/02/16','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0MzIwMDAwLzI0MzEyMDAwLzI0MzExOTkwLzY0M2RhMjhjX2IuanBn');
[11/28/2023 07:14:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '102', booking_detail_id = '1', room_type_code = '', room_name = 'single', room_type_description = 'FullBed Deluxe Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:19.18;s:25:"displayNightlyRateDisplay";s:154:"Rate - 19.18,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.32 USD, Marketing Fee - 1.32  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:19.280000000000001;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:19.18;}}', native_room_rate_total = '19.18', wh_room_rate_total = '19.28', display_room_rate_total = '19.18', number_of_rooms = '1';
[11/28/2023 07:14:04], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '102', booking_detail_id = '1', rid = '111', room = '0', salutations = 'Mr', first_name = 'test', last_name = 'test', passenger_type = 'adult', age = '';
[11/28/2023 07:14:05], [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_07_14_04_1701155644_37.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_07_14_04_1701155644_37.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_07_14_04_1701155644_37.json', 'expediapackage', '2023-11-28 07:14:05', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:14:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7077134094437', confirmation_number = '7077134094437', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-02-13<br>If you cancel between 2024-02-13 12:30:00 and 2024-02-15 00:00:00 , you will be charged 19.28 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 13th 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-13 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'shiva@gmailcom', leader_phone = '9876543211', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='19.28',  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.18',  applicable_service_tax='0',  supplier_rate='19.18',  uid='f53be6d90e427b9e8477e559e09d3196'  where id='102';
[11/28/2023 07:14:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='102';
[11/28/2023 07:14:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('102','18.95112099','72.83793084');
[11/28/2023 07:14:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 07:14:05',`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;102\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -102 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 07:14:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='336', `entity`='BookingId', `value`='102' ;
[11/28/2023 07:14:05], [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 ('1030','102','confirmed','2023-11-28 07:14:05','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 07:14:05], [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('102','2024-02-13 12:30:00','2024-02-13 12:30:00','2024-02-15 00:00:00','2024-02-15 00:00:00','19.18','19.28','0','2023-11-28 07:14:05','19.28');
[11/28/2023 07:14:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='102',status='1' where reservation_id='1030' and booking_id ='0';
[11/28/2023 07:14:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='102' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 07:14:05], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.32',  commission_tax='',  booking_id ='102',  supplier_tax='2.14',  supplier_base_fare='17.04',  supplier_commissionable_fare='1.32'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 07:14:05';
[11/28/2023 07:16:49], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 07:16:49',login_attempt=0 where id = '7857';
[11/28/2023 07:16:49], [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 07:16:49', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 07:16:49], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:16:49' WHERE id= '160';
[11/28/2023 07:16:56], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:16:56' WHERE id= '160';
[11/28/2023 07:16:57], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:16:57' WHERE id= '160';
[11/28/2023 07:16:59], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:16:59' WHERE id= '160';
[11/28/2023 07:17:00], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:17:00' WHERE id= '160';
[11/28/2023 07:17:07], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:17:07' WHERE id= '160';
[11/28/2023 07:17:07], [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 07:17:07' , 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 07:17:08], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:17:08' WHERE id= '160';
[11/28/2023 07:17:09], [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_07_17_08_1701155828_82.json', 'e1/28_11_2023/response_availability_Deepak_T_07_17_08_1701155828_82.json', 'e1/28_11_2023/response_header_availability_Deepak_T_07_17_08_1701155828_82.json', 'expedia', '2023-11-28 07:17:09', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 07:17:09], [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 07:17:08.789'
            , 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.729'
            , error_description = ''
            , memory_used = '15372248'
            WHERE id = '14809';
[11/28/2023 07:17:09], [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_07_17_08_1701155828_36.json', 'e1p/28_11_2023/response_availability_Deepak_T_07_17_08_1701155828_36.json', 'e1p/28_11_2023/response_header_availability_Deepak_T_07_17_08_1701155828_36.json', 'expediapackage', '2023-11-28 07:17:09', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 07:17:09], [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_07_17_08_1701155828_26.json', 'e1/28_11_2023/response_availability_Deepak_T_07_17_08_1701155828_26.json', 'e1/28_11_2023/response_header_availability_Deepak_T_07_17_08_1701155828_26.json', 'expedia', '2023-11-28 07:17:09', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 07:17:09], [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 07:17:08.789'
            , 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.114'
            , error_description = ''
            , memory_used = '15793200'
            WHERE id = '14810';
[11/28/2023 07:17:10], [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 07:17:08.789'
            , 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.313'
            , error_description = ''
            , memory_used = '32884000'
            WHERE id = '14811';
[11/28/2023 07:17:10], [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_07_17_08_1701155828_1.json', 'e1p/28_11_2023/response_availability_Deepak_T_07_17_08_1701155828_1.json', 'e1p/28_11_2023/response_header_availability_Deepak_T_07_17_08_1701155828_1.json', 'expediapackage', '2023-11-28 07:17:10', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 07:17:10], [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 07:17:08.789'
            , 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.684'
            , error_description = ''
            , memory_used = '33764224'
            WHERE id = '14812';
[11/28/2023 07:17:10], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:17:10' WHERE id= '160';
[11/28/2023 07:17:12], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:17:12' WHERE id= '160';
[11/28/2023 07:17:19], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:17:19' WHERE id= '160';
[11/28/2023 07:17:19], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:17:19' WHERE id= '160';
[11/28/2023 07:17:19], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701155839','43.239.53.130');
[11/28/2023 07:17:20], [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_07_17_19_1701155839_47.json', 'e1p/28_11_2023/response_valuation_Deepak_T_07_17_19_1701155839_47.json', 'e1p/28_11_2023/response_header_valuation_Deepak_T_07_17_19_1701155839_47.json', 'expediapackage', '2023-11-28 07:17:20', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 07:17:27], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:17:27' WHERE id= '160';
[11/28/2023 07:17:40], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:17:40' WHERE id= '160';
[11/28/2023 07:17:40], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701155860','43.239.53.130');
[11/28/2023 07:17:40], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:17:40' WHERE id= '160';
[11/28/2023 07:17:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1032', create_date = '2023-11-28 07:17:41', 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 = 'bhavesh', leader_last_name = 'gurav', status_date = '2023-11-28 07:17:41';
[11/28/2023 07:17:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '28'
		WHERE
		id='103'
		;
[11/28/2023 07:17:41], [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('103','1032','','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 07:17:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '103', 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 07:17:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '103', booking_detail_id = '1', rid = '112', room = '0', salutations = 'Mr', first_name = 'bhavesh', last_name = 'gurav', passenger_type = 'adult', age = '';
[11/28/2023 07:17:41], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '103', booking_detail_id = '1', rid = '112', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 07:17:42], [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_07_17_41_1701155861_59.json', 'e1p/28_11_2023/response_reservation_Deepak_T_07_17_41_1701155861_59.json', 'e1p/28_11_2023/response_header_reservation_Deepak_T_07_17_41_1701155861_59.json', 'expediapackage', '2023-11-28 07:17:42', '', '23f3c61fd12e1ebd9b9cca7fae7c2bab69b28d73680b4c65a511ef6e1745188a', '0');
[11/28/2023 07:17:42], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7906750466706', confirmation_number = '7906750466706', 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='81e7f2516cb3bfdcf3f67477ac2c72c8'  where id='103';
[11/28/2023 07:17:42], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='103';
[11/28/2023 07:17:42], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('103','18.950835','72.837922');
[11/28/2023 07:17:42], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Deepak_T',`create_date`= '2023-11-28 07:17:42',`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;103\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -103 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 07:17:42], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='337', `entity`='BookingId', `value`='103' ;
[11/28/2023 07:17:42], [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 ('1032','103','confirmed','2023-11-28 07:17:42','Booking confirmed. Booked by Back Office v3alpha on behalf of Agent - Deepak  trivedi(CA7857)','7857','43.239.53.130','0','7857');
[11/28/2023 07:17:42], [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('103','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 07:17:42','47.15');
[11/28/2023 07:17:42], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='103',status='1' where reservation_id='1032' and booking_id ='0';
[11/28/2023 07:17:42], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='103' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 07:17:42], [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 ='103',  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 07:17:42';
[11/28/2023 07:25:25], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:25' WHERE id= '158';
[11/28/2023 07:25:25], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 07:25:25',login_attempt=0 where id = '7865';
[11/28/2023 07:25:25], [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 07:25:25', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 07:25:26], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:26' WHERE id= '158';
[11/28/2023 07:25:31], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:31' WHERE id= '158';
[11/28/2023 07:25:32], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:32' WHERE id= '158';
[11/28/2023 07:25:33], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:33' WHERE id= '158';
[11/28/2023 07:25:35], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:35' WHERE id= '158';
[11/28/2023 07:25:36], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:36' WHERE id= '158';
[11/28/2023 07:25:42], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:42' WHERE id= '158';
[11/28/2023 07:25:42], [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/03/12' , departure_date = '2024/03/13' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 07:25:42' , 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 07:25:42], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:42' WHERE id= '158';
[11/28/2023 07:25:43], [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_07_25_42_1701156342_90.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_07_25_42_1701156342_90.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_25_42_1701156342_90.json', 'expedia', '2023-11-28 07:25:43', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:25:43], [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_07_25_42_1701156342_22.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_07_25_42_1701156342_22.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_25_42_1701156342_22.json', 'expedia', '2023-11-28 07:25:43', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:25:43], [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 07:25:42.753'
            , 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.782'
            , error_description = ''
            , memory_used = '16401160'
            WHERE id = '14815';
[11/28/2023 07:25:43], [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 07:25:42.753'
            , 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.967'
            , error_description = ''
            , memory_used = '33851408'
            WHERE id = '14816';
[11/28/2023 07:25:43], [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_07_25_42_1701156342_4.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_07_25_42_1701156342_4.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_25_42_1701156342_4.json', 'expediapackage', '2023-11-28 07:25:43', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:25:43], [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_07_25_42_1701156342_10.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_07_25_42_1701156342_10.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_25_42_1701156342_10.json', 'expediapackage', '2023-11-28 07:25:43', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:25:43], [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 07:25:42.753'
            , 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.240'
            , error_description = ''
            , memory_used = '16479128'
            WHERE id = '14817';
[11/28/2023 07:25:44], [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 07:25:42.753'
            , 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.420'
            , error_description = ''
            , memory_used = '34556688'
            WHERE id = '14818';
[11/28/2023 07:25:44], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:44' WHERE id= '158';
[11/28/2023 07:25:51], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:51' WHERE id= '158';
[11/28/2023 07:25:52], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:25:52' WHERE id= '158';
[11/28/2023 07:25:52], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701156352','43.239.53.130');
[11/28/2023 07:25:52], [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_07_25_52_1701156352_5.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_07_25_52_1701156352_5.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_07_25_52_1701156352_5.json', 'expediapackage', '2023-11-28 07:25:52', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:26:06], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:26:06' WHERE id= '158';
[11/28/2023 07:26:06], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701156366','43.239.53.130');
[11/28/2023 07:26:06], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:26:06' WHERE id= '158';
[11/28/2023 07:26:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1034', create_date = '2023-11-28 07:26:07', 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.14', display_currency_code = 'USD', native_room_rate = '19.14', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/03/12', check_out_date = '2024/03/13', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'test', leader_last_name = 'test', status_date = '2023-11-28 07:26:07';
[11/28/2023 07:26:07], [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 ('104','HOTEL RELAX','Relax Guest House','24311990','OT000812803','mumbai','expediapackage',NOW());
[11/28/2023 07:26:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='104'
		;
[11/28/2023 07:26:07], [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('104','1034','','1','2','0','-','','','24311990','Relax Guest House','0911, Syed Mukhri Street Katha Bazar, Masijd Bunder','91-0-9022952250','3.0','1','2024/03/12','2024/03/13','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0MzIwMDAwLzI0MzEyMDAwLzI0MzExOTkwLzY0M2RhMjhjX2IuanBn');
[11/28/2023 07:26:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '104', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Deluxe Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:19.140000000000001;s:25:"displayNightlyRateDisplay";s:152:"Rate - 19.14,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.3 USD, Marketing Fee - 1.3  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:19.239999999999998;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:19.140000000000001;}}', native_room_rate_total = '19.14', wh_room_rate_total = '19.24', display_room_rate_total = '19.14', number_of_rooms = '1';
[11/28/2023 07:26:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '104', booking_detail_id = '1', rid = '113', room = '0', salutations = 'Mr', first_name = 'test', last_name = 'test', passenger_type = 'adult', age = '';
[11/28/2023 07:26:07], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '104', booking_detail_id = '1', rid = '113', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 07:26:08], [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_07_26_07_1701156367_52.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_07_26_07_1701156367_52.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_07_26_07_1701156367_52.json', 'expediapackage', '2023-11-28 07:26:08', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:26:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7605732544969', confirmation_number = '7605732544969', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-03-10<br>If you cancel between 2024-03-10 12:30:00 and 2024-03-12 00:00:00 , you will be charged 19.24 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 10th of March 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-03-10 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='19.24',  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.14',  applicable_service_tax='0',  supplier_rate='19.14',  uid='87e52596f88164f34612655a2b139d89'  where id='104';
[11/28/2023 07:26:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='104';
[11/28/2023 07:26:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('104','18.95112099','72.83793084');
[11/28/2023 07:26:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 07:26:08',`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;104\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -104 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 07:26:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='338', `entity`='BookingId', `value`='104' ;
[11/28/2023 07:26:08], [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 ('1034','104','confirmed','2023-11-28 07:26:08','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 07:26:08], [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('104','2024-03-10 12:30:00','2024-03-10 12:30:00','2024-03-12 00:00:00','2024-03-12 00:00:00','19.14','19.24','0','2023-11-28 07:26:08','19.24');
[11/28/2023 07:26:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='104',status='1' where reservation_id='1034' and booking_id ='0';
[11/28/2023 07:26:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='104' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 07:26:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.3',  commission_tax='',  booking_id ='104',  supplier_tax='2.14',  supplier_base_fare='17',  supplier_commissionable_fare='1.3'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 07:26:08';
[11/28/2023 07:27:13], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:27:13' WHERE id= '158';
[11/28/2023 07:27:13], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 07:27:13',login_attempt=0 where id = '7865';
[11/28/2023 07:27:13], [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 07:27:13', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 07:27:13], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:27:13' WHERE id= '158';
[11/28/2023 07:27:17], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:27:17' WHERE id= '158';
[11/28/2023 07:27:23], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:27:23' WHERE id= '158';
[11/28/2023 07:27:23], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7865' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '31' , ip = '43.239.53.130' , city = 'mumbai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/02/14' , departure_date = '2024/02/15' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 07:27:23' , 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 07:27:24], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:27:24' WHERE id= '158';
[11/28/2023 07:27: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_07_27_24_1701156444_47.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_07_27_24_1701156444_47.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_27_24_1701156444_47.json', 'expedia', '2023-11-28 07:27:24', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:27:24], [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 07:27:24.220'
            , 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.661'
            , error_description = ''
            , memory_used = '15612392'
            WHERE id = '14821';
[11/28/2023 07:27: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', 'e1/28_11_2023/request_availability_Baysan_Tourism_wh_07_27_24_1701156444_77.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_07_27_24_1701156444_77.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_27_24_1701156444_77.json', 'expedia', '2023-11-28 07:27:25', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:27: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_07_27_24_1701156444_10.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_07_27_24_1701156444_10.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_27_24_1701156444_10.json', 'expediapackage', '2023-11-28 07:27:25', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:27:25], [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 07:27:24.220'
            , 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.047'
            , error_description = ''
            , memory_used = '15618736'
            WHERE id = '14823';
[11/28/2023 07:27:25], [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 07:27:24.220'
            , 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.087'
            , error_description = ''
            , memory_used = '32171296'
            WHERE id = '14822';
[11/28/2023 07:27: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_07_27_24_1701156444_60.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_07_27_24_1701156444_60.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_27_24_1701156444_60.json', 'expediapackage', '2023-11-28 07:27:27', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:27: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 07:27:24.220'
            , 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.831'
            , error_description = ''
            , memory_used = '32994592'
            WHERE id = '14824';
[11/28/2023 07:27:28], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:27:28' WHERE id= '158';
[11/28/2023 07:27:29], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:27:29' WHERE id= '158';
[11/28/2023 07:27:35], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:27:35' WHERE id= '158';
[11/28/2023 07:27:35], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:27:35' WHERE id= '158';
[11/28/2023 07:27:35], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701156455','43.239.53.130');
[11/28/2023 07:27: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_07_27_35_1701156455_51.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_07_27_35_1701156455_51.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_07_27_35_1701156455_51.json', 'expediapackage', '2023-11-28 07:27:36', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:27:49], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:27:49' WHERE id= '158';
[11/28/2023 07:27:49], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701156469','43.239.53.130');
[11/28/2023 07:27:49], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:27:49' WHERE id= '158';
[11/28/2023 07:27:50], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1036', create_date = '2023-11-28 07:27:50', 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.14', display_currency_code = 'USD', native_room_rate = '19.14', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2024/02/14', check_out_date = '2024/02/15', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'test', leader_last_name = 'test', status_date = '2023-11-28 07:27:50';
[11/28/2023 07:27:50], [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 ('105','HOTEL RELAX','Relax Guest House','24311990','OT000812803','mumbai','expediapackage',NOW());
[11/28/2023 07:27:50], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='105'
		;
[11/28/2023 07:27:50], [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('105','1036','','1','2','0','-','','','24311990','Relax Guest House','0911, Syed Mukhri Street Katha Bazar, Masijd Bunder','91-0-9022952250','3.0','1','2024/02/14','2024/02/15','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0MzIwMDAwLzI0MzEyMDAwLzI0MzExOTkwLzY0M2RhMjhjX2IuanBn');
[11/28/2023 07:27:50], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '105', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Deluxe Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Book now and save)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:"displayNightlyRate";d:19.140000000000001;s:25:"displayNightlyRateDisplay";s:152:"Rate - 19.14,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.3 USD, Marketing Fee - 1.3  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:19.239999999999998;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:19.140000000000001;}}', native_room_rate_total = '19.14', wh_room_rate_total = '19.24', display_room_rate_total = '19.14', number_of_rooms = '1';
[11/28/2023 07:27:50], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '105', booking_detail_id = '1', rid = '114', room = '0', salutations = 'Mr', first_name = 'test', last_name = 'test', passenger_type = 'adult', age = '';
[11/28/2023 07:27:50], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '105', booking_detail_id = '1', rid = '114', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 07:27:52], [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_07_27_50_1701156470_57.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_07_27_50_1701156470_57.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_07_27_50_1701156470_57.json', 'expediapackage', '2023-11-28 07:27:52', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:27:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7478320164766', confirmation_number = '7478320164766', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:29:59 on  2024-02-12<br>If you cancel between 2024-02-12 12:30:00 and 2024-02-14 00:00:00 , you will be charged 19.24 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 12th 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-12 12:30:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Ayman', sales_manager_id = '0', admin_booked = '0', email_id = 'bahvesh.gurav@qtechsoftware.com', leader_phone = '9876543212', agent_currency_multiplier = '1.00000', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free WiFi<br><br><b>Deal:</b> Book now and save,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'Ayman', customer_id = '', applied_multiplier='1.00000',  wh_applied_markup='0.5',  wh_agent_currency_multiplier='1.00000',  wh_agent_markup='0.5',  wh_agent_rate='19.24',  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.14',  applicable_service_tax='0',  supplier_rate='19.14',  uid='5e9ef2eb5397a8f7440f228cb8f80fe2'  where id='105';
[11/28/2023 07:27:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='105';
[11/28/2023 07:27:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('105','18.95112099','72.83793084');
[11/28/2023 07:27:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 07:27:52',`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;105\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -105 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 07:27:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='339', `entity`='BookingId', `value`='105' ;
[11/28/2023 07:27:52], [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 ('1036','105','confirmed','2023-11-28 07:27:52','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 07:27:52], [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('105','2024-02-12 12:30:00','2024-02-12 12:30:00','2024-02-14 00:00:00','2024-02-14 00:00:00','19.14','19.24','0','2023-11-28 07:27:52','19.24');
[11/28/2023 07:27:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='105',status='1' where reservation_id='1036' and booking_id ='0';
[11/28/2023 07:27:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='105' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 07:27:52], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.3',  commission_tax='',  booking_id ='105',  supplier_tax='2.14',  supplier_base_fare='17',  supplier_commissionable_fare='1.3'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 07:27:52';
[11/28/2023 07:37:23], [file name :-/home/otrams/public_html/beta/agent_login.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:37:23' WHERE id= '158';
[11/28/2023 07:37:23], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-11-28 07:37:23',login_attempt=0 where id = '7865';
[11/28/2023 07:37:23], [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 07:37:23', ip = '43.239.53.130', action = 'Login' ;
[11/28/2023 07:37:23], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:37:23' WHERE id= '158';
[11/28/2023 07:37:29], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:37:29' WHERE id= '158';
[11/28/2023 07:37:35], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:37:35' WHERE id= '158';
[11/28/2023 07:37:35], [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 = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-11-28 07:37:35' , 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 07:37:36], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:37:36' WHERE id= '158';
[11/28/2023 07:37: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_07_37_36_1701157056_5.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_07_37_36_1701157056_5.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_37_36_1701157056_5.json', 'expedia', '2023-11-28 07:37:37', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:37: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_07_37_36_1701157056_59.json', 'e1/28_11_2023/response_availability_Baysan_Tourism_wh_07_37_36_1701157056_59.json', 'e1/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_37_36_1701157056_59.json', 'expedia', '2023-11-28 07:37:37', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:37: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 07:37:36.643'
            , 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.824'
            , error_description = ''
            , memory_used = '16400632'
            WHERE id = '14830';
[11/28/2023 07:37: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=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 07:37:36.643'
            , 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.014'
            , error_description = ''
            , memory_used = '32408784'
            WHERE id = '14831';
[11/28/2023 07:37: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', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_07_37_36_1701157056_87.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_07_37_36_1701157056_87.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_37_36_1701157056_87.json', 'expediapackage', '2023-11-28 07:37:37', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:37: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', 'e1p/28_11_2023/request_availability_Baysan_Tourism_wh_07_37_36_1701157056_63.json', 'e1p/28_11_2023/response_availability_Baysan_Tourism_wh_07_37_36_1701157056_63.json', 'e1p/28_11_2023/response_header_availability_Baysan_Tourism_wh_07_37_36_1701157056_63.json', 'expediapackage', '2023-11-28 07:37:37', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:37:37], [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 07:37:36.643'
            , 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.215'
            , error_description = ''
            , memory_used = '16441368'
            WHERE id = '14832';
[11/28/2023 07:37: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 07:37:36.643'
            , 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.392'
            , error_description = ''
            , memory_used = '33931632'
            WHERE id = '14833';
[11/28/2023 07:37:38], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:37:38' WHERE id= '158';
[11/28/2023 07:37:46], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:37:46' WHERE id= '158';
[11/28/2023 07:37:46], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:37:46' WHERE id= '158';
[11/28/2023 07:37:46], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701157066','43.239.53.130');
[11/28/2023 07:37:47], [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_07_37_46_1701157066_86.json', 'e1p/28_11_2023/response_valuation_Baysan_Tourism_wh_07_37_46_1701157066_86.json', 'e1p/28_11_2023/response_header_valuation_Baysan_Tourism_wh_07_37_46_1701157066_86.json', 'expediapackage', '2023-11-28 07:37:47', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:38:08], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:38:08' WHERE id= '158';
[11/28/2023 07:38:08], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1701157088','43.239.53.130');
[11/28/2023 07:38:08], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:38:08' WHERE id= '158';
[11/28/2023 07:38:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '1038', create_date = '2023-11-28 07:38:09', 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.78', display_currency_code = 'USD', native_room_rate = '21.78', 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 = 'bhavesh', leader_last_name = 'bhavesh', status_date = '2023-11-28 07:38:09';
[11/28/2023 07:38:09], [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 ('106','HOTEL NIRMAL LODGING','Hotel Nirmal Lodging','24458893','OT000874159','mumbai','expediapackage',NOW());
[11/28/2023 07:38:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '31'
		WHERE
		id='106'
		;
[11/28/2023 07:38: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('106','1038','','1','2','0','-','','','24458893','Hotel Nirmal Lodging','MN Road Wadia Estate','91-8050890867','3.0','1','2024/01/10','2024/01/11','','https://baysantravel.astrabookings.com//cpf/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzI1MDAwMDAwLzI0NDYwMDAwLzI0NDU4OTAwLzI0NDU4ODkzLzEwMzhlZWU5X2IuanBn');
[11/28/2023 07:38:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '106', 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.780000000000001;s:25:"displayNightlyRateDisplay";s:154:"Rate - 21.78,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 1.87 USD, Marketing Fee - 1.87  USD Discount - 0  #expediapackage";s:13:"whNightlyRate";d:21.890000000000001;}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:21.780000000000001;}}', native_room_rate_total = '21.78', wh_room_rate_total = '21.89', display_room_rate_total = '21.78', number_of_rooms = '1';
[11/28/2023 07:38:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '106', booking_detail_id = '1', rid = '115', room = '0', salutations = 'Mr', first_name = 'bhavesh', last_name = 'bhavesh', passenger_type = 'adult', age = '';
[11/28/2023 07:38:09], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '106', booking_detail_id = '1', rid = '115', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[11/28/2023 07:38: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_Baysan_Tourism_wh_07_38_09_1701157089_76.json', 'e1p/28_11_2023/response_reservation_Baysan_Tourism_wh_07_38_09_1701157089_76.json', 'e1p/28_11_2023/response_header_reservation_Baysan_Tourism_wh_07_38_09_1701157089_76.json', 'expediapackage', '2023-11-28 07:38:10', '', 'c1663b895fd7df93842d9e081c88476290b7d2a54ca2eec5f58325a75d1b3007', '0');
[11/28/2023 07:38:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7762692949654', confirmation_number = '7762692949654', 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 21.89 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 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.89',  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.78',  applicable_service_tax='0',  supplier_rate='21.78',  uid='a6738c74776ce3c00493bd49925f7ff1'  where id='106';
[11/28/2023 07:38: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 ='106';
[11/28/2023 07:38:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('106','19.0727','72.8561');
[11/28/2023 07:38:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'Baysan_Tourism_wh',`create_date`= '2023-11-28 07:38: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;106\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -106 And Booking Status - confirmed',`ip`= '43.239.53.130';
[11/28/2023 07:38:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='340', `entity`='BookingId', `value`='106' ;
[11/28/2023 07:38: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 ('1038','106','confirmed','2023-11-28 07:38:10','Booking confirmed. Booked by Back Office Ayman on behalf of Agent - Baysan  Tourism(CD7863)','7863','43.239.53.130','0','7863');
[11/28/2023 07:38: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('106','2024-01-08 12:30:00','2024-01-08 12:30:00','2024-01-10 00:00:00','2024-01-10 00:00:00','21.78','21.89','0','2023-11-28 07:38:10','21.89');
[11/28/2023 07:38:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='106',status='1' where reservation_id='1038' and booking_id ='0';
[11/28/2023 07:38:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='106' where agent_logs_id='0' and source_type='expediapackage';
[11/28/2023 07:38:10], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='1.87',  commission_tax='',  booking_id ='106',  supplier_tax='2.36',  supplier_base_fare='19.42',  supplier_commissionable_fare='1.87'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-11-28 07:38:10';
[11/28/2023 07:40:11], [file name :-/home/otrams/public_html/beta/index.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:40:11' WHERE id= '158';
[11/28/2023 07:40:12], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-11-28 07:40:12' WHERE id= '158';
