From 8ade925dc89805fa8079b2dbb45a0b87975af450 Mon Sep 17 00:00:00 2001
From: Pu Zhibing <393733352@qq.com>
Date: 星期一, 31 三月 2025 09:56:26 +0800
Subject: [PATCH] 修改查询bug

---
 ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/service/impl/TChargingPileServiceImpl.java |   50 ++++++++++++++++++++++++++++++--------------------
 1 files changed, 30 insertions(+), 20 deletions(-)

diff --git a/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/service/impl/TChargingPileServiceImpl.java b/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/service/impl/TChargingPileServiceImpl.java
index 3632b19..8f4155f 100644
--- a/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/service/impl/TChargingPileServiceImpl.java
+++ b/ruoyi-service/ruoyi-chargingPile/src/main/java/com/ruoyi/chargingPile/service/impl/TChargingPileServiceImpl.java
@@ -386,37 +386,47 @@
 
 	@Override
 	public List<TChargingPileVO> getChargingGunList(Integer siteId,Integer type) {
-		List<TChargingPileVO> chargingPileVOS = this.baseMapper.getChargingGunList(siteId);
 		LambdaQueryWrapper<TChargingGun> wrapper = new LambdaQueryWrapper<>();
 		if(Objects.nonNull(type)){
 			wrapper.eq(TChargingGun::getChargeMode, type);
 		}
 		wrapper.eq(TChargingGun::getSiteId, siteId);
 		List<TChargingGun> chargingGuns = chargingGunService.list(wrapper);
-		// 查询充电枪信息
-		chargingPileVOS.forEach(item -> {
-			List<TChargingGun> chargingGunList = chargingGuns.stream().filter(gun -> gun.getChargingPileId().equals(item.getId())).collect(Collectors.toList());
-			for (TChargingGun chargingGun : chargingGunList) {
-				if(chargingGun.getStatus().equals(4)){
-					// 查询正在充电的单子的实时记录
-					TChargingOrder chargingOrder = chargingOrderClient.getOrderDetailByGunId(chargingGun.getId()).getData();
-					if(Objects.nonNull(chargingOrder)){
-						UploadRealTimeMonitoringData uploadRealTimeMonitoringData = uploadRealTimeMonitoringDataClient.chargingOrderInfo(chargingOrder.getCode()).getData();
-						if(null != uploadRealTimeMonitoringData){
-							chargingGun.setSoc(uploadRealTimeMonitoringData.getSoc());
-						}else{
-							chargingGun.setSoc(0);
+		Set<Integer> collect = chargingGuns.stream().map(TChargingGun::getChargingPileId).collect(Collectors.toSet());
+		List<TChargingPileVO> chargingPileVOS = new ArrayList<>();
+		if(collect.size() > 0){
+			List<TChargingPile> tChargingPiles = this.baseMapper.selectBatchIds(collect);
+			for (TChargingPile tChargingPile : tChargingPiles) {
+				TChargingPileVO vo = new TChargingPileVO();
+				List<TChargingGun> chargingGunList = chargingGuns.stream().filter(gun -> gun.getChargingPileId().equals(tChargingPile.getId())).collect(Collectors.toList());
+				for (TChargingGun chargingGun : chargingGunList) {
+					if(chargingGun.getStatus().equals(4)){
+						// 查询正在充电的单子的实时记录
+						TChargingOrder chargingOrder = chargingOrderClient.getOrderDetailByGunId(chargingGun.getId()).getData();
+						if(Objects.nonNull(chargingOrder)){
+							UploadRealTimeMonitoringData uploadRealTimeMonitoringData = uploadRealTimeMonitoringDataClient.chargingOrderInfo(chargingOrder.getCode()).getData();
+							if(null != uploadRealTimeMonitoringData){
+								chargingGun.setSoc(uploadRealTimeMonitoringData.getSoc());
+							}else{
+								chargingGun.setSoc(0);
+							}
+						}else {
+							chargingGun.setSoc(100);
 						}
-					}else {
+					}
+					if(chargingGun.getStatus().equals(5)){
 						chargingGun.setSoc(100);
 					}
 				}
-				if(chargingGun.getStatus().equals(5)){
-					chargingGun.setSoc(100);
-				}
+				vo.setChargingGunList(chargingGunList);
+				vo.setId(tChargingPile.getId());
+				vo.setCode(tChargingPile.getCode());
+				vo.setName(tChargingPile.getName());
+				vo.setNumber(tChargingPile.getNumber());
+				chargingPileVOS.add(vo);
+				
 			}
-			item.setChargingGunList(chargingGunList);
-		});
+		}
 		return chargingPileVOS;
 	}
 	

--
Gitblit v1.7.1