From ff1fec7eae681e89e607fd441d2597ab67b5ed2a Mon Sep 17 00:00:00 2001 From: guyue <1721849008@qq.com> Date: 星期二, 12 八月 2025 19:04:34 +0800 Subject: [PATCH] 修改查看时间和删除关键词 --- src/main/java/com/linghu/service/impl/KeywordServiceImpl.java | 33 ++++++++++++++++----------------- 1 files changed, 16 insertions(+), 17 deletions(-) diff --git a/src/main/java/com/linghu/service/impl/KeywordServiceImpl.java b/src/main/java/com/linghu/service/impl/KeywordServiceImpl.java index a0cf143..389b4c0 100644 --- a/src/main/java/com/linghu/service/impl/KeywordServiceImpl.java +++ b/src/main/java/com/linghu/service/impl/KeywordServiceImpl.java @@ -8,6 +8,7 @@ import com.alibaba.excel.write.metadata.holder.WriteWorkbookHolder; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.linghu.config.FinalStatus; import com.linghu.mapper.ReferenceMapper; import com.linghu.model.common.ResponseResult; import com.linghu.model.dto.ExportFeedDTO; @@ -15,6 +16,7 @@ import com.linghu.model.dto.ExportGetResultDTO; import com.linghu.model.dto.ExportStaticsDTO; import com.linghu.model.entity.Keyword; +import com.linghu.model.entity.KeywordTask; import com.linghu.model.entity.Platform; import com.linghu.model.entity.Reference; import com.linghu.model.excel.FeedExportExcel; @@ -24,6 +26,7 @@ import com.linghu.service.KeywordService; import com.linghu.mapper.KeywordMapper; +import com.linghu.service.KeywordTaskService; import com.linghu.service.PlatformService; import com.linghu.service.ReferenceService; import org.apache.poi.ss.usermodel.DataValidation; @@ -66,6 +69,8 @@ private ReferenceMapper referenceMapper; @Autowired private PlatformService platformService; + @Autowired + private KeywordTaskService keywordTaskService; @Override public ResponseResult<KeywordStaticsListVO> statics(Integer keywordId, Integer questionId) { @@ -75,7 +80,7 @@ if (keyword == null) { return ResponseResult.error("关键词不存在"); } - if (!"completed".equals(keyword.getStatus())) { + if (!FinalStatus.COMPLETED.getValue().equals(keyword.getStatus())) { return ResponseResult.success(); } List<KeywordStaticsVO> statics = this.getBaseMapper().statics(keywordId, questionId, keyword.getNum()); @@ -97,7 +102,7 @@ if (keyword == null) { return ResponseResult.error("关键词不存在"); } - if (!"completed".equals(keyword.getStatus())) { + if (!FinalStatus.COMPLETED.getValue().equals(keyword.getStatus())) { return ResponseResult.error("关键词采集未完成"); } List<PlatformProportionVO> result = this.getBaseMapper().getResultByTypeId(keywordId, questionId, @@ -113,7 +118,7 @@ if (keyword == null) { return ResponseResult.error("关键词不存在"); } - if (!"completed".equals(keyword.getStatus())) { + if (!FinalStatus.COMPLETED.getValue().equals(keyword.getStatus())) { return ResponseResult.error("关键词采集未完成"); } @@ -136,26 +141,20 @@ GetTimeVO vo = new GetTimeVO(); Keyword keyword = this.getById(keywordId); - LambdaQueryWrapper<Reference> queryWrapper = new LambdaQueryWrapper<>(); - queryWrapper.eq(Reference::getKeyword_id, keywordId); - if (questionId != null) { - queryWrapper.eq(Reference::getQuestion_id, questionId); - } - queryWrapper.eq(Reference::getNum,keyword.getNum()); + LambdaQueryWrapper<KeywordTask> queryWrapper = new LambdaQueryWrapper<>(); + queryWrapper.eq(KeywordTask::getKeyword_id, keywordId); + queryWrapper.eq(KeywordTask::getNum,keyword.getNum()); - List<Reference> list = referenceService.list(queryWrapper); + List<KeywordTask> list = keywordTaskService.list(queryWrapper); if (null != list && !list.isEmpty()) { vo.setNow(list.get(0).getCreate_time()); } //首次 - LambdaQueryWrapper<Reference> queryWrapper2 = new LambdaQueryWrapper<>(); - queryWrapper2.eq(Reference::getKeyword_id, keywordId); - if (questionId != null) { - queryWrapper2.eq(Reference::getQuestion_id, questionId); - } - queryWrapper2.eq(Reference::getNum,1); + LambdaQueryWrapper<KeywordTask> queryWrapper2 = new LambdaQueryWrapper<>(); + queryWrapper2.eq(KeywordTask::getKeyword_id, keywordId); + queryWrapper2.eq(KeywordTask::getNum,1); - List<Reference> list2 = referenceService.list(queryWrapper2); + List<KeywordTask> list2 = keywordTaskService.list(queryWrapper2); if (null != list2 && !list2.isEmpty()) { vo.setFirst(list2.get(0).getCreate_time()); } -- Gitblit v1.7.1