From 87b55a899bc1b4bc7d5a0f8d6ad1a1ede233ebd1 Mon Sep 17 00:00:00 2001
From: qixiaoning <jony.kee@outlook.com>
Date: 星期四, 04 九月 2025 17:35:24 +0800
Subject: [PATCH] 系统监控模型进程统计实时监控摄像机名称为空问题修复

---
 camera-common/models/task.go |   21 +++++++++++++++++++++
 1 files changed, 21 insertions(+), 0 deletions(-)

diff --git a/camera-common/models/task.go b/camera-common/models/task.go
index 7c2bfc7..e17a7c7 100644
--- a/camera-common/models/task.go
+++ b/camera-common/models/task.go
@@ -12,6 +12,12 @@
 	TaskName string `db:"task_name" json:"taskName"`
 }
 
+type TaskAggregate struct {
+	ID       int64  `gorm:"column:task_id" json:"id"`
+	Name     string `gorm:"column:task_name"  json:"name"`
+	IsDelete int8   `json:"isDelete"`
+}
+
 type TaskM struct {
 	TaskId          int64  `db:"task_id" json:"taskId"`
 	TaskName        string `db:"task_name" json:"taskName"`
@@ -44,3 +50,18 @@
 	}
 	return
 }
+
+// 鏌ヨ鍒楄〃鏁版嵁
+func GetAllTask() (items []TaskAggregate, err error) {
+	// 涓绘煡璇QL
+	sqlStr := fmt.Sprintf(`
+	    SELECT task_id, task_name
+	    FROM  mal_smart_task
+	    ORDER BY task_id DESC
+	`)
+	if err := db.Raw(sqlStr).Scan(&items).Error; err != nil {
+		fmt.Println(err.Error())
+		return nil, err
+	}
+	return
+}

--
Gitblit v1.8.0