From b7a2bc7c7306d6a76b491dc03f21f315539c75b6 Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Mon, 20 Dec 2021 19:42:53 +0800
Subject: [PATCH] 成绩查询修改,排序

---
 src/main/java/org/springblade/modules/system/mapper/UserMapper.java |   26 ++++++++++++++++++++++++++
 1 files changed, 26 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 15166d4..f0526e8 100644
--- a/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
+++ b/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
@@ -23,6 +23,7 @@
 import org.apache.ibatis.annotations.MapKey;
 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.SecurityExcel;
 import org.springblade.modules.system.excel.UserExcel;
 import org.springblade.modules.system.entity.User;
@@ -46,6 +47,7 @@
 	 * @param user
 	 * @return
 	 */
+	@SqlParser(filter = true)
 	List<UserVO> selectUserPages(IPage<UserVO> page, @Param("user") UserVO user);
 
 
@@ -222,4 +224,28 @@
 	 * @return
 	 */
 	List<SecurityExcel> exportSecurityInfo(@Param("user") UserVO user);
+	/**
+	 * 查询押运人员编码不为null的保安信息
+	 * @return
+	 */
+	List<Map<String, Object>> selectEquipent();
+
+	/**
+	 * 查詢派遣信息
+	 * @param id 用戶id
+	 * @return
+	 */
+	DispatcherVO getUserDispatcherInfo(Long id);
+
+	/**
+	 * 用户批量导入
+	 * @param userList
+	 */
+    void batchUserList(@Param("list") List<User> userList);
+
+	/**
+	 * 从业记录批量导入
+	 * @param experienceList
+	 */
+	void batchExperienceList(@Param("list") List<Experience> experienceList);
 }

--
Gitblit v1.9.3