From 826d7a2d241c24a1ef47fe0e69533a18b3464bc2 Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期五, 04 七月 2025 21:16:46 +0800
Subject: [PATCH] art:技术状态鉴定工单变更-数据库设计

---
 lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/SysUserMapper.java |   46 +++++++++++++++++++++++++++++++++++++++++-----
 1 files changed, 41 insertions(+), 5 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
index 4bbaf0a..a00919a 100644
--- 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
@@ -8,6 +8,7 @@
 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.EamUserRepDepVo;
 import org.jeecg.modules.system.vo.MdcUserProVo;
 import org.jeecg.modules.system.vo.SysUserDepVo;
 
@@ -62,22 +63,30 @@
 	 * @return
 	 */
 	IPage<SysUser> getUserByRoleId(Page page, @Param("roleId") String roleId, @Param("username") String username);
-	
+
+	/**
+	 * 鏍规嵁璁惧杞﹂棿绠$悊Id鏌ヨ
+	 * @param page
+	 * @param workShopDepartId 璁惧杞﹂棿绠$悊Id
+	 * @return
+	 */
+	IPage<SysUser> getUserByWorkShopDepartId(Page page, @Param("baseFactoryId") String baseFactoryId, @Param("username") String username);
+
 	/**
 	 * 鏍规嵁鐢ㄦ埛鍚嶈缃儴闂↖D
 	 * @param username
 	 * @param orgCode
 	 */
 	void updateUserDepart(@Param("username") String username,@Param("orgCode") String orgCode);
-	
+
 	/**
 	 * 鏍规嵁鎵嬫満鍙锋煡璇㈢敤鎴蜂俊鎭�
 	 * @param phone
 	 * @return
 	 */
 	public SysUser getUserByPhone(@Param("phone") String phone);
-	
-	
+
+
 	/**
 	 * 鏍规嵁閭鏌ヨ鐢ㄦ埛淇℃伅
 	 * @param email
@@ -150,7 +159,7 @@
      */
     @Deprecated
     int updateNullByEmptyString(@Param("fieldName") String fieldName);
-    
+
 	/**
 	 *  鏍规嵁閮ㄩ棬Ids,鏌ヨ閮ㄩ棬涓嬬敤鎴蜂俊鎭�
 	 * @param departIds
@@ -163,4 +172,31 @@
 	 * 鏍规嵁鐢ㄦ埛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);
+
+	List<SysUser> getUserByRoleCodeList(@Param("roleCodeList") List<String> roleCodeList);
+
+	/**
+	 * 鏍规嵁鐢ㄦ埛Ids,鏌ヨ鐢ㄦ埛鎵�灞炵淮淇儴闂ㄥ悕绉颁俊鎭�
+	 */
+	List<EamUserRepDepVo> getRepDepNamesByUserIds(@Param("userIds") List<String> userIds);
 }

--
Gitblit v1.9.3