From eac932eb827c93e2e998ac1210c3f5e548af0dbf Mon Sep 17 00:00:00 2001
From: qixiaoning <jony.kee@outlook.com>
Date: 星期四, 28 八月 2025 09:10:14 +0800
Subject: [PATCH] 推送回显地址bug,实时监控接口摄像机名称直接取video_point_name,
---
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