| 34 | } |
| 35 | |
| 36 | func GetAllUserTask(userId int, startIdx int, num int, queryParams TaskQueryParams) []*Midjourney { |
| 37 | var tasks []*Midjourney |
| 38 | var err error |
| 39 | |
| 40 | // 初始化查询构建器 |
| 41 | query := DB.Where("user_id = ?", userId) |
| 42 | |
| 43 | if queryParams.MjID != "" { |
| 44 | query = query.Where("mj_id = ?", queryParams.MjID) |
| 45 | } |
| 46 | if queryParams.StartTimestamp != "" { |
| 47 | // 假设您已将前端传来的时间戳转换为数据库所需的时间格式，并处理了时间戳的验证和解析 |
| 48 | query = query.Where("submit_time >= ?", queryParams.StartTimestamp) |
| 49 | } |
| 50 | if queryParams.EndTimestamp != "" { |
| 51 | query = query.Where("submit_time <= ?", queryParams.EndTimestamp) |
| 52 | } |
| 53 | |
| 54 | // 获取数据 |
| 55 | err = query.Order("id desc").Limit(num).Offset(startIdx).Find(&tasks).Error |
| 56 | if err != nil { |
| 57 | return nil |
| 58 | } |
| 59 | |
| 60 | return tasks |
| 61 | } |
| 62 | |
| 63 | func GetAllTasks(startIdx int, num int, queryParams TaskQueryParams) []*Midjourney { |
| 64 | var tasks []*Midjourney |