[09/02/2020 05:25:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],INSERT INTO `tax_configuration` (`branch_country`, `branch_state`, `valid_from`, `valid_to`, `supplier_registered`,`supplier_country`,`supplier_type` , `service`, `sub_service`, `exempted`,`consumed`,`has_consumed_location`, `type`,`system`, `input_tax_id`, `input_tax_amt`,`output_tax_id`, `output_tax_amt`,`created_by`,`created_on`,`branch`)
	 	VALUES ('132','', '2020-09-01', '2050-12-31', '1', '0','external', '10', '', '0','IB' , '0' , 'IN', 'b2b', '0', '', '6', '3','tfg','2020-09-02 05:25:27','');
[09/02/2020 05:25:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-09-02 05:25:27',`log_type`= 'Tax Configuration',`sql_query`= 'INSERT INTO `tax_configuration` (`branch_country`, `branch_state`, `valid_from`, `valid_to`, `supplier_registered`,`supplier_country`,`supplier_type` , `service`, `sub_service`, `exempted`,`consumed`,`has_consumed_location`, `type`,`system`, `input_tax_id`, `input_tax_amt`,`output_tax_id`, `output_tax_amt`,`created_by`,`created_on`,`branch`)
	 	VALUES (\&#039;132\&#039;,\&#039;\&#039;, \&#039;2020-09-01\&#039;, \&#039;2050-12-31\&#039;, \&#039;1\&#039;, \&#039;0\&#039;,\&#039;external\&#039;, \&#039;10\&#039;, \&#039;\&#039;, \&#039;0\&#039;,\&#039;IB\&#039; , \&#039;0\&#039; , \&#039;IN\&#039;, \&#039;b2b\&#039;, \&#039;0\&#039;, \&#039;\&#039;, \&#039;6\&#039;, \&#039;3\&#039;,\&#039;tfg\&#039;,\&#039;2020-09-02 05:25:27\&#039;,\&#039;\&#039;)',`log_description`= 'Tax Configuration added',`ip`= '43.250.210.87';
[09/02/2020 05:37:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 392;
[09/02/2020 05:37:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation SET q_name = '',email='ankita.rao@qtechsoftware.com',contact_no='7666065659',unique_id = 'QTECHCA002221',backoffice_user = 'tfg',create_date = '2020-09-02 05:37:28',currency ='USD',service_date='2020-09-30',service_checkout_date='2020-09-30',city_code ='71100',country_code ='132',nationality ='106',total_adult ='2',total_child ='1',child_age ='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7D',sequence='4',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D',agent_id = '22',q_info = 'a%3A20%3A%7Bs%3A4%3A%22Misc%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A38%3A%7Bs%3A15%3A%22misc_service_id%22%3Bs%3A1%3A%228%22%3Bs%3A12%3A%22misc_service%22%3Bs%3A21%3A%22Entrance+Ticket%28MISC%29%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22sub_service%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%224%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A8%3A%22RateInfo%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A15%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22displayNightlyRate%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%228.43%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%228.43%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%22275.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A10%3A%22total_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A20%3A%22per_infant_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.21%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2299.96%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22total_room%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22room_rate_per_night%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22total_night%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A22%3A%22total_supplier_charges%22%3Bs%3A6%3A%22275.00%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A17%3A%22total_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22total_infant_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A6%3A%22userid%22%3Bs%3A2%3A%2222%22%3Bs%3A15%3A%22search_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A13%3A%22selected_city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22selected_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22agent_category%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A38%3A%7Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A15%3A%22misc_service_id%22%3Bs%3A1%3A%228%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22Entrance+Ticket%28MISC%29%22%3Bs%3A16%3A%22sub_service_name%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A20%3A%22per_infant_agentrate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A200%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A50%3Bs%3A17%3A%22total_infant_rate%22%3Bi%3A25%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A22%3A%22total_infant_agentrate%22%3Bi%3A0%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.21%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2299.96%22%3B%7D%7D%7D%7D',service = 'misc',hotel_id = '8',additional_markup = '0',city_name ='Colombo',leader_name ='Ankita Test',salutation ='Ms',first_name ='Ankita',last_name ='Test',quotation_type ='back_end',enquiry_id ='392',total_price ='8.43';
[09/02/2020 05:37:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1820', q_name='', service='misc', agent_id='22', create_date='2020-09-02 05:37:28', q_info='a%3A20%3A%7Bs%3A4%3A%22Misc%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A38%3A%7Bs%3A15%3A%22misc_service_id%22%3Bs%3A1%3A%228%22%3Bs%3A12%3A%22misc_service%22%3Bs%3A21%3A%22Entrance+Ticket%28MISC%29%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22sub_service%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%224%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A8%3A%22RateInfo%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A15%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22displayNightlyRate%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%228.43%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%228.43%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%22275.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A10%3A%22total_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A20%3A%22per_infant_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.21%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2299.96%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22total_room%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22room_rate_per_night%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22total_night%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A22%3A%22total_supplier_charges%22%3Bs%3A6%3A%22275.00%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A17%3A%22total_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22total_infant_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A6%3A%22userid%22%3Bs%3A2%3A%2222%22%3Bs%3A15%3A%22search_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A13%3A%22selected_city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22selected_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22agent_category%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A38%3A%7Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A15%3A%22misc_service_id%22%3Bs%3A1%3A%228%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22Entrance+Ticket%28MISC%29%22%3Bs%3A16%3A%22sub_service_name%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A20%3A%22per_infant_agentrate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A200%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A50%3Bs%3A17%3A%22total_infant_rate%22%3Bi%3A25%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A22%3A%22total_infant_agentrate%22%3Bi%3A0%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.21%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2299.96%22%3B%7D%7D%7D%7D', city_name='Colombo', hotel_id='8', additional_markup='0', cancelltion_policy='', per_night=NULL, total_price='8.43', room_type=NULL, room_rate=NULL, currency='USD', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-09-02 05:37:28', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002221', service_date='2020-09-30 00:00:00', service_checkout_date='2020-09-30 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='2', total_child='1', child_age='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7D', leader_name='Ankita Test', salutation='Ms', first_name='Ankita', last_name='Test', email='ankita.rao@qtechsoftware.com', contact_no='7666065659', enquiry_id='392', 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%2230%2F09%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D';
[09/02/2020 05:37:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1820', service_id='8', service_type='misc',service_date='2020-09-30', sequence='4';
[09/02/2020 05:37:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1820', service_date='2020-09-30';
[09/02/2020 05:37:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002221' AND quotation_status!='booked';
[09/02/2020 05:39:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 392;
[09/02/2020 05:39:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1820', q_name='', service='misc', agent_id='22', create_date='2020-09-02 05:39:46', q_info='a%3A20%3A%7Bs%3A4%3A%22Misc%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A38%3A%7Bs%3A15%3A%22misc_service_id%22%3Bs%3A1%3A%228%22%3Bs%3A12%3A%22misc_service%22%3Bs%3A21%3A%22Entrance+Ticket%28MISC%29%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22sub_service%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%224%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A8%3A%22RateInfo%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A15%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22displayNightlyRate%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%228.43%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%228.43%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%22275.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A10%3A%22total_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A20%3A%22per_infant_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.21%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2299.96%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22total_room%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22room_rate_per_night%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22total_night%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A22%3A%22total_supplier_charges%22%3Bs%3A6%3A%22275.00%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A17%3A%22total_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22total_infant_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A6%3A%22userid%22%3Bs%3A2%3A%2222%22%3Bs%3A15%3A%22search_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A13%3A%22selected_city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22selected_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22agent_category%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A38%3A%7Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2230%2F09%2F2020%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A15%3A%22misc_service_id%22%3Bs%3A1%3A%228%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22Entrance+Ticket%28MISC%29%22%3Bs%3A16%3A%22sub_service_name%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A20%3A%22per_infant_agentrate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A200%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A50%3Bs%3A17%3A%22total_infant_rate%22%3Bi%3A25%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A22%3A%22total_infant_agentrate%22%3Bi%3A0%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%224.21%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2299.96%22%3B%7D%7D%7D%7D', city_name='Colombo', hotel_id='8', additional_markup='0', cancelltion_policy='', per_night=NULL, total_price='8.43', room_type=NULL, room_rate=NULL, currency='USD', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-09-02 05:39:46', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002221', service_date='2020-09-30 00:00:00', service_checkout_date='2020-09-30 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='2', total_child='1', child_age='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7D', leader_name='Ankita Test', salutation='Ms', first_name='Ankita', last_name='Test', email='ankita.rao@qtechsoftware.com', contact_no='7666065659', enquiry_id='392', 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%2230%2F09%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D';
[09/02/2020 05:39:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='ankita.rao@qtechsoftware.com',contact_no='7666065659',unique_id = 'QTECHCA002221',modified_by = 'tfg',modified_date = '2020-09-02 05:39:46',currency ='USD',service_date='2020-10-02',service_checkout_date='2020-10-02',city_code ='71100',country_code ='132',nationality ='106',total_adult ='2',total_child ='1',child_age ='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7D',sequence='4',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D',agent_id = '22',q_info = 'a%3A20%3A%7Bs%3A4%3A%22Misc%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A38%3A%7Bs%3A15%3A%22misc_service_id%22%3Bs%3A2%3A%2210%22%3Bs%3A12%3A%22misc_service%22%3Bs%3A21%3A%22Train+Ticket+%28Public%29%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22sub_service%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%224%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A8%3A%22RateInfo%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A15%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22displayNightlyRate%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%228.43%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%228.43%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%22275.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A10%3A%22total_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A20%3A%22per_infant_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A10%3A%22STATUTORY%09%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%223%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.25%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.97%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2294.14%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22total_room%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22room_rate_per_night%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22total_night%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A22%3A%22total_supplier_charges%22%3Bs%3A6%3A%22275.00%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A17%3A%22total_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22total_infant_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A6%3A%22userid%22%3Bs%3A2%3A%2222%22%3Bs%3A15%3A%22search_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22selected_city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22selected_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22agent_category%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A38%3A%7Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A15%3A%22misc_service_id%22%3Bs%3A2%3A%2210%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22Train+Ticket+%28Public%29%22%3Bs%3A16%3A%22sub_service_name%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A20%3A%22per_infant_agentrate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A200%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A50%3Bs%3A17%3A%22total_infant_rate%22%3Bi%3A25%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A22%3A%22total_infant_agentrate%22%3Bi%3A0%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A10%3A%22STATUTORY%09%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%223%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.25%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.97%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2294.14%22%3B%7D%7D%7D%7D',service = 'misc',hotel_id = '10',additional_markup = '0',city_name ='Colombo',leader_name ='Ankita Test',salutation ='Ms',first_name ='Ankita',last_name ='Test',quotation_type ='back_end',enquiry_id ='392',total_price ='8.43' WHERE q_id='1820';
[09/02/2020 05:39:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1820', service_id='10', service_type='misc',service_date='2020-10-02', sequence='4';
[09/02/2020 05:39:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1820', service_date='2020-10-02';
[09/02/2020 05:39:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002221' AND quotation_status!='booked';
[09/02/2020 05:39:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 392;
[09/02/2020 05:39:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1820', q_name='', service='misc', agent_id='22', create_date='2020-09-02 05:39:51', q_info='a%3A20%3A%7Bs%3A4%3A%22Misc%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A38%3A%7Bs%3A15%3A%22misc_service_id%22%3Bs%3A2%3A%2210%22%3Bs%3A12%3A%22misc_service%22%3Bs%3A21%3A%22Train+Ticket+%28Public%29%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22sub_service%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%224%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A8%3A%22RateInfo%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A15%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22displayNightlyRate%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%228.43%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%228.43%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%22275.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A10%3A%22total_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A20%3A%22per_infant_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A10%3A%22STATUTORY%09%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%223%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.25%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.97%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2294.14%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22total_room%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22room_rate_per_night%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22total_night%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A22%3A%22total_supplier_charges%22%3Bs%3A6%3A%22275.00%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A17%3A%22total_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22total_infant_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A6%3A%22userid%22%3Bs%3A2%3A%2222%22%3Bs%3A15%3A%22search_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22selected_city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22selected_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22agent_category%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A38%3A%7Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A15%3A%22misc_service_id%22%3Bs%3A2%3A%2210%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22Train+Ticket+%28Public%29%22%3Bs%3A16%3A%22sub_service_name%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A20%3A%22per_infant_agentrate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A200%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A50%3Bs%3A17%3A%22total_infant_rate%22%3Bi%3A25%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A22%3A%22total_infant_agentrate%22%3Bi%3A0%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A10%3A%22STATUTORY%09%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%223%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.25%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.97%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2294.14%22%3B%7D%7D%7D%7D', city_name='Colombo', hotel_id='10', additional_markup='0', cancelltion_policy='', per_night=NULL, total_price='8.43', room_type=NULL, room_rate=NULL, currency='USD', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-09-02 05:39:51', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002221', service_date='2020-10-02 00:00:00', service_checkout_date='2020-10-02 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='2', total_child='1', child_age='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7D', leader_name='Ankita Test', salutation='Ms', first_name='Ankita', last_name='Test', email='ankita.rao@qtechsoftware.com', contact_no='7666065659', enquiry_id='392', 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%2202%2F10%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D';
[09/02/2020 05:39:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='ankita.rao@qtechsoftware.com',contact_no='7666065659',unique_id = 'QTECHCA002221',modified_by = 'tfg',modified_date = '2020-09-02 05:39:51',currency ='USD',service_date='2020-10-02',service_checkout_date='2020-10-02',city_code ='71100',country_code ='132',nationality ='106',total_adult ='2',total_child ='1',child_age ='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7D',sequence='4',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D',agent_id = '22',q_info = 'a%3A20%3A%7Bs%3A4%3A%22Misc%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A38%3A%7Bs%3A15%3A%22misc_service_id%22%3Bs%3A2%3A%2210%22%3Bs%3A12%3A%22misc_service%22%3Bs%3A21%3A%22Train+Ticket+%28Public%29%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22sub_service%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%224%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A8%3A%22RateInfo%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A15%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22displayNightlyRate%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%228.43%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%228.43%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%22275.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A10%3A%22total_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A20%3A%22per_infant_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A10%3A%22STATUTORY%09%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%223%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.25%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.97%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2294.14%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22total_room%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22room_rate_per_night%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22total_night%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A22%3A%22total_supplier_charges%22%3Bs%3A6%3A%22275.00%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A17%3A%22total_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22total_infant_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A6%3A%22userid%22%3Bs%3A2%3A%2222%22%3Bs%3A15%3A%22search_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22selected_city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22selected_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22agent_category%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A38%3A%7Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A15%3A%22misc_service_id%22%3Bs%3A2%3A%2210%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22Train+Ticket+%28Public%29%22%3Bs%3A16%3A%22sub_service_name%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A20%3A%22per_infant_agentrate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A200%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A50%3Bs%3A17%3A%22total_infant_rate%22%3Bi%3A25%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A22%3A%22total_infant_agentrate%22%3Bi%3A0%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A10%3A%22STATUTORY%09%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%223%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.25%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.97%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2294.14%22%3B%7D%7D%7D%7D',service = 'misc',hotel_id = '10',additional_markup = '0',city_name ='Colombo',leader_name ='Ankita Test',salutation ='Ms',first_name ='Ankita',last_name ='Test',quotation_type ='back_end',enquiry_id ='392',total_price ='8.43' WHERE q_id='1820';
[09/02/2020 05:39:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002221' AND quotation_status!='booked';
[09/02/2020 05:40:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 392;
[09/02/2020 05:40:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1820', q_name='', service='misc', agent_id='22', create_date='2020-09-02 05:40:30', q_info='a%3A20%3A%7Bs%3A4%3A%22Misc%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A38%3A%7Bs%3A15%3A%22misc_service_id%22%3Bs%3A2%3A%2210%22%3Bs%3A12%3A%22misc_service%22%3Bs%3A21%3A%22Train+Ticket+%28Public%29%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22sub_service%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%224%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A8%3A%22RateInfo%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A15%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22displayNightlyRate%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%228.43%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%228.43%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%22275.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A10%3A%22total_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A20%3A%22per_infant_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A10%3A%22STATUTORY%09%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%223%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.25%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.97%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2294.14%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22total_room%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22room_rate_per_night%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22total_night%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A22%3A%22total_supplier_charges%22%3Bs%3A6%3A%22275.00%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A17%3A%22total_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22total_infant_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A6%3A%22userid%22%3Bs%3A2%3A%2222%22%3Bs%3A15%3A%22search_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22selected_city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22selected_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22agent_category%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A38%3A%7Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A15%3A%22misc_service_id%22%3Bs%3A2%3A%2210%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22Train+Ticket+%28Public%29%22%3Bs%3A16%3A%22sub_service_name%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A20%3A%22per_infant_agentrate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A200%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A50%3Bs%3A17%3A%22total_infant_rate%22%3Bi%3A25%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A22%3A%22total_infant_agentrate%22%3Bi%3A0%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A10%3A%22STATUTORY%09%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%223%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.25%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.97%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2294.14%22%3B%7D%7D%7D%7D', city_name='Colombo', hotel_id='10', additional_markup='0', cancelltion_policy='', per_night=NULL, total_price='8.43', room_type=NULL, room_rate=NULL, currency='USD', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-09-02 05:40:30', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002221', service_date='2020-10-02 00:00:00', service_checkout_date='2020-10-02 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='2', total_child='1', child_age='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7D', leader_name='Ankita Test', salutation='Ms', first_name='Ankita', last_name='Test', email='ankita.rao@qtechsoftware.com', contact_no='7666065659', enquiry_id='392', 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%2202%2F10%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D';
[09/02/2020 05:40:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='ankita.rao@qtechsoftware.com',contact_no='7666065659',unique_id = 'QTECHCA002221',modified_by = 'tfg',modified_date = '2020-09-02 05:40:30',currency ='USD',service_date='2020-10-02',service_checkout_date='2020-10-02',city_code ='71100',country_code ='132',nationality ='106',total_adult ='2',total_child ='1',child_age ='a%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7D',sequence='4',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D',agent_id = '22',q_info = 'a%3A20%3A%7Bs%3A4%3A%22Misc%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A38%3A%7Bs%3A15%3A%22misc_service_id%22%3Bs%3A2%3A%2210%22%3Bs%3A12%3A%22misc_service%22%3Bs%3A21%3A%22Train+Ticket+%28Public%29%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22sub_service%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A12%3A%22total_people%22%3Bs%3A1%3A%224%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A3%3A%22275%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A7%3A%224.21575%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A3%3A%22275%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A8%3A%22RateInfo%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A15%3A%7Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22displayNightlyRate%22%3Ba%3A2%3A%7Bs%3A4%3A%22size%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%228.43%22%3B%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%228.43%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%22275.00%22%3B%7Ds%3A14%3A%22nativeRoomRate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A10%3A%22total_rate%22%3Bs%3A4%3A%228.43%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22per_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A20%3A%22per_infant_agentrate%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A10%3A%22STATUTORY%09%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%223%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.25%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.97%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2294.14%22%3B%7D%7Ds%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22total_room%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22room_rate_per_night%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22total_night%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A22%3A%22total_supplier_charges%22%3Bs%3A6%3A%22275.00%22%3Bs%3A16%3A%22total_adult_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A16%3A%22total_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A17%3A%22total_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22total_adult_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A21%3A%22total_child_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22total_infant_agentrate%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3B%7D%7Ds%3A6%3A%22userid%22%3Bs%3A2%3A%2222%22%3Bs%3A15%3A%22search_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A17%3A%22selected_currency%22%3Bs%3A3%3A%22USD%22%3Bs%3A21%3A%22selected_arrival_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A13%3A%22selected_city%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22selected_city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A9%3A%22child_age%22%3Ba%3A2%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22agent_category%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A38%3A%7Bs%3A12%3A%22service_date%22%3Bs%3A10%3A%2202%2F10%2F2020%22%3Bs%3A15%3A%22selected_adults%22%3Bs%3A1%3A%222%22%3Bs%3A17%3A%22selected_children%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22selected_infant%22%3Bs%3A2%3A%2201%22%3Bs%3A15%3A%22misc_service_id%22%3Bs%3A2%3A%2210%22%3Bs%3A11%3A%22sub_type_id%22%3Bs%3A0%3A%22%22%3Bs%3A4%3A%22name%22%3Bs%3A21%3A%22Train+Ticket+%28Public%29%22%3Bs%3A16%3A%22sub_service_name%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22rate_type%22%3Bs%3A7%3A%22per_pax%22%3Bs%3A9%3A%22city_code%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A13%3A%22supplier_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A7%3A%22country%22%3Bs%3A3%3A%22132%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A4%3A%22misc%22%3Bs%3A16%3A%22rateCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A13%3A%22total_charges%22%3Bs%3A4%3A%228.43%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22275.00%22%3Bs%3A14%3A%22per_adult_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A14%3A%22per_child_rate%22%3Bs%3A2%3A%2250%22%3Bs%3A15%3A%22per_infant_rate%22%3Bs%3A2%3A%2225%22%3Bs%3A19%3A%22per_adult_agentrate%22%3BN%3Bs%3A19%3A%22per_child_agentrate%22%3BN%3Bs%3A20%3A%22per_infant_agentrate%22%3BN%3Bs%3A16%3A%22total_adult_rate%22%3Bi%3A200%3Bs%3A16%3A%22total_child_rate%22%3Bi%3A50%3Bs%3A17%3A%22total_infant_rate%22%3Bi%3A25%3Bs%3A21%3A%22total_adult_agentrate%22%3Bi%3A0%3Bs%3A21%3A%22total_child_agentrate%22%3Bi%3A0%3Bs%3A22%3A%22total_infant_agentrate%22%3Bi%3A0%3Bs%3A14%3A%22applied_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22additional_markup%22%3Bs%3A1%3A%220%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A3%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A1%3A%226%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A10%3A%22STATUTORY%09%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%223%22%3B%7Ds%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.25%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.97%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2294.14%22%3B%7D%7D%7D%7D',service = 'misc',hotel_id = '10',additional_markup = '0',city_name ='Colombo',leader_name ='Ankita Test',salutation ='Ms',first_name ='Ankita',last_name ='Test',quotation_type ='back_end',enquiry_id ='392',total_price ='8.43' WHERE q_id='1820';
[09/02/2020 05:40:30], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002221' AND quotation_status!='booked';
[09/02/2020 05:41:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-09-02 05:41:26', '', '', '');
[09/02/2020 05:55:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET status='D' WHERE q_id IN (1820);;
