| | |
|---|
| | | @ApiOperation(value = "下载", tags = {"管理后台-账户结算账单"}) |
|---|
| | | @PutMapping("/downloadAccount") |
|---|
| | | public R downloadAccount(@RequestBody ChargingListQuery dto,HttpServletResponse response) |
|---|
| | | { |
|---|
| | | { dto.setPageCurr(1); |
|---|
| | | dto.setPageSize(99999999); |
|---|
| | | AccountListVO data = orderClient.accountBillList(dto).getData(); |
|---|
| | | try { |
|---|
| | | response.setCharacterEncoding(Constants.UTF8); |
|---|
| | |
|---|
| | | try { |
|---|
| | | // excel模板封装 |
|---|
| | | ExcelWriterBuilder excelWriterBuilder = EasyExcelFactory.write(response.getOutputStream()); |
|---|
| | | InputStream stream = Thread.currentThread().getContextClassLoader().getResourceAsStream("template/" +"运营商名称1-充电桩名称1-结算对账单明细-结算月份1" + ".xlsx"); |
|---|
| | | InputStream stream = Thread.currentThread().getContextClassLoader().getResourceAsStream("template/" +"结算汇总" + ".xlsx"); |
|---|
| | | // 自动释放资源 |
|---|
| | | try (ExcelWriter excelWriter = excelWriterBuilder.withTemplate(stream).build()) { |
|---|
| | | WriteSheet writeSheet = EasyExcel.writerSheet().build(); |
|---|
