#update 普达大屏统计

张天森

2023-02-16 945a54b590cc3d1003ef883c764e9ccb53501045

#update 普达大屏统计

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComScreenDao.java

@@ -54,5 +54,10 @@

    BuildingListHeaderStatisticsAdminVo buildingListHeaderStatisticsAdmin(Long communityId);

    /**
     * 建筑数量统计
     * */
    int assetAnalysis(Long communityId);


}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ScreenWorkServiceImpl.java

@@ -400,6 +400,7 @@
        BasicDataVO vo=new BasicDataVO();
        vo.setPeople(buildingListHeaderStatisticsAdminVo.getPopulationNum());
        vo.setBuildings(buildingListHeaderStatisticsAdminVo.getBuildNum());
        vo.setBuildings(comScreenDao.assetAnalysis(communityId));
        return R.ok(vo);
    }


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

@@ -5,7 +5,7 @@
<mapper namespace="com.panzhihua.service_community.dao.ComScreenDao">
    <select id="autonomyDynamic" resultType="com.panzhihua.common.model.vos.puda.DynamicVO">
        select community_id,
        (select count(id) from com_act_micro_wish where status=6 and  community_id=#{communityId}) as microWish,
        (select count(id) from com_act_micro_wish where community_id=#{communityId}) as microWish,
        (select count(id) from com_act_easy_photo where del_tag=0 and status=5 and  community_id=#{communityId}) as easyPhoto,
        (select count(id) from com_act_announcement where community_id=#{communityId}) as announcement,
        (select count(id) from com_act_activity where community_id=#{communityId}) as communityInfo,
@@ -96,4 +96,9 @@
        WHERE
            cmb.act_id = #{communityId}
    </select>
    <select id="assetAnalysis" resultType="java.lang.Integer">
        select count(id)
        from com_mng_real_assets
        where community_id=#{communityId}
    </select>
</mapper>