[08/20/2021 11:57:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_request_logs SET quotation_id='RDTCD0021191', request_detail='a%3A28%3A%7Bs%3A6%3A%22action%22%3Bs%3A22%3A%22insertQuotationService%22%3Bs%3A14%3A%22bookingSession%22%3Bs%3A32%3A%22b90dcc71a8ed102f9d0736f564c36ed7%22%3Bs%3A17%3A%22agent_suggest_box%22%3Bs%3A41%3A%22Qtech_Ankita+%5BCD0021-ankita%5D+%5BAnkita-Rao%5D%22%3Bs%3A12%3A%22search_agent%22%3Bs%3A2%3A%2221%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A23%3A%22total_quotation_to_book%22%3Bs%3A1%3A%222%22%3Bs%3A37%3A%22quotation_booking_unique_session_code%22%3Bs%3A32%3A%22b90dcc71a8ed102f9d0736f564c36ed7%22%3Bs%3A14%3A%22quotation_name%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A12%3A%22RDTCD0021191%22%3Bs%3A11%3A%22ServiceDate%22%3Bs%3A10%3A%2227-07-2021%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A11%3A%22selCurrency%22%3Bs%3A3%3A%22INR%22%3Bs%3A15%3A%22sel_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A13%3A%22reservationId%22%3Bs%3A13%3A%22RDT2021081973%22%3Bs%3A16%3A%22tags_suggest_box%22%3Ba%3A5%3A%7Bi%3A0%3Bs%3A7%3A%22romance%22%3Bi%3A1%3Bs%3A13%3A%22romanticdrive%22%3Bi%3A2%3Bs%3A13%3A%22welcometohell%22%3Bi%3A3%3Bs%3A9%3A%22mommylove%22%3Bi%3A4%3Bs%3A11%3A%22hellomumbai%22%3B%7Ds%3A19%3A%22sel_hotel_quotation%22%3Bs%3A4%3A%221917%22%3Bs%3A22%3A%22sel_transfer_quotation%22%3Bs%3A4%3A%221918%22%3Bs%3A20%3A%22enableInventoryCheck%22%3Bs%3A4%3A%22true%22%3Bs%3A10%3A%22salutation%22%3Bs%3A2%3A%22Ms%22%3Bs%3A10%3A%22first_name%22%3Bs%3A4%3A%22Roma%22%3Bs%3A9%3A%22last_name%22%3Bs%3A7%3A%22Banwani%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%3A2%3A%7Bs%3A5%3A%22hotel%22%3Ba%3A1%3A%7Bs%3A23%3A%2227-07-2021%5E%3A%5E28-07-2021%22%3Ba%3A1%3A%7Bi%3A53704%3Ba%3A1%3A%7Bi%3A0%3Ba%3A44%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253704%22%3Bs%3A12%3A%22service_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2227-07-2021%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2228-07-2021%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221917%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271129%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Bentota%22%3Bs%3A10%3A%22country_id%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A14%3A%22nationality_id%22%3Bs%3A3%3A%22106%22%3Bs%3A11%3A%22nationality%22%3Bs%3A6%3A%22Indian%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A22%3A%22rate_description_field%22%3Bs%3A456%3A%22%255B%255B%257B%2522date%2522%253A%25222021-07-27%2522%252C%2522supplier_rate%2522%253A1%252C%2522supplier_rate_in_agent_currency%2522%253A%25221%2522%252C%2522applied_markup%2522%253A%252212%2522%252C%2522applied_markup_amount%2522%253A%25220%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%25221.12%2522%252C%2522supplier_commission%2522%253A%25220%2522%252C%2522supplier_commission_amount%2522%253A%25220%2522%252C%2522profit%2522%253A%25220.12%2522%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22bookingDetails%22%3Bs%3A2587%3A%22%257B%2522quotation_id%2522%253A%25221917%2522%252C%2522name%2522%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%252C%2522id%2522%253A%252253704%2522%252C%2522city_id%2522%253A%252271129%2522%252C%2522city_name%2522%253A%2522Bentota%2522%252C%2522country_id%2522%253A%2522132%2522%252C%2522country_name%2522%253A%2522Sri%2BLanka%2522%252C%2522nationality_id%2522%253A%2522106%2522%252C%2522nationality%2522%253A%2522Indian%2522%252C%2522room_category_id%2522%253A%2522991%2522%252C%2522room_details%2522%253A%255B%257B%2522display_currency_code%2522%253A%2522INR%2522%252C%2522native_currency_code%2522%253A%2522INR%2522%252C%2522displayRoomTypeRates%2522%253A%25221.12%2522%252C%2522nativeRoomTypeRates%2522%253A%25221%2522%252C%2522applied_markup%2522%253A%252212%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522room_type_id%2522%253A%25221%2522%252C%2522room_category_id%2522%253A%2522991%2522%252C%2522room_basis_id%2522%253A%25224%2522%252C%2522room_type%2522%253A%2522single%2522%252C%2522inventory_room_class%2522%253A%2522Whole%2BVilla%2522%252C%2522room_category_text%2522%253A%2522Whole%2BVilla%2B-%2BSingle%2522%252C%2522meal_basis_text%2522%253A%2522Room%2BOnly%2522%252C%2522room_type_code%2522%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%252C%2522number_of_room%2522%253A%25221%2522%252C%2522total_adults%2522%253A1%252C%2522total_child%2522%253A0%252C%2522total_pax%2522%253A1%252C%2522child_age%2522%253A%2522%2522%257D%255D%252C%2522currency_id%2522%253A%2522INR%2522%252C%2522supplier_id%2522%253A%2522S000000078%2522%252C%2522native_room_rate%2522%253A%25221%2522%252C%2522total_native_rate%2522%253A%25221%2522%252C%2522number_of_room%2522%253A1%252C%2522native_currency_code%2522%253A%2522INR%2522%252C%2522display_currency_code%2522%253A%2522INR%2522%252C%2522display_room_rate%2522%253A%25221.12%2522%252C%2522total_agent_rate%2522%253A%25221.12%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522applied_markup%2522%253A12.00000000000001%252C%2522checkindate%2522%253A%252227-07-2021%2522%252C%2522checkoutdate%2522%253A%252228-07-2021%2522%252C%2522total_adults%2522%253A1%252C%2522total_child%2522%253A0%252C%2522rate_description_field%2522%253A%2522%25255B%25255B%25257B%252522date%252522%25253A%2525222021-07-27%252522%25252C%252522supplier_rate%252522%25253A1%25252C%252522supplier_rate_in_agent_currency%252522%25253A%2525221%252522%25252C%252522applied_markup%252522%25253A%25252212%252522%25252C%252522applied_markup_amount%252522%25253A%2525220%252522%25252C%252522applied_multiplier%252522%25253A%2525221.00000%252522%25252C%252522agent_rate%252522%25253A%2525221.12%252522%25252C%252522supplier_commission%252522%25253A%2525220%252522%25252C%252522supplier_commission_amount%252522%25253A%2525220%252522%25252C%252522profit%252522%25253A%2525220.12%252522%25252C%252522supplier_currency%252522%25253A%252522INR%252522%25252C%252522agent_currency%252522%25253A%252522INR%252522%25257D%25255D%25255D%2522%252C%2522user_description%2522%253A%2522%2522%252C%2522special_remark%2522%253A%2522%2522%252C%2522cancellation_policy_response%2522%253A%2522%2522%252C%2522sequence%2522%253A%25222%2522%252C%2522sourcetype%2522%253A%2522localsystem%2522%252C%2522booking_status%2522%253A%2522confirmed%2522%257D%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Room+Only%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22Whole+Villa%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22991%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%224%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Roma%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A7%3A%22Banwani%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%3A1%3A%221%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A4%3A%221.12%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A4%3A%221.12%22%3Bs%3A11%3A%22supplierFoc%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22agentFoc%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%222%22%3B%7D%7D%7D%7Ds%3A8%3A%22transfer%22%3Ba%3A1%3A%7Bs%3A10%3A%2228-07-2021%22%3Ba%3A1%3A%7Bi%3A183%3Ba%3A1%3A%7Bi%3A0%3Ba%3A44%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A3%3A%22183%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221918%22%3Bs%3A10%3A%22service_id%22%3Bs%3A3%3A%22183%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000066%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%3A9%3A%22child_age%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A1%3A%225%22%3Bs%3A4%3A%22type%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22H%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22H%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A9%3A%22undefined%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A9%3A%22sri+lanka%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22transfer_duration%22%3Bs%3A11%3A%223+hr+0+min+%22%3Bs%3A16%3A%22vehicle_capacity%22%3Bs%3A1%3A%229%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22service_name%22%3Bs%3A22%3A%22Srilanka+Transfer+Test%22%3Bs%3A17%3A%22vehicle_type_name%22%3Bs%3A13%3A%22VAN+15+SEATER%22%3Bs%3A13%3A%22transfer_type%22%3Bs%3A12%3A%22Privateperkm%22%3Bs%3A11%3A%22serviceDate%22%3Bs%3A10%3A%2228-07-2021%22%3Bs%3A11%3A%22NoOfService%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%3A25%3A%22pickup_time_accommodation%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22Time_Minute%22%3Bs%3A0%3A%22%22%3B%7Ds%3A26%3A%22dropoff_time_accommodation%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22Time_Minute%22%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%3A4%3A%22Roma%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A7%3A%22Banwani%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%3A7%3A%221000.00%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A4%3A%221000%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A2%3A%2210%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A7%3A%221100.00%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A4%3A%221100%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%3A7%3A%221101.12%22%3B%7D', create_date='2021-08-20 11:57:14';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO bookings SET agent_id = '21' , service_type = 'hotel' , reservation_id = 'RDT2021081973' , display_currency_code = 'INR' , created_datetime='2021-08-20 11:57:15' , create_date='2021-08-20 11:57:15' , created_by ='tfg' , sales_manager_id ='' , consultant_id = 'tfg' , backoffice_user = 'tfg' , itenirary_id = '2' , sequence = '2', city_id='Bentota', country_id='132', leader_title='Ms', leader_first_name='Roma', leader_last_name='Banwani', nationality='Indian', site_id='0', supplier_profile_id='1', comment_contract='', supplier_cancellation_policy='', special_remark='', source_type='localsystem', booking_type='offline', booking_branch_id='3', service_type_detail='Ramada Qtech Test_newTest(Do not Book)', country_of_residence='106';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '3'
        WHERE
        id='3139'
        ;
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into bookings_details set booking_id ='3139' , hotel_id='53704' , hotel_name='Ramada Qtech Test_newTest(Do not Book)' , hotel_address1='' , hotel_phone='' , hotel_rating='0.0';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_room_detail set booking_id = '3139', booking_detail_id = '1250', room_type_code = '1~~~154~~~991~~~4~~~~~~~~~71129~~~0~~~S000000078', room_name = 'single', meal_basis = 'Room Only', room_category = 'Whole Villa', room_type_description = 'Whole Villa - Room Only', display_nightly_rates = 'a:1:{i:0;a:1:{s:18:"displayNightlyRate";d:1.12;}}' ,native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";i:1;}}' ,native_room_rate_total = '1' ,display_room_rate_total = '1.12' ,number_of_rooms = '1';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE bookings SET confirmation_number='',itenirary_id ='2',sequence ='2',voucher_id='',voucher_hashcode='',native_currency_code='INR',cancellation_policy='',supplier_cancellation_policy='',applied_multiplier='1.00000',applied_markup='12',consultant_id='tfg',basecurrency_multiplier='0.01533',basecurrency_multiplier_native='0.01533'_native,agent_currency_multiplier='1.00000',current_status='confirmed',status_date='2021-08-20 11:57:15',service_date='2021-07-27',check_out_date='2021-07-28',display_room_rate= '1.12',display_discount='',native_room_rate= '1',native_discount='',additional_charge='0',expiration_date= '2021-08-20 00:00:00',source_type='localsystem',free_sale='yes',special_comment='',admin_note='' WHERE id='3139';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings set  parent_agent_id='21', sub_agent_rate='', agent_rate='1.12', applicable_service_tax='', agent_markup='12', supplier_rate='1' where id='3139';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],update bookings_details set total_nights='1',supplier_id= 'S000000078',arrival_date='2021/07/27',departure_date='2021/07/28',rate_code='~',total_rooms= '1',total_adults= '1',total_children= '0',total_infants= '0' where booking_id ='3139';
[08/20/2021 11:57:15], [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
        ('','','3139','confirmed','2021-08-20 11:57:15','confirmed by tfg','tfg','171.60.184.136','tfg','','');
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE room_rates rr SET availability=0,consumed_inventory=consumed_inventory+1
                            WHERE time_stamp IN ('8f603ff1c1893f3676d5c325ed5dbac0','b2f07a73e0778fd1b62034229c01cbf6') AND rr.date_from='2021-07-27' AND rr.status='A' AND rr.hotel_id = '53704'
                            AND rr.inventory_class_id IN ('154') AND rr.supplier_id= 'S000000078' AND (FIND_IN_SET('106',rr.exclude_countries)< 1 OR rr.exclude_countries='' OR rr.exclude_countries IS NULL)
                            AND rr.stop_sale != '1' ;;
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-08-20 11:57:15',`log_type`= 'Hotel Inventory Updated',`sql_query`= 'UPDATE room_rates rr SET availability=0,consumed_inventory=consumed_inventory+1
                            WHERE time_stamp IN (\&#039;8f603ff1c1893f3676d5c325ed5dbac0\&#039;,\&#039;b2f07a73e0778fd1b62034229c01cbf6\&#039;) AND rr.date_from=\&#039;2021-07-27\&#039; AND rr.status=\&#039;A\&#039; AND rr.hotel_id = \&#039;53704\&#039;
                            AND rr.inventory_class_id IN (\&#039;154\&#039;) AND rr.supplier_id= \&#039;S000000078\&#039; AND (FIND_IN_SET(\&#039;106\&#039;,rr.exclude_countries)&lt; 1 OR rr.exclude_countries=\&#039;\&#039; OR rr.exclude_countries IS NULL)
                            AND rr.stop_sale != \&#039;1\&#039; ;',`log_description`= 'Hotel Inventory Updated From 0 To 0 For Date : , Rate Profile : 1;',`ip`= '171.60.184.136';
[08/20/2021 11:57:15], [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 ('3139','1250','1856','0','Ms','Roma','Banwani','adult','');
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3139', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223139%22%3Bs%3A12%3A%22post_details%22%3Ba%3A46%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A5%3A%2253704%22%3Bs%3A12%3A%22service_name%22%3Bs%3A38%3A%22Ramada+Qtech+Test_newTest%28Do+not+Book%29%22%3Bs%3A11%3A%22CheckInDate%22%3Bs%3A10%3A%2227-07-2021%22%3Bs%3A12%3A%22CheckOutDate%22%3Bs%3A10%3A%2228-07-2021%22%3Bs%3A9%3A%22NoOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22noOfAdults%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22noOfChild%22%3Bs%3A1%3A%220%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221917%22%3Bs%3A10%3A%22service_id%22%3Bs%3A5%3A%2253704%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A7%3A%22city_id%22%3Bs%3A5%3A%2271129%22%3Bs%3A9%3A%22city_name%22%3Bs%3A7%3A%22Bentota%22%3Bs%3A10%3A%22country_id%22%3Bs%3A3%3A%22132%22%3Bs%3A12%3A%22country_name%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A14%3A%22nationality_id%22%3Bs%3A3%3A%22106%22%3Bs%3A11%3A%22nationality%22%3Bs%3A6%3A%22Indian%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A22%3A%22rate_description_field%22%3Bs%3A456%3A%22%255B%255B%257B%2522date%2522%253A%25222021-07-27%2522%252C%2522supplier_rate%2522%253A1%252C%2522supplier_rate_in_agent_currency%2522%253A%25221%2522%252C%2522applied_markup%2522%253A%252212%2522%252C%2522applied_markup_amount%2522%253A%25220%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522agent_rate%2522%253A%25221.12%2522%252C%2522supplier_commission%2522%253A%25220%2522%252C%2522supplier_commission_amount%2522%253A%25220%2522%252C%2522profit%2522%253A%25220.12%2522%252C%2522supplier_currency%2522%253A%2522INR%2522%252C%2522agent_currency%2522%253A%2522INR%2522%257D%255D%255D%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22bookingDetails%22%3Bs%3A2587%3A%22%257B%2522quotation_id%2522%253A%25221917%2522%252C%2522name%2522%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%252C%2522id%2522%253A%252253704%2522%252C%2522city_id%2522%253A%252271129%2522%252C%2522city_name%2522%253A%2522Bentota%2522%252C%2522country_id%2522%253A%2522132%2522%252C%2522country_name%2522%253A%2522Sri%2BLanka%2522%252C%2522nationality_id%2522%253A%2522106%2522%252C%2522nationality%2522%253A%2522Indian%2522%252C%2522room_category_id%2522%253A%2522991%2522%252C%2522room_details%2522%253A%255B%257B%2522display_currency_code%2522%253A%2522INR%2522%252C%2522native_currency_code%2522%253A%2522INR%2522%252C%2522displayRoomTypeRates%2522%253A%25221.12%2522%252C%2522nativeRoomTypeRates%2522%253A%25221%2522%252C%2522applied_markup%2522%253A%252212%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522room_type_id%2522%253A%25221%2522%252C%2522room_category_id%2522%253A%2522991%2522%252C%2522room_basis_id%2522%253A%25224%2522%252C%2522room_type%2522%253A%2522single%2522%252C%2522inventory_room_class%2522%253A%2522Whole%2BVilla%2522%252C%2522room_category_text%2522%253A%2522Whole%2BVilla%2B-%2BSingle%2522%252C%2522meal_basis_text%2522%253A%2522Room%2BOnly%2522%252C%2522room_type_code%2522%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%252C%2522number_of_room%2522%253A%25221%2522%252C%2522total_adults%2522%253A1%252C%2522total_child%2522%253A0%252C%2522total_pax%2522%253A1%252C%2522child_age%2522%253A%2522%2522%257D%255D%252C%2522currency_id%2522%253A%2522INR%2522%252C%2522supplier_id%2522%253A%2522S000000078%2522%252C%2522native_room_rate%2522%253A%25221%2522%252C%2522total_native_rate%2522%253A%25221%2522%252C%2522number_of_room%2522%253A1%252C%2522native_currency_code%2522%253A%2522INR%2522%252C%2522display_currency_code%2522%253A%2522INR%2522%252C%2522display_room_rate%2522%253A%25221.12%2522%252C%2522total_agent_rate%2522%253A%25221.12%2522%252C%2522applied_multiplier%2522%253A%25221.00000%2522%252C%2522applied_markup%2522%253A12.00000000000001%252C%2522checkindate%2522%253A%252227-07-2021%2522%252C%2522checkoutdate%2522%253A%252228-07-2021%2522%252C%2522total_adults%2522%253A1%252C%2522total_child%2522%253A0%252C%2522rate_description_field%2522%253A%2522%25255B%25255B%25257B%252522date%252522%25253A%2525222021-07-27%252522%25252C%252522supplier_rate%252522%25253A1%25252C%252522supplier_rate_in_agent_currency%252522%25253A%2525221%252522%25252C%252522applied_markup%252522%25253A%25252212%252522%25252C%252522applied_markup_amount%252522%25253A%2525220%252522%25252C%252522applied_multiplier%252522%25253A%2525221.00000%252522%25252C%252522agent_rate%252522%25253A%2525221.12%252522%25252C%252522supplier_commission%252522%25253A%2525220%252522%25252C%252522supplier_commission_amount%252522%25253A%2525220%252522%25252C%252522profit%252522%25253A%2525220.12%252522%25252C%252522supplier_currency%252522%25253A%252522INR%252522%25252C%252522agent_currency%252522%25253A%252522INR%252522%25257D%25255D%25255D%2522%252C%2522user_description%2522%253A%2522%2522%252C%2522special_remark%2522%253A%2522%2522%252C%2522cancellation_policy_response%2522%253A%2522%2522%252C%2522sequence%2522%253A%25222%2522%252C%2522sourcetype%2522%253A%2522localsystem%2522%252C%2522booking_status%2522%253A%2522confirmed%2522%257D%22%3Bs%3A18%3A%22room_category_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A20%3A%22Whole+Villa+-+Single%22%3B%7Ds%3A15%3A%22room_basis_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A9%3A%22Room+Only%22%3B%7Ds%3A16%3A%22NoOfRoomsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A17%3A%22noOfAdultsPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A16%3A%22noOfChildPerRoom%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A20%3A%22inventory_room_class%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A11%3A%22Whole+Villa%22%3B%7Ds%3A16%3A%22room_category_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A3%3A%22991%22%3B%7Ds%3A10%3A%22room_basis%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%224%22%3B%7Ds%3A12%3A%22room_type_id%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%221%22%3B%7Ds%3A14%3A%22room_type_code%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3B%7Ds%3A14%3A%22room_type_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A6%3A%22single%22%3B%7Ds%3A14%3A%22room_child_age%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22passenger_details%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A10%3A%22first_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Roma%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A7%3A%22Banwani%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%3A1%3A%221%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A4%3A%221.12%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A4%3A%221.12%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%3A11319%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1988928000%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252227%252F07%252F2021%2B--%2B28%252F07%252F2021%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253704%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253704%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25220.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bi%253A1%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A1%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A4%253A%25221.12%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%25222021-07-27%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A1%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A1%253A%25221%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A4%253A%25221.12%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A4%253A%25220.12%2522%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%253A4%253A%25221.12%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A1%253A%25221%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522991%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A9%253A%2522Room%2BOnly%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A30%253A%2522Whole%2BVilla%2B-%2BSingle%2BRoom%2BOnly%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.04%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25220.08%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25228.21%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%25221.12%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253704----------S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25223.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.04%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25228.21%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A8%253A%25226.278698%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A9%253A%252299.730656%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A1%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271129%2522%253Bs%253A16%253A%2522selected_country%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A20%253A%2522selected_nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A20%253A%2522selected_country_res%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A22%253A%2522TEST%2BHOTEL%2BDESCRIPTION%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A285%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bi%253A1%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A1%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A4%253A%25221.12%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%25222021-07-27%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A1%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A1%253A%25221%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A4%253A%25221.12%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A4%253A%25220.12%2522%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%253A4%253A%25221.12%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A1%253A%25221%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522991%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A9%253A%2522Room%2BOnly%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A30%253A%2522Whole%2BVilla%2B-%2BSingle%2BRoom%2BOnly%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.04%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25220.08%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25228.21%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%25221.12%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253704----------S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25223.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.04%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25228.21%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3Bs%3A18%3A%22inventory_class_id%22%3Bs%3A5%3A%22%27154%27%22%3B%7Ds%3A15%3A%22request_details%22%3Ba%3A72%3A%7Bs%3A13%3A%22check_in_date%22%3Bs%3A10%3A%2227-07-2021%22%3Bs%3A14%3A%22check_out_date%22%3Bs%3A10%3A%222021-07-28%22%3Bs%3A11%3A%22action_name%22%3Bs%3A10%3A%22add_sector%22%3Bs%3A11%3A%22total_night%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22agent_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2221%22%3Bs%3A17%3A%22agent_selected_id%22%3Bs%3A2%3A%2221%22%3Bs%3A17%3A%22total_native_rate%22%3Bs%3A1%3A%221%22%3Bs%3A18%3A%22total_display_rate%22%3Bs%3A4%3A%221.12%22%3Bs%3A13%3A%22sel_countries%22%3Bs%3A3%3A%22132%22%3Bs%3A24%3A%22sel_country_of_residence%22%3Bs%3A3%3A%22106%22%3Bs%3A8%3A%22sel_city%22%3Bs%3A5%3A%2271129%22%3Bs%3A10%3A%22sel_hotels%22%3Bs%3A5%3A%2253704%22%3Bs%3A11%3A%22hotel_phone%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A11%3A%22arrive_date%22%3Bs%3A10%3A%2227-07-2021%22%3Bs%3A11%3A%22depart_date%22%3Bs%3A10%3A%2228-07-2021%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%3A4%3A%22Roma%22%3B%7Ds%3A13%3A%22sel_last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A7%3A%22Banwani%22%3B%7Ds%3A14%3A%22leader_address%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22rdSupplierType%22%3Bs%3A1%3A%22L%22%3Bs%3A12%3A%22sel_supplier%22%3Bs%3A10%3A%22S000000078%22%3Bs%3A20%3A%22sel_supplierProfileL%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22sel_currencies_online%22%3Bs%3A3%3A%22INR%22%3Bs%3A21%3A%22display_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A22%3A%22supplier_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A25%3A%22agent_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22txt_agent_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A23%3A%22basecurrency_multiplier%22%3Bd%3A0.01533%3Bs%3A30%3A%22basecurrency_multiplier_native%22%3Bd%3A0.01533%3Bs%3A10%3A%22txt_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A12%3A%22room_type_id%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A12%3A%22total_adults%22%3Bs%3A1%3A%221%22%3Bs%3A14%3A%22total_children%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22total_pax%22%3Bs%3A1%3A%221%22%3Bs%3A9%3A%22room_type%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A13%3A%22single_room_1%22%3B%7Ds%3A25%3A%22single_room_1_description%22%3Bs%3A11%3A%22Whole+Villa%22%3Bs%3A18%3A%22single_room_1_code%22%3Bs%3A48%3A%221%7E%7E%7E154%7E%7E%7E991%7E%7E%7E4%7E%7E%7E%7E%7E%7E%7E%7E%7E71129%7E%7E%7E0%7E%7E%7ES000000078%22%3Bs%3A24%3A%22single_room_1_room_basis%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A29%3A%22single_room_1_room_basis_desc%22%3Bs%3A9%3A%22Room+Only%22%3Bs%3A29%3A%22single_room_1_number_of_rooms%22%3Bs%3A1%3A%221%22%3Bs%3A25%3A%22single_room_1_native_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bi%3A1%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%3A1.12%3B%7Ds%3A30%3A%22single_room_1_sub_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A1.12%3B%7Ds%3A29%3A%22single_room_1_wh_display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A1.12%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%2F08%2F2021+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%3A13%3A%22RDT2021081973%22%3Bs%3A12%3A%22leader_phone%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22email_id%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22sequence%22%3Bs%3A1%3A%222%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%222%22%3Bs%3A20%3A%22is_quote_fit_booking%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22fetch_booking_details%22%3Bb%3A1%3Bs%3A28%3A%22strip_room_class_description%22%3Bb%3A1%3Bs%3A9%3A%22free_sale%22%3Bs%3A2%3A%22no%22%3B%7Ds%3A17%3A%22quotation_details%22%3Bs%3A11319%3A%22a%253A21%253A%257Bs%253A11%253A%2522arrivaltime%2522%253Bi%253A1988928000%253Bs%253A13%253A%2522date_selected%2522%253Bs%253A24%253A%252227%252F07%252F2021%2B--%2B28%252F07%252F2021%2522%253Bs%253A15%253A%2522selected_nights%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522hotel_id%2522%253Bs%253A5%253A%252253704%2522%253Bs%253A14%253A%2522local_hotel_id%2522%253Bs%253A5%253A%252253704%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A14%253A%2522propertyRating%2522%253Bs%253A3%253A%25220.0%2522%253Bs%253A10%253A%2522hotel_info%2522%253Ba%253A1%253A%257Bs%253A11%253A%2522localsystem%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A8%253A%2522RateInfo%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bi%253A1%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A1%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A4%253A%25221.12%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%25222021-07-27%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A1%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A1%253A%25221%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A4%253A%25221.12%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A4%253A%25220.12%2522%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%253A4%253A%25221.12%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A1%253A%25221%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522991%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A9%253A%2522Room%2BOnly%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A30%253A%2522Whole%2BVilla%2B-%2BSingle%2BRoom%2BOnly%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.04%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25220.08%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25228.21%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%25221.12%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253704----------S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25223.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.04%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25228.21%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%257D%257Ds%253A7%253A%2522address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A8%253A%2522latitude%2522%253Bs%253A8%253A%25226.278698%2522%253Bs%253A9%253A%2522longitude%2522%253Bs%253A9%253A%252299.730656%2522%253Bs%253A13%253A%2522numberOfRooms%2522%253Bi%253A1%253Bs%253A11%253A%2522totalAdults%2522%253Bi%253A1%253Bs%253A13%253A%2522totalChildren%2522%253Bi%253A0%253Bs%253A13%253A%2522selected_city%2522%253Bs%253A5%253A%252271129%2522%253Bs%253A16%253A%2522selected_country%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A20%253A%2522selected_nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A20%253A%2522selected_country_res%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A22%253A%2522TEST%2BHOTEL%2BDESCRIPTION%2522%253Bs%253A11%253A%2522hotel_image%2522%253Bs%253A285%253A%2522https%253A%252F%252Falpha.otrams.thefabulousgetaway.com%252F%252Fcpfv3%252Fimages%252F%253Fimage%253DaHR0cHM6Ly9hbHBoYS5vdHJhbXMudGhlZmFidWxvdXNnZXRhd2F5LmNvbS9wcm9qZWN0X2ZvbGRlci90ZmdfcHJvamVjdC91cGxvYWRzL2hvdGVsX2ltYWdlcy91cGxvYWQvMTU3MzI5ODkzN19tYWluXzE1NTY3OTE4NjJfbWFpbl9UQVJVLVZJTExBUyZuZGFzaDtMQUtFLUxPREdFLTEuanBn%2522%253Bs%253A18%253A%2522quotation_selected%2522%253Ba%253A17%253A%257Bs%253A10%253A%2522room_rates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A31%253A%257Bs%253A11%253A%2522ratebreakup%2522%253Ba%253A4%253A%257Bs%253A6%253A%2522markup%2522%253Bi%253A0%253Bs%253A10%253A%2522commission%2522%253Bi%253A0%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A2%253A%257Bs%253A19%253A%2522O_nativeNightlyRate%2522%253Bi%253A1%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bi%253A1%253B%257D%257Ds%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A1%253A%257Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A4%253A%25221.12%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%25222021-07-27%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bi%253A1%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A1%253A%25221%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A4%253A%25221.12%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A4%253A%25220.12%2522%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%253A4%253A%25221.12%2522%253Bs%253A19%253A%2522nativeRoomTypeRates%2522%253Bs%253A1%253A%25221%2522%253Bs%253A7%253A%2522room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A13%253A%2522NumberOfRooms%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A12%253A%2522supplierName%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A14%253A%2522room_type_code%2522%253Bs%253A3%253A%2522991%2522%253Bs%253A14%253A%2522boardtype_code%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522number_of_child%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522meal_basis%2522%253Bs%253A9%253A%2522Room%2BOnly%2522%253Bs%253A9%253A%2522room_type%2522%253Bs%253A30%253A%2522Whole%2BVilla%2B-%2BSingle%2BRoom%2BOnly%2522%253Bs%253A9%253A%2522room_name%2522%253Bs%253A6%253A%2522single%2522%253Bs%253A14%253A%2522room_type_desc%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A13%253A%2522room_category%2522%253Bs%253A20%253A%2522Whole%2BVilla%2B-%2BSingle%2522%253Bs%253A14%253A%2522non_refundable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A15%253A%2522class_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522search_unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A19%253A%2522localsystem_room_id%2522%253Bs%253A48%253A%25221%257E%257E%257E154%257E%257E%257E991%257E%257E%257E4%257E%257E%257E%257E%257E%257E%257E%257E%257E71129%257E%257E%257E0%257E%257E%257ES000000078%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A11%253A%2522tax_details%2522%253Ba%253A1%253A%257Bs%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.04%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A2%253A%252212%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A4%253A%25220.08%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25228.21%2522%253B%257D%257D%257D%257Ds%253A9%253A%2522available%2522%253Bi%253A0%253Bs%253A15%253A%2522displayRoomRate%2522%253Bs%253A4%253A%25221.12%2522%253Bs%253A14%253A%2522nativeRoomRate%2522%253Bs%253A1%253A%25221%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252212%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A9%253A%2522unique_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25221%2522%253Bs%253A13%253A%2522supplier_data%2522%253Ba%253A5%253A%257Bs%253A7%253A%2522hotelId%2522%253Bs%253A25%253A%252253704----------S000000078%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A11%253A%2522localsystem%2522%253Bs%253A15%253A%2522supp_hotel_name%2522%253Bs%253A38%253A%2522Ramada%2BQtech%2BTest_newTest%2528Do%2Bnot%2BBook%2529%2522%253Bs%253A18%253A%2522supp_hotel_address%2522%253Bs%253A39%253A%2522Test%2BAddress%2BMumbai%252C%2BIndia%252C%2BMaharashtra%2522%253Bs%253A10%253A%2522supplierId%2522%253Bs%253A10%253A%2522S000000078%2522%253B%257Ds%253A11%253A%2522tax_details%2522%253Ba%253A4%253A%257Bs%253A9%253A%2522input_tax%2522%253Ba%253A3%253A%257Bs%253A12%253A%2522input_tax_id%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522input_tax_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522input_tax_amt%2522%253Bs%253A1%253A%25220%2522%253B%257Ds%253A10%253A%2522output_tax%2522%253Ba%253A3%253A%257Bs%253A13%253A%2522output_tax_id%2522%253Bs%253A1%253A%25224%2522%253Bs%253A15%253A%2522output_tax_code%2522%253Bs%253A12%253A%2522Transfer%2BTax%2522%253Bs%253A14%253A%2522output_tax_amt%2522%253Bs%253A3%253A%25223.5%2522%253B%257Ds%253A7%253A%2522net_tax%2522%253Bs%253A4%253A%25220.04%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A4%253A%25228.21%2522%253B%257Ds%253A8%253A%2522no_class%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7D', create_date='2021-08-20 11:57:15';;
[08/20/2021 11:57:15], [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
        ('','','3139','confirmed','2021-08-20 11:57:15','Quotation Id - RDTCD0021191 created on behalf of Agent - Ankita Rao(21) by tfg','tfg','171.60.184.136','tfg','','');
[08/20/2021 11:57:15], [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
        ('','','3139','confirmed','2021-08-20 11:57:15','Enquiry Id - 412 created on behalf of Agent - Ankita Rao(21) by tfg','tfg','171.60.184.136','tfg','','');
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO bookings set reservation_id = 'RDT2021081973' ,agent_id = '21' ,confirmation_number = '' ,city_id = 'Colombo' ,country_id = '132' ,nationality = 'Indian' ,display_room_rate = '1100' ,native_discount = '' ,display_discount = '' ,display_currency_code = 'INR' ,native_room_rate = '1000' ,consultant_id = 'tfg' ,backoffice_user = 'tfg' ,sales_manager_id = '' ,native_currency_code = 'INR' ,cancellation_policy = '' ,supplier_cancellation_policy = '' ,current_status = 'confirmed' ,booking_status= '1',create_date = '2021-08-20 11:57:15' ,status_date = '2021-08-20 11:57:15' ,source_type = 'localtransfer' ,comment_contract = '' ,booking_type= 'offline',booking_branch_id='3' ,country_of_residence='106' ,itenirary_id='3' ,sequence='3' ,expiration_date= '2021-08-19 18:30:00',native_rate = '' ,display_rate = '' ,applied_multiplier = '1.00000' ,applied_markup = '10' ,agent_markup = '10' ,basecurrency_multiplier = '0.01533' ,basecurrency_multiplier_native = '0.01533' ,check_out_date = '2021-07-28' ,service_date = '2021-07-28' ,service_type_detail = 'Srilanka Transfer Test' ,agent_currency_multiplier = '1.00000' ,supplier_profile_id = '6' ,created_by = 'tfg' ,leader_title = 'Ms' ,leader_first_name = 'Roma' ,leader_last_name = 'Banwani' ,leader_phone = '' ,service_type= 'transfer';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE
        bookings
        SET
        booking_branch_id= '3'
        WHERE
        id='3140'
        ;
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE bookings SET  parent_agent_id= '21', sub_agent_rate= '', agent_rate= '1100', applicable_service_tax= '', supplier_rate= '1000' where id= '3140';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO transfer_bookings SET booking_id = '3140' ,transfer_date = '2021-07-28' ,country_code = '132' ,city_code = '71100' ,pickup = 'O' ,pickup_code = '' ,dropoff = 'O' ,dropoff_code = '' ,no_of_pass = '1' ,pick_up_time = '' ,dropoff_time = '' ,item_code = '183' ,item_content = 'Srilanka Transfer Test' ,sel_arr_from = 'Colombo' ,flight_number = '' ,dropoff_to_hotel = '' ,dropoff_station = '' ,dropoff_station_train = '' ,dropoff_station_destination = '' ,dest_flight_no = '' ,flight_destination = '' ,dropoff_port_shipname = '' ,dropoff_port_shipcompany = '' ,dropoff_port_shipdestination = '' ,pickup_acc_address1 = '' ,pickup_acc_address2 = '' ,pickup_acc_city = '' ,pickup_acc_country = '' ,pickup_acc_postcode = '' ,pickup_acc_phone = '' ,dropoff_acc_address1 = '' ,dropoff_acc_address2 = '' ,dropoff_acc_city = '' ,dropoff_acc_country = '' ,dropoff_acc_postcode = '' ,dropoff_acc_phone = '' ,dropoff_other_address1 = 'sri lanka' ,dropoff_other_address2 = '' ,dropoff_other_country = 'Sri Lanka' ,dropoff_other_postcode = '' ,dropoff_other_phone = '' ,Error= '',Item_Confirm_Ref='',airport_arriving_from = '' ,arriving_flight_number = '' ,pickup_from_hotel = '' ,pickup_station_arriving_from = '' ,pickup_station_train_name = '' ,pickup_station_arriving_station = '' ,pickup_port_arriving_from = '' ,pickup_port_ship_name = '' ,pickup_port_shipping_company = '' ,pickup_other_address1 = 'undefined' ,pickup_other_address2 = '' ,pickup_other_country = 'Sri Lanka' ,pickup_other_postcode = '' ,pickup_other_phone = '' ,travel_duration = '3 hr 0 min ' ,supplier_id = 'S000000066' ,charge_applied_type = 'private_per_km' ,vehicle_type = '5' ,calculated_distance = '100' ,supplier_profile= '6';
[08/20/2021 11:57:15], [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
        ('','','3140','confirmed','2021-08-20 11:57:15','Offline transfer booking by tfg','tfg','171.60.184.136','tfg','','');
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO transfer_vehicles SET  booking_id  = '3140' ,vehicle_code = '5' ,vehicle_name = 'VAN 15 SEATER' ,max_passenger = '9' ,max_luggage = '9' , sel_passenger  = '1' , no_of_adult  = '1' , no_of_child  = '' , lead_name  = 'Ms Roma Banwani' , adult_rate  = '0' , child_rate  = '0' , parking_fee  = '' , driver_tips  = '' , representative_cost  = '' , guide_cost  = '' , touristic_fee  = '' , vehicle_native_price  = '1000.00' , native_price  = '1000' , display_price  = '1100.00' , native_surcharge  = '' , display_surcharge  = '' ;
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO booking_search_log SET booking_id='3140', request_details='a%3A4%3A%7Bs%3A10%3A%22booking_id%22%3Bs%3A4%3A%223140%22%3Bs%3A12%3A%22post_details%22%3Ba%3A45%3A%7Bs%3A14%3A%22seviceSelected%22%3Bs%3A3%3A%22183%22%3Bs%3A12%3A%22quotation_id%22%3Bs%3A4%3A%221918%22%3Bs%3A10%3A%22service_id%22%3Bs%3A3%3A%22183%22%3Bs%3A11%3A%22supplier_id%22%3Bs%3A10%3A%22S000000066%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%3A9%3A%22child_age%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A12%3A%22vehicle_type%22%3Bs%3A1%3A%225%22%3Bs%3A4%3A%22type%22%3Bs%3A12%3A%22privateperkm%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22H%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22H%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22pickup_code_name%22%3Bs%3A9%3A%22undefined%22%3Bs%3A17%3A%22dropoff_code_name%22%3Bs%3A9%3A%22sri+lanka%22%3Bs%3A13%3A%22total_mileage%22%3Bs%3A3%3A%22100%22%3Bs%3A13%3A%22extra_mileage%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22transfer_duration%22%3Bs%3A11%3A%223+hr+0+min+%22%3Bs%3A16%3A%22vehicle_capacity%22%3Bs%3A1%3A%229%22%3Bs%3A15%3A%22userDescription%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22specialRemark%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22service_name%22%3Bs%3A22%3A%22Srilanka+Transfer+Test%22%3Bs%3A17%3A%22vehicle_type_name%22%3Bs%3A13%3A%22VAN+15+SEATER%22%3Bs%3A13%3A%22transfer_type%22%3Bs%3A12%3A%22Privateperkm%22%3Bs%3A11%3A%22serviceDate%22%3Bs%3A10%3A%2228-07-2021%22%3Bs%3A11%3A%22NoOfService%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%3A25%3A%22pickup_time_accommodation%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22Time_Minute%22%3Bs%3A0%3A%22%22%3B%7Ds%3A26%3A%22dropoff_time_accommodation%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22Time_Minute%22%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%3A4%3A%22Roma%22%3B%7Ds%3A9%3A%22last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A7%3A%22Banwani%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%3A7%3A%221000.00%22%3Bs%3A15%3A%22totalNativeRate%22%3Bs%3A4%3A%221000%22%3Bs%3A17%3A%22appliedMultiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A13%3A%22appliedMarkup%22%3Bs%3A2%3A%2210%22%3Bs%3A13%3A%22baseAgentCost%22%3Bs%3A7%3A%221100.00%22%3Bs%3A16%3A%22totalDisplayRate%22%3Bs%3A4%3A%221100%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%223%22%3Bs%3A14%3A%22quotation_info%22%3Bs%3A9484%3A%22a%253A58%253A%257Bs%253A8%253A%2522noofpass%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522tra_date%2522%253Bs%253A10%253A%25222021-07-28%2522%253Bs%253A17%253A%2522markup_percentage%2522%253Bs%253A2%253A%252210%2522%253Bs%253A10%253A%2522TransferId%2522%253Bs%253A3%253A%2522183%2522%253Bs%253A13%253A%2522Vehicle_un_id%2522%253Bs%253A19%253A%2522localtransfer_183_0%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A22%253A%2522Srilanka%2BTransfer%2BTest%2522%253Bs%253A4%253A%2522city%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A9%253A%2522city_code%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A6%253A%2522Pickup%2522%253Ba%253A0%253A%257B%257Ds%253A7%253A%2522Dropoff%2522%253Ba%253A0%253A%257B%257Ds%253A8%253A%2522Duration%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A3%253A%25223.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A11%253A%25223%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A16%253A%2522rateCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522cancellation_hours%2522%253Bs%253A2%253A%252248%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A15%253A%2522TransferSummary%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252210%2522%253Bs%253A13%253A%2522total_charges%2522%253Bs%253A7%253A%25221100.00%2522%253Bs%253A17%253A%2522propertyAvailable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253BN%253Bs%253A19%253A%2522per_child_agentrate%2522%253BN%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bi%253A0%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bi%253A0%253Bs%253A7%253A%2522Vehical%2522%253Ba%253A9%253A%257Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A11%253A%2522supplier_id%2522%253Bs%253A10%253A%2522S000000066%2522%253Bs%253A10%253A%2522ChargeType%2522%253Bs%253A12%253A%2522privateperkm%2522%253Bs%253A8%253A%2522RateInfo%2522%253Ba%253A15%253A%257Bs%253A9%253A%2522AdultRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522ChildRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522TariffCode%2522%253Bs%253A32%253A%2522129d2cf3fd8db68c03b7474915ad90b0%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A7%253A%25221100.00%2522%253B%257Ds%253A15%253A%2522displayRoomRate%2522%253Bs%253A7%253A%25221100.00%2522%253Bs%253A23%253A%2522chargeableRoomRateTotal%2522%253Bs%253A7%253A%25221000.00%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A7%253A%25221000.00%2522%253B%257Ds%253A14%253A%2522nativeRoomRate%2522%253Bs%253A7%253A%25221000.00%2522%253Bs%253A14%253A%2522baseNativeRate%2522%253Bs%253A2%253A%252210%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522per_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A8%253A%2522Language%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522code%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A4%253A%2522desc%2522%253Bs%253A7%253A%2522English%2522%253B%257Ds%253A11%253A%2522VehicleInfo%2522%253Ba%253A5%253A%257Bs%253A4%253A%2522Code%2522%253Bs%253A1%253A%25225%2522%253Bs%253A14%253A%2522MaximumLuggage%2522%253Bs%253A1%253A%25229%2522%253Bs%253A17%253A%2522MaximumPassengers%2522%253Bs%253A1%253A%25229%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A13%253A%2522VAN%2B15%2BSEATER%2522%253Bs%253A12%253A%2522thumbNailUrl%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A20%253A%2522noofAdultPassVehicle%2522%253Bs%253A1%253A%25221%2522%253Bs%253A20%253A%2522noofChildPassVehicle%2522%253Bs%253A1%253A%25220%2522%253Bs%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253B%257Ds%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522selected_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A12%253A%2522country_code%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A12%253A%2522to_city_code%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A9%253A%2522language1%2522%253Bs%253A1%253A%2522E%2522%253Bs%253A9%253A%2522language2%2522%253Bs%253A1%253A%2522E%2522%253Bs%253A27%253A%2522display_currency_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A11%253A%2522nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A9%253A%2522noofadult%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522noofchild%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522child_age%2522%253Ba%253A0%253A%257B%257Ds%253A18%253A%2522selected_child_age%2522%253Ba%253A0%253A%257B%257Ds%253A17%253A%2522additional_markup%2522%253Bs%253A2%253A%252210%2522%253Bs%253A12%253A%2522country_name%2522%253Bs%253A9%253A%2522Sri%2BLanka%2522%253Bs%253A16%253A%2522pickup_code_name%2522%253Bs%253A9%253A%2522undefined%2522%253Bs%253A17%253A%2522dropoff_code_name%2522%253Bs%253A9%253A%2522sri%2Blanka%2522%253Bs%253A6%253A%2522pickup%2522%253Bs%253A1%253A%2522H%2522%253Bs%253A7%253A%2522dropoff%2522%253Bs%253A1%253A%2522H%2522%253Bs%253A11%253A%2522pickup_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A12%253A%2522dropoff_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522total_mileage%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A13%253A%2522extra_mileage%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522language1_data%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A14%253A%2522language2_data%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A21%253A%2522dropoff_transfer_city%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A26%253A%2522dropoff_transfer_city_name%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A9%253A%2522item_code%2522%253Bs%253A3%253A%2522183%2522%253Bs%253A18%253A%2522description_number%2522%253Bi%253A0%253Bs%253A18%253A%2522total_native_price%2522%253Bs%253A7%253A%25221000.00%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%253A3%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%253A2%253A%252215%2522%253B%257Ds%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A6%253A%2522143.48%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A2%253A%252210%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A6%253A%2522-43.48%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25220.00%2522%253B%257D%257Ds%253A8%253A%2522Transfer%2522%253Ba%253A28%253A%257Bs%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222021-07-28%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A4%253A%25221000%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A4%253A%25221000%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A2%253A%252210%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A4%253A%25221100%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A3%253A%2522100%2522%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%253A27%253A%2522display_currency_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A17%253A%2522markup_percentage%2522%253Bs%253A2%253A%252210%2522%253Bi%253A0%253Bs%253A7%253A%25221100.00%2522%253Bs%253A10%253A%2522TransferId%2522%253Bs%253A3%253A%2522183%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A22%253A%2522Srilanka%2BTransfer%2BTest%2522%253Bs%253A4%253A%2522city%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A9%253A%2522city_code%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A11%253A%2522DropoffCity%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A15%253A%2522DropoffCityCode%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A8%253A%2522Duration%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A3%253A%25223.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A11%253A%25223%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A6%253A%2522Pickup%2522%253Ba%253A0%253A%257B%257Ds%253A7%253A%2522Dropoff%2522%253Ba%253A0%253A%257B%257Ds%253A16%253A%2522rateCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522cancellation_hours%2522%253Bs%253A2%253A%252248%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A14%253A%2522originalsource%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25226%2522%253Bs%253A15%253A%2522TransferSummary%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A7%253A%2522Vehicle%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A9%253A%257Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A11%253A%2522supplier_id%2522%253Bs%253A10%253A%2522S000000066%2522%253Bs%253A10%253A%2522ChargeType%2522%253Bs%253A12%253A%2522privateperkm%2522%253Bs%253A8%253A%2522RateInfo%2522%253Ba%253A15%253A%257Bs%253A9%253A%2522AdultRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522ChildRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522TariffCode%2522%253Bs%253A32%253A%2522129d2cf3fd8db68c03b7474915ad90b0%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A7%253A%25221100.00%2522%253B%257Ds%253A15%253A%2522displayRoomRate%2522%253Bs%253A7%253A%25221100.00%2522%253Bs%253A23%253A%2522chargeableRoomRateTotal%2522%253Bs%253A7%253A%25221000.00%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A7%253A%25221000.00%2522%253B%257Ds%253A14%253A%2522nativeRoomRate%2522%253Bs%253A7%253A%25221000.00%2522%253Bs%253A14%253A%2522baseNativeRate%2522%253Bs%253A2%253A%252210%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522per_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A8%253A%2522Language%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522code%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A4%253A%2522desc%2522%253Bs%253A7%253A%2522English%2522%253B%257Ds%253A11%253A%2522VehicleInfo%2522%253Ba%253A5%253A%257Bs%253A4%253A%2522Code%2522%253Bs%253A1%253A%25225%2522%253Bs%253A14%253A%2522MaximumLuggage%2522%253Bs%253A1%253A%25229%2522%253Bs%253A17%253A%2522MaximumPassengers%2522%253Bs%253A1%253A%25229%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A13%253A%2522VAN%2B15%2BSEATER%2522%253Bs%253A12%253A%2522thumbNailUrl%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A20%253A%2522noofAdultPassVehicle%2522%253Bs%253A1%253A%25221%2522%253Bs%253A20%253A%2522noofChildPassVehicle%2522%253Bs%253A1%253A%25220%2522%253Bs%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253B%257D%257Ds%253A19%253A%2522transfer_conditions%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252210%2522%253Bs%253A13%253A%2522total_charges%2522%253Bs%253A7%253A%25221100.00%2522%253Bs%253A17%253A%2522propertyAvailable%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7Ds%3A15%3A%22request_details%22%3Ba%3A91%3A%7Bs%3A13%3A%22txt_city_code%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A25%3A%22txt_dropoff_other_country%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A24%3A%22txt_pickup_other_country%22%3Bs%3A9%3A%22Sri+Lanka%22%3Bs%3A26%3A%22txt_dropoff_other_address1%22%3Bs%3A9%3A%22sri+lanka%22%3Bs%3A25%3A%22txt_pickup_other_address1%22%3Bs%3A9%3A%22undefined%22%3Bs%3A12%3A%22dropoff_code%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22pickup_code%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22call_from%22%3Bs%3A23%3A%22offline_backend_booking%22%3Bs%3A14%3A%22reservation_id%22%3Bs%3A13%3A%22RDT2021081973%22%3Bs%3A11%3A%22action_name%22%3Bs%3A23%3A%22insert_transfer_booking%22%3Bs%3A17%3A%22agent_selected_id%22%3Bs%3A2%3A%2221%22%3Bs%3A19%3A%22agent_currency_code%22%3Bs%3A3%3A%22INR%22%3Bs%3A22%3A%22supplier_type_selected%22%3Bs%3A1%3A%22L%22%3Bs%3A8%3A%22agent_id%22%3Bs%3A2%3A%2221%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%3A15%3A%22sel_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A13%3A%22sel_city_name%22%3Bs%3A7%3A%22Colombo%22%3Bs%3A8%3A%22sel_city%22%3Bs%3A5%3A%2271100%22%3Bs%3A6%3A%22pickup%22%3Bs%3A1%3A%22O%22%3Bs%3A7%3A%22dropoff%22%3Bs%3A1%3A%22O%22%3Bs%3A10%3A%22sel_pickup%22%3Bs%3A1%3A%22O%22%3Bs%3A11%3A%22sel_dropoff%22%3Bs%3A1%3A%22O%22%3Bs%3A14%3A%22rdSupplierType%22%3Bs%3A1%3A%22L%22%3Bs%3A12%3A%22sel_supplier%22%3Bs%3A10%3A%22S000000066%22%3Bs%3A20%3A%22sel_supplierProfileL%22%3Bs%3A1%3A%226%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%3A18%3A%22applied_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A23%3A%22basecurrency_multiplier%22%3Bd%3A0.01533%3Bs%3A30%3A%22basecurrency_multiplier_native%22%3Bd%3A0.01533%3Bs%3A25%3A%22agent_currency_multiplier%22%3Bs%3A7%3A%221.00000%22%3Bs%3A16%3A%22txt_agent_markup%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22txt_markup%22%3Bs%3A2%3A%2210%22%3Bs%3A15%3A%22select_transfer%22%3Bs%3A3%3A%22183%22%3Bs%3A18%3A%22sel_booking_status%22%3Bs%3A9%3A%22confirmed%22%3Bs%3A13%3A%22transfer_date%22%3Bs%3A10%3A%2228-07-2021%22%3Bs%3A15%3A%22chk_charge_type%22%3Bs%3A14%3A%22private_per_km%22%3Bs%3A16%3A%22sel_vehicle_type%22%3Bs%3A1%3A%225%22%3Bs%3A19%3A%22supplier_commission%22%3BN%3Bs%3A22%3A%22total_native_surcharge%22%3Bd%3A0%3Bs%3A23%3A%22total_display_surcharge%22%3Bd%3A0%3Bs%3A17%3A%22total_native_rate%22%3Bs%3A4%3A%221000%22%3Bs%3A11%3A%22vehicle_cnt%22%3Bs%3A1%3A%221%22%3Bs%3A17%3A%22leader_salutation%22%3Bs%3A2%3A%22Ms%22%3Bs%3A17%3A%22leader_first_name%22%3Bs%3A4%3A%22Roma%22%3Bs%3A16%3A%22leader_last_name%22%3Bs%3A7%3A%22Banwani%22%3Bs%3A18%3A%22dropoff_time_other%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22Time_Minute%22%3Bs%3A0%3A%22%22%3B%7Ds%3A17%3A%22pickup_time_other%22%3Ba%3A2%3A%7Bs%3A9%3A%22Time_Hour%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22Time_Minute%22%3Bs%3A0%3A%22%22%3B%7Ds%3A9%3A%22no_adults%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A1%3B%7Ds%3A11%3A%22no_children%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A0%3B%7Ds%3A12%3A%22leader_title%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A2%3A%22Ms%22%3B%7Ds%3A9%3A%22lead_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A4%3A%22Roma%22%3B%7Ds%3A14%3A%22lead_last_name%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A7%3A%22Banwani%22%3B%7Ds%3A10%3A%22lead_phone%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A10%3A%22adult_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22child_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A1%3A%220%22%3B%7Ds%3A11%3A%22parking_fee%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A11%3A%22driver_tips%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A19%3A%22representative_cost%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A10%3A%22guide_cost%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A13%3A%22touristic_fee%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A0%3A%22%22%3B%7Ds%3A11%3A%22native_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A7%3A%221000.00%22%3B%7Ds%3A12%3A%22display_rate%22%3Ba%3A1%3A%7Bi%3A0%3Bs%3A7%3A%221100.00%22%3B%7Ds%3A16%3A%22native_surcharge%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A0%3B%7Ds%3A17%3A%22display_surcharge%22%3Ba%3A1%3A%7Bi%3A0%3Bd%3A0%3B%7Ds%3A18%3A%22total_display_rate%22%3Bd%3A1100%3Bs%3A14%3A%22applicable_tax%22%3Bi%3A0%3Bs%3A27%3A%22display_surcharge_and_rates%22%3Bd%3A1100%3Bs%3A26%3A%22native_surcharge_and_rates%22%3Bd%3A1000%3Bs%3A15%3A%22expiration_date%22%3Bs%3A19%3A%2220-08-2021+00%3A00%3A00%22%3Bs%3A13%3A%22meeting_point%22%3Bs%3A0%3A%22%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%3A19%3A%22confirmation_number%22%3Bs%3A0%3A%22%22%3Bs%3A20%3A%22txt_sub_agent_markup%22%3Bs%3A0%3A%22%22%3Bs%3A17%3A%22additional_charge%22%3Bs%3A0%3A%22%22%3Bs%3A12%3A%22leader_phone%22%3Bs%3A0%3A%22%22%3Bs%3A8%3A%22email_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22trans_duration%22%3Bs%3A11%3A%223+hr+0+min+%22%3Bs%3A14%3A%22leader_address%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22additional_distance%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22calculated_distance%22%3Bi%3A100%3Bs%3A14%3A%22passenger_list%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A4%3A%7Bs%3A10%3A%22salutation%22%3Ba%3A0%3A%7B%7Ds%3A10%3A%22first_name%22%3Ba%3A0%3A%7B%7Ds%3A9%3A%22last_name%22%3Ba%3A0%3A%7B%7Ds%3A3%3A%22age%22%3Ba%3A0%3A%7B%7D%7D%7Ds%3A20%3A%22is_quote_fit_booking%22%3Bs%3A1%3A%221%22%3Bs%3A21%3A%22fetch_booking_details%22%3Bb%3A1%3Bs%3A8%3A%22sequence%22%3Bs%3A1%3A%223%22%3Bs%3A12%3A%22itenirary_id%22%3Bs%3A1%3A%223%22%3B%7Ds%3A17%3A%22quotation_details%22%3Bs%3A9484%3A%22a%253A58%253A%257Bs%253A8%253A%2522noofpass%2522%253Bs%253A1%253A%25221%2522%253Bs%253A8%253A%2522tra_date%2522%253Bs%253A10%253A%25222021-07-28%2522%253Bs%253A17%253A%2522markup_percentage%2522%253Bs%253A2%253A%252210%2522%253Bs%253A10%253A%2522TransferId%2522%253Bs%253A3%253A%2522183%2522%253Bs%253A13%253A%2522Vehicle_un_id%2522%253Bs%253A19%253A%2522localtransfer_183_0%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A22%253A%2522Srilanka%2BTransfer%2BTest%2522%253Bs%253A4%253A%2522city%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A9%253A%2522city_code%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A6%253A%2522Pickup%2522%253Ba%253A0%253A%257B%257Ds%253A7%253A%2522Dropoff%2522%253Ba%253A0%253A%257B%257Ds%253A8%253A%2522Duration%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A3%253A%25223.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A11%253A%25223%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A16%253A%2522rateCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522cancellation_hours%2522%253Bs%253A2%253A%252248%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A15%253A%2522TransferSummary%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252210%2522%253Bs%253A13%253A%2522total_charges%2522%253Bs%253A7%253A%25221100.00%2522%253Bs%253A17%253A%2522propertyAvailable%2522%253Bs%253A1%253A%25220%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253BN%253Bs%253A19%253A%2522per_child_agentrate%2522%253BN%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bi%253A0%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bi%253A0%253Bs%253A7%253A%2522Vehical%2522%253Ba%253A9%253A%257Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A11%253A%2522supplier_id%2522%253Bs%253A10%253A%2522S000000066%2522%253Bs%253A10%253A%2522ChargeType%2522%253Bs%253A12%253A%2522privateperkm%2522%253Bs%253A8%253A%2522RateInfo%2522%253Ba%253A15%253A%257Bs%253A9%253A%2522AdultRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522ChildRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522TariffCode%2522%253Bs%253A32%253A%2522129d2cf3fd8db68c03b7474915ad90b0%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A7%253A%25221100.00%2522%253B%257Ds%253A15%253A%2522displayRoomRate%2522%253Bs%253A7%253A%25221100.00%2522%253Bs%253A23%253A%2522chargeableRoomRateTotal%2522%253Bs%253A7%253A%25221000.00%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A7%253A%25221000.00%2522%253B%257Ds%253A14%253A%2522nativeRoomRate%2522%253Bs%253A7%253A%25221000.00%2522%253Bs%253A14%253A%2522baseNativeRate%2522%253Bs%253A2%253A%252210%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522per_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A8%253A%2522Language%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522code%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A4%253A%2522desc%2522%253Bs%253A7%253A%2522English%2522%253B%257Ds%253A11%253A%2522VehicleInfo%2522%253Ba%253A5%253A%257Bs%253A4%253A%2522Code%2522%253Bs%253A1%253A%25225%2522%253Bs%253A14%253A%2522MaximumLuggage%2522%253Bs%253A1%253A%25229%2522%253Bs%253A17%253A%2522MaximumPassengers%2522%253Bs%253A1%253A%25229%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A13%253A%2522VAN%2B15%2BSEATER%2522%253Bs%253A12%253A%2522thumbNailUrl%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A20%253A%2522noofAdultPassVehicle%2522%253Bs%253A1%253A%25221%2522%253Bs%253A20%253A%2522noofChildPassVehicle%2522%253Bs%253A1%253A%25220%2522%253Bs%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253B%257Ds%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522selected_currency%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A12%253A%2522country_code%2522%253Bs%253A3%253A%2522132%2522%253Bs%253A12%253A%2522to_city_code%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A9%253A%2522language1%2522%253Bs%253A1%253A%2522E%2522%253Bs%253A9%253A%2522language2%2522%253Bs%253A1%253A%2522E%2522%253Bs%253A27%253A%2522display_currency_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A11%253A%2522nationality%2522%253Bs%253A3%253A%2522106%2522%253Bs%253A9%253A%2522noofadult%2522%253Bs%253A1%253A%25221%2522%253Bs%253A9%253A%2522noofchild%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522child_age%2522%253Ba%253A0%253A%257B%257Ds%253A18%253A%2522selected_child_age%2522%253Ba%253A0%253A%257B%257Ds%253A17%253A%2522additional_markup%2522%253Bs%253A2%253A%252210%2522%253Bs%253A12%253A%2522country_name%2522%253Bs%253A9%253A%2522Sri%2BLanka%2522%253Bs%253A16%253A%2522pickup_code_name%2522%253Bs%253A9%253A%2522undefined%2522%253Bs%253A17%253A%2522dropoff_code_name%2522%253Bs%253A9%253A%2522sri%2Blanka%2522%253Bs%253A6%253A%2522pickup%2522%253Bs%253A1%253A%2522H%2522%253Bs%253A7%253A%2522dropoff%2522%253Bs%253A1%253A%2522H%2522%253Bs%253A11%253A%2522pickup_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A12%253A%2522dropoff_code%2522%253Bs%253A0%253A%2522%2522%253Bs%253A13%253A%2522total_mileage%2522%253Bs%253A3%253A%2522100%2522%253Bs%253A13%253A%2522extra_mileage%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522language1_data%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A14%253A%2522language2_data%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A21%253A%2522dropoff_transfer_city%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A26%253A%2522dropoff_transfer_city_name%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A9%253A%2522item_code%2522%253Bs%253A3%253A%2522183%2522%253Bs%253A18%253A%2522description_number%2522%253Bi%253A0%253Bs%253A18%253A%2522total_native_price%2522%253Bs%253A7%253A%25221000.00%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%253A3%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%253A2%253A%252215%2522%253B%257Ds%253A10%253A%2522tax_profit%2522%253Ba%253A4%253A%257Bs%253A7%253A%2522net_tax%2522%253Bs%253A6%253A%2522143.48%2522%253Bs%253A10%253A%2522tax_markup%2522%253Bs%253A2%253A%252210%2522%253Bs%253A13%253A%2522profit_amount%2522%253Bs%253A6%253A%2522-43.48%2522%253Bs%253A14%253A%2522profit_percent%2522%253Bs%253A4%253A%25220.00%2522%253B%257D%257Ds%253A8%253A%2522Transfer%2522%253Ba%253A28%253A%257Bs%253A25%253A%2522RateBreakUpDetailsCompact%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A12%253A%257Bs%253A4%253A%2522date%2522%253Bs%253A10%253A%25222021-07-28%2522%253Bs%253A13%253A%2522supplier_rate%2522%253Bs%253A4%253A%25221000%2522%253Bs%253A31%253A%2522supplier_rate_in_agent_currency%2522%253Bs%253A4%253A%25221000%2522%253Bs%253A14%253A%2522applied_markup%2522%253Bs%253A2%253A%252210%2522%253Bs%253A21%253A%2522applied_markup_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A18%253A%2522applied_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A10%253A%2522agent_rate%2522%253Bs%253A4%253A%25221100%2522%253Bs%253A19%253A%2522supplier_commission%2522%253Bs%253A1%253A%25220%2522%253Bs%253A26%253A%2522supplier_commission_amount%2522%253Bs%253A1%253A%25220%2522%253Bs%253A6%253A%2522profit%2522%253Bs%253A3%253A%2522100%2522%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%253A27%253A%2522display_currency_multiplier%2522%253Bs%253A7%253A%25221.00000%2522%253Bs%253A17%253A%2522markup_percentage%2522%253Bs%253A2%253A%252210%2522%253Bi%253A0%253Bs%253A7%253A%25221100.00%2522%253Bs%253A10%253A%2522TransferId%2522%253Bs%253A3%253A%2522183%2522%253Bs%253A4%253A%2522name%2522%253Bs%253A22%253A%2522Srilanka%2BTransfer%2BTest%2522%253Bs%253A4%253A%2522city%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A9%253A%2522city_code%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A11%253A%2522DropoffCity%2522%253Bs%253A7%253A%2522Colombo%2522%253Bs%253A15%253A%2522DropoffCityCode%2522%253Bs%253A5%253A%252271100%2522%253Bs%253A8%253A%2522Duration%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522Time%2522%253Bs%253A3%253A%25223.0%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A11%253A%25223%2Bhr%2B0%2Bmin%2B%2522%253B%257Ds%253A6%253A%2522Pickup%2522%253Ba%253A0%253A%257B%257Ds%253A7%253A%2522Dropoff%2522%253Ba%253A0%253A%257B%257Ds%253A16%253A%2522rateCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522cancellation_hours%2522%253Bs%253A2%253A%252248%2522%253Bs%253A10%253A%2522sourceType%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A14%253A%2522originalsource%2522%253Bs%253A13%253A%2522localtransfer%2522%253Bs%253A19%253A%2522supplier_profile_id%2522%253Bs%253A1%253A%25226%2522%253Bs%253A15%253A%2522TransferSummary%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522shortDescription%2522%253Bs%253A0%253A%2522%2522%253Bs%253A7%253A%2522Vehicle%2522%253Ba%253A1%253A%257Bi%253A0%253Ba%253A9%253A%257Bs%253A9%253A%2522available%2522%253Bs%253A1%253A%25220%2522%253Bs%253A11%253A%2522supplier_id%2522%253Bs%253A10%253A%2522S000000066%2522%253Bs%253A10%253A%2522ChargeType%2522%253Bs%253A12%253A%2522privateperkm%2522%253Bs%253A8%253A%2522RateInfo%2522%253Ba%253A15%253A%257Bs%253A9%253A%2522AdultRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A9%253A%2522ChildRate%2522%253Bs%253A1%253A%25220%2522%253Bs%253A10%253A%2522TariffCode%2522%253Bs%253A32%253A%2522129d2cf3fd8db68c03b7474915ad90b0%2522%253Bs%253A19%253A%2522displayCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A19%253A%2522DisplayNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A18%253A%2522displayNightlyRate%2522%253Bs%253A7%253A%25221100.00%2522%253B%257Ds%253A15%253A%2522displayRoomRate%2522%253Bs%253A7%253A%25221100.00%2522%253Bs%253A23%253A%2522chargeableRoomRateTotal%2522%253Bs%253A7%253A%25221000.00%2522%253Bs%253A18%253A%2522nativeCurrencyCode%2522%253Bs%253A3%253A%2522INR%2522%253Bs%253A18%253A%2522NativeNightlyRates%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522size%2522%253Bs%253A1%253A%25221%2522%253Bs%253A17%253A%2522nativeNightlyRate%2522%253Bs%253A7%253A%25221000.00%2522%253B%257Ds%253A14%253A%2522nativeRoomRate%2522%253Bs%253A7%253A%25221000.00%2522%253Bs%253A14%253A%2522baseNativeRate%2522%253Bs%253A2%253A%252210%2522%253Bs%253A19%253A%2522per_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A19%253A%2522per_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_adult_agentrate%2522%253Bs%253A0%253A%2522%2522%253Bs%253A21%253A%2522total_child_agentrate%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A8%253A%2522Language%2522%253Ba%253A2%253A%257Bs%253A4%253A%2522code%2522%253Bs%253A7%253A%2522English%2522%253Bs%253A4%253A%2522desc%2522%253Bs%253A7%253A%2522English%2522%253B%257Ds%253A11%253A%2522VehicleInfo%2522%253Ba%253A5%253A%257Bs%253A4%253A%2522Code%2522%253Bs%253A1%253A%25225%2522%253Bs%253A14%253A%2522MaximumLuggage%2522%253Bs%253A1%253A%25229%2522%253Bs%253A17%253A%2522MaximumPassengers%2522%253Bs%253A1%253A%25229%2522%253Bs%253A8%253A%2522_content%2522%253Bs%253A13%253A%2522VAN%2B15%2BSEATER%2522%253Bs%253A12%253A%2522thumbNailUrl%2522%253Bs%253A0%253A%2522%2522%253B%257Ds%253A20%253A%2522noofAdultPassVehicle%2522%253Bs%253A1%253A%25221%2522%253Bs%253A20%253A%2522noofChildPassVehicle%2522%253Bs%253A1%253A%25220%2522%253Bs%253A13%253A%2522no_of_vehicle%2522%253Bs%253A1%253A%25221%2522%253B%257D%257Ds%253A19%253A%2522transfer_conditions%2522%253Bs%253A0%253A%2522%2522%253Bs%253A16%253A%2522user_description%2522%253Bs%253A0%253A%2522%2522%253Bs%253A14%253A%2522special_remark%2522%253Bs%253A0%253A%2522%2522%253Bs%253A18%253A%2522applied_markup_per%2522%253Bs%253A2%253A%252210%2522%253Bs%253A13%253A%2522total_charges%2522%253Bs%253A7%253A%25221100.00%2522%253Bs%253A17%253A%2522propertyAvailable%2522%253Bs%253A1%253A%25220%2522%253B%257D%257D%22%3B%7D', create_date='2021-08-20 11:57:15';;
[08/20/2021 11:57:15], [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
        ('','','3140','confirmed','2021-08-20 11:57:15','Quotation Id - RDTCD0021191 created on behalf of Agent - Ankita Rao(21) by tfg','tfg','171.60.184.136','tfg','','');
[08/20/2021 11:57:15], [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
        ('','','3140','confirmed','2021-08-20 11:57:15','Enquiry Id - 412 created on behalf of Agent - Ankita Rao(21) by tfg','tfg','171.60.184.136','tfg','','');
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='booked' where unique_id='RDTCD0021191';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3139',q_id='RDTCD0021191',enquiry_id='412',quote_id='1917',backoffice_user='tfg',agent_id='21',create_date='2021-08-20 11:57:15',booked_from='agent_quote_itemized';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO quotation_bookings SET booking_id='3140',q_id='RDTCD0021191',enquiry_id='412',quote_id='1918',backoffice_user='tfg',agent_id='21',create_date='2021-08-20 11:57:15',booked_from='agent_quote_itemized';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO tags_booking SET booking_id='3139', q_id='RDTCD0021191' ,enquiry_id ='',tags ='romance,romanticdrive,welcometohell,mommylove,hellomumbai',backoffice_user ='tfg',create_date ='2021-08-20 11:57:15';
[08/20/2021 11:57:15], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE bookings SET reservation_id='RDT2021081973' WHERE id IN (3139,3140);
