金汇大屏社区服务接口添加通知公告

lidongdong

2023-11-01 003117309029e35f145c0ee2d4f6a7788e6dd6d0

金汇大屏社区服务接口添加通知公告

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/jinhui/JinhuiCommunityServicesVO.java

@@ -60,6 +60,9 @@
    @ApiModelProperty("获取社区工作者")
    private String serviceTeam="0";

    @ApiModelProperty("通知公告")
    private String announcement="0";



    @ApiModelProperty("商家分类")

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

@@ -83,6 +83,7 @@
    <select id="baseInfo" resultType="com.panzhihua.common.model.vos.jinhui.JinhuiCommunityServicesVO">
        select
            count(id) as population,
            IFNULL((select count(id) from com_act_announcement where community_id = ${communityId}) ,0) as announcement,
            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