JAVA-通过Calendar获取报表按日、周、月分组的时间轴

最新推荐文章于 2022-12-04 11:00:00 发布

CSYZA

最新推荐文章于 2022-12-04 11:00:00 发布

阅读量640

点赞数

文章标签： java

本文链接：https://blog.csdn.net/CSYZA/article/details/119790250

版权

这篇博客介绍了如何利用Java的Calendar类来创建时间轴，确保在报表需求中即使在没有对应记录的时间段也能保持时间轴的连续性。提供了按周和按7天周期获取时间间隔的方法，并展示了从指定日期到当前日期的日、月间隔的生成示例。

摘要由CSDN通过智能技术生成

在报表需求中，经常需要按日、周、月分组，但是如果某段时间没有对应的记录，时间轴会不连续

我们可以使用JAVA的Calendar来预设某段时间的时间轴

传入时间区间，获取轴
直接上 代码。


public class DateUtil {
	// 当然入参也可以换成localdate、date等类型，出参也可以换成月-日等

    private static final DateTimeFormatter format = DateTimeFormatter.ofPattern("MM/dd");
    
	 /**
     * 获取day1到day2的周间隔
     * @return
     */
    public static List<String> getWeekSection(LocalDateTime day1, LocalDateTime day2) {
        List<String> list = new ArrayList<>();

        Calendar start = Calendar.getInstance();
        start.setMinimalDaysInFirstWeek(4);//设置一年第一周归属
        start.setTime(Date.from(day1.atZone(ZoneId.systemDefault()).toInstant()));
        start.setFirstDayOfWeek(Calendar.MONDAY);
        start.set(Calendar.DAY_OF_WEEK, start.getFirstDayOfWeek());

        Calendar end = Calendar.getInstance();
        end.setMinimalDaysInFirstWeek(4);//设置一年第一周归属
        end.setTime(Date.from(day2.atZone(ZoneId.systemDefault()).toInstant()));
        end.setFirstDayOfWeek(Calendar.MONDAY);
        end.set(Calendar.DAY_OF_WEEK, end.getFirstDayOfWeek() + 6);

        while (!start.after(end)){
            //该年该周
            String yearWeek = start.get(Calendar.YEAR)+"/"+start.get(Calendar.WEEK_OF_YEAR);
            //该周开始日期
            LocalDateTime sectionStart = LocalDateTime.ofInstant(start.getTime().toInstant(), ZoneId.systemDefault());
            //该周结束日期
            start.add(Calendar.DAY_OF_MONTH, 6);
            LocalDateTime sectionEnd = LocalDateTime.ofInstant(start.getTime().toInstant(), ZoneId.systemDefault());

            list.add(yearWeek);
            //下一周
            start.add(Calendar.DAY_OF_MONTH, 1);
        }
        return list;
    }

    /**
     * 获取day1到day2的间隔7天周期
     * @return
     */
    public static List<String> getWeekSection2(LocalDateTime day1, LocalDateTime day2) {
        List<String> list = new ArrayList<>();

        Calendar start = Calendar.getInstance();
        start.setMinimalDaysInFirstWeek(4);//设置一年第一周归属
        start.setTime(Date.from(day1.atZone(ZoneId.systemDefault()).toInstant()));
        start.setFirstDayOfWeek(Calendar.MONDAY);
        start.set(Calendar.DAY_OF_WEEK, start.getFirstDayOfWeek());

        Calendar end = Calendar.getInstance();
        end.setMinimalDaysInFirstWeek(4);//设置一年第一周归属
        end.setTime(Date.from(day2.atZone(ZoneId.systemDefault()).toInstant()));
        end.setFirstDayOfWeek(Calendar.MONDAY);
        end.set(Calendar.DAY_OF_WEEK, end.getFirstDayOfWeek() + 6);

        while (!start.after(end)){
            //该周开始日期
            LocalDateTime sectionStart = LocalDateTime.ofInstant(start.getTime().toInstant(), ZoneId.systemDefault());
            //该周结束日期
            start.add(Calendar.DAY_OF_MONTH, 6);
            LocalDateTime sectionEnd = LocalDateTime.ofInstant(start.getTime().toInstant(), ZoneId.systemDefault());
            String startStr = format.format(sectionStart);
            //设置出参
            String endStr = format.format(sectionEnd);
            list.add(startStr+"-"+endStr);
            //下一周
            start.add(Calendar.DAY_OF_MONTH, 1);
        }
        return list;
    }


    /**
     * 获取day1到day2的间隔
     * @return
     */
    public static List<String> getDaySection(LocalDateTime day1, LocalDateTime day2) {
        //出参
        List<String> list = new ArrayList<>();

        //localDateTime转date
        ZoneId zone = ZoneId.systemDefault();
        Instant instant1 = day1.atZone(zone).toInstant();
        Date date1 = Date.from(instant1);

        Instant instant2 = day2.atZone(zone).toInstant();
        Date date2 = Date.from(instant2);

        Calendar start = Calendar.getInstance();
        start.setTime(date1);

        Calendar end = Calendar.getInstance();
        end.setTime(date2);

        while (!start.after(end)){
            String year = start.get(Calendar.YEAR) + "";
            String month = (((start.get(Calendar.MONTH) + 1) < 10 ?"0":"") + (start.get(Calendar.MONTH) + 1));
            String day = ((start.get(Calendar.DATE) < 10 ?"0":"") + start.get(Calendar.DATE));
            list.add(year + "/" + month + "/" + day);
            start.add(Calendar.DATE,1);
        }

        return list;
    }

    /**
     * 获取day1到day2的月间隔
     * @return
     */
    public static List<String> getMonthSection(LocalDateTime day1, LocalDateTime day2) {
        //出参
        List<String> list = new ArrayList<>();

        //localDateTime转date
        ZoneId zone = ZoneId.systemDefault();
        Instant instant1 = day1.atZone(zone).toInstant();
        Date date1 = Date.from(instant1);

        Instant instant2 = day2.atZone(zone).toInstant();
        Date date2 = Date.from(instant2);

        Calendar start = Calendar.getInstance();
        start.setTime(date1);

        Calendar end = Calendar.getInstance();
        end.setTime(date2);

        while (!start.after(end)){
            String month = (((start.get(Calendar.MONTH) + 1) < 10 ?"0":"") + (start.get(Calendar.MONTH) + 1));
            String time = start.get(Calendar.YEAR) + "/" + month;
            list.add(time);
            start.add(Calendar.MONTH,1);
        }

        return list;
    }

    public static void main(String[] args) {
//测试一下

//        DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
//        LocalDateTime ldt = LocalDateTime.parse("2021-02-12 00:00:00",df);
//        System.out.println(getDaySection(ldt,LocalDateTime.now()));

//        DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
//        LocalDateTime ldt = LocalDateTime.parse("2021-02-12 00:00:00",df);
//        System.out.println(getMonthSection(ldt,LocalDateTime.now()));
//
        DateTimeFormatter df = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
        LocalDateTime ldt1 = LocalDateTime.parse("2021-12-20 00:00:00",df);
        LocalDateTime ldt2 = LocalDateTime.parse("2022-01-30 23:59:59",df);
        System.out.println(getWeekSection(ldt1,ldt2));

    }

}