zjh 本地 2024/01/30 -1

zjh

2024-01-30 8cf225a3c519b49a2f62f4b627cec4002348082d

 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);
}