From 0bf868d3cdf9226e178c076d3b588ed5207409a0 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: 星期五, 24 十一月 2023 17:51:40 +0800
Subject: [PATCH] merge

---
 assess-system/src/main/java/com/gkhy/assess/system/mapper/SysUserMapper.java |  111 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 111 insertions(+), 0 deletions(-)

diff --git a/assess-system/src/main/java/com/gkhy/assess/system/mapper/SysUserMapper.java b/assess-system/src/main/java/com/gkhy/assess/system/mapper/SysUserMapper.java
new file mode 100644
index 0000000..c1c4083
--- /dev/null
+++ b/assess-system/src/main/java/com/gkhy/assess/system/mapper/SysUserMapper.java
@@ -0,0 +1,111 @@
+package com.gkhy.assess.system.mapper;
+
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.gkhy.assess.system.domain.SysUser;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+
+/**
+ * <p>
+ * 用户表 Mapper 接口
+ * </p>
+ *
+ * @author kzy
+ * @since 2023-10-17 14:26:29
+ */
+@Mapper
+public interface SysUserMapper extends BaseMapper<SysUser> {
+    /**
+     * 根据登录名获取用户
+     * @param username
+     * @return
+     */
+    public SysUser getUserByUsername(String username);
+
+    /**
+     * 根据登录名或者手机号获取用户
+     * @param username
+     * @return
+     */
+    public SysUser getUserByUsernamePhone(String username);
+
+    /**
+     * 获取监管用户列表
+     * @param user
+     * @return
+     */
+    List<SysUser> monitorList(SysUser user);
+
+    /**
+     * 获取机构用户列表
+     * @param user
+     * @return
+     */
+    List<SysUser> agencyList(SysUser user);
+
+    /**
+     * 获取专家用户列表
+     * @param user
+     * @return
+     */
+    List<SysUser> expertList(SysUser user);
+
+    /**
+     * 根据手机号获取用户
+     * @param phone
+     * @return
+     */
+    public SysUser getUserByPhone(String phone);
+
+    /**
+     * 根据email获取用户
+     * @param email
+     * @return
+     */
+    public SysUser getUserByEmail(String email);
+
+    /**
+     * 根据用户id获取用户
+     * @param userId
+     * @return
+     */
+    public SysUser getUserById(Long userId);
+
+    /**
+     * 删除用户
+     * @param userId
+     * @return
+     */
+    public int deleteUserById(Long userId);
+
+    /**
+     * 批量删除用户
+     * @param userIds
+     * @return
+     */
+    public int deleteUserByIds(Long[] userIds);
+
+    /**
+     * 校验用户名称是否唯一
+     * @param username
+     * @return
+     */
+    SysUser checkLoginNameUnique(String username);
+
+    /**
+     * 校验手机号是否唯一
+     * @param phone
+     * @return
+     */
+    SysUser checkPhoneUnique(String phone);
+
+    /**
+     * 校验邮箱是否唯一
+     * @param email
+     * @return
+     */
+    SysUser checkEmailUnique(String email);
+
+}

--
Gitblit v1.9.2