[11/02/2020 05:31:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-11-02 05:31:19', '', '', '');
[11/02/2020 05:31:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-11-02 05:31:38', '', '', '');
[11/02/2020 05:31:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-11-02 05:31:52', '', '', '');
[11/02/2020 05:32:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],DELETE FROM agent_supplier_settings WHERE 1  and agent_id= ? ;
[11/02/2020 05:32:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '1' ,status = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[11/02/2020 05:32:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '6' ,status = '' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[11/02/2020 05:32:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '3' ,status = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[11/02/2020 05:32:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '2' ,status = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[11/02/2020 05:32:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '4' ,status = '' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[11/02/2020 05:32:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],INSERT INTO agent_supplier_settings SET agent_id = '25',supplier_id = '5' ,status = '1' ,priority = '0.00' ,branch_id = '',percentage = '0.00',visible_supplier_on_voucher = '0',lead_time = '0';
[11/02/2020 05:32:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-11-02 05:32:29',`log_type`= 'Agent Supplier settings',`sql_query`= '======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 1 ,status = \&#039;1\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 6 ,status = \&#039;\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 3 ,status = \&#039;1\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 2 ,status = \&#039;1\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 4 ,status = \&#039;\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;======INSERT INTO agent_supplier_settings SET agent_id = \&#039;25\&#039;,supplier_id = 5 ,status = \&#039;1\&#039; ,priority = \&#039;0.00\&#039; ,branch_id = \&#039;\&#039;,percentage = \&#039;0.00\&#039;,visible_supplier_on_voucher = \&#039;0\&#039;,lead_time = \&#039;0\&#039;',`log_description`= 'Supplier setting updated  Previous data-- agent_id-25 ## supplier_id- 1 ## company_name - Contracted Hotels ## supplier_code-localsystem  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-25 ## supplier_id- 2 ## company_name - Contracted Sightseeing ## supplier_code-localsightseeing  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-25 ## supplier_id- 3 ## company_name - Contracted Transfer ## supplier_code-localtransfer  ## percentage - 0.00 ## lead_time - 0 ==&lt;br&gt;== agent_id-25 ## supplier_id- 5 ## company_name - Misc Services ## supplier_code-misc  ## percentage - 0.00 ## lead_time - 0 ',`ip`= '60.254.5.70';
[11/02/2020 05:32:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/agent.php],insert into user_log_link Set `user_logs_id`='3881', `entity`='Agents', `value`='25' ;
[11/02/2020 05:32:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-11-02 05:32:35',login_attempt=0 where id = '25';
[11/02/2020 05:32:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-11-02 05:32:35', ip = '60.254.5.70', action = 'Login' ;
[11/02/2020 05:32:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.5.70' , city = 'colombo' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/11/12' , departure_date = '2020/11/13' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-11-02 05:32:53' , site_id = '' , country_code = '132' , web_service = '' ;
[11/02/2020 05:32:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-11-02 05:32:56', '', 'a9262af8e708440d983dc55c02116316c41e4b34d6041aa4e026b684cfaf7c5f', '471');
[11/02/2020 05:32:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=a9262af8e708440d983dc55c02116316c41e4b34d6041aa4e026b684cfaf7c5f&xml_user_id=25&request_no=0&local_hotel_code=35&#039;,&#039;36&#039;,&#039;60&#039;,&#039;61&#039;,&#039;65&#039;,&#039;77&#039;,&#039;53699&#039;,&#039;53700&#039;,&#039;38&#039;,&#039;39&#039;,&#039;99&#039;,&#039;78&#039;,&#039;51821&#039;,&#039;76&#039;,&#039;51811&#039;,&#039;53701&#039;,&#039;51808&#039;,&#039;53725&#039;,&#039;53733&#039;,&#039;51817&#039;,&#039;53770&#039;,&#039;53777&web_service=no&site_id='
, http_hit_time = '2020-11-02 05:32:55.631'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.238'
, error_description = ''
, memory_used = '7909528'
WHERE id = '3251';
[11/02/2020 05:32:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=a9262af8e708440d983dc55c02116316c41e4b34d6041aa4e026b684cfaf7c5f',
  duration = '1.726',
  merge_duration = '0.075',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '1.17',
  system_load_5_min = '2.19',
  system_load_15_min = '1.91',
  system_memory_usage = '90.04',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '471') + '8043344',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '471';
[11/02/2020 05:33:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-11-02 05:33:29', '', '', '');
[11/02/2020 05:33:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 407;
[11/02/2020 05:33:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation SET q_name = 'RateGain',email='',contact_no='',unique_id = 'QTECHCD002510',backoffice_user = 'tfg',create_date = '2020-11-02 05:33:45',currency ='USD',service_date='2020-11-19 00:00:00',service_checkout_date='2020-11-20 00:00:00',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-19%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A100%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%221.533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.53%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D',sequence='2',agent_id = '25',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1747008000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2219%2F11%2F2020+--+20%2F11%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253701%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253701%22%3Bs%3A4%3A%22name%22%3Bs%3A13%3A%22QuotationTest%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A100%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A100%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%221.53%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-19%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A100%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%221.533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.53%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%221.53%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22100%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E111%7E%7E%7E617%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000070%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A7%3A%22Pooja+R%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22617%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A70%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A71%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A53%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E111%7E%7E%7E617%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000070%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.05%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%22-0.05%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%221.53%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22100%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253701----------S000000070%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A13%3A%22QuotationTest%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A8%3A%22SriLanka%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%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.05%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%22-3.57%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A8%3A%22SriLanka%22%3Bs%3A8%3A%22latitude%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22longitude%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%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%3Bi%3A100%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A100%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%221.53%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-19%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A100%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%221.533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.53%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%221.53%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22100%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E111%7E%7E%7E617%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000070%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A7%3A%22Pooja+R%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22617%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A70%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A71%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A53%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E111%7E%7E%7E617%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000070%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.05%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%22-0.05%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%221.53%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22100%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253701----------S000000070%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A13%3A%22QuotationTest%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A8%3A%22SriLanka%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%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.05%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%22-3.57%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53701',city_name ='Colombo',city_code ='71100',country_code ='132',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name ='Snehal Test',salutation ='Mrs',first_name ='Snehal',last_name ='Test',quotation_type ='back_end',total_adult ='2',enquiry_id ='407',total_price ='1.53',per_night ='1.53',room_type ='Luxury Tent (A/C) - Single, Max Pax - 4, Extrabed - 0 (Bed & Breakfast)',room_rate ='1.53';
[11/02/2020 05:33:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1901', q_name='RateGain', service='hotel', agent_id='25', create_date='2020-11-02 05:33:45', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1747008000%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2219%2F11%2F2020+--+20%2F11%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253701%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253701%22%3Bs%3A4%3A%22name%22%3Bs%3A13%3A%22QuotationTest%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%224.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A100%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A100%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%221.53%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-19%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A100%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%221.533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.53%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%221.53%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22100%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E111%7E%7E%7E617%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000070%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A7%3A%22Pooja+R%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22617%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A70%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A71%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A53%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E111%7E%7E%7E617%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000070%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.05%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%22-0.05%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%221.53%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22100%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253701----------S000000070%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A13%3A%22QuotationTest%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A8%3A%22SriLanka%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%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.05%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%22-3.57%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A8%3A%22SriLanka%22%3Bs%3A8%3A%22latitude%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22longitude%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22132%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22132%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%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%3Bi%3A100%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A100%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%221.53%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-19%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A100%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%221.533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.53%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%221.53%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22100%22%3Bs%3A7%3A%22room_id%22%3Bs%3A48%3A%222%7E%7E%7E111%7E%7E%7E617%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000070%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A7%3A%22Pooja+R%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A3%3A%22617%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A70%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A71%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A53%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A48%3A%222%7E%7E%7E111%7E%7E%7E617%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000070%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.05%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A5%3A%22-0.05%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A4%3A%220.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bi%3A0%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%221.53%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22100%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253701----------S000000070%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A13%3A%22QuotationTest%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A8%3A%22SriLanka%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000070%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.05%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%22-3.57%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Colombo', hotel_id='53701', additional_markup='0', cancelltion_policy='', per_night='1.53', total_price='1.53', room_type='Luxury Tent (A/C) - Single, Max Pax - 4, Extrabed - 0 (Bed & Breakfast)', room_rate='1.53', currency='USD', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-11-02 05:33:45', status='A', is_visible='1', is_optional='0', unique_id='QTECHCD002510', service_date='2020-11-19 00:00:00', service_checkout_date='2020-11-20 00:00:00', city_code='71100', country_code='132', nationality='106', total_adult='2', total_child='0', child_age='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D', leader_name='Snehal Test', salutation='Mrs', first_name='Snehal', last_name='Test', email='', contact_no='', enquiry_id='407', quotation_status='edited', sequence='2', rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-11-19%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A100%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A5%3A%221.533%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A1%3A%220%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%221.53%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A1%3A%220%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22INR%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22USD%22%3B%7D%7D%7D%7D';
[11/02/2020 05:33:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1901', service_id='53701', service_type='hotel',service_date='2020-11-19', sequence='2';
[11/02/2020 05:33:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1901', service_date='2020-11-19';
[11/02/2020 05:33:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1901', service_id='53701', service_type='hotel',service_date='2020-11-20', sequence='2';
[11/02/2020 05:33:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1901', service_date='2020-11-20';
[11/02/2020 05:33:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='QTECHCD002510' AND quotation_status!='booked';
[11/02/2020 05:34:02], [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 ('QTECHCD002510') AND agent_id='25' AND quotation_status!='booked';
[11/02/2020 05:36:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_request_logs SET quotation_id='QTECHCD002510', request_detail='a%3A25%3A%7Bs%3A6%3A%22action%22%3Bs%3A22%3A%22insertQuotationService%22%3Bs%3A14%3A%22bookingSession%22%3Bs%3A32%3A%22a7166c8c68d9f52cc7ac08463daaf3d7%22%3Bs%3A17%3A%22agent_suggest_box%22%3Bs%3A42%3A%22QtechPvt+%5BCD0025-PhpTest%5D+%5BSnehal-Valanju%5D%22%3Bs%3A12%3A%22search_agent%22%3Bs%3A2%3A%2225%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A23%3A%22total_quotation_to_book%22%3Bs%3A1%3A%222%22%3Bs%3A37%3A%22quotation_booking_unique_session_code%22%3Bs%3A32%3A%22a7166c8c68d9f52cc7ac08463daaf3d7%22%3Bs%3A14%3A%22quotation_name%22%3Bs%3A8%3A%22RateGain%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A13%3A%22QTECHCD002510%22%3Bs%3A11%3A%22ServiceDate%22%3Bs%3A10%3A%2201-11-2020%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A11%3A%22selCurrency%22%3Bs%3A3%3A%22USD%22%3Bs%3A15%3A%22sel_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A13%3A%22reservationId%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22sel_hotel_quotation%22%3Bs%3A4%3A%221901%22%3Bs%3A10%3A%22salutation%22%3Bs%3A3%3A%22Mrs%22%3Bs%3A10%3A%22first_name%22%3Bs%3A6%3A%22Snehal%22%3Bs%3A9%3A%22last_name%22%3Bs%3A4%3A%22Test%22%3Bs%3A18%3A%22countryOfResidence%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22BookingNotes%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22customerAddress%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22bookquotation%22%3Ba%3A1%3A%7Bs%3A5%3A%22hotel%22%3Ba%3A2%3A%7Bs%3A23%3A%2201-11-2020%5E%3A%5E02-11-2020%22%3Ba%3A1%3A%7Bi%3A53777%3Ba%3A1%3A%7Bi%3A0%3Ba%3A43%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253777%22%3Bs%3A12%3A%22service_name%22%3Bs%3A12%3A%22The+Heritage%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2201-11-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2202-11-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221900%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253777%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000243%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%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%3A455%3A%22%255B%255B%257B%2522date%2522%253A%25222020-11-01%2522%252C%2522supplier_rate%2522%253A100%252C%2522supplier_rate_in_agent_currency%2522%253A%2522100%2522%252C%2522applied_markup%2522%253A%25223%2522%252C%2522applied_markup_amount%2522%253A%25220%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%2522103%2522%252C%2522supplier_commission%2522%253A%25220%2522%252C%2522supplier_commission_amount%2522%253A%25220%2522%252C%2522profit%2522%253A%25223%2522%252C%2522supplier_currency%2522%253A%2522USD%2522%252C%2522agent_currency%2522%253A%2522USD%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%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A49%3A%22Standard+-+Double%2C+Extrabed+-+1+%28Bed+%26+Breakfast%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A15%3A%22Bed+%26+Breakfast%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%222%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%3A8%3A%22Standard%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%221049%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1049%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000243%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22double%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%3A3%3A%22Mrs%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Snehal%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Test%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A1%3A%223%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A3%3A%22103%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A3%3A%22103%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%7Ds%3A23%3A%2219-11-2020%5E%3A%5E20-11-2020%22%3Ba%3A1%3A%7Bi%3A53701%3Ba%3A1%3A%7Bi%3A0%3Ba%3A43%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253701%22%3Bs%3A12%3A%22service_name%22%3Bs%3A13%3A%22QuotationTest%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2219-11-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2220-11-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221901%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253701%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000070%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%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%3A458%3A%22%255B%255B%257B%2522date%2522%253A%25222020-11-19%2522%252C%2522supplier_rate%2522%253A100%252C%2522supplier_rate_in_agent_currency%2522%253A%25221.533%2522%252C%2522applied_markup%2522%253A%25220%2522%252C%2522applied_markup_amount%2522%253A%25220%2522%252C%2522applied_multiplier%2522%253A%25220.01533%2522%252C%2522agent_rate%2522%253A%25221.53%2522%252C%2522supplier_commission%2522%253A%25220%2522%252C%2522supplier_commission_amount%2522%253A%25220%2522%252C%2522profit%2522%253A%25220%2522%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522USD%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%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A71%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0+%28Bed+%26+Breakfast%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A15%3A%22Bed+%26+Breakfast%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%222%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%3A17%3A%22Luxury+Tent+%28A%2FC%29%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22617%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A48%3A%222%7E%7E%7E111%7E%7E%7E617%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000070%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22double%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%3A3%3A%22Mrs%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Snehal%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Test%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A4%3A%221.53%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A4%3A%221.53%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%222%22%3Bs%3A19%3A%22total_package_child%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22total_selling_price%22%3Bs%3A6%3A%22104.53%22%3B%7D', create_date='2020-11-02 05:36:33';
[11/02/2020 05:36:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1604295393','60.254.5.70');
[11/02/2020 05:36:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO bookings SET agent_id = '25' , service_type = 'hotel' , reservation_id = '1869' , display_currency_code = 'USD' , created_datetime='2020-11-02 05:36:33' , create_date='2020-11-02 05:36:33' , created_by ='tfg' , sales_manager_id ='otrams' , consultant_id = 'tfg' , backoffice_user = 'tfg' , itenirary_id = '2' , sequence = '2', city_id='Colombo', country_id='132', leader_title='Mrs', leader_first_name='Snehal', leader_last_name='Test', 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='The Heritage', country_of_residence='132';
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3054'
        ;
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into bookings_details set booking_id ='3054' , hotel_id='53777' , hotel_name='The Heritage' , hotel_address1='' , hotel_phone='' , hotel_rating='4.0';
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_room_detail set booking_id = '3054', booking_detail_id = '1192', room_type_code = '2~~~132~~~1049~~~1~~~~~~~~~71100~~~0~~~S000000243', room_name = 'double', meal_basis = 'Bed & Breakfast', room_category = 'Standard', room_type_description = 'Standard - Bed & Breakfast', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:103;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";i:100;}}' ,native_room_rate_total = '100' ,display_room_rate_total = '103' ,number_of_rooms = '1';
[11/02/2020 05:36:34], [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='USD',cancellation_policy='',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='3',consultant_id='tfg',basecurrency_multiplier='1',basecurrency_multiplier_native='1'_native,agent_currency_multiplier='1.00000',current_status='confirmed',status_date='2020-11-02 05:36:34',service_date='2020-11-01',check_out_date='2020-11-02',display_room_rate= '103',display_discount='',native_room_rate= '100',native_discount='',additional_charge='0',expiration_date= '2020-11-02 00:00:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3054';
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings set  parent_agent_id='25', sub_agent_rate='', agent_rate='103', applicable_service_tax='', agent_markup='3', supplier_rate='100' where id='3054';
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings_details set total_nights='1', supplier_id= 'S000000243',arrival_date='2020/11/01',departure_date='2020/11/02',rate_code='~', total_rooms= '1', total_adults= '2', total_children= '0', total_infants= '0' where booking_id ='3054';
[11/02/2020 05:36:34], [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
        ('','','3054','confirmed','2020-11-02 05:36:34','confirmed by tfg','tfg','60.254.5.70','tfg','','');
[11/02/2020 05:36:34], [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 ('3054','1192','1786','0','Mrs','Snehal','Test','adult',''),('3054','1192','1786','0','Mr','ToBeAdvisedB','ToBeAdvisedB','adult','');
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3054', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223054%22%3Bs%3A12%3A%22post_details%22%3Ba%3A45%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253777%22%3Bs%3A12%3A%22service_name%22%3Bs%3A12%3A%22The+Heritage%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2201-11-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2202-11-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221900%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253777%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000243%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%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%3A455%3A%22%255B%255B%257B%2522date%2522%253A%25222020-11-01%2522%252C%2522supplier_rate%2522%253A100%252C%2522supplier_rate_in_agent_currency%2522%253A%2522100%2522%252C%2522applied_markup%2522%253A%25223%2522%252C%2522applied_markup_amount%2522%253A%25220%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%2522103%2522%252C%2522supplier_commission%2522%253A%25220%2522%252C%2522supplier_commission_amount%2522%253A%25220%2522%252C%2522profit%2522%253A%25223%2522%252C%2522supplier_currency%2522%253A%2522USD%2522%252C%2522agent_currency%2522%253A%2522USD%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%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A49%3A%22Standard+-+Double%2C+Extrabed+-+1+%28Bed+%26+Breakfast%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A15%3A%22Bed+%26+Breakfast%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%222%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%3A8%3A%22Standard%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%221049%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1049%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000243%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22double%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%3A3%3A%22Mrs%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Snehal%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Test%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22USD%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A1%3A%223%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A3%3A%22103%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A3%3A%22103%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%3A10993%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1179014400%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252201%252F11%252F2020%2B--%2B02%252F11%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253777%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253777%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A12%253A%2522The%2BHeritage%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25224.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%253Bi%253A100%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A100%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A3%253A%2522103%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%25222020-11-01%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A100%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25223%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A1%253A%25223%2522%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522USD%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25221%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A49%253A%25222%257E%257E%257E132%257E%257E%257E1049%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000243%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A16%253A%2522RateGainSriLanka%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A4%253A%25221049%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A15%253A%2522Bed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A48%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%2B%2BBed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522double%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A49%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%2B%2528Bed%2B%2526%2BBreakfast%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A31%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%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%253A1%253A%25223%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A49%253A%25222%257E%257E%257E132%257E%257E%257E1049%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000243%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.00%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25223%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25223.00%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25223.00%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25223%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%252253777----------S000000243%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A12%253A%2522The%2BHeritage%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%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%253A0%253A%2522%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.00%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25223.00%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A2%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271100%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%2522132%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A99%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252Fproject_folder%252Ftfg_project%252Fimages%252Fimagenotavailable.jpg%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%253Bi%253A100%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A100%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A3%253A%2522103%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%25222020-11-01%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A100%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25223%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A1%253A%25223%2522%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522USD%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25221%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A49%253A%25222%257E%257E%257E132%257E%257E%257E1049%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000243%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A16%253A%2522RateGainSriLanka%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A4%253A%25221049%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A15%253A%2522Bed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A48%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%2B%2BBed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522double%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A49%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%2B%2528Bed%2B%2526%2BBreakfast%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A31%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%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%253A1%253A%25223%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A49%253A%25222%257E%257E%257E132%257E%257E%257E1049%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000243%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.00%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25223%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25223.00%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25223.00%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25223%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%252253777----------S000000243%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A12%253A%2522The%2BHeritage%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%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%253A0%253A%2522%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.00%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25223.00%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%27132%27%22%3B%7Ds%3A15%3A%22request_details%22%3Ba%3A71%3A%7Bs%3A13%3A%22check_in_date%22%3Bs%3A10%3A%2201-11-2020%22%3Bs%3A14%3A%22check_out_date%22%3Bs%3A10%3A%222020-11-02%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%22USD%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2225%22%3Bs%3A17%3A%22agent_selected_id%22%3Bs%3A2%3A%2225%22%3Bs%3A17%3A%22total_native_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A18%3A%22total_display_rate%22%3Bs%3A3%3A%22103%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A24%3A%22sel_country_of_residence%22%3Bs%3A3%3A%22132%22%3Bs%3A8%3A%22sel_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A10%3A%22sel_hotels%22%3Bs%3A5%3A%2253777%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%2201-11-2020%22%3Bs%3A11%3A%22depart_date%22%3Bs%3A10%3A%2202-11-2020%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%3A3%3A%22Mrs%22%3B%7Ds%3A14%3A%22sel_first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Snehal%22%3B%7Ds%3A13%3A%22sel_last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Test%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%22S000000243%22%3Bs%3A20%3A%22sel_supplierProfileL%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22sel_currencies_online%22%3Bs%3A3%3A%22USD%22%3Bs%3A21%3A%22display_currency_code%22%3Bs%3A3%3A%22USD%22%3Bs%3A22%3A%22supplier_currency_code%22%3Bs%3A3%3A%22USD%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%3A1%3A%223%22%3Bs%3A23%3A%22basecurrency_multiplier%22%3Bd%3A1%3Bs%3A30%3A%22basecurrency_multiplier_native%22%3Bd%3A1%3Bs%3A10%3A%22txt_markup%22%3Bs%3A1%3A%223%22%3Bs%3A12%3A%22room_type_id%22%3Bs%3A1%3A%222%22%3Bs%3A15%3A%22number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22total_pax%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22room_type%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A13%3A%22double_room_1%22%3B%7Ds%3A25%3A%22double_room_1_description%22%3Bs%3A8%3A%22Standard%22%3Bs%3A18%3A%22double_room_1_code%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1049%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000243%22%3Bs%3A24%3A%22double_room_1_room_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A29%3A%22double_room_1_room_basis_desc%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A29%3A%22double_room_1_number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22double_room_1_native_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bi%3A100%3B%7Ds%3A40%3A%22double_room_1_native_supplier_commission%22%3BN%3Bs%3A47%3A%22double_room_1_native_supplier_commission_amount%22%3BN%3Bs%3A26%3A%22double_room_1_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A103%3B%7Ds%3A30%3A%22double_room_1_sub_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A103%3B%7Ds%3A29%3A%22double_room_1_wh_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A103%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%2202%2F11%2F2020+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%221869%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%3B%7Ds%3A17%3A%22quotation_details%22%3Bs%3A10993%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1179014400%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252201%252F11%252F2020%2B--%2B02%252F11%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253777%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253777%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A12%253A%2522The%2BHeritage%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25224.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%253Bi%253A100%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A100%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A3%253A%2522103%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%25222020-11-01%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A100%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25223%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A1%253A%25223%2522%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522USD%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25221%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A49%253A%25222%257E%257E%257E132%257E%257E%257E1049%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000243%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A16%253A%2522RateGainSriLanka%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A4%253A%25221049%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A15%253A%2522Bed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A48%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%2B%2BBed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522double%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A49%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%2B%2528Bed%2B%2526%2BBreakfast%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A31%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%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%253A1%253A%25223%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A49%253A%25222%257E%257E%257E132%257E%257E%257E1049%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000243%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.00%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25223%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25223.00%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25223.00%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25223%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%252253777----------S000000243%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A12%253A%2522The%2BHeritage%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%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%253A0%253A%2522%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.00%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25223.00%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A2%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271100%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%2522132%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A99%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252Fproject_folder%252Ftfg_project%252Fimages%252Fimagenotavailable.jpg%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%253Bi%253A100%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A100%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A3%253A%2522103%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%25222020-11-01%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A100%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25223%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A1%253A%25223%2522%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522USD%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25221%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A49%253A%25222%257E%257E%257E132%257E%257E%257E1049%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000243%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A16%253A%2522RateGainSriLanka%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A4%253A%25221049%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A15%253A%2522Bed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A48%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%2B%2BBed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522double%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A49%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%2B%2528Bed%2B%2526%2BBreakfast%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A31%253A%2522Standard%2B-%2BDouble%252C%2BExtrabed%2B-%2B1%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%253A1%253A%25223%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A49%253A%25222%257E%257E%257E132%257E%257E%257E1049%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000243%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.00%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25223%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25223.00%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25223.00%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522103%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25223%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%252253777----------S000000243%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A12%253A%2522The%2BHeritage%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000243%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%253A0%253A%2522%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.00%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25223.00%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7D', create_date='2020-11-02 05:36:34';;
[11/02/2020 05:36:34], [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
        ('','','3054','confirmed','2020-11-02 05:36:34','Quotation Id - QTECHCD002510 created on behalf of Agent - Snehal Valanju(25) by tfg','tfg','60.254.5.70','tfg','','');
[11/02/2020 05:36:34], [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
        ('','','3054','confirmed','2020-11-02 05:36:34','Enquiry Id - 407 created on behalf of Agent - Snehal Valanju(25) by tfg','tfg','60.254.5.70','tfg','','');
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO bookings SET agent_id = '25' , service_type = 'hotel' , reservation_id = '1869' , display_currency_code = 'USD' , created_datetime='2020-11-02 05:36:34' , create_date='2020-11-02 05:36:34' , created_by ='tfg' , sales_manager_id ='otrams' , consultant_id = 'tfg' , backoffice_user = 'tfg' , itenirary_id = '2' , sequence = '2', city_id='Colombo', country_id='132', leader_title='Mrs', leader_first_name='Snehal', leader_last_name='Test', 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='QuotationTest', country_of_residence='132';
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3055'
        ;
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into bookings_details set booking_id ='3055' , hotel_id='53701' , hotel_name='QuotationTest' , hotel_address1='' , hotel_phone='' , hotel_rating='4.0';
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_room_detail set booking_id = '3055', booking_detail_id = '1193', room_type_code = '2~~~111~~~617~~~1~~~~~~~~~71100~~~0~~~S000000070', room_name = 'double', meal_basis = 'Bed & Breakfast', room_category = 'Luxury Tent (A/C)', room_type_description = 'Luxury Tent (A/C) - Bed & Breakfast', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:1.53;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";i:100;}}' ,native_room_rate_total = '100' ,display_room_rate_total = '1.53' ,number_of_rooms = '1';
[11/02/2020 05:36:34], [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='0.01533',applied_markup='-0.19569471624265',consultant_id='tfg',basecurrency_multiplier='1',basecurrency_multiplier_native='1'_native,agent_currency_multiplier='1.00000',current_status='confirmed',status_date='2020-11-02 05:36:34',service_date='2020-11-19',check_out_date='2020-11-20',display_room_rate= '1.53',display_discount='',native_room_rate= '100',native_discount='',additional_charge='0',expiration_date= '2020-11-02 00:00:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3055';
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings set  parent_agent_id='25', sub_agent_rate='', agent_rate='1.53', applicable_service_tax='', agent_markup='-0.19569471624265', supplier_rate='100' where id='3055';
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings_details set total_nights='1', supplier_id= 'S000000070',arrival_date='2020/11/19',departure_date='2020/11/20',rate_code='~', total_rooms= '1', total_adults= '2', total_children= '0', total_infants= '0' where booking_id ='3055';
[11/02/2020 05:36:34], [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
        ('','','3055','confirmed','2020-11-02 05:36:34','confirmed by tfg','tfg','60.254.5.70','tfg','','');
[11/02/2020 05:36:34], [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 ('3055','1193','1787','0','Mrs','Snehal','Test','adult',''),('3055','1193','1787','0','Mr','ToBeAdvisedB','ToBeAdvisedB','adult','');
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3055', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223055%22%3Bs%3A12%3A%22post_details%22%3Ba%3A45%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253701%22%3Bs%3A12%3A%22service_name%22%3Bs%3A13%3A%22QuotationTest%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2219-11-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2220-11-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221901%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253701%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000070%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271100%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Colombo%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%3A458%3A%22%255B%255B%257B%2522date%2522%253A%25222020-11-19%2522%252C%2522supplier_rate%2522%253A100%252C%2522supplier_rate_in_agent_currency%2522%253A%25221.533%2522%252C%2522applied_markup%2522%253A%25220%2522%252C%2522applied_markup_amount%2522%253A%25220%2522%252C%2522applied_multiplier%2522%253A%25220.01533%2522%252C%2522agent_rate%2522%253A%25221.53%2522%252C%2522supplier_commission%2522%253A%25220%2522%252C%2522supplier_commission_amount%2522%253A%25220%2522%252C%2522profit%2522%253A%25220%2522%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522USD%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%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A71%3A%22Luxury+Tent+%28A%2FC%29+-+Single%2C+Max+Pax+-+4%2C+Extrabed+-+0+%28Bed+%26+Breakfast%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A15%3A%22Bed+%26+Breakfast%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%222%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%3A17%3A%22Luxury+Tent+%28A%2FC%29%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22617%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A48%3A%222%7E%7E%7E111%7E%7E%7E617%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000070%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22double%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%3A3%3A%22Mrs%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Snehal%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Test%22%3B%7Ds%3A3%3A%22age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7D%7D%7Ds%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A16%3A%22baseSupplierRate%22%3Bs%3A3%3A%22100%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22100%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%220.01533%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A4%3A%221.53%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A4%3A%221.53%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%3A11283%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1747008000%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252219%252F11%252F2020%2B--%2B20%252F11%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253701%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253701%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A13%253A%2522QuotationTest%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25224.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%253Bi%253A100%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A100%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A4%253A%25221.53%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%25222020-11-19%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A100%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A5%253A%25221.533%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25220%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A1%253A%25220%2522%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522USD%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25222%257E%257E%257E111%257E%257E%257E617%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000070%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A7%253A%2522Pooja%2BR%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522617%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A15%253A%2522Bed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A70%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%2B%2BBed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522double%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A71%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%2B%2528Bed%2B%2526%2BBreakfast%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A53%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%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%253A17%253A%2522-0.19569471624265%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25222%257E%257E%257E111%257E%257E%257E617%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000070%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.05%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%2522-0.19569471624265%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%2522-0.05%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25220.00%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A17%253A%2522-0.19569471624265%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%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%252253701----------S000000070%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A13%253A%2522QuotationTest%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A8%253A%2522SriLanka%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%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.05%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A5%253A%2522-3.57%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A8%253A%2522SriLanka%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A2%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271100%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%2522132%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A99%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252Fproject_folder%252Ftfg_project%252Fimages%252Fimagenotavailable.jpg%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%253Bi%253A100%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A100%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A4%253A%25221.53%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%25222020-11-19%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A100%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A5%253A%25221.533%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25220%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A1%253A%25220%2522%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522USD%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25222%257E%257E%257E111%257E%257E%257E617%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000070%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A7%253A%2522Pooja%2BR%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522617%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A15%253A%2522Bed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A70%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%2B%2BBed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522double%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A71%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%2B%2528Bed%2B%2526%2BBreakfast%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A53%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%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%253A17%253A%2522-0.19569471624265%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25222%257E%257E%257E111%257E%257E%257E617%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000070%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.05%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%2522-0.19569471624265%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%2522-0.05%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25220.00%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A17%253A%2522-0.19569471624265%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%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%252253701----------S000000070%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A13%253A%2522QuotationTest%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A8%253A%2522SriLanka%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%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.05%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A5%253A%2522-3.57%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%27111%27%22%3B%7Ds%3A15%3A%22request_details%22%3Ba%3A71%3A%7Bs%3A13%3A%22check_in_date%22%3Bs%3A10%3A%2219-11-2020%22%3Bs%3A14%3A%22check_out_date%22%3Bs%3A10%3A%222020-11-20%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%22USD%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2225%22%3Bs%3A17%3A%22agent_selected_id%22%3Bs%3A2%3A%2225%22%3Bs%3A17%3A%22total_native_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A18%3A%22total_display_rate%22%3Bs%3A4%3A%221.53%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A24%3A%22sel_country_of_residence%22%3Bs%3A3%3A%22132%22%3Bs%3A8%3A%22sel_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A10%3A%22sel_hotels%22%3Bs%3A5%3A%2253701%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%2219-11-2020%22%3Bs%3A11%3A%22depart_date%22%3Bs%3A10%3A%2220-11-2020%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%3A3%3A%22Mrs%22%3B%7Ds%3A14%3A%22sel_first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Snehal%22%3B%7Ds%3A13%3A%22sel_last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Test%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%22S000000070%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%22USD%22%3Bs%3A22%3A%22supplier_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%220.01533%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%3A17%3A%22-0.19569471624265%22%3Bs%3A23%3A%22basecurrency_multiplier%22%3Bd%3A1%3Bs%3A30%3A%22basecurrency_multiplier_native%22%3Bd%3A0.01533%3Bs%3A10%3A%22txt_markup%22%3Bs%3A17%3A%22-0.19569471624265%22%3Bs%3A12%3A%22room_type_id%22%3Bs%3A1%3A%222%22%3Bs%3A15%3A%22number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%222%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22total_pax%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22room_type%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A13%3A%22double_room_1%22%3B%7Ds%3A25%3A%22double_room_1_description%22%3Bs%3A17%3A%22Luxury+Tent+%28A%2FC%29%22%3Bs%3A18%3A%22double_room_1_code%22%3Bs%3A48%3A%222%7E%7E%7E111%7E%7E%7E617%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000070%22%3Bs%3A24%3A%22double_room_1_room_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A29%3A%22double_room_1_room_basis_desc%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A29%3A%22double_room_1_number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22double_room_1_native_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bi%3A100%3B%7Ds%3A40%3A%22double_room_1_native_supplier_commission%22%3BN%3Bs%3A47%3A%22double_room_1_native_supplier_commission_amount%22%3BN%3Bs%3A26%3A%22double_room_1_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A1.53%3B%7Ds%3A30%3A%22double_room_1_sub_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A1.53%3B%7Ds%3A29%3A%22double_room_1_wh_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A1.53%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%2202%2F11%2F2020+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%221869%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%3B%7Ds%3A17%3A%22quotation_details%22%3Bs%3A11283%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1747008000%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252219%252F11%252F2020%2B--%2B20%252F11%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253701%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253701%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A13%253A%2522QuotationTest%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25224.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%253Bi%253A100%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A100%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A4%253A%25221.53%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%25222020-11-19%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A100%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A5%253A%25221.533%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25220%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A1%253A%25220%2522%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522USD%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25222%257E%257E%257E111%257E%257E%257E617%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000070%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A7%253A%2522Pooja%2BR%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522617%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A15%253A%2522Bed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A70%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%2B%2BBed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522double%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A71%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%2B%2528Bed%2B%2526%2BBreakfast%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A53%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%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%253A17%253A%2522-0.19569471624265%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25222%257E%257E%257E111%257E%257E%257E617%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000070%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.05%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%2522-0.19569471624265%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%2522-0.05%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25220.00%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A17%253A%2522-0.19569471624265%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%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%252253701----------S000000070%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A13%253A%2522QuotationTest%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A8%253A%2522SriLanka%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%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.05%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A5%253A%2522-3.57%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A8%253A%2522SriLanka%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A2%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271100%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%2522132%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A99%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252Fproject_folder%252Ftfg_project%252Fimages%252Fimagenotavailable.jpg%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%253Bi%253A100%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A100%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A4%253A%25221.53%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%25222020-11-19%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A100%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A5%253A%25221.533%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25220%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A1%253A%25220%2522%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522USD%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25222%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25222%257E%257E%257E111%257E%257E%257E617%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000070%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A7%253A%2522Pooja%2BR%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522617%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25221%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A15%253A%2522Bed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A70%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%2B%2BBed%2B%2526%2BBreakfast%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522double%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A71%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%2B%2528Bed%2B%2526%2BBreakfast%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A53%253A%2522Luxury%2BTent%2B%2528A%252FC%2529%2B-%2BSingle%252C%2BMax%2BPax%2B-%2B4%252C%2BExtrabed%2B-%2B0%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%253A17%253A%2522-0.19569471624265%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25222%257E%257E%257E111%257E%257E%257E617%257E%257E%257E1%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000070%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.05%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%2522-0.19569471624265%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%2522-0.05%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25220.00%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%25221.53%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522USD%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A17%253A%2522-0.19569471624265%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25220.01533%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%252253701----------S000000070%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A13%253A%2522QuotationTest%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A8%253A%2522SriLanka%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000070%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.05%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A5%253A%2522-3.57%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7D', create_date='2020-11-02 05:36:34';;
[11/02/2020 05:36:34], [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
        ('','','3055','confirmed','2020-11-02 05:36:34','Quotation Id - QTECHCD002510 created on behalf of Agent - Snehal Valanju(25) by tfg','tfg','60.254.5.70','tfg','','');
[11/02/2020 05:36:34], [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
        ('','','3055','confirmed','2020-11-02 05:36:34','Enquiry Id - 407 created on behalf of Agent - Snehal Valanju(25) by tfg','tfg','60.254.5.70','tfg','','');
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='booked' where unique_id='QTECHCD002510';
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3054',q_id='QTECHCD002510',enquiry_id='407',quote_id='1900',backoffice_user='tfg',agent_id='25',create_date='2020-11-02 05:36:34',booked_from='agent_quote_itemized';
[11/02/2020 05:36:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3055',q_id='QTECHCD002510',enquiry_id='407',quote_id='1901',backoffice_user='tfg',agent_id='25',create_date='2020-11-02 05:36:34',booked_from='agent_quote_itemized';
