[07/08/2024 05:06:56], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 05:06:56',login_attempt=0 where id = '949';
[07/08/2024 05:06:56], [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 05:06:56', ip = '103.104.226.130', action = 'Login' ;
[07/08/2024 05:07:19], [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/29' , departure_date = '2024/07/30' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 05:07:19' , 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 05:07:21], [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_05_07_20_17204152403.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_07_20_17204152403.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_07_20_17204152403.xml', 'jumbotours', '2024-07-08 05:07:21', '', '9490820240705071948200944257', '12727185', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_07_20_17204152403.xml');
[07/08/2024 05:07:21], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705071948200944257&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 05:07:20.506'
        , request_start_time = '0.026'
        , parsing_start_time = '1.193'
        , mapping_complete_time = '0.034'
        , mongo_start_time = '0.095'
        , search_end_time = '0.000'
        , total_duration = '1.365'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2979456'
        WHERE id = '157028335';
[07/08/2024 05:07: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_05_07_20_17204152400.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_07_20_17204152400.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_07_20_17204152400.xml', 'jumbotours', '2024-07-08 05:07:22', '', '9490820240705071948200944257', '12727185', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_07_20_17204152400.xml');
[07/08/2024 05:07: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_05_07_20_17204152401.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_07_20_17204152401.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_07_20_17204152401.xml', 'jumbotours', '2024-07-08 05:07:22', '', '9490820240705071948200944257', '12727185', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_07_20_17204152401.xml');
[07/08/2024 05:07: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_05_07_20_17204152402.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_07_20_17204152402.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_07_20_17204152402.xml', 'jumbotours', '2024-07-08 05:07:22', '', '9490820240705071948200944257', '12727185', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_07_20_17204152402.xml');
[07/08/2024 05:07:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705071948200944257&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 05:07:20.504'
        , request_start_time = '0.007'
        , parsing_start_time = '2.183'
        , mapping_complete_time = '0.330'
        , mongo_start_time = '0.616'
        , search_end_time = '0.000'
        , total_duration = '2.882'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '30436056'
        WHERE id = '157028336';
[07/08/2024 05:07:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705071948200944257&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 05:07:20.505'
        , request_start_time = '0.009'
        , parsing_start_time = '2.274'
        , mapping_complete_time = '0.312'
        , mongo_start_time = '0.582'
        , search_end_time = '0.000'
        , total_duration = '2.933'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '28759120'
        WHERE id = '157028338';
[07/08/2024 05:07:23], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705071948200944257&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 05:07:20.506'
        , request_start_time = '0.008'
        , parsing_start_time = '2.254'
        , mapping_complete_time = '0.364'
        , mongo_start_time = '0.680'
        , search_end_time = '0.000'
        , total_duration = '3.011'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '33105104'
        WHERE id = '157028337';
[07/08/2024 05:07:23], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '201',
        request_path = '/xml_all.php?userid=949&sessionid=9490820240705071948200944257',
        duration = '3.142',
        merge_duration = '0.004',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '4.68',
        system_load_5_min = '3.61',
        system_load_15_min = '2.39',
        system_memory_usage = '38.77',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727185') + '2478752',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727185';
[07/08/2024 05:07:37], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720415257','103.104.226.130');
[07/08/2024 05:07:38], [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_05_07_37_1720415257.xml', 'j2/08_07_2024/response_valuation_yogeshqtech_05_07_37_1720415257.xml', 'j2/08_07_2024/response_header_valuation_yogeshqtech_05_07_37_1720415257.xml', 'jumbotours', '2024-07-08 05:07:38', '', '9490820240705071948200944257', '12727185', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_valuation_yogeshqtech_05_07_37_1720415257.xml');
[07/08/2024 05:08:38], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720415318','103.104.226.130');
[07/08/2024 05:08:39], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'jumbotours', reservation_id = '1877192', create_date = '2024-07-08 05:08:39', 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 = '28.4', display_currency_code = 'USD', native_room_rate = '27.05', native_currency_code = 'USD', supplier_profile_id = '27', service_type = 'hotel', service_date = '2024/07/29', check_out_date = '2024/07/30', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Sup', leader_last_name = 'Gangawane', status_date = '2024-07-08 05:08:39';
[07/08/2024 05:08:39], [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 ('132975','SMANA HOTEL AL RAFFA','NA','97022','OT000217302','dubai','jumbotours',NOW());
[07/08/2024 05:08:39], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='132975'
		;
[07/08/2024 05:08:39], [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('132975','1877192','','1','2','0','-','','','97022','SMANA HOTEL AL RAFFA','AL Mina Road, Dubai','+97143259966','3.0','1','2024/07/29','2024/07/30','','https://i.travelapi.com/lodging/28000000/27780000/27772400/27772378/5c196c6d_b.jpg');
[07/08/2024 05:08:39], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132975', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'DELUXE ROOM ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:28.399999999999999;s:25:"displayNightlyRateDisplay";s:159:"Rate - 27.05, 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:27.050000000000001;}}', native_room_rate_total = '27.05', display_room_rate_total = '28.4', number_of_rooms = '1', room_category = 'Double DELUXE ROOM', meal_basis = 'ROOM ONLY';
[07/08/2024 05:08:39], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132975', booking_detail_id = '1', rid = '145738', room = '0', salutations = 'Mr', first_name = 'Sup', last_name = 'Gangawane', passenger_type = 'adult', age = '';
[07/08/2024 05:08:39], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132975', booking_detail_id = '1', rid = '145738', room = '0', salutations = 'Mr', first_name = 'Aji', last_name = 'Gangawane', passenger_type = 'adult', age = '';
[07/08/2024 05:08:40], [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_05_08_39_1720415319.xml', 'j2/08_07_2024/response_reservation_yogeshqtech_05_08_39_1720415319.xml', 'j2/08_07_2024/response_header_reservation_yogeshqtech_05_08_39_1720415319.xml', 'jumbotours', '2024-07-08 05:08:40', '', '9490820240705071948200944257', '12727185', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_reservation_yogeshqtech_05_08_39_1720415319.xml');
[07/08/2024 05:08:40], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', native_discount = '0', cancellation_policy = '<b>DELUXE ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-24 05:29:59<br>If you cancel between 2024-07-24 05:30:00 and 2024-07-29 00:00:00 , you will be charged 28.4 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 24th of July 2024.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'failed', expiration_date = '2024-07-24 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.	.ROOM CONDITIONS: If the title of the room does not specify if there is an extra bed. Child will share the bed with adults<br>ADDITIONAL INFO: Tourism Dirham to be paid by Guest upon check-in at the hotel. Nationality with UAE Residence & UAE nationals UAE rates will apply. Any cancellation & rebooking at lower rate is not allowed.', 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.	.ROOM CONDITIONS: If the title of the room does not specify if there is an extra bed. Child will share the bed with adults<br>ADDITIONAL INFO: Tourism Dirham to be paid by Guest upon check-in at the hotel. Nationality with UAE Residence & UAE nationals UAE rates will apply. Any cancellation & rebooking at lower rate is not allowed.', 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='28.4',  applicable_service_tax='0',  supplier_rate='27.05',  uid='fbcc30d6b46577ad3915e53eb712190e'  where id='132975';
[07/08/2024 05:08:40], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='132975';
[07/08/2024 05:08:40], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '132975' , sr_id = '6' ;
[07/08/2024 05:08:40], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('132975','25.24997','55.2819');
[07/08/2024 05:08:40], [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 ('1877192','132975','failed','2024-07-08 05:08:40','Booking failed Error: Failed. Booked by Back Office Qtech_pranali on behalf of Agent - Deepak  Trivedi(CD0949)','949','103.104.226.130','0','949');
[07/08/2024 05:08:40], [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('132975','2024-07-24 05:30:00','2024-07-25 05:30:00','2024-07-29 00:00:00','2024-07-30 00:00:00','27.05','28.4','24','2024-07-08 05:08:40','28.4');
[07/08/2024 05:08:40], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='132975',status='1' where reservation_id='1877192' and booking_id ='0';
[07/08/2024 05:08:40], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='132975' where agent_logs_id='12727185' and source_type='jumbotours';
[07/08/2024 05:08:42], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132975','deepak.trivedi@qtechsoftware.com');
[07/08/2024 05:08:42], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132975','demo@demo.demo');
[07/08/2024 05:08:43], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132975','ops@astrabookings.com');
[07/08/2024 05:14:22], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 05:14:22',login_attempt=0 where id = '949';
[07/08/2024 05:14:22], [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 05:14:22', ip = '103.104.226.130', action = 'Login' ;
[07/08/2024 05:14:44], [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/28' , departure_date = '2024/07/29' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 05:14:44' , 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 05:14:45], [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_05_14_45_17204156853.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_14_45_17204156853.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_14_45_17204156853.xml', 'jumbotours', '2024-07-08 05:14:45', '', '9490820240705144420082422400', '12727222', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_14_45_17204156853.xml');
[07/08/2024 05:14:46], [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_05_14_45_17204156850.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_14_45_17204156850.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_14_45_17204156850.xml', 'jumbotours', '2024-07-08 05:14:46', '', '9490820240705144420082422400', '12727222', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_14_45_17204156850.xml');
[07/08/2024 05:14:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705144420082422400&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 05:14:45.319'
        , request_start_time = '0.019'
        , parsing_start_time = '0.580'
        , mapping_complete_time = '0.027'
        , mongo_start_time = '0.030'
        , search_end_time = '0.000'
        , total_duration = '0.694'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '1819424'
        WHERE id = '157029177';
[07/08/2024 05:14:46], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705144420082422400&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 05:14:45.320'
        , request_start_time = '0.010'
        , parsing_start_time = '0.532'
        , mapping_complete_time = '0.033'
        , mongo_start_time = '0.091'
        , search_end_time = '0.000'
        , total_duration = '0.707'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2979672'
        WHERE id = '157029176';
[07/08/2024 05:14:47], [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_05_14_45_17204156851.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_14_45_17204156851.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_14_45_17204156851.xml', 'jumbotours', '2024-07-08 05:14:47', '', '9490820240705144420082422400', '12727222', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_14_45_17204156851.xml');
[07/08/2024 05:14:47], [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_05_14_45_17204156852.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_14_45_17204156852.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_14_45_17204156852.xml', 'jumbotours', '2024-07-08 05:14:47', '', '9490820240705144420082422400', '12727222', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_14_45_17204156852.xml');
[07/08/2024 05:14:47], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705144420082422400&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 05:14:45.320'
        , request_start_time = '0.018'
        , parsing_start_time = '1.749'
        , mapping_complete_time = '0.362'
        , mongo_start_time = '0.665'
        , search_end_time = '0.000'
        , total_duration = '2.498'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '33189864'
        WHERE id = '157029178';
[07/08/2024 05:14:48], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705144420082422400&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 05:14:45.320'
        , request_start_time = '0.022'
        , parsing_start_time = '2.090'
        , mapping_complete_time = '0.320'
        , mongo_start_time = '0.585'
        , search_end_time = '0.000'
        , total_duration = '2.759'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '28778368'
        WHERE id = '157029179';
[07/08/2024 05:14:48], [file name :-/efsdata/otrams/public_html/beta/xml_all.php],UPDATE agent_logs SET
        hotel_count = '135',
        request_path = '/xml_all.php?userid=949&sessionid=9490820240705144420082422400',
        duration = '2.867',
        merge_duration = '0.004',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '20.11',
        system_load_5_min = '9.63',
        system_load_15_min = '4.81',
        system_memory_usage = '44.34',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727222') + '2449816',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727222';
[07/08/2024 05:15:00], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720415700','103.104.226.130');
[07/08/2024 05:15:01], [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_05_15_00_1720415700.xml', 'j2/08_07_2024/response_valuation_yogeshqtech_05_15_00_1720415700.xml', 'j2/08_07_2024/response_header_valuation_yogeshqtech_05_15_00_1720415700.xml', 'jumbotours', '2024-07-08 05:15:01', '', '9490820240705144420082422400', '12727222', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_valuation_yogeshqtech_05_15_00_1720415700.xml');
[07/08/2024 05:16:03], [file name :-/efsdata/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1720415763','103.104.226.130');
[07/08/2024 05:16:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'jumbotours', reservation_id = '1877195', create_date = '2024-07-08 05:16:05', 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 = '31.55', display_currency_code = 'USD', native_room_rate = '30.05', native_currency_code = 'USD', supplier_profile_id = '27', service_type = 'hotel', service_date = '2024/07/28', check_out_date = '2024/07/29', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'Sup', leader_last_name = 'Sonar', status_date = '2024-07-08 05:16:05';
[07/08/2024 05:16:05], [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 ('132976','GULF INN HOTEL DEIRA','NA','240341','OT000207452','dubai','jumbotours',NOW());
[07/08/2024 05:16:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '1'
		WHERE
		id='132976'
		;
[07/08/2024 05:16:05], [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('132976','1877195','','1','2','0','-','','','240341','GULF INN HOTEL DEIRA','Salahuddin Road -','','3.0','1','2024/07/28','2024/07/29','','https://betalive.astrabookings.com//cpfv3/images/?image=aHR0cDovL2ltYWdlcy54dHJhdmVsc3lzdGVtLmNvbS9zbGlkZS9maWxlcy9wdWJsaWMvMjQwLzMvNC8xL0ltYWdlcy81LmpwZw==');
[07/08/2024 05:16:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '132976', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'STANDARD ROOM ROOM ONLY ', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:31.550000000000001;s:25:"displayNightlyRateDisplay";s:159:"Rate - 30.05, 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:30.050000000000001;}}', native_room_rate_total = '30.05', display_room_rate_total = '31.55', number_of_rooms = '1', room_category = 'Double STANDARD ROOM', meal_basis = 'ROOM ONLY';
[07/08/2024 05:16:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132976', booking_detail_id = '1', rid = '145739', room = '0', salutations = 'Mr', first_name = 'Sup', last_name = 'Sonar', passenger_type = 'adult', age = '';
[07/08/2024 05:16:05], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '132976', booking_detail_id = '1', rid = '145739', room = '0', salutations = 'Mr', first_name = 'Aji', last_name = 'Gangawane', passenger_type = 'adult', age = '';
[07/08/2024 05:16:09], [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_05_16_05_1720415765.xml', 'j2/08_07_2024/response_reservation_yogeshqtech_05_16_05_1720415765.xml', 'j2/08_07_2024/response_header_reservation_yogeshqtech_05_16_05_1720415765.xml', 'jumbotours', '2024-07-08 05:16:09', '', '9490820240705144420082422400', '12727222', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_reservation_yogeshqtech_05_16_05_1720415765.xml');
[07/08/2024 05:16:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '8141173618', display_discount = '0', native_discount = '0', cancellation_policy = '<b>STANDARD ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-22 05:29:59<br>If you cancel between 2024-07-22 05:30:00 and 2024-07-28 00:00:00 , you will be charged 31.55 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 22nd 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-22 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.	.ROOM CONDITIONS: If the title of the room does not specify if there is an extra bed. Child will share the bed with adults<br>ADDITIONAL INFO: Tourism Dirham to be paid by Guest upon check-in at the hotel. Nationality with UAE Residence & UAE nationals UAE rates will apply. Any cancellation & rebooking at lower rate is not allowed.', 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.	.ROOM CONDITIONS: If the title of the room does not specify if there is an extra bed. Child will share the bed with adults<br>ADDITIONAL INFO: Tourism Dirham to be paid by Guest upon check-in at the hotel. Nationality with UAE Residence & UAE nationals UAE rates will apply. Any cancellation & rebooking at lower rate is not allowed.', 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='31.55',  applicable_service_tax='0',  supplier_rate='30.05',  uid='068074f5f97d03f63e20ca6508279457'  where id='132976';
[07/08/2024 05:16:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='132976';
[07/08/2024 05:16:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '132976' , sr_id = '6' ;
[07/08/2024 05:16:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('132976','25.270014836783','55.319002676197');
[07/08/2024 05:16:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'yogeshqtech',`create_date`= '2024-07-08 05:16:09',`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;132976\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -132976 And Booking Status - confirmed',`ip`= '103.104.226.130';
[07/08/2024 05:16:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='1', `entity`='BookingId', `value`='132976' ;
[07/08/2024 05:16:09], [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 ('1877195','132976','confirmed','2024-07-08 05:16:09','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 05:16:09], [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('132976','2024-07-22 05:30:00','2024-07-23 05:30:00','2024-07-28 00:00:00','2024-07-29 00:00:00','30.05','31.55','24','2024-07-08 05:16:09','31.55');
[07/08/2024 05:16:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='132976',status='1' where reservation_id='1877195' and booking_id ='0';
[07/08/2024 05:16:09], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='132976' where agent_logs_id='12727222' and source_type='jumbotours';
[07/08/2024 05:16:11], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132976','deepak.trivedi@qtechsoftware.com');
[07/08/2024 05:16:11], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132976','demo@demo.demo');
[07/08/2024 05:16:13], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132976','ops@astrabookings.com');
[07/08/2024 05:16:13], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132976','info@astrabookings.com');
[07/08/2024 05:16:13], [file name :-/efsdata/otrams/public_html/beta/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('132976','ops@astrabookings.com');
[07/08/2024 05:33:17], [file name :-/efsdata/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2024-07-08 05:33:17',login_attempt=0 where id = '949';
[07/08/2024 05:33:18], [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 05:33:18', ip = '103.104.226.130', action = 'Login' ;
[07/08/2024 05:33:56], [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/22' , departure_date = '2024/07/23' , nights = '1' , nationality = '106' , room_types = '2, 2' , room_type='[{"numberOfAdults":2},{"numberOfAdults":2}]' , available='0' , create_date = '2024-07-08 05:33:56' , 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 05:33:58], [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_05_33_57_17204168373.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_33_57_17204168373.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_33_57_17204168373.xml', 'jumbotours', '2024-07-08 05:33:58', '', '9490820240705335698669694736', '12727395', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_33_57_17204168373.xml');
[07/08/2024 05:33:58], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705335698669694736&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 05:33:57.671'
        , request_start_time = '0.009'
        , parsing_start_time = '0.688'
        , mapping_complete_time = '0.028'
        , mongo_start_time = '0.079'
        , search_end_time = '0.000'
        , total_duration = '0.839'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '2526168'
        WHERE id = '157031402';
[07/08/2024 05:33:59], [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_05_33_57_17204168372.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_33_57_17204168372.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_33_57_17204168372.xml', 'jumbotours', '2024-07-08 05:33:59', '', '9490820240705335698669694736', '12727395', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_33_57_17204168372.xml');
[07/08/2024 05:33:59], [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_05_33_57_17204168370.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_33_57_17204168370.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_33_57_17204168370.xml', 'jumbotours', '2024-07-08 05:33:59', '', '9490820240705335698669694736', '12727395', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_33_57_17204168370.xml');
[07/08/2024 05:34:00], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705335698669694736&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 05:33:57.671'
        , request_start_time = '0.024'
        , parsing_start_time = '1.770'
        , mapping_complete_time = '0.297'
        , mongo_start_time = '0.489'
        , search_end_time = '0.000'
        , total_duration = '2.332'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '25073552'
        WHERE id = '157031403';
[07/08/2024 05:34:00], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705335698669694736&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 05:33:57.670'
        , request_start_time = '0.012'
        , parsing_start_time = '1.966'
        , mapping_complete_time = '0.434'
        , mongo_start_time = '0.770'
        , search_end_time = '0.001'
        , total_duration = '2.808'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '36296824'
        WHERE id = '157031404';
[07/08/2024 05:34:03], [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_05_33_57_17204168371.xml', 'j2/08_07_2024/response_availability_yogeshqtech_05_33_57_17204168371.xml', 'j2/08_07_2024/response_header_availability_yogeshqtech_05_33_57_17204168371.xml', 'jumbotours', '2024-07-08 05:34:03', '', '9490820240705335698669694736', '12727395', 'https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_availability_yogeshqtech_05_33_57_17204168371.xml');
[07/08/2024 05:34:03], [file name :-/efsdata/otrams/public_html/beta/call.php],UPDATE xmllogs SET
        hotel_count = ''
        , request_url = '/call.php?s=jumbotours&sessionid=9490820240705335698669694736&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 05:33:57.671'
        , request_start_time = '0.009'
        , parsing_start_time = '5.253'
        , mapping_complete_time = '0.425'
        , mongo_start_time = '0.704'
        , search_end_time = '0.000'
        , total_duration = '6.030'
        , error_description = 'jumbotours: city missing.'
        , memory_used = '35409240'
        WHERE id = '157031406';
[07/08/2024 05:34:03], [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=9490820240705335698669694736',
        duration = '6.158',
        merge_duration = '0.002',
        assigned_supplier_count = '1',
        searched_supplier_count = '1',
        system_load_1_min = '1.65',
        system_load_5_min = '2.93',
        system_load_15_min = '3.16',
        system_memory_usage = '59.59',
        memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '12727395') + '2236344',
        parallel_search_count = '',
        mongo_archive_collection = '',
        error_description = 'jumbotours: city missing.jumbotours: city missing.',
        is_cached = 'no'
        WHERE id = '12727395';
[07/08/2024 05:51:23], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 05:51: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('132976', 'CANCELLATION_FEE', 'j2/08_07_2024/request_CANCELLATION_FEE_yogeshqtech_132976_05_51_29_1720417889.xml', 'j2/08_07_2024/response_CANCELLATION_FEE_yogeshqtech_132976_05_51_29_1720417889.xml', 'j2/08_07_2024/response_header_CANCELLATION_FEE_yogeshqtech_132976_05_51_29_1720417889.xml', 'jumbotours', '2024-07-08 05:51:30', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_CANCELLATION_FEE_yogeshqtech_132976_05_51_29_1720417889.xml');
[07/08/2024 05:51:35], [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('132976', 'CANCEL', 'j2/08_07_2024/request_cancel_yogeshqtech_132976_05_51_33_1720417893.xml', 'j2/08_07_2024/response_cancel_yogeshqtech_132976_05_51_33_1720417893.xml', 'j2/08_07_2024/response_header_cancel_yogeshqtech_132976_05_51_33_1720417893.xml', 'jumbotours', '2024-07-08 05:51:35', '','https://betalive.astrabookings.com/project_folder/astra_protected//supplier_logs/j2/08_07_2024/response_cancel_yogeshqtech_132976_05_51_33_1720417893.xml');
[07/08/2024 05:51:35], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],INSERT INTO history_bookings set history_booking_id ='132976', agent_id ='949', itenirary_id ='', confirmation_number ='8141173618', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='supriya@gmail.com', leader_title ='Mr', leader_first_name ='Sup', leader_last_name ='Sonar', city_id ='dubai', country_id ='138', display_room_rate ='31.550', native_room_rate ='30.050', native_currency_code ='USD', additional_charge ='0.000', cancellation_policy ='<b>STANDARD ROOM ROOM ONLY </b><br>Free cancellation up to 2024-07-22 05:29:59<br>If you cancel between 2024-07-22 05:30:00 and 2024-07-28 00:00:00 , you will be charged 31.55 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 22nd 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 05:16:05', create_date ='2024-07-08 05:16:05', source_type ='jumbotours', expiration_date ='2024-07-22 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.	.ROOM CONDITIONS: If the title of the room does not specify if there is an extra bed. Child will share the bed with adults<br>ADDITIONAL INFO: Tourism Dirham to be paid by Guest upon check-in at the hotel. Nationality with UAE Residence & UAE nationals UAE rates will apply. Any cancellation & rebooking at lower rate is not allowed.', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='', native_rate ='', display_rate ='', agent_rate ='31.550', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='30.050', 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 05:51:35', modified_by ='', display_currency_code ='USD', created_datetime ='2024-07-08 05:51:35', 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 05:51:35], [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
		('','','132976','cancelled','2024-07-08 05:51:35','','949','103.104.226.130','','','');
[07/08/2024 05:51:35], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],UPDATE bookings SET current_status='cancelled',status_date='2024-07-08 05:51:35' , pending_cancellation = 'no' WHERE reservation_id = '1877195' AND id = '132976' 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 05:51:35], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update booking_commission set status='D'  where booking_id ='132976';
[07/08/2024 05:51:35], [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 = '132976' AND (current_status = 'cancelled' ) ;
[07/08/2024 05:51:35], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],delete from cancellations where booking_id =? ;
[07/08/2024 05:51:35], [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','1877195','132976','2024-07-08 05:51:35','',' ');
[07/08/2024 05:51:37], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 05:51:39], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132976','deepak.trivedi@qtechsoftware.com');
[07/08/2024 05:51:39], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132976','demo@demo.demo');
[07/08/2024 05:51:41], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132976','ops@astrabookings.com');
[07/08/2024 05:51:41], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132976','info@astrabookings.com');
[07/08/2024 05:51:41], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],insert into temp(booking_id,mail_send_to)values('132976','ops@astrabookings.com');
[07/08/2024 05:51:49], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 05:51:52], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/08/2024 05:52:08], [file name :-/efsdata/otrams/public_html/beta/booking_list.php],update messages set mssg_status='R' where booking_id=?;
