#update 普达大屏红色物业接口

张天森

2023-02-07 9910dfecd0df0a5f191c4f2511613aff5a10582e

#update 普达大屏红色物业接口

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

@@ -16,10 +16,9 @@
        where community_id=#{communityId}
    </select>
    <select id="propertyData" resultType="com.panzhihua.common.model.vos.puda.PropertyVO">
         select cp.name as propertyName,
        (select count(cpm.id) from com_pb_member as cpm where cpm.community_id=#{communityId} and cpm.check_unit_id=cp.id) as partyMembers
        from com_property as cp
        where cp.community_id=#{communityId}
        select cp.name as propertyName,(select count(id) from com_pb_service_team cpst where cp.id=cpst.property_id)  as partyMembers
        from com_property cp
        where cp.community_id=#{communityId}
    </select>
    <select id="partyData" resultType="com.panzhihua.common.model.vos.puda.PartyDataVO">
        select id,