From 29383149f7040d89ae00ad48dc48bbcf46587946 Mon Sep 17 00:00:00 2001 From: feiyu02 <risaku@163.com> Date: 星期一, 01 九月 2025 17:32:53 +0800 Subject: [PATCH] 2025.9.1 1. 新增走航任务统计功能(待完成) --- src/main/kotlin/com/flightfeather/uav/domain/repository/SegmentInfoRep.kt | 28 ++++++++++++++++++++++++++++ 1 files changed, 28 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..7770930 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,30 @@ fun insert(list: List<SegmentInfo>):Int { return segmentInfoMapper.insertList(list) } + + fun findList(segmentInfo: SegmentInfo): List<SegmentInfo?> { + return segmentInfoMapper.select(segmentInfo) + } + + /** + * 鏌ヨ鏃舵鎵�娑夊強鐨勬墍鏈夎矾娈� + * + */ + fun findPeriod(missionCode:String?, sTime: LocalDateTime?, eTime: LocalDateTime?): List<SegmentInfo?> { + return segmentInfoMapper.selectByExample((Example(SegmentInfo::class.java).apply { +// createCriteria().andEqualTo("missionCode", missionCode) + + 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