[07/13/2020 08:06:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-13 08:06:41',login_attempt=0 where id = '23';
[07/13/2020 08:06:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'Sayali', user_type = 'A', branch_id = '1', login_datetime = '2020-07-13 08:06:41', ip = '150.107.41.241', action = 'Login' ;
[07/13/2020 08:06:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-07-13 08:06:53',login_attempt=0 where id = '21';
[07/13/2020 08:06:53], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'ankita', user_type = 'A', branch_id = '3', login_datetime = '2020-07-13 08:06:53', ip = '150.107.41.241', action = 'Login' ;
[07/13/2020 08:07:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '150.107.41.241' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/07/22' , departure_date = '2020/07/23' , nationality = '3' , nights = '1' , room_types = '2' , create_date = '2020-07-13 08:07:54' , site_id = '' , country_code = '106' , web_service = '' ;
[07/13/2020 08:07:58], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-07-13 08:07:58', '', 'b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7', '341');
[07/13/2020 08:07:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7&xml_user_id=21&request_no=0&local_hotel_code=2&#039;,&#039;97&#039;,&#039;53716&#039;,&#039;53734&#039;,&#039;53735&#039;,&#039;53736&#039;,&#039;53737&#039;,&#039;53738&#039;,&#039;53739&#039;,&#039;53740&#039;,&#039;53741&#039;,&#039;53742&#039;,&#039;53744&#039;,&#039;53745&#039;,&#039;53746&#039;,&#039;53747&#039;,&#039;53748&#039;,&#039;53749&#039;,&#039;53750&#039;,&#039;53751&#039;,&#039;53757&#039;,&#039;53758&#039;,&#039;53759&web_service=no&site_id='
, http_hit_time = '2020-07-13 08:07:58.85'
, request_start_time = '0.000'
, parsing_start_time = '0.000'
, mapping_complete_time = '0.000'
, mongo_start_time = '0.000'
, search_end_time = '0.000'
, total_duration = '1.609'
, error_description = ''
, memory_used = '8020520'
WHERE id = '2878';
[07/13/2020 08:07:59], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=21&sessionid=b404c6c12f9a97d3c6b970d1f052494d9e882f04c2e62ae5b14498a1871f4cd7',
  duration = '2.997',
  merge_duration = '0.139',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.69',
  system_load_5_min = '2.46',
  system_load_15_min = '2.64',
  system_memory_usage = '90.77',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '341') + '8148720',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '341';
[07/13/2020 08:08:29], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594627709','150.107.41.241');
[07/13/2020 08:09:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1594627766','150.107.41.241');
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = '1666', create_date = '2020-07-13 08:09:38', agent_id = '21', parent_agent_id = '21', agent_ref_no = '', nationality = 'Bahamian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '240', display_currency_code = 'INR', native_room_rate = '200', native_currency_code = 'INR', supplier_profile_id = '1', service_type = 'hotel', service_date = '2020/07/22', check_out_date = '2020/07/23', sub_user_id = '', booking_status = '1', leader_title = '', leader_first_name = '', leader_last_name = '', booking_branch_id = '3', expiration_date = '2020-07-13 08:09:00', cancellation_policy = 'Amendment of Dates, Room Category, Passenger Names are considered as Cancel and Rebook by most of the Hotels.
        Any Changes in initial booking may be denied by the supplier or may result in extra charges.
        Confirmation of amendment requests is subject to availablity and rates at the time of amendment.<Br><Br><B><U>Detailed Cancellation Policy:</U></B> <br/> Cancellation Charges of 240 INR applicable if cancelled after 13 Jul 2020 13:38 hrs.', supplier_cancellation_policy = '', status_date = '2020-07-13 08:09:38',  site_url = 'http://uat.tfg.otrams.net/';
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO external_mapping_data_tracking (booking_id,search_hotel_name,booked_hotel_name_supplier,hotel_id,master_id,city_id,supplier,date)
            VALUES ('2781','TAMASHA','TAMASHA','53749','53749','mumbai','LOCAL_SUPPLIER',NOW());
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '3'
        WHERE
        id='2781'
        ;
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into bookings_details(booking_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,hotel_id,local_hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('2781','S000000219','1','2','0','-','','','53749','53749','TAMASHA','Test Address','+605 - 1234 5677','4.0','1','2020/07/22','2020/07/23','','http://uat.tfg.otrams.net/project_folder/tfg_project/images/imagenotavailable.jpg');
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '2781', booking_detail_id = '1088', room_type_code = '2~~~140~~~930~~~1~~~~~~~~~64440~~~0~~~S000000219', room_name = 'double', room_type_description = 'ROH (Standard/Superior)  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI) (Non-Refundable)', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:240;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:190:\"Supplier Name - localsupplier(Tamasha - S000000219), Rate - 200 INR, Currency Multiplier (INR-INR) - 1.00000 Supplier Commission-0 , Branch:% #localsystem Agent Hotel Category Markup=20.00 %\";}}', native_nightly_rates = 'a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0219-11508\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}', markup = '0', commission = '0', native_room_rate_total = '200', display_room_rate_total = '240', number_of_rooms = '1';
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '', confirmation_number = '', display_discount = '0', current_status = 'confirmed', comment_contract = ' Tax will be collected at the time of Check-Out', consultant_id = 'nitinalpha', sales_manager_id = '', admin_booked = '1', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '150.107.41.241', backoffice_user = 'tfg', customer_id = '', applied_multiplier='1.00000', free_sale='',  applied_markup='20',  agent_markup='20',  basecurrency_multiplier='0.01533',  basecurrency_multiplier_native='0.01533',  parent_agent_id='21',  sub_agent_rate='0', agent_rate='240',  applicable_service_tax='0',  supplier_rate='200',  original_source='',  uid='da2f1ddb38d0c0608012dbb809f43298'  where id='2781';
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' ,gtaToken = '' , special_request='' where booking_id ='2781';
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,supplier_charge,agent_charge,lead_time,create_date)  VALUES('2781','2020-07-13 08:08:00','2020-07-13 08:08:00','200','240','0','2020-07-13 08:09:38');
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '2781' , sr_id = '1',approved_status='1' ;
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], INSERT INTO booking_special_request set booking_id = '2781' , sr_id = '2',approved_status='1' ;
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('2781','6.278698','99.730656');
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_status (booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('2781','confirmed','2020-07-13 08:09:38','Booking confirmed . Booked by Back Office tfg on behalf of Agent - Ankita  Rao(CD0021)','21','150.107.41.241','0','21');
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details)
        VALUES(2781, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"5f0c165ffad1ad1c2d0e8248\";}s:7:\"hotelId\";s:25:\"53749----------S000000219\";s:4:\"name\";s:7:\"TAMASHA\";s:14:\"local_hotel_id\";s:5:\"53749\";s:8:\"address1\";s:12:\"Test Address\";s:8:\"latitude\";d:6.278698;s:9:\"longitude\";d:99.730656;s:4:\"city\";s:5:\"64440\";s:8:\"location\";N;s:14:\"prefered_hotel\";s:1:\"0\";s:10:\"mlosSlogan\";s:0:\"\";s:16:\"isMlosApplicable\";s:2:\"no\";s:7:\"country\";s:3:\"106\";s:16:\"rateCurrencyCode\";s:3:\"INR\";s:5:\"phone\";s:16:\"+605 - 1234 5677\";s:16:\"shortDescription\";s:22:\"TEST HOTEL DESCRIPTION\";s:11:\"website_url\";s:20:\"http://www.test.com/\";s:12:\"thumbNailUrl\";s:81:\"http://uat.tfg.otrams.net/project_folder/tfg_project/images/imagenotavailable.jpg\";s:10:\"sourceType\";s:11:\"localsystem\";s:10:\"supplierid\";s:10:\"S000000219\";s:12:\"suppliername\";s:7:\"Tamasha\";s:14:\"propertyRating\";s:3:\"4.0\";s:15:\"specialCategory\";a:1:{i:0;s:1:\"1\";}s:13:\"HotelProperty\";a:1:{s:11:\"localsystem\";a:4:{i:0;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0219-11508\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:240;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:190:\"Supplier Name - localsupplier(Tamasha - S000000219), Rate - 200 INR, Currency Multiplier (INR-INR) - 1.00000 Supplier Commission-0 , Branch:% #localsystem Agent Hotel Category Markup=20.00 %\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";s:46:\"Tax will be collected at the time of Check-Out\";s:10:\"time_stamp\";s:32:\"61cfed1abeeecf64126c9ba36aac0c60\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"0\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:20:\"displayRoomTypeRates\";i:240;s:20:\"sortingRoomTypeRates\";i:240;s:19:\"nativeRoomTypeRates\";i:200;s:12:\"offerApplied\";N;s:7:\"room_id\";s:48:\"2~~~140~~~930~~~1~~~~~~~~~64440~~~0~~~S000000219\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:48:\"2~~~140~~~930~~~1~~~~~~~~~64440~~~0~~~S000000219\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000219\";s:12:\"supplierName\";s:7:\"Tamasha\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:37:\"Promotion~ FREE WIFI (Non-Refundable)\";s:13:\"room_category\";s:28:\"ROH (Standard/Superior) Room\";s:9:\"room_type\";s:112:\"ROH (Standard/Superior)  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI) (Non-Refundable)\";s:14:\"non_refundable\";s:1:\"1\";s:15:\"class_unique_id\";s:17:\"0_0_53749_5651000\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";i:240;s:14:\"nativeRoomRate\";i:200;s:9:\"unique_id\";s:38:\"1_53749----------S000000219_10_0_18933\";s:10:\"supplierId\";s:10:\"S000000219\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:20;s:18:\"applied_multiplier\";s:7:\"1.00000\";s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53749----------S000000219\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:7:\"TAMASHA\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000219\";}s:8:\"no_class\";i:0;}}i:1;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:200;s:17:\"nativeNightlyRate\";i:200;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0219-11508\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:240;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:190:\"Supplier Name - localsupplier(Tamasha - S000000219), Rate - 200 INR, Currency Multiplier (INR-INR) - 1.00000 Supplier Commission-0 , Branch:% #localsystem Agent Hotel Category Markup=20.00 %\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"2c1ec640c2a73c48ac9f264759057bb3\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"0\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:20:\"displayRoomTypeRates\";i:240;s:20:\"sortingRoomTypeRates\";i:240;s:19:\"nativeRoomTypeRates\";i:200;s:12:\"offerApplied\";N;s:7:\"room_id\";s:48:\"2~~~140~~~931~~~1~~~~~~~~~64440~~~1~~~S000000219\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:48:\"2~~~140~~~931~~~1~~~~~~~~~64440~~~1~~~S000000219\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000219\";s:12:\"supplierName\";s:7:\"Tamasha\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:20:\"Promotion~ FREE WIFI\";s:13:\"room_category\";s:28:\"ROH (Standard/Superior) Room\";s:9:\"room_type\";s:95:\"ROH (Standard/Superior)  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI)\";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"1_1_53749_2539962\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";i:240;s:14:\"nativeRoomRate\";i:200;s:9:\"unique_id\";s:38:\"1_53749----------S000000219_10_1_65542\";s:10:\"supplierId\";s:10:\"S000000219\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:20;s:18:\"applied_multiplier\";s:7:\"1.00000\";s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53749----------S000000219\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:7:\"TAMASHA\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000219\";}s:8:\"no_class\";i:0;}}i:2;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:230;s:17:\"nativeNightlyRate\";i:230;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0219-11508\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:276;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:190:\"Supplier Name - localsupplier(Tamasha - S000000219), Rate - 230 INR, Currency Multiplier (INR-INR) - 1.00000 Supplier Commission-0 , Branch:% #localsystem Agent Hotel Category Markup=20.00 %\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"b18fac489b7ee9a7cab3b564ad551cb1\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"0\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:20:\"displayRoomTypeRates\";i:276;s:20:\"sortingRoomTypeRates\";i:276;s:19:\"nativeRoomTypeRates\";i:230;s:12:\"offerApplied\";N;s:7:\"room_id\";s:48:\"2~~~133~~~933~~~1~~~~~~~~~64440~~~2~~~S000000219\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:48:\"2~~~133~~~933~~~1~~~~~~~~~64440~~~2~~~S000000219\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000219\";s:12:\"supplierName\";s:7:\"Tamasha\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:37:\"Promotion~ FREE WIFI (Non-Refundable)\";s:13:\"room_category\";s:23:\"Junior Suite Tower Room\";s:9:\"room_type\";s:107:\"Junior Suite Tower  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI) (Non-Refundable)\";s:14:\"non_refundable\";s:1:\"1\";s:15:\"class_unique_id\";s:17:\"2_2_53749_5259226\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";i:276;s:14:\"nativeRoomRate\";i:230;s:9:\"unique_id\";s:38:\"1_53749----------S000000219_10_2_68948\";s:10:\"supplierId\";s:10:\"S000000219\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:20;s:18:\"applied_multiplier\";s:7:\"1.00000\";s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53749----------S000000219\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:7:\"TAMASHA\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000219\";}s:8:\"no_class\";i:0;}}i:3;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:34:{s:11:\"ratebreakup\";a:4:{s:6:\"markup\";i:0;s:10:\"commission\";i:0;s:18:\"NativeNightlyRates\";a:1:{i:0;a:4:{s:19:\"O_nativeNightlyRate\";i:230;s:17:\"nativeNightlyRate\";i:230;s:9:\"free_sale\";s:2:\"no\";s:14:\"Discount/Offer\";a:7:{s:4:\"code\";a:1:{i:0;s:10:\"0219-11508\";}s:4:\"Name\";a:1:{i:0;s:9:\"Promotion\";}s:7:\"S_Value\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:5:\"Value\";i:0;s:12:\"Display_Name\";a:1:{i:0;s:9:\"Promotion\";}s:10:\"Offer_Note\";a:1:{i:0;s:11:\"~ FREE WIFI\";}s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";i:276;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:190:\"Supplier Name - localsupplier(Tamasha - S000000219), Rate - 230 INR, Currency Multiplier (INR-INR) - 1.00000 Supplier Commission-0 , Branch:% #localsystem Agent Hotel Category Markup=20.00 %\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_note\";s:9:\"Promotion\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";s:11:\"~ FREE WIFI\";s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"279ca5f8351f484bdcf3a7072774e91b\";s:16:\"number_of_adults\";s:1:\"2\";s:10:\"view_basis\";s:0:\"\";s:13:\"view_basis_id\";s:1:\"0\";s:9:\"available\";i:1;s:9:\"free_sale\";N;s:7:\"minStay\";s:1:\"0\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:20:\"displayRoomTypeRates\";i:276;s:20:\"sortingRoomTypeRates\";i:276;s:19:\"nativeRoomTypeRates\";i:230;s:12:\"offerApplied\";N;s:7:\"room_id\";s:48:\"2~~~133~~~934~~~1~~~~~~~~~64440~~~3~~~S000000219\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:48:\"2~~~133~~~934~~~1~~~~~~~~~64440~~~3~~~S000000219\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000219\";s:12:\"supplierName\";s:7:\"Tamasha\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:20:\"Promotion~ FREE WIFI\";s:13:\"room_category\";s:23:\"Junior Suite Tower Room\";s:9:\"room_type\";s:90:\"Junior Suite Tower  -Bed & Breakfast : 2 Pax <br>( Promotion)<br>(Offer Note: ~ FREE WIFI)\";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"3_3_53749_2565163\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";i:276;s:14:\"nativeRoomRate\";i:230;s:9:\"unique_id\";s:38:\"1_53749----------S000000219_10_3_60115\";s:10:\"supplierId\";s:10:\"S000000219\";s:19:\"displayCurrencyCode\";s:3:\"INR\";s:18:\"nativeCurrencyCode\";s:3:\"INR\";s:18:\"applied_markup_per\";i:20;s:18:\"applied_multiplier\";s:7:\"1.00000\";s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53749----------S000000219\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:7:\"TAMASHA\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000219\";}s:8:\"no_class\";i:0;}}}}s:13:\"total_charges\";i:240;s:17:\"propertyAvailable\";i:1;s:8:\"no_class\";i:0;s:18:\"sort_total_charges\";i:240;s:16:\"hotel_name_ascii\";s:7:\"tamasha\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53749----------S000000219\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:7:\"TAMASHA\";s:18:\"supp_hotel_address\";s:12:\"Test Address\";s:10:\"supplierId\";s:10:\"S000000219\";}}');
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('2781','2020-07-13 08:08:00','2020-07-13 08:08:00','1970-01-01 00:00:00','1970-01-01 00:00:00','200','240','0','2020-07-13 08:09:38','');
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '0219-11508',  offer_type_code= 'PM',  booking_id= '2781',  room_id= '2~~~140~~~930~~~1~~~~~~~~~64440~~~0~~~S000000219',  room_name= 'double',  supplier_id= 'S000000219',  agent_id= '',  promotion_text= '',  offer_disc_type= 'Discount',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-07-13 08:09:38' ;
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set confirmation_number='',itenirary_id='2781' where  id ='2781';
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE room_rates SET availability = availability-1,consumed_inventory = consumed_inventory+1 WHERE hotel_id = '53749' and inventory_class_id = '140' and supplier_id = 'S000000219' and date_from = '2020-07-22';
[07/13/2020 08:09:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update supplement_rate set inventory = '0' where supplement_rate_id = '1';
[07/13/2020 08:20:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/quotation.php],DELETE FROM agent_quotation WHERE q_name='0' and agent_id='21';
[07/13/2020 08:21:16], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/13/2020 08:22:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/message_action.php],insert into email_logs SET `subject`= 'Message Acknowledgment - The Fabulous Getaway',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 4720 characters]',to_email_id= 'otramsmessages@thefabulousgetaway.com,nitin@qtechsoftware.com',cc= 'snehal.valanju@qtechsoftware.com',bcc= '',status= 'Success',page_url= '/message_action.php',create_date= '2020-07-13 08:22:01';
[07/13/2020 08:22:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/booking_list.php],update messages set mssg_status='R' where booking_id=?;
[07/13/2020 08:23:20], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/message_action.php],UPDATE msg_message set sender_view_count=1 WHERE id= ?;
[07/13/2020 08:29:43], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '103.104.226.130' , city = 'Mumbai' , arrival_date='2020/07/23',  departure_date='2020/07/23',  nights='1',  create_date='2020-07-13 :08:29:43',  nationality='132',  additional_markup='',  selected_currency='INR',  service_type='transfer',  total_adult='1',  total_children='',  site_id = '' ;
[07/13/2020 08:30:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '45.120.147.56' , city = 'Colombo' , arrival_date='2020/07/23',  departure_date='2020/07/23',  nights='1',  create_date='2020-07-13 :08:30:27',  nationality='132',  additional_markup='',  selected_currency='USD',  service_type='transfer',  total_adult='2',  total_children='',  site_id = '' ;
[07/13/2020 08:30:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '103.104.226.130' , city = 'Colombo' , arrival_date='2020/07/23',  departure_date='2020/07/23',  nights='1',  create_date='2020-07-13 :08:30:54',  nationality='132',  additional_markup='',  selected_currency='USD',  service_type='transfer',  total_adult='2',  total_children='',  site_id = '' ;
[07/13/2020 08:31:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/transfer_search_list.php],INSERT INTO agent_logs SET  agent_id = '21' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '3' , ip = '45.120.147.56' , city = 'Colombo' , arrival_date='2020/07/23',  departure_date='2020/07/23',  nights='1',  create_date='2020-07-13 :08:31:25',  nationality='132',  additional_markup='',  selected_currency='USD',  service_type='transfer',  total_adult='2',  total_children='',  site_id = '' ;
