From 8853292babb2ad94de4a3207966f1e83b767cd2d Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Sun, 17 Sep 2023 16:38:34 +0800
Subject: [PATCH] 新增流程节点进程查询接口
---
src/main/java/org/springblade/modules/system/mapper/UserMapper.java | 51 ++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 50 insertions(+), 1 deletions(-)
diff --git a/src/main/java/org/springblade/modules/system/mapper/UserMapper.java b/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
index 9db23a7..492f1a1 100644
--- a/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
+++ b/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
@@ -50,6 +50,16 @@
@SqlParser(filter = true)
List<UserVO> selectUserPages(IPage<UserVO> page, @Param("user") UserVO user);
+ /**
+ * 自定义分页,带坐标
+ *
+ * @param page
+ * @param user
+ * @return
+ */
+ @SqlParser(filter = true)
+ List<UserVO> selectUserPagesByAge(IPage<UserVO> page, @Param("user") UserVO user);
+
/**
* 自定义分页
@@ -177,7 +187,7 @@
* @param securityNumber 保安证编码
* @return
*/
- UserVO getUserInfoBySecurityNumber(@Param("securityNumber") String securityNumber);
+ UserVO getUserInfoBySecurityNumber(@Param("securityNumber") String securityNumber,@Param("cardid") String cardid);
/**
* 保安员信息
@@ -249,5 +259,44 @@
*/
void batchExperienceList(@Param("list") List<Experience> experienceList);
+ /**
+ * 年龄分布查询
+ * @return
+ */
+ List<Integer> getAgeStatistics(@Param("user") UserVO user);
+
+ /**
+ * 根据用户 id 查询用户信息
+ * @param id
+ * @return
+ */
+ User getUserById(long id);
+
+ /**
+ * 根据手机号获取用户信息
+ * @param tenantId
+ * @param phone
+ * @return
+ */
+ User getUserByPhone(@Param("tenantId")String tenantId,@Param("phone") String phone);
+
+ /**
+ * 按天查询 day 天未登录的人员ids集合信息
+ * @param day
+ * @return
+ */
+ List<String> getMoreDayNotLoginUser(@Param("day")int day);
+
+ /**
+ * 用户冻结操作
+ * @param userIds
+ */
+ void updateFreeze(@Param("list") List<String> userIds);
+
+ /**
+ * 用户注销操作
+ * @param userIds
+ */
+ void updateLogout(@Param("list") List<String> userIds);
}
--
Gitblit v1.9.3