[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '91.5' , weekend_rate= '91.5'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-10-21' AND date_to= '2020-10-21' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1039',room_basis = '1',date_from = '2020-10-21',weekday_rate = '91.5',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_11_11_01_1603105861_53773.xml',create_date = '2020-10-19 11:11:01';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '92.5' , weekend_rate= '92.5'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-10-22' AND date_to= '2020-10-22' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1039',room_basis = '1',date_from = '2020-10-22',weekday_rate = '92.5',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_11_11_01_1603105861_53773.xml',create_date = '2020-10-19 11:11:01';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '93.5' , weekend_rate= '93.5'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-10-23' AND date_to= '2020-10-23' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1039',room_basis = '1',date_from = '2020-10-23',weekday_rate = '93.5',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_11_11_01_1603105861_53773.xml',create_date = '2020-10-19 11:11:01';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '94.5' , weekend_rate= '94.5'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-10-24' AND date_to= '2020-10-24' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1039',room_basis = '1',date_from = '2020-10-24',weekday_rate = '94.5',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_11_11_01_1603105861_53773.xml',create_date = '2020-10-19 11:11:01';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  weekday_rate= '95.5' , weekend_rate= '95.5'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2020-10-25' AND date_to= '2020-10-25' AND room_class= '1039' AND room_basis= '1' AND inventory_class_id= '132';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_class = '1039',room_basis = '1',date_from = '2020-10-25',weekday_rate = '95.5',type = 'rates',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_11_11_01_1603105861_53773.xml',create_date = '2020-10-19 11:11:01';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-19 11:11:01',channel_manager_name= 'rategain',hotel_id= '53773',room_id= '1',room_class_id= '1039',rate_id= '132',start_date= '2020-10-25';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTkgMTE6MTE6MDE8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIwLTEwLTIxICwgMjAyMC0xMC0yMiAsIDIwMjAtMTAtMjMgLCAyMDIwLTEwLTI0ICwgMjAyMC0xMC0yNTxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-19 11:11:01';
[10/19/2020 11:11:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-10-19 11:11:01<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2020-10-21 , 2020-10-22 , 2020-10-23 , 2020-10-24 , 2020-10-25<br>',  email_sent ='yes', create_date ='2020-10-19 11:11:01', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/19/2020 11:19:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_request_logs SET quotation_id='QTECHCD00093', request_detail='a%3A25%3A%7Bs%3A6%3A%22action%22%3Bs%3A22%3A%22insertQuotationService%22%3Bs%3A14%3A%22bookingSession%22%3Bs%3A32%3A%2255824953d56bedc0b870290cf1e0374e%22%3Bs%3A17%3A%22agent_suggest_box%22%3Bs%3A37%3A%22Qtech+%5BCD0009-arvind%5D+%5BArvind-Pandey%5D%22%3Bs%3A12%3A%22search_agent%22%3Bs%3A1%3A%229%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%2255824953d56bedc0b870290cf1e0374e%22%3Bs%3A14%3A%22quotation_name%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A12%3A%22QTECHCD00093%22%3Bs%3A11%3A%22ServiceDate%22%3Bs%3A10%3A%2215-10-2020%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A11%3A%22selCurrency%22%3Bs%3A3%3A%22INR%22%3Bs%3A15%3A%22sel_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A13%3A%22reservationId%22%3Bs%3A15%3A%22QTECH2020101816%22%3Bs%3A19%3A%22sel_hotel_quotation%22%3Bs%3A4%3A%221894%22%3Bs%3A10%3A%22salutation%22%3Bs%3A2%3A%22Ms%22%3Bs%3A10%3A%22first_name%22%3Bs%3A6%3A%22Ankita%22%3Bs%3A9%3A%22last_name%22%3Bs%3A3%3A%22Rao%22%3Bs%3A18%3A%22countryOfResidence%22%3Bs%3A3%3A%22106%22%3Bs%3A12%3A%22BookingNotes%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22customerAddress%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22bookquotation%22%3Ba%3A1%3A%7Bs%3A5%3A%22hotel%22%3Ba%3A2%3A%7Bs%3A23%3A%2215-10-2020%5E%3A%5E16-10-2020%22%3Ba%3A1%3A%7Bi%3A53699%3Ba%3A1%3A%7Bi%3A0%3Ba%3A43%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253699%22%3Bs%3A12%3A%22service_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2215-10-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2216-10-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221893%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000071%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-10-15%2522%252C%2522supplier_rate%2522%253A%2522100.00%2522%252C%2522supplier_rate_in_agent_currency%2522%253A%2522100.00%2522%252C%2522applied_markup%2522%253A%25227%2522%252C%2522applied_markup_amount%2522%253Anull%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%2522107.00%2522%252C%2522supplier_commission%2522%253Anull%252C%2522supplier_commission_amount%2522%253Anull%252C%2522profit%2522%253Anull%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A50%3A%22Cilantro+Suite+-+Triple%2C+Extrabed+-+3+%28Full+Board%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%22Full+Board%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A14%3A%22Cilantro+Suite%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22620%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%223%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A47%3A%221%7E%7E%7E51%7E%7E%7E620%7E%7E%7E3%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%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%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A1%3A%227%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A3%3A%22107%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A3%3A%22107%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%2224-11-2020%5E%3A%5E25-11-2020%22%3Ba%3A1%3A%7Bi%3A53699%3Ba%3A1%3A%7Bi%3A1%3Ba%3A43%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253699%22%3Bs%3A12%3A%22service_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2224-11-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2225-11-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221894%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000071%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-24%2522%252C%2522supplier_rate%2522%253A%2522200.00%2522%252C%2522supplier_rate_in_agent_currency%2522%253A%2522200.00%2522%252C%2522applied_markup%2522%253A%25227%2522%252C%2522applied_markup_amount%2522%253Anull%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%2522214.00%2522%252C%2522supplier_commission%2522%253Anull%252C%2522supplier_commission_amount%2522%253Anull%252C%2522profit%2522%253Anull%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A58%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0+%28Half+Board%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%22Half+Board%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A22%3A%22Colonial+Manssion+-+01%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22653%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%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%22200%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22200%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A1%3A%227%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A3%3A%22214%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A3%3A%22214%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%223%22%3B%7D%7D%7D%7D%7Ds%3A19%3A%22total_package_adult%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22total_package_child%22%3Bs%3A1%3A%220%22%3Bs%3A19%3A%22total_selling_price%22%3Bs%3A3%3A%22321%22%3B%7D', create_date='2020-10-19 11:19:09';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO bookings SET agent_id = '9' , service_type = 'hotel' , reservation_id = 'QTECH2020101816' , display_currency_code = 'INR' , created_datetime='2020-10-19 11:19:10' , create_date='2020-10-19 11:19:10' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg' , itenirary_id = '2' , sequence = '2', city_id='Colombo', country_id='132', leader_title='Ms', leader_first_name='Ankita', leader_last_name='Rao', 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='Marino Beach Colombo', country_of_residence='106';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3021'
        ;
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into bookings_details set booking_id ='3021' , hotel_id='53699' , hotel_name='Marino Beach Colombo' , hotel_address1='' , hotel_phone='' , hotel_rating='5.0';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_room_detail set booking_id = '3021', booking_detail_id = '1162', room_type_code = '1~~~51~~~620~~~3~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', meal_basis = 'Full Board', room_category = 'Cilantro Suite', room_type_description = 'Cilantro Suite - Full Board', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:107;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"100.00";}}' ,native_room_rate_total = '100' ,display_room_rate_total = '107' ,number_of_rooms = '1';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE bookings SET confirmation_number='',itenirary_id ='2',sequence ='2',voucher_id='',voucher_hashcode='',native_currency_code='INR',cancellation_policy='',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='7',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1.00000',current_status='confirmed',status_date='2020-10-19 11:19:10',service_date='2020-10-15',check_out_date='2020-10-16',display_room_rate= '107',display_discount='',native_room_rate= '100',native_discount='',additional_charge='0',expiration_date= '2020-10-19 00:00:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3021';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings set  parent_agent_id='9', sub_agent_rate='', agent_rate='107', applicable_service_tax='', agent_markup='7', supplier_rate='100' where id='3021';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings_details set total_nights='1', supplier_id= 'S000000071',arrival_date='2020/10/15',departure_date='2020/10/16',rate_code='~', total_rooms= '1', total_adults= '1', total_children= '0', total_infants= '0' where booking_id ='3021';
[10/19/2020 11:19:10], [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
        ('','','3021','confirmed','2020-10-19 11:19:10','confirmed by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:19:10], [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 ('3021','1162','1744','0','Ms','Ankita','Rao','adult','');
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3021', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223021%22%3Bs%3A12%3A%22post_details%22%3Ba%3A45%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253699%22%3Bs%3A12%3A%22service_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2215-10-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2216-10-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221893%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000071%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-10-15%2522%252C%2522supplier_rate%2522%253A%2522100.00%2522%252C%2522supplier_rate_in_agent_currency%2522%253A%2522100.00%2522%252C%2522applied_markup%2522%253A%25227%2522%252C%2522applied_markup_amount%2522%253Anull%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%2522107.00%2522%252C%2522supplier_commission%2522%253Anull%252C%2522supplier_commission_amount%2522%253Anull%252C%2522profit%2522%253Anull%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A50%3A%22Cilantro+Suite+-+Triple%2C+Extrabed+-+3+%28Full+Board%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%22Full+Board%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A14%3A%22Cilantro+Suite%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22620%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%223%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A47%3A%221%7E%7E%7E51%7E%7E%7E620%7E%7E%7E3%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%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%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A1%3A%227%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A3%3A%22107%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A3%3A%22107%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%3A13783%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1618099200%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252215%252F10%252F2020%2B--%2B16%252F10%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25225.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522107.00%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-10-15%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522620%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25223%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Full%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A49%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2BFull%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A50%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2528Full%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A37%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%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%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%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%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25225.42%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522107%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%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%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%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%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%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%253A1%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%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A2184%253A%2522Colombo%2B%2528%252Fk%253F%253Fl%253Fmbo%253F%252F%253B%2BSinhala%253A%2B%253F%253F%253F%253F%252C%2Bromanized%253A%2BKolamba%252C%2Bpronunciation%2B%255B%253Fk%253Fl%253Fmb%253F%255D%253B%2BTamil%253A%2B%253F%253F%253F%253F%253F%253F%253F%253F%252C%2Bromanized%253A%2BKo%253Fumpu%252C%2BTamil%2Bpronunciation%253A%2B%255Bko%253Fumbu%255D%2529%2Bis%2Bthe%2Bcommercial%2Bcapital%255B3%255D%2Band%2Blargest%2Bcity%2Bof%2BSri%2BLanka%2Bby%2Bpopulation.%2BAccording%2Bto%2Bthe%2BBrookings%2BInstitution%252C%2BColombo%2Bmetropolitan%2Barea%2Bhas%2Ba%2Bpopulation%2Bof%2B5.6%2Bmillion%252C%255B4%255D%255B5%255D%255B6%255D%255B7%255D%2Band%2B752%252C993%255B2%255D%2Bin%2Bthe%2Bcity%2Bproper.%2BIt%2Bis%2Bthe%2Bfinancial%2Bcentre%2Bof%2Bthe%2Bisland%2Band%2Ba%2Bpopular%2Btourist%2Bdestination.%255B8%255D%2BIt%2Bis%2Blocated%2Bon%2Bthe%2Bwest%2Bcoast%2Bof%2Bthe%2Bisland%2Band%2Badjacent%2Bto%2Bthe%2BGreater%2BColombo%2Barea%2Bwhich%2Bincludes%2BSri%2BJayawardenepura%2BKotte%252C%2Bthe%2Blegislative%2Bcapital%2Bof%2BSri%2BLanka%2Band%2BDehiwala-Mount%2BLavinia.%2BColombo%2Bis%2Boften%2Breferred%2Bto%2Bas%2Bthe%2Bcapital%2Bsince%2BSri%2BJayawardenepura%2BKotte%2Bis%2Bwithin%2Bthe%2Burban%2Barea%2Bof%252C%2Band%2Ba%2Bsuburb%2Bof%252C%2BColombo.%2BIt%2Bis%2Balso%2Bthe%2Badministrative%2Bcapital%2Bof%2Bthe%2BWestern%2BProvince%2Band%2Bthe%2Bdistrict%2Bcapital%2Bof%2BColombo%2BDistrict.%2BColombo%2Bis%2Ba%2Bbusy%2Band%2Bvibrant%2Bplace%2Bwith%2Ba%2Bmixture%2Bof%2Bmodern%2Blife%2Band%2Bcolonial%2Bbuildings%2Band%2Bruins.%255B9%255D%250D%250A%250D%250ADue%2Bto%2Bits%2Blarge%2Bharbour%2Band%2Bits%2Bstrategic%2Bposition%2Balong%2Bthe%2BEast-West%2Bsea%2Btrade%2Broutes%252C%2BColombo%2Bwas%2Bknown%2Bto%2Bancient%2Btraders%2B2%252C000%2Byears%2Bago.%255Bcitation%2Bneeded%255D%2BIt%2Bwas%2Bmade%2Bthe%2Bcapital%2Bof%2Bthe%2Bisland%2Bwhen%2BSri%2BLanka%2Bwas%2Bceded%2Bto%2Bthe%2BBritish%2BEmpire%2Bin%2B1815%252C%255B10%255D%2Band%2Bits%2Bstatus%2Bas%2Bcapital%2Bwas%2Bretained%2Bwhen%2Bthe%2Bnation%2Bbecame%2Bindependent%2Bin%2B1948.%2BIn%2B1978%252C%2Bwhen%2Badministrative%2Bfunctions%2Bwere%2Bmoved%2Bto%2BSri%2BJayawardenepura%2BKotte%252C%2BColombo%2Bwas%2Bdesignated%2Bas%2Bthe%2Bcommercial%2Bcapital%2Bof%2BSri%2BLanka.%250D%250A%250D%250ALike%2Bmany%2Bcities%252C%2BColombo%255C%2526%2523039%253Bs%2Burban%2Barea%2Bextends%2Bwell%2Bbeyond%2Bthe%2Bboundaries%2Bof%2Ba%2Bsingle%2Blocal%2Bauthority%252C%2Bencompassing%2Bother%2Bmunicipal%2Band%2Burban%2Bcouncils%2Bsuch%2Bas%2BSri%2BJayawardenepura%2BKotte%2BMunicipal%2BCouncil%252C%2BDehiwala%2BMount%2BLavinia%2BMunicipal%2BCouncil%252C%2BKolonnawa%2BUrban%2BCouncil%252C%2BKaduwela%2BMunicipal%2BCouncil%2Band%2BKotikawatte%2BMulleriyawa%2BPradeshiya%2BSabha.%2BThe%2Bmain%2Bcity%2Bis%2Bhome%2Bto%2Ba%2Bmajority%2Bof%2BSri%2BLanka%255C%2526%2523039%253Bs%2Bcorporate%2Boffices%252C%2Brestaurants%2Band%2Bentertainment%2Bvenues.%255B11%255D%2BFamous%2Blandmarks%2Bin%2BColombo%2Binclude%2BGalle%2BFace%2BGreen%252C%2BViharamahadevi%2BPark%252C%2BBeira%2BLake%252C%2BColombo%2BRacecourse%252C%2BPlanetarium%252C%2BUniversity%2Bof%2BColombo%252C%2BMount%2BLavinia%2Bbeach%252C%2BNelum%2BPokuna%2BTheatre%252C%2BColombo%2BLotus%2BTower%2Bas%2Bwell%2Bas%2Bthe%2BNational%2BMuseum.%2B%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A249%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5Njg1OF9tYWluX21haW4mIzAzOTtzX2ltYWdlcy5qcGVn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522107.00%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-10-15%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522620%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25223%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Full%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A49%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2BFull%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A50%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2528Full%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A37%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%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%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%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%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25225.42%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522107%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%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%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%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%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%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%3A4%3A%22%2751%27%22%3B%7Ds%3A15%3A%22request_details%22%3Ba%3A71%3A%7Bs%3A13%3A%22check_in_date%22%3Bs%3A10%3A%2215-10-2020%22%3Bs%3A14%3A%22check_out_date%22%3Bs%3A10%3A%222020-10-16%22%3Bs%3A11%3A%22action_name%22%3Bs%3A10%3A%22add_sector%22%3Bs%3A11%3A%22total_night%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22agent_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22agent_selected_id%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22total_native_rate%22%3Bs%3A3%3A%22100%22%3Bs%3A18%3A%22total_display_rate%22%3Bs%3A3%3A%22107%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A24%3A%22sel_country_of_residence%22%3Bs%3A3%3A%22106%22%3Bs%3A8%3A%22sel_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A10%3A%22sel_hotels%22%3Bs%3A5%3A%2253699%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%2215-10-2020%22%3Bs%3A11%3A%22depart_date%22%3Bs%3A10%3A%2216-10-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%3A2%3A%22Ms%22%3B%7Ds%3A14%3A%22sel_first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A13%3A%22sel_last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%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%22S000000071%22%3Bs%3A20%3A%22sel_supplierProfileL%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22sel_currencies_online%22%3Bs%3A3%3A%22INR%22%3Bs%3A21%3A%22display_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A22%3A%22supplier_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A25%3A%22agent_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22txt_agent_markup%22%3Bs%3A1%3A%227%22%3Bs%3A23%3A%22basecurrency_multiplier%22%3Bd%3A0.01533%3Bs%3A30%3A%22basecurrency_multiplier_native%22%3Bd%3A0.01533%3Bs%3A10%3A%22txt_markup%22%3Bs%3A1%3A%227%22%3Bs%3A12%3A%22room_type_id%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22total_pax%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22room_type%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A13%3A%22single_room_1%22%3B%7Ds%3A25%3A%22single_room_1_description%22%3Bs%3A14%3A%22Cilantro+Suite%22%3Bs%3A18%3A%22single_room_1_code%22%3Bs%3A47%3A%221%7E%7E%7E51%7E%7E%7E620%7E%7E%7E3%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3Bs%3A24%3A%22single_room_1_room_basis%22%3Bs%3A10%3A%22Full+Board%22%3Bs%3A29%3A%22single_room_1_room_basis_desc%22%3Bs%3A10%3A%22Full+Board%22%3Bs%3A29%3A%22single_room_1_number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22single_room_1_native_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22100.00%22%3B%7Ds%3A40%3A%22single_room_1_native_supplier_commission%22%3BN%3Bs%3A47%3A%22single_room_1_native_supplier_commission_amount%22%3BN%3Bs%3A26%3A%22single_room_1_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A107%3B%7Ds%3A30%3A%22single_room_1_sub_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A107%3B%7Ds%3A29%3A%22single_room_1_wh_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A107%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%2219%2F10%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%3A15%3A%22QTECH2020101816%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%3A13783%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1618099200%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252215%252F10%252F2020%2B--%2B16%252F10%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25225.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522107.00%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-10-15%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522620%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25223%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Full%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A49%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2BFull%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A50%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2528Full%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A37%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%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%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%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%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25225.42%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522107%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%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%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%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%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%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%253A1%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%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A2184%253A%2522Colombo%2B%2528%252Fk%253F%253Fl%253Fmbo%253F%252F%253B%2BSinhala%253A%2B%253F%253F%253F%253F%252C%2Bromanized%253A%2BKolamba%252C%2Bpronunciation%2B%255B%253Fk%253Fl%253Fmb%253F%255D%253B%2BTamil%253A%2B%253F%253F%253F%253F%253F%253F%253F%253F%252C%2Bromanized%253A%2BKo%253Fumpu%252C%2BTamil%2Bpronunciation%253A%2B%255Bko%253Fumbu%255D%2529%2Bis%2Bthe%2Bcommercial%2Bcapital%255B3%255D%2Band%2Blargest%2Bcity%2Bof%2BSri%2BLanka%2Bby%2Bpopulation.%2BAccording%2Bto%2Bthe%2BBrookings%2BInstitution%252C%2BColombo%2Bmetropolitan%2Barea%2Bhas%2Ba%2Bpopulation%2Bof%2B5.6%2Bmillion%252C%255B4%255D%255B5%255D%255B6%255D%255B7%255D%2Band%2B752%252C993%255B2%255D%2Bin%2Bthe%2Bcity%2Bproper.%2BIt%2Bis%2Bthe%2Bfinancial%2Bcentre%2Bof%2Bthe%2Bisland%2Band%2Ba%2Bpopular%2Btourist%2Bdestination.%255B8%255D%2BIt%2Bis%2Blocated%2Bon%2Bthe%2Bwest%2Bcoast%2Bof%2Bthe%2Bisland%2Band%2Badjacent%2Bto%2Bthe%2BGreater%2BColombo%2Barea%2Bwhich%2Bincludes%2BSri%2BJayawardenepura%2BKotte%252C%2Bthe%2Blegislative%2Bcapital%2Bof%2BSri%2BLanka%2Band%2BDehiwala-Mount%2BLavinia.%2BColombo%2Bis%2Boften%2Breferred%2Bto%2Bas%2Bthe%2Bcapital%2Bsince%2BSri%2BJayawardenepura%2BKotte%2Bis%2Bwithin%2Bthe%2Burban%2Barea%2Bof%252C%2Band%2Ba%2Bsuburb%2Bof%252C%2BColombo.%2BIt%2Bis%2Balso%2Bthe%2Badministrative%2Bcapital%2Bof%2Bthe%2BWestern%2BProvince%2Band%2Bthe%2Bdistrict%2Bcapital%2Bof%2BColombo%2BDistrict.%2BColombo%2Bis%2Ba%2Bbusy%2Band%2Bvibrant%2Bplace%2Bwith%2Ba%2Bmixture%2Bof%2Bmodern%2Blife%2Band%2Bcolonial%2Bbuildings%2Band%2Bruins.%255B9%255D%250D%250A%250D%250ADue%2Bto%2Bits%2Blarge%2Bharbour%2Band%2Bits%2Bstrategic%2Bposition%2Balong%2Bthe%2BEast-West%2Bsea%2Btrade%2Broutes%252C%2BColombo%2Bwas%2Bknown%2Bto%2Bancient%2Btraders%2B2%252C000%2Byears%2Bago.%255Bcitation%2Bneeded%255D%2BIt%2Bwas%2Bmade%2Bthe%2Bcapital%2Bof%2Bthe%2Bisland%2Bwhen%2BSri%2BLanka%2Bwas%2Bceded%2Bto%2Bthe%2BBritish%2BEmpire%2Bin%2B1815%252C%255B10%255D%2Band%2Bits%2Bstatus%2Bas%2Bcapital%2Bwas%2Bretained%2Bwhen%2Bthe%2Bnation%2Bbecame%2Bindependent%2Bin%2B1948.%2BIn%2B1978%252C%2Bwhen%2Badministrative%2Bfunctions%2Bwere%2Bmoved%2Bto%2BSri%2BJayawardenepura%2BKotte%252C%2BColombo%2Bwas%2Bdesignated%2Bas%2Bthe%2Bcommercial%2Bcapital%2Bof%2BSri%2BLanka.%250D%250A%250D%250ALike%2Bmany%2Bcities%252C%2BColombo%255C%2526%2523039%253Bs%2Burban%2Barea%2Bextends%2Bwell%2Bbeyond%2Bthe%2Bboundaries%2Bof%2Ba%2Bsingle%2Blocal%2Bauthority%252C%2Bencompassing%2Bother%2Bmunicipal%2Band%2Burban%2Bcouncils%2Bsuch%2Bas%2BSri%2BJayawardenepura%2BKotte%2BMunicipal%2BCouncil%252C%2BDehiwala%2BMount%2BLavinia%2BMunicipal%2BCouncil%252C%2BKolonnawa%2BUrban%2BCouncil%252C%2BKaduwela%2BMunicipal%2BCouncil%2Band%2BKotikawatte%2BMulleriyawa%2BPradeshiya%2BSabha.%2BThe%2Bmain%2Bcity%2Bis%2Bhome%2Bto%2Ba%2Bmajority%2Bof%2BSri%2BLanka%255C%2526%2523039%253Bs%2Bcorporate%2Boffices%252C%2Brestaurants%2Band%2Bentertainment%2Bvenues.%255B11%255D%2BFamous%2Blandmarks%2Bin%2BColombo%2Binclude%2BGalle%2BFace%2BGreen%252C%2BViharamahadevi%2BPark%252C%2BBeira%2BLake%252C%2BColombo%2BRacecourse%252C%2BPlanetarium%252C%2BUniversity%2Bof%2BColombo%252C%2BMount%2BLavinia%2Bbeach%252C%2BNelum%2BPokuna%2BTheatre%252C%2BColombo%2BLotus%2BTower%2Bas%2Bwell%2Bas%2Bthe%2BNational%2BMuseum.%2B%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A249%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5Njg1OF9tYWluX21haW4mIzAzOTtzX2ltYWdlcy5qcGVn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522100.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522107.00%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-10-15%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522107.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522100.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522620%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25223%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Full%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A49%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2BFull%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A50%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%2B%2528Full%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A37%253A%2522Cilantro%2BSuite%2B-%2BTriple%252C%2BExtrabed%2B-%2B3%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%25227%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A47%253A%25221%257E%257E%257E51%257E%257E%257E620%257E%257E%257E3%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%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%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25225.42%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522107%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%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%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%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%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25221.58%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7D', create_date='2020-10-19 11:19:10';;
[10/19/2020 11:19:10], [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
        ('','','3021','confirmed','2020-10-19 11:19:10','Quotation Id - QTECHCD00093 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:19:10], [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
        ('','','3021','confirmed','2020-10-19 11:19:10','Enquiry Id - 404 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO bookings SET agent_id = '9' , service_type = 'hotel' , reservation_id = 'QTECH2020101816' , display_currency_code = 'INR' , created_datetime='2020-10-19 11:19:10' , create_date='2020-10-19 11:19:10' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg' , itenirary_id = '3' , sequence = '3', city_id='Colombo', country_id='132', leader_title='Ms', leader_first_name='Ankita', leader_last_name='Rao', 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='Marino Beach Colombo', country_of_residence='106';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3022'
        ;
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into bookings_details set booking_id ='3022' , hotel_id='53699' , hotel_name='Marino Beach Colombo' , hotel_address1='' , hotel_phone='' , hotel_rating='5.0';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_room_detail set booking_id = '3022', booking_detail_id = '1163', room_type_code = '1~~~142~~~653~~~2~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', meal_basis = 'Half Board', room_category = 'Colonial Manssion - 01', room_type_description = 'Colonial Manssion - 01 - Half Board', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:214;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"200.00";}}' ,native_room_rate_total = '200' ,display_room_rate_total = '214' ,number_of_rooms = '1';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE bookings SET confirmation_number='',itenirary_id ='3',sequence ='3',voucher_id='',voucher_hashcode='',native_currency_code='INR',cancellation_policy='',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='7',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1.00000',current_status='confirmed',status_date='2020-10-19 11:19:10',service_date='2020-11-24',check_out_date='2020-11-25',display_room_rate= '214',display_discount='',native_room_rate= '200',native_discount='',additional_charge='0',expiration_date= '2020-10-19 00:00:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3022';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings set  parent_agent_id='9', sub_agent_rate='', agent_rate='214', applicable_service_tax='', agent_markup='7', supplier_rate='200' where id='3022';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings_details set total_nights='1', supplier_id= 'S000000071',arrival_date='2020/11/24',departure_date='2020/11/25',rate_code='~', total_rooms= '1', total_adults= '1', total_children= '0', total_infants= '0' where booking_id ='3022';
[10/19/2020 11:19:10], [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
        ('','','3022','confirmed','2020-10-19 11:19:10','confirmed by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:19:10], [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 ('3022','1163','1745','0','Ms','Ankita','Rao','adult','');
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3022', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223022%22%3Bs%3A12%3A%22post_details%22%3Ba%3A45%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253699%22%3Bs%3A12%3A%22service_name%22%3Bs%3A20%3A%22Marino+Beach+Colombo%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2224-11-2020%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2225-11-2020%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221894%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253699%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000071%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-24%2522%252C%2522supplier_rate%2522%253A%2522200.00%2522%252C%2522supplier_rate_in_agent_currency%2522%253A%2522200.00%2522%252C%2522applied_markup%2522%253A%25227%2522%252C%2522applied_markup_amount%2522%253Anull%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%2522214.00%2522%252C%2522supplier_commission%2522%253Anull%252C%2522supplier_commission_amount%2522%253Anull%252C%2522profit%2522%253Anull%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A58%3A%22Colonial+Manssion+-+01+-+Double%2C+Extrabed+-+0+%28Half+Board%29%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A10%3A%22Half+Board%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A22%3A%22Colonial+Manssion+-+01%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22653%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%222%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%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%22200%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A3%3A%22200%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A1%3A%227%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A3%3A%22214%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A3%3A%22214%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%223%22%3Bs%3A14%3A%22quotation_info%22%3Bs%3A13905%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1904860800%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252224%252F11%252F2020%2B--%2B25%252F11%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25225.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522214.00%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-24%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522653%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25222%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Half%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A57%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2BHalf%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A58%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2528Half%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A45%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%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%25227.000000000000001%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%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%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%252210.84%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522214%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522200%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%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%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%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%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%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%253A1%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%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A2184%253A%2522Colombo%2B%2528%252Fk%253F%253Fl%253Fmbo%253F%252F%253B%2BSinhala%253A%2B%253F%253F%253F%253F%252C%2Bromanized%253A%2BKolamba%252C%2Bpronunciation%2B%255B%253Fk%253Fl%253Fmb%253F%255D%253B%2BTamil%253A%2B%253F%253F%253F%253F%253F%253F%253F%253F%252C%2Bromanized%253A%2BKo%253Fumpu%252C%2BTamil%2Bpronunciation%253A%2B%255Bko%253Fumbu%255D%2529%2Bis%2Bthe%2Bcommercial%2Bcapital%255B3%255D%2Band%2Blargest%2Bcity%2Bof%2BSri%2BLanka%2Bby%2Bpopulation.%2BAccording%2Bto%2Bthe%2BBrookings%2BInstitution%252C%2BColombo%2Bmetropolitan%2Barea%2Bhas%2Ba%2Bpopulation%2Bof%2B5.6%2Bmillion%252C%255B4%255D%255B5%255D%255B6%255D%255B7%255D%2Band%2B752%252C993%255B2%255D%2Bin%2Bthe%2Bcity%2Bproper.%2BIt%2Bis%2Bthe%2Bfinancial%2Bcentre%2Bof%2Bthe%2Bisland%2Band%2Ba%2Bpopular%2Btourist%2Bdestination.%255B8%255D%2BIt%2Bis%2Blocated%2Bon%2Bthe%2Bwest%2Bcoast%2Bof%2Bthe%2Bisland%2Band%2Badjacent%2Bto%2Bthe%2BGreater%2BColombo%2Barea%2Bwhich%2Bincludes%2BSri%2BJayawardenepura%2BKotte%252C%2Bthe%2Blegislative%2Bcapital%2Bof%2BSri%2BLanka%2Band%2BDehiwala-Mount%2BLavinia.%2BColombo%2Bis%2Boften%2Breferred%2Bto%2Bas%2Bthe%2Bcapital%2Bsince%2BSri%2BJayawardenepura%2BKotte%2Bis%2Bwithin%2Bthe%2Burban%2Barea%2Bof%252C%2Band%2Ba%2Bsuburb%2Bof%252C%2BColombo.%2BIt%2Bis%2Balso%2Bthe%2Badministrative%2Bcapital%2Bof%2Bthe%2BWestern%2BProvince%2Band%2Bthe%2Bdistrict%2Bcapital%2Bof%2BColombo%2BDistrict.%2BColombo%2Bis%2Ba%2Bbusy%2Band%2Bvibrant%2Bplace%2Bwith%2Ba%2Bmixture%2Bof%2Bmodern%2Blife%2Band%2Bcolonial%2Bbuildings%2Band%2Bruins.%255B9%255D%250D%250A%250D%250ADue%2Bto%2Bits%2Blarge%2Bharbour%2Band%2Bits%2Bstrategic%2Bposition%2Balong%2Bthe%2BEast-West%2Bsea%2Btrade%2Broutes%252C%2BColombo%2Bwas%2Bknown%2Bto%2Bancient%2Btraders%2B2%252C000%2Byears%2Bago.%255Bcitation%2Bneeded%255D%2BIt%2Bwas%2Bmade%2Bthe%2Bcapital%2Bof%2Bthe%2Bisland%2Bwhen%2BSri%2BLanka%2Bwas%2Bceded%2Bto%2Bthe%2BBritish%2BEmpire%2Bin%2B1815%252C%255B10%255D%2Band%2Bits%2Bstatus%2Bas%2Bcapital%2Bwas%2Bretained%2Bwhen%2Bthe%2Bnation%2Bbecame%2Bindependent%2Bin%2B1948.%2BIn%2B1978%252C%2Bwhen%2Badministrative%2Bfunctions%2Bwere%2Bmoved%2Bto%2BSri%2BJayawardenepura%2BKotte%252C%2BColombo%2Bwas%2Bdesignated%2Bas%2Bthe%2Bcommercial%2Bcapital%2Bof%2BSri%2BLanka.%250D%250A%250D%250ALike%2Bmany%2Bcities%252C%2BColombo%255C%2526%2523039%253Bs%2Burban%2Barea%2Bextends%2Bwell%2Bbeyond%2Bthe%2Bboundaries%2Bof%2Ba%2Bsingle%2Blocal%2Bauthority%252C%2Bencompassing%2Bother%2Bmunicipal%2Band%2Burban%2Bcouncils%2Bsuch%2Bas%2BSri%2BJayawardenepura%2BKotte%2BMunicipal%2BCouncil%252C%2BDehiwala%2BMount%2BLavinia%2BMunicipal%2BCouncil%252C%2BKolonnawa%2BUrban%2BCouncil%252C%2BKaduwela%2BMunicipal%2BCouncil%2Band%2BKotikawatte%2BMulleriyawa%2BPradeshiya%2BSabha.%2BThe%2Bmain%2Bcity%2Bis%2Bhome%2Bto%2Ba%2Bmajority%2Bof%2BSri%2BLanka%255C%2526%2523039%253Bs%2Bcorporate%2Boffices%252C%2Brestaurants%2Band%2Bentertainment%2Bvenues.%255B11%255D%2BFamous%2Blandmarks%2Bin%2BColombo%2Binclude%2BGalle%2BFace%2BGreen%252C%2BViharamahadevi%2BPark%252C%2BBeira%2BLake%252C%2BColombo%2BRacecourse%252C%2BPlanetarium%252C%2BUniversity%2Bof%2BColombo%252C%2BMount%2BLavinia%2Bbeach%252C%2BNelum%2BPokuna%2BTheatre%252C%2BColombo%2BLotus%2BTower%2Bas%2Bwell%2Bas%2Bthe%2BNational%2BMuseum.%2B%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A249%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5Njg1OF9tYWluX21haW4mIzAzOTtzX2ltYWdlcy5qcGVn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522214.00%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-24%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522653%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25222%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Half%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A57%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2BHalf%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A58%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2528Half%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A45%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%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%25227.000000000000001%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%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%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%252210.84%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522214%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522200%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%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%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%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%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%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%27142%27%22%3B%7Ds%3A15%3A%22request_details%22%3Ba%3A71%3A%7Bs%3A13%3A%22check_in_date%22%3Bs%3A10%3A%2224-11-2020%22%3Bs%3A14%3A%22check_out_date%22%3Bs%3A10%3A%222020-11-25%22%3Bs%3A11%3A%22action_name%22%3Bs%3A10%3A%22add_sector%22%3Bs%3A11%3A%22total_night%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22agent_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22agent_selected_id%22%3Bs%3A1%3A%229%22%3Bs%3A17%3A%22total_native_rate%22%3Bs%3A3%3A%22200%22%3Bs%3A18%3A%22total_display_rate%22%3Bs%3A3%3A%22214%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A24%3A%22sel_country_of_residence%22%3Bs%3A3%3A%22106%22%3Bs%3A8%3A%22sel_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A10%3A%22sel_hotels%22%3Bs%3A5%3A%2253699%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%2224-11-2020%22%3Bs%3A11%3A%22depart_date%22%3Bs%3A10%3A%2225-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%3A2%3A%22Ms%22%3B%7Ds%3A14%3A%22sel_first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22Ankita%22%3B%7Ds%3A13%3A%22sel_last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22Rao%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%22S000000071%22%3Bs%3A20%3A%22sel_supplierProfileL%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22sel_currencies_online%22%3Bs%3A3%3A%22INR%22%3Bs%3A21%3A%22display_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A22%3A%22supplier_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A25%3A%22agent_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22txt_agent_markup%22%3Bs%3A1%3A%227%22%3Bs%3A23%3A%22basecurrency_multiplier%22%3Bd%3A0.01533%3Bs%3A30%3A%22basecurrency_multiplier_native%22%3Bd%3A0.01533%3Bs%3A10%3A%22txt_markup%22%3Bs%3A1%3A%227%22%3Bs%3A12%3A%22room_type_id%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22total_pax%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22room_type%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A13%3A%22single_room_1%22%3B%7Ds%3A25%3A%22single_room_1_description%22%3Bs%3A22%3A%22Colonial+Manssion+-+01%22%3Bs%3A18%3A%22single_room_1_code%22%3Bs%3A48%3A%221%7E%7E%7E142%7E%7E%7E653%7E%7E%7E2%7E%7E%7E%7E%7E%7E%7E%7E%7E71100%7E%7E%7E0%7E%7E%7ES000000071%22%3Bs%3A24%3A%22single_room_1_room_basis%22%3Bs%3A10%3A%22Half+Board%22%3Bs%3A29%3A%22single_room_1_room_basis_desc%22%3Bs%3A10%3A%22Half+Board%22%3Bs%3A29%3A%22single_room_1_number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22single_room_1_native_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22200.00%22%3B%7Ds%3A40%3A%22single_room_1_native_supplier_commission%22%3BN%3Bs%3A47%3A%22single_room_1_native_supplier_commission_amount%22%3BN%3Bs%3A26%3A%22single_room_1_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A214%3B%7Ds%3A30%3A%22single_room_1_sub_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A214%3B%7Ds%3A29%3A%22single_room_1_wh_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A214%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%2219%2F10%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%3A15%3A%22QTECH2020101816%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%223%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%223%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%3A13905%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1904860800%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252224%252F11%252F2020%2B--%2B25%252F11%252F2020%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253699%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25225.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522214.00%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-24%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522653%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25222%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Half%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A57%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2BHalf%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A58%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2528Half%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A45%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%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%25227.000000000000001%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%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%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%252210.84%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522214%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522200%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%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%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%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%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%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%253A1%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%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A2184%253A%2522Colombo%2B%2528%252Fk%253F%253Fl%253Fmbo%253F%252F%253B%2BSinhala%253A%2B%253F%253F%253F%253F%252C%2Bromanized%253A%2BKolamba%252C%2Bpronunciation%2B%255B%253Fk%253Fl%253Fmb%253F%255D%253B%2BTamil%253A%2B%253F%253F%253F%253F%253F%253F%253F%253F%252C%2Bromanized%253A%2BKo%253Fumpu%252C%2BTamil%2Bpronunciation%253A%2B%255Bko%253Fumbu%255D%2529%2Bis%2Bthe%2Bcommercial%2Bcapital%255B3%255D%2Band%2Blargest%2Bcity%2Bof%2BSri%2BLanka%2Bby%2Bpopulation.%2BAccording%2Bto%2Bthe%2BBrookings%2BInstitution%252C%2BColombo%2Bmetropolitan%2Barea%2Bhas%2Ba%2Bpopulation%2Bof%2B5.6%2Bmillion%252C%255B4%255D%255B5%255D%255B6%255D%255B7%255D%2Band%2B752%252C993%255B2%255D%2Bin%2Bthe%2Bcity%2Bproper.%2BIt%2Bis%2Bthe%2Bfinancial%2Bcentre%2Bof%2Bthe%2Bisland%2Band%2Ba%2Bpopular%2Btourist%2Bdestination.%255B8%255D%2BIt%2Bis%2Blocated%2Bon%2Bthe%2Bwest%2Bcoast%2Bof%2Bthe%2Bisland%2Band%2Badjacent%2Bto%2Bthe%2BGreater%2BColombo%2Barea%2Bwhich%2Bincludes%2BSri%2BJayawardenepura%2BKotte%252C%2Bthe%2Blegislative%2Bcapital%2Bof%2BSri%2BLanka%2Band%2BDehiwala-Mount%2BLavinia.%2BColombo%2Bis%2Boften%2Breferred%2Bto%2Bas%2Bthe%2Bcapital%2Bsince%2BSri%2BJayawardenepura%2BKotte%2Bis%2Bwithin%2Bthe%2Burban%2Barea%2Bof%252C%2Band%2Ba%2Bsuburb%2Bof%252C%2BColombo.%2BIt%2Bis%2Balso%2Bthe%2Badministrative%2Bcapital%2Bof%2Bthe%2BWestern%2BProvince%2Band%2Bthe%2Bdistrict%2Bcapital%2Bof%2BColombo%2BDistrict.%2BColombo%2Bis%2Ba%2Bbusy%2Band%2Bvibrant%2Bplace%2Bwith%2Ba%2Bmixture%2Bof%2Bmodern%2Blife%2Band%2Bcolonial%2Bbuildings%2Band%2Bruins.%255B9%255D%250D%250A%250D%250ADue%2Bto%2Bits%2Blarge%2Bharbour%2Band%2Bits%2Bstrategic%2Bposition%2Balong%2Bthe%2BEast-West%2Bsea%2Btrade%2Broutes%252C%2BColombo%2Bwas%2Bknown%2Bto%2Bancient%2Btraders%2B2%252C000%2Byears%2Bago.%255Bcitation%2Bneeded%255D%2BIt%2Bwas%2Bmade%2Bthe%2Bcapital%2Bof%2Bthe%2Bisland%2Bwhen%2BSri%2BLanka%2Bwas%2Bceded%2Bto%2Bthe%2BBritish%2BEmpire%2Bin%2B1815%252C%255B10%255D%2Band%2Bits%2Bstatus%2Bas%2Bcapital%2Bwas%2Bretained%2Bwhen%2Bthe%2Bnation%2Bbecame%2Bindependent%2Bin%2B1948.%2BIn%2B1978%252C%2Bwhen%2Badministrative%2Bfunctions%2Bwere%2Bmoved%2Bto%2BSri%2BJayawardenepura%2BKotte%252C%2BColombo%2Bwas%2Bdesignated%2Bas%2Bthe%2Bcommercial%2Bcapital%2Bof%2BSri%2BLanka.%250D%250A%250D%250ALike%2Bmany%2Bcities%252C%2BColombo%255C%2526%2523039%253Bs%2Burban%2Barea%2Bextends%2Bwell%2Bbeyond%2Bthe%2Bboundaries%2Bof%2Ba%2Bsingle%2Blocal%2Bauthority%252C%2Bencompassing%2Bother%2Bmunicipal%2Band%2Burban%2Bcouncils%2Bsuch%2Bas%2BSri%2BJayawardenepura%2BKotte%2BMunicipal%2BCouncil%252C%2BDehiwala%2BMount%2BLavinia%2BMunicipal%2BCouncil%252C%2BKolonnawa%2BUrban%2BCouncil%252C%2BKaduwela%2BMunicipal%2BCouncil%2Band%2BKotikawatte%2BMulleriyawa%2BPradeshiya%2BSabha.%2BThe%2Bmain%2Bcity%2Bis%2Bhome%2Bto%2Ba%2Bmajority%2Bof%2BSri%2BLanka%255C%2526%2523039%253Bs%2Bcorporate%2Boffices%252C%2Brestaurants%2Band%2Bentertainment%2Bvenues.%255B11%255D%2BFamous%2Blandmarks%2Bin%2BColombo%2Binclude%2BGalle%2BFace%2BGreen%252C%2BViharamahadevi%2BPark%252C%2BBeira%2BLake%252C%2BColombo%2BRacecourse%252C%2BPlanetarium%252C%2BUniversity%2Bof%2BColombo%252C%2BMount%2BLavinia%2Bbeach%252C%2BNelum%2BPokuna%2BTheatre%252C%2BColombo%2BLotus%2BTower%2Bas%2Bwell%2Bas%2Bthe%2BNational%2BMuseum.%2B%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A249%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5Njg1OF9tYWluX21haW4mIzAzOTtzX2ltYWdlcy5qcGVn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A6%253A%2522200.00%2522%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A6%253A%2522214.00%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-24%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A1%253A%25227%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253BN%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522supplier_commission%2522%253BN%253Bs%253A26%253A%2522supplier_commission_amount%2522%253BN%253Bs%253A6%253A%2522profit%2522%253BN%253Bs%253A17%253A%2522supplier_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A14%253A%2522agent_currency%2522%253Bs%253A3%253A%2522INR%2522%253B%257D%257Ds%253A16%253A%2522number_of_adults%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A20%253A%2522displayRoomTypeRates%2522%253Bs%253A6%253A%2522214.00%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A6%253A%2522200.00%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A20%253A%2522MARINO%2BBEACH%2BCOLOMBO%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522653%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25222%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A10%253A%2522Half%2BBoard%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A57%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2BHalf%2BBoard%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A58%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%252C%2BExtrabed%2B-%2B0%2B%2528Half%2BBoard%2529%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A45%253A%2522Colonial%2BManssion%2B-%2B01%2B-%2BDouble%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%25227.000000000000001%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E142%257E%257E%257E653%257E%257E%257E2%257E%257E%257E%257E%257E%257E%257E%257E%257E71100%257E%257E%257E0%257E%257E%257ES000000071%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%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A17%253A%25227.000000000000001%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A5%253A%252210.84%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25225.42%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A3%253A%2522214%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A3%253A%2522200%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A1%253A%25227%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%252253699----------S000000071%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A20%253A%2522Marino%2BBeach%2BColombo%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A66%253A%2522Colombo%2B03%252C%2BColombo%252C%2BSri%2BLanka%250D%250A%250D%250A0.9%2Bkm%2Bfrom%2BBarefoot%2BGarden%2BCafe%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000071%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%25221.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25223.16%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25225.42%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7D', create_date='2020-10-19 11:19:10';;
[10/19/2020 11:19:10], [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
        ('','','3022','confirmed','2020-10-19 11:19:10','Quotation Id - QTECHCD00093 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:19:10], [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
        ('','','3022','confirmed','2020-10-19 11:19:10','Enquiry Id - 404 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='booked' where unique_id='QTECHCD00093';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3021',q_id='QTECHCD00093',enquiry_id='404',quote_id='1893',backoffice_user='tfg',agent_id='9',create_date='2020-10-19 11:19:10',booked_from='agent_quote_itemized';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3022',q_id='QTECHCD00093',enquiry_id='404',quote_id='1894',backoffice_user='tfg',agent_id='9',create_date='2020-10-19 11:19:10',booked_from='agent_quote_itemized';
[10/19/2020 11:19:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE bookings SET reservation_id='QTECH2020101816' WHERE id IN (3021,3022);
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='3020', agent_id ='9', itenirary_id ='2', sequence = '2', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Ms', leader_first_name ='Ankita', leader_last_name ='Rao', city_id ='Colombo', country_id ='132', display_room_rate ='107.000', native_room_rate ='100.000', native_currency_code ='INR', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='0', status_date ='2020-10-19 09:50:41', create_date ='2020-10-19 09:50:41', source_type ='localsystem', expiration_date ='2020-10-19 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='Marino Beach Colombo', native_rate ='', display_rate ='', agent_rate ='107.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='100.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='7', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='7', wh_agent_markup ='0.000', basecurrency_multiplier ='0.01533', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.01533', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-10-19 11:19:52', modified_by ='tfg', display_currency_code ='INR', created_datetime ='2020-10-19 11:19:52', sub_agent_rate ='0.000', discount_to_sub ='0', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='';
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1161', old_reff_id ='525', booking_id ='3020', supplier_id ='S000000071', total_nights ='1', arrival_date ='2020/10/15', departure_date ='2020/10/16', hotel_id ='53699', hotel_name ='Marino Beach Colombo', hotel_address1 ='', hotel_phone ='', hotel_rating ='5.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6330', old_reff_id = '525', booking_id = '3020', booking_detail_id = '1161', salutations = 'Ms', room = '0', rid = '1743', first_name = 'Ankita', last_name = 'Rao' ,passenger_type = 'adult' ,age = '';
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '1743', old_reff_id = '525', booking_id = '3020', booking_detail_id = '1161', room_type_code = '1~~~51~~~620~~~3~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', room_type_description = 'Cilantro Suite - Full Board', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:107;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"100.00";}}' ,native_room_rate_total = '100' ,display_room_rate_total = '107' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3020', booking_detail_id = '1161', room_type_code = '1~~~51~~~620~~~3~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', meal_basis = 'Full Board', room_type_description = 'Cilantro Suite - Full Board', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"107";s:13:"whNightlyRate";s:0:"";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"100.00";}}' ,native_room_rate_total = '100' ,display_room_rate_total = '107' ,number_of_rooms = '1';
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3020', booking_detail_id = '1161', salutations = 'Ms', room = '', rid = '1746', first_name = 'Ankita', last_name = 'Rao' ,age = '';
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='testbookingdonotconfirm',native_currency_code='INR',display_currency_code='INR',cancellation_policy='                                ',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='7',agent_markup='7',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1.00000',service_type_detail='Marino Beach Colombo',current_status='confirmed',status_date='2020-10-19 11:19:52',service_date='2020-10-15',check_out_date='2020-10-16',display_room_rate= '107',display_discount='0.000',modified_datetime='2020-10-19 11:19:52',modified_by ='tfg',native_room_rate='100',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Ms',leader_first_name='Ankita',leader_last_name='Rao',nationality ='Indian',accounts_processed ='0',booking_type ='offline',agent_ref_no ='',supplier_profile_id ='1',expiration_date= '2020-10-19 00:00:00',source_type='localsystem',free_sale='yes',leader_phone='',admin_note='',comment_contract='' WHERE id='3020';
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-19 11:19:52',`log_type`= 'Accounts Data Added',`sql_query`= '',`log_description`= 'Accounts Only : Data Added by \&#039;tfg\&#039; From IP \&#039;43.250.210.76\&#039; for booking \&#039;3020\&#039;',`ip`= '43.250.210.76';
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='9', sub_agent_rate='', agent_rate='107', agent_markup='7', supplier_rate='100', wh_sub_agent_rate='', discount_to_sub='', wh_agent_rate='' where id='3020';
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'S000000071' , total_rooms= '1', arrival_date='2020/10/15', departure_date='2020/10/16', rate_code='~', hotel_address1='', hotel_name='Marino Beach Colombo', hotel_phone='' where booking_id ='3020';
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3020','confirmed','2020-10-19 11:19:52','Booking Modified by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:19:52], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_currency_multiplier set multiplier='1.00000' where booking_id='3020' and from_currency='INR' and to_currency='INR';
[10/19/2020 11:20:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-19 11:20:36',current_status='vouchered',voucher_hashcode='9644ba3d4e01775406e6aee12c740378661533020',vouchered_by ='tfg' where id='3020';
[10/19/2020 11:20:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3020',config_key='VOUCHER_DATE', config_value='2020-10-19 11:20:36',create_date='2020-10-19 11:20:36';
[10/19/2020 11:20:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/386' where id='3020' and is_invoiced!='yes';
[10/19/2020 11:20:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('107'),   credit_value= credit_value-('107') ,  cd_credit_usage=cd_credit_usage+('107') , cd_credit_value=cd_credit_value-('107')  WHERE id = '9';
[10/19/2020 11:20:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '9',credit_value= '20395.000',credit_usage= '79605.000',credit_limit= '100000',receipt_id= '',amount= '107',booking_id='3020',booking_cost= '107',receipt_allocation= '',balance= '107',ip='43.250.210.76',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-19 11:10:37';
[10/19/2020 11:20:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='INR',supplier_price='100',supplier_type='offline',supplier_id='S000000071',acc_type='purchase',accounting_multiplier='0.01533',booking_id='3020',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-19 11:20:37',account_invoice='2020/386',particulars='';
[10/19/2020 11:20:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3020','1','100.000','13.04347826087','IP','15','1','purchase','booking_rate_info','1482','supplier');
[10/19/2020 11:20:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/386',acc_export='1' where bid='1482';
[10/19/2020 11:20:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='107',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='3020',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-19 11:20:37',account_invoice='2020/386',particulars='';
[10/19/2020 11:20:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1483;
[10/19/2020 11:20:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1483',booking_id= '3020',invoice_number= '2020/386',service_type= 'hotel',booking_type= 'offline',service_name= 'Marino Beach Colombo',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2020/10/15',to_date= '2020/10/16',quantity= '1',price= '107',total_price= '107';
[10/19/2020 11:20:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3020','4','107.000','13.95652173913','OP','15','1','sale','booking_rate_info','1483','agent');
[10/19/2020 11:20:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/386',acc_export='1' where bid='1483';
[10/19/2020 11:20:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/386',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 38876 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,arvind.pandey@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-19 11:20:39';
[10/19/2020 11:20:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3020','vouchered-invoiced','2020-10-19 11:20:39',' by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:20:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3020',booking_detail_id ='3020',agent_id ='9',is_sub_agent ='N',parent_id ='',display_commission ='7',display_currency ='INR',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 7 %',create_date ='2020-10-19 11:20:39';
[10/19/2020 11:20:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3020',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/19/2020 11:20:40], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3020','vouchered','2020-10-19 11:20:40','Vouchered By tfg by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:20:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG103020 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27012 characters]',to_email_id= 'arvind.pandey@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= 'jignesh@qtechsoftware.com',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-19 11:20:41';
[10/19/2020 11:20:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3020','arvind.pandey@qtechsoftware.com');
[10/19/2020 11:20:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3020','jignesh@qtechsoftware.com');
[10/19/2020 11:20:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3020','ankita.rao@qtechsoftware.com');
[10/19/2020 11:24:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php], UPDATE `tax_configuration` SET
		`branch_country` = '132' ,
		`branch_state` = '' ,
        `branch` = '' ,
		`valid_from` = '2019-06-28' ,
		`valid_to` = '2020-10-20' ,
		`supplier_registered` = '1' ,
		`supplier_country` = '0' ,
        `supplier_type` = 'external' ,
		`service` = '1' ,
		`sub_service` = '' ,
		`exempted` = '0' ,
		`consumed` = 'IB' ,
		`has_consumed_location` = '0' ,
		`type` = 'IN' ,
		`system` = 'b2b' ,
		`input_tax_id` = '1' ,
		`input_tax_amt` = '15' ,
		`output_tax_id` = '4' ,
		`output_tax_amt` = '15' ,
		`updated_by` = 'tfg' ,
		`updated_on` = '2020-10-19 11:24:28'
		WHERE `id` = 7 ;
[10/19/2020 11:24:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-19 11:24:28',`log_type`= 'Tax Configuration',`sql_query`= ' UPDATE `tax_configuration` SET
		`branch_country` = \&#039;132\&#039; ,
		`branch_state` = \&#039;\&#039; ,
        `branch` = \&#039;\&#039; ,
		`valid_from` = \&#039;2019-06-28\&#039; ,
		`valid_to` = \&#039;2020-10-20\&#039; ,
		`supplier_registered` = \&#039;1\&#039; ,
		`supplier_country` = \&#039;0\&#039; ,
        `supplier_type` = \&#039;external\&#039; ,
		`service` = \&#039;1\&#039; ,
		`sub_service` = \&#039;\&#039; ,
		`exempted` = \&#039;0\&#039; ,
		`consumed` = \&#039;IB\&#039; ,
		`has_consumed_location` = \&#039;0\&#039; ,
		`type` = \&#039;IN\&#039; ,
		`system` = \&#039;b2b\&#039; ,
		`input_tax_id` = \&#039;1\&#039; ,
		`input_tax_amt` = \&#039;15\&#039; ,
		`output_tax_id` = \&#039;4\&#039; ,
		`output_tax_amt` = \&#039;15\&#039; ,
		`updated_by` = \&#039;tfg\&#039; ,
		`updated_on` = \&#039;2020-10-19 11:24:28\&#039;
		WHERE `id` = 7 ',`log_description`= 'Tax Configuration updated',`ip`= '43.250.210.76';
[10/19/2020 11:24:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],DELETE FROM tax_consumed_location WHERE tax_config_id=?;
[10/19/2020 11:24:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-06',to_date='2021-01-06',supplier_id='S000000241',hotel_id='53773',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-07',to_date='2021-01-07',supplier_id='S000000241',hotel_id='53773',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-08',to_date='2021-01-08',supplier_id='S000000241',hotel_id='53773',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-09',to_date='2021-01-09',supplier_id='S000000241',hotel_id='53773',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2021-01-10',to_date='2021-01-10',supplier_id='S000000241',hotel_id='53773',room_basis_id='1',room_class_id='1039',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-19 11:24:39',`log_type`= 'ExtraBed Rates',`sql_query`= '',`log_description`= 'Extrabed Rates For RateGainOne added successfully. Room Category :- Standard - Single, Extrabed - 1(Bed & Breakfast) From :- 06-01-2021 To :- 10-01-2021',`ip`= '60.254.42.133',`username`= 'tfg',`user_id`= 'S000000241';
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3753', `entity`='Hotels', `value`='53773' ;
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3753', `entity`='Suppliers', `value`='S000000241' ;
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3753', `entity`='Inventory', `value`='132' ;
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3753', `entity`='Room', `value`='1039' ;
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('53773@S000000241@2021-01-06@2021-01-06@@1039@1@1@@@0','06-01-2021~06-01-2021','53773','S000000241','2021-01-06','2021-01-06','1039','1','60.254.42.133','0','0','f878b4779e9bbf64a2dedc397821826b','Sa,Su','1','Supplier','132','A','100','100','AED','0','0','0','0','','','0','f878b4779e9bbf64a2dedc397821826b','2020-10-19 11:24:39','2020-10-19','Supplier','','','','','0','');
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-19 11:24:39',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For RateGainOne Rate:- 100 Room Category :- Standard - Single, Extrabed - 1 (Bed & Breakfast) Market :- All Market From:- 06-01-2021 To:- 10-01-2021',`ip`= '60.254.42.133',`username`= 'tfg',`user_id`= 'S000000241';
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3754', `entity`='Hotels', `value`='53773' ;
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3754', `entity`='Suppliers', `value`='S000000241' ;
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3754', `entity`='Inventory', `value`='132' ;
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3754', `entity`='Room', `value`='1039' ;
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3754', `entity`='Market', `value`='1' ;
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('53773@S000000241@2021-01-07@2021-01-07@@1039@1@1@@@0','07-01-2021~07-01-2021','53773','S000000241','2021-01-07','2021-01-07','1039','1','60.254.42.133','0','0','fddf1806eaf1ef147c8b9fb849ab6903','Sa,Su','1','Supplier','132','A','100','100','AED','0','0','0','0','','','0','fddf1806eaf1ef147c8b9fb849ab6903','2020-10-19 11:24:39','2020-10-19','Supplier','','','','','0',''),('53773@S000000241@2021-01-08@2021-01-08@@1039@1@1@@@0','08-01-2021~08-01-2021','53773','S000000241','2021-01-08','2021-01-08','1039','1','60.254.42.133','0','0','533758f1660302e38779e9cfe5b5467d','Sa,Su','1','Supplier','132','A','100','100','AED','0','0','0','0','','','0','533758f1660302e38779e9cfe5b5467d','2020-10-19 11:24:39','2020-10-19','Supplier','','','','','0',''),('53773@S000000241@2021-01-09@2021-01-09@@1039@1@1@@@0','09-01-2021~09-01-2021','53773','S000000241','2021-01-09','2021-01-09','1039','1','60.254.42.133','0','0','5324e350391fb41443ba5cb020f4153c','Sa,Su','1','Supplier','132','A','100','100','AED','0','0','0','0','','','0','5324e350391fb41443ba5cb020f4153c','2020-10-19 11:24:39','2020-10-19','Supplier','','','','','0',''),('53773@S000000241@2021-01-10@2021-01-10@@1039@1@1@@@0','10-01-2021~10-01-2021','53773','S000000241','2021-01-10','2021-01-10','1039','1','60.254.42.133','0','0','bf9ddd062ebfc19e66ba21b89663464b','Sa,Su','1','Supplier','132','A','100','100','AED','0','0','0','0','','','0','bf9ddd062ebfc19e66ba21b89663464b','2020-10-19 11:24:39','2020-10-19','Supplier','','','','','0','');
[10/19/2020 11:24:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[10/19/2020 11:25:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='5' where supplier_id='S000000241' AND hotel_id='53773' AND inventory_class_id='132'  AND date_from >='2021-01-06' AND date_from <='2021-01-07' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')='0';
[10/19/2020 11:25:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='5' where supplier_id='S000000241' AND hotel_id='53773' AND inventory_class_id='132'  AND date_from >='2021-01-06' AND date_from <='2021-01-07' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')>'0';
[10/19/2020 11:25:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-19 11:25:31',`log_type`= 'Inventory Allocation',`sql_query`= 'update room_rates set  availability=\&#039;5\&#039; where supplier_id=\&#039;S000000241\&#039; AND hotel_id=\&#039;53773\&#039; AND inventory_class_id=\&#039;132\&#039;  AND date_from &gt;=\&#039;2021-01-06\&#039; AND date_from &lt;=\&#039;2021-01-07\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)=\&#039;0\&#039;&lt;br&gt;update room_rates set  availability=\&#039;5\&#039; where supplier_id=\&#039;S000000241\&#039; AND hotel_id=\&#039;53773\&#039; AND inventory_class_id=\&#039;132\&#039;  AND date_from &gt;=\&#039;2021-01-06\&#039; AND date_from &lt;=\&#039;2021-01-07\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)&gt;\&#039;0\&#039;',`log_description`= 'Upadated Inventory Allocation For hotel RateGainOne- Inventory:-Standard From:-06-01-2021 To:-07-01-2021 Weekday Inventory Allocation:-5 Weekend Inventory Allocation:-5',`ip`= '60.254.42.133',`username`= 'tfg',`user_id`= 'S000000241';
[10/19/2020 11:25:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3755', `entity`='Hotels', `value`='53773' ;
[10/19/2020 11:25:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3755', `entity`='Suppliers', `value`='S000000241' ;
[10/19/2020 11:25:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3755', `entity`='Inventory', `value`='132' ;
[10/19/2020 11:25:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='5' where supplier_id='S000000241' AND hotel_id='53773' AND inventory_class_id='132'  AND date_from >='2021-01-09' AND date_from <='2021-01-10' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')='0';
[10/19/2020 11:25:31], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='5' where supplier_id='S000000241' AND hotel_id='53773' AND inventory_class_id='132'  AND date_from >='2021-01-09' AND date_from <='2021-01-10' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')>'0';
[10/19/2020 11:25:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-19 11:25:32',`log_type`= 'Inventory Allocation',`sql_query`= 'update room_rates set  availability=\&#039;5\&#039; where supplier_id=\&#039;S000000241\&#039; AND hotel_id=\&#039;53773\&#039; AND inventory_class_id=\&#039;132\&#039;  AND date_from &gt;=\&#039;2021-01-09\&#039; AND date_from &lt;=\&#039;2021-01-10\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)=\&#039;0\&#039;&lt;br&gt;update room_rates set  availability=\&#039;5\&#039; where supplier_id=\&#039;S000000241\&#039; AND hotel_id=\&#039;53773\&#039; AND inventory_class_id=\&#039;132\&#039;  AND date_from &gt;=\&#039;2021-01-09\&#039; AND date_from &lt;=\&#039;2021-01-10\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)&gt;\&#039;0\&#039;',`log_description`= 'Upadated Inventory Allocation For hotel RateGainOne- Inventory:-Standard From:-09-01-2021 To:-10-01-2021 Weekday Inventory Allocation:-5 Weekend Inventory Allocation:-5',`ip`= '60.254.42.133',`username`= 'tfg',`user_id`= 'S000000241';
[10/19/2020 11:25:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3756', `entity`='Hotels', `value`='53773' ;
[10/19/2020 11:25:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3756', `entity`='Suppliers', `value`='S000000241' ;
[10/19/2020 11:25:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3756', `entity`='Inventory', `value`='132' ;
[10/19/2020 11:27:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],INSERT INTO `tax_configuration` (`branch_country`, `branch_state`, `valid_from`, `valid_to`, `supplier_registered`,`supplier_country`,`supplier_type` , `service`, `sub_service`, `exempted`,`consumed`,`has_consumed_location`, `type`,`system`, `input_tax_id`, `input_tax_amt`,`output_tax_id`, `output_tax_amt`,`created_by`,`created_on`,`branch`)
	 	VALUES ('132','', '2020-10-21', '2050-12-31', '1', '0','external', '1', '', '0','IB' , '0' , 'IN', 'b2b', '1', '3', '4', '15','tfg','2020-10-19 11:27:04','');
[10/19/2020 11:27:04], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-19 11:27:04',`log_type`= 'Tax Configuration',`sql_query`= 'INSERT INTO `tax_configuration` (`branch_country`, `branch_state`, `valid_from`, `valid_to`, `supplier_registered`,`supplier_country`,`supplier_type` , `service`, `sub_service`, `exempted`,`consumed`,`has_consumed_location`, `type`,`system`, `input_tax_id`, `input_tax_amt`,`output_tax_id`, `output_tax_amt`,`created_by`,`created_on`,`branch`)
	 	VALUES (\&#039;132\&#039;,\&#039;\&#039;, \&#039;2020-10-21\&#039;, \&#039;2050-12-31\&#039;, \&#039;1\&#039;, \&#039;0\&#039;,\&#039;external\&#039;, \&#039;1\&#039;, \&#039;\&#039;, \&#039;0\&#039;,\&#039;IB\&#039; , \&#039;0\&#039; , \&#039;IN\&#039;, \&#039;b2b\&#039;, \&#039;1\&#039;, \&#039;3\&#039;, \&#039;4\&#039;, \&#039;15\&#039;,\&#039;tfg\&#039;,\&#039;2020-10-19 11:27:04\&#039;,\&#039;\&#039;)',`log_description`= 'Tax Configuration added',`ip`= '43.250.210.76';
[10/19/2020 11:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '7'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-06' AND inventory_class_id= '132';
[10/19/2020 11:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-01-06',availability = '7',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_11_27_35_1603106855_53773.xml',create_date = '2020-10-19 11:27:35';
[10/19/2020 11:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '7'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-07' AND inventory_class_id= '132';
[10/19/2020 11:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-01-07',availability = '7',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_11_27_35_1603106855_53773.xml',create_date = '2020-10-19 11:27:35';
[10/19/2020 11:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '7'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-08' AND inventory_class_id= '132';
[10/19/2020 11:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-01-08',availability = '7',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_11_27_35_1603106855_53773.xml',create_date = '2020-10-19 11:27:35';
[10/19/2020 11:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '7'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-09' AND inventory_class_id= '132';
[10/19/2020 11:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-01-09',availability = '7',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_11_27_35_1603106855_53773.xml',create_date = '2020-10-19 11:27:35';
[10/19/2020 11:27:35], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],UPDATE room_rates SET  availability= '7'  WHERE 1  AND hotel_id= '53773' AND supplier_id= 'S000000241' AND date_from= '2021-01-10' AND inventory_class_id= '132';
[10/19/2020 11:27:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],INSERT INTO channel_manager_pushed_info SET hotel_id = '53773',supplier_id = 'S000000241',inventory_class_id = '132',room_basis = '',date_from = '2021-01-10',availability = '7',type = 'availability',channel_manager = 'rategain',log_path = 'https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/supplier_logs/rate_gain/53773/19_10_2020/request_getHotelARIUpdate_11_27_35_1603106855_53773.xml',create_date = '2020-10-19 11:27:36';
[10/19/2020 11:27:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into channel_manager_logs SET create_date= '2020-10-19 11:27:35',channel_manager_name= 'rategain',hotel_id= '53773',rate_id= '132',start_date= '2021-01-06';
[10/19/2020 11:27:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php],insert into email_logs SET `subject`= 'Rate Modified for RateGainOne by RateGain(CHANNEL_MANAGER_UPDATES)',from_email_id= 'sanket.desai@qtechsoftware.com',body= 'RGVhciBUZWFtICw8YnI+PGJyPlVzZXIgPGI+PC9iPiBoYXMgbW9kaWZpZWQgdGhlIHJhdGVzIGZvciBSYXRlR2Fpbk9uZSA8YnI+PGJyPkJlbG93IGFyZSB0aGUgZGV0YWlsczxicj48YnI+IDxiPlN1cHBsaWVyPC9iPiA6IFJhdGVHYWluU3VwcGxpZXI8YnI+IDxiPkRhdGUgPC9iPiA6IDIwMjAtMTAtMTkgMTE6Mjc6MzU8YnI+IDxiPkhvdGVsIDwvYj4gOiBSYXRlR2Fpbk9uZTxicj4gPGI+SG90ZWwgQ29kZTwvYj4gOiA1Mzc3Mzxicj4gPGI+U3VwcGxpZXIgSUQgPC9iPiA6IFMwMDAwMDAyNDE8YnI+IDxiPkRhdGVzIDwvYj4gOiAyMDIxLTAxLTA2ICwgMjAyMS0wMS0wNyAsIDIwMjEtMDEtMDggLCAyMDIxLTAxLTA5ICwgMjAyMS0wMS0xMDxicj4=',to_email_id= 'sanket.desai@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/api/rate_gain_response.php',create_date= '2020-10-19 11:27:36';
[10/19/2020 11:27:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/api/rate_gain_response.php], insert into email_trigger set  subject ='Rate Modified for RateGainOne by RateGain',  message='Dear Team ,<br><br>User <b></b> has modified the rates for RateGainOne <br><br>Below are the details<br><br> <b>Supplier</b> : RateGainSupplier<br> <b>Date </b> : 2020-10-19 11:27:35<br> <b>Hotel </b> : RateGainOne<br> <b>Hotel Code</b> : 53773<br> <b>Supplier ID </b> : S000000241<br> <b>Dates </b> : 2021-01-06 , 2021-01-07 , 2021-01-08 , 2021-01-09 , 2021-01-10<br>',  email_sent ='yes', create_date ='2020-10-19 11:27:36', email_sent_to ='sanket.desai@qtechsoftware.com,TESTER_EMAIL_ID', email_type ='CHANNEL_MANAGER_UPDATES';
[10/19/2020 11:27:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],UPDATE tax_master SET `tax_name`= 'Transfer Tax',`tax_value`= '3.5',`tax_type`= 'OP',`updated_by`= 'tfg',`updated_on`= '2020-10-19 11:27:49',`reverse`= '0'   WHERE id='4' ;
[10/19/2020 11:27:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-19 11:27:49',`log_type`= 'Tax Master',`sql_query`= 'UPDATE tax_master SET `tax_name`= \&#039;Transfer Tax\&#039;,`tax_value`= \&#039;3.5\&#039;,`tax_type`= \&#039;OP\&#039;,`updated_by`= \&#039;tfg\&#039;,`updated_on`= \&#039;2020-10-19 11:27:49\&#039;,`reverse`= \&#039;0\&#039;   WHERE id=\&#039;4\&#039; ',`log_description`= 'Tax Master updated for Transfer Tax value 3.5 and type OP',`ip`= '43.250.210.76';
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings set history_booking_id ='3021', agent_id ='9', itenirary_id ='2', sequence = '2', confirmation_number ='', payment_confirmation_no ='', voucher_id ='', voucher_hashcode ='', email_id ='', leader_title ='Ms', leader_first_name ='Ankita', leader_last_name ='Rao', city_id ='Colombo', country_id ='132', display_room_rate ='107.000', native_room_rate ='100.000', native_currency_code ='INR', additional_charge ='0.000', cancellation_policy ='', supplier_cancellation_policy ='', current_status ='confirmed', booking_status ='0', status_date ='2020-10-19 11:19:10', create_date ='2020-10-19 11:19:10', source_type ='localsystem', expiration_date ='2020-10-19 00:00:00', comment_contract ='', admin_note ='', is_payment_gateway ='0', service_type ='hotel', service_type_detail ='Marino Beach Colombo', native_rate ='', display_rate ='', agent_rate ='107.000', wh_sub_agent_rate ='0.000', wh_agent_rate ='0.000', supplier_rate ='100.000', special_comment ='', special_remark ='', sms_status ='', is_xml ='0', consultant_id ='tfg', admin_booked ='0', emailed_status ='0', applied_multiplier ='1.00000', applied_markup ='7', wh_applied_markup ='0.000', original_voucher ='', subagent_markup ='', agent_markup ='7', wh_agent_markup ='0.000', basecurrency_multiplier ='0.01533', wh_basecurrency_multiplier ='1', basecurrency_multiplier_native ='0.01533', wh_basecurrency_multiplier_native ='1', agent_currency_multiplier ='1.00000', wh_agent_currency_multiplier ='1.000', modified_datetime ='2020-10-19 11:28:24', modified_by ='tfg', display_currency_code ='INR', created_datetime ='2020-10-19 11:28:24', sub_agent_rate ='0.000', discount_to_sub ='0', created_by ='tfg', site_id ='0', applicable_service_tax ='0.000', wh_parent_agent_id ='0', wh_agent_id ='0', nationality ='Indian', ip_addr ='';
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_bookings_details  set  history_booking_detail_id ='1162', old_reff_id ='526', booking_id ='3021', supplier_id ='S000000071', total_nights ='1', arrival_date ='2020/10/15', departure_date ='2020/10/16', hotel_id ='53699', hotel_name ='Marino Beach Colombo', hotel_address1 ='', hotel_phone ='', hotel_rating ='5.0', rate_code ='~', touricoRoomResId ='', gta_item_confirm_ref ='', channel_manager ='', reservation_pushed ='0', gtaToken ='';
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_passangers set history_passenger_id = '6331', old_reff_id = '526', booking_id = '3021', booking_detail_id = '1162', salutations = 'Ms', room = '0', rid = '1744', first_name = 'Ankita', last_name = 'Rao' ,passenger_type = 'adult' ,age = '';
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO history_booking_room_detail set rid = '1744', old_reff_id = '526', booking_id = '3021', booking_detail_id = '1162', room_type_code = '1~~~51~~~620~~~3~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', room_type_description = 'Cilantro Suite - Full Board', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:107;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"100.00";}}' ,native_room_rate_total = '100' ,display_room_rate_total = '107' ,wh_room_rate_total = '' ,number_of_rooms = '1';
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from booking_room_detail WHERE booking_id=?;
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],delete from passangers WHERE booking_id=?;
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_room_detail set booking_id = '3021', booking_detail_id = '1162', room_type_code = '1~~~51~~~620~~~3~~~~~~~~~71100~~~0~~~S000000071', room_name = 'single', meal_basis = 'Full Board', room_type_description = 'Cilantro Suite - Full Board', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";s:3:"107";s:13:"whNightlyRate";s:0:"";}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";s:6:"100.00";}}' ,native_room_rate_total = '100' ,display_room_rate_total = '107' ,number_of_rooms = '1';
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO passangers set booking_id = '3021', booking_detail_id = '1162', salutations = 'Ms', room = '', rid = '1747', first_name = 'Ankita', last_name = 'Rao' ,age = '';
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],UPDATE bookings SET confirmation_number='42535',native_currency_code='INR',display_currency_code='INR',cancellation_policy='                                ',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='7',agent_markup='7',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1.00000',service_type_detail='Marino Beach Colombo',current_status='confirmed',status_date='2020-10-19 11:28:24',service_date='2020-10-15',check_out_date='2020-10-16',display_room_rate= '107',display_discount='0.000',modified_datetime='2020-10-19 11:28:24',modified_by ='tfg',native_room_rate='100',native_discount='0.000',additional_charge='0.000',applicable_service_tax='',leader_title='Ms',leader_first_name='Ankita',leader_last_name='Rao',nationality ='Indian',accounts_processed ='0',booking_type ='offline',agent_ref_no ='',supplier_profile_id ='1',expiration_date= '2020-10-19 00:00:00',source_type='localsystem',free_sale='yes',leader_phone='',admin_note='',comment_contract='' WHERE id='3021';
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-19 11:28:24',`log_type`= 'Accounts Data Added',`sql_query`= '',`log_description`= 'Accounts Only : Data Added by \&#039;tfg\&#039; From IP \&#039;43.250.210.76\&#039; for booking \&#039;3021\&#039;',`ip`= '43.250.210.76';
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings set  parent_agent_id='9', sub_agent_rate='', agent_rate='107', agent_markup='7', supplier_rate='100', wh_sub_agent_rate='', discount_to_sub='', wh_agent_rate='' where id='3021';
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update bookings_details set total_nights='1' , supplier_id= 'S000000071' , total_rooms= '1', arrival_date='2020/10/15', departure_date='2020/10/16', rate_code='~', hotel_address1='', hotel_name='Marino Beach Colombo', hotel_phone='' where booking_id ='3021';
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3021','confirmed','2020-10-19 11:28:24','Booking Modified by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:28:24], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/bookings_modification.php],update booking_currency_multiplier set multiplier='1.00000' where booking_id='3021' and from_currency='INR' and to_currency='INR';
[10/19/2020 11:29:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-19 11:29:10',current_status='vouchered',voucher_hashcode='dadb016177aed3dbdea69e323420130b605833021',vouchered_by ='tfg' where id='3021';
[10/19/2020 11:29:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3021',config_key='VOUCHER_DATE', config_value='2020-10-19 11:29:10',create_date='2020-10-19 11:29:10';
[10/19/2020 11:29:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/386' where id='3021' and is_invoiced!='yes';
[10/19/2020 11:29:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('107'),   credit_value= credit_value-('107') ,  cd_credit_usage=cd_credit_usage+('107') , cd_credit_value=cd_credit_value-('107')  WHERE id = '9';
[10/19/2020 11:29:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '9',credit_value= '20288.000',credit_usage= '79712.000',credit_limit= '100000',receipt_id= '',amount= '107',booking_id='3021',booking_cost= '107',receipt_allocation= '',balance= '107',ip='43.250.210.76',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-19 11:10:10';
[10/19/2020 11:29:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='INR',supplier_price='100',supplier_type='offline',supplier_id='S000000071',acc_type='purchase',accounting_multiplier='0.01533',booking_id='3021',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-19 11:29:10',account_invoice='2020/386',particulars='';
[10/19/2020 11:29:10], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3021','1','100.000','13.04347826087','IP','15','1','purchase','booking_rate_info','1484','supplier');
[10/19/2020 11:29:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/386',acc_export='1' where bid='1484';
[10/19/2020 11:29:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='107',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='3021',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-19 11:29:10',account_invoice='2020/386',particulars='';
[10/19/2020 11:29:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1485;
[10/19/2020 11:29:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1485',booking_id= '3021',invoice_number= '2020/386',service_type= 'hotel',booking_type= 'offline',service_name= 'Marino Beach Colombo',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2020/10/15',to_date= '2020/10/16',quantity= '1',price= '107',total_price= '107';
[10/19/2020 11:29:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3021','4','107.000','13.95652173913','OP','15','1','sale','booking_rate_info','1485','agent');
[10/19/2020 11:29:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/386',acc_export='1' where bid='1485';
[10/19/2020 11:29:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/386',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 40644 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,arvind.pandey@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-19 11:29:13';
[10/19/2020 11:29:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3021','vouchered-invoiced','2020-10-19 11:29:13',' by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:29:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3021',booking_detail_id ='3021',agent_id ='9',is_sub_agent ='N',parent_id ='',display_commission ='7',display_currency ='INR',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 7 %',create_date ='2020-10-19 11:29:13';
[10/19/2020 11:29:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3021',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/19/2020 11:29:13], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3021','vouchered','2020-10-19 11:29:13','Vouchered By tfg by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:29:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG103021 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27012 characters]',to_email_id= 'arvind.pandey@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= 'jignesh@qtechsoftware.com',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-19 11:29:14';
[10/19/2020 11:29:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3021','arvind.pandey@qtechsoftware.com');
[10/19/2020 11:29:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3021','jignesh@qtechsoftware.com');
[10/19/2020 11:29:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3021','ankita.rao@qtechsoftware.com');
[10/19/2020 11:29:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='testbooking',status_date='2020-10-19 11:29:15',current_status='vouchered',voucher_hashcode='781dc0327bfbdfd3fd5016aca784a7ce835623022',vouchered_by ='tfg' where id='3022';
[10/19/2020 11:29:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3022',config_key='VOUCHER_DATE', config_value='2020-10-19 11:29:15',create_date='2020-10-19 11:29:15';
[10/19/2020 11:29:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/386' where id='3022' and is_invoiced!='yes';
[10/19/2020 11:29:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],UPDATE agents SET credit_usage=credit_usage+('214'),   credit_value= credit_value-('214') ,  cd_credit_usage=cd_credit_usage+('214') , cd_credit_value=cd_credit_value-('214')  WHERE id = '9';
[10/19/2020 11:29:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '9',credit_value= '20074.000',credit_usage= '79926.000',credit_limit= '100000',receipt_id= '',amount= '214',booking_id='3022',booking_cost= '214',receipt_allocation= '',balance= '214',ip='43.250.210.76',user_type='admin',admin_id='tfg',temp_credit_limit='',log_type='Add Invoice',note='Add Invoice',create_date='2020-10-19 11:10:15';
[10/19/2020 11:29:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='0',sub_agent_price='0',supplier_currency='INR',supplier_price='200',supplier_type='offline',supplier_id='S000000071',acc_type='purchase',accounting_multiplier='0.01533',booking_id='3022',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-19 11:29:15',account_invoice='2020/386',particulars='';
[10/19/2020 11:29:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3022','1','200.000','5.8252427184466','IP','3','1','purchase','booking_rate_info','1486','supplier');
[10/19/2020 11:29:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/386',acc_export='1' where bid='1486';
[10/19/2020 11:29:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into booking_rate_info set agent_price='214',sub_agent_price='0',supplier_price='0',acc_type='sale',accounting_multiplier='0.01533',booking_id='3022',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-19 11:29:15',account_invoice='2020/386',particulars='';
[10/19/2020 11:29:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1487;
[10/19/2020 11:29:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1487',booking_id= '3022',invoice_number= '2020/386',service_type= 'hotel',booking_type= 'offline',service_name= 'Marino Beach Colombo',type= 'sale',room_type= 'single',quantity_room= '1',from_date= '2020/11/24',to_date= '2020/11/25',quantity= '1',price= '214',total_price= '214';
[10/19/2020 11:29:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO `bookings_tax` (`booking_id`, `tax_id`, `tax_value`, `tax_amount`, `tax_type` ,`tax_percent`, `branch_id`, `acc_type` , `transaction`, `transaction_id`, `entity` )
                VALUES ('3022','4','214.000','27.913043478261','OP','15','1','sale','booking_rate_info','1487','agent');
[10/19/2020 11:29:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/386',acc_export='1' where bid='1487';
[10/19/2020 11:29:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/386',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 42412 characters]',to_email_id= 'ankita.rao@qtechsoftware.com,arvind.pandey@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-19 11:29:18';
[10/19/2020 11:29:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3022','vouchered-invoiced','2020-10-19 11:29:18',' by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:29:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3022',booking_detail_id ='3022',agent_id ='9',is_sub_agent ='N',parent_id ='',display_commission ='14',display_currency ='INR',paid ='N',type ='hotel',description ='Agent Mark Up Percentage is 7 %',create_date ='2020-10-19 11:29:18';
[10/19/2020 11:29:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3022',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/19/2020 11:29:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3022','vouchered','2020-10-19 11:29:18','Vouchered By tfg by tfg','tfg','43.250.210.76','tfg','','');
[10/19/2020 11:29:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG103022 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 26356 characters]',to_email_id= 'arvind.pandey@qtechsoftware.com,ankita.rao@qtechsoftware.com',cc= 'jignesh@qtechsoftware.com',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-19 11:29:19';
[10/19/2020 11:29:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3022','arvind.pandey@qtechsoftware.com');
[10/19/2020 11:29:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3022','jignesh@qtechsoftware.com');
[10/19/2020 11:29:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3022','ankita.rao@qtechsoftware.com');
