[07/30/2020 08:51:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],DELETE from hotel_supplier_mapping WHERE SupplierId= 'S000000072' AND city_code= '64440' AND country_code= '106';
[07/30/2020 08:51:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],INSERT INTO hotel_supplier_mapping SET SupplierId = 'S000000072',hotel_id = '53759',city_code = '64440',country_code = '106';
[07/30/2020 08:51:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-30 08:51:33',`log_type`= 'Hotel Supplier Mapping Updated',`sql_query`= ' ------ INSERT INTO hotel_supplier_mapping SET SupplierId = \&#039;S000000072\&#039;,hotel_id = \&#039;53759\&#039;,city_code = \&#039;64440\&#039;,country_code = \&#039;106\&#039;',`log_description`= 'Hotel Supplier Mapping Updated for Supplier  : S000000072, City : 64440, Country : 106, Hotels are : 53759',`ip`= '60.254.44.39';
[07/30/2020 08:51:33], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_supplier_mapping.php],insert into user_log_link Set `user_logs_id`='3393', `entity`='Suppliers', `value`='S000000072' ;
[07/30/2020 08:52:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/inventory_room_class.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-30 08:52:37',`log_type`= 'Inventory Room Category',`sql_query`= 'INSERT INTO inventory_room_class SET inventory_room_class =\&#039;UATDouble\&#039;,status =\&#039;A\&#039;',`log_description`= 'Inventory Room Category Added UATDouble',`ip`= '60.254.44.39';
[07/30/2020 08:52:37], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/inventory_room_class.php],INSERT INTO inventory_room_class SET inventory_room_class ='UATDouble',status ='A';
[07/30/2020 08:52:57], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/inventory_room_class.php],UPDATE inventory_room_class SET status='D' WHERE id= ?;
[07/30/2020 08:53:28], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_room_basis.php],INSERT INTO room_basis SET room_basis = ?,status ='A',create_date = ?;
[07/30/2020 08:53:38], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/edit_room_basis.php],UPDATE room_basis SET status='D' , modify_date='' WHERE id= ?;
[07/30/2020 08:54:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set prefered_hotel= '1' where id = '53746' and city = '64440' and country = '106';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '0' where id = '19596';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '0' where id = '22284';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '0' where id = '29556';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '0' where id = '44313';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '0' where id = '47522';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '0' where id = '47562';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '1' where id = '19596' AND prefered_hotel='1';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '1' where id = '47522' AND prefered_hotel='1';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '1' where id = '29556' AND prefered_hotel='1';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '1' where id = '47562' AND prefered_hotel='1';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '1' where id = '44313' AND prefered_hotel='1';
[07/30/2020 08:55:27], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/add_preferred_hotel.php],update hotels set search_prefered_hotel= '1' where id = '22284' AND prefered_hotel='1';
[07/30/2020 08:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_category.php],INSERT INTO hotel_categories SET category_name= 'FiveStar',created_by = 'tfg',created_at = '2020-07-30 08:07:45';
[07/30/2020 08:57:45], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_category.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-30 08:57:45',`log_type`= 'Hotel Category Mapping',`sql_query`= 'INSERT INTO hotel_categories SET category_name= \&#039;FiveStar\&#039;,created_by = \&#039;tfg\&#039;,created_at = \&#039;2020-07-30 08:07:45\&#039;',`log_description`= 'A Manual Hotel Category Mapping has been done',`ip`= '60.254.44.39';
[07/30/2020 08:58:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_category.php],UPDATE hotel_categories SET status='D' WHERE id= '6';
[07/30/2020 08:58:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_category.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-30 08:58:14',`log_type`= 'Hotel Category Mapping',`sql_query`= 'UPDATE hotel_categories SET status=\&#039;D\&#039; WHERE id= \&#039;6\&#039;',`log_description`= 'A Manual Hotel Category Mapping has been Deleted',`ip`= '60.254.44.39';
[07/30/2020 08:59:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_property_type.php],INSERT INTO hotel_property_type SET name= 'Bungalow',created_by = 'tfg',created_datetime = '2020-07-30 08:07:26';
[07/30/2020 08:59:26], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_property_type.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-30 08:59:26',`log_type`= 'Hotel Property Type Mapping',`sql_query`= 'INSERT INTO hotel_property_type SET name= \&#039;Bungalow\&#039;,created_by = \&#039;tfg\&#039;,created_datetime = \&#039;2020-07-30 08:07:26\&#039;',`log_description`= 'A Manual Hotel Property Type Mapping has been done',`ip`= '60.254.44.39';
[07/30/2020 08:59:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_property_type.php],UPDATE hotel_property_type SET status='D' WHERE id= '3';
[07/30/2020 08:59:36], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotel_property_type.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2020-07-30 08:59:36',`log_type`= 'Hotel Property Type Mapping',`sql_query`= 'UPDATE hotel_property_type SET status=\&#039;D\&#039; WHERE id= \&#039;3\&#039;',`log_description`= 'A Manual Hotel Property Type Mapping has been Deleted',`ip`= '60.254.44.39';
