From 00ec64bdf38a52b979f709de2e82e9994ed17749 Mon Sep 17 00:00:00 2001
From: Riku <risaku@163.com>
Date: 星期日, 07 七月 2024 21:40:17 +0800
Subject: [PATCH] 1. 新增走航报告异常数据所经路段查询功能
---
src/main/kotlin/com/flightfeather/uav/domain/repository/SegmentInfoRep.kt | 22 ++++++++++++++++++++++
1 files changed, 22 insertions(+), 0 deletions(-)
diff --git a/src/main/kotlin/com/flightfeather/uav/domain/repository/SegmentInfoRep.kt b/src/main/kotlin/com/flightfeather/uav/domain/repository/SegmentInfoRep.kt
index b5daa84..de6ef79 100644
--- a/src/main/kotlin/com/flightfeather/uav/domain/repository/SegmentInfoRep.kt
+++ b/src/main/kotlin/com/flightfeather/uav/domain/repository/SegmentInfoRep.kt
@@ -3,6 +3,8 @@
import com.flightfeather.uav.domain.entity.SegmentInfo
import com.flightfeather.uav.domain.mapper.SegmentInfoMapper
import org.springframework.stereotype.Repository
+import tk.mybatis.mapper.entity.Example
+import java.time.LocalDateTime
/**
* 杞ㄨ抗鍒嗛殧鏁版嵁搴撴搷浣�
@@ -19,4 +21,24 @@
fun findList(segmentInfo: SegmentInfo): List<SegmentInfo?> {
return segmentInfoMapper.select(segmentInfo)
}
+
+ /**
+ * 鏌ヨ鏃舵鎵�娑夊強鐨勬墍鏈夎矾娈�
+ *
+ */
+ fun findPeriod(sTime: LocalDateTime?, eTime: LocalDateTime?): List<SegmentInfo?> {
+ return segmentInfoMapper.selectByExample((Example(SegmentInfo::class.java).apply {
+ createCriteria().andLessThanOrEqualTo("startTime", sTime)
+ .andGreaterThanOrEqualTo("endTime", sTime)
+ or(
+ createCriteria().andLessThanOrEqualTo("startTime", eTime)
+ .andGreaterThanOrEqualTo("endTime", eTime)
+ )
+ or(
+ createCriteria().andGreaterThanOrEqualTo("startTime", sTime)
+ .andLessThanOrEqualTo("endTime", eTime)
+ )
+ orderBy("startTime")
+ }))
+ }
}
\ No newline at end of file
--
Gitblit v1.9.3