1

phpcjl

2024-12-17 712a745a481c5ecb642741b10e5fc44b779aebbf

1

 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>