| | |
|---|
| | | response.setContentType("application/vnd.ms-excel"); |
|---|
| | | response.setHeader("Access-Control-Expose-Headers", "Content-disposition"); |
|---|
| | | response.setHeader("Content-Disposition", "attachment;filename=" + |
|---|
| | | URLEncoder.encode("月账单-"+data.getCategory()+"-"+data.getBillWeek()+"-"+data.getSiteName(), CharEncoding.UTF_8) + ".xlsx"); |
|---|
| | | // URLEncoder.encode("月账单-"+data.getCategory()+"-"+data.getBillWeek()+"-"+data.getSiteName(), CharEncoding.UTF_8) + ".xlsx"); |
|---|
| | | URLEncoder.encode("月账单", CharEncoding.UTF_8) + ".xlsx"); |
|---|
| | | } catch (UnsupportedEncodingException e) { |
|---|
| | | return R.fail("excel导出失败！"); |
|---|
| | | } |
|---|
| | |
|---|
| | | BigDecimal bigDecimal = new BigDecimal("0"); |
|---|
| | | |
|---|
| | | for (TChargingOrder chargingOrder : collect) { |
|---|
| | | bigDecimal = bigDecimal.add(chargingOrder.getPaymentAmount()); |
|---|
| | | bigDecimal = bigDecimal.add(chargingOrder.getRefundAmount()); |
|---|
| | | if (chargingOrder.getRechargePaymentType()!=null){ |
|---|
| | | switch (chargingOrder.getRechargePaymentType()){ |
|---|
| | | case 1: |
|---|
