From 24360b947a95337a052e20acfbbcf9c1a7e20b17 Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期四, 17 三月 2022 14:21:58 +0800
Subject: [PATCH] 更新账户相关定时任务
---
src/main/java/com/whyc/service/UserService.java | 21 +++++++++++++++++++++
1 files changed, 21 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/UserService.java b/src/main/java/com/whyc/service/UserService.java
index b94852e..ec959ca 100644
--- a/src/main/java/com/whyc/service/UserService.java
+++ b/src/main/java/com/whyc/service/UserService.java
@@ -217,4 +217,25 @@
}
+ public void updateExpiredAccount() {
+ UpdateWrapper<UserInf> wrapper = Wrappers.update();
+ wrapper.set("status",UserConstant.ACCOUNT_STATUS_CANCEL).eq("type",UserConstant.ACCOUNT_TYPE_TEMP).gt("expiration_time",new Date());
+ userMapper.update(null,wrapper);
+ }
+
+ public void unLock() {
+ UpdateWrapper<UserInf> wrapper = Wrappers.update();
+ wrapper.set("status", UserConstant.ACCOUNT_STATUS_ACTIVE.getValue()).set("lock_time",null)
+ .eq("status",UserConstant.ACCOUNT_STATUS_LOCK_FAIL.getValue())
+ .last(" and date_add(lock_time,interval 20 MINUTE)<now() and uId is not null");
+ userMapper.update(null,wrapper);
+ }
+
+ public void updateAccountStatus(int status) {
+ UpdateWrapper<UserInf> wrapper = Wrappers.update();
+ wrapper.set("status", status)
+ .eq("status",UserConstant.ACCOUNT_STATUS_ACTIVE.getValue())
+ .last(" and date_add(last_login_time,interval 3 MONTH)<now() and uId is not null");
+ userMapper.update(null,wrapper);
+ }
}
--
Gitblit v1.9.1