[10/14/2021 05:38:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 412;
[10/14/2021 05:38:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1917', q_name='', service='hotel', agent_id='21', create_date='2021-10-14 05:38:28', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1988928000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2227%2F07%2F2021+--+28%2F07%2F2021%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%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%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A1%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A1%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%221.12%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-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A1%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.12%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%3A4%3A%220.12%22%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%3A4%3A%221.12%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A1%3A%221%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+Single%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%221%7E%7E%7E154%7E%7E%7E991%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%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.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.08%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%221.12%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A1%3A%221%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%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%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%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%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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%3A1%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%22106%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%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A1%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A1%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%221.12%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-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A1%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.12%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%3A4%3A%220.12%22%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%3A4%3A%221.12%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A1%3A%221%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+Single%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%221%7E%7E%7E154%7E%7E%7E991%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%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.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.08%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%221.12%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A1%3A%221%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%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%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%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%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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='', supplier_cancellation_policy=NULL, per_night='1.12', total_price='1.12', room_type='Whole Villa - Single', room_rate='1.12', currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2021-10-14 05:38:28', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021191', service_date='2021-07-27 00:00:00', service_checkout_date='2021-07-28 00:00:00', city_code='71129', 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=' ', salutation='Ms', first_name='', last_name='', email='', contact_no='', enquiry_id='412', quotation_status='edited', sequence='2', 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-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A1%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.12%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%3A4%3A%220.12%22%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/14/2021 05:38:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'RDTCD0021191',modified_by = 'tfg',modified_date = '2021-10-14 05:38:28',currency ='INR',service_date='2021-07-27 00:00:00',service_checkout_date='2021-07-28 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-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A1%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.12%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%3A4%3A%220.12%22%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='2',agent_id = '21',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1988928000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2227%2F07%2F2021+--+28%2F07%2F2021%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%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%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A1%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A1%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%221.12%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-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A1%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.12%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%3A4%3A%220.12%22%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%3A4%3A%221.12%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A1%3A%221%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+Single%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%221%7E%7E%7E154%7E%7E%7E991%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%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.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.08%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%221.12%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A1%3A%221%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%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%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%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%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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%3A1%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%22106%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%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A1%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A1%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%221.12%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-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A1%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.12%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%3A4%3A%220.12%22%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%3A4%3A%221.12%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A1%3A%221%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+Single%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%221%7E%7E%7E154%7E%7E%7E991%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%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.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.08%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%221.12%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A1%3A%221%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%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%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%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%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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 =' ',salutation ='Ms',first_name ='',last_name ='',quotation_type ='back_end',total_adult ='1',enquiry_id ='412',total_price ='1.12',per_night ='1.12',room_type ='Whole Villa - Single',room_rate ='1.12' WHERE q_id='1917';
[10/14/2021 05:38:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='RDTCD0021191' AND quotation_status!='booked';
[10/14/2021 05:40:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 412;
[10/14/2021 05:40:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1917', q_name='', service='hotel', agent_id='21', create_date='2021-10-14 05:40:00', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1988928000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2227%2F07%2F2021+--+28%2F07%2F2021%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%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%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A1%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A1%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%221.12%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-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A1%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.12%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%3A4%3A%220.12%22%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%3A4%3A%221.12%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A1%3A%221%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+Single%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%221%7E%7E%7E154%7E%7E%7E991%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%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.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.08%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%221.12%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A1%3A%221%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%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%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%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%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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%3A1%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%22106%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%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A1%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A1%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%221.12%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-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A1%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.12%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%3A4%3A%220.12%22%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%3A4%3A%221.12%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A1%3A%221%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+Single%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%221%7E%7E%7E154%7E%7E%7E991%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%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.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.08%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%221.12%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A1%3A%221%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%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%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%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%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.04%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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='', supplier_cancellation_policy=NULL, per_night='1.12', total_price='1.12', room_type='Whole Villa - Single', room_rate='1.12', currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2021-10-14 05:40:00', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021191', service_date='2021-07-27 00:00:00', service_checkout_date='2021-07-28 00:00:00', city_code='71129', 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=' ', salutation='Ms', first_name='', last_name='', email='', contact_no='', enquiry_id='412', quotation_status='edited', sequence='2', 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-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A1%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.12%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%3A4%3A%220.12%22%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/14/2021 05:40:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'RDTCD0021191',modified_by = 'tfg',modified_date = '2021-10-14 05:40:00',currency ='INR',service_date='2021-07-27 00:00:00',service_checkout_date='2021-07-29 00:00:00',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.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%3A5%3A%2222.40%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%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.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%3A5%3A%2222.40%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='2',agent_id = '21',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1988928000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2227%2F07%2F2021+--+29%2F07%2F2021%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%222%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%3A2%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3B%7Di%3A1%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2222.40%22%3B%7Di%3A1%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2222.40%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A2%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.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%3A5%3A%2222.40%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%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.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%3A5%3A%2222.40%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%3A5%3A%2244.80%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A5%3A%2240.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+Single%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%3A18%3A%2211.999999999999993%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%7E154%7E%7E%7E991%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%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%221.51%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2211.999999999999993%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.29%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%2244.8%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A2%3A%2240%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%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%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%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%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%221.51%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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%3A1%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%22106%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%3A2%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3B%7Di%3A1%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2222.40%22%3B%7Di%3A1%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2222.40%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A2%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.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%3A5%3A%2222.40%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%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.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%3A5%3A%2222.40%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%3A5%3A%2244.80%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A5%3A%2240.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+Single%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%3A18%3A%2211.999999999999993%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%7E154%7E%7E%7E991%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%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%221.51%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2211.999999999999993%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.29%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%2244.8%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A2%3A%2240%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%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%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%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%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%221.51%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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 =' ',salutation ='Ms',first_name ='',last_name ='',quotation_type ='back_end',total_adult ='1',enquiry_id ='412',total_price ='44.8',per_night ='22.4',room_type ='Whole Villa - Single',room_rate ='44.80' WHERE q_id='1917';
[10/14/2021 05:40:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1917', service_id='53704', service_type='hotel',service_date='2021-07-29', sequence='2';
[10/14/2021 05:40:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1917', service_date='2021-07-29';
[10/14/2021 05:40:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='RDTCD0021191' AND quotation_status!='booked';
[10/14/2021 05:40:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET is_optional = @is_optional :=NOT is_optional WHERE q_id='1917';;
[10/14/2021 05:40:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET is_optional = @is_optional :=NOT is_optional WHERE q_id='1917';;
[10/14/2021 05:48:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logout.php],INSERT INTO psa_login_log set username = 'tfg' , user_type = 'tfg'_type , branch_id = '' , login_datetime = '2021-10-14 05:48:21' , ip = '43.239.53.130' , action = 'Logout'  ;
