From 30df94c05573a426d030510d4dd58ae1d93bfb7a Mon Sep 17 00:00:00 2001
From: tangzy <tangzy123456>
Date: Mon, 06 Dec 2021 14:03:37 +0800
Subject: [PATCH] 1.资格审查排序
---
src/main/java/org/springblade/modules/system/mapper/UserMapper.java | 48 ++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 46 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 43fc080..a2dbe5e 100644
--- a/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
+++ b/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
@@ -16,14 +16,19 @@
*/
package org.springblade.modules.system.mapper;
+import com.baomidou.mybatisplus.annotation.KeySequence;
+import com.baomidou.mybatisplus.annotation.SqlParser;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.springblade.modules.system.excel.UserExcel;
import org.springblade.modules.system.entity.User;
+import org.springblade.modules.system.vo.UserVO;
+import org.springframework.boot.autoconfigure.quartz.QuartzDataSource;
import java.util.List;
+import java.util.Map;
/**
* Mapper 接口
@@ -61,10 +66,49 @@
*/
List<UserExcel> exportUser(@Param("ew") Wrapper<User> queryWrapper);
- void updateUser(String hold,String cardid);
+ void updateUser(String hold,String cardid,String holdv,String time);
/**
* 自定义用户列表(只有保安员)
*/
- List<User> selectUserPageSecurity(IPage<User> page, @Param("user") User user, @Param("deptIdList") List<Long> deptIdList, @Param("tenantId") String tenantId);
+ @SqlParser(filter = true)
+ List<UserVO> selectUserPageSecurity(IPage<UserVO> page, @Param("user") UserVO user);
+
+ /**
+ * 查询所有未注销用户
+ * @return
+ */
+ List<User> getAllUserList();
+
+ /**
+ * 查询用户数据,未删除的,未审核的
+ * @return
+ */
+ List<User> getNotAuditAllUserList();
+
+ /**
+ * 自定义列表，...
+ * @param page
+ * @param user
+ * @return
+ */
+ List<User> selectUserPages(IPage<User> page,@Param("user") User user);
+
+ /**
+ * 根据保安员编码查询保安员信息
+ * @param securityNumber
+ * @return
+ */
+ UserVO getUserInfoBySecurityNumber(@Param("securityNumber") String securityNumber);
+
+
+ /**
+ * 通过 身份证号查询用户信息
+ * @param idCardNo 身份证号
+ * @return
+ */
+ User getUserInfoByIdCardNo(String idCardNo);
+
+
+ List selectPeo(@Param("user") UserVO user);
}
--
Gitblit v1.9.3