[09/04/2020 08:00:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET quotation_status='responded' WHERE unique_id IN ('RDTCD0021185') AND agent_id='21' AND quotation_status!='booked';
[09/04/2020 08:01:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET quotation_status='responded' WHERE unique_id IN ('RDTCD0021185') AND agent_id='21' AND quotation_status!='booked';
[09/04/2020 08:03:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-09-04 08:03:09', '', '', '');
[09/04/2020 08:03:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 395;
[09/04/2020 08:03:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1828', q_name='', service='hotel', agent_id='21', create_date='2020-09-04 08:03:20', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A2088892800%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2230%2F09%2F2020+--+01%2F10%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A4%3A%22name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.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%2282263%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%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Yala', hotel_id='53715', additional_markup='0', cancelltion_policy='', per_night='3705.41', total_price='3705.41', room_type='Bawa Villa - Double (Bed & Breakfast)', room_rate='3705.41', currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-09-04 08:03:20', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021185', service_date='2020-09-30 00:00:00', service_checkout_date='2020-10-01 00:00:00', city_code='82263', 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 Test', salutation='Ms', first_name='Ankita', last_name='Test', email='', contact_no='', enquiry_id='395', 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%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D';
[09/04/2020 08:03:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'RDTCD0021185',modified_by = 'tfg',modified_date = '2020-09-04 08:03:20',currency ='INR',service_date='2020-09-30 00:00:00',service_checkout_date='2020-10-01 00:00:00',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%3A2088892800%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2230%2F09%2F2020+--+01%2F10%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A4%3A%22name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.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%2282263%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%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53715',city_name ='Yala',city_code ='82263',country_code ='132',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name ='Ankita Test',salutation ='Ms',first_name ='Ankita',last_name ='Test',quotation_type ='back_end',total_adult ='2',enquiry_id ='395',total_price ='3705.41',per_night ='3705.41',room_type ='Bawa Villa - Double (Bed & Breakfast)',room_rate ='3705.41' WHERE q_id='1828';
[09/04/2020 08:03:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='RDTCD0021185' AND quotation_status!='booked';
[09/04/2020 08:03:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-09-04 08:03:21', '', '', '');
[09/04/2020 08:03:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET quotation_status='responded' WHERE unique_id IN ('RDTCD0021185') AND agent_id='21' AND quotation_status!='booked';
[09/04/2020 08:03:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 395;
[09/04/2020 08:03:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1828', q_name='', service='hotel', agent_id='21', create_date='2020-09-04 08:03:43', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A2088892800%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2230%2F09%2F2020+--+01%2F10%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A4%3A%22name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.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%2282263%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%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Yala', hotel_id='53715', additional_markup='0', cancelltion_policy='', per_night='3705.41', total_price='3705.41', room_type='Bawa Villa - Double (Bed & Breakfast)', room_rate='3705.41', currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-09-04 08:03:43', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021185', service_date='2020-09-30 00:00:00', service_checkout_date='2020-10-01 00:00:00', city_code='82263', 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 Test', salutation='Ms', first_name='Ankita', last_name='Test', email='', contact_no='', enquiry_id='395', 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%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D';
[09/04/2020 08:03:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'RDTCD0021185',modified_by = 'tfg',modified_date = '2020-09-04 08:03:43',currency ='INR',service_date='2020-09-30 00:00:00',service_checkout_date='2020-10-01 00:00:00',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%3A2088892800%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2230%2F09%2F2020+--+01%2F10%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A4%3A%22name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.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%2282263%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%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53715',city_name ='Yala',city_code ='82263',country_code ='132',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name ='Ankita Test',salutation ='Ms',first_name ='Ankita',last_name ='Test',quotation_type ='back_end',total_adult ='2',enquiry_id ='395',total_price ='3705.41',per_night ='3705.41',room_type ='Bawa Villa - Double (Bed & Breakfast)',room_rate ='3705.41' WHERE q_id='1828';
[09/04/2020 08:03:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='RDTCD0021185' AND quotation_status!='booked';
[09/04/2020 08:04:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 395;
[09/04/2020 08:04:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1828', q_name='', service='hotel', agent_id='21', create_date='2020-09-04 08:04:01', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A2088892800%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2230%2F09%2F2020+--+01%2F10%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A4%3A%22name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.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%2282263%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%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Yala', hotel_id='53715', additional_markup='0', cancelltion_policy='', per_night='3705.41', total_price='3705.41', room_type='Bawa Villa - Double (Bed & Breakfast)', room_rate='3705.41', currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-09-04 08:04:01', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021185', service_date='2020-09-30 00:00:00', service_checkout_date='2020-10-01 00:00:00', city_code='82263', 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 Test', salutation='Ms', first_name='Ankita', last_name='Test', email='', contact_no='', enquiry_id='395', 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%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D';
[09/04/2020 08:04:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'RDTCD0021185',modified_by = 'tfg',modified_date = '2020-09-04 08:04:01',currency ='INR',service_date='2020-09-30 00:00:00',service_checkout_date='2020-10-01 00:00:00',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%3A2088892800%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2230%2F09%2F2020+--+01%2F10%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253715%22%3Bs%3A4%3A%22name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.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%2282263%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%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%223705.41%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-30%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A8%3A%223091.962%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2219.84%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A5%3A%2239.68%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%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%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A7%3A%223705.41%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221031%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A36%3A%22Bawa+Villa+-+Double++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A37%3A%22Bawa+Villa+-+Double+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A19%3A%22Bawa+Villa+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E129%7E%7E%7E1031%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E82263%7E%7E%7E0%7E%7E%7ES000000088%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22613.45%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2219.84%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%223705.41%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%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%22MYR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%2219.840088590998%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A8%3A%2215.45981%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%2253715----------S000000088%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A12%3A%22Kulu+Safaris%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A12%3A%22Test+Address%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000088%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2219.84%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53715',city_name ='Yala',city_code ='82263',country_code ='132',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name ='Ankita Test',salutation ='Ms',first_name ='Ankita',last_name ='Test',quotation_type ='back_end',total_adult ='2',enquiry_id ='395',total_price ='3705.41',per_night ='3705.41',room_type ='Bawa Villa - Double (Bed & Breakfast)',room_rate ='3705.41' WHERE q_id='1828';
[09/04/2020 08:04:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='RDTCD0021185' AND quotation_status!='booked';
[09/04/2020 08:04:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET quotation_status='responded' WHERE unique_id IN ('RDTCD0021185') AND agent_id='21' AND quotation_status!='booked';
