From 8b375fe00a241b3a769b82fe3dac8d1c9dce8a02 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Thu, 16 Jun 2022 14:36:07 +0800
Subject: [PATCH] 模拟考试修改
---
src/main/java/org/springblade/modules/system/mapper/UserMapper.java | 43 +++++++++++++++++++++++++++++++++++++++++--
1 files changed, 41 insertions(+), 2 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 f0526e8..06d23ff 100644
--- a/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
+++ b/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
@@ -24,6 +24,7 @@
import org.apache.ibatis.annotations.Param;
import org.springblade.modules.dispatcher.vo.DispatcherVO;
import org.springblade.modules.experience.entity.Experience;
+import org.springblade.modules.system.excel.ExportSecurityExcel;
import org.springblade.modules.system.excel.SecurityExcel;
import org.springblade.modules.system.excel.UserExcel;
import org.springblade.modules.system.entity.User;
@@ -49,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 +188,7 @@
* @param securityNumber 保安证编码
* @return
*/
- UserVO getUserInfoBySecurityNumber(@Param("securityNumber") String securityNumber);
+ UserVO getUserInfoBySecurityNumber(@Param("securityNumber") String securityNumber,@Param("cardid") String cardid);
/**
* 保安员信息
@@ -223,7 +234,7 @@
* @param user
* @return
*/
- List<SecurityExcel> exportSecurityInfo(@Param("user") UserVO user);
+ List<ExportSecurityExcel> exportSecurityInfo(@Param("user") UserVO user);
/**
* 查询押运人员编码不为null的保安信息
* @return
@@ -248,4 +259,32 @@
* @param experienceList
*/
void batchExperienceList(@Param("list") List<Experience> experienceList);
+
+ /**
+ * 年龄分布查询
+ * @return
+ */
+ List<Integer> getAgeStatistics(@Param("user") UserVO user);
+
+ /**
+ * 根据用户 id 查询用户信息
+ * @param id
+ * @return
+ */
+ User getUserById(long id);
+
+ /**
+ * 手动新增用户信息
+ * @param user
+ * @return
+ */
+ int insertUser(@Param("user") User user);
+
+ /**
+ * 批量更新用户信息
+ * @param updateList
+ * @return
+ */
+ @SqlParser(filter = true)
+ void batchUpdateUserList(@Param("list") List<User> updateList);
}
--
Gitblit v1.9.3