[08/06/2020 11:00:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596711609','150.107.41.77');
[08/06/2020 11:00:32], [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 ('Test Hotel', 'colombo', '132', '25', '', '1', '', 'hotelquotation', '2020-08-06 :11:00:32','');
[08/06/2020 11:00:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_addtoquote.php],UPDATE agent_quotation_sequence SET sequence_no='4' WHERE agent_id='25';
[08/06/2020 11:00:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_addtoquote.php],INSERT INTO agent_quotation SET q_name = 'UAT2.1-Sanket',unique_id = 'QTECHCD00254',backoffice_user = '',currency ='USD',service_date='2020-08-21 00:00:00',service_checkout_date='2020-08-22 00:00:00',city_code = '71100',country_code = '132',nationality = '106',total_adult = '2',total_child = '',child_age = 'a%3A0%3A%7B%7D',sequence = '1',agent_id = '25',create_date = '2020-08-06 11:00:32',q_info = 'a%3A22%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1597968000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2221%2F08%2F2020+--+22%2F08%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A24%3A%225f2be2a085e8ad69706a35f9%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253733%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53733----------S000000203_2_0_41967%22%3Bs%3A4%3A%22name%22%3Bs%3A10%3A%22TEST+HOTEL%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%3A2%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%3A33%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%3A210%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A210%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%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22Name%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22S_Value%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22Offer_Note%22%3BN%3Bs%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%3A15.39%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A156%3A%22Supplier+Name+-+localsupplier%28TestHotel+-+S000000203%29%2C+Rate+-+210+ZAR%2C+Currency+Multiplier+%28ZAR-USD%29+-+0.07328+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3BN%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%227ea2c775784ee3b403d8c2eeb8f2867d%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%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A15.39%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A15.39%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A210%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E132%7E%7E%7E810%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000203%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%7E132%7E%7E%7E810%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000203%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%22S000000203%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A9%3A%22TestHotel%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22room_category%22%3Bs%3A13%3A%22Standard+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A35%3A%22Standard++-Bed+%26+Breakfast+%3A+2+Pax+%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%220_0_53733_9952741%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A15.39%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A210%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53733----------S000000203_2_0_41967%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A0%3Bs%3A18%3A%22applied_multiplier%22%3Bd%3A0.07328%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%2253733----------S000000203%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22TEST+HOTEL%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A10%3A%22Test+Hotel%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%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%3A33%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%3A250%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A250%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%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22Name%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22S_Value%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22Offer_Note%22%3BN%3Bs%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%3A18.32%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A156%3A%22Supplier+Name+-+localsupplier%28TestHotel+-+S000000203%29%2C+Rate+-+250+ZAR%2C+Currency+Multiplier+%28ZAR-USD%29+-+0.07328+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3BN%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%2292bc4481be6d81ca1ac0dcbb320ea078%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%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A18.32%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A18.32%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A250%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A47%3A%222%7E%7E%7E22%7E%7E%7E812%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E1%7E%7E%7ES000000203%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%3A47%3A%222%7E%7E%7E22%7E%7E%7E812%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E1%7E%7E%7ES000000203%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%22S000000203%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A9%3A%22TestHotel%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22room_category%22%3Bs%3A17%3A%22Deluxe+Suite+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A39%3A%22Deluxe+Suite++-Bed+%26+Breakfast+%3A+2+Pax+%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%221_1_53733_3411668%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A18.32%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A250%3Bs%3A9%3A%22unique_id%22%3Bs%3A35%3A%221_53733----------S000000203_2_1_661%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A0%3Bs%3A18%3A%22applied_multiplier%22%3Bd%3A0.07328%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%2253733----------S000000203%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22TEST+HOTEL%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A10%3A%22Test+Hotel%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%22%3B%7Ds%3A8%3A%22no_class%22%3Bi%3A0%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A10%3A%22Test+Hotel%22%3Bs%3A8%3A%22latitude%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22longitude%22%3Bs%3A0%3A%22%22%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%3A7%3A%22colombo%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A24%3A%22No+Description+Available%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A195%3A%22http%3A%2F%2Fuat.tfg.otrams.net%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU4ODY2NDk3OF9tYWluXzkyNjIwMjAxLmpwZw%3D%3D%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A14%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A33%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%3A210%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A210%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%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22Name%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22S_Value%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22Offer_Note%22%3BN%3Bs%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%3A15.39%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A156%3A%22Supplier+Name+-+localsupplier%28TestHotel+-+S000000203%29%2C+Rate+-+210+ZAR%2C+Currency+Multiplier+%28ZAR-USD%29+-+0.07328+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3BN%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%227ea2c775784ee3b403d8c2eeb8f2867d%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%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A15.39%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A15.39%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A210%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E132%7E%7E%7E810%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000203%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%7E132%7E%7E%7E810%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000203%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%22S000000203%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A9%3A%22TestHotel%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22room_category%22%3Bs%3A13%3A%22Standard+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A35%3A%22Standard++-Bed+%26+Breakfast+%3A+2+Pax+%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%220_0_53733_9952741%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A15.39%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A210%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53733----------S000000203_2_0_41967%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A0%3Bs%3A18%3A%22applied_multiplier%22%3Bd%3A0.07328%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%2253733----------S000000203%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22TEST+HOTEL%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A10%3A%22Test+Hotel%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%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%3A459%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+15.39+USD+applicable+if+cancelled+after+19-Aug-2020+14%3A00+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%2219-Aug-2020+14%3A00%22%3Bs%3A7%3A%22date_to%22%3Bs%3A17%3A%2221-Aug-2020+00%3A00%22%3Bs%3A7%3A%22charges%22%3Bs%3A9%3A%2215.39+USD%22%3B%7D%7D%7Ds%3A26%3A%22cancellationPolicy_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A9%3A%22from_date%22%3Bs%3A17%3A%2219-Aug-2020+14%3A00%22%3Bs%3A13%3A%22agent_charges%22%3Bd%3A15.39%3Bs%3A16%3A%22supplier_charges%22%3Bi%3A210%3B%7D%7Ds%3A16%3A%22inventory_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A18%3A%22cancellation_hours%22%3Bi%3A34%3Bs%3A6%3A%22office%22%3BN%3Bs%3A16%3A%22comment_contract%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22applied_agent_charges%22%3Bd%3A15.39%3B%7D%7D%7D%7D',service = 'hotel',hotel_id = '5f2be2a085e8ad69706a35f9',additional_markup = '0',city_name ='colombo',total_price ='15.39',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 15.39 USD applicable if cancelled after 19-Aug-2020 14:00 hrs.&lt;/td&gt;
				&lt;/tr&gt;
				
				
		&lt;/table&gt;
		&lt;/td&gt;
	&lt;/tr&gt;
&lt;/table&gt;	
',per_night ='15.39',room_type ='Standard -Bed & Breakfast : 2 Pax',room_rate ='15.39';
[08/06/2020 11:00:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_write_cache.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1596711647','150.107.41.77');
[08/06/2020 11:00:53], [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 ('Test Hotel', 'colombo', '132', '25', '', '1', '', 'hotelquotation', '2020-08-06 :11:00:53','');
[08/06/2020 11:00:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/m1_addtoquote.php],INSERT INTO agent_quotation SET q_name = 'UAT2.1-Sanket',unique_id = 'QTECHCD00254',backoffice_user = '',currency ='USD',service_date='2020-08-21 00:00:00',service_checkout_date='2020-08-22 00:00:00',city_code = '71100',country_code = '132',nationality = '106',total_adult = '2',total_child = '',child_age = 'a%3A0%3A%7B%7D',sequence = '1',agent_id = '25',create_date = '2020-08-06 11:00:53',q_info = 'a%3A22%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1597968000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2221%2F08%2F2020+--+22%2F08%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A24%3A%225f2be2a085e8ad69706a35f9%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253733%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53733----------S000000203_2_0_41967%22%3Bs%3A4%3A%22name%22%3Bs%3A10%3A%22TEST+HOTEL%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%3A2%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%3A33%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%3A210%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A210%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%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22Name%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22S_Value%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22Offer_Note%22%3BN%3Bs%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%3A15.39%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A156%3A%22Supplier+Name+-+localsupplier%28TestHotel+-+S000000203%29%2C+Rate+-+210+ZAR%2C+Currency+Multiplier+%28ZAR-USD%29+-+0.07328+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3BN%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%227ea2c775784ee3b403d8c2eeb8f2867d%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%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A15.39%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A15.39%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A210%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E132%7E%7E%7E810%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000203%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%7E132%7E%7E%7E810%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000203%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%22S000000203%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A9%3A%22TestHotel%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22room_category%22%3Bs%3A13%3A%22Standard+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A35%3A%22Standard++-Bed+%26+Breakfast+%3A+2+Pax+%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%220_0_53733_9952741%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A15.39%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A210%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53733----------S000000203_2_0_41967%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A0%3Bs%3A18%3A%22applied_multiplier%22%3Bd%3A0.07328%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%2253733----------S000000203%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22TEST+HOTEL%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A10%3A%22Test+Hotel%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%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%3A33%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%3A250%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A250%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%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22Name%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22S_Value%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22Offer_Note%22%3BN%3Bs%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%3A18.32%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A156%3A%22Supplier+Name+-+localsupplier%28TestHotel+-+S000000203%29%2C+Rate+-+250+ZAR%2C+Currency+Multiplier+%28ZAR-USD%29+-+0.07328+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3BN%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%2292bc4481be6d81ca1ac0dcbb320ea078%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%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A18.32%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A18.32%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A250%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A47%3A%222%7E%7E%7E22%7E%7E%7E812%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E1%7E%7E%7ES000000203%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%3A47%3A%222%7E%7E%7E22%7E%7E%7E812%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E1%7E%7E%7ES000000203%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%22S000000203%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A9%3A%22TestHotel%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22room_category%22%3Bs%3A17%3A%22Deluxe+Suite+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A39%3A%22Deluxe+Suite++-Bed+%26+Breakfast+%3A+2+Pax+%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%221_1_53733_3411668%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A18.32%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A250%3Bs%3A9%3A%22unique_id%22%3Bs%3A35%3A%221_53733----------S000000203_2_1_661%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A0%3Bs%3A18%3A%22applied_multiplier%22%3Bd%3A0.07328%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%2253733----------S000000203%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22TEST+HOTEL%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A10%3A%22Test+Hotel%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%22%3B%7Ds%3A8%3A%22no_class%22%3Bi%3A0%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A10%3A%22Test+Hotel%22%3Bs%3A8%3A%22latitude%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22longitude%22%3Bs%3A0%3A%22%22%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%3A7%3A%22colombo%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A24%3A%22No+Description+Available%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A195%3A%22http%3A%2F%2Fuat.tfg.otrams.net%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU4ODY2NDk3OF9tYWluXzkyNjIwMjAxLmpwZw%3D%3D%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A14%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A33%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%3A210%3Bs%3A17%3A%22nativeNightlyRate%22%3Bd%3A210%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%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22Name%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22S_Value%22%3Bs%3A0%3A%22%22%3Bs%3A5%3A%22Value%22%3Bi%3A0%3Bs%3A12%3A%22Display_Name%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22Offer_Note%22%3BN%3Bs%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%3A15.39%3Bs%3A16%3A%22promotionDisplay%22%3Bs%3A0%3A%22%22%3Bs%3A25%3A%22displayNightlyRateDisplay%22%3Bs%3A156%3A%22Supplier+Name+-+localsupplier%28TestHotel+-+S000000203%29%2C+Rate+-+210+ZAR%2C+Currency+Multiplier+%28ZAR-USD%29+-+0.07328+Supplier+Commission-0+%2C+Branch%3A%25+%23localsystem%22%3B%7D%7D%7Ds%3A20%3A%22offer_promotion_note%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22offer_discount_type%22%3Bs%3A0%3A%22%22%3Bs%3A27%3A%22offer_discount_note_details%22%3BN%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%227ea2c775784ee3b403d8c2eeb8f2867d%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%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bd%3A15.39%3Bs%3A20%3A%22sortingRoomTypeRates%22%3Bd%3A15.39%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bd%3A210%3Bs%3A12%3A%22offerApplied%22%3BN%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E132%7E%7E%7E810%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000203%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%7E132%7E%7E%7E810%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000203%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%22S000000203%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A9%3A%22TestHotel%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A4%3A%22note%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22room_category%22%3Bs%3A13%3A%22Standard+Room%22%3Bs%3A9%3A%22room_type%22%3Bs%3A35%3A%22Standard++-Bed+%26+Breakfast+%3A+2+Pax+%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A17%3A%220_0_53733_9952741%22%3B%7D%7Ds%3A9%3A%22available%22%3Bi%3A1%3Bs%3A15%3A%22displayRoomRate%22%3Bd%3A15.39%3Bs%3A14%3A%22nativeRoomRate%22%3Bd%3A210%3Bs%3A9%3A%22unique_id%22%3Bs%3A37%3A%221_53733----------S000000203_2_0_41967%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22ZAR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bd%3A0%3Bs%3A18%3A%22applied_multiplier%22%3Bd%3A0.07328%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%2253733----------S000000203%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22TEST+HOTEL%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A10%3A%22Test+Hotel%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000203%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%3A459%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+15.39+USD+applicable+if+cancelled+after+19-Aug-2020+14%3A00+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%2219-Aug-2020+14%3A00%22%3Bs%3A7%3A%22date_to%22%3Bs%3A17%3A%2221-Aug-2020+00%3A00%22%3Bs%3A7%3A%22charges%22%3Bs%3A9%3A%2215.39+USD%22%3B%7D%7D%7Ds%3A26%3A%22cancellationPolicy_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A9%3A%22from_date%22%3Bs%3A17%3A%2219-Aug-2020+14%3A00%22%3Bs%3A13%3A%22agent_charges%22%3Bd%3A15.39%3Bs%3A16%3A%22supplier_charges%22%3Bi%3A210%3B%7D%7Ds%3A16%3A%22inventory_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A18%3A%22cancellation_hours%22%3Bi%3A34%3Bs%3A6%3A%22office%22%3BN%3Bs%3A16%3A%22comment_contract%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22applied_agent_charges%22%3Bd%3A15.39%3B%7D%7D%7D%7D',service = 'hotel',hotel_id = '5f2be2a085e8ad69706a35f9',additional_markup = '0',city_name ='colombo',total_price ='15.39',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 15.39 USD applicable if cancelled after 19-Aug-2020 14:00 hrs.&lt;/td&gt;
				&lt;/tr&gt;
				
				
		&lt;/table&gt;
		&lt;/td&gt;
	&lt;/tr&gt;
&lt;/table&gt;	
',per_night ='15.39',room_type ='Standard -Bed & Breakfast : 2 Pax',room_rate ='15.39';
[08/06/2020 11:11:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/frontendfunc.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', '25', '', '1', '', 'hoteldetails', '2020-08-06 :11:11:09','');
[08/06/2020 11:11:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/frontendfunc.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 ('Marino Beach Colombo', 'colombo', '132', '25', '', '1', '', 'hoteldetails', '2020-08-06 :11:11:20','');
[08/06/2020 11:13:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],UPDATE sub_user SET status='A',modify_date='2020-08-06 11:13:17' ,expiry_date='2020-11-04 11:13:17', login_attempt=0  WHERE sub_user_id='8';
[08/06/2020 11:13:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdsb2dpbl9hdHRlbXB0JyBpbiAnZmllbGQgbGlzdCcgZnJvbSBPdHJhbXNEQi5waHAgb24gMDYtMDgtMjAyMCAxMToxMzoxNwogUXVlcnk6VVBEQVRFIHN1Yl91c2VyIFNFVCBzdGF0dXM9J0EnLG1vZGlmeV9kYXRlPScyMDIwLTA4LTA2IDExOjEzOjE3JyAsZXhwaXJ5X2RhdGU9JzIwMjAtMTEtMDQgMTE6MTM6MTcnLCBsb2dpbl9hdHRlbXB0PTAgIFdIRVJFIHN1Yl91c2VyX2lkPSc4JwoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL1N1Yl9Vc2VyLnBocCcsCiAgICAnbGluZScgPT4gMzUsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvbWFuYWdlX3N1Yl91c2VyLnBocCcsCiAgICAnbGluZScgPT4gNzEsCiAgICAnZnVuY3Rpb24nID0+ICdhY3RpdmUnLAogICAgJ2NsYXNzJyA9PiAnU3ViX1VzZXInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDE1MC4xMDcuNDEuNzc8L3ByZT48YnI+CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ2LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvU3ViX1VzZXIucGhwJywKICAgICdsaW5lJyA9PiAzNSwKICAgICdmdW5jdGlvbicgPT4gJ3F1ZXJ5JywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9tYW5hZ2Vfc3ViX3VzZXIucGhwJywKICAgICdsaW5lJyA9PiA3MSwKICAgICdmdW5jdGlvbicgPT4gJ2FjdGl2ZScsCiAgICAnY2xhc3MnID0+ICdTdWJfVXNlcicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAop',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/manage_sub_user.php?action_name=active&sub_user_id=8',create_date= '2020-08-06 11:13:17';
[08/06/2020 11:13:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],UPDATE sub_user SET status='A',modify_date='2020-08-06 11:13:56' ,expiry_date='2020-11-04 11:13:56', login_attempt=0  WHERE sub_user_id='8';
[08/06/2020 11:13:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdsb2dpbl9hdHRlbXB0JyBpbiAnZmllbGQgbGlzdCcgZnJvbSBPdHJhbXNEQi5waHAgb24gMDYtMDgtMjAyMCAxMToxMzo1NgogUXVlcnk6VVBEQVRFIHN1Yl91c2VyIFNFVCBzdGF0dXM9J0EnLG1vZGlmeV9kYXRlPScyMDIwLTA4LTA2IDExOjEzOjU2JyAsZXhwaXJ5X2RhdGU9JzIwMjAtMTEtMDQgMTE6MTM6NTYnLCBsb2dpbl9hdHRlbXB0PTAgIFdIRVJFIHN1Yl91c2VyX2lkPSc4JwoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL1N1Yl9Vc2VyLnBocCcsCiAgICAnbGluZScgPT4gMzUsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvbWFuYWdlX3N1Yl91c2VyLnBocCcsCiAgICAnbGluZScgPT4gNzEsCiAgICAnZnVuY3Rpb24nID0+ICdhY3RpdmUnLAogICAgJ2NsYXNzJyA9PiAnU3ViX1VzZXInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDE1MC4xMDcuNDEuNzc8L3ByZT48YnI+CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ2LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvU3ViX1VzZXIucGhwJywKICAgICdsaW5lJyA9PiAzNSwKICAgICdmdW5jdGlvbicgPT4gJ3F1ZXJ5JywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9tYW5hZ2Vfc3ViX3VzZXIucGhwJywKICAgICdsaW5lJyA9PiA3MSwKICAgICdmdW5jdGlvbicgPT4gJ2FjdGl2ZScsCiAgICAnY2xhc3MnID0+ICdTdWJfVXNlcicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAop',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/manage_sub_user.php?action_name=active&sub_user_id=8',create_date= '2020-08-06 11:13:56';
[08/06/2020 11:18:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],UPDATE sub_user SET status='A',modify_date='2020-08-06 11:18:15' ,expiry_date='2020-11-04 11:18:15', login_attempt=0  WHERE sub_user_id='8';
[08/06/2020 11:18:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdsb2dpbl9hdHRlbXB0JyBpbiAnZmllbGQgbGlzdCcgZnJvbSBPdHJhbXNEQi5waHAgb24gMDYtMDgtMjAyMCAxMToxODoxNQogUXVlcnk6VVBEQVRFIHN1Yl91c2VyIFNFVCBzdGF0dXM9J0EnLG1vZGlmeV9kYXRlPScyMDIwLTA4LTA2IDExOjE4OjE1JyAsZXhwaXJ5X2RhdGU9JzIwMjAtMTEtMDQgMTE6MTg6MTUnLCBsb2dpbl9hdHRlbXB0PTAgIFdIRVJFIHN1Yl91c2VyX2lkPSc4JwoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL1N1Yl9Vc2VyLnBocCcsCiAgICAnbGluZScgPT4gMzUsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvbWFuYWdlX3N1Yl91c2VyLnBocCcsCiAgICAnbGluZScgPT4gNzEsCiAgICAnZnVuY3Rpb24nID0+ICdhY3RpdmUnLAogICAgJ2NsYXNzJyA9PiAnU3ViX1VzZXInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDE1MC4xMDcuNDEuNzc8L3ByZT48YnI+CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ2LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvU3ViX1VzZXIucGhwJywKICAgICdsaW5lJyA9PiAzNSwKICAgICdmdW5jdGlvbicgPT4gJ3F1ZXJ5JywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9tYW5hZ2Vfc3ViX3VzZXIucGhwJywKICAgICdsaW5lJyA9PiA3MSwKICAgICdmdW5jdGlvbicgPT4gJ2FjdGl2ZScsCiAgICAnY2xhc3MnID0+ICdTdWJfVXNlcicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAop',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/manage_sub_user.php?action_name=active&sub_user_id=8',create_date= '2020-08-06 11:18:15';
[08/06/2020 11:20:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],UPDATE sub_user SET status='A',modify_date='2020-08-06 11:20:15' ,expiry_date='2020-11-04 11:20:15', login_attempt=0  WHERE sub_user_id='8';
[08/06/2020 11:20:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],insert into email_logs SET `subject`= 'Query Failed please check uat.tfg.otrams.net',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'PGJyPi0tLS0tLS0tLSAKCjxicj5FcnJvcjoKU1FMU1RBVEVbNDJTMjJdOiBDb2x1bW4gbm90IGZvdW5kOiAxMDU0IFVua25vd24gY29sdW1uICdsb2dpbl9hdHRlbXB0JyBpbiAnZmllbGQgbGlzdCcgZnJvbSBPdHJhbXNEQi5waHAgb24gMDYtMDgtMjAyMCAxMToyMDoxNQogUXVlcnk6VVBEQVRFIHN1Yl91c2VyIFNFVCBzdGF0dXM9J0EnLG1vZGlmeV9kYXRlPScyMDIwLTA4LTA2IDExOjIwOjE1JyAsZXhwaXJ5X2RhdGU9JzIwMjAtMTEtMDQgMTE6MjA6MTUnLCBsb2dpbl9hdHRlbXB0PTAgIFdIRVJFIHN1Yl91c2VyX2lkPSc4JwoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKCjxwcmU+Ckhvc3RuYW1lOiBxdGVjaC5vdHJhbXMuY29tCiA8YnI+CgpDb25uZWN0aW9uOiBvdHJhbXNfdGhlZmFiQDIwOS4yMzYuMTE0LjE3NAoKQmFja3RyYWNlOgphcnJheSAoCiAgMCA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy90bXMvY2xhc3Nlcy9PdHJhbXNEQi5waHAnLAogICAgJ2xpbmUnID0+IDI0NiwKICAgICdmdW5jdGlvbicgPT4gJ3dyaXRlRXJyb3InLAogICAgJ2NsYXNzJyA9PiAnT3RyYW1zREInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKICAxID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL1N1Yl9Vc2VyLnBocCcsCiAgICAnbGluZScgPT4gMzUsCiAgICAnZnVuY3Rpb24nID0+ICdxdWVyeScsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDIgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvbWFuYWdlX3N1Yl91c2VyLnBocCcsCiAgICAnbGluZScgPT4gNzEsCiAgICAnZnVuY3Rpb24nID0+ICdhY3RpdmUnLAogICAgJ2NsYXNzJyA9PiAnU3ViX1VzZXInLAogICAgJ3R5cGUnID0+ICctPicsCiAgKSwKKQoKL21hbmFnZV9zdWJfdXNlci5waHA/YWN0aW9uX25hbWU9YWN0aXZlJnN1Yl91c2VyX2lkPTgKdWF0LnRmZy5vdHJhbXMubmV0LCBDbGllbnQgSVA6IDE1MC4xMDcuNDEuNzc8L3ByZT48YnI+CmFycmF5ICgKICAwID0+IAogIGFycmF5ICgKICAgICdmaWxlJyA9PiAnL2hvbWUvb3RyYW1zL3B1YmxpY19odG1sL290cmFtc3BocDcvdWF0L3Yzb3RyYW1zL3Rtcy9jbGFzc2VzL090cmFtc0RCLnBocCcsCiAgICAnbGluZScgPT4gMjQ2LAogICAgJ2Z1bmN0aW9uJyA9PiAnd3JpdGVFcnJvcicsCiAgICAnY2xhc3MnID0+ICdPdHJhbXNEQicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAogIDEgPT4gCiAgYXJyYXkgKAogICAgJ2ZpbGUnID0+ICcvaG9tZS9vdHJhbXMvcHVibGljX2h0bWwvb3RyYW1zcGhwNy91YXQvdjNvdHJhbXMvdG1zL2NsYXNzZXMvU3ViX1VzZXIucGhwJywKICAgICdsaW5lJyA9PiAzNSwKICAgICdmdW5jdGlvbicgPT4gJ3F1ZXJ5JywKICAgICdjbGFzcycgPT4gJ090cmFtc0RCJywKICAgICd0eXBlJyA9PiAnLT4nLAogICksCiAgMiA9PiAKICBhcnJheSAoCiAgICAnZmlsZScgPT4gJy9ob21lL290cmFtcy9wdWJsaWNfaHRtbC9vdHJhbXNwaHA3L3VhdC92M290cmFtcy9tYW5hZ2Vfc3ViX3VzZXIucGhwJywKICAgICdsaW5lJyA9PiA3MSwKICAgICdmdW5jdGlvbicgPT4gJ2FjdGl2ZScsCiAgICAnY2xhc3MnID0+ICdTdWJfVXNlcicsCiAgICAndHlwZScgPT4gJy0+JywKICApLAop',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/manage_sub_user.php?action_name=active&sub_user_id=8',create_date= '2020-08-06 11:20:16';
[08/06/2020 11:29:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],UPDATE sub_user SET status='A',modify_date='2020-08-06 11:29:01' ,expiry_date='2020-11-04 11:29:01', login_attempt=0  WHERE sub_user_id='8';
[08/06/2020 11:29:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/manage_sub_user.php],UPDATE sub_user SET status='A',modify_date='2020-08-06 11:29:23' ,expiry_date='2020-11-04 11:29:23', login_attempt=0  WHERE sub_user_id='8';
[08/06/2020 11:36:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],DELETE FROM report_access where psa_user_id='25';
[08/06/2020 11:36:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],INSERT INTO report_access SET psa_user_id='25',report_function_name='customer_statement';
[08/06/2020 11:36:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],INSERT INTO report_access SET psa_user_id='25',report_function_name='invoice_report';
[08/06/2020 11:36:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],INSERT INTO report_access SET psa_user_id='25',report_function_name='voucher_report';
[08/06/2020 11:36:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/report_access_agent.php],INSERT INTO report_access SET psa_user_id='25',report_function_name='receipts_report';
