From 8d43111bd0e598bc0b2014cbfa69a32e74959dff Mon Sep 17 00:00:00 2001
From: Administrator <admin>
Date: Wed, 15 Dec 2021 19:24:05 +0800
Subject: [PATCH] ftp sql 同步封装

---
 src/main/java/org/springblade/modules/system/service/IUserService.java |   96 ++++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 92 insertions(+), 4 deletions(-)

diff --git a/src/main/java/org/springblade/modules/system/service/IUserService.java b/src/main/java/org/springblade/modules/system/service/IUserService.java
index 75d7b26..0a13cb1 100644
--- a/src/main/java/org/springblade/modules/system/service/IUserService.java
+++ b/src/main/java/org/springblade/modules/system/service/IUserService.java
@@ -17,15 +17,16 @@
 package org.springblade.modules.system.service;
 
 
-import com.baomidou.mybatisplus.core.conditions.Wrapper;
 import com.baomidou.mybatisplus.core.metadata.IPage;
-import org.apache.ibatis.annotations.Param;
 import org.springblade.core.mp.base.BaseService;
 import org.springblade.core.mp.support.Query;
 import org.springblade.modules.auth.enums.UserEnum;
 import org.springblade.modules.system.entity.User;
 import org.springblade.modules.system.entity.UserInfo;
 import org.springblade.modules.system.entity.UserOauth;
+import org.springblade.modules.system.excel.QrCodeExcel;
+import org.springblade.modules.system.excel.SecurityExcel;
+import org.springblade.modules.system.excel.SecurityYyExcel;
 import org.springblade.modules.system.excel.UserExcel;
 import org.springblade.modules.system.node.TreeNode;
 import org.springblade.modules.system.vo.UserVO;
@@ -82,7 +83,7 @@
 	 * @param tenantId
 	 * @return
 	 */
-	IPage<User> selectUserPage(IPage<User> page, User user, Long deptId, String tenantId);
+	IPage<UserVO> selectUserPage(IPage<UserVO> page, User user, Long deptId, String tenantId);
 
 	/**
 	 * 自定义分页
@@ -182,7 +183,7 @@
 	 * @param isCovered
 	 * @return
 	 */
-	void importUser(List<UserExcel> data, Boolean isCovered);
+	void importUser(List<UserExcel> data, Boolean isCovered,String deptId);
 
 	/**
 	 * 导出用户数据
@@ -252,6 +253,13 @@
 	 */
 	List<TreeNode> getSecurityApplyTree(UserVO user);
 
+	/**
+	 * 保安员列表树 安员列表树，帅选无保安证,下拉tree
+	 * @param user 用户信息
+	 * @return
+	 */
+	List<TreeNode> getSecurityDispatcherTree(UserVO user);
+
 	List<Map<Object,Object>> selectInr(String deptid);
 
 
@@ -277,4 +285,84 @@
 	UserVO getUserAgeById(Long userId);
 
 	List<Map<String, Object>> selectUser();
+
+	/**
+	 * 导入保安员
+	 * @param data
+	 * @param isCovered
+	 */
+	void importSecurity(List<SecurityExcel> data, Boolean isCovered, String deptId);
+
+	/**
+	 * 押运人员导入
+	 * @param data
+	 * @param isCovered
+	 * @param deptId
+	 */
+	void importSecurityYy(List<SecurityYyExcel> data, Boolean isCovered, String deptId);
+
+	/**
+	 * 根据保安员编码查询保安信息
+	 * @param securityNumber 保安证编码
+	 * @return
+	 */
+    UserVO getUserInfoBySecurityNumber(String securityNumber);
+
+	/**
+	 * 保安员信息
+	 * @param user
+	 * @return
+	 */
+    UserVO getUserDetails(User user);
+	List<Map<String, Object>> seleL(String type,String deptid,String jurisdiction,Long userId);
+
+	/**
+	 * 查询账号相同的用户数量
+	 * @param account
+	 * @return
+	 */
+	Integer selectCount(String account);
+
+	/**
+	 * 查询用户表中未删除，未离职的用户信息
+	 * @param username
+	 * @return
+	 */
+	User getUserInfo(String username);
+
+	/**
+	 * 生成二维码
+	 * @param data
+	 * @param isCovered
+	 * @param deptId
+	 */
+	void importQrCode(List<QrCodeExcel> data, Boolean isCovered, String deptId);
+
+
+	/**
+	 * 根据用户账户查询用户是否存在
+	 * @param account
+	 * @return
+	 */
+	Integer selectCountAccount(String account);
+
+	/**
+	 * 保安员信息导出
+	 * @param user
+	 * @return
+	 */
+    List<SecurityExcel> exportSecurityInfo(UserVO user);
+
+	/**
+	 * 导入保安员test
+	 * @param data
+	 * @param isCovered
+	 * @param deptId
+	 */
+	void importSecurityTest(List<SecurityExcel> data, Boolean isCovered, String deptId);
+	/**
+	 * 查询押运人员编码不为null的保安信息
+	 * @return
+	 */
+	List<Map<String, Object>> selectEquipent();
 }

--
Gitblit v1.9.3