| | |
| | | settlementExportVO.setCreateTime1(createTime.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"))); |
| | | settlementExportVO.setStartTime1(startTime.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"))); |
| | | settlementExportVO.setEndTime1(endTime.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"))); |
| | | switch (settlementExportVO.getStatus()){ |
| | | case 0: |
| | | settlementExportVO.setStatusName("未知"); |
| | | break; |
| | | case 1: |
| | | settlementExportVO.setStatusName("等待中/已插枪"); |
| | | break; |
| | | case 2: |
| | | settlementExportVO.setStatusName("启动中"); |
| | | break; |
| | | case 3: |
| | | settlementExportVO.setStatusName("充电中"); |
| | | break; |
| | | case 4: |
| | | settlementExportVO.setStatusName("停止中"); |
| | | break; |
| | | case 5: |
| | | settlementExportVO.setStatusName("已结束"); |
| | | break; |
| | | if (chargingOrder.getStatus()!=null){ |
| | | switch (chargingOrder.getStatus()){ |
| | | case 0: |
| | | settlementExportVO.setStatusName("未知"); |
| | | break; |
| | | case 1: |
| | | settlementExportVO.setStatusName("等待中/已插枪"); |
| | | break; |
| | | case 2: |
| | | settlementExportVO.setStatusName("启动中"); |
| | | break; |
| | | case 3: |
| | | settlementExportVO.setStatusName("充电中"); |
| | | break; |
| | | case 4: |
| | | settlementExportVO.setStatusName("停止中"); |
| | | break; |
| | | case 5: |
| | | settlementExportVO.setStatusName("已结束"); |
| | | break; |
| | | |
| | | } |
| | | } |
| | | settlementExportVO.setOrderTypeName("充电订单"); |
| | | settlementExportVO.setChargingType("单桩双充"); |
| | |
| | | excelWriter.fill(new FillWrapper("data1", chargingBillVOS), fillConfig, writeSheet); |
| | | excelWriter.fill(new FillWrapper("data2", chargingBillVOS), fillConfig, writeSheet2); |
| | | excelWriter.fill(new FillWrapper("data3", data.getList()), fillConfig, writeSheet3); |
| | | excelWriter.fill(new FillWrapper("data4", data.getList()), fillConfig, writeSheet3); |
| | | excelWriter.finish(); |
| | | } catch (Exception e) { |
| | | return R.fail("excel导出失败!"); |