{"created_at":"2020-09-18 09:42: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-09-18 09:42:41","OPEN_FOR_INTERNAL","2020-09-18 09:42:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 09:42: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-09-18 09:42:41","OPEN_FOR_INTERNAL","2020-09-18 09:42:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 09:42:41","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 09:43: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-09-18 09:43:11","OPEN_FOR_INTERNAL","2020-09-18 09:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 09:43: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-09-18 09:43:54","OPEN_FOR_INTERNAL","2020-09-18 09:43:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 09:44: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-09-18 09:44:37","OPEN_FOR_INTERNAL","2020-09-18 09:44:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 09:44: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-09-18 09:44:37","OPEN_FOR_INTERNAL","2020-09-18 09:44:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 09:44:44","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-09-18 09:44:44","OPEN_FOR_INTERNAL","2020-09-18 09:44:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 09:44: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-09-18 09:44:47","OPEN_FOR_INTERNAL","2020-09-18 09:44:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:00: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-09-18 10:00:21","OPEN_FOR_INTERNAL","2020-09-18 10:00:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:00: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-09-18 10:00:21","OPEN_FOR_INTERNAL","2020-09-18 10:00:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:00:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:02: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-09-18 10:02:14","OPEN_FOR_INTERNAL","2020-09-18 10:02:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:02: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-09-18 10:02:14","OPEN_FOR_INTERNAL","2020-09-18 10:02:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:02:14","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:04: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-09-18 10:04:14","OPEN_FOR_INTERNAL","2020-09-18 10:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:04: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-09-18 10:04:14","OPEN_FOR_INTERNAL","2020-09-18 10:04:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:04: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-09-18 10:04:28","OPEN_FOR_INTERNAL","2020-09-18 10:04:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:04: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-09-18 10:04:37","OPEN_FOR_INTERNAL","2020-09-18 10:04:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:06:05","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-09-18 10:06:05","OPEN_FOR_INTERNAL","2020-09-18 10:06:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:06:05","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-09-18 10:06:05","OPEN_FOR_INTERNAL","2020-09-18 10:06:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:06:05","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:06:20","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-09-18 10:06:20","OPEN_FOR_INTERNAL","2020-09-18 10:06:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:06:20","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:08: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-09-18 10:08:18","OPEN_FOR_INTERNAL","2020-09-18 10:08:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:08: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-09-18 10:08:18","OPEN_FOR_INTERNAL","2020-09-18 10:08:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:08: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-09-18 10:08:23","OPEN_FOR_INTERNAL","2020-09-18 10:08:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:08:24","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-09-18 10:08:24","OPEN_FOR_INTERNAL","2020-09-18 10:08:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:08:55","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-09-18 10:08:55","OPEN_FOR_INTERNAL","2020-09-18 10:08:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10: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-09-18 10:10:08","OPEN_FOR_INTERNAL","2020-09-18 10:10:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10:16","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-09-18 10:10:16","OPEN_FOR_INTERNAL","2020-09-18 10:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10: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-09-18 10:10:59","OPEN_FOR_INTERNAL","2020-09-18 10:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:10: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-09-18 10:10:59","OPEN_FOR_INTERNAL","2020-09-18 10:10:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:00","OPEN_FOR_INTERNAL","2020-09-18 10:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:00","OPEN_FOR_INTERNAL","2020-09-18 10:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:00","OPEN_FOR_INTERNAL","2020-09-18 10:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:00","OPEN_FOR_INTERNAL","2020-09-18 10:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:00","OPEN_FOR_INTERNAL","2020-09-18 10:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:00","OPEN_FOR_INTERNAL","2020-09-18 10:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:00","OPEN_FOR_INTERNAL","2020-09-18 10:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:00","OPEN_FOR_INTERNAL","2020-09-18 10:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:00","OPEN_FOR_INTERNAL","2020-09-18 10:11:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:01","OPEN_FOR_INTERNAL","2020-09-18 10:11:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:01","OPEN_FOR_INTERNAL","2020-09-18 10:11:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:01","OPEN_FOR_INTERNAL","2020-09-18 10:11:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11:06","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-09-18 10:11:06","OPEN_FOR_INTERNAL","2020-09-18 10:11:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:08","OPEN_FOR_INTERNAL","2020-09-18 10:11:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:09","OPEN_FOR_INTERNAL","2020-09-18 10:11:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:09","OPEN_FOR_INTERNAL","2020-09-18 10:11:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:09","OPEN_FOR_INTERNAL","2020-09-18 10:11:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:09","OPEN_FOR_INTERNAL","2020-09-18 10:11:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:10","OPEN_FOR_INTERNAL","2020-09-18 10:11:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:11","OPEN_FOR_INTERNAL","2020-09-18 10:11:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:11: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-09-18 10:11:11","OPEN_FOR_INTERNAL","2020-09-18 10:11:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:13: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-09-18 10:13:17","OPEN_FOR_INTERNAL","2020-09-18 10:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:15: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-09-18 10:15:30","OPEN_FOR_INTERNAL","2020-09-18 10:15:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:15: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-09-18 10:15:37","OPEN_FOR_INTERNAL","2020-09-18 10:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:15: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-09-18 10:15:37","OPEN_FOR_INTERNAL","2020-09-18 10:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:15: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-09-18 10:15:37","OPEN_FOR_INTERNAL","2020-09-18 10:15:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:15: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-09-18 10:15:47","OPEN_FOR_INTERNAL","2020-09-18 10:15:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-09-18 10:15:47","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":1399,"customer_code":"C191399","identity_type":"PERSONAL","identity_id":"E575975(0)","title":"Ms","lastname":"Chan","firstname":"Hay Lin Helina","companyname":"","email":null,"tel":"63338303","address":"Flat A, 5\/F, Lee Loy Building, 208-214 Jaffe Road, Wanchai, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"1709.0","renew_rent_month":"3","renew_warehousing_date":"2020-09-23","renew_room_key":"0012492259","renew_remark":"3 months contract. Storage rental paid by bank transfer on June 18,2020. Storage deposit $1798 transferred from agreement C15-CT207447 to this agreement. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT208166, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"175","order_discount":[{"master_room_discount_id":"425","master_room_id":"175","discount_type":"%","price":"1798.00","disocunted_price":"1709.00","discount":"4.95","monthly_deduct":89.001,"room_id":"1336","is_final_discount":"0","payment_term":"PREPAID_3_MO"}],"order_room":[{"room_id":"1336","room_code":"C15-030","retail_price":"1798.0","discounted_price":1709,"location_id":"6"}],"roughly_size":"32","total_retail_price":1798,"total_discounted_price":1709,"deposit":0,"rent_month":"3","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"3","prepaid_amount":5127,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-09-23","rent_from":"2020-09-23","rent_to":"2020-12-22","delivery_service":"0","remark":"3 months contract. Storage rental paid by bank transfer on 18 Sep 2020. Storage deposit $1798 transferred from agreement C15-CT208166 to this agreement. ","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":5127,"final_order_total":5127,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012492259","order_product":[],"pass":true}},"first_order_id":"5970","selected_room_tr":"