package cn.iocoder.yudao.module.crm.controller.admin.invoice;
|
|
import cn.hutool.core.collection.CollUtil;
|
import cn.hutool.core.lang.Assert;
|
import cn.iocoder.yudao.framework.apilog.core.annotation.ApiAccessLog;
|
import cn.iocoder.yudao.framework.common.pojo.CommonResult;
|
import cn.iocoder.yudao.framework.common.pojo.PageResult;
|
import cn.iocoder.yudao.framework.common.util.collection.MapUtils;
|
import cn.iocoder.yudao.framework.common.util.number.NumberUtils;
|
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.CrmInvoicePageReqVO;
|
import cn.iocoder.yudao.module.crm.controller.admin.invoice.vo.invoice.CrmInvoiceRespVO;
|
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.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;
|
import jakarta.annotation.Resource;
|
import jakarta.servlet.http.HttpServletResponse;
|
import jakarta.validation.Valid;
|
import org.springframework.security.access.prepost.PreAuthorize;
|
import org.springframework.validation.annotation.Validated;
|
import org.springframework.web.bind.annotation.*;
|
|
import java.io.IOException;
|
import java.math.BigDecimal;
|
import java.util.ArrayList;
|
import java.util.Collections;
|
import java.util.List;
|
import java.util.Map;
|
import java.util.stream.Stream;
|
|
import static cn.iocoder.yudao.framework.apilog.core.enums.OperateTypeEnum.EXPORT;
|
import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
|
import static cn.iocoder.yudao.framework.common.pojo.PageParam.PAGE_SIZE_NONE;
|
import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertListByFlatMap;
|
import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet;
|
import static cn.iocoder.yudao.framework.common.util.collection.MapUtils.findAndThen;
|
import static cn.iocoder.yudao.framework.security.core.util.SecurityFrameworkUtils.getLoginUserId;
|
|
@Tag(name = "管理后台 - CRM 开票")
|
@RestController
|
@RequestMapping("/crm/invoice")
|
@Validated
|
public class CrmInvoiceController {
|
|
@Resource
|
private CrmInvoiceService invoiceService;
|
@Resource
|
private CrmContractService contractService;
|
@Resource
|
private CrmCustomerService customerService;
|
@Resource
|
private CrmReceivableService receivableService;
|
|
@Resource
|
private AdminUserApi adminUserApi;
|
@Resource
|
private DeptApi deptApi;
|
@Resource
|
private StorageAttachmentApi storageAttachmentApi;
|
|
@PostMapping("/create")
|
@Operation(summary = "创建开票")
|
@PreAuthorize("@ss.hasPermission('crm:invoice:create')")
|
public CommonResult<Long> createInvoice(@Valid @RequestBody CrmInvoiceSaveReqVO createReqVO) {
|
return success(invoiceService.createInvoice(createReqVO));
|
}
|
|
@PutMapping("/update")
|
@Operation(summary = "更新开票")
|
@PreAuthorize("@ss.hasPermission('crm:invoice:update')")
|
public CommonResult<Boolean> updateInvoice(@Valid @RequestBody CrmInvoiceSaveReqVO updateReqVO) {
|
invoiceService.updateInvoice(updateReqVO);
|
return success(true);
|
}
|
|
@DeleteMapping("/delete")
|
@Operation(summary = "删除开票")
|
@Parameter(name = "id", description = "编号", required = true)
|
@PreAuthorize("@ss.hasPermission('crm:invoice:delete')")
|
public CommonResult<Boolean> deleteInvoice(@RequestParam("id") Long id) {
|
invoiceService.deleteInvoice(id);
|
return success(true);
|
}
|
|
@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));
|
}
|
|
private CrmInvoiceRespVO buildInvoiceDetail(CrmInvoiceDO invoice) {
|
if (invoice == null) {
|
return null;
|
}
|
return buildInvoiceDetailList(Collections.singletonList(invoice)).get(0);
|
}
|
|
@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()));
|
}
|
|
@GetMapping("/page-by-customer")
|
@Operation(summary = "获得开票分页，基于指定客户")
|
public CommonResult<PageResult<CrmInvoiceRespVO>> getInvoicePageByCustomer(@Valid CrmInvoicePageReqVO pageReqVO) {
|
Assert.notNull(pageReqVO.getCustomerId(), "客户编号不能为空");
|
PageResult<CrmInvoiceDO> pageResult = invoiceService.getInvoicePageByCustomerId(pageReqVO);
|
return success(new PageResult<>(buildInvoiceDetailList(pageResult.getList()), pageResult.getTotal()));
|
}
|
|
@GetMapping("/export-excel")
|
@Operation(summary = "导出开票 Excel")
|
@PreAuthorize("@ss.hasPermission('crm:invoice:export')")
|
@ApiAccessLog(operateType = EXPORT)
|
public void exportInvoiceExcel(@Valid CrmInvoicePageReqVO exportReqVO,
|
HttpServletResponse response) throws IOException {
|
exportReqVO.setPageSize(PAGE_SIZE_NONE);
|
List<CrmInvoiceDO> list = invoiceService.getInvoicePage(exportReqVO, getLoginUserId()).getList();
|
// 导出 Excel
|
ExcelUtils.write(response, "开票.xls", "数据", CrmInvoiceRespVO.class,
|
buildInvoiceDetailList(list));
|
}
|
|
private List<CrmInvoiceRespVO> buildInvoiceDetailList(List<CrmInvoiceDO> invoiceList) {
|
if (CollUtil.isEmpty(invoiceList)) {
|
return Collections.emptyList();
|
}
|
// 1.1 获取客户列表
|
Map<Long, CrmCustomerDO> customerMap = customerService.getCustomerMap(
|
convertSet(invoiceList, CrmInvoiceDO::getCustomerId));
|
// 1.2 获取创建人、负责人列表
|
Map<Long, AdminUserRespDTO> userMap = adminUserApi.getUserMap(convertListByFlatMap(invoiceList,
|
invoice -> Stream.of(NumberUtils.parseLong(invoice.getCreator()), invoice.getOwnerUserId())));
|
Map<Long, DeptRespDTO> deptMap = deptApi.getDeptMap(convertSet(userMap.values(), AdminUserRespDTO::getDeptId));
|
// 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 拼接客户名称
|
findAndThen(customerMap, invoiceVO.getCustomerId(), customer -> invoiceVO.setCustomerName(customer.getName()));
|
// 2.2 拼接负责人、创建人名称
|
MapUtils.findAndThen(userMap, NumberUtils.parseLong(invoiceVO.getCreator()),
|
user -> invoiceVO.setCreatorName(user.getNickname()));
|
MapUtils.findAndThen(userMap, invoiceVO.getOwnerUserId(), user -> {
|
invoiceVO.setOwnerUserName(user.getNickname());
|
MapUtils.findAndThen(deptMap, user.getDeptId(), dept -> invoiceVO.setOwnerUserDeptName(dept.getName()));
|
});
|
// 2.3 拼接合同信息
|
findAndThen(contractMap, invoiceVO.getContractId(), contract ->
|
invoiceVO.setContract(BeanUtils.toBean(contract, CrmContractRespVO.class)));
|
// 2.4 拼接发票附件
|
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)));
|
});
|
}
|
|
@PutMapping("/submit")
|
@Operation(summary = "提交开票审批")
|
@PreAuthorize("@ss.hasPermission('crm:invoice:update')")
|
public CommonResult<Boolean> submitInvoice(@RequestParam("id") Long id) {
|
invoiceService.submitInvoice(id, getLoginUserId());
|
return success(true);
|
}
|
|
@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)
|
@PreAuthorize("@ss.hasPermission('crm:invoice:query')")
|
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());
|
}
|
// 过滤：已上传发票附件
|
invoices.removeIf(invoice -> 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);
|
}
|
|
}
|
