1 | <?php |
||
2 | |||
3 | namespace Itstructure\MFU\Models\Owners; |
||
4 | |||
5 | use Illuminate\Database\Query\Builder as QueryBuilder; |
||
6 | use Illuminate\Database\Eloquent\{Collection, Model, Builder as EloquentBuilder}; |
||
7 | |||
8 | /** |
||
9 | * Class Owner |
||
10 | * @package Itstructure\MFU\Models\Owners |
||
11 | */ |
||
12 | abstract class Owner extends Model |
||
13 | { |
||
14 | /** |
||
15 | * Get model (mediafile/album) primary key name. |
||
16 | * @return string |
||
17 | */ |
||
18 | abstract protected static function getDependencyKeyName(): string; |
||
19 | |||
20 | /** |
||
21 | * Remove: |
||
22 | * 1. Mediafile entry with physical directories and files when album is removed. |
||
23 | * 2. Album entry with related mediafiles and physical directories and files when parent entity (Product, Post, Page e.t.c) is removed. |
||
24 | * @param int $entityId |
||
25 | * @return bool |
||
26 | */ |
||
27 | abstract protected static function removeDependency(int $entityId): bool; |
||
28 | |||
29 | /** |
||
30 | * Add owner to mediafiles table. |
||
31 | * @param int $modelId |
||
32 | * @param int $ownerId |
||
33 | * @param string $ownerName |
||
34 | * @param string $ownerAttribute |
||
35 | * @return bool |
||
36 | */ |
||
37 | public static function addOwner(int $modelId, int $ownerId, string $ownerName, string $ownerAttribute): bool |
||
38 | { |
||
39 | $ownerModel = new static(); |
||
40 | $ownerModel->{static::getDependencyKeyName()} = $modelId; |
||
41 | $ownerModel->owner_id = $ownerId; |
||
0 ignored issues
–
show
|
|||
42 | $ownerModel->owner_name = $ownerName; |
||
0 ignored issues
–
show
|
|||
43 | $ownerModel->owner_attribute = $ownerAttribute; |
||
0 ignored issues
–
show
|
|||
44 | |||
45 | return $ownerModel->save(); |
||
46 | } |
||
47 | |||
48 | /** |
||
49 | * Remove this mediafile/album owner. |
||
50 | * @param int $ownerId |
||
51 | * @param string $ownerName |
||
52 | * @param string|null $ownerAttribute |
||
53 | * @param bool $removeDependencies |
||
54 | * @return bool |
||
55 | */ |
||
56 | public static function removeOwner(int $ownerId, string $ownerName, string $ownerAttribute = null, bool $removeDependencies = false): bool |
||
57 | { |
||
58 | $query = static::query(); |
||
59 | foreach (static::buildFilterOptions($ownerId, $ownerName, $ownerAttribute) as $attribute => $value) { |
||
60 | /* @var QueryBuilder $q */ |
||
61 | $query->where($attribute, '=', $value); |
||
62 | } |
||
63 | $entries = $query->get(); |
||
64 | $thisOwnerEntityIds = $entries->pluck(static::getDependencyKeyName())->toArray(); |
||
65 | $otherOwnerEntityIds = static::filterMultipliedEntityIds($ownerId, $ownerName, $thisOwnerEntityIds) |
||
66 | ->pluck(static::getDependencyKeyName()) |
||
67 | ->toArray(); |
||
68 | $deleted = 0; |
||
69 | foreach ($entries as $entry) { |
||
70 | $entityId = $entry->{static::getDependencyKeyName()}; |
||
71 | $entry->delete(); |
||
72 | if ($removeDependencies && !in_array($entityId, $otherOwnerEntityIds)) { |
||
73 | static::removeDependency($entityId); |
||
74 | } |
||
75 | $deleted++; |
||
76 | } |
||
77 | return $deleted > 0; |
||
78 | } |
||
79 | |||
80 | /** |
||
81 | * @return int |
||
82 | */ |
||
83 | public function getOwnerId(): int |
||
84 | { |
||
85 | return $this->owner_id; |
||
86 | } |
||
87 | |||
88 | /** |
||
89 | * @return string |
||
90 | */ |
||
91 | public function getOwnerName(): string |
||
92 | { |
||
93 | return $this->owner_name; |
||
94 | } |
||
95 | |||
96 | /** |
||
97 | * Getting entity id's which are related with Other owners too. |
||
98 | * @param int $ownerId |
||
99 | * @param string $ownerName |
||
100 | * @param array $entityIds |
||
101 | * @return Collection|static[] |
||
102 | */ |
||
103 | public static function filterMultipliedEntityIds(int $ownerId, string $ownerName, array $entityIds): Collection |
||
104 | { |
||
105 | return static::query()->select(static::getDependencyKeyName()) |
||
106 | ->whereIn(static::getDependencyKeyName(), $entityIds) |
||
107 | ->where(function ($q) use ($ownerId, $ownerName) { |
||
108 | /* @var QueryBuilder $q */ |
||
109 | $q->where('owner_id', '!=', $ownerId) |
||
110 | ->orWhere('owner_name', '!=', $ownerName); |
||
111 | }) |
||
112 | ->get(); |
||
113 | } |
||
114 | |||
115 | /** |
||
116 | * Get Id's by owner. |
||
117 | * @param string $nameId |
||
118 | * @param array $args It can be an array of the next params: owner_name{string}, owner_id{int}, owner_attribute{string}. |
||
119 | * @return EloquentBuilder |
||
120 | */ |
||
121 | protected static function getEntityIdsQuery(string $nameId, array $args): EloquentBuilder |
||
122 | { |
||
123 | return static::query()->select($nameId)->when(count($args) > 0, function($q) use ($args) { |
||
0 ignored issues
–
show
|
|||
124 | foreach ($args as $attribute => $value) { |
||
125 | /* @var QueryBuilder $q */ |
||
126 | $q->where($attribute, $value); |
||
127 | } |
||
128 | }); |
||
129 | } |
||
130 | |||
131 | /** |
||
132 | * Build filter options for some actions. |
||
133 | * @param int $ownerId |
||
134 | * @param string $ownerName |
||
135 | * @param string|null $ownerAttribute |
||
136 | * @return array |
||
137 | */ |
||
138 | protected static function buildFilterOptions(int $ownerId, string $ownerName, string $ownerAttribute = null): array |
||
139 | { |
||
140 | return array_merge([ |
||
141 | 'owner_id' => $ownerId, |
||
142 | 'owner_name' => $ownerName |
||
143 | ], empty($ownerAttribute) ? [] : ['owner_attribute' => $ownerAttribute]); |
||
144 | } |
||
145 | } |
||
146 |
Checks if undeclared accessed properties appear in database migrations and if the creating migration is correct.