金汇大屏社区服务接口

lidongdong

2023-11-01 e743e5ac1082b0b672732e65e5b9959e73594bfd

金汇大屏社区服务接口

 springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/JinhuiLargeScreenAppi.java

@@ -52,7 +52,7 @@
     * 金汇大屏社区服务
     * @return
     */
    @ApiOperation(value = "金汇大屏首页数据",response = JinhuiCommunityServicesVO.class)
    @ApiOperation(value = "金汇大屏社区服务",response = JinhuiCommunityServicesVO.class)
    @GetMapping("/getCommunityServices")
    public R getCommunityServices()
    {

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/resources/mapper/JinhuiLargeScreenMapper.xml

@@ -82,6 +82,7 @@
    <!--  党员  志愿者数量  -->
    <select id="baseInfo" resultType="com.panzhihua.common.model.vos.jinhui.JinhuiCommunityServicesVO">
        select
            count(id) as population,
            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
        from com_mng_population_community_tags AS cmpct