[05/03/2023 06:48:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into email_logs SET `subject`= 'Quotation Details',from_email_id= 'sneha.jain@qtechsoftware.com',body= '[encoded data, 69696 characters]',to_email_id= 'sneha.jain@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/controller_quotation.php?action=emailThemeQuotation',create_date= '2023-05-03 06:48:10';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation_sequence SET sequence_no='198' WHERE agent_id='21';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO task SET module_id='417',module='enquiry',task_status='open',status='A',create_date='2023-05-03 06:59:18' ,created_by='tfg', task_priority='medium', task_description='Offline Quotation Enquiry has been added by tfg&lt;br/&gt;';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_settings SET quotation_unique_code='RDTCD0021198', preset_text_fields='a%3A3%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A5%3A%22label%22%3Bs%3A18%3A%22Terms+%26+conditions%22%3Bs%3A11%3A%22description%22%3Bs%3A690%3A%22%3Cdiv%3E%3Cul%3E%3Cli%3EValid+for+Economy+class+return+air+fares+purchased+online+at+macktrip.com%3C%2Fli%3E%3Cli%3EFares+mentioned+above+are+including+of+taxes+and+surcharges+and+are+subject+to+change+without+prior+notice%3C%2Fli%3E%3Cli%3EFares+mentioned+above+are+subject+to+availability%3C%2Fli%3E%3Cli%3EPassengers+will+be+charged+the+applicable+penalties+for+any+changes%3C%2Fli%3E%3Cli%3EPassengers+need+to+obtain+relevant+Visas%2C+other+authorizations+and+documents+required+for+travel%3C%2Fli%3E%3Cli%3EStandard+terms+and+conditions+and+fare+rules+will+continue+to+apply%3C%2Fli%3E%3Cli%3EMacktrip+reserves+the+right+to+withdraw+all+or+any+of+the+rules+applicable+to+the+above+offer+at+any+time+at+its+sole+discretion+without+prior+notice%3C%2Fli%3E%3C%2Ful%3E%3C%2Fdiv%3E%22%3Bs%3A2%3A%22id%22%3Bs%3A1%3A%221%22%3B%7Di%3A1%3Ba%3A3%3A%7Bs%3A5%3A%22label%22%3Bs%3A8%3A%22Includes%22%3Bs%3A11%3A%22description%22%3Bs%3A209%3A%22After+breakfast%2C+transfer+back+to+Colombo%2C+visiting+Hambantota+Salterns+and+the+Stilt+Fisherman+at+Weligama+en+route%2C+followed+by+the+Galle+Fort.+In+Colombo%2C+take+a+city+tour+to+end+your+Sri+Lanka+exploration.%22%3Bs%3A2%3A%22id%22%3Bs%3A1%3A%222%22%3B%7Di%3A2%3Ba%3A3%3A%7Bs%3A5%3A%22label%22%3Bs%3A7%3A%22Exclude%22%3Bs%3A11%3A%22description%22%3Bs%3A209%3A%22After+breakfast%2C+transfer+back+to+Colombo%2C+visiting+Hambantota+Salterns+and+the+Stilt+Fisherman+at+Weligama+en+route%2C+followed+by+the+Galle+Fort.+In+Colombo%2C+take+a+city+tour+to+end+your+Sri+Lanka+exploration.%22%3Bs%3A2%3A%22id%22%3Bs%3A1%3A%223%22%3B%7D%7D', email_template_data='a%3A2%3A%7Bs%3A14%3A%22email_template%22%3Ba%3A23%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%22RDTCD0021197%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2221%22%3Bs%3A6%3A%22themes%22%3Bs%3A1%3A%226%22%3Bs%3A10%3A%22categories%22%3Bs%3A2%3A%2217%22%3Bs%3A13%3A%22sel_theme_img%22%3BN%3Bs%3A18%3A%22selected_theme_img%22%3Bb%3A0%3Bs%3A10%3A%22banner_img%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A5%3A%2271649%22%3B%7Ds%3A22%3A%22banner_images_box_imgs%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_102314.png%22%3B%7Ds%3A13%3A%22highlight_img%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A5%3A%2271649%22%3B%7Ds%3A25%3A%22highlight_images_box_imgs%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A119%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Fpackage_images%2F%2Fgallery%2FImage_102314.png%22%3B%7Ds%3A8%3A%22services%22%3Bs%3A2%3A%2232%22%3Bs%3A17%3A%22selected_tour_img%22%3Bs%3A0%3A%22%22%3Bs%3A122%3A%22https%3A%2F%2Falpha_otrams_thefabulousgetaway_com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1677821337_op_1_HKGTheme1_jpeg%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_102314_png%22%3Bs%3A2%3A%22on%22%3Bs%3A13%3A%22admin_session%22%3Bs%3A32%3A%22288d79492c423fca8a9b6be9c63f5f49%22%3Bs%3A3%3A%22_ga%22%3Bs%3A26%3A%22GA1.2.986287956.1678282316%22%3Bs%3A6%3A%22__hstc%22%3Bs%3A85%3A%2242914746.13bd35671ceca6ce399c332c35ad8e78.1678282327450.1678282327450.1680152787629.2%22%3Bs%3A10%3A%22hubspotutk%22%3Bs%3A32%3A%2213bd35671ceca6ce399c332c35ad8e78%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%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A32%3Ba%3A3%3A%7Bi%3A0%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1677821337_op_1_HKGTheme1.jpeg%22%3Bi%3A1%3Bs%3A0%3A%22%22%3Bi%3A2%3Bs%3A0%3A%22%22%3B%7D%7D%7D%7D%7D', created_by='tfg', updated_by=NULL, created_at='2023-05-03 06:59:18', updated_at=NULL;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation  SET q_name='Family Tour', service='hotel', agent_id='21', create_date='2023-05-03 06:59:18', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1686787200%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2215%2F06%2F2023+--+16%2F06%2F2023%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2247877%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2247877%22%3Bs%3A4%3A%22name%22%3Bs%3A48%3A%22THE+WESTIN+DUBAI+MINA+SEYAHI+BEACH+RESORT+MARINA%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%225.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22105.00%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222023-04-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22105.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A6%3A%22105.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22100.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E896%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71649%7E%7E%7E0%7E%7E%7ES000000212%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A6%3A%22Snehal%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22896%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A43%3A%22Junior+Suite+Tower+-+Double+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A27%3A%22Junior+Suite+Tower+-+Double%22%3Bs%3A13%3A%22room_category%22%3Bs%3A27%3A%22Junior+Suite+Tower+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%225%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E896%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71649%7E%7E%7E0%7E%7E%7ES000000212%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%225%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%225.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%225.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22105%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22100%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%225%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%2247877----------S000000212%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A48%3A%22THE+WESTIN+DUBAI+MINA+SEYAHI+BEACH+RESORT+MARINA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%225.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%2225.09239%22%3Bs%3A9%3A%22longitude%22%3Bs%3A7%3A%2255.1495%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271649%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22138%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%3BN%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22105.00%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222023-04-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22105.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A6%3A%22105.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22100.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E896%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71649%7E%7E%7E0%7E%7E%7ES000000212%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A6%3A%22Snehal%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22896%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A43%3A%22Junior+Suite+Tower+-+Double+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A27%3A%22Junior+Suite+Tower+-+Double%22%3Bs%3A13%3A%22room_category%22%3Bs%3A27%3A%22Junior+Suite+Tower+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%225%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E896%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71649%7E%7E%7E0%7E%7E%7ES000000212%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%225%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%225.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%225.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22105%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22100%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%225%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%2247877----------S000000212%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A48%3A%22THE+WESTIN+DUBAI+MINA+SEYAHI+BEACH+RESORT+MARINA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%225.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Dubai', hotel_id='47877', additional_markup='0', cancelltion_policy='', supplier_cancellation_policy=NULL, per_night='105.00', total_price='105.00', room_type='Junior Suite Tower - Double', room_rate='105.00', currency='AED', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2023-04-10 10:17:20', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021198', service_date='2023-06-15 00:00:00', service_checkout_date='2023-06-16 00:00:00', city_code='71649', country_code='138', nationality='106', total_adult='2', total_child='0', child_age='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D', leader_name='TestA TestL', salutation='Ms', first_name='TestA', last_name='TestL', email='ashwini.shetty@qtechsoftware.com', contact_no='91-12345566', enquiry_id='417', quotation_status='copied', 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%222023-04-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22105.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7D%7D%7D';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1960', q_name='Family Tour', service='hotel', agent_id='21', create_date='2023-05-03 06:59:18', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1686787200%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2215%2F06%2F2023+--+16%2F06%2F2023%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2247877%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2247877%22%3Bs%3A4%3A%22name%22%3Bs%3A48%3A%22THE+WESTIN+DUBAI+MINA+SEYAHI+BEACH+RESORT+MARINA%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%225.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22105.00%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222023-04-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22105.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A6%3A%22105.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22100.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E896%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71649%7E%7E%7E0%7E%7E%7ES000000212%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A6%3A%22Snehal%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22896%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A43%3A%22Junior+Suite+Tower+-+Double+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A27%3A%22Junior+Suite+Tower+-+Double%22%3Bs%3A13%3A%22room_category%22%3Bs%3A27%3A%22Junior+Suite+Tower+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%225%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E896%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71649%7E%7E%7E0%7E%7E%7ES000000212%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%225%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%225.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%225.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22105%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22100%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%225%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%2247877----------S000000212%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A48%3A%22THE+WESTIN+DUBAI+MINA+SEYAHI+BEACH+RESORT+MARINA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%225.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%2225.09239%22%3Bs%3A9%3A%22longitude%22%3Bs%3A7%3A%2255.1495%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271649%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22138%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%3BN%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22100.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A6%3A%22105.00%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222023-04-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22105.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A6%3A%22105.00%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22100.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E896%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71649%7E%7E%7E0%7E%7E%7ES000000212%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A6%3A%22Snehal%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22896%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A43%3A%22Junior+Suite+Tower+-+Double+Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A27%3A%22Junior+Suite+Tower+-+Double%22%3Bs%3A13%3A%22room_category%22%3Bs%3A27%3A%22Junior+Suite+Tower+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%225%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E133%7E%7E%7E896%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71649%7E%7E%7E0%7E%7E%7ES000000212%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%225%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%225.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%225.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A3%3A%22105%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22100%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%225%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%2247877----------S000000212%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A48%3A%22THE+WESTIN+DUBAI+MINA+SEYAHI+BEACH+RESORT+MARINA%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000212%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%225.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Dubai', hotel_id='47877', additional_markup='0', cancelltion_policy='', supplier_cancellation_policy=NULL, per_night='105.00', total_price='105.00', room_type='Junior Suite Tower - Double', room_rate='105.00', currency='AED', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2023-05-03 06:59:18', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021198', service_date='2023-06-15 00:00:00', service_checkout_date='2023-06-16 00:00:00', city_code='71649', country_code='138', nationality='106', total_adult='2', total_child='0', child_age='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D', leader_name='TestA TestL', salutation='Ms', first_name='TestA', last_name='TestL', email='ashwini.shetty@qtechsoftware.com', contact_no='91-12345566', enquiry_id='417', 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%222023-04-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A6%3A%22105.00%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7D%7D%7D';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],DELETE FROM day_wise_quotation_itinerary WHERE quote_id='1956';;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary  SET quote_id='1960', service_id='47877', service_type='hotel', service_date='2023-06-15', sequence='3';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary  SET quote_id='1960', service_id='47877', service_type='hotel', service_date='2023-06-16', sequence='3';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],DELETE FROM day_wise_quotation_description WHERE quote_id='1956';;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description  SET quote_id='1960', service_date='2023-06-15', description=NULL;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description  SET quote_id='1960', service_date='2023-06-16', description=NULL;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation  SET q_name='Family Tour', service='transfer', agent_id='21', create_date='2023-05-03 06:59:18', q_info='a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%222%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222023-06-15%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22281%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_281_0%22%3Bs%3A4%3A%22name%22%3Bs%3A10%3A%22Air+to+Acc%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%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%222.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%222+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22BHD%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%3A8%3A%2210708.83%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%22S000000212%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A7%3A%22private%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%22c9a6a8b078ec9a6726588a920ef6fb22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%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%3A8%3A%2210708.83%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A8%3A%2210708.83%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A7%3A%221000.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22BHD%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%3A1%3A%220%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%3A2%3A%2219%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%226%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%22Safari+Jeep%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%222%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%22AED%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22138%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2271649%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%3A6%3A%229.7353%22%3Bs%3A11%3A%22nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A9%3A%22noofadult%22%3Bs%3A1%3A%222%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%3A20%3A%22United+Arab+Emirates%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A27%3A%22Dubai+International+Airport%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A50%3A%22The+Westin+Dubai+Mina+Seyahi+Beach+Resort+%26+Marina%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22A%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22H%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A3%3A%22105%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A11%3A%2219638_71649%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A0%3A%22%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%2271649%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22281%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%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2210%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22973.53%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.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%222023-04-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%221000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%229735.3%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%3A6%3A%229.7353%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2210708.83%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%22BHD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7Ds%3A27%3A%22display_currency_multiplier%22%3Bs%3A6%3A%229.7353%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A2%3A%2210%22%3Bi%3A0%3Bs%3A8%3A%2210708.83%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22281%22%3Bs%3A4%3A%22name%22%3Bs%3A10%3A%22Air+to+Acc%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2271649%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%222.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%222+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%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22BHD%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%22S000000212%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A7%3A%22private%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%22c9a6a8b078ec9a6726588a920ef6fb22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%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%3A8%3A%2210708.83%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A8%3A%2210708.83%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A7%3A%221000.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22BHD%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%3A1%3A%220%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%3A2%3A%2219%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%226%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%22Safari+Jeep%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%222%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%3A8%3A%2210708.83%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Dubai', hotel_id='281', additional_markup='10', cancelltion_policy='', supplier_cancellation_policy=NULL, per_night=NULL, total_price='10708.83', room_type=NULL, room_rate=NULL, currency='AED', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by=NULL, modified_date='0000-00-00 00:00:00', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021198', service_date='2023-06-15 00:00:00', service_checkout_date='2023-06-15 00:00:00', city_code='71649', country_code='138', nationality='106', total_adult='2', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name='TestA TestL', salutation='Ms', first_name='TestA', last_name='TestL', email='ashwini.shetty@qtechsoftware.com', contact_no='91-12345566', enquiry_id='417', quotation_status='copied', 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%222023-04-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%221000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%229735.3%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%3A6%3A%229.7353%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2210708.83%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%22BHD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7D%7D%7D';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1961', q_name='Family Tour', service='transfer', agent_id='21', create_date='2023-05-03 06:59:18', q_info='a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%222%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222023-06-15%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22281%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_281_0%22%3Bs%3A4%3A%22name%22%3Bs%3A10%3A%22Air+to+Acc%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%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%222.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%222+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22BHD%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%3A8%3A%2210708.83%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%22S000000212%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A7%3A%22private%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%22c9a6a8b078ec9a6726588a920ef6fb22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%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%3A8%3A%2210708.83%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A8%3A%2210708.83%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A7%3A%221000.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22BHD%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%3A1%3A%220%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%3A2%3A%2219%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%226%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%22Safari+Jeep%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%222%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%22AED%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22138%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2271649%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%3A6%3A%229.7353%22%3Bs%3A11%3A%22nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A9%3A%22noofadult%22%3Bs%3A1%3A%222%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%3A20%3A%22United+Arab+Emirates%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A27%3A%22Dubai+International+Airport%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A50%3A%22The+Westin+Dubai+Mina+Seyahi+Beach+Resort+%26+Marina%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22A%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22H%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A3%3A%22105%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A11%3A%2219638_71649%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A0%3A%22%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%2271649%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22281%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%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2210%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22973.53%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2210.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%222023-04-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%221000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%229735.3%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%3A6%3A%229.7353%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2210708.83%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%22BHD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7Ds%3A27%3A%22display_currency_multiplier%22%3Bs%3A6%3A%229.7353%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A2%3A%2210%22%3Bi%3A0%3Bs%3A8%3A%2210708.83%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22281%22%3Bs%3A4%3A%22name%22%3Bs%3A10%3A%22Air+to+Acc%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2271649%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%222.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%222+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%22AED%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22BHD%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%22S000000212%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A7%3A%22private%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%22c9a6a8b078ec9a6726588a920ef6fb22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%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%3A8%3A%2210708.83%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A8%3A%2210708.83%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A7%3A%221000.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22BHD%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%3A1%3A%220%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%3A2%3A%2219%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%226%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%22Safari+Jeep%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%222%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%3A8%3A%2210708.83%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Dubai', hotel_id='281', additional_markup='10', cancelltion_policy='', supplier_cancellation_policy=NULL, per_night=NULL, total_price='10708.83', room_type=NULL, room_rate=NULL, currency='AED', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2023-05-03 06:59:18', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021198', service_date='2023-06-15 00:00:00', service_checkout_date='2023-06-15 00:00:00', city_code='71649', country_code='138', nationality='106', total_adult='2', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name='TestA TestL', salutation='Ms', first_name='TestA', last_name='TestL', email='ashwini.shetty@qtechsoftware.com', contact_no='91-12345566', enquiry_id='417', 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%222023-04-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%221000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%229735.3%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%3A6%3A%229.7353%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A8%3A%2210708.83%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%22BHD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7D%7D%7D';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],DELETE FROM day_wise_quotation_itinerary WHERE quote_id='1957';;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary  SET quote_id='1961', service_id='281', service_type='transfer', service_date='2023-06-15', sequence='4';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],DELETE FROM day_wise_quotation_description WHERE quote_id='1957';;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description  SET quote_id='1961', service_date='2023-06-15', description=NULL;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation  SET q_name='Family Tour', service='sightseeing', agent_id='21', create_date='2023-05-03 06:59:18', q_info='a%3A48%3A%7Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%222023%2F06%2F17%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A2%3A%2232%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271649%22%3Bs%3A4%3A%22name%22%3Bs%3A16%3A%22Dubai+Theme+park%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271649%22%3Bs%3A9%3A%22city_name%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A17%3A%22terms_n_condition%22%3BN%3Bs%3A16%3A%22tour_description%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A355%3A%22o+implement+capacity+control%2C+all+guests+will+be+required+to+make+a+reservation+for+their+visit+date+with+their+valid+tickets+beginning+90+days+prior+to+arrival+through+Hong+Kong+Disneyland+Resort+Park+Visit+Reservation+website.+Guests+with+reservations+must+present+valid+tickets+for+entry.+A+reservation+is+not+required+for+children+below+3+years+of+age%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A171%3A%22Enjoy+direct+entry+with+QR+code%0D%0AEnjoy+seasonal+events%2C+like+Christmas%2C+Halloween+and+celebrate+the+festivals%0D%0ATake+some+memorable+photos+with+the+Castle+of+Magical+Dreams%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%226+Hrs+15+Min%22%3Bs%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2282%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A2%3A%2232%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A15%3A%22Food+and+drinks%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222023-04-05+06%3A22%3A55%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22138%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%22AED%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2281%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A2%3A%2232%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222023-04-05+06%3A22%3A55%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A121%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1677821337_main_HKGTheme.jpeg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A121%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1677821337_main_HKGTheme.jpeg%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A6%3A%22216.00%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%3A6%3A%22216.00%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A2%3A%2232%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A9%3A%22date_from%22%3Bs%3A10%3A%222023-06-17%22%3Bs%3A7%3A%22date_to%22%3Bs%3A10%3A%222023-06-17%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271649%22%3Bs%3A4%3A%22name%22%3Bs%3A16%3A%22Dubai+Theme+park%22%3Bs%3A15%3A%22TermsNCondition%22%3Bs%3A19%3A%22Passport+or+ID+card%22%3Bs%3A16%3A%22tour_description%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A355%3A%22o+implement+capacity+control%2C+all+guests+will+be+required+to+make+a+reservation+for+their+visit+date+with+their+valid+tickets+beginning+90+days+prior+to+arrival+through+Hong+Kong+Disneyland+Resort+Park+Visit+Reservation+website.+Guests+with+reservations+must+present+valid+tickets+for+entry.+A+reservation+is+not+required+for+children+below+3+years+of+age%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A171%3A%22Enjoy+direct+entry+with+QR+code%0D%0AEnjoy+seasonal+events%2C+like+Christmas%2C+Halloween+and+celebrate+the+festivals%0D%0ATake+some+memorable+photos+with+the+Castle+of+Magical+Dreams%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%226+Hrs+15+Min%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271649%22%3Bs%3A9%3A%22city_name%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%222%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22138%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2281%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A2%3A%2232%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222023-04-05+06%3A22%3A55%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%2282%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A2%3A%2232%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A15%3A%22Food+and+drinks%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222023-04-05+06%3A22%3A55%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A7%3A%22to_date%22%3Bs%3A10%3A%222023-06-17%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%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%3A121%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1677821337_main_HKGTheme.jpeg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A121%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1677821337_main_HKGTheme.jpeg%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22actual_adult%22%3Bs%3A1%3A%222%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%222023-04-14%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A3%3A%22200%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%228%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%3A3%3A%22216%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%3A2%3A%2216%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%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%226+Hrs+15+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22N%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A0%3A%22%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%22AED%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%3A6%3A%22216.00%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%228%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A6%3A%22216.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%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%3A6%3A%22200.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22200.00%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A6%3A%22216.00%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%3A7%3A%221.00000%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A6%3A%22216.00%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%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%228%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2216.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.00%22%3B%7D%7D%7Ds%3A17%3A%22additional_markup%22%3Bs%3A1%3A%228%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%226+Hrs+15+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22N%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A0%3A%22%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%22AED%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%3A6%3A%22216.00%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%228%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A6%3A%22216.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%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%3A6%3A%22200.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22200.00%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A6%3A%22216.00%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%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%228%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2216.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.00%22%3B%7D%7D%7D', city_name='Dubai', hotel_id='32', additional_markup='8', cancelltion_policy='', supplier_cancellation_policy=NULL, per_night=NULL, total_price='216.00', room_type=NULL, room_rate=NULL, currency='AED', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by=NULL, modified_date='0000-00-00 00:00:00', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021198', service_date='2023-06-17 00:00:00', service_checkout_date='2023-06-17 00:00:00', city_code='71649', country_code='138', nationality='106', total_adult='2', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name='TestA TestL', salutation='Ms', first_name='TestA', last_name='TestL', email='ashwini.shetty@qtechsoftware.com', contact_no='91-12345566', enquiry_id='417', quotation_status='copied', sequence='5', 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%222023-04-14%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A3%3A%22200%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%228%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%3A3%3A%22216%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%3A2%3A%2216%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7D%7D%7D';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1962', q_name='Family Tour', service='sightseeing', agent_id='21', create_date='2023-05-03 06:59:18', q_info='a%3A48%3A%7Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%222023%2F06%2F17%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A2%3A%2232%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271649%22%3Bs%3A4%3A%22name%22%3Bs%3A16%3A%22Dubai+Theme+park%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271649%22%3Bs%3A9%3A%22city_name%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A17%3A%22terms_n_condition%22%3BN%3Bs%3A16%3A%22tour_description%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A355%3A%22o+implement+capacity+control%2C+all+guests+will+be+required+to+make+a+reservation+for+their+visit+date+with+their+valid+tickets+beginning+90+days+prior+to+arrival+through+Hong+Kong+Disneyland+Resort+Park+Visit+Reservation+website.+Guests+with+reservations+must+present+valid+tickets+for+entry.+A+reservation+is+not+required+for+children+below+3+years+of+age%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A171%3A%22Enjoy+direct+entry+with+QR+code%0D%0AEnjoy+seasonal+events%2C+like+Christmas%2C+Halloween+and+celebrate+the+festivals%0D%0ATake+some+memorable+photos+with+the+Castle+of+Magical+Dreams%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%226+Hrs+15+Min%22%3Bs%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2282%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A2%3A%2232%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A15%3A%22Food+and+drinks%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222023-04-05+06%3A22%3A55%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22138%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%22AED%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2281%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A2%3A%2232%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222023-04-05+06%3A22%3A55%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A121%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1677821337_main_HKGTheme.jpeg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A121%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1677821337_main_HKGTheme.jpeg%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A6%3A%22216.00%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%3A6%3A%22216.00%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A2%3A%2232%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A9%3A%22date_from%22%3Bs%3A10%3A%222023-06-17%22%3Bs%3A7%3A%22date_to%22%3Bs%3A10%3A%222023-06-17%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271649%22%3Bs%3A4%3A%22name%22%3Bs%3A16%3A%22Dubai+Theme+park%22%3Bs%3A15%3A%22TermsNCondition%22%3Bs%3A19%3A%22Passport+or+ID+card%22%3Bs%3A16%3A%22tour_description%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A355%3A%22o+implement+capacity+control%2C+all+guests+will+be+required+to+make+a+reservation+for+their+visit+date+with+their+valid+tickets+beginning+90+days+prior+to+arrival+through+Hong+Kong+Disneyland+Resort+Park+Visit+Reservation+website.+Guests+with+reservations+must+present+valid+tickets+for+entry.+A+reservation+is+not+required+for+children+below+3+years+of+age%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A171%3A%22Enjoy+direct+entry+with+QR+code%0D%0AEnjoy+seasonal+events%2C+like+Christmas%2C+Halloween+and+celebrate+the+festivals%0D%0ATake+some+memorable+photos+with+the+Castle+of+Magical+Dreams%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%226+Hrs+15+Min%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271649%22%3Bs%3A9%3A%22city_name%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%222%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22138%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A186%3A%22Enjoy+endless+fun+in+seven+magical+lands+and+experience+your+favorite+Disney+stories+just+as+you+remember+them+from+the+classic+Disney+films.+Here%27s+where+fairytales+really+do+come+true.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2281%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A2%3A%2232%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222023-04-05+06%3A22%3A55%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%2282%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A2%3A%2232%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A15%3A%22Food+and+drinks%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222023-04-05+06%3A22%3A55%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A7%3A%22to_date%22%3Bs%3A10%3A%222023-06-17%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%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%3A121%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1677821337_main_HKGTheme.jpeg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A121%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1677821337_main_HKGTheme.jpeg%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22actual_adult%22%3Bs%3A1%3A%222%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%222023-04-14%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A3%3A%22200%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%228%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%3A3%3A%22216%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%3A2%3A%2216%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%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%226+Hrs+15+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22N%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A0%3A%22%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%22AED%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%3A6%3A%22216.00%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%228%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A6%3A%22216.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%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%3A6%3A%22200.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22200.00%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A6%3A%22216.00%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%3A7%3A%221.00000%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A6%3A%22216.00%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%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%228%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2216.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.00%22%3B%7D%7D%7Ds%3A17%3A%22additional_markup%22%3Bs%3A1%3A%228%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%226+Hrs+15+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22N%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A0%3A%22%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A0%3A%22%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%22AED%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%3A6%3A%22216.00%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%228%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A6%3A%22216.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%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%3A6%3A%22200.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22200.00%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A6%3A%22216.00%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%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%228%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%2216.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.00%22%3B%7D%7D%7D', city_name='Dubai', hotel_id='32', additional_markup='8', cancelltion_policy='', supplier_cancellation_policy=NULL, per_night=NULL, total_price='216.00', room_type=NULL, room_rate=NULL, currency='AED', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2023-05-03 06:59:18', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021198', service_date='2023-06-17 00:00:00', service_checkout_date='2023-06-17 00:00:00', city_code='71649', country_code='138', nationality='106', total_adult='2', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name='TestA TestL', salutation='Ms', first_name='TestA', last_name='TestL', email='ashwini.shetty@qtechsoftware.com', contact_no='91-12345566', enquiry_id='417', quotation_status='edited', sequence='5', 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%222023-04-14%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A3%3A%22200%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%228%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%3A3%3A%22216%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%3A2%3A%2216%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7D%7D%7D';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],DELETE FROM day_wise_quotation_itinerary WHERE quote_id='1958';;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary  SET quote_id='1962', service_id='32', service_type='sightseeing', service_date='2023-06-17', sequence='5';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],DELETE FROM day_wise_quotation_description WHERE quote_id='1958';;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description  SET quote_id='1962', service_date='2023-06-17', description=NULL;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation  SET q_name='Family Tour', service='misc', agent_id='21', create_date='2023-05-03 06:59:18', q_info='a%3A20%3A%7Bs%3A4%3A%22Misc%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A38%3A%7Bs%3A15%3A%22misc_service_id%22%3Bs%3A1%3A%229%22%3Bs%3A12%3A%22misc_service%22%3Bs%3A18%3A%22Ferry+Ticket%28MISC%29%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22sub_service%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A6%3A%22Snehal%22%3Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2217%2F06%2F2023%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A9%3A%22city_name%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%222%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22138%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A9%3A%22child_age%22%3Ba%3A0%3A%7B%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2214%2F04%2F2023%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2287.037%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.87037%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2287.04%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%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7Ds%3A8%3A%22RateInfo%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A15%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22displayNightlyRate%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2287.04%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.87037%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2287.04%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A6%3A%22100.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A10%3A%22total_rate%22%3Bs%3A5%3A%2287.04%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A1%3A%220%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%3A20%3A%22per_infant_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%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.87037%22%3Bs%3A10%3A%22total_room%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22room_rate_per_night%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22total_night%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2287.04%22%3Bs%3A22%3A%22total_supplier_charges%22%3Bs%3A6%3A%22100.00%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22total_infant_rate%22%3Bs%3A1%3A%220%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%3A22%3A%22total_infant_agentrate%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%3B%7D%7Ds%3A6%3A%22userid%22%3Bs%3A2%3A%2221%22%3Bs%3A15%3A%22search_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%2217%2F06%2F2023%22%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A18%3A%22selected_city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22138%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22total_infant%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22child_age%22%3Ba%3A0%3A%7B%7Ds%3A14%3A%22agent_category%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A38%3A%7Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2217%2F06%2F2023%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22misc_service_id%22%3Bs%3A1%3A%229%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Ferry+Ticket%28MISC%29%22%3Bs%3A16%3A%22sub_service_name%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A9%3A%22city_name%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.87037%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A6%3A%22Snehal%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22138%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2287.04%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A14%3A%22per_child_rate%22%3Bi%3A0%3Bs%3A15%3A%22per_infant_rate%22%3Bi%3A0%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A20%3A%22per_infant_agentrate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A100%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A0%3Bs%3A17%3A%22total_infant_rate%22%3Bi%3A0%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A22%3A%22total_infant_agentrate%22%3Bi%3A0%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22additional_markup%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%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7D%7D%7D', city_name='Dubai', hotel_id='9', additional_markup='0', cancelltion_policy='', supplier_cancellation_policy=NULL, per_night=NULL, total_price='87.04', room_type=NULL, room_rate=NULL, currency='AED', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by=NULL, modified_date='0000-00-00 00:00:00', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021198', service_date='2023-06-17 00:00:00', service_checkout_date='2023-06-17 00:00:00', city_code='71649', country_code='138', nationality='106', total_adult='2', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name='TestA TestL', salutation='Ms', first_name='TestA', last_name='TestL', email='ashwini.shetty@qtechsoftware.com', contact_no='91-12345566', enquiry_id='417', quotation_status='copied', sequence='6', 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%2214%2F04%2F2023%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2287.037%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.87037%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2287.04%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%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7D%7D%7D';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1963', q_name='Family Tour', service='misc', agent_id='21', create_date='2023-05-03 06:59:18', q_info='a%3A20%3A%7Bs%3A4%3A%22Misc%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A38%3A%7Bs%3A15%3A%22misc_service_id%22%3Bs%3A1%3A%229%22%3Bs%3A12%3A%22misc_service%22%3Bs%3A18%3A%22Ferry+Ticket%28MISC%29%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22sub_service%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A6%3A%22Snehal%22%3Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2217%2F06%2F2023%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A9%3A%22city_name%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%222%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22138%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A9%3A%22child_age%22%3Ba%3A0%3A%7B%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2214%2F04%2F2023%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2287.037%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.87037%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2287.04%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%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7Ds%3A8%3A%22RateInfo%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A15%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22displayNightlyRate%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2287.04%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.87037%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2287.04%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A6%3A%22100.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A10%3A%22total_rate%22%3Bs%3A5%3A%2287.04%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A1%3A%220%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%3A20%3A%22per_infant_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%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.87037%22%3Bs%3A10%3A%22total_room%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22room_rate_per_night%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22total_night%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2287.04%22%3Bs%3A22%3A%22total_supplier_charges%22%3Bs%3A6%3A%22100.00%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22total_infant_rate%22%3Bs%3A1%3A%220%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%3A22%3A%22total_infant_agentrate%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%3B%7D%7Ds%3A6%3A%22userid%22%3Bs%3A2%3A%2221%22%3Bs%3A15%3A%22search_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%2217%2F06%2F2023%22%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A18%3A%22selected_city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22138%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22total_infant%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22child_age%22%3Ba%3A0%3A%7B%7Ds%3A14%3A%22agent_category%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A38%3A%7Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2217%2F06%2F2023%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22misc_service_id%22%3Bs%3A1%3A%229%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Ferry+Ticket%28MISC%29%22%3Bs%3A16%3A%22sub_service_name%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271649%22%3Bs%3A9%3A%22city_name%22%3Bs%3A5%3A%22Dubai%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.87037%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000212%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A6%3A%22Snehal%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22138%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2287.04%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22100.00%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A14%3A%22per_child_rate%22%3Bi%3A0%3Bs%3A15%3A%22per_infant_rate%22%3Bi%3A0%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A20%3A%22per_infant_agentrate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A100%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A0%3Bs%3A17%3A%22total_infant_rate%22%3Bi%3A0%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A22%3A%22total_infant_agentrate%22%3Bi%3A0%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22additional_markup%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%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7D%7D%7D', city_name='Dubai', hotel_id='9', additional_markup='0', cancelltion_policy='', supplier_cancellation_policy=NULL, per_night=NULL, total_price='87.04', room_type=NULL, room_rate=NULL, currency='AED', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2023-05-03 06:59:18', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021198', service_date='2023-06-17 00:00:00', service_checkout_date='2023-06-17 00:00:00', city_code='71649', country_code='138', nationality='106', total_adult='2', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name='TestA TestL', salutation='Ms', first_name='TestA', last_name='TestL', email='ashwini.shetty@qtechsoftware.com', contact_no='91-12345566', enquiry_id='417', quotation_status='edited', sequence='6', 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%2214%2F04%2F2023%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2287.037%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.87037%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2287.04%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%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22AED%22%3B%7D%7D%7D%7D';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],DELETE FROM day_wise_quotation_itinerary WHERE quote_id='1959';;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary  SET quote_id='1963', service_id='9', service_type='misc', service_date='2023-06-17', sequence='6';
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],DELETE FROM day_wise_quotation_description WHERE quote_id='1959';;
[05/03/2023 06:59:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description  SET quote_id='1963', service_date='2023-06-17', description=NULL;
