From ccff3913e0e6854a3811788d5d41614463110095 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期三, 04 十一月 2026 16:44:53 +0800
Subject: [PATCH] feat(crm): 开票管理支持关联销售订单,开票金额按订单未开票金额校验

---
 yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/dataobject/invoice/CrmInvoiceDO.java                     |   10 ++
 yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoiceRespVO.java    |    6 +
 yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/invoice/CrmInvoiceMapper.java                      |    7 +
 docs/crm_invoice_sale_order_integration.md                                                                              |   68 +++++++++++++
 yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/service/invoice/CrmInvoiceService.java                       |    8 +
 yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/service/invoice/CrmInvoiceServiceImpl.java                   |  106 ++++++++++++++++++--
 yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/enums/ErrorCodeConstants.java                                |    2 
 yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoicePageReqVO.java |    3 
 yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoiceSaveReqVO.java |    3 
 docs/sql/crm_invoice_sale_order_20261104.sql                                                                            |   42 ++++++++
 yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/CrmInvoiceController.java           |    8 +
 11 files changed, 250 insertions(+), 13 deletions(-)

diff --git a/docs/crm_invoice_sale_order_integration.md b/docs/crm_invoice_sale_order_integration.md
new file mode 100644
index 0000000..dafd07c
--- /dev/null
+++ b/docs/crm_invoice_sale_order_integration.md
@@ -0,0 +1,68 @@
+# 寮�绁ㄧ鐞嗗叧鑱旈攢鍞鍗� - 鍓嶇鑱旇皟鏂规
+
+## 鑳屾櫙
+
+瀹佸涓囬�氶渶姹傦細寮�绁ㄧ鐞嗕腑鐨勩�屽紑绁ㄩ噾棰濄�嶆敼涓烘寜閿�鍞鍗曢噾棰濊蛋銆�
+寮�绁ㄥ崟鏂板銆岄攢鍞鍗曘�嶉�夋嫨椤癸細閫夊畾閿�鍞鍗曞悗锛屽鎴枫�佸悎鍚屻�佸彂绁ㄦ姮澶磋嚜鍔ㄥ甫鍑猴紝寮�绁ㄩ噾棰濋粯璁ゅ甫鍑鸿璁㈠崟鐨勬湭寮�绁ㄩ噾棰濓紝淇濆瓨鏃舵寜璇ヨ鍗曢噾棰濇牎楠屼笂闄愶紱鍚堝悓浠嶅彲绌恒��
+
+## 娑夊強椤甸潰
+
+- 钀ラ攢绠$悊 - 寮�绁ㄧ鐞嗭紙鏂板 / 缂栬緫寮圭獥銆佸垪琛級
+
+## 涓氬姟娴佺▼涓庢暟鎹甫鍏�
+
+1. 閿�鍞鍗曪紙宸插鏍革紝status=20锛� -> 寮�绁ㄥ崟锛氬鎴枫�佸悎鍚岋紙璁㈠崟宸插叧鑱斾笖鍚堝悓宸插鏍搁�氳繃鏃讹級銆佸彂绁ㄦ姮澶淬�佸紑绁ㄩ噾棰濓紙璇ヨ鍗曞墿浣欏彲寮�绁ㄩ噾棰濓級鑷姩甯﹀叆锛屼笖瀹㈡埛/鍚堝悓鍦ㄩ�夊畾璁㈠崟鍚庣疆鐏颁笉鍙敼銆�
+2. 鏈�夋嫨閿�鍞鍗曟椂锛岃涓轰笌鏀归�犲墠瀹屽叏涓�鑷达紙鎸夊悎鍚岄噾棰濇牎楠岋紝鍚堝悓鍙┖锛夈��
+
+## API
+
+| 鏂规硶 | 璺緞 | 璇存槑 |
+|------|------|------|
+| GET | /crm/invoice/sale-order-remain-price | 鏌ヨ閿�鍞鍗曞墿浣欏彲寮�绁ㄩ噾棰濓紙瀹℃壒閫氳繃 + 瀹℃壒涓凡鍗犵敤棰濆害锛� |
+| POST | /crm/invoice/create | 鏂板寮�绁紝鏂板 saleOrderId 鍙傛暟 |
+| PUT | /crm/invoice/update | 淇敼寮�绁紝saleOrderId 涓嶆敮鎸佷慨鏀癸紙鍚庣娌跨敤鍘熷�硷級 |
+| GET | /crm/invoice/page | 鍒楄〃锛岃繑鍥� saleOrderNo |
+
+**璇锋眰鍙傛暟锛坰ale-order-remain-price锛夛細**
+
+| 鍙傛暟 | 绫诲瀷 | 蹇呭~ | 璇存槑 |
+|------|------|------|------|
+| saleOrderId | Long | 鏄� | 閿�鍞鍗曠紪鍙� |
+
+**鍝嶅簲锛�** `{ "code": 0, "data": 10860.00 }`锛圔igDecimal锛屽墿浣欏彲寮�绁ㄩ噾棰濓級
+
+**create / update 鏂板瀛楁锛�**
+
+| 瀛楁 | 绫诲瀷 | 蹇呭~ | 璇存槑 |
+|------|------|------|------|
+| saleOrderId | Long | 鍚� | 閿�鍞鍗曠紪鍙凤紱浼犱簡鍒欐寜璁㈠崟鏍¢獙寮�绁ㄩ噾棰濓紝瀹㈡埛/鍚堝悓浠ヨ鍗曚负鍑� |
+
+**page / get 鍝嶅簲鏂板瀛楁锛�**
+
+| 瀛楁 | 绫诲瀷 | 璇存槑 |
+|------|------|------|
+| saleOrderId | Long | 閿�鍞鍗曠紪鍙� |
+| saleOrderNo | String | 閿�鍞鍗曞彿锛堝垪琛ㄥ睍绀猴級 |
+
+## 瀛楁灞曠ず瑙勫垯
+
+| 瀛楁 | 灞曠ず浣嶇疆 | 璇存槑 |
+|------|----------|------|
+| 閿�鍞鍗� | 鏂板/缂栬緫寮圭獥锛堝鎴蜂笂鏂癸級 | 寮圭獥閫夋嫨锛屽彧鍒楀凡瀹℃牳锛坰tatus=20锛夎鍗曪紱缂栬緫鎬佷笉鍙敼 |
+| 閿�鍞鍗曞彿 | 鍒楄〃锛堝悎鍚岀紪鍙峰彸渚э級 | 鐩存帴灞曠ず saleOrderNo锛屾湭鍏宠仈鏃朵负绌� |
+
+## 涓氬姟瑙勫垯璇存槑
+
+| 鍦烘櫙 | 瑙勫垯 |
+|------|------|
+| 鏈�夐攢鍞鍗� | 鎸夊師閫昏緫锛氶�変簡鍚堝悓鎸夊悎鍚屽墿浣欏彲寮�绁ㄩ噾棰濇牎楠岋紝鍚堝悓涓虹┖涓嶆牎楠� |
+| 閫変簡閿�鍞鍗� | 鎸夈�岃鍗曢噾棰� 鈭� 宸插紑绁紙瀹℃壒閫氳繃 + 瀹℃壒涓級銆嶆牎楠岋紱鑽夌涓嶅崰鐢ㄩ搴� |
+| 璁㈠崟鐘舵�� | 鍙湁瀹℃牳閫氳繃锛坰tatus=20锛夌殑璁㈠崟鍙紑绁紝鍚﹀垯鎶ャ�屾墍閫夐攢鍞鍗曗�︿笉鏄凡瀹℃牳鐘舵�併�� |
+| 鎻愪氦瀹℃壒 | 鎻愪氦鏃舵寜鍚屼竴鍙e緞閲嶆柊鏍¢獙涓�娆★紝闃叉澶氭鑽夌绱瓒呭紑 |
+| 缂栬緫 | 閿�鍞鍗曚笉鍙慨鏀癸紱淇敼閲戦鏃舵寜鍘熻鍗曟牎楠� |
+
+## 娉ㄦ剰浜嬮」
+
+- `sale-order-remain-price` 鍙粺璁″鎵归�氳繃銆佸鎵逛腑鐨勫紑绁紝涓庡垱寤�/鎻愪氦鏍¢獙鍙e緞涓�鑷淬��
+- 璁㈠崟鍏宠仈鐨勫悎鍚岃嫢鏈鏍搁�氳繃锛屽悗绔笉浼氬洖濉悎鍚岋紙閬垮厤鎸′綇鎸夎鍗曞紑绁級锛屾鏃跺悎鍚屼繚鎸佷负绌恒��
+- 鏁版嵁搴撻渶鍏堟墽琛� `docs/sql/crm_invoice_sale_order_20261104.sql`锛坈rm_invoice 澧炲姞 sale_order_id銆乻ale_order_no 鍙婄储寮曪級銆�
diff --git a/docs/sql/crm_invoice_sale_order_20261104.sql b/docs/sql/crm_invoice_sale_order_20261104.sql
new file mode 100644
index 0000000..a8c317d
--- /dev/null
+++ b/docs/sql/crm_invoice_sale_order_20261104.sql
@@ -0,0 +1,42 @@
+-- =====================================================================
+-- 瀹佸涓囬�氶渶姹傦細寮�绁ㄧ鐞嗘敮鎸佸叧鑱旈攢鍞鍗曪紝寮�绁ㄩ噾棰濇寜閿�鍞鍗曢噾棰濇牎楠�
+-- 2026-11-04
+-- 璇存槑锛歝rm_invoice 鏂板 sale_order_id锛堥攢鍞鍗曠紪鍙凤級銆乻ale_order_no锛堥攢鍞鍗曞彿锛屽啑浣欏睍绀猴級
+--       杩欎袱涓瓧娈甸兘鍙负绌猴細涓嶅叧鑱旈攢鍞鍗曟椂锛岃涓轰笌鏀归�犲墠瀹屽叏涓�鑷达紙鎸夊悎鍚岄噾棰濇牎楠岋級
+-- =====================================================================
+
+-- 1. sale_order_id
+SET @exists_sale_order_id = (
+    SELECT COUNT(*) FROM information_schema.columns
+    WHERE table_schema = DATABASE() AND table_name = 'crm_invoice' AND column_name = 'sale_order_id'
+);
+SET @ddl = IF(@exists_sale_order_id = 0,
+    'ALTER TABLE crm_invoice ADD COLUMN sale_order_id BIGINT NULL COMMENT ''閿�鍞鍗曠紪鍙凤紝鍏宠仈 erp_sale_order.id'' AFTER contract_id',
+    'SELECT 1');
+PREPARE stmt FROM @ddl;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- 2. sale_order_no
+SET @exists_sale_order_no = (
+    SELECT COUNT(*) FROM information_schema.columns
+    WHERE table_schema = DATABASE() AND table_name = 'crm_invoice' AND column_name = 'sale_order_no'
+);
+SET @ddl = IF(@exists_sale_order_no = 0,
+    'ALTER TABLE crm_invoice ADD COLUMN sale_order_no VARCHAR(64) NULL COMMENT ''閿�鍞鍗曞彿锛屽啑浣欎究浜庡睍绀�'' AFTER sale_order_id',
+    'SELECT 1');
+PREPARE stmt FROM @ddl;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
+
+-- 3. 绱㈠紩锛堟寜璁㈠崟鏌ヨ宸插紑绁ㄩ噾棰濓級
+SET @exists_idx = (
+    SELECT COUNT(*) FROM information_schema.statistics
+    WHERE table_schema = DATABASE() AND table_name = 'crm_invoice' AND index_name = 'idx_crm_invoice_sale_order_id'
+);
+SET @ddl = IF(@exists_idx = 0,
+    'ALTER TABLE crm_invoice ADD INDEX idx_crm_invoice_sale_order_id (sale_order_id)',
+    'SELECT 1');
+PREPARE stmt FROM @ddl;
+EXECUTE stmt;
+DEALLOCATE PREPARE stmt;
diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/CrmInvoiceController.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/CrmInvoiceController.java
index 3ef2373..20e8c2f 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/CrmInvoiceController.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/CrmInvoiceController.java
@@ -218,6 +218,14 @@
         return success(true);
     }
 
+    @GetMapping("/sale-order-remain-price")
+    @Operation(summary = "鑾峰緱閿�鍞鍗曞墿浣欏彲寮�绁ㄩ噾棰�")
+    @Parameter(name = "saleOrderId", description = "閿�鍞鍗曠紪鍙�", required = true, example = "2048")
+    @PreAuthorize("@ss.hasPermission('crm:invoice:query')")
+    public CommonResult<BigDecimal> getSaleOrderRemainInvoicePrice(@RequestParam("saleOrderId") Long saleOrderId) {
+        return success(invoiceService.getSaleOrderRemainInvoicePrice(saleOrderId));
+    }
+
     @GetMapping("/audit-count")
     @Operation(summary = "鑾峰緱寰呭鏍稿紑绁ㄦ暟閲�")
     @PreAuthorize("@ss.hasPermission('crm:invoice:query')")
diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoicePageReqVO.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoicePageReqVO.java
index 994a1bb..a3fe678 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoicePageReqVO.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoicePageReqVO.java
@@ -24,6 +24,9 @@
     @Schema(description = "鍚堝悓缂栧彿", example = "4963")
     private Long contractId;
 
+    @Schema(description = "閿�鍞鍗曠紪鍙�", example = "2048")
+    private Long saleOrderId;
+
     @Schema(description = "鍦烘櫙绫诲瀷", example = "1")
     @InEnum(CrmSceneTypeEnum.class)
     private Integer sceneType; // 鍦烘櫙绫诲瀷锛屼负 null 鏃跺垯琛ㄧず鍏ㄩ儴
diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoiceRespVO.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoiceRespVO.java
index 57f86c5..8cec10e 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoiceRespVO.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoiceRespVO.java
@@ -60,6 +60,12 @@
     @Schema(description = "鍚堝悓淇℃伅")
     private CrmContractRespVO contract;
 
+    @Schema(description = "閿�鍞鍗曠紪鍙�", example = "2048")
+    private Long saleOrderId;
+    @Schema(description = "閿�鍞鍗曞彿", example = "XSDD2026010113")
+    @ExcelProperty("閿�鍞鍗曞彿")
+    private String saleOrderNo;
+
     @Schema(description = "璐熻矗浜虹殑鐢ㄦ埛缂栧彿", example = "25682")
     private Long ownerUserId;
     @Schema(description = "璐熻矗浜哄悕瀛�", example = "25682")
diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoiceSaveReqVO.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoiceSaveReqVO.java
index 682279c..53d10ec 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoiceSaveReqVO.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/vo/invoice/CrmInvoiceSaveReqVO.java
@@ -24,6 +24,9 @@
     @Schema(description = "鍚堝悓缂栧彿", example = "1024")
     private Long contractId; // 闈炲繀濉細鍏佽涓嶅叧鑱斿悎鍚屽紑绁�
 
+    @Schema(description = "閿�鍞鍗曠紪鍙�", example = "2048")
+    private Long saleOrderId; // 闈炲繀濉細閫夋嫨鍚庡紑绁ㄩ噾棰濇寜閿�鍞鍗曢噾棰濇牎楠岋紙瀹㈡埛銆佸悎鍚岀敱璁㈠崟甯﹀嚭锛�
+
     @Schema(description = "璐熻矗浜虹紪鍙�", example = "25682")
     private Long ownerUserId;
 
diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/dataobject/invoice/CrmInvoiceDO.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/dataobject/invoice/CrmInvoiceDO.java
index 664300d..ce4ee21 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/dataobject/invoice/CrmInvoiceDO.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/dataobject/invoice/CrmInvoiceDO.java
@@ -50,6 +50,16 @@
      */
     private Long contractId;
     /**
+     * 閿�鍞鍗曠紪鍙�
+     *
+     * 鍏宠仈 {@link cn.iocoder.yudao.module.erp.dal.dataobject.sale.ErpSaleOrderDO#getId()}锛涘紑绁ㄩ噾棰濇寜璇ヨ鍗曢噾棰濇牎楠�
+     */
+    private Long saleOrderId;
+    /**
+     * 閿�鍞鍗曞彿锛堝啑浣欙紝渚夸簬鍒楄〃灞曠ず锛�
+     */
+    private String saleOrderNo;
+    /**
      * 璐熻矗浜虹紪鍙凤紝鍏宠仈 {@link AdminUserRespDTO#getId()}
      */
     private Long ownerUserId;
diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/invoice/CrmInvoiceMapper.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/invoice/CrmInvoiceMapper.java
index 66daa01..acc9eeb 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/invoice/CrmInvoiceMapper.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/dal/mysql/invoice/CrmInvoiceMapper.java
@@ -51,6 +51,7 @@
         query.selectAll(CrmInvoiceDO.class)
                 .eqIfPresent(CrmInvoiceDO::getNo, pageReqVO.getNo())
                 .eqIfPresent(CrmInvoiceDO::getContractId, pageReqVO.getContractId())
+                .eqIfPresent(CrmInvoiceDO::getSaleOrderId, pageReqVO.getSaleOrderId())
                 .eqIfPresent(CrmInvoiceDO::getAuditStatus, pageReqVO.getAuditStatus())
                 .orderByDesc(CrmInvoiceDO::getId);
         return selectJoinPage(pageReqVO, CrmInvoiceDO.class, query);
@@ -72,6 +73,12 @@
                 .in(CrmInvoiceDO::getAuditStatus, auditStatuses));
     }
 
+    default List<CrmInvoiceDO> selectListBySaleOrderIdAndStatus(Long saleOrderId, Collection<Integer> auditStatuses) {
+        return selectList(new LambdaQueryWrapperX<CrmInvoiceDO>()
+                .eq(CrmInvoiceDO::getSaleOrderId, saleOrderId)
+                .in(CrmInvoiceDO::getAuditStatus, auditStatuses));
+    }
+
     default Map<Long, BigDecimal> selectInvoicePriceMapByContractId(Collection<Long> contractIds) {
         if (CollUtil.isEmpty(contractIds)) {
             return Collections.emptyMap();
diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/enums/ErrorCodeConstants.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/enums/ErrorCodeConstants.java
index d0627c7..7911ac1 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/enums/ErrorCodeConstants.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/enums/ErrorCodeConstants.java
@@ -136,6 +136,8 @@
     ErrorCode RECEIVABLE_CREATE_FAIL_INVOICE_NOT_ATTACHMENT = new ErrorCode(1_020_016_010, "鍒涘缓鍥炴澶辫触锛屽師鍥狅細鍏宠仈鐨勫紑绁ㄦ湭涓婁紶鍙戠エ闄勪欢");
     ErrorCode RECEIVABLE_CREATE_FAIL_INVOICE_CONTRACT_MISMATCH = new ErrorCode(1_020_016_011, "鍒涘缓鍥炴澶辫触锛屽師鍥狅細鍏宠仈鐨勫紑绁ㄤ笌鎵�閫夊悎鍚屼笉鍖归厤");
     ErrorCode RECEIVABLE_CREATE_FAIL_INVOICE_PRICE_EXCEEDS = new ErrorCode(1_020_016_012, "鍒涘缓鍥炴澶辫触锛屽師鍥狅細鍥炴閲戦瓒呭嚭璇ュ紑绁ㄥ墿浣欏彲鍥炴閲戦锛岀洰鍓嶅彲鍥炴锛歿} 鍏�");
+    ErrorCode INVOICE_CREATE_FAIL_SALE_ORDER_NOT_EXISTS = new ErrorCode(1_020_016_013, "鍒涘缓寮�绁ㄥけ璐ワ紝鍘熷洜锛氭墍閫夐攢鍞鍗曚笉瀛樺湪");
+    ErrorCode INVOICE_CREATE_FAIL_SALE_ORDER_NOT_APPROVE = new ErrorCode(1_020_016_014, "鍒涘缓寮�绁ㄥけ璐ワ紝鍘熷洜锛氭墍閫夐攢鍞鍗曚笉鏄鏍搁�氳繃鐘舵��");
 
     ErrorCode CRM_SALES_TARGET_NOT_EXISTS = new ErrorCode(1_020_017_000, "閿�鍞洰鏍囦笉瀛樺湪");
     ErrorCode CRM_SALES_TARGET_PERIOD_VALUE_INVALID = new ErrorCode(1_020_017_001, "鍛ㄦ湡鍊笺�恵}銆戞牸寮忎笉姝g‘锛屽簲涓� {}");
diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/service/invoice/CrmInvoiceService.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/service/invoice/CrmInvoiceService.java
index 53109b1..1d44588 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/service/invoice/CrmInvoiceService.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/service/invoice/CrmInvoiceService.java
@@ -146,4 +146,12 @@
      */
     Long getInvoiceCountByContractId(Long contractId);
 
+    /**
+     * 鑾峰緱閿�鍞鍗曞墿浣欏彲寮�绁ㄩ噾棰濓紙瀹℃壒閫氳繃 + 瀹℃壒涓崰鐢ㄩ搴︼級
+     *
+     * @param saleOrderId 閿�鍞鍗曠紪鍙�
+     * @return 鍓╀綑鍙紑绁ㄩ噾棰�
+     */
+    BigDecimal getSaleOrderRemainInvoicePrice(Long saleOrderId);
+
 }
diff --git a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/service/invoice/CrmInvoiceServiceImpl.java b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/service/invoice/CrmInvoiceServiceImpl.java
index 0216598..ba51dbb 100644
--- a/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/service/invoice/CrmInvoiceServiceImpl.java
+++ b/yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/service/invoice/CrmInvoiceServiceImpl.java
@@ -6,6 +6,7 @@
 import cn.hutool.core.util.ObjUtil;
 import cn.hutool.core.util.ObjectUtil;
 import cn.hutool.core.util.StrUtil;
+import cn.iocoder.yudao.framework.common.exception.ServiceException;
 import cn.iocoder.yudao.framework.common.pojo.PageResult;
 import cn.iocoder.yudao.framework.common.util.collection.CollectionUtils;
 import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
@@ -29,6 +30,8 @@
 import cn.iocoder.yudao.module.crm.service.customer.CrmCustomerService;
 import cn.iocoder.yudao.module.crm.service.permission.CrmPermissionService;
 import cn.iocoder.yudao.module.crm.service.permission.bo.CrmPermissionCreateReqBO;
+import cn.iocoder.yudao.module.erp.api.sale.ErpSaleOrderApi;
+import cn.iocoder.yudao.module.erp.api.sale.dto.ErpSaleOrderRespDTO;
 import cn.iocoder.yudao.module.system.api.storage.StorageAttachmentApi;
 import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
 import com.mzt.logapi.context.LogRecordContext;
@@ -77,6 +80,11 @@
      */
     private static final String INVOICE_RECORD_TYPE = "crm_invoice";
 
+    /**
+     * 閿�鍞鍗曘�屽凡瀹℃牳銆嶇姸鎬侊紝瀵瑰簲 ErpAuditStatus.APPROVE
+     */
+    private static final Integer SALE_ORDER_APPROVE_STATUS = 20;
+
     @Resource
     private CrmInvoiceMapper invoiceMapper;
 
@@ -91,6 +99,8 @@
     private CrmPermissionService permissionService;
 
     @Resource
+    private ErpSaleOrderApi erpSaleOrderApi;
+    @Resource
     private AdminUserApi adminUserApi;
     @Resource
     private BpmProcessInstanceApi bpmProcessInstanceApi;
@@ -102,10 +112,10 @@
     @LogRecord(type = CRM_INVOICE_TYPE, subType = CRM_INVOICE_CREATE_SUB_TYPE, bizNo = "{{#invoice.id}}",
             success = CRM_INVOICE_CREATE_SUCCESS)
     public Long createInvoice(CrmInvoiceSaveReqVO createReqVO) {
-        // 1.1 鏍¢獙鍙紑绁ㄩ噾棰濊秴杩囦笂闄�
-        validateInvoicePriceExceedsLimit(createReqVO);
-        // 1.2 鏍¢獙鍏宠仈鏁版嵁瀛樺湪
-        validateRelationDataExists(createReqVO);
+        // 1.1 鏍¢獙鍏宠仈鏁版嵁瀛樺湪锛堝叧鑱旈攢鍞鍗曟椂杩斿洖璁㈠崟锛岀敤浜庡洖濉鍗曞彿銆佹牎楠屽紑绁ㄩ搴︼級
+        ErpSaleOrderRespDTO saleOrder = validateRelationDataExists(createReqVO);
+        // 1.2 鏍¢獙鍙紑绁ㄩ噾棰濊秴杩囦笂闄�
+        validateInvoicePriceExceedsLimit(createReqVO, saleOrder);
         // 1.3 纭畾寮�绁ㄧ紪鍙凤紙鍓嶇濉啓鍒欑敤鑷畾涔夊崟鍙凤紝鐣欑┖鍒欒嚜鍔ㄧ敓鎴愶級锛屽苟鏍¢獙鍞竴鎬�
         String customNo = StrUtil.trim(createReqVO.getNo());
         String no = StrUtil.isNotBlank(customNo) ? customNo
@@ -116,7 +126,8 @@
 
         // 2.1 鎻掑叆寮�绁�
         CrmInvoiceDO invoice = BeanUtils.toBean(createReqVO, CrmInvoiceDO.class)
-                .setNo(no).setAuditStatus(CrmAuditStatusEnum.DRAFT.getStatus());
+                .setNo(no).setAuditStatus(CrmAuditStatusEnum.DRAFT.getStatus())
+                .setSaleOrderNo(saleOrder != null ? saleOrder.getNo() : null);
         invoiceMapper.insert(invoice);
 
         // 2.2 缁戝畾鍙戠エ闄勪欢
@@ -349,7 +360,21 @@
                 + "銆嶅畬鍏ㄧ浉鍚岋紙鍙兘鏄湰娆″鍏ュ墠闈㈢殑琛岋紝涔熷彲鑳芥槸绯荤粺涓凡鏈夊崟鎹級銆傝鍕块噸澶嶅鍏ワ紱濡傜‘闇�閲嶆柊瀵煎叆锛岃鍏堝湪銆岃惀閿�绠$悊-寮�绁ㄧ鐞嗐�嶄腑鍒犻櫎璇ュ紑绁ㄥ崟鍚庨噸璇�");
     }
 
-    private void validateInvoicePriceExceedsLimit(CrmInvoiceSaveReqVO reqVO) {
+    private void validateInvoicePriceExceedsLimit(CrmInvoiceSaveReqVO reqVO, ErpSaleOrderRespDTO saleOrder) {
+        // 鍏宠仈浜嗛攢鍞鍗曠殑锛屽紑绁ㄩ噾棰濇寜閿�鍞鍗曢噾棰濇牎楠岋紙浼樺厛绾ч珮浜庡悎鍚岋級
+        if (saleOrder != null) {
+            BigDecimal remainPrice = getRemainingInvoicePriceBySaleOrder(saleOrder, reqVO.getId());
+            if (reqVO.getPrice().compareTo(remainPrice) > 0) {
+                throw new ServiceException(INVOICE_CREATE_FAIL_PRICE_EXCEEDS_LIMIT.getCode(),
+                        StrUtil.format("寮�绁ㄩ噾棰濊秴杩囬攢鍞鍗昜{}]鍓╀綑鍙紑绁ㄩ噾棰濓細璇ヨ鍗曢噾棰� {} 鍏冿紝宸插紑绁紙鍚鎵逛腑锛墈} 鍏冿紝"
+                                        + "鍓╀綑鍙紑绁� {} 鍏冿紝鏈濉啓 {} 鍏冦�傝璋冩暣寮�绁ㄩ噾棰濓紝鎴栧厛鍦ㄣ�岃惀閿�绠$悊-寮�绁ㄧ鐞嗐�嶆牳瀵硅鍗曞凡寮�绁ㄩ噾棰濆悗閲嶈瘯銆�",
+                                saleOrder.getNo(), saleOrder.getTotalPrice().stripTrailingZeros().toPlainString(),
+                                saleOrder.getTotalPrice().subtract(remainPrice).stripTrailingZeros().toPlainString(),
+                                remainPrice.stripTrailingZeros().toPlainString(),
+                                reqVO.getPrice().stripTrailingZeros().toPlainString()));
+            }
+            return;
+        }
         // 鏈叧鑱斿悎鍚岀殑锛堝悎鍚岄潪蹇呭~锛夛紝涓嶅崰鐢ㄤ换浣曞悎鍚岀殑寮�绁ㄩ搴︼紝鏃犻渶鏍¢獙涓婇檺
         if (reqVO.getContractId() == null) {
             return;
@@ -379,9 +404,47 @@
                 CollectionUtils.getSumValue(invoices, CrmInvoiceDO::getPrice, BigDecimal::add, BigDecimal.ZERO));
     }
 
-    private void validateRelationDataExists(CrmInvoiceSaveReqVO reqVO) {
+    /**
+     * 璁$畻閿�鍞鍗曞墿浣欏彲寮�绁ㄩ噾棰濓紙瀹℃壒涓�佸鏍搁�氳繃鐨勫紑绁ㄥ崰鐢ㄩ搴︼級
+     *
+     * @param saleOrder       閿�鍞鍗�
+     * @param excludeInvoiceId 闇�鎺掗櫎鐨勫紑绁ㄧ紪鍙凤紝鍙负绌�
+     */
+    private BigDecimal getRemainingInvoicePriceBySaleOrder(ErpSaleOrderRespDTO saleOrder, Long excludeInvoiceId) {
+        List<CrmInvoiceDO> invoices = invoiceMapper.selectListBySaleOrderIdAndStatus(saleOrder.getId(),
+                List.of(CrmAuditStatusEnum.APPROVE.getStatus(), CrmAuditStatusEnum.PROCESS.getStatus()));
+        if (excludeInvoiceId != null) {
+            invoices.removeIf(invoice -> ObjectUtil.equal(invoice.getId(), excludeInvoiceId));
+        }
+        return ObjectUtil.defaultIfNull(saleOrder.getTotalPrice(), BigDecimal.ZERO).subtract(
+                CollectionUtils.getSumValue(invoices, CrmInvoiceDO::getPrice, BigDecimal::add, BigDecimal.ZERO));
+    }
+
+    private ErpSaleOrderRespDTO validateRelationDataExists(CrmInvoiceSaveReqVO reqVO) {
         if (reqVO.getOwnerUserId() != null) {
             adminUserApi.validateUser(reqVO.getOwnerUserId()); // 鏍¢獙璐熻矗浜哄瓨鍦�
+        }
+        // 鍏宠仈閿�鍞鍗曪細璁㈠崟蹇呴』宸插鏍搁�氳繃锛屽鎴蜂互璁㈠崟涓哄噯
+        ErpSaleOrderRespDTO saleOrder = null;
+        if (reqVO.getSaleOrderId() != null) {
+            saleOrder = erpSaleOrderApi.getSaleOrder(reqVO.getSaleOrderId()).getCheckedData();
+            if (saleOrder == null) {
+                throw new ServiceException(INVOICE_CREATE_FAIL_SALE_ORDER_NOT_EXISTS.getCode(),
+                        StrUtil.format("鎵�閫夐攢鍞鍗曚笉瀛樺湪锛堢紪鍙� ID={}锛夛紝鍙兘宸茶鍒犻櫎锛岃鍒锋柊鍚庨噸鏂伴�夋嫨", reqVO.getSaleOrderId()));
+            }
+            if (!SALE_ORDER_APPROVE_STATUS.equals(saleOrder.getStatus())) {
+                throw new ServiceException(INVOICE_CREATE_FAIL_SALE_ORDER_NOT_APPROVE.getCode(),
+                        StrUtil.format("鎵�閫夐攢鍞鍗昜{}]褰撳墠涓嶆槸銆屽凡瀹℃牳銆嶇姸鎬侊紝鍙湁瀹℃牳閫氳繃鐨勯攢鍞鍗曟墠鑳藉紑绁ㄣ��"
+                                + "璇峰厛鍦ㄣ�怑RP-閿�鍞鍗曘�戝畬鎴愯璁㈠崟瀹℃壒锛屾垨鏀归�夊叾浠栧凡瀹℃牳閫氳繃鐨勯攢鍞鍗�", saleOrder.getNo()));
+            }
+            reqVO.setCustomerId(saleOrder.getCustomerId());
+            // 鍚堝悓甯﹀嚭锛氫粎褰撹鍗曞叧鑱旂殑鍚堝悓瀛樺湪涓斿凡瀹℃牳閫氳繃鏃跺洖濉紝閬垮厤鍥犲悎鍚屾湭瀹℃壒鎸′綇鎸夎鍗曞紑绁�
+            if (reqVO.getContractId() == null && saleOrder.getContractId() != null) {
+                CrmContractDO contract = contractService.getContract(saleOrder.getContractId());
+                if (contract != null && ObjectUtil.equal(contract.getAuditStatus(), CrmAuditStatusEnum.APPROVE.getStatus())) {
+                    reqVO.setContractId(contract.getId());
+                }
+            }
         }
         if (reqVO.getCustomerId() != null) {
             customerService.validateCustomer(reqVO.getCustomerId()); // 鏍¢獙瀹㈡埛瀛樺湪
@@ -393,6 +456,7 @@
             }
             reqVO.setCustomerId(contract.getCustomerId()); // 璁剧疆瀹㈡埛缂栧彿
         }
+        return saleOrder;
     }
 
     @Override
@@ -406,9 +470,11 @@
         // 1.1 鏍¢獙瀛樺湪
         CrmInvoiceDO oldInvoice = validateInvoiceExists(updateReqVO.getId());
         updateReqVO.setOwnerUserId(oldInvoice.getOwnerUserId()).setCustomerId(oldInvoice.getCustomerId())
-                .setContractId(oldInvoice.getContractId()); // 璁剧疆宸插瓨鍦ㄧ殑鍊�
-        // 1.2 鏍¢獙鍙紑绁ㄩ噾棰濊秴杩囦笂闄�
-        validateInvoicePriceExceedsLimit(updateReqVO);
+                .setContractId(oldInvoice.getContractId()).setSaleOrderId(oldInvoice.getSaleOrderId()); // 璁剧疆宸插瓨鍦ㄧ殑鍊�
+        // 1.2 鏍¢獙鍙紑绁ㄩ噾棰濊秴杩囦笂闄愶紙閿�鍞鍗曚笉鍙慨鏀癸紝鎸夊師璁㈠崟鏍¢獙棰濆害锛�
+        ErpSaleOrderRespDTO saleOrder = updateReqVO.getSaleOrderId() != null
+                ? erpSaleOrderApi.getSaleOrder(updateReqVO.getSaleOrderId()).getCheckedData() : null;
+        validateInvoicePriceExceedsLimit(updateReqVO, saleOrder);
 
         // 1.3 鍙湁鑽夌銆佸鎵逛腑锛屽彲浠ョ紪杈戯紱
         if (!ObjectUtils.equalsAny(oldInvoice.getAuditStatus(), CrmAuditStatusEnum.DRAFT.getStatus(),
@@ -417,7 +483,9 @@
         }
 
         // 2. 鏇存柊寮�绁�
-        CrmInvoiceDO updateObj = BeanUtils.toBean(updateReqVO, CrmInvoiceDO.class);
+        CrmInvoiceDO updateObj = BeanUtils.toBean(updateReqVO, CrmInvoiceDO.class)
+                // 閿�鍞鍗曚笉鍙慨鏀癸紝娌跨敤鍘熷��
+                .setSaleOrderId(oldInvoice.getSaleOrderId()).setSaleOrderNo(oldInvoice.getSaleOrderNo());
         invoiceMapper.updateById(updateObj);
 
         // 3. 澧為噺鏇存柊鍙戠エ闄勪欢
@@ -480,9 +548,12 @@
             throw exception(INVOICE_SUBMIT_FAIL_NOT_DRAFT);
         }
 
-        // 1.1 閲嶆柊鏍¢獙鍙紑绁ㄩ噾棰濓紝闃叉绱寮�绁ㄨ秴杩囧悎鍚岄噾棰濓紙鑽夌鏈熷悗鍙兘鏈夊叾浠栧崟杩涘叆瀹℃壒涓級
+        // 1.1 閲嶆柊鏍¢獙鍙紑绁ㄩ噾棰濓紝闃叉绱寮�绁ㄨ秴杩囧悎鍚�/閿�鍞鍗曢噾棰濓紙鑽夌鏈熷悗鍙兘鏈夊叾浠栧崟杩涘叆瀹℃壒涓級
+        ErpSaleOrderRespDTO saleOrder = invoice.getSaleOrderId() != null
+                ? erpSaleOrderApi.getSaleOrder(invoice.getSaleOrderId()).getCheckedData() : null;
         validateInvoicePriceExceedsLimit(new CrmInvoiceSaveReqVO()
-                .setId(invoice.getId()).setContractId(invoice.getContractId()).setPrice(invoice.getPrice()));
+                .setId(invoice.getId()).setContractId(invoice.getContractId())
+                .setSaleOrderId(invoice.getSaleOrderId()).setPrice(invoice.getPrice()), saleOrder);
 
         // 2. 鍒涘缓寮�绁ㄥ鎵规祦绋嬪疄渚�
         String processInstanceId = bpmProcessInstanceApi.createProcessInstance(userId, new BpmProcessInstanceCreateReqDTO()
@@ -549,4 +620,13 @@
         return invoiceMapper.selectCountByContractId(contractId);
     }
 
+    @Override
+    public BigDecimal getSaleOrderRemainInvoicePrice(Long saleOrderId) {
+        ErpSaleOrderRespDTO saleOrder = erpSaleOrderApi.getSaleOrder(saleOrderId).getCheckedData();
+        if (saleOrder == null) {
+            throw exception(INVOICE_CREATE_FAIL_SALE_ORDER_NOT_EXISTS);
+        }
+        return getRemainingInvoicePriceBySaleOrder(saleOrder, null);
+    }
+
 }

--
Gitblit v1.9.3