From f934309e1f07ea68e975bfd5c9d4fb06762f0dfc Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期二, 15 十月 2024 16:17:51 +0800 Subject: [PATCH] zjh20241015修改采样数据添加逻辑 --- ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java | 10 ++++++++++ 1 files changed, 10 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..61566d0 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,14 @@ 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(); } -- Gitblit v1.8.0