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