From 23855599412c4d61b38d78f0f3abd3430a48b5b1 Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期三, 25 六月 2025 11:51:38 +0800
Subject: [PATCH] Merge branch 'mdc_hyjs_master'
---
lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserMapper.java | 191 +++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 191 insertions(+), 0 deletions(-)
diff --git a/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserMapper.java b/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserMapper.java
new file mode 100644
index 0000000..3200bfe
--- /dev/null
+++ b/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserMapper.java
@@ -0,0 +1,191 @@
+package org.jeecg.modules.system.mapper;
+
+import com.baomidou.mybatisplus.core.conditions.Wrapper;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.core.toolkit.Constants;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
+import org.apache.ibatis.annotations.Param;
+import org.jeecg.modules.system.entity.SysUser;
+import org.jeecg.modules.system.model.SysUserSysDepartModel;
+import org.jeecg.modules.system.vo.MdcUserProVo;
+import org.jeecg.modules.system.vo.SysUserDepVo;
+
+import java.util.List;
+
+/**
+ * <p>
+ * 鐢ㄦ埛琛� Mapper 鎺ュ彛
+ * </p>
+ *
+ * @Author scott
+ * @since 2018-12-20
+ */
+public interface SysUserMapper extends BaseMapper<SysUser> {
+ /**
+ * 閫氳繃鐢ㄦ埛璐﹀彿鏌ヨ鐢ㄦ埛淇℃伅
+ * @param username
+ * @return
+ */
+ SysUser getUserByName(@Param("username") String username);
+
+ /**
+ * 鏍规嵁閮ㄩ棬Id鏌ヨ鐢ㄦ埛淇℃伅
+ * @param page
+ * @param departId
+ * @param username 鐢ㄦ埛鐧诲綍璐︽埛
+ * @return
+ */
+ IPage<SysUser> getUserByDepId(Page page, @Param("departId") String departId, @Param("username") String username);
+
+ /**
+ * 鏍规嵁鐢ㄦ埛Ids,鏌ヨ鐢ㄦ埛鎵�灞為儴闂ㄥ悕绉颁俊鎭�
+ * @param userIds
+ * @return
+ */
+ List<SysUserDepVo> getDepNamesByUserIds(@Param("userIds")List<String> userIds);
+
+ /**
+ * 鏍规嵁閮ㄩ棬Ids,鏌ヨ閮ㄩ棬涓嬬敤鎴蜂俊鎭�
+ * @param page
+ * @param departIds
+ * @param username 鐢ㄦ埛鐧诲綍璐︽埛
+ * @return
+ */
+ IPage<SysUser> getUserByDepIds(Page page, @Param("departIds") List<String> departIds, @Param("username") String username);
+
+ /**
+ * 鏍规嵁瑙掕壊Id鏌ヨ鐢ㄦ埛淇℃伅
+ * @param page
+ * @param roleId 瑙掕壊id
+ * @param username 鐢ㄦ埛鐧诲綍璐︽埛
+ * @return
+ */
+ IPage<SysUser> getUserByRoleId(Page page, @Param("roleId") String roleId, @Param("username") String username);
+
+ /**
+ * 鏍规嵁鐢ㄦ埛鍚嶈缃儴闂↖D
+ * @param username
+ * @param orgCode
+ */
+ void updateUserDepart(@Param("username") String username,@Param("orgCode") String orgCode);
+
+ /**
+ * 鏍规嵁鎵嬫満鍙锋煡璇㈢敤鎴蜂俊鎭�
+ * @param phone
+ * @return
+ */
+ SysUser getUserByPhone(@Param("phone") String phone);
+
+
+ /**
+ * 鏍规嵁閭鏌ヨ鐢ㄦ埛淇℃伅
+ * @param email
+ * @return
+ */
+ SysUser getUserByEmail(@Param("email") String email);
+
+ /**
+ * 鏍规嵁 orgCode 鏌ヨ鐢ㄦ埛锛屽寘鎷瓙閮ㄩ棬涓嬬殑鐢ㄦ埛
+ *
+ * @param page 鍒嗛〉瀵硅薄, xml涓彲浠ヤ粠閲岄潰杩涜鍙栧��,浼犻�掑弬鏁� Page 鍗宠嚜鍔ㄥ垎椤�,蹇呴』鏀惧湪绗竴浣�(浣犲彲浠ョ户鎵縋age瀹炵幇鑷繁鐨勫垎椤靛璞�)
+ * @param orgCode
+ * @param userParams 鐢ㄦ埛鏌ヨ鏉′欢锛屽彲涓虹┖
+ * @return
+ */
+ List<SysUserSysDepartModel> getUserByOrgCode(IPage page, @Param("orgCode") String orgCode, @Param("userParams") SysUser userParams);
+
+
+ /**
+ * 鏌ヨ getUserByOrgCode 鐨凾otal
+ *
+ * @param orgCode
+ * @param userParams 鐢ㄦ埛鏌ヨ鏉′欢锛屽彲涓虹┖
+ * @return
+ */
+ Integer getUserByOrgCodeTotal(@Param("orgCode") String orgCode, @Param("userParams") SysUser userParams);
+
+ /**
+ * 鎵归噺鍒犻櫎瑙掕壊涓庣敤鎴峰叧绯�
+ * @Author scott
+ * @Date 2019/12/13 16:10
+ * @param roleIdArray
+ */
+ void deleteBathRoleUserRelation(@Param("roleIdArray") String[] roleIdArray);
+
+ /**
+ * 鎵归噺鍒犻櫎瑙掕壊涓庢潈闄愬叧绯�
+ * @Author scott
+ * @Date 2019/12/13 16:10
+ * @param roleIdArray
+ */
+ void deleteBathRolePermissionRelation(@Param("roleIdArray") String[] roleIdArray);
+
+ /**
+ * 鏌ヨ琚�昏緫鍒犻櫎鐨勭敤鎴�
+ * @param wrapper
+ * @return List<SysUser>
+ */
+ List<SysUser> selectLogicDeleted(@Param(Constants.WRAPPER) Wrapper<SysUser> wrapper);
+
+ /**
+ * 杩樺師琚�昏緫鍒犻櫎鐨勭敤鎴�
+ * @param userIds 鐢ㄦ埛id
+ * @param entity
+ * @return int
+ */
+ int revertLogicDeleted(@Param("userIds") List<String> userIds, @Param("entity") SysUser entity);
+
+ /**
+ * 褰诲簳鍒犻櫎琚�昏緫鍒犻櫎鐨勭敤鎴�
+ * @param userIds 澶氫釜鐢ㄦ埛id
+ * @return int
+ */
+ int deleteLogicDeleted(@Param("userIds") List<String> userIds);
+
+ /**
+ * 鏇存柊绌哄瓧绗︿覆涓簄ull銆愭鍐欐硶鏈塻ql娉ㄥ叆椋庨櫓锛岀姝㈤殢渚跨敤銆�
+ * @param fieldName
+ * @return int
+ */
+ @Deprecated
+ int updateNullByEmptyString(@Param("fieldName") String fieldName);
+
+ /**
+ * 鏍规嵁閮ㄩ棬Ids,鏌ヨ閮ㄩ棬涓嬬敤鎴蜂俊鎭�
+ * @param departIds
+ * @param username 鐢ㄦ埛璐︽埛鍚嶇О
+ * @return
+ */
+ List<SysUser> queryByDepIds(@Param("departIds")List<String> departIds,@Param("username") String username);
+
+ /**
+ * 鏍规嵁鐢ㄦ埛Ids,鏌ヨ鐢ㄦ埛鎵�灞炰骇绾垮悕绉颁俊鎭�
+ */
+ List<MdcUserProVo> getProNamesByUserIds(@Param("userIds") List<String> userIds);
+
+ /**
+ * 鏍规嵁瑙掕壊Id鏌ヨ璇ヨ鑹蹭笅鐨勬墍鏈夌敤鎴蜂俊鎭�
+ *
+ * @param
+ * @return
+ */
+ List<SysUser> getAllUsersByRoleId(@Param("roleId") String roleId);
+
+
+
+ /**
+ * 鏍规嵁瑙掕壊缂栫爜鏌ヨ鐢ㄦ埛id闆嗗悎
+ */
+ List<String> getUserByRoleCode(@Param("roleCode") String roleCode);
+
+ /**
+ * 鏍规嵁瑙掕壊缂栫爜鍜岃澶囩紪鍙锋煡璇㈢敤鎴�
+ */
+ List<SysUser> getEquipmentAdmin(@Param("roleCode") String roleCode, @Param("equipmentId") String equipmentId);
+
+ /** 鏍规嵁鐢ㄦ埛鍚嶆壒閲忔煡璇�
+ * @param userNames 鐢ㄦ埛鍚嶅垪琛紙闇�纭繚闈炵┖锛�
+ */
+ List<SysUser> selectUsersByNames(@Param("userNames") List<String> userNames);
+}
--
Gitblit v1.9.3