From a7682a26a113a2974634b9ffa319414d26dffcef Mon Sep 17 00:00:00 2001 From: rentaiming <806181062@qq.com> Date: 星期四, 04 七月 2024 18:12:58 +0800 Subject: [PATCH] 修改bug --- ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml | 6 ++++++ 1 files changed, 6 insertions(+), 0 deletions(-) diff --git a/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml b/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml index 94364ab..b944656 100644 --- a/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml +++ b/ruoyi-modules/ruoyi-order/src/main/resources/mapper/order/OrderMapper.xml @@ -61,6 +61,9 @@ <if test="skuName != null and skuName != ''"> AND o.sku_name LIKE CONCAT('%',#{skuName},'%') </if> + <if test="goodsSkuId != null and goodsSkuId != ''"> + and o.goods_sku_id = #{goodsSkuId} + </if> AND o.order_from = 3 AND o.del_flag=0 AND o.member_id=#{memberId} @@ -78,6 +81,9 @@ <if test="skuName != null and skuName != ''"> AND o.sku_name LIKE CONCAT('%',#{skuName},'%') </if> + <if test="goodsSkuId != null and goodsSkuId != ''"> + and o.goods_sku_id = #{goodsSkuId} + </if> AND o.order_from = 3 AND o.del_flag=0 AND o.member_id=#{memberId} -- Gitblit v1.7.1