From 9b17a8dcbc1f94eb117a37b3b24ca9dae0d2d588 Mon Sep 17 00:00:00 2001
From: qixiaoning <jony.kee@outlook.com>
Date: 星期三, 29 十月 2025 09:40:54 +0800
Subject: [PATCH] 摄像机相关接口跳转，推送配置修改，系统权限菜单修改
---
camera-common/models/task.go | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 53 insertions(+), 0 deletions(-)
diff --git a/camera-common/models/task.go b/camera-common/models/task.go
index 82a66d6..1a75371 100644
--- a/camera-common/models/task.go
+++ b/camera-common/models/task.go
@@ -6,9 +6,37 @@
)
// 鏅烘煡浠诲姟
+
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 TaskIdM struct {
+ ID int64 `gorm:"column:task_id" json:"id"`
+}
+
+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"`
+}
+
+// 璁粌妯″瀷鏍囩
+type TrainTags struct {
+ Id int64 `gorm:"primaryKey;autoIncrement;column:id" json:"id"`
+ Createtime string `gorm:"type:varchar(50);column:create_time;default:''" json:"create_time"`
+}
+
+func (TrainTags) TableName() string {
+ return "mal_train_tags"
}
// 瑙嗛
@@ -36,3 +64,28 @@
}
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
+}
+
+// 鏍规嵁cid鏌ヨ瑙嗛
+func GetTaskTotal(cid string) (items []TaskIdM, err error) {
+ sqlStr := "select task_id from mal_task_video_link where video_id='" + cid + "'"
+ if err := db.Raw(sqlStr).Scan(&items).Error; err != nil {
+ fmt.Println(err.Error())
+ return nil, err
+ }
+ return
+}
--
Gitblit v1.8.0