From 8b0f5324c7a0b5caabf48b9e6743368b33e54ee6 Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期二, 06 五月 2025 11:02:08 +0800
Subject: [PATCH] 对研发邮箱发送邮件

---
 src/main/java/com/whyc/service/UserService.java           |    9 +++++++++
 src/main/java/com/whyc/schedule/SoftwareMailSchedule.java |   10 ++++++++--
 2 files changed, 17 insertions(+), 2 deletions(-)

diff --git a/src/main/java/com/whyc/schedule/SoftwareMailSchedule.java b/src/main/java/com/whyc/schedule/SoftwareMailSchedule.java
index 76f9d9a..5f681a8 100644
--- a/src/main/java/com/whyc/schedule/SoftwareMailSchedule.java
+++ b/src/main/java/com/whyc/schedule/SoftwareMailSchedule.java
@@ -3,6 +3,7 @@
 import com.whyc.factory.ThreadPoolExecutorFactory;
 import com.whyc.pojo.Software;
 import com.whyc.service.SoftwareService;
+import com.whyc.service.UserService;
 import com.whyc.util.DateUtil;
 import com.whyc.util.MailUtil;
 import com.whyc.util.ThreadLocalUtil;
@@ -28,13 +29,18 @@
     @Autowired
     private SoftwareService softwareService;
 
+    @Autowired
+    private UserService userService;
+
     /**鏁版嵁4绉掗挓鑾峰彇涓�娆�*/
     @Scheduled(cron = "0/4 * * * * ? ")
     public void sendMail(){
         //鏌ヨ闇�瑕佸彂閫侀偖浠�
         List<Software> list = softwareService.getSendList();
-        String[] toArrStr = new String[]{"perryhsu@163.com"};
-        List toArr = Arrays.asList(toArrStr);
+        //鏌ヨ鐮斿彂瑙掕壊鐨勬墍鏈夌敤鎴烽偖绠�
+        List<String> toArr = userService.getEmailList();
+        //String[] toArrStr = new String[]{"perryhsu@163.com"};
+        //List toArr = Arrays.asList(toArrStr);
 
         for (int i = 0; i < list.size(); i++){
             Software software = list.get(i);
diff --git a/src/main/java/com/whyc/service/UserService.java b/src/main/java/com/whyc/service/UserService.java
index 2ce9dd5..48b9416 100644
--- a/src/main/java/com/whyc/service/UserService.java
+++ b/src/main/java/com/whyc/service/UserService.java
@@ -1,6 +1,8 @@
 package com.whyc.service;
 
 import com.baomidou.mybatisplus.core.conditions.Wrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
 import com.github.pagehelper.PageHelper;
 import com.github.pagehelper.PageInfo;
 import com.whyc.dto.Response;
@@ -18,6 +20,7 @@
 import javax.servlet.ServletContext;
 import java.security.InvalidParameterException;
 import java.util.*;
+import java.util.stream.Collectors;
 
 @Service
 @Slf4j
@@ -190,4 +193,10 @@
         }
     }
 
+    public List<String> getEmailList() {
+        QueryWrapper<User> query = Wrappers.query();
+        query.select("email");
+        query.eq("role_id",2);
+        return userMapper.selectList(query).stream().map(User::getEmail).collect(Collectors.toList());
+    }
 }

--
Gitblit v1.9.1