TaskCountAllUserTask returns total tasks for given user
(userId int, queryParams SyncTaskQueryParams)
| 340 | |
| 341 | // TaskCountAllUserTask returns total tasks for given user |
| 342 | func TaskCountAllUserTask(userId int, queryParams SyncTaskQueryParams) int64 { |
| 343 | var total int64 |
| 344 | query := DB.Model(&Task{}).Where("user_id = ?", userId) |
| 345 | if queryParams.TaskID != "" { |
| 346 | query = query.Where("task_id = ?", queryParams.TaskID) |
| 347 | } |
| 348 | if queryParams.Action != "" { |
| 349 | query = query.Where("action = ?", queryParams.Action) |
| 350 | } |
| 351 | if queryParams.Status != "" { |
| 352 | query = query.Where("status = ?", queryParams.Status) |
| 353 | } |
| 354 | if queryParams.Platform != "" { |
| 355 | query = query.Where("platform = ?", queryParams.Platform) |
| 356 | } |
| 357 | if queryParams.StartTimestamp != 0 { |
| 358 | query = query.Where("submit_time >= ?", queryParams.StartTimestamp) |
| 359 | } |
| 360 | if queryParams.EndTimestamp != 0 { |
| 361 | query = query.Where("submit_time <= ?", queryParams.EndTimestamp) |
| 362 | } |
| 363 | _ = query.Count(&total).Error |
| 364 | return total |
| 365 | } |