[01/30/2021 06:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotel_supplier_mapping SET channel_manager = 'rategain',ip_addr='43.239.53.130' WHERE SupplierId = 'S000000092' AND hotel_id = '53719' AND status = 'A';
[01/30/2021 06:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:35:12',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;rategain\&#039;,ip_addr=\&#039;43.239.53.130\&#039; WHERE SupplierId = \&#039;S000000092\&#039; AND hotel_id = \&#039;53719\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:35:12',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;rategain\&#039;,ip_addr=\&#039;43.239.53.130\&#039; WHERE SupplierId = \&#039;S000000092\&#039; AND hotel_id = \&#039;53719\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4091', `entity`='Hotels', `value`='53719' ;
[01/30/2021 06:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4091', `entity`='Suppliers', `value`='S000000092' ;
[01/30/2021 06:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotels SET weekend='6,7',infant_lower_limit='0',infant_upper_limit='2',tiny_child_lower_limit='3',tiny_child_upper_limit='4',child_lower_limit='5',child_upper_limit='6',teen_child_lower_limit='7',teen_child_upper_limit='11',booking_closing_time='',timezone='8' where id= '53719';
[01/30/2021 06:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:35:12',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=\&#039;0\&#039;,infant_upper_limit=\&#039;2\&#039;,tiny_child_lower_limit=\&#039;3\&#039;,tiny_child_upper_limit=\&#039;4\&#039;,child_lower_limit=\&#039;5\&#039;,child_upper_limit=\&#039;6\&#039;,teen_child_lower_limit=\&#039;7\&#039;,teen_child_upper_limit=\&#039;11\&#039;,booking_closing_time=\&#039;\&#039;,timezone=\&#039;8\&#039; where id= \&#039;53719\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:35:12',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=\&#039;0\&#039;,infant_upper_limit=\&#039;2\&#039;,tiny_child_lower_limit=\&#039;3\&#039;,tiny_child_upper_limit=\&#039;4\&#039;,child_lower_limit=\&#039;5\&#039;,child_upper_limit=\&#039;6\&#039;,teen_child_lower_limit=\&#039;7\&#039;,teen_child_upper_limit=\&#039;11\&#039;,booking_closing_time=\&#039;\&#039;,timezone=\&#039;8\&#039; where id= \&#039;53719\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4093', `entity`='Hotels', `value`='53719' ;
[01/30/2021 06:35:12], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4093', `entity`='Suppliers', `value`='S000000092' ;
[01/30/2021 06:44:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotel_supplier_mapping SET channel_manager = '',ip_addr='43.239.53.130' WHERE SupplierId = 'S000000092' AND hotel_id = '53719' AND status = 'A';
[01/30/2021 06:44:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:44:14',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;\&#039;,ip_addr=\&#039;43.239.53.130\&#039; WHERE SupplierId = \&#039;S000000092\&#039; AND hotel_id = \&#039;53719\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:44:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:44:14',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;\&#039;,ip_addr=\&#039;43.239.53.130\&#039; WHERE SupplierId = \&#039;S000000092\&#039; AND hotel_id = \&#039;53719\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:44:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4095', `entity`='Hotels', `value`='53719' ;
[01/30/2021 06:44:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4095', `entity`='Suppliers', `value`='S000000092' ;
[01/30/2021 06:44:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotels SET weekend='6,7',infant_lower_limit='0',infant_upper_limit='2',tiny_child_lower_limit='3',tiny_child_upper_limit='4',child_lower_limit='5',child_upper_limit='6',teen_child_lower_limit='7',teen_child_upper_limit='11',booking_closing_time='',timezone='8' where id= '53719';
[01/30/2021 06:44:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:44:14',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=\&#039;0\&#039;,infant_upper_limit=\&#039;2\&#039;,tiny_child_lower_limit=\&#039;3\&#039;,tiny_child_upper_limit=\&#039;4\&#039;,child_lower_limit=\&#039;5\&#039;,child_upper_limit=\&#039;6\&#039;,teen_child_lower_limit=\&#039;7\&#039;,teen_child_upper_limit=\&#039;11\&#039;,booking_closing_time=\&#039;\&#039;,timezone=\&#039;8\&#039; where id= \&#039;53719\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:44:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:44:14',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=\&#039;0\&#039;,infant_upper_limit=\&#039;2\&#039;,tiny_child_lower_limit=\&#039;3\&#039;,tiny_child_upper_limit=\&#039;4\&#039;,child_lower_limit=\&#039;5\&#039;,child_upper_limit=\&#039;6\&#039;,teen_child_lower_limit=\&#039;7\&#039;,teen_child_upper_limit=\&#039;11\&#039;,booking_closing_time=\&#039;\&#039;,timezone=\&#039;8\&#039; where id= \&#039;53719\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:44:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4097', `entity`='Hotels', `value`='53719' ;
[01/30/2021 06:44:14], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4097', `entity`='Suppliers', `value`='S000000092' ;
[01/30/2021 06:44:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotel_supplier_mapping SET channel_manager = 'rategain',ip_addr='43.239.53.130' WHERE SupplierId = 'S000000092' AND hotel_id = '53719' AND status = 'A';
[01/30/2021 06:44:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:44:32',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;rategain\&#039;,ip_addr=\&#039;43.239.53.130\&#039; WHERE SupplierId = \&#039;S000000092\&#039; AND hotel_id = \&#039;53719\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:44:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:44:32',`log_type`= 'Channel Manager updated',`sql_query`= 'UPDATE hotel_supplier_mapping SET channel_manager = \&#039;rategain\&#039;,ip_addr=\&#039;43.239.53.130\&#039; WHERE SupplierId = \&#039;S000000092\&#039; AND hotel_id = \&#039;53719\&#039; AND status = \&#039;A\&#039;',`log_description`= 'Channel Manager updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:44:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4099', `entity`='Hotels', `value`='53719' ;
[01/30/2021 06:44:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4099', `entity`='Suppliers', `value`='S000000092' ;
[01/30/2021 06:44:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],UPDATE hotels SET weekend='6,7',infant_lower_limit='0',infant_upper_limit='2',tiny_child_lower_limit='3',tiny_child_upper_limit='4',child_lower_limit='5',child_upper_limit='6',teen_child_lower_limit='7',teen_child_upper_limit='11',booking_closing_time='',timezone='8' where id= '53719';
[01/30/2021 06:44:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:44:32',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=\&#039;0\&#039;,infant_upper_limit=\&#039;2\&#039;,tiny_child_lower_limit=\&#039;3\&#039;,tiny_child_upper_limit=\&#039;4\&#039;,child_lower_limit=\&#039;5\&#039;,child_upper_limit=\&#039;6\&#039;,teen_child_lower_limit=\&#039;7\&#039;,teen_child_upper_limit=\&#039;11\&#039;,booking_closing_time=\&#039;\&#039;,timezone=\&#039;8\&#039; where id= \&#039;53719\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:44:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into `user_logs` set `username`= 'tfg',`create_date`= '2021-01-30 06:44:32',`log_type`= 'Hotel Details updated',`sql_query`= 'UPDATE hotels SET weekend=\&#039;6,7\&#039;,infant_lower_limit=\&#039;0\&#039;,infant_upper_limit=\&#039;2\&#039;,tiny_child_lower_limit=\&#039;3\&#039;,tiny_child_upper_limit=\&#039;4\&#039;,child_lower_limit=\&#039;5\&#039;,child_upper_limit=\&#039;6\&#039;,teen_child_lower_limit=\&#039;7\&#039;,teen_child_upper_limit=\&#039;11\&#039;,booking_closing_time=\&#039;\&#039;,timezone=\&#039;8\&#039; where id= \&#039;53719\&#039;',`log_description`= 'Hotel Details updated by User tfg',`ip`= '43.239.53.130';
[01/30/2021 06:44:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4101', `entity`='Hotels', `value`='53719' ;
[01/30/2021 06:44:32], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/tms/hotels.php],insert into user_log_link Set `user_logs_id`='4101', `entity`='Suppliers', `value`='S000000092' ;
[01/30/2021 06:48:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='10' where supplier_id='S000000092' AND hotel_id='53719' AND inventory_class_id='140'  AND date_from >='2021-02-17' AND date_from <='2021-02-17' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')='0';
[01/30/2021 06:48:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set  availability='10' where supplier_id='S000000092' AND hotel_id='53719' AND inventory_class_id='140'  AND date_from >='2021-02-17' AND date_from <='2021-02-17' AND FIND_IN_SET(LEFT(DAYNAME(date_from),2),'Sa,Su')>'0';
[01/30/2021 06:48:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2021-01-30 06:48:39',`log_type`= 'Inventory Allocation',`sql_query`= 'update room_rates set  availability=\&#039;10\&#039; where supplier_id=\&#039;S000000092\&#039; AND hotel_id=\&#039;53719\&#039; AND inventory_class_id=\&#039;140\&#039;  AND date_from &gt;=\&#039;2021-02-17\&#039; AND date_from &lt;=\&#039;2021-02-17\&#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;S000000092\&#039; AND hotel_id=\&#039;53719\&#039; AND inventory_class_id=\&#039;140\&#039;  AND date_from &gt;=\&#039;2021-02-17\&#039; AND date_from &lt;=\&#039;2021-02-17\&#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 WALLAWWA- Inventory:-ROH (Standard/Superior) From:-17-02-2021 To:-17-02-2021 Weekday Inventory Allocation:-10 Weekend Inventory Allocation:-10',`ip`= '43.239.53.130',`username`= 'tfg',`user_id`= 'S000000092';
[01/30/2021 06:48:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4102', `entity`='Hotels', `value`='53719' ;
[01/30/2021 06:48:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4102', `entity`='Suppliers', `value`='S000000092' ;
[01/30/2021 06:48:39], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4102', `entity`='Inventory', `value`='140' ;
[01/30/2021 06:49:17], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],update room_rates set stop_sale='1' where supplier_id='S000000092' and hotel_id=53719  and inventory_class_id in ('140') and date_from >='2021-02-17' AND date_from <='2021-02-17' ;
[01/30/2021 06:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into `user_logs` set  `create_date`= '2021-01-30 06:49:18',`log_type`= 'Sell Policy',`sql_query`= 'update room_rates set stop_sale=\&#039;1\&#039; where supplier_id=\&#039;S000000092\&#039; and hotel_id=53719  and inventory_class_id in (\&#039;140\&#039;) and date_from &gt;=\&#039;2021-02-17\&#039; AND date_from &lt;=\&#039;2021-02-17\&#039; &lt;br&gt;',`log_description`= 'Updated Sell Policy For hotel THE WALLAWWA- Inventory Room Class:-ROH (Standard/Superior) From:-17-02-2021 To:-17-02-2021 Weekday Policy:-Full Stop Sell Weekend Policy:-Full Stop Sell',`ip`= '43.239.53.130',`username`= 'tfg',`user_id`= 'S000000092';
[01/30/2021 06:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4103', `entity`='Hotels', `value`='53719' ;
[01/30/2021 06:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4103', `entity`='Suppliers', `value`='S000000092' ;
[01/30/2021 06:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4103', `entity`='Inventory', `value`='' ;
[01/30/2021 06:49:18], [file name :-/home/otrams/public_html/otramsphp7/uat/v3otrams/extranet-app/controllers/controller.php],insert into user_log_link Set `user_logs_id`='4103', `entity`='Roomclass', `value`='' ;
