antonioribeiro /
tracker
| @@ 67-85 (lines=19) @@ | ||
| 64 | return $this->log()->count(); |
|
| 65 | } |
|
| 66 | ||
| 67 | public function users($minutes, $result) |
|
| 68 | { |
|
| 69 | $query = $this |
|
| 70 | ->select( |
|
| 71 | 'user_id', |
|
| 72 | $this->getConnection()->raw('max(updated_at) as updated_at') |
|
| 73 | ) |
|
| 74 | ->groupBy('user_id') |
|
| 75 | ->from('tracker_sessions') |
|
| 76 | ->period($minutes) |
|
| 77 | ->whereNotNull('user_id') |
|
| 78 | ->orderBy($this->getConnection()->raw('max(updated_at)'), 'desc'); |
|
| 79 | ||
| 80 | if ($result) { |
|
| 81 | return $query->get(); |
|
| 82 | } |
|
| 83 | ||
| 84 | return $query; |
|
| 85 | } |
|
| 86 | ||
| 87 | public function userDevices($minutes, $result, $user_id) |
|
| 88 | { |
|
| @@ 87-105 (lines=19) @@ | ||
| 84 | return $query; |
|
| 85 | } |
|
| 86 | ||
| 87 | public function userDevices($minutes, $result, $user_id) |
|
| 88 | { |
|
| 89 | $query = $this |
|
| 90 | ->select( |
|
| 91 | 'user_id', |
|
| 92 | $this->getConnection()->raw('max(updated_at) as updated_at') |
|
| 93 | ) |
|
| 94 | ->groupBy('user_id') |
|
| 95 | ->from('tracker_sessions') |
|
| 96 | ->period($minutes) |
|
| 97 | ->whereNotNull('user_id') |
|
| 98 | ->orderBy($this->getConnection()->raw('max(updated_at)'), 'desc'); |
|
| 99 | ||
| 100 | if ($result) { |
|
| 101 | return $query->get(); |
|
| 102 | } |
|
| 103 | ||
| 104 | return $query; |
|
| 105 | } |
|
| 106 | } |
|
| 107 | ||
