fix：sql查询时间调整

cjl

2024-01-31 3f667355c7013b459f3ab5ec0c1bc035d7e2d5aa

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
package com.moral.api.task;
 
import com.moral.api.service.DeviceService;
import com.moral.api.util.DeviceExcelDTO;
import com.moral.api.util.EmailSpringUtil;
import com.moral.api.util.ExcelUtil;
import com.moral.util.DateUtils;
import com.xxl.job.core.handler.annotation.XxlJob;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.core.io.ByteArrayResource;
import org.springframework.stereotype.Component;
 
import javax.mail.MessagingException;
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.util.Date;
import java.util.List;
import java.util.Objects;
 
/**
 * @ClassName EmaleTask
 * @Description TODO
 * @Author @cjl
 * @Date 2024-01-24 15:33
 * @Version 1.0
 */
@Component
@Slf4j
public class EmilInsetTask {
    @Autowired
    private DeviceService deviceService;
    private final EmailSpringUtil emailSpringUtil;
 
    public EmilInsetTask(EmailSpringUtil emailSpringUtil) {
        this.emailSpringUtil = emailSpringUtil;
    }
 
    @XxlJob("emilTask")
    public void emilTask()throws IOException {
        Date date = DateUtils.addDays(new Date(),-1);
        String startTime = DateUtils.dateToDateString(date,DateUtils.yyyy_MM_dd_EN);
        String mon = DateUtils.dateToDateString(date,DateUtils.yyyyMM_EN);
        List<DeviceExcelDTO> list = deviceService.ListDeviceExcel(startTime,mon,72);
        String path = System.getProperty("user.dir")+"/";
        String fileName = String.format("%s疾控中心数据-%s.xlsx",path,startTime);
        ByteArrayOutputStream out = null;
        try {
            // 生成excel文件
            out = ExcelUtil.generateExcel(list, DeviceExcelDTO.class);
            // 发送邮件
            String content = startTime+"疾控中心设备统计数据";
            String toMail = "lili@nieh.chinacdc.cn";
            emailSpringUtil.sendEmail("设备分钟数据",content,false,"909710561@qq.com",
                    toMail,"909710561@qq.com",null, fileName, new ByteArrayResource(out.toByteArray()));
        } catch (IOException e) {
            log.error(String.format("生成excel失败，原因：%s",e));
            e.printStackTrace();
        } catch (MessagingException e) {
            log.error(String.format("邮件发送失败，原因：%s",e));
            e.printStackTrace();
        }finally {
            if(out != null){
                out.close();
            }
        }
        log.info("邮件发送成功");
    }
 
    public static void main(String[] args) {
        Date date = DateUtils.addDays(new Date(),+1);
        String startTime = DateUtils.dateToDateString(date,DateUtils.yyyy_MM_dd_EN);
        String mon = DateUtils.dateToDateString(date,DateUtils.yyyyMM_EN);
        System.out.println(startTime);
        System.out.println(mon);
    }
}