[07/08/2024 06:00:40], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 06:00:40',login_attempt=0 where id = '949';
[07/08/2024 06:00:40], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-08 06:00:40', ip = '103.104.226.130', action = 'Login' ;
[07/08/2024 06:01:33], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/30' , departure_date = '2024/07/31' , nights = '1' , nationality = '106' , room_types = '2, 1' , room_type='[{"numberOfAdults":2},{"numberOfAdults":1}]' , available='0' , create_date = '2024-07-08 06:01:33' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/08/2024 06:01:34], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_01_34_17204184943.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_01_34_17204184943.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_01_34_17204184943.xml', 'jumbotours', '2024-07-08 06:01:34', '', '9490820240706013347054429311', '12727670', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_01_34_17204184943.xml');
[07/08/2024 06:01:35], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706013347054429311&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:01:34.142'
        , request_start_time = '0.024'
        , parsing_start_time = '0.736'
        , mapping_complete_time = '0.030'
        , mongo_start_time = '0.083'
        , search_end_time = '0.000'
        , total_duration = '0.895'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2530344'
        WHERE id = '157035010';
[07/08/2024 06:01:35], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_01_34_17204184942.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_01_34_17204184942.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_01_34_17204184942.xml', 'jumbotours', '2024-07-08 06:01:35', '', '9490820240706013347054429311', '12727670', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_01_34_17204184942.xml');
[07/08/2024 06:01:36], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_01_34_17204184940.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_01_34_17204184940.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_01_34_17204184940.xml', 'jumbotours', '2024-07-08 06:01:36', '', '9490820240706013347054429311', '12727670', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_01_34_17204184940.xml');
[07/08/2024 06:01:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706013347054429311&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:01:34.142'
        , request_start_time = '0.026'
        , parsing_start_time = '1.706'
        , mapping_complete_time = '0.323'
        , mongo_start_time = '0.631'
        , search_end_time = '0.000'
        , total_duration = '2.413'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '27201696'
        WHERE id = '157035011';
[07/08/2024 06:01:36], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706013347054429311&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:01:34.141'
        , request_start_time = '0.017'
        , parsing_start_time = '1.851'
        , mapping_complete_time = '0.503'
        , mongo_start_time = '0.843'
        , search_end_time = '0.000'
        , total_duration = '2.770'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '38878032'
        WHERE id = '157035012';
[07/08/2024 06:01:42], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_01_34_17204184941.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_01_34_17204184941.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_01_34_17204184941.xml', 'jumbotours', '2024-07-08 06:01:42', '', '9490820240706013347054429311', '12727670', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_01_34_17204184941.xml');
[07/08/2024 06:01:43], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706013347054429311&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:01:34.142'
        , request_start_time = '0.013'
        , parsing_start_time = '8.636'
        , mapping_complete_time = '0.432'
        , mongo_start_time = '0.809'
        , search_end_time = '0.000'
        , total_duration = '9.520'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '35772280'
        WHERE id = '157035013';
[07/08/2024 06:01:43], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '93',
        request_path = '/xml_all.php?userid=949&sessionid=9490820240706013347054429311',
        duration = '9.694',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '2.68',
        system_load_5_min = '3.58',
        system_load_15_min = '3.23',
        system_memory_usage = '60.87',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727670') + '2400032',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727670';
[07/08/2024 06:02:07], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:04:07], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720418647','103.104.226.130');
[07/08/2024 06:04:08], [file name :-/efsdata/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,file_path) VALUE ('', 'VALUATION', 'j2/08_07_2024/request_valuation_yogeshqtech_06_04_07_1720418647.xml', 'j2/08_07_2024/response_valuation_yogeshqtech_06_04_07_1720418647.xml', 'j2/08_07_2024/response_header_valuation_yogeshqtech_06_04_07_1720418647.xml', 'jumbotours', '2024-07-08 06:04:08', '', '9490820240706013347054429311', '12727670', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_valuation_yogeshqtech_06_04_07_1720418647.xml');
[07/08/2024 06:04:59], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720418699','103.104.226.130');
[07/08/2024 06:05:00], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'jumbotours', reservation_id = '1877211', create_date = '2024-07-08 06:05:00', agent_id = '949', parent_agent_id = '949', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', booking_branch_id = '1', is_xml = '0', display_room_rate = '76.2', display_currency_code = 'USD', native_room_rate = '72.58', native_currency_code = 'USD', supplier_profile_id = '27', service_type = 'hotel', service_date = '2024/07/30', check_out_date = '2024/07/31', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Sup', leader_last_name = 'Gangawane', status_date = '2024-07-08 06:05:00';
[07/08/2024 06:05:00], [file name :-/efsdata/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 ('132979','ROVE HEALTHCARE CITY','NA','738391','OT000631572','dubai','jumbotours',NOW());
[07/08/2024 06:05:00], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='132979'
		;
[07/08/2024 06:05:00], [file name :-/efsdata/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('132979','1877211','','2','3','0','-','','','738391','ROVE HEALTHCARE CITY','19th Street, Oud Metha','','3.0','1','2024/07/30','2024/07/31','','https://i.travelapi.com/lodging/17000000/16710000/16700600/16700525/cbc9f26f_b.jpg');
[07/08/2024 06:05:00], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132979', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'ROVER ROOM ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:38.100000000000001;s:25:"displayNightlyRateDisplay";s:159:"Rate - 36.29, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:36.289999999999999;}}', native_room_rate_total = '36.29', display_room_rate_total = '38.1', number_of_rooms = '1', room_category = 'Double ROVER ROOM', meal_basis = 'ROOM ONLY';
[07/08/2024 06:05:00], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132979', booking_detail_id = '1', rid = '145742', room = '0', salutations = 'Mr', first_name = 'Sup', last_name = 'Gangawane', passenger_type = 'adult', age = '';
[07/08/2024 06:05:00], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132979', booking_detail_id = '1', rid = '145742', room = '0', salutations = 'Mr', first_name = 'Aji', last_name = 'Gangawane', passenger_type = 'adult', age = '';
[07/08/2024 06:05:00], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132979', booking_detail_id = '1', room_type_code = '', room_name = 'single', room_type_description = 'ROVER ROOM ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:38.100000000000001;s:25:"displayNightlyRateDisplay";s:159:"Rate - 36.29, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:36.289999999999999;}}', native_room_rate_total = '36.29', display_room_rate_total = '38.1', number_of_rooms = '1', room_category = 'Single ROVER ROOM', meal_basis = 'ROOM ONLY';
[07/08/2024 06:05:00], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132979', booking_detail_id = '1', rid = '145743', room = '0', salutations = 'Mr', first_name = 'Pranali', last_name = 'Mhatre', passenger_type = 'adult', age = '';
[07/08/2024 06:05:14], [file name :-/efsdata/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,file_path) VALUE ('', 'RESERVATION', 'j2/08_07_2024/request_reservation_yogeshqtech_06_05_00_1720418700.xml', 'j2/08_07_2024/response_reservation_yogeshqtech_06_05_00_1720418700.xml', 'j2/08_07_2024/response_header_reservation_yogeshqtech_06_05_00_1720418700.xml', 'jumbotours', '2024-07-08 06:05:14', '', '9490820240706013347054429311', '12727670', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_reservation_yogeshqtech_06_05_00_1720418700.xml');
[07/08/2024 06:05:14], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '8681173613', display_discount = '0', native_discount = '0', cancellation_policy = '<b>ROVER ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-27 05:29:59<br>If you cancel between 2024-07-27 05:30:00 and 2024-07-30 00:00:00 , you will be charged 38.1 USD<br><b>ROVER ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-27 05:29:59<br>If you cancel between 2024-07-27 05:30:00 and 2024-07-30 00:00:00 , you will be charged 38.1 USD<br>No show is subject to a 100.0% 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 05:30 on 27th of July 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-07-27 00:00:00', comment_contract = ' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ADDITIONAL INFO: 1 CC BB - Rate inclusive of BreakfastADDITIONAL INFO: 1 CC BAR - Room only rate<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed Tax ID - 100256339100003 This property accepts credit cards, debit cards, and cash This property reserves the right to pre-authorize the guest\'s credit card prior to arrival. Cashless transactions are available Please note that cultural norms and guest policies may differ by country and by property; the policies listed are provided by the property Please note: Guestrooms are equipped with single sofa beds, suitable for children only. This property offers transfers from the airport (surcharges may apply). To arrange pick-up, guests must contact the property 24 hours prior to arrival, using the contact information on the booking confirmation. Front desk staff will greet guests on arrival. For more details, please contact the property using the information on the booking confirmation. The credit card used to book the reservation must be presented by the cardholder at check-in. All guests, including children, must present valid passport or UAE/GCC National identification at check-in.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: A tax is imposed by the city: AED 10.00 per accommodation, per night We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for continental breakfast: approximately AED 59 per person Airport shuttle fee: AED 210 per vehicle (maximum occupancy 4) The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: One child 16 years old or younger stays free when occupying the parent or guardian\'s room, using existing bedding. Only registered guests are allowed in the guestrooms. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. Cashless payment methods are available for all transactions.', consultant_id = 'Bhavesh_qtech', sales_manager_id = '', admin_booked = '0', email_id = 'supriya@gmail.com', leader_phone = '9987204292', agent_currency_multiplier = '1.00000', ip_addr = '103.104.226.130', comment_contract = ' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ADDITIONAL INFO: 1 CC BB - Rate inclusive of BreakfastADDITIONAL INFO: 1 CC BAR - Room only rate<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed Tax ID - 100256339100003 This property accepts credit cards, debit cards, and cash This property reserves the right to pre-authorize the guest\'s credit card prior to arrival. Cashless transactions are available Please note that cultural norms and guest policies may differ by country and by property; the policies listed are provided by the property Please note: Guestrooms are equipped with single sofa beds, suitable for children only. This property offers transfers from the airport (surcharges may apply). To arrange pick-up, guests must contact the property 24 hours prior to arrival, using the contact information on the booking confirmation. Front desk staff will greet guests on arrival. For more details, please contact the property using the information on the booking confirmation. The credit card used to book the reservation must be presented by the cardholder at check-in. All guests, including children, must present valid passport or UAE/GCC National identification at check-in.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: A tax is imposed by the city: AED 10.00 per accommodation, per night We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for continental breakfast: approximately AED 59 per person Airport shuttle fee: AED 210 per vehicle (maximum occupancy 4) The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: One child 16 years old or younger stays free when occupying the parent or guardian\'s room, using existing bedding. Only registered guests are allowed in the guestrooms. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. Cashless payment methods are available for all transactions.', backoffice_user = 'Qtech_pranali', customer_id = '', applied_multiplier='1.00000',  applied_markup='4.99',  agent_markup='4.99',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='949',  sub_agent_rate='0',  agent_rate='76.2',  applicable_service_tax='0',  supplier_rate='72.58',  uid='e72c28aab10f9e5d56c38625aea9d567'  where id='132979';
[07/08/2024 06:05:14], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='132979';
[07/08/2024 06:05:14], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '132979' , sr_id = '6' ;
[07/08/2024 06:05:14], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('132979','25.234132539839','55.314431495701');
[07/08/2024 06:05:14], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'yogeshqtech',`create_date`= '2024-07-08 06:05:14',`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;132979\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -132979 And Booking Status - confirmed',`ip`= '103.104.226.130';
[07/08/2024 06:05:14], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='1', `entity`='BookingId', `value`='132979' ;
[07/08/2024 06:05:14], [file name :-/efsdata/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 ('1877211','132979','confirmed','2024-07-08 06:05:14','Booking confirmed. Booked by Back Office Qtech_pranali on behalf of Agent - Deepak  Trivedi(CD0949)','949','103.104.226.130','0','949');
[07/08/2024 06:05:14], [file name :-/efsdata/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('132979','2024-07-27 05:30:00','2024-07-28 05:30:00','2024-07-30 00:00:00','2024-07-31 00:00:00','36.29','38.1','24','2024-07-08 06:05:14','38.1');
[07/08/2024 06:05:14], [file name :-/efsdata/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('132979','2024-07-27 05:30:00','2024-07-28 05:30:00','2024-07-30 00:00:00','2024-07-31 00:00:00','36.29','38.1','24','2024-07-08 06:05:14','38.1');
[07/08/2024 06:05:14], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='132979',status='1' where reservation_id='1877211' and booking_id ='0';
[07/08/2024 06:05:14], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='132979' where agent_logs_id='12727670' and source_type='jumbotours';
[07/08/2024 06:05:16], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132979','deepak.trivedi@qtechsoftware.com');
[07/08/2024 06:05:16], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132979','demo@demo.demo');
[07/08/2024 06:05:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132979','ops@astrabookings.com');
[07/08/2024 06:05:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132979','info@astrabookings.com');
[07/08/2024 06:05:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132979','ops@astrabookings.com');
[07/08/2024 06:07:24], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:07:30], [file name :-/efsdata/otrams/public_html/beta/get_cancellation_fee.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('132979', 'CANCELLATION_FEE', 'j2/08_07_2024/request_CANCELLATION_FEE_yogeshqtech_132979_06_07_29_1720418849.xml', 'j2/08_07_2024/response_CANCELLATION_FEE_yogeshqtech_132979_06_07_29_1720418849.xml', 'j2/08_07_2024/response_header_CANCELLATION_FEE_yogeshqtech_132979_06_07_29_1720418849.xml', 'jumbotours', '2024-07-08 06:07:30', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_CANCELLATION_FEE_yogeshqtech_132979_06_07_29_1720418849.xml');
[07/08/2024 06:07:41], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('132979', 'CANCEL', 'j2/08_07_2024/request_cancel_yogeshqtech_132979_06_07_31_1720418851.xml', 'j2/08_07_2024/response_cancel_yogeshqtech_132979_06_07_31_1720418851.xml', 'j2/08_07_2024/response_header_cancel_yogeshqtech_132979_06_07_31_1720418851.xml', 'jumbotours', '2024-07-08 06:07:41', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_cancel_yogeshqtech_132979_06_07_31_1720418851.xml');
[07/08/2024 06:07:41], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO history_bookings set history_booking_id ='132979', agent_id ='949', itenirary_id ='', confirmation_number ='8681173613', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='supriya@gmail.com', leader_title ='Mr', leader_first_name ='Sup', leader_last_name ='Gangawane', city_id ='dubai', country_id ='138', display_room_rate ='76.200', native_room_rate ='72.580', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='<b>ROVER ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-27 05:29:59<br>If you cancel between 2024-07-27 05:30:00 and 2024-07-30 00:00:00 , you will be charged 38.1 USD<br><b>ROVER ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-27 05:29:59<br>If you cancel between 2024-07-27 05:30:00 and 2024-07-30 00:00:00 , you will be charged 38.1 USD<br>No show is subject to a 100.0% 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 05:30 on 27th of July 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2024-07-08 06:05:00', create_date ='2024-07-08 06:05:00', source_type ='jumbotours', expiration_date ='2024-07-27 00:00:00', comment_contract =' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ADDITIONAL INFO: 1 CC BB - Rate inclusive of BreakfastADDITIONAL INFO: 1 CC BAR - Room only rate<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed Tax ID - 100256339100003 This property accepts credit cards, debit cards, and cash This property reserves the right to pre-authorize the guest\'s credit card prior to arrival. Cashless transactions are available Please note that cultural norms and guest policies may differ by country and by property; the policies listed are provided by the property Please note: Guestrooms are equipped with single sofa beds, suitable for children only. This property offers transfers from the airport (surcharges may apply). To arrange pick-up, guests must contact the property 24 hours prior to arrival, using the contact information on the booking confirmation. Front desk staff will greet guests on arrival. For more details, please contact the property using the information on the booking confirmation. The credit card used to book the reservation must be presented by the cardholder at check-in. All guests, including children, must present valid passport or UAE/GCC National identification at check-in.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: A tax is imposed by the city: AED 10.00 per accommodation, per night We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for continental breakfast: approximately AED 59 per person Airport shuttle fee: AED 210 per vehicle (maximum occupancy 4) The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: One child 16 years old or younger stays free when occupying the parent or guardian\'s room, using existing bedding. Only registered guests are allowed in the guestrooms. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. Cashless payment methods are available for all transactions.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='76.200', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='72.580', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Bhavesh_qtech', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='4.99', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='4.99', wh_agent_markup ='0.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2024-07-08 06:07:41', modified_by ='', display_currency_code ='USD', created_datetime ='2024-07-08 06:07:41', sub_agent_rate ='0.000', created_by ='yogeshqtech', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='103.104.226.130', is_cancel_history ='1';
[07/08/2024 06:07:41], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','132979','cancelled','2024-07-08 06:07:41','','949','103.104.226.130','','','');
[07/08/2024 06:07:41], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],UPDATE bookings SET current_status='cancelled',status_date='2024-07-08 06:07:41' , pending_cancellation = 'no' WHERE reservation_id = '1877211' AND id = '132979' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[07/08/2024 06:07:41], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update booking_commission set status='D'  where booking_id ='132979';
[07/08/2024 06:07:41], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='' , applicable_service_tax='0' WHERE id = '132979' AND (current_status = 'cancelled' ) ;
[07/08/2024 06:07:41], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],delete from cancellations where booking_id =? ;
[07/08/2024 06:07:41], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO cancellations (native_charge,display_charge,native_currency_code,display_currency_code,reservation_id,booking_id,cancellation_date,confirmation_no,note) values ('','0','USD','USD','1877211','132979','2024-07-08 06:07:41','',' ');
[07/08/2024 06:07:43], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:07:45], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132979','deepak.trivedi@qtechsoftware.com');
[07/08/2024 06:07:45], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132979','demo@demo.demo');
[07/08/2024 06:07:48], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132979','ops@astrabookings.com');
[07/08/2024 06:07:48], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132979','info@astrabookings.com');
[07/08/2024 06:07:48], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132979','ops@astrabookings.com');
[07/08/2024 06:07:52], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:07:54], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '77' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '89' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '102' ,status = '' ,priority = '12' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '12';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '76' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '98' ,status = '' ,priority = '15' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '15';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '58' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '99' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '86' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '74' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '75' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '96' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '56' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '60' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '84' ,status = '1' ,priority = '5' ,lead_time = '24',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '5';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '67' ,status = '' ,priority = '25' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '25';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '1' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '101' ,status = '' ,priority = '' ,lead_time = '72',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '73' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '85' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '100' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '93' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '57' ,status = '' ,priority = '' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '97' ,status = '' ,priority = '9' ,lead_time = '0',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '9';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '81' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '78' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '83' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '68' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '90' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '66' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '64' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '65' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '949',supplier_id = '69' ,status = '' ,priority = '14' ,lead_time = '96',branch_id = '',visible_supplier_on_voucher = '0',pricing_profile_id = '14';
[07/08/2024 06:11:50], [file name :-/efsdata/otrams/public_html/beta/tms/agent.php],insert into `user_logs` set `username`= 'Qtech_pranali',`create_date`= '2024-07-08 06:11:50',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 77 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 89 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 102 ,status = \&#039;\&#039; ,priority = \&#039;12\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;12\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 76 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 98 ,status = \&#039;\&#039; ,priority = \&#039;15\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;15\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 58 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 99 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 86 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 74 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 75 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 96 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 56 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 60 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 84 ,status = \&#039;1\&#039; ,priority = \&#039;5\&#039; ,lead_time = \&#039;24\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;5\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 67 ,status = \&#039;\&#039; ,priority = \&#039;25\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;25\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 1 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 101 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;72\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 73 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 85 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 100 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 93 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 57 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 97 ,status = \&#039;\&#039; ,priority = \&#039;9\&#039; ,lead_time = \&#039;0\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;9\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 81 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 78 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 83 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 68 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 90 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 66 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 64 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 65 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;949\&#039;,supplier_id = 69 ,status = \&#039;\&#039; ,priority = \&#039;14\&#039; ,lead_time = \&#039;96\&#039;,branch_id = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,pricing_profile_id = \&#039;14\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-949 ## supplier_id- 84 ## company_name - Jumbotours ## supplier_code-jumbotours  ## percentage - 0.00 ## lead_time - 24 ',`ip`= '103.104.226.130';
[07/08/2024 06:11:55], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 06:11:55',login_attempt=0 where id = '949';
[07/08/2024 06:11:55], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-08 06:11:55', ip = '103.104.226.130', action = 'Login' ;
[07/08/2024 06:12:12], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/09' , departure_date = '2024/07/10' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 06:12:12' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/08/2024 06:12:13], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_12_12_17204191323.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_12_12_17204191323.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_12_12_17204191323.xml', 'jumbotours', '2024-07-08 06:12:13', '', '9490820240706121278129004409', '12727865', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_12_12_17204191323.xml');
[07/08/2024 06:12:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706121278129004409&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:12:12.851'
        , request_start_time = '0.021'
        , parsing_start_time = '1.008'
        , mapping_complete_time = '0.034'
        , mongo_start_time = '0.091'
        , search_end_time = '0.000'
        , total_duration = '1.166'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2981552'
        WHERE id = '157036698';
[07/08/2024 06:12:14], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_12_12_17204191322.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_12_12_17204191322.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_12_12_17204191322.xml', 'jumbotours', '2024-07-08 06:12:14', '', '9490820240706121278129004409', '12727865', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_12_12_17204191322.xml');
[07/08/2024 06:12:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706121278129004409&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:12:12.849'
        , request_start_time = '0.008'
        , parsing_start_time = '1.865'
        , mapping_complete_time = '0.172'
        , mongo_start_time = '0.321'
        , search_end_time = '0.000'
        , total_duration = '2.258'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '16077256'
        WHERE id = '157036699';
[07/08/2024 06:12:15], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_12_12_17204191321.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_12_12_17204191321.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_12_12_17204191321.xml', 'jumbotours', '2024-07-08 06:12:15', '', '9490820240706121278129004409', '12727865', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_12_12_17204191321.xml');
[07/08/2024 06:12:15], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706121278129004409&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:12:12.851'
        , request_start_time = '0.011'
        , parsing_start_time = '2.694'
        , mapping_complete_time = '0.127'
        , mongo_start_time = '0.260'
        , search_end_time = '0.000'
        , total_duration = '3.021'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '12404624'
        WHERE id = '157036700';
[07/08/2024 06:12:22], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_12_12_17204191320.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_12_12_17204191320.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_12_12_17204191320.xml', 'jumbotours', '2024-07-08 06:12:22', '', '9490820240706121278129004409', '12727865', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_12_12_17204191320.xml');
[07/08/2024 06:12:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706121278129004409&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:12:12.850'
        , request_start_time = '0.008'
        , parsing_start_time = '10.019'
        , mapping_complete_time = '0.111'
        , mongo_start_time = '0.223'
        , search_end_time = '0.000'
        , total_duration = '10.321'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '10807608'
        WHERE id = '157036701';
[07/08/2024 06:12:23], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '140',
        request_path = '/xml_all.php?userid=949&sessionid=9490820240706121278129004409',
        duration = '10.436',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.90',
        system_load_5_min = '2.46',
        system_load_15_min = '2.83',
        system_memory_usage = '61.81',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727865') + '2398016',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727865';
[07/08/2024 06:12:26], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 06:12:26',login_attempt=0 where id = '949';
[07/08/2024 06:12:26], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-08 06:12:26', ip = '103.104.226.130', action = 'Login' ;
[07/08/2024 06:12:53], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/19' , departure_date = '2024/07/20' , nights = '1' , nationality = '106' , room_types = '2, 3' , room_type='[{"numberOfAdults":3},{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 06:12:53' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/08/2024 06:12:56], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_12_55_17204191753.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_12_55_17204191753.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_12_55_17204191753.xml', 'jumbotours', '2024-07-08 06:12:56', '', '9490820240706125385208534264', '12727907', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_12_55_17204191753.xml');
[07/08/2024 06:12:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706125385208534264&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:12:55.436'
        , request_start_time = '0.022'
        , parsing_start_time = '0.562'
        , mapping_complete_time = '0.022'
        , mongo_start_time = '0.025'
        , search_end_time = '0.000'
        , total_duration = '0.669'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '1802144'
        WHERE id = '157036807';
[07/08/2024 06:12:56], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_12_55_17204191750.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_12_55_17204191750.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_12_55_17204191750.xml', 'jumbotours', '2024-07-08 06:12:56', '', '9490820240706125385208534264', '12727907', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_12_55_17204191750.xml');
[07/08/2024 06:12:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706125385208534264&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:12:55.435'
        , request_start_time = '0.010'
        , parsing_start_time = '0.907'
        , mapping_complete_time = '0.152'
        , mongo_start_time = '0.285'
        , search_end_time = '0.000'
        , total_duration = '1.275'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '13050392'
        WHERE id = '157036808';
[07/08/2024 06:13:01], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_12_55_17204191752.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_12_55_17204191752.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_12_55_17204191752.xml', 'jumbotours', '2024-07-08 06:13:01', '', '9490820240706125385208534264', '12727907', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_12_55_17204191752.xml');
[07/08/2024 06:13:01], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_12_55_17204191751.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_12_55_17204191751.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_12_55_17204191751.xml', 'jumbotours', '2024-07-08 06:13:01', '', '9490820240706125385208534264', '12727907', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_12_55_17204191751.xml');
[07/08/2024 06:13:01], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706125385208534264&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:12:55.436'
        , request_start_time = '0.021'
        , parsing_start_time = '5.544'
        , mapping_complete_time = '0.155'
        , mongo_start_time = '0.277'
        , search_end_time = '0.000'
        , total_duration = '5.902'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '12820840'
        WHERE id = '157036809';
[07/08/2024 06:13:01], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240706125385208534264&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:12:55.436'
        , request_start_time = '0.018'
        , parsing_start_time = '5.746'
        , mapping_complete_time = '0.197'
        , mongo_start_time = '0.351'
        , search_end_time = '0.000'
        , total_duration = '6.180'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '16676480'
        WHERE id = '157036810';
[07/08/2024 06:13:01], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '64',
        request_path = '/xml_all.php?userid=949&sessionid=9490820240706125385208534264',
        duration = '6.290',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.56',
        system_load_5_min = '2.31',
        system_load_15_min = '2.77',
        system_memory_usage = '61.81',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727907') + '2238992',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727907';
[07/08/2024 06:13:33], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720419213','103.104.226.130');
[07/08/2024 06:13:35], [file name :-/efsdata/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,file_path) VALUE ('', 'VALUATION', 'j2/08_07_2024/request_valuation_yogeshqtech_06_13_33_1720419213.xml', 'j2/08_07_2024/response_valuation_yogeshqtech_06_13_33_1720419213.xml', 'j2/08_07_2024/response_header_valuation_yogeshqtech_06_13_33_1720419213.xml', 'jumbotours', '2024-07-08 06:13:35', '', '9490820240706125385208534264', '12727907', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_valuation_yogeshqtech_06_13_33_1720419213.xml');
[07/08/2024 06:14:54], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720419294','103.104.226.130');
[07/08/2024 06:14:56], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'jumbotours', reservation_id = '1877216', create_date = '2024-07-08 06:14:56', agent_id = '949', parent_agent_id = '949', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', booking_branch_id = '1', is_xml = '0', display_room_rate = '94.94', display_currency_code = 'USD', native_room_rate = '90.42', native_currency_code = 'USD', supplier_profile_id = '27', service_type = 'hotel', service_date = '2024/07/19', check_out_date = '2024/07/20', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'test', leader_last_name = 'test', status_date = '2024-07-08 06:14:56';
[07/08/2024 06:14:56], [file name :-/efsdata/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 ('132981','ALOFT AL MINA, DUBAI','NA','2175182','OT001282376','dubai','jumbotours',NOW());
[07/08/2024 06:14:56], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='132981'
		;
[07/08/2024 06:14:56], [file name :-/efsdata/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('132981','1877216','','2','5','0','-','','','2175182','ALOFT AL MINA, DUBAI','Sheikh Rashid Road & 37th Street','','4.0','1','2024/07/19','2024/07/20','','https://i.travelapi.com/lodging/67000000/66260000/66252500/66252432/c245db44_b.jpg');
[07/08/2024 06:14:56], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132981', booking_detail_id = '1', room_type_code = '', room_name = 'triple', room_type_description = 'ALOFT, GUEST ROOM, 1 KING - <font color=\'red\'>PACKAGE RATE</font> ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:47.469999999999999;s:25:"displayNightlyRateDisplay";s:159:"Rate - 45.21, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:45.210000000000001;}}', native_room_rate_total = '45.21', display_room_rate_total = '47.47', number_of_rooms = '1', room_category = 'Triple ALOFT, GUEST ROOM, 1 KING - <font color=\'red\'>PACKAGE RATE</font>', meal_basis = 'ROOM ONLY';
[07/08/2024 06:14:56], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132981', booking_detail_id = '1', rid = '145745', room = '0', salutations = 'Mr', first_name = 'test', last_name = 'test', passenger_type = 'adult', age = '';
[07/08/2024 06:14:56], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132981', booking_detail_id = '1', rid = '145745', room = '0', salutations = 'Mr', first_name = 'test one', last_name = 'test', passenger_type = 'adult', age = '';
[07/08/2024 06:14:56], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132981', booking_detail_id = '1', rid = '145745', room = '0', salutations = 'Mr', first_name = 'test two', last_name = 'test', passenger_type = 'adult', age = '';
[07/08/2024 06:14:56], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132981', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'ALOFT, GUEST ROOM, 1 KING - <font color=\'red\'>PACKAGE RATE</font> ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:47.469999999999999;s:25:"displayNightlyRateDisplay";s:159:"Rate - 45.21, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:45.210000000000001;}}', native_room_rate_total = '45.21', display_room_rate_total = '47.47', number_of_rooms = '1', room_category = 'Double ALOFT, GUEST ROOM, 1 KING - <font color=\'red\'>PACKAGE RATE</font>', meal_basis = 'ROOM ONLY';
[07/08/2024 06:14:56], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132981', booking_detail_id = '1', rid = '145746', room = '0', salutations = 'Mr', first_name = 'testing', last_name = 'test', passenger_type = 'adult', age = '';
[07/08/2024 06:14:56], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132981', booking_detail_id = '1', rid = '145746', room = '0', salutations = 'Mr', first_name = 'testing one', last_name = 'test', passenger_type = 'adult', age = '';
[07/08/2024 06:15:08], [file name :-/efsdata/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,file_path) VALUE ('', 'RESERVATION', 'j2/08_07_2024/request_reservation_yogeshqtech_06_14_56_1720419296.xml', 'j2/08_07_2024/response_reservation_yogeshqtech_06_14_56_1720419296.xml', 'j2/08_07_2024/response_header_reservation_yogeshqtech_06_14_56_1720419296.xml', 'jumbotours', '2024-07-08 06:15:08', '', '9490820240706125385208534264', '12727907', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_reservation_yogeshqtech_06_14_56_1720419296.xml');
[07/08/2024 06:15:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '8791173614', display_discount = '0', native_discount = '0', cancellation_policy = '<b>ALOFT, GUEST ROOM, 1 KING - <font color=\'red\'>PACKAGE RATE</font> ROOM ONLY </b> - <font color=\'red\'>Package Rate</font><br>Free cancellation up to 2024-07-16 05:29:59<br>If you cancel between 2024-07-16 05:30:00 and 2024-07-19 00:00:00 , you will be charged 47.47 USD<br><b>ALOFT, GUEST ROOM, 1 KING - <font color=\'red\'>PACKAGE RATE</font> ROOM ONLY </b> - <font color=\'red\'>Package Rate</font><br>Free cancellation up to 2024-07-16 05:29:59<br>If you cancel between 2024-07-16 05:30:00 and 2024-07-19 00:00:00 , you will be charged 47.47 USD<br>No show is subject to a 100.0% 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 05:30 on 16th of July 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-07-16 00:00:00', comment_contract = ' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ADDITIONAL INFO: Tour Operator Dynamic Rate, Tour Operator Dynamic, Book or change or cancel only by Tour Operators<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed The name on the credit card used at check-in to pay for incidentals must be the primary name on the guestroom reservation This property accepts credit cards, debit cards, mobile payments, and cash Mobile payment options include: Google Pay, Apple Pay, and PayPay This property reserves the right to pre-authorize the guest\'s credit card prior to arrival. Cashless transactions are available This property affirms that it follows the cleaning and disinfection practices of Commitment to Clean (Marriott) Front desk staff will greet guests on arrival.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: A tax is imposed by the city: AED 15.00 per accommodation, per night We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for buffet breakfast: approximately AED 45 per person Rollaway bed fee: AED 100.0 per night The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: Reservations are required for massage services and spa treatments. Reservations can be made by contacting the hotel prior to arrival, using the contact information on the booking confirmation. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. No pets and no service animals are allowed at this property. Cashless payment methods are available for all transactions. Contactless check-in and contactless check-out are available.', consultant_id = 'Bhavesh_qtech', sales_manager_id = '', admin_booked = '0', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '103.104.226.130', comment_contract = ' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ADDITIONAL INFO: Tour Operator Dynamic Rate, Tour Operator Dynamic, Book or change or cancel only by Tour Operators<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed The name on the credit card used at check-in to pay for incidentals must be the primary name on the guestroom reservation This property accepts credit cards, debit cards, mobile payments, and cash Mobile payment options include: Google Pay, Apple Pay, and PayPay This property reserves the right to pre-authorize the guest\'s credit card prior to arrival. Cashless transactions are available This property affirms that it follows the cleaning and disinfection practices of Commitment to Clean (Marriott) Front desk staff will greet guests on arrival.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: A tax is imposed by the city: AED 15.00 per accommodation, per night We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for buffet breakfast: approximately AED 45 per person Rollaway bed fee: AED 100.0 per night The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: Reservations are required for massage services and spa treatments. Reservations can be made by contacting the hotel prior to arrival, using the contact information on the booking confirmation. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. No pets and no service animals are allowed at this property. Cashless payment methods are available for all transactions. Contactless check-in and contactless check-out are available.', backoffice_user = 'Qtech_pranali', customer_id = '', applied_multiplier='1.00000',  applied_markup='5',  agent_markup='5',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='949',  sub_agent_rate='0',  agent_rate='94.94',  applicable_service_tax='0',  supplier_rate='90.42',  uid='25a1665d455e6d4c08b8a0e0cfff9f0e'  where id='132981';
[07/08/2024 06:15:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='132981';
[07/08/2024 06:15:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '132981' , sr_id = '6' ;
[07/08/2024 06:15:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('132981','25.248623186714','55.283909639193');
[07/08/2024 06:15:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'yogeshqtech',`create_date`= '2024-07-08 06:15: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;132981\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -132981 And Booking Status - confirmed',`ip`= '103.104.226.130';
[07/08/2024 06:15:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='1', `entity`='BookingId', `value`='132981' ;
[07/08/2024 06:15:08], [file name :-/efsdata/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 ('1877216','132981','confirmed','2024-07-08 06:15:08','Booking confirmed. Booked by Back Office Qtech_pranali on behalf of Agent - Deepak  Trivedi(CD0949)','949','103.104.226.130','0','949');
[07/08/2024 06:15:08], [file name :-/efsdata/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('132981','2024-07-16 05:30:00','2024-07-17 05:30:00','2024-07-19 00:00:00','2024-07-20 00:00:00','45.21','47.47','24','2024-07-08 06:15:08','47.47');
[07/08/2024 06:15:08], [file name :-/efsdata/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('132981','2024-07-16 05:30:00','2024-07-17 05:30:00','2024-07-19 00:00:00','2024-07-20 00:00:00','45.21','47.47','24','2024-07-08 06:15:08','47.47');
[07/08/2024 06:15:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='132981',status='1' where reservation_id='1877216' and booking_id ='0';
[07/08/2024 06:15:08], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='132981' where agent_logs_id='12727907' and source_type='jumbotours';
[07/08/2024 06:15:10], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132981','deepak.trivedi@qtechsoftware.com');
[07/08/2024 06:15:10], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132981','demo@demo.demo');
[07/08/2024 06:15:12], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132981','ops@astrabookings.com');
[07/08/2024 06:15:12], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132981','info@astrabookings.com');
[07/08/2024 06:15:12], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132981','ops@astrabookings.com');
[07/08/2024 06:18:39], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:18:48], [file name :-/efsdata/otrams/public_html/beta/get_cancellation_fee.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('132981', 'CANCELLATION_FEE', 'j2/08_07_2024/request_CANCELLATION_FEE_yogeshqtech_132981_06_18_48_1720419528.xml', 'j2/08_07_2024/response_CANCELLATION_FEE_yogeshqtech_132981_06_18_48_1720419528.xml', 'j2/08_07_2024/response_header_CANCELLATION_FEE_yogeshqtech_132981_06_18_48_1720419528.xml', 'jumbotours', '2024-07-08 06:18:48', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_CANCELLATION_FEE_yogeshqtech_132981_06_18_48_1720419528.xml');
[07/08/2024 06:19:02], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('132981', 'CANCEL', 'j2/08_07_2024/request_cancel_yogeshqtech_132981_06_18_51_1720419531.xml', 'j2/08_07_2024/response_cancel_yogeshqtech_132981_06_18_51_1720419531.xml', 'j2/08_07_2024/response_header_cancel_yogeshqtech_132981_06_18_51_1720419531.xml', 'jumbotours', '2024-07-08 06:19:02', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_cancel_yogeshqtech_132981_06_18_51_1720419531.xml');
[07/08/2024 06:19:02], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO history_bookings set history_booking_id ='132981', agent_id ='949', itenirary_id ='', confirmation_number ='8791173614', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Mr', leader_first_name ='test', leader_last_name ='test', city_id ='dubai', country_id ='138', display_room_rate ='94.940', native_room_rate ='90.420', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='<b>ALOFT, GUEST ROOM, 1 KING - <font color=\'red\'>PACKAGE RATE</font> ROOM ONLY </b> - <font color=\'red\'>Package Rate</font><br>Free cancellation up to 2024-07-16 05:29:59<br>If you cancel between 2024-07-16 05:30:00 and 2024-07-19 00:00:00 , you will be charged 47.47 USD<br><b>ALOFT, GUEST ROOM, 1 KING - <font color=\'red\'>PACKAGE RATE</font> ROOM ONLY </b> - <font color=\'red\'>Package Rate</font><br>Free cancellation up to 2024-07-16 05:29:59<br>If you cancel between 2024-07-16 05:30:00 and 2024-07-19 00:00:00 , you will be charged 47.47 USD<br>No show is subject to a 100.0% 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 05:30 on 16th of July 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2024-07-08 06:14:56', create_date ='2024-07-08 06:14:56', source_type ='jumbotours', expiration_date ='2024-07-16 00:00:00', comment_contract =' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ADDITIONAL INFO: Tour Operator Dynamic Rate, Tour Operator Dynamic, Book or change or cancel only by Tour Operators<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed The name on the credit card used at check-in to pay for incidentals must be the primary name on the guestroom reservation This property accepts credit cards, debit cards, mobile payments, and cash Mobile payment options include: Google Pay, Apple Pay, and PayPay This property reserves the right to pre-authorize the guest\'s credit card prior to arrival. Cashless transactions are available This property affirms that it follows the cleaning and disinfection practices of Commitment to Clean (Marriott) Front desk staff will greet guests on arrival.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: A tax is imposed by the city: AED 15.00 per accommodation, per night We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for buffet breakfast: approximately AED 45 per person Rollaway bed fee: AED 100.0 per night The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: Reservations are required for massage services and spa treatments. Reservations can be made by contacting the hotel prior to arrival, using the contact information on the booking confirmation. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. No pets and no service animals are allowed at this property. Cashless payment methods are available for all transactions. Contactless check-in and contactless check-out are available.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='94.940', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='90.420', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Bhavesh_qtech', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='5', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='5', wh_agent_markup ='0.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2024-07-08 06:19:02', modified_by ='', display_currency_code ='USD', created_datetime ='2024-07-08 06:19:02', sub_agent_rate ='0.000', created_by ='yogeshqtech', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='103.104.226.130', is_cancel_history ='1';
[07/08/2024 06:19:02], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','132981','cancelled','2024-07-08 06:19:02','','949','103.104.226.130','','','');
[07/08/2024 06:19:02], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],UPDATE bookings SET current_status='cancelled',status_date='2024-07-08 06:19:02' , pending_cancellation = 'no' WHERE reservation_id = '1877216' AND id = '132981' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[07/08/2024 06:19:02], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update booking_commission set status='D'  where booking_id ='132981';
[07/08/2024 06:19:02], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='' , applicable_service_tax='0' WHERE id = '132981' AND (current_status = 'cancelled' ) ;
[07/08/2024 06:19:02], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],delete from cancellations where booking_id =? ;
[07/08/2024 06:19:02], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO cancellations (native_charge,display_charge,native_currency_code,display_currency_code,reservation_id,booking_id,cancellation_date,confirmation_no,note) values ('','0','USD','USD','1877216','132981','2024-07-08 06:19:02','',' ');
[07/08/2024 06:19:04], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:19:06], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132981','deepak.trivedi@qtechsoftware.com');
[07/08/2024 06:19:06], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132981','demo@demo.demo');
[07/08/2024 06:19:09], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132981','ops@astrabookings.com');
[07/08/2024 06:19:09], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132981','info@astrabookings.com');
[07/08/2024 06:19:09], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132981','ops@astrabookings.com');
[07/08/2024 06:19:13], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:19:15], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:19:25], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 06:19:25',login_attempt=0 where id = '949';
[07/08/2024 06:19:25], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'yogeshqtech', user_type = 'A', branch_id = '1', login_datetime = '2024-07-08 06:19:25', ip = '103.104.226.130', action = 'Login' ;
[07/08/2024 06:19:53], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/14' , departure_date = '2024/07/15' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 06:19:53' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/08/2024 06:19:54], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_19_54_17204195943.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_19_54_17204195943.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_19_54_17204195943.xml', 'jumbotours', '2024-07-08 06:19:54', '', '949082024070619535314096957', '12728057', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_19_54_17204195943.xml');
[07/08/2024 06:19:54], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070619535314096957&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:19:54.169'
        , request_start_time = '0.008'
        , parsing_start_time = '0.622'
        , mapping_complete_time = '0.035'
        , mongo_start_time = '0.096'
        , search_end_time = '0.000'
        , total_duration = '0.799'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2979648'
        WHERE id = '157038209';
[07/08/2024 06:19:56], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_19_54_17204195940.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_19_54_17204195940.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_19_54_17204195940.xml', 'jumbotours', '2024-07-08 06:19:56', '', '949082024070619535314096957', '12728057', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_19_54_17204195940.xml');
[07/08/2024 06:19:56], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_19_54_17204195942.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_19_54_17204195942.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_19_54_17204195942.xml', 'jumbotours', '2024-07-08 06:19:56', '', '949082024070619535314096957', '12728057', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_19_54_17204195942.xml');
[07/08/2024 06:19:56], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_19_54_17204195941.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_19_54_17204195941.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_19_54_17204195941.xml', 'jumbotours', '2024-07-08 06:19:56', '', '949082024070619535314096957', '12728057', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_19_54_17204195941.xml');
[07/08/2024 06:19:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070619535314096957&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:19:54.170'
        , request_start_time = '0.008'
        , parsing_start_time = '2.011'
        , mapping_complete_time = '0.306'
        , mongo_start_time = '0.567'
        , search_end_time = '0.000'
        , total_duration = '2.659'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '27282184'
        WHERE id = '157038211';
[07/08/2024 06:19:56], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070619535314096957&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:19:54.169'
        , request_start_time = '0.018'
        , parsing_start_time = '1.957'
        , mapping_complete_time = '0.419'
        , mongo_start_time = '0.673'
        , search_end_time = '0.000'
        , total_duration = '2.713'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '28747080'
        WHERE id = '157038210';
[07/08/2024 06:19:57], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=949082024070619535314096957&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:19:54.170'
        , request_start_time = '0.024'
        , parsing_start_time = '2.155'
        , mapping_complete_time = '0.464'
        , mongo_start_time = '0.753'
        , search_end_time = '0.000'
        , total_duration = '2.989'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '32818032'
        WHERE id = '157038212';
[07/08/2024 06:19:57], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '200',
        request_path = '/xml_all.php?userid=949&sessionid=949082024070619535314096957',
        duration = '3.101',
        merge_duration = '0.003',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.45',
        system_load_5_min = '2.06',
        system_load_15_min = '2.53',
        system_memory_usage = '62.71',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12728057') + '2258776',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12728057';
[07/08/2024 06:20:11], [file name :-/efsdata/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '949' , sub_agent_id = '' , sub_user_id = '0' , wh_agent_id = '' , branch_id = '1' , ip = '103.104.226.130' , city = 'dubai' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2024/07/14' , departure_date = '2024/07/15' , nights = '1' , nationality = '106' , room_types = '2, 1' , room_type='[{"numberOfAdults":2},{"numberOfAdults":1}]' , available='0' , create_date = '2024-07-08 06:20:11' , site_id = '' , country_code = '138' , city_code = '71649' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '0' ;
[07/08/2024 06:20:13], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_20_12_17204196122.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_20_12_17204196122.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_20_12_17204196122.xml', 'jumbotours', '2024-07-08 06:20:13', '', '94908202407062011562592279', '12728058', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_20_12_17204196122.xml');
[07/08/2024 06:20:14], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_20_12_17204196121.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_20_12_17204196121.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_20_12_17204196121.xml', 'jumbotours', '2024-07-08 06:20:14', '', '94908202407062011562592279', '12728058', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_20_12_17204196121.xml');
[07/08/2024 06:20:14], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_20_12_17204196120.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_20_12_17204196120.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_20_12_17204196120.xml', 'jumbotours', '2024-07-08 06:20:14', '', '94908202407062011562592279', '12728058', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_20_12_17204196120.xml');
[07/08/2024 06:20:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=94908202407062011562592279&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=2&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:20:12.599'
        , request_start_time = '0.008'
        , parsing_start_time = '1.215'
        , mapping_complete_time = '0.299'
        , mongo_start_time = '0.532'
        , search_end_time = '0.000'
        , total_duration = '1.818'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '24887840'
        WHERE id = '157038215';
[07/08/2024 06:20:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=94908202407062011562592279&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=1&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:20:12.599'
        , request_start_time = '0.008'
        , parsing_start_time = '1.391'
        , mapping_complete_time = '0.432'
        , mongo_start_time = '0.739'
        , search_end_time = '0.000'
        , total_duration = '2.213'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '35553320'
        WHERE id = '157038216';
[07/08/2024 06:20:14], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=94908202407062011562592279&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=0&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:20:12.599'
        , request_start_time = '0.007'
        , parsing_start_time = '1.468'
        , mapping_complete_time = '0.438'
        , mongo_start_time = '0.735'
        , search_end_time = '0.000'
        , total_duration = '2.284'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '35725056'
        WHERE id = '157038217';
[07/08/2024 06:20:16], [file name :-/efsdata/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,file_path) VALUE ('', 'AVAILABILITY', 'j2/08_07_2024/request_availability_yogeshqtech_06_20_12_17204196123.xml', 'j2/08_07_2024/response_availability_yogeshqtech_06_20_12_17204196123.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_06_20_12_17204196123.xml', 'jumbotours', '2024-07-08 06:20:16', '', '94908202407062011562592279', '12728058', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_06_20_12_17204196123.xml');
[07/08/2024 06:20:16], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=94908202407062011562592279&xml_user_id=949&db_caching=1&wh_agent_id=&erequest=3&total_request=4&hotels_ids=&web_service=no&site_id=&save_log=yes'
        , http_hit_time = '2024-07-08 06:20:12.599'
        , request_start_time = '0.019'
        , parsing_start_time = '3.918'
        , mapping_complete_time = '0.031'
        , mongo_start_time = '0.055'
        , search_end_time = '0.000'
        , total_duration = '4.038'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2529848'
        WHERE id = '157038220';
[07/08/2024 06:20:16], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '93',
        request_path = '/xml_all.php?userid=949&sessionid=94908202407062011562592279',
        duration = '4.145',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.51',
        system_load_5_min = '2.04',
        system_load_15_min = '2.51',
        system_memory_usage = '63.18',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12728058') + '2239864',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12728058';
[07/08/2024 06:20:26], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720419626','103.104.226.130');
[07/08/2024 06:20:27], [file name :-/efsdata/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,file_path) VALUE ('', 'VALUATION', 'j2/08_07_2024/request_valuation_yogeshqtech_06_20_26_1720419626.xml', 'j2/08_07_2024/response_valuation_yogeshqtech_06_20_26_1720419626.xml', 'j2/08_07_2024/response_header_valuation_yogeshqtech_06_20_26_1720419626.xml', 'jumbotours', '2024-07-08 06:20:27', '', '94908202407062011562592279', '12728058', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_valuation_yogeshqtech_06_20_26_1720419626.xml');
[07/08/2024 06:20:31], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720419631','103.104.226.130');
[07/08/2024 06:20:32], [file name :-/efsdata/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,file_path) VALUE ('', 'VALUATION', 'j2/08_07_2024/request_valuation_yogeshqtech_06_20_31_1720419631.xml', 'j2/08_07_2024/response_valuation_yogeshqtech_06_20_31_1720419631.xml', 'j2/08_07_2024/response_header_valuation_yogeshqtech_06_20_31_1720419631.xml', 'jumbotours', '2024-07-08 06:20:32', '', '94908202407062011562592279', '12728058', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_valuation_yogeshqtech_06_20_31_1720419631.xml');
[07/08/2024 06:21:16], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720419676','103.104.226.130');
[07/08/2024 06:21:17], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'jumbotours', reservation_id = '1877230', create_date = '2024-07-08 06:21:17', agent_id = '949', parent_agent_id = '949', agent_ref_no = '', nationality = 'Indian', city_id = 'dubai', country_id = '138', current_status = 'inprocess-booking', booking_branch_id = '1', is_xml = '0', display_room_rate = '76.2', display_currency_code = 'USD', native_room_rate = '72.58', native_currency_code = 'USD', supplier_profile_id = '27', service_type = 'hotel', service_date = '2024/07/14', check_out_date = '2024/07/15', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'test', leader_last_name = 'test', status_date = '2024-07-08 06:21:17';
[07/08/2024 06:21:17], [file name :-/efsdata/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 ('132983','ROVE HEALTHCARE CITY','NA','738391','OT000631572','dubai','jumbotours',NOW());
[07/08/2024 06:21:17], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='132983'
		;
[07/08/2024 06:21:17], [file name :-/efsdata/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('132983','1877230','','2','3','0','-','','','738391','ROVE HEALTHCARE CITY','19th Street, Oud Metha','','3.0','1','2024/07/14','2024/07/15','','https://i.travelapi.com/lodging/17000000/16710000/16700600/16700525/cbc9f26f_b.jpg');
[07/08/2024 06:21:17], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132983', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'ROVER ROOM ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:38.100000000000001;s:25:"displayNightlyRateDisplay";s:159:"Rate - 36.29, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:36.289999999999999;}}', native_room_rate_total = '36.29', display_room_rate_total = '38.1', number_of_rooms = '1', room_category = 'Double ROVER ROOM', meal_basis = 'ROOM ONLY';
[07/08/2024 06:21:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132983', booking_detail_id = '1', rid = '145748', room = '0', salutations = 'Mr', first_name = 'test', last_name = 'test', passenger_type = 'adult', age = '';
[07/08/2024 06:21:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132983', booking_detail_id = '1', rid = '145748', room = '0', salutations = 'Mr', first_name = 'testing', last_name = 'test', passenger_type = 'adult', age = '';
[07/08/2024 06:21:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132983', booking_detail_id = '1', room_type_code = '', room_name = 'single', room_type_description = 'ROVER ROOM ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:38.100000000000001;s:25:"displayNightlyRateDisplay";s:159:"Rate - 36.29, Currency Multiplier (USD-USD) - 1.00000, Markup in % - 5.00%, Markup Amount - 0, Markup Amount in USD- 0.00, Supplier Commission - 0% #jumbotours";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:36.289999999999999;}}', native_room_rate_total = '36.29', display_room_rate_total = '38.1', number_of_rooms = '1', room_category = 'Single ROVER ROOM', meal_basis = 'ROOM ONLY';
[07/08/2024 06:21:18], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132983', booking_detail_id = '1', rid = '145749', room = '0', salutations = 'Mr', first_name = 'test one', last_name = 'test', passenger_type = 'adult', age = '';
[07/08/2024 06:21:25], [file name :-/efsdata/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,file_path) VALUE ('', 'RESERVATION', 'j2/08_07_2024/request_reservation_yogeshqtech_06_21_18_1720419678.xml', 'j2/08_07_2024/response_reservation_yogeshqtech_06_21_18_1720419678.xml', 'j2/08_07_2024/response_header_reservation_yogeshqtech_06_21_18_1720419678.xml', 'jumbotours', '2024-07-08 06:21:25', '', '94908202407062011562592279', '12728058', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_reservation_yogeshqtech_06_21_18_1720419678.xml');
[07/08/2024 06:21:25], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '8502173615', display_discount = '0', native_discount = '0', cancellation_policy = '<b>ROVER ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-11 05:29:59<br>If you cancel between 2024-07-11 05:30:00 and 2024-07-14 00:00:00 , you will be charged 38.1 USD<br><b>ROVER ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-11 05:29:59<br>If you cancel between 2024-07-11 05:30:00 and 2024-07-14 00:00:00 , you will be charged 38.1 USD<br>No show is subject to a 100.0% 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 05:30 on 11th of July 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-07-11 00:00:00', comment_contract = ' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ADDITIONAL INFO: 1 CC BB - Rate inclusive of BreakfastADDITIONAL INFO: 1 CC BAR - Room only rate<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed Tax ID - 100256339100003 This property accepts credit cards, debit cards, and cash This property reserves the right to pre-authorize the guest\'s credit card prior to arrival. Cashless transactions are available Please note that cultural norms and guest policies may differ by country and by property; the policies listed are provided by the property Please note: Guestrooms are equipped with single sofa beds, suitable for children only. This property offers transfers from the airport (surcharges may apply). To arrange pick-up, guests must contact the property 24 hours prior to arrival, using the contact information on the booking confirmation. Front desk staff will greet guests on arrival. For more details, please contact the property using the information on the booking confirmation. The credit card used to book the reservation must be presented by the cardholder at check-in. All guests, including children, must present valid passport or UAE/GCC National identification at check-in.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: A tax is imposed by the city: AED 10.00 per accommodation, per night We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for continental breakfast: approximately AED 59 per person Airport shuttle fee: AED 210 per vehicle (maximum occupancy 4) The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: One child 16 years old or younger stays free when occupying the parent or guardian\'s room, using existing bedding. Only registered guests are allowed in the guestrooms. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. Cashless payment methods are available for all transactions.', consultant_id = 'Bhavesh_qtech', sales_manager_id = '', admin_booked = '0', email_id = 'supriya@gmail.com', leader_phone = '9987204292', agent_currency_multiplier = '1.00000', ip_addr = '103.104.226.130', comment_contract = ' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ADDITIONAL INFO: 1 CC BB - Rate inclusive of BreakfastADDITIONAL INFO: 1 CC BAR - Room only rate<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed Tax ID - 100256339100003 This property accepts credit cards, debit cards, and cash This property reserves the right to pre-authorize the guest\'s credit card prior to arrival. Cashless transactions are available Please note that cultural norms and guest policies may differ by country and by property; the policies listed are provided by the property Please note: Guestrooms are equipped with single sofa beds, suitable for children only. This property offers transfers from the airport (surcharges may apply). To arrange pick-up, guests must contact the property 24 hours prior to arrival, using the contact information on the booking confirmation. Front desk staff will greet guests on arrival. For more details, please contact the property using the information on the booking confirmation. The credit card used to book the reservation must be presented by the cardholder at check-in. All guests, including children, must present valid passport or UAE/GCC National identification at check-in.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: A tax is imposed by the city: AED 10.00 per accommodation, per night We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for continental breakfast: approximately AED 59 per person Airport shuttle fee: AED 210 per vehicle (maximum occupancy 4) The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: One child 16 years old or younger stays free when occupying the parent or guardian\'s room, using existing bedding. Only registered guests are allowed in the guestrooms. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. Cashless payment methods are available for all transactions.', backoffice_user = 'Qtech_pranali', customer_id = '', applied_multiplier='1.00000',  applied_markup='4.99',  agent_markup='4.99',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='949',  sub_agent_rate='0',  agent_rate='76.2',  applicable_service_tax='0',  supplier_rate='72.58',  uid='5f5d9be92a0c1f7eaafb4480142b251c'  where id='132983';
[07/08/2024 06:21:25], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='132983';
[07/08/2024 06:21:25], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '132983' , sr_id = '6' ;
[07/08/2024 06:21:25], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('132983','25.234132539839','55.314431495701');
[07/08/2024 06:21:25], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'yogeshqtech',`create_date`= '2024-07-08 06:21:25',`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;132983\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -132983 And Booking Status - confirmed',`ip`= '103.104.226.130';
[07/08/2024 06:21:25], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='1', `entity`='BookingId', `value`='132983' ;
[07/08/2024 06:21:25], [file name :-/efsdata/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 ('1877230','132983','confirmed','2024-07-08 06:21:25','Booking confirmed. Booked by Back Office Qtech_pranali on behalf of Agent - Deepak  Trivedi(CD0949)','949','103.104.226.130','0','949');
[07/08/2024 06:21:25], [file name :-/efsdata/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('132983','2024-07-11 05:30:00','2024-07-12 05:30:00','2024-07-14 00:00:00','2024-07-15 00:00:00','36.29','38.1','24','2024-07-08 06:21:25','38.1');
[07/08/2024 06:21:25], [file name :-/efsdata/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('132983','2024-07-11 05:30:00','2024-07-12 05:30:00','2024-07-14 00:00:00','2024-07-15 00:00:00','36.29','38.1','24','2024-07-08 06:21:25','38.1');
[07/08/2024 06:21:25], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='132983',status='1' where reservation_id='1877230' and booking_id ='0';
[07/08/2024 06:21:25], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='132983' where agent_logs_id='12728058' and source_type='jumbotours';
[07/08/2024 06:21:27], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132983','deepak.trivedi@qtechsoftware.com');
[07/08/2024 06:21:27], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132983','demo@demo.demo');
[07/08/2024 06:21:28], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132983','ops@astrabookings.com');
[07/08/2024 06:21:29], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132983','info@astrabookings.com');
[07/08/2024 06:21:29], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132983','ops@astrabookings.com');
[07/08/2024 06:29:31], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:29:39], [file name :-/efsdata/otrams/public_html/beta/get_cancellation_fee.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('132983', 'CANCELLATION_FEE', 'j2/08_07_2024/request_CANCELLATION_FEE_yogeshqtech_132983_06_29_38_1720420178.xml', 'j2/08_07_2024/response_CANCELLATION_FEE_yogeshqtech_132983_06_29_38_1720420178.xml', 'j2/08_07_2024/response_header_CANCELLATION_FEE_yogeshqtech_132983_06_29_38_1720420178.xml', 'jumbotours', '2024-07-08 06:29:39', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_CANCELLATION_FEE_yogeshqtech_132983_06_29_38_1720420178.xml');
[07/08/2024 06:29:50], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('132983', 'CANCEL', 'j2/08_07_2024/request_cancel_yogeshqtech_132983_06_29_40_1720420180.xml', 'j2/08_07_2024/response_cancel_yogeshqtech_132983_06_29_40_1720420180.xml', 'j2/08_07_2024/response_header_cancel_yogeshqtech_132983_06_29_40_1720420180.xml', 'jumbotours', '2024-07-08 06:29:50', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_cancel_yogeshqtech_132983_06_29_40_1720420180.xml');
[07/08/2024 06:29:50], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO history_bookings set history_booking_id ='132983', agent_id ='949', itenirary_id ='', confirmation_number ='8502173615', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='supriya@gmail.com', leader_title ='Mr', leader_first_name ='test', leader_last_name ='test', city_id ='dubai', country_id ='138', display_room_rate ='76.200', native_room_rate ='72.580', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='<b>ROVER ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-11 05:29:59<br>If you cancel between 2024-07-11 05:30:00 and 2024-07-14 00:00:00 , you will be charged 38.1 USD<br><b>ROVER ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-11 05:29:59<br>If you cancel between 2024-07-11 05:30:00 and 2024-07-14 00:00:00 , you will be charged 38.1 USD<br>No show is subject to a 100.0% 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 05:30 on 11th of July 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='1', status_date ='2024-07-08 06:21:17', create_date ='2024-07-08 06:21:17', source_type ='jumbotours', expiration_date ='2024-07-11 00:00:00', comment_contract =' BOOKING POLICY: Cancelling and rebooking for the same dates with price offer is not allowed in this hotel. Original prices will be applied and names of guests will be checked accurately at time of check-in.CITY TAX: Hotel prices do not include room taxes established by local entities. These room taxes vary according to the city and hotel category and are charged directly by the hotel upon client’s arrival.	.ADDITIONAL INFO: 1 CC BB - Rate inclusive of BreakfastADDITIONAL INFO: 1 CC BAR - Room only rate<br>ADDITIONAL INFO: Extra-person charges may apply and vary depending on property policy Government-issued photo identification and a credit card, debit card, or cash deposit may be required at check-in for incidental charges Special requests are subject to availability upon check-in and may incur additional charges; special requests cannot be guaranteed Tax ID - 100256339100003 This property accepts credit cards, debit cards, and cash This property reserves the right to pre-authorize the guest\'s credit card prior to arrival. Cashless transactions are available Please note that cultural norms and guest policies may differ by country and by property; the policies listed are provided by the property Please note: Guestrooms are equipped with single sofa beds, suitable for children only. This property offers transfers from the airport (surcharges may apply). To arrange pick-up, guests must contact the property 24 hours prior to arrival, using the contact information on the booking confirmation. Front desk staff will greet guests on arrival. For more details, please contact the property using the information on the booking confirmation. The credit card used to book the reservation must be presented by the cardholder at check-in. All guests, including children, must present valid passport or UAE/GCC National identification at check-in.<br>ADDITIONAL INFO: You\'ll be asked to pay the following charges at the property: A tax is imposed by the city: AED 10.00 per accommodation, per night We have included all charges provided to us by the property.<br>ADDITIONAL INFO: Fee for continental breakfast: approximately AED 59 per person Airport shuttle fee: AED 210 per vehicle (maximum occupancy 4) The above list may not be comprehensive. Fees and deposits may not include tax and are subject to change.<br>ADDITIONAL INFO: One child 16 years old or younger stays free when occupying the parent or guardian\'s room, using existing bedding. Only registered guests are allowed in the guestrooms. The property has connecting/adjoining rooms, which are subject to availability and can be requested by contacting the property using the number on the booking confirmation. Cashless payment methods are available for all transactions.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='76.200', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='72.580', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='Bhavesh_qtech', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='4.99', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='4.99', wh_agent_markup ='0.000', basecurrency_multiplier ='1.00000', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='1.00000', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2024-07-08 06:29:50', modified_by ='', display_currency_code ='USD', created_datetime ='2024-07-08 06:29:50', sub_agent_rate ='0.000', created_by ='yogeshqtech', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='103.104.226.130', is_cancel_history ='1';
[07/08/2024 06:29:50], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
		('','','132983','cancelled','2024-07-08 06:29:50','','949','103.104.226.130','','','');
[07/08/2024 06:29:50], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],UPDATE bookings SET current_status='cancelled',status_date='2024-07-08 06:29:50' , pending_cancellation = 'no' WHERE reservation_id = '1877230' AND id = '132983' AND (current_status = 'pending' OR  current_status = 'confirmed' OR  current_status = 'vouchered' OR  current_status = 'on_request' OR  current_status = 'inprocess_cancel') ;
[07/08/2024 06:29:51], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update booking_commission set status='D'  where booking_id ='132983';
[07/08/2024 06:29:51], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],UPDATE bookings SET  agent_rate='0' , sub_agent_rate='0' , supplier_rate='' , applicable_service_tax='0' WHERE id = '132983' AND (current_status = 'cancelled' ) ;
[07/08/2024 06:29:51], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],delete from cancellations where booking_id =? ;
[07/08/2024 06:29:51], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO cancellations (native_charge,display_charge,native_currency_code,display_currency_code,reservation_id,booking_id,cancellation_date,confirmation_no,note) values ('','0','USD','USD','1877230','132983','2024-07-08 06:29:51','',' ');
[07/08/2024 06:29:53], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:29:55], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132983','deepak.trivedi@qtechsoftware.com');
[07/08/2024 06:29:55], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132983','demo@demo.demo');
[07/08/2024 06:29:58], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132983','ops@astrabookings.com');
[07/08/2024 06:29:58], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132983','info@astrabookings.com');
[07/08/2024 06:29:58], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132983','ops@astrabookings.com');
[07/08/2024 06:30:02], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:30:05], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:45:40], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:45:46], [file name :-/efsdata/otrams/public_html/beta/get_cancellation_fee.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header,file_path) VALUE('132974', 'CANCELLATION_FEE', 'j2/08_07_2024/request_CANCELLATION_FEE_yogeshqtech_132974_06_45_46_1720421146.xml', 'j2/08_07_2024/response_CANCELLATION_FEE_yogeshqtech_132974_06_45_46_1720421146.xml', 'j2/08_07_2024/response_header_CANCELLATION_FEE_yogeshqtech_132974_06_45_46_1720421146.xml', 'jumbotours', '2024-07-08 06:45:46', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_CANCELLATION_FEE_yogeshqtech_132974_06_45_46_1720421146.xml');
[07/08/2024 06:45:51], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:45:53], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132974','deepak.trivedi@qtechsoftware.com');
[07/08/2024 06:45:53], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132974','demo@demo.demo');
[07/08/2024 06:45:56], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132974','ops@astrabookings.com');
[07/08/2024 06:45:56], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132974','info@astrabookings.com');
[07/08/2024 06:45:56], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132974','ops@astrabookings.com');
[07/08/2024 06:45:59], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 06:46:01], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
