From 12448cb6604875e3b3df367e3b132dd1db45bff8 Mon Sep 17 00:00:00 2001 From: cjl <909710561@qq.com> Date: Thu, 25 Jan 2024 09:58:23 +0800 Subject: [PATCH] fix:补充提交 --- screen-job/src/main/resources/application-dev.yml | 17 ++++++++++++----- screen-job/src/main/java/com/moral/api/controller/PubController.java | 4 +++- screen-job/src/main/java/com/moral/api/mapper/DeviceMapper.java | 2 +- screen-job/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java | 2 +- 4 files changed, 17 insertions(+), 8 deletions(-) diff --git a/screen-job/src/main/java/com/moral/api/controller/PubController.java b/screen-job/src/main/java/com/moral/api/controller/PubController.java index c1b1b4e..c29aa7e 100644 --- a/screen-job/src/main/java/com/moral/api/controller/PubController.java +++ b/screen-job/src/main/java/com/moral/api/controller/PubController.java @@ -21,6 +21,7 @@ import javax.mail.MessagingException; import java.io.ByteArrayOutputStream; import java.io.IOException; +import java.nio.file.Files; import java.util.*; /** @@ -177,7 +178,8 @@ public void excelDevice() throws IOException { String startTime = DateUtils.dateToDateString(DateUtils.addDays(new Date(),-1),DateUtils.yyyy_MM_dd_EN); List<DeviceExcelDTO> list = deviceService.ListDeviceExcel(startTime,null,72); - String path = Objects.requireNonNull(this.getClass().getClassLoader().getResource("")).getPath(); + // String path = this.getClass().getClassLoader().getResource("/data/file").getPath(); + String path = System.getProperty("user.dir")+"/"; String fileName = String.format("%s������������������-%s.xlsx",path,startTime); ByteArrayOutputStream out = null; try { diff --git a/screen-job/src/main/java/com/moral/api/mapper/DeviceMapper.java b/screen-job/src/main/java/com/moral/api/mapper/DeviceMapper.java index 38337bf..3b87ff3 100644 --- a/screen-job/src/main/java/com/moral/api/mapper/DeviceMapper.java +++ b/screen-job/src/main/java/com/moral/api/mapper/DeviceMapper.java @@ -17,5 +17,5 @@ */ public interface DeviceMapper extends BaseMapper<Device> { - List<DeviceExcelDTO> ListDeviceExcel(@Param("startTime") String startTime,@Param("endTime") String endTime,@Param("id") int id); + List<DeviceExcelDTO> ListDeviceExcel(@Param("startTime") String startTime,@Param("id") int id); } diff --git a/screen-job/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java b/screen-job/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java index 0ecca0e..8f258a8 100644 --- a/screen-job/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java +++ b/screen-job/src/main/java/com/moral/api/service/impl/DeviceServiceImpl.java @@ -78,6 +78,6 @@ @Override public List<DeviceExcelDTO> ListDeviceExcel(String startTime, String endTime, int id) { - return this.baseMapper.ListDeviceExcel(startTime,endTime,id); + return this.baseMapper.ListDeviceExcel(startTime,id); } } \ No newline at end of file diff --git a/screen-job/src/main/resources/application-dev.yml b/screen-job/src/main/resources/application-dev.yml index a2d70c8..8e026a0 100644 --- a/screen-job/src/main/resources/application-dev.yml +++ b/screen-job/src/main/resources/application-dev.yml @@ -18,7 +18,7 @@ application: name: screen-job redis: - host: r-bp1xdlb9wfc6zt0msp18.redis.rds.aliyuncs.com + host: r-bp1xdlb9wfc6zt0msppd13.redis.rds.aliyuncs.com port: 6379 password: QxPcRedis_moarl_2320 timeout: 30000 @@ -35,7 +35,7 @@ max-wait: 30000 min-idle: 32 tokenRedis: - host: r-bp1xdlb9wfc6zt0msp18.redis.rds.aliyuncs.com + host: r-bp1xdlb9wfc6zt0msppd13.redis.rds.aliyuncs.com port: 6379 password: QxPcRedis_moarl_2320 timeout: 30000 @@ -55,7 +55,7 @@ filters: stat type: com.alibaba.druid.pool.DruidDataSource max-wait: 60000 - url: jdbc:mysql://rm-bp1pr3rx9m3fnkwsk18.mysql.rds.aliyuncs.com:3306/moral?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai + url: jdbc:mysql://rm-bp1pr3rx9m3fnkwskso.mysql.rds.aliyuncs.com:3306/moral?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai username: moral_qx password: QxPcRedis_moarl_2320 test-on-borrow: false @@ -74,9 +74,16 @@ mail: smtp: auth: true # ��������������������������������������������������������������������������� + socketFactory: + port: 465 + class: javax.net.ssl.SSLSocketFactory + fallback: false starttls: #SMTP������������:���������������TLS������������ - enable: true - required: true + enable: true + required: true + protocol: smtp + port: 465 + default-encoding: UTF-8 mybatis-plus: mapper-locations: classpath:mapper/*.xml global-config: -- Gitblit v1.8.0