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> 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 != ''">