[10/16/2020 06:58:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 384;
[10/16/2020 06:58:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1808', q_name='Tax ALL CHANGES', service='hotel', agent_id='22', create_date='2020-10-16 06:58:51', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1589241600%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2214%2F11%2F2020+--+17%2F11%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%223%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A4%3A%22name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%220.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%3A3%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7Di%3A1%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7Di%3A2%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A3%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7Di%3A1%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7Di%3A2%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A3%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-14%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A1%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-15%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A2%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-16%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%222%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%22336.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22300.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E147%7E%7E%7E970%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22970%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A37%3A%22Monara+-+Single%2C+Max+Pax-14+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A38%3A%22Monara+-+Single%2C+Max+Pax-14%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A27%3A%22Monara+-+Single%2C+Max+Pax-14%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%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E147%7E%7E%7E970%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A92%3A%22This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%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%224.70%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2231.30%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.43%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22336%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22300%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%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%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22user_description%22%3Bs%3A92%3A%22This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%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%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%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%3A1%3A%221%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A9%3A%22Qtech+VAT%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A2%3A%2215%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%3A2%3A%2215%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%224.70%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.43%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.278698%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2299.730656%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%3A5%3A%2271129%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%3A285%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%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%3A3%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7Di%3A1%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7Di%3A2%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A3%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7Di%3A1%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7Di%3A2%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A3%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-14%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A1%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-15%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A2%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-16%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%222%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%22336.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22300.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E147%7E%7E%7E970%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22970%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A37%3A%22Monara+-+Single%2C+Max+Pax-14+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A38%3A%22Monara+-+Single%2C+Max+Pax-14%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A27%3A%22Monara+-+Single%2C+Max+Pax-14%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%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E147%7E%7E%7E970%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A92%3A%22This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%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%224.70%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2231.30%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.43%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22336%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22300%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%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%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22user_description%22%3Bs%3A92%3A%22This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%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%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%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%3A1%3A%221%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A9%3A%22Qtech+VAT%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A2%3A%2215%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%3A2%3A%2215%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%224.70%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.43%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Bentota', hotel_id='53704', additional_markup='0', cancelltion_policy='', per_night='112.00', total_price='336.00', room_type='Monara - Single, Max Pax-14(Room Only)', room_rate='336.00', currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-10-16 06:58:51', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002219', service_date='2020-11-14 00:00:00', service_checkout_date='2020-11-17 00:00:00', city_code='71129', 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='Ankita Rao', salutation='Ms', first_name='Ankita', last_name='Rao', email='ankita.rao@qtechsoftware.com', contact_no='7666065659', enquiry_id='384', quotation_status='edited', sequence='10', rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-14%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A1%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-15%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A2%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-16%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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';
[10/16/2020 06:58:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = 'Tax ALL CHANGES',email='ankita.rao@qtechsoftware.com',contact_no='7666065659',unique_id = 'QTECHCA002219',modified_by = 'tfg',modified_date = '2020-10-16 06:58:51',currency ='INR',service_date='2020-11-14 00:00:00',service_checkout_date='2020-11-17 00:00:00',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-14%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A1%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-15%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A2%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-16%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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='10',agent_id = '22',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1589241600%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2214%2F11%2F2020+--+17%2F11%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%223%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A4%3A%22name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%220.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%3A3%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7Di%3A1%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7Di%3A2%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A3%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7Di%3A1%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7Di%3A2%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A3%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-14%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A1%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-15%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A2%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-16%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%222%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%22336.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22300.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E147%7E%7E%7E970%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22970%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A37%3A%22Monara+-+Single%2C+Max+Pax-14+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A38%3A%22Monara+-+Single%2C+Max+Pax-14%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A27%3A%22Monara+-+Single%2C+Max+Pax-14%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%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E147%7E%7E%7E970%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A498%3A%22This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%3Cdiv%3E%3Cbr%3E%3C%2Fdiv%3E%3Cdiv%3EPart+two+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%3C%2Fdiv%3E%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%224.70%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2231.30%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.43%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22336%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22300%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%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%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22user_description%22%3Bs%3A498%3A%22This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%3Cdiv%3E%3Cbr%3E%3C%2Fdiv%3E%3Cdiv%3EPart+two+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%3C%2Fdiv%3E%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%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%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%3A1%3A%221%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A9%3A%22Qtech+VAT%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A2%3A%2215%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%3A2%3A%2215%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%224.70%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.43%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.278698%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2299.730656%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%3A5%3A%2271129%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%3A285%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%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%3A3%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7Di%3A1%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7Di%3A2%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A3%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7Di%3A1%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7Di%3A2%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22112.00%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A3%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-14%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A1%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-15%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%7Di%3A2%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-16%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%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%22112.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%222%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%22336.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22300.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E147%7E%7E%7E970%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22970%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A37%3A%22Monara+-+Single%2C+Max+Pax-14+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A38%3A%22Monara+-+Single%2C+Max+Pax-14%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A27%3A%22Monara+-+Single%2C+Max+Pax-14%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%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E147%7E%7E%7E970%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A498%3A%22This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%3Cdiv%3E%3Cbr%3E%3C%2Fdiv%3E%3Cdiv%3EPart+two+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%3C%2Fdiv%3E%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%224.70%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2231.30%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.43%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22336%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22300%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%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%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22user_description%22%3Bs%3A498%3A%22This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%3Cdiv%3E%3Cbr%3E%3C%2Fdiv%3E%3Cdiv%3EPart+two+This+is+a+test+text+to+check+the+font+size+and+font+that+is+used+to+display+this+text..+etc.%3C%2Fdiv%3E%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%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%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%3A1%3A%221%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A9%3A%22Qtech+VAT%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A2%3A%2215%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%3A2%3A%2215%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%224.70%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2210.43%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53704',city_name ='Bentota',city_code ='71129',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 ='2',enquiry_id ='384',total_price ='336',per_night ='112',room_type ='Monara - Single, Max Pax-14(Room Only)',room_rate ='336.00' WHERE q_id='1808';
[10/16/2020 06:58:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002219' AND quotation_status!='booked';
