[07/26/2021 08:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO enquiry SET agent_id = '21', contact_salutation = 'Ms', contact_name = 'Ms', residing_country = '106', currency = 'INR', enquiry_source = 'on call', destination = '132', nationality = '106', created_by = 'tfg', create_date= '2021-07-26 08:24:39';
[07/26/2021 08:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO task SET module_id='412',module='enquiry',task_status='open',status='A',create_date='2021-07-26 08:24:39' ,created_by='tfg', task_priority='medium', task_description='Offline Quotation Enquiry has been added by tfg&lt;br/&gt;Agent : Qtech_Ankita [CD0021-ankita] [Ankita-Rao]&lt;br/&gt;Country : Sri Lanka&lt;br/&gt;Selected Currency : INR&lt;br/&gt;';
[07/26/2021 08:25:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2021-07-26 08:25:22', '', '', '');
[07/26/2021 08:25:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2021-07-26 08:25:37', '', '', '');
[07/26/2021 08:26:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 412;
[07/26/2021 08:26:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation_sequence SET sequence_no='191' WHERE agent_id='21';
[07/26/2021 08:26:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'RDTCD0021191',backoffice_user = 'tfg',create_date = '2021-07-26 08:26:01',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';
[07/26/2021 08:26:01], [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-07-26 08:26:01', 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='', 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-07-26 08:26:01', 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';
[07/26/2021 08:26:01], [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-27', sequence='2';
[07/26/2021 08:26:01], [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-27';
[07/26/2021 08:26:01], [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-28', sequence='2';
[07/26/2021 08:26:01], [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-28';
[07/26/2021 08:26:01], [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';
[07/26/2021 08:28:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 412;
[07/26/2021 08:28:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'RDTCD0021191',backoffice_user = 'tfg',create_date = '2021-07-26 08:28:07',currency ='INR',service_date='2021-07-28',service_checkout_date='2021-07-28',sequence='3',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-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%221000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%221000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2210%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%221100%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%3A3%3A%22100%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',agent_id = '21',q_info = 'a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22183%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_183_0%22%3Bs%3A4%3A%22name%22%3Bs%3A22%3A%22Srilanka+Transfer+Test%22%3Bs%3A4%3A%22city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A6%3A%22Pickup%22%3Ba%3A0%3A%7B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%223.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%223+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2210%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A7%3A%221100.00%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A7%3A%22Vehical%22%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000066%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22129d2cf3fd8db68c03b7474915ad90b0%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%221100.00%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%221100.00%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A7%3A%221000.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%225%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%229%22%3Bs%3A8%3A%22_content%22%3Bs%3A13%3A%22VAN+15+SEATER%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%221%22%3Bs%3A20%3A%22noofChildPassVehicle%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3B%7Ds%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22language1%22%3Bs%3A1%3A%22E%22%3Bs%3A9%3A%22language2%22%3Bs%3A1%3A%22E%22%3Bs%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A11%3A%22nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A9%3A%22noofadult%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noofchild%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22child_age%22%3Ba%3A0%3A%7B%7Ds%3A18%3A%22selected_child_age%22%3Ba%3A0%3A%7B%7Ds%3A17%3A%22additional_markup%22%3Bs%3A2%3A%2210%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A9%3A%22undefined%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A9%3A%22sri+lanka%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22H%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22H%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22language1_data%22%3Bs%3A7%3A%22English%22%3Bs%3A14%3A%22language2_data%22%3Bs%3A7%3A%22English%22%3Bs%3A21%3A%22dropoff_transfer_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22183%22%3Bs%3A18%3A%22description_number%22%3Bi%3A0%3Bs%3A18%3A%22total_native_price%22%3Bs%3A7%3A%221000.00%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%3A3%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%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A6%3A%22143.48%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2210%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22-43.48%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7Ds%3A8%3A%22Transfer%22%3Ba%3A28%3A%7Bs%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%221000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%221000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2210%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%221100%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%3A3%3A%22100%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%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A2%3A%2210%22%3Bi%3A0%3Bs%3A7%3A%221100.00%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22183%22%3Bs%3A4%3A%22name%22%3Bs%3A22%3A%22Srilanka+Transfer+Test%22%3Bs%3A4%3A%22city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%223.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%223+hr+0+min+%22%3B%7Ds%3A6%3A%22Pickup%22%3Ba%3A0%3A%7B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A14%3A%22originalsource%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22Vehicle%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000066%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22129d2cf3fd8db68c03b7474915ad90b0%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%221100.00%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%221100.00%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A7%3A%221000.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%225%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%229%22%3Bs%3A8%3A%22_content%22%3Bs%3A13%3A%22VAN+15+SEATER%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%221%22%3Bs%3A20%3A%22noofChildPassVehicle%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3B%7D%7Ds%3A19%3A%22transfer_conditions%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2210%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A7%3A%221100.00%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'transfer',hotel_id = '183',additional_markup = '10',city_name ='Colombo',city_code ='71100',country_code ='132',nationality ='106',total_adult ='1',total_child ='0',child_age ='a%3A0%3A%7B%7D',leader_name =' ',salutation ='Ms',first_name ='',last_name ='',quotation_type ='back_end',enquiry_id ='412',total_price ='1100';
[07/26/2021 08:28:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1918', q_name='', service='transfer', agent_id='21', create_date='2021-07-26 08:28:07', q_info='a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22183%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_183_0%22%3Bs%3A4%3A%22name%22%3Bs%3A22%3A%22Srilanka+Transfer+Test%22%3Bs%3A4%3A%22city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A6%3A%22Pickup%22%3Ba%3A0%3A%7B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%223.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%223+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2210%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A7%3A%221100.00%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A7%3A%22Vehical%22%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000066%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22129d2cf3fd8db68c03b7474915ad90b0%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%221100.00%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%221100.00%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A7%3A%221000.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%225%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%229%22%3Bs%3A8%3A%22_content%22%3Bs%3A13%3A%22VAN+15+SEATER%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%221%22%3Bs%3A20%3A%22noofChildPassVehicle%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3B%7Ds%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22language1%22%3Bs%3A1%3A%22E%22%3Bs%3A9%3A%22language2%22%3Bs%3A1%3A%22E%22%3Bs%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A11%3A%22nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A9%3A%22noofadult%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noofchild%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22child_age%22%3Ba%3A0%3A%7B%7Ds%3A18%3A%22selected_child_age%22%3Ba%3A0%3A%7B%7Ds%3A17%3A%22additional_markup%22%3Bs%3A2%3A%2210%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A9%3A%22undefined%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A9%3A%22sri+lanka%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22H%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22H%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22language1_data%22%3Bs%3A7%3A%22English%22%3Bs%3A14%3A%22language2_data%22%3Bs%3A7%3A%22English%22%3Bs%3A21%3A%22dropoff_transfer_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22183%22%3Bs%3A18%3A%22description_number%22%3Bi%3A0%3Bs%3A18%3A%22total_native_price%22%3Bs%3A7%3A%221000.00%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%3A3%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%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A6%3A%22143.48%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2210%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22-43.48%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7Ds%3A8%3A%22Transfer%22%3Ba%3A28%3A%7Bs%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%221000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%221000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2210%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%221100%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%3A3%3A%22100%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%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A2%3A%2210%22%3Bi%3A0%3Bs%3A7%3A%221100.00%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22183%22%3Bs%3A4%3A%22name%22%3Bs%3A22%3A%22Srilanka+Transfer+Test%22%3Bs%3A4%3A%22city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%223.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%223+hr+0+min+%22%3B%7Ds%3A6%3A%22Pickup%22%3Ba%3A0%3A%7B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A14%3A%22originalsource%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22Vehicle%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000066%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22129d2cf3fd8db68c03b7474915ad90b0%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A7%3A%221100.00%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A7%3A%221100.00%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A7%3A%221000.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%225%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%229%22%3Bs%3A8%3A%22_content%22%3Bs%3A13%3A%22VAN+15+SEATER%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%221%22%3Bs%3A20%3A%22noofChildPassVehicle%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3B%7D%7Ds%3A19%3A%22transfer_conditions%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2210%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A7%3A%221100.00%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Colombo', hotel_id='183', additional_markup='10', cancelltion_policy='', per_night=NULL, total_price='1100.00', room_type=NULL, room_rate=NULL, currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2021-07-26 08:28:07', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021191', service_date='2021-07-28 00:00:00', service_checkout_date='2021-07-28 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='1', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name=' ', salutation='Ms', first_name='', last_name='', email='', contact_no='', enquiry_id='412', quotation_status='edited', sequence='3', rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%221000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%221000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2210%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%221100%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%3A3%3A%22100%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';
[07/26/2021 08:28:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1918', service_id='183', service_type='transfer',service_date='2021-07-28', sequence='3';
[07/26/2021 08:28:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1918', service_date='2021-07-28';
[07/26/2021 08:28:07], [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';
[07/26/2021 08:30:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 412;
[07/26/2021 08:30:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'RDTCD0021191',backoffice_user = 'tfg',create_date = '2021-07-26 08:30:06',currency ='INR',service_date='2021/07/28',service_checkout_date='2021/07/28',city_code ='71100',country_code ='132',nationality ='106',total_adult ='1',total_child ='0',child_age ='a%3A0%3A%7B%7D',sequence='4',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-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22201%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2212060%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2213936.54%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%3A7%3A%2231.2756%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D',agent_id = '21',q_info = 'a%3A48%3A%7Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%222021%2F07%2F28%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A17%3A%22terms_n_condition%22%3BN%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3BN%3Bs%3A14%3A%22per_child_rate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A0%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A0%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22fullSingleSightData%22%3Ba%3A53%3A%7Bi%3A0%3Bs%3A9%3A%2213936.540%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A9%3A%22date_from%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A7%3A%22date_to%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A15%3A%22TermsNCondition%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%221%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A7%3A%22to_date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22selected_language%22%3Bs%3A1%3A%22E%22%3Bs%3A10%3A%22child_ages%22%3Ba%3A0%3A%7B%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22actual_adult%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22actual_child%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22201%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2212060%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2213936.54%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%3A7%3A%2231.2756%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A8%3A%22TourTrip%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A3%3A%22sic%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A2%3A%2221%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22MERCEDES+CAR%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A2%3A%2221%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A9%3A%2213936.540%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A3%3A%22201%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22201%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%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%3A3%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%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A7%3A%221817.81%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2258.73%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.49%22%3B%7D%7D%7Ds%3A17%3A%22additional_markup%22%3Bs%3A5%3A%2215.56%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%22RateBreakup%22%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A3%3A%22sic%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A2%3A%2221%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22MERCEDES+CAR%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A2%3A%2221%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A9%3A%2213936.540%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A3%3A%22201%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22201%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%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%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A7%3A%221817.81%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2258.73%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.49%22%3B%7D%7D%7D',service = 'sightseeing',hotel_id = '2',additional_markup = '15.56',city_name ='Colombo',leader_name =' ',salutation ='Ms',first_name ='',last_name ='',quotation_type ='back_end',enquiry_id ='412',total_price ='13936.540';
[07/26/2021 08:30:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1919', q_name='', service='sightseeing', agent_id='21', create_date='2021-07-26 08:30:06', q_info='a%3A48%3A%7Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%222021%2F07%2F28%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A17%3A%22terms_n_condition%22%3BN%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3BN%3Bs%3A14%3A%22per_child_rate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A0%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A0%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22fullSingleSightData%22%3Ba%3A53%3A%7Bi%3A0%3Bs%3A9%3A%2213936.540%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A9%3A%22date_from%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A7%3A%22date_to%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A15%3A%22TermsNCondition%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%221%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A7%3A%22to_date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22selected_language%22%3Bs%3A1%3A%22E%22%3Bs%3A10%3A%22child_ages%22%3Ba%3A0%3A%7B%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22actual_adult%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22actual_child%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22201%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2212060%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2213936.54%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%3A7%3A%2231.2756%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A8%3A%22TourTrip%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A3%3A%22sic%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A2%3A%2221%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22MERCEDES+CAR%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A2%3A%2221%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A9%3A%2213936.540%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A3%3A%22201%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22201%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%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%3A3%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%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A7%3A%221817.81%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2258.73%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.49%22%3B%7D%7D%7Ds%3A17%3A%22additional_markup%22%3Bs%3A5%3A%2215.56%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%22RateBreakup%22%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A3%3A%22sic%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A2%3A%2221%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22MERCEDES+CAR%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A2%3A%2221%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A9%3A%2213936.540%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A3%3A%22201%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22201%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%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%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A7%3A%221817.81%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2258.73%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.49%22%3B%7D%7D%7D', city_name='Colombo', hotel_id='2', additional_markup='16', cancelltion_policy='', per_night=NULL, total_price='13936.54', room_type=NULL, room_rate=NULL, currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2021-07-26 08:30:06', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021191', service_date='2021-07-28 00:00:00', service_checkout_date='2021-07-28 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='1', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name=' ', salutation='Ms', first_name='', last_name='', email='', contact_no='', enquiry_id='412', quotation_status='edited', sequence='4', 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-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22201%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2212060%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2213936.54%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%3A7%3A%2231.2756%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D';
[07/26/2021 08:30:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1919', service_id='2', service_type='sightseeing',service_date='2021-07-28', sequence='4';
[07/26/2021 08:30:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1919', service_date='2021-07-28';
[07/26/2021 08:30:06], [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';
[07/26/2021 08:30:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 412;
[07/26/2021 08:30:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1919', q_name='', service='sightseeing', agent_id='21', create_date='2021-07-26 08:30:14', q_info='a%3A48%3A%7Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%222021%2F07%2F28%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A17%3A%22terms_n_condition%22%3BN%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3BN%3Bs%3A14%3A%22per_child_rate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A0%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A0%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22fullSingleSightData%22%3Ba%3A53%3A%7Bi%3A0%3Bs%3A9%3A%2213936.540%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A9%3A%22date_from%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A7%3A%22date_to%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A15%3A%22TermsNCondition%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%221%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A7%3A%22to_date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22selected_language%22%3Bs%3A1%3A%22E%22%3Bs%3A10%3A%22child_ages%22%3Ba%3A0%3A%7B%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22actual_adult%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22actual_child%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22201%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2212060%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2213936.54%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%3A7%3A%2231.2756%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A8%3A%22TourTrip%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A3%3A%22sic%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A2%3A%2221%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22MERCEDES+CAR%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A2%3A%2221%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A9%3A%2213936.540%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A3%3A%22201%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22201%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%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%3A3%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%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A7%3A%221817.81%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2258.73%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.49%22%3B%7D%7D%7Ds%3A17%3A%22additional_markup%22%3Bs%3A5%3A%2215.56%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%22RateBreakup%22%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A3%3A%22sic%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A2%3A%2221%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22MERCEDES+CAR%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A2%3A%2221%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A9%3A%2213936.540%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A3%3A%22201%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22201%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%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%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A7%3A%221817.81%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2258.73%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.49%22%3B%7D%7D%7D', city_name='Colombo', hotel_id='2', additional_markup='16', cancelltion_policy='', per_night=NULL, total_price='13936.54', room_type=NULL, room_rate=NULL, currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2021-07-26 08:30:14', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021191', service_date='2021-07-28 00:00:00', service_checkout_date='2021-07-28 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='1', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name=' ', salutation='Ms', first_name='', last_name='', email='', contact_no='', enquiry_id='412', quotation_status='edited', sequence='4', 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-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22201%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2212060%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2213936.54%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%3A7%3A%2231.2756%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D';
[07/26/2021 08:30:14], [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-07-26 08:30:14',currency ='INR',service_date='2021/07/28',service_checkout_date='2021/07/28',city_code ='71100',country_code ='132',nationality ='106',total_adult ='1',total_child ='0',child_age ='a%3A0%3A%7B%7D',sequence='4',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-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22201%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2212060%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2213936.54%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%3A7%3A%2231.2756%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D',agent_id = '21',q_info = 'a%3A48%3A%7Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%222021%2F07%2F28%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A17%3A%22terms_n_condition%22%3BN%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3BN%3Bs%3A14%3A%22per_child_rate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A0%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A0%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22fullSingleSightData%22%3Ba%3A53%3A%7Bi%3A0%3Bs%3A9%3A%2213936.540%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A9%3A%22date_from%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A7%3A%22date_to%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A15%3A%22TermsNCondition%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%221%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A7%3A%22to_date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22selected_language%22%3Bs%3A1%3A%22E%22%3Bs%3A10%3A%22child_ages%22%3Ba%3A0%3A%7B%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22actual_adult%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22actual_child%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22201%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2212060%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2213936.54%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%3A7%3A%2231.2756%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A8%3A%22TourTrip%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A3%3A%22sic%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A2%3A%2221%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22MERCEDES+CAR%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A2%3A%2221%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A9%3A%2213936.540%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A3%3A%22201%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22201%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%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%3A3%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%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A7%3A%221817.81%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2258.73%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.49%22%3B%7D%7D%7Ds%3A17%3A%22additional_markup%22%3Bs%3A5%3A%2215.56%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%22RateBreakup%22%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A3%3A%22sic%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A2%3A%2221%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22MERCEDES+CAR%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A2%3A%2221%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22to_slot%22%3BN%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A9%3A%2213936.540%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A3%3A%22201%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22201%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A9%3A%2213936.540%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%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%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A7%3A%221817.81%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2215.56%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2258.73%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.49%22%3B%7D%7D%7D',service = 'sightseeing',hotel_id = '2',additional_markup = '15.56',city_name ='Colombo',leader_name =' ',salutation ='Ms',first_name ='',last_name ='',quotation_type ='back_end',enquiry_id ='412',total_price ='13936.540' WHERE q_id='1919';
[07/26/2021 08:30:14], [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';
[07/26/2021 08:30:19], [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 ('RDTCD0021191') AND agent_id='21' AND quotation_status!='booked';
[07/26/2021 08:32:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_settings SET email_template_data = 'a%3A1%3A%7Bs%3A14%3A%22email_template%22%3Ba%3A18%3A%7Bs%3A6%3A%22action%22%3Bs%3A19%3A%22updateEmailTemplate%22%3Bs%3A7%3A%22is_ajax%22%3Bs%3A4%3A%22true%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A12%3A%22RDTCD0021191%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2221%22%3Bs%3A6%3A%22themes%22%3Bs%3A1%3A%224%22%3Bs%3A10%3A%22categories%22%3Bs%3A1%3A%224%22%3Bs%3A13%3A%22sel_theme_img%22%3Bi%3A2%3Bs%3A18%3A%22selected_theme_img%22%3Bs%3A146%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FRDT%2FCulture%2F1627285124_ceremony-at-la-cabae.jpg%22%3Bs%3A10%3A%22banner_img%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A5%3A%2271129%22%3Bi%3A1%3Bs%3A5%3A%2271100%22%3B%7Ds%3A22%3A%22banner_images_box_imgs%22%3Ba%3A5%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3Bi%3A1%3Bs%3A0%3A%22%22%3Bi%3A2%3Bs%3A0%3A%22%22%3Bi%3A3%3Bs%3A0%3A%22%22%3Bi%3A4%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_051712.png%22%3B%7Ds%3A13%3A%22highlight_img%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A5%3A%2271129%22%3Bi%3A1%3Bs%3A5%3A%2271100%22%3B%7Ds%3A25%3A%22highlight_images_box_imgs%22%3Ba%3A5%3A%7Bi%3A0%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_140636.png%22%3Bi%3A1%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142841.png%22%3Bi%3A2%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142909.png%22%3Bi%3A3%3Bs%3A0%3A%22%22%3Bi%3A4%3Bs%3A0%3A%22%22%3B%7Ds%3A146%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FTFG%2FCulture%2F1627285734_ceremony-at-la-cabae_jpg%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_051712_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_140636_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142841_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142909_png%22%3Bs%3A2%3A%22on%22%3Bs%3A146%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FRDT%2FCulture%2F1627285124_ceremony-at-la-cabae_jpg%22%3Bs%3A2%3A%22on%22%3B%7D%7D',quotation_unique_code = 'RDTCD0021191',created_by = 'tfg',created_at = '2021-07-26 08:32:32';
[07/26/2021 08:32:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE quotation_settings SET email_template_data = 'a%3A2%3A%7Bs%3A14%3A%22email_template%22%3Ba%3A18%3A%7Bs%3A6%3A%22action%22%3Bs%3A19%3A%22updateEmailTemplate%22%3Bs%3A7%3A%22is_ajax%22%3Bs%3A4%3A%22true%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A12%3A%22RDTCD0021191%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2221%22%3Bs%3A6%3A%22themes%22%3Bs%3A1%3A%224%22%3Bs%3A10%3A%22categories%22%3Bs%3A1%3A%224%22%3Bs%3A13%3A%22sel_theme_img%22%3Bi%3A2%3Bs%3A18%3A%22selected_theme_img%22%3Bs%3A146%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FRDT%2FCulture%2F1627285124_ceremony-at-la-cabae.jpg%22%3Bs%3A10%3A%22banner_img%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A5%3A%2271129%22%3Bi%3A1%3Bs%3A5%3A%2271100%22%3B%7Ds%3A22%3A%22banner_images_box_imgs%22%3Ba%3A5%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3Bi%3A1%3Bs%3A0%3A%22%22%3Bi%3A2%3Bs%3A0%3A%22%22%3Bi%3A3%3Bs%3A0%3A%22%22%3Bi%3A4%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_051712.png%22%3B%7Ds%3A13%3A%22highlight_img%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A5%3A%2271129%22%3Bi%3A1%3Bs%3A5%3A%2271100%22%3B%7Ds%3A25%3A%22highlight_images_box_imgs%22%3Ba%3A5%3A%7Bi%3A0%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_140636.png%22%3Bi%3A1%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142841.png%22%3Bi%3A2%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142909.png%22%3Bi%3A3%3Bs%3A0%3A%22%22%3Bi%3A4%3Bs%3A0%3A%22%22%3B%7Ds%3A146%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FTFG%2FCulture%2F1627285734_ceremony-at-la-cabae_jpg%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_051712_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_140636_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142841_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142909_png%22%3Bs%3A2%3A%22on%22%3Bs%3A146%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FRDT%2FCulture%2F1627285124_ceremony-at-la-cabae_jpg%22%3Bs%3A2%3A%22on%22%3B%7Ds%3A14%3A%22service_images%22%3Ba%3A2%3A%7Bs%3A12%3A%22hotel_images%22%3BN%3Bs%3A11%3A%22tour_images%22%3BN%3B%7D%7D',quotation_unique_code = 'RDTCD0021191',updated_by = 'tfg',updated_at = '2021-07-26 08:32:33' where quotation_unique_code = 'RDTCD0021191';
[07/26/2021 08:40:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE quotation_settings SET email_template_data = 'a%3A2%3A%7Bs%3A14%3A%22email_template%22%3Ba%3A21%3A%7Bs%3A6%3A%22action%22%3Bs%3A19%3A%22updateEmailTemplate%22%3Bs%3A7%3A%22is_ajax%22%3Bs%3A4%3A%22true%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A12%3A%22RDTCD0021191%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2221%22%3Bs%3A6%3A%22themes%22%3Bs%3A1%3A%224%22%3Bs%3A10%3A%22categories%22%3Bs%3A1%3A%224%22%3Bs%3A13%3A%22sel_theme_img%22%3Bi%3A2%3Bs%3A18%3A%22selected_theme_img%22%3Bs%3A146%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FRDT%2FCulture%2F1627285124_ceremony-at-la-cabae.jpg%22%3Bs%3A10%3A%22banner_img%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A5%3A%2271129%22%3Bi%3A1%3Bs%3A5%3A%2271100%22%3B%7Ds%3A22%3A%22banner_images_box_imgs%22%3Ba%3A5%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3Bi%3A1%3Bs%3A0%3A%22%22%3Bi%3A2%3Bs%3A0%3A%22%22%3Bi%3A3%3Bs%3A0%3A%22%22%3Bi%3A4%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_051712.png%22%3B%7Ds%3A13%3A%22highlight_img%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A5%3A%2271129%22%3Bi%3A1%3Bs%3A5%3A%2271100%22%3B%7Ds%3A25%3A%22highlight_images_box_imgs%22%3Ba%3A5%3A%7Bi%3A0%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_140636.png%22%3Bi%3A1%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142841.png%22%3Bi%3A2%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142909.png%22%3Bi%3A3%3Bs%3A0%3A%22%22%3Bi%3A4%3Bs%3A0%3A%22%22%3B%7Ds%3A146%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FTFG%2FCulture%2F1627285734_ceremony-at-la-cabae_jpg%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_051712_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_140636_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142841_png%22%3Bs%3A2%3A%22on%22%3Bs%3A119%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_142909_png%22%3Bs%3A2%3A%22on%22%3Bs%3A146%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fgroups%2Femail%2Fthemes%2FRDT%2FCulture%2F1627285124_ceremony-at-la-cabae_jpg%22%3Bs%3A2%3A%22on%22%3Bs%3A13%3A%22setPresetText%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22servicewisedate%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22quotation_special_note%22%3Bs%3A0%3A%22%22%3B%7Ds%3A14%3A%22service_images%22%3Ba%3A2%3A%7Bs%3A12%3A%22hotel_images%22%3BN%3Bs%3A11%3A%22tour_images%22%3BN%3B%7D%7D',preset_text_fields = '',updated_by = 'tfg',updated_at = '2021-07-26 08:40:03' where quotation_unique_code = 'RDTCD0021191';
