package models
|
|
import (
|
"fmt"
|
"strings"
|
)
|
|
// 智查任务
|
|
type Task struct {
|
TaskId int64 `db:"task_id" json:"taskId"`
|
TaskName string `db:"task_name" json:"taskName"`
|
}
|
|
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 Video struct {
|
VideoIds []string `json:"videoIds"`
|
}
|
|
// 查询列表数据
|
func GetListTask(ids []string) (items []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 := db.Raw(sqlStr).Scan(&items).Error; err != nil {
|
fmt.Println(err.Error())
|
return nil, err
|
}
|
return
|
}
|
|
// 查询列表数据
|
func GetAllTask() (items []Task, err error) {
|
// 主查询SQL
|
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
|
}
|
