修改bug

mitao

2024-07-19 ffbc5d462791b3ec92e465d2158a351913284446

修改bug

 ruoyi-modules/ruoyi-goods/src/main/resources/mapper/goods/GoodsGroupPurchaseMapper.xml

@@ -15,5 +15,6 @@
        AND tgs.sku_name LIKE CONCAT('%',#{goodsSkuName},'%')
      </if>
    </where>
    ORDER BY tgp.create_time DESC
  </select>
</mapper>

 ruoyi-modules/ruoyi-goods/src/main/resources/mapper/goods/GoodsSkuMapper.xml

@@ -2,4 +2,15 @@
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.ruoyi.goods.mapper.GoodsSkuMapper">

  <update id="addGoodsStock">
    UPDATE t_goods_sku
    SET stock = stock + #{auctionStock}
    WHERE id = #{id}
  </update>
  <update id="subGoodsStock">
    UPDATE t_goods_sku
    SET stock = stock - #{auctionStock}
    WHERE id = #{id}
      AND stock >= #{auctionStock}
  </update>
</mapper>