From f894e386d81e43831ea5fda78e30a029eca6fda5 Mon Sep 17 00:00:00 2001
From: “mitao” <“2763622819@qq.com”>
Date: 星期二, 16 十二月 2025 18:37:33 +0800
Subject: [PATCH] 大礼包、实物商品下单、回调
---
ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBigGiftPackageMapper.java | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 deletions(-)
diff --git a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBigGiftPackageMapper.java b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBigGiftPackageMapper.java
index c2b16b2..0ff7398 100644
--- a/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBigGiftPackageMapper.java
+++ b/ruoyi-system/src/main/java/com/ruoyi/system/mapper/TBigGiftPackageMapper.java
@@ -1,7 +1,9 @@
package com.ruoyi.system.mapper;
-import com.ruoyi.system.model.TBigGiftPackage;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ruoyi.system.model.TBigGiftPackage;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Update;
/**
* <p>
@@ -13,4 +15,14 @@
*/
public interface TBigGiftPackageMapper extends BaseMapper<TBigGiftPackage> {
+ /**
+ * 使用乐观锁扣减库存
+ *
+ * @param id 商品ID
+ * @param quantity 扣减数量
+ * @return 更新行数（0表示库存不足或并发冲突）
+ */
+ @Update("UPDATE t_big_gift_package SET inventory = inventory - #{quantity} WHERE id = #{id} AND inventory >= #{quantity} AND status = 1")
+ int deductInventory(@Param("id") Integer id, @Param("quantity") Integer quantity);
+
}
--
Gitblit v1.7.1