From fd31206bcb8b084720291a53c986db771d8f5975 Mon Sep 17 00:00:00 2001
From: qixiaoning <jony.kee@outlook.com>
Date: 星期四, 18 九月 2025 13:58:16 +0800
Subject: [PATCH] 抓拍预警记录查询修改，备份还原接口问题修复，应用安装接口调试
---
camera-common/models/task.go | 18 +++++++++++++++++-
1 files changed, 17 insertions(+), 1 deletions(-)
diff --git a/camera-common/models/task.go b/camera-common/models/task.go
index 125a838..5d8d915 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"`
@@ -46,7 +52,7 @@
}
// 鏌ヨ鍒楄〃鏁版嵁
-func GetAllTask() (items []Task, err error) {
+func GetAllTask() (items []TaskAggregate, err error) {
// 涓绘煡璇QL
sqlStr := fmt.Sprintf(`
SELECT task_id, task_name
@@ -59,3 +65,13 @@
}
return
}
+
+// 鏍规嵁cid鏌ヨ瑙嗛
+func GetTaskTotal(cid string) (total int, err error) {
+ sql := "select count(1) as total from mal_task_video_link where video_id='" + cid + "'"
+ err = db.Raw(sql).Count(&total).Error
+ if err != nil {
+ return 0, err
+ }
+ return total, nil
+}
--
Gitblit v1.8.0