| | |
| | | |
| | | @ApiModelProperty("区域code") |
| | | private String areaCode; |
| | | |
| | | private String communityId; |
| | | } |
| | |
| | | realUserVO.setRealUserRate(rate.doubleValue()); |
| | | } |
| | | for (RealUser realUser : realUsers) { |
| | | if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(realUser)){ |
| | | if (realUser.getCommunityId().equals("11")){ |
| | | continue; |
| | | } |
| | | } |
| | | RealUserAnalysisVO vo=new RealUserAnalysisVO(); |
| | | vo.setCount(realUser.getCount()); |
| | | vo.setName(typeToNameRealUser(type, realUser)); |
| | |
| | | limit 10 |
| | | </select> |
| | | <select id="realUserCount" resultType="com.panzhihua.common.model.vos.user.RealUser"> |
| | | select cs.area_code as areaCode,cs.street_id,ac.name as communityName,cs.name as StreetName,count(su.user_id) as count from sys_user as su |
| | | select cs.area_code as areaCode,cs.street_id,ac.name as communityName,su.community_id as communityId, |
| | | cs.name as StreetName,count(su.user_id) as count from sys_user as su |
| | | left join com_act as ac on su.community_id=ac.community_id |
| | | left join com_street as cs on ac.street_id=cs.street_id |
| | | where su.community_id<>'' |