BanRepository.php
2.74 KB
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php
namespace FootyRoom\Repositories;
use Illuminate\Database\Connection;
class BanRepository
{
/**
* @var \Illuminate\Database\Connection
*/
protected $mysql;
/**
* Constructor.
*
* @param \Illuminate\Database\Connection $mysql
*/
public function __construct(Connection $mysql)
{
$this->mysql = $mysql;
}
/**
* Finds active ban by specified parameters.
*
* @param string $entityType
* @param string|int $entityId
* @param string $type
*
* @return object
*/
public function findActive($entityType, $entityId, $type)
{
$data = $this->mysql
->table('bans')
->select('*')
->where('entity_type', '=', $entityType)
->where('entity_id', '=', $entityId)
->where('type', '=', $type)
->whereRaw('DATE_ADD(created_at, INTERVAL `duration` SECOND) > NOW()')
->orderBy('id', 'desc')
->first();
if (!$data) {
return null;
}
$ban = new \StdClass();
$ban->id = $data->id;
$ban->entityType = $data->entity_type;
$ban->entityId = $data->entity_id;
$ban->type = $data->type;
$ban->duration = $data->duration;
$ban->createdAt = $data->created_at;
$ban->createdBy = $data->created_by;
return $ban;
}
/**
* Creates new ban.
*
* @param string $entityType Something like 'user_id' or 'cookieId'
* @param string|int $entityId
* @param string $type
* @param int $duration
* @param int $createdBy
*
* @return bool
*/
public function create($entityType, $entityId, $type, $duration, $createdBy)
{
return $this->mysql
->table('bans')
->insert([
'entity_type' => $entityType,
'entity_id' => $entityId,
'type' => $type,
'duration' => $duration,
'created_at' => $this->mysql->raw('NOW()'),
'created_by' => $createdBy,
]);
}
/**
* Resets ban duration to new value starting from now.
*
* @param int $id
* @param int $duration
*
* @return bool
*/
public function resetDuration($id, $duration)
{
return $this->mysql
->table('bans')
->where('id', '=', $id)
->update([
'duration' => $duration,
'created_at' => $this->mysql->raw('NOW()'),
]);
}
/**
* Deletes ban by id.
*
* @param int $id
*
* @return bool
*/
public static function delete($id)
{
return $this->mysql
->table('bans')
->where('id', '=', $id)
->delete();
}
}