| | |
|---|
| | | <select id="getHeaderOrgDataStatistics" resultType="com.panzhihua.common.model.vos.partybuilding.ComDataStatisticsHeaderOrgVo"> |
|---|
| | | SELECT |
|---|
| | | count( id ) AS orgNum, |
|---|
| | | ( SELECT count( distinct id ) FROM com_pb_org WHERE community_id = #{communityId} AND area_id IS NOT NULL ) AS areaNum, |
|---|
| | | ( SELECT count( distinct area_id ) FROM com_pb_org WHERE community_id = #{communityId} AND area_id IS NOT NULL ) AS areaNum, |
|---|
| | | (select count(village_id) from com_mng_village where community_id = #{communityId}) as villageNum |
|---|
| | | FROM |
|---|
| | | com_pb_org |
|---|
