From e5bdf2e02090357cbd580d54e6cd2406dd541760 Mon Sep 17 00:00:00 2001
From: feiyu02 <risaku@163.com>
Date: 星期五, 21 三月 2025 17:39:30 +0800
Subject: [PATCH] 1. 新增卫星遥测网格热力图计算逻辑（待完成）
---
src/main/kotlin/com/flightfeather/uav/domain/repository/SatelliteGridRep.kt | 54 ++++++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 52 insertions(+), 2 deletions(-)
diff --git a/src/main/kotlin/com/flightfeather/uav/domain/repository/SatelliteGridRep.kt b/src/main/kotlin/com/flightfeather/uav/domain/repository/SatelliteGridRep.kt
index 4c35033..a5439b5 100644
--- a/src/main/kotlin/com/flightfeather/uav/domain/repository/SatelliteGridRep.kt
+++ b/src/main/kotlin/com/flightfeather/uav/domain/repository/SatelliteGridRep.kt
@@ -28,13 +28,14 @@
private val gridAodDetailMapper: GridAodDetailMapper,
) {
- fun fetchGridGroup(areaVo: AreaVo): List<GridGroup?> {
+ fun fetchGridGroup(areaVo: AreaVo, type: String?): List<GridGroup?> {
return gridGroupMapper.selectByExample(Example(GridGroup::class.java).apply {
createCriteria()
.andEqualTo("provinceCode", areaVo.provinceCode).andEqualTo("provinceName", areaVo.provinceName)
.andEqualTo("cityCode", areaVo.cityCode).andEqualTo("cityName", areaVo.cityName)
.andEqualTo("districtCode", areaVo.districtCode).andEqualTo("districtName", areaVo.districtName)
.andEqualTo("townCode", areaVo.townCode).andEqualTo("townName", areaVo.townName)
+ .andEqualTo("type", type)
})
}
@@ -46,12 +47,40 @@
return gridGroupMapper.select(gridGroup)
}
+ fun insertGridGroup(gridGroup: GridGroup): Int {
+ return gridGroupMapper.insert(gridGroup)
+ }
+
+ @Transactional
+ fun deleteGridGroup(groupId: Int) {
+ gridCellMapper.delete(GridCell().apply { this.groupId = groupId })
+ gridCellMapper.selectByExample(
+ Example(GridCell::class.java).apply { orderBy("id").desc() }
+ ).takeIf { it.isNotEmpty() }?.get(0)?.id?.let { id ->
+ gridCellMapper.resetAutoIncrement(id + 1)
+ }
+ gridGroupMapper.deleteByPrimaryKey(groupId)
+ gridGroupMapper.selectByExample(
+ Example(GridGroup::class.java).apply { orderBy("id").desc() }
+ ).takeIf { it.isNotEmpty() }?.get(0)?.id?.let { id ->
+ gridGroupMapper.resetAutoIncrement(id + 1)
+ }
+ }
+
+ /*****************************************************************/
+
fun fetchGridCell(groupId: Int): List<GridCell?> {
return gridCellMapper.selectByExample(Example(GridCell::class.java).apply {
createCriteria().andEqualTo("groupId", groupId)
orderBy("id")
})
}
+
+ fun insertGridCell(gridCellList: List<GridCell?>): Int {
+ return gridCellMapper.insertList(gridCellList)
+ }
+
+ /*****************************************************************/
fun fetchGridData(groupId: Int, dataTime: LocalDateTime?, type: Int?): List<GridData?> {
return gridDataMapper.selectByExample(Example(GridData::class.java).apply {
@@ -65,7 +94,27 @@
return gridDataMapper.select(gridData)
}
- fun fetchGridDataDetail(dataId: Int, groupId: Int?, cellId: Int?): List<GridDataDetail?> {
+ fun fetchGridData(id: Int): GridData? {
+ return gridDataMapper.selectByPrimaryKey(id)
+ }
+
+ fun insertGridData(gridData: GridData): Int {
+ return gridDataMapper.insert(gridData)
+ }
+
+ fun insertGridDataDetail(gridDataDetails: List<GridDataDetail?>): Int {
+ return gridDataDetailMapper.insertList(gridDataDetails)
+ }
+
+ fun updateGridDataDetail(gridDataDetails: List<GridDataDetail?>): Int {
+ var res = 0
+ gridDataDetails.forEach {
+ res += gridDataDetailMapper.updateByPrimaryKey(it)
+ }
+ return res
+ }
+
+ fun fetchGridDataDetail(dataId: Int?, groupId: Int?, cellId: Int?): List<GridDataDetail?> {
return gridDataDetailMapper.selectByExample(Example(GridDataDetail::class.java).apply {
createCriteria().andEqualTo("dataId", dataId)
.andEqualTo("groupId", groupId)
@@ -87,6 +136,7 @@
gridDataDetailMapper.updatePM25Batch(gridDataDetails)
}
+ /*****************************************************************/
// aod 鐩稿叧鎿嶄綔
fun fetchGridAod(groupId: Int, dataTime: LocalDateTime?): List<GridAod?> {
--
Gitblit v1.9.3