| | |
| | | |
| | | @Override |
| | | public ChargingBillVO chargingBillList1(ChargingListQuery dto) { |
| | | |
| | | ChargingBillVO chargingBillVO = new ChargingBillVO(); |
| | | List<TChargingOrder> tChargingOrders1 = new ArrayList<>(); |
| | | String startTime1 = null; |
| | |
| | | List<TAppUser> userList = appUserClient.getAllUser().getData(); |
| | | List<TAppUserCar> carList = appUserCarClient.getAllCar().getData(); |
| | | List<TChargingOrder> total = chargingOrderList.selectList(new LambdaQueryWrapper<>(TChargingOrder.class) |
| | | .eq(TChargingOrder::getRechargePaymentStatus, 2)); |
| | | .eq(TChargingOrder::getRechargePaymentStatus, 2).eq(TChargingOrder::getStatus, 5)); |
| | | List<TChargingOrderRefund> totalRefund = chargingOrderRefundService.lambdaQuery().eq(TChargingOrderRefund::getRefundStatus, 2).list(); |
| | | Long userId = tokenService.getLoginUser().getUserid(); |
| | | // 查询当前登陆人按钮权限 |
| | |
| | | break; |
| | | case 2: |
| | | temp = "各个站点账单"; |
| | | temp1 = siteClient.getSiteByIds(Arrays.asList(chargingBillListVO.getSiteId())).getData().get(0).getName(); |
| | | Site site = siteList.stream().filter(e -> e.getId().equals(chargingBillListVO.getSiteId())).findFirst().orElse(null); |
| | | if (site!=null){ |
| | | temp1 =site.getName(); |
| | | } |
| | | break; |
| | | } |
| | | chargingBillVO.setCategory(temp); |
| | |
| | | // 获取该月份的最后一天 |
| | | LocalDateTime lastDayOfMonth = localDate.with(TemporalAdjusters.lastDayOfMonth()); |
| | | LocalDateTime firstDayOfMonth = localDate.with(TemporalAdjusters.firstDayOfMonth()); |
| | | List<TChargingOrder> tChargingOrders = total.stream().filter(e -> chargingBillListVO.getType() == 2 ? |
| | | e.getSiteId().equals(chargingBillListVO.getSiteId()) : true && |
| | | e.getPayTime().isBefore(lastDayOfMonth.withHour(23).withMinute(59).withSecond(59)) |
| | | && e.getPayTime().isAfter(firstDayOfMonth.withHour(0).withMinute(0).withSecond(0))).collect(Collectors.toList()); |
| | | List<TChargingOrder> tChargingOrders = new ArrayList<>(); |
| | | if (chargingBillListVO.getType() == 2){ |
| | | tChargingOrders = total.stream().filter(e -> e.getSiteId().equals(chargingBillListVO.getSiteId()) && e.getPayTime().isBefore(lastDayOfMonth.withHour(23).withMinute(59).withSecond(59)) |
| | | && e.getPayTime().isAfter(firstDayOfMonth.withHour(0).withMinute(0).withSecond(0))).collect(Collectors.toList()); |
| | | }else{ |
| | | tChargingOrders = total.stream().filter(e -> e.getPayTime().isBefore(lastDayOfMonth.withHour(23).withMinute(59).withSecond(59)) |
| | | && e.getPayTime().isAfter(firstDayOfMonth.withHour(0).withMinute(0).withSecond(0))).collect(Collectors.toList()); |
| | | } |
| | | |
| | | |
| | | |
| | | int chargingSecond = 0; |
| | |
| | | BigDecimal add = tChargingOrder.getElectrovalence().add(tChargingOrder.getServiceCharge()); |
| | | tChargingOrder.setTotalAmount(add.toString()); |
| | | tChargingOrder.setDiscount(tChargingOrder.getCouponDiscountAmount()!=null?tChargingOrder.getCouponDiscountAmount().toString():"0"); |
| | | UploadRealTimeMonitoringData data5 = uploadRealTimeMonitoringDataClient.chargingOrderInfo(tChargingOrder.getCode()).getData(); |
| | | if (data5!=null){ |
| | | tChargingOrder.setEndSoc(data5.getSoc().toString()); |
| | | } |
| | | // UploadRealTimeMonitoringData data5 = uploadRealTimeMonitoringDataClient.chargingOrderInfo(tChargingOrder.getCode()).getData(); |
| | | // if (data5!=null){ |
| | | // tChargingOrder.setEndSoc(data5.getSoc().toString()); |
| | | // } |
| | | if (tChargingOrder.getStartTime()!=null && tChargingOrder.getEndTime()!=null){ |
| | | LocalDateTime startTime = tChargingOrder.getStartTime(); |
| | | LocalDateTime endTime = tChargingOrder.getEndTime(); |
| | |
| | | // 获取该月份的最后一天 |
| | | LocalDateTime lastDayOfMonth = localDate.with(TemporalAdjusters.lastDayOfMonth()); |
| | | LocalDateTime firstDayOfMonth = localDate.with(TemporalAdjusters.firstDayOfMonth()); |
| | | List<TChargingOrder> tChargingOrders = total.stream().filter(e -> chargingBillListVO.getType() == 2 ? |
| | | e.getSiteId().equals(chargingBillListVO.getSiteId()) : true && |
| | | e.getPayTime().isBefore(lastDayOfMonth.withHour(23).withMinute(59).withSecond(59)) |
| | | && e.getPayTime().isAfter(firstDayOfMonth.withHour(0).withMinute(0).withSecond(0))).collect(Collectors.toList()); |
| | | List<TChargingOrder> tChargingOrders = new ArrayList<>(); |
| | | if (chargingBillListVO.getType() == 2){ |
| | | tChargingOrders = total.stream().filter(e -> e.getSiteId().equals(chargingBillListVO.getSiteId()) && e.getPayTime().isBefore(lastDayOfMonth.withHour(23).withMinute(59).withSecond(59)) |
| | | && e.getPayTime().isAfter(firstDayOfMonth.withHour(0).withMinute(0).withSecond(0))).collect(Collectors.toList()); |
| | | }else{ |
| | | tChargingOrders = total.stream().filter(e -> e.getPayTime().isBefore(lastDayOfMonth.withHour(23).withMinute(59).withSecond(59)) |
| | | && e.getPayTime().isAfter(firstDayOfMonth.withHour(0).withMinute(0).withSecond(0))).collect(Collectors.toList()); |
| | | } |
| | | for (TChargingOrder tChargingOrder : tChargingOrders) { |
| | | if (tChargingOrder.getOrderAmount()!=null){ |
| | | paymentAmountTotal = paymentAmountTotal.add(tChargingOrder.getPaymentAmount()); |
| | |
| | | startTime2 = split[1]; |
| | | } |
| | | List<TChargingOrder> total = chargingOrderList.selectList(new LambdaQueryWrapper<>(TChargingOrder.class) |
| | | .eq(TChargingOrder::getRechargePaymentStatus, 2)); |
| | | .eq(TChargingOrder::getRechargePaymentStatus, 2).eq(TChargingOrder::getStatus, 5)); |
| | | PageInfo<ChargingBillListVO> pageInfo = new PageInfo<>(dto.getPageCurr(),dto.getPageSize()); |
| | | List<Site> data6 = siteClient.getSiteAll().getData(); |
| | | List<TChargingGun> gunList = chargingGunClient.getAllGun().getData(); |