springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/partybuilding/ComDataStatisticsHeaderOrgVo.java
@@ -21,6 +21,9 @@ @ApiModelProperty(value = "党组织绑定小区数量") private Integer areaNum = 0; @ApiModelProperty(value = "社区下小区数量") private Integer villageNum = 0; @ApiModelProperty(value = "小区覆盖率") private BigDecimal villageRate = BigDecimal.ZERO; } springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/service/impl/ComPbMemberServiceImpl.java
@@ -782,10 +782,10 @@ public R getHeaderOrgDataStatistics(Long communityId) { ComDataStatisticsHeaderOrgVo headerOrgVo = comPbMemberDAO.getHeaderOrgDataStatistics(communityId); if(headerOrgVo != null){ if(headerOrgVo.getOrgNum() == null || headerOrgVo.getOrgNum().equals(0)){ if(headerOrgVo.getVillageNum() == null || headerOrgVo.getVillageNum().equals(0)){ headerOrgVo.setVillageRate(BigDecimal.ZERO); }else{ headerOrgVo.setVillageRate(BigDecimal.valueOf(headerOrgVo.getAreaNum()).divide(BigDecimal.valueOf(headerOrgVo.getOrgNum()) headerOrgVo.setVillageRate(BigDecimal.valueOf(headerOrgVo.getAreaNum()).divide(BigDecimal.valueOf(headerOrgVo.getVillageNum()) ,4,BigDecimal.ROUND_HALF_UP).multiply(BigDecimal.valueOf(100))); } } springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/ComPbMemberMapper.xml
@@ -454,7 +454,8 @@ <select id="getHeaderOrgDataStatistics" resultType="com.panzhihua.common.model.vos.partybuilding.ComDataStatisticsHeaderOrgVo"> SELECT count( id ) AS orgNum, ( SELECT count( id ) FROM com_pb_org WHERE community_id = #{communityId} AND area_id IS NOT NULL ) AS areaNum ( SELECT count( 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 WHERE