[07/26/2021 01:38:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2021-07-26 01:38:31',login_attempt=0 where id = '21';
[07/26/2021 01:38:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'ankita', user_type = 'A', branch_id = '3', login_datetime = '2021-07-26 13:38:31', ip = '43.250.210.73', action = 'Login' ;
[07/26/2021 01:38:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '43.250.210.73' , city = 'colombo' , service_name = '' , service_type = 'hotel' , arrival_date = '2021/07/28' , departure_date = '2021/07/29' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2021-07-26 13:38:55' , site_id = '' , country_code = '132' , web_service = '' ;
[07/26/2021 01:39:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2021-07-26 01:39:02', '', 'fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e', '6');
[07/26/2021 01:39:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e&xml_user_id=21&request_no=0&local_hotel_code=35&#039;,&#039;36&#039;,&#039;60&#039;,&#039;61&#039;,&#039;65&#039;,&#039;77&#039;,&#039;53699&#039;,&#039;53700&#039;,&#039;38&#039;,&#039;39&#039;,&#039;99&#039;,&#039;78&#039;,&#039;51821&#039;,&#039;76&#039;,&#039;51811&#039;,&#039;53701&#039;,&#039;51808&#039;,&#039;53725&#039;,&#039;53733&#039;,&#039;51817&#039;,&#039;53770&#039;,&#039;53777&web_service=no&site_id='
, http_hit_time = '2021-07-26 13:39:01.554'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.238'
, error_description = ''
, memory_used = '11656768'
WHERE id = '3412';
[07/26/2021 01:39:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e',
  duration = '1.885',
  merge_duration = '0.098',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.81',
  system_load_5_min = '1.24',
  system_load_15_min = '1.28',
  system_memory_usage = '95.12',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '6') + '8244240',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '6';
[07/26/2021 01:41:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '43.250.210.73' , city = 'colombo' , service_name = '' , service_type = 'hotel' , arrival_date = '2021/07/28' , departure_date = '2021/07/29' , nationality = '3' , nights = '1' , room_types = '2, 2' , create_date = '2021-07-26 13:41:40' , site_id = '' , country_code = '132' , web_service = '' ;
[07/26/2021 01:41:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2021-07-26 01:41:44', '', 'fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e', '7');
[07/26/2021 01:41:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e&xml_user_id=21&request_no=0&local_hotel_code=35&#039;,&#039;36&#039;,&#039;60&#039;,&#039;61&#039;,&#039;65&#039;,&#039;77&#039;,&#039;53699&#039;,&#039;53700&#039;,&#039;38&#039;,&#039;39&#039;,&#039;99&#039;,&#039;78&#039;,&#039;51821&#039;,&#039;76&#039;,&#039;51811&#039;,&#039;53701&#039;,&#039;51808&#039;,&#039;53725&#039;,&#039;53733&#039;,&#039;51817&#039;,&#039;53770&#039;,&#039;53777&web_service=no&site_id='
, http_hit_time = '2021-07-26 13:41:43.251'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.096'
, error_description = ''
, memory_used = '11657624'
WHERE id = '3413';
[07/26/2021 01:41:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e',
  duration = '1.682',
  merge_duration = '0.076',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.08',
  system_load_5_min = '1.56',
  system_load_15_min = '1.42',
  system_memory_usage = '95.09',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '7') + '8245008',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '7';
[07/26/2021 01:42:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/show_hotel_details.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Test Hotel', 'colombo', '132', '21', '', '3', '', 'hoteldetails', '2021-07-26 :13:42:06','');
[07/26/2021 01:42:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1627306956','43.250.210.73');
[07/26/2021 01:46:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1627307195','43.250.210.73');
[07/26/2021 01:46:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = '1971', create_date = '2021-07-26 13:46:46', agent_id = '21', parent_agent_id = '21', agent_ref_no = '12334', nationality = 'Bahamian', city_id = 'colombo', country_id = '132', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '2406.58', display_currency_code = 'INR', native_room_rate = '420', native_currency_code = 'ZAR', supplier_profile_id = '1', service_type = 'hotel', service_date = '2021/07/28', check_out_date = '2021/07/29', sub_user_id = '', booking_status = '1', leader_title = 'Ms', leader_first_name = 'Ankita', leader_last_name = 'Rao', booking_branch_id = '3', expiration_date = '2021-07-27 00:00:00', cancellation_policy = 'Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.<Br><Br><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 2406.58 INR applicable if cancelled after 27-Jul-2021 05:30 hrs.', supplier_cancellation_policy = '', status_date = '2021-07-26 13:46:46',  site_url = 'https://alpha.otrams.thefabulousgetaway.com/';
[07/26/2021 01:46:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/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 ('3129','TEST HOTEL','TEST HOTEL','53733','53733','colombo','LOCAL_SUPPLIER',NOW());
[07/26/2021 01:46:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '3'
        WHERE
        id='3129'
        ;
[07/26/2021 01:46:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into bookings_details(booking_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,local_hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('3129','S000000203','2','2','0','-','','','53733','53733','TEST HOTEL','Test Hotel','111111111','4.0','1','2021/07/28','2021/07/29','','https://alpha.otrams.thefabulousgetaway.com//cpfv3/images/?image=aHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU4ODY2NDk3OF9tYWluXzkyNjIwMjAxLmpwZw==');
[07/26/2021 01:46:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '3129', booking_detail_id = '1244', room_type_code = '2~~~132~~~810~~~1~~~~~~~~~71100~~~0~~~S000000203', room_name = 'double', room_type_description = 'Standard   - Bed & Breakfast : 2 Pax ', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";d:1203.29;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:202:\"Supplier Name - localsupplier(TestHotel - S000000203), Rate - 210 ZAR, Currency Multiplier (ZAR-INR) - 4.78134 Supplier Commission-0% #localsystem, VAT Markup=7.000%, Agent Hotel Category Markup=12.00 %\";}}', native_nightly_rates = 'a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:210;s:17:\"nativeNightlyRate\";i:210;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}', markup = '0', commission = '0', native_room_rate_total = '420', display_room_rate_total = '2406.58', number_of_rooms = '2';
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into passangers set  booking_id = '3129', booking_detail_id = '1244', rid = '1850', room = '0', salutations = 'Ms', first_name = 'Ankita', last_name = 'Rao', passenger_type = 'adult', age = '';
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into passangers set  booking_id = '3129', booking_detail_id = '1244', rid = '1850', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into passangers set  booking_id = '3129', booking_detail_id = '1244', rid = '1850', room = '1', salutations = 'Mr', first_name = 'TBAC', last_name = 'TBAC', passenger_type = 'adult', age = '';
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into passangers set  booking_id = '3129', booking_detail_id = '1244', rid = '1850', room = '1', salutations = 'Mr', first_name = 'TBAD', last_name = 'TBAD', passenger_type = 'adult', age = '';
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', current_status = 'confirmed', comment_contract = '', consultant_id = 'nitinalpha', sales_manager_id = '', admin_booked = '0', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '43.250.210.73', backoffice_user = 'tfg', customer_id = '', applied_multiplier='4.78134', free_sale='',  applied_markup='19.84',  agent_markup='19.84',  basecurrency_multiplier='0.01533',  basecurrency_multiplier_native='0.07328',  parent_agent_id='21',  sub_agent_rate='0', agent_rate='2406.58',  applicable_service_tax='0',  supplier_rate='420',  original_source='',  uid='bdcafda1ed4b264558d3b06099e155ab'  where id='3129';
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' ,gtaToken = '' , special_request='' where booking_id ='3129';
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,supplier_charge,agent_charge,lead_time,create_date)  VALUES('3129','2021-07-27 05:30:00','2021-07-27 05:30:00','420','2406.58','0','2021-07-26 13:46:47');
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('3129','','');
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_status (booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('3129','confirmed','2021-07-26 13:46:47','Booking confirmed . Booked by Back Office tfg on behalf of Agent - Ankita  Rao(CD0021)','21','43.250.210.73','0','21');
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details) VALUES(3129, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"60febb987343524e49741683\";}s:7:\"hotelId\";s:25:\"53733----------S000000203\";s:4:\"name\";s:10:\"TEST HOTEL\";s:14:\"local_hotel_id\";s:5:\"53733\";s:8:\"address1\";s:10:\"Test Hotel\";s:8:\"latitude\";s:0:\"\";s:9:\"longitude\";s:0:\"\";s:4:\"city\";s:5:\"71100\";s:8:\"location\";s:0:\"\";s:14:\"prefered_hotel\";s:1:\"0\";s:10:\"mlosSlogan\";s:0:\"\";s:16:\"isMlosApplicable\";s:2:\"no\";s:7:\"country\";s:3:\"132\";s:16:\"rateCurrencyCode\";s:3:\"INR\";s:5:\"phone\";s:9:\"111111111\";s:16:\"shortDescription\";s:24:\"No Description Available\";s:11:\"website_url\";s:0:\"\";s:12:\"thumbNailUrl\";s:237:\"https://alpha.otrams.thefabulousgetaway.com//cpfv3/images/?image=aHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU4ODY2NDk3OF9tYWluXzkyNjIwMjAxLmpwZw==\";s:10:\"sourceType\";s:11:\"localsystem\";s:10:\"supplierid\";s:10:\"S000000203\";s:12:\"suppliername\";s:9:\"TestHotel\";s:14:\"propertyRating\";s:3:\"4.0\";s:15:\"specialCategory\";a:1:{i:0;s:1:\"1\";}s:13:\"HotelProperty\";a:1:{s:11:\"localsystem\";a:2:{i:0;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:33:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:210;s:17:\"nativeNightlyRate\";i:210;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";d:1203.29;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:202:\"Supplier Name - localsupplier(TestHotel - S000000203), Rate - 210 ZAR, Currency Multiplier (ZAR-INR) - 4.78134 Supplier Commission-0% #localsystem, VAT Markup=7.000%, Agent Hotel Category Markup=12.00 %\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";N;s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"a58a736772beb74d45a09d486bf98f7d\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"0\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"ZAR\";s:20:\"displayRoomTypeRates\";d:2406.58;s:20:\"sortingRoomTypeRates\";d:2406.58;s:19:\"nativeRoomTypeRates\";i:420;s:12:\"offerApplied\";N;s:7:\"room_id\";s:48:\"2~~~132~~~810~~~1~~~~~~~~~71100~~~0~~~S000000203\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:48:\"2~~~132~~~810~~~1~~~~~~~~~71100~~~0~~~S000000203\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:2;s:10:\"supplierId\";s:10:\"S000000203\";s:12:\"supplierName\";s:9:\"TestHotel\";s:10:\"meal_basis\";s:17:\"  Bed & Breakfast\";s:4:\"note\";s:0:\"\";s:13:\"room_category\";s:13:\"Standard Room\";s:9:\"room_type\";s:37:\"Standard   - Bed & Breakfast : 2 Pax \";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"0_0_53733_7789015\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";d:2406.58;s:14:\"nativeRoomRate\";i:420;s:9:\"unique_id\";s:37:\"1_53733----------S000000203_0_0_81465\";s:10:\"supplierId\";s:10:\"S000000203\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"ZAR\";s:18:\"applied_markup_per\";d:19.84;s:18:\"applied_multiplier\";d:4.78134;s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53733----------S000000203\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:10:\"TEST HOTEL\";s:18:\"supp_hotel_address\";s:10:\"Test Hotel\";s:10:\"supplierId\";s:10:\"S000000203\";}s:8:\"no_class\";i:0;}}i:1;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:33:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:250;s:17:\"nativeNightlyRate\";i:250;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";d:1432.49;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:202:\"Supplier Name - localsupplier(TestHotel - S000000203), Rate - 250 ZAR, Currency Multiplier (ZAR-INR) - 4.78134 Supplier Commission-0% #localsystem, VAT Markup=7.000%, Agent Hotel Category Markup=12.00 %\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";N;s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"f5ab8d5e74597f7a76467b7e664644bb\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"0\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"ZAR\";s:20:\"displayRoomTypeRates\";d:2864.98;s:20:\"sortingRoomTypeRates\";d:2864.98;s:19:\"nativeRoomTypeRates\";i:500;s:12:\"offerApplied\";N;s:7:\"room_id\";s:47:\"2~~~22~~~812~~~1~~~~~~~~~71100~~~1~~~S000000203\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:47:\"2~~~22~~~812~~~1~~~~~~~~~71100~~~1~~~S000000203\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:2;s:10:\"supplierId\";s:10:\"S000000203\";s:12:\"supplierName\";s:9:\"TestHotel\";s:10:\"meal_basis\";s:17:\"  Bed & Breakfast\";s:4:\"note\";s:0:\"\";s:13:\"room_category\";s:17:\"Deluxe Suite Room\";s:9:\"room_type\";s:41:\"Deluxe Suite   - Bed & Breakfast : 2 Pax \";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"1_1_53733_9609428\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";d:2864.98;s:14:\"nativeRoomRate\";i:500;s:9:\"unique_id\";s:37:\"1_53733----------S000000203_0_1_64110\";s:10:\"supplierId\";s:10:\"S000000203\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"ZAR\";s:18:\"applied_markup_per\";d:19.84;s:18:\"applied_multiplier\";d:4.78134;s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53733----------S000000203\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:10:\"TEST HOTEL\";s:18:\"supp_hotel_address\";s:10:\"Test Hotel\";s:10:\"supplierId\";s:10:\"S000000203\";}s:8:\"no_class\";i:0;}}}}s:13:\"total_charges\";d:2406.58;s:17:\"propertyAvailable\";i:1;s:8:\"no_class\";i:0;s:18:\"sort_total_charges\";d:2406.58;s:16:\"hotel_name_ascii\";s:10:\"test hotel\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53733----------S000000203\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:10:\"TEST HOTEL\";s:18:\"supp_hotel_address\";s:10:\"Test Hotel\";s:10:\"supplierId\";s:10:\"S000000203\";}}');
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/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('3129','2021-07-27 05:30:00','2021-07-27 05:30:00','1970-01-01 00:00:00','1970-01-01 00:00:00','420','2406.58','0','2021-07-26 13:46:47','');
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '3129',  room_id= '2~~~132~~~810~~~1~~~~~~~~~71100~~~0~~~S000000203',  room_name= 'double',  supplier_id= 'S000000203',  agent_id= '21',  applied_native_discount= '0',  original_native_rate= '210',  native_rate= '210',  promotion_text= '',  offer_disc_type= '',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2021-07-26 13:46:47' ;
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set confirmation_number='',itenirary_id='3129' where  id ='3129';
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-2,consumed_inventory = consumed_inventory+2 WHERE hotel_id = '53733' and inventory_class_id = '132' and supplier_id = 'S000000203' and date_from = '2021-07-28';
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update supplement_rate set inventory = '0' where supplement_rate_id = '1';
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_configuration set  booking_id = '3129', config_key = 'BOOKING OTP', config_value = 'HZGjvF7o';;
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update posted_bookings set booking_id='3129',status='1' where reservation_id='1971' and booking_id ='0';
[07/26/2021 01:46:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update xmllogs set reservation_id='3129' where agent_logs_id='7' and source_type='localsystem';
[07/26/2021 01:46:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103129 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27464 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,nitin@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2021-07-26 13:46:48';
[07/26/2021 01:46:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3129','snehal.valanju@qtechsoftware.com');
[07/26/2021 01:46:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3129','nitin@qtechsoftware.com');
[07/26/2021 01:51:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '43.250.210.73' , city = 'Colombo' , arrival_date='2021/07/27',  departure_date='2021/07/27',  nights='1',  create_date='2021-07-26 :13:51:31',  nationality='132',  additional_markup='',  selected_currency='EUR',  service_type='transfer',  total_adult='1',  total_children='',  site_id = '' ;
[07/26/2021 01:53:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],insert into email_logs SET `subject`= 'Required Cancellation Policy  for Colombo-Kandy Train Journey transfer',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICwgPGJyPjxicj5QbGVhc2UgYWRkIHRoZSBDYW5jZWxsYXRpb24gUG9saWN5IGZvciA8Yj5Db2xvbWJvLUthbmR5IFRyYWluIEpvdXJuZXk8L2I+IHRyYW5zZmVyLiA8YnI+PGJyPg==',to_email_id= '',cc= '',bcc= '',status= 'You must provide at least one recipient email address.',page_url= '/transfer_book_now.php',create_date= '2021-07-26 13:53:12';
[07/26/2021 01:53:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_book_now.php],INSERT INTO mails_error_log set mailfrom='sanket.desai@qtechsoftware.com',mailsubject='Required Cancellation Policy  for Colombo-Kandy Train Journey transfer',mailbody='Dear Team , &lt;br&gt;&lt;br&gt;Please add the Cancellation Policy for &lt;b&gt;Colombo-Kandy Train Journey&lt;/b&gt; transfer. &lt;br&gt;&lt;br&gt;',mailto='',mailcc='',mailbcc='',mailattachment='',reason='You must provide at least one recipient email address.',date_time='2021-07-26 01:53:12';
[07/26/2021 01:56:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],DELETE FROM report_access where psa_user_id='21';
[07/26/2021 01:56:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],INSERT INTO report_access SET psa_user_id='21',report_function_name='invoice_report';
[07/26/2021 01:56:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],INSERT INTO report_access SET psa_user_id='21',report_function_name='voucher_report';
[07/26/2021 01:56:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],INSERT INTO report_access SET psa_user_id='21',report_function_name='receipts_report';
[07/26/2021 01:56:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],INSERT INTO report_access SET psa_user_id='21',report_function_name='customer_statement';
[07/26/2021 01:59:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/26/2021 01:59:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '43.250.210.73' , city = 'colombo' , service_name = 'Test Hotel' , service_type = 'hotel' , arrival_date = '2021/07/29' , departure_date = '2021/07/30' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2021-07-26 13:59:44' , site_id = '' , country_code = '132' , web_service = '' ;
[07/26/2021 01:59:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2021-07-26 01:59:47', '', 'fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e', '9');
[07/26/2021 01:59:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e&xml_user_id=21&request_no=0&local_hotel_code=53733&web_service=no&site_id='
, http_hit_time = '2021-07-26 13:59:47.22'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.001'
, error_description = ''
, memory_used = '11609408'
WHERE id = '3414';
[07/26/2021 01:59:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e',
  duration = '1.452',
  merge_duration = '0.090',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.13',
  system_load_5_min = '0.53',
  system_load_15_min = '1.00',
  system_memory_usage = '95.51',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '9') + '6605656',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '9';
[07/26/2021 01:59:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '43.250.210.73' , city = 'colombo' , service_name = 'Test Hotel' , service_type = 'hotel' , arrival_date = '2021/07/28' , departure_date = '2021/07/29' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2021-07-26 13:59:54' , site_id = '' , country_code = '132' , web_service = '' ;
[07/26/2021 01:59:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2021-07-26 01:59:58', '', 'fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e', '10');
[07/26/2021 01:59:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e&xml_user_id=21&request_no=0&local_hotel_code=53733&web_service=no&site_id='
, http_hit_time = '2021-07-26 13:59:57.131'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.605'
, error_description = ''
, memory_used = '11609784'
WHERE id = '3415';
[07/26/2021 01:59:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=fa0200c4668d9f10a7ecaa5b09ffa65e6aacf6c015af72ddedea1882da6a664e',
  duration = '2.027',
  merge_duration = '0.058',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.18',
  system_load_5_min = '0.53',
  system_load_15_min = '1.00',
  system_memory_usage = '95.51',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '10') + '6605528',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '10';
