From d39e4f7d839167c16425086dfa2f8747bccfdff9 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期四, 05 十一月 2026 17:39:01 +0800
Subject: [PATCH] feat: 打通销售采购财务闭环并完成累计业务优化
---
yudao-module-crm/src/main/java/cn/iocoder/yudao/module/crm/controller/admin/invoice/CrmInvoiceController.java | 124 +++++++++++++++++++++++++++++++++++++++-
1 files changed, 119 insertions(+), 5 deletions(-)
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 0a960e5..2700294 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
@@ -10,20 +10,28 @@
import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils;
import cn.iocoder.yudao.module.crm.controller.admin.contract.vo.contract.CrmContractRespVO;
+import cn.iocoder.yudao.module.crm.controller.admin.invoice.vo.invoice.CrmInvoiceEntryReqVO;
+import cn.iocoder.yudao.module.crm.controller.admin.invoice.vo.invoice.CrmInvoiceImportExcelVO;
+import cn.iocoder.yudao.module.crm.controller.admin.invoice.vo.invoice.CrmInvoiceImportRespVO;
import cn.iocoder.yudao.module.crm.controller.admin.invoice.vo.invoice.CrmInvoicePageReqVO;
import cn.iocoder.yudao.module.crm.controller.admin.invoice.vo.invoice.CrmInvoiceRespVO;
+import cn.iocoder.yudao.module.crm.controller.admin.invoice.vo.invoice.CrmInvoiceSaleOutRespVO;
import cn.iocoder.yudao.module.crm.controller.admin.invoice.vo.invoice.CrmInvoiceSaveReqVO;
import cn.iocoder.yudao.module.crm.dal.dataobject.contract.CrmContractDO;
import cn.iocoder.yudao.module.crm.dal.dataobject.customer.CrmCustomerDO;
import cn.iocoder.yudao.module.crm.dal.dataobject.invoice.CrmInvoiceDO;
+import cn.iocoder.yudao.module.crm.dal.dataobject.receivable.CrmReceivablePlanDO;
+import cn.iocoder.yudao.module.crm.enums.common.CrmAuditStatusEnum;
import cn.iocoder.yudao.module.crm.service.contract.CrmContractService;
import cn.iocoder.yudao.module.crm.service.customer.CrmCustomerService;
import cn.iocoder.yudao.module.crm.service.invoice.CrmInvoiceService;
+import cn.iocoder.yudao.module.crm.service.receivable.CrmReceivableService;
import cn.iocoder.yudao.module.system.api.dept.DeptApi;
import cn.iocoder.yudao.module.system.api.dept.dto.DeptRespDTO;
import cn.iocoder.yudao.module.system.api.storage.StorageAttachmentApi;
import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
import cn.iocoder.yudao.module.system.api.user.dto.AdminUserRespDTO;
+import cn.iocoder.yudao.module.system.enums.storage.StorageRecordTypeEnum;
import io.swagger.v3.oas.annotations.Operation;
import io.swagger.v3.oas.annotations.Parameter;
import io.swagger.v3.oas.annotations.tags.Tag;
@@ -33,8 +41,11 @@
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.validation.annotation.Validated;
import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
import java.io.IOException;
+import java.math.BigDecimal;
+import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import java.util.Map;
@@ -60,6 +71,8 @@
private CrmContractService contractService;
@Resource
private CrmCustomerService customerService;
+ @Resource
+ private CrmReceivableService receivableService;
@Resource
private AdminUserApi adminUserApi;
@@ -83,6 +96,24 @@
return success(true);
}
+ @PutMapping("/entry")
+ @Operation(summary = "寮�绁ㄧ敵璇峰綍鍏ュ彂绁�", description = "寮�绁ㄧ敵璇峰鎵归�氳繃鍚庯紝褰曞叆鐪熷疄鍙戠エ鍙风爜銆佸紑绁ㄦ棩鏈熴�侀檮浠讹紝骞跺～鍐欐敹娆捐妭鐐�")
+ @PreAuthorize("@ss.hasPermission('crm:invoice:update')")
+ public CommonResult<Boolean> entryInvoice(@Valid @RequestBody CrmInvoiceEntryReqVO entryReqVO) {
+ invoiceService.entryInvoice(entryReqVO);
+ return success(true);
+ }
+
+ @GetMapping("/sale-out-list")
+ @Operation(summary = "鑾峰緱寮�绁ㄥ彲閫夌殑閿�鍞嚭搴撳崟", description = "鎸夐攢鍞鍗曟煡璇� MES 宸插畬鎴愬嚭搴撳崟锛岃繑鍥炲凡寮�绁ㄩ噾棰濅笌鍓╀綑鍙紑绁ㄩ噾棰�")
+ @Parameter(name = "saleOrderId", description = "閿�鍞鍗曠紪鍙�", required = true)
+ @Parameter(name = "id", description = "寮�绁ㄥ崟缂栧彿锛堢紪杈戞椂浼犻�掞紝鐢ㄤ簬鎺掗櫎鑷韩宸插崰鐢ㄩ噾棰濓級")
+ public CommonResult<List<CrmInvoiceSaleOutRespVO>> getSaleOutListForInvoice(
+ @RequestParam("saleOrderId") Long saleOrderId,
+ @RequestParam(value = "id", required = false) Long id) {
+ return success(invoiceService.getSaleOutListForInvoice(saleOrderId, id));
+ }
+
@DeleteMapping("/delete")
@Operation(summary = "鍒犻櫎寮�绁�")
@Parameter(name = "id", description = "缂栧彿", required = true)
@@ -95,7 +126,6 @@
@GetMapping("/get")
@Operation(summary = "鑾峰緱寮�绁�")
@Parameter(name = "id", description = "缂栧彿", required = true, example = "1024")
- @PreAuthorize("@ss.hasPermission('crm:invoice:query')")
public CommonResult<CrmInvoiceRespVO> getInvoice(@RequestParam("id") Long id) {
CrmInvoiceDO invoice = invoiceService.getInvoice(id);
return success(buildInvoiceDetail(invoice));
@@ -105,12 +135,30 @@
if (invoice == null) {
return null;
}
- return buildInvoiceDetailList(Collections.singletonList(invoice)).get(0);
+ CrmInvoiceRespVO invoiceVO = buildInvoiceDetailList(Collections.singletonList(invoice)).get(0);
+ // 璇︽儏椤佃ˉ鍏呮敹娆捐妭鐐癸紙鍒楄〃椤典笉杩斿洖锛岄伩鍏� N+1 鏌ヨ锛�
+ List<CrmReceivablePlanDO> plans = invoiceService.getPaymentNodeListByInvoiceId(invoice.getId());
+ if (CollUtil.isNotEmpty(plans)) {
+ List<CrmInvoiceRespVO.PaymentNode> nodes = new ArrayList<>(plans.size());
+ for (CrmReceivablePlanDO plan : plans) {
+ CrmInvoiceRespVO.PaymentNode node = new CrmInvoiceRespVO.PaymentNode();
+ node.setId(plan.getId());
+ node.setStage(plan.getStage());
+ node.setAmount(plan.getPrice());
+ node.setReturnTime(plan.getReturnTime());
+ node.setActualTime(plan.getActualTime());
+ node.setReceiptedPrice(plan.getReceiptedPrice());
+ node.setStatus(plan.getStatus());
+ node.setRemark(plan.getRemark());
+ nodes.add(node);
+ }
+ invoiceVO.setPaymentNodes(nodes);
+ }
+ return invoiceVO;
}
@GetMapping("/page")
@Operation(summary = "鑾峰緱寮�绁ㄥ垎椤�")
- @PreAuthorize("@ss.hasPermission('crm:invoice:query')")
public CommonResult<PageResult<CrmInvoiceRespVO>> getInvoicePage(@Valid CrmInvoicePageReqVO pageReqVO) {
PageResult<CrmInvoiceDO> pageResult = invoiceService.getInvoicePage(pageReqVO, getLoginUserId());
return success(new PageResult<>(buildInvoiceDetailList(pageResult.getList()), pageResult.getTotal()));
@@ -137,6 +185,27 @@
buildInvoiceDetailList(list));
}
+ @GetMapping("/get-import-template")
+ @Operation(summary = "鑾峰緱瀵煎叆寮�绁ㄦā鏉�")
+ @PreAuthorize("@ss.hasPermission('crm:invoice:import')")
+ public void importTemplate(HttpServletResponse response) throws IOException {
+ List<CrmInvoiceImportExcelVO> list = Collections.singletonList(
+ CrmInvoiceImportExcelVO.builder()
+ .contractNo("HT20260101000001").invoiceType("澧炲�肩◣涓撶敤鍙戠エ")
+ .invoiceNo("02564178").invoiceTitle("绀轰緥瀹㈡埛鏈夐檺鍏徃").price(new BigDecimal("10000.00"))
+ .invoiceTime("2026-01-01 10:00:00").remark("绀轰緥鏁版嵁锛屽鍏ュ墠璇锋浛鎹�")
+ .build());
+ ExcelUtils.write(response, "寮�绁ㄥ鍏ユā鏉�.xls", "寮�绁�", CrmInvoiceImportExcelVO.class, list);
+ }
+
+ @PostMapping("/import")
+ @Operation(summary = "瀵煎叆寮�绁�")
+ @PreAuthorize("@ss.hasPermission('crm:invoice:import')")
+ public CommonResult<CrmInvoiceImportRespVO> importInvoiceExcel(@RequestParam("file") MultipartFile file) throws Exception {
+ List<CrmInvoiceImportExcelVO> list = ExcelUtils.read(file, CrmInvoiceImportExcelVO.class);
+ return success(invoiceService.importInvoiceList(list));
+ }
+
private List<CrmInvoiceRespVO> buildInvoiceDetailList(List<CrmInvoiceDO> invoiceList) {
if (CollUtil.isEmpty(invoiceList)) {
return Collections.emptyList();
@@ -151,6 +220,9 @@
// 1.3 鑾峰緱鍚堝悓鍒楄〃
Map<Long, CrmContractDO> contractMap = contractService.getContractMap(
convertSet(invoiceList, CrmInvoiceDO::getContractId));
+ // 1.4 鑾峰緱姣忓紶寮�绁ㄥ凡鍥炴閲戦锛堣崏绋� + 瀹℃壒涓� + 瀹℃壒閫氳繃锛�
+ Map<Long, BigDecimal> receivablePriceMap = receivableService.getReceivablePriceMapByInvoiceId(
+ convertSet(invoiceList, CrmInvoiceDO::getId));
// 2. 鎷兼帴缁撴灉
return BeanUtils.toBean(invoiceList, CrmInvoiceRespVO.class, (invoiceVO) -> {
// 2.1 鎷兼帴瀹㈡埛鍚嶇О
@@ -166,7 +238,13 @@
findAndThen(contractMap, invoiceVO.getContractId(), contract ->
invoiceVO.setContract(BeanUtils.toBean(contract, CrmContractRespVO.class)));
// 2.4 鎷兼帴鍙戠エ闄勪欢
- invoiceVO.setAttachmentList(storageAttachmentApi.listAttachments("crm_invoice", invoiceVO.getId()));
+ invoiceVO.setAttachmentList(storageAttachmentApi.listAttachments(
+ StorageRecordTypeEnum.CRM_INVOICE.getType(), invoiceVO.getId()));
+ // 2.5 鎷兼帴鏄惁宸蹭笂浼犻檮浠�
+ invoiceVO.setHasAttachment(CollUtil.isNotEmpty(invoiceVO.getAttachmentList()));
+ // 2.6 鎷兼帴鍓╀綑鍙洖娆鹃噾棰�
+ invoiceVO.setRemainingInvoicePrice(invoiceVO.getPrice().subtract(
+ receivablePriceMap.getOrDefault(invoiceVO.getId(), BigDecimal.ZERO)));
});
}
@@ -180,9 +258,45 @@
@GetMapping("/audit-count")
@Operation(summary = "鑾峰緱寰呭鏍稿紑绁ㄦ暟閲�")
- @PreAuthorize("@ss.hasPermission('crm:invoice:query')")
public CommonResult<Long> getAuditInvoiceCount() {
return success(invoiceService.getAuditInvoiceCount(getLoginUserId()));
}
+ @GetMapping("/simple-list")
+ @Operation(summary = "鑾峰緱寮�绁ㄧ簿绠�鍒楄〃", description = "鍙寘鍚鏍搁�氳繃涓斿凡涓婁紶鍙戠エ闄勪欢鐨勫紑绁紝涓昏鐢ㄤ簬鍥炴鍒涘缓鏃堕�夋嫨鍏宠仈寮�绁�")
+ @Parameter(name = "contractId", description = "鍚堝悓缂栧彿", required = true)
+ public CommonResult<List<CrmInvoiceRespVO>> getInvoiceSimpleList(@RequestParam("contractId") Long contractId) {
+ List<CrmInvoiceDO> invoices = invoiceService.getInvoiceListByContractIdAndStatus(contractId,
+ List.of(CrmAuditStatusEnum.APPROVE.getStatus()));
+ if (CollUtil.isEmpty(invoices)) {
+ return success(Collections.emptyList());
+ }
+ // 杩囨护锛氬繀椤绘槸宸插綍鍏ュ彂绁紙entryStatus=10锛夛紱鍘嗗彶鏁版嵁鏃犲綍鍏ョ姸鎬佹椂锛屼互鏄惁瀛樺湪鍙戠エ闄勪欢鍏滃簳
+ invoices.removeIf(invoice -> !Integer.valueOf(10).equals(invoice.getEntryStatus())
+ && CollUtil.isEmpty(storageAttachmentApi.listAttachments(
+ StorageRecordTypeEnum.CRM_INVOICE.getType(), invoice.getId())));
+ if (CollUtil.isEmpty(invoices)) {
+ return success(Collections.emptyList());
+ }
+ // 璁＄畻姣忓紶寮�绁ㄥ凡鍥炴閲戦锛堣崏绋� + 瀹℃壒涓� + 瀹℃壒閫氳繃锛屽彛寰勪笌鍒涘缓鍥炴鏍￠獙涓�鑷达級
+ Map<Long, BigDecimal> receivablePriceMap = receivableService.getReceivablePriceMapByInvoiceId(
+ convertSet(invoices, CrmInvoiceDO::getId));
+ // 杩囨护锛氬墿浣欏彲鍥炴閲戦 > 0 鎵嶅彲閫�
+ List<CrmInvoiceRespVO> result = new ArrayList<>();
+ for (CrmInvoiceDO invoice : invoices) {
+ BigDecimal remainingPrice = invoice.getPrice()
+ .subtract(receivablePriceMap.getOrDefault(invoice.getId(), BigDecimal.ZERO));
+ if (remainingPrice.compareTo(BigDecimal.ZERO) <= 0) {
+ continue;
+ }
+ result.add(new CrmInvoiceRespVO() // 鍙繑鍥炵簿绠�瀛楁
+ .setId(invoice.getId()).setNo(invoice.getNo()).setInvoiceNo(invoice.getInvoiceNo())
+ .setInvoiceTitle(invoice.getInvoiceTitle()).setPrice(invoice.getPrice())
+ .setCustomerId(invoice.getCustomerId()).setContractId(invoice.getContractId())
+ .setAuditStatus(invoice.getAuditStatus()).setHasAttachment(true)
+ .setRemainingInvoicePrice(remainingPrice));
+ }
+ return success(result);
+ }
+
}
--
Gitblit v1.9.3