zjh 2024/01/26--1

zjh

2024-01-26 23d2cdbd5060ca8fc24a556225c85f033e10efb3

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjDwGroupingMapper.java

@@ -69,20 +69,20 @@
    public int selectTjDwGroupingBySex(@Param("dwDeptId")String dwDeptId,@Param("sex") String sex);


    @Select("SELECT SUM(b.aa) cc FROM ( SELECT" +
            "CASE WHEN ISNULL( b.sex )" +
            "AND ISNULL( c.pro_name ) THEN 0" +
            "WHEN ! ISNULL( b.sex )" +
            "AND ISNULL( c.pro_name ) THEN 0 ELSE 1" +
            "END" +
            "aa" +
            "FROM" +
            "tj_dw_dept a" +
            "LEFT JOIN tj_dw_grouping b ON a.id = b.dw_dept_id" +
            "LEFT JOIN tj_grouping_pro c ON b.id = c.grouping_id " +
            "WHERE" +
            "a.id =#{dwDeptId}" +
            "GROUP BY" +
    @Select("SELECT SUM(b.aa) cc FROM ( SELECT\n" +
            "            CASE WHEN ISNULL( b.sex )\n" +
            "            AND ISNULL( c.pro_name ) THEN 0\n" +
            "            WHEN !ISNULL( b.sex )\n" +
            "            AND ISNULL(c.pro_name ) THEN 0 ELSE 1\n" +
            "            END\n" +
            "            aa\n" +
            "            FROM\n" +
            "            tj_dw_dept a\n" +
            "            LEFT JOIN tj_dw_grouping b ON a.id = b.dw_dept_id\n" +
            "            LEFT JOIN tj_grouping_pro c ON b.id = c.grouping_id\n" +
            "            WHERE\n" +
            "            a.id =#{dwDeptId} \n" +
            "            GROUP BY\n" +
            "b.sex)b")
    public int selectTjDwGroupingByDwDeptId(String dwDeptId);
}