[11/09/2020 06:54:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-11-09 06:54:11',`log_type`= 'Excel Update',`sql_query`= 'File Path=alpha.otrams.thefabulousgetaway.com/project_folder/tfg_project/protected/csv_roomrates/811264744f007e8bed4fe1ccb099d266.xls',`log_description`= 'Update Content for Hotel:- Baan Boran(51817) and Supplier:-Baan Boran(S000000230) From Excel',`ip`= '203.192.244.141';
[11/09/2020 06:54:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='3888', `entity`='Hotels', `value`='51817' ;
[11/09/2020 06:54:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],insert into user_log_link Set `user_logs_id`='3888', `entity`='Suppliers', `value`='S000000230' ;
[11/09/2020 06:54:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],UPDATE inventory_room_class SET inventory_room_class='04 Suites' WHERE id='99';
[11/09/2020 06:54:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],UPDATE inventory_room_class SET inventory_room_class='Junior Suite' WHERE id='28';
[11/09/2020 06:54:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO supplement_rate SET  hotel_id='51817', supplier_id='S000000230', supplement_id='110', class_id='968', from_date='2020-11-07', to_date='2020-11-20', week_day_rate='100', week_end_rate='111', added_by='admin', supplement_per_pax='1', is_child_rate='1';
[11/09/2020 06:54:11], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_supplement_rate SET  weekday_rate='10', weekend_rate='11', age_from='0', age_to='2', supplement_rate_id='756', added_by='admin', status='A';
[11/09/2020 06:54:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_supplement_rate SET  weekday_rate='20', weekend_rate='22', age_from='3', age_to='7', supplement_rate_id='756', added_by='admin', status='A';
[11/09/2020 06:54:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_supplement_rate SET  weekday_rate='30', weekend_rate='33', age_from='8', age_to='10', supplement_rate_id='756', added_by='admin', status='A';
[11/09/2020 06:54:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/read_excel.php],INSERT INTO child_supplement_rate SET  weekday_rate='40', weekend_rate='44', age_from='11', age_to='12', supplement_rate_id='756', added_by='admin', status='A';
[11/09/2020 06:57:34], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/logout.php],INSERT INTO psa_login_log set username = 'tfg' , user_type = 'tfg'_type , branch_id = '' , login_datetime = '2020-11-09 06:57:34' , ip = '203.192.244.141' , action = 'Logout'  ;
