[01/18/2021 10:30:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 404;
[01/18/2021 10:30:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1894', q_name='', service='hotel', agent_id='9', create_date='2021-01-18 10:30:55', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1904860800%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2224%2F11%2F2020+--+25%2F11%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A4%3A%22name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%225.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%3Bs%3A6%3A%22200.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22200.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22214.00%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%222020-11-24%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22200.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22200.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%227%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22214.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A6%3A%22214.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22200.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A20%3A%22MARINO+BEACH+COLOMBO%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22653%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%222%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A10%3A%22Half+Board%22%3Bs%3A9%3A%22room_type%22%3Bs%3A57%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0++Half+Board%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A58%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0+%28Half+Board%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A45%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0%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%3A17%3A%227.000000000000001%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%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%223.16%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%227.000000000000001%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2210.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%225.42%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22214%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%227%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%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%2253699----------S000000071%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A66%3A%22Colombo+03%2C+Colombo%2C+Sri+Lanka%0D%0A%0D%0A0.9+km+from+Barefoot+Garden+Cafe%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%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%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A3%3A%221.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%223.16%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%225.42%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A66%3A%22Colombo+03%2C+Colombo%2C+Sri+Lanka%0D%0A%0D%0A0.9+km+from+Barefoot+Garden+Cafe%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%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A1%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271100%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%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A2184%3A%22Colombo+%28%2Fk%3F%3Fl%3Fmbo%3F%2F%3B+Sinhala%3A+%3F%3F%3F%3F%2C+romanized%3A+Kolamba%2C+pronunciation+%5B%3Fk%3Fl%3Fmb%3F%5D%3B+Tamil%3A+%3F%3F%3F%3F%3F%3F%3F%3F%2C+romanized%3A+Ko%3Fumpu%2C+Tamil+pronunciation%3A+%5Bko%3Fumbu%5D%29+is+the+commercial+capital%5B3%5D+and+largest+city+of+Sri+Lanka+by+population.+According+to+the+Brookings+Institution%2C+Colombo+metropolitan+area+has+a+population+of+5.6+million%2C%5B4%5D%5B5%5D%5B6%5D%5B7%5D+and+752%2C993%5B2%5D+in+the+city+proper.+It+is+the+financial+centre+of+the+island+and+a+popular+tourist+destination.%5B8%5D+It+is+located+on+the+west+coast+of+the+island+and+adjacent+to+the+Greater+Colombo+area+which+includes+Sri+Jayawardenepura+Kotte%2C+the+legislative+capital+of+Sri+Lanka+and+Dehiwala-Mount+Lavinia.+Colombo+is+often+referred+to+as+the+capital+since+Sri+Jayawardenepura+Kotte+is+within+the+urban+area+of%2C+and+a+suburb+of%2C+Colombo.+It+is+also+the+administrative+capital+of+the+Western+Province+and+the+district+capital+of+Colombo+District.+Colombo+is+a+busy+and+vibrant+place+with+a+mixture+of+modern+life+and+colonial+buildings+and+ruins.%5B9%5D%0D%0A%0D%0ADue+to+its+large+harbour+and+its+strategic+position+along+the+East-West+sea+trade+routes%2C+Colombo+was+known+to+ancient+traders+2%2C000+years+ago.%5Bcitation+needed%5D+It+was+made+the+capital+of+the+island+when+Sri+Lanka+was+ceded+to+the+British+Empire+in+1815%2C%5B10%5D+and+its+status+as+capital+was+retained+when+the+nation+became+independent+in+1948.+In+1978%2C+when+administrative+functions+were+moved+to+Sri+Jayawardenepura+Kotte%2C+Colombo+was+designated+as+the+commercial+capital+of+Sri+Lanka.%0D%0A%0D%0ALike+many+cities%2C+Colombo%5C%26%23039%3Bs+urban+area+extends+well+beyond+the+boundaries+of+a+single+local+authority%2C+encompassing+other+municipal+and+urban+councils+such+as+Sri+Jayawardenepura+Kotte+Municipal+Council%2C+Dehiwala+Mount+Lavinia+Municipal+Council%2C+Kolonnawa+Urban+Council%2C+Kaduwela+Municipal+Council+and+Kotikawatte+Mulleriyawa+Pradeshiya+Sabha.+The+main+city+is+home+to+a+majority+of+Sri+Lanka%5C%26%23039%3Bs+corporate+offices%2C+restaurants+and+entertainment+venues.%5B11%5D+Famous+landmarks+in+Colombo+include+Galle+Face+Green%2C+Viharamahadevi+Park%2C+Beira+Lake%2C+Colombo+Racecourse%2C+Planetarium%2C+University+of+Colombo%2C+Mount+Lavinia+beach%2C+Nelum+Pokuna+Theatre%2C+Colombo+Lotus+Tower+as+well+as+the+National+Museum.+%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A249%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5Njg1OF9tYWluX21haW4mIzAzOTtzX2ltYWdlcy5qcGVn%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%3Bs%3A6%3A%22200.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22200.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22214.00%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%222020-11-24%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22200.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22200.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%227%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22214.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A6%3A%22214.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22200.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A20%3A%22MARINO+BEACH+COLOMBO%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22653%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%222%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A10%3A%22Half+Board%22%3Bs%3A9%3A%22room_type%22%3Bs%3A57%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0++Half+Board%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A58%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0+%28Half+Board%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A45%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0%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%3A17%3A%227.000000000000001%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%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%223.16%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%227.000000000000001%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2210.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%225.42%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22214%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%227%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%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%2253699----------S000000071%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A66%3A%22Colombo+03%2C+Colombo%2C+Sri+Lanka%0D%0A%0D%0A0.9+km+from+Barefoot+Garden+Cafe%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%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%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A3%3A%221.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%223.16%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%225.42%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Colombo', hotel_id='53699', additional_markup='0', cancelltion_policy='', per_night='214.00', total_price='214.00', room_type='Colonial Manssion - 01 - Double, Extrabed - 0 (Half Board)', room_rate='214.00', currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2021-01-18 10:30:55', status='A', is_visible='1', is_optional='0', unique_id='QTECHCD00093', service_date='2020-11-24 00:00:00', service_checkout_date='2020-11-25 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='1', total_child='0', child_age='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D', leader_name='Ankita Rao', salutation='Ms', first_name='Ankita', last_name='Rao', email='', contact_no='', enquiry_id='404', 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%222020-11-24%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22200.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22200.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%227%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22214.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D';
[01/18/2021 10:30:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'QTECHCD00093',modified_by = 'tfg',modified_date = '2021-01-18 10:30:54',currency ='INR',service_date='2020-11-24 00:00:00',service_checkout_date='2020-11-25 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%222020-11-24%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22200.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22200.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%227%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22214.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D',sequence='3',agent_id = '9',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1904860800%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2224%2F11%2F2020+--+25%2F11%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A4%3A%22name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%225.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%3Bs%3A6%3A%22200.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22200.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22214.00%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%222020-11-24%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22200.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22200.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%227%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22214.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A6%3A%22214.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22200.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A20%3A%22MARINO+BEACH+COLOMBO%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22653%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%222%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A10%3A%22Half+Board%22%3Bs%3A9%3A%22room_type%22%3Bs%3A57%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0++Half+Board%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A58%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0+%28Half+Board%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A45%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0%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%3A1%3A%227%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3Bs%3A16%3A%22user_description%22%3Bs%3A7%3A%22test123%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%223.16%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%227%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2210.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%225.42%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22214%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%227%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22user_description%22%3Bs%3A7%3A%22test123%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%2253699----------S000000071%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A66%3A%22Colombo+03%2C+Colombo%2C+Sri+Lanka%0D%0A%0D%0A0.9+km+from+Barefoot+Garden+Cafe%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%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%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A3%3A%221.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%223.16%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%225.42%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A66%3A%22Colombo+03%2C+Colombo%2C+Sri+Lanka%0D%0A%0D%0A0.9+km+from+Barefoot+Garden+Cafe%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%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A1%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271100%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%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A2184%3A%22Colombo+%28%2Fk%3F%3Fl%3Fmbo%3F%2F%3B+Sinhala%3A+%3F%3F%3F%3F%2C+romanized%3A+Kolamba%2C+pronunciation+%5B%3Fk%3Fl%3Fmb%3F%5D%3B+Tamil%3A+%3F%3F%3F%3F%3F%3F%3F%3F%2C+romanized%3A+Ko%3Fumpu%2C+Tamil+pronunciation%3A+%5Bko%3Fumbu%5D%29+is+the+commercial+capital%5B3%5D+and+largest+city+of+Sri+Lanka+by+population.+According+to+the+Brookings+Institution%2C+Colombo+metropolitan+area+has+a+population+of+5.6+million%2C%5B4%5D%5B5%5D%5B6%5D%5B7%5D+and+752%2C993%5B2%5D+in+the+city+proper.+It+is+the+financial+centre+of+the+island+and+a+popular+tourist+destination.%5B8%5D+It+is+located+on+the+west+coast+of+the+island+and+adjacent+to+the+Greater+Colombo+area+which+includes+Sri+Jayawardenepura+Kotte%2C+the+legislative+capital+of+Sri+Lanka+and+Dehiwala-Mount+Lavinia.+Colombo+is+often+referred+to+as+the+capital+since+Sri+Jayawardenepura+Kotte+is+within+the+urban+area+of%2C+and+a+suburb+of%2C+Colombo.+It+is+also+the+administrative+capital+of+the+Western+Province+and+the+district+capital+of+Colombo+District.+Colombo+is+a+busy+and+vibrant+place+with+a+mixture+of+modern+life+and+colonial+buildings+and+ruins.%5B9%5D%0D%0A%0D%0ADue+to+its+large+harbour+and+its+strategic+position+along+the+East-West+sea+trade+routes%2C+Colombo+was+known+to+ancient+traders+2%2C000+years+ago.%5Bcitation+needed%5D+It+was+made+the+capital+of+the+island+when+Sri+Lanka+was+ceded+to+the+British+Empire+in+1815%2C%5B10%5D+and+its+status+as+capital+was+retained+when+the+nation+became+independent+in+1948.+In+1978%2C+when+administrative+functions+were+moved+to+Sri+Jayawardenepura+Kotte%2C+Colombo+was+designated+as+the+commercial+capital+of+Sri+Lanka.%0D%0A%0D%0ALike+many+cities%2C+Colombo%5C%26%23039%3Bs+urban+area+extends+well+beyond+the+boundaries+of+a+single+local+authority%2C+encompassing+other+municipal+and+urban+councils+such+as+Sri+Jayawardenepura+Kotte+Municipal+Council%2C+Dehiwala+Mount+Lavinia+Municipal+Council%2C+Kolonnawa+Urban+Council%2C+Kaduwela+Municipal+Council+and+Kotikawatte+Mulleriyawa+Pradeshiya+Sabha.+The+main+city+is+home+to+a+majority+of+Sri+Lanka%5C%26%23039%3Bs+corporate+offices%2C+restaurants+and+entertainment+venues.%5B11%5D+Famous+landmarks+in+Colombo+include+Galle+Face+Green%2C+Viharamahadevi+Park%2C+Beira+Lake%2C+Colombo+Racecourse%2C+Planetarium%2C+University+of+Colombo%2C+Mount+Lavinia+beach%2C+Nelum+Pokuna+Theatre%2C+Colombo+Lotus+Tower+as+well+as+the+National+Museum.+%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A249%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5Njg1OF9tYWluX21haW4mIzAzOTtzX2ltYWdlcy5qcGVn%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%3Bs%3A6%3A%22200.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22200.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22214.00%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%222020-11-24%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22200.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22200.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%227%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22214.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A6%3A%22214.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22200.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A20%3A%22MARINO+BEACH+COLOMBO%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22653%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%222%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A10%3A%22Half+Board%22%3Bs%3A9%3A%22room_type%22%3Bs%3A57%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0++Half+Board%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A58%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0+%28Half+Board%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A45%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0%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%3A1%3A%227%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3Bs%3A16%3A%22user_description%22%3Bs%3A7%3A%22test123%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%223.16%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%227%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2210.84%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%225.42%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22214%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%227%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22user_description%22%3Bs%3A7%3A%22test123%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%2253699----------S000000071%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A66%3A%22Colombo+03%2C+Colombo%2C+Sri+Lanka%0D%0A%0D%0A0.9+km+from+Barefoot+Garden+Cafe%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000071%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%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A3%3A%221.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%223.16%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%225.42%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53699',city_name ='Colombo',city_code ='71100',country_code ='132',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name ='Ankita Rao',salutation ='Ms',first_name ='Ankita',last_name ='Rao',quotation_type ='back_end',total_adult ='1',enquiry_id ='404',total_price ='214',per_night ='214',room_type ='Colonial Manssion - 01 - Double, Extrabed - 0 (Half Board)',room_rate ='214.00' WHERE q_id='1894';
[01/18/2021 10:30:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCD00093' AND quotation_status!='booked';
