[10/21/2020 04:47:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 403;
[10/21/2020 04:47:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1884', q_name='JAMES BURMBY - Option 02 (21 D , EAST , RDT)', service='transfer', agent_id='22', create_date='2020-10-21 04:47:20', q_info='a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222020-11-10%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_201_0%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%223.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%223+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%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%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%2293fd3da18240c3e2274f0150df869676%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%225%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+6+SEATER%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%222%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%22MYR%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2290964%22%3Bs%3A9%3A%22language1%22%3Bs%3A1%3A%22E%22%3Bs%3A9%3A%22language2%22%3Bs%3A1%3A%22E%22%3Bs%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%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%222%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A18%3A%22selected_child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A17%3A%22additional_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A56%3A%22The+Steuart+by+Citrus%2C+Hospital+Lane%2C+Colombo%2C+Sri+Lanka%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A74%3A%22Airport+Expressway%2C+Colombo+-+Katunayake+Expressway%2C+Katunayake%2C+Sri+Lanka%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22A%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22A%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A7%3A%2230.0+km%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A1%3A%220%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%2290964%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A4%3A%22Ella%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22201%22%3Bs%3A18%3A%22description_number%22%3Bi%3A0%3Bs%3A18%3A%22total_native_price%22%3Bs%3A6%3A%22550.00%22%3Bs%3A16%3A%22user_description%22%3Bs%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%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%3A4%3A%225.47%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.87%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%222.44%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%222020-09-09%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7Ds%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bi%3A0%3Bs%3A5%3A%2241.91%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A4%3A%22Ella%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2290964%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%223.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%223+hr+0+min+%22%3B%7Ds%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A14%3A%22originalsource%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22Vehicle%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%2293fd3da18240c3e2274f0150df869676%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%225%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+6+SEATER%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%222%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%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Katunayake', hotel_id='201', additional_markup='18', cancelltion_policy='', per_night=NULL, total_price='41.91', room_type=NULL, room_rate=NULL, currency='MYR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-10-21 04:47:20', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002227', service_date='2020-11-10 00:00:00', service_checkout_date='2020-11-10 00:00:00', city_code='82246', country_code='132', nationality='106', total_adult='2', total_child='2', child_age='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7D', leader_name='Shiba Test', salutation='Ms', first_name='Shiba', last_name='Test', email='ankita.rao@qtechsoftware.com', contact_no='7666065659', enquiry_id='403', quotation_status='edited', sequence='2', rate_description_field='a%3A2%3A%7Bs%3A12%3A%22optionalcost%22%3Ba%3A1%3A%7Bi%3A1%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A16%3A%22optional_cost_id%22%3Bi%3A1%3Bs%3A18%3A%22optional_cost_name%22%3Bs%3A10%3A%22Driver+fee%22%3Bs%3A18%3A%22optional_cost_rate%22%3Bs%3A3%3A%22500%22%3B%7D%7D%7Ds%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-09%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7D%7D%7D';
[10/21/2020 04:47:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = 'JAMES BURMBY - Option 02 (21 D , EAST , RDT)',email='ankita.rao@qtechsoftware.com',contact_no='7666065659',unique_id = 'QTECHCA002227',modified_by = 'tfg',modified_date = '2020-10-21 04:47:20',currency ='MYR',service_date='2020-11-10',service_checkout_date='2020-11-10',sequence='2',cancelltion_policy='',rate_description_field='a%3A2%3A%7Bs%3A12%3A%22optionalcost%22%3Ba%3A1%3A%7Bi%3A1%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A16%3A%22optional_cost_id%22%3Bi%3A1%3Bs%3A18%3A%22optional_cost_name%22%3Bs%3A10%3A%22Driver+fee%22%3Bs%3A18%3A%22optional_cost_rate%22%3Bs%3A3%3A%22500%22%3B%7D%7D%7Ds%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-11-10%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7D%7D%7D',agent_id = '22',q_info = 'a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222020-11-10%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_201_0%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2221.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2221+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%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%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22a3c4665db88b4adfe33393e97a8142ed%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+4+SEATER%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%222%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%22MYR%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2290964%22%3Bs%3A9%3A%22language1%22%3Bs%3A1%3A%22E%22%3Bs%3A9%3A%22language2%22%3Bs%3A1%3A%22E%22%3Bs%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%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%222%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A18%3A%22selected_child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A17%3A%22additional_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A56%3A%22The+Steuart+by+Citrus%2C+Hospital+Lane%2C+Colombo%2C+Sri+Lanka%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A74%3A%22Airport+Expressway%2C+Colombo+-+Katunayake+Expressway%2C+Katunayake%2C+Sri+Lanka%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22A%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22A%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A7%3A%2230.0+km%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A1%3A%220%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%2290964%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A4%3A%22Ella%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22201%22%3Bs%3A18%3A%22description_number%22%3Bi%3A0%3Bs%3A18%3A%22total_native_price%22%3Bs%3A6%3A%22550.00%22%3Bs%3A16%3A%22user_description%22%3Bs%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%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%3A4%3A%225.47%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.87%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%222.44%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%222020-11-10%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7Ds%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bi%3A0%3Bs%3A5%3A%2241.91%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A4%3A%22Ella%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2290964%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2221.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2221+hr+0+min+%22%3B%7Ds%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A14%3A%22originalsource%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22Vehicle%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22a3c4665db88b4adfe33393e97a8142ed%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+4+SEATER%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%222%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%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'transfer',hotel_id = '201',additional_markup = '17.810760667903523',city_name ='Katunayake',city_code ='82246',country_code ='132',nationality ='106',total_adult ='2',total_child ='2',child_age ='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7D',leader_name ='Shiba Test',salutation ='Ms',first_name ='Shiba',last_name ='Test',quotation_type ='back_end',enquiry_id ='403',total_price ='41.91' WHERE q_id='1884';
[10/21/2020 04:47:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1884', service_id='201', service_type='transfer',service_date='2020-11-10', sequence='2';
[10/21/2020 04:47:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1884', service_date='2020-11-10';
[10/21/2020 04:47:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002227' AND quotation_status!='booked';
[10/21/2020 04:47:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 403;
[10/21/2020 04:47:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1884', q_name='JAMES BURMBY - Option 02 (21 D , EAST , RDT)', service='transfer', agent_id='22', create_date='2020-10-21 04:47:45', q_info='a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222020-11-10%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_201_0%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2221.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2221+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%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%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22a3c4665db88b4adfe33393e97a8142ed%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+4+SEATER%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%222%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%22MYR%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2290964%22%3Bs%3A9%3A%22language1%22%3Bs%3A1%3A%22E%22%3Bs%3A9%3A%22language2%22%3Bs%3A1%3A%22E%22%3Bs%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%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%222%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A18%3A%22selected_child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A17%3A%22additional_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A56%3A%22The+Steuart+by+Citrus%2C+Hospital+Lane%2C+Colombo%2C+Sri+Lanka%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A74%3A%22Airport+Expressway%2C+Colombo+-+Katunayake+Expressway%2C+Katunayake%2C+Sri+Lanka%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22A%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22A%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A7%3A%2230.0+km%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A1%3A%220%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%2290964%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A4%3A%22Ella%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22201%22%3Bs%3A18%3A%22description_number%22%3Bi%3A0%3Bs%3A18%3A%22total_native_price%22%3Bs%3A6%3A%22550.00%22%3Bs%3A16%3A%22user_description%22%3Bs%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%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%3A4%3A%225.47%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.87%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%222.44%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%222020-11-10%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7Ds%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bi%3A0%3Bs%3A5%3A%2241.91%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A4%3A%22Ella%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2290964%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2221.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2221+hr+0+min+%22%3B%7Ds%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A14%3A%22originalsource%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22Vehicle%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22a3c4665db88b4adfe33393e97a8142ed%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+4+SEATER%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%222%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%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Katunayake', hotel_id='201', additional_markup='18', cancelltion_policy='', per_night=NULL, total_price='41.91', room_type=NULL, room_rate=NULL, currency='MYR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-10-21 04:47:45', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002227', service_date='2020-11-10 00:00:00', service_checkout_date='2020-11-10 00:00:00', city_code='82246', country_code='132', nationality='106', total_adult='2', total_child='2', child_age='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7D', leader_name='Shiba Test', salutation='Ms', first_name='Shiba', last_name='Test', email='ankita.rao@qtechsoftware.com', contact_no='7666065659', enquiry_id='403', quotation_status='edited', sequence='2', rate_description_field='a%3A2%3A%7Bs%3A12%3A%22optionalcost%22%3Ba%3A1%3A%7Bi%3A1%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A16%3A%22optional_cost_id%22%3Bi%3A1%3Bs%3A18%3A%22optional_cost_name%22%3Bs%3A10%3A%22Driver+fee%22%3Bs%3A18%3A%22optional_cost_rate%22%3Bs%3A3%3A%22500%22%3B%7D%7D%7Ds%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-11-10%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7D%7D%7D';
[10/21/2020 04:47:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = 'JAMES BURMBY - Option 02 (21 D , EAST , RDT)',email='ankita.rao@qtechsoftware.com',contact_no='7666065659',unique_id = 'QTECHCA002227',modified_by = 'tfg',modified_date = '2020-10-21 04:47:45',currency ='MYR',service_date='2020-11-10',service_checkout_date='2020-11-10',sequence='2',cancelltion_policy='',rate_description_field='a%3A2%3A%7Bs%3A12%3A%22optionalcost%22%3Ba%3A1%3A%7Bi%3A1%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A16%3A%22optional_cost_id%22%3Bi%3A1%3Bs%3A18%3A%22optional_cost_name%22%3Bs%3A10%3A%22Driver+fee%22%3Bs%3A18%3A%22optional_cost_rate%22%3Bs%3A3%3A%22500%22%3B%7D%7D%7Ds%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-11-10%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7D%7D%7D',agent_id = '22',q_info = 'a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222020-11-10%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_201_0%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2221.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2221+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%228.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%228+hr+0+min+%22%3B%7Ds%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%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%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22a3c4665db88b4adfe33393e97a8142ed%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+4+SEATER%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%222%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%22MYR%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2290964%22%3Bs%3A9%3A%22language1%22%3Bs%3A1%3A%22E%22%3Bs%3A9%3A%22language2%22%3Bs%3A1%3A%22E%22%3Bs%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%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%222%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A18%3A%22selected_child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A17%3A%22additional_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A56%3A%22The+Steuart+by+Citrus%2C+Hospital+Lane%2C+Colombo%2C+Sri+Lanka%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A74%3A%22Airport+Expressway%2C+Colombo+-+Katunayake+Expressway%2C+Katunayake%2C+Sri+Lanka%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22A%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22A%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A7%3A%2230.0+km%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A1%3A%220%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%2290964%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A4%3A%22Ella%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22201%22%3Bs%3A18%3A%22description_number%22%3Bi%3A0%3Bs%3A18%3A%22total_native_price%22%3Bs%3A6%3A%22550.00%22%3Bs%3A16%3A%22user_description%22%3Bs%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%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%3A4%3A%225.47%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.87%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%222.44%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%222020-11-10%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7Ds%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bi%3A0%3Bs%3A5%3A%2241.91%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A4%3A%22Ella%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2290964%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2221.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2221+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%228.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%228+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A14%3A%22originalsource%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22Vehicle%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22a3c4665db88b4adfe33393e97a8142ed%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+4+SEATER%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%222%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%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'transfer',hotel_id = '201',additional_markup = '17.810760667903523',city_name ='Katunayake',city_code ='82246',country_code ='132',nationality ='106',total_adult ='2',total_child ='2',child_age ='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7D',leader_name ='Shiba Test',salutation ='Ms',first_name ='Shiba',last_name ='Test',quotation_type ='back_end',enquiry_id ='403',total_price ='41.91' WHERE q_id='1884';
[10/21/2020 04:47:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002227' AND quotation_status!='booked';
[10/21/2020 04:47:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 403;
[10/21/2020 04:47:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1884', q_name='JAMES BURMBY - Option 02 (21 D , EAST , RDT)', service='transfer', agent_id='22', create_date='2020-10-21 04:47:51', q_info='a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222020-11-10%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_201_0%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2221.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2221+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%228.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%228+hr+0+min+%22%3B%7Ds%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%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%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22a3c4665db88b4adfe33393e97a8142ed%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+4+SEATER%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%222%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%22MYR%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2290964%22%3Bs%3A9%3A%22language1%22%3Bs%3A1%3A%22E%22%3Bs%3A9%3A%22language2%22%3Bs%3A1%3A%22E%22%3Bs%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%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%222%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A18%3A%22selected_child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A17%3A%22additional_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A56%3A%22The+Steuart+by+Citrus%2C+Hospital+Lane%2C+Colombo%2C+Sri+Lanka%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A74%3A%22Airport+Expressway%2C+Colombo+-+Katunayake+Expressway%2C+Katunayake%2C+Sri+Lanka%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22A%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22A%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A7%3A%2230.0+km%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A1%3A%220%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%2290964%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A4%3A%22Ella%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22201%22%3Bs%3A18%3A%22description_number%22%3Bi%3A0%3Bs%3A18%3A%22total_native_price%22%3Bs%3A6%3A%22550.00%22%3Bs%3A16%3A%22user_description%22%3Bs%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%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%3A4%3A%225.47%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.87%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%222.44%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%222020-11-10%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7Ds%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bi%3A0%3Bs%3A5%3A%2241.91%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A4%3A%22Ella%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2290964%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2221.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2221+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%228.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%228+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A14%3A%22originalsource%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22Vehicle%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22a3c4665db88b4adfe33393e97a8142ed%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+4+SEATER%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%222%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%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Katunayake', hotel_id='201', additional_markup='18', cancelltion_policy='', per_night=NULL, total_price='41.91', room_type=NULL, room_rate=NULL, currency='MYR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-10-21 04:47:51', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002227', service_date='2020-11-10 00:00:00', service_checkout_date='2020-11-10 00:00:00', city_code='82246', country_code='132', nationality='106', total_adult='2', total_child='2', child_age='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7D', leader_name='Shiba Test', salutation='Ms', first_name='Shiba', last_name='Test', email='ankita.rao@qtechsoftware.com', contact_no='7666065659', enquiry_id='403', quotation_status='edited', sequence='2', rate_description_field='a%3A2%3A%7Bs%3A12%3A%22optionalcost%22%3Ba%3A1%3A%7Bi%3A1%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A16%3A%22optional_cost_id%22%3Bi%3A1%3Bs%3A18%3A%22optional_cost_name%22%3Bs%3A10%3A%22Driver+fee%22%3Bs%3A18%3A%22optional_cost_rate%22%3Bs%3A3%3A%22500%22%3B%7D%7D%7Ds%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-11-10%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7D%7D%7D';
[10/21/2020 04:47:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = 'JAMES BURMBY - Option 02 (21 D , EAST , RDT)',email='ankita.rao@qtechsoftware.com',contact_no='7666065659',unique_id = 'QTECHCA002227',modified_by = 'tfg',modified_date = '2020-10-21 04:47:51',currency ='MYR',service_date='2020-11-10',service_checkout_date='2020-11-10',sequence='2',cancelltion_policy='',rate_description_field='a%3A2%3A%7Bs%3A12%3A%22optionalcost%22%3Ba%3A1%3A%7Bi%3A1%3Ba%3A1%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A16%3A%22optional_cost_id%22%3Bi%3A1%3Bs%3A18%3A%22optional_cost_name%22%3Bs%3A10%3A%22Driver+fee%22%3Bs%3A18%3A%22optional_cost_rate%22%3Bs%3A3%3A%22500%22%3B%7D%7D%7Ds%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-11-10%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7D%7D%7D',agent_id = '22',q_info = 'a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222020-11-10%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_201_0%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2221.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2221+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%228.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%228+hr+0+min+%22%3B%7Ds%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%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%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22a3c4665db88b4adfe33393e97a8142ed%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+4+SEATER%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%222%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%22MYR%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2290964%22%3Bs%3A9%3A%22language1%22%3Bs%3A1%3A%22E%22%3Bs%3A9%3A%22language2%22%3Bs%3A1%3A%22E%22%3Bs%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%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%222%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A18%3A%22selected_child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7Ds%3A17%3A%22additional_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A56%3A%22The+Steuart+by+Citrus%2C+Hospital+Lane%2C+Colombo%2C+Sri+Lanka%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A74%3A%22Airport+Expressway%2C+Colombo+-+Katunayake+Expressway%2C+Katunayake%2C+Sri+Lanka%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22A%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22A%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A7%3A%2230.0+km%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A1%3A%220%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%2290964%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A4%3A%22Ella%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22201%22%3Bs%3A18%3A%22description_number%22%3Bi%3A0%3Bs%3A18%3A%22total_native_price%22%3Bs%3A6%3A%22550.00%22%3Bs%3A16%3A%22user_description%22%3Bs%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%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%3A4%3A%225.47%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.87%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%222.44%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%222020-11-10%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A6%3A%2235.574%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2241.91%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%3A15%3A%2297.959183673469%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22MYR%22%3B%7D%7Ds%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A18%3A%2217.810760667903523%22%3Bi%3A0%3Bs%3A5%3A%2241.91%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22201%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A4%3A%22city%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2282246%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A4%3A%22Ella%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2290964%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2210.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2210+hr+0+min+%22%3B%7Ds%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A4%3A%2221.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%2221+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%228.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%228+hr+0+min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A14%3A%22originalsource%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22Vehicle%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%22a3c4665db88b4adfe33393e97a8142ed%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22MYR%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%3A5%3A%2241.91%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A6%3A%22550.00%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A3%3A%220.5%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A1%3A%224%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A1%3A%224%22%3Bs%3A8%3A%22_content%22%3Bs%3A12%3A%22VAN+4+SEATER%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%222%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%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A5%3A%2241.91%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'transfer',hotel_id = '201',additional_markup = '17.810760667903523',city_name ='Katunayake',city_code ='82246',country_code ='132',nationality ='106',total_adult ='2',total_child ='2',child_age ='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3Bi%3A1%3Bs%3A1%3A%229%22%3B%7D',leader_name ='Shiba Test',salutation ='Ms',first_name ='Shiba',last_name ='Test',quotation_type ='back_end',enquiry_id ='403',total_price ='41.91' WHERE q_id='1884';
[10/21/2020 04:47:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002227' AND quotation_status!='booked';
[10/21/2020 04:47:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET quotation_status='responded' WHERE unique_id IN ('QTECHCA002227') AND agent_id='22' AND quotation_status!='booked';
[10/21/2020 04:48:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_request_logs SET quotation_id='QTECHCA002227', request_detail='a%3A25%3A%7Bs%3A6%3A%22action%22%3Bs%3A22%3A%22insertQuotationService%22%3Bs%3A14%3A%22bookingSession%22%3Bs%3A32%3A%22778e676d774e232f92680756793d379f%22%3Bs%3A17%3A%22agent_suggest_box%22%3Bs%3A41%3A%22Qtech+Ankita+%5BCD0022-Nilesh%5D+%5BNilesh-Rao%5D%22%3Bs%3A12%3A%22search_agent%22%3Bs%3A2%3A%2222%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A23%3A%22total_quotation_to_book%22%3Bs%3A1%3A%221%22%3Bs%3A37%3A%22quotation_booking_unique_session_code%22%3Bs%3A32%3A%22778e676d774e232f92680756793d379f%22%3Bs%3A14%3A%22quotation_name%22%3Bs%3A44%3A%22JAMES+BURMBY+-+Option+02+%2821+D+%2C+EAST+%2C+RDT%29%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A13%3A%22QTECHCA002227%22%3Bs%3A11%3A%22ServiceDate%22%3Bs%3A10%3A%2210-11-2020%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A11%3A%22selCurrency%22%3Bs%3A3%3A%22MYR%22%3Bs%3A15%3A%22sel_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A13%3A%22reservationId%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22sel_transfer_quotation%22%3Bs%3A4%3A%221884%22%3Bs%3A10%3A%22salutation%22%3Bs%3A2%3A%22Ms%22%3Bs%3A10%3A%22first_name%22%3Bs%3A5%3A%22Shiba%22%3Bs%3A9%3A%22last_name%22%3Bs%3A4%3A%22Test%22%3Bs%3A18%3A%22countryOfResidence%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22BookingNotes%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22customerAddress%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22bookquotation%22%3Ba%3A1%3A%7Bs%3A8%3A%22transfer%22%3Ba%3A1%3A%7Bs%3A10%3A%2210-11-2020%22%3Ba%3A1%3A%7Bi%3A201%3Ba%3A1%3A%7Bi%3A0%3Ba%3A44%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A3%3A%22201%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221884%22%3Bs%3A10%3A%22service_id%22%3Bs%3A3%3A%22201%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2282246%22%3Bs%3A9%3A%22city_name%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A10%3A%22country_id%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A14%3A%22nationality_id%22%3Bs%3A3%3A%22106%22%3Bs%3A11%3A%22nationality%22%3Bs%3A6%3A%22Indian%22%3Bs%3A9%3A%22child_age%22%3Bs%3A23%3A%22%255B%25222%2522%252C%25229%2522%255D%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A1%3A%224%22%3Bs%3A4%3A%22type%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22A%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22A%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A56%3A%22The+Steuart+by+Citrus%2C+Hospital+Lane%2C+Colombo%2C+Sri+Lanka%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A74%3A%22Airport+Expressway%2C+Colombo+-+Katunayake+Expressway%2C+Katunayake%2C+Sri+Lanka%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A7%3A%2230.0+km%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22transfer_duration%22%3Bs%3A12%3A%2210+hr+0+min+%22%3Bs%3A16%3A%22vehicle_capacity%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A110%3A%22Unregistered%2Bsup%2Band%2Btransfer%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253Ecustomer%253C%252Fspan%253E%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A338%3A%22Unregistered%2Bsup%2Band%2B%253Cspan%2Bstyle%253D%2522color%253A%2Brgb%2528255%252C%2B0%252C%2B0%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522background-color%253A%2Brgb%2528255%252C%2B255%252C%2B255%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522text-decoration%253A%2Bunderline%253B%2522%253Etransfer%253C%252Fspan%253E%253C%252Fspan%253E%253C%252Fspan%253E%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253ESupplier%253C%252Fspan%253E%22%3Bs%3A12%3A%22service_name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A17%3A%22vehicle_type_name%22%3Bs%3A12%3A%22VAN+4+SEATER%22%3Bs%3A13%3A%22transfer_type%22%3Bs%3A12%3A%22Privateperkm%22%3Bs%3A11%3A%22serviceDate%22%3Bs%3A10%3A%2210-11-2020%22%3Bs%3A11%3A%22NoOfService%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%222%22%3Bs%3A19%3A%22pickup_time_airport%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A2%3A%2221%22%3Bs%3A11%3A%22Time_Minute%22%3Bs%3A2%3A%2200%22%3B%7Ds%3A20%3A%22dropoff_time_airport%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A2%3A%2208%22%3Bs%3A11%3A%22Time_Minute%22%3Bs%3A2%3A%2200%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A5%3A%22Shiba%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Test%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22550%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A5%3A%2241.91%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%222%22%3B%7D%7D%7D%7D%7Ds%3A19%3A%22total_package_adult%22%3Bs%3A1%3A%222%22%3Bs%3A19%3A%22total_package_child%22%3Bs%3A1%3A%222%22%3Bs%3A19%3A%22total_selling_price%22%3Bs%3A5%3A%2241.91%22%3B%7D', create_date='2020-10-21 04:48:27';
[10/21/2020 04:48:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603255707','43.250.210.76');
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO bookings set reservation_id = '1820' ,agent_id = '22' ,confirmation_number = '' ,city_id = 'Katunayake' ,country_id = '132' ,nationality = 'Indian' ,display_room_rate = '41.91' ,native_discount = '' ,display_discount = '' ,display_currency_code = 'MYR' ,native_room_rate = '550' ,consultant_id = 'tfg' ,backoffice_user = 'tfg' ,sales_manager_id = '' ,native_currency_code = 'INR' ,cancellation_policy = '' ,supplier_cancellation_policy = '' ,current_status = 'confirmed' ,booking_status= '1',create_date = '2020-10-21 04:48:28' ,status_date = '2020-10-21 04:48:28' ,source_type = 'localtransfer' ,comment_contract = '' ,booking_type= 'offline',booking_branch_id='1' ,country_of_residence='132' ,itenirary_id='2' ,sequence='2' ,email_id = 'ankita.rao@qtechsoftware.com' ,expiration_date= '2020-10-20 18:30:00',native_rate = '' ,display_rate = '' ,applied_multiplier = '0.06468' ,applied_markup = '17.810760667903523' ,agent_markup = '17.810760667903523' ,basecurrency_multiplier = '0.23694' ,basecurrency_multiplier_native = '0.01533' ,check_out_date = '2020-11-10' ,service_date = '2020-11-10' ,service_type_detail = 'BIA-Ella Air Transfer' ,agent_currency_multiplier = '0.23694' ,supplier_profile_id = '6' ,created_by = 'tfg' ,leader_title = 'Ms' ,leader_first_name = 'Shiba' ,leader_last_name = 'Test' ,leader_phone = '7666065659' ,special_comment= 'Unregistered sup and transfer for &lt;br&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;customer&lt;/span&gt;',special_remark= 'Unregistered sup and &lt;span style=&quot;color: rgb(255, 0, 0);&quot;&gt;&lt;span style=&quot;background-color: rgb(255, 255, 255);&quot;&gt;&lt;span style=&quot;text-decoration: underline;&quot;&gt;transfer&lt;/span&gt;&lt;/span&gt;&lt;/span&gt; for &lt;br&gt;&lt;span style=&quot;font-weight: bold;&quot;&gt;Supplier&lt;/span&gt;',service_type= 'transfer';
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3028'
        ;
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE bookings SET  parent_agent_id= '22', sub_agent_rate= '', agent_rate= '41.91', applicable_service_tax= '', supplier_rate= '550' where id= '3028';
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO transfer_bookings SET booking_id = '3028' ,transfer_date = '2020-11-10' ,country_code = '132' ,city_code = '82246' ,pickup = 'O' ,pickup_code = '' ,dropoff = 'O' ,dropoff_code = '' ,no_of_pass = '4' ,pick_up_time = '21.00' ,dropoff_time = '08.00' ,item_code = '201' ,item_content = 'BIA-Ella Air Transfer' ,sel_arr_from = 'Katunayake' ,flight_number = '' ,dropoff_to_hotel = '' ,dropoff_station = '' ,dropoff_station_train = '' ,dropoff_station_destination = '' ,dest_flight_no = '' ,flight_destination = '' ,dropoff_port_shipname = '' ,dropoff_port_shipcompany = '' ,dropoff_port_shipdestination = '' ,pickup_acc_address1 = '' ,pickup_acc_address2 = '' ,pickup_acc_city = '' ,pickup_acc_country = '' ,pickup_acc_postcode = '' ,pickup_acc_phone = '' ,dropoff_acc_address1 = '' ,dropoff_acc_address2 = '' ,dropoff_acc_city = '' ,dropoff_acc_country = '' ,dropoff_acc_postcode = '' ,dropoff_acc_phone = '' ,dropoff_other_address1 = 'Airport Expressway, Colombo - Katunayake Expressway, Katunayake, Sri Lanka' ,dropoff_other_address2 = '' ,dropoff_other_country = 'Sri Lanka' ,dropoff_other_postcode = '' ,dropoff_other_phone = '' ,Error= '',Item_Confirm_Ref='',airport_arriving_from = '' ,arriving_flight_number = '' ,pickup_from_hotel = '' ,pickup_station_arriving_from = '' ,pickup_station_train_name = '' ,pickup_station_arriving_station = '' ,pickup_port_arriving_from = '' ,pickup_port_ship_name = '' ,pickup_port_shipping_company = '' ,pickup_other_address1 = 'The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka' ,pickup_other_address2 = '' ,pickup_other_country = 'Sri Lanka' ,pickup_other_postcode = '' ,pickup_other_phone = '' ,travel_duration = '10 hr 0 min ' ,supplier_id = 'S000000003' ,charge_applied_type = 'private_per_km' ,vehicle_type = '4' ,calculated_distance = '30' ,supplier_profile= '6';
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3028','confirmed','2020-10-21 04:48:28','Offline transfer booking by tfg','tfg','43.250.210.76','tfg','','');
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO transfer_vehicles SET  booking_id  = '3028' ,vehicle_code = '4' ,vehicle_name = 'VAN 4 SEATER' ,max_passenger = '4' ,max_luggage = '2' , sel_passenger  = '4' , no_of_adult  = '2' , no_of_child  = '2' , lead_name  = 'Ms Shiba Test' , adult_rate  = '0' , child_rate  = '0' , parking_fee  = '' , driver_tips  = '' , representative_cost  = '' , guide_cost  = '' , touristic_fee  = '' , vehicle_native_price  = '550.00' , native_price  = '550' , display_price  = '41.91' , native_surcharge  = '' , display_surcharge  = '' ;
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO passangers SET booking_id='3028',salutations='Mr',first_name='ToBeAdvisedB',last_name='ToBeAdvisedB',passenger_type='adult',age='',rid='1023';
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO passangers SET booking_id='3028',salutations='child',first_name='ToBeAdvised',last_name='ToBeAdvised',passenger_type='child',age='2',rid='1023';
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO passangers SET booking_id='3028',salutations='child',first_name='ToBeAdvised',last_name='ToBeAdvised',passenger_type='child',age='9',rid='1023';
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3028', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223028%22%3Bs%3A12%3A%22post_details%22%3Ba%3A45%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A3%3A%22201%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221884%22%3Bs%3A10%3A%22service_id%22%3Bs%3A3%3A%22201%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2282246%22%3Bs%3A9%3A%22city_name%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A10%3A%22country_id%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A14%3A%22nationality_id%22%3Bs%3A3%3A%22106%22%3Bs%3A11%3A%22nationality%22%3Bs%3A6%3A%22Indian%22%3Bs%3A9%3A%22child_age%22%3Bs%3A23%3A%22%255B%25222%2522%252C%25229%2522%255D%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A1%3A%224%22%3Bs%3A4%3A%22type%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22A%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22A%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A56%3A%22The+Steuart+by+Citrus%2C+Hospital+Lane%2C+Colombo%2C+Sri+Lanka%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A74%3A%22Airport+Expressway%2C+Colombo+-+Katunayake+Expressway%2C+Katunayake%2C+Sri+Lanka%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A7%3A%2230.0+km%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22transfer_duration%22%3Bs%3A12%3A%2210+hr+0+min+%22%3Bs%3A16%3A%22vehicle_capacity%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A110%3A%22Unregistered%2Bsup%2Band%2Btransfer%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253Ecustomer%253C%252Fspan%253E%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A338%3A%22Unregistered%2Bsup%2Band%2B%253Cspan%2Bstyle%253D%2522color%253A%2Brgb%2528255%252C%2B0%252C%2B0%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522background-color%253A%2Brgb%2528255%252C%2B255%252C%2B255%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522text-decoration%253A%2Bunderline%253B%2522%253Etransfer%253C%252Fspan%253E%253C%252Fspan%253E%253C%252Fspan%253E%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253ESupplier%253C%252Fspan%253E%22%3Bs%3A12%3A%22service_name%22%3Bs%3A21%3A%22BIA-Ella+Air+Transfer%22%3Bs%3A17%3A%22vehicle_type_name%22%3Bs%3A12%3A%22VAN+4+SEATER%22%3Bs%3A13%3A%22transfer_type%22%3Bs%3A12%3A%22Privateperkm%22%3Bs%3A11%3A%22serviceDate%22%3Bs%3A10%3A%2210-11-2020%22%3Bs%3A11%3A%22NoOfService%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%222%22%3Bs%3A19%3A%22pickup_time_airport%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A2%3A%2221%22%3Bs%3A11%3A%22Time_Minute%22%3Bs%3A2%3A%2200%22%3B%7Ds%3A20%3A%22dropoff_time_airport%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A2%3A%2208%22%3Bs%3A11%3A%22Time_Minute%22%3Bs%3A2%3A%2200%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A5%3A%22Shiba%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Test%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A6%3A%22550.00%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22550%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A5%3A%2241.91%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A5%3A%2241.91%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22quotation_info%22%3Bs%3A11118%3A%22a%253A58%253A%257Bs%253A8%253A%2522noofpass%2522%253Bs%253A1%253A%25224%2522%253Bs%253A8%253A%2522tra_date%2522%253Bs%253A10%253A%25222020-11-10%2522%253Bs%253A17%253A%2522markup_percentage%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A10%253A%2522TransferId%2522%253Bs%253A3%253A%2522201%2522%253Bs%253A13%253A%2522Vehicle_un_id%2522%253Bs%253A19%253A%2522localtransfer_201_0%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A21%253A%2522BIA-Ella%2BAir%2BTransfer%2522%253Bs%253A4%253A%2522city%2522%253Bs%253A10%253A%2522Katunayake%2522%253Bs%253A9%253A%2522city_code%2522%253Bs%253A5%253A%252282246%2522%253Bs%253A6%253A%2522Pickup%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A4%253A%252221.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%252221%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A7%253A%2522Dropoff%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A3%253A%25228.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A11%253A%25228%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A8%253A%2522Duration%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A4%253A%252210.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%252210%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A16%253A%2522rateCurrencyCode%2522%253Bs%253A3%253A%2522MYR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522cancellation_hours%2522%253Bs%253A2%253A%252248%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A15%253A%2522TransferSummary%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A13%253A%2522total_charges%2522%253Bs%253A5%253A%252241.91%2522%253Bs%253A17%253A%2522propertyAvailable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253BN%253Bs%253A19%253A%2522per_child_agentrate%2522%253BN%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bi%253A0%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bi%253A0%253Bs%253A7%253A%2522Vehical%2522%253Ba%253A9%253A%257Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A11%253A%2522supplier_id%2522%253Bs%253A10%253A%2522S000000003%2522%253Bs%253A10%253A%2522ChargeType%2522%253Bs%253A12%253A%2522privateperkm%2522%253Bs%253A8%253A%2522RateInfo%2522%253Ba%253A15%253A%257Bs%253A9%253A%2522AdultRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522ChildRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522TariffCode%2522%253Bs%253A32%253A%2522a3c4665db88b4adfe33393e97a8142ed%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522MYR%2522%253Bs%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A5%253A%252241.91%2522%253B%257Ds%253A15%253A%2522displayRoomRate%2522%253Bs%253A5%253A%252241.91%2522%253Bs%253A23%253A%2522chargeableRoomRateTotal%2522%253Bs%253A6%253A%2522550.00%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522550.00%2522%253B%257Ds%253A14%253A%2522nativeRoomRate%2522%253Bs%253A6%253A%2522550.00%2522%253Bs%253A14%253A%2522baseNativeRate%2522%253Bs%253A3%253A%25220.5%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522per_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A8%253A%2522Language%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522code%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A4%253A%2522desc%2522%253Bs%253A7%253A%2522English%2522%253B%257Ds%253A11%253A%2522VehicleInfo%2522%253Ba%253A5%253A%257Bs%253A4%253A%2522Code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A14%253A%2522MaximumLuggage%2522%253Bs%253A1%253A%25222%2522%253Bs%253A17%253A%2522MaximumPassengers%2522%253Bs%253A1%253A%25224%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%2522VAN%2B4%2BSEATER%2522%253Bs%253A12%253A%2522thumbNailUrl%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A20%253A%2522noofAdultPassVehicle%2522%253Bs%253A1%253A%25222%2522%253Bs%253A20%253A%2522noofChildPassVehicle%2522%253Bs%253A1%253A%25222%2522%253Bs%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253B%257Ds%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522selected_currency%2522%253Bs%253A3%253A%2522MYR%2522%253Bs%253A12%253A%2522country_code%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A12%253A%2522to_city_code%2522%253Bs%253A5%253A%252290964%2522%253Bs%253A9%253A%2522language1%2522%253Bs%253A1%253A%2522E%2522%253Bs%253A9%253A%2522language2%2522%253Bs%253A1%253A%2522E%2522%253Bs%253A27%253A%2522display_currency_multiplier%2522%253Bs%253A7%253A%25220.06468%2522%253Bs%253A11%253A%2522nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A9%253A%2522noofadult%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522noofchild%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522child_age%2522%253Ba%253A2%253A%257Bi%253A0%253Bs%253A1%253A%25222%2522%253Bi%253A1%253Bs%253A1%253A%25229%2522%253B%257Ds%253A18%253A%2522selected_child_age%2522%253Ba%253A2%253A%257Bi%253A0%253Bs%253A1%253A%25222%2522%253Bi%253A1%253Bs%253A1%253A%25229%2522%253B%257Ds%253A17%253A%2522additional_markup%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A12%253A%2522country_name%2522%253Bs%253A9%253A%2522Sri%2BLanka%2522%253Bs%253A16%253A%2522pickup_code_name%2522%253Bs%253A56%253A%2522The%2BSteuart%2Bby%2BCitrus%252C%2BHospital%2BLane%252C%2BColombo%252C%2BSri%2BLanka%2522%253Bs%253A17%253A%2522dropoff_code_name%2522%253Bs%253A74%253A%2522Airport%2BExpressway%252C%2BColombo%2B-%2BKatunayake%2BExpressway%252C%2BKatunayake%252C%2BSri%2BLanka%2522%253Bs%253A6%253A%2522pickup%2522%253Bs%253A1%253A%2522A%2522%253Bs%253A7%253A%2522dropoff%2522%253Bs%253A1%253A%2522A%2522%253Bs%253A11%253A%2522pickup_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A12%253A%2522dropoff_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522total_mileage%2522%253Bs%253A7%253A%252230.0%2Bkm%2522%253Bs%253A13%253A%2522extra_mileage%2522%253Bs%253A1%253A%25220%2522%253Bs%253A14%253A%2522language1_data%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A14%253A%2522language2_data%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A21%253A%2522dropoff_transfer_city%2522%253Bs%253A5%253A%252290964%2522%253Bs%253A26%253A%2522dropoff_transfer_city_name%2522%253Bs%253A4%253A%2522Ella%2522%253Bs%253A9%253A%2522item_code%2522%253Bs%253A3%253A%2522201%2522%253Bs%253A18%253A%2522description_number%2522%253Bi%253A0%253Bs%253A18%253A%2522total_native_price%2522%253Bs%253A6%253A%2522550.00%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A86%253A%2522Unregistered%2Bsup%2Band%2Btransfer%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253Ecustomer%253C%252Fspan%253E%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A238%253A%2522Unregistered%2Bsup%2Band%2B%253Cspan%2Bstyle%253D%2522color%253A%2Brgb%2528255%252C%2B0%252C%2B0%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522background-color%253A%2Brgb%2528255%252C%2B255%252C%2B255%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522text-decoration%253A%2Bunderline%253B%2522%253Etransfer%253C%252Fspan%253E%253C%252Fspan%253E%253C%252Fspan%253E%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253ESupplier%253C%252Fspan%253E%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A3%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A2%253A%252215%2522%253B%257Ds%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25225.47%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25220.87%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25222.44%2522%253B%257D%257Ds%253A8%253A%2522Transfer%2522%253Ba%253A28%253A%257Bs%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222020-11-10%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A3%253A%2522550%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%252235.574%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.06468%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A5%253A%252241.91%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A15%253A%252297.959183673469%2522%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522MYR%2522%253B%257D%257Ds%253A27%253A%2522display_currency_multiplier%2522%253Bs%253A7%253A%25220.06468%2522%253Bs%253A17%253A%2522markup_percentage%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bi%253A0%253Bs%253A5%253A%252241.91%2522%253Bs%253A10%253A%2522TransferId%2522%253Bs%253A3%253A%2522201%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A21%253A%2522BIA-Ella%2BAir%2BTransfer%2522%253Bs%253A4%253A%2522city%2522%253Bs%253A10%253A%2522Katunayake%2522%253Bs%253A9%253A%2522city_code%2522%253Bs%253A5%253A%252282246%2522%253Bs%253A11%253A%2522DropoffCity%2522%253Bs%253A4%253A%2522Ella%2522%253Bs%253A15%253A%2522DropoffCityCode%2522%253Bs%253A5%253A%252290964%2522%253Bs%253A8%253A%2522Duration%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A4%253A%252210.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%252210%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A6%253A%2522Pickup%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A4%253A%252221.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%252221%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A7%253A%2522Dropoff%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A3%253A%25228.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A11%253A%25228%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A16%253A%2522rateCurrencyCode%2522%253Bs%253A3%253A%2522MYR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522cancellation_hours%2522%253Bs%253A2%253A%252248%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A14%253A%2522originalsource%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25226%2522%253Bs%253A15%253A%2522TransferSummary%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A7%253A%2522Vehicle%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A9%253A%257Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A11%253A%2522supplier_id%2522%253Bs%253A10%253A%2522S000000003%2522%253Bs%253A10%253A%2522ChargeType%2522%253Bs%253A12%253A%2522privateperkm%2522%253Bs%253A8%253A%2522RateInfo%2522%253Ba%253A15%253A%257Bs%253A9%253A%2522AdultRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522ChildRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522TariffCode%2522%253Bs%253A32%253A%2522a3c4665db88b4adfe33393e97a8142ed%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522MYR%2522%253Bs%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A5%253A%252241.91%2522%253B%257Ds%253A15%253A%2522displayRoomRate%2522%253Bs%253A5%253A%252241.91%2522%253Bs%253A23%253A%2522chargeableRoomRateTotal%2522%253Bs%253A6%253A%2522550.00%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522550.00%2522%253B%257Ds%253A14%253A%2522nativeRoomRate%2522%253Bs%253A6%253A%2522550.00%2522%253Bs%253A14%253A%2522baseNativeRate%2522%253Bs%253A3%253A%25220.5%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522per_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A8%253A%2522Language%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522code%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A4%253A%2522desc%2522%253Bs%253A7%253A%2522English%2522%253B%257Ds%253A11%253A%2522VehicleInfo%2522%253Ba%253A5%253A%257Bs%253A4%253A%2522Code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A14%253A%2522MaximumLuggage%2522%253Bs%253A1%253A%25222%2522%253Bs%253A17%253A%2522MaximumPassengers%2522%253Bs%253A1%253A%25224%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%2522VAN%2B4%2BSEATER%2522%253Bs%253A12%253A%2522thumbNailUrl%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A20%253A%2522noofAdultPassVehicle%2522%253Bs%253A1%253A%25222%2522%253Bs%253A20%253A%2522noofChildPassVehicle%2522%253Bs%253A1%253A%25222%2522%253Bs%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253B%257D%257Ds%253A19%253A%2522transfer_conditions%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A86%253A%2522Unregistered%2Bsup%2Band%2Btransfer%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253Ecustomer%253C%252Fspan%253E%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A238%253A%2522Unregistered%2Bsup%2Band%2B%253Cspan%2Bstyle%253D%2522color%253A%2Brgb%2528255%252C%2B0%252C%2B0%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522background-color%253A%2Brgb%2528255%252C%2B255%252C%2B255%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522text-decoration%253A%2Bunderline%253B%2522%253Etransfer%253C%252Fspan%253E%253C%252Fspan%253E%253C%252Fspan%253E%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253ESupplier%253C%252Fspan%253E%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A13%253A%2522total_charges%2522%253Bs%253A5%253A%252241.91%2522%253Bs%253A17%253A%2522propertyAvailable%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7Ds%3A15%3A%22request_details%22%3Ba%3A91%3A%7Bs%3A13%3A%22txt_city_code%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A25%3A%22txt_dropoff_other_country%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A24%3A%22txt_pickup_other_country%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A26%3A%22txt_dropoff_other_address1%22%3Bs%3A74%3A%22Airport+Expressway%2C+Colombo+-+Katunayake+Expressway%2C+Katunayake%2C+Sri+Lanka%22%3Bs%3A25%3A%22txt_pickup_other_address1%22%3Bs%3A56%3A%22The+Steuart+by+Citrus%2C+Hospital+Lane%2C+Colombo%2C+Sri+Lanka%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22call_from%22%3Bs%3A23%3A%22offline_backend_booking%22%3Bs%3A14%3A%22reservation_id%22%3Bs%3A4%3A%221820%22%3Bs%3A11%3A%22action_name%22%3Bs%3A23%3A%22insert_transfer_booking%22%3Bs%3A17%3A%22agent_selected_id%22%3Bs%3A2%3A%2222%22%3Bs%3A19%3A%22agent_currency_code%22%3Bs%3A3%3A%22MYR%22%3Bs%3A22%3A%22supplier_type_selected%22%3Bs%3A1%3A%22L%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2222%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A24%3A%22sel_country_of_residence%22%3Bs%3A3%3A%22132%22%3Bs%3A15%3A%22sel_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A13%3A%22sel_city_name%22%3Bs%3A10%3A%22Katunayake%22%3Bs%3A8%3A%22sel_city%22%3Bs%3A5%3A%2282246%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22O%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22O%22%3Bs%3A10%3A%22sel_pickup%22%3Bs%3A1%3A%22O%22%3Bs%3A11%3A%22sel_dropoff%22%3Bs%3A1%3A%22O%22%3Bs%3A14%3A%22rdSupplierType%22%3Bs%3A1%3A%22L%22%3Bs%3A12%3A%22sel_supplier%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A20%3A%22sel_supplierProfileL%22%3Bs%3A1%3A%226%22%3Bs%3A21%3A%22sel_currencies_online%22%3Bs%3A3%3A%22INR%22%3Bs%3A21%3A%22display_currency_code%22%3Bs%3A3%3A%22MYR%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.06468%22%3Bs%3A23%3A%22basecurrency_multiplier%22%3Bd%3A0.23694%3Bs%3A30%3A%22basecurrency_multiplier_native%22%3Bd%3A0.01533%3Bs%3A25%3A%22agent_currency_multiplier%22%3Bd%3A0.23694%3Bs%3A16%3A%22txt_agent_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A10%3A%22txt_markup%22%3Bs%3A18%3A%2217.810760667903523%22%3Bs%3A15%3A%22select_transfer%22%3Bs%3A3%3A%22201%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A13%3A%22transfer_date%22%3Bs%3A10%3A%2210-11-2020%22%3Bs%3A15%3A%22chk_charge_type%22%3Bs%3A14%3A%22private_per_km%22%3Bs%3A16%3A%22sel_vehicle_type%22%3Bs%3A1%3A%224%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A22%3A%22total_native_surcharge%22%3Bd%3A0%3Bs%3A23%3A%22total_display_surcharge%22%3Bd%3A0%3Bs%3A17%3A%22total_native_rate%22%3Bs%3A3%3A%22550%22%3Bs%3A11%3A%22vehicle_cnt%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22leader_salutation%22%3Bs%3A2%3A%22Ms%22%3Bs%3A17%3A%22leader_first_name%22%3Bs%3A5%3A%22Shiba%22%3Bs%3A16%3A%22leader_last_name%22%3Bs%3A4%3A%22Test%22%3Bs%3A18%3A%22dropoff_time_other%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A2%3A%2208%22%3Bs%3A11%3A%22Time_Minute%22%3Bs%3A2%3A%2200%22%3B%7Ds%3A17%3A%22pickup_time_other%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A2%3A%2221%22%3Bs%3A11%3A%22Time_Minute%22%3Bs%3A2%3A%2200%22%3B%7Ds%3A9%3A%22no_adults%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A2%3B%7Ds%3A11%3A%22no_children%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A2%3B%7Ds%3A12%3A%22leader_title%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A9%3A%22lead_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A5%3A%22Shiba%22%3B%7Ds%3A14%3A%22lead_last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Test%22%3B%7Ds%3A10%3A%22lead_phone%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A10%3A%22adult_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22child_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A11%3A%22parking_fee%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A11%3A%22driver_tips%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A19%3A%22representative_cost%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A10%3A%22guide_cost%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A13%3A%22touristic_fee%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A11%3A%22native_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22550.00%22%3B%7Ds%3A12%3A%22display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A5%3A%2241.91%22%3B%7Ds%3A16%3A%22native_surcharge%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A0%3B%7Ds%3A17%3A%22display_surcharge%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A0%3B%7Ds%3A18%3A%22total_display_rate%22%3Bd%3A41.91%3Bs%3A14%3A%22applicable_tax%22%3Bi%3A0%3Bs%3A27%3A%22display_surcharge_and_rates%22%3Bd%3A41.91%3Bs%3A26%3A%22native_surcharge_and_rates%22%3Bd%3A550%3Bs%3A15%3A%22expiration_date%22%3Bs%3A19%3A%2221-10-2020+00%3A00%3A00%22%3Bs%3A13%3A%22meeting_point%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22cancellation_policy%22%3Bs%3A0%3A%22%22%3Bs%3A28%3A%22supplier_cancellation_policy%22%3Bs%3A0%3A%22%22%3Bs%3A6%3A%22remark%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22special_comment%22%3Bs%3A86%3A%22Unregistered+sup+and+transfer+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3Ecustomer%3C%2Fspan%3E%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A238%3A%22Unregistered+sup+and+%3Cspan+style%3D%22color%3A+rgb%28255%2C+0%2C+0%29%3B%22%3E%3Cspan+style%3D%22background-color%3A+rgb%28255%2C+255%2C+255%29%3B%22%3E%3Cspan+style%3D%22text-decoration%3A+underline%3B%22%3Etransfer%3C%2Fspan%3E%3C%2Fspan%3E%3C%2Fspan%3E+for+%3Cbr%3E%3Cspan+style%3D%22font-weight%3A+bold%3B%22%3ESupplier%3C%2Fspan%3E%22%3Bs%3A19%3A%22confirmation_number%22%3Bs%3A0%3A%22%22%3Bs%3A20%3A%22txt_sub_agent_markup%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22additional_charge%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22leader_phone%22%3Bs%3A10%3A%227666065659%22%3Bs%3A8%3A%22email_id%22%3Bs%3A28%3A%22ankita.rao%40qtechsoftware.com%22%3Bs%3A14%3A%22trans_duration%22%3Bs%3A12%3A%2210+hr+0+min+%22%3Bs%3A14%3A%22leader_address%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22additional_distance%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22calculated_distance%22%3Bi%3A30%3Bs%3A14%3A%22passenger_list%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A3%3A%7Bi%3A1%3Bs%3A2%3A%22Mr%22%3Bi%3A2%3Bs%3A5%3A%22child%22%3Bi%3A3%3Bs%3A5%3A%22child%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A3%3A%7Bi%3A1%3Bs%3A12%3A%22ToBeAdvisedB%22%3Bi%3A2%3Bs%3A11%3A%22ToBeAdvised%22%3Bi%3A3%3Bs%3A11%3A%22ToBeAdvised%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A3%3A%7Bi%3A1%3Bs%3A12%3A%22ToBeAdvisedB%22%3Bi%3A2%3Bs%3A11%3A%22ToBeAdvised%22%3Bi%3A3%3Bs%3A11%3A%22ToBeAdvised%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A3%3A%7Bi%3A1%3Bs%3A0%3A%22%22%3Bi%3A2%3Bs%3A1%3A%222%22%3Bi%3A3%3Bs%3A1%3A%229%22%3B%7D%7D%7Ds%3A20%3A%22is_quote_fit_booking%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22fetch_booking_details%22%3Bb%3A1%3Bs%3A8%3A%22sequence%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%222%22%3B%7Ds%3A17%3A%22quotation_details%22%3Bs%3A11118%3A%22a%253A58%253A%257Bs%253A8%253A%2522noofpass%2522%253Bs%253A1%253A%25224%2522%253Bs%253A8%253A%2522tra_date%2522%253Bs%253A10%253A%25222020-11-10%2522%253Bs%253A17%253A%2522markup_percentage%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A10%253A%2522TransferId%2522%253Bs%253A3%253A%2522201%2522%253Bs%253A13%253A%2522Vehicle_un_id%2522%253Bs%253A19%253A%2522localtransfer_201_0%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A21%253A%2522BIA-Ella%2BAir%2BTransfer%2522%253Bs%253A4%253A%2522city%2522%253Bs%253A10%253A%2522Katunayake%2522%253Bs%253A9%253A%2522city_code%2522%253Bs%253A5%253A%252282246%2522%253Bs%253A6%253A%2522Pickup%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A4%253A%252221.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%252221%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A7%253A%2522Dropoff%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A3%253A%25228.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A11%253A%25228%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A8%253A%2522Duration%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A4%253A%252210.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%252210%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A16%253A%2522rateCurrencyCode%2522%253Bs%253A3%253A%2522MYR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522cancellation_hours%2522%253Bs%253A2%253A%252248%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A15%253A%2522TransferSummary%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A13%253A%2522total_charges%2522%253Bs%253A5%253A%252241.91%2522%253Bs%253A17%253A%2522propertyAvailable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253BN%253Bs%253A19%253A%2522per_child_agentrate%2522%253BN%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bi%253A0%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bi%253A0%253Bs%253A7%253A%2522Vehical%2522%253Ba%253A9%253A%257Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A11%253A%2522supplier_id%2522%253Bs%253A10%253A%2522S000000003%2522%253Bs%253A10%253A%2522ChargeType%2522%253Bs%253A12%253A%2522privateperkm%2522%253Bs%253A8%253A%2522RateInfo%2522%253Ba%253A15%253A%257Bs%253A9%253A%2522AdultRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522ChildRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522TariffCode%2522%253Bs%253A32%253A%2522a3c4665db88b4adfe33393e97a8142ed%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522MYR%2522%253Bs%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A5%253A%252241.91%2522%253B%257Ds%253A15%253A%2522displayRoomRate%2522%253Bs%253A5%253A%252241.91%2522%253Bs%253A23%253A%2522chargeableRoomRateTotal%2522%253Bs%253A6%253A%2522550.00%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522550.00%2522%253B%257Ds%253A14%253A%2522nativeRoomRate%2522%253Bs%253A6%253A%2522550.00%2522%253Bs%253A14%253A%2522baseNativeRate%2522%253Bs%253A3%253A%25220.5%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522per_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A8%253A%2522Language%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522code%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A4%253A%2522desc%2522%253Bs%253A7%253A%2522English%2522%253B%257Ds%253A11%253A%2522VehicleInfo%2522%253Ba%253A5%253A%257Bs%253A4%253A%2522Code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A14%253A%2522MaximumLuggage%2522%253Bs%253A1%253A%25222%2522%253Bs%253A17%253A%2522MaximumPassengers%2522%253Bs%253A1%253A%25224%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%2522VAN%2B4%2BSEATER%2522%253Bs%253A12%253A%2522thumbNailUrl%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A20%253A%2522noofAdultPassVehicle%2522%253Bs%253A1%253A%25222%2522%253Bs%253A20%253A%2522noofChildPassVehicle%2522%253Bs%253A1%253A%25222%2522%253Bs%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253B%257Ds%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522selected_currency%2522%253Bs%253A3%253A%2522MYR%2522%253Bs%253A12%253A%2522country_code%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A12%253A%2522to_city_code%2522%253Bs%253A5%253A%252290964%2522%253Bs%253A9%253A%2522language1%2522%253Bs%253A1%253A%2522E%2522%253Bs%253A9%253A%2522language2%2522%253Bs%253A1%253A%2522E%2522%253Bs%253A27%253A%2522display_currency_multiplier%2522%253Bs%253A7%253A%25220.06468%2522%253Bs%253A11%253A%2522nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A9%253A%2522noofadult%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522noofchild%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522child_age%2522%253Ba%253A2%253A%257Bi%253A0%253Bs%253A1%253A%25222%2522%253Bi%253A1%253Bs%253A1%253A%25229%2522%253B%257Ds%253A18%253A%2522selected_child_age%2522%253Ba%253A2%253A%257Bi%253A0%253Bs%253A1%253A%25222%2522%253Bi%253A1%253Bs%253A1%253A%25229%2522%253B%257Ds%253A17%253A%2522additional_markup%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A12%253A%2522country_name%2522%253Bs%253A9%253A%2522Sri%2BLanka%2522%253Bs%253A16%253A%2522pickup_code_name%2522%253Bs%253A56%253A%2522The%2BSteuart%2Bby%2BCitrus%252C%2BHospital%2BLane%252C%2BColombo%252C%2BSri%2BLanka%2522%253Bs%253A17%253A%2522dropoff_code_name%2522%253Bs%253A74%253A%2522Airport%2BExpressway%252C%2BColombo%2B-%2BKatunayake%2BExpressway%252C%2BKatunayake%252C%2BSri%2BLanka%2522%253Bs%253A6%253A%2522pickup%2522%253Bs%253A1%253A%2522A%2522%253Bs%253A7%253A%2522dropoff%2522%253Bs%253A1%253A%2522A%2522%253Bs%253A11%253A%2522pickup_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A12%253A%2522dropoff_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522total_mileage%2522%253Bs%253A7%253A%252230.0%2Bkm%2522%253Bs%253A13%253A%2522extra_mileage%2522%253Bs%253A1%253A%25220%2522%253Bs%253A14%253A%2522language1_data%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A14%253A%2522language2_data%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A21%253A%2522dropoff_transfer_city%2522%253Bs%253A5%253A%252290964%2522%253Bs%253A26%253A%2522dropoff_transfer_city_name%2522%253Bs%253A4%253A%2522Ella%2522%253Bs%253A9%253A%2522item_code%2522%253Bs%253A3%253A%2522201%2522%253Bs%253A18%253A%2522description_number%2522%253Bi%253A0%253Bs%253A18%253A%2522total_native_price%2522%253Bs%253A6%253A%2522550.00%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A86%253A%2522Unregistered%2Bsup%2Band%2Btransfer%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253Ecustomer%253C%252Fspan%253E%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A238%253A%2522Unregistered%2Bsup%2Band%2B%253Cspan%2Bstyle%253D%2522color%253A%2Brgb%2528255%252C%2B0%252C%2B0%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522background-color%253A%2Brgb%2528255%252C%2B255%252C%2B255%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522text-decoration%253A%2Bunderline%253B%2522%253Etransfer%253C%252Fspan%253E%253C%252Fspan%253E%253C%252Fspan%253E%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253ESupplier%253C%252Fspan%253E%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A3%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A2%253A%252215%2522%253B%257Ds%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25225.47%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25220.87%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25222.44%2522%253B%257D%257Ds%253A8%253A%2522Transfer%2522%253Ba%253A28%253A%257Bs%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222020-11-10%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A3%253A%2522550%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%252235.574%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.06468%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A5%253A%252241.91%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A15%253A%252297.959183673469%2522%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522MYR%2522%253B%257D%257Ds%253A27%253A%2522display_currency_multiplier%2522%253Bs%253A7%253A%25220.06468%2522%253Bs%253A17%253A%2522markup_percentage%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bi%253A0%253Bs%253A5%253A%252241.91%2522%253Bs%253A10%253A%2522TransferId%2522%253Bs%253A3%253A%2522201%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A21%253A%2522BIA-Ella%2BAir%2BTransfer%2522%253Bs%253A4%253A%2522city%2522%253Bs%253A10%253A%2522Katunayake%2522%253Bs%253A9%253A%2522city_code%2522%253Bs%253A5%253A%252282246%2522%253Bs%253A11%253A%2522DropoffCity%2522%253Bs%253A4%253A%2522Ella%2522%253Bs%253A15%253A%2522DropoffCityCode%2522%253Bs%253A5%253A%252290964%2522%253Bs%253A8%253A%2522Duration%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A4%253A%252210.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%252210%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A6%253A%2522Pickup%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A4%253A%252221.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%252221%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A7%253A%2522Dropoff%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A3%253A%25228.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A11%253A%25228%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A16%253A%2522rateCurrencyCode%2522%253Bs%253A3%253A%2522MYR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522cancellation_hours%2522%253Bs%253A2%253A%252248%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A14%253A%2522originalsource%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25226%2522%253Bs%253A15%253A%2522TransferSummary%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A7%253A%2522Vehicle%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A9%253A%257Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A11%253A%2522supplier_id%2522%253Bs%253A10%253A%2522S000000003%2522%253Bs%253A10%253A%2522ChargeType%2522%253Bs%253A12%253A%2522privateperkm%2522%253Bs%253A8%253A%2522RateInfo%2522%253Ba%253A15%253A%257Bs%253A9%253A%2522AdultRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522ChildRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522TariffCode%2522%253Bs%253A32%253A%2522a3c4665db88b4adfe33393e97a8142ed%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522MYR%2522%253Bs%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A5%253A%252241.91%2522%253B%257Ds%253A15%253A%2522displayRoomRate%2522%253Bs%253A5%253A%252241.91%2522%253Bs%253A23%253A%2522chargeableRoomRateTotal%2522%253Bs%253A6%253A%2522550.00%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522550.00%2522%253B%257Ds%253A14%253A%2522nativeRoomRate%2522%253Bs%253A6%253A%2522550.00%2522%253Bs%253A14%253A%2522baseNativeRate%2522%253Bs%253A3%253A%25220.5%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522per_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A8%253A%2522Language%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522code%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A4%253A%2522desc%2522%253Bs%253A7%253A%2522English%2522%253B%257Ds%253A11%253A%2522VehicleInfo%2522%253Ba%253A5%253A%257Bs%253A4%253A%2522Code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A14%253A%2522MaximumLuggage%2522%253Bs%253A1%253A%25222%2522%253Bs%253A17%253A%2522MaximumPassengers%2522%253Bs%253A1%253A%25224%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A12%253A%2522VAN%2B4%2BSEATER%2522%253Bs%253A12%253A%2522thumbNailUrl%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A20%253A%2522noofAdultPassVehicle%2522%253Bs%253A1%253A%25222%2522%253Bs%253A20%253A%2522noofChildPassVehicle%2522%253Bs%253A1%253A%25222%2522%253Bs%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253B%257D%257Ds%253A19%253A%2522transfer_conditions%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A86%253A%2522Unregistered%2Bsup%2Band%2Btransfer%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253Ecustomer%253C%252Fspan%253E%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A238%253A%2522Unregistered%2Bsup%2Band%2B%253Cspan%2Bstyle%253D%2522color%253A%2Brgb%2528255%252C%2B0%252C%2B0%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522background-color%253A%2Brgb%2528255%252C%2B255%252C%2B255%2529%253B%2522%253E%253Cspan%2Bstyle%253D%2522text-decoration%253A%2Bunderline%253B%2522%253Etransfer%253C%252Fspan%253E%253C%252Fspan%253E%253C%252Fspan%253E%2Bfor%2B%253Cbr%253E%253Cspan%2Bstyle%253D%2522font-weight%253A%2Bbold%253B%2522%253ESupplier%253C%252Fspan%253E%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A18%253A%252217.810760667903523%2522%253Bs%253A13%253A%2522total_charges%2522%253Bs%253A5%253A%252241.91%2522%253Bs%253A17%253A%2522propertyAvailable%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7D', create_date='2020-10-21 04:48:28';;
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3028','confirmed','2020-10-21 04:48:28','Quotation Id - QTECHCA002227 created on behalf of Agent - Nilesh Rao(22) by tfg','tfg','43.250.210.76','tfg','','');
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3028','confirmed','2020-10-21 04:48:28','Enquiry Id - 403 created on behalf of Agent - Nilesh Rao(22) by tfg','tfg','43.250.210.76','tfg','','');
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='booked' where unique_id='QTECHCA002227';
[10/21/2020 04:48:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3028',q_id='QTECHCA002227',enquiry_id='403',quote_id='1884',backoffice_user='tfg',agent_id='22',create_date='2020-10-21 04:48:28',booked_from='agent_quote_itemized';
[10/21/2020 04:49:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-21 04:49:02',current_status='vouchered',voucher_hashcode='390642d7ad0e52033adc8a8777fc323a945333028',vouchered_by ='tfg' where id='3028';
[10/21/2020 04:49:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3028',config_key='VOUCHER_DATE', config_value='2020-10-21 04:49:02',create_date='2020-10-21 04:49:02';
[10/21/2020 04:49:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1603255742');
[10/21/2020 04:49:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/388' where id='3028' and is_invoiced!='yes';
[10/21/2020 04:49:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('9.9301554'),   credit_value= credit_value-('9.9301554') ,  cd_credit_usage=cd_credit_usage+('9.9301554') , cd_credit_value=cd_credit_value-('9.9301554')  WHERE id = '22';
[10/21/2020 04:49:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '22',credit_value= '49503252.380',credit_usage= '496747.620',credit_limit= '50000000',receipt_id= '',amount= '9.9301554',booking_id='3028',booking_cost= '41.91',receipt_allocation= '',balance= '41.91',ip='43.250.210.76',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-21 04:10:02';
[10/21/2020 04:49:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='INR',supplier_price='550',supplier_type='offline',supplier_id='S000000003',acc_type='purchase',accounting_multiplier='0.01533',booking_id='3028',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-21 04:49:02',account_invoice='2020/388',particulars='';
[10/21/2020 04:49:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3028','0','550.000','0','IP','0','1','purchase','booking_rate_info','1496','supplier');
[10/21/2020 04:49:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/388',acc_export='1' where bid='1496';
[10/21/2020 04:49:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='41.91',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.23694',booking_id='3028',booking_log='Transfer Booking Vouchered',type='Sale',create_date='2020-10-21 04:49:02',account_invoice='2020/388',particulars='';
[10/21/2020 04:49:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1497;
[10/21/2020 04:49:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1497',booking_id= '3028',invoice_number= '2020/388',service_type= 'transfer',booking_type= 'offline',service_name= 'BIA-Ella Air Transfer',type= 'sale',from_date= '2020-11-10',to_date= '2020-11-10',price= '41.910',total_price= '41.910';
[10/21/2020 04:49:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3028','4','41.910','5.4665217391304','OP','15','1','sale','booking_rate_info','1497','agent');
[10/21/2020 04:49:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/388',acc_export='1' where bid='1497';
[10/21/2020 04:49:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/388',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 44156 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,ankita.rao@qtechsofware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-21 04:49:06';
[10/21/2020 04:49:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3028','vouchered-invoiced','2020-10-21 04:49:06',' by tfg','tfg','43.250.210.76','tfg','','');
[10/21/2020 04:49:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3028',booking_detail_id ='3028',agent_id ='22',is_sub_agent ='N',parent_id ='',display_commission ='6.3359999999998',display_currency ='MYR',paid ='N',type ='transfer',description ='Agent Mark Up Percentage is 17.810760667903 %',create_date ='2020-10-21 04:49:06';
[10/21/2020 04:49:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3028',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/21/2020 04:49:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3028','vouchered','2020-10-21 04:49:06','Vouchered By tfg by tfg','tfg','43.250.210.76','tfg','','');
[10/21/2020 04:49:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303028/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41840 characters]',to_email_id= 'ankita.rao@qtechsofware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-21 04:49:08';
[10/21/2020 04:49:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG303028/  Booking Vouchered ',from_email_id= '',body= '[encoded data, 41840 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-21 04:49:10';
[10/21/2020 04:50:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_assignment SET assignment_no='L00113',assignment_type='internal',entity_value='4',entity_type='driver',vehicle_no='1',vehicle='2',type='private_per_km',allowance='550',substitute_price='',petty_cash='',pickupSlot='2020-11-10 21:00:00',dropOffSlot='2020-11-11 07:00:00',remark='',duration='10 hours 0 mintues',create_date='2020-10-21 04:50:08',created_by='tfg';
[10/21/2020 04:50:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO logistics_bookings SET la_id='112',booking_id='3028',pax='4',start_assignment_time='2020-11-10 21:00:00',end_assignment_time='2020-11-11 07:00:00',pickup='The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka Sri Lanka',dropoff='Airport Expressway, Colombo - Katunayake Expressway, Katunayake, Sri Lanka Sri Lanka',service_name='BIA-Ella Air Transfer',created_date='2020-10-21 04:50:08';
[10/21/2020 04:50:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],delete from bookings_tax WHERE acc_type='purchase' AND booking_id IN (3028);
[10/21/2020 04:50:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],update booking_rate_info SET supplier_price='0',original_supplier_price='550.000',acc_export='0' WHERE acc_type='purchase' AND booking_id IN (3028) and type != 'Assignment';
[10/21/2020 04:50:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],INSERT INTO booking_rate_info SET agent_price='',sub_agent_price='',supplier_currency='INR',supplier_price='550.000',supplier_type='offlline',supplier_id='S000000072',acc_type='purchase',accounting_multiplier='0.01533',substitute_price='0.000',booking_id='3028',booking_log='',type='Assignment',create_date='2020-10-21 04:50:08',account_invoice='L00113',particulars='Logistics Assignment';
[10/21/2020 04:50:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],Update transfer_bookings SET old_supplier = supplier_id, supplier_id = 'S000000072' where booking_id = '3028' ;
[10/21/2020 04:50:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],update booking_rate_info set account_invoice_number='2020/388',acc_export='1' where bid='1496';
[10/21/2020 04:50:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],update booking_rate_info set account_invoice_number='L00113',acc_export='1' where bid='1498';
[10/21/2020 04:50:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-21 04:50:09',`log_type`= 'Assignment',`sql_query`= 'INSERT INTO logistics_assignment SET assignment_no=\&#039;L00113\&#039;,assignment_type=\&#039;internal\&#039;,entity_value=\&#039;4\&#039;,entity_type=\&#039;driver\&#039;,vehicle_no=1,vehicle=\&#039;2\&#039;,type=\&#039;private_per_km\&#039;,allowance=550,substitute_price=0,petty_cash=0,pickupSlot=\&#039;2020-11-10 21:00:00\&#039;,dropOffSlot=\&#039;2020-11-11 07:00:00\&#039;,remark=\&#039;\&#039;,duration=\&#039;10 hours 0 mintues\&#039;,create_date=\&#039;2020-10-21 04:50:08\&#039;,created_by=\&#039;tfg\&#039;----INSERT INTO logistics_bookings SET la_id=\&#039;112\&#039;,booking_id=\&#039;3028\&#039;,pax=\&#039;4\&#039;,start_assignment_time=\&#039;2020-11-10 21:00:00\&#039;,end_assignment_time=\&#039;2020-11-11 07:00:00\&#039;,pickup=\&#039;The Steuart by Citrus, Hospital Lane, Colombo, Sri Lanka Sri Lanka\&#039;,dropoff=\&#039;Airport Expressway, Colombo - Katunayake Expressway, Katunayake, Sri Lanka Sri Lanka\&#039;,service_name=\&#039;BIA-Ella Air Transfer\&#039;,created_date=\&#039;2020-10-21 04:50:08\&#039;',`log_description`= ' driver Allowance:-  INR petty Cash:-  INR',`ip`= '43.250.210.76';
[10/21/2020 04:50:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3781', `entity`='BookingId', `value`='3028' ;
[10/21/2020 04:50:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logistics.php],insert into user_log_link Set `user_logs_id`='3781', `entity`='Assignment', `value`='L00113' ;
