From fecd439687dd9d0bd37a1788412ecd1f0b661417 Mon Sep 17 00:00:00 2001 From: rentaiming <806181062@qq.com> Date: 星期四, 04 七月 2024 18:13:45 +0800 Subject: [PATCH] 修改bug --- ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionSalesroomMapper.xml | 4 ++-- ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionGoodsMapper.xml | 9 ++++++--- 2 files changed, 8 insertions(+), 5 deletions(-) diff --git a/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionGoodsMapper.xml b/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionGoodsMapper.xml index 4a811f0..a80bcb1 100644 --- a/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionGoodsMapper.xml +++ b/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionGoodsMapper.xml @@ -4,11 +4,14 @@ <select id="getAuctionGoodsPgeList" resultType="com.ruoyi.system.api.domain.AuctionGoods"> SELECT * FROM t_auction_goods ta WHERE del_flag = 0 and listing_status=0 - <if test="param.startStatus!=null and param.startStatus != ''"> - AND start_status=#{param.startStatus} + <if test="param.startStatus!=null and param.startStatus!= 5"> + AND ta.start_status=#{param.startStatus} + </if> + <if test="param.startStatus == 5"> + AND ta.start_status=0 </if> <if test="param.goodsSkuIdList != null and param.goodsSkuIdList.size()>0"> - AND goods_sku_id IN + AND id IN <foreach collection="param.goodsSkuIdList" item="item" open="(" separator="," close=")"> #{item} </foreach> diff --git a/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionSalesroomMapper.xml b/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionSalesroomMapper.xml index 37d0b2c..0ad1e7a 100644 --- a/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionSalesroomMapper.xml +++ b/ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionSalesroomMapper.xml @@ -20,10 +20,10 @@ <select id="pageMemberAuctionSalesroomWdList" resultType="com.ruoyi.system.api.domain.AuctionSalesroom"> SELECT * FROM t_auction_salesroom ta WHERE ta.del_flag = 0 - <if test="param.status!=null and param.salesroomName != 5"> + <if test="param.status!=null and param.status!= 5"> AND ta.status=#{param.status} </if> - <if test="param.salesroomName == 5"> + <if test="param.status == 5"> AND ta.status=0 </if> <if test="param.salesroomName!=null and param.salesroomName != ''"> -- Gitblit v1.7.1