From 724c05408de0cd74cc852e15cd2c8a0fce0be0c9 Mon Sep 17 00:00:00 2001
From: qixiaoning <jony.kee@outlook.com>
Date: 星期五, 19 九月 2025 09:17:08 +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