1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
namespace Sfneal\Tracking\Queries; |
4
|
|
|
|
5
|
|
|
use Sfneal\Helpers\Time\TimePeriods; |
6
|
|
|
use Sfneal\Queries\Traits\ParamGetter; |
7
|
|
|
use Sfneal\Tracking\Builders\TrackActivityBuilder; |
8
|
|
|
use Sfneal\Tracking\Queries\Base\TrackingQuery; |
9
|
|
|
use Sfneal\Tracking\Utils\ModelAdapter; |
10
|
|
|
|
11
|
|
|
class TrackActivityQuery extends TrackingQuery |
12
|
|
|
{ |
13
|
|
|
use ParamGetter; |
14
|
|
|
|
15
|
|
|
/** |
16
|
|
|
* Retrieve a Query builder. |
17
|
|
|
* |
18
|
|
|
* @return TrackActivityBuilder |
19
|
|
|
*/ |
20
|
|
|
protected function builder(): TrackActivityBuilder |
21
|
|
|
{ |
22
|
|
|
$builder = ModelAdapter::TrackActivity()::query(); |
23
|
|
|
|
24
|
|
|
if (! empty($this->relationships)) { |
25
|
|
|
$builder->with($this->relationships); |
26
|
|
|
} |
27
|
|
|
|
28
|
|
|
return $builder; |
29
|
|
|
} |
30
|
|
|
|
31
|
|
|
/** |
32
|
|
|
* Retrieve a TrackActivity by table query result set. |
33
|
|
|
* |
34
|
|
|
* @return TrackActivityBuilder |
35
|
|
|
*/ |
36
|
|
|
public function execute(): TrackActivityBuilder |
37
|
|
|
{ |
38
|
|
|
$tracking = $this->builder(); |
39
|
|
|
|
40
|
|
|
// Table |
41
|
|
|
if ($type = self::getParam($this->request, $this->parameters, 'type')) { |
42
|
|
|
$tracking->whereTrackableType($type); |
43
|
|
|
} |
44
|
|
|
|
45
|
|
|
// User |
46
|
|
|
if ($user = self::getParam($this->request, $this->parameters, 'user')) { |
47
|
|
|
$tracking->whereUser($user); |
48
|
|
|
} |
49
|
|
|
|
50
|
|
|
// User(s) |
51
|
|
|
if ($users = self::getParam($this->request, $this->parameters, 'users')) { |
52
|
|
|
$tracking->whereUserIn($users); |
53
|
|
|
} |
54
|
|
|
|
55
|
|
|
// Key |
56
|
|
|
if ($trackable_ids = self::getParam($this->request, $this->parameters, 'id')) { |
57
|
|
|
$tracking->whereTrackableId($trackable_ids); |
58
|
|
|
} |
59
|
|
|
|
60
|
|
|
// Time Period |
61
|
|
|
if ($period = self::getParam($this->request, $this->parameters, 'period')) { |
62
|
|
|
if (is_string($period)) { |
63
|
|
|
$period = TimePeriods::timePeriod($period); |
64
|
|
|
} |
65
|
|
|
$tracking->whereBetween('created_at', $period); |
|
|
|
|
66
|
|
|
} |
67
|
|
|
|
68
|
|
|
return $tracking; |
69
|
|
|
} |
70
|
|
|
} |
71
|
|
|
|