Blame view

app/Repositories/BanRepository.php 2.74 KB
e77200db5   nologostudio.ru   Initial commit
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();
      }
  }