From 135e1a36d71ff23a6a4832da6e28e33ce115943c Mon Sep 17 00:00:00 2001
From: Helius <wangdoubleone@gmail.com>
Date: Mon, 28 Jun 2021 10:36:32 +0800
Subject: [PATCH] fix viewJhyOrder.json
---
gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml | 20 +-------------------
gc-shop/src/main/java/com/xzx/gc/shop/mapper/JhyOrderMapper.java | 2 +-
2 files changed, 2 insertions(+), 20 deletions(-)
diff --git a/gc-shop/src/main/java/com/xzx/gc/shop/mapper/JhyOrderMapper.java b/gc-shop/src/main/java/com/xzx/gc/shop/mapper/JhyOrderMapper.java
index 7140ea6..da45c45 100644
--- a/gc-shop/src/main/java/com/xzx/gc/shop/mapper/JhyOrderMapper.java
+++ b/gc-shop/src/main/java/com/xzx/gc/shop/mapper/JhyOrderMapper.java
@@ -13,5 +13,5 @@
List<QueryJhyOrderListVo> queryOrderList(@Param("record") QueryJhyOrderListDto model);
- ViewJhyOrderVo viewJhyOrder(@Param("id")Long id);
+ ViewJhyOrderVo viewJhyOrder(@Param("id") Long id);
}
diff --git a/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml b/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml
index dc41949..f073cf6 100644
--- a/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml
+++ b/gc-shop/src/main/resources/mapper/shop/JhyOrderMapper.xml
@@ -65,25 +65,7 @@
xzx_jhy_order a
left join xzx_user_info b on b.user_id = a.user_id
left join xzx_jhy_info d on d.id = a.jhy_id
- WHERE 1 = 1
- <if test="record.orderNo != null and record.orderNo != ''">
- and a.order_no like concat('%',#{record.orderNo},'%')
- </if>
- <if test="record.status != null and record.status != ''">
- and a.status = #{record.status}
- </if>
- <if test="record.account != null and record.account != ''">
- and ( b.nick_name like concat('%',#{record.account},'%')
- or b.mobile_phone like concat('%',#{record.account},'%') )
- </if>
- <if test="record.reserveTimeStart != null">
- and a.reserve_time >= #{record.reserveTimeStart}
- </if>
-
- <if test="record.reserveTimeEnd != null">
- and a.reserve_time <= #{record.reserveTimeEnd}
- </if>
- order by a.CREATED_TIME desc
+ WHERE a.id=#{id}
</select>
--
Gitblit v1.9.1