| | |
|---|
| | | ) |
|---|
| | | |
|---|
| | | // 查询列表数据 |
|---|
| | | func GetListTask(ids []string) (items []models.Task, err error) { |
|---|
| | | func GetListTask(ids []string) (items []models.TaskM, 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 |
|---|
| | | SELECT c.task_id, c.task_name,c.task_description,b.dict_value as event_name |
|---|
| | | FROM mal_task_video_link a |
|---|
| | | LEFT JOIN mal_smart_task c ON a.task_id = c.task_id |
|---|
| | | LEFT JOIN mal_dict_type b ON b.dict_id = c.event_level |
|---|
| | | WHERE a.video_id IN (%s) |
|---|
| | | ORDER BY a.task_id DESC |
|---|
| | | `, idList) |
|---|
