From 0892d843cd394f383ff50f480f7f22f2ec3829bc Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期五, 27 六月 2025 20:24:45 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java | 15 +++++++++++++++ 1 files changed, 15 insertions(+), 0 deletions(-) diff --git a/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java b/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java index 9740b24..70b0f8d 100644 --- a/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java +++ b/ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java @@ -145,4 +145,19 @@ List<List<?>> getSysDeptHyAndYxYjWjCustomerList13(Map<String,Object> map); List<ResultSet> getSysDeptYjWjCustomerList2(Map<String,Object> map); + + + @Select("SELECT a.dept_id FROM sys_dept a WHERE a.deleted=0 AND a.`status`=0 AND a.org_type=1") + List<String> getJyDeptIds(); + + @Select("SELECT a.dept_id FROM sys_dept a WHERE a.deleted=0 AND a.`status`=0 AND a.org_type=2") + List<String> getJcDeptIds(); + + @Select("SELECT a.dept_id FROM sys_dept a WHERE a.deleted=0 AND a.`status`=0 AND a.org_type=3") + List<String> getCzDeptIds(); + + @Select("SELECT e.dept_name FROM sys_dept e WHERE e.dept_id=#{deptId}") + String getprentks(String deptId); + + List<Long> getDeptTreeById(@Param("deptId") String deptId); } -- Gitblit v1.8.0