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 |   71 ++++++++++++++++++++++++++++++++++-
 1 files changed, 69 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 b88bc35..a5439b5 100644
--- a/src/main/kotlin/com/flightfeather/uav/domain/repository/SatelliteGridRep.kt
+++ b/src/main/kotlin/com/flightfeather/uav/domain/repository/SatelliteGridRep.kt
@@ -9,6 +9,7 @@
 import com.flightfeather.uav.domain.mapper.GridGroupMapper
 import com.flightfeather.uav.lightshare.bean.AreaVo
 import org.springframework.stereotype.Repository
+import org.springframework.transaction.annotation.Transactional
 import tk.mybatis.mapper.entity.Example
 import java.time.LocalDateTime
 
@@ -27,15 +28,46 @@
     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)
         })
     }
+
+    fun fetchGridGroup(id: Int): GridGroup? {
+        return gridGroupMapper.selectByPrimaryKey(id)
+    }
+
+    fun fetchGridGroup(gridGroup: GridGroup): List<GridGroup?> {
+        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 {
@@ -43,6 +75,12 @@
             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 {
@@ -52,7 +90,31 @@
         })
     }
 
-    fun fetchGridDataDetail(dataId: Int, groupId: Int?, cellId: Int?): List<GridDataDetail?> {
+    fun fetchGridData(gridData: GridData): List<GridData?> {
+        return gridDataMapper.select(gridData)
+    }
+
+    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)
@@ -74,6 +136,7 @@
         gridDataDetailMapper.updatePM25Batch(gridDataDetails)
     }
 
+    /*****************************************************************/
 
     //    aod 鐩稿叧鎿嶄綔
     fun fetchGridAod(groupId: Int, dataTime: LocalDateTime?): List<GridAod?> {
@@ -109,7 +172,11 @@
                     .andEqualTo("cellId", it.cellId)
             })
         }
+    }
 
+    @Transactional
+    fun updateGridCellBatch(gridCellList: List<GridCell?>) {
+        gridCellList.forEach { gridCellMapper.updateByPrimaryKey(it) }
     }
 
 }
\ No newline at end of file

--
Gitblit v1.9.3