| | |
| | | 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.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.CrmInvoiceSaveReqVO; |
| | |
| | | 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; |
| | |
| | | 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(); |