feat(crm): 投标保证金迁移到销售管理并关联销售台账

gaoluyang

4 天以前 cdaec80a5ffa474f69e5c36f0312be3c0abf2210

 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);
    }

}