From fc868e56b1e8199d2c4267fae74c44cfa62a777f Mon Sep 17 00:00:00 2001 From: zjh <zjh@888> Date: 星期三, 31 一月 2024 09:13:51 +0800 Subject: [PATCH] zjh 本地 2024/01/31 -1 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java | 9 +++++++++ 1 files changed, 9 insertions(+), 0 deletions(-) diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java index 6c60a6c..6cfa9ed 100644 --- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java +++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java @@ -121,4 +121,13 @@ "on c.pro_parent_id=b.pro_id\n" + ") d\n") List<TjProject> getProBySqlAndName(@Param("proName")String proName,@Param("checkType")String checkType,@Param("deptId")String deptId); + + + + @Select("SELECT * FROM (\n" + + "SELECT * FROM tj_package_project a WHERE a.pac_id=#{pacId} AND a.pro_id IN\n" + + "(\n" + + " SELECT b.pro_id FROM tj_project b WHERE b.pro_parent_id=0 AND b.dept_id='259'\n" + + ")) aa LEFT JOIN tj_project c ON aa.pro_id=c.pro_id ") + List<TjProject> getTjProListByPacIdAndDeptId(String pacId); } -- Gitblit v1.8.0