{"created_at":"2020-08-13 04:38:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 04:38:37","OPEN_FOR_INTERNAL","2020-08-13 04:38:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 04:38:37","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:04:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:04:00","OPEN_FOR_INTERNAL","2020-08-13 10:04:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:04:00","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:04:00","OPEN_FOR_INTERNAL","2020-08-13 10:04:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:04:00","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:05:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:05:17","OPEN_FOR_INTERNAL","2020-08-13 10:05:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:05:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:05:17","OPEN_FOR_INTERNAL","2020-08-13 10:05:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:05:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:05:25","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:05:25","OPEN_FOR_INTERNAL","2020-08-13 10:05:25"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:07:08","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:07:08","OPEN_FOR_INTERNAL","2020-08-13 10:07:08"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:17:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:17:28","OPEN_FOR_INTERNAL","2020-08-13 10:17:28"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:18:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:18:21","OPEN_FOR_INTERNAL","2020-08-13 10:18:21"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:18:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:18:27","OPEN_FOR_INTERNAL","2020-08-13 10:18:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:18:33","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:18:33","OPEN_FOR_INTERNAL","2020-08-13 10:18:33"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:20:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:20:04","OPEN_FOR_INTERNAL","2020-08-13 10:20:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:20:36","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:20:36","OPEN_FOR_INTERNAL","2020-08-13 10:20:36"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:20:41","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:20:41","OPEN_FOR_INTERNAL","2020-08-13 10:20:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:20:47","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:20:47","OPEN_FOR_INTERNAL","2020-08-13 10:20:47"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:20:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:20:59","OPEN_FOR_INTERNAL","2020-08-13 10:20:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:21:09","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:21:09","OPEN_FOR_INTERNAL","2020-08-13 10:21:09"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:21:15","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:21:15","OPEN_FOR_INTERNAL","2020-08-13 10:21:15"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:21:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:21:17","OPEN_FOR_INTERNAL","2020-08-13 10:21:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:21:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:21:32","OPEN_FOR_INTERNAL","2020-08-13 10:21:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:21:41","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:21:41","OPEN_FOR_INTERNAL","2020-08-13 10:21:41"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:22:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:22:42","OPEN_FOR_INTERNAL","2020-08-13 10:22:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:22:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:22:42","OPEN_FOR_INTERNAL","2020-08-13 10:22:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:22:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:22:48","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:22:48","OPEN_FOR_INTERNAL","2020-08-13 10:22:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:22:48","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:22:48","OPEN_FOR_INTERNAL","2020-08-13 10:22:48"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:22:51","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:22:51","OPEN_FOR_INTERNAL","2020-08-13 10:22:51"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:22:52","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:22:52","OPEN_FOR_INTERNAL","2020-08-13 10:22:52"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:23:13","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:23:13","OPEN_FOR_INTERNAL","2020-08-13 10:23:13"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:24:30","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:24:30","OPEN_FOR_INTERNAL","2020-08-13 10:24:30"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:24:53","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:24:53","OPEN_FOR_INTERNAL","2020-08-13 10:24:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:24:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:24:59","OPEN_FOR_INTERNAL","2020-08-13 10:24:59"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:25:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:25:42","OPEN_FOR_INTERNAL","2020-08-13 10:25:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:25:46","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:25:46","OPEN_FOR_INTERNAL","2020-08-13 10:25:46"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:25:56","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:25:56","OPEN_FOR_INTERNAL","2020-08-13 10:25:56"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:26:01","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:26:00","OPEN_FOR_INTERNAL","2020-08-13 10:26:00"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:26:03","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:26:03","OPEN_FOR_INTERNAL","2020-08-13 10:26:03"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:26:10","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:26:10","OPEN_FOR_INTERNAL","2020-08-13 10:26:10"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:26:14","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:26:14","OPEN_FOR_INTERNAL","2020-08-13 10:26:14"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:26:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:26:19","OPEN_FOR_INTERNAL","2020-08-13 10:26:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:26:54","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:26:54","OPEN_FOR_INTERNAL","2020-08-13 10:26:54"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:27:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:27:27","OPEN_FOR_INTERNAL","2020-08-13 10:27:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:27:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:27:27","OPEN_FOR_INTERNAL","2020-08-13 10:27:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:27:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:29:17","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:29:17","OPEN_FOR_INTERNAL","2020-08-13 10:29:17"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:29:18","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:29:18","OPEN_FOR_INTERNAL","2020-08-13 10:29:18"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:29:18","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:29:21","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:29:21","OPEN_FOR_INTERNAL","2020-08-13 10:29:21"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:29:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:29:23","OPEN_FOR_INTERNAL","2020-08-13 10:29:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:29:23","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:29:23","OPEN_FOR_INTERNAL","2020-08-13 10:29:23"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:30:28","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:30:28","OPEN_FOR_INTERNAL","2020-08-13 10:30:28"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:30:34","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:30:34","OPEN_FOR_INTERNAL","2020-08-13 10:30:34"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:32:32","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:32:32","OPEN_FOR_INTERNAL","2020-08-13 10:32:32"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:32:43","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:32:43","OPEN_FOR_INTERNAL","2020-08-13 10:32:43"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:33:37","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:33:37","OPEN_FOR_INTERNAL","2020-08-13 10:33:37"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:35:04","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:35:04","OPEN_FOR_INTERNAL","2020-08-13 10:35:04"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:35:12","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:35:12","OPEN_FOR_INTERNAL","2020-08-13 10:35:12"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:35:19","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:35:19","OPEN_FOR_INTERNAL","2020-08-13 10:35:19"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:35:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:35:26","OPEN_FOR_INTERNAL","2020-08-13 10:35:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:35:38","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:35:38","OPEN_FOR_INTERNAL","2020-08-13 10:35:38"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:35:42","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:35:42","OPEN_FOR_INTERNAL","2020-08-13 10:35:42"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:35:53","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:35:53","OPEN_FOR_INTERNAL","2020-08-13 10:35:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:02","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:02","OPEN_FOR_INTERNAL","2020-08-13 10:36:02"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:11","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:11","OPEN_FOR_INTERNAL","2020-08-13 10:36:11"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:26","OPEN_FOR_INTERNAL","2020-08-13 10:36:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:26","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:26","OPEN_FOR_INTERNAL","2020-08-13 10:36:26"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:27","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:27","OPEN_FOR_INTERNAL","2020-08-13 10:36:27"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:50","OPEN_FOR_INTERNAL","2020-08-13 10:36:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:50","OPEN_FOR_INTERNAL","2020-08-13 10:36:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:50","OPEN_FOR_INTERNAL","2020-08-13 10:36:50"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:53","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-08-13 10:36:53","OPEN_FOR_INTERNAL","2020-08-13 10:36:53"]},"data_before":[],"data_after":[],"step":1}
*****
{"created_at":"2020-08-13 10:36:53","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":62,"customer_code":"C160062","identity_type":"PERSONAL","identity_id":"K228082(5)","title":"Mr","lastname":"Yuen","firstname":"Kwok On, Mark","companyname":"","email":"ym6128@yahoo.com.hk","tel":"61287967","address":"Flat 7,20\/F ,Blk E, Yue Fai Court,Aberdeen","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"598.0","renew_rent_month":"1","renew_warehousing_date":"2020-08-14","renew_room_key":"254,19454","renew_remark":"1 month contract. Storage rental $600 paid by cash deposit on Jul 13, 2020. Storage deposit transferred from agreement A12-CT208083 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A12-CT208389, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"1","order_discount":[],"order_room":[{"room_id":"214","room_code":"D18","retail_price":"598.0","discounted_price":"598.00","location_id":"1"}],"roughly_size":"12","total_retail_price":598,"total_discounted_price":598,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":598,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0","warehousing_date":"2020-08-14","rent_from":"2020-08-14","rent_to":"2020-09-13","delivery_service":"0","remark":"1 month contract. Storage rental $600 paid by cash deposit on Aug 06, 2020. Storage deposit transferred from agreement A12-CT208389 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":598,"final_order_total":598,"location_id":"1","branch_id":"1","company_id":"1","room_key":"254,19454","order_product":[],"pass":true}},"first_order_id":"4763","selected_room_tr":"