From 9d4ca2e7bdfc0d634b0cc27c7fbe23740f4bb398 Mon Sep 17 00:00:00 2001
From: hcong <1050828145@qq.com>
Date: 星期五, 27 十二月 2024 15:43:30 +0800
Subject: [PATCH] 1. 新增aod数据索引,aod详细数据实体类,mapper,service 2. 新增卫星遥测数据网格数据pm2.5、aod数据导入,模板下载 3. FileExchange.kt 新增转换pm2.5和aod数据方法

---
 src/main/kotlin/com/flightfeather/uav/domain/repository/SegmentInfoRep.kt |   26 ++++++++++++++++++++++++++
 1 files changed, 26 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 e508d45..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
 
 /**
  * 杞ㄨ抗鍒嗛殧鏁版嵁搴撴搷浣�
@@ -15,4 +17,28 @@
     fun insert(list: List<SegmentInfo>):Int {
         return segmentInfoMapper.insertList(list)
     }
+
+    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