From 2ebca060a47784db76369a4aa84f63293da9be33 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 16 Jun 2022 10:08:08 +0800
Subject: [PATCH] 保安员新增同步编号问题
---
src/main/java/org/springblade/modules/system/mapper/UserMapper.java | 39 +++++++++++++++++++++++++++++++++++++++
1 files changed, 39 insertions(+), 0 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 a7ee5dc..5a3cabc 100644
--- a/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
+++ b/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
@@ -25,6 +25,7 @@
import org.springblade.modules.system.excel.SecurityExcel;
import org.springblade.modules.system.excel.UserExcel;
import org.springblade.modules.system.entity.User;
+import org.springblade.modules.system.vo.UserDTO;
import org.springblade.modules.system.vo.UserVO;
import org.springframework.boot.autoconfigure.quartz.QuartzDataSource;
@@ -113,4 +114,42 @@
* @return
*/
List selectPeo(@Param("user") UserVO user);
+
+ /**
+ * 查询当前部门名称及父级部门名称
+ * @param deptId 部门名称
+ * @return
+ */
+ @SqlParser(filter = true)
+ List<String> getDeptName(@Param("deptId") String deptId);
+
+ /**
+ * 查询用户年龄
+ * @param id
+ * @return
+ */
+ int getUserAge(@Param("id") long id);
+
+ /**
+ * 查询保安证编号位数
+ * @param pre
+ * @return
+ */
+ Integer getSecurityPaperCount(@Param("pre") String pre);
+
+ /**
+ * 查询保安员信息
+ * @param user
+ * @return
+ */
+ UserDTO getSecurityInfoByIdCardNo(@Param("user")User user);
+
+ /**
+ * 通过 身份证号查询用户信息
+ * @param idCardNo 身份证号
+ * @return
+ */
+ User getUserInfoByIdCardNo(String idCardNo);
+
+ UserVO getUserAgeById(@Param("userId") long id);
}
--
Gitblit v1.9.3