From 4335937dd6169c56600ddb5157cf87c60e21ff37 Mon Sep 17 00:00:00 2001
From: linwei <872216696@qq.com>
Date: Wed, 08 Apr 2026 16:51:14 +0800
Subject: [PATCH] opt: 人大金仓数据库改造
---
drone-service/drone-fw/src/main/java/org/sxkj/fw/record/service/impl/FwDroneAlarmRecordServiceImpl.java | 26 ++++++++++++++++++++++++++
1 files changed, 26 insertions(+), 0 deletions(-)
diff --git a/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/service/impl/FwDroneAlarmRecordServiceImpl.java b/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/service/impl/FwDroneAlarmRecordServiceImpl.java
index e445978..363d331 100644
--- a/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/service/impl/FwDroneAlarmRecordServiceImpl.java
+++ b/drone-service/drone-fw/src/main/java/org/sxkj/fw/record/service/impl/FwDroneAlarmRecordServiceImpl.java
@@ -18,6 +18,7 @@
import lombok.extern.slf4j.Slf4j;
import org.springblade.core.secure.utils.AuthUtil;
+import org.springblade.core.tool.utils.StringUtil;
import org.sxkj.common.utils.HeaderUtils;
import org.sxkj.fw.cockpit.vo.AlarmStatisticsVO;
import org.sxkj.fw.record.dto.FwDroneAlarmRecordDTO;
@@ -37,6 +38,9 @@
import org.sxkj.system.entity.Dept;
import org.sxkj.system.entity.Region;
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
+import java.util.Date;
import java.util.List;
/**
@@ -52,6 +56,13 @@
@Autowired
private FwDevicePerShareMapper fwDevicePerShareMapper;
+ /**
+ * 查询无人机告警记录分页列表
+ *
+ * @param page 分页对象
+ * @param fwDroneAlarmRecord 无人机告警记录查询参数
+ * @return 分页结果
+ */
@Override
public IPage<FwDroneAlarmRecordVO> selectFwDroneAlarmRecordPage(IPage<FwDroneAlarmRecordVO> page, FwDroneAlarmRecordDTO fwDroneAlarmRecord) {
// 设置当前用户ID
@@ -65,6 +76,21 @@
fwDroneAlarmRecord.setRegionName(byCode.getName());
fwDroneAlarmRecord.setCurrentDeptId(AuthUtil.getDeptId());
fwDroneAlarmRecord.setRegionCode(HeaderUtils.formatAreaCode(byCode.getCode()));
+ // 如果结束时间有值，设置为当天的最后一秒
+ if (StringUtil.isNotBlank(fwDroneAlarmRecord.getEndTime())) {
+ try {
+ // 解析结束时间
+ SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+ Date endDate = sdf.parse(fwDroneAlarmRecord.getEndTime());
+ // 设置时间为当天的23:59:59
+ SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
+ String dateStr = dateFormat.format(endDate);
+ String lastSecondOfDay = dateStr + " 23:59:59";
+ fwDroneAlarmRecord.setEndTime(lastSecondOfDay);
+ } catch (ParseException e) {
+ log.error("解析结束时间失败: {}", e.getMessage());
+ }
+ }
return page.setRecords(baseMapper.selectFwDroneAlarmRecordPage(page, fwDroneAlarmRecord));
}
--
Gitblit v1.9.3