[07/25/2020 11:00:32], [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-07-25 11:00:32', '', '', '');
[07/25/2020 11:01:16], [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-07-25 11:01:16', '', '', '');
[07/25/2020 11:04:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 369;
[07/25/2020 11:04:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1764', q_name='', service='hotel', agent_id='22', create_date='2020-07-25 11:04:12', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1391990400%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2208%2F08%2F2020+--+09%2F08%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A4%3A%22name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22500.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22500.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%228.28%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-08%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22500.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%227.67%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%228%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.28%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%228.28%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22500.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E133%7E%7E%7E595%7E%7E%7E5%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22595%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%225%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A13%3A%22All+Inclusive%22%3Bs%3A9%3A%22room_type%22%3Bs%3A41%3A%22Junior+Suite+Tower+-+Single+All+Inclusive%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A42%3A%22Junior+Suite+Tower+-+Single%28All+Inclusive%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A27%3A%22Junior+Suite+Tower+-+Single%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%227.953063885267269%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E133%7E%7E%7E595%7E%7E%7E5%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%227.953063885267269%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.61%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.02%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%228.28%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22500%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%228.0234833659491%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.02%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.278698%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2299.730656%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A1%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271129%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A243%3A%22http%3A%2F%2Fuat.tfg.otrams.net%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22500.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22500.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%228.28%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-08%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22500.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%227.67%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%228%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.28%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%228.28%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22500.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E133%7E%7E%7E595%7E%7E%7E5%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22595%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%225%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A13%3A%22All+Inclusive%22%3Bs%3A9%3A%22room_type%22%3Bs%3A41%3A%22Junior+Suite+Tower+-+Single+All+Inclusive%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A42%3A%22Junior+Suite+Tower+-+Single%28All+Inclusive%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A27%3A%22Junior+Suite+Tower+-+Single%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%227.953063885267269%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E133%7E%7E%7E595%7E%7E%7E5%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%227.953063885267269%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.61%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.02%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%228.28%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22500%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%228.0234833659491%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.02%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Bentota', hotel_id='53704', additional_markup='0', cancelltion_policy='', per_night='8.28', total_price='8.28', room_type='Junior Suite Tower - Single(All Inclusive)', room_rate='8.28', currency='USD', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-07-25 11:04:12', status='A', is_visible='1', is_optional='0', unique_id='QTECHCA002217', service_date='2020-08-08 00:00:00', service_checkout_date='2020-08-09 00:00:00', city_code='71129', country_code='132', nationality='106', total_adult='1', total_child='0', child_age='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D', leader_name='Snehal ', salutation='Mrs', first_name='Snehal', last_name='', email='', contact_no='', enquiry_id='369', quotation_status='edited', sequence='2', 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-08-08%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22500.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%227.67%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%228%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%228.28%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D';
[07/25/2020 11:04:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'QTECHCA002217',modified_by = 'tfg',modified_date = '2020-07-25 11:04:12',currency ='USD',service_date='2020-08-08 00:00:00',service_checkout_date='2020-08-09 00:00:00',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-08-08%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22800.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2212.26%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A15%3A%228.0234833659491%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2213.25%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D',sequence='2',agent_id = '22',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1391990400%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2208%2F08%2F2020+--+09%2F08%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A4%3A%22name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22800.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22800.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2213.25%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-08%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22800.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2212.26%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A15%3A%228.0234833659491%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2213.25%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2213.25%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22800.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E5%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22983%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%225%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A13%3A%22All+Inclusive%22%3Bs%3A9%3A%22room_type%22%3Bs%3A32%3A%22Eli+Kunji+-+Double+All+Inclusive%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A33%3A%22Eli+Kunji+-+Double%28All+Inclusive%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A18%3A%22Eli+Kunji+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A16%3A%228.07504078303426%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E5%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A16%3A%228.07504078303426%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.99%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.04%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2213.25%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22800%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%228.0397912589693%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.04%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.278698%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2299.730656%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A1%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271129%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A243%3A%22http%3A%2F%2Fuat.tfg.otrams.net%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A6%3A%22800.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A6%3A%22800.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2213.25%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-08%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A6%3A%22800.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2212.26%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A15%3A%228.0234833659491%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2213.25%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2213.25%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A6%3A%22800.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E5%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22983%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%225%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A13%3A%22All+Inclusive%22%3Bs%3A9%3A%22room_type%22%3Bs%3A32%3A%22Eli+Kunji+-+Double+All+Inclusive%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A33%3A%22Eli+Kunji+-+Double%28All+Inclusive%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A18%3A%22Eli+Kunji+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A16%3A%228.07504078303426%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E5%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A16%3A%228.07504078303426%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%220.99%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.04%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2213.25%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22800%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A15%3A%228.0397912589693%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.04%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53704',city_name ='Bentota',city_code ='71129',country_code ='132',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name ='Snehal ',salutation ='Mrs',first_name ='Snehal',last_name ='',quotation_type ='back_end',total_adult ='1',enquiry_id ='369',total_price ='13.25',per_night ='13.25',room_type ='Eli Kunji - Double(All Inclusive)',room_rate ='13.25' WHERE q_id='1764';
[07/25/2020 11:04:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCA002217' AND quotation_status!='booked';
[07/25/2020 11:04:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET is_visible = @is_visible :=NOT is_visible WHERE q_id='1764';;
[07/25/2020 11:06:02], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET is_visible = @is_visible :=NOT is_visible WHERE q_id='1764';;
[07/25/2020 11:06:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET is_optional = @is_optional :=NOT is_optional WHERE q_id='1764';;
[07/25/2020 11:07:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET status='D' WHERE q_id IN (1766);;
[07/25/2020 11:07:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET quotation_status='responded' WHERE unique_id IN ('QTECHCA002217') AND agent_id='22' AND quotation_status!='booked';
[07/25/2020 11:14:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE day_wise_quotation_itinerary SET sequence='1' WHERE id IN ('2367');;
[07/25/2020 11:14:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE day_wise_quotation_description SET description='' WHERE id IN ('2209');;
[07/25/2020 11:14:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_settings SET email_template_data = 'a%3A1%3A%7Bs%3A14%3A%22email_template%22%3Ba%3A12%3A%7Bs%3A6%3A%22action%22%3Bs%3A19%3A%22updateEmailTemplate%22%3Bs%3A13%3A%22setPresetText%22%3Bs%3A1%3A%221%22%3Bs%3A7%3A%22is_ajax%22%3Bs%3A4%3A%22true%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A13%3A%22QTECHCA002217%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2222%22%3Bs%3A15%3A%22preset_text_sel%22%3Bs%3A1%3A%223%22%3Bs%3A15%3A%22preset_text_ids%22%3Ba%3A3%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3Bi%3A1%3Bs%3A1%3A%223%22%3Bi%3A2%3Bs%3A1%3A%222%22%3B%7Ds%3A17%3A%22preset_text_label%22%3Ba%3A3%3A%7Bi%3A0%3Bs%3A18%3A%22Terms+%26+conditions%22%3Bi%3A1%3Bs%3A7%3A%22Exclude%22%3Bi%3A2%3Bs%3A8%3A%22Includes%22%3B%7Ds%3A15%3A%22servicewisedate%22%3Bs%3A10%3A%2207%2F08%2F2020%22%3Bs%3A14%3A%22daydescription%22%3Bs%3A0%3A%22%22%3Bs%3A22%3A%22quotation_special_note%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22preset_text%22%3Ba%3A3%3A%7Bi%3A0%3Bs%3A690%3A%22%3Cdiv%3E%3Cul%3E%3Cli%3EValid+for+Economy+class+return+air+fares+purchased+online+at+macktrip.com%3C%2Fli%3E%3Cli%3EFares+mentioned+above+are+including+of+taxes+and+surcharges+and+are+subject+to+change+without+prior+notice%3C%2Fli%3E%3Cli%3EFares+mentioned+above+are+subject+to+availability%3C%2Fli%3E%3Cli%3EPassengers+will+be+charged+the+applicable+penalties+for+any+changes%3C%2Fli%3E%3Cli%3EPassengers+need+to+obtain+relevant+Visas%2C+other+authorizations+and+documents+required+for+travel%3C%2Fli%3E%3Cli%3EStandard+terms+and+conditions+and+fare+rules+will+continue+to+apply%3C%2Fli%3E%3Cli%3EMacktrip+reserves+the+right+to+withdraw+all+or+any+of+the+rules+applicable+to+the+above+offer+at+any+time+at+its+sole+discretion+without+prior+notice%3C%2Fli%3E%3C%2Ful%3E%3C%2Fdiv%3E%22%3Bi%3A1%3Bs%3A209%3A%22After+breakfast%2C+transfer+back+to+Colombo%2C+visiting+Hambantota+Salterns+and+the+Stilt+Fisherman+at+Weligama+en+route%2C+followed+by+the+Galle+Fort.+In+Colombo%2C+take+a+city+tour+to+end+your+Sri+Lanka+exploration.%22%3Bi%3A2%3Bs%3A209%3A%22After+breakfast%2C+transfer+back+to+Colombo%2C+visiting+Hambantota+Salterns+and+the+Stilt+Fisherman+at+Weligama+en+route%2C+followed+by+the+Galle+Fort.+In+Colombo%2C+take+a+city+tour+to+end+your+Sri+Lanka+exploration.%22%3B%7D%7D%7D',preset_text_fields = 'a%3A3%3A%7Bi%3A0%3Ba%3A3%3A%7Bs%3A5%3A%22label%22%3Bs%3A18%3A%22Terms+%26+conditions%22%3Bs%3A11%3A%22description%22%3Bs%3A690%3A%22%3Cdiv%3E%3Cul%3E%3Cli%3EValid+for+Economy+class+return+air+fares+purchased+online+at+macktrip.com%3C%2Fli%3E%3Cli%3EFares+mentioned+above+are+including+of+taxes+and+surcharges+and+are+subject+to+change+without+prior+notice%3C%2Fli%3E%3Cli%3EFares+mentioned+above+are+subject+to+availability%3C%2Fli%3E%3Cli%3EPassengers+will+be+charged+the+applicable+penalties+for+any+changes%3C%2Fli%3E%3Cli%3EPassengers+need+to+obtain+relevant+Visas%2C+other+authorizations+and+documents+required+for+travel%3C%2Fli%3E%3Cli%3EStandard+terms+and+conditions+and+fare+rules+will+continue+to+apply%3C%2Fli%3E%3Cli%3EMacktrip+reserves+the+right+to+withdraw+all+or+any+of+the+rules+applicable+to+the+above+offer+at+any+time+at+its+sole+discretion+without+prior+notice%3C%2Fli%3E%3C%2Ful%3E%3C%2Fdiv%3E%22%3Bs%3A2%3A%22id%22%3Bs%3A1%3A%221%22%3B%7Di%3A1%3Ba%3A3%3A%7Bs%3A5%3A%22label%22%3Bs%3A7%3A%22Exclude%22%3Bs%3A11%3A%22description%22%3Bs%3A209%3A%22After+breakfast%2C+transfer+back+to+Colombo%2C+visiting+Hambantota+Salterns+and+the+Stilt+Fisherman+at+Weligama+en+route%2C+followed+by+the+Galle+Fort.+In+Colombo%2C+take+a+city+tour+to+end+your+Sri+Lanka+exploration.%22%3Bs%3A2%3A%22id%22%3Bs%3A1%3A%223%22%3B%7Di%3A2%3Ba%3A3%3A%7Bs%3A5%3A%22label%22%3Bs%3A8%3A%22Includes%22%3Bs%3A11%3A%22description%22%3Bs%3A209%3A%22After+breakfast%2C+transfer+back+to+Colombo%2C+visiting+Hambantota+Salterns+and+the+Stilt+Fisherman+at+Weligama+en+route%2C+followed+by+the+Galle+Fort.+In+Colombo%2C+take+a+city+tour+to+end+your+Sri+Lanka+exploration.%22%3Bs%3A2%3A%22id%22%3Bs%3A1%3A%222%22%3B%7D%7D',quotation_unique_code = 'QTECHCA002217',created_by = 'tfg',created_at = '2020-07-25 11:14:20';
[07/25/2020 11:15:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1595675704','60.254.42.8');
[07/25/2020 11:15:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1595675726','60.254.42.8');
[07/25/2020 11:17:19], [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-07-25 11:17:19', '', '', '');
[07/25/2020 11:17:47], [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-07-25 11:17:47', '', '', '');
[07/25/2020 11:18:16], [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-07-25 11:18:16', '', '', '');
[07/25/2020 11:18:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO bookings SET agent_id = '22' , service_type = 'hotel' , reservation_id = '1669' , display_currency_code = 'USD' , created_datetime='2020-07-25 11:18:36' , create_date='2020-07-25 11:18:36' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg', city_id='Bentota', country_id='132', leader_title='Ms', leader_first_name='Snehal', leader_last_name='Test', nationality='Indian', site_id='0', supplier_profile_id='4', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='1', service_type_detail='Ramada Qtech Test_newTest(Do not Book)';
[07/25/2020 11:18:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='2782'
        ;
[07/25/2020 11:18:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into bookings_details set booking_id ='2782' , hotel_id='53704' , hotel_name='Ramada Qtech Test_newTest(Do not Book)' , hotel_address1='Test Address Mumbai, India, Maharashtra' , hotel_phone='+605 - 1234 5677' , hotel_rating='4.0';
[07/25/2020 11:18:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO bookings SET agent_id = '22' , service_type = 'hotel' , reservation_id = '1669' , display_currency_code = 'USD' , created_datetime='2020-07-25 11:18:48' , create_date='2020-07-25 11:18:48' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg', city_id='Bentota', country_id='132', leader_title='Ms', leader_first_name='Snehal', leader_last_name='Test', nationality='Indian', site_id='0', supplier_profile_id='4', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='1', service_type_detail='Ramada Qtech Test_newTest(Do not Book)';
[07/25/2020 11:18:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='2783'
        ;
[07/25/2020 11:18:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into bookings_details set booking_id ='2783' , hotel_id='53704' , hotel_name='Ramada Qtech Test_newTest(Do not Book)' , hotel_address1='Test Address Mumbai, India, Maharashtra' , hotel_phone='+605 - 1234 5677' , hotel_rating='4.0';

[07/25/2020 11:21:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25' , cal_hashcode='47652'25'ab9'25'97d152b556a829c3be8fa3417c66e1e7fa6dcebf8'25'f487662'25'9'25'9d' ,cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ? and site_id = ''25'';
[07/25/2020 11:21:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into email_logs SET `subject`= 'Registration Acknowledgement - Agent ID - 25 The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 20420 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftwrae.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/agent.php?branch_search=&consultant_search=&agent_type_search=&country_srch=&agency_name_search=&username_search=&status_search=&person_name_search=&search=&country_search=&city_search=&currency_search=&rate_profile_search=&email_search=&agency_id_search=',create_date= '2020-07-25 11:21:55';
[07/25/2020 11:22:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-25 11:22:06',login_attempt=0 where id = '25';
[07/25/2020 11:22:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-07-25 11:22:06', ip = '60.254.42.8', action = 'Login' ;
[07/25/2020 11:23:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'QtechPvt',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '0',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '1000',credit_limit= '1000',credit_distribution= '0',temp_credit_limit= '',address= 'MUmbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-10',enable_dst= '',branch_id='1',phone= '12-123456789',mobile= '12-22333134345345',fax= '',currency= '6',email= 'snehal.valanju@qtechsoftwrae.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '',allow_book_under_cancellation='0',modify_date='2020-07-25 11:23:05',consultant_id= 'SalesConsultant',agency_email= '',acc_name= 'A',acc_email= 'snehal.valanju@qtechsoftware.com',acc_phone= '',man_name= 'B',man_email= '',man_phone= '',res_name= 'C',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '5',can_show_hotels= '' WHERE id= '25';
[07/25/2020 11:23:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-25 11:23:05',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;QtechPvt\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;123\&#039;,auto_voucher_bookings = \&#039;0\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Snehal\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Valanju\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;1000\&#039;,credit_limit= \&#039;1000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;MUmbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-10\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;12-123456789\&#039;,mobile= \&#039;12-22333134345345\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;snehal.valanju@qtechsoftwrae.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= 0,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= ,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2020-07-25 11:23:05\&#039;,consultant_id= \&#039;SalesConsultant\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;A\&#039;,acc_email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;B\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;C\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;5\&#039;,can_show_hotels= 0 WHERE id= \&#039;25\&#039;',`log_description`= 'Agent 25 updated For  - modify_date=0000-00-00+00%3A00%3A00 changed to - modify_date=2020-07-25+11%3A23%3A05',`ip`= '60.254.42.8';
[07/25/2020 11:23:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3369', `entity`='Agents', `value`='25' ;
[07/25/2020 11:23:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[07/25/2020 11:23:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '1000.000',credit_usage= '0.000',credit_limit= '1000',receipt_id= '',amount= '',ip='60.254.42.8',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-07-25 11:07:05';
[07/25/2020 11:23:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'SalesConsultant',sales_manager_id= '',profile= '', auto_voucher_bookings = '0', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[07/25/2020 11:23:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[07/25/2020 11:23:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '1' ,status = '1' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[07/25/2020 11:23:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '6' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[07/25/2020 11:23:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '3' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[07/25/2020 11:23:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '2' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[07/25/2020 11:23:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '4' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[07/25/2020 11:23:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '5' ,status = '' ,priority = '' ,branch_id = '',percentage = '',visible_supplier_on_voucher = '0',lead_time = '';
[07/25/2020 11:23:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-25 11:23:22',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 1 ,status = \&#039;1\&#039; ,priority = \&#039;\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 6 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 3 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 2 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 4 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 5 ,status = \&#039;\&#039; ,priority = \&#039;\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;\&#039;',`log_description`= 'Supplier setting updated  ',`ip`= '60.254.42.8';
[07/25/2020 11:23:22], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3370', `entity`='Agents', `value`='25' ;
[07/25/2020 11:23:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-25 11:23:28',login_attempt=0 where id = '25';
[07/25/2020 11:23:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-07-25 11:23:28', ip = '60.254.42.8', action = 'Login' ;
[07/25/2020 11:23:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.42.8' , city = 'bentota' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/25' , departure_date = '2020/07/26' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-07-25 11:23:41' , site_id = '' , country_code = '132' , web_service = '' ;
[07/25/2020 11:23:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.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-07-25 11:23:45', '', '27ba9905a4e4aee042f1337a0cffc713c1f96c1d1ae609a4b2a30be88de2ce75', '349');
[07/25/2020 11:23:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=27ba9905a4e4aee042f1337a0cffc713c1f96c1d1ae609a4b2a30be88de2ce75&xml_user_id=25&request_no=0&local_hotel_code=100&#039;,&#039;53704&#039;,&#039;53707&web_service=no&site_id='
, http_hit_time = '2020-07-25 11:23:44.405'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.606'
, error_description = ''
, memory_used = '7941752'
WHERE id = '2924';
[07/25/2020 11:23:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=27ba9905a4e4aee042f1337a0cffc713c1f96c1d1ae609a4b2a30be88de2ce75',
  duration = '1.933',
  merge_duration = '0.006',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.73',
  system_load_5_min = '0.95',
  system_load_15_min = '1.15',
  system_memory_usage = '90.56',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '349') + '8147856',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '349';
[07/25/2020 11:24:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'QtechPvt',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '0',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '1000',credit_limit= '1000',credit_distribution= '0',temp_credit_limit= '',address= 'MUmbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-10',enable_dst= '',branch_id='1',phone= '12-123456789',mobile= '12-22333134345345',fax= '',currency= '6',email= 'snehal.valanju@qtechsoftwrae.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '',allow_book_under_cancellation='0',modify_date='2020-07-25 11:24:16',consultant_id= 'SalesConsultant',agency_email= '',acc_name= 'A',acc_email= 'snehal.valanju@qtechsoftware.com',acc_phone= '',man_name= 'B',man_email= '',man_phone= '',res_name= 'C',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '5',can_show_hotels= '' WHERE id= '25';
[07/25/2020 11:24:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-25 11:24:16',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;QtechPvt\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;123\&#039;,auto_voucher_bookings = \&#039;0\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Snehal\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Valanju\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;1000\&#039;,credit_limit= \&#039;1000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;MUmbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-10\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;12-123456789\&#039;,mobile= \&#039;12-22333134345345\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;snehal.valanju@qtechsoftwrae.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= 0,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= ,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2020-07-25 11:24:16\&#039;,consultant_id= \&#039;SalesConsultant\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;A\&#039;,acc_email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;B\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;C\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;5\&#039;,can_show_hotels= 0 WHERE id= \&#039;25\&#039;',`log_description`= 'Agent 25 updated For  - modify_date=2020-07-25+11%3A23%3A05 changed to - modify_date=2020-07-25+11%3A24%3A16',`ip`= '60.254.42.8';
[07/25/2020 11:24:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3371', `entity`='Agents', `value`='25' ;
[07/25/2020 11:24:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[07/25/2020 11:24:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '1000.000',credit_usage= '0.000',credit_limit= '1000',receipt_id= '',amount= '',ip='60.254.42.8',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-07-25 11:07:16';
[07/25/2020 11:24:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'SalesConsultant',sales_manager_id= '',profile= '', auto_voucher_bookings = '0', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[07/25/2020 11:24:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'QtechPvt',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '0',outstanding_limit = '0',accounting_name= '',first_name= 'Snehal',middle_name= '',last_name= 'Valanju',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '1000',credit_limit= '1000',credit_distribution= '0',temp_credit_limit= '',address= 'MUmbai',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '-10',enable_dst= '',branch_id='1',phone= '12-123456789',mobile= '12-22333134345345',fax= '',currency= '6',email= 'snehal.valanju@qtechsoftwrae.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '1',can_voucher= '',allow_book_under_cancellation='0',modify_date='2020-07-25 11:24:56',consultant_id= 'SalesConsultant',agency_email= '',acc_name= 'A',acc_email= 'snehal.valanju@qtechsoftware.com',acc_phone= '',man_name= 'B',man_email= '',man_phone= '',res_name= 'C',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '5',can_show_hotels= '' WHERE id= '25';
[07/25/2020 11:24:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-25 11:24:56',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= \&#039;QtechPvt\&#039;,other_language_agency_name= \&#039;\&#039;,accounting_id= \&#039;123\&#039;,auto_voucher_bookings = \&#039;0\&#039;,outstanding_limit = \&#039;0\&#039;,accounting_name= \&#039;\&#039;,first_name= \&#039;Snehal\&#039;,middle_name= \&#039;\&#039;,last_name= \&#039;Valanju\&#039;,agent_type= \&#039;CC\&#039;,sort_type= \&#039;price\&#039;,credit_limit_assigned= \&#039;1000\&#039;,credit_limit= \&#039;1000\&#039;,credit_distribution= \&#039;0\&#039;,temp_credit_limit= \&#039;\&#039;,address= \&#039;MUmbai\&#039;,other_language_address= \&#039;\&#039;,city= \&#039;64440\&#039;,pincode= \&#039;\&#039;,country= \&#039;106\&#039;,time_zone_offset= \&#039;-10\&#039;,enable_dst= 0,branch_id=\&#039;1\&#039;,phone= \&#039;12-123456789\&#039;,mobile= \&#039;12-22333134345345\&#039;,fax= \&#039;\&#039;,currency= \&#039;6\&#039;,email= \&#039;snehal.valanju@qtechsoftwrae.com\&#039;,website= \&#039;\&#039;,lead_time= 0,search_by_multicurrency= 1,debug= 0,profile= \&#039;\&#039;,designation= \&#039;\&#039;,iata_status= \&#039;0\&#039;,iata_number= \&#039;\&#039;,nature_of_business= \&#039;0\&#039;,can_book= \&#039;1\&#039;,sales_manager_id= \&#039;\&#039;,comp_reg_no= \&#039;\&#039;,allow_quotation= \&#039;1\&#039;,can_voucher= ,allow_book_under_cancellation=\&#039;0\&#039;,modify_date=\&#039;2020-07-25 11:24:56\&#039;,consultant_id= \&#039;SalesConsultant\&#039;,agency_email= \&#039;\&#039;,acc_name= \&#039;A\&#039;,acc_email= \&#039;snehal.valanju@qtechsoftware.com\&#039;,acc_phone= \&#039;\&#039;,man_name= \&#039;B\&#039;,man_email= \&#039;\&#039;,man_phone= \&#039;\&#039;,res_name= \&#039;C\&#039;,res_email= \&#039;\&#039;,res_phone= \&#039;\&#039;,remarks= \&#039;\&#039;,apply_service_tax= \&#039;no\&#039;,allow_ticketing= 0,agent_category= \&#039;5\&#039;,can_show_hotels= 0 WHERE id= \&#039;25\&#039;',`log_description`= 'Agent 25 updated For  - modify_date=2020-07-25+11%3A24%3A16 changed to - modify_date=2020-07-25+11%3A24%3A56',`ip`= '60.254.42.8';
[07/25/2020 11:24:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3372', `entity`='Agents', `value`='25' ;
[07/25/2020 11:24:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'25' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[07/25/2020 11:24:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '25',credit_value= '1000.000',credit_usage= '0.000',credit_limit= '1000',receipt_id= '',amount= '',ip='60.254.42.8',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2020-07-25 11:07:56';
[07/25/2020 11:24:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '6',branch_id= '1',consultant_id= 'SalesConsultant',sales_manager_id= '',profile= '', auto_voucher_bookings = '0', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '25';
[07/25/2020 11:25:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET credit_option = 'on_voucher_date', no_of_days= '' WHERE id= '25' ;
[07/25/2020 11:25:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-25 11:25:29',`log_type`= 'Credit Setting',`sql_query`= 'UPDATE agents SET credit_option = \&#039;on_voucher_date\&#039;, no_of_days= 0 WHERE id= \&#039;25\&#039; ',`log_description`= 'Credit Setting is updated',`ip`= '60.254.42.8';
[07/25/2020 11:25:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3373', `entity`='Agents', `value`='25' ;
[07/25/2020 11:25:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET credit_option = 'service_date', no_of_days= '' WHERE id= '25' ;
[07/25/2020 11:25:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-25 11:25:37',`log_type`= 'Credit Setting',`sql_query`= 'UPDATE agents SET credit_option = \&#039;service_date\&#039;, no_of_days= 0 WHERE id= \&#039;25\&#039; ',`log_description`= 'Credit Setting is updated',`ip`= '60.254.42.8';
[07/25/2020 11:25:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3374', `entity`='Agents', `value`='25' ;
[07/25/2020 11:25:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET credit_option = 'service_date', no_of_days= '' WHERE id= '25' ;
[07/25/2020 11:25:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-25 11:25:58',`log_type`= 'Credit Setting',`sql_query`= 'UPDATE agents SET credit_option = \&#039;service_date\&#039;, no_of_days= 0 WHERE id= \&#039;25\&#039; ',`log_description`= 'Credit Setting is updated',`ip`= '60.254.42.8';
[07/25/2020 11:25:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3375', `entity`='Agents', `value`='25' ;
[07/25/2020 11:27:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO customers SET salutations='Ms',first_name='Snehal', last_name='Test', email='',address='', mobile='', create_date='2020-07-25 11:27:20';;
[07/25/2020 11:27:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO enquiry SET agent_id = '25', contact_salutation = 'Ms', contact_first_name = 'Snehal', contact_last_name = 'Test', contact_name = 'Snehal Test', residing_country = '106', currency = 'USD', enquiry_source = 'direct', destination = '132', nationality = '106', customer_id = '64', created_by = 'tfg', create_date= '2020-07-25 11:27:20';
[07/25/2020 11:27:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO task SET module_id='370',module='enquiry',task_status='open',status='A',create_date='2020-07-25 11:27:20' ,created_by='tfg', task_priority='medium', task_description='Offline Quotation Enquiry has been added by tfg&lt;br/&gt;Agent : QtechPvt[CD0025-PhpTest][Snehal-Valanju]&lt;br/&gt;Country : Sri Lanka&lt;br/&gt;Selected Currency : USD&lt;br/&gt;';
[07/25/2020 11:27:53], [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-07-25 11:27:53', '', '', '');
[07/25/2020 11:28:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 370;
[07/25/2020 11:28:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation_sequence SET agent_id='25', sequence_no='1';
[07/25/2020 11:28:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'QTECHCD00251',backoffice_user = 'tfg',create_date = '2020-07-25 11:28:51',currency ='USD',service_date='2020-08-05 00:00:00',service_checkout_date='2020-08-06 00:00:00',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-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D',sequence='2',agent_id = '25',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1297296000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2205%2F08%2F2020+--+06%2F08%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A4%3A%22name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2219.16%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A7%3A%221000.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22983%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A28%3A%22Eli+Kunji+-+Double+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A29%3A%22Eli+Kunji+-+Double%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A18%3A%22Eli+Kunji+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.83%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2224.98%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%221000%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A14%3A%2224.98369210698%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2224.98%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.278698%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2299.730656%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A0%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271129%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A243%3A%22http%3A%2F%2Fuat.tfg.otrams.net%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2219.16%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A7%3A%221000.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22983%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A28%3A%22Eli+Kunji+-+Double+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A29%3A%22Eli+Kunji+-+Double%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A18%3A%22Eli+Kunji+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.83%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2224.98%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%221000%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A14%3A%2224.98369210698%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2224.98%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53704',city_name ='Bentota',city_code ='71129',country_code ='132',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name ='Snehal Test',salutation ='Ms',first_name ='Snehal',last_name ='Test',quotation_type ='back_end',enquiry_id ='370',total_price ='19.16',per_night ='19.16',room_type ='Eli Kunji - Double(Room Only)',room_rate ='19.16';
[07/25/2020 11:28:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1767', q_name='', service='hotel', agent_id='25', create_date='2020-07-25 11:28:51', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1297296000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2205%2F08%2F2020+--+06%2F08%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A4%3A%22name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2219.16%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A7%3A%221000.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22983%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A28%3A%22Eli+Kunji+-+Double+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A29%3A%22Eli+Kunji+-+Double%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A18%3A%22Eli+Kunji+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.83%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2224.98%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%221000%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A14%3A%2224.98369210698%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2224.98%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.278698%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2299.730656%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A0%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271129%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A243%3A%22http%3A%2F%2Fuat.tfg.otrams.net%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2219.16%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A7%3A%221000.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22983%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A28%3A%22Eli+Kunji+-+Double+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A29%3A%22Eli+Kunji+-+Double%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A18%3A%22Eli+Kunji+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.83%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2224.98%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%221000%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A14%3A%2224.98369210698%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2224.98%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Bentota', hotel_id='53704', additional_markup='0', cancelltion_policy='', per_night='19.16', total_price='19.16', room_type='Eli Kunji - Double(Room Only)', room_rate='19.16', currency='USD', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-07-25 11:28:51', status='A', is_visible='1', is_optional='0', unique_id='QTECHCD00251', service_date='2020-08-05 00:00:00', service_checkout_date='2020-08-06 00:00:00', city_code='71129', country_code='132', nationality='106', total_adult=NULL, total_child='0', child_age='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D', leader_name='Snehal Test', salutation='Ms', first_name='Snehal', last_name='Test', email='', contact_no='', enquiry_id='370', quotation_status='edited', sequence='2', 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-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D';
[07/25/2020 11:28:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1767', service_id='53704', service_type='hotel',service_date='2020-08-05', sequence='2';
[07/25/2020 11:28:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1767', service_date='2020-08-05';
[07/25/2020 11:28:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1767', service_id='53704', service_type='hotel',service_date='2020-08-06', sequence='2';
[07/25/2020 11:28:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1767', service_date='2020-08-06';
[07/25/2020 11:28:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCD00251' AND quotation_status!='booked';
[07/25/2020 11:29:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 370;
[07/25/2020 11:29:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1767', q_name='', service='hotel', agent_id='25', create_date='2020-07-25 11:29:05', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1297296000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2205%2F08%2F2020+--+06%2F08%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A4%3A%22name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2219.16%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A7%3A%221000.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22983%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A28%3A%22Eli+Kunji+-+Double+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A29%3A%22Eli+Kunji+-+Double%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A18%3A%22Eli+Kunji+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.83%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2224.98%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%221000%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A14%3A%2224.98369210698%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2224.98%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.278698%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2299.730656%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A0%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271129%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A243%3A%22http%3A%2F%2Fuat.tfg.otrams.net%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2219.16%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A7%3A%221000.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22983%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A28%3A%22Eli+Kunji+-+Double+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A29%3A%22Eli+Kunji+-+Double%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A18%3A%22Eli+Kunji+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.83%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2224.98%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%221000%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A14%3A%2224.98369210698%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2224.98%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Bentota', hotel_id='53704', additional_markup='0', cancelltion_policy='', per_night='19.16', total_price='19.16', room_type='Eli Kunji - Double(Room Only)', room_rate='19.16', currency='USD', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-07-25 11:29:05', status='A', is_visible='1', is_optional='0', unique_id='QTECHCD00251', service_date='2020-08-05 00:00:00', service_checkout_date='2020-08-06 00:00:00', city_code='71129', country_code='132', nationality='106', total_adult=NULL, total_child='0', child_age='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D', leader_name='Snehal Test', salutation='Ms', first_name='Snehal', last_name='Test', email='', contact_no='', enquiry_id='370', quotation_status='edited', sequence='2', 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-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D';
[07/25/2020 11:29:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'QTECHCD00251',modified_by = 'tfg',modified_date = '2020-07-25 11:29:05',currency ='USD',service_date='2020-08-05 00:00:00',service_checkout_date='2020-08-06 00:00:00',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-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D',sequence='2',agent_id = '25',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1297296000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2205%2F08%2F2020+--+06%2F08%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A4%3A%22name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2219.16%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A7%3A%221000.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22983%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A28%3A%22Eli+Kunji+-+Double+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A29%3A%22Eli+Kunji+-+Double%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A18%3A%22Eli+Kunji+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.83%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2224.98%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%221000%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A14%3A%2224.98369210698%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2224.98%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A8%3A%22latitude%22%3Bs%3A8%3A%226.278698%22%3Bs%3A9%3A%22longitude%22%3Bs%3A9%3A%2299.730656%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A0%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271129%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A22%3A%22TEST+HOTEL+DESCRIPTION%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A243%3A%22http%3A%2F%2Fuat.tfg.otrams.net%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cDovL3VhdC50Zmcub3RyYW1zLm5ldC9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A7%3A%221000.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2219.16%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-08-05%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A7%3A%221000.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2215.33%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2225%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A26%3A%22supplier_commission_amount%22%3BN%3Bs%3A6%3A%22profit%22%3BN%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22available%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2219.16%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A7%3A%221000.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bi%3A1%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22983%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%224%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A9%3A%22room_type%22%3Bs%3A28%3A%22Eli+Kunji+-+Double+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A29%3A%22Eli+Kunji+-+Double%28Room+Only%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A18%3A%22Eli+Kunji+-+Double%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E151%7E%7E%7E983%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%2224.98369210697978%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.83%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2224.98%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A5%3A%2219.16%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A4%3A%221000%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A14%3A%2224.98369210698%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253704----------S000000078%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A39%3A%22Test+Address+Mumbai%2C+India%2C+Maharashtra%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000078%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2224.98%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53704',city_name ='Bentota',city_code ='71129',country_code ='132',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name ='Snehal Test',salutation ='Ms',first_name ='Snehal',last_name ='Test',quotation_type ='back_end',enquiry_id ='370',total_price ='19.16',per_night ='19.16',room_type ='Eli Kunji - Double(Room Only)',room_rate ='19.16' WHERE q_id='1767';
[07/25/2020 11:29:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCD00251' AND quotation_status!='booked';
[07/25/2020 11:29:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET quotation_status='responded' WHERE unique_id IN ('QTECHCD00251') AND agent_id='25' AND quotation_status!='booked';
[07/25/2020 11:29:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= 'Registration Acknowledgement - Agent ID - 25 The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 20420 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,snehal.valanju@qtechsoftwrae.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=agent_registration_email&agent_id=25',create_date= '2020-07-25 11:29:14';
[07/25/2020 11:29:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into email_logs SET `subject`= 'Login Details - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 15784 characters]',to_email_id= 'snehal.valanju@qtechsoftwrae.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/resend_email.php?action=agent_confirmation_email&agent_id=25',create_date= '2020-07-25 11:29:49';
[07/25/2020 11:31:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_message.php],insert into email_logs SET `subject`= 'Message Acknowledgment - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 4712 characters]',to_email_id= 'otramsmessages@thefabulousgetaway.com',cc= 'ankita.rao@qtechsofware.com',bcc= '',status= 'Success',page_url= '/tms/add_message.php',create_date= '2020-07-25 11:31:14';
