| | |
| | | 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; |
| | |
| | | private KeywordService keywordService; |
| | | @Autowired |
| | | private QuestionService questionService; |
| | | @Autowired |
| | | private OrderMapper orderMapper; |
| | | @Autowired |
| | | private KeywordTaskService keywordTaskService; |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | |
| | | 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; |
| | |
| | | return false; |
| | | } |
| | | |
| | | // 删除旧关键词(当状态为1时允许修改关键词) |
| | | // 删除旧关键词(当状态为未提交时允许修改关键词) |
| | | keywordService.lambdaUpdate() |
| | | .eq(Keyword::getOrder_id, orderDto.getOrder_id()) |
| | | .eq(Keyword::getStatus, "notSubmitted") |
| | | .eq(Keyword::getStatus, FinalStatus.NOTSUBMITTED.getValue()) |
| | | .remove(); |
| | | |
| | | // 保存新关键词 |
| | |
| | | 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); |
| | | } |
| | | } |
| | |
| | | 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()) |
| | |
| | | } |
| | | 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); |
| | | } |
| | | |
| | | |
| | | } |