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