[09/25/2020 05:15:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1601010912','203.192.209.187');
[09/25/2020 05:22:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/new_offline_sightseeing_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1601011329','203.192.209.187');
[09/25/2020 05:37:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_vehicle_type.php],UPDATE vehicle_type SET vehicle_desc='VAN 6 SEATER',pax_capacity ='6',max_lugguage ='3' WHERE id='4';
[09/25/2020 05:37:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_vehicle_type.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-25 05:37:52',`log_type`= 'Vehicle Type',`sql_query`= 'UPDATE vehicle_type SET vehicle_desc=\&#039;VAN 6 SEATER\&#039;,pax_capacity =\&#039;6\&#039;,max_lugguage =\&#039;3\&#039; WHERE id=\&#039;4\&#039;',`log_description`= 'Vehicle Type \&#039;VAN 6 SEATER\&#039; Edited By User tfg From Ip : 203.192.209.187 on 25-09-2020 05:37:52',`ip`= '203.192.209.187';
[09/25/2020 05:42:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_vehicle_type.php],UPDATE vehicle_type SET vehicle_desc='VAN 4 SEATER',pax_capacity ='4',max_lugguage ='2' WHERE id='4';
[09/25/2020 05:42:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_vehicle_type.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-25 05:42:47',`log_type`= 'Vehicle Type',`sql_query`= 'UPDATE vehicle_type SET vehicle_desc=\&#039;VAN 4 SEATER\&#039;,pax_capacity =\&#039;4\&#039;,max_lugguage =\&#039;2\&#039; WHERE id=\&#039;4\&#039;',`log_description`= 'Vehicle Type \&#039;VAN 4 SEATER\&#039; Edited By User tfg From Ip : 203.192.209.187 on 25-09-2020 05:42:47',`ip`= '203.192.209.187';
[09/25/2020 05:43:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 398;
[09/25/2020 05:43:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1839', q_name='', service='sightseeing', agent_id='22', create_date='2020-09-25 05:43:12', q_info='a%3A48%3A%7Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%222020%2F09%2F29%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A17%3A%22terms_n_condition%22%3BN%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A10%3A%22160249.360%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%3A10%3A%22160249.360%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A9%3A%22date_from%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A7%3A%22date_to%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A15%3A%22TermsNCondition%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%226%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A7%3A%22to_date%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22selected_language%22%3Bs%3A1%3A%22E%22%3Bs%3A10%3A%22child_ages%22%3Ba%3A0%3A%7B%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22actual_adult%22%3Bs%3A1%3A%226%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%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%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%222020-09-29%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%222000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22120000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A9%3A%22160249.36%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%3A9%3A%22670.82272%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A8%3A%22TourTrip%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A7%3A%22private%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A1%3A%224%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22VAN+6+SEATER%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A1%3A%224%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%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A10%3A%22160249.360%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A4%3A%222000%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%222000%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A8%3A%2220902.09%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A8%3A%2219347.27%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2216.12%22%3B%7D%7D%7Ds%3A17%3A%22additional_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22RateBreakup%22%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A7%3A%22private%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A1%3A%224%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22VAN+6+SEATER%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A1%3A%224%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%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A10%3A%22160249.360%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A4%3A%222000%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%222000%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A8%3A%2220902.09%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A8%3A%2219347.27%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2216.12%22%3B%7D%7D%7D', city_name='Colombo', hotel_id='2', additional_markup='34', cancelltion_policy='', per_night=NULL, total_price='160249.36', room_type=NULL, room_rate=NULL, currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-09-25 05:43:12', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002224', service_date='2020-09-29 00:00:00', service_checkout_date='2020-09-29 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='6', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name=' ', salutation='Mr', first_name='', last_name='', email='', contact_no='', enquiry_id='398', 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%222020-09-29%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%222000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22120000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A9%3A%22160249.36%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%3A9%3A%22670.82272%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D';
[09/25/2020 05:43:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'QTECHCA002224',modified_by = 'tfg',modified_date = '2020-09-25 05:43:12',currency ='INR',service_date='2020/09/29',service_checkout_date='2020/09/29',city_code ='71100',country_code ='132',nationality ='106',total_adult ='6',total_child ='0',child_age ='a%3A0%3A%7B%7D',sequence='3',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%222000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22120000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A9%3A%22160249.36%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%3A9%3A%22670.82272%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D',agent_id = '22',q_info = 'a%3A48%3A%7Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%222020%2F09%2F29%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A17%3A%22terms_n_condition%22%3BN%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A13%3A%22pick_up_point%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22drop_off_point%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22slot_type%22%3Bs%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A10%3A%22160249.360%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%3A10%3A%22160249.360%22%3Bs%3A13%3A%22SightseeingId%22%3Bs%3A1%3A%222%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A9%3A%22date_from%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A7%3A%22date_to%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A16%3A%22ResponsecityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A4%3A%22name%22%3Bs%3A18%3A%22Colombo+by+tuk+tuk%22%3Bs%3A15%3A%22TermsNCondition%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22tour_description%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A11%3A%22restriction%22%3Bs%3A76%3A%22This+experience+is+great+for+children%2C+and+not+recommended+for+kids+under+5.%22%3Bs%3A15%3A%22tour_highlights%22%3Bs%3A538%3A%22Colombo+is+a+vibrant%2C+compact+and+interesting+city%2C+rich+in+culture%2C+history+and+heritage.+There+is+so+much+to+see+and+do%21+The+city+traffic%2C+however%2C+can+be+a+little+unruly+at+times+and+the+best+way+to+get+around+the+chaos+is+by+taking+a+tuk+tuk.+The+three-wheeled+taxis%2C+fondly+known+by+locals+as+%E2%80%98tuk-tuks%E2%80%99+for+the+sound+of+their+sputtering+little+engines%2C+are+notoriously+fast%2C+easy+to+park%2C+and+can+maneuver+through+the+tiny+streets+of+this+compact+city+with+ease%2C+making+it+a+great+way+to+experience+Colombo%E2%80%99s+disorderly+charm.%22%3Bs%3A8%3A%22duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A4%3A%22city%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%226%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A16%3A%22localsightseeing%22%3Bs%3A11%3A%22TourSummary%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A485%3A%22Colombo+by+tuk+tuk+is+about+offering+travelers+the+exhilarating+experience+of+riding+a+tuk+tuk+within+a+safe+environment+assisted+by+trained%2C+English-speaking+drivers.+It+is+easily%2C+the+most+fun+way+to+have+your+own+local+friend+and+guide+to+show+you+around+with+their+own+stories+and+inherent+knowledge+of+the+city.+As+part+of+the+standard+itinerary%2C+a+list+of+%E2%80%98non-touristy%E2%80%99%2C+rather+rare+and+quirky+recommendations+will+give+you+a+current+and+honest+sneak-peek+into+Colombo+life.%22%3Bs%3A13%3A%22tourInclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2275%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Includes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A101%3A%22A+guided+tour+of+Colombo%2C+all+entrance+tickets%2C+bottled+water+and+refreshments%2C+transport+by+tuk+tuk.%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A13%3A%22tourExclusion%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A6%3A%7Bs%3A2%3A%22id%22%3Bs%3A2%3A%2276%22%3Bs%3A7%3A%22tour_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22highlight_type%22%3Bs%3A8%3A%22Excludes%22%3Bs%3A9%3A%22highlight%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22create_date%22%3Bs%3A19%3A%222020-09-19+02%3A12%3A18%22%3Bs%3A6%3A%22status%22%3Bs%3A1%3A%22A%22%3B%7D%7Ds%3A7%3A%22to_date%22%3Bs%3A10%3A%222020-09-29%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%226%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22selected_language%22%3Bs%3A1%3A%22E%22%3Bs%3A10%3A%22child_ages%22%3Ba%3A0%3A%7B%7Ds%3A12%3A%22thumbNailUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A12%3A%22FullImageUrl%22%3Bs%3A122%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fuploads%2Ftours_images%2F1526106909_main_images_%283%29.jpg%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22actual_adult%22%3Bs%3A1%3A%226%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%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%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%222020-09-29%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A4%3A%222000%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%22120000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A9%3A%22160249.36%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%3A9%3A%22670.82272%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A8%3A%22TourTrip%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A7%3A%22private%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A1%3A%224%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22VAN+4+SEATER%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A1%3A%224%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%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A10%3A%22160249.360%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A4%3A%222000%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%222000%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A8%3A%2220902.09%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A8%3A%2219347.27%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2216.12%22%3B%7D%7D%7Ds%3A17%3A%22additional_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22RateBreakup%22%3Ba%3A14%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22Duration%22%3Bs%3A12%3A%222+Hrs+30+Min%22%3Bs%3A17%3A%22transfer_included%22%3Bs%3A1%3A%22Y%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A7%3A%22private%22%3Bs%3A10%3A%22vehicle_id%22%3Bs%3A1%3A%224%22%3Bs%3A12%3A%22vehicle_name%22%3Bs%3A12%3A%22VAN+4+SEATER%22%3Bs%3A17%3A%22vehicle_type_code%22%3Bs%3A1%3A%224%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%3A12%3A%229%3A00%5E%3A%5E11%3A30%22%3Bs%3A9%3A%22from_slot%22%3Bs%3A4%3A%229%3A00%22%3Bs%3A7%3A%22to_slot%22%3Bs%3A5%3A%2211%3A30%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A13%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A10%3A%22160249.360%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2260%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A4%3A%222000%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%222000%22%3Bs%3A9%3A%22tour_rate%22%3Bs%3A10%3A%22160249.360%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A2%3A%2215%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A8%3A%2220902.09%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A9%3A%2233.541136%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A8%3A%2219347.27%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2216.12%22%3B%7D%7D%7D',service = 'sightseeing',hotel_id = '2',additional_markup = '33.541136',city_name ='Colombo',leader_name =' ',salutation ='Mr',first_name ='',last_name ='',quotation_type ='back_end',enquiry_id ='398',total_price ='160249.360' WHERE q_id='1839';
[09/25/2020 05:43:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002224' AND quotation_status!='booked';
