[05/31/2022 06:00:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 412;
[05/31/2022 06:00:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1917', q_name='', service='hotel', agent_id='21', create_date='2022-05-31 06:00:44', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1988928000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2227%2F07%2F2021+--+29%2F07%2F2021%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%222%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%220.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%3A2%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3B%7Di%3A1%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2222.40%22%3B%7Di%3A1%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2222.40%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A2%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2222.40%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%22INR%22%3B%7Di%3A1%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2222.40%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%22INR%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%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2244.80%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A5%3A%2240.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%7E%7E%7E4%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+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%3A18%3A%2211.999999999999993%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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%221.51%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2211.999999999999993%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.29%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%2244.8%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A2%3A%2240%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%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%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%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A3%3A%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%221.51%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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%3A285%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%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%3A2%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3B%7Di%3A1%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A5%3A%2220.00%22%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A2%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2222.40%22%3B%7Di%3A1%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A5%3A%2222.40%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A2%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2222.40%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%22INR%22%3B%7Di%3A1%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2222.40%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%22INR%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%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2244.80%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A5%3A%2240.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%7E%7E%7E4%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+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%3A18%3A%2211.999999999999993%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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%221.51%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2211.999999999999993%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%223.29%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%2244.8%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A2%3A%2240%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%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%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%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A3%3A%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%221.51%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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='', supplier_cancellation_policy=NULL, per_night='22.40', total_price='44.80', room_type='Whole Villa - Single', room_rate='44.80', currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2022-05-31 06:00:44', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021191', service_date='2021-07-27 00:00:00', service_checkout_date='2021-07-29 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=' ', salutation='Ms', first_name='', last_name='', email='', contact_no='', enquiry_id='412', quotation_status='edited', sequence='2', rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2222.40%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%22INR%22%3B%7Di%3A1%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2222.40%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%22INR%22%3B%7D%7D%7D%7D';
[05/31/2022 06:00:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'RDTCD0021191',modified_by = 'tfg',modified_date = '2022-05-31 06:00:44',currency ='INR',service_date='2022-10-12 00:00:00',service_checkout_date='2022-10-13 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%222022-10-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2222.40%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%22INR%22%3B%7D%7D%7D%7D',sequence='2',agent_id = '21',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1523664000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2212%2F10%2F2022+--+13%2F10%2F2022%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%220.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%3A5%3A%2220.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A5%3A%2220.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%2222.40%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%222022-10-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2222.40%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%22INR%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%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2222.40%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A5%3A%2220.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%7E%7E%7E4%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+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%3A18%3A%2211.999999999999993%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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.76%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2211.999999999999993%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%221.64%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%2222.4%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A2%3A%2220%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%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%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%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A3%3A%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.76%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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%3A285%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2F%2Fcpfv3%2Fimages%2F%3Fimage%3DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%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%3A5%3A%2220.00%22%3Bs%3A17%3A%22nativeNightlyRate%22%3Bs%3A5%3A%2220.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%2222.40%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%222022-10-12%22%3Bs%3A13%3A%22supplier_rate%22%3Bs%3A5%3A%2220.00%22%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%2220.00%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3BN%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A5%3A%2222.40%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%22INR%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%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A5%3A%2222.40%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A5%3A%2220.00%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%7E%7E%7E4%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%22991%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%3A30%3A%22Whole+Villa+-+Single+Room+Only%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22single%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3Bs%3A13%3A%22room_category%22%3Bs%3A20%3A%22Whole+Villa+-+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%3A18%3A%2211.999999999999993%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%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.76%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A18%3A%2211.999999999999993%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A4%3A%221.64%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%228.21%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%2222.4%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A2%3A%2220%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%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%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%3A1%3A%224%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A12%3A%22Transfer+Tax%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A3%3A%223.5%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.76%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A4%3A%228.21%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 =' ',salutation ='Ms',first_name ='',last_name ='',quotation_type ='back_end',total_adult ='1',enquiry_id ='412',total_price ='22.4',per_night ='22.4',room_type ='Whole Villa - Single',room_rate ='22.40' WHERE q_id='1917';
[05/31/2022 06:00:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1917', service_id='53704', service_type='hotel',service_date='2022-10-12', sequence='2';
[05/31/2022 06:00:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1917', service_date='2022-10-12';
[05/31/2022 06:00:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1917', service_id='53704', service_type='hotel',service_date='2022-10-13', sequence='2';
[05/31/2022 06:00:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1917', service_date='2022-10-13';
[05/31/2022 06:00:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='RDTCD0021191' AND quotation_status!='booked';
[05/31/2022 06:00:56], [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 ('RDTCD0021191') AND agent_id='21' AND quotation_status!='booked';
[05/31/2022 06:00:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE quotation_tags SET tags='romance,romanticdrive,welcometohell,mommylove,helloworld' WHERE unique_id='RDTCD0021191';
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_request_logs SET quotation_id='RDTCD0021191', request_detail='a%3A27%3A%7Bs%3A6%3A%22action%22%3Bs%3A22%3A%22insertQuotationService%22%3Bs%3A14%3A%22bookingSession%22%3Bs%3A32%3A%224203ed6e20e8dcde9be036a1c71cfd21%22%3Bs%3A17%3A%22agent_suggest_box%22%3Bs%3A41%3A%22Qtech_Ankita+%5BCD0021-ankita%5D+%5BAnkita-Rao%5D%22%3Bs%3A12%3A%22search_agent%22%3Bs%3A2%3A%2221%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A23%3A%22total_quotation_to_book%22%3Bs%3A1%3A%221%22%3Bs%3A37%3A%22quotation_booking_unique_session_code%22%3Bs%3A32%3A%224203ed6e20e8dcde9be036a1c71cfd21%22%3Bs%3A14%3A%22quotation_name%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A12%3A%22RDTCD0021191%22%3Bs%3A11%3A%22ServiceDate%22%3Bs%3A10%3A%2228-07-2021%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A11%3A%22selCurrency%22%3Bs%3A3%3A%22INR%22%3Bs%3A15%3A%22sel_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A13%3A%22reservationId%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22tags_suggest_box%22%3Ba%3A5%3A%7Bi%3A0%3Bs%3A7%3A%22romance%22%3Bi%3A1%3Bs%3A13%3A%22romanticdrive%22%3Bi%3A2%3Bs%3A13%3A%22welcometohell%22%3Bi%3A3%3Bs%3A9%3A%22mommylove%22%3Bi%3A4%3Bs%3A10%3A%22helloworld%22%3B%7Ds%3A19%3A%22sel_hotel_quotation%22%3Bs%3A4%3A%221917%22%3Bs%3A20%3A%22enableInventoryCheck%22%3Bs%3A4%3A%22true%22%3Bs%3A10%3A%22salutation%22%3Bs%3A2%3A%22Ms%22%3Bs%3A10%3A%22first_name%22%3Bs%3A6%3A%22+Altaf%22%3Bs%3A9%3A%22last_name%22%3Bs%3A6%3A%22Tester%22%3Bs%3A18%3A%22countryOfResidence%22%3Bs%3A3%3A%22106%22%3Bs%3A12%3A%22BookingNotes%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22customerAddress%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22bookquotation%22%3Ba%3A1%3A%7Bs%3A5%3A%22hotel%22%3Ba%3A1%3A%7Bs%3A23%3A%2212-10-2022%5E%3A%5E13-10-2022%22%3Ba%3A1%3A%7Bi%3A53704%3Ba%3A1%3A%7Bi%3A0%3Ba%3A44%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253704%22%3Bs%3A12%3A%22service_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2212-10-2022%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2213-10-2022%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221917%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271129%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Bentota%22%3Bs%3A10%3A%22country_id%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A14%3A%22nationality_id%22%3Bs%3A3%3A%22106%22%3Bs%3A11%3A%22nationality%22%3Bs%3A6%3A%22Indian%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A22%3A%22rate_description_field%22%3Bs%3A456%3A%22%255B%255B%257B%2522date%2522%253A%25222022-10-12%2522%252C%2522supplier_rate%2522%253A%252220.00%2522%252C%2522supplier_rate_in_agent_currency%2522%253A%252220.00%2522%252C%2522applied_markup%2522%253A%252212%2522%252C%2522applied_markup_amount%2522%253Anull%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%252222.40%2522%252C%2522supplier_commission%2522%253Anull%252C%2522supplier_commission_amount%2522%253Anull%252C%2522profit%2522%253Anull%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22bookingDetails%22%3Bs%3A2583%3A%22%257B%2522quotation_id%2522%253A%25221917%2522%252C%2522name%2522%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%252C%2522id%2522%253A%252253704%2522%252C%2522city_id%2522%253A%252271129%2522%252C%2522city_name%2522%253A%2522Bentota%2522%252C%2522country_id%2522%253A%2522132%2522%252C%2522country_name%2522%253A%2522Sri%2BLanka%2522%252C%2522nationality_id%2522%253A%2522106%2522%252C%2522nationality%2522%253A%2522Indian%2522%252C%2522room_category_id%2522%253A%2522991%2522%252C%2522room_details%2522%253A%255B%257B%2522display_currency_code%2522%253A%2522INR%2522%252C%2522native_currency_code%2522%253A%2522INR%2522%252C%2522displayRoomTypeRates%2522%253A%252222.40%2522%252C%2522nativeRoomTypeRates%2522%253A%252220.00%2522%252C%2522applied_markup%2522%253A%252212%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522room_type_id%2522%253A%25221%2522%252C%2522room_category_id%2522%253A%2522991%2522%252C%2522room_basis_id%2522%253A%25224%2522%252C%2522room_type%2522%253A%2522single%2522%252C%2522inventory_room_class%2522%253A%2522Whole%2BVilla%2522%252C%2522room_category_text%2522%253A%2522Whole%2BVilla%2B-%2BSingle%2522%252C%2522meal_basis_text%2522%253A%2522Room%2BOnly%2522%252C%2522room_type_code%2522%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%252C%2522number_of_room%2522%253A%25221%2522%252C%2522total_adults%2522%253A1%252C%2522total_child%2522%253A0%252C%2522total_pax%2522%253A1%252C%2522child_age%2522%253A%2522%2522%257D%255D%252C%2522currency_id%2522%253A%2522INR%2522%252C%2522supplier_id%2522%253A%2522S000000078%2522%252C%2522native_room_rate%2522%253A%252220%2522%252C%2522total_native_rate%2522%253A%252220%2522%252C%2522number_of_room%2522%253A1%252C%2522native_currency_code%2522%253A%2522INR%2522%252C%2522display_currency_code%2522%253A%2522INR%2522%252C%2522display_room_rate%2522%253A%252222.4%2522%252C%2522total_agent_rate%2522%253A%252222.4%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522applied_markup%2522%253A11.999999999999993%252C%2522checkindate%2522%253A%252212-10-2022%2522%252C%2522checkoutdate%2522%253A%252213-10-2022%2522%252C%2522total_adults%2522%253A1%252C%2522total_child%2522%253A0%252C%2522rate_description_field%2522%253A%2522%25255B%25255B%25257B%252522date%252522%25253A%2525222022-10-12%252522%25252C%252522supplier_rate%252522%25253A%25252220.00%252522%25252C%252522supplier_rate_in_agent_currency%252522%25253A%25252220.00%252522%25252C%252522applied_markup%252522%25253A%25252212%252522%25252C%252522applied_markup_amount%252522%25253Anull%25252C%252522applied_multiplier%252522%25253A%2525221.00000%252522%25252C%252522agent_rate%252522%25253A%25252222.40%252522%25252C%252522supplier_commission%252522%25253Anull%25252C%252522supplier_commission_amount%252522%25253Anull%25252C%252522profit%252522%25253Anull%25252C%252522supplier_currency%252522%25253A%252522INR%252522%25252C%252522agent_currency%252522%25253A%252522INR%252522%25257D%25255D%25255D%2522%252C%2522user_description%2522%253A%2522%2522%252C%2522special_remark%2522%253A%2522%2522%252C%2522cancellation_policy_response%2522%253A%2522%2522%252C%2522sequence%2522%253A%25222%2522%252C%2522sourcetype%2522%253A%2522localsystem%2522%252C%2522booking_status%2522%253A%2522confirmed%2522%257D%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Room+Only%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22Whole+Villa%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22991%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%224%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A5%3A%22Altaf%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Tester%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A2%3A%2220%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A2%3A%2220%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A4%3A%2222.4%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A4%3A%2222.4%22%3Bs%3A11%3A%22supplierFoc%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22agentFoc%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%222%22%3B%7D%7D%7D%7D%7Ds%3A19%3A%22total_package_adult%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22total_package_child%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22total_selling_price%22%3Bs%3A4%3A%2222.4%22%3B%7D', create_date='2022-05-31 06:02:06';
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1653976926','103.104.226.130');
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO bookings SET agent_id = '21' , service_type = 'hotel' , reservation_id = '1986' , display_currency_code = 'INR' , created_datetime='2022-05-31 06:02:06' , create_date='2022-05-31 06:02:06' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg' , itenirary_id = '2' , sequence = '2', city_id='Bentota', country_id='132', leader_title='Ms', leader_first_name=' Altaf', leader_last_name='Tester', nationality='Indian', site_id='0', supplier_profile_id='1', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='3', service_type_detail='Ramada Qtech Test_newTest(Do not Book)', country_of_residence='106';
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '3'
        WHERE
        id='3160'
        ;
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into bookings_details set booking_id ='3160' , hotel_id='53704' , hotel_name='Ramada Qtech Test_newTest(Do not Book)' , hotel_address1='' , hotel_phone='' , hotel_rating='0.0';
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_room_detail set booking_id = '3160', booking_detail_id = '1260', room_type_code = '1~~~154~~~991~~~4~~~~~~~~~71129~~~0~~~S000000078', room_name = 'single', meal_basis = 'Room Only', room_category = 'Whole Villa', room_type_description = 'Whole Villa - Room Only', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:22.4;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:5:"20.00";}}' ,native_room_rate_total = '20' ,display_room_rate_total = '22.4' ,number_of_rooms = '1';
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE bookings SET confirmation_number='',itenirary_id ='2',sequence ='2',voucher_id='',voucher_hashcode='',native_currency_code='INR',cancellation_policy='',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='12',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1.00000',current_status='confirmed',status_date='2022-05-31 06:02:06',service_date='2022-10-12',check_out_date='2022-10-13',display_room_rate= '22.4',display_discount='',native_room_rate= '20',native_discount='',additional_charge='0',expiration_date= '2022-05-31 00:00:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3160';
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings set  parent_agent_id='21', sub_agent_rate='', agent_rate='22.4', applicable_service_tax='', agent_markup='12', supplier_rate='20' where id='3160';
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings_details set total_nights='1',supplier_id= 'S000000078',arrival_date='2022/10/12',departure_date='2022/10/13',rate_code='~',total_rooms= '1',total_adults= '1',total_children= '0',total_infants= '0' where booking_id ='3160';
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3160','confirmed','2022-05-31 06:02:06','confirmed by tfg','tfg','103.104.226.130','tfg','','');
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO passangers (booking_id,booking_detail_id,rid,room,salutations,first_name,last_name,passenger_type,age) values ('3160','1260','1867','0','Ms','Altaf','Tester','adult','');
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3160', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223160%22%3Bs%3A12%3A%22post_details%22%3Ba%3A46%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253704%22%3Bs%3A12%3A%22service_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2212-10-2022%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2213-10-2022%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221917%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271129%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Bentota%22%3Bs%3A10%3A%22country_id%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A14%3A%22nationality_id%22%3Bs%3A3%3A%22106%22%3Bs%3A11%3A%22nationality%22%3Bs%3A6%3A%22Indian%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A22%3A%22rate_description_field%22%3Bs%3A456%3A%22%255B%255B%257B%2522date%2522%253A%25222022-10-12%2522%252C%2522supplier_rate%2522%253A%252220.00%2522%252C%2522supplier_rate_in_agent_currency%2522%253A%252220.00%2522%252C%2522applied_markup%2522%253A%252212%2522%252C%2522applied_markup_amount%2522%253Anull%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%252222.40%2522%252C%2522supplier_commission%2522%253Anull%252C%2522supplier_commission_amount%2522%253Anull%252C%2522profit%2522%253Anull%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22bookingDetails%22%3Bs%3A2583%3A%22%257B%2522quotation_id%2522%253A%25221917%2522%252C%2522name%2522%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%252C%2522id%2522%253A%252253704%2522%252C%2522city_id%2522%253A%252271129%2522%252C%2522city_name%2522%253A%2522Bentota%2522%252C%2522country_id%2522%253A%2522132%2522%252C%2522country_name%2522%253A%2522Sri%2BLanka%2522%252C%2522nationality_id%2522%253A%2522106%2522%252C%2522nationality%2522%253A%2522Indian%2522%252C%2522room_category_id%2522%253A%2522991%2522%252C%2522room_details%2522%253A%255B%257B%2522display_currency_code%2522%253A%2522INR%2522%252C%2522native_currency_code%2522%253A%2522INR%2522%252C%2522displayRoomTypeRates%2522%253A%252222.40%2522%252C%2522nativeRoomTypeRates%2522%253A%252220.00%2522%252C%2522applied_markup%2522%253A%252212%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522room_type_id%2522%253A%25221%2522%252C%2522room_category_id%2522%253A%2522991%2522%252C%2522room_basis_id%2522%253A%25224%2522%252C%2522room_type%2522%253A%2522single%2522%252C%2522inventory_room_class%2522%253A%2522Whole%2BVilla%2522%252C%2522room_category_text%2522%253A%2522Whole%2BVilla%2B-%2BSingle%2522%252C%2522meal_basis_text%2522%253A%2522Room%2BOnly%2522%252C%2522room_type_code%2522%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%252C%2522number_of_room%2522%253A%25221%2522%252C%2522total_adults%2522%253A1%252C%2522total_child%2522%253A0%252C%2522total_pax%2522%253A1%252C%2522child_age%2522%253A%2522%2522%257D%255D%252C%2522currency_id%2522%253A%2522INR%2522%252C%2522supplier_id%2522%253A%2522S000000078%2522%252C%2522native_room_rate%2522%253A%252220%2522%252C%2522total_native_rate%2522%253A%252220%2522%252C%2522number_of_room%2522%253A1%252C%2522native_currency_code%2522%253A%2522INR%2522%252C%2522display_currency_code%2522%253A%2522INR%2522%252C%2522display_room_rate%2522%253A%252222.4%2522%252C%2522total_agent_rate%2522%253A%252222.4%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522applied_markup%2522%253A11.999999999999993%252C%2522checkindate%2522%253A%252212-10-2022%2522%252C%2522checkoutdate%2522%253A%252213-10-2022%2522%252C%2522total_adults%2522%253A1%252C%2522total_child%2522%253A0%252C%2522rate_description_field%2522%253A%2522%25255B%25255B%25257B%252522date%252522%25253A%2525222022-10-12%252522%25252C%252522supplier_rate%252522%25253A%25252220.00%252522%25252C%252522supplier_rate_in_agent_currency%252522%25253A%25252220.00%252522%25252C%252522applied_markup%252522%25253A%25252212%252522%25252C%252522applied_markup_amount%252522%25253Anull%25252C%252522applied_multiplier%252522%25253A%2525221.00000%252522%25252C%252522agent_rate%252522%25253A%25252222.40%252522%25252C%252522supplier_commission%252522%25253Anull%25252C%252522supplier_commission_amount%252522%25253Anull%25252C%252522profit%252522%25253Anull%25252C%252522supplier_currency%252522%25253A%252522INR%252522%25252C%252522agent_currency%252522%25253A%252522INR%252522%25257D%25255D%25255D%2522%252C%2522user_description%2522%253A%2522%2522%252C%2522special_remark%2522%253A%2522%2522%252C%2522cancellation_policy_response%2522%253A%2522%2522%252C%2522sequence%2522%253A%25222%2522%252C%2522sourcetype%2522%253A%2522localsystem%2522%252C%2522booking_status%2522%253A%2522confirmed%2522%257D%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Room+Only%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22Whole+Villa%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22991%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%224%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A5%3A%22Altaf%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Tester%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A2%3A%2220%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A2%3A%2220%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A4%3A%2222.4%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A4%3A%2222.4%22%3Bs%3A11%3A%22supplierFoc%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22agentFoc%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22quotation_info%22%3Bs%3A11377%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1523664000%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252212%252F10%252F2022%2B--%2B13%252F10%252F2022%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253704%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253704%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25220.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A5%253A%252220.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A5%253A%252222.40%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222022-10-12%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A5%253A%252222.40%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A5%253A%252222.40%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522991%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A9%253A%2522Room%2BOnly%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A30%253A%2522Whole%2BVilla%2B-%2BSingle%2BRoom%2BOnly%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A18%253A%252211.999999999999993%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.76%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A18%253A%252211.999999999999993%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25221.64%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25228.21%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%252222.4%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A2%253A%252220%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253704----------S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25223.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.76%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25228.21%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A8%253A%25226.278698%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A9%253A%252299.730656%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A1%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271129%2522%253Bs%253A16%253A%2522selected_country%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A20%253A%2522selected_nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A20%253A%2522selected_country_res%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A22%253A%2522TEST%2BHOTEL%2BDESCRIPTION%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A285%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A5%253A%252220.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A5%253A%252222.40%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222022-10-12%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A5%253A%252222.40%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A5%253A%252222.40%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522991%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A9%253A%2522Room%2BOnly%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A30%253A%2522Whole%2BVilla%2B-%2BSingle%2BRoom%2BOnly%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A18%253A%252211.999999999999993%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.76%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A18%253A%252211.999999999999993%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25221.64%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25228.21%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%252222.4%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A2%253A%252220%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253704----------S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25223.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.76%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25228.21%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3Bs%3A18%3A%22inventory_class_id%22%3Bs%3A5%3A%22%27154%27%22%3B%7Ds%3A15%3A%22request_details%22%3Ba%3A72%3A%7Bs%3A13%3A%22check_in_date%22%3Bs%3A10%3A%2212-10-2022%22%3Bs%3A14%3A%22check_out_date%22%3Bs%3A10%3A%222022-10-13%22%3Bs%3A11%3A%22action_name%22%3Bs%3A10%3A%22add_sector%22%3Bs%3A11%3A%22total_night%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22agent_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2221%22%3Bs%3A17%3A%22agent_selected_id%22%3Bs%3A2%3A%2221%22%3Bs%3A17%3A%22total_native_rate%22%3Bs%3A2%3A%2220%22%3Bs%3A18%3A%22total_display_rate%22%3Bs%3A4%3A%2222.4%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A24%3A%22sel_country_of_residence%22%3Bs%3A3%3A%22106%22%3Bs%3A8%3A%22sel_city%22%3Bs%3A5%3A%2271129%22%3Bs%3A10%3A%22sel_hotels%22%3Bs%3A5%3A%2253704%22%3Bs%3A11%3A%22hotel_phone%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A11%3A%22arrive_date%22%3Bs%3A10%3A%2212-10-2022%22%3Bs%3A11%3A%22depart_date%22%3Bs%3A10%3A%2213-10-2022%22%3Bs%3A19%3A%22confirmation_number%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22sel_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A15%3A%22sel_salutations%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A14%3A%22sel_first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22+Altaf%22%3B%7Ds%3A13%3A%22sel_last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Tester%22%3B%7Ds%3A14%3A%22leader_address%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22rdSupplierType%22%3Bs%3A1%3A%22L%22%3Bs%3A12%3A%22sel_supplier%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A20%3A%22sel_supplierProfileL%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22sel_currencies_online%22%3Bs%3A3%3A%22INR%22%3Bs%3A21%3A%22display_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A22%3A%22supplier_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A25%3A%22agent_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22txt_agent_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A23%3A%22basecurrency_multiplier%22%3Bd%3A0.01533%3Bs%3A30%3A%22basecurrency_multiplier_native%22%3Bd%3A0.01533%3Bs%3A10%3A%22txt_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A12%3A%22room_type_id%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22total_pax%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22room_type%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A13%3A%22single_room_1%22%3B%7Ds%3A25%3A%22single_room_1_description%22%3Bs%3A11%3A%22Whole+Villa%22%3Bs%3A18%3A%22single_room_1_code%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A24%3A%22single_room_1_room_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A29%3A%22single_room_1_room_basis_desc%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A29%3A%22single_room_1_number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22single_room_1_native_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A5%3A%2220.00%22%3B%7Ds%3A40%3A%22single_room_1_native_supplier_commission%22%3BN%3Bs%3A47%3A%22single_room_1_native_supplier_commission_amount%22%3BN%3Bs%3A26%3A%22single_room_1_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A22.4%3B%7Ds%3A30%3A%22single_room_1_sub_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A22.4%3B%7Ds%3A29%3A%22single_room_1_wh_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A22.4%3B%7Ds%3A15%3A%22native_discount%22%3Bi%3A0%3Bs%3A16%3A%22display_discount%22%3Bi%3A0%3Bs%3A17%3A%22additional_charge%22%3Bs%3A1%3A%220%22%3Bs%3A15%3A%22expiration_date%22%3Bs%3A19%3A%2231%2F05%2F2022+00%3A00%3A00%22%3Bs%3A19%3A%22cancellation_policy%22%3Bs%3A0%3A%22%22%3Bs%3A28%3A%22supplier_cancellation_policy%22%3Bs%3A0%3A%22%22%3Bs%3A6%3A%22remark%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22special_comment%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22supplier_type%22%3Bs%3A7%3A%22offline%22%3Bs%3A14%3A%22reservation_id%22%3Bs%3A4%3A%221986%22%3Bs%3A12%3A%22leader_phone%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22email_id%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22sequence%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%222%22%3Bs%3A20%3A%22is_quote_fit_booking%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22fetch_booking_details%22%3Bb%3A1%3Bs%3A28%3A%22strip_room_class_description%22%3Bb%3A1%3Bs%3A9%3A%22free_sale%22%3Bs%3A2%3A%22no%22%3B%7Ds%3A17%3A%22quotation_details%22%3Bs%3A11377%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1523664000%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252212%252F10%252F2022%2B--%2B13%252F10%252F2022%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253704%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253704%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25220.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A5%253A%252220.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A5%253A%252222.40%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222022-10-12%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A5%253A%252222.40%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A5%253A%252222.40%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522991%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A9%253A%2522Room%2BOnly%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A30%253A%2522Whole%2BVilla%2B-%2BSingle%2BRoom%2BOnly%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A18%253A%252211.999999999999993%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.76%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A18%253A%252211.999999999999993%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25221.64%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25228.21%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%252222.4%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A2%253A%252220%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253704----------S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25223.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.76%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25228.21%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A8%253A%25226.278698%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A9%253A%252299.730656%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A1%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271129%2522%253Bs%253A16%253A%2522selected_country%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A20%253A%2522selected_nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A20%253A%2522selected_country_res%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A22%253A%2522TEST%2BHOTEL%2BDESCRIPTION%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A285%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A5%253A%252220.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A5%253A%252222.40%2522%253B%257D%257D%257Ds%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222022-10-12%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A5%253A%252222.40%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A5%253A%252222.40%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A5%253A%252220.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522991%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A9%253A%2522Room%2BOnly%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A30%253A%2522Whole%2BVilla%2B-%2BSingle%2BRoom%2BOnly%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A18%253A%252211.999999999999993%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.76%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A18%253A%252211.999999999999993%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25221.64%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25228.21%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%252222.4%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A2%253A%252220%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253704----------S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25223.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.76%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25228.21%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7D', create_date='2022-05-31 06:02:06';;
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3160','confirmed','2022-05-31 06:02:06','Quotation Id - RDTCD0021191 created on behalf of Agent - Ankita Rao(21) by tfg','tfg','103.104.226.130','tfg','','');
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3160','confirmed','2022-05-31 06:02:06','Enquiry Id - 412 created on behalf of Agent - Ankita Rao(21) by tfg','tfg','103.104.226.130','tfg','','');
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='booked' where unique_id='RDTCD0021191';
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3160',q_id='RDTCD0021191',enquiry_id='412',quote_id='1917',backoffice_user='tfg',agent_id='21',create_date='2022-05-31 06:02:06',booked_from='agent_quote_itemized';
[05/31/2022 06:02:06], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO tags_booking SET reservationId='RDT2022051986', tags ='romance,romanticdrive,welcometohell,mommylove,helloworld',backoffice_user ='tfg',create_date ='2022-05-31 06:02:06';
[05/31/2022 06:10:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3160','snehal.valanju@qtechsoftware.com');
[05/31/2022 06:10:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3160','ankita.rao@qtechsoftware.com');
[05/31/2022 06:17:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET agency_name= 'Qtech',other_language_agency_name= '',accounting_id= '123',auto_voucher_bookings = '0',outstanding_limit = '0',accounting_name= '',first_name= 'Altaf',middle_name= '',last_name= 'Shaikh',agent_type= 'CC',sort_type= 'price',credit_limit_assigned= '10000',credit_limit= '10000',credit_distribution= '0',temp_credit_limit= '',address= 'test',other_language_address= '',city= '64440',pincode= '',country= '106',time_zone_offset= '5.5',enable_dst= '',branch_id='1',phone= '91-9999999999',mobile= '91-9999999999',fax= '',currency= '4',email= 'altaf.shaikh@qtechsoftware.com',website= '',lead_time= '',search_by_multicurrency= '1',debug= '1',profile= '',designation= '',iata_status= '0',iata_number= '',nature_of_business= '0',can_book= '1',sales_manager_id= '',comp_reg_no= '',allow_quotation= '',can_voucher= '1',allow_book_under_cancellation='1',modify_date='2022-05-31 06:17:37',consultant_id= 'nitinalpha',agency_email= '',acc_name= 'ALTAF',acc_email= 'altaf.shaikh@qtechsoftware.com',acc_phone= '',man_name= 'QTECH',man_email= '',man_phone= '',res_name= 'QTECH',res_email= '',res_phone= '',remarks= '',apply_service_tax= 'no',allow_ticketing= '',agent_category= '2',can_show_hotels= '',logo='1653977857download.jpeg' WHERE id= '28';
[05/31/2022 06:17:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2022-05-31 06:17:37',`log_type`= 'Agent Updated',`sql_query`= 'UPDATE agents SET agency_name= :agency_name,other_language_agency_name= :other_language_agency_name,accounting_id= :accounting_id,auto_voucher_bookings = :auto_voucher_bookings,outstanding_limit = :outstanding_limit,accounting_name= :accounting_name,first_name= :first_name,middle_name= :middle_name,last_name= :last_name,agent_type= :agent_type,sort_type= :sort_type,credit_limit_assigned= :credit_limit_assigned,credit_limit= :credit_limit,credit_distribution= :credit_distribution,temp_credit_limit= :temp_credit_limit,address= :address,other_language_address= :other_language_address,city= :city,pincode= :pincode,country= :country,time_zone_offset= :time_zone_offset,enable_dst= :enable_dst,branch_id=\&#039;1\&#039;,phone= :phone,mobile= :mobile,fax= :fax,currency= :currency,email= :email,website= :website,lead_time= :lead_time,search_by_multicurrency= :search_by_multicurrency,debug= :debug,profile= :profile,designation= :designation,iata_status= :iata_status,iata_number= :iata_number,nature_of_business= :nature_of_business,can_book= :can_book,sales_manager_id= :sales_manager_id,comp_reg_no= :comp_reg_no,allow_quotation= :allow_quotation,can_voucher= :can_voucher,allow_book_under_cancellation=\&#039;1\&#039;,modify_date=\&#039;2022-05-31 06:17:37\&#039;,consultant_id= :consultant_id,agency_email= :agency_email,acc_name= :acc_name,acc_email= :acc_email,acc_phone= :acc_phone,man_name= :man_name,man_email= :man_email,man_phone= :man_phone,res_name= :res_name,res_email= :res_email,res_phone= :res_phone,remarks= :remarks,apply_service_tax= :apply_service_tax,allow_ticketing= :allow_ticketing,agent_category= :agent_category,can_show_hotels= :can_show_hotels,logo=\&#039;1653977857download.jpeg\&#039; WHERE id= :id',`log_description`= 'Agent 28 updated For  - logo=&modify_date=2022-05-05+10%3A23%3A18 changed to - logo=1653977857download.jpeg&modify_date=2022-05-31+06%3A17%3A37',`ip`= '103.104.226.130';
[05/31/2022 06:17:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='4204', `entity`='Agents', `value`='28' ;
[05/31/2022 06:17:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET cd_credit_limit=credit_limit-'28' , cd_credit_value=cd_credit_limit-cd_credit_usage WHERE id= ?;
[05/31/2022 06:17:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into  agent_credit_log SET agent_id= '28',credit_value= '7360.000',credit_usage= '2640.000',credit_limit= '10000',receipt_id= '',amount= '',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Edit_Agent',note='Agent Edited by tfg',create_date='2022-05-31 06:05:37';
[05/31/2022 06:17:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],UPDATE agents SET currency= '4',branch_id= '1',consultant_id= 'nitinalpha',sales_manager_id= '',profile= '', auto_voucher_bookings = '0', outstanding_limit = '0', agent_type= 'CC' WHERE parent_agent= '28';
[05/31/2022 06:17:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_booking.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1653977872','103.104.226.130');
[05/31/2022 06:18:21], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1653977901','103.104.226.130');
[05/31/2022 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO bookings SET agent_id = '28' , service_type = 'hotel' , reservation_id = '1988' , display_currency_code = 'INR' , created_datetime='2022-05-31 06:20:17' , create_date='2022-05-31 06:20:17' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg', city_id='Mumbai', country_id='106', leader_title='Mr', leader_first_name='Altaf', leader_last_name='Tester', nationality='Indian', site_id='0', supplier_profile_id='1', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='1', service_type_detail=' Fab Hotel Crawford Inn South Mumbai';
[05/31/2022 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3161'
        ;
[05/31/2022 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into bookings_details set booking_id ='3161' , hotel_id='47832' , hotel_name=' Fab Hotel Crawford Inn South Mumbai' , hotel_address1='' , hotel_phone='' , hotel_rating='';
[05/31/2022 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3161', booking_detail_id = '1261', room_type_code = '', room_name = 'single', meal_basis = '', room_category = 'Single', room_type_description = 'Single', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";s:3:"600";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:2:"10";}}' ,native_room_rate_total = '10' ,display_room_rate_total = '600' ,number_of_rooms = '1';
[05/31/2022 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3161', booking_detail_id = '1261', salutations = 'Mr', room = '', rid = '1868', first_name = 'Altaf', last_name = 'Tester' ,age = '';
[05/31/2022 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='1112',voucher_id='',voucher_hashcode='',native_currency_code='USD',cancellation_policy='Cancellation or charges made on/after 10-07-2022 will be subject to FULL CHARGE.',supplier_cancellation_policy='',applied_multiplier='60',applied_markup='0',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1',current_status='confirmed',status_date='2022-05-31 06:20:17',service_date='2022-07-13',check_out_date='2022-07-14',display_room_rate= '600',display_discount='0',native_room_rate= '10',native_discount='0',additional_charge='',expiration_date= '2022-07-10 05:30:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3161';
[05/31/2022 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='28', sub_agent_rate='', agent_rate='600', applicable_service_tax='', agent_markup='0', supplier_rate='10' where id='3161';
[05/31/2022 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1',supplier_id= 'S000000037',arrival_date='2022/07/13',departure_date='2022/07/14',rate_code='~',total_rooms= '1',total_adults= '1',total_children= '0',total_infants= '0' where booking_id ='3161';
[05/31/2022 06:20:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3161','confirmed','2022-05-31 06:20:17','confirmed by tfg','tfg','103.104.226.130','tfg','','');
[05/31/2022 06:20:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2022-05-31 06:20:48',current_status='vouchered',voucher_hashcode='d1c214dfb087dda072d4d62a835781c6985433161',vouchered_by ='tfg' where id='3161';
[05/31/2022 06:20:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3161',config_key='VOUCHER_DATE', config_value='2022-05-31 06:20:48',create_date='2022-05-31 06:20:48';
[05/31/2022 06:20:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO autogenerator_invoice_number (id, number) VALUES ('','1653978048');
[05/31/2022 06:20:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2022/407' where id='3161' and is_invoiced!='yes';
[05/31/2022 06:20:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('600'),   credit_value= credit_value-('600') ,  cd_credit_usage=cd_credit_usage+('600') , cd_credit_value=cd_credit_value-('600')  WHERE id = '28';
[05/31/2022 06:20:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '28',credit_value= '6760.000',credit_usage= '3240.000',credit_limit= '10000',receipt_id= '',amount= '600',booking_id='3161',booking_cost= '600',receipt_allocation= '',balance= '600',ip='103.104.226.130',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2022-05-31 06:05:48';
[05/31/2022 06:20:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='USD',supplier_price='10',supplier_type='offline',supplier_id='S000000037',acc_type='purchase',accounting_multiplier='1.00000',booking_id='3161',booking_log='Booking Vouchered',type='Sale',create_date='2022-05-31 06:20:48',account_invoice='2022/407',particulars='';
[05/31/2022 06:20:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='600',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='3161',booking_log='Booking Vouchered',type='Sale',create_date='2022-05-31 06:20:48',account_invoice='2022/407',particulars='';
[05/31/2022 06:20:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1536;
[05/31/2022 06:20:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1536',booking_id= '3161',invoice_number= '2022/407',service_type= 'hotel',booking_type= 'offline',service_name= ' Fab Hotel Crawford Inn South Mumbai',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2022/07/13',to_date= '2022/07/14',quantity= '1',price= '600',total_price= '600';
[05/31/2022 06:20:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'The Fabulous Getaway Tax Dispute(TaxInvoice)',from_email_id= 'roma.banwani@qtechsoftware.com',body= 'Rm9yIEZvbGxvd2luZyBib29raW5nIFRheCBpcyBub3QgaW5zZXJ0ZWQ8YnI+Qm9va2luZ0lkOi0zMTYxPGJyPkludm9pY2Ugbm86LTIwMjIvNDA3PGJyPmJyYW5jaF9pZDotMTxicj5UeXBlOi1hZ2VudDxicj5BY2NvdW50IHR5cGU6LXNhbGU8YnI+',to_email_id= 'roma.banwani@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2022-05-31 06:20:49';
[05/31/2022 06:20:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php], insert into email_trigger set  subject ='The Fabulous Getaway Tax Dispute',  message='For Following booking Tax is not inserted<br>BookingId:-3161<br>Invoice no:-2022/407<br>branch_id:-1<br>Type:-agent<br>Account type:-sale<br>',  email_sent ='yes', create_date ='2022-05-31 06:20:49', email_sent_to ='roma.banwani@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='TaxInvoice';
[05/31/2022 06:20:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2022/407',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 26624 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,altaf.shaikh@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2022-05-31 06:20:50';
[05/31/2022 06:20:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3161','vouchered-invoiced','2022-05-31 06:20:50',' by tfg','tfg','103.104.226.130','tfg','','');
[05/31/2022 06:20:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3161',booking_detail_id ='3161',agent_id ='28',is_sub_agent ='N',parent_id ='',display_commission ='0',display_currency ='INR',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 0 %',create_date ='2022-05-31 06:20:50';
[05/31/2022 06:20:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3161',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[05/31/2022 06:20:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3161','vouchered','2022-05-31 06:20:50','Vouchered By tfg by tfg','tfg','103.104.226.130','tfg','','');
[05/31/2022 06:20:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG103161 /  Booking Vouchered ',from_email_id= 'roma.banwani@qtechsoftware.com',body= '[encoded data, 26736 characters]',to_email_id= 'altaf.shaikh@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2022-05-31 06:20:51';
[05/31/2022 06:20:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3161','altaf.shaikh@qtechsoftware.com');
[05/31/2022 06:20:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3161','ankita.rao@qtechsoftware.com');
[05/31/2022 06:25:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','altaf.shaikh@qtechsoftware.com');
[05/31/2022 06:25:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','ankita.rao@qtechsoftware.com');
[05/31/2022 06:26:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','maheshyohanjayasinghe@gmail.com');
[05/31/2022 06:26:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','maheshyohanjayasinghe@gmail.com');
[05/31/2022 06:26:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','maheshyohanjayasinghe@gmail.com');
[05/31/2022 06:26:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','altaf.shaikh@qtechsoftware.com');
[05/31/2022 06:26:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3161','ankita.rao@qtechsoftware.com');
