From cbb51be06db9560ffaca9cd42d1f2d92b4ed3f37 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Fri, 15 Dec 2023 13:47:19 +0800
Subject: [PATCH] 添加打卡距离

---
 src/main/java/org/springblade/modules/system/mapper/UserMapper.java |   92 ++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 89 insertions(+), 3 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 61637ce..2dc90e2 100644
--- a/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
+++ b/src/main/java/org/springblade/modules/system/mapper/UserMapper.java
@@ -23,10 +23,12 @@
 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;
 import org.springblade.modules.system.node.TreeNode;
+import org.springblade.modules.system.vo.UserInfoDetail;
 import org.springblade.modules.system.vo.UserVO;
 
 import java.util.List;
@@ -46,7 +48,18 @@
 	 * @param user
 	 * @return
 	 */
+	@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);
 
 
 	/**
@@ -102,9 +115,8 @@
 	 * @param user 用户信息
 	 * @return
 	 */
-	@MapKey(value = "id")
 	@SqlParser(filter=true)
-	Map<Long, TreeNode> getSecurityApplyTree(@Param("user") UserVO user);
+	List<TreeNode> getSecurityApplyTree(@Param("user") UserVO user);
 
 
 	/**
@@ -175,7 +187,7 @@
 	 * @param securityNumber 保安证编码
 	 * @return
 	 */
-    UserVO getUserInfoBySecurityNumber(@Param("securityNumber") String securityNumber);
+    UserVO getUserInfoBySecurityNumber(@Param("securityNumber") String securityNumber,@Param("cardid") String cardid);
 
 	/**
 	 * 保安员信息
@@ -234,4 +246,78 @@
 	 * @return
 	 */
 	DispatcherVO getUserDispatcherInfo(Long id);
+
+	/**
+	 * 用户批量导入
+	 * @param userList
+	 */
+    void batchUserList(@Param("list") List<User> userList);
+
+	/**
+	 * 从业记录批量导入
+	 * @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 tenantId
+	 * @param phone
+	 * @return
+	 */
+	User getUserByPhone(@Param("tenantId")String tenantId,@Param("phone") String phone);
+
+	/**
+	 * 按天查询 day 天未登录的人员ids集合信息
+	 * @param day
+	 * @return
+	 */
+    List<String> getMoreDayNotLoginUser(@Param("day")int day);
+
+	/**
+	 * 用户冻结操作
+	 * @param userIds
+	 */
+	void updateFreeze(@Param("list") List<String> userIds);
+
+	/**
+	 * 用户注销操作
+	 * @param userIds
+	 */
+	void updateLogout(@Param("list") List<String> userIds);
+
+	/**
+	 * 判断是否报名
+	 * @param id
+	 * @return
+	 */
+	User getUserIsApply(@Param("id") Long id);
+
+	/**
+	 * 自定义查询详情信息
+	 * @param id
+	 * @return
+	 */
+    UserVO getUserDetailById(@Param("id") Long id);
+
+	/**
+	 * 查询未关联的保安员
+	 * @return
+	 */
+	List<User> getNotGlList();
+
+	UserInfoDetail getUserInfoDetail(@Param("id") String id);
 }

--
Gitblit v1.9.3