From 4f9d9f37898cb82ba300fa92c38744bf3f47ef36 Mon Sep 17 00:00:00 2001
From: 无关风月 <443237572@qq.com>
Date: 星期三, 10 七月 2024 20:03:59 +0800
Subject: [PATCH] 分表
---
ruoyi-api/ruoyi-api-goods/src/main/java/com/ruoyi/goods/api/model/TOrderVO.java | 2 +-
ruoyi-service/ruoyi-goods/src/main/resources/mapper/goods/TOrderMapper.xml | 14 +++++++-------
2 files changed, 8 insertions(+), 8 deletions(-)
diff --git a/ruoyi-api/ruoyi-api-goods/src/main/java/com/ruoyi/goods/api/model/TOrderVO.java b/ruoyi-api/ruoyi-api-goods/src/main/java/com/ruoyi/goods/api/model/TOrderVO.java
index 47c0a28..f1a678e 100644
--- a/ruoyi-api/ruoyi-api-goods/src/main/java/com/ruoyi/goods/api/model/TOrderVO.java
+++ b/ruoyi-api/ruoyi-api-goods/src/main/java/com/ruoyi/goods/api/model/TOrderVO.java
@@ -25,7 +25,7 @@
/**
* 主键id
*/
- @TableId(value = "id", type = IdType.AUTO)
+ @TableId(value = "id", type = IdType.NONE)
private Long id;
@ApiModelProperty(value = "用户id")
private Integer userId;
diff --git a/ruoyi-service/ruoyi-goods/src/main/resources/mapper/goods/TOrderMapper.xml b/ruoyi-service/ruoyi-goods/src/main/resources/mapper/goods/TOrderMapper.xml
index 4ad6fe2..05314a1 100644
--- a/ruoyi-service/ruoyi-goods/src/main/resources/mapper/goods/TOrderMapper.xml
+++ b/ruoyi-service/ruoyi-goods/src/main/resources/mapper/goods/TOrderMapper.xml
@@ -31,21 +31,21 @@
integral
</sql>
<select id="listAll" resultType="com.ruoyi.goods.vo.TOrderVO">
- select t1.*, t2.name as name
- from t_order t1
- left join t_goods t2 on t1.goodsId = t2.id
+ select t_order.*, t_goods.name as name
+ from t_order
+ left join t_goods on t_order.goodsId = t_goods.id
where 1 = 1
<if test="null != req.state">
- and t1.state = #{req.state}
+ and t_order.state = #{req.state}
</if>
<if test="null != req.orderNumber and '' != req.orderNumber">
- and t1.orderNumber like CONCAT('%', #{req.orderNumber}, '%')
+ and t_order.orderNumber like CONCAT('%', #{req.orderNumber}, '%')
</if>
<if test="null != req.startTime">
- and t1.insertTime between #{req.startTime1} and #{req.endTime1}
+ and t_order.insertTime between #{req.startTime1} and #{req.endTime1}
</if>
- order by t1.state asc, t1.insertTime desc
+ order by t_order.state asc, t_order.insertTime desc
</select>
<select id="getGoodBuyNumber" resultType="java.lang.Integer">
--
Gitblit v1.7.1