| | |
| | | if (StringUtils.isNotEmpty(range)){ |
| | | r=Integer.parseInt(range); |
| | | } |
| | | return userService.userRate(type, sId,aCode,r); |
| | | return userService.userRate(type, sId,aCode,r,this.getAppId()); |
| | | } |
| | | |
| | | @ApiOperation(value = "新数据看板:实名用户", response = RealUserVO.class) |
| | |
| | | if (StringUtils.isNotEmpty(range)){ |
| | | r=Integer.parseInt(range); |
| | | } |
| | | return userService.realUser(type,sId,aCode,r); |
| | | return userService.realUser(type,sId,aCode,r,this.getAppId()); |
| | | } |
| | | |
| | | @ApiOperation(value = "新数据看板:用户行为分析", response = UserActivityAnalysisVO.class) |
| | |
| | | R userRate(@RequestParam(value = "type",required = false) Integer type, |
| | | @RequestParam(value = "streetId",required = false) Long streetId, |
| | | @RequestParam(value = "areaCode",required = false) Long areaCode, |
| | | @RequestParam(value = "range",required = false) Integer range); |
| | | @RequestParam(value = "range",required = false) Integer range,@RequestParam(value = "appId",required = false) String appId); |
| | | |
| | | |
| | | @GetMapping("/indexData/realUser") |
| | | R realUser(@RequestParam(value = "type",required = false) Integer type, |
| | | @RequestParam(value = "streetId",required = false) Long streetId, |
| | | @RequestParam(value = "areaCode",required = false) Long areaCode, |
| | | @RequestParam(value = "range",required = false) Integer range); |
| | | @RequestParam(value = "range",required = false) Integer range,@RequestParam(value = "appId",required = false) String appId); |
| | | |
| | | @GetMapping("/indexData/userActivity") |
| | | R userActivity(@RequestParam(value = "type",required = false) Integer type, |
| | |
| | | public R userRate(@RequestParam(value = "type",required = false) Integer type, |
| | | @RequestParam(value = "streetId",required = false) Long streetId, |
| | | @RequestParam(value = "areaCode",required = false) Long areaCode, |
| | | @RequestParam(value = "range",required = false) Integer range){ |
| | | return userService.userRate(type,streetId,areaCode,range); |
| | | @RequestParam(value = "range",required = false) Integer range,@RequestParam("appId")String appId){ |
| | | return userService.userRate(type,streetId,areaCode,range,appId); |
| | | } |
| | | |
| | | /** |
| | |
| | | public R realUser(@RequestParam(value = "type",required = false) Integer type, |
| | | @RequestParam(value = "streetId",required = false) Long streetId, |
| | | @RequestParam(value = "areaCode",required = false) Long areaCode, |
| | | @RequestParam(value = "range",required = false) Integer range){ |
| | | return userService.realUser(type,streetId,areaCode,range); |
| | | @RequestParam(value = "range",required = false) Integer range,@RequestParam(value = "appId",required = false)String appId){ |
| | | return userService.realUser(type,streetId,areaCode,range,appId); |
| | | } |
| | | |
| | | |
| | |
| | | /** |
| | | * 看板用户统计:用户占比统计 |
| | | * */ |
| | | List<UserProportion> userAnalysis(@Param("type") Integer type,@Param("range") String range,@Param("streetId") Long streetId,@Param("areaCode")Long areaCode); |
| | | List<UserProportion> userAnalysis(@Param("type") Integer type,@Param("range") String range,@Param("streetId") Long streetId,@Param("areaCode")Long areaCode,@Param("appId")String appId); |
| | | |
| | | /** |
| | | * 统计区域实名用户数 |
| | | * */ |
| | | List<RealUser> realUserCount(@Param("type") Integer type,@Param("range") String range,@Param("streetId") Long streetId,@Param("areaCode")Long areaCode); |
| | | List<RealUser> realUserCount(@Param("type") Integer type,@Param("range") String range,@Param("streetId") Long streetId,@Param("areaCode")Long areaCode,@Param("appId")String appId); |
| | | |
| | | /** |
| | | * 统计该街道内的所有用户数 |
| | |
| | | /** |
| | | * 获取本月的 |
| | | * */ |
| | | Integer getMonthUsers(@Param("streetId") Long streetId,@Param("areaCode") Long areaCode,@Param("range") String range); |
| | | Integer getMonthUsers(@Param("streetId") Long streetId,@Param("areaCode") Long areaCode,@Param("range") String range,@Param("appId")String appId); |
| | | |
| | | /** |
| | | * 获取街道下属村/社区 |
| | |
| | | * @param streetId 街道id |
| | | * @param areaCode 区县code |
| | | * @param range */ |
| | | R userRate(Integer type, Long streetId, Long areaCode, Integer range); |
| | | R userRate(Integer type, Long streetId, Long areaCode, Integer range,String appId); |
| | | |
| | | /** |
| | | * 真实用户占比统计 |
| | |
| | | * @param streetId 街道id |
| | | * @param areaCode 区县code |
| | | * @param range */ |
| | | R realUser(Integer type, Long streetId, Long areaCode, Integer range); |
| | | R realUser(Integer type, Long streetId, Long areaCode, Integer range,String appId); |
| | | |
| | | |
| | | /** |
| | |
| | | } |
| | | |
| | | @Override |
| | | public R userRate(Integer type, Long streetId, Long areaCode, Integer range) { |
| | | public R userRate(Integer type, Long streetId, Long areaCode, Integer range,String appId) { |
| | | IndexDataAnalysisVO analysisVO=new IndexDataAnalysisVO(); |
| | | if (type.equals(BYSTREET) || type.equals(BYAREA)){ |
| | | //街道,区县筛选 |
| | |
| | | BeanUtils.copyProperties(indexDataVO,analysisVO ); |
| | | }else { |
| | | //总量数据 |
| | | IndexDataKanbanVO indexDataKanbanVO = userDao.selectIndexDataKanban(null); |
| | | IndexDataKanbanVO indexDataKanbanVO = userDao.selectIndexDataKanban(appId); |
| | | BeanUtils.copyProperties(indexDataKanbanVO,analysisVO ); |
| | | } |
| | | String date=""; |
| | |
| | | date = DateUtil.parse(dateTime.toString(), "yyyy-MM-dd HH:mm:ss").toString(); |
| | | } |
| | | } |
| | | List<UserProportion> userProportions = userDao.userAnalysis(type, date, streetId,areaCode); |
| | | List<UserProportion> userProportions = userDao.userAnalysis(type, date, streetId,areaCode,appId); |
| | | List<UserRateAnalysisVO> userRateAnalysisVOList=new ArrayList<>(); |
| | | Boolean monthRange=false; |
| | | if (org.apache.commons.lang3.ObjectUtils.isNotEmpty(range)){ |
| | |
| | | } |
| | | //获取本月的用户总数作为计算占比的用户总数 |
| | | //IndexDataKanbanVO data = userDao.dataKanBanStreet(streetId, areaCode, date); |
| | | Integer monthUsers = userDao.getMonthUsers(streetId, areaCode, date); |
| | | Integer monthUsers = userDao.getMonthUsers(streetId, areaCode, date,appId); |
| | | vo.setRate(getRate(monthUsers,userProportion.getUser())); |
| | | }else{ |
| | | vo.setRate(getRate(analysisVO.getAllUser(),userProportion.getUser())); |
| | |
| | | } |
| | | |
| | | @Override |
| | | public R realUser(Integer type, Long streetId, Long areaCode, Integer range) { |
| | | public R realUser(Integer type, Long streetId, Long areaCode, Integer range,String appId) { |
| | | IndexDataAnalysisVO analysisVO=new IndexDataAnalysisVO(); |
| | | if (type.equals(BYSTREET) || type.equals(BYAREA)){ |
| | | //街道,区县筛选 |
| | |
| | | BeanUtils.copyProperties(indexDataVO,analysisVO ); |
| | | }else { |
| | | //总量数据 |
| | | IndexDataKanbanVO indexDataKanbanVO = userDao.selectIndexDataKanban(null); |
| | | IndexDataKanbanVO indexDataKanbanVO = userDao.selectIndexDataKanban(appId); |
| | | BeanUtils.copyProperties(indexDataKanbanVO,analysisVO ); |
| | | } |
| | | String date=""; |
| | |
| | | } |
| | | } |
| | | RealUserVO realUserVO=new RealUserVO(); |
| | | List<RealUser> realUsers = userDao.realUserCount(type, date, streetId, areaCode); |
| | | List<RealUser> realUsers = userDao.realUserCount(type, date, streetId, areaCode,appId); |
| | | List<RealUserAnalysisVO> realUserList=new ArrayList<>(); |
| | | realUserVO.setRealUserCount(getStreetRealUser(realUsers)); |
| | | Integer rate = getRate(analysisVO.getAllUser(), realUserVO.getRealUserCount()); |
| | |
| | | <if test="range != null and range != ''"> |
| | | and su.create_at >= #{range} |
| | | </if> |
| | | <if test="appId!=null and appId!=''"> |
| | | and su.app_id = #{appId} |
| | | </if> |
| | | <if test="type == 5"> |
| | | <if test="areaCode != null"> |
| | | and ac.area_code=#{areaCode} |
| | |
| | | and su.id_card<>'' |
| | | <if test="range != null and range != ''"> |
| | | and su.create_at >= #{range} |
| | | </if> |
| | | <if test="appId!=null and appId!=''"> |
| | | and su.app_id = #{appId} |
| | | </if> |
| | | <if test="type == 5"> |
| | | <if test="areaCode != null"> |
| | |
| | | <if test="range != null and range != ''"> |
| | | and t.create_at >= #{range} |
| | | </if> |
| | | <if test="appId!=null and appId!=''"> |
| | | and t.app_id = #{appId} |
| | | </if> |
| | | </select> |
| | | <select id="selectCommunityByStreetId" resultType="com.panzhihua.common.model.vos.user.CommunityVO"> |
| | | select community_id as id,name from com_act where street_id =#{id} |