From 8461d90c8ba36e2de2c14569b31ab148a673cb81 Mon Sep 17 00:00:00 2001 From: Pu Zhibing <393733352@qq.com> Date: 星期二, 22 七月 2025 15:01:05 +0800 Subject: [PATCH] 修改bug --- ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TChargingOrderServiceImpl.java | 4 +--- ruoyi-api/ruoyi-api-order/src/main/java/com/ruoyi/order/api/vo/ChargingOrderListVO.java | 7 ++++--- ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/FinancialSettlementController.java | 13 +++++++------ ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TChargingOrderMapper.xml | 7 ++++++- ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/export/TChargingOrderExport.java | 4 ++++ 5 files changed, 22 insertions(+), 13 deletions(-) diff --git a/ruoyi-api/ruoyi-api-order/src/main/java/com/ruoyi/order/api/vo/ChargingOrderListVO.java b/ruoyi-api/ruoyi-api-order/src/main/java/com/ruoyi/order/api/vo/ChargingOrderListVO.java index 2147175..073682b 100644 --- a/ruoyi-api/ruoyi-api-order/src/main/java/com/ruoyi/order/api/vo/ChargingOrderListVO.java +++ b/ruoyi-api/ruoyi-api-order/src/main/java/com/ruoyi/order/api/vo/ChargingOrderListVO.java @@ -14,7 +14,6 @@ public class ChargingOrderListVO { @ApiModelProperty(value = "电站名称") private String siteName; - @ApiModelProperty(value = "订单状态") private Integer status; @ApiModelProperty(value = "充值支付方式(1=微信,2=支付宝)") @@ -49,10 +48,14 @@ private BigDecimal chargingCapacity; @ApiModelProperty(value = "充电电流 度") private BigDecimal electricity; + @ApiModelProperty(value = "充电支付金额") + private BigDecimal rechargeAmount; @ApiModelProperty(value = "充电到账金额") private BigDecimal orderAmount; @ApiModelProperty(value = "会员抵扣金额") private BigDecimal vipDiscountAmount; + @ApiModelProperty(value = "退款金额") + private BigDecimal refundAmount; @ApiModelProperty(value = "车牌号") private String licensePlate; @ApiModelProperty(value = "客户手机号") @@ -67,8 +70,6 @@ private BigDecimal serviceCharge; @ApiModelProperty(value = "平台手续费") private BigDecimal commissionAmount; - @ApiModelProperty(value = "平台手续费") - private BigDecimal rechargeAmount; @ApiModelProperty(value = "引流平台") private String tripartitePlatformName; @ApiModelProperty(value = "平台分佣") diff --git a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/FinancialSettlementController.java b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/FinancialSettlementController.java index d6caee3..1022a54 100644 --- a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/FinancialSettlementController.java +++ b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/controller/FinancialSettlementController.java @@ -27,10 +27,7 @@ import com.ruoyi.order.api.vo.ChargingOrderTimeVO; import com.ruoyi.order.api.vo.SettlementTotalVO; import com.ruoyi.order.export.TChargingOrderExport; -import com.ruoyi.order.service.AccountingStrategyOrderService; -import com.ruoyi.order.service.TChargingOrderAccountingStrategyService; -import com.ruoyi.order.service.TChargingOrderService; -import com.ruoyi.order.service.TSettlementConfirmService; +import com.ruoyi.order.service.*; import com.ruoyi.order.vo.ChargingOrderListInfoVO; import com.ruoyi.other.api.domain.TVip; import com.ruoyi.other.api.feignClient.VipClient; @@ -69,6 +66,9 @@ @Resource private TChargingOrderService chargingOrderService; + @Resource + private TChargingOrderRefundService chargingOrderRefundService; + @Resource private TSettlementConfirmService tSettlementConfirmService; @Resource @@ -121,8 +121,7 @@ List<Partner> data7 = siteClient.getAllPartner().getData(); List<AccountingStrategyOrder> listAll = accountingStrategyOrderService.lambdaQuery() .list(); - List<TChargingOrderAccountingStrategy> stageCostAll = tChargingOrderAccountingStrategyService.list( - ); + List<TChargingOrderAccountingStrategy> stageCostAll = tChargingOrderAccountingStrategyService.list(); List<TVip> data5 = vipClient.getAllVip().getData(); List<TAppUserCar> data8 = appUserCarClient.getAllCar().getData(); for (ChargingOrderListVO chargingOrderListVO : exportList) { @@ -230,6 +229,8 @@ long between = ChronoUnit.SECONDS.between(startTime, endTime); tChargingOrderExport.setCumulativeChargingTime((between*60)+""); } + tChargingOrderExport.setRechargeAmount(chargingOrderListVO.getRechargeAmount().toString()); + tChargingOrderExport.setRefundAmount(chargingOrderListVO.getRefundAmount().toString()); tChargingOrderExport.setStartSoc(chargingOrderListVO.getStartSoc()); tChargingOrderExport.setEndtSoc(chargingOrderListVO.getEndSoc()); tChargingOrderExport.setIsSoc("否"); diff --git a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/export/TChargingOrderExport.java b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/export/TChargingOrderExport.java index 8ea61be..d17aada 100644 --- a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/export/TChargingOrderExport.java +++ b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/export/TChargingOrderExport.java @@ -79,6 +79,10 @@ private String serviceChargePriceLook; @Excel(name = "充电时长(分钟)",width = 30) private String cumulativeChargingTime; + @Excel(name = "充值金额",width = 30) + private String rechargeAmount; + @Excel(name = "退款金额",width = 30) + private String refundAmount; @Excel(name = "充电前面soc",width = 30) private String startSoc; @Excel(name = "充电后soc",width = 30) diff --git a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TChargingOrderServiceImpl.java b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TChargingOrderServiceImpl.java index 83734ad..0b89153 100644 --- a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TChargingOrderServiceImpl.java +++ b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/TChargingOrderServiceImpl.java @@ -1826,9 +1826,7 @@ dto.setSiteIds(siteIds); PageInfo<ChargingOrderListVO> pageInfo = new PageInfo<>(dto.getPageCurr(), dto.getPageSize()); List<ChargingOrderListVO> list = this.baseMapper.chargingList(pageInfo, dto, startTime1, startTime2, endTime1, endTime2); - List<Integer> siteIdsList = list.stream().map(ChargingOrderListVO::getSiteId).collect(Collectors.toList()); - if (siteIdsList.isEmpty()) siteIdsList.add(-1); - List<Site> sites = siteClient.getSiteByIds(siteIdsList).getData(); + List<Site> sites = siteClient.getSiteAll().getData(); for (ChargingOrderListVO chargingOrderListVO : list) { if (roleType == 2) { diff --git a/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TChargingOrderMapper.xml b/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TChargingOrderMapper.xml index bf5ff24..cc163ad 100644 --- a/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TChargingOrderMapper.xml +++ b/ruoyi-service/ruoyi-order/src/main/resources/mapper/order/TChargingOrderMapper.xml @@ -952,7 +952,12 @@ </select> <select id="chargingList" resultType="com.ruoyi.order.api.vo.ChargingOrderListVO"> select t1.*, - t1.current as chargingCapacity,t1.payment_amount as paymentAmount,t1.electricity as chargingCapacity from t_charging_order t1 + t1.current as chargingCapacity, + t1.payment_amount as paymentAmount, + t1.electricity as chargingCapacity, + ifnull(t2.refund_amount, 0) as refundAmount + from t_charging_order t1 + left join t_charging_order_refund t2 on t1.id = t2.charging_order_id where t1.del_flag = 0 and t1.status = 5 and t1.recharge_payment_status = 2 <if test="null != req.code and req.code!=''"> and t1.code LIKE CONCAT('%',#{req.code},'%') -- Gitblit v1.7.1