| | |
| | | import java.math.BigDecimal; |
| | | import java.math.RoundingMode; |
| | | import java.net.URLEncoder; |
| | | import java.text.SimpleDateFormat; |
| | | import java.time.format.DateTimeFormatter; |
| | | import java.util.ArrayList; |
| | | import java.util.Arrays; |
| | |
| | | @ApiOperation(value = "充电时段统计-导出", tags = {"管理后台-财务结算"}) |
| | | @PutMapping("/export") |
| | | public void export(@RequestBody ChargingListQuery dto) { |
| | | SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); |
| | | |
| | | ChargingOrderTimeVO res = chargingOrderService.chargingList(dto); |
| | | List<TChargingOrderExport> tChargingOrderExports = new ArrayList<>(); |
| | | List<ChargingOrderListVO> exportList = res.getList().getRecords(); |
| | |
| | | tChargingOrderExport.setOrderClassification("1"); |
| | | tChargingOrderExport.setStartType("扫码"); |
| | | tChargingOrderExport.setOne("小程序"); |
| | | tChargingOrderExport.setTwo("小程序"); |
| | | tChargingOrderExport.setCreateTime(chargingOrderListVO.getCreateTime()+""); |
| | | tChargingOrderExport.setStartTime(chargingOrderListVO.getStartTime()+""); |
| | | tChargingOrderExport.setEndTime(chargingOrderListVO.getEndTime()+""); |
| | | if (chargingOrderListVO.getRechargePaymentType()!=null){ |
| | | switch (chargingOrderListVO.getRechargePaymentType()){ |
| | | case 1: |
| | | tChargingOrderExport.setTwo("微信小程序"); |
| | | break; |
| | | case 2: |
| | | tChargingOrderExport.setTwo("支付宝小程序"); |
| | | break; |
| | | } |
| | | } |
| | | String s1 = DateUtils.localDateTimeToString(chargingOrderListVO.getCreateTime()); |
| | | String s2 = DateUtils.localDateTimeToString(chargingOrderListVO.getStartTime()); |
| | | String s3 = DateUtils.localDateTimeToString(chargingOrderListVO.getEndTime()); |
| | | tChargingOrderExport.setCreateTime(s1); |
| | | tChargingOrderExport.setStartTime(s2); |
| | | tChargingOrderExport.setEndTime(s3); |
| | | tChargingOrderExport.setRechargePaymentStatus(chargingOrderListVO.getRechargePaymentStatus()+""); |
| | | tChargingOrderExport.setType("充电订单"); |
| | | tChargingOrderExport.setChargingType("单桩双充"); |
| | |
| | | BigDecimal size = new BigDecimal(stageCost.size()); |
| | | |
| | | for (TChargingOrderAccountingStrategy tChargingOrderAccountingStrategy : stageCost) { |
| | | bigDecimal1 = bigDecimal1.add(tChargingOrderAccountingStrategy.getElectrovalence()); |
| | | bigDecimal1 = bigDecimal1.add(tChargingOrderAccountingStrategy.getPeriodElectricPrice()); |
| | | bigDecimal2 = bigDecimal2.add(tChargingOrderAccountingStrategy.getPeriodServicePrice()); |
| | | bigDecimal3 = bigDecimal3.add(tChargingOrderAccountingStrategy.getPeriodOriginalServicePrice()); |
| | | } |
| | |
| | | tChargingOrderExport.setVipType(data1.getName()); |
| | | } |
| | | } |
| | | // tChargingOrderExport.setVipType(); |
| | | tChargingOrderExport.setIsPlus(chargingOrderListVO.getVipDiscountAmount().compareTo(BigDecimal.ZERO)>0?"是":"否"); |
| | | if (data3!=null){ |
| | | tChargingOrderExport.setRealName(data3.getName()); |