[10/20/2020 08:02:20], [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%2210ca8a21419ce498d119c91e2984de6f%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%2210ca8a21419ce498d119c91e2984de6f%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%22QTECH2020101817%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-20 08:02:20';
[10/20/2020 08:02:20], [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 = 'QTECH2020101817' , display_currency_code = 'INR' , created_datetime='2020-10-20 08:02:20' , create_date='2020-10-20 08:02:20' , 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/20/2020 08:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3025'
        ;
[10/20/2020 08:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into bookings_details set booking_id ='3025' , hotel_id='53699' , hotel_name='Marino Beach Colombo' , hotel_address1='' , hotel_phone='' , hotel_rating='5.0';
[10/20/2020 08:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_room_detail set booking_id = '3025', booking_detail_id = '1166', 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/20/2020 08:02:20], [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-20 08:02:20',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-20 00:00:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3025';
[10/20/2020 08:02:20], [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='3025';
[10/20/2020 08:02:20], [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 ='3025';
[10/20/2020 08:02:20], [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
        ('','','3025','confirmed','2020-10-20 08:02:20','confirmed by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 08:02:20], [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 ('3025','1166','1752','0','Ms','Ankita','Rao','adult','');
[10/20/2020 08:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3025', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223025%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%2220%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%22QTECH2020101817%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-20 08:02:20';;
[10/20/2020 08:02:20], [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
        ('','','3025','confirmed','2020-10-20 08:02:20','Quotation Id - QTECHCD00093 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 08:02:20], [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
        ('','','3025','confirmed','2020-10-20 08:02:20','Enquiry Id - 404 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 08:02:20], [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 = 'QTECH2020101817' , display_currency_code = 'INR' , created_datetime='2020-10-20 08:02:20' , create_date='2020-10-20 08:02:20' , 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/20/2020 08:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3026'
        ;
[10/20/2020 08:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into bookings_details set booking_id ='3026' , hotel_id='53699' , hotel_name='Marino Beach Colombo' , hotel_address1='' , hotel_phone='' , hotel_rating='5.0';
[10/20/2020 08:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_room_detail set booking_id = '3026', booking_detail_id = '1167', 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/20/2020 08:02:20], [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-20 08:02:20',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-20 00:00:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3026';
[10/20/2020 08:02:20], [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='3026';
[10/20/2020 08:02:20], [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 ='3026';
[10/20/2020 08:02:20], [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
        ('','','3026','confirmed','2020-10-20 08:02:20','confirmed by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 08:02:20], [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 ('3026','1167','1753','0','Ms','Ankita','Rao','adult','');
[10/20/2020 08:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3026', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223026%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%2220%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%22QTECH2020101817%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-20 08:02:20';;
[10/20/2020 08:02:20], [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
        ('','','3026','confirmed','2020-10-20 08:02:20','Quotation Id - QTECHCD00093 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 08:02:20], [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
        ('','','3026','confirmed','2020-10-20 08:02:20','Enquiry Id - 404 created on behalf of Agent - Arvind Pandey(9) by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 08:02:20], [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/20/2020 08:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3025',q_id='QTECHCD00093',enquiry_id='404',quote_id='1893',backoffice_user='tfg',agent_id='9',create_date='2020-10-20 08:02:20',booked_from='agent_quote_itemized';
[10/20/2020 08:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3026',q_id='QTECHCD00093',enquiry_id='404',quote_id='1894',backoffice_user='tfg',agent_id='9',create_date='2020-10-20 08:02:20',booked_from='agent_quote_itemized';
[10/20/2020 08:02:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE bookings SET reservation_id='QTECH2020101817' WHERE id IN (3025,3026);
[10/20/2020 08:02:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2020-10-20 08:02:41',current_status='vouchered',voucher_hashcode='3b9aef3789bddedc0a0e86035268c792911803025',vouchered_by ='tfg' where id='3025';
[10/20/2020 08:02:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3025',config_key='VOUCHER_DATE', config_value='2020-10-20 08:02:41',create_date='2020-10-20 08:02:41';
[10/20/2020 08:02:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/387' where id='3025' and is_invoiced!='yes';
[10/20/2020 08:02:42], [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/20/2020 08:02:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '9',credit_value= '19646.000',credit_usage= '80354.000',credit_limit= '100000',receipt_id= '',amount= '107',booking_id='3025',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-20 08:10:42';
[10/20/2020 08:02:42], [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='3025',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-20 08:02:42',account_invoice='2020/387',particulars='';
[10/20/2020 08:02:42], [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 ('3025','1','100.000','13.04347826087','IP','15','1','purchase','booking_rate_info','1492','supplier');
[10/20/2020 08:02:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/387',acc_export='1' where bid='1492';
[10/20/2020 08:02:42], [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='3025',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-20 08:02:42',account_invoice='2020/387',particulars='';
[10/20/2020 08:02:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1493;
[10/20/2020 08:02:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1493',booking_id= '3025',invoice_number= '2020/387',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/20/2020 08:02:42], [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 ('3025','4','107.000','13.95652173913','OP','15','1','sale','booking_rate_info','1493','agent');
[10/20/2020 08:02:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/387',acc_export='1' where bid='1493';
[10/20/2020 08:02:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/387',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 30044 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-20 08:02:44';
[10/20/2020 08:02:44], [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
        ('','','3025','vouchered-invoiced','2020-10-20 08:02:44',' by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 08:02:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3025',booking_detail_id ='3025',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-20 08:02:44';
[10/20/2020 08:02:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3025',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/20/2020 08:02:44], [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
        ('','','3025','vouchered','2020-10-20 08:02:44','Vouchered By tfg by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 08:02:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG103025 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 26960 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-20 08:02:45';
[10/20/2020 08:02:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3025','ankita.rao@qtechsoftware.com');
[10/20/2020 08:02:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3025','ankita.rao@qtechsoftware.com');
[10/20/2020 08:02:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3025','ankita.rao@qtechsoftware.com');
[10/20/2020 08:02:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set voucher_id='test',status_date='2020-10-20 08:02:46',current_status='vouchered',voucher_hashcode='a70131dcf959cf7d467fd97058c3ae05492853026',vouchered_by ='tfg' where id='3026';
[10/20/2020 08:02:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],Insert into booking_configuration set booking_id='3026',config_key='VOUCHER_DATE', config_value='2020-10-20 08:02:46',create_date='2020-10-20 08:02:46';
[10/20/2020 08:02:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update bookings set is_invoiced='yes',invoice_number= '2020/387' where id='3026' and is_invoiced!='yes';
[10/20/2020 08:02:46], [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/20/2020 08:02:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into  agent_credit_log SET agent_id= '9',credit_value= '19432.000',credit_usage= '80568.000',credit_limit= '100000',receipt_id= '',amount= '214',booking_id='3026',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-20 08:10:46';
[10/20/2020 08:02:46], [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='3026',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-20 08:02:46',account_invoice='2020/387',particulars='';
[10/20/2020 08:02:46], [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 ('3026','0','200.000','0','IP','0','1','purchase','booking_rate_info','1494','supplier');
[10/20/2020 08:02:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/387',acc_export='1' where bid='1494';
[10/20/2020 08:02:47], [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='3026',booking_log='Booking Vouchered',type='Sale',create_date='2020-10-20 08:02:46',account_invoice='2020/387',particulars='';
[10/20/2020 08:02:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],DELETE FROM accounts_invoice_transaction WHERE bid = 1495;
[10/20/2020 08:02:47], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO accounts_invoice_transaction SET bid= '1495',booking_id= '3026',invoice_number= '2020/387',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/20/2020 08:02:47], [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 ('3026','4','214.000','7.2367149758454','OP','3.5','1','sale','booking_rate_info','1495','agent');
[10/20/2020 08:02:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],update booking_rate_info set account_invoice_number='2020/387',acc_export='1' where bid='1495';
[10/20/2020 08:02:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= 'Invoice :2020/387',from_email_id= 'ankita.rao@qtechsoftware.com',body= '[encoded data, 31808 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-20 08:02:49';
[10/20/2020 08:02:49], [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
        ('','','3026','vouchered-invoiced','2020-10-20 08:02:49',' by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 08:02:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],INSERT INTO agent_commission SET booking_id ='3026',booking_detail_id ='3026',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-20 08:02:49';
[10/20/2020 08:02:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into accounting_status set booking_id ='3026',acc_sales_export='0',acc_purchase_export='0',acc_status='A';
[10/20/2020 08:02:49], [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
        ('','','3026','vouchered','2020-10-20 08:02:49','Vouchered By tfg by tfg','tfg','43.250.210.76','tfg','','');
[10/20/2020 08:02:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into email_logs SET `subject`= ' TFG103026 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 26348 characters]',to_email_id= 'ankita.rao@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/tms/add_voucher.php',create_date= '2020-10-20 08:02:50';
[10/20/2020 08:02:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3026','ankita.rao@qtechsoftware.com');
[10/20/2020 08:02:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3026','ankita.rao@qtechsoftware.com');
[10/20/2020 08:02:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_voucher.php],insert into temp(booking_id,mail_send_to)values('3026','ankita.rao@qtechsoftware.com');
[10/20/2020 08:03:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php], UPDATE `tax_configuration` SET
		`branch_country` = '132' ,
		`branch_state` = '' ,
        `branch` = '' ,
		`valid_from` = '2020-10-21' ,
		`valid_to` = '2050-12-31' ,
		`supplier_registered` = '1' ,
		`supplier_country` = '0' ,
        `supplier_type` = 'internal' ,
		`service` = '1' ,
		`sub_service` = '' ,
		`exempted` = '0' ,
		`consumed` = 'IB' ,
		`has_consumed_location` = '0' ,
		`type` = 'IN' ,
		`system` = 'b2b' ,
		`input_tax_id` = '0' ,
		`input_tax_amt` = '0' ,
		`output_tax_id` = '4' ,
		`output_tax_amt` = '3.5' ,
		`updated_by` = 'tfg' ,
		`updated_on` = '2020-10-20 08:03:00'
		WHERE `id` = 23 ;
[10/20/2020 08:03:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 08:03:00',`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;2020-10-21\&#039; ,
		`valid_to` = \&#039;2050-12-31\&#039; ,
		`supplier_registered` = \&#039;1\&#039; ,
		`supplier_country` = \&#039;0\&#039; ,
        `supplier_type` = \&#039;internal\&#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;0\&#039; ,
		`input_tax_amt` = \&#039;0\&#039; ,
		`output_tax_id` = \&#039;4\&#039; ,
		`output_tax_amt` = \&#039;3.5\&#039; ,
		`updated_by` = \&#039;tfg\&#039; ,
		`updated_on` = \&#039;2020-10-20 08:03:00\&#039;
		WHERE `id` = 23 ',`log_description`= 'Tax Configuration updated',`ip`= '43.250.210.76';
[10/20/2020 08:03:00], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],DELETE FROM tax_consumed_location WHERE tax_config_id=?;
[10/20/2020 08:05:07], [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', '29', '', '0','IB' , '0' , 'IN', 'b2b', '0', '', '4', '3.5','tfg','2020-10-20 08:05:07','');
[10/20/2020 08:05:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 08:05:07',`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;29\&#039;, \&#039;\&#039;, \&#039;0\&#039;,\&#039;IB\&#039; , \&#039;0\&#039; , \&#039;IN\&#039;, \&#039;b2b\&#039;, \&#039;0\&#039;, \&#039;\&#039;, \&#039;4\&#039;, \&#039;3.5\&#039;,\&#039;tfg\&#039;,\&#039;2020-10-20 08:05:07\&#039;,\&#039;\&#039;)',`log_description`= 'Tax Configuration added',`ip`= '43.250.210.76';
[10/20/2020 08:05:07], [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','internal', '29', '', '0','IB' , '0' , 'IN', 'b2b', '0', '', '4', '3.5','tfg','2020-10-20 08:05:07','');
[10/20/2020 08:05:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 08:05:07',`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;internal\&#039;, \&#039;29\&#039;, \&#039;\&#039;, \&#039;0\&#039;,\&#039;IB\&#039; , \&#039;0\&#039; , \&#039;IN\&#039;, \&#039;b2b\&#039;, \&#039;0\&#039;, \&#039;\&#039;, \&#039;4\&#039;, \&#039;3.5\&#039;,\&#039;tfg\&#039;,\&#039;2020-10-20 08:05:07\&#039;,\&#039;\&#039;)',`log_description`= 'Tax Configuration added',`ip`= '43.250.210.76';
[10/20/2020 08:05:07], [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','substitute', '29', '', '0','IB' , '0' , 'IN', 'b2b', '0', '', '4', '3.5','tfg','2020-10-20 08:05:07','');
[10/20/2020 08:05:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 08:05:07',`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;substitute\&#039;, \&#039;29\&#039;, \&#039;\&#039;, \&#039;0\&#039;,\&#039;IB\&#039; , \&#039;0\&#039; , \&#039;IN\&#039;, \&#039;b2b\&#039;, \&#039;0\&#039;, \&#039;\&#039;, \&#039;4\&#039;, \&#039;3.5\&#039;,\&#039;tfg\&#039;,\&#039;2020-10-20 08:05:07\&#039;,\&#039;\&#039;)',`log_description`= 'Tax Configuration added',`ip`= '43.250.210.76';
[10/20/2020 08:05:07], [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', '30', '', '0','IB' , '0' , 'IN', 'b2b', '0', '', '4', '3.5','tfg','2020-10-20 08:05:07','');
[10/20/2020 08:05:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 08:05:07',`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;30\&#039;, \&#039;\&#039;, \&#039;0\&#039;,\&#039;IB\&#039; , \&#039;0\&#039; , \&#039;IN\&#039;, \&#039;b2b\&#039;, \&#039;0\&#039;, \&#039;\&#039;, \&#039;4\&#039;, \&#039;3.5\&#039;,\&#039;tfg\&#039;,\&#039;2020-10-20 08:05:07\&#039;,\&#039;\&#039;)',`log_description`= 'Tax Configuration added',`ip`= '43.250.210.76';
[10/20/2020 08:05:07], [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','internal', '30', '', '0','IB' , '0' , 'IN', 'b2b', '0', '', '4', '3.5','tfg','2020-10-20 08:05:07','');
[10/20/2020 08:05:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 08:05:07',`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;internal\&#039;, \&#039;30\&#039;, \&#039;\&#039;, \&#039;0\&#039;,\&#039;IB\&#039; , \&#039;0\&#039; , \&#039;IN\&#039;, \&#039;b2b\&#039;, \&#039;0\&#039;, \&#039;\&#039;, \&#039;4\&#039;, \&#039;3.5\&#039;,\&#039;tfg\&#039;,\&#039;2020-10-20 08:05:07\&#039;,\&#039;\&#039;)',`log_description`= 'Tax Configuration added',`ip`= '43.250.210.76';
[10/20/2020 08:05:07], [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','substitute', '30', '', '0','IB' , '0' , 'IN', 'b2b', '0', '', '4', '3.5','tfg','2020-10-20 08:05:07','');
[10/20/2020 08:05:07], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/tax.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-20 08:05:07',`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;substitute\&#039;, \&#039;30\&#039;, \&#039;\&#039;, \&#039;0\&#039;,\&#039;IB\&#039; , \&#039;0\&#039; , \&#039;IN\&#039;, \&#039;b2b\&#039;, \&#039;0\&#039;, \&#039;\&#039;, \&#039;4\&#039;, \&#039;3.5\&#039;,\&#039;tfg\&#039;,\&#039;2020-10-20 08:05:07\&#039;,\&#039;\&#039;)',`log_description`= 'Tax Configuration added',`ip`= '43.250.210.76';
