人大修改

puhanshu

2022-06-09 dba27fcf4714a1f4153621c610a9342c60b47c77

人大修改

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/bigscreen/BaseInfo.java

@@ -26,5 +26,7 @@
    private Integer volunteer;
    @ApiModelProperty("党组织")
    private Integer partyOrg;
    @ApiModelProperty("人大代表")
    private Integer dpcNum;
}


 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngPopulationDOMapper.xml

@@ -1118,13 +1118,14 @@

    <select id="baseInfo" resultType="com.panzhihua.common.model.vos.community.bigscreen.BaseInfo">
        select count(id) as population,
               IFNULL((select count(id) from com_mng_population_house where community_id = ${communityId}),0) as house,
               IFNULL((select count(id) from com_mng_real_company where community_id = ${communityId}),0) as company,
               IFNULL((select count(DISTINCT `name`) from com_mng_village where community_id = ${communityId}),0) as village,
               IFNULL((select count(user_id) from sys_user where community_id = ${communityId} and type=1),0) as user,
                        IFNULL((select count(id) from com_pb_member where community_id = ${communityId} and audit_result =1 ),0) as partyMember,
                        IFNULL((select count(id) from com_mng_volunteer_mng where community_id = ${communityId} and state=2 ),0) as volunteer,
                        IFNULL((select count(id) from com_pb_org where community_id = ${communityId} and parent_id = 0),0) as partyOrg
            IFNULL((select count(id) from com_mng_population_house where community_id = ${communityId}),0) as house,
            IFNULL((select count(id) from com_mng_real_company where community_id = ${communityId}),0) as company,
            IFNULL((select count(DISTINCT `name`) from com_mng_village where community_id = ${communityId}),0) as village,
            IFNULL((select count(user_id) from sys_user where community_id = ${communityId} and type=1),0) as user,
            IFNULL((select count(id) from com_pb_member where community_id = ${communityId} and audit_result =1 ),0) as partyMember,
            IFNULL((select count(id) from com_mng_volunteer_mng where community_id = ${communityId} and state=2 ),0) as volunteer,
            IFNULL((select count(id) from com_pb_org where community_id = ${communityId} and parent_id = 0),0) as partyOrg,
            IFNULL((select count(id) from com_act_dpc where community_id = ${communityId} AND is_del = 0),0) as dpcNum
        from com_mng_population_community_tags AS cmpct
        where cmpct.community_id = ${communityId}
    </select>