[09/21/2020 05:28:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 398;
[09/21/2020 05:28:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1840', q_name='', service='transfer', agent_id='22', create_date='2020-09-21 05:28:33', q_info='a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222020-09-01%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22204%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_204_0%22%3Bs%3A4%3A%22name%22%3Bs%3A11%3A%22Leisure+Day%22%3Bs%3A4%3A%22city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%220.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%220+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%3A2%3A%226.%22%3Bs%3A8%3A%22_content%22%3Bs%3A10%3A%226+hr++min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%220.00%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A7%3A%22Vehical%22%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A7%3A%22private%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%220eec1d9e86129be257451d96687259ba%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%220.00%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%220.00%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A4%3A%220.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%3A4%3A%220.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%220.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A12%3A%22vehicle_desc%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22_content%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%221%22%3Bs%3A20%3A%22noofChildPassVehicle%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3B%7Ds%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22language1%22%3Bs%3A1%3A%22E%22%3Bs%3A9%3A%22language2%22%3Bs%3A1%3A%22E%22%3Bs%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A11%3A%22nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A9%3A%22noofadult%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noofchild%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22child_age%22%3Ba%3A0%3A%7B%7Ds%3A18%3A%22selected_child_age%22%3Ba%3A0%3A%7B%7Ds%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A0%3A%22%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22O%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22O%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%3A0%3A%22%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22language1_data%22%3Bs%3A7%3A%22English%22%3Bs%3A14%3A%22language2_data%22%3Bs%3A7%3A%22English%22%3Bs%3A21%3A%22dropoff_transfer_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22204%22%3Bs%3A18%3A%22description_number%22%3Bi%3A0%3Bs%3A18%3A%22total_native_price%22%3Bs%3A4%3A%220.00%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7Ds%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-01%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A1%3A%220%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%220%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A1%3A%220%22%3Bi%3A0%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22204%22%3Bs%3A4%3A%22name%22%3Bs%3A11%3A%22Leisure+Day%22%3Bs%3A4%3A%22city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A2%3A%226.%22%3Bs%3A8%3A%22_content%22%3Bs%3A10%3A%226+hr++min+%22%3B%7Ds%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%220.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%220+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A14%3A%22originalsource%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22Vehicle%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A7%3A%22private%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%220eec1d9e86129be257451d96687259ba%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%220.00%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%220.00%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A4%3A%220.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%3A4%3A%220.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%220.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A12%3A%22vehicle_desc%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22_content%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%221%22%3Bs%3A20%3A%22noofChildPassVehicle%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3B%7D%7Ds%3A19%3A%22transfer_conditions%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%220.00%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Colombo', hotel_id='204', additional_markup='0', cancelltion_policy='', per_night=NULL, total_price='0.00', room_type=NULL, room_rate=NULL, currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-09-21 05:28:33', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002224', service_date='2020-09-01 00:00:00', service_checkout_date='2020-09-01 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='1', total_child='0', child_age='a%3A0%3A%7B%7D', leader_name=' ', salutation='Mr', first_name='', last_name='', email='', contact_no='', enquiry_id='398', quotation_status='edited', sequence='4', rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-01%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A1%3A%220%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%220%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D';
[09/21/2020 05:28:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'QTECHCA002224',modified_by = 'tfg',modified_date = '2020-09-21 05:28:33',currency ='INR',service_date='2020-09-01',service_checkout_date='2020-09-01',sequence='4',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-09-01%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A1%3A%220%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%220%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D',agent_id = '22',q_info = 'a%3A58%3A%7Bs%3A8%3A%22noofpass%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22tra_date%22%3Bs%3A10%3A%222020-09-01%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22204%22%3Bs%3A13%3A%22Vehicle_un_id%22%3Bs%3A19%3A%22localtransfer_204_0%22%3Bs%3A4%3A%22name%22%3Bs%3A11%3A%22Leisure+Day%22%3Bs%3A4%3A%22city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%220.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%220+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%3A2%3A%226.%22%3Bs%3A8%3A%22_content%22%3Bs%3A10%3A%226+hr++min+%22%3B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%220.00%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A7%3A%22Vehical%22%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A7%3A%22private%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%220eec1d9e86129be257451d96687259ba%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%220.00%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%220.00%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A4%3A%220.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%3A4%3A%220.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%220.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A12%3A%22vehicle_desc%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22_content%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%221%22%3Bs%3A20%3A%22noofChildPassVehicle%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3B%7Ds%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A12%3A%22country_code%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22to_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22language1%22%3Bs%3A1%3A%22E%22%3Bs%3A9%3A%22language2%22%3Bs%3A1%3A%22E%22%3Bs%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A11%3A%22nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A9%3A%22noofadult%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noofchild%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22child_age%22%3Ba%3A0%3A%7B%7Ds%3A18%3A%22selected_child_age%22%3Ba%3A0%3A%7B%7Ds%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A12%3A%22Test+Leisure%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A12%3A%22Test+Leisure%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22O%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22O%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A2%3A%2271%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A2%3A%2271%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22language1_data%22%3Bs%3A7%3A%22English%22%3Bs%3A14%3A%22language2_data%22%3Bs%3A7%3A%22English%22%3Bs%3A21%3A%22dropoff_transfer_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A26%3A%22dropoff_transfer_city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22item_code%22%3Bs%3A3%3A%22204%22%3Bs%3A18%3A%22description_number%22%3Bi%3A0%3Bs%3A18%3A%22total_native_price%22%3Bs%3A4%3A%220.00%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7Ds%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-01%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A1%3A%220%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A1%3A%220%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A27%3A%22display_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A17%3A%22markup_percentage%22%3Bs%3A1%3A%220%22%3Bi%3A0%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22TransferId%22%3Bs%3A3%3A%22204%22%3Bs%3A4%3A%22name%22%3Bs%3A11%3A%22Leisure+Day%22%3Bs%3A4%3A%22city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A11%3A%22DropoffCity%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A15%3A%22DropoffCityCode%22%3Bs%3A5%3A%2271100%22%3Bs%3A8%3A%22Duration%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A2%3A%226.%22%3Bs%3A8%3A%22_content%22%3Bs%3A10%3A%226+hr++min+%22%3B%7Ds%3A6%3A%22Pickup%22%3Ba%3A2%3A%7Bs%3A4%3A%22Time%22%3Bs%3A3%3A%220.0%22%3Bs%3A8%3A%22_content%22%3Bs%3A11%3A%220+hr+0+min+%22%3B%7Ds%3A7%3A%22Dropoff%22%3Ba%3A0%3A%7B%7Ds%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22cancellation_hours%22%3Bs%3A2%3A%2248%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A14%3A%22originalsource%22%3Bs%3A13%3A%22localtransfer%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22TransferSummary%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A7%3A%22Vehicle%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A9%3A%7Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000003%22%3Bs%3A10%3A%22ChargeType%22%3Bs%3A7%3A%22private%22%3Bs%3A8%3A%22RateInfo%22%3Ba%3A15%3A%7Bs%3A9%3A%22AdultRate%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22ChildRate%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22TariffCode%22%3Bs%3A32%3A%220eec1d9e86129be257451d96687259ba%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%220.00%22%3B%7Ds%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%220.00%22%3Bs%3A23%3A%22chargeableRoomRateTotal%22%3Bs%3A4%3A%220.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%3A4%3A%220.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%220.00%22%3Bs%3A14%3A%22baseNativeRate%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3B%7Ds%3A8%3A%22Language%22%3Ba%3A2%3A%7Bs%3A4%3A%22code%22%3Bs%3A7%3A%22English%22%3Bs%3A4%3A%22desc%22%3Bs%3A7%3A%22English%22%3B%7Ds%3A11%3A%22VehicleInfo%22%3Ba%3A5%3A%7Bs%3A4%3A%22Code%22%3Bs%3A12%3A%22vehicle_desc%22%3Bs%3A14%3A%22MaximumLuggage%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22MaximumPassengers%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22_content%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22thumbNailUrl%22%3Bs%3A0%3A%22%22%3B%7Ds%3A20%3A%22noofAdultPassVehicle%22%3Bs%3A1%3A%221%22%3Bs%3A20%3A%22noofChildPassVehicle%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22no_of_vehicle%22%3Bs%3A1%3A%221%22%3B%7D%7Ds%3A19%3A%22transfer_conditions%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A1%3A%220%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%220.00%22%3Bs%3A17%3A%22propertyAvailable%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'transfer',hotel_id = '204',additional_markup = '0',city_name ='Colombo',city_code ='71100',country_code ='132',nationality ='106',total_adult ='1',total_child ='0',child_age ='a%3A0%3A%7B%7D',leader_name =' ',salutation ='Mr',first_name ='',last_name ='',quotation_type ='back_end',enquiry_id ='398',total_price ='' WHERE q_id='1840';
[09/21/2020 05:28:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002224' AND quotation_status!='booked';
