From 9daf1936174685bad526ed41a026d2f2c421f6b0 Mon Sep 17 00:00:00 2001
From: guyue <1721849008@qq.com>
Date: 星期六, 26 七月 2025 23:32:04 +0800
Subject: [PATCH] 修改获取结果方法，重复次数计算
---
src/main/java/com/linghu/controller/OrderController.java | 38 ++++++++++++++++++++++++++++----------
1 files changed, 28 insertions(+), 10 deletions(-)
diff --git a/src/main/java/com/linghu/controller/OrderController.java b/src/main/java/com/linghu/controller/OrderController.java
index a26b7d2..544bf2f 100644
--- a/src/main/java/com/linghu/controller/OrderController.java
+++ b/src/main/java/com/linghu/controller/OrderController.java
@@ -16,6 +16,7 @@
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.*;
import javax.servlet.http.HttpServletRequest;
@@ -42,6 +43,7 @@
* 新增订单
*/
@PostMapping
+ @Transactional // 开启事务
@ApiOperation(value = "新增订单")
public ResponseResult<Orders> add(@RequestBody OrderDto orderDto) {
// 将dto转entity
@@ -55,14 +57,26 @@
// 生成订单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);
- long count = orderService.count(queryWrapper);
+ queryWrapper.likeRight(Orders::getOrder_id, dateStr)
+ .select(Orders::getOrder_id)
+ .orderByDesc(Orders::getOrder_id)
+ .last("LIMIT 1"); // 只取最大的一条
+ Orders maxOrder = orderService.getOne(queryWrapper);
+ int sequence = 1; // 默认序号
- // 生成订单ID
- String orderId = String.format("%s%04d", dateStr, count + 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);
// 设置初始状态
@@ -78,7 +92,7 @@
//更新关键词数量
LambdaQueryWrapper<Keyword> queryKeywordsQueryWrapper = new LambdaQueryWrapper<>();
queryKeywordsQueryWrapper.eq(Keyword::getOrder_id, order.getOrder_id());
- int count1 = keywordService.count(queryKeywordsQueryWrapper);
+ int count1 = (int) keywordService.count(queryKeywordsQueryWrapper);
order.setKeyword_num(count1);
order.setUpdate_time(LocalDateTime.now());
orderService.updateById(order);
@@ -132,11 +146,13 @@
if (!saveOrderWithKeywords) {
return ResponseResult.error("添加关键词失败");
}
+ //更新订单状态，新增关键词
+ orderDto.setStatus(1);
}
//更新关键词数量
LambdaQueryWrapper<Keyword> queryKeywordsQueryWrapper = new LambdaQueryWrapper<>();
queryKeywordsQueryWrapper.eq(Keyword::getOrder_id, orderDto.getOrder_id());
- int count1 = keywordService.count(queryKeywordsQueryWrapper);
+ int count1 = (int) keywordService.count(queryKeywordsQueryWrapper);
orderDto.setKeyword_num(count1);
@@ -177,7 +193,7 @@
// 添加查询条件
if (clientName != null && !clientName.trim().isEmpty()) {
- queryWrapper.like(Orders::getClient_name, clientName);
+ queryWrapper.eq(Orders::getClient_name, clientName);
}
if (status != null) {
queryWrapper.eq(Orders::getStatus, status);
@@ -208,6 +224,8 @@
queryWrapper.ge(Orders::getCreate_time, startTime);
}
}
+ // 排序
+ queryWrapper.orderByDesc(Orders::getCreate_time);
// 分页查询
if (pageNum != null && pageSize != null) {
Page<Orders> pageInfo = new Page<>(pageNum, pageSize);
@@ -233,7 +251,7 @@
@ApiOperation("获取客户列表")
public ResponseResult<CustomPage<String>> getClientList(@RequestParam(required = false) String clientName,
@RequestParam(required = false,defaultValue = "1") Integer pageNum,
- @RequestParam(required = false, defaultValue = "10") Integer pageSize) {
+ @RequestParam(required = false, defaultValue = "100") Integer pageSize) {
Page<String> result = orderService.getClientList(clientName,pageNum, pageSize);
--
Gitblit v1.7.1