EmailParseService.java 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600
  1. package com.smppw.modaq.domain.service;
  2. import cn.hutool.core.collection.CollUtil;
  3. import cn.hutool.core.collection.ListUtil;
  4. import cn.hutool.core.date.DateUtil;
  5. import cn.hutool.core.exceptions.ExceptionUtil;
  6. import cn.hutool.core.map.MapUtil;
  7. import cn.hutool.core.util.StrUtil;
  8. import com.smppw.modaq.application.components.ReportParseUtils;
  9. import com.smppw.modaq.application.components.report.parser.ReportParser;
  10. import com.smppw.modaq.application.components.report.parser.ReportParserFactory;
  11. import com.smppw.modaq.application.components.report.writer.ReportWriter;
  12. import com.smppw.modaq.application.components.report.writer.ReportWriterFactory;
  13. import com.smppw.modaq.application.util.EmailUtil;
  14. import com.smppw.modaq.common.conts.DateConst;
  15. import com.smppw.modaq.common.conts.EmailParseStatusConst;
  16. import com.smppw.modaq.common.conts.EmailTypeConst;
  17. import com.smppw.modaq.common.enums.ReportParseStatus;
  18. import com.smppw.modaq.common.enums.ReportParserFileType;
  19. import com.smppw.modaq.common.enums.ReportType;
  20. import com.smppw.modaq.common.exception.ReportParseException;
  21. import com.smppw.modaq.domain.dto.EmailContentInfoDTO;
  22. import com.smppw.modaq.domain.dto.EmailZipFileDTO;
  23. import com.smppw.modaq.domain.dto.MailboxInfoDTO;
  24. import com.smppw.modaq.domain.dto.report.ParseResult;
  25. import com.smppw.modaq.domain.dto.report.ReportData;
  26. import com.smppw.modaq.domain.dto.report.ReportParserParams;
  27. import com.smppw.modaq.domain.entity.EmailFileInfoDO;
  28. import com.smppw.modaq.domain.entity.EmailParseInfoDO;
  29. import com.smppw.modaq.domain.mapper.EmailFileInfoMapper;
  30. import com.smppw.modaq.domain.mapper.EmailParseInfoMapper;
  31. import com.smppw.modaq.infrastructure.util.ExcelUtil;
  32. import com.smppw.modaq.infrastructure.util.FileUtil;
  33. import jakarta.mail.*;
  34. import jakarta.mail.internet.MimeUtility;
  35. import jakarta.mail.search.ComparisonTerm;
  36. import jakarta.mail.search.ReceivedDateTerm;
  37. import jakarta.mail.search.SearchTerm;
  38. import org.apache.commons.compress.archivers.ArchiveException;
  39. import org.slf4j.Logger;
  40. import org.slf4j.LoggerFactory;
  41. import org.springframework.beans.factory.annotation.Value;
  42. import org.springframework.stereotype.Service;
  43. import org.springframework.util.StopWatch;
  44. import java.io.File;
  45. import java.io.IOException;
  46. import java.nio.file.Path;
  47. import java.nio.file.Paths;
  48. import java.util.*;
  49. import java.util.regex.Matcher;
  50. import java.util.regex.Pattern;
  51. import java.util.stream.Collectors;
  52. /**
  53. * @author mozuwen
  54. * @date 2024-09-04
  55. * @description 邮件解析服务
  56. */
  57. @Service
  58. public class EmailParseService {
  59. // public static final int stepSize = 10000;
  60. private static final Logger log = LoggerFactory.getLogger(EmailParseService.class);
  61. // private final EmailFieldMappingMapper emailFieldMapper;
  62. private final EmailParseInfoMapper emailParseInfoMapper;
  63. private final EmailFileInfoMapper emailFileInfoMapper;
  64. /* 报告解析和入库的方法 */
  65. private final ReportParserFactory reportParserFactory;
  66. private final ReportWriterFactory reportWriterFactory;
  67. @Value("${email.file.path}")
  68. private String path;
  69. public EmailParseService(EmailParseInfoMapper emailParseInfoMapper,
  70. EmailFileInfoMapper emailFileInfoMapper,
  71. ReportParserFactory reportParserFactory,
  72. ReportWriterFactory reportWriterFactory) {
  73. this.emailParseInfoMapper = emailParseInfoMapper;
  74. this.emailFileInfoMapper = emailFileInfoMapper;
  75. this.reportParserFactory = reportParserFactory;
  76. this.reportWriterFactory = reportWriterFactory;
  77. }
  78. /**
  79. * 解析指定邮箱指定时间范围内的邮件
  80. *
  81. * @param mailboxInfoDTO 邮箱配置信息
  82. * @param startDate 邮件起始日期(yyyy-MM-dd HH:mm:ss)
  83. * @param endDate 邮件截止日期(yyyy-MM-dd HH:mm:ss, 为null,将解析邮件日期小于等于startDate的当天邮件)
  84. */
  85. public void parseEmail(MailboxInfoDTO mailboxInfoDTO, Date startDate, Date endDate) {
  86. log.info("开始邮件解析 -> 邮箱信息:{},开始时间:{},结束时间:{}", mailboxInfoDTO, DateUtil.format(startDate,
  87. DateConst.YYYY_MM_DD_HH_MM_SS), DateUtil.format(endDate, DateConst.YYYY_MM_DD_HH_MM_SS));
  88. // 邮件类型配置
  89. Map<Integer, List<String>> emailTypeMap = getEmailType();
  90. // 邮件字段识别映射表
  91. // Map<String, List<String>> emailFieldMap = getEmailFieldMapping();
  92. Map<String, List<EmailContentInfoDTO>> emailContentMap;
  93. try {
  94. emailContentMap = realEmail(mailboxInfoDTO, emailTypeMap, startDate, endDate);
  95. } catch (Exception e) {
  96. log.info("采集邮件失败 -> 邮箱配置信息:{},堆栈信息:{}", mailboxInfoDTO, ExceptionUtil.stacktraceToString(e));
  97. return;
  98. }
  99. if (MapUtil.isEmpty(emailContentMap)) {
  100. log.info("未采集到邮件 -> 邮箱配置信息:{},开始时间:{},结束时间:{}", mailboxInfoDTO,
  101. DateUtil.format(startDate, DateConst.YYYY_MM_DD_HH_MM_SS), DateUtil.format(endDate, DateConst.YYYY_MM_DD_HH_MM_SS));
  102. return;
  103. }
  104. for (Map.Entry<String, List<EmailContentInfoDTO>> emailEntry : emailContentMap.entrySet()) {
  105. List<EmailContentInfoDTO> emailContentInfoDTOList = emailEntry.getValue();
  106. if (CollUtil.isEmpty(emailContentInfoDTOList)) {
  107. log.warn("未采集到正文或附件");
  108. continue;
  109. }
  110. log.info("开始解析邮件数据 -> 邮件主题:{},邮件日期:{}", emailContentInfoDTOList.get(0).getEmailTitle(), emailContentInfoDTOList.get(0).getEmailDate());
  111. Map<EmailContentInfoDTO, List<EmailZipFileDTO>> emailZipFileMap = MapUtil.newHashMap();
  112. Iterator<EmailContentInfoDTO> iterator = emailContentInfoDTOList.iterator();
  113. while (iterator.hasNext()) {
  114. EmailContentInfoDTO emailContentInfoDTO = iterator.next();
  115. // 正文不用解压附件
  116. if (emailContentInfoDTO.getFileName() != null && emailContentInfoDTO.getFileName().endsWith(".html")) {
  117. emailZipFileMap.put(emailContentInfoDTO, ListUtil.empty());
  118. continue;
  119. }
  120. try {
  121. List<EmailZipFileDTO> fundNavDTOList = parseZipEmail(emailContentInfoDTO);
  122. emailZipFileMap.put(emailContentInfoDTO, fundNavDTOList);
  123. } catch (IOException | ArchiveException e) {
  124. log.error("压缩包解压失败:{}", ExceptionUtil.stacktraceToString(e));
  125. EmailParseInfoDO fail = buildEmailParseInfo(null, mailboxInfoDTO.getAccount(), emailContentInfoDTO);
  126. fail.setFailReason("压缩包解压失败");
  127. fail.setParseStatus(EmailParseStatusConst.FAIL);
  128. fail.setEmailKey(emailEntry.getKey());
  129. this.emailParseInfoMapper.insert(fail);
  130. iterator.remove();
  131. } catch (Exception e) {
  132. log.error("堆栈信息:{}", ExceptionUtil.stacktraceToString(e));
  133. }
  134. }
  135. // 保存相关信息 -> 邮件信息表,邮件文件表,邮件净值表,邮件规模表,基金净值表
  136. saveRelatedTable(emailEntry.getKey(), mailboxInfoDTO.getAccount(), emailZipFileMap);
  137. log.info("结束邮件解析 -> 邮箱信息:{},开始时间:{},结束时间:{}", mailboxInfoDTO,
  138. DateUtil.format(startDate, DateConst.YYYY_MM_DD_HH_MM_SS), DateUtil.format(endDate, DateConst.YYYY_MM_DD_HH_MM_SS));
  139. }
  140. }
  141. public List<EmailZipFileDTO> parseZipEmail(EmailContentInfoDTO emailContentInfoDTO) throws Exception {
  142. List<EmailZipFileDTO> resultList = ListUtil.list(false);
  143. Integer emailType = emailContentInfoDTO.getEmailType();
  144. String filepath = emailContentInfoDTO.getFilePath();
  145. if (ExcelUtil.isZip(filepath)) {
  146. handleCompressedFiles(filepath, ".zip", emailType, resultList);
  147. } else if (ExcelUtil.isRAR(filepath)) {
  148. handleCompressedFiles(filepath, ".rar", emailType, resultList);
  149. }
  150. return resultList;
  151. }
  152. private void handleCompressedFiles(String filepath, String extension, Integer emailType, List<EmailZipFileDTO> resultList) throws Exception {
  153. String destPath = getDestinationPath(filepath, extension);
  154. log.info("压缩包地址:{}, 解压后文件地址:{}", filepath, destPath);
  155. File destFile = new File(destPath);
  156. if (!destFile.exists()) {
  157. if (!destFile.mkdirs()) {
  158. throw new IOException("无法创建目标目录: " + destPath);
  159. }
  160. }
  161. List<String> extractedDirs;
  162. if (ExcelUtil.isZip(filepath)) {
  163. extractedDirs = ExcelUtil.extractCompressedFiles(filepath, destPath);
  164. } else if (ExcelUtil.isRAR(filepath)) {
  165. extractedDirs = ExcelUtil.extractRar5(filepath, destPath);
  166. } else {
  167. return;
  168. }
  169. for (String dir : extractedDirs) {
  170. // 如果邮件类型不满足解析条件则重新根据文件名判断
  171. if (!Objects.equals(EmailTypeConst.REPORT_EMAIL_TYPE, emailType)
  172. && !Objects.equals(EmailTypeConst.REPORT_LETTER_EMAIL_TYPE, emailType)) {
  173. emailType = EmailUtil.getEmailTypeBySubject(dir, this.getEmailType());
  174. }
  175. File file = new File(dir);
  176. if (file.isDirectory()) {
  177. String[] subDirs = file.list();
  178. if (subDirs != null) {
  179. for (String subDir : subDirs) {
  180. resultList.add(new EmailZipFileDTO(subDir, emailType));
  181. }
  182. } else {
  183. log.warn("目录 {} 下无文件", dir);
  184. }
  185. } else {
  186. resultList.add(new EmailZipFileDTO(dir, emailType));
  187. }
  188. }
  189. }
  190. private String getDestinationPath(String filepath, String extension) {
  191. Path path = Paths.get(filepath);
  192. String fileName = path.getFileName().toString();
  193. String baseName = fileName.substring(0, fileName.length() - extension.length());
  194. return path.getParent().resolve(baseName).toString();
  195. }
  196. public void saveRelatedTable(String emailKey, String emailAddress,
  197. Map<EmailContentInfoDTO, List<EmailZipFileDTO>> emailZipFileMap) {
  198. // python 报告解析接口结果
  199. List<ParseResult<ReportData>> dataList = ListUtil.list(false);
  200. for (Map.Entry<EmailContentInfoDTO, List<EmailZipFileDTO>> entry : emailZipFileMap.entrySet()) {
  201. EmailContentInfoDTO emailContentInfoDTO = entry.getKey();
  202. if (emailContentInfoDTO.getFileName() != null && emailContentInfoDTO.getFileName().endsWith(".html")) {
  203. continue;
  204. }
  205. Integer emailId = emailContentInfoDTO.getEmailId();
  206. EmailParseInfoDO emailParseInfoDO = buildEmailParseInfo(emailId, emailAddress, emailContentInfoDTO);
  207. emailParseInfoDO.setEmailKey(emailKey);
  208. emailId = saveEmailParseInfo(emailParseInfoDO);
  209. if (emailId == null) {
  210. continue;
  211. }
  212. List<EmailZipFileDTO> zipFiles = entry.getValue();
  213. if (CollUtil.isNotEmpty(zipFiles)) {
  214. for (EmailZipFileDTO zipFile : zipFiles) {
  215. EmailFileInfoDO emailFile = saveEmailFileInfo(emailId, null, zipFile.getFilename(), zipFile.getFilepath(), null);
  216. // 解析结果(可以从python获取或者自行解析)并保存报告
  217. ParseResult<ReportData> parseResult = this.parseReportAndHandleResult(emailFile.getId(), zipFile.getFilename(),
  218. zipFile.getFilepath(), zipFile.getEmailType(), emailFile.getAiFileId());
  219. dataList.add(parseResult);
  220. }
  221. } else {
  222. String fileName = emailContentInfoDTO.getFileName();
  223. EmailFileInfoDO emailFile = saveEmailFileInfo(emailId, emailContentInfoDTO.getFileId(), fileName,
  224. emailContentInfoDTO.getFilePath(), emailContentInfoDTO.getAiFileId());
  225. // 解析结果(可以从python获取或者自行解析)并保存报告
  226. ParseResult<ReportData> parseResult = this.parseReportAndHandleResult(emailFile.getId(), fileName,
  227. emailContentInfoDTO.getFilePath(), emailContentInfoDTO.getEmailType(), emailFile.getAiFileId());
  228. dataList.add(parseResult);
  229. }
  230. String failReason = null;
  231. int emailParseStatus = EmailParseStatusConst.SUCCESS;
  232. // 报告邮件有一条失败就表示整个邮件解析失败
  233. if (CollUtil.isNotEmpty(dataList)) {
  234. // ai解析结果
  235. List<ReportData> aiParaseList = dataList.stream().map(ParseResult::getData)
  236. .filter(Objects::nonNull).filter(e -> Objects.equals(true, e.getAiParse())).toList();
  237. if (CollUtil.isNotEmpty(aiParaseList)) {
  238. for (ReportData data : aiParaseList) {
  239. this.emailFileInfoMapper.updateAiParseByFileId(data.getBaseInfo().getFileId(), data.getAiParse(), data.getAiFileId());
  240. }
  241. }
  242. long failNum = dataList.stream().filter(e -> !Objects.equals(EmailParseStatusConst.SUCCESS, e.getStatus())).count();
  243. if (failNum > 0) {
  244. emailParseStatus = EmailParseStatusConst.FAIL;
  245. failReason = dataList.stream().map(ParseResult::getMsg).collect(Collectors.joining(";"));
  246. }
  247. }
  248. emailParseInfoMapper.updateParseStatus(emailId, emailParseStatus, failReason);
  249. }
  250. }
  251. private ParseResult<ReportData> parseReportAndHandleResult(int fileId, String fileName,
  252. String filepath, Integer emailType, String aiFileId) {
  253. ParseResult<ReportData> result = new ParseResult<>();
  254. boolean reportFlag = !Objects.equals(EmailTypeConst.REPORT_EMAIL_TYPE, emailType)
  255. && !Objects.equals(EmailTypeConst.REPORT_LETTER_EMAIL_TYPE, emailType);
  256. if (reportFlag || StrUtil.isBlank(fileName) || fileName.endsWith(".html")) {
  257. result.setStatus(ReportParseStatus.NOT_A_REPORT.getCode());
  258. result.setMsg(StrUtil.format(ReportParseStatus.NOT_A_REPORT.getMsg(), fileName));
  259. return result;
  260. }
  261. Pattern pattern = Pattern.compile("[A-Z0-9]{6}");
  262. Matcher matcher = pattern.matcher(fileName);
  263. String registerNumber = null;
  264. if (matcher.find()) {
  265. registerNumber = matcher.group();
  266. }
  267. // 类型识别---先识别季度报告,没有季度再识别年度报告,最后识别月报
  268. ReportType reportType = ReportParseUtils.matchReportType(fileName);
  269. if (Objects.equals(EmailTypeConst.REPORT_LETTER_EMAIL_TYPE, emailType)) {
  270. reportType = ReportType.LETTER;
  271. }
  272. // 解析器--如果开启python解析则直接调用python接口,否则根据文件后缀获取对应解析器
  273. ReportParserFileType fileType;
  274. String fileSuffix = StrUtil.subAfter(fileName, ".", true);
  275. fileType = ReportParserFileType.getBySuffix(fileSuffix);
  276. // 不支持的格式
  277. if (fileType == null) {
  278. result.setStatus(ReportParseStatus.NO_SUPPORT_TEMPLATE.getCode());
  279. result.setMsg(StrUtil.format(ReportParseStatus.NO_SUPPORT_TEMPLATE.getMsg(), fileName));
  280. return result;
  281. }
  282. // 不是定期报告的判断逻辑放在不支持的格式下面
  283. if (reportType == null) {
  284. result.setStatus(ReportParseStatus.NOT_A_REPORT.getCode());
  285. result.setMsg(StrUtil.format(ReportParseStatus.NOT_A_REPORT.getMsg(), fileName));
  286. return result;
  287. }
  288. // 解析报告
  289. ReportData reportData = null;
  290. StopWatch parserWatch = new StopWatch();
  291. parserWatch.start();
  292. try {
  293. ReportParserParams params = ReportParserParams.builder().fileId(fileId).filename(fileName)
  294. .filepath(filepath).registerNumber(registerNumber).reportType(reportType).aiFileId(aiFileId).build();
  295. ReportParser<ReportData> instance = this.reportParserFactory.getInstance(reportType, fileType);
  296. reportData = instance.parse(params);
  297. result.setStatus(1);
  298. result.setMsg("报告解析成功");
  299. result.setData(reportData);
  300. } catch (ReportParseException e) {
  301. log.error("解析失败\n{}", StrUtil.format(e.getMsg(), fileName));
  302. result.setStatus(e.getCode());
  303. result.setMsg(StrUtil.format(e.getMsg(), fileName));
  304. } catch (Exception e) {
  305. log.error("解析错误\n{}", ExceptionUtil.stacktraceToString(e));
  306. result.setStatus(ReportParseStatus.PARSE_FAIL.getCode());
  307. result.setMsg(StrUtil.format(ReportParseStatus.PARSE_FAIL.getMsg(), e.getMessage()));
  308. } finally {
  309. parserWatch.stop();
  310. if (log.isInfoEnabled()) {
  311. log.info("报告{}解析结果为{},耗时{}ms", fileName, reportData, parserWatch.getTotalTimeMillis());
  312. }
  313. }
  314. // 保存报告解析结果
  315. if (reportData != null) {
  316. StopWatch writeWatch = new StopWatch();
  317. writeWatch.start();
  318. try {
  319. ReportWriter<ReportData> instance = this.reportWriterFactory.getInstance(reportType);
  320. instance.write(reportData);
  321. } catch (Exception e) {
  322. log.error("报告{}结果保存失败\n{}", fileName, ExceptionUtil.stacktraceToString(e));
  323. } finally {
  324. writeWatch.stop();
  325. if (log.isInfoEnabled()) {
  326. log.info("报告{}解析结果保存完成,耗时{}ms", fileName, writeWatch.getTotalTimeMillis());
  327. }
  328. }
  329. }
  330. return result;
  331. }
  332. private EmailFileInfoDO saveEmailFileInfo(Integer emailId, Integer fileId, String fileName, String filePath, String aiFileId) {
  333. EmailFileInfoDO emailFileInfoDO = buildEmailFileInfoDO(emailId, fileId, fileName, filePath);
  334. emailFileInfoDO.setAiFileId(aiFileId);
  335. if (emailFileInfoDO.getId() != null) {
  336. emailFileInfoMapper.updateTimeById(fileId, new Date());
  337. return emailFileInfoDO;
  338. }
  339. emailFileInfoMapper.insert(emailFileInfoDO);
  340. return emailFileInfoDO;
  341. }
  342. private EmailFileInfoDO buildEmailFileInfoDO(Integer emailId, Integer fileId, String fileName, String filePath) {
  343. EmailFileInfoDO emailFileInfoDO = new EmailFileInfoDO();
  344. emailFileInfoDO.setId(fileId);
  345. emailFileInfoDO.setEmailId(emailId);
  346. emailFileInfoDO.setFileName(fileName);
  347. emailFileInfoDO.setFilePath(filePath);
  348. emailFileInfoDO.setIsvalid(1);
  349. emailFileInfoDO.setCreatorId(0);
  350. emailFileInfoDO.setCreateTime(new Date());
  351. emailFileInfoDO.setUpdaterId(0);
  352. emailFileInfoDO.setUpdateTime(new Date());
  353. return emailFileInfoDO;
  354. }
  355. private Integer saveEmailParseInfo(EmailParseInfoDO emailParseInfoDO) {
  356. if (emailParseInfoDO == null) {
  357. return null;
  358. }
  359. // 重新邮件功能 -> 修改解析时间和更新时间
  360. if (emailParseInfoDO.getId() != null) {
  361. emailParseInfoMapper.updateParseTime(emailParseInfoDO.getId(), emailParseInfoDO.getParseDate());
  362. return emailParseInfoDO.getId();
  363. }
  364. // // 根据邮件发送人、邮件地址、邮箱日期、主题找到是否已经存在的记录(不管是否成功),已存在就不解析了
  365. // EmailParseInfoDO temp = this.emailParseInfoMapper.searchEmail(emailParseInfoDO);
  366. // if (temp != null) {
  367. // return null;
  368. // }
  369. emailParseInfoMapper.insert(emailParseInfoDO);
  370. return emailParseInfoDO.getId();
  371. }
  372. private EmailParseInfoDO buildEmailParseInfo(Integer emailId, String emailAddress, EmailContentInfoDTO emailContentInfoDTO) {
  373. EmailParseInfoDO emailParseInfoDO = new EmailParseInfoDO();
  374. emailParseInfoDO.setId(emailId);
  375. emailParseInfoDO.setSenderEmail(emailContentInfoDTO.getSenderEmail());
  376. emailParseInfoDO.setEmail(emailAddress);
  377. emailParseInfoDO.setEmailDate(DateUtil.parse(emailContentInfoDTO.getEmailDate(), DateConst.YYYY_MM_DD_HH_MM_SS));
  378. emailParseInfoDO.setParseDate(emailContentInfoDTO.getParseDate() == null ? null : DateUtil.parseDate(emailContentInfoDTO.getParseDate()));
  379. emailParseInfoDO.setEmailTitle(emailContentInfoDTO.getEmailTitle());
  380. emailParseInfoDO.setEmailType(emailContentInfoDTO.getEmailType());
  381. emailParseInfoDO.setParseStatus(EmailParseStatusConst.SUCCESS);
  382. emailParseInfoDO.setIsvalid(1);
  383. emailParseInfoDO.setCreatorId(0);
  384. emailParseInfoDO.setCreateTime(new Date());
  385. emailParseInfoDO.setUpdaterId(0);
  386. emailParseInfoDO.setUpdateTime(new Date());
  387. return emailParseInfoDO;
  388. }
  389. public Map<Integer, List<String>> getEmailType() {
  390. Map<Integer, List<String>> emailTypeMap = MapUtil.newHashMap(3, true);
  391. emailTypeMap.put(EmailTypeConst.REPORT_EMAIL_TYPE,
  392. ListUtil.toList("月报", "月度报告", "季报", "季度报告", "年报", "年度报告"));
  393. emailTypeMap.put(EmailTypeConst.REPORT_LETTER_EMAIL_TYPE,
  394. ListUtil.toList("确认单", "确认函", "交易确认数据", "赎回确认", "申购确认", "分红确认", "确认表", "交易确认", "确认"));
  395. return emailTypeMap;
  396. }
  397. /**
  398. * 读取邮件
  399. *
  400. * @param mailboxInfoDTO 邮箱配置信息
  401. * @param emailTypeMap 邮件类型识别规则映射表
  402. * @param startDate 邮件起始日期
  403. * @param endDate 邮件截止日期(为null,将解析邮件日期小于等于startDate的当天邮件)
  404. * @return 读取到的邮件信息
  405. * @throws Exception 异常信息
  406. */
  407. private Map<String, List<EmailContentInfoDTO>> realEmail(MailboxInfoDTO mailboxInfoDTO,
  408. Map<Integer, List<String>> emailTypeMap, Date startDate, Date endDate) throws Exception {
  409. Store store = EmailUtil.getStoreNew(mailboxInfoDTO);
  410. if (store == null) {
  411. return MapUtil.newHashMap();
  412. }
  413. // 默认读取收件箱的邮件
  414. Folder folder = store.getFolder("INBOX");
  415. folder.open(Folder.READ_ONLY);
  416. Message[] messages = getEmailMessage(folder, mailboxInfoDTO.getProtocol(), startDate);
  417. if (messages == null || messages.length == 0) {
  418. log.info("获取不到邮件 -> 邮箱信息:{},开始时间:{},结束时间:{}", mailboxInfoDTO, startDate, endDate);
  419. return MapUtil.newHashMap();
  420. }
  421. Map<String, List<EmailContentInfoDTO>> emailMessageMap = MapUtil.newHashMap();
  422. for (Message message : messages) {
  423. long start = System.currentTimeMillis();
  424. List<EmailContentInfoDTO> emailContentInfoDTOList = CollUtil.newArrayList();
  425. String uuidKey = UUID.randomUUID().toString().replaceAll("-", "");
  426. Integer emailType;
  427. String senderEmail;
  428. String emailTitle = null;
  429. try {
  430. Date emailDate = message.getSentDate();
  431. boolean isNotParseConditionSatisfied = emailDate == null || (endDate != null && emailDate.compareTo(endDate) > 0) || (startDate != null && emailDate.compareTo(startDate) < 0);
  432. if (isNotParseConditionSatisfied) {
  433. continue;
  434. }
  435. emailTitle = message.getSubject();
  436. senderEmail = getSenderEmail(message);
  437. emailType = EmailUtil.getEmailTypeBySubject(emailTitle, emailTypeMap);
  438. String emailDateStr = DateUtil.format(emailDate, DateConst.YYYY_MM_DD_HH_MM_SS);
  439. if (emailType == null) {
  440. log.info("邮件不满足解析条件 -> 邮件主题:{},邮件日期:{}", emailTitle, emailDateStr);
  441. continue;
  442. }
  443. log.info("邮件{} 基本信息获取完成,开始下载附件!邮件日期:{}", emailTitle, emailDateStr);
  444. Object content = message.getContent();
  445. if (content instanceof Multipart multipart) {
  446. this.reMultipart(mailboxInfoDTO.getAccount(), emailTitle, emailDate, multipart, emailContentInfoDTOList);
  447. } else if (content instanceof Part part) {
  448. this.rePart(mailboxInfoDTO.getAccount(), emailTitle, emailDate, part, emailContentInfoDTOList);
  449. } else {
  450. log.warn("不支持的邮件数据 {}", emailTitle);
  451. }
  452. if (CollUtil.isNotEmpty(emailContentInfoDTOList)) {
  453. emailContentInfoDTOList.forEach(e -> {
  454. e.setEmailType(emailType);
  455. e.setSenderEmail(senderEmail);
  456. });
  457. emailMessageMap.put(uuidKey, emailContentInfoDTOList);
  458. }
  459. } catch (Exception e) {
  460. log.error("获取邮箱的邮件{} 报错,堆栈信息:{}", emailTitle, ExceptionUtil.stacktraceToString(e));
  461. } finally {
  462. if (log.isInfoEnabled()) {
  463. log.info("邮件{} 下载完成,总计耗时{} ms", emailTitle, System.currentTimeMillis() - start);
  464. }
  465. }
  466. }
  467. folder.close(false);
  468. store.close();
  469. return emailMessageMap;
  470. }
  471. private void rePart(String account, String subject, Date sendDate, Part part, List<EmailContentInfoDTO> emailContentInfoDTOList) throws Exception {
  472. String disposition = part.getDisposition();
  473. if (disposition != null && (disposition.equals(Part.ATTACHMENT) || disposition.equals(Part.INLINE))) {
  474. String emailDate = DateUtil.format(sendDate, DateConst.YYYYMMDDHHMMSS24);
  475. String emailDateStr = DateUtil.format(sendDate, DateConst.YYYYMMDD);
  476. String filePath = path + File.separator + account + File.separator + emailDateStr + File.separator;
  477. EmailContentInfoDTO emailContentInfoDTO = new EmailContentInfoDTO();
  478. String fileName = MimeUtility.decodeText(part.getFileName());
  479. emailContentInfoDTO.setFileName(fileName);
  480. emailContentInfoDTO.setFileSize((long) part.getSize());
  481. String realPath = filePath + emailDate + fileName;
  482. File saveFile = cn.hutool.core.io.FileUtil.file(realPath);
  483. if (!saveFile.exists()) {
  484. if (!saveFile.getParentFile().exists()) {
  485. boolean mkdirs = saveFile.getParentFile().mkdirs();
  486. if (!mkdirs) {
  487. log.warn("file path mkdir failed.");
  488. }
  489. }
  490. FileUtil.saveFile(saveFile, part);
  491. } else {
  492. cn.hutool.core.io.FileUtil.del(saveFile);
  493. FileUtil.saveFile(saveFile, part);
  494. }
  495. emailContentInfoDTO.setFilePath(realPath);
  496. emailContentInfoDTO.setEmailAddress(account);
  497. emailContentInfoDTO.setEmailTitle(subject);
  498. emailContentInfoDTO.setEmailDate(DateUtil.format(sendDate, DateConst.YYYY_MM_DD_HH_MM_SS));
  499. emailContentInfoDTOList.add(emailContentInfoDTO);
  500. }
  501. }
  502. private void reMultipart(String account, String subject, Date emailDate, Multipart multipart, List<EmailContentInfoDTO> emailContentInfoDTOList) throws Exception {
  503. for (int i = 0; i < multipart.getCount(); i++) {
  504. Part bodyPart = multipart.getBodyPart(i);
  505. if (bodyPart.getContent() instanceof Multipart mp) {
  506. this.reMultipart(account, subject, emailDate, mp, emailContentInfoDTOList);
  507. } else {
  508. this.rePart(account, subject, emailDate, bodyPart, emailContentInfoDTOList);
  509. }
  510. }
  511. }
  512. private String getSenderEmail(Message message) {
  513. Address[] senderAddress;
  514. try {
  515. senderAddress = message.getFrom();
  516. if (senderAddress == null || senderAddress.length == 0) {
  517. return null;
  518. }
  519. // 此时的address是含有编码(MIME编码方式)后的文本和实际的邮件地址
  520. String address = "";
  521. for (Address from : senderAddress) {
  522. if (StrUtil.isNotBlank(from.toString())) {
  523. address = from.toString();
  524. break;
  525. }
  526. }
  527. // 正则表达式匹配邮件地址
  528. Pattern pattern = Pattern.compile("<(\\S+)>");
  529. Matcher matcher = pattern.matcher(address);
  530. if (matcher.find()) {
  531. return matcher.group(1);
  532. }
  533. // //说明匹配不到,直接获取sender
  534. // Address sender = message.getSender();
  535. // if (sender == null) {
  536. // return address;
  537. // }
  538. // String senderEmail = sender.toString();
  539. // log.info("senderEmail:" + senderEmail + "====================");
  540. // if (senderEmail.contains("<") && senderEmail.contains(">") && senderEmail.indexOf("<") < senderEmail.indexOf(">")) {
  541. // senderEmail = senderEmail.substring(senderEmail.indexOf("<") + 1, senderEmail.length() - 1);
  542. // }
  543. // return senderEmail;
  544. } catch (MessagingException e) {
  545. log.error(e.getMessage(), e);
  546. }
  547. return null;
  548. }
  549. private Message[] getEmailMessage(Folder folder, String protocol, Date startDate) {
  550. try {
  551. if (protocol.contains("imap")) {
  552. // 获取邮件日期大于等于startDate的邮件(搜索条件只支持按天)
  553. SearchTerm startDateTerm = new ReceivedDateTerm(ComparisonTerm.GE, startDate);
  554. return folder.search(startDateTerm);
  555. } else {
  556. return folder.getMessages();
  557. }
  558. } catch (MessagingException e) {
  559. throw new RuntimeException(e);
  560. }
  561. }
  562. }