From 2f55cebbad3dea187a5f91d16ec80a9677dab699 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 13 十一月 2024 11:16:53 +0800
Subject: [PATCH] 1
---
src/main/java/com/yssh/service/EmailService.java | 170 ++++++++++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 151 insertions(+), 19 deletions(-)
diff --git a/src/main/java/com/yssh/service/EmailService.java b/src/main/java/com/yssh/service/EmailService.java
index 0611e4c..2729437 100644
--- a/src/main/java/com/yssh/service/EmailService.java
+++ b/src/main/java/com/yssh/service/EmailService.java
@@ -1,23 +1,20 @@
package com.yssh.service;
+import com.yssh.mapper.QxshMapper;
import com.yssh.utils.StringUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Value;
-import org.springframework.stereotype.Component;
import org.springframework.stereotype.Service;
+import javax.annotation.Resource;
import javax.mail.*;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;
-import java.util.Properties;
+import java.io.File;
+import java.text.SimpleDateFormat;
+import java.util.*;
-/**
- * 閭欢鏈嶅姟绫�
- *
- * @author www
- * @date 2024-03-21
- */
@Service
public class EmailService {
@Value("${email.userName}")
@@ -47,17 +44,49 @@
@Value("${email.cc}")
private String cc;
+ @Value("${csv.bigPath}")
+ private String bigPath;
+
+ @Value("${csv.filePath}")
+ private String filePath;
+
+ @Value("${csv.vocPath}")
+ private String vocPath;
+
+ @Value("${email.hours}")
+ private Integer hours;
+
+ @Value("${email.names}")
+ private String names;
+
+ @Value("${email.title}")
+ private String title;
+
+ @Value("${email.enable}")
+ private Boolean enable;
+
+ @Value("${email.debug}")
+ private Boolean debug;
+
+ @Resource
+ private QxshMapper qxshMapper;
+
+ private static boolean isBusy = false;
+
+ private final static SimpleDateFormat YMDH = new SimpleDateFormat("yyyyMMddHH");
+
+ private final static SimpleDateFormat Y_M_D_H = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+
protected final Logger logger = LoggerFactory.getLogger(this.getClass());
public Session createSession() {
- // 鍒涘缓涓�涓厤缃枃浠讹紝骞朵繚瀛�
Properties props = new Properties();
- // SMTP鏈嶅姟鍣ㄨ繛鎺ヤ俊鎭細126鈥攕mtp.126.com锛�163鈥攕mtp.163.com锛宷q-smtp.qq.com"
- props.put("mail.smtp.host", smtpHost); // SMTP涓绘満鍚�
- props.put("mail.smtp.port", smtpPort); // 涓绘満绔彛鍙凤細126鈥�25锛�163鈥�645锛宷q-587
- props.put("mail.smtp.auth", smtpAuth); // 鏄惁闇�瑕佺敤鎴疯璇�
- props.put("mail.smtp.starttls.enale", smtpTls); // 鍚敤TlS鍔犲瘑
+ // 126鈥攕mtp.126.com锛�163鈥攕mtp.163.com锛宷q-smtp.qq.com"
+ props.put("mail.smtp.host", smtpHost);
+ props.put("mail.smtp.port", smtpPort);
+ props.put("mail.smtp.auth", smtpAuth);
+ props.put("mail.smtp.starttls.enale", smtpTls);
Session session = Session.getInstance(props, new Authenticator() {
@Override
@@ -66,18 +95,19 @@
}
});
- // 鎺у埗鍙版墦鍗拌皟璇曚俊鎭�
- session.setDebug(true);
+ session.setDebug(debug);
return session;
}
public Boolean send(String title, String text) {
try {
- // 鍒涘缓Session浼氳瘽
+ if (!enable) {
+ return null;
+ }
+
Session session = createSession();
- // 鍒涘缓閭欢瀵硅薄
MimeMessage message = new MimeMessage(session);
message.setSubject(title);
message.setText(text);
@@ -93,7 +123,6 @@
message.setRecipients(Message.RecipientType.CC, ias);
}
- // 鍙戦��
Transport.send(message);
return true;
@@ -102,4 +131,107 @@
return false;
}
}
+
+ public Integer calcData() {
+ try {
+ if (isBusy) {
+ return null;
+ }
+
+ isBusy = true;
+ List<String> list = new ArrayList<>();
+ calcCsvData(list);
+ calcDbData(list);
+
+ int size = list.size();
+ if (size > 0) {
+ String text = String.join("銆�", list.toArray(new String[list.size()])) + "锛岃繎" + hours + "灏忔椂鍐呭瓨鍦ㄦ暟鎹己澶便��";
+ send(title, text);
+ }
+ isBusy = false;
+
+ return size;
+ } catch (Exception ex) {
+ logger.error(ex.getMessage(), ex);
+ isBusy = false;
+ return null;
+ }
+ }
+
+ private void calcCsvData(List<String> list) {
+ String[] strs = names.split(",");
+ int count = countCsv(bigPath, hours);
+ if (0 == count) {
+ list.add(strs[0]);
+ }
+ count = countCsv(filePath, hours);
+ if (0 == count) {
+ list.add(strs[1]);
+ }
+ count = countCsv(vocPath, hours);
+ if (0 == count) {
+ list.add(strs[2]);
+ }
+ }
+
+ private void calcDbData(List<String> list) {
+ Calendar calendar = getCalendar(0);
+ Integer iEnd = Integer.parseInt(YMDH.format(calendar.getTime()));
+ String sEnd = Y_M_D_H.format(calendar.getTime());
+ calendar.add(Calendar.HOUR, 1 - hours);
+ Integer iStart = Integer.parseInt(YMDH.format(calendar.getTime()));
+ String sStart = Y_M_D_H.format(calendar.getTime());
+
+ String[] strs = names.split(",");
+ int count = qxshMapper.countGcsjByTime(iStart, iEnd);
+ if (0 == count) {
+ list.add(strs[3]);
+ }
+ count = qxshMapper.countQxshByTime(iStart, iEnd);
+ if (0 == count) {
+ list.add(strs[4]);
+ }
+ count = qxshMapper.countSuYuan46ByTime(sStart, sEnd);
+ if (0 == count) {
+ list.add(strs[5]);
+ }
+ count = qxshMapper.countSuYuan70ByTime(sStart, sEnd);
+ if (0 == count) {
+ list.add(strs[6]);
+ }
+ count = qxshMapper.countSuYuanFastByTime(sStart, sEnd);
+ if (0 == count) {
+ list.add(strs[7]);
+ }
+ }
+
+ public int countCsv(String path, Integer hours) {
+ try {
+ int count = 0;
+ Calendar calendar = getCalendar(1);
+ for (int i = 0; i < hours; i++) {
+ calendar.add(Calendar.HOUR, -1);
+ String filePath = path + File.separator + YMDH.format(calendar.getTime()) + ".csv";
+ if (new File(filePath).exists()) {
+ count++;
+ }
+ }
+
+ return count;
+ } catch (Exception ex) {
+ logger.error(ex.getMessage(), ex);
+ return 0;
+ }
+ }
+
+ public Calendar getCalendar(int start) {
+ Calendar calendar = Calendar.getInstance();
+ calendar.setTime(new Date());
+ calendar.add(Calendar.HOUR, start);
+ calendar.set(Calendar.MINUTE, 0);
+ calendar.set(Calendar.SECOND, 0);
+ calendar.set(Calendar.MILLISECOND, 0);
+
+ return calendar;
+ }
}
--
Gitblit v1.9.3