From 550492cb85ea7e01831939f2866259193378f2f7 Mon Sep 17 00:00:00 2001
From: qixiaoning <jony.kee@outlook.com>
Date: 星期二, 22 七月 2025 16:11:36 +0800
Subject: [PATCH] 新增修改实时监控和摄像机配置相关接口
---
camera-common/models/task.go | 37 +++++++++++++++++++++++++++++++++++++
1 files changed, 37 insertions(+), 0 deletions(-)
diff --git a/camera-common/models/task.go b/camera-common/models/task.go
index 2640e7f..82a66d6 100644
--- a/camera-common/models/task.go
+++ b/camera-common/models/task.go
@@ -1 +1,38 @@
package models
+
+import (
+ "fmt"
+ "strings"
+)
+
+// 鏅烘煡浠诲姟
+type Task struct {
+ TaskId int64 `db:"task_id" json:"taskId"`
+ TaskName string `db:"task_name" json:"taskName"`
+}
+
+// 瑙嗛
+type Video struct {
+ VideoIds []string `json:"videoIds"`
+}
+
+// 鏌ヨ鍒楄〃鏁版嵁
+func GetListTask(ids []string) (items []Task, err error) {
+
+ //idList := strings.Join(ids, ",")
+ idList := "'" + strings.Join(ids, "','") + "'"
+ // 涓绘煡璇QL
+ //sqlStr := `select c.task_id, c.task_name from mal_task_video_link a left join mal_smart_task c on a.task_id = c.task_id where a.video_id in(?) ORDER BY a.task_id desc`
+ sqlStr := fmt.Sprintf(`
+ SELECT c.task_id, c.task_name
+ FROM mal_task_video_link a
+ LEFT JOIN mal_smart_task c ON a.task_id = c.task_id
+ WHERE a.video_id IN (%s)
+ ORDER BY a.task_id DESC
+ `, idList)
+ if err := db.Raw(sqlStr).Scan(&items).Error; err != nil {
+ fmt.Println(err.Error())
+ return nil, err
+ }
+ return
+}
--
Gitblit v1.8.0