ParseEmailServiceImpl.java 5.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135
  1. package com.simuwang.manage.service.impl;
  2. import com.simuwang.base.common.enums.ParseStatus;
  3. import com.simuwang.base.common.support.MybatisPage;
  4. import com.simuwang.base.common.util.DateUtils;
  5. import com.simuwang.base.mapper.EmailFileInfoMapper;
  6. import com.simuwang.base.mapper.EmailParseInfoMapper;
  7. import com.simuwang.base.mapper.EmailTypeRuleMapper;
  8. import com.simuwang.base.pojo.dos.EmailFileInfoDO;
  9. import com.simuwang.base.pojo.dos.EmailParseInfoDO;
  10. import com.simuwang.base.pojo.dos.EmailTypeRuleDO;
  11. import com.simuwang.base.pojo.dto.query.EmailFileQuery;
  12. import com.simuwang.base.pojo.dto.query.EmailParseQuery;
  13. import com.simuwang.base.pojo.vo.EmailFileInfoVO;
  14. import com.simuwang.base.pojo.vo.EmailParseDetailVO;
  15. import com.simuwang.base.pojo.vo.EmailParseInfoVO;
  16. import com.simuwang.base.pojo.vo.EmailTypeRuleVO;
  17. import com.simuwang.manage.service.ParseEmailService;
  18. import com.smppw.common.pojo.enums.TimeRange;
  19. import com.smppw.utils.DateUtil;
  20. import org.springframework.beans.factory.annotation.Autowired;
  21. import org.springframework.stereotype.Service;
  22. import java.util.Date;
  23. import java.util.HashMap;
  24. import java.util.List;
  25. import java.util.Map;
  26. import java.util.stream.Collectors;
  27. /**
  28. * FileName: ParseEmailServiceImpl
  29. * Author: chenjianhua
  30. * Date: 2024/9/10 11:26
  31. * Description: ${DESCRIPTION}
  32. */
  33. @Service
  34. public class ParseEmailServiceImpl implements ParseEmailService {
  35. @Autowired
  36. private EmailTypeRuleMapper emailTypeRuleMapper;
  37. @Autowired
  38. private EmailParseInfoMapper emailParseInfoMapper;
  39. @Autowired
  40. private EmailFileInfoMapper emailFileInfoMapper;
  41. @Override
  42. public void saveEmailType(EmailTypeRuleVO emailTypeRuleVO) {
  43. EmailTypeRuleDO ruleDO = new EmailTypeRuleDO();
  44. ruleDO.setId(emailTypeRuleVO.getId());
  45. ruleDO.setNav(emailTypeRuleVO.getNav());
  46. ruleDO.setReport(emailTypeRuleVO.getReport());
  47. ruleDO.setValuation(emailTypeRuleVO.getValuation());
  48. ruleDO.setUpdateTime(new Date());
  49. if(ruleDO.getId() == null){
  50. ruleDO.setCreateTime(new Date());
  51. emailTypeRuleMapper.saveEmailType(ruleDO);
  52. }else{
  53. emailTypeRuleMapper.updateEmailType(ruleDO);
  54. }
  55. }
  56. @Override
  57. public EmailTypeRuleVO searchEmailType() {
  58. EmailTypeRuleVO emailTypeRuleVO = new EmailTypeRuleVO();
  59. EmailTypeRuleDO emailTypeRuleDO = emailTypeRuleMapper.searchEmailType();
  60. if(emailTypeRuleDO == null){
  61. return emailTypeRuleVO;
  62. }
  63. emailTypeRuleVO.setId(emailTypeRuleDO.getId());
  64. emailTypeRuleVO.setNav(emailTypeRuleDO.getNav());
  65. emailTypeRuleVO.setValuation(emailTypeRuleDO.getValuation());
  66. emailTypeRuleVO.setReport(emailTypeRuleDO.getReport());
  67. return emailTypeRuleVO;
  68. }
  69. @Override
  70. public MybatisPage<EmailParseInfoVO> searchEmailList(EmailParseQuery emailParseQuery){
  71. if(!emailParseQuery.getTimeRange().equals(TimeRange.Custom)){
  72. emailParseQuery.setEndDate(DateUtils.getAroundToday(1));
  73. emailParseQuery.setStartDate( DateUtil.RangeTime(emailParseQuery.getTimeRange().getFloatDateSymbel(),DateUtil.getTodayDate()));
  74. }else{
  75. //自定义时间,把结束时间延后一天,确保时间判断能查到结束日期当天的数据
  76. emailParseQuery.setEndDate(DateUtil.getAroundDate(DateUtils.parse(emailParseQuery.getEndDate(),DateUtils.YYYY_MM_DD),1));
  77. }
  78. List<EmailParseInfoDO> emailParseInfoDOList = emailParseInfoMapper.searchEmailList(emailParseQuery);
  79. List<EmailParseInfoVO> emailParseInfoVOList = emailParseInfoDOList.stream().map(EmailParseInfoDO::toVO).collect(Collectors.toList());
  80. for(EmailParseInfoVO vo : emailParseInfoVOList){
  81. List<EmailFileInfoDO> emailFileInfoList = emailFileInfoMapper.queryByEmailId(vo.getId());
  82. List<EmailFileInfoVO> emailFileInfoVOList = emailFileInfoList.stream().map(EmailFileInfoDO::toVO).collect(Collectors.toList());
  83. vo.setEmailFileInfoList(emailFileInfoVOList);
  84. }
  85. long total = emailParseInfoMapper.countEmailList(emailParseQuery);
  86. return MybatisPage.of(total,emailParseInfoVOList);
  87. }
  88. @Override
  89. public Map<String, Integer> searchEmailCount(TimeRange timeRange) {
  90. Map<String, Integer> result = new HashMap<>();
  91. String parseDate = getParseDate(timeRange, DateUtils.getDate());
  92. Integer parseTotal = emailParseInfoMapper.searchEmailCount(parseDate,null);
  93. result.put("parseTotal",parseTotal);
  94. Integer parseSuccess = emailParseInfoMapper.searchEmailCount(parseDate, ParseStatus.Success.getCode());
  95. result.put("parseSuccess",parseSuccess);
  96. Integer parseFail = emailParseInfoMapper.searchEmailCount(parseDate, ParseStatus.Fail.getCode());
  97. result.put("parseFail",parseFail);
  98. return result;
  99. }
  100. private String getParseDate(TimeRange timeRange, String date) {
  101. String preDate =DateUtil.RangeTime(timeRange.getFloatDateSymbel(),date);
  102. return preDate;
  103. }
  104. @Override
  105. public EmailFileInfoVO getEmailFileById(Integer fileId) {
  106. EmailFileInfoDO emailFileInfoDO = emailFileInfoMapper.getEmailFileById(fileId);
  107. EmailFileInfoVO fileInfoVO = new EmailFileInfoVO();
  108. if(emailFileInfoDO != null){
  109. fileInfoVO.setId(emailFileInfoDO.getId());
  110. fileInfoVO.setEmailId(emailFileInfoDO.getEmailId());
  111. fileInfoVO.setFilePath(emailFileInfoDO.getFilePath());
  112. fileInfoVO.setFileName(emailFileInfoDO.getFileName());
  113. }
  114. return fileInfoVO;
  115. }
  116. @Override
  117. public MybatisPage<EmailParseDetailVO> searchEmailDetailById(EmailFileQuery emailFileQuery) {
  118. //根据邮件ID获取附件信息
  119. List<EmailParseDetailVO> result = emailFileInfoMapper.searchEmailDetailById(emailFileQuery);
  120. long total = emailFileInfoMapper.countEmailDetailById(emailFileQuery);
  121. return MybatisPage.of(total,result);
  122. }
  123. }