1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
| package models
|
| import (
| "fmt"
| "strings"
| "vamicro/camera-common/models"
| )
|
| // 查询列表数据
| func GetListTask(ids []string) (items []models.Task, err error) {
|
| //idList := strings.Join(ids, ",")
| idList := "'" + strings.Join(ids, "','") + "'"
| // 主查询SQL
| //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 := db2.Raw(sqlStr).Scan(&items).Error; err != nil {
| fmt.Println(err.Error())
| return nil, err
| }
| return
| }
|
| // 获取任务统计
| func GetTasks() (items []models.Task, err error) {
|
| }
|
|
