From aa1bdb548aa6a6371a8953efacc3986300eee576 Mon Sep 17 00:00:00 2001
From: swb <jpy123456>
Date: Fri, 15 Nov 2024 08:50:23 +0800
Subject: [PATCH] fix:补充提交
---
screen-job/src/main/java/com/moral/api/controller/PubController.java | 89 ++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 85 insertions(+), 4 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 822ed13..cb46262 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
@@ -1,6 +1,9 @@
package com.moral.api.controller;
import com.moral.api.service.*;
+import com.moral.api.util.DeviceExcelDTO;
+import com.moral.api.util.EmailSpringUtil;
+import com.moral.api.util.ExcelUtil;
import com.moral.api.util.HttpUtils;
import com.moral.constant.ResultMessage;
import com.moral.util.DateUtils;
@@ -10,13 +13,15 @@
import org.apache.http.HttpResponse;
import org.apache.http.util.EntityUtils;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.core.io.ByteArrayResource;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
-import java.util.Date;
-import java.util.HashMap;
-import java.util.Map;
+import javax.mail.MessagingException;
+import java.io.ByteArrayOutputStream;
+import java.io.IOException;
+import java.util.*;
/**
* @ClassName UserController
@@ -46,6 +51,22 @@
private HistoryHourlyService historyHourlyService;
@Autowired
private HistoryMonthlyService historyMonthlyService;
+ @Autowired
+ private DeviceService deviceService;
+
+ @Autowired
+ private ManageCoordinateDetailService manageCoordinateDetailService;
+
+ @Autowired
+ private HistorySecondCruiserService historySecondCruiserService;
+
+ private final EmailSpringUtil emailSpringUtil;
+ private final CityWeatherForecastService cityWeatherForecastService;
+
+ public PubController(EmailSpringUtil emailSpringUtil, CityWeatherForecastService cityWeatherForecastService) {
+ this.emailSpringUtil = emailSpringUtil;
+ this.cityWeatherForecastService = cityWeatherForecastService;
+ }
@GetMapping("insertHistoryDaily")
@ApiOperation(value = "���������������", notes = "���������������")
@@ -105,6 +126,13 @@
return new ResultMessage();
}
+ @GetMapping("insertHistoryHourly")
+ @ApiOperation(value = "������������������������", notes = "������������������������")
+ public ResultMessage insertHistoryHourly() {
+ historyHourlyService.insertHistoryHourly();
+ return new ResultMessage();
+ }
+
@GetMapping("insertHCHistoryAqi")
@ApiOperation(value = "������������", notes = "������������")
public ResultMessage insertHCHistoryAqi() {
@@ -131,10 +159,35 @@
return new ResultMessage();
}
+ @GetMapping("insertCityWeatherForecast")
+ @ApiOperation(value = "������������������������", notes = "������������������������")
+ public ResultMessage insertCityWeatherForecast() {
+ cityWeatherForecastService.insertCityWeatherForecast();
+ return new ResultMessage();
+ }
+
@GetMapping("insertHistoryMonthly")
@ApiOperation(value = "���������", notes = "���������")
public ResultMessage insertHistoryMonthly() {
historyMonthlyService.insertHistoryMonthly();
+ return new ResultMessage();
+ }
+
+ @GetMapping("secondCruiserSort")
+ @ApiOperation(value = "���������������", notes = "���������������")
+ public ResultMessage secondCruiserSort() {
+ String startTime ="2024-11-13 00:00:00";
+ String endTime ="2024-11-14 00:00:00";
+ historySecondCruiserService.sort(startTime,endTime);
+ return new ResultMessage();
+ }
+
+ @GetMapping("insertCoordinateDetail")
+ @ApiOperation(value = "������������", notes = "������������")
+ public ResultMessage insertCoordinateDetail() {
+ String startTime ="2024-06-06 00:07:01";
+ String endTime ="2024-06-06 23:07:01";
+ manageCoordinateDetailService.insertCoordinateDetail(startTime,endTime);
return new ResultMessage();
}
@@ -170,5 +223,33 @@
}
}
-
+ @GetMapping("excelDevice")
+ @ApiOperation(value = "excle", notes = "excle")
+ 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 = 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 {
+ // ������excel������
+ out = ExcelUtil.generateExcel(list, DeviceExcelDTO.class);
+ // ������������
+ String content = startTime+"������������������������������";
+ String toMail = "ad@7drlb.com";
+ 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();
+ }
+ }
+ }
}
--
Gitblit v1.8.0