[10/27/2020 12:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3042','snehal.valanju@qtechsoftware.com');
[10/27/2020 12:45:09], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3042','snehal.valanju@qtechsoftware.com');
[10/27/2020 12:45:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3039','example@test.com');
[10/27/2020 12:45:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3039','example@test.com');
[10/27/2020 12:45:48], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/resend_email.php],insert into temp(booking_id,mail_send_to)values('3039','example@test.com');
[10/27/2020 12:46:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],update agents set last_login_date = '2020-10-27 12:46:49',login_attempt=0 where id = '25';
[10/27/2020 12:46:49], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/agent_login.php],INSERT INTO psa_login_log  SET username = 'PhpTest', user_type = 'A', branch_id = '1', login_datetime = '2020-10-27 12:46:49', ip = '60.254.5.70', action = 'Login' ;
[10/27/2020 12:47:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '25' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '1' , ip = '60.254.5.70' , city = 'mumbai' , service_name = '' , service_type = 'hotel' , arrival_date = '2020/10/29' , departure_date = '2020/10/30' , nationality = '106' , nights = '1' , room_types = '2' , create_date = '2020-10-27 12:47:14' , site_id = '' , country_code = '106' , web_service = '' ;
[10/27/2020 12:47:17], [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-10-27 12:47:17', '', '0c41f8b08d0aac531e509500d81a2b701d43415ad76f2bf4829770a777f428f2', '466');
[10/27/2020 12:47:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=0c41f8b08d0aac531e509500d81a2b701d43415ad76f2bf4829770a777f428f2&xml_user_id=25&request_no=1&local_hotel_code=53769&#039;,&#039;53771&#039;,&#039;53773&#039;,&#039;53775&#039;,&#039;53776&#039;,&#039;53742&web_service=no&site_id='
, http_hit_time = '2020-10-27 12:47:17.222'
, 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 = '0.952'
, error_description = ''
, memory_used = '7908976'
WHERE id = '3228';
[10/27/2020 12:47:18], [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-10-27 12:47:18', '', '0c41f8b08d0aac531e509500d81a2b701d43415ad76f2bf4829770a777f428f2', '466');
[10/27/2020 12:47:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/call.php],UPDATE xmllogs SET
hotel_count = ''
, request_url = '/call.php?s=localsystem&sessionid=0c41f8b08d0aac531e509500d81a2b701d43415ad76f2bf4829770a777f428f2&xml_user_id=25&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;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&#039;,&#039;53766&#039;,&#039;53767&#039;,&#039;53768&web_service=no&site_id='
, http_hit_time = '2020-10-27 12:47:17.194'
, 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.588'
, error_description = ''
, memory_used = '7910416'
WHERE id = '3229';
[10/27/2020 12:47:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/xml_all.php],UPDATE agent_logs SET
  hotel_count = '',
  request_path = '/xml_all.php?userid=25&sessionid=0c41f8b08d0aac531e509500d81a2b701d43415ad76f2bf4829770a777f428f2',
  duration = '2.192',
  merge_duration = '0.088',
  assigned_supplier_count = '1',
  searched_supplier_count = '1',
  system_load_1_min = '0.85',
  system_load_5_min = '1.04',
  system_load_15_min = '1.08',
  system_memory_usage = '89.54',
  memory_usage = (SELECT COALESCE(SUM(memory_used),0) FROM xmllogs WHERE agent_logs_id = '466') + '8043720',
  parallel_search_count = '',
  mongo_archive_collection = '',
  error_description = '',
  is_cached = 'no'
WHERE id = '466';
[10/27/2020 12:47:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603802853','60.254.5.70');
[10/27/2020 12:47:50], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1603802870','60.254.5.70');
[10/27/2020 12:47:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings SET  source_type = 'localsystem', reservation_id = '1859', create_date = '2020-10-27 12:47:54', agent_id = '25', parent_agent_id = '25', agent_ref_no = '', nationality = 'Indian', city_id = 'mumbai', country_id = '106', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '54.44', display_currency_code = 'USD', native_room_rate = '200', native_currency_code = 'AED', supplier_profile_id = '1', service_type = 'hotel', service_date = '2020/10/29', check_out_date = '2020/10/30', sub_user_id = '', booking_status = '1', leader_title = '', leader_first_name = '', leader_last_name = '', booking_branch_id = '1', expiration_date = '2020-10-27 00:00: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 2.72 USD applicable if cancelled after 26-Oct-2020 14:00 hrs.', supplier_cancellation_policy = '', status_date = '2020-10-27 12:47:54',  site_url = 'https://alpha.otrams.thefabulousgetaway.com/';
[10/27/2020 12:47:54], [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 ('3050','SASSYSPOON','SASSYSPOON','53775','53775','mumbai','LOCAL_SUPPLIER',NOW());
[10/27/2020 12:47:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],UPDATE
        bookings
        SET
        booking_branch_id= '1'
        WHERE
        id='3050'
        ;
[10/27/2020 12:47:54], [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('3050','S000000241','1','2','0','-','','','53775','53775','SASSYSPOON','Test','123456789','5.0','1','2020/10/29','2020/10/30','','https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg');
[10/27/2020 12:47:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_room_detail set  booking_id = '3050', booking_detail_id = '1188', room_type_code = '2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241', room_name = 'double', room_type_description = 'Standard  -Bed & Breakfast : 2 Pax <font color=\'red\'>-D</font>', display_nightly_rates = 'a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";d:54.44;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 200 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}}', 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\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}', markup = '0', commission = '0', native_room_rate_total = '200', display_room_rate_total = '54.44', number_of_rooms = '1';
[10/27/2020 12:47:54], [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 = '', consultant_id = 'nitinalpha', sales_manager_id = 'otrams', admin_booked = '1', email_id = '', leader_phone = '', agent_currency_multiplier = '1.00000', ip_addr = '60.254.5.70', backoffice_user = 'tfg', customer_id = '', applied_multiplier='0.27222', free_sale='',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='0.27222',  parent_agent_id='25',  sub_agent_rate='0', agent_rate='54.44',  applicable_service_tax='0',  supplier_rate='200',  original_source='',  uid='7fa21c4bbb355111a89eef5c97dc8224'  where id='3050';
[10/27/2020 12:47:54], [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 ='3050';
[10/27/2020 12:47:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set reservation_pushed = '1', channel_manager = 'rategain',room_type_description='' where booking_id = '3050';
[10/27/2020 12:47:54], [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('3050','2020-10-26 14:00:00','2020-10-26 14:00:00','10','2.72','0','2020-10-27 12:47:54');
[10/27/2020 12:47:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('3050','','');
[10/27/2020 12:47:54], [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 ('3050','confirmed','2020-10-27 12:47:54','Booking confirmed . Booked by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0025)','25','60.254.5.70','0','25');
[10/27/2020 12:47:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_search_log(booking_id, details)
        VALUES(3050, 'a:30:{s:3:\"_id\";a:1:{s:4:\"$oid\";s:24:\"5f9816d64d916d3df06ebf10\";}s:7:\"hotelId\";s:25:\"53775----------S000000241\";s:4:\"name\";s:10:\"SASSYSPOON\";s:14:\"local_hotel_id\";s:5:\"53775\";s:8:\"address1\";s:4:\"Test\";s:8:\"latitude\";s:0:\"\";s:9:\"longitude\";s:0:\"\";s:4:\"city\";s:5:\"64440\";s:8:\"location\";s:0:\"\";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:\"USD\";s:5:\"phone\";s:9:\"123456789\";s:16:\"shortDescription\";s:24:\"No Description Available\";s:11:\"website_url\";s:0:\"\";s:12:\"thumbNailUrl\";s:99:\"https://alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/images/imagenotavailable.jpg\";s:10:\"sourceType\";s:11:\"localsystem\";s:10:\"supplierid\";s:10:\"S000000241\";s:12:\"suppliername\";s:16:\"RateGainSupplier\";s:14:\"propertyRating\";s:3:\"5.0\";s:15:\"specialCategory\";a:1:{i:0;s:1:\"1\";}s:13:\"HotelProperty\";a:1:{s:11:\"localsystem\";a:1:{i:0;a:1:{s:8:\"RateInfo\";a:13:{s:10:\"room_rates\";a:1:{i:0;a:33:{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\";s:0:\"\";s:4:\"Name\";s:0:\"\";s:7:\"S_Value\";s:0:\"\";s:5:\"Value\";i:0;s:12:\"Display_Name\";s:0:\"\";s:10:\"Offer_Note\";N;s:10:\"Offer_Type\";N;}}}s:19:\"DisplayNightlyRates\";a:1:{i:0;a:3:{s:18:\"displayNightlyRate\";d:54.44;s:16:\"promotionDisplay\";s:0:\"\";s:25:\"displayNightlyRateDisplay\";s:152:\"Supplier Name - localsupplier(RateGainSupplier - S000000241), Rate - 200 AED, Currency Multiplier (AED-USD) - 0.27222 Supplier Commission-0 #localsystem\";}}}s:20:\"offer_promotion_note\";s:0:\"\";s:19:\"offer_discount_type\";s:0:\"\";s:27:\"offer_discount_note_details\";N;s:9:\"room_name\";s:6:\"double\";s:9:\"stay_note\";N;s:10:\"time_stamp\";s:32:\"28cc18be1e999d276b002b813513e4a2\";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:\"1\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:20:\"displayRoomTypeRates\";d:54.44;s:20:\"sortingRoomTypeRates\";d:54.44;s:19:\"nativeRoomTypeRates\";i:200;s:12:\"offerApplied\";N;s:7:\"room_id\";s:49:\"2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:14:\"room_type_code\";s:1:\"2\";s:14:\"boardtype_code\";s:1:\"1\";s:16:\"valuation_number\";s:49:\"2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241\";s:15:\"number_of_child\";i:0;s:13:\"NumberOfRooms\";i:1;s:10:\"supplierId\";s:10:\"S000000241\";s:12:\"supplierName\";s:16:\"RateGainSupplier\";s:10:\"meal_basis\";s:15:\"Bed & Breakfast\";s:4:\"note\";s:0:\"\";s:13:\"room_category\";s:13:\"Standard Room\";s:9:\"room_type\";s:62:\"Standard  -Bed & Breakfast : 2 Pax <font color=\'red\'>-D</font>\";s:14:\"non_refundable\";s:1:\"0\";s:15:\"class_unique_id\";s:17:\"0_0_53775_1817947\";}}s:9:\"available\";i:1;s:15:\"displayRoomRate\";d:54.44;s:14:\"nativeRoomRate\";i:200;s:9:\"unique_id\";s:36:\"1_53775----------S000000241_2_0_1388\";s:10:\"supplierId\";s:10:\"S000000241\";s:19:\"displayCurrencyCode\";s:3:\"USD\";s:18:\"nativeCurrencyCode\";s:3:\"AED\";s:18:\"applied_markup_per\";i:0;s:18:\"applied_multiplier\";d:0.27222;s:19:\"supplier_profile_id\";s:1:\"1\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53775----------S000000241\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:10:\"SASSYSPOON\";s:18:\"supp_hotel_address\";s:4:\"Test\";s:10:\"supplierId\";s:10:\"S000000241\";}s:8:\"no_class\";i:0;}}}}s:13:\"total_charges\";d:54.44;s:17:\"propertyAvailable\";i:1;s:8:\"no_class\";i:0;s:18:\"sort_total_charges\";d:54.44;s:16:\"hotel_name_ascii\";s:10:\"sassyspoon\";s:13:\"supplier_data\";a:5:{s:7:\"hotelId\";s:25:\"53775----------S000000241\";s:10:\"sourceType\";s:11:\"localsystem\";s:15:\"supp_hotel_name\";s:10:\"SASSYSPOON\";s:18:\"supp_hotel_address\";s:4:\"Test\";s:10:\"supplierId\";s:10:\"S000000241\";}}');
[10/27/2020 12:47:54], [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('3050','2020-10-26 14:00:00','2020-10-26 14:00:00','1970-01-01 00:00:00','1970-01-01 00:00:00','10','2.72','0','2020-10-27 12:47:54','');
[10/27/2020 12:47:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings_details set reservation_pushed = '1', channel_manager = 'rategain',room_type_description='' where booking_id = '3050';
[10/27/2020 12:47:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO bookings_applicable_offer set  oid= '',  offer_type_code= '',  booking_id= '3050',  room_id= '2~~~132~~~1044~~~1~~~~~~~~~64440~~~0~~~S000000241',  room_name= 'double',  supplier_id= 'S000000241',  agent_id= '',  applied_native_discount= '0',  original_native_rate= '200',  native_rate= '200',  promotion_text= '',  offer_disc_type= '',  offer_disc_value= '',  offer_disc_currency= '',  create_date= '2020-10-27 12:47:54' ;
[10/27/2020 12:47:54], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set confirmation_number='',itenirary_id='3050' where  id ='3050';
[10/27/2020 12:47:54], [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 = '53775' and inventory_class_id = '132' and supplier_id = 'S000000241' and date_from = '2020-10-29';
[10/27/2020 12:47:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update supplement_rate set inventory = '0' where supplement_rate_id = '1';
[10/27/2020 12:47:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php], insert into booking_configuration set  booking_id = '3050', config_key = 'BOOKING OTP', config_value = 'xK1owJFp';;
[10/27/2020 12:47:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103050 /  Booking Confirmed ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 39944 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-10-27 12:47:55';
[10/27/2020 12:47:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3050','snehal.valanju@qtechsoftware.com');
[10/27/2020 12:47:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3050','snehal.valanju@qtechsoftware.com');
[10/27/2020 12:47:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update posted_bookings set booking_id='3050',status='1' where reservation_id='1859' and booking_id ='0';
[10/27/2020 12:47:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update xmllogs set reservation_id='3050' where agent_logs_id='466' and source_type='localsystem';
[10/27/2020 12:47:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='',  profit_percent='',  gross_profit='',  commission_tax='',  booking_id ='3050',  create_date ='2020-10-27 12:47:55', supplier_tax='';
[10/27/2020 12:47:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],update bookings set voucher_id='Test123',status_date='2020-10-27 12:47:55',current_status='vouchered',voucher_hashcode='808bfcc1cb919b0e7b11958abf59197d773323050',vouchered_by ='' where id='3050';
[10/27/2020 12:47:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],Insert into booking_configuration set booking_id='3050',config_key='VOUCHER_DATE', config_value='2020-10-27 12:47:55',create_date='2020-10-27 12:47:55';
[10/27/2020 12:47:55], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],INSERT INTO booking_status (visa_id,visa_status,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by,crons) VALUES
        ('','','3050','vouchered','2020-10-27 12:47:55','Voucherd by Back Office tfg on behalf of Agent - Snehal  Valanju(CD0025)','25','60.254.5.70','','','');
[10/27/2020 12:47:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into email_logs SET `subject`= ' TFG103050 /  Booking Vouchered ',from_email_id= 'sanket.desai@qtechsoftware.com',body= '[encoded data, 27828 characters]',to_email_id= 'snehal.valanju@qtechsoftware.com,nitin@qtechsoftware.com',cc= '',bcc= '',status= 'Success',page_url= '/confirm_booking.php',create_date= '2020-10-27 12:47:56';
[10/27/2020 12:47:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3050','snehal.valanju@qtechsoftware.com');
[10/27/2020 12:47:56], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/confirm_booking.php],insert into temp(booking_id,mail_send_to)values('3050','nitin@qtechsoftware.com');
[10/27/2020 12:48:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO enquiry SET agent_id = '21', contact_salutation = 'Mr', contact_name = 'Mr', residing_country = '106', currency = 'INR', enquiry_source = 'email', destination = '106', nationality = '106', created_by = 'tfg', create_date= '2020-10-27 12:48:26';
[10/27/2020 12:48:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO task SET module_id='406',module='enquiry',task_status='open',status='A',create_date='2020-10-27 12:48:26' ,created_by='tfg', task_priority='medium', task_description='Offline Quotation Enquiry has been added by tfg&lt;br/&gt;Agent : Qtech_Ankita [CD0021-ankita] [Ankita-Rao]&lt;br/&gt;Country : India&lt;br/&gt;Selected Currency : INR&lt;br/&gt;';
[10/27/2020 12:51:41], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
VALUE ('', 'AVAILABILITY', '/request_placeholder.xml', '/response_placeholder.xml', '/response_header_placeholder.xml', 'localsystem', '2020-10-27 12:51:41', '', '', '');
[10/27/2020 12:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 406;
[10/27/2020 12:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation_sequence SET sequence_no='189' WHERE agent_id='21';
[10/27/2020 12:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'RDTCD0021189',backoffice_user = 'tfg',create_date = '2020-10-27 12:52:01',currency ='INR',service_date='2020-10-27 00:00:00',service_checkout_date='2020-10-28 00:00:00',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D',sequence='2',agent_id = '21',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1996790400%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2227%2F10%2F2020+--+28%2F10%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253775%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253775%22%3Bs%3A4%3A%22name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%225.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%222240%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A16%3A%22RateGainSupplier%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221044%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A48%3A%22Standard+-+Double%2C+Extrabed+-+1++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A49%3A%22Standard+-+Double%2C+Extrabed+-+1+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A31%3A%22Standard+-+Double%2C+Extrabed+-+1%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22240.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2212.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%222240%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253775----------S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A4%3A%22Test%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2212.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A4%3A%22Test%22%3Bs%3A8%3A%22latitude%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22longitude%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2264440%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%222240%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A16%3A%22RateGainSupplier%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221044%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A48%3A%22Standard+-+Double%2C+Extrabed+-+1++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A49%3A%22Standard+-+Double%2C+Extrabed+-+1+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A31%3A%22Standard+-+Double%2C+Extrabed+-+1%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22240.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2212.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%222240%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253775----------S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A4%3A%22Test%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2212.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53775',city_name ='Mumbai',city_code ='64440',country_code ='106',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name =' ',salutation ='Mr',first_name ='',last_name ='',quotation_type ='back_end',total_adult ='2',enquiry_id ='406',total_price ='2240',per_night ='2240',room_type ='Standard - Double, Extrabed - 1 (Bed & Breakfast)',room_rate ='2240';
[10/27/2020 12:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1899', q_name='', service='hotel', agent_id='21', create_date='2020-10-27 12:52:01', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1996790400%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2227%2F10%2F2020+--+28%2F10%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253775%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253775%22%3Bs%3A4%3A%22name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%225.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%222240%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A16%3A%22RateGainSupplier%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221044%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A48%3A%22Standard+-+Double%2C+Extrabed+-+1++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A49%3A%22Standard+-+Double%2C+Extrabed+-+1+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A31%3A%22Standard+-+Double%2C+Extrabed+-+1%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22240.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2212.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%222240%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253775----------S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A4%3A%22Test%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2212.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A4%3A%22Test%22%3Bs%3A8%3A%22latitude%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22longitude%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2264440%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%222240%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A16%3A%22RateGainSupplier%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221044%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A48%3A%22Standard+-+Double%2C+Extrabed+-+1++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A49%3A%22Standard+-+Double%2C+Extrabed+-+1+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A31%3A%22Standard+-+Double%2C+Extrabed+-+1%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22240.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2212.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%222240%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253775----------S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A4%3A%22Test%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2212.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Mumbai', hotel_id='53775', additional_markup='0', cancelltion_policy='', per_night='2240.00', total_price='2240.00', room_type='Standard - Double, Extrabed - 1 (Bed & Breakfast)', room_rate='2240', currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-10-27 12:52:01', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021189', service_date='2020-10-27 00:00:00', service_checkout_date='2020-10-28 00:00:00', city_code='64440', country_code='106', nationality='106', total_adult='2', total_child='0', child_age='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D', leader_name=' ', salutation='Mr', first_name='', last_name='', email='', contact_no='', enquiry_id='406', quotation_status='edited', sequence='2', rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D';
[10/27/2020 12:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1899', service_id='53775', service_type='hotel',service_date='2020-10-27', sequence='2';
[10/27/2020 12:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1899', service_date='2020-10-27';
[10/27/2020 12:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_itinerary SET quote_id='1899', service_id='53775', service_type='hotel',service_date='2020-10-28', sequence='2';
[10/27/2020 12:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO day_wise_quotation_description SET quote_id='1899', service_date='2020-10-28';
[10/27/2020 12:52:01], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='RDTCD0021189' AND quotation_status!='booked';
[10/27/2020 12:52:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE enquiry set status = 'quotation_added' where id = 406;
[10/27/2020 12:52:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],INSERT INTO history_agent_quotation SET q_id='1899', q_name='', service='hotel', agent_id='21', create_date='2020-10-27 12:52:25', q_info='a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1996790400%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2227%2F10%2F2020+--+28%2F10%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253775%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253775%22%3Bs%3A4%3A%22name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%225.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%222240%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A16%3A%22RateGainSupplier%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221044%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A48%3A%22Standard+-+Double%2C+Extrabed+-+1++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A49%3A%22Standard+-+Double%2C+Extrabed+-+1+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A31%3A%22Standard+-+Double%2C+Extrabed+-+1%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22240.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2212.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%222240%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253775----------S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A4%3A%22Test%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2212.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A4%3A%22Test%22%3Bs%3A8%3A%22latitude%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22longitude%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2264440%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%222240%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A16%3A%22RateGainSupplier%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221044%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A48%3A%22Standard+-+Double%2C+Extrabed+-+1++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A49%3A%22Standard+-+Double%2C+Extrabed+-+1+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A31%3A%22Standard+-+Double%2C+Extrabed+-+1%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22240.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2212.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%222240%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253775----------S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A4%3A%22Test%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2212.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D', city_name='Mumbai', hotel_id='53775', additional_markup='0', cancelltion_policy='', per_night='2240.00', total_price='2240.00', room_type='Standard - Double, Extrabed - 1 (Bed & Breakfast)', room_rate='2240', currency='INR', quotation_type='back_end', rate_type='fit', backoffice_user='tfg', modified_by='tfg', modified_date='2020-10-27 12:52:25', status='A', is_visible='1', is_optional='0', unique_id='RDTCD0021189', service_date='2020-10-27 00:00:00', service_checkout_date='2020-10-28 00:00:00', city_code='64440', country_code='106', nationality='106', total_adult='2', total_child='0', child_age='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D', leader_name=' ', salutation='Mr', first_name='', last_name='', email='', contact_no='', enquiry_id='406', quotation_status='edited', sequence='2', rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D';
[10/27/2020 12:52:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation SET q_name = '',email='',contact_no='',unique_id = 'RDTCD0021189',modified_by = 'tfg',modified_date = '2020-10-27 12:52:25',currency ='INR',service_date='2020-10-27 00:00:00',service_checkout_date='2020-10-28 00:00:00',cancelltion_policy='',rate_description_field='a%3A1%3A%7Bs%3A13%3A%22rate_break_up%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7D%7D%7D',sequence='2',agent_id = '21',q_info = 'a%3A21%3A%7Bs%3A11%3A%22arrivaltime%22%3Bi%3A1996790400%3Bs%3A13%3A%22date_selected%22%3Bs%3A24%3A%2227%2F10%2F2020+--+28%2F10%2F2020%22%3Bs%3A15%3A%22selected_nights%22%3Bs%3A1%3A%221%22%3Bs%3A8%3A%22hotel_id%22%3Bs%3A5%3A%2253775%22%3Bs%3A14%3A%22local_hotel_id%22%3Bs%3A5%3A%2253775%22%3Bs%3A4%3A%22name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A14%3A%22propertyRating%22%3Bs%3A3%3A%225.0%22%3Bs%3A10%3A%22hotel_info%22%3Ba%3A1%3A%7Bs%3A11%3A%22localsystem%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A8%3A%22RateInfo%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%222240%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A16%3A%22RateGainSupplier%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221044%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A48%3A%22Standard+-+Double%2C+Extrabed+-+1++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A49%3A%22Standard+-+Double%2C+Extrabed+-+1+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A31%3A%22Standard+-+Double%2C+Extrabed+-+1%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22240.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2212.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%222240%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253775----------S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A4%3A%22Test%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2212.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D%7D%7Ds%3A7%3A%22address%22%3Bs%3A4%3A%22Test%22%3Bs%3A8%3A%22latitude%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22longitude%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22numberOfRooms%22%3Bi%3A1%3Bs%3A11%3A%22totalAdults%22%3Bi%3A2%3Bs%3A13%3A%22totalChildren%22%3Bi%3A0%3Bs%3A13%3A%22selected_city%22%3Bs%3A5%3A%2264440%22%3Bs%3A16%3A%22selected_country%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_nationality%22%3Bs%3A3%3A%22106%22%3Bs%3A20%3A%22selected_country_res%22%3Bs%3A3%3A%22106%22%3Bs%3A16%3A%22shortDescription%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22hotel_image%22%3Bs%3A99%3A%22https%3A%2F%2Falpha.otrams.thefabulousgetaway.com%2Fproject_folder%2Ftfg_project%2Fimages%2Fimagenotavailable.jpg%22%3Bs%3A18%3A%22quotation_selected%22%3Ba%3A17%3A%7Bs%3A10%3A%22room_rates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A31%3A%7Bs%3A11%3A%22ratebreakup%22%3Ba%3A4%3A%7Bs%3A6%3A%22markup%22%3Bi%3A0%3Bs%3A10%3A%22commission%22%3Bi%3A0%3Bs%3A18%3A%22NativeNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A2%3A%7Bs%3A19%3A%22O_nativeNightlyRate%22%3Bi%3A200%3Bs%3A17%3A%22nativeNightlyRate%22%3Bi%3A200%3B%7D%7Ds%3A19%3A%22DisplayNightlyRates%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A1%3A%7Bs%3A18%3A%22displayNightlyRate%22%3Bs%3A4%3A%222240%22%3B%7D%7D%7Ds%3A25%3A%22RateBreakUpDetailsCompact%22%3Ba%3A1%3A%7Bi%3A0%3Ba%3A12%3A%7Bs%3A4%3A%22date%22%3Bs%3A10%3A%222020-10-27%22%3Bs%3A13%3A%22supplier_rate%22%3Bi%3A200%3Bs%3A31%3A%22supplier_rate_in_agent_currency%22%3Bs%3A4%3A%222000%22%3Bs%3A14%3A%22applied_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A21%3A%22applied_markup_amount%22%3Bs%3A1%3A%220%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A10%3A%22agent_rate%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22supplier_commission%22%3Bs%3A1%3A%220%22%3Bs%3A26%3A%22supplier_commission_amount%22%3Bs%3A1%3A%220%22%3Bs%3A6%3A%22profit%22%3Bs%3A2%3A%2224%22%3Bs%3A17%3A%22supplier_currency%22%3Bs%3A3%3A%22AED%22%3Bs%3A14%3A%22agent_currency%22%3Bs%3A3%3A%22INR%22%3B%7D%7Ds%3A16%3A%22number_of_adults%22%3Bs%3A1%3A%222%22%3Bs%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A20%3A%22displayRoomTypeRates%22%3Bs%3A4%3A%222240%22%3Bs%3A19%3A%22nativeRoomTypeRates%22%3Bs%3A3%3A%22200%22%3Bs%3A7%3A%22room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A13%3A%22NumberOfRooms%22%3Bs%3A1%3A%221%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A12%3A%22supplierName%22%3Bs%3A16%3A%22RateGainSupplier%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A14%3A%22room_type_code%22%3Bs%3A4%3A%221044%22%3Bs%3A14%3A%22boardtype_code%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22number_of_child%22%3Bs%3A1%3A%220%22%3Bs%3A10%3A%22meal_basis%22%3Bs%3A15%3A%22Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_type%22%3Bs%3A48%3A%22Standard+-+Double%2C+Extrabed+-+1++Bed+%26+Breakfast%22%3Bs%3A9%3A%22room_name%22%3Bs%3A6%3A%22double%22%3Bs%3A14%3A%22room_type_desc%22%3Bs%3A49%3A%22Standard+-+Double%2C+Extrabed+-+1+%28Bed+%26+Breakfast%29%22%3Bs%3A13%3A%22room_category%22%3Bs%3A31%3A%22Standard+-+Double%2C+Extrabed+-+1%22%3Bs%3A14%3A%22non_refundable%22%3Bs%3A1%3A%220%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22class_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A16%3A%22search_unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A19%3A%22localsystem_room_id%22%3Bs%3A49%3A%222%7E%7E%7E132%7E%7E%7E1044%7E%7E%7E1%7E%7E%7E%7E%7E%7E%7E%7E%7E64440%7E%7E%7E0%7E%7E%7ES000000241%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A11%3A%22tax_details%22%3Ba%3A1%3A%7Bs%3A10%3A%22tax_profit%22%3Ba%3A4%3A%7Bs%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A2%3A%2212%22%3Bs%3A13%3A%22profit_amount%22%3Bs%3A6%3A%22240.00%22%3Bs%3A14%3A%22profit_percent%22%3Bs%3A5%3A%2212.00%22%3B%7D%7D%7D%7Ds%3A9%3A%22available%22%3Bs%3A1%3A%221%22%3Bs%3A15%3A%22displayRoomRate%22%3Bs%3A4%3A%222240%22%3Bs%3A14%3A%22nativeRoomRate%22%3Bs%3A3%3A%22200%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A19%3A%22displayCurrencyCode%22%3Bs%3A3%3A%22INR%22%3Bs%3A18%3A%22nativeCurrencyCode%22%3Bs%3A3%3A%22AED%22%3Bs%3A18%3A%22applied_markup_per%22%3Bs%3A2%3A%2212%22%3Bs%3A18%3A%22applied_multiplier%22%3Bs%3A2%3A%2210%22%3Bs%3A16%3A%22user_description%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22special_remark%22%3Bs%3A0%3A%22%22%3Bs%3A9%3A%22unique_id%22%3Bs%3A0%3A%22%22%3Bs%3A19%3A%22supplier_profile_id%22%3Bs%3A1%3A%221%22%3Bs%3A13%3A%22supplier_data%22%3Ba%3A5%3A%7Bs%3A7%3A%22hotelId%22%3Bs%3A25%3A%2253775----------S000000241%22%3Bs%3A10%3A%22sourceType%22%3Bs%3A11%3A%22localsystem%22%3Bs%3A15%3A%22supp_hotel_name%22%3Bs%3A10%3A%22SassySpoon%22%3Bs%3A18%3A%22supp_hotel_address%22%3Bs%3A4%3A%22Test%22%3Bs%3A10%3A%22supplierId%22%3Bs%3A10%3A%22S000000241%22%3B%7Ds%3A11%3A%22tax_details%22%3Ba%3A4%3A%7Bs%3A9%3A%22input_tax%22%3Ba%3A3%3A%7Bs%3A12%3A%22input_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22input_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A13%3A%22input_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A10%3A%22output_tax%22%3Ba%3A3%3A%7Bs%3A13%3A%22output_tax_id%22%3Bs%3A0%3A%22%22%3Bs%3A15%3A%22output_tax_code%22%3Bs%3A0%3A%22%22%3Bs%3A14%3A%22output_tax_amt%22%3Bs%3A1%3A%220%22%3B%7Ds%3A7%3A%22net_tax%22%3Bs%3A4%3A%220.00%22%3Bs%3A10%3A%22tax_markup%22%3Bs%3A5%3A%2212.00%22%3B%7Ds%3A8%3A%22no_class%22%3Bs%3A1%3A%220%22%3B%7D%7D',service = 'hotel',hotel_id = '53775',city_name ='Mumbai',city_code ='64440',country_code ='106',nationality ='106',total_child ='',child_age ='a%3A1%3A%7Bi%3A0%3Ba%3A0%3A%7B%7D%7D',leader_name =' ',salutation ='Mr',first_name ='',last_name ='',quotation_type ='back_end',total_adult ='2',enquiry_id ='406',total_price ='2240',per_night ='2240',room_type ='Standard - Double, Extrabed - 1 (Bed & Breakfast)',room_rate ='2240' WHERE q_id='1899';
[10/27/2020 12:52:25], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation.php],UPDATE agent_quotation set quotation_status='drafted' WHERE unique_id='RDTCD0021189' AND quotation_status!='booked';
[10/27/2020 12:52:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/controller_quotation_ajax.php],UPDATE agent_quotation SET quotation_status='responded' WHERE unique_id IN ('RDTCD0021189') AND agent_id='21' AND quotation_status!='booked';
[10/27/2020 12:52:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],INSERT INTO hotels SET name = 'The Heritage',rating = '4.0',first_name = '',middle_name = '' ,last_name = '' ,city = '71100',country = '132',location_id = '',area = '',address = 'Colombo' ,phone ='123456789',fax = '',email = '',website = '',latitude = '',longitude = '',driving_direction = '',near_by = '',weekend = '6,7',main_image = '',optional_images = '#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#',main_image_desc = '',optional_images_desc = '',hotelbeds_code ='',status ='A',short_desc = '',long_desc = '',category_id = '1';
[10/27/2020 12:52:51], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-27 12:52:51',`log_type`= 'Hotel Added',`sql_query`= 'INSERT INTO hotels SET name = \&#039;The Heritage\&#039;,rating = \&#039;4.0\&#039;,first_name = \&#039;\&#039;,middle_name = \&#039;\&#039; ,last_name = \&#039;\&#039; ,city = \&#039;71100\&#039;,country = \&#039;132\&#039;,location_id = \&#039;\&#039;,area = \&#039;\&#039;,address = \&#039;Colombo\&#039; ,phone =\&#039;123456789\&#039;,fax = \&#039;\&#039;,email = \&#039;\&#039;,website = \&#039;\&#039;,latitude = \&#039;\&#039;,longitude = \&#039;\&#039;,driving_direction = \&#039;\&#039;,near_by = \&#039;\&#039;,weekend = \&#039;6,7\&#039;,main_image = \&#039;\&#039;,optional_images = \&#039;#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#,#NAN#\&#039;,main_image_desc = \&#039;\&#039;,optional_images_desc = \&#039;\&#039;,hotelbeds_code =\&#039;\&#039;,status =\&#039;A\&#039;,short_desc = \&#039;\&#039;,long_desc = \&#039;\&#039;,category_id = \&#039;1\&#039;',`log_description`= 'Hotel The Heritage Added by User tfg',`ip`= '60.254.5.70';
[10/27/2020 12:54:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_local_supplier.php],INSERT INTO psa_users set updated='2020-10-27 12:54:23' ,lname='' ,fname='RateGainSriLanka' ,mname='' ,email='' ,phone='123' ,time_zone_offset='0' ,enable_dst='' ,id='RateGainSL' ,pass='0187352f9aef2a2d7cf91f0925b04738' ,hash='38179d42fe4c447a154af8a121ac7b72' ,groups='6,7' ,active='Y' ,expiration='' ,branch_id='' ,can_debug='' ,allow_book_under_cancellation='' ,allow_cancellation_after_voucher='' ,all_bookings='' ,user_type='supplier' ,site_id='' ;
[10/27/2020 12:54:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_local_supplier.php],INSERT INTO psa_pass_recover (question, answer, id) VALUES ('', '', '38179d42fe4c447a154af8a121ac7b72');
[10/27/2020 12:54:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_local_supplier.php],INSERT INTO supplier SET SupplierId = 'S000000243
' ,SupplierName = 'RateGainSriLanka' ,accounting_id = '123' ,suppliername_printing = '' ,Address = 'Test' ,CityID = '71100' ,CountryID = '132' ,TelNo = '123' ,Fax = '' ,Mobile = '' ,Email = 'snehal.valanju@qtechsoftware.com' ,reservation_email = 'snehal.valanju@qtechsoftware.com' ,cancellation_email = 'snehal.valanju@qtechsoftware.com' ,modification_email = '' ,technical_email = '' ,Contact1 = '' ,Contact2 = '' ,Remarks = '' ,priority ='',Visible = 'Y',time_zone_offset = '0' ,enable_dst = '' ,username = 'RateGainSL' ,password = 'Test@123' ,EnteredBy = '',EnteredDate = '2020-10-27 12:54:23' ,CurrencyId = '6' ,UpdateFlag = '',OpBal = '' ,marked_up_per = '' ,commission = '' ,commission_type = 'P' ,manual = '1' , allow_edit_hotel = '' ,allow_to_edit_admin_rates = '' ,hotel_supplier = '1' ,tour_supplier = '' ,visa_supplier = '' , supplier_type = 'external' , airline_supplier = '' , is_registered = '1' , send_email = '1' , fit_package_supplier = '' , transfer_supplier = '';
[10/27/2020 12:54:23], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_local_supplier.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-27 12:54:23',`log_type`= 'Offline Supplier',`sql_query`= 'INSERT INTO supplier SET SupplierId = \&#039;S000000243
\&#039; ,SupplierName = \&#039;RateGainSriLanka\&#039; ,accounting_id = \&#039;123\&#039; ,suppliername_printing = \&#039;\&#039; ,Address = \&#039;Test\&#039; ,CityID = \&#039;71100\&#039; ,CountryID = \&#039;132\&#039; ,TelNo = \&#039;123\&#039; ,Fax = \&#039;\&#039; ,Mobile = \&#039;\&#039; ,Email = \&#039;snehal.valanju@qtechsoftware.com\&#039; ,reservation_email = \&#039;snehal.valanju@qtechsoftware.com\&#039; ,cancellation_email = \&#039;snehal.valanju@qtechsoftware.com\&#039; ,modification_email = \&#039;\&#039; ,technical_email = \&#039;\&#039; ,Contact1 = \&#039;\&#039; ,Contact2 = \&#039;\&#039; ,Remarks = \&#039;\&#039; ,priority =\&#039;\&#039;,Visible = \&#039;Y\&#039;,time_zone_offset = \&#039;0\&#039; ,enable_dst = \&#039;\&#039; ,username = \&#039;RateGainSL\&#039; ,password = \&#039;Test@123\&#039; ,EnteredBy = \&#039;\&#039;,EnteredDate = \&#039;2020-10-27 12:54:23\&#039; ,CurrencyId = \&#039;6\&#039; ,UpdateFlag = 0,OpBal = \&#039;\&#039; ,marked_up_per = \&#039;\&#039; ,commission = \&#039;\&#039; ,commission_type = \&#039;P\&#039; ,manual = \&#039;1\&#039; , allow_edit_hotel = \&#039;\&#039; ,allow_to_edit_admin_rates = \&#039;\&#039; ,hotel_supplier = \&#039;1\&#039; ,tour_supplier = \&#039;\&#039; ,visa_supplier = \&#039;\&#039; , supplier_type = \&#039;external\&#039; , airline_supplier = \&#039;\&#039; , is_registered = \&#039;1\&#039; , send_email = \&#039;1\&#039; , fit_package_supplier = \&#039;\&#039; , transfer_supplier = \&#039;\&#039;',`log_description`= 'Offline Supplier Added RateGainSriLanka',`ip`= '60.254.5.70';
[10/27/2020 12:55:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],DELETE from hotel_supplier_mapping WHERE SupplierId= 'S000000243' AND city_code= '71100' AND country_code= '132';
[10/27/2020 12:55:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000243',hotel_id = '53777',city_code = '71100',country_code = '132';
[10/27/2020 12:55:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-27 12:55:19',`log_type`= 'Hotel Supplier Mapping Updated',`sql_query`= ' ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000243\&#039;,hotel_id = \&#039;53777\&#039;,city_code = \&#039;71100\&#039;,country_code = \&#039;132\&#039;',`log_description`= 'Hotel Supplier Mapping Updated for Supplier  : S000000243, City : 71100, Country : 132, Hotels are : 53777',`ip`= '60.254.5.70';
[10/27/2020 12:55:19], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],insert into user_log_link Set `user_logs_id`='3860', `entity`='Suppliers', `value`='S000000243' ;
[10/27/2020 12:56:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotel_supplier_mapping SET channel_manager = 'rategain',ip_addr='60.254.5.70' WHERE SupplierId = 'S000000243' AND hotel_id = '53777' AND status = 'A';
[10/27/2020 12:56:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-27 12:56:03',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;rategain\&#039;,ip_addr=\&#039;60.254.5.70\&#039; WHERE SupplierId = \&#039;S000000243\&#039; AND hotel_id = \&#039;53777\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '60.254.5.70';
[10/27/2020 12:56:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-27 12:56:03',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;rategain\&#039;,ip_addr=\&#039;60.254.5.70\&#039; WHERE SupplierId = \&#039;S000000243\&#039; AND hotel_id = \&#039;53777\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '60.254.5.70';
[10/27/2020 12:56:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3862', `entity`='Hotels', `value`='53777' ;
[10/27/2020 12:56:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3862', `entity`='Suppliers', `value`='S000000243' ;
[10/27/2020 12:56:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotels SET weekend='6,7',infant_lower_limit=NULL,infant_upper_limit=NULL,tiny_child_lower_limit=NULL,tiny_child_upper_limit=NULL,child_lower_limit=NULL,child_upper_limit=NULL,teen_child_lower_limit=NULL,teen_child_upper_limit=NULL,booking_closing_time='',timezone='0' where id= '53777';
[10/27/2020 12:56:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-27 12:56:03',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=NULL,infant_upper_limit=NULL,tiny_child_lower_limit=NULL,tiny_child_upper_limit=NULL,child_lower_limit=NULL,child_upper_limit=NULL,teen_child_lower_limit=NULL,teen_child_upper_limit=NULL,booking_closing_time=\&#039;\&#039;,timezone=\&#039;0\&#039; where id= \&#039;53777\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '60.254.5.70';
[10/27/2020 12:56:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-27 12:56:03',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=NULL,infant_upper_limit=NULL,tiny_child_lower_limit=NULL,tiny_child_upper_limit=NULL,child_lower_limit=NULL,child_upper_limit=NULL,teen_child_lower_limit=NULL,teen_child_upper_limit=NULL,booking_closing_time=\&#039;\&#039;,timezone=\&#039;0\&#039; where id= \&#039;53777\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '60.254.5.70';
[10/27/2020 12:56:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3864', `entity`='Hotels', `value`='53777' ;
[10/27/2020 12:56:03], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='3864', `entity`='Suppliers', `value`='S000000243' ;
[10/27/2020 12:56:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_room_class.php],INSERT INTO room_class SET room_class ='Single, Extrabed - 0 ',supplier_id ='S000000243',min_adult ='1',max_adult ='1',max_capacity ='1',is_child_extrabed ='no',is_adult_extrabed ='no',inventory_class_id  ='132',non_refundable  ='0',status ='A',create_date ='2020-10-27 12:56:45';
[10/27/2020 12:56:46], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_room_class.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-27 12:56:46',`log_type`= 'Room Category',`sql_query`= 'INSERT INTO room_class SET room_class =\&#039;Single, Extrabed - 0 \&#039;,supplier_id =\&#039;S000000243\&#039;,min_adult =\&#039;1\&#039;,max_adult =\&#039;1\&#039;,max_capacity =1,is_child_extrabed =\&#039;no\&#039;,is_adult_extrabed =\&#039;no\&#039;,inventory_class_id  =\&#039;132\&#039;,non_refundable  =\&#039;0\&#039;,status =\&#039;A\&#039;,create_date =\&#039;2020-10-27 12:56:45\&#039;',`log_description`= 'Room Category Added ',`ip`= '60.254.5.70';
[10/27/2020 12:57:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_room_class.php],INSERT INTO room_class SET room_class ='Double, Extrabed - 1 ',supplier_id ='S000000243',min_adult ='2',max_adult ='2',max_capacity ='3',is_child_extrabed ='yes',is_adult_extrabed ='yes',inventory_class_id  ='132',non_refundable  ='0',status ='A',create_date ='2020-10-27 12:57:08';
[10/27/2020 12:57:08], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_room_class.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-10-27 12:57:08',`log_type`= 'Room Category',`sql_query`= 'INSERT INTO room_class SET room_class =\&#039;Double, Extrabed - 1 \&#039;,supplier_id =\&#039;S000000243\&#039;,min_adult =\&#039;2\&#039;,max_adult =\&#039;2\&#039;,max_capacity =3,is_child_extrabed =\&#039;yes\&#039;,is_adult_extrabed =\&#039;yes\&#039;,inventory_class_id  =\&#039;132\&#039;,non_refundable  =\&#039;0\&#039;,status =\&#039;A\&#039;,create_date =\&#039;2020-10-27 12:57:08\&#039;',`log_description`= 'Room Category Added ',`ip`= '60.254.5.70';
[10/27/2020 12:57:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='53777' AND supplier_id='S000000243';
[10/27/2020 12:57:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53777', supplier_id='S000000243', class_id='1049', is_channel_manager_mapped = '0';
[10/27/2020 12:57:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53777', supplier_id='S000000243', class_id='1048', is_channel_manager_mapped = '0';
[10/27/2020 12:57:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],DELETE FROM hotel_room_class_mapping WHERE hotel_id='53777' AND supplier_id='S000000243';
[10/27/2020 12:57:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53777', supplier_id='S000000243', class_id='1049', is_channel_manager_mapped = '1';
[10/27/2020 12:57:42], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/local_system.php],INSERT into hotel_room_class_mapping SET hotel_id='53777', supplier_id='S000000243', class_id='1048', is_channel_manager_mapped = '1';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-27',to_date='2020-10-27',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-28',to_date='2020-10-28',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-29',to_date='2020-10-29',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-30',to_date='2020-10-30',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-10-31',to_date='2020-10-31',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-01',to_date='2020-11-01',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-02',to_date='2020-11-02',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-03',to_date='2020-11-03',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-04',to_date='2020-11-04',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-05',to_date='2020-11-05',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-06',to_date='2020-11-06',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-07',to_date='2020-11-07',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-08',to_date='2020-11-08',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-09',to_date='2020-11-09',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-10',to_date='2020-11-10',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-11',to_date='2020-11-11',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-12',to_date='2020-11-12',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-13',to_date='2020-11-13',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-14',to_date='2020-11-14',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-15',to_date='2020-11-15',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-16',to_date='2020-11-16',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-17',to_date='2020-11-17',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-18',to_date='2020-11-18',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-19',to_date='2020-11-19',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-20',to_date='2020-11-20',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-21',to_date='2020-11-21',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-22',to_date='2020-11-22',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-23',to_date='2020-11-23',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-24',to_date='2020-11-24',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-25',to_date='2020-11-25',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-26',to_date='2020-11-26',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-27',to_date='2020-11-27',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-28',to_date='2020-11-28',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-29',to_date='2020-11-29',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-11-30',to_date='2020-11-30',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-01',to_date='2020-12-01',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-02',to_date='2020-12-02',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-03',to_date='2020-12-03',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-04',to_date='2020-12-04',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-05',to_date='2020-12-05',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-06',to_date='2020-12-06',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-07',to_date='2020-12-07',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-08',to_date='2020-12-08',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-09',to_date='2020-12-09',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-10',to_date='2020-12-10',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-11',to_date='2020-12-11',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-12',to_date='2020-12-12',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-13',to_date='2020-12-13',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-14',to_date='2020-12-14',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-15',to_date='2020-12-15',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-16',to_date='2020-12-16',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-17',to_date='2020-12-17',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-18',to_date='2020-12-18',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-19',to_date='2020-12-19',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-20',to_date='2020-12-20',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:44], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-21',to_date='2020-12-21',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-22',to_date='2020-12-22',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-23',to_date='2020-12-23',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-24',to_date='2020-12-24',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-25',to_date='2020-12-25',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-26',to_date='2020-12-26',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-27',to_date='2020-12-27',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-28',to_date='2020-12-28',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-29',to_date='2020-12-29',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-30',to_date='2020-12-30',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO child_extrabed_rates SET from_date='2020-12-31',to_date='2020-12-31',supplier_id='S000000243',hotel_id='53777',room_basis_id='1',room_class_id='1049',child_no='',infant_wtc_rate=NULL,infant_wtc_weekend_rate=NULL,infant_display= 'no',tiny_child_wtb_rate=NULL,tiny_child_wtb_weekend_rate=NULL,tiny_display= 'no',child_wtb_rate=NULL,child_wtb_weekend_rate=NULL,child_display= 'no',teen_child_wtb_rate=NULL,teen_child_wtb_weekend_rate=NULL,teen_display= 'no',adult_wb_rate= '20',adult_wb_weekend_rate= '20',adult_display= 'yes';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-27 12:58:45',`log_type`= 'ExtraBed Rates',`sql_query`= '',`log_description`= 'Extrabed Rates For The Heritage added successfully. Room Category :- Standard - Double, Extrabed - 1(Bed & Breakfast) From :- 27-10-2020 To :- 31-12-2020',`ip`= '60.254.5.70',`username`= 'tfg',`user_id`= 'S000000243';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3867', `entity`='Hotels', `value`='53777' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3867', `entity`='Suppliers', `value`='S000000243' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3867', `entity`='Inventory', `value`='132' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3867', `entity`='Room', `value`='1049' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO hotel_supplier_currency_mapping SET SupplierId ='S000000243',hotel_id ='53777',currency_code ='USD',city_code ='71100',country_code ='132',created_datetime ='2020-10-27 12:58:45',created_by ='#supplier#',ip_addr ='60.254.5.70';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('53777@S000000243@2020-10-27@2020-10-27@@1049@1@1@@@0','27-10-2020~27-10-2020','53777','S000000243','2020-10-27','2020-10-27','1049','1','60.254.5.70','0','0','1960e8d5c48ed2ba3fae99778464a54f','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','1960e8d5c48ed2ba3fae99778464a54f','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0','');
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-27 12:58:45',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For The Heritage Rate:- 100 Room Category :- Standard - Double, Extrabed - 1 (Bed & Breakfast) Market :- All Market From:- 27-10-2020 To:- 31-12-2020',`ip`= '60.254.5.70',`username`= 'tfg',`user_id`= 'S000000243';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3868', `entity`='Hotels', `value`='53777' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3868', `entity`='Suppliers', `value`='S000000243' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3868', `entity`='Inventory', `value`='132' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3868', `entity`='Room', `value`='1049' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3868', `entity`='Market', `value`='1' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-27 12:58:45',`log_type`= 'Rates',`sql_query`= '',`log_description`= 'Inserted Rates For The Heritage Rate:- 50 Room Category :- Standard - Single, Extrabed - 0 (Bed & Breakfast) Market :- All Market From:- 27-10-2020 To:- 31-12-2020',`ip`= '60.254.5.70',`username`= 'tfg',`user_id`= 'S000000243';
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3869', `entity`='Hotels', `value`='53777' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3869', `entity`='Suppliers', `value`='S000000243' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3869', `entity`='Inventory', `value`='132' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3869', `entity`='Room', `value`='1048' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3869', `entity`='Market', `value`='1' ;
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],INSERT INTO room_rates (room_rate_code,rate_group,hotel_id,supplier_id,date_from,date_to,room_class,room_basis,ip_addr,room_type,view_basis,edit_time_stamp,weekend,rate_profile,entered_by,inventory_class_id,status,weekday_rate,weekend_rate,currency,minstay,availability,time_limit,checkin_block_for,exclude_countries,exclude_residence,stop_sale,time_stamp,created_datetime,create_date,created_by,changed_by,modify_date,modified_datetime,modified_by,consumed_inventory,stay_note) values ('53777@S000000243@2020-10-28@2020-10-28@@1049@1@1@@@0','28-10-2020~28-10-2020','53777','S000000243','2020-10-28','2020-10-28','1049','1','60.254.5.70','0','0','f8110f45bdda7e3106fe9b8ebcd193cb','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','f8110f45bdda7e3106fe9b8ebcd193cb','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-10-29@2020-10-29@@1049@1@1@@@0','29-10-2020~29-10-2020','53777','S000000243','2020-10-29','2020-10-29','1049','1','60.254.5.70','0','0','3e43cd891e24fd76fdf5e56d675fcaf0','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','3e43cd891e24fd76fdf5e56d675fcaf0','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-10-30@2020-10-30@@1049@1@1@@@0','30-10-2020~30-10-2020','53777','S000000243','2020-10-30','2020-10-30','1049','1','60.254.5.70','0','0','c468cfe6115c004c3ea91d9445af78dd','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','c468cfe6115c004c3ea91d9445af78dd','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-10-31@2020-10-31@@1049@1@1@@@0','31-10-2020~31-10-2020','53777','S000000243','2020-10-31','2020-10-31','1049','1','60.254.5.70','0','0','f3bdd95dc6517d18e0ced6f0f6080cfd','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','f3bdd95dc6517d18e0ced6f0f6080cfd','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-01@2020-11-01@@1049@1@1@@@0','01-11-2020~01-11-2020','53777','S000000243','2020-11-01','2020-11-01','1049','1','60.254.5.70','0','0','dc187e77a6796d5bce9372af423c3186','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','dc187e77a6796d5bce9372af423c3186','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-02@2020-11-02@@1049@1@1@@@0','02-11-2020~02-11-2020','53777','S000000243','2020-11-02','2020-11-02','1049','1','60.254.5.70','0','0','f167c55a01d64c7fc84941b202cf26f1','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','f167c55a01d64c7fc84941b202cf26f1','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-03@2020-11-03@@1049@1@1@@@0','03-11-2020~03-11-2020','53777','S000000243','2020-11-03','2020-11-03','1049','1','60.254.5.70','0','0','510a78a46998c5ad85c09d7637db65a7','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','510a78a46998c5ad85c09d7637db65a7','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-04@2020-11-04@@1049@1@1@@@0','04-11-2020~04-11-2020','53777','S000000243','2020-11-04','2020-11-04','1049','1','60.254.5.70','0','0','794bc38c5b623474b9fd706d1ff2cc32','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','794bc38c5b623474b9fd706d1ff2cc32','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-05@2020-11-05@@1049@1@1@@@0','05-11-2020~05-11-2020','53777','S000000243','2020-11-05','2020-11-05','1049','1','60.254.5.70','0','0','93065e746bbf7f4345b072248b848afc','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','93065e746bbf7f4345b072248b848afc','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-06@2020-11-06@@1049@1@1@@@0','06-11-2020~06-11-2020','53777','S000000243','2020-11-06','2020-11-06','1049','1','60.254.5.70','0','0','eac5829389e0c995bdcb2089248edf46','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','eac5829389e0c995bdcb2089248edf46','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-07@2020-11-07@@1049@1@1@@@0','07-11-2020~07-11-2020','53777','S000000243','2020-11-07','2020-11-07','1049','1','60.254.5.70','0','0','894309b0b3cd6543c8c77fa361a7b105','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','894309b0b3cd6543c8c77fa361a7b105','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-08@2020-11-08@@1049@1@1@@@0','08-11-2020~08-11-2020','53777','S000000243','2020-11-08','2020-11-08','1049','1','60.254.5.70','0','0','5a28fd4dd83a3d059f7958a9289bbd01','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','5a28fd4dd83a3d059f7958a9289bbd01','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-09@2020-11-09@@1049@1@1@@@0','09-11-2020~09-11-2020','53777','S000000243','2020-11-09','2020-11-09','1049','1','60.254.5.70','0','0','f5d8284bb21d5f8597b8ef652a4c2b79','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','f5d8284bb21d5f8597b8ef652a4c2b79','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-10@2020-11-10@@1049@1@1@@@0','10-11-2020~10-11-2020','53777','S000000243','2020-11-10','2020-11-10','1049','1','60.254.5.70','0','0','3994cac726048584cacdc58347e9d19b','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','3994cac726048584cacdc58347e9d19b','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-11@2020-11-11@@1049@1@1@@@0','11-11-2020~11-11-2020','53777','S000000243','2020-11-11','2020-11-11','1049','1','60.254.5.70','0','0','d14273468f497de5ae61355d7d6e9424','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','d14273468f497de5ae61355d7d6e9424','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-12@2020-11-12@@1049@1@1@@@0','12-11-2020~12-11-2020','53777','S000000243','2020-11-12','2020-11-12','1049','1','60.254.5.70','0','0','4e1a9095efeca49eb481d7ebc8433205','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','4e1a9095efeca49eb481d7ebc8433205','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-13@2020-11-13@@1049@1@1@@@0','13-11-2020~13-11-2020','53777','S000000243','2020-11-13','2020-11-13','1049','1','60.254.5.70','0','0','7749e9428b4bce03ca7f7d915d6f2ba1','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','7749e9428b4bce03ca7f7d915d6f2ba1','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-14@2020-11-14@@1049@1@1@@@0','14-11-2020~14-11-2020','53777','S000000243','2020-11-14','2020-11-14','1049','1','60.254.5.70','0','0','166117194f0a34d014d5368cb89a1c85','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','166117194f0a34d014d5368cb89a1c85','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-15@2020-11-15@@1049@1@1@@@0','15-11-2020~15-11-2020','53777','S000000243','2020-11-15','2020-11-15','1049','1','60.254.5.70','0','0','ed6e950e6338359f7abb9ae0a02e12dd','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','ed6e950e6338359f7abb9ae0a02e12dd','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-16@2020-11-16@@1049@1@1@@@0','16-11-2020~16-11-2020','53777','S000000243','2020-11-16','2020-11-16','1049','1','60.254.5.70','0','0','9ef74eb88ba2d480f5fb07a6ed27ae68','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','9ef74eb88ba2d480f5fb07a6ed27ae68','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-17@2020-11-17@@1049@1@1@@@0','17-11-2020~17-11-2020','53777','S000000243','2020-11-17','2020-11-17','1049','1','60.254.5.70','0','0','3285cbc8a229d3dfaa248f5f85c8b55c','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','3285cbc8a229d3dfaa248f5f85c8b55c','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-18@2020-11-18@@1049@1@1@@@0','18-11-2020~18-11-2020','53777','S000000243','2020-11-18','2020-11-18','1049','1','60.254.5.70','0','0','ac24e7329a275755eb9ac7879b398e1a','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','ac24e7329a275755eb9ac7879b398e1a','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-19@2020-11-19@@1049@1@1@@@0','19-11-2020~19-11-2020','53777','S000000243','2020-11-19','2020-11-19','1049','1','60.254.5.70','0','0','0bb55f89423bccf4a45a3f448a63ddc0','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','0bb55f89423bccf4a45a3f448a63ddc0','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-20@2020-11-20@@1049@1@1@@@0','20-11-2020~20-11-2020','53777','S000000243','2020-11-20','2020-11-20','1049','1','60.254.5.70','0','0','ac26e6a76536f215c6c476581a62bf7d','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','ac26e6a76536f215c6c476581a62bf7d','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-21@2020-11-21@@1049@1@1@@@0','21-11-2020~21-11-2020','53777','S000000243','2020-11-21','2020-11-21','1049','1','60.254.5.70','0','0','b184a0732526d3f94e8f60caa1b90c1f','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','b184a0732526d3f94e8f60caa1b90c1f','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-22@2020-11-22@@1049@1@1@@@0','22-11-2020~22-11-2020','53777','S000000243','2020-11-22','2020-11-22','1049','1','60.254.5.70','0','0','efa861a83591831eebd021ef1131bde5','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','efa861a83591831eebd021ef1131bde5','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-23@2020-11-23@@1049@1@1@@@0','23-11-2020~23-11-2020','53777','S000000243','2020-11-23','2020-11-23','1049','1','60.254.5.70','0','0','4f1a8acd8a18231d5747481ec93a5ba8','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','4f1a8acd8a18231d5747481ec93a5ba8','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-24@2020-11-24@@1049@1@1@@@0','24-11-2020~24-11-2020','53777','S000000243','2020-11-24','2020-11-24','1049','1','60.254.5.70','0','0','cabf51be76396748a79b60c5bb48e414','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','cabf51be76396748a79b60c5bb48e414','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-25@2020-11-25@@1049@1@1@@@0','25-11-2020~25-11-2020','53777','S000000243','2020-11-25','2020-11-25','1049','1','60.254.5.70','0','0','69a6b6bb2f5b09c22611d899afa9e50a','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','69a6b6bb2f5b09c22611d899afa9e50a','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-26@2020-11-26@@1049@1@1@@@0','26-11-2020~26-11-2020','53777','S000000243','2020-11-26','2020-11-26','1049','1','60.254.5.70','0','0','1bbcbc6dc08ef36edcef5950095e4292','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','1bbcbc6dc08ef36edcef5950095e4292','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-27@2020-11-27@@1049@1@1@@@0','27-11-2020~27-11-2020','53777','S000000243','2020-11-27','2020-11-27','1049','1','60.254.5.70','0','0','e759116b3ecda77a6f8abecf0cff55f2','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','e759116b3ecda77a6f8abecf0cff55f2','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-28@2020-11-28@@1049@1@1@@@0','28-11-2020~28-11-2020','53777','S000000243','2020-11-28','2020-11-28','1049','1','60.254.5.70','0','0','6edb956ef5ad71adc11f19c22bf1b718','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','6edb956ef5ad71adc11f19c22bf1b718','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-29@2020-11-29@@1049@1@1@@@0','29-11-2020~29-11-2020','53777','S000000243','2020-11-29','2020-11-29','1049','1','60.254.5.70','0','0','2b6db15ea187cfbb5a5f35fd543913d3','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','2b6db15ea187cfbb5a5f35fd543913d3','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-30@2020-11-30@@1049@1@1@@@0','30-11-2020~30-11-2020','53777','S000000243','2020-11-30','2020-11-30','1049','1','60.254.5.70','0','0','6b4f4fc384d53ac8679f1ee6e60caf44','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','6b4f4fc384d53ac8679f1ee6e60caf44','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-01@2020-12-01@@1049@1@1@@@0','01-12-2020~01-12-2020','53777','S000000243','2020-12-01','2020-12-01','1049','1','60.254.5.70','0','0','a7305fdde399218c556f5e212ef18db3','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','a7305fdde399218c556f5e212ef18db3','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-02@2020-12-02@@1049@1@1@@@0','02-12-2020~02-12-2020','53777','S000000243','2020-12-02','2020-12-02','1049','1','60.254.5.70','0','0','be28dedb4730c1c0292963bb74c41dbd','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','be28dedb4730c1c0292963bb74c41dbd','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-03@2020-12-03@@1049@1@1@@@0','03-12-2020~03-12-2020','53777','S000000243','2020-12-03','2020-12-03','1049','1','60.254.5.70','0','0','93871c2d2e196bf4af61c9908d340b11','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','93871c2d2e196bf4af61c9908d340b11','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-04@2020-12-04@@1049@1@1@@@0','04-12-2020~04-12-2020','53777','S000000243','2020-12-04','2020-12-04','1049','1','60.254.5.70','0','0','3ec093278871a2784144d72c48c5ad17','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','3ec093278871a2784144d72c48c5ad17','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-05@2020-12-05@@1049@1@1@@@0','05-12-2020~05-12-2020','53777','S000000243','2020-12-05','2020-12-05','1049','1','60.254.5.70','0','0','ccd01d9fab42949a03e79dd640116caf','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','ccd01d9fab42949a03e79dd640116caf','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-06@2020-12-06@@1049@1@1@@@0','06-12-2020~06-12-2020','53777','S000000243','2020-12-06','2020-12-06','1049','1','60.254.5.70','0','0','f29d02628d1bdc233fdcb4c4a9c67b8e','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','f29d02628d1bdc233fdcb4c4a9c67b8e','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-07@2020-12-07@@1049@1@1@@@0','07-12-2020~07-12-2020','53777','S000000243','2020-12-07','2020-12-07','1049','1','60.254.5.70','0','0','8f2e64d1382620fa1d71044223061b63','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','8f2e64d1382620fa1d71044223061b63','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-08@2020-12-08@@1049@1@1@@@0','08-12-2020~08-12-2020','53777','S000000243','2020-12-08','2020-12-08','1049','1','60.254.5.70','0','0','685267d1a66de41e05182eff8e0df8fb','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','685267d1a66de41e05182eff8e0df8fb','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-09@2020-12-09@@1049@1@1@@@0','09-12-2020~09-12-2020','53777','S000000243','2020-12-09','2020-12-09','1049','1','60.254.5.70','0','0','e4e59ce7a010af04a3d81d41da1f25ce','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','e4e59ce7a010af04a3d81d41da1f25ce','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-10@2020-12-10@@1049@1@1@@@0','10-12-2020~10-12-2020','53777','S000000243','2020-12-10','2020-12-10','1049','1','60.254.5.70','0','0','ee1c7dfd39bf8a86bf3aa9d245867b49','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','ee1c7dfd39bf8a86bf3aa9d245867b49','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-11@2020-12-11@@1049@1@1@@@0','11-12-2020~11-12-2020','53777','S000000243','2020-12-11','2020-12-11','1049','1','60.254.5.70','0','0','a86e03bd1494bdf505a789a55e7481a2','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','a86e03bd1494bdf505a789a55e7481a2','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-12@2020-12-12@@1049@1@1@@@0','12-12-2020~12-12-2020','53777','S000000243','2020-12-12','2020-12-12','1049','1','60.254.5.70','0','0','664029ad261047ec9150082e055e6d9c','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','664029ad261047ec9150082e055e6d9c','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-13@2020-12-13@@1049@1@1@@@0','13-12-2020~13-12-2020','53777','S000000243','2020-12-13','2020-12-13','1049','1','60.254.5.70','0','0','e4840e9f2967dfe6cb1dc28bb55a5e17','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','e4840e9f2967dfe6cb1dc28bb55a5e17','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-14@2020-12-14@@1049@1@1@@@0','14-12-2020~14-12-2020','53777','S000000243','2020-12-14','2020-12-14','1049','1','60.254.5.70','0','0','74cb2bdd8d5510ee2f25d785097990b5','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','74cb2bdd8d5510ee2f25d785097990b5','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-15@2020-12-15@@1049@1@1@@@0','15-12-2020~15-12-2020','53777','S000000243','2020-12-15','2020-12-15','1049','1','60.254.5.70','0','0','ee0fad3d4357f12ccdaa49964e32b806','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','ee0fad3d4357f12ccdaa49964e32b806','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-16@2020-12-16@@1049@1@1@@@0','16-12-2020~16-12-2020','53777','S000000243','2020-12-16','2020-12-16','1049','1','60.254.5.70','0','0','0df9aebbc6c73f01a61af208db250673','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','0df9aebbc6c73f01a61af208db250673','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-17@2020-12-17@@1049@1@1@@@0','17-12-2020~17-12-2020','53777','S000000243','2020-12-17','2020-12-17','1049','1','60.254.5.70','0','0','ea062d80da9074c4e456268e6663ba41','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','ea062d80da9074c4e456268e6663ba41','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-18@2020-12-18@@1049@1@1@@@0','18-12-2020~18-12-2020','53777','S000000243','2020-12-18','2020-12-18','1049','1','60.254.5.70','0','0','082b76b37b3c161ee45650e04607a880','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','082b76b37b3c161ee45650e04607a880','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-19@2020-12-19@@1049@1@1@@@0','19-12-2020~19-12-2020','53777','S000000243','2020-12-19','2020-12-19','1049','1','60.254.5.70','0','0','8ed4790ff3af7c64e716533fbbe615e3','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','8ed4790ff3af7c64e716533fbbe615e3','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-20@2020-12-20@@1049@1@1@@@0','20-12-2020~20-12-2020','53777','S000000243','2020-12-20','2020-12-20','1049','1','60.254.5.70','0','0','a5a42a7086e75b2b7a32a1efc8decea3','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','a5a42a7086e75b2b7a32a1efc8decea3','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-21@2020-12-21@@1049@1@1@@@0','21-12-2020~21-12-2020','53777','S000000243','2020-12-21','2020-12-21','1049','1','60.254.5.70','0','0','e9aeaaf243a7c29ffed9e3f5952e9625','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','e9aeaaf243a7c29ffed9e3f5952e9625','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-22@2020-12-22@@1049@1@1@@@0','22-12-2020~22-12-2020','53777','S000000243','2020-12-22','2020-12-22','1049','1','60.254.5.70','0','0','934915039be9cfb23487ca155830e3e8','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','934915039be9cfb23487ca155830e3e8','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-23@2020-12-23@@1049@1@1@@@0','23-12-2020~23-12-2020','53777','S000000243','2020-12-23','2020-12-23','1049','1','60.254.5.70','0','0','f525abcc902a80ee32bf769ebb73d781','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','f525abcc902a80ee32bf769ebb73d781','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-24@2020-12-24@@1049@1@1@@@0','24-12-2020~24-12-2020','53777','S000000243','2020-12-24','2020-12-24','1049','1','60.254.5.70','0','0','ebb82f538940f587ccb11ef380d7bb07','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','ebb82f538940f587ccb11ef380d7bb07','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-25@2020-12-25@@1049@1@1@@@0','25-12-2020~25-12-2020','53777','S000000243','2020-12-25','2020-12-25','1049','1','60.254.5.70','0','0','832eef53ffb2cb73a89770f867ef9471','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','832eef53ffb2cb73a89770f867ef9471','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-26@2020-12-26@@1049@1@1@@@0','26-12-2020~26-12-2020','53777','S000000243','2020-12-26','2020-12-26','1049','1','60.254.5.70','0','0','130257776ad3745906cf075dddb6a0c0','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','130257776ad3745906cf075dddb6a0c0','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-27@2020-12-27@@1049@1@1@@@0','27-12-2020~27-12-2020','53777','S000000243','2020-12-27','2020-12-27','1049','1','60.254.5.70','0','0','1a0b67bf83f76a0d51f01689b36c8478','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','1a0b67bf83f76a0d51f01689b36c8478','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-28@2020-12-28@@1049@1@1@@@0','28-12-2020~28-12-2020','53777','S000000243','2020-12-28','2020-12-28','1049','1','60.254.5.70','0','0','6f2e5091bb2c98a83125a4e6443c646c','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','6f2e5091bb2c98a83125a4e6443c646c','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-29@2020-12-29@@1049@1@1@@@0','29-12-2020~29-12-2020','53777','S000000243','2020-12-29','2020-12-29','1049','1','60.254.5.70','0','0','384d3dc52d54f69b70c3bedd24958317','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','384d3dc52d54f69b70c3bedd24958317','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-30@2020-12-30@@1049@1@1@@@0','30-12-2020~30-12-2020','53777','S000000243','2020-12-30','2020-12-30','1049','1','60.254.5.70','0','0','b7fa9ff4effbbda15c028a3c850f052e','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','b7fa9ff4effbbda15c028a3c850f052e','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-31@2020-12-31@@1049@1@1@@@0','31-12-2020~31-12-2020','53777','S000000243','2020-12-31','2020-12-31','1049','1','60.254.5.70','0','0','038eecc2b955c5b88c64cc14fb03782b','Sa,Su','1','Supplier','132','A','100','100','USD','1','0','0','0','','','0','038eecc2b955c5b88c64cc14fb03782b','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-10-27@2020-10-27@@1048@1@1@@@0','27-10-2020~27-10-2020','53777','S000000243','2020-10-27','2020-10-27','1048','1','60.254.5.70','0','0','b069e57b1ef6a6ed991023b4e426cb3e','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','b069e57b1ef6a6ed991023b4e426cb3e','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-10-28@2020-10-28@@1048@1@1@@@0','28-10-2020~28-10-2020','53777','S000000243','2020-10-28','2020-10-28','1048','1','60.254.5.70','0','0','a0cb8b475815b94b6cf7369a7fbb1442','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','a0cb8b475815b94b6cf7369a7fbb1442','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-10-29@2020-10-29@@1048@1@1@@@0','29-10-2020~29-10-2020','53777','S000000243','2020-10-29','2020-10-29','1048','1','60.254.5.70','0','0','4b79fbaa0e82fb7288464136d71258c6','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','4b79fbaa0e82fb7288464136d71258c6','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-10-30@2020-10-30@@1048@1@1@@@0','30-10-2020~30-10-2020','53777','S000000243','2020-10-30','2020-10-30','1048','1','60.254.5.70','0','0','48041150e4ec2dedf4c5152992e962ff','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','48041150e4ec2dedf4c5152992e962ff','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-10-31@2020-10-31@@1048@1@1@@@0','31-10-2020~31-10-2020','53777','S000000243','2020-10-31','2020-10-31','1048','1','60.254.5.70','0','0','4e08075ee9fa7a260d40003689299396','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','4e08075ee9fa7a260d40003689299396','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-01@2020-11-01@@1048@1@1@@@0','01-11-2020~01-11-2020','53777','S000000243','2020-11-01','2020-11-01','1048','1','60.254.5.70','0','0','e14b011bccac672f518829413b3769fb','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','e14b011bccac672f518829413b3769fb','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-02@2020-11-02@@1048@1@1@@@0','02-11-2020~02-11-2020','53777','S000000243','2020-11-02','2020-11-02','1048','1','60.254.5.70','0','0','3c16a59ed519cf395643dac1c4428175','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','3c16a59ed519cf395643dac1c4428175','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-03@2020-11-03@@1048@1@1@@@0','03-11-2020~03-11-2020','53777','S000000243','2020-11-03','2020-11-03','1048','1','60.254.5.70','0','0','5a4f16015366eca132cd315efb30cb98','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','5a4f16015366eca132cd315efb30cb98','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-04@2020-11-04@@1048@1@1@@@0','04-11-2020~04-11-2020','53777','S000000243','2020-11-04','2020-11-04','1048','1','60.254.5.70','0','0','6061a428b58e66a601f74c353a5dab46','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','6061a428b58e66a601f74c353a5dab46','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-05@2020-11-05@@1048@1@1@@@0','05-11-2020~05-11-2020','53777','S000000243','2020-11-05','2020-11-05','1048','1','60.254.5.70','0','0','9d3e3ea51d137cb37d2edf07b55b9080','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','9d3e3ea51d137cb37d2edf07b55b9080','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-06@2020-11-06@@1048@1@1@@@0','06-11-2020~06-11-2020','53777','S000000243','2020-11-06','2020-11-06','1048','1','60.254.5.70','0','0','7e95f957cdf6b0e88fb919a74a11e932','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','7e95f957cdf6b0e88fb919a74a11e932','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-07@2020-11-07@@1048@1@1@@@0','07-11-2020~07-11-2020','53777','S000000243','2020-11-07','2020-11-07','1048','1','60.254.5.70','0','0','ea89b644efc8136dd4021ba0ef3695d2','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','ea89b644efc8136dd4021ba0ef3695d2','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-08@2020-11-08@@1048@1@1@@@0','08-11-2020~08-11-2020','53777','S000000243','2020-11-08','2020-11-08','1048','1','60.254.5.70','0','0','a00cc5c7ab8b4531b6ec288e7dc0f2d3','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','a00cc5c7ab8b4531b6ec288e7dc0f2d3','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-09@2020-11-09@@1048@1@1@@@0','09-11-2020~09-11-2020','53777','S000000243','2020-11-09','2020-11-09','1048','1','60.254.5.70','0','0','af167bf388ad14e69d6b88bb52c9b29a','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','af167bf388ad14e69d6b88bb52c9b29a','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-10@2020-11-10@@1048@1@1@@@0','10-11-2020~10-11-2020','53777','S000000243','2020-11-10','2020-11-10','1048','1','60.254.5.70','0','0','07cea7c9076be269bd7930e7cba5f859','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','07cea7c9076be269bd7930e7cba5f859','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-11@2020-11-11@@1048@1@1@@@0','11-11-2020~11-11-2020','53777','S000000243','2020-11-11','2020-11-11','1048','1','60.254.5.70','0','0','2335198f00e989bc0fe333c7a66f8983','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','2335198f00e989bc0fe333c7a66f8983','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-12@2020-11-12@@1048@1@1@@@0','12-11-2020~12-11-2020','53777','S000000243','2020-11-12','2020-11-12','1048','1','60.254.5.70','0','0','16d25968fa019afd19bff68b19f95fbf','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','16d25968fa019afd19bff68b19f95fbf','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-13@2020-11-13@@1048@1@1@@@0','13-11-2020~13-11-2020','53777','S000000243','2020-11-13','2020-11-13','1048','1','60.254.5.70','0','0','71cf5c3b56ad7cf3f059fd64e43077aa','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','71cf5c3b56ad7cf3f059fd64e43077aa','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-14@2020-11-14@@1048@1@1@@@0','14-11-2020~14-11-2020','53777','S000000243','2020-11-14','2020-11-14','1048','1','60.254.5.70','0','0','719158841b7deecbcd127bc669cff761','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','719158841b7deecbcd127bc669cff761','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-15@2020-11-15@@1048@1@1@@@0','15-11-2020~15-11-2020','53777','S000000243','2020-11-15','2020-11-15','1048','1','60.254.5.70','0','0','74304e5dfbe8d2539207f2116f49f1fb','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','74304e5dfbe8d2539207f2116f49f1fb','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-16@2020-11-16@@1048@1@1@@@0','16-11-2020~16-11-2020','53777','S000000243','2020-11-16','2020-11-16','1048','1','60.254.5.70','0','0','d69db828d0c2db84a37345d6d9e89acf','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','d69db828d0c2db84a37345d6d9e89acf','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-17@2020-11-17@@1048@1@1@@@0','17-11-2020~17-11-2020','53777','S000000243','2020-11-17','2020-11-17','1048','1','60.254.5.70','0','0','2b902381b1d6604582dcd51c1315a565','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','2b902381b1d6604582dcd51c1315a565','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-18@2020-11-18@@1048@1@1@@@0','18-11-2020~18-11-2020','53777','S000000243','2020-11-18','2020-11-18','1048','1','60.254.5.70','0','0','fd503b5862a75da2da2c3c78e40f642b','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','fd503b5862a75da2da2c3c78e40f642b','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-19@2020-11-19@@1048@1@1@@@0','19-11-2020~19-11-2020','53777','S000000243','2020-11-19','2020-11-19','1048','1','60.254.5.70','0','0','f01be0b836cf37bda6286a58da6a33ba','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','f01be0b836cf37bda6286a58da6a33ba','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-20@2020-11-20@@1048@1@1@@@0','20-11-2020~20-11-2020','53777','S000000243','2020-11-20','2020-11-20','1048','1','60.254.5.70','0','0','170cfda14bb57e228ce1db7975d68e6d','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','170cfda14bb57e228ce1db7975d68e6d','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-21@2020-11-21@@1048@1@1@@@0','21-11-2020~21-11-2020','53777','S000000243','2020-11-21','2020-11-21','1048','1','60.254.5.70','0','0','36902d48296d9b59486ee4e1d750f5a9','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','36902d48296d9b59486ee4e1d750f5a9','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-22@2020-11-22@@1048@1@1@@@0','22-11-2020~22-11-2020','53777','S000000243','2020-11-22','2020-11-22','1048','1','60.254.5.70','0','0','750e2e9cec7afe16b4934c91f5dd68c2','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','750e2e9cec7afe16b4934c91f5dd68c2','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-23@2020-11-23@@1048@1@1@@@0','23-11-2020~23-11-2020','53777','S000000243','2020-11-23','2020-11-23','1048','1','60.254.5.70','0','0','338a147de053441097fe618ebba370c0','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','338a147de053441097fe618ebba370c0','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-24@2020-11-24@@1048@1@1@@@0','24-11-2020~24-11-2020','53777','S000000243','2020-11-24','2020-11-24','1048','1','60.254.5.70','0','0','1550dc0337079118cd27a42f676507fd','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','1550dc0337079118cd27a42f676507fd','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-25@2020-11-25@@1048@1@1@@@0','25-11-2020~25-11-2020','53777','S000000243','2020-11-25','2020-11-25','1048','1','60.254.5.70','0','0','c1acd8d7ee326cf4caadba8fc917a377','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','c1acd8d7ee326cf4caadba8fc917a377','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-26@2020-11-26@@1048@1@1@@@0','26-11-2020~26-11-2020','53777','S000000243','2020-11-26','2020-11-26','1048','1','60.254.5.70','0','0','a9d0d3387dd8bd356aab26832fc7df72','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','a9d0d3387dd8bd356aab26832fc7df72','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-27@2020-11-27@@1048@1@1@@@0','27-11-2020~27-11-2020','53777','S000000243','2020-11-27','2020-11-27','1048','1','60.254.5.70','0','0','a1589738bb96c0250859a01077186cc4','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','a1589738bb96c0250859a01077186cc4','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-28@2020-11-28@@1048@1@1@@@0','28-11-2020~28-11-2020','53777','S000000243','2020-11-28','2020-11-28','1048','1','60.254.5.70','0','0','bbf1b1ed1d7a136d77737c0232b0caa7','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','bbf1b1ed1d7a136d77737c0232b0caa7','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-29@2020-11-29@@1048@1@1@@@0','29-11-2020~29-11-2020','53777','S000000243','2020-11-29','2020-11-29','1048','1','60.254.5.70','0','0','b167005ade45fcda99fb85048f5d9cb9','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','b167005ade45fcda99fb85048f5d9cb9','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-11-30@2020-11-30@@1048@1@1@@@0','30-11-2020~30-11-2020','53777','S000000243','2020-11-30','2020-11-30','1048','1','60.254.5.70','0','0','0c0e057be2ca5a26eca23e6945e1de48','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','0c0e057be2ca5a26eca23e6945e1de48','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-01@2020-12-01@@1048@1@1@@@0','01-12-2020~01-12-2020','53777','S000000243','2020-12-01','2020-12-01','1048','1','60.254.5.70','0','0','6be5dd5f97d3cd965fe7650d3f5e9ee0','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','6be5dd5f97d3cd965fe7650d3f5e9ee0','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-02@2020-12-02@@1048@1@1@@@0','02-12-2020~02-12-2020','53777','S000000243','2020-12-02','2020-12-02','1048','1','60.254.5.70','0','0','c425604003eb79908ddd4474fa2e49db','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','c425604003eb79908ddd4474fa2e49db','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-03@2020-12-03@@1048@1@1@@@0','03-12-2020~03-12-2020','53777','S000000243','2020-12-03','2020-12-03','1048','1','60.254.5.70','0','0','1171ccc6a1d27eb0b2e6dc26a82b47e0','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','1171ccc6a1d27eb0b2e6dc26a82b47e0','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-04@2020-12-04@@1048@1@1@@@0','04-12-2020~04-12-2020','53777','S000000243','2020-12-04','2020-12-04','1048','1','60.254.5.70','0','0','e796ee2f2fb8596c9f85dd80fbbfeaba','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','e796ee2f2fb8596c9f85dd80fbbfeaba','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-05@2020-12-05@@1048@1@1@@@0','05-12-2020~05-12-2020','53777','S000000243','2020-12-05','2020-12-05','1048','1','60.254.5.70','0','0','eca6391df86883a26bb615a15612706e','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','eca6391df86883a26bb615a15612706e','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-06@2020-12-06@@1048@1@1@@@0','06-12-2020~06-12-2020','53777','S000000243','2020-12-06','2020-12-06','1048','1','60.254.5.70','0','0','f82bcf27eac6478216e2206ec616e88d','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','f82bcf27eac6478216e2206ec616e88d','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-07@2020-12-07@@1048@1@1@@@0','07-12-2020~07-12-2020','53777','S000000243','2020-12-07','2020-12-07','1048','1','60.254.5.70','0','0','340355e3cc75492a900d46d64aa1fed5','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','340355e3cc75492a900d46d64aa1fed5','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-08@2020-12-08@@1048@1@1@@@0','08-12-2020~08-12-2020','53777','S000000243','2020-12-08','2020-12-08','1048','1','60.254.5.70','0','0','388ddd4845265354d2a6e5ddb4fdce2d','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','388ddd4845265354d2a6e5ddb4fdce2d','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-09@2020-12-09@@1048@1@1@@@0','09-12-2020~09-12-2020','53777','S000000243','2020-12-09','2020-12-09','1048','1','60.254.5.70','0','0','83486029f4899fdf0ea5858ca4978b4e','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','83486029f4899fdf0ea5858ca4978b4e','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-10@2020-12-10@@1048@1@1@@@0','10-12-2020~10-12-2020','53777','S000000243','2020-12-10','2020-12-10','1048','1','60.254.5.70','0','0','308f792ec8921490de4c345ac236b5df','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','308f792ec8921490de4c345ac236b5df','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-11@2020-12-11@@1048@1@1@@@0','11-12-2020~11-12-2020','53777','S000000243','2020-12-11','2020-12-11','1048','1','60.254.5.70','0','0','edc2be4ff3cd8e2997c448c65c2ba495','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','edc2be4ff3cd8e2997c448c65c2ba495','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-12@2020-12-12@@1048@1@1@@@0','12-12-2020~12-12-2020','53777','S000000243','2020-12-12','2020-12-12','1048','1','60.254.5.70','0','0','07c0ff7d5a88b1cc61428ad1b79fc158','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','07c0ff7d5a88b1cc61428ad1b79fc158','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-13@2020-12-13@@1048@1@1@@@0','13-12-2020~13-12-2020','53777','S000000243','2020-12-13','2020-12-13','1048','1','60.254.5.70','0','0','eafe0e767ff0f7d74565b3777841f242','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','eafe0e767ff0f7d74565b3777841f242','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-14@2020-12-14@@1048@1@1@@@0','14-12-2020~14-12-2020','53777','S000000243','2020-12-14','2020-12-14','1048','1','60.254.5.70','0','0','f138c2a425f0208d015e1ff9daa70925','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','f138c2a425f0208d015e1ff9daa70925','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-15@2020-12-15@@1048@1@1@@@0','15-12-2020~15-12-2020','53777','S000000243','2020-12-15','2020-12-15','1048','1','60.254.5.70','0','0','111b04c12533638aa74346d3084d0fcb','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','111b04c12533638aa74346d3084d0fcb','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-16@2020-12-16@@1048@1@1@@@0','16-12-2020~16-12-2020','53777','S000000243','2020-12-16','2020-12-16','1048','1','60.254.5.70','0','0','17bff8facdb90052c525d47ec43dff74','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','17bff8facdb90052c525d47ec43dff74','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-17@2020-12-17@@1048@1@1@@@0','17-12-2020~17-12-2020','53777','S000000243','2020-12-17','2020-12-17','1048','1','60.254.5.70','0','0','b39206b9142c8ed3ffec607950b2445c','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','b39206b9142c8ed3ffec607950b2445c','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-18@2020-12-18@@1048@1@1@@@0','18-12-2020~18-12-2020','53777','S000000243','2020-12-18','2020-12-18','1048','1','60.254.5.70','0','0','caf5e1a6a3afc644ce867d3e1cc5f1d3','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','caf5e1a6a3afc644ce867d3e1cc5f1d3','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-19@2020-12-19@@1048@1@1@@@0','19-12-2020~19-12-2020','53777','S000000243','2020-12-19','2020-12-19','1048','1','60.254.5.70','0','0','57c6ac40b722df7a16269d0cb2473908','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','57c6ac40b722df7a16269d0cb2473908','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-20@2020-12-20@@1048@1@1@@@0','20-12-2020~20-12-2020','53777','S000000243','2020-12-20','2020-12-20','1048','1','60.254.5.70','0','0','6659b22c671e49127ad3a1bdc37d4630','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','6659b22c671e49127ad3a1bdc37d4630','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-21@2020-12-21@@1048@1@1@@@0','21-12-2020~21-12-2020','53777','S000000243','2020-12-21','2020-12-21','1048','1','60.254.5.70','0','0','c5547969404e3c3c7cecb02ea96c712a','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','c5547969404e3c3c7cecb02ea96c712a','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-22@2020-12-22@@1048@1@1@@@0','22-12-2020~22-12-2020','53777','S000000243','2020-12-22','2020-12-22','1048','1','60.254.5.70','0','0','076246b6e8ebb025448d9e9a25138ee7','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','076246b6e8ebb025448d9e9a25138ee7','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-23@2020-12-23@@1048@1@1@@@0','23-12-2020~23-12-2020','53777','S000000243','2020-12-23','2020-12-23','1048','1','60.254.5.70','0','0','07a845beb36de5f314ea4cbc20731cd2','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','07a845beb36de5f314ea4cbc20731cd2','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-24@2020-12-24@@1048@1@1@@@0','24-12-2020~24-12-2020','53777','S000000243','2020-12-24','2020-12-24','1048','1','60.254.5.70','0','0','4cafd01ef5ec194b89601a0943da18cf','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','4cafd01ef5ec194b89601a0943da18cf','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-25@2020-12-25@@1048@1@1@@@0','25-12-2020~25-12-2020','53777','S000000243','2020-12-25','2020-12-25','1048','1','60.254.5.70','0','0','11b6e84b2bd86aaf4b223dd221488e31','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','11b6e84b2bd86aaf4b223dd221488e31','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-26@2020-12-26@@1048@1@1@@@0','26-12-2020~26-12-2020','53777','S000000243','2020-12-26','2020-12-26','1048','1','60.254.5.70','0','0','4e74eba51d45724ae840002a664679e8','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','4e74eba51d45724ae840002a664679e8','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-27@2020-12-27@@1048@1@1@@@0','27-12-2020~27-12-2020','53777','S000000243','2020-12-27','2020-12-27','1048','1','60.254.5.70','0','0','1da7de58c0885e602f9ed6260bb25a5f','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','1da7de58c0885e602f9ed6260bb25a5f','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-28@2020-12-28@@1048@1@1@@@0','28-12-2020~28-12-2020','53777','S000000243','2020-12-28','2020-12-28','1048','1','60.254.5.70','0','0','907086372d7244894fb68d1b2b883ecd','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','907086372d7244894fb68d1b2b883ecd','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-29@2020-12-29@@1048@1@1@@@0','29-12-2020~29-12-2020','53777','S000000243','2020-12-29','2020-12-29','1048','1','60.254.5.70','0','0','4099f8cd4fc761b17024c4809c28ee10','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','4099f8cd4fc761b17024c4809c28ee10','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-30@2020-12-30@@1048@1@1@@@0','30-12-2020~30-12-2020','53777','S000000243','2020-12-30','2020-12-30','1048','1','60.254.5.70','0','0','17073f35355dd5fe70e3d77d0d095645','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','17073f35355dd5fe70e3d77d0d095645','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0',''),('53777@S000000243@2020-12-31@2020-12-31@@1048@1@1@@@0','31-12-2020~31-12-2020','53777','S000000243','2020-12-31','2020-12-31','1048','1','60.254.5.70','0','0','3aaccb62e34a17d29121a8279110f1c0','Sa,Su','1','Supplier','132','A','50','50','USD','1','0','0','0','','','0','3aaccb62e34a17d29121a8279110f1c0','2020-10-27 12:58:45','2020-10-27','Supplier','','','','','0','');
[10/27/2020 12:58:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],DELETE  FROM room_rates WHERE id IN ('');
[10/27/2020 12:59:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='10' where supplier_id='S000000243' AND hotel_id='53777' AND inventory_class_id='132'  AND date_from >='2020-10-27' AND date_from <='2020-12-31' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')='0';
[10/27/2020 12:59:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='10' where supplier_id='S000000243' AND hotel_id='53777' AND inventory_class_id='132'  AND date_from >='2020-10-27' AND date_from <='2020-12-31' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')>'0';
[10/27/2020 12:59:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2020-10-27 12:59:05',`log_type`= 'Inventory Allocation',`sql_query`= 'update room_rates set  availability=\&#039;10\&#039; where supplier_id=\&#039;S000000243\&#039; AND hotel_id=\&#039;53777\&#039; AND inventory_class_id=\&#039;132\&#039;  AND date_from &gt;=\&#039;2020-10-27\&#039; AND date_from &lt;=\&#039;2020-12-31\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)=\&#039;0\&#039;&lt;br&gt;update room_rates set  availability=\&#039;10\&#039; where supplier_id=\&#039;S000000243\&#039; AND hotel_id=\&#039;53777\&#039; AND inventory_class_id=\&#039;132\&#039;  AND date_from &gt;=\&#039;2020-10-27\&#039; AND date_from &lt;=\&#039;2020-12-31\&#039; AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),\&#039;Sa,Su\&#039;)&gt;\&#039;0\&#039;',`log_description`= 'Upadated Inventory Allocation For hotel The Heritage- Inventory:-Standard From:-27-10-2020 To:-31-12-2020 Weekday Inventory Allocation:-10 Weekend Inventory Allocation:-10',`ip`= '60.254.5.70',`username`= 'tfg',`user_id`= 'S000000243';
[10/27/2020 12:59:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3870', `entity`='Hotels', `value`='53777' ;
[10/27/2020 12:59:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3870', `entity`='Suppliers', `value`='S000000243' ;
[10/27/2020 12:59:05], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='3870', `entity`='Inventory', `value`='132' ;
