From 67d06a785d5fc4524639ace27651c01ff05a4b58 Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期四, 29 五月 2025 22:31:33 +0800
Subject: [PATCH] 修改bug

---
 ruoyi-service/ruoyi-jianguan/src/main/java/com/ruoyi/jianguan/governmentCloud/UploadDataTaskUtil.java |  237 ++++------------------------------------------------------
 1 files changed, 18 insertions(+), 219 deletions(-)

diff --git a/ruoyi-service/ruoyi-jianguan/src/main/java/com/ruoyi/jianguan/governmentCloud/UploadDataTaskUtil.java b/ruoyi-service/ruoyi-jianguan/src/main/java/com/ruoyi/jianguan/governmentCloud/UploadDataTaskUtil.java
index eb706fe..a5f9da3 100644
--- a/ruoyi-service/ruoyi-jianguan/src/main/java/com/ruoyi/jianguan/governmentCloud/UploadDataTaskUtil.java
+++ b/ruoyi-service/ruoyi-jianguan/src/main/java/com/ruoyi/jianguan/governmentCloud/UploadDataTaskUtil.java
@@ -15,8 +15,11 @@
 import org.springframework.scheduling.annotation.Scheduled;
 import org.springframework.stereotype.Component;
 
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
 import java.time.LocalDate;
 import java.time.LocalDateTime;
+import java.util.Date;
 import java.util.List;
 import java.util.concurrent.*;
 
@@ -28,66 +31,15 @@
 public class UploadDataTaskUtil {
 
     @Autowired
-    private AcquisitionBillingModeService acquisitionBillingModeService;
-    @Autowired
-    private BillingModeVerifyService billingModeVerifyService;
-    @Autowired
-    private BmsAbortService bmsAbortService;
-    @Autowired
-    private BmsDemandAndChargerExportationService bmsDemandAndChargerExportationService;
-    @Autowired
-    private OnlineService onlineService;
-    @Autowired
-    private EndChargeService endChargeService;
-    @Autowired
-    private ErrorMessageMessageService errorMessageMessageService;
-    @Autowired
     private UploadRealTimeMonitoringDataService uploadRealTimeMonitoringDataService;
     @Autowired
-    private ChargingHandshakeService chargingHandshakeService;
-    @Autowired
-    private ParameterSettingService parameterSettingService;
-    @Autowired
-    private MotorAbortService motorAbortService;
-    @Autowired
-    private BmsInformationService bmsInformationService;
-    @Autowired
-    private ChargingPileStartsChargingService chargingPileStartsChargingService;
-    @Autowired
-    private PlatformStartChargingReplyService platformStartChargingReplyService;
-    @Autowired
-    private PlatformStopChargingReplyService platformStopChargingReplyService;
-    @Autowired
-    private TransactionRecordService transactionRecordService;
-    @Autowired
-    private UpdateBalanceReplyService updateBalanceReplyService;
-    @Autowired
-    private SynchronizeOfflineCardReplyService synchronizeOfflineCardReplyService;
-    @Autowired
-    private ClearOfflineCardReplyService clearOfflineCardReplyService;
-    @Autowired
-    private WorkingParameterSettingReplyService workingParameterSettingReplyService;
-    @Autowired
-    private TimingSettingService timingSettingService;
-    @Autowired
-    private SetupBillingModelReplyService setupBillingModelReplyService;
-    @Autowired
-    private GroundLockRealTimeDataService groundLockRealTimeDataService;
-    @Autowired
-    private ChargingPileReturnsGroundLockDataService chargingPileReturnsGroundLockDataService;
-    @Autowired
-    private PlatformRestartReplyService platformRestartReplyService;
-    @Autowired
-    private PlatformRemoteUpdateReplyService platformRemoteUpdateReplyService;
-    @Autowired
-    private QrCodeDeliveryReplyService qrCodeDeliveryReplyService;
-    @Autowired
-    private SecurityDetectionService securityDetectionService;
+    private MqttPushUtil mqttPushUtil;
 
     /**
      * 每天的9点执行的任务
      */
     @Scheduled(cron = "0 0 9 * * *")
+//    @Scheduled(fixedRate = 60000)
     public void taskDay(){
         try {
             // 传输mongodb的硬件数据
@@ -129,179 +81,22 @@
 
         try {
             LocalDate localDate = LocalDate.now().minusDays(1);
-            String startTime = localDate + " 00:00:00";
-            String endTime = localDate + " 23:59:59";
+            String start = localDate + " 00:00:00";
+            String end = localDate + " 23:59:59";
+            Date startTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(start);
+            Date endTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(end);
             // 查询所有的mango数据
-            List<AcquisitionBillingMode> acquisitionBillingModeList = acquisitionBillingModeService.getRangeTimeData(startTime, endTime);
-            List<BillingModeVerify> billingModeVerifyList = billingModeVerifyService.getRangeTimeData(startTime, endTime);
-            List<BmsAbort> bmsAbortList = bmsAbortService.getRangeTimeData(startTime, endTime);
-            List<BmsDemandAndChargerExportation> bmsDemandAndChargerExportationList = bmsDemandAndChargerExportationService.getRangeTimeData(startTime, endTime);
-            List<Online> onlineList = onlineService.getRangeTimeData(startTime, endTime);
-            List<EndCharge> endChargeList = endChargeService.getRangeTimeData(startTime, endTime);
-            List<ErrorMessageMessage> errorMessageMessageList = errorMessageMessageService.getRangeTimeData(startTime, endTime);
             List<UploadRealTimeMonitoringData> uploadRealTimeMonitoringDataList = uploadRealTimeMonitoringDataService.getRangeTimeData(startTime, endTime);
-            List<ChargingHandshake> chargingHandshakeList = chargingHandshakeService.getRangeTimeData(startTime, endTime);
-            List<ParameterSetting> parameterSettingList = parameterSettingService.getRangeTimeData(startTime, endTime);
-            List<MotorAbort> motorAbortList = motorAbortService.getRangeTimeData(startTime, endTime);
-            List<BmsInformation> bmsInformationList = bmsInformationService.getRangeTimeData(startTime, endTime);
-            List<ChargingPileStartsCharging> chargingPileStartsChargingList = chargingPileStartsChargingService.getRangeTimeData(startTime, endTime);
-            List<PlatformStartChargingReply> platformStartChargingReplyList = platformStartChargingReplyService.getRangeTimeData(startTime, endTime);
-            List<PlatformStopChargingReply> platformStopChargingReplyList = platformStopChargingReplyService.getRangeTimeData(startTime, endTime);
-            List<TransactionRecord> transactionRecordList = transactionRecordService.getRangeTimeData(startTime, endTime);
-            List<UpdateBalanceReply> updateBalanceReplyList = updateBalanceReplyService.getRangeTimeData(startTime, endTime);
-            List<SynchronizeOfflineCardReply> synchronizeOfflineCardReplyList = synchronizeOfflineCardReplyService.getRangeTimeData(startTime, endTime);
-            List<ClearOfflineCardReply> clearOfflineCardReplyList = clearOfflineCardReplyService.getRangeTimeData(startTime, endTime);
-            List<WorkingParameterSettingReply> workingParameterSettingReplyList = workingParameterSettingReplyService.getRangeTimeData(startTime, endTime);
-            List<TimingSetting> timingSettingList = timingSettingService.getRangeTimeData(startTime, endTime);
-            List<SetupBillingModelReply> setupBillingModelReplyList = setupBillingModelReplyService.getRangeTimeData(startTime, endTime);
-            List<GroundLockRealTimeData> groundLockRealTimeDataList = groundLockRealTimeDataService.getRangeTimeData(startTime, endTime);
-            List<ChargingPileReturnsGroundLockData> chargingPileReturnsGroundLockDataList = chargingPileReturnsGroundLockDataService.getRangeTimeData(startTime, endTime);
-            List<PlatformRestartReply> platformRestartReplyList = platformRestartReplyService.getRangeTimeData(startTime, endTime);
-            List<PlatformRemoteUpdateReply> platformRemoteUpdateReplyList = platformRemoteUpdateReplyService.getRangeTimeData(startTime, endTime);
-            List<QrCodeDeliveryReply> qrCodeDeliveryReplyList = qrCodeDeliveryReplyService.getRangeTimeData(startTime, endTime);
-            List<SecurityDetection> securityDetectionList = securityDetectionService.getRangeTimeData(startTime, endTime);
             customthreadPoolExecutor.execute(() -> {
-//                if (acquisitionBillingModeList != null && acquisitionBillingModeList.size() > 0) {
-//                    for (AcquisitionBillingMode acquisitionBillingMode : acquisitionBillingModeList) {
-//                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", acquisitionBillingMode.getCharging_pile_code()), JSONObject.toJSONString(acquisitionBillingMode));
-//                    }
-//                }
-                if (billingModeVerifyList != null && billingModeVerifyList.size() > 0) {
-                    for (BillingModeVerify billingModeVerify : billingModeVerifyList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", billingModeVerify.getCharging_pile_code()), JSONObject.toJSONString(billingModeVerify));
-                    }
-                }
-                if (bmsAbortList != null && bmsAbortList.size() > 0) {
-                    for (BmsAbort bmsAbort : bmsAbortList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", bmsAbort.getCharging_pile_code()), JSONObject.toJSONString(bmsAbort));
-                    }
-                }
-                if (bmsDemandAndChargerExportationList != null && bmsDemandAndChargerExportationList.size() > 0) {
-                    for (BmsDemandAndChargerExportation bmsDemandAndChargerExportation : bmsDemandAndChargerExportationList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE",  bmsDemandAndChargerExportation.getCharging_pile_code()),  JSONObject.toJSONString(bmsDemandAndChargerExportation));
-                    }
-                }
-                if (onlineList != null && onlineList.size() > 0) {
-                    for (Online online : onlineList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", online.getCharging_pile_code()), JSONObject.toJSONString(online));
-                    }
-                }
-                if (endChargeList != null && endChargeList.size() > 0) {
-                    for (EndCharge endCharge : endChargeList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", endCharge.getCharging_pile_code()), JSONObject.toJSONString(endCharge));
-                    }
-                }
-                if (errorMessageMessageList != null && errorMessageMessageList.size() > 0) {
-                    for (ErrorMessageMessage errorMessageMessage : errorMessageMessageList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", errorMessageMessage.getCharging_pile_code()), JSONObject.toJSONString(errorMessageMessage));
-                    }
-                }
                 if (uploadRealTimeMonitoringDataList != null && uploadRealTimeMonitoringDataList.size() > 0) {
                     for (UploadRealTimeMonitoringData uploadRealTimeMonitoringData : uploadRealTimeMonitoringDataList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", uploadRealTimeMonitoringData.getCharging_pile_code()), JSONObject.toJSONString(uploadRealTimeMonitoringData));
+                        JSONObject jsonObject = new JSONObject();
+                        jsonObject.put("device_code", uploadRealTimeMonitoringData.getCharging_pile_code());
+                        jsonObject.put("report_time", System.currentTimeMillis());
+                        jsonObject.put("properties", uploadRealTimeMonitoringData);
+                        mqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", uploadRealTimeMonitoringData.getCharging_pile_code()), jsonObject.toJSONString());
                     }
                 }
-                if (chargingHandshakeList != null && chargingHandshakeList.size() > 0) {
-                    for (ChargingHandshake chargingHandshake : chargingHandshakeList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", chargingHandshake.getCharging_pile_code()), JSONObject.toJSONString(chargingHandshake));
-                    }
-                }
-                if (parameterSettingList != null && parameterSettingList.size() > 0) {
-                    for (ParameterSetting parameterSetting : parameterSettingList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", parameterSetting.getCharging_pile_code()), JSONObject.toJSONString(parameterSetting));
-                    }
-                }
-                if (motorAbortList != null && motorAbortList.size() > 0) {
-                    for (MotorAbort motorAbort : motorAbortList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", motorAbort.getCharging_pile_code()), JSONObject.toJSONString(motorAbort));
-                    }
-                }
-                if (bmsInformationList != null && bmsInformationList.size() > 0) {
-                    for (BmsInformation bmsInformation : bmsInformationList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", bmsInformation.getCharging_pile_code()), JSONObject.toJSONString(bmsInformation));
-                    }
-                }
-                if (chargingPileStartsChargingList != null && chargingPileStartsChargingList.size() > 0) {
-                    for (ChargingPileStartsCharging chargingPileStartsCharging : chargingPileStartsChargingList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", chargingPileStartsCharging.getCharging_pile_code()),JSONObject.toJSONString(chargingPileStartsCharging));
-                    }
-                }
-                if (platformStartChargingReplyList != null && platformStartChargingReplyList.size() > 0) {
-                    for (PlatformStartChargingReply platformStartChargingReply : platformStartChargingReplyList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", platformStartChargingReply.getCharging_pile_code()), JSONObject.toJSONString(platformStartChargingReply));
-                    }
-                }
-                if (platformStopChargingReplyList != null && platformStopChargingReplyList.size() > 0) {
-                    for (PlatformStopChargingReply platformStopChargingReply : platformStopChargingReplyList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", platformStopChargingReply.getCharging_pile_code()), JSONObject.toJSONString(platformStopChargingReply));
-                    }
-                }
-                if (transactionRecordList != null && transactionRecordList.size() > 0) {
-                    for (TransactionRecord transactionRecord : transactionRecordList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", transactionRecord.getCharging_pile_code()), JSONObject.toJSONString(transactionRecord));
-                    }
-                }
-//                if (updateBalanceReplyList != null && updateBalanceReplyList.size() > 0) {
-//                    for (UpdateBalanceReply updateBalanceReply : updateBalanceReplyList) {
-//                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", updateBalanceReply.getCharging_pile_code()), JSONObject.toJSONString(updateBalanceReply));
-//                    }
-//                }
-//                if (synchronizeOfflineCardReplyList != null && synchronizeOfflineCardReplyList.size() > 0) {
-//                    for (SynchronizeOfflineCardReply synchronizeOfflineCardReply : synchronizeOfflineCardReplyList) {
-//                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", synchronizeOfflineCardReply.getCharging_pile_code()), JSONObject.toJSONString(synchronizeOfflineCardReply));
-//                    }
-//                }
-//                if (clearOfflineCardReplyList != null && clearOfflineCardReplyList.size() > 0) {
-//                    for (ClearOfflineCardReply clearOfflineCardReply : clearOfflineCardReplyList) {
-//                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", clearOfflineCardReply.getCharging_pile_code()), JSONObject.toJSONString(clearOfflineCardReply));
-//                   }
-//                }
-                if (workingParameterSettingReplyList != null && workingParameterSettingReplyList.size() > 0) {
-                    for (WorkingParameterSettingReply workingParameterSettingReply : workingParameterSettingReplyList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", workingParameterSettingReply.getCharging_pile_code()), JSONObject.toJSONString(workingParameterSettingReply));
-                    }
-                }
-                if (timingSettingList != null && timingSettingList.size() > 0) {
-                    for (TimingSetting timingSetting : timingSettingList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", timingSetting.getCharging_pile_code()), JSONObject.toJSONString(timingSetting));
-                    }
-                }
-//                if (setupBillingModelReplyList != null && setupBillingModelReplyList.size() > 0) {
-//                    for (SetupBillingModelReply setupBillingModelReply : setupBillingModelReplyList) {
-//                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", setupBillingModelReply.getCharging_pile_code()), JSONObject.toJSONString(setupBillingModelReply));
-//                    }
-//                }
-                if (groundLockRealTimeDataList != null && groundLockRealTimeDataList.size() > 0) {
-                    for (GroundLockRealTimeData groundLockRealTimeData : groundLockRealTimeDataList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", groundLockRealTimeData.getCharging_pile_code()), JSONObject.toJSONString(groundLockRealTimeData));
-                    }
-                }
-                if (chargingPileReturnsGroundLockDataList != null && chargingPileReturnsGroundLockDataList.size() > 0) {
-                    for (ChargingPileReturnsGroundLockData chargingPileReturnsGroundLockData : chargingPileReturnsGroundLockDataList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", chargingPileReturnsGroundLockData.getCharging_pile_code()), JSONObject.toJSONString(chargingPileReturnsGroundLockData));
-                    }
-                }
-                if (platformRestartReplyList != null && platformRestartReplyList.size() > 0) {
-                    for (PlatformRestartReply platformRestartReply : platformRestartReplyList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", platformRestartReply.getCharging_pile_code()), JSONObject.toJSONString(platformRestartReply));
-                    }
-                }
-                if (platformRemoteUpdateReplyList != null && platformRemoteUpdateReplyList.size() > 0) {
-                    for (PlatformRemoteUpdateReply platformRemoteUpdateReply : platformRemoteUpdateReplyList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", platformRemoteUpdateReply.getCharging_pile_code()), JSONObject.toJSONString(platformRemoteUpdateReply));
-                    }
-                }
-                if (qrCodeDeliveryReplyList != null && qrCodeDeliveryReplyList.size() > 0) {
-                    for (QrCodeDeliveryReply qrCodeDeliveryReply : qrCodeDeliveryReplyList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", qrCodeDeliveryReply.getCharging_pile_code()), JSONObject.toJSONString(qrCodeDeliveryReply));
-                    }
-                }
-                if (securityDetectionList != null && securityDetectionList.size() > 0) {
-                    for (SecurityDetection securityDetection : securityDetectionList) {
-                        MqttPushUtil.pushChargePileData(TopicConstants.CHARGE_PILE_CODE.replace("CHARGE_PILE_CODE", securityDetection.getCharging_pile_code()), JSONObject.toJSONString(securityDetection));
-                    }
-                }
-
             });
 
             TimeUnit.MILLISECONDS.sleep(1);
@@ -342,4 +137,8 @@
         }
     }
 
+    public static void main(String[] args) {
+        System.err.println(System.currentTimeMillis());
+    }
+
 }

--
Gitblit v1.7.1