From 8e4eee5ad4d74e1a4e6ab4de3a9c28000700dce0 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期二, 03 十一月 2026 13:49:04 +0800
Subject: [PATCH] 修复采购退货页面 ERP 模块已禁用报错

---
 yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseInItemMapper.java |   56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 56 insertions(+), 0 deletions(-)

diff --git a/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseInItemMapper.java b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseInItemMapper.java
new file mode 100644
index 0000000..5a14317
--- /dev/null
+++ b/yudao-module-erp/src/main/java/cn/iocoder/yudao/module/erp/dal/mysql/purchase/ErpPurchaseInItemMapper.java
@@ -0,0 +1,56 @@
+package cn.iocoder.yudao.module.erp.dal.mysql.purchase;
+
+import cn.hutool.core.collection.CollUtil;
+import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX;
+import cn.iocoder.yudao.module.erp.dal.dataobject.purchase.ErpPurchaseInItemDO;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import org.apache.ibatis.annotations.Mapper;
+
+import java.math.BigDecimal;
+import java.util.Collection;
+import java.util.Collections;
+import java.util.List;
+import java.util.Map;
+
+import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertMap;
+
+/**
+ * ERP 閲囪喘鍏ュ簱椤� Mapper
+ *
+ * @author 鑺嬮亾婧愮爜
+ */
+@Mapper
+public interface ErpPurchaseInItemMapper extends BaseMapperX<ErpPurchaseInItemDO> {
+
+    default List<ErpPurchaseInItemDO> selectListByInId(Long inId) {
+        return selectList(ErpPurchaseInItemDO::getInId, inId);
+    }
+
+    default List<ErpPurchaseInItemDO> selectListByInIds(Collection<Long> inIds) {
+        return selectList(ErpPurchaseInItemDO::getInId, inIds);
+    }
+
+    default int deleteByInId(Long inId) {
+        return delete(ErpPurchaseInItemDO::getInId, inId);
+    }
+
+    /**
+     * 鍩轰簬閲囪喘璁㈠崟缂栧彿锛屾煡璇㈡瘡涓噰璐鍗曢」鐨勫叆搴撴暟閲忎箣鍜�
+     *
+     * @param inIds 鍏ュ簱璁㈠崟椤圭紪鍙锋暟缁�
+     * @return key锛氶噰璐鍗曢」缂栧彿锛泇alue锛氬叆搴撴暟閲忎箣鍜�
+     */
+    default Map<Long, BigDecimal> selectOrderItemCountSumMapByInIds(Collection<Long> inIds) {
+        if (CollUtil.isEmpty(inIds)) {
+            return Collections.emptyMap();
+        }
+        // SQL sum 鏌ヨ
+        List<Map<String, Object>> result = selectMaps(new QueryWrapper<ErpPurchaseInItemDO>()
+                .select("order_item_id, SUM(count) AS sum_count")
+                .groupBy("order_item_id")
+                .in("in_id", inIds));
+        // 鑾峰緱鏁伴噺
+        return convertMap(result, obj -> (Long) obj.get("order_item_id"), obj -> (BigDecimal) obj.get("sum_count"));
+    }
+
+}
\ No newline at end of file

--
Gitblit v1.9.3