1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
<?php
/**
* UserFrosting (http://www.userfrosting.com)
*
* @link https://github.com/userfrosting/UserFrosting
* @license https://github.com/userfrosting/UserFrosting/blob/master/licenses/UserFrosting.md (MIT License)
*/
namespace UserFrosting\Sprinkle\Account\Database\Models;
use Illuminate\Database\Capsule\Manager as Capsule;
use UserFrosting\Sprinkle\Core\Database\Models\Model;
/**
* Activity Class
*
* Represents a single user activity at a specified point in time.
* @author Alex Weissman (https://alexanderweissman.com)
* @property string ip_address
* @property int user_id
* @property string type
* @property datetime occurred_at
* @property string description
*/
class Activity extends Model
{
/**
* @var string The name of the table for the current model.
*/
protected $table = "activities";
protected $fillable = [
"ip_address",
"user_id",
"type",
"occurred_at",
"description"
];
/**
* Joins the activity's user, so we can do things like sort, search, paginate, etc.
*/
public function scopeJoinUser($query)
{
$query = $query->select('activities.*');
$query = $query->leftJoin('users', 'activities.user_id', '=', 'users.id');
return $query;
}
/**
* Add clauses to select the most recent event of each type for each user, to the query.
*
* @return \Illuminate\Database\Query\Builder
*/
public function scopeMostRecentEvents($query)
{
return $query->select('user_id', 'event_type', Capsule::raw('MAX(occurred_at) as occurred_at'))
->groupBy('user_id')
->groupBy('type');
}
/**
* Add clauses to select the most recent event of a given type for each user, to the query.
*
* @param string $type The type of event, matching the `event_type` field in the user_event table.
* @return \Illuminate\Database\Query\Builder
*/
public function scopeMostRecentEventsByType($query, $type)
{
return $query->select('user_id', Capsule::raw('MAX(occurred_at) as occurred_at'))
->where('type', $type)
->groupBy('user_id');
}
/**
* Get the user associated with this activity.
*/
public function user()
{
/** @var UserFrosting\Sprinkle\Core\Util\ClassMapper $classMapper */
$classMapper = static::$ci->classMapper;
return $this->belongsTo($classMapper->getClassMapping('user'), 'user_id');
}
}
|
