[07/11/2020 12:50:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-11 12:50:47',login_attempt=0 where id = '21';
[07/11/2020 12:50:47], [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 = '2020-07-11 12:50:47', ip = '150.129.29.107', action = 'Login' ;
[07/11/2020 12:51:23], [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 = '150.129.29.107' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/17' , departure_date = '2020/07/18' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-11 12:51:23' , site_id = '' , country_code = '106' , web_service = '' ;
[07/11/2020 12:51:28], [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', '2020-07-11 12:51:28', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '340');
[07/11/2020 12:51:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&web_service=no&site_id='
, http_hit_time = '2020-07-11 12:51:27.765'
, 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.833'
, error_description = ''
, memory_used = '8020520'
WHERE id = '2877';
[07/11/2020 12:51:29], [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=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '2.513',
  merge_duration = '0.165',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.00',
  system_load_5_min = '1.01',
  system_load_15_min = '0.93',
  system_memory_usage = '89.63',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '340') + '8148720',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '340';
[07/11/2020 12:51:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594471916','150.129.29.107');
[07/11/2020 12:51:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.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 ('Creamcentre', 'mumbai', '106', '21', '', '3', '', 'hotelcancellationpolicy', '2020-07-11 :12:51:57','');
[07/11/2020 12:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594471921','150.129.29.107');
[07/11/2020 12:52:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_addtoquote.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 ('Creamcentre', 'mumbai', '106', '21', '', '3', '', 'hotelquotation', '2020-07-11 :12:52:07','');
[07/11/2020 12:52:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_addtoquote.php],INSERT INTO agent_quotation SET q_name = 'Fronend quotation',unique_id = 'CD0021Q4',backoffice_user = 'tfg',currency ='INR',service_date='2020-07-17 00:00:00',service_checkout_date='2020-07-18 00:00:00',city_code = '64440',country_code = '106',nationality = '3',total_adult = '2',total_child = '',child_age = 'a%3A0%3A%7B%7D',sequence = '2',agent_id = '21',create_date = '2020-07-11 12:52:07',q_info = 'a%3A22%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1594944000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2217%2F07%2F2020+--+18%2F07%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A24%3A%225f09b5d1bff2aa70e432b281%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253748%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53748----------S000000218_9_0_63133%22%3Bs%3A4%3A%22name%22%3Bs%3A11%3A%22CREAMCENTRE%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A4%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A34%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bd%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A200%3Bs%3A9%3A%22free_sale%22%3Bs%3A2%3A%22no%22%3Bs%3A14%3A%22Discount%2FOffer%22%3Ba%3A7%3A%7Bs%3A4%3A%22code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%220218-11503%22%3B%7Ds%3A4%3A%22Name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Promotion%22%3B%7Ds%3A7%3A%22S_Value%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3B%7Ds%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Promotion%22%3B%7Ds%3A10%3A%22Offer_Note%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3B%7Ds%3A10%3A%22Offer_Type%22%3BN%3B%7D%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bd%3A240%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A194%3A%22Supplier+Name+-+localsupplier%28Creamcentre+-+S000000218%29%2C+Rate+-+200+INR%2C+Currency+Multiplier+%28INR-INR%29+-+1.00000+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem+Agent+Hotel+Category+Markup%3D20.00+%25%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_note%22%3Bs%3A9%3A%22Promotion%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A9%3A%22stay_note%22%3Bs%3A46%3A%22Tax+will+be+collected+at+the+time+of+Check-Out%22%3Bs%3A10%3A%22time_stamp%22%3Bs%3A32%3A%2212f937a23d868b7cfbf969b46ca3d230%22%3Bs%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A10%3A%22view_basis%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22view_basis_id%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22available%22%3Bi%3A1%3Bs%3A9%3A%22free_sale%22%3BN%3Bs%3A7%3A%22minStay%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A240%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A240%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A200%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E140%7E%7E%7E922%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000218%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A16%3A%22valuation_number%22%3Bs%3A48%3A%222%7E%7E%7E140%7E%7E%7E922%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000218%22%3Bs%3A15%3A%22number_of_child%22%3Bi%3A0%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A11%3A%22Creamcentre%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A37%3A%22Promotion%7E+FREE+WIFI+%28Non-Refundable%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A28%3A%22ROH+%28Standard%2FSuperior%29+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A112%3A%22ROH+%28Standard%2FSuperior%29++-Bed+%26+Breakfast+%3A+2+Pax+%3Cbr%3E%28+Promotion%29%3Cbr%3E%28Offer+Note%3A+%7E+FREE+WIFI%29+%28Non-Refundable%29%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%220_0_53748_8932424%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A240%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A200%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53748----------S000000218_9_0_63133%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A20%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253748----------S000000218%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A11%3A%22CREAMCENTRE%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3B%7Ds%3A8%3A%22no_class%22%3Bi%3A0%3B%7D%7Di%3A1%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A34%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bd%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A200%3Bs%3A9%3A%22free_sale%22%3Bs%3A2%3A%22no%22%3Bs%3A14%3A%22Discount%2FOffer%22%3Ba%3A7%3A%7Bs%3A4%3A%22code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%220218-11503%22%3B%7Ds%3A4%3A%22Name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Promotion%22%3B%7Ds%3A7%3A%22S_Value%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3B%7Ds%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Promotion%22%3B%7Ds%3A10%3A%22Offer_Note%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3B%7Ds%3A10%3A%22Offer_Type%22%3BN%3B%7D%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bd%3A240%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A194%3A%22Supplier+Name+-+localsupplier%28Creamcentre+-+S000000218%29%2C+Rate+-+200+INR%2C+Currency+Multiplier+%28INR-INR%29+-+1.00000+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem+Agent+Hotel+Category+Markup%3D20.00+%25%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_note%22%3Bs%3A9%3A%22Promotion%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A9%3A%22stay_note%22%3BN%3Bs%3A10%3A%22time_stamp%22%3Bs%3A32%3A%22c06bc24583a2a349726760bd287bcab9%22%3Bs%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A10%3A%22view_basis%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22view_basis_id%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22available%22%3Bi%3A1%3Bs%3A9%3A%22free_sale%22%3BN%3Bs%3A7%3A%22minStay%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A240%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A240%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A200%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E140%7E%7E%7E923%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E1%7E%7E%7ES000000218%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A16%3A%22valuation_number%22%3Bs%3A48%3A%222%7E%7E%7E140%7E%7E%7E923%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E1%7E%7E%7ES000000218%22%3Bs%3A15%3A%22number_of_child%22%3Bi%3A0%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A11%3A%22Creamcentre%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A20%3A%22Promotion%7E+FREE+WIFI%22%3Bs%3A13%3A%22room_category%22%3Bs%3A28%3A%22ROH+%28Standard%2FSuperior%29+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A95%3A%22ROH+%28Standard%2FSuperior%29++-Bed+%26+Breakfast+%3A+2+Pax+%3Cbr%3E%28+Promotion%29%3Cbr%3E%28Offer+Note%3A+%7E+FREE+WIFI%29%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%221_1_53748_2963872%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A240%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A200%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53748----------S000000218_9_1_84698%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A20%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253748----------S000000218%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A11%3A%22CREAMCENTRE%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3B%7Ds%3A8%3A%22no_class%22%3Bi%3A0%3B%7D%7Di%3A2%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A34%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bd%3A230%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A230%3Bs%3A9%3A%22free_sale%22%3Bs%3A2%3A%22no%22%3Bs%3A14%3A%22Discount%2FOffer%22%3Ba%3A7%3A%7Bs%3A4%3A%22code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%220218-11503%22%3B%7Ds%3A4%3A%22Name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Promotion%22%3B%7Ds%3A7%3A%22S_Value%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3B%7Ds%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Promotion%22%3B%7Ds%3A10%3A%22Offer_Note%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3B%7Ds%3A10%3A%22Offer_Type%22%3BN%3B%7D%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bd%3A276%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A194%3A%22Supplier+Name+-+localsupplier%28Creamcentre+-+S000000218%29%2C+Rate+-+230+INR%2C+Currency+Multiplier+%28INR-INR%29+-+1.00000+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem+Agent+Hotel+Category+Markup%3D20.00+%25%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_note%22%3Bs%3A9%3A%22Promotion%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A9%3A%22stay_note%22%3BN%3Bs%3A10%3A%22time_stamp%22%3Bs%3A32%3A%22d2b43a976080118364a2b3af701a4dbf%22%3Bs%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A10%3A%22view_basis%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22view_basis_id%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22available%22%3Bi%3A1%3Bs%3A9%3A%22free_sale%22%3BN%3Bs%3A7%3A%22minStay%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A276%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A276%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A230%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E925%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E2%7E%7E%7ES000000218%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A16%3A%22valuation_number%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E925%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E2%7E%7E%7ES000000218%22%3Bs%3A15%3A%22number_of_child%22%3Bi%3A0%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A11%3A%22Creamcentre%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A37%3A%22Promotion%7E+FREE+WIFI+%28Non-Refundable%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A23%3A%22Junior+Suite+Tower+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A107%3A%22Junior+Suite+Tower++-Bed+%26+Breakfast+%3A+2+Pax+%3Cbr%3E%28+Promotion%29%3Cbr%3E%28Offer+Note%3A+%7E+FREE+WIFI%29+%28Non-Refundable%29%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%222_2_53748_1339408%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A276%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A230%3Bs%3A9%3A%22unique_id%22%3Bs%3A36%3A%221_53748----------S000000218_9_2_1507%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A20%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253748----------S000000218%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A11%3A%22CREAMCENTRE%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3B%7Ds%3A8%3A%22no_class%22%3Bi%3A0%3B%7D%7Di%3A3%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A34%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bd%3A230%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A230%3Bs%3A9%3A%22free_sale%22%3Bs%3A2%3A%22no%22%3Bs%3A14%3A%22Discount%2FOffer%22%3Ba%3A7%3A%7Bs%3A4%3A%22code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%220218-11503%22%3B%7Ds%3A4%3A%22Name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Promotion%22%3B%7Ds%3A7%3A%22S_Value%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3B%7Ds%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Promotion%22%3B%7Ds%3A10%3A%22Offer_Note%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3B%7Ds%3A10%3A%22Offer_Type%22%3BN%3B%7D%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bd%3A276%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A194%3A%22Supplier+Name+-+localsupplier%28Creamcentre+-+S000000218%29%2C+Rate+-+230+INR%2C+Currency+Multiplier+%28INR-INR%29+-+1.00000+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem+Agent+Hotel+Category+Markup%3D20.00+%25%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_note%22%3Bs%3A9%3A%22Promotion%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A9%3A%22stay_note%22%3BN%3Bs%3A10%3A%22time_stamp%22%3Bs%3A32%3A%22a232054c3b76d82c8d71250bbc0ec34c%22%3Bs%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A10%3A%22view_basis%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22view_basis_id%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22available%22%3Bi%3A1%3Bs%3A9%3A%22free_sale%22%3BN%3Bs%3A7%3A%22minStay%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A276%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A276%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A230%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E926%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E3%7E%7E%7ES000000218%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A16%3A%22valuation_number%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E926%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E3%7E%7E%7ES000000218%22%3Bs%3A15%3A%22number_of_child%22%3Bi%3A0%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A11%3A%22Creamcentre%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A20%3A%22Promotion%7E+FREE+WIFI%22%3Bs%3A13%3A%22room_category%22%3Bs%3A23%3A%22Junior+Suite+Tower+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A90%3A%22Junior+Suite+Tower++-Bed+%26+Breakfast+%3A+2+Pax+%3Cbr%3E%28+Promotion%29%3Cbr%3E%28Offer+Note%3A+%7E+FREE+WIFI%29%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%223_3_53748_7175107%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A276%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A230%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53748----------S000000218_9_3_67031%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A20%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253748----------S000000218%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A11%3A%22CREAMCENTRE%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3B%7Ds%3A8%3A%22no_class%22%3Bi%3A0%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bd%3A6.278698%3Bs%3A9%3A%22longitude%22%3Bd%3A99.730656%3Bs%3A13%3A%22numberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A17%3A%22selectedUserTypes%22%3Ba%3A1%3A%7Bs%3A6%3A%22double%22%3Ba%3A20%3A%7Bs%3A2%3A%22id%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22room_type_display%22%3Bs%3A6%3A%22Double%22%3Bs%3A24%3A%22room_type_display_arabic%22%3Bs%3A12%3A%22%D9%85%D8%B2%D8%AF%D9%88%D8%AC%D8%A9%22%3Bs%3A9%3A%22room_type%22%3Bs%3A6%3A%22double%22%3Bs%3A13%3A%22child_allowed%22%3Bs%3A2%3A%22no%22%3Bs%3A12%3A%22no_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A11%3A%22no_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22child_from%22%3Bs%3A1%3A%220%22%3Bs%3A8%3A%22child_to%22%3Bs%3A1%3A%220%22%3Bs%3A8%3A%22sequence%22%3Bs%3A1%3A%221%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3Bs%3A11%3A%22create_date%22%3Bs%3A10%3A%222007-09-14%22%3Bs%3A11%3A%22modify_date%22%3Bs%3A10%3A%222014-02-13%22%3Bs%3A13%3A%22property_type%22%3BN%3Bs%3A7%3A%22is_twin%22%3Bs%3A1%3A%220%22%3Bs%3A14%3A%22selected_rooms%22%3Bi%3A1%3Bs%3A8%3A%22room_key%22%3Bi%3A0%3Bs%3A9%3A%22occurance%22%3Bi%3A1%3Bs%3A10%3A%22AdultCount%22%3Bi%3A2%3Bs%3A10%3A%22childCount%22%3Bi%3A0%3B%7D%7Ds%3A13%3A%22selected_city%22%3Bs%3A6%3A%22mumbai%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A1%3A%223%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A81%3A%22http%3A%2F%2Fuat.tfg.otrams.net%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A14%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A34%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bd%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A200%3Bs%3A9%3A%22free_sale%22%3Bs%3A2%3A%22no%22%3Bs%3A14%3A%22Discount%2FOffer%22%3Ba%3A7%3A%7Bs%3A4%3A%22code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%220218-11503%22%3B%7Ds%3A4%3A%22Name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Promotion%22%3B%7Ds%3A7%3A%22S_Value%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3B%7Ds%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Promotion%22%3B%7Ds%3A10%3A%22Offer_Note%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3B%7Ds%3A10%3A%22Offer_Type%22%3BN%3B%7D%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bd%3A240%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A194%3A%22Supplier+Name+-+localsupplier%28Creamcentre+-+S000000218%29%2C+Rate+-+200+INR%2C+Currency+Multiplier+%28INR-INR%29+-+1.00000+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem+Agent+Hotel+Category+Markup%3D20.00+%25%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_note%22%3Bs%3A9%3A%22Promotion%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3Bs%3A11%3A%22%7E+FREE+WIFI%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A9%3A%22stay_note%22%3Bs%3A46%3A%22Tax+will+be+collected+at+the+time+of+Check-Out%22%3Bs%3A10%3A%22time_stamp%22%3Bs%3A32%3A%2212f937a23d868b7cfbf969b46ca3d230%22%3Bs%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A10%3A%22view_basis%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22view_basis_id%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22available%22%3Bi%3A1%3Bs%3A9%3A%22free_sale%22%3BN%3Bs%3A7%3A%22minStay%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A240%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A240%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A200%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E140%7E%7E%7E922%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000218%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A16%3A%22valuation_number%22%3Bs%3A48%3A%222%7E%7E%7E140%7E%7E%7E922%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000218%22%3Bs%3A15%3A%22number_of_child%22%3Bi%3A0%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A11%3A%22Creamcentre%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A37%3A%22Promotion%7E+FREE+WIFI+%28Non-Refundable%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A28%3A%22ROH+%28Standard%2FSuperior%29+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A112%3A%22ROH+%28Standard%2FSuperior%29++-Bed+%26+Breakfast+%3A+2+Pax+%3Cbr%3E%28+Promotion%29%3Cbr%3E%28Offer+Note%3A+%7E+FREE+WIFI%29+%28Non-Refundable%29%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%220_0_53748_8932424%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A240%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A200%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53748----------S000000218_9_0_63133%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A20%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253748----------S000000218%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A11%3A%22CREAMCENTRE%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000218%22%3B%7Ds%3A8%3A%22no_class%22%3Bi%3A0%3Bs%3A19%3A%22cancellation_policy%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A8%3A%7Bs%3A18%3A%22cancellationPolicy%22%3Bs%3A457%3A%22Amendment+of+Dates%2C+Room+Category%2C+Passenger+Names+are+considered+as+Cancel+and+Rebook+by+most+of+the+Hotels.%0A++++++++Any+Changes+in+initial+booking+may+be+denied+by+the+supplier+or+may+result+in+extra+charges.%0A++++++++Confirmation+of+amendment+requests+is+subject+to+availablity+and+rates+at+the+time+of+amendment.%3CBr%3E%3CBr%3E%3CB%3E%3CU%3EDetailed+Cancellation+Policy%3A%3C%2FU%3E%3C%2FB%3E+%3Cbr%2F%3E+Cancellation+Charges+of+240+INR+applicable+if+cancelled+after+11+Jul+2020+18%3A22+hrs.%22%3Bs%3A24%3A%22cancellationPolicy_table%22%3Ba%3A1%3A%7Bs%3A12%3A%22no_room_wise%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A9%3A%22date_from%22%3Bs%3A17%3A%2211+Jul+2020+18%3A22%22%3Bs%3A7%3A%22date_to%22%3Bs%3A17%3A%2217-Jul-2020+00%3A00%22%3Bs%3A7%3A%22charges%22%3Bs%3A7%3A%22240+INR%22%3B%7D%7D%7Ds%3A26%3A%22cancellationPolicy_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A9%3A%22from_date%22%3Bs%3A17%3A%2211-Jul-2020+12%3A52%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22agent_charges%22%3Bi%3A240%3Bs%3A16%3A%22supplier_charges%22%3Bi%3A200%3B%7D%7Ds%3A16%3A%22inventory_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A18%3A%22cancellation_hours%22%3Bd%3A125.63305555555556%3Bs%3A6%3A%22office%22%3BN%3Bs%3A16%3A%22comment_contract%22%3Bs%3A46%3A%22Tax+will+be+collected+at+the+time+of+Check-Out%22%3Bs%3A21%3A%22applied_agent_charges%22%3Bi%3A240%3B%7D%7D%7D%7D',service = 'hotel',hotel_id = '5f09b5d1bff2aa70e432b281',additional_markup = '0',city_name ='mumbai',total_price ='240',cancelltion_policy ='  
&lt;!-- Added code to display price change while displaying cancelltion rate change in search listing - Swapnil Nagaonkar - 6 November 2014 - START --&gt;
			
&lt;!-- Ended code to display price change while displaying cancelltion rate change in search listing - Swapnil Nagaonkar - 6 November 2014 - END --&gt;

&lt;h2 class=&quot;cancellation&quot; style=&quot;  margin:14px 0px -15px 22px;font-weight:300;font-family: &#039;Source Sans Pro&#039;, sans-serif;color: #4d4d4d; font-size: 26px;&quot;&gt;Cancellation Policy&lt;/h2&gt;
&lt;table width=&quot;100%&quot; border=&quot;0&quot; cellspacing=&quot;5&quot; cellpadding=&quot;0&quot; style=&quot;font-family: &#039;Source Sans Pro&#039;, sans-serif;&quot;&gt;
	&lt;tr&gt;
	&lt;td&gt;
		&lt;table border=&quot;0&quot; width=&quot;100%&quot; align=&quot;center&quot; cellpadding=&quot;0&quot; cellspacing=&quot;10&quot; style=&quot;border: 1px dotted grey;margin-top:20px; color: #8b8e91; font-family: &#039;Source Sans Pro&#039;,sans-serif; font-size: 14px; font-weight: 400; line-height: 18px;&quot;&gt;
		 									&lt;tr&gt;
					&lt;td&gt;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.&lt;Br&gt;&lt;Br&gt;&lt;B&gt;&lt;U&gt;Detailed Cancellation Policy:&lt;/U&gt;&lt;/B&gt; &lt;br/&gt; Cancellation Charges of 240 INR applicable if cancelled after 11 Jul 2020 18:22 hrs.&lt;/td&gt;
				&lt;/tr&gt;
				
				
		&lt;/table&gt;
		&lt;/td&gt;
	&lt;/tr&gt;
&lt;/table&gt;	
',per_night ='240',room_type ='ROH (Standard/Superior) -Bed & Breakfast : 2 Pax &lt;br&gt;( Promotion)&lt;br&gt;(Offer Note: ~ FREE WIFI) (Non-Refundable)',room_rate ='240';
[07/11/2020 12:52:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594471941','150.129.29.107');
[07/11/2020 12:52:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594471970','150.129.29.107');
[07/11/2020 12:52:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = '1664', create_date = '2020-07-11 12:52:56', agent_id = '21', parent_agent_id = '21', agent_ref_no = '', nationality = 'Bahamian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '240', display_currency_code = 'INR', native_room_rate = '200', native_currency_code = 'INR', supplier_profile_id = '1', service_type = 'hotel', service_date = '2020/07/17', check_out_date = '2020/07/18', sub_user_id = '', booking_status = '1', leader_title = '', leader_first_name = '', leader_last_name = '', booking_branch_id = '3', expiration_date = '2020-07-11 12:53: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 240 INR applicable if cancelled after 11 Jul 2020 18:22 hrs.', supplier_cancellation_policy = '', status_date = '2020-07-11 12:52:56',  site_url = 'http://uat.tfg.otrams.net/';
[07/11/2020 12:52:56], [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 ('2780','CREAMCENTRE','CREAMCENTRE','53748','53748','mumbai','LOCAL_SUPPLIER',NOW());
[07/11/2020 12:52:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '3'
        WHERE
        id='2780'
        ;
[07/11/2020 12:52:56], [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('2780','S000000218','1','2','0','-','','','53748','53748','CREAMCENTRE','Test Address','+605 - 1234 5677','4.0','1','2020/07/17','2020/07/18','','http://uat.tfg.otrams.net/project_folder/tfg_project/images/imagenotavailable.jpg');
[07/11/2020 12:52:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '2780', booking_detail_id = '1087', room_type_code = '2~~~140~~~922~~~1~~~~~~~~~64440~~~0~~~S000000218', room_name = 'double', room_type_description = 'ROH (Standard/Superior)  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI) (Non-Refundable)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:240;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:194:\"Supplier Name - localsupplier(Creamcentre - S000000218), Rate - 200 INR, Currency Multiplier (INR-INR) - 1.00000 Supplier Commission-0 , Branch:% #localsystem Agent Hotel Category Markup=20.00 %\";}}', native_nightly_rates = 'a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0218-11503\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}', markup = '0', commission = '0', native_room_rate_total = '200', display_room_rate_total = '240', number_of_rooms = '1';
[07/11/2020 12:52:56], [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 = ' Tax will be collected at the time of Check-Out', consultant_id = 'nitinalpha', sales_manager_id = '', admin_booked = '1', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '150.129.29.107', backoffice_user = 'tfg', customer_id = '', applied_multiplier='1.00000', free_sale='',  applied_markup='20',  agent_markup='20',  basecurrency_multiplier='0.01533',  basecurrency_multiplier_native='0.01533',  parent_agent_id='21',  sub_agent_rate='0', agent_rate='240',  applicable_service_tax='0',  supplier_rate='200',  original_source='',  uid='a11c9e84fd2553e951815144edd07c7b'  where id='2780';
[07/11/2020 12:52:56], [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 ='2780';
[07/11/2020 12:52:56], [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('2780','2020-07-11 12:52:00','2020-07-11 12:52:00','200','240','0','2020-07-11 12:52:56');
[07/11/2020 12:52:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '2780' , sr_id = '1',approved_status='1' ;
[07/11/2020 12:52:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdhcHByb3ZlZF9zdGF0dXMnIGluICdmaWVsZCBsaXN0JyBmcm9tIE90cmFtc0RCLnBocCBvbiAxMS0wNy0yMDIwIDEyOjUyOjU2CiBRdWVyeTogSU5TRVJUIElOVE8gYm9va2luZ19zcGVjaWFsX3JlcXVlc3Qgc2V0IGJvb2tpbmdfaWQgPSAnMjc4MCcgLCBzcl9pZCA9ICcxJyxhcHByb3ZlZF9zdGF0dXM9JzEnIAoKL2NvbmZpcm1fYm9va2luZy5waHAKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDcyLjkuMTU2LjgwCgpCYWNrdHJhY2U6CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ0LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvSG90ZWxfQm9va2luZy5waHAnLAogICAgJ2xpbmUnID0+IDIxNzMsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvY29uZmlybV9ib29raW5nLnBocCcsCiAgICAnbGluZScgPT4gOCwKICAgICdmdW5jdGlvbicgPT4gJ2NvbmZpcm1fYm9va2luZycsCiAgICAnY2xhc3MnID0+ICdIb3RlbF9Cb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCikKCi9jb25maXJtX2Jvb2tpbmcucGhwCnVhdC50Zmcub3RyYW1zLm5ldCwgQ2xpZW50IElQOiAxNTAuMTI5LjI5LjEwNzwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiAyNDQsCiAgICAnZnVuY3Rpb24nID0+ICd3cml0ZUVycm9yJywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMSA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Ib3RlbF9Cb29raW5nLnBocCcsCiAgICAnbGluZScgPT4gMjE3MywKICAgICdmdW5jdGlvbicgPT4gJ3F1ZXJ5JywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9jb25maXJtX2Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiA4LAogICAgJ2Z1bmN0aW9uJyA9PiAnY29uZmlybV9ib29raW5nJywKICAgICdjbGFzcycgPT4gJ0hvdGVsX0Jvb2tpbmcnLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQ==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-07-11 12:52:57';
[07/11/2020 12:52:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '2780' , sr_id = '2',approved_status='1' ;
[07/11/2020 12:52:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdhcHByb3ZlZF9zdGF0dXMnIGluICdmaWVsZCBsaXN0JyBmcm9tIE90cmFtc0RCLnBocCBvbiAxMS0wNy0yMDIwIDEyOjUyOjU3CiBRdWVyeTogSU5TRVJUIElOVE8gYm9va2luZ19zcGVjaWFsX3JlcXVlc3Qgc2V0IGJvb2tpbmdfaWQgPSAnMjc4MCcgLCBzcl9pZCA9ICcyJyxhcHByb3ZlZF9zdGF0dXM9JzEnIAoKL2NvbmZpcm1fYm9va2luZy5waHAKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDcyLjkuMTU2LjgwCgpCYWNrdHJhY2U6CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ0LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvSG90ZWxfQm9va2luZy5waHAnLAogICAgJ2xpbmUnID0+IDIxNzMsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvY29uZmlybV9ib29raW5nLnBocCcsCiAgICAnbGluZScgPT4gOCwKICAgICdmdW5jdGlvbicgPT4gJ2NvbmZpcm1fYm9va2luZycsCiAgICAnY2xhc3MnID0+ICdIb3RlbF9Cb29raW5nJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCikKCi9jb25maXJtX2Jvb2tpbmcucGhwCnVhdC50Zmcub3RyYW1zLm5ldCwgQ2xpZW50IElQOiAxNTAuMTI5LjI5LjEwNzwvcHJlPjxicj4KYXJyYXkgKAogIDAgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvT3RyYW1zREIucGhwJywKICAgICdsaW5lJyA9PiAyNDQsCiAgICAnZnVuY3Rpb24nID0+ICd3cml0ZUVycm9yJywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMSA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9Ib3RlbF9Cb29raW5nLnBocCcsCiAgICAnbGluZScgPT4gMjE3MywKICAgICdmdW5jdGlvbicgPT4gJ3F1ZXJ5JywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9jb25maXJtX2Jvb2tpbmcucGhwJywKICAgICdsaW5lJyA9PiA4LAogICAgJ2Z1bmN0aW9uJyA9PiAnY29uZmlybV9ib29raW5nJywKICAgICdjbGFzcycgPT4gJ0hvdGVsX0Jvb2tpbmcnLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQ==',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-07-11 12:52:57';
[07/11/2020 12:52:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('2780','6.278698','99.730656');
[07/11/2020 12:52:57], [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 ('2780','confirmed','2020-07-11 12:52:56','Booking confirmed . Booked by Back Office tfg on behalf of Agent - Ankita  Rao(CD0021)','21','150.129.29.107','0','21');
[07/11/2020 12:52:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details)
        VALUES(2780, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"5f09b5d1bff2aa70e432b281\";}s:7:\"hotelId\";s:25:\"53748----------S000000218\";s:4:\"name\";s:11:\"CREAMCENTRE\";s:14:\"local_hotel_id\";s:5:\"53748\";s:8:\"address1\";s:12:\"Test Address\";s:8:\"latitude\";d:6.278698;s:9:\"longitude\";d:99.730656;s:4:\"city\";s:5:\"64440\";s:8:\"location\";N;s:14:\"prefered_hotel\";s:1:\"0\";s:10:\"mlosSlogan\";s:0:\"\";s:16:\"isMlosApplicable\";s:2:\"no\";s:7:\"country\";s:3:\"106\";s:16:\"rateCurrencyCode\";s:3:\"INR\";s:5:\"phone\";s:16:\"+605 - 1234 5677\";s:16:\"shortDescription\";s:22:\"TEST HOTEL DESCRIPTION\";s:11:\"website_url\";s:20:\"http://www.test.com/\";s:12:\"thumbNailUrl\";s:81:\"http://uat.tfg.otrams.net/project_folder/tfg_project/images/imagenotavailable.jpg\";s:10:\"sourceType\";s:11:\"localsystem\";s:10:\"supplierid\";s:10:\"S000000218\";s:12:\"suppliername\";s:11:\"Creamcentre\";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:4:{i:0;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{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:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0218-11503\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:240;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:194:\"Supplier Name - localsupplier(Creamcentre - S000000218), Rate - 200 INR, Currency Multiplier (INR-INR) - 1.00000 Supplier Commission-0 , Branch:% #localsystem Agent Hotel Category Markup=20.00 %\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";s:46:\"Tax will be collected at the time of Check-Out\";s:10:\"time_stamp\";s:32:\"12f937a23d868b7cfbf969b46ca3d230\";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:\"INR\";s:20:\"displayRoomTypeRates\";i:240;s:20:\"sortingRoomTypeRates\";i:240;s:19:\"nativeRoomTypeRates\";i:200;s:12:\"offerApplied\";N;s:7:\"room_id\";s:48:\"2~~~140~~~922~~~1~~~~~~~~~64440~~~0~~~S000000218\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:48:\"2~~~140~~~922~~~1~~~~~~~~~64440~~~0~~~S000000218\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000218\";s:12:\"supplierName\";s:11:\"Creamcentre\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:37:\"Promotion~ FREE WIFI (Non-Refundable)\";s:13:\"room_category\";s:28:\"ROH (Standard/Superior) Room\";s:9:\"room_type\";s:112:\"ROH (Standard/Superior)  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI) (Non-Refundable)\";s:14:\"non_refundable\";s:1:\"1\";s:15:\"class_unique_id\";s:17:\"0_0_53748_8932424\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";i:240;s:14:\"nativeRoomRate\";i:200;s:9:\"unique_id\";s:37:\"1_53748----------S000000218_9_0_63133\";s:10:\"supplierId\";s:10:\"S000000218\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:20;s:18:\"applied_multiplier\";s:7:\"1.00000\";s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53748----------S000000218\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:11:\"CREAMCENTRE\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000218\";}s:8:\"no_class\";i:0;}}i:1;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{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:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0218-11503\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:240;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:194:\"Supplier Name - localsupplier(Creamcentre - S000000218), Rate - 200 INR, Currency Multiplier (INR-INR) - 1.00000 Supplier Commission-0 , Branch:% #localsystem Agent Hotel Category Markup=20.00 %\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"c06bc24583a2a349726760bd287bcab9\";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:\"INR\";s:20:\"displayRoomTypeRates\";i:240;s:20:\"sortingRoomTypeRates\";i:240;s:19:\"nativeRoomTypeRates\";i:200;s:12:\"offerApplied\";N;s:7:\"room_id\";s:48:\"2~~~140~~~923~~~1~~~~~~~~~64440~~~1~~~S000000218\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:48:\"2~~~140~~~923~~~1~~~~~~~~~64440~~~1~~~S000000218\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000218\";s:12:\"supplierName\";s:11:\"Creamcentre\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:20:\"Promotion~ FREE WIFI\";s:13:\"room_category\";s:28:\"ROH (Standard/Superior) Room\";s:9:\"room_type\";s:95:\"ROH (Standard/Superior)  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI)\";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"1_1_53748_2963872\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";i:240;s:14:\"nativeRoomRate\";i:200;s:9:\"unique_id\";s:37:\"1_53748----------S000000218_9_1_84698\";s:10:\"supplierId\";s:10:\"S000000218\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:20;s:18:\"applied_multiplier\";s:7:\"1.00000\";s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53748----------S000000218\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:11:\"CREAMCENTRE\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000218\";}s:8:\"no_class\";i:0;}}i:2;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{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:230;s:17:\"nativeNightlyRate\";i:230;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0218-11503\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:276;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:194:\"Supplier Name - localsupplier(Creamcentre - S000000218), Rate - 230 INR, Currency Multiplier (INR-INR) - 1.00000 Supplier Commission-0 , Branch:% #localsystem Agent Hotel Category Markup=20.00 %\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"d2b43a976080118364a2b3af701a4dbf\";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:\"INR\";s:20:\"displayRoomTypeRates\";i:276;s:20:\"sortingRoomTypeRates\";i:276;s:19:\"nativeRoomTypeRates\";i:230;s:12:\"offerApplied\";N;s:7:\"room_id\";s:48:\"2~~~133~~~925~~~1~~~~~~~~~64440~~~2~~~S000000218\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:48:\"2~~~133~~~925~~~1~~~~~~~~~64440~~~2~~~S000000218\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000218\";s:12:\"supplierName\";s:11:\"Creamcentre\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:37:\"Promotion~ FREE WIFI (Non-Refundable)\";s:13:\"room_category\";s:23:\"Junior Suite Tower Room\";s:9:\"room_type\";s:107:\"Junior Suite Tower  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI) (Non-Refundable)\";s:14:\"non_refundable\";s:1:\"1\";s:15:\"class_unique_id\";s:17:\"2_2_53748_1339408\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";i:276;s:14:\"nativeRoomRate\";i:230;s:9:\"unique_id\";s:36:\"1_53748----------S000000218_9_2_1507\";s:10:\"supplierId\";s:10:\"S000000218\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:20;s:18:\"applied_multiplier\";s:7:\"1.00000\";s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53748----------S000000218\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:11:\"CREAMCENTRE\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000218\";}s:8:\"no_class\";i:0;}}i:3;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{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:230;s:17:\"nativeNightlyRate\";i:230;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0218-11503\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:276;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:194:\"Supplier Name - localsupplier(Creamcentre - S000000218), Rate - 230 INR, Currency Multiplier (INR-INR) - 1.00000 Supplier Commission-0 , Branch:% #localsystem Agent Hotel Category Markup=20.00 %\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"a232054c3b76d82c8d71250bbc0ec34c\";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:\"INR\";s:20:\"displayRoomTypeRates\";i:276;s:20:\"sortingRoomTypeRates\";i:276;s:19:\"nativeRoomTypeRates\";i:230;s:12:\"offerApplied\";N;s:7:\"room_id\";s:48:\"2~~~133~~~926~~~1~~~~~~~~~64440~~~3~~~S000000218\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:48:\"2~~~133~~~926~~~1~~~~~~~~~64440~~~3~~~S000000218\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000218\";s:12:\"supplierName\";s:11:\"Creamcentre\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:20:\"Promotion~ FREE WIFI\";s:13:\"room_category\";s:23:\"Junior Suite Tower Room\";s:9:\"room_type\";s:90:\"Junior Suite Tower  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI)\";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"3_3_53748_7175107\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";i:276;s:14:\"nativeRoomRate\";i:230;s:9:\"unique_id\";s:37:\"1_53748----------S000000218_9_3_67031\";s:10:\"supplierId\";s:10:\"S000000218\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:20;s:18:\"applied_multiplier\";s:7:\"1.00000\";s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53748----------S000000218\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:11:\"CREAMCENTRE\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000218\";}s:8:\"no_class\";i:0;}}}}s:13:\"total_charges\";i:240;s:17:\"propertyAvailable\";i:1;s:8:\"no_class\";i:0;s:18:\"sort_total_charges\";i:240;s:16:\"hotel_name_ascii\";s:11:\"creamcentre\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53748----------S000000218\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:11:\"CREAMCENTRE\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000218\";}}');
[07/11/2020 12:52:57], [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('2780','2020-07-11 12:52:00','2020-07-11 12:52:00','1970-01-01 00:00:00','1970-01-01 00:00:00','200','240','0','2020-07-11 12:52:57','');
[07/11/2020 12:52:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '0218-11503',  offer_type_code= 'PM',  booking_id= '2780',  room_id= '2~~~140~~~922~~~1~~~~~~~~~64440~~~0~~~S000000218',  room_name= 'double',  supplier_id= 'S000000218',  agent_id= '',  promotion_text= '',  offer_disc_type= 'Discount',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-07-11 12:52:57' ;
[07/11/2020 12:52:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set confirmation_number='',itenirary_id='2780' where  id ='2780';
[07/11/2020 12:52:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53748' and inventory_class_id = '140' and supplier_id = 'S000000218' and date_from = '2020-07-17';
[07/11/2020 12:52:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update supplement_rate set inventory = '0' where supplement_rate_id = '1';
