From 0f97177f258c67397b206b70e5aea2b24a4868c1 Mon Sep 17 00:00:00 2001
From: qixiaoning <jony.kee@outlook.com>
Date: 星期五, 22 八月 2025 09:18:13 +0800
Subject: [PATCH] 移除panic

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

diff --git a/camera-common/models/task.go b/camera-common/models/task.go
index 82a66d6..e17a7c7 100644
--- a/camera-common/models/task.go
+++ b/camera-common/models/task.go
@@ -6,9 +6,23 @@
 )
 
 // 鏅烘煡浠诲姟
+
 type Task struct {
 	TaskId   int64  `db:"task_id" json:"taskId"`
 	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"`
+	TaskDescription string `db:"task_description" json:"taskDescription"`
+	EventName       string `db:"event_name" json:"eventName"`
 }
 
 // 瑙嗛
@@ -36,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