1.统计接口编写

tangzy

2021-08-14 f55acbda1a161a342866500e85aba8969e40ce21

1.统计接口编写

 src/main/java/org/springblade/modules/information/mapper/InformationMapper.xml

@@ -65,7 +65,8 @@
        SELECT IFNULL(B.confess, 0)  AS confess,
               IFNULL(C.staff, 0)    AS staff,
               IFNULL(D.security, 0) AS security,
               IFNULL(E.armed, 0)    AS armed
               IFNULL(E.armed, 0)    AS armed,
               IFNULL(F.region, 0)    AS region
        FROM (SELECT jurisdiction FROM sys_information GROUP BY jurisdiction) A
                 LEFT JOIN (SELECT COUNT(stats) AS confess, jurisdiction
                            FROM sys_information
@@ -83,6 +84,10 @@
                            FROM sys_information
                            WHERE stats = 3
                            GROUP BY jurisdiction) E ON A.jurisdiction = E.jurisdiction
                 LEFT JOIN (SELECT COUNT(stats) AS region, jurisdiction
                            FROM sys_information
                            WHERE stats = 4
                            GROUP BY jurisdiction) F ON A.jurisdiction = E.jurisdiction
        WHERE A.jurisdiction = #{departmentid}
    </select>