java实现折线图统计数据

           需求：可以分别按日，周，月进行统计交易总额。后台接收参数为type,string。其中type为查询类型，string接收的为“yyyy-mm-dd”格式的字符串。按周统计的话是计算一周的交易总额，按月的话是计算一个月的交易总额；按周或者按月都是通过传过来的字符串去解析周数或月份。默认查询：日前推30天，周前推12周，月前推12个月。

           注意：1，周计数策略统一为iso标准策略计算；每周一为一周的第一天，第一个自然周最少要4天；

                           相关参考链接：

                                                    https://blog.csdn.net/wysnxzm/article/details/89095495

                                                    https://blog.csdn.net/sayWhat_sayHello/article/details/80589304  ；

                                                    https://blog.csdn.net/lifuxiangcaohui/article/details/50953018

                      2，数据的补全策略，通过事先运算出该时间范围内的所有应展示的统计数据与实际mysql中查询出来的数据进行对比，如果不存在响应map中则添加一条值为0的记录。

           参考代码：

public OpenAPiJsonResult shopTradeTrend(AppSession session, GetTradeTrendRequest request) throws Exception {
        WeekFields weekFields = WeekFields.of(DayOfWeek.MONDAY, 4);
        // 查询条件
        String queryData = request.getQueryDate();
        Integer queryType = request.getType();

        List<String> responseDate = Lists.newArrayList();
        if (Objects.isNull(queryType) && StringUtils.isBlank(queryData)) {
            // 默认按日，展示当前日期前推30天的数据
            request.setType(0);
            request.setStartDate(LocalDate.now().minusDays(29).toString());
            request.setEndDate(LocalDate.now().plusDays(1).toString());
            responseDate = DateUtil.findDates(LocalDate.now().minusDays(30).toString(), LocalDate.now().toString());
        } else if (Objects.nonNull(queryType)) {
            if (queryType == 0) {
                // 按日，默认查30天
                if (StringUtils.isBlank(queryData)) {
                    request.setStartDate(LocalDate.now().minusDays(29).toString());
                    request.setEndDate(LocalDate.now().plusDays(1).toString());
                    responseDate = DateUtil.findDates(LocalDate.now().minusDays(30).toString(), LocalDate.now().toString());
                } else {
                    LocalDate queryDate = DateUtil.stringToLocalDate(queryData);
                    request.setStartDate(queryDate.minusDays(29).toString());
                    request.setEndDate(queryDate.plusDays(1).toString());
                    responseDate = DateUtil.findDates(queryDate.minusDays(30).toString(), queryDate.toString());
                }
            } else if (queryType == 1) {
                // 按周，默认查当前周前推12周的数据
                if (StringUtils.isBlank(queryData)) {
                    int nowWeekNo = LocalDate.now().get(weekFields.weekOfYear());
                    String weekStartDate = DateUtil.getWeekDays(LocalDate.now().getYear(), nowWeekNo, -11);
                    request.setStartDate(weekStartDate);
                    request.setEndDate(LocalDate.now().plusDays(1).toString());
                    responseDate = new ArrayList<>(Objects.requireNonNull(DateUtil.getWeekBetween(weekStartDate, LocalDate.now().toString())));
                } else {
                    LocalDate date = DateUtil.stringToLocalDate(queryData);
                    int nowWeekNo = date.get(weekFields.weekOfWeekBasedYear());
                    request.setStartDate(DateUtil.getWeekDays(date.get(weekFields.weekBasedYear()), nowWeekNo, -11));
                    request.setEndDate(DateUtil.getDateByYearAndWeekNo(date.get(weekFields.weekBasedYear()), nowWeekNo).plusDays(1).toString());
                    responseDate = new ArrayList<>(Objects.requireNonNull(DateUtil.getWeekBetween(DateUtil.getWeekDays(date.get(weekFields.weekBasedYear()), nowWeekNo, -11), DateUtil.getDateByYearAndWeekNo(date.get(weekFields.weekBasedYear()), nowWeekNo).toString())));
                }
            } else {
                // 按月，默认查12个月
                if (StringUtils.isBlank(queryData)) {
                    String startMonth = DateUtil.dateMinusMonth(LocalDate.now().getYear() + "" + LocalDate.now().getMonthValue(), -11);
                    request.setStartDate(startMonth.substring(0, 4) + "-" + startMonth.substring(4, 6) + "-01");
                    request.setEndDate(LocalDate.now().plusDays(1).toString());

                    responseDate = DateUtil.getMonthBetween(startMonth.substring(0, 4) + "-" + startMonth.substring(4, 6), LocalDate.now().getYear() + "-" + LocalDate.now().getMonthValue());
                } else {
                    LocalDate date = DateUtil.stringToLocalDate(queryData);
                    String startMonth = DateUtil.dateMinusMonth(date.getYear() + "" + date.getMonthValue(), -11);
                    request.setStartDate(startMonth.substring(0, 4) + "-" + startMonth.substring(4, 6) + "-01");
                    String endDate = DateUtil.getLastDay(date.getYear() + "-" + date.getMonthValue() + "-01");
                    request.setEndDate(DateUtil.stringToLocalDate(endDate).plusDays(1).toString());
                    responseDate = DateUtil.getMonthBetween(startMonth.substring(0, 4) + "-" + startMonth.substring(4, 6), date.getYear() + "-" + date.getMonthValue());
                }
            }
        }
        List<TradeTrendResponse> responseList = orderService.selectCountTradeTrend(session.getOrgId(), session.getStoreId(), request.getType(), request.getStartDate(), request.getEndDate());

        // 因为mysql month,week,day函数返回的数据在1-9内的都不带0，需要拼装成规范月，周，日数据
        List<String> convertData = Stream.of("1", "2", "3", "4", "5", "6", "7", "8", "9").collect(toList());
        if (Objects.isNull(request.getType()) || request.getType() == 0) {
            List<String> hasData = Lists.newArrayList();
            TreeMap<LocalDate, Double> responseMap = Maps.newTreeMap();
            // 按日
            responseList.forEach(x -> {
                if (convertData.contains(x.getMonthNo())) {
                    x.setMonthNo("0" + x.getMonthNo());
                }
                if (convertData.contains(x.getDayNo())) {
                    x.setDayNo("0" + x.getDayNo());
                }
                String str = x.getYearNo() + "-" + x.getMonthNo() + "-" + x.getDayNo();
                responseMap.put(DateUtil.stringToLocalDate(str), x.getAmount());
                hasData.add(str);
            });
            responseDate.removeAll(hasData);
            responseDate.forEach(noData -> {
                responseMap.put(DateUtil.stringToLocalDate(noData), 0.00);
            });
            return OpenAPiJsonResult.success(responseMap);
        } else if (request.getType() == 1) {
            // 按周
            List<String> hasData = Lists.newArrayList();
            TreeMap<String, Double> map = Maps.newTreeMap();
            responseList.forEach(x -> {
                map.put(x.getWeekNo().substring(0, 4) + "第" + x.getWeekNo().substring(4, 6) + "周", x.getAmount());
                hasData.add(x.getWeekNo());
            });
            responseDate.removeAll(hasData);
            responseDate.forEach(noData -> {
                map.put(noData.substring(0, 4) + "第" + noData.substring(4, 6) + "周", 0.00);
            });
            if (map.size() > 12) {
                map.remove(map.firstKey());
            }
            return OpenAPiJsonResult.success(map);
        } else {
            // 按月
            List<String> hasData = Lists.newArrayList();
            TreeMap<String, Double> map = Maps.newTreeMap();
            responseList.forEach(x -> {
                if (convertData.contains(x.getMonthNo())) {
                    x.setMonthNo("0" + x.getMonthNo());
                }
                String str = x.getYearNo() + "-" + x.getMonthNo();
                map.put(str + "月", x.getAmount());
                hasData.add(str);
            });
            responseDate.removeAll(hasData);
            responseDate.forEach(noData -> {
                map.put(noData + "月", 0.00);
            });
            return OpenAPiJsonResult.success(map);
        }
    }

  /**
     * 根据当前周号，计算n周前或后的周一日期
     *
     * @param year
     * @param week
     * @param targetNum
     * @return
     */
    public static String getWeekDays(int year, int week, int targetNum) {
        // 计算目标周数
        if (week + targetNum > 52) {
            year++;
        } else if (week + targetNum <= 0) {
            year--;
            week += targetNum + 52;
        } else {
            week += targetNum;
        }

        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
        Calendar cal = Calendar.getInstance();

        // 设置每周的开始日期
        cal.setFirstDayOfWeek(Calendar.MONDAY);

        cal.set(Calendar.YEAR, year);
        cal.set(Calendar.WEEK_OF_YEAR, week);
        cal.set(Calendar.DAY_OF_WEEK, cal.getFirstDayOfWeek());

        // 该周周一
        String beginDate = sdf.format(cal.getTime());

        cal.add(Calendar.DAY_OF_WEEK, 6);
        // 该周周日
        String endDate = sdf.format(cal.getTime());

        return beginDate;
    }

    /**
     * 根据年，周号，获取该周周日
     *
     * @return
     */
    public static LocalDate getDateByYearAndWeekNo(int year, int week) {
        WeekFields weekFields2 = WeekFields.of(DayOfWeek.MONDAY, 4);
        LocalDate sunday = LocalDate.now()
                .withYear(year)
                .with(weekFields2.weekOfYear(), week)
                .with(weekFields2.dayOfWeek(), 7L);

        return sunday;
    }

    /**
     * 日期加、减几月
     *
     * @param str
     * @param amount 正数加，负数减
     * @return
     * @throws Exception
     */
    public static String dateMinusMonth(String str, int amount) throws Exception {
        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMM");
        Date dt = sdf.parse(str);//将字符串生成Date
        Calendar rightNow = Calendar.getInstance();
        rightNow.setTime(dt);//使用给定的 Date 设置此 Calendar 的时间。
        rightNow.add(Calendar.MONTH, amount);// 日期减1个月
        Date dt1 = rightNow.getTime();//返回一个表示此 Calendar 时间值的 Date 对象。
        String reStr = sdf.format(dt1);//将给定的 Date 格式化为日期/时间字符串，并将结果添加到给定的 StringBuffer。
        return reStr;
    }

    /**
     * 获取某个月最后一天
     *
     * @param datadate
     * @return
     * @throws Exception
     */
    public static String getLastDay(String datadate) throws Exception {
        Date date = null;
        String day_last = null;
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
        date = format.parse(datadate);

//创建日历
        Calendar calendar = Calendar.getInstance();
        calendar.setTime(date);
        calendar.add(Calendar.MONTH, 1); //加一个月
        calendar.set(Calendar.DATE, 1);//设置为该月第一天
        calendar.add(Calendar.DATE, -1);//再减一天即为上个月最后一天
        day_last = format.format(calendar.getTime());
        return day_last;
    }

    /**
     * 获取时间段内，所有天
     *
     * @param dBegin
     * @param dEnd
     * @return
     * @throws ParseException
     */
    public static List<String> findDates(String dBegin, String dEnd) throws ParseException {
        //日期工具类准备
        DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
        //设置开始时间
        Calendar calBegin = Calendar.getInstance();
        calBegin.setTime(format.parse(dBegin));
        //设置结束时间
        Calendar calEnd = Calendar.getInstance();
        calEnd.setTime(format.parse(dEnd));
        //装返回的日期集合容器
        List<String> datelist = new ArrayList<String>();
        // 每次循环给calBegin日期加一天，直到calBegin.getTime()时间等于dEnd
        while (format.parse(dEnd).after(calBegin.getTime())) {
            // 根据日历的规则，为给定的日历字段添加或减去指定的时间量
            calBegin.add(Calendar.DAY_OF_MONTH, 1);
            datelist.add(format.format(calBegin.getTime()));
        }
        return datelist;
    }

    /**
     * 获取一段时间内，所有月份
     *
     * @param minDate
     * @param maxDate
     * @return
     * @throws ParseException
     */
    public static List<String> getMonthBetween(String minDate, String maxDate) throws ParseException {
        ArrayList<String> result = new ArrayList<String>();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM");//格式化为年月

        Calendar min = Calendar.getInstance();
        Calendar max = Calendar.getInstance();

        min.setTime(sdf.parse(minDate));
        min.set(min.get(Calendar.YEAR), min.get(Calendar.MONTH), 1);

        max.setTime(sdf.parse(maxDate));
        max.set(max.get(Calendar.YEAR), max.get(Calendar.MONTH), 2);

        Calendar curr = min;
        while (curr.before(max)) {
            result.add(sdf.format(curr.getTime()));
            curr.add(Calendar.MONTH, 1);
        }

        return result;
    }

    /**
     * 获取时间段内所有的周，注意：需要指定周计数策略
     *
     * @param startStr
     * @param endStr
     * @return
     */
    @SuppressWarnings("all")
    public static Set<String> getWeekBetween(String startStr, String endStr) {
        WeekFields weekFields = WeekFields.of(DayOfWeek.MONDAY, 4);
        LocalDate start = DateUtil.stringToLocalDate(startStr);
        LocalDate end = DateUtil.stringToLocalDate(endStr);
        int startY = start.get(weekFields.weekBasedYear());
        int startW = start.get(weekFields.weekOfWeekBasedYear());
        int endY = end.get(weekFields.weekBasedYear());
        int endW = end.get(weekFields.weekOfWeekBasedYear());
        List<Integer> convertData = Stream.of(1, 2, 3, 4, 5, 6, 7, 8, 9).collect(toList());
        Set<String> response = Sets.newTreeSet();
        if (endY - startY == 0) {// 同一年
            for (int i = startW; i <= endW; i++) {
                if (convertData.contains(i)) {
                    response.add(endY + "0" + i);
                } else {
                    response.add(endY + "" + i);
                }
            }
            return response;
        } else if (endY - startY == 1) { // 这里因业务只统计跨度为12周的数据，所以只考虑年差距在一年的情况
            String lastDay = startY + "-12-31";  // 获取起始年最大周数
            int maxWeek = DateUtil.stringToLocalDate(lastDay).get(weekFields.weekOfYear());
            for (int i = startW; i <= maxWeek; i++) {
                if (convertData.contains(i)) {
                    response.add(startY + "0" + i);
                } else {
                    response.add(startY + "" + i);
                }
            }
            for (int j = 1; j <= endW; j++) {
                if (convertData.contains(j)) {
                    response.add(endY + "0" + j);
                } else {
                    response.add(endY + "" + j);
                }
            }
            return response;
        } else {// 暂不考虑
            return null;
        }
    }

  <select id="selectCountTradeTrend" resultMap="CountPayTrend">
        select
        <if test="queryType == 0">
            MONTH(pay_time) as month_no,
            DAY(pay_time) as day_no,
        </if>
        <if test="queryType == 1">
            yearweek(pay_time,3) as week_no,
        </if>
        <if test="queryType == 2">
            MONTH(pay_time) as month_no,
        </if>
        YEAR(pay_time) as year_no,
        SUM(practical_deal_price) as amount
        from
        <include refid="tableName"/>
        <where>
            org_id = #{orgId}
            and store_id = #{storeId}
            and is_del = 0
            <if test="startDate != null and startDate != ''">
                and pay_time &gt;= #{startDate}
            </if>
            <if test="endDate != null and endDate != ''">
                and pay_time &lt;= #{endDate}
            </if>
        </where>
        GROUP BY
        <if test="queryType == 0">
            DAY(pay_time)
        </if>
        <if test="queryType == 1">
            yearweek(pay_time,3)
        </if>
        <if test="queryType == 2">
            MONTH(pay_time)
        </if>
    </select>