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