{"created_at":"2020-12-27 10:03: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-12-27 10:03:05","OPEN_FOR_INTERNAL","2020-12-27 10:03:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:03: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-12-27 10:03:06","OPEN_FOR_INTERNAL","2020-12-27 10:03:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:03: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-12-27 10:03:10","OPEN_FOR_INTERNAL","2020-12-27 10:03:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:03: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-12-27 10:03:11","OPEN_FOR_INTERNAL","2020-12-27 10:03:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:03: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-12-27 10:03:24","OPEN_FOR_INTERNAL","2020-12-27 10:03:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:08:07","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-12-27 10:08:07","OPEN_FOR_INTERNAL","2020-12-27 10:08:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:08:07","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-12-27 10:08:07","OPEN_FOR_INTERNAL","2020-12-27 10:08:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:08:07","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:08: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-12-27 10:08:13","OPEN_FOR_INTERNAL","2020-12-27 10:08:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:08: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-12-27 10:08:13","OPEN_FOR_INTERNAL","2020-12-27 10:08:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:08: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-12-27 10:08:16","OPEN_FOR_INTERNAL","2020-12-27 10:08:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:08: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-12-27 10:08:16","OPEN_FOR_INTERNAL","2020-12-27 10:08:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:09: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-12-27 10:09:12","OPEN_FOR_INTERNAL","2020-12-27 10:09:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:09: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-12-27 10:09:16","OPEN_FOR_INTERNAL","2020-12-27 10:09:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:09: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-12-27 10:09:41","OPEN_FOR_INTERNAL","2020-12-27 10:09:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:10: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-12-27 10:10:02","OPEN_FOR_INTERNAL","2020-12-27 10:10:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:10: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-12-27 10:10:04","OPEN_FOR_INTERNAL","2020-12-27 10:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:10: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-12-27 10:10:12","OPEN_FOR_INTERNAL","2020-12-27 10:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:38: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-12-27 10:38:28","OPEN_FOR_INTERNAL","2020-12-27 10:38:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 10:38: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-12-27 10:38:32","OPEN_FOR_INTERNAL","2020-12-27 10:38:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:00: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-12-27 11:00:27","OPEN_FOR_INTERNAL","2020-12-27 11:00:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:00: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-12-27 11:00:27","OPEN_FOR_INTERNAL","2020-12-27 11:00:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:00:27","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:00: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-12-27 11:00:30","OPEN_FOR_INTERNAL","2020-12-27 11:00:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:00: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-12-27 11:00:30","OPEN_FOR_INTERNAL","2020-12-27 11:00:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:00: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-12-27 11:00:32","OPEN_FOR_INTERNAL","2020-12-27 11:00:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:00: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-12-27 11:00:33","OPEN_FOR_INTERNAL","2020-12-27 11:00:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:18: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-12-27 11:18:55","OPEN_FOR_INTERNAL","2020-12-27 11:18:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:25: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-12-27 11:25:33","OPEN_FOR_INTERNAL","2020-12-27 11:25:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:09","OPEN_FOR_INTERNAL","2020-12-27 11:43:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11: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-12-27 11:43:11","OPEN_FOR_INTERNAL","2020-12-27 11:43:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:12","OPEN_FOR_INTERNAL","2020-12-27 11:43:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:25","OPEN_FOR_INTERNAL","2020-12-27 11:43:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:25","OPEN_FOR_INTERNAL","2020-12-27 11:43:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43:29","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-12-27 11:43:29","OPEN_FOR_INTERNAL","2020-12-27 11:43:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43:31","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-12-27 11:43:31","OPEN_FOR_INTERNAL","2020-12-27 11:43:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43: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-12-27 11:43:37","OPEN_FOR_INTERNAL","2020-12-27 11:43:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:43:45","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-12-27 11:43:45","OPEN_FOR_INTERNAL","2020-12-27 11:43:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:44: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-12-27 11:44:52","OPEN_FOR_INTERNAL","2020-12-27 11:44:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 11:47: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-12-27 11:47:28","OPEN_FOR_INTERNAL","2020-12-27 11:47:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:01: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-12-27 12:01:26","OPEN_FOR_INTERNAL","2020-12-27 12:01:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:01:31","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-12-27 12:01:31","OPEN_FOR_INTERNAL","2020-12-27 12:01:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:21","OPEN_FOR_INTERNAL","2020-12-27 12:09:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:24","OPEN_FOR_INTERNAL","2020-12-27 12:09:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:48","OPEN_FOR_INTERNAL","2020-12-27 12:09:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:48","OPEN_FOR_INTERNAL","2020-12-27 12:09:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09:49","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-12-27 12:09:49","OPEN_FOR_INTERNAL","2020-12-27 12:09:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09:49","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-12-27 12:09:49","OPEN_FOR_INTERNAL","2020-12-27 12:09:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09:49","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-12-27 12:09:49","OPEN_FOR_INTERNAL","2020-12-27 12:09:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09:49","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-12-27 12:09:49","OPEN_FOR_INTERNAL","2020-12-27 12:09:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:52","OPEN_FOR_INTERNAL","2020-12-27 12:09:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:52","OPEN_FOR_INTERNAL","2020-12-27 12:09:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:52","OPEN_FOR_INTERNAL","2020-12-27 12:09:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:52","OPEN_FOR_INTERNAL","2020-12-27 12:09:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:53","OPEN_FOR_INTERNAL","2020-12-27 12:09:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:53","OPEN_FOR_INTERNAL","2020-12-27 12:09:53"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:54","OPEN_FOR_INTERNAL","2020-12-27 12:09:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:54","OPEN_FOR_INTERNAL","2020-12-27 12:09:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:54","OPEN_FOR_INTERNAL","2020-12-27 12:09:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:09: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-12-27 12:09:55","OPEN_FOR_INTERNAL","2020-12-27 12:09:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:26","OPEN_FOR_INTERNAL","2020-12-27 12:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:26","OPEN_FOR_INTERNAL","2020-12-27 12:11:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11:26","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:28","OPEN_FOR_INTERNAL","2020-12-27 12:11:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:28","OPEN_FOR_INTERNAL","2020-12-27 12:11:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:33","OPEN_FOR_INTERNAL","2020-12-27 12:11:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:34","OPEN_FOR_INTERNAL","2020-12-27 12:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11:39","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-12-27 12:11:39","OPEN_FOR_INTERNAL","2020-12-27 12:11:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:44","OPEN_FOR_INTERNAL","2020-12-27 12:11:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:51","OPEN_FOR_INTERNAL","2020-12-27 12:11:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:51","OPEN_FOR_INTERNAL","2020-12-27 12:11:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:52","OPEN_FOR_INTERNAL","2020-12-27 12:11:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:52","OPEN_FOR_INTERNAL","2020-12-27 12:11:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:54","OPEN_FOR_INTERNAL","2020-12-27 12:11:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:54","OPEN_FOR_INTERNAL","2020-12-27 12:11:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:54","OPEN_FOR_INTERNAL","2020-12-27 12:11:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:56","OPEN_FOR_INTERNAL","2020-12-27 12:11:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:56","OPEN_FOR_INTERNAL","2020-12-27 12:11:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:11: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-12-27 12:11:56","OPEN_FOR_INTERNAL","2020-12-27 12:11:56"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:12:49","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-12-27 12:12:49","OPEN_FOR_INTERNAL","2020-12-27 12:12:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:12:49","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-12-27 12:12:49","OPEN_FOR_INTERNAL","2020-12-27 12:12:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:12:49","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-12-27 12:12:49","OPEN_FOR_INTERNAL","2020-12-27 12:12:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12: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-12-27 12:13:17","OPEN_FOR_INTERNAL","2020-12-27 12:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:13:17","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","index_url_parameter":"","floor_plan_rent_room":[{"room_id":"1798","master_room_id":"259","room_code":"D02-30"}],"renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1748,"customer_code":"C201748","identity_type":"BUSINESS","identity_id":"71562007-001-01-20-6","title":"Mr","lastname":"\u5f35","firstname":"\u5049\u502b","companyname":"Kalon Trading Limited","email":"gerund@kalontrading.asia","tel":"97269098","address":"HK","pass":true},"2":{"renew_paymethod2":"CHEQUE","renew_bank_name2":"DBS","renew_cheque_num2":"000037","renew_paymethod_order2":null,"renew_total_discounted_price":"720.0","renew_rent_month":"3","renew_warehousing_date":"2020-12-10","renew_room_key":"0012518463","renew_remark":"3 months contract. Storage rental deposit paid by PPS on 14 Sep 2020. \\n\u820a\u5408\u7d04\u7de8\u865f: C15-CT208876, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $720.0","renew_master_room_id":"159","order_discount":[],"order_room":[{"room_id":"1412","room_code":"C15-106","retail_price":"720.0","discounted_price":"720.00","location_id":"6"}],"roughly_size":"9","total_retail_price":720,"total_discounted_price":720,"deposit":0,"rent_month":"1","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"1","prepaid_amount":720,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-12-10","rent_from":"2020-12-10","rent_to":"2021-01-09","delivery_service":"0","remark":"1 months contract. Storage rental paid by bank transfer on Dec 27, 2020. Storage deposit transferred from agreement C15-CT208876 to this agreement.\r\n\r\n","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":720,"final_order_total":720,"location_id":"6","branch_id":"3","company_id":"1","room_key":"0012518463","order_product":[],"pass":true}},"first_order_id":8876,"selected_room_tr":"\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t

---

\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t

\u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t

\u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	\u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t	<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr>
C15-106 <\/td>\r\n\t\t\t\t\t	3X3X6.5 <\/td>\r\n\t\t\t\t\t	$720.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed83\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed86\u500b\u6708 % \u6298\u6263 <\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td>	\r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","roughly_size":"9","total_discounted_price":"720.00","deposit":"0.00","total_retail_price":"720.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:13:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?, `renew` = ?, `first_order_id` = ?","parameters":["1","3","6",1748,"NEW","C15-CT2010044",720,720,0,0,"1","1",720,720,720,"2020-12-27 12:13:17","0",null,null,null,"2020-12-10","2021-01-09","1 months contract. Storage rental paid by bank transfer on Dec 27, 2020. Storage deposit transferred from agreement C15-CT208876 to this agreement.\r\n\r\n","2020-12-10","9",0,null,0,"0.00","2","2020-12-27 12:13:17","2","2020-12-27 12:13:17","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012518463","C201748","BUSINESS","Mr","0MT8Feol9EwG5iZPAoFwXA==","GbMh2m5+wtls+rH3z9irUg==","Kalon Trading Limited","Zufl8\/PMqJCWjlXLT4o9XQ==","4XX+\/VGQkHIe5ZJGI8jHpQ==","mpmuNp3p7ZOrsuQgZLqzvvAVKta1jHqMbKJg08uqXYs=",null,"xaRdEPNq9+iMOiSrY4yYvOR4NLxtJM49sYH506JIOP8=",1,8876]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:13:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["10044","1412","720.0","720.00","2","2020-12-27 12:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:13:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-12-10","2021-01-09","1412"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-12-27 12:13:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10044",1748,"SETTLED","C15-I2010373","2020-12-27 12:13:17","2020-12-10","2","2020-12-27 12:13:17","2","2020-12-27 12:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:13:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10373","RENT","\u9810\u7e73\u79df\u91d1",1,720,"MO","1",720,"2","2020-12-27 12:13:17","2","2020-12-27 12:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:13:17","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[720,0,"10373"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-12-27 12:13:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":[1748,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P2010009","2020-12-27 12:13:17",720,"2","2020-12-27 12:13:17","2","2020-12-27 12:13:17","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:13:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10009","DEPOSIT",null,"PAID","2020-12-27 12:13:17",0,"2","2020-12-27 12:13:17","2","2020-12-27 12:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:13:17","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10009","INVOICE","10373","PAID","2020-12-27 12:13:17",720,"2","2020-12-27 12:13:17","2","2020-12-27 12:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12: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-12-27 12:13:17","OPEN_FOR_INTERNAL","2020-12-27 12:13:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:13: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-12-27 12:13:18","OPEN_FOR_INTERNAL","2020-12-27 12:13:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:14: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-12-27 12:14:27","OPEN_FOR_INTERNAL","2020-12-27 12:14:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:14: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-12-27 12:14:28","OPEN_FOR_INTERNAL","2020-12-27 12:14:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:14:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:16: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-12-27 12:16:52","OPEN_FOR_INTERNAL","2020-12-27 12:16:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:16: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-12-27 12:16:52","OPEN_FOR_INTERNAL","2020-12-27 12:16:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:16:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:16: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-12-27 12:16:54","OPEN_FOR_INTERNAL","2020-12-27 12:16:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:16: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-12-27 12:16:54","OPEN_FOR_INTERNAL","2020-12-27 12:16:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:16:57","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-12-27 12:16:57","OPEN_FOR_INTERNAL","2020-12-27 12:16:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:16:58","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-12-27 12:16:58","OPEN_FOR_INTERNAL","2020-12-27 12:16:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12: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-12-27 12:17:28","OPEN_FOR_INTERNAL","2020-12-27 12:17:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:17: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-12-27 12:17:43","OPEN_FOR_INTERNAL","2020-12-27 12:17:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:17: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-12-27 12:17:44","OPEN_FOR_INTERNAL","2020-12-27 12:17:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:17: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-12-27 12:17:51","OPEN_FOR_INTERNAL","2020-12-27 12:17:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:18: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-12-27 12:18:15","OPEN_FOR_INTERNAL","2020-12-27 12:18:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:18: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-12-27 12:18:16","OPEN_FOR_INTERNAL","2020-12-27 12:18:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:18:16","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:18: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-12-27 12:18:36","OPEN_FOR_INTERNAL","2020-12-27 12:18:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:18: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-12-27 12:18:37","OPEN_FOR_INTERNAL","2020-12-27 12:18:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:18:39","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-12-27 12:18:39","OPEN_FOR_INTERNAL","2020-12-27 12:18:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:18:39","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-12-27 12:18:39","OPEN_FOR_INTERNAL","2020-12-27 12:18:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:18: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-12-27 12:18:42","OPEN_FOR_INTERNAL","2020-12-27 12:18:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:18:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:21: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-12-27 12:21:23","OPEN_FOR_INTERNAL","2020-12-27 12:21:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:23: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-12-27 12:23:54","OPEN_FOR_INTERNAL","2020-12-27 12:23:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:23: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-12-27 12:23:55","OPEN_FOR_INTERNAL","2020-12-27 12:23:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:23: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-12-27 12:23:55","OPEN_FOR_INTERNAL","2020-12-27 12:23:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:23:55","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:24: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-12-27 12:24:01","OPEN_FOR_INTERNAL","2020-12-27 12:24:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:24: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-12-27 12:24:04","OPEN_FOR_INTERNAL","2020-12-27 12:24:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:24: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-12-27 12:24:04","OPEN_FOR_INTERNAL","2020-12-27 12:24:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:24: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-12-27 12:24:06","OPEN_FOR_INTERNAL","2020-12-27 12:24:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:24: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-12-27 12:24:19","OPEN_FOR_INTERNAL","2020-12-27 12:24:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:24: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-12-27 12:24:19","OPEN_FOR_INTERNAL","2020-12-27 12:24:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:24:19","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:24:22","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-12-27 12:24:22","OPEN_FOR_INTERNAL","2020-12-27 12:24:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:24:31","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-12-27 12:24:31","OPEN_FOR_INTERNAL","2020-12-27 12:24:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:24: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-12-27 12:24:34","OPEN_FOR_INTERNAL","2020-12-27 12:24:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:25: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-12-27 12:25:34","OPEN_FOR_INTERNAL","2020-12-27 12:25:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:26: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-12-27 12:26:42","OPEN_FOR_INTERNAL","2020-12-27 12:26:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:26: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-12-27 12:26:42","OPEN_FOR_INTERNAL","2020-12-27 12:26:42"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 12:26:42","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 13:13: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-12-27 13:13:44","OPEN_FOR_INTERNAL","2020-12-27 13:13:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 13:13: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-12-27 13:13:44","OPEN_FOR_INTERNAL","2020-12-27 13:13:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 13:14: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-12-27 13:14:01","OPEN_FOR_INTERNAL","2020-12-27 13:14:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 13:14: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-12-27 13:14:04","OPEN_FOR_INTERNAL","2020-12-27 13:14:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 13:14:07","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-12-27 13:14:07","OPEN_FOR_INTERNAL","2020-12-27 13:14:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 13:14: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-12-27 13:14:09","OPEN_FOR_INTERNAL","2020-12-27 13:14:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 13:14: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-12-27 13:14:10","OPEN_FOR_INTERNAL","2020-12-27 13:14:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 13:15:31","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-12-27 13:15:31","OPEN_FOR_INTERNAL","2020-12-27 13:15:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 13:15: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-12-27 13:15:33","OPEN_FOR_INTERNAL","2020-12-27 13:15:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 13:26: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-12-27 13:26:09","OPEN_FOR_INTERNAL","2020-12-27 13:26:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 13:26: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-12-27 13:26:09","OPEN_FOR_INTERNAL","2020-12-27 13:26:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 14:36:57","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-12-27 14:36:57","OPEN_FOR_INTERNAL","2020-12-27 14:36:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 14:36:57","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-12-27 14:36:57","OPEN_FOR_INTERNAL","2020-12-27 14:36:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 14:37: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-12-27 14:37:00","OPEN_FOR_INTERNAL","2020-12-27 14:37:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 14:37: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-12-27 14:37:02","OPEN_FOR_INTERNAL","2020-12-27 14:37:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 14:41:58","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-12-27 14:41:58","OPEN_FOR_INTERNAL","2020-12-27 14:41:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 14:42: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-12-27 14:42:24","OPEN_FOR_INTERNAL","2020-12-27 14:42:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 14:42: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-12-27 14:42:44","OPEN_FOR_INTERNAL","2020-12-27 14:42:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:35: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-12-27 15:35:10","OPEN_FOR_INTERNAL","2020-12-27 15:35:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:35: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-12-27 15:35:10","OPEN_FOR_INTERNAL","2020-12-27 15:35:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:35: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-12-27 15:35:43","OPEN_FOR_INTERNAL","2020-12-27 15:35:43"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:35:45","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-12-27 15:35:45","OPEN_FOR_INTERNAL","2020-12-27 15:35:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:36: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-12-27 15:36:03","OPEN_FOR_INTERNAL","2020-12-27 15:36:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:36: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-12-27 15:36:05","OPEN_FOR_INTERNAL","2020-12-27 15:36:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:36: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-12-27 15:36:08","OPEN_FOR_INTERNAL","2020-12-27 15:36:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:36:40","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-12-27 15:36:40","OPEN_FOR_INTERNAL","2020-12-27 15:36:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:36:40","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-12-27 15:36:40","OPEN_FOR_INTERNAL","2020-12-27 15:36:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:36:40","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:36:45","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-12-27 15:36:45","OPEN_FOR_INTERNAL","2020-12-27 15:36:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:37: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-12-27 15:37:05","OPEN_FOR_INTERNAL","2020-12-27 15:37:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:37: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-12-27 15:37:16","OPEN_FOR_INTERNAL","2020-12-27 15:37:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:37: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-12-27 15:37:27","OPEN_FOR_INTERNAL","2020-12-27 15:37:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:38: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-12-27 15:38:12","OPEN_FOR_INTERNAL","2020-12-27 15:38:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:38: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-12-27 15:38:12","OPEN_FOR_INTERNAL","2020-12-27 15:38:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:38:12","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:38: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-12-27 15:38:15","OPEN_FOR_INTERNAL","2020-12-27 15:38:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:38: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-12-27 15:38:15","OPEN_FOR_INTERNAL","2020-12-27 15:38:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:38: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-12-27 15:38:17","OPEN_FOR_INTERNAL","2020-12-27 15:38:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:38:17","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:38: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-12-27 15:38:20","OPEN_FOR_INTERNAL","2020-12-27 15:38:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:38:35","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-12-27 15:38:35","OPEN_FOR_INTERNAL","2020-12-27 15:38:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:38:40","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-12-27 15:38:40","OPEN_FOR_INTERNAL","2020-12-27 15:38:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:38: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-12-27 15:38:55","OPEN_FOR_INTERNAL","2020-12-27 15:38:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:39: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-12-27 15:39:11","OPEN_FOR_INTERNAL","2020-12-27 15:39:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:39: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-12-27 15:39:20","OPEN_FOR_INTERNAL","2020-12-27 15:39:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:39: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-12-27 15:39:26","OPEN_FOR_INTERNAL","2020-12-27 15:39:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:39:29","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-12-27 15:39:29","OPEN_FOR_INTERNAL","2020-12-27 15:39:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:39: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-12-27 15:39:41","OPEN_FOR_INTERNAL","2020-12-27 15:39:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:39: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-12-27 15:39:41","OPEN_FOR_INTERNAL","2020-12-27 15:39:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:39:45","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-12-27 15:39:45","OPEN_FOR_INTERNAL","2020-12-27 15:39:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:57:57","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-12-27 15:57:57","OPEN_FOR_INTERNAL","2020-12-27 15:57:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:59: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-12-27 15:59:38","OPEN_FOR_INTERNAL","2020-12-27 15:59:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 15:59: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-12-27 15:59:41","OPEN_FOR_INTERNAL","2020-12-27 15:59:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:04: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-12-27 16:04:55","OPEN_FOR_INTERNAL","2020-12-27 16:04:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:04:57","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-12-27 16:04:57","OPEN_FOR_INTERNAL","2020-12-27 16:04:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:05: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-12-27 16:05:05","OPEN_FOR_INTERNAL","2020-12-27 16:05:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:05: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-12-27 16:05:28","OPEN_FOR_INTERNAL","2020-12-27 16:05:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:05: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-12-27 16:05:28","OPEN_FOR_INTERNAL","2020-12-27 16:05:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:05:28","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:05: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-12-27 16:05:38","OPEN_FOR_INTERNAL","2020-12-27 16:05:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:05: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-12-27 16:05:51","OPEN_FOR_INTERNAL","2020-12-27 16:05:51"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:06: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-12-27 16:06:38","OPEN_FOR_INTERNAL","2020-12-27 16:06:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:06:49","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-12-27 16:06:49","OPEN_FOR_INTERNAL","2020-12-27 16:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:06:49","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-12-27 16:06:49","OPEN_FOR_INTERNAL","2020-12-27 16:06:49"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:06: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-12-27 16:06:52","OPEN_FOR_INTERNAL","2020-12-27 16:06:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:05","OPEN_FOR_INTERNAL","2020-12-27 16:07:05"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:09","OPEN_FOR_INTERNAL","2020-12-27 16:07:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:09","OPEN_FOR_INTERNAL","2020-12-27 16:07:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:11","OPEN_FOR_INTERNAL","2020-12-27 16:07:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:13","OPEN_FOR_INTERNAL","2020-12-27 16:07:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:13","OPEN_FOR_INTERNAL","2020-12-27 16:07:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:13","OPEN_FOR_INTERNAL","2020-12-27 16:07:13"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:14","OPEN_FOR_INTERNAL","2020-12-27 16:07:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:14","OPEN_FOR_INTERNAL","2020-12-27 16:07:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:19","OPEN_FOR_INTERNAL","2020-12-27 16:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:19","OPEN_FOR_INTERNAL","2020-12-27 16:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:19","OPEN_FOR_INTERNAL","2020-12-27 16:07:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:25","OPEN_FOR_INTERNAL","2020-12-27 16:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:25","OPEN_FOR_INTERNAL","2020-12-27 16:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:25","OPEN_FOR_INTERNAL","2020-12-27 16:07:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:26","OPEN_FOR_INTERNAL","2020-12-27 16:07:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:26","OPEN_FOR_INTERNAL","2020-12-27 16:07:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:26","OPEN_FOR_INTERNAL","2020-12-27 16:07:26"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:28","OPEN_FOR_INTERNAL","2020-12-27 16:07:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:28","OPEN_FOR_INTERNAL","2020-12-27 16:07:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07:29","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-12-27 16:07:29","OPEN_FOR_INTERNAL","2020-12-27 16:07:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07:29","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-12-27 16:07:29","OPEN_FOR_INTERNAL","2020-12-27 16:07:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07:29","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-12-27 16:07:29","OPEN_FOR_INTERNAL","2020-12-27 16:07:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07:29","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-12-27 16:07:29","OPEN_FOR_INTERNAL","2020-12-27 16:07:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07:29","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-12-27 16:07:29","OPEN_FOR_INTERNAL","2020-12-27 16:07:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:30","OPEN_FOR_INTERNAL","2020-12-27 16:07:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:33","OPEN_FOR_INTERNAL","2020-12-27 16:07:33"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07:35","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-12-27 16:07:35","OPEN_FOR_INTERNAL","2020-12-27 16:07:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:07: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-12-27 16:07:37","OPEN_FOR_INTERNAL","2020-12-27 16:07:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:08: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-12-27 16:08:10","OPEN_FOR_INTERNAL","2020-12-27 16:08:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:08: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-12-27 16:08:10","OPEN_FOR_INTERNAL","2020-12-27 16:08:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:08: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-12-27 16:08:10","OPEN_FOR_INTERNAL","2020-12-27 16:08:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:08: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-12-27 16:08:14","OPEN_FOR_INTERNAL","2020-12-27 16:08:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:08: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-12-27 16:08:16","OPEN_FOR_INTERNAL","2020-12-27 16:08:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:08: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-12-27 16:08:17","OPEN_FOR_INTERNAL","2020-12-27 16:08:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16: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-12-27 16:08:18","OPEN_FOR_INTERNAL","2020-12-27 16:08:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16: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-12-27 16:08:18","OPEN_FOR_INTERNAL","2020-12-27 16:08:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:08: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-12-27 16:08:19","OPEN_FOR_INTERNAL","2020-12-27 16:08:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:08: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-12-27 16:08:20","OPEN_FOR_INTERNAL","2020-12-27 16:08:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:04","OPEN_FOR_INTERNAL","2020-12-27 16:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:04","OPEN_FOR_INTERNAL","2020-12-27 16:10:04"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10:07","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-12-27 16:10:07","OPEN_FOR_INTERNAL","2020-12-27 16:10:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10:07","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-12-27 16:10:07","OPEN_FOR_INTERNAL","2020-12-27 16:10:07"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:10","OPEN_FOR_INTERNAL","2020-12-27 16:10:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:10","OPEN_FOR_INTERNAL","2020-12-27 16:10:10"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:12","OPEN_FOR_INTERNAL","2020-12-27 16:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:12","OPEN_FOR_INTERNAL","2020-12-27 16:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:12","OPEN_FOR_INTERNAL","2020-12-27 16:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:12","OPEN_FOR_INTERNAL","2020-12-27 16:10:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:14","OPEN_FOR_INTERNAL","2020-12-27 16:10:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:15","OPEN_FOR_INTERNAL","2020-12-27 16:10:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:15","OPEN_FOR_INTERNAL","2020-12-27 16:10:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:15","OPEN_FOR_INTERNAL","2020-12-27 16:10:15"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16: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-12-27 16:10:16","OPEN_FOR_INTERNAL","2020-12-27 16:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16: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-12-27 16:10:16","OPEN_FOR_INTERNAL","2020-12-27 16:10:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:17","OPEN_FOR_INTERNAL","2020-12-27 16:10:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:18","OPEN_FOR_INTERNAL","2020-12-27 16:10:18"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:19","OPEN_FOR_INTERNAL","2020-12-27 16:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:19","OPEN_FOR_INTERNAL","2020-12-27 16:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:19","OPEN_FOR_INTERNAL","2020-12-27 16:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:19","OPEN_FOR_INTERNAL","2020-12-27 16:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:19","OPEN_FOR_INTERNAL","2020-12-27 16:10:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:21","OPEN_FOR_INTERNAL","2020-12-27 16:10:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:21","OPEN_FOR_INTERNAL","2020-12-27 16:10:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:47","OPEN_FOR_INTERNAL","2020-12-27 16:10:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:47","OPEN_FOR_INTERNAL","2020-12-27 16:10:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:47","OPEN_FOR_INTERNAL","2020-12-27 16:10:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:10: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-12-27 16:10:47","OPEN_FOR_INTERNAL","2020-12-27 16:10:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11: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-12-27 16:11:27","OPEN_FOR_INTERNAL","2020-12-27 16:11:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11: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-12-27 16:11:27","OPEN_FOR_INTERNAL","2020-12-27 16:11:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11: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-12-27 16:11:27","OPEN_FOR_INTERNAL","2020-12-27 16:11:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11: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-12-27 16:11:34","OPEN_FOR_INTERNAL","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:34","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","index_url_parameter":"filter1=3&filter2=1927","floor_plan_rent_room":[{"room_id":"1363","master_room_id":"167","room_code":"C15-057"}],"selected_room_tr":"\r\n\t\t\t\t\t\t\t\t\t\t\t	\u9078\u64c7\u8ff7\u4f60\u5009<\/td>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t	\r\n\t\t\t\t\t\t\t\t\t\t\t\t \r\n\r\n\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t \u5df2\u9078\u53d6\u5009\u5eab \u6e05\u7a7a\u5df2\u9078\u53d6\u5009\u5eab<\/button><\/caption>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t \u5009\u5eab\u7de8\u865f<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u5c3a\u5bf8<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u539f\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u512a\u60e0\u50f9(\u6708)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u9810\u7e73 \/ \u6307\u5b9a\u5009\u5eab\u512a\u60e0<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t \u50f9\u683c(\u6298\u6263\u5f8c)<\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/tr> C15-057 <\/td>\r\n\t\t\t\t\t 4X3X6.5 <\/td>\r\n\t\t\t\t\t $810.00 <\/td>\r\n\t\t\t\t N\/A <\/td> \u9810\u4ed86\u500b\u6708 % \u6298\u6263 \/ <\/br>\u9810\u4ed83\u500b\u6708 % \u6298\u6263 <\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\r\n\t\t\t\t\t<\/td> \r\n\t\t\t\t\t\t\u522a\u9664<\/button>\r\n\t\t\t\t\t<\/td><\/tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t<\/tbody><\/table>\r\n\r\n\t\t\t\t\t\t\t\t\t\t\t<\/td>\r\n\t\t\t\t\t\t\t\t\t\t","warehousing":{"1":{"new_customer":"0","identity_type":"PERSONAL","identity_id":"K978270(2)","title":"Ms","lastname":"YU","firstname":"Che Kwan","companyname":"","email":"","tel":"68941898","address":"Flat N, 16\/F, HING CHEUNG BUILDING, 15-31 SHAU KEI WAN ROAD, SHAU KEI WAN, HK ","pass":true,"customer_id":"1927","customer_code":"C201927","customer_first_order":false},"2":{"order_discount":[],"order_room":[{"room_id":"1363","room_code":"C15-057","retail_price":"810.0","discounted_price":"810.00","location_id":"6"}],"roughly_size":"12","total_retail_price":810,"total_discounted_price":729,"deposit":810,"rent_month":"8","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"8","prepaid_amount":6642,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-12-28","rent_from":"2020-12-28","rent_to":"2021-08-27","delivery_service":"0","remark":"8 months contract. Storage rental $5832 and deposit $810 paid by bank transfer on Dec 27,2020. ","paymethod":"BANKIN","paymethod_other":"","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":6642,"final_order_total":6642,"location_id":"6","branch_id":"3","company_id":"1","room_key":"189,28771","order_product":[],"pass":true}},"roughly_size":"12","total_discounted_price":"729.00","deposit":"810.00","total_retail_price":"810.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order` set `company_id` = ?, `branch_id` = ?, `location_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `total_retail_price` = ?, `total_discounted_price` = ?, `deposit` = ?, `deposit_penalty` = ?, `rent_month` = ?, `prepaid_month` = ?, `prepaid_amount` = ?, `original_amount` = ?, `balance` = ?, `docdate` = ?, `transport_enable` = ?, `transport_date` = ?, `transport_address` = ?, `transport_destination` = ?, `startdate` = ?, `enddate` = ?, `remark` = ?, `warehousing_date` = ?, `roughly_size` = ?, `free_first_month_deduct` = ?, `free_2_month_deduct` = ?, `discount_deduct` = ?, `last_paid` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `from_order_id` = ?, `total_return_amount` = ?, `room_key` = ?, `customer_code` = ?, `customer_typeid` = ?, `customer_title` = ?, `customer_firstname` = ?, `customer_lastname` = ?, `customer_companyname` = ?, `customer_address` = ?, `customer_tel` = ?, `customer_email` = ?, `customer_hkid` = ?, `customer_hkbr` = ?","parameters":["1","3","6","1927","NEW","C15-CT2010045",810,729,810,0,"8","8",6642,6642,6642,"2020-12-27 16:11:35","0",null,null,null,"2020-12-28","2021-08-27","8 months contract. Storage rental $5832 and deposit $810 paid by bank transfer on Dec 27,2020. ","2020-12-28","12",0,null,0,"0.00","2","2020-12-27 16:11:34","2","2020-12-27 16:11:34","BANKIN","","","","BANKIN","","","",null,0,"189,28771","C201927","PERSONAL","Ms","ZajMJ1QHkJAdm4e1sHfdTA==","4sZhlLfrmxrYN8eefiQ6Rg==","","NqGWbDQFWnf1u2jwSZQE+LZfO5Q7o+HqS7+KLzQ6jxFa0qkB6QH5j1rgm5eS5YN7pSadbhMD3jndAKvHzgWtF3GzUdQcsLUAeU6UvhggWWE=","EZzzWg\/4JJIW0sC0ZX4ZEg==",null,"naPsIjFtA4LFkaT9t3DdPw==",null]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `order_room` set `order_id` = ?, `room_id` = ?, `retail_price` = ?, `discounted_price` = ?, `createby` = ?, `createdate` = ?","parameters":["10045","1363","810.0","810.00","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update room set `status` = 'RENTED', rentaldate_from = ?, rentaldate_to = ? where id = ?","parameters":["2020-12-28","2021-08-27","1363"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `deposit` set `order_id` = ?, `code` = ?, `status` = ?, `amount` = ?, `balance` = ?, `expected_returndate` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `customer_id` = ?","parameters":["10045","C15-D205986","PAID",810,0,"2021-08-27","2020-12-27 16:11:34","2020-12-27 16:11:34","2","2020-12-27 16:11:34","2","2020-12-27 16:11:34","1927"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice` set `order_id` = ?, `customer_id` = ?, `status` = ?, `code` = ?, `docdate` = ?, `duedate` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10045","1927","SETTLED","C15-I2010374","2020-12-27 16:11:34","2020-12-28","2","2020-12-27 16:11:34","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10374","RENT","\u9810\u7e73\u79df\u91d1",1,729,"MO","1",729,"2","2020-12-27 16:11:34","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10374","RENT","\u9810\u7e73\u79df\u91d1",2,729,"MO","1",729,"2","2020-12-27 16:11:34","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10374","RENT","\u9810\u7e73\u79df\u91d1",3,729,"MO","1",729,"2","2020-12-27 16:11:34","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10374","RENT","\u9810\u7e73\u79df\u91d1",4,729,"MO","1",729,"2","2020-12-27 16:11:34","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10374","RENT","\u9810\u7e73\u79df\u91d1",5,729,"MO","1",729,"2","2020-12-27 16:11:34","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10374","RENT","\u9810\u7e73\u79df\u91d1",6,729,"MO","1",729,"2","2020-12-27 16:11:34","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10374","RENT","\u9810\u7e73\u79df\u91d1",7,729,"MO","1",729,"2","2020-12-27 16:11:34","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `invoice_dtl` set `invoice_id` = ?, `type` = ?, `remark` = ?, `month` = ?, `price` = ?, `uom_price` = ?, `qty` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10374","RENT","\u9810\u7e73\u79df\u91d1",8,729,"MO","1",729,"2","2020-12-27 16:11:34","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[5832,0,"10374"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment` set `customer_id` = ?, `paymethod` = ?, `bank_name` = ?, `cheque_num` = ?, `paymethod_other` = ?, `paymethod2` = ?, `bank_name2` = ?, `cheque_num2` = ?, `paymethod_other2` = ?, `status` = ?, `code` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?, `payfor` = ?","parameters":["1927","BANKIN","","","","BANKIN","","","","PAID","P2010010","2020-12-27 16:11:34",6642,"2","2020-12-27 16:11:34","2","2020-12-27 16:11:34","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10010","DEPOSIT","5986","PAID","2020-12-27 16:11:34",810,"2","2020-12-27 16:11:34","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","login_id":"2","controller":"insert_record","function":"","input":{"sql":"insert into `payment_dtl` set `payment_id` = ?, `payable_type` = ?, `payable_id` = ?, `status` = ?, `docdate` = ?, `amount` = ?, `createby` = ?, `createdate` = ?, `lastupby` = ?, `lastupdate` = ?","parameters":["10010","INVOICE","10374","PAID","2020-12-27 16:11:34",5832,"2","2020-12-27 16:11:34","2","2020-12-27 16:11:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","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-12-27 16:11:35","OPEN_FOR_INTERNAL","2020-12-27 16:11:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:11:35","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-12-27 16:11:35","OPEN_FOR_INTERNAL","2020-12-27 16:11:35"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:22: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-12-27 16:22:21","OPEN_FOR_INTERNAL","2020-12-27 16:22:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:22: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-12-27 16:22:21","OPEN_FOR_INTERNAL","2020-12-27 16:22:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:22:21","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:22: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-12-27 16:22:24","OPEN_FOR_INTERNAL","2020-12-27 16:22:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:22: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-12-27 16:22:34","OPEN_FOR_INTERNAL","2020-12-27 16:22:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:22:39","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-12-27 16:22:39","OPEN_FOR_INTERNAL","2020-12-27 16:22:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 16:23: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-12-27 16:23:27","OPEN_FOR_INTERNAL","2020-12-27 16:23:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 18:27:22","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-12-27 18:27:22","OPEN_FOR_INTERNAL","2020-12-27 18:27:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 18:27:22","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-12-27 18:27:22","OPEN_FOR_INTERNAL","2020-12-27 18:27:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 18:27:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 18:27: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-12-27 18:27:25","OPEN_FOR_INTERNAL","2020-12-27 18:27:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 18:27: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-12-27 18:27:25","OPEN_FOR_INTERNAL","2020-12-27 18:27:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 18:27:29","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-12-27 18:27:29","OPEN_FOR_INTERNAL","2020-12-27 18:27:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 18:27:31","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-12-27 18:27:31","OPEN_FOR_INTERNAL","2020-12-27 18:27:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-12-27 18:27: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-12-27 18:27:56","OPEN_FOR_INTERNAL","2020-12-27 18:27:56"]},"data_before":[],"data_after":[],"step":1} *****