From 401bdd0cfb4d7ce7344e34b3897ff14e303188fb Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期四, 15 十月 2026 14:02:52 +0800
Subject: [PATCH] feat(crm): 新增合同Word文档下载功能

---
 yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/receivable/CrmReceivableMapper.java |   61 +++++++++++++++++++++++++++++-
 1 files changed, 59 insertions(+), 2 deletions(-)

diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/receivable/CrmReceivableMapper.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/receivable/CrmReceivableMapper.java
index 904357e..7739e71 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/receivable/CrmReceivableMapper.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/receivable/CrmReceivableMapper.java
@@ -6,13 +6,13 @@
 import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
 import cn.iocoder.yudao.framework.mybatis.core.query.MPJLambdaWrapperX;
 import cn.iocoder.yudao.module.crm.controller.admin.receivable.vo.receivable.CrmReceivablePageReqVO;
-import cn.iocoder.yudao.module.crm.dal.dataobject.contract.CrmContractDO;
 import cn.iocoder.yudao.module.crm.dal.dataobject.receivable.CrmReceivableDO;
 import cn.iocoder.yudao.module.crm.enums.common.CrmAuditStatusEnum;
 import cn.iocoder.yudao.module.crm.enums.common.CrmBizTypeEnum;
 import cn.iocoder.yudao.module.crm.enums.common.CrmSceneTypeEnum;
 import cn.iocoder.yudao.module.crm.util.CrmPermissionUtils;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
 import org.apache.ibatis.annotations.Mapper;
 
 import java.math.BigDecimal;
@@ -33,6 +33,11 @@
 
     default CrmReceivableDO selectByNo(String no) {
         return selectOne(CrmReceivableDO::getNo, no);
+    }
+
+    default int updateByIdAndStatus(Long id, Integer status, CrmReceivableDO updateObj) {
+        return update(updateObj, new LambdaUpdateWrapper<CrmReceivableDO>()
+                .eq(CrmReceivableDO::getId, id).eq(CrmReceivableDO::getAuditStatus, status));
     }
 
     default PageResult<CrmReceivableDO> selectPageByCustomerId(CrmReceivablePageReqVO reqVO) {
@@ -65,7 +70,7 @@
         CrmPermissionUtils.appendPermissionCondition(query, CrmBizTypeEnum.CRM_RECEIVABLE.getType(),
                 CrmReceivableDO::getId, userId, CrmSceneTypeEnum.OWNER.getType());
         // 鏈鏍�
-        query.eq(CrmContractDO::getAuditStatus, CrmAuditStatusEnum.PROCESS.getStatus());
+        query.eq(CrmReceivableDO::getAuditStatus, CrmAuditStatusEnum.PROCESS.getStatus());
         return selectCount(query);
     }
 
@@ -73,6 +78,27 @@
         return selectList(new LambdaQueryWrapperX<CrmReceivableDO>()
                 .eq(CrmReceivableDO::getContractId, contractId)
                 .in(CrmReceivableDO::getAuditStatus, auditStatuses));
+    }
+
+    default List<CrmReceivableDO> selectListByInvoiceIdAndStatus(Long invoiceId, Collection<Integer> auditStatuses) {
+        return selectList(new LambdaQueryWrapperX<CrmReceivableDO>()
+                .eq(CrmReceivableDO::getInvoiceId, invoiceId)
+                .in(CrmReceivableDO::getAuditStatus, auditStatuses));
+    }
+
+    default Map<Long, BigDecimal> selectReceivablePriceMapByInvoiceId(Collection<Long> invoiceIds) {
+        if (CollUtil.isEmpty(invoiceIds)) {
+            return Collections.emptyMap();
+        }
+        // SQL sum 鏌ヨ
+        List<Map<String, Object>> result = selectMaps(new QueryWrapper<CrmReceivableDO>()
+                .select("invoice_id, SUM(price) AS total_price")
+                .in("audit_status", CrmAuditStatusEnum.DRAFT.getStatus(), // 鑽夌 + 瀹℃壒涓� + 瀹℃壒閫氳繃
+                        CrmAuditStatusEnum.PROCESS.getStatus(), CrmAuditStatusEnum.APPROVE.getStatus())
+                .groupBy("invoice_id")
+                .in("invoice_id", invoiceIds));
+        // 鑾峰緱閲戦
+        return convertMap(result, obj -> (Long) obj.get("invoice_id"), obj -> (BigDecimal) obj.get("total_price"));
     }
 
     default Map<Long, BigDecimal> selectReceivablePriceMapByContractId(Collection<Long> contractIds) {
@@ -94,4 +120,35 @@
         return selectCount(CrmReceivableDO::getContractId, contractId);
     }
 
+    // ========== 缁熻鏂规硶 ==========
+
+    default BigDecimal selectReceivablePriceSum() {
+        LambdaQueryWrapperX<CrmReceivableDO> query = new LambdaQueryWrapperX<>();
+        query.in(CrmReceivableDO::getAuditStatus,
+                CrmAuditStatusEnum.DRAFT.getStatus(),
+                CrmAuditStatusEnum.PROCESS.getStatus(),
+                CrmAuditStatusEnum.APPROVE.getStatus())
+                .select(CrmReceivableDO::getPrice);
+        List<CrmReceivableDO> list = selectList(query);
+        return list.stream()
+                .map(CrmReceivableDO::getPrice)
+                .filter(p -> p != null)
+                .reduce(BigDecimal.ZERO, BigDecimal::add);
+    }
+
+    default BigDecimal selectReceivablePriceSumByOwnerUserId(Long ownerUserId) {
+        LambdaQueryWrapperX<CrmReceivableDO> query = new LambdaQueryWrapperX<>();
+        query.eq(CrmReceivableDO::getOwnerUserId, ownerUserId)
+                .in(CrmReceivableDO::getAuditStatus,
+                        CrmAuditStatusEnum.DRAFT.getStatus(),
+                        CrmAuditStatusEnum.PROCESS.getStatus(),
+                        CrmAuditStatusEnum.APPROVE.getStatus())
+                .select(CrmReceivableDO::getPrice);
+        List<CrmReceivableDO> list = selectList(query);
+        return list.stream()
+                .map(CrmReceivableDO::getPrice)
+                .filter(p -> p != null)
+                .reduce(BigDecimal.ZERO, BigDecimal::add);
+    }
+
 }

--
Gitblit v1.9.3