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/OrderServiceImpl.java | 277 ++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 271 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/linghu/service/impl/OrderServiceImpl.java b/src/main/java/com/linghu/service/impl/OrderServiceImpl.java
index c2b03b3..9fb5444 100644
--- a/src/main/java/com/linghu/service/impl/OrderServiceImpl.java
+++ b/src/main/java/com/linghu/service/impl/OrderServiceImpl.java
@@ -1,12 +1,34 @@
package com.linghu.service.impl;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.metadata.IPage;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import com.linghu.config.FinalStatus;
+import com.linghu.model.common.ResponseResult;
+import com.linghu.model.dto.KeywordDto;
import com.linghu.model.dto.OrderDto;
import com.linghu.model.entity.Keyword;
+import com.linghu.model.entity.KeywordTask;
import com.linghu.model.entity.Orders;
+import com.linghu.model.entity.Question;
+import com.linghu.model.page.CustomPage;
import com.linghu.service.KeywordService;
+import com.linghu.service.KeywordTaskService;
import com.linghu.service.OrderService;
import com.linghu.mapper.OrderMapper;
+
+import java.text.SimpleDateFormat;
+import java.time.LocalDateTime;
+import java.util.ArrayList;
+import java.util.Date;
+import java.util.List;
+import java.util.Objects;
+import java.util.stream.Collectors;
+
+import com.linghu.service.QuestionService;
+import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -23,11 +45,16 @@
@Autowired
private KeywordService keywordService;
+ @Autowired
+ private QuestionService questionService;
+ @Autowired
+ private OrderMapper orderMapper;
+ @Autowired
+ private KeywordTaskService keywordTaskService;
@Override
@Transactional(rollbackFor = Exception.class)
- public boolean saveOrderWithKeywords(OrderDto orderDto,String order_id) {
-
+ public boolean saveOrderWithKeywords(OrderDto orderDto, String order_id) {
// 如果有关键词，则保存关键词
if (StringUtils.hasText(orderDto.getKeywords())) {
@@ -37,11 +64,12 @@
Keyword keyword = new Keyword();
keyword.setOrder_id(order_id);
keyword.setKeyword_name(keywordName.trim());
- keyword.setStatus("notSubmitted");
+ keyword.setStatus(FinalStatus.NOTSUBMITTED.getValue());
// keyword.setNum(1); // 默认采集轮数为1
keywordService.save(keyword);
}
}
+
}
return true;
@@ -60,10 +88,10 @@
return false;
}
- // 删除旧关键词（当状态为1时允许修改关键词）
+ // 删除旧关键词（当状态为未提交时允许修改关键词）
keywordService.lambdaUpdate()
.eq(Keyword::getOrder_id, orderDto.getOrder_id())
- .eq(Keyword::getStatus, "notSubmitted")
+ .eq(Keyword::getStatus, FinalStatus.NOTSUBMITTED.getValue())
.remove();
// 保存新关键词
@@ -74,7 +102,7 @@
Keyword keyword = new Keyword();
keyword.setOrder_id(orderDto.getOrder_id());
keyword.setKeyword_name(keywordName.trim());
- keyword.setStatus("notSubmitted");
+ keyword.setStatus(FinalStatus.NOTSUBMITTED.getValue());
keywordService.save(keyword);
}
}
@@ -82,4 +110,241 @@
return true;
}
+
+ @Override
+ public List<KeywordDto> getKeywordListByOrderId(String orderId) {
+ List<Keyword> keywords = keywordService.lambdaQuery()
+ .eq(Keyword::getOrder_id, orderId)
+ .list();
+
+ // 遍历关键词，获取每个关键词对应的提问词
+ List<KeywordDto> keywordDtos = new ArrayList<>();
+ for (Keyword keyword : keywords) {
+ KeywordDto dto = new KeywordDto();
+ BeanUtils.copyProperties(keyword, dto);
+ LambdaQueryWrapper<KeywordTask> queryWrapper = new LambdaQueryWrapper<>();
+ queryWrapper.eq(KeywordTask::getKeyword_id, keyword.getKeyword_id());
+ List<KeywordTask> keywordTasks = keywordTaskService.list(queryWrapper);
+
+ // 提取 task_id 列表
+ List<String> taskIdList = keywordTasks.stream()
+ .map(KeywordTask::getTask_id)
+ .filter(Objects::nonNull)
+ .collect(Collectors.toList());
+
+ dto.setTaskIdList(taskIdList); // 设置 task_id 列表
+ // 查询该关键词下的所有提问词
+ List<Question> questions = questionService.lambdaQuery()
+ .eq(Question::getKeyword_id, keyword.getKeyword_id())
+ .list();
+ dto.setQuestionList(questions);
+ keywordDtos.add(dto);
+ }
+ return keywordDtos;
+ }
+ @Override
+ public Page<String> getClientList(String clientName, Integer pageNum, Integer pageSize) {
+ Page<Orders> page = new Page<>(pageNum, pageSize);
+
+ // 构建查询条件（根据客户名称模糊搜索）
+ LambdaQueryWrapper<Orders> queryWrapper = new LambdaQueryWrapper<>();
+ queryWrapper.select(Orders::getClient_name) // 只查询客户名称字段
+ .eq(Orders::getDel_flag, 0) // 只查询未删除的订单
+ .groupBy(Orders::getClient_name); // 按客户名称分组去重
+ if (clientName != null && !clientName.isEmpty()) {
+ queryWrapper.like(Orders::getClient_name, clientName);
+ }
+ List<Orders> orders = orderMapper.selectList(queryWrapper);
+
+ // 转换为客户选项列表（统计每个客户的订单数量）
+ List<String> clientOptions = orders.stream()
+ .map(Orders::getClient_name)
+ .collect(Collectors.toList());
+
+ // 构建结果分页对象
+ Page<String> resultPage = new Page<>();
+ resultPage.setRecords(clientOptions);
+
+ return resultPage;
+
+
+ }
+
+ @Override
+ public ResponseResult<CustomPage<Orders>> getCustomPageResponseResult(Integer pageNum, Integer pageSize, String clientName, Integer status, String timeRange) {
+ LambdaQueryWrapper<Orders> queryWrapper = new LambdaQueryWrapper<>();
+ queryWrapper.eq(Orders::getDel_flag, 0);
+
+ // 添加查询条件
+ if (clientName != null && !clientName.trim().isEmpty()) {
+ queryWrapper.eq(Orders::getClient_name, clientName);
+ }
+ if (status != null) {
+ queryWrapper.eq(Orders::getStatus, status);
+ }
+ // 改造时间筛选逻辑
+ if (timeRange != null && !timeRange.trim().isEmpty()) {
+ LocalDateTime now = LocalDateTime.now();
+ LocalDateTime startTime = null;
+
+ switch (timeRange.trim()) {
+ case "week":
+ startTime = now.minusWeeks(1);
+ break;
+ case "month":
+ startTime = now.minusMonths(1);
+ break;
+ case "threeMonths":
+ startTime = now.minusMonths(3);
+ break;
+ case "year":
+ startTime = now.minusYears(1);
+ break;
+ default:
+ // 可添加日志记录无效参数
+ break;
+ }
+ if (startTime != null) {
+ queryWrapper.ge(Orders::getCreate_time, startTime);
+ }
+ }
+ // 排序
+ queryWrapper.orderByDesc(Orders::getCreate_time);
+ // 分页查询
+ if (pageNum != null && pageSize != null) {
+ Page<Orders> pageInfo = new Page<>(pageNum, pageSize);
+ Page<Orders> result = this.page(pageInfo, queryWrapper);
+ return ResponseResult.success(new CustomPage<>(result));
+ }
+
+ // 不分页查询：手动创建 CustomPage
+ List<Orders> list = this.list(queryWrapper);
+ CustomPage<Orders> page = new CustomPage<>(new Page<>());
+ page.setRecords(list);
+ page.setTotal(list.size());
+
+ return ResponseResult.success(page);
+ }
+
+ @Override
+
+ public ResponseResult<Orders> getOrdersResponseResult(OrderDto orderDto) {
+ // 将dto转entity
+ Orders order = new Orders();
+ BeanUtils.copyProperties(orderDto, order);
+
+ if (order.getClient_name() == null || order.getClient_name().trim().isEmpty()) {
+ return ResponseResult.error("客户名称不能为空");
+ }
+
+ // 生成订单ID：日期+当天的订单数量（如：202507060001）
+ SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMdd");
+ String dateStr = dateFormat.format(new Date());
+ // 1. 查询当天最大的订单号（包含已删除的，适应硬删除场景）
+ LambdaQueryWrapper<Orders> queryWrapper = new LambdaQueryWrapper<>();
+ queryWrapper.likeRight(Orders::getOrder_id, dateStr)
+ .select(Orders::getOrder_id)
+ .orderByDesc(Orders::getOrder_id)
+ .last("LIMIT 1"); // 只取最大的一条
+ Orders maxOrder = this.getOne(queryWrapper);
+ int sequence = 1; // 默认序号
+
+ if (maxOrder != null && maxOrder.getOrder_id() != null) {
+ // 2. 从最大订单号中提取序号（如"202507250005"提取"0005"）
+ String maxId = maxOrder.getOrder_id();
+ if (maxId.length() == dateStr.length() + 4) { // 校验格式
+ String seqStr = maxId.substring(dateStr.length());
+ sequence = Integer.parseInt(seqStr) + 1; // 序号+1
+ }
+ }
+
+ // 3. 生成新订单号（补全4位，如1→0001）
+ String orderId = String.format("%s%04d", dateStr, sequence);
+ order.setOrder_id(orderId);
+
+ // 设置初始状态
+ order.setStatus(1); // 待处理
+ order.setDel_flag(0); // 未删除
+ order.setCreate_time(LocalDateTime.now());
+ boolean save = this.save(order);
+ // 保存关键词
+ boolean saveOrderWithKeywords = this.saveOrderWithKeywords(orderDto, order.getOrder_id());
+ if (!saveOrderWithKeywords) {
+ return ResponseResult.error("添加关键词失败");
+ }
+ //更新关键词数量
+ LambdaQueryWrapper<Keyword> queryKeywordsQueryWrapper = new LambdaQueryWrapper<>();
+ queryKeywordsQueryWrapper.eq(Keyword::getOrder_id, order.getOrder_id());
+ int count1 = (int) keywordService.count(queryKeywordsQueryWrapper);
+ order.setKeyword_num(count1);
+ order.setUpdate_time(LocalDateTime.now());
+ this.updateById(order);
+
+ if (save) {
+ return ResponseResult.success(order);
+ }
+ return ResponseResult.error("添加订单失败");
+ }
+
+ @Override
+ public ResponseResult<Void> getVoidResponseResult(String orderId) {
+ Orders order = this.getById(orderId);
+ if (order == null) {
+ return ResponseResult.error("订单不存在");
+ }
+
+ order.setDel_flag(1);
+ order.setUpdate_time(LocalDateTime.now());
+ boolean success = this.updateById(order);
+
+ return success ? ResponseResult.success() : ResponseResult.error("删除订单失败");
+ }
+
+ @Override
+ public ResponseResult<Void> updateOrder(OrderDto orderDto) {
+ if (orderDto.getOrder_id() == null) {
+ return ResponseResult.error("订单ID不能为空");
+ }
+ if (orderDto.getClient_name() == null || orderDto.getClient_name().trim().isEmpty()) {
+ return ResponseResult.error("客户名称不能为空");
+ }
+
+ Orders existingOrder = this.getById(orderDto.getOrder_id());
+ if (existingOrder == null) {
+ return ResponseResult.error("订单不存在");
+ }
+
+ orderDto.setUpdate_time(LocalDateTime.now());
+ if (orderDto.getKeywords()!= null&& orderDto.getKeywords().trim().length() > 0){
+ // 保存关键词
+ boolean saveOrderWithKeywords = saveOrderWithKeywords(orderDto, orderDto.getOrder_id());
+ if (!saveOrderWithKeywords) {
+ return ResponseResult.error("添加关键词失败");
+ }
+ //更新订单状态，新增关键词
+ orderDto.setStatus(1);
+ }
+ //更新关键词数量
+ LambdaQueryWrapper<Keyword> queryKeywordsQueryWrapper = new LambdaQueryWrapper<>();
+ queryKeywordsQueryWrapper.eq(Keyword::getOrder_id, orderDto.getOrder_id());
+ int count1 = (int) keywordService.count(queryKeywordsQueryWrapper);
+ orderDto.setKeyword_num(count1);
+
+
+ if (this.updateById(orderDto)) {
+ return ResponseResult.success();
+ }
+ return ResponseResult.error("更新订单失败");
+ }
+
+ @Override
+ public ResponseResult<Orders> getOrderById(String orderId) {
+ Orders order = this.getById(orderId);
+ if (order == null || order.getDel_flag() == 1) {
+ return ResponseResult.error("订单不存在");
+ }
+ return ResponseResult.success(order);
+ }
+
+
}
--
Gitblit v1.7.1