| 90 | } |
| 91 | |
| 92 | func TaskGetAllUserTask(userId int, startIdx int, num int, queryParams SyncTaskQueryParams) []*Task { |
| 93 | var tasks []*Task |
| 94 | var err error |
| 95 | |
| 96 | // 初始化查询构建器 |
| 97 | query := DB.Where("user_id = ?", userId) |
| 98 | |
| 99 | if queryParams.TaskID != "" { |
| 100 | query = query.Where("task_id = ?", queryParams.TaskID) |
| 101 | } |
| 102 | if queryParams.Action != "" { |
| 103 | query = query.Where("action = ?", queryParams.Action) |
| 104 | } |
| 105 | if queryParams.Status != "" { |
| 106 | query = query.Where("status = ?", queryParams.Status) |
| 107 | } |
| 108 | if queryParams.Platform != "" { |
| 109 | query = query.Where("platform = ?", queryParams.Platform) |
| 110 | } |
| 111 | if queryParams.StartTimestamp != 0 { |
| 112 | // 假设您已将前端传来的时间戳转换为数据库所需的时间格式，并处理了时间戳的验证和解析 |
| 113 | query = query.Where("submit_time >= ?", queryParams.StartTimestamp) |
| 114 | } |
| 115 | if queryParams.EndTimestamp != 0 { |
| 116 | query = query.Where("submit_time <= ?", queryParams.EndTimestamp) |
| 117 | } |
| 118 | |
| 119 | // 获取数据 |
| 120 | err = query.Omit("channel_id").Order("id desc").Limit(num).Offset(startIdx).Find(&tasks).Error |
| 121 | if err != nil { |
| 122 | return nil |
| 123 | } |
| 124 | |
| 125 | return tasks |
| 126 | } |
| 127 | |
| 128 | func TaskGetAllTasks(startIdx int, num int, queryParams SyncTaskQueryParams) []*Task { |
| 129 | var tasks []*Task |