| 61 | } |
| 62 | |
| 63 | func GetAllTasks(startIdx int, num int, queryParams TaskQueryParams) []*Midjourney { |
| 64 | var tasks []*Midjourney |
| 65 | var err error |
| 66 | |
| 67 | // 初始化查询构建器 |
| 68 | query := DB |
| 69 | |
| 70 | // 添加过滤条件 |
| 71 | if queryParams.ChannelID != "" { |
| 72 | query = query.Where("channel_id = ?", queryParams.ChannelID) |
| 73 | } |
| 74 | if queryParams.MjID != "" { |
| 75 | query = query.Where("mj_id = ?", queryParams.MjID) |
| 76 | } |
| 77 | if queryParams.StartTimestamp != "" { |
| 78 | query = query.Where("submit_time >= ?", queryParams.StartTimestamp) |
| 79 | } |
| 80 | if queryParams.EndTimestamp != "" { |
| 81 | query = query.Where("submit_time <= ?", queryParams.EndTimestamp) |
| 82 | } |
| 83 | |
| 84 | // 获取数据 |
| 85 | err = query.Order("id desc").Limit(num).Offset(startIdx).Find(&tasks).Error |
| 86 | if err != nil { |
| 87 | return nil |
| 88 | } |
| 89 | |
| 90 | return tasks |
| 91 | } |
| 92 | |
| 93 | func GetAllUnFinishTasks() []*Midjourney { |
| 94 | var tasks []*Midjourney |