用户统计~

文章目录

• • 概要
  • 整体架构流程
  • 技术细节
  • 小结

概要

用户统计业务通常涉及收集、分析和报告用户在网站、应用或其他平台上的行为数据。这类业务对于了解用户习惯、优化产品体验、制定营销策略等方面至关重要.

需求分析以及接口设计

业务规则：

• 基于可视化报表的折线图展示用户数据，X轴为日期，Y轴为用户数

• 根据时间选择区间，展示每天的用户总量和新增用户量数据

技术细节

1.Controller层

 /**
     * 用户统计
     * @param begin
     * @param end
     * @return
     */
    @ApiOperation("用户统计")
    @GetMapping("/userStatistics")
    public Result<UserReportVO> userStatistics(
            @DateTimeFormat(pattern = "yyyy-MM-dd") LocalDate begin,
            @DateTimeFormat(pattern = "yyyy-MM-dd")LocalDate end){
        log.info("用户统计:{},{}",begin,end);
        UserReportVO userReportVO = reportService.userStatistics(begin,end);
        return Result.success(userReportVO);
    }

2.Service层:

 /**
     * 用户统计
     * @param begin
     * @param end
     * @return
     */
    public UserReportVO userStatistics(LocalDate begin, LocalDate end) {
        //时间
        List<LocalDate> dateList = getDateList(begin, end);
        String dateListStr = StringUtils.join(dateList, ",");
        //每日总用户
        ArrayList<Integer> countAllUsersList = new ArrayList<>();
        for (LocalDate date : dateList) {
            LocalDateTime beginTime = LocalDateTime.of(date, LocalTime.MIN);
            LocalDateTime endTime = LocalDateTime.of(date, LocalTime.MAX);
            HashMap<String, Object> map = new HashMap<>();
            map.put("begin",beginTime);
            map.put("end",endTime);
            Integer countAllUsers = userMapper.getByMap(map);
            countAllUsers = countAllUsers == null ? 0 : countAllUsers;
            countAllUsersList.add(countAllUsers);
        }
        String countAllUserListStr = StringUtils.join(countAllUsersList, ",");
        //每日新增用户
        ArrayList<Integer> newUsersList = new ArrayList<>();
        for (LocalDate date : dateList) {
            LocalDateTime beginTime = LocalDateTime.of(date, LocalTime.MIN);
            HashMap<String, Object> nowMap = new HashMap<>();
            nowMap.put("begin",beginTime);
            Integer todayUsers = userMapper.getByMap(nowMap);
            HashMap<String, Object> yesterdayMap = new HashMap<>();
            yesterdayMap.put("begin",begin.plusDays(-1));
            Integer yesterdayUsers = userMapper.getByMap(yesterdayMap);
            Integer newUsers = todayUsers - yesterdayUsers;
            newUsers = newUsers < 0 ? 0 : newUsers;
            newUsersList.add(newUsers);
        }
        String newUserListStr = StringUtils.join(newUsersList, ",");
        return UserReportVO
                .builder()
                .dateList(dateListStr)
                .totalUserList(countAllUserListStr)
                .newUserList(newUserListStr)
                .build();
    }

    private List<LocalDate> getDateList(LocalDate begin, LocalDate end){
        ArrayList<LocalDate> dateList = new ArrayList<>();
        dateList.add(begin);
        while (!begin.equals(end)){
            begin = begin.plusDays(1);
            dateList.add(begin);
        }
        return dateList;
    }

3.Mapper层

<select id="getByMap" resultType="java.lang.Integer">
        select count(*) from `sky-take-out`.user
        <where>
            <if test="begin != null">create_time &lt; #{begin}</if>
        </where>
    </select>

效果展示