[01/30/2021 05:46:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2021-01-30 05:46:37', '', '', '');
[01/30/2021 05:47:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 407;
[01/30/2021 05:47:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation SET q_name = 'Rate Gain',email='',contact_no='',unique_id = 'QTECHCD002510',backoffice_user = 'tfg',create_date = '2021-01-30 05:47:06',currency ='USD',service_date='2021-02-17 00:00:00',service_checkout_date='2021-02-18 00:00:00',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D',sequence='3',agent_id = '25',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1660435200%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2217%2F02%2F2021+--+18%2F02%2F2021%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253719%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253719%22%3Bs%3A4%3A%22name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%223.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%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%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2252.23%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22671%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A73%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A74%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A57%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.22%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%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%2253719----------S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.22%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.857788%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2280.573064%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A6%3A%22105489%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%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%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2252.23%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22671%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A73%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A74%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A57%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.22%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%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%2253719----------S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.22%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53719',city_name ='Kotugoda',city_code ='105489',country_code ='132',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name ='Snehal Test',salutation ='Mrs',first_name ='Snehal',last_name ='Test',quotation_type ='back_end',total_adult ='2',enquiry_id ='407',total_price ='52.23',per_night ='52.23',room_type ='ROH (Standard/Superior) - Double, Max Pax-3, Extrabed - 3(Bed & Breakfast)',room_rate ='52.23';
[01/30/2021 05:47:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1904', q_name='Rate Gain', service='hotel', agent_id='25', create_date='2021-01-30 05:47:06', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1660435200%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2217%2F02%2F2021+--+18%2F02%2F2021%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253719%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253719%22%3Bs%3A4%3A%22name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%223.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%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%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2252.23%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22671%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A73%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A74%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A57%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.22%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%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%2253719----------S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.22%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.857788%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2280.573064%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A6%3A%22105489%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%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%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2252.23%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22671%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A73%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A74%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A57%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.22%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%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%2253719----------S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.22%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Kotugoda', hotel_id='53719', additional_markup='0', cancelltion_policy='', per_night='52.23', total_price='52.23', room_type='ROH (Standard/Superior) - Double, Max Pax-3, Extrabed - 3(Bed & Breakfast)', room_rate='52.23', currency='USD', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2021-01-30 05:47:06', status='A', is_visible='1', is_optional='0', unique_id='QTECHCD002510', service_date='2021-02-17 00:00:00', service_checkout_date='2021-02-18 00:00:00', city_code='105489', country_code='132', nationality='106', total_adult='2', total_child='0', child_age='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D', leader_name='Snehal Test', salutation='Mrs', first_name='Snehal', last_name='Test', email='', contact_no='', enquiry_id='407', quotation_status='edited', sequence='3', rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D';
[01/30/2021 05:47:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1904', service_id='53719', service_type='hotel',service_date='2021-02-17', sequence='3';
[01/30/2021 05:47:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1904', service_date='2021-02-17';
[01/30/2021 05:47:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1904', service_id='53719', service_type='hotel',service_date='2021-02-18', sequence='3';
[01/30/2021 05:47:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1904', service_date='2021-02-18';
[01/30/2021 05:47:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCD002510' AND quotation_status!='booked';
[01/30/2021 05:47:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET status='D' WHERE q_id IN (1901);;
[01/30/2021 05:47:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET status='D' WHERE q_id IN (1900);;
[01/30/2021 05:47:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 407;
[01/30/2021 05:47:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1904', q_name='Rate Gain', service='hotel', agent_id='25', create_date='2021-01-30 05:47:35', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1660435200%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2217%2F02%2F2021+--+18%2F02%2F2021%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253719%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253719%22%3Bs%3A4%3A%22name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%223.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%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%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2252.23%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22671%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A73%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A74%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A57%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.22%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%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%2253719----------S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.22%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.857788%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2280.573064%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A6%3A%22105489%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%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%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2252.23%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22671%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A73%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A74%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A57%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.22%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%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%2253719----------S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.22%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Kotugoda', hotel_id='53719', additional_markup='0', cancelltion_policy='', per_night='52.23', total_price='52.23', room_type='ROH (Standard/Superior) - Double, Max Pax-3, Extrabed - 3(Bed & Breakfast)', room_rate='52.23', currency='USD', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2021-01-30 05:47:35', status='A', is_visible='1', is_optional='0', unique_id='QTECHCD002510', service_date='2021-02-17 00:00:00', service_checkout_date='2021-02-18 00:00:00', city_code='105489', country_code='132', nationality='106', total_adult='2', total_child='0', child_age='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D', leader_name='Snehal Test', salutation='Mrs', first_name='Snehal', last_name='Test', email='', contact_no='', enquiry_id='407', quotation_status='edited', sequence='3', rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D';
[01/30/2021 05:47:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = 'Rate Gain',email='',contact_no='',unique_id = 'QTECHCD002510',modified_by = 'tfg',modified_date = '2021-01-30 05:47:35',currency ='USD',service_date='2021-02-17 00:00:00',service_checkout_date='2021-02-18 00:00:00',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D',sequence='3',agent_id = '25',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1660435200%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2217%2F02%2F2021+--+18%2F02%2F2021%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253719%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253719%22%3Bs%3A4%3A%22name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%223.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%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%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2252.23%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22671%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A73%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A74%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A57%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.22%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%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%2253719----------S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.22%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.857788%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2280.573064%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A6%3A%22105489%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%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%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2252.23%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-02-17%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2247.388%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2210.21%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2220.42%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2252.23%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22671%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A73%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A74%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A57%3A%22ROH+%28Standard%2FSuperior%29+-+Double%2C+Max+Pax-3%2C+Extrabed+-+3%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E140%7E%7E%7E671%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E105489%7E%7E%7E0%7E%7E%7ES000000092%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.22%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2252.23%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2210.217776652317%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.23694%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%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%2253719----------S000000092%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22THE+WALLAWWA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000092%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.22%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53719',city_name ='Kotugoda',city_code ='105489',country_code ='132',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name ='Snehal Test',salutation ='Mrs',first_name ='Snehal',last_name ='Test',quotation_type ='back_end',total_adult ='2',enquiry_id ='407',total_price ='52.23',per_night ='52.23',room_type ='ROH (Standard/Superior) - Double, Max Pax-3, Extrabed - 3(Bed & Breakfast)',room_rate ='52.23' WHERE q_id='1904';
[01/30/2021 05:47:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCD002510' AND quotation_status!='booked';
[01/30/2021 05:47:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET quotation_status='responded' WHERE unique_id IN ('QTECHCD002510') AND agent_id='25' AND quotation_status!='booked';
[01/30/2021 05:47:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET leader_name='Snehal Test',salutation='Mrs',first_name='Snehal',last_name='Test',q_name='Rate Gain',email='',contact_no='',nationality='106' WHERE agent_id='25' AND unique_id IN ('QTECHCD002510');
[01/30/2021 05:50:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='0' where supplier_id='S000000092' AND hotel_id='53719' AND inventory_class_id='140'  AND date_from >='2021-02-17' AND date_from <='2021-02-18' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Mo,Tu,We,Th,Fr,Sa,Su')='0';
[01/30/2021 05:50:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='0' where supplier_id='S000000092' AND hotel_id='53719' AND inventory_class_id='140'  AND date_from >='2021-02-17' AND date_from <='2021-02-18' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Mo,Tu,We,Th,Fr,Sa,Su')>'0';
[01/30/2021 05:50:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2021-01-30 05:50:12',`log_type`= 'Inventory Allocation',`sql_query`= 'update room_rates set  availability=\&#039;0\&#039; where supplier_id=\&#039;S000000092\&#039; AND hotel_id=\&#039;53719\&#039; AND inventory_class_id=\&#039;140\&#039;  AND date_from &gt;=\&#039;2021-02-17\&#039; AND date_from &lt;=\&#039;2021-02-18\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Mo,Tu,We,Th,Fr,Sa,Su\&#039;)=\&#039;0\&#039;&lt;br&gt;update room_rates set  availability=\&#039;0\&#039; where supplier_id=\&#039;S000000092\&#039; AND hotel_id=\&#039;53719\&#039; AND inventory_class_id=\&#039;140\&#039;  AND date_from &gt;=\&#039;2021-02-17\&#039; AND date_from &lt;=\&#039;2021-02-18\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Mo,Tu,We,Th,Fr,Sa,Su\&#039;)&gt;\&#039;0\&#039;',`log_description`= 'Upadated Inventory Allocation For hotel THE WALLAWWA- Inventory:-ROH (Standard/Superior) From:-17-02-2021 To:-18-02-2021 Weekday Inventory Allocation:-0 Weekend Inventory Allocation:-0',`ip`= '106.209.233.35',`username`= 'tfg',`user_id`= 'S000000092';
[01/30/2021 05:50:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4089', `entity`='Hotels', `value`='53719' ;
[01/30/2021 05:50:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4089', `entity`='Suppliers', `value`='S000000092' ;
[01/30/2021 05:50:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4089', `entity`='Inventory', `value`='140' ;
