From 7b291d619aa70e5bb33f2b1caabe7f4b0bd003d9 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Fri, 10 Jun 2022 17:28:15 +0800
Subject: [PATCH] 制证数据更新
---
src/main/java/org/springblade/modules/system/mapper/UserMapper.java | 30 ++++++++++++++++++++++++++++++
1 files changed, 30 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..8bdf9ce 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,33 @@
* @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);
}
--
Gitblit v1.9.3