From 712a745a481c5ecb642741b10e5fc44b779aebbf Mon Sep 17 00:00:00 2001
From: phpcjl <phpcjl@gmail.com>
Date: 星期二, 17 十二月 2024 10:08:56 +0800
Subject: [PATCH] 1
---
ruoyi-service/ruoyi-other/src/main/resources/mapper/other/GoodsMapper.xml | 28 +++++++++++++---------------
1 files changed, 13 insertions(+), 15 deletions(-)
diff --git a/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/GoodsMapper.xml b/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/GoodsMapper.xml
index 1887bca..7584154 100644
--- a/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/GoodsMapper.xml
+++ b/ruoyi-service/ruoyi-other/src/main/resources/mapper/other/GoodsMapper.xml
@@ -40,21 +40,19 @@
<where>
tg.del_flag = 0
<if test="goods.id != null">
- <if test="goods.id != null">
- and tg.id = #{goods.id}
- </if>
- <if test="goods.name != null and goods.name != ''">
- and tg.`name` like concat('%',#{goods.name},'%')
- </if>
- <if test="goods.type != null">
- and tg.type = #{goods.type}
- </if>
- <if test="goods.goodsCategoryId != null">
- and tg.goodsCategoryId = #{goods.goodsCategoryId}
- </if>
- <if test="goods.status != null">
- and tg.`status` = #{goods.status}
- </if>
+ and tg.id = #{goods.id}
+ </if>
+ <if test="goods.name != null and goods.name != ''">
+ and tg.`name` like concat('%',#{goods.name},'%')
+ </if>
+ <if test="goods.type != null">
+ and tg.type = #{goods.type}
+ </if>
+ <if test="goods.goodsCategoryId != null">
+ and tg.goodsCategoryId = #{goods.goodsCategoryId}
+ </if>
+ <if test="goods.status != null">
+ and tg.`status` = #{goods.status}
</if>
</where>
</select>
--
Gitblit v1.7.1