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