{"created_at":"2020-11-29 12:22: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-11-29 12:22:03","OPEN_FOR_INTERNAL","2020-11-29 12:22:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:22: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-11-29 12:22:03","OPEN_FOR_INTERNAL","2020-11-29 12:22:03"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:22:03","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:22: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-11-29 12:22:08","OPEN_FOR_INTERNAL","2020-11-29 12:22:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:22: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-11-29 12:22:28","OPEN_FOR_INTERNAL","2020-11-29 12:22:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:22: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-11-29 12:22:45","OPEN_FOR_INTERNAL","2020-11-29 12:22:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:22:59","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-29 12:22:59","OPEN_FOR_INTERNAL","2020-11-29 12:22:59"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:23: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-11-29 12:23:25","OPEN_FOR_INTERNAL","2020-11-29 12:23:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 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-11-29 12:24:01","OPEN_FOR_INTERNAL","2020-11-29 12:24:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:25: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-11-29 12:25:16","OPEN_FOR_INTERNAL","2020-11-29 12:25:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:25: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-11-29 12:25:21","OPEN_FOR_INTERNAL","2020-11-29 12:25:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:25: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-11-29 12:25:37","OPEN_FOR_INTERNAL","2020-11-29 12:25:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:25: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-11-29 12:25:41","OPEN_FOR_INTERNAL","2020-11-29 12:25:41"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:26: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-11-29 12:26:00","OPEN_FOR_INTERNAL","2020-11-29 12:26:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:26: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-11-29 12:26:02","OPEN_FOR_INTERNAL","2020-11-29 12:26:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:26:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-29 12:26:50","OPEN_FOR_INTERNAL","2020-11-29 12:26:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12:27: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-11-29 12:27:19","OPEN_FOR_INTERNAL","2020-11-29 12:27:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 12: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-11-29 12:27:22","OPEN_FOR_INTERNAL","2020-11-29 12:27:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 13:23: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-11-29 13:23:38","OPEN_FOR_INTERNAL","2020-11-29 13:23:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 13:23: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-11-29 13:23:44","OPEN_FOR_INTERNAL","2020-11-29 13:23:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 13:41: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-11-29 13:41:38","OPEN_FOR_INTERNAL","2020-11-29 13:41:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 13:47: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-11-29 13:47:48","OPEN_FOR_INTERNAL","2020-11-29 13:47:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 13:47:50","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-29 13:47:50","OPEN_FOR_INTERNAL","2020-11-29 13:47:50"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 14:24: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-11-29 14:24:21","OPEN_FOR_INTERNAL","2020-11-29 14:24:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:38: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-11-29 15:38:22","OPEN_FOR_INTERNAL","2020-11-29 15:38:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:38: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-11-29 15:38:22","OPEN_FOR_INTERNAL","2020-11-29 15:38:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:38:22","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:38: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-11-29 15:38:34","OPEN_FOR_INTERNAL","2020-11-29 15:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:38: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-11-29 15:38:34","OPEN_FOR_INTERNAL","2020-11-29 15:38:34"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:38: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-11-29 15:38:39","OPEN_FOR_INTERNAL","2020-11-29 15:38:39"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 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-11-29 15:38:40","OPEN_FOR_INTERNAL","2020-11-29 15:38:40"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:39: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-11-29 15:39:09","OPEN_FOR_INTERNAL","2020-11-29 15:39:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:39: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-11-29 15:39:30","OPEN_FOR_INTERNAL","2020-11-29 15:39:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:19","OPEN_FOR_INTERNAL","2020-11-29 15:43:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:23","OPEN_FOR_INTERNAL","2020-11-29 15:43:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:23","OPEN_FOR_INTERNAL","2020-11-29 15:43:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:23","OPEN_FOR_INTERNAL","2020-11-29 15:43:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:23","OPEN_FOR_INTERNAL","2020-11-29 15:43:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:23","OPEN_FOR_INTERNAL","2020-11-29 15:43:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:23","OPEN_FOR_INTERNAL","2020-11-29 15:43:23"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:24","OPEN_FOR_INTERNAL","2020-11-29 15:43:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:24","OPEN_FOR_INTERNAL","2020-11-29 15:43:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:24","OPEN_FOR_INTERNAL","2020-11-29 15:43:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:24","OPEN_FOR_INTERNAL","2020-11-29 15:43:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:24","OPEN_FOR_INTERNAL","2020-11-29 15:43:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:24","OPEN_FOR_INTERNAL","2020-11-29 15:43:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:24","OPEN_FOR_INTERNAL","2020-11-29 15:43:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:24","OPEN_FOR_INTERNAL","2020-11-29 15:43:24"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:27","OPEN_FOR_INTERNAL","2020-11-29 15:43:27"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:28","OPEN_FOR_INTERNAL","2020-11-29 15:43:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:28","OPEN_FOR_INTERNAL","2020-11-29 15:43:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:28","OPEN_FOR_INTERNAL","2020-11-29 15:43:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15: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-11-29 15:43:29","OPEN_FOR_INTERNAL","2020-11-29 15:43:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15: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-11-29 15:43:29","OPEN_FOR_INTERNAL","2020-11-29 15:43:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:30","OPEN_FOR_INTERNAL","2020-11-29 15:43:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:32","OPEN_FOR_INTERNAL","2020-11-29 15:43:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:43: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-11-29 15:43:32","OPEN_FOR_INTERNAL","2020-11-29 15:43:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:01","OPEN_FOR_INTERNAL","2020-11-29 15:44:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:02","OPEN_FOR_INTERNAL","2020-11-29 15:44:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:02","OPEN_FOR_INTERNAL","2020-11-29 15:44:02"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:08","OPEN_FOR_INTERNAL","2020-11-29 15:44:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:08","OPEN_FOR_INTERNAL","2020-11-29 15:44:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:08","OPEN_FOR_INTERNAL","2020-11-29 15:44:08"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:09","OPEN_FOR_INTERNAL","2020-11-29 15:44:09"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:11","OPEN_FOR_INTERNAL","2020-11-29 15:44:11"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:12","OPEN_FOR_INTERNAL","2020-11-29 15:44:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:12","OPEN_FOR_INTERNAL","2020-11-29 15:44:12"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:14","OPEN_FOR_INTERNAL","2020-11-29 15:44:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:44: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-11-29 15:44:14","OPEN_FOR_INTERNAL","2020-11-29 15:44:14"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:45: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-11-29 15:45:44","OPEN_FOR_INTERNAL","2020-11-29 15:45:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:47: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-11-29 15:47:45","OPEN_FOR_INTERNAL","2020-11-29 15:47:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:47: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-11-29 15:47:45","OPEN_FOR_INTERNAL","2020-11-29 15:47:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:47:46","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-29 15:47:45","OPEN_FOR_INTERNAL","2020-11-29 15:47:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:47: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-11-29 15:47:47","OPEN_FOR_INTERNAL","2020-11-29 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:47: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-11-29 15:47:47","OPEN_FOR_INTERNAL","2020-11-29 15:47:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:47: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-11-29 15:47:48","OPEN_FOR_INTERNAL","2020-11-29 15:47:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:47: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-11-29 15:47:48","OPEN_FOR_INTERNAL","2020-11-29 15:47:48"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48: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-11-29 15:48:28","OPEN_FOR_INTERNAL","2020-11-29 15:48:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48: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-11-29 15:48:28","OPEN_FOR_INTERNAL","2020-11-29 15:48:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48: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-11-29 15:48:28","OPEN_FOR_INTERNAL","2020-11-29 15:48:28"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48: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-11-29 15:48:45","OPEN_FOR_INTERNAL","2020-11-29 15:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:45","login_id":"2","controller":"warehousing_step3_post.php","function":"","input":{"post":[],"session":{"loginname":"admin","cmsloginid":"2","loginid":"2","cmsrole":"admin","role":"admin","KCFINDER":{"disabled":false,"uploadURL":"upload\/","uploadDir":""},"langcode":"tc","renew":1,"warehousing":{"1":{"new_customer":0,"customer_id":1119,"customer_code":"C181119","identity_type":"PERSONAL","identity_id":"D826898(4)","title":"Mr","lastname":"Chiu","firstname":"Sung Hei","companyname":"","email":"milk1083@yahoo.com","tel":"64773817","address":"Flat D, 8\/F, Fortune Mansion, 20 Hung Shing Street, Apleichau, Hong Kong","pass":true},"2":{"renew_paymethod2":"BANKIN","renew_bank_name2":"","renew_cheque_num2":"","renew_paymethod_order2":null,"renew_total_discounted_price":"538.0","renew_rent_month":"6","renew_warehousing_date":"2020-12-02","renew_room_key":"0012476535","renew_remark":"6 months contract. Storage rental paid by bank transfer on May 27, 2020. Storage deposit $1196 transferred from agreement A05-CT196599 to this agreement.
\\n\u820a\u5408\u7d04\u7de8\u865f: A05-CT208040, \u820a\u5408\u7d04\u6309\u91d1\u91d1\u984d: $0.0","renew_master_room_id":"110","order_discount":[],"order_room":[{"room_id":"1078","room_code":"A05-076","retail_price":"598.0","discounted_price":"598.00","location_id":"4"}],"roughly_size":"8","total_retail_price":598,"total_discounted_price":538,"deposit":0,"rent_month":"6","biggest_retail_price":"0","biggest_discounted_price":"0","prepaid_month":"6","prepaid_amount":3228,"free_first_month":0,"free_first_month_deduct":0,"free_2_month_deduct":null,"last_paid":"0.00","warehousing_date":"2020-12-02","rent_from":"2020-12-02","rent_to":"2021-06-01","delivery_service":"0","remark":"6 months contract. Storage rental paid by bank transfer on Nov 29, 2020. Storage deposit $1196 transferred from agreement A05-CT208040 to this agreement.","paymethod":"NO_NEED_PAID_RENEW","paymethod2":"BANKIN","paymethod_other2":"","discount_deduct":0,"order_total":3228,"final_order_total":3228,"location_id":"4","branch_id":"1","company_id":"1","room_key":"0012476535","order_product":[],"pass":true}},"first_order_id":"3732","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>
A05-076 <\/td>\r\n\t\t\t\t\t	4X2X3.5 <\/td>\r\n\t\t\t\t\t	$598.00 <\/td>\r\n\t\t\t\t	N\/A <\/td>	\u9810\u4ed812\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":"8","total_discounted_price":"538.00","deposit":"0.00","total_retail_price":"598.00"}},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","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","1","4",1119,"NEW","A05-CT209728",598,538,0,0,"6","6",3228,3228,3228,"2020-11-29 15:48:46","0",null,null,null,"2020-12-02","2021-06-01","6 months contract. Storage rental paid by bank transfer on Nov 29, 2020. Storage deposit $1196 transferred from agreement A05-CT208040 to this agreement.","2020-12-02","8",0,null,0,"0.00","2","2020-11-29 15:48:45","2","2020-11-29 15:48:45","NO_NEED_PAID_RENEW","","","","BANKIN","","","",null,0,"0012476535","C181119","PERSONAL","Mr","MuZt1lYgrMpypgbMsIt8Lg==","sQFQFKDK2lCJDg4WUvEEAw==","","h9FsxQ4+y6tmkXXSf28JN+\/+fESDd1YBpOIM5j\/ZGlSxIgSaYj6ZyF1PjRqum+WKF9Eap9myr+tDMrNsbQIOfoW7I62uXvJ1upAUTlBDwHE=","e5kgt1YGSyJD\/M7FfyYOEw==","JxGuC86ZykblJcqi+nR5I5jLNd3SjVegJ2PfsLL40zg=","DS+B4iq5I2pIT9W8mSYlzw==",null,1,"3732"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","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":["9728","1078","598.0","598.00","2","2020-11-29 15:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","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-02","2021-06-01","1078"]},"data_before":[],"data_after":[],"step":5} ***** {"created_at":"2020-11-29 15:48:46","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":["9728",1119,"SETTLED","A05-I2010057","2020-11-29 15:48:45","2020-12-02","2","2020-11-29 15:48:45","2","2020-11-29 15:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","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":["10057","RENT","\u9810\u7e73\u79df\u91d1",1,538,"MO","1",538,"2","2020-11-29 15:48:45","2","2020-11-29 15:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","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":["10057","RENT","\u9810\u7e73\u79df\u91d1",2,538,"MO","1",538,"2","2020-11-29 15:48:45","2","2020-11-29 15:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","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":["10057","RENT","\u9810\u7e73\u79df\u91d1",3,538,"MO","1",538,"2","2020-11-29 15:48:45","2","2020-11-29 15:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","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":["10057","RENT","\u9810\u7e73\u79df\u91d1",4,538,"MO","1",538,"2","2020-11-29 15:48:45","2","2020-11-29 15:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","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":["10057","RENT","\u9810\u7e73\u79df\u91d1",5,538,"MO","1",538,"2","2020-11-29 15:48:45","2","2020-11-29 15:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","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":["10057","RENT","\u9810\u7e73\u79df\u91d1",6,538,"MO","1",538,"2","2020-11-29 15:48:45","2","2020-11-29 15:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","login_id":"2","controller":"warehousing_step3_post.php","function":"update query","input":{"sql":"update invoice set amount = ?, balance = ? where id = ?","parameters":[3228,0,"10057"]},"data_before":[],"data_after":[],"step":6} ***** {"created_at":"2020-11-29 15:48:46","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":[1119,"NO_NEED_PAID_RENEW","","","","BANKIN","","","","PAID","P209695","2020-11-29 15:48:45",3228,"2","2020-11-29 15:48:45","2","2020-11-29 15:48:45","ALL"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","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":["9695","DEPOSIT",null,"PAID","2020-11-29 15:48:45",0,"2","2020-11-29 15:48:45","2","2020-11-29 15:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","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":["9695","INVOICE","10057","PAID","2020-11-29 15:48:45",3228,"2","2020-11-29 15:48:45","2","2020-11-29 15:48:45"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-29 15:48:46","OPEN_FOR_INTERNAL","2020-11-29 15:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 15:48:46","login_id":"2","controller":"basic_info.php","function":"update_room_online_hold","input":{"sql":"update room set status = ?, session_id = ?, online_hold_time = ?, lastupby = ?, lastupdate = ? where status = ? and (? > online_hold_time or online_hold_time = '' or online_hold_time IS NULL)","parameters":["OPEN","","","2","2020-11-29 15:48:46","OPEN_FOR_INTERNAL","2020-11-29 15:48:46"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:13: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-11-29 16:13:52","OPEN_FOR_INTERNAL","2020-11-29 16:13:52"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:13:52","login_id":"2","controller":"mainpage.php","function":"","input":[],"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:13: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-11-29 16:13:54","OPEN_FOR_INTERNAL","2020-11-29 16:13:54"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:13: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-11-29 16:13:55","OPEN_FOR_INTERNAL","2020-11-29 16:13:55"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:13: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-11-29 16:13:58","OPEN_FOR_INTERNAL","2020-11-29 16:13:58"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:06","OPEN_FOR_INTERNAL","2020-11-29 16:14:06"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:16","OPEN_FOR_INTERNAL","2020-11-29 16:14:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:16","OPEN_FOR_INTERNAL","2020-11-29 16:14:16"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:17","OPEN_FOR_INTERNAL","2020-11-29 16:14:17"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:19","OPEN_FOR_INTERNAL","2020-11-29 16:14:19"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:20","OPEN_FOR_INTERNAL","2020-11-29 16:14:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:20","OPEN_FOR_INTERNAL","2020-11-29 16:14:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:20","OPEN_FOR_INTERNAL","2020-11-29 16:14:20"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:21","OPEN_FOR_INTERNAL","2020-11-29 16:14:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:21","OPEN_FOR_INTERNAL","2020-11-29 16:14:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:21","OPEN_FOR_INTERNAL","2020-11-29 16:14:21"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:22","OPEN_FOR_INTERNAL","2020-11-29 16:14:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:22","OPEN_FOR_INTERNAL","2020-11-29 16:14:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:22","OPEN_FOR_INTERNAL","2020-11-29 16:14:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:22","OPEN_FOR_INTERNAL","2020-11-29 16:14:22"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:29","OPEN_FOR_INTERNAL","2020-11-29 16:14:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:29","OPEN_FOR_INTERNAL","2020-11-29 16:14:29"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:30","OPEN_FOR_INTERNAL","2020-11-29 16:14:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:30","OPEN_FOR_INTERNAL","2020-11-29 16:14:30"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:31","OPEN_FOR_INTERNAL","2020-11-29 16:14:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:31","OPEN_FOR_INTERNAL","2020-11-29 16:14:31"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:32","OPEN_FOR_INTERNAL","2020-11-29 16:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:32","OPEN_FOR_INTERNAL","2020-11-29 16:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:32","OPEN_FOR_INTERNAL","2020-11-29 16:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:32","OPEN_FOR_INTERNAL","2020-11-29 16:14:32"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:36","OPEN_FOR_INTERNAL","2020-11-29 16:14:36"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:37","OPEN_FOR_INTERNAL","2020-11-29 16:14:37"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:38","OPEN_FOR_INTERNAL","2020-11-29 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:38","OPEN_FOR_INTERNAL","2020-11-29 16:14:38"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:44","OPEN_FOR_INTERNAL","2020-11-29 16:14:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:44","OPEN_FOR_INTERNAL","2020-11-29 16:14:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:14: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-11-29 16:14:44","OPEN_FOR_INTERNAL","2020-11-29 16:14:44"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:15: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-11-29 16:15:00","OPEN_FOR_INTERNAL","2020-11-29 16:15:00"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:15: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-11-29 16:15:01","OPEN_FOR_INTERNAL","2020-11-29 16:15:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:15: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-11-29 16:15:01","OPEN_FOR_INTERNAL","2020-11-29 16:15:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:15: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-11-29 16:15:01","OPEN_FOR_INTERNAL","2020-11-29 16:15:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:15: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-11-29 16:15:01","OPEN_FOR_INTERNAL","2020-11-29 16:15:01"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:28: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-11-29 16:28:47","OPEN_FOR_INTERNAL","2020-11-29 16:28:47"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:40: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-11-29 16:40:25","OPEN_FOR_INTERNAL","2020-11-29 16:40:25"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 16:40: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-11-29 16:40:57","OPEN_FOR_INTERNAL","2020-11-29 16:40:57"]},"data_before":[],"data_after":[],"step":1} ***** {"created_at":"2020-11-29 19:55: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-11-29 19:55:48","OPEN_FOR_INTERNAL","2020-11-29 19:55:48"]},"data_before":[],"data_after":[],"step":1} *****