src/main/java/com/mzl/flower/dto/response/payment/DeliveryOrderStatisticsDTO.java

@@ -11,6 +11,9 @@
@Data
public class DeliveryOrderStatisticsDTO {

    @ApiModelProperty(value = "日期id")
    private String id;

    @ApiModelProperty(value = "日期")
    private LocalDate date;


 src/main/java/com/mzl/flower/entity/CalendarDO.java

对比新文件
@@ -0,0 +1,61 @@
package com.mzl.flower.entity;


import com.baomidou.mybatisplus.annotation.TableName;

import lombok.Data;

import lombok.experimental.Accessors;

import java.time.LocalDateTime;

/**
 * @author @TaoJie
 * @since 2024-09-12
 */
@Data
@Accessors(chain = true)
@TableName("t_calendar")
public class CalendarDO {

    private String id;


    /**
     * 日期
     */
    private LocalDateTime calDate;

    /**
     * 年
     */
    private String calYear;

    /**
     * 月
     */
    private String calMonth;

    /**
     * 日
     */
    private String calDay;

    /**
     * 周(一/二/三/四/五/六/日)
     */
    private String calWeek;

    /**
     * 无/休/班
     */
    private Integer type;


    private LocalDateTime createTime;


    private LocalDateTime updateTime;


}

 src/main/java/com/mzl/flower/mapper/CalendarMapper.java

对比新文件
@@ -0,0 +1,16 @@
package com.mzl.flower.mapper;

import com.mzl.flower.entity.CalendarDO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author @TaoJie
 * @since 2024-09-12
 */
public interface CalendarMapper extends BaseMapper<CalendarDO> {

}

 src/main/java/com/mzl/flower/service/calendar/CalendarService.java

对比新文件
@@ -0,0 +1,17 @@
package com.mzl.flower.service.calendar;

import com.mzl.flower.entity.CalendarDO;
import com.baomidou.mybatisplus.extension.service.IService;

/**
 * <p>
 *  服务类
 * </p>
 *
 * @author @TaoJie
 * @since 2024-09-12
 */
public interface CalendarService extends IService<CalendarDO> {

    void generateCalendar(int i);
}

 src/main/java/com/mzl/flower/service/impl/CalendarServiceImpl.java

对比新文件
@@ -0,0 +1,56 @@
package com.mzl.flower.service.impl;

import cn.hutool.core.util.IdUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.mzl.flower.entity.CalendarDO;
import com.mzl.flower.mapper.CalendarMapper;
import com.mzl.flower.service.calendar.CalendarService;
import org.springframework.stereotype.Service;

import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.List;

/**
 * <p>
 *  服务实现类
 * </p>
 *
 * @author @TaoJie
 * @since 2024-09-12
 */
@Service
public class CalendarServiceImpl extends ServiceImpl<CalendarMapper, CalendarDO> implements CalendarService {

    @Override
    public void generateCalendar(int year) {
        List<CalendarDO> CalendarDOList = new ArrayList<>();
        LocalDateTime startDate = LocalDateTime.of(year, 1, 1, 0, 0);
        LocalDateTime endDate = LocalDateTime.of(year, 12, 31, 23, 59);


        //删除年的数据
        QueryWrapper<CalendarDO> queryWrapper=new QueryWrapper();
        queryWrapper.lambda().eq(CalendarDO::getCalYear,year);
        baseMapper.delete(queryWrapper);

        for (LocalDateTime date = startDate; !date.isAfter(endDate); date = date.plusDays(1)) {
            CalendarDO CalendarDO = new CalendarDO();
            CalendarDO.setId(IdUtil.simpleUUID());
            CalendarDO.setCalYear(String.valueOf(date.getYear()));
            CalendarDO.setCalMonth(String.valueOf(date.getMonthValue()));
            CalendarDO.setCalDay(String.valueOf(date.getDayOfMonth()));
            CalendarDO.setCalDate(date);
            CalendarDO.setCalWeek(String.valueOf(date.getDayOfWeek().getValue()));
            CalendarDO.setType(0);
            CalendarDO.setCreateTime(LocalDateTime.now());
            CalendarDO.setUpdateTime(LocalDateTime.now());
            CalendarDOList.add(CalendarDO);

            // 重新生成年的数据
            baseMapper.insert(CalendarDO);
        }

    }
}

 src/main/java/com/mzl/flower/service/payment/DeliveryOrderService.java

@@ -34,6 +34,7 @@
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.time.temporal.ChronoUnit;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
@@ -179,6 +180,8 @@
    }

    public Page<DeliveryOrderStatisticsDTO> selectSupplierDoStatistics(Page page){

        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyyMMdd");
        LocalDate theDay = parseLocalDate("2024-08-03");

        long current = page.getCurrent();
@@ -187,7 +190,7 @@
        current = current == 0 ? 1 : current;

        long endDays = (current - 1) * size;
        long beginDays = endDays + size;
        long beginDays = endDays + size-1;
        LocalDate beginDate = now.plusDays(-beginDays);
        LocalDate endDate = now.plusDays(-endDays);

@@ -207,6 +210,7 @@
                    , fivePm.plusDays(-1), fivePm);

            DeliveryOrderStatisticsDTO dto = new DeliveryOrderStatisticsDTO();
            dto.setId(endDate.format(formatter));
            dto.setDate(endDate);
            dto.setNum(0);
            dto.setPrice(new BigDecimal(0));
@@ -219,6 +223,14 @@
        }

        page.setRecords(ls);


        // 获取当前日期
        LocalDate today = LocalDate.now();
        // 计算当前日期与给定日期的天数差
        long daysBetween = ChronoUnit.DAYS.between(theDay, today);
        page.setTotal(daysBetween);

        return page;
    }


 src/main/java/com/mzl/flower/web/calendar/CalendarController.java

对比新文件
@@ -0,0 +1,35 @@
package com.mzl.flower.web.calendar;


import com.mzl.flower.service.calendar.CalendarService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
* @author @TaoJie
* @since 2024-09-12
*/
@RestController
@RequestMapping("/v2/calendar")
@Api(value = "日历", tags = "日历")
public class CalendarController {

    @Autowired
    CalendarService calendarService;

    @ApiOperation(value = "日历生成", notes = "日历生成")
    @GetMapping("/generate/fromTo/{startYear}/{endYear}")
    public void generateFromTo(@PathVariable Integer startYear, @PathVariable Integer endYear) {
        for(int i=startYear;i<=endYear;i++){
            calendarService.generateCalendar(i);
        }

    }


}

 src/main/resources/mapper/calendar/CalendarMapper.xml

对比新文件
@@ -0,0 +1,18 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.mzl.flower.mapper.CalendarMapper">

    <!-- 通用查询映射结果 -->
    <resultMap id="BaseResultMap" type="com.mzl.flower.entity.CalendarDO">
        <id column="id" property="id" />
        <result column="create_time" property="createTime" />
        <result column="update_time" property="updateTime" />
        <result column="cal_date" property="calDate" />
        <result column="cal_year" property="calYear" />
        <result column="cal_month" property="calMonth" />
        <result column="cal_day" property="calDay" />
        <result column="cal_week" property="calWeek" />
        <result column="type" property="type" />
    </resultMap>

</mapper>