提交【管理后台】订单管理相关接口

mitao

2024-06-13 682a7f41ec41c3865312dc68e849f93f5387e7fc

提交【管理后台】订单管理相关接口

 ruoyi-modules/ruoyi-auction/src/main/resources/mapper/auction/AuctionSalesroomGoodsMapper.xml

@@ -3,11 +3,17 @@
<mapper namespace="com.ruoyi.auction.mapper.AuctionSalesroomGoodsMapper">
  <update id="updateBatchById" parameterType="java.util.List">
    UPDATE t_auction_salesroom_goods
    SET status = CASE
    SET
    backup_status = CASE
    <foreach collection="param" item="item" index="index">
      WHEN id = #{item.id} THEN #{item.backupStatus}
    </foreach>
    ELSE status END,
    status = CASE
    <foreach collection="param" item="item" index="index">
      WHEN id = #{item.id} THEN #{item.status}
    </foreach>
    END
    ELSE status END
    WHERE id IN
    <foreach collection="param" index="index" item="item" open="(" separator="," close=")">
      #{item.id}