From 2c785c3d4513daea9deb5c7edbb17a9f17111d25 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 21 二月 2025 17:49:03 +0800
Subject: [PATCH] zjh20250221
---
ltkj-system/src/main/java/com/ltkj/system/mapper/SysDeptMapper.java | 18 ++++++++++++++++++
1 files changed, 18 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 065cbc3..4dac7d2 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
@@ -30,6 +30,9 @@
@Select("SELECT * FROM v_tj_deptpro")
public List<SysDept> selectDeptTreeList1();
+ @Select("SELECT * FROM v_dept_template")
+ public List<SysDept> selectDeptTreeList11();
+
/**
* 鏍规嵁瑙掕壊ID鏌ヨ閮ㄩ棬鏍戜俊鎭�
*
@@ -139,5 +142,20 @@
List<List<?>> getSysDeptYjWjCustomerList13(Map<String,Object> map);
+ 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);
}
--
Gitblit v1.8.0