1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
namespace App\Models; |
4
|
|
|
|
5
|
|
|
use App\Helpers\Macros\Traits\Languages; |
6
|
|
|
use App\Models\Traits\BelongsToElementset; |
7
|
|
|
use App\Models\Traits\HasStatus; |
8
|
|
|
use Culpa\Traits\Blameable; |
9
|
|
|
use Culpa\Traits\CreatedBy; |
10
|
|
|
use Culpa\Traits\DeletedBy; |
11
|
|
|
use Culpa\Traits\UpdatedBy; |
12
|
|
|
use Illuminate\Database\Eloquent\Model; |
13
|
|
|
use Illuminate\Database\Eloquent\Relations\HasMany; |
14
|
|
|
use Illuminate\Database\Eloquent\SoftDeletes; |
15
|
|
|
use Laracasts\Matryoshka\Cacheable; |
16
|
|
|
|
17
|
|
|
/** |
18
|
|
|
* App\Models\Element |
19
|
|
|
* |
20
|
|
|
* @property int $id |
21
|
|
|
* @property \Carbon\Carbon|null $created_at |
22
|
|
|
* @property \Carbon\Carbon|null $updated_at |
23
|
|
|
* @property \Carbon\Carbon|null $deleted_at |
24
|
|
|
* @property int|null $created_user_id |
25
|
|
|
* @property int|null $updated_user_id |
26
|
|
|
* @property int|null $deleted_user_id |
27
|
|
|
* @property int $schema_id |
28
|
|
|
* @property string|null $name |
29
|
|
|
* @property string|null $label |
30
|
|
|
* @property string|null $definition |
31
|
|
|
* @property string|null $comment |
32
|
|
|
* @property string $type |
33
|
|
|
* @property int|null $is_subproperty_of |
34
|
|
|
* @property string|null $parent_uri |
35
|
|
|
* @property string $uri |
36
|
|
|
* @property int $status_id |
37
|
|
|
* @property string $language |
38
|
|
|
* @property string|null $note |
39
|
|
|
* @property string|null $domain |
40
|
|
|
* @property string|null $orange |
41
|
|
|
* @property int|null $is_deprecated Boolean. Has this class/property been deprecated |
42
|
|
|
* @property string|null $url |
43
|
|
|
* @property string|null $lexical_alias |
44
|
|
|
* @property string|null $hash_id |
45
|
|
|
* @property int|null $created_by |
46
|
|
|
* @property int|null $updated_by |
47
|
|
|
* @property int|null $deleted_by |
48
|
|
|
* @property-read \App\Models\Access\User\User|null $creator |
49
|
|
|
* @property-read \App\Models\Elementset $elementset |
50
|
|
|
* @property-read \App\Models\Access\User\User|null $eraser |
51
|
|
|
* @property mixed $languages |
52
|
|
|
* @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\ElementAttribute[] $statements |
53
|
|
|
* @property-read \App\Models\Status $status |
54
|
|
|
* @property-read \App\Models\Access\User\User|null $updater |
55
|
|
|
* @method static bool|null forceDelete() |
56
|
|
|
* @method static \Illuminate\Database\Query\Builder|\App\Models\Element onlyTrashed() |
57
|
|
|
* @method static bool|null restore() |
58
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereComment($value) |
59
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereCreatedAt($value) |
60
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereCreatedBy($value) |
61
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereCreatedUserId($value) |
62
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereDefinition($value) |
63
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereDeletedAt($value) |
64
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereDeletedBy($value) |
65
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereDeletedUserId($value) |
66
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereDomain($value) |
67
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereHashId($value) |
68
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereId($value) |
69
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereIsDeprecated($value) |
70
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereIsSubpropertyOf($value) |
71
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereLabel($value) |
72
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereLanguage($value) |
73
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereLexicalAlias($value) |
74
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereName($value) |
75
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereNote($value) |
76
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereOrange($value) |
77
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereParentUri($value) |
78
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereSchemaId($value) |
79
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereStatusId($value) |
80
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereType($value) |
81
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereUpdatedAt($value) |
82
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereUpdatedBy($value) |
83
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereUpdatedUserId($value) |
84
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereUri($value) |
85
|
|
|
* @method static \Illuminate\Database\Eloquent\Builder|\App\Models\Element whereUrl($value) |
86
|
|
|
* @method static \Illuminate\Database\Query\Builder|\App\Models\Element withTrashed() |
87
|
|
|
* @method static \Illuminate\Database\Query\Builder|\App\Models\Element withoutTrashed() |
88
|
|
|
* @mixin \Eloquent |
89
|
|
|
*/ |
90
|
|
|
class Element extends Model |
91
|
|
|
{ |
92
|
|
|
const TABLE = 'reg_schema_property'; |
93
|
|
|
const FORM_PROPERTIES = [1, 2, 3, 4, 5, 6, 7, 9, 11, 12, 13, 14, 27]; |
94
|
|
|
protected $table = self::TABLE; |
95
|
|
|
use SoftDeletes, Blameable, CreatedBy, UpdatedBy, DeletedBy; |
96
|
|
|
use Cacheable; |
|
|
|
|
97
|
|
|
use Languages, HasStatus, BelongsToElementset; |
98
|
|
|
protected $blameable = [ |
99
|
|
|
'created' => 'created_user_id', |
100
|
|
|
'updated' => 'updated_user_id', |
101
|
|
|
'deleted' => 'deleted_user_id', |
102
|
|
|
]; |
103
|
|
|
protected $dates = ['deleted_at']; |
104
|
|
|
protected $guarded = ['id']; |
105
|
|
|
|
106
|
|
|
/* |
107
|
|
|
|-------------------------------------------------------------------------- |
108
|
|
|
| FUNCTIONS |
109
|
|
|
|-------------------------------------------------------------------------- |
110
|
|
|
*/ |
111
|
|
|
|
112
|
|
|
/** |
113
|
|
|
* @param int $projectId |
114
|
|
|
* |
115
|
|
|
* @return array |
116
|
|
|
*/ |
117
|
|
|
public static function SelectElementsByProject($projectId) |
118
|
|
|
{ |
119
|
|
|
return \DB::table(ElementAttribute::TABLE) |
120
|
|
|
->join(self::TABLE, |
121
|
|
|
self::TABLE . '.id', |
122
|
|
|
'=', |
123
|
|
|
ElementAttribute::TABLE . '.schema_property_id') |
124
|
|
|
->join(Elementset::TABLE, |
125
|
|
|
Elementset::TABLE . '.id', |
126
|
|
|
'=', |
127
|
|
|
self::TABLE . '.schema_id') |
128
|
|
|
->select(ElementAttribute::TABLE . '.schema_property_id as id', |
129
|
|
|
Elementset::TABLE . '.name as Elementset', |
130
|
|
|
ElementAttribute::TABLE . '.language', |
131
|
|
|
ElementAttribute::TABLE . '.object as label') |
132
|
|
|
->where([ |
133
|
|
|
[ElementAttribute::TABLE . '.profile_property_id', 2], |
134
|
|
|
[Elementset::TABLE . '.agent_id', $projectId], |
135
|
|
|
]) |
136
|
|
|
->orderBy(Elementset::TABLE . '.name') |
137
|
|
|
->orderBy(ElementAttribute::TABLE . '.language') |
138
|
|
|
->orderBy(ElementAttribute::TABLE . '.object') |
139
|
|
|
->get() |
140
|
|
|
->mapWithKeys(function ($item) { |
141
|
|
|
return [ |
142
|
|
|
$item->id . '_' . $item->language => $item->Elementset . |
143
|
|
|
' - (' . |
144
|
|
|
$item->language . |
145
|
|
|
') ' . |
146
|
|
|
$item->label, |
147
|
|
|
]; |
148
|
|
|
}) |
149
|
|
|
->toArray(); |
150
|
|
|
} |
151
|
|
|
|
152
|
|
|
public function updateFromStatements(array $statements = null): self |
153
|
|
|
{ |
154
|
|
|
$language = $this->language; |
155
|
|
|
if (! $statements) { |
156
|
|
|
$s = |
157
|
|
|
collect($this->statements->whereIn('profile_property_id', self::FORM_PROPERTIES)->toArray()); |
158
|
|
|
$statements = $s->filter(function ($item) use ($language) { |
159
|
|
|
return $item['language'] === $language || $item['language'] === ''; |
160
|
|
|
})->keyBy(function ($item) { |
161
|
|
|
return $item['profile_property_id']; |
162
|
|
|
})->map(function ($item) { |
163
|
|
|
return $item['object']; |
164
|
|
|
}); |
165
|
|
|
} |
166
|
|
|
if (isset($statements['1'])) { |
167
|
|
|
$this->name = $statements['1']; |
168
|
|
|
} |
169
|
|
|
if (isset($statements['2'])) { |
170
|
|
|
$this->label = $statements['2']; |
171
|
|
|
} |
172
|
|
|
if (isset($statements['3'])) { |
173
|
|
|
$this->definition = $statements['3']; |
174
|
|
|
} |
175
|
|
|
if (isset($statements['4'])) { |
176
|
|
|
$this->type = $statements['4']; |
177
|
|
|
} |
178
|
|
|
if (isset($statements['5'])) { |
179
|
|
|
$this->comment = $statements['5']; |
180
|
|
|
} |
181
|
|
|
if (strtolower($this->type) === 'property') { |
182
|
|
|
if (isset($statements['6'])) { |
183
|
|
|
$this->parent_uri = $statements['6']; |
184
|
|
|
} |
185
|
|
|
} else { |
186
|
|
|
if (isset($statements['9'])) { |
187
|
|
|
$this->parent_uri = $statements['9']; |
188
|
|
|
} |
189
|
|
|
} |
190
|
|
|
if (isset($statements['7'])) { |
191
|
|
|
$this->note = $statements['7']; |
192
|
|
|
} |
193
|
|
|
if (isset($statements['11'])) { |
194
|
|
|
$this->domain = $statements['11']; |
195
|
|
|
} |
196
|
|
|
if (isset($statements['12'])) { |
197
|
|
|
$this->orange = $statements['12']; |
198
|
|
|
} |
199
|
|
|
if (isset($statements['13'])) { |
200
|
|
|
$this->uri = $statements['13']; |
201
|
|
|
} |
202
|
|
|
if (isset($statements['14'])) { |
203
|
|
|
$this->status_id = |
204
|
|
|
is_numeric($statements['14']) ? $statements['14'] : |
205
|
|
|
Status::getByName($statements['14'])->id; |
206
|
|
|
} |
207
|
|
|
if (isset($statements['27'])) { |
208
|
|
|
$this->lexical_alias = $statements['27']; |
209
|
|
|
} |
210
|
|
|
//$this->url = $statements["45"]; |
211
|
|
|
$this->save(); |
212
|
|
|
|
213
|
|
|
return $this; |
214
|
|
|
} |
215
|
|
|
|
216
|
|
|
/* |
217
|
|
|
|-------------------------------------------------------------------------- |
218
|
|
|
| RELATIONS |
219
|
|
|
|-------------------------------------------------------------------------- |
220
|
|
|
*/ |
221
|
|
|
|
222
|
|
|
public function statements(): ?HasMany |
223
|
|
|
{ |
224
|
|
|
return $this->hasMany(ElementAttribute::class, 'schema_property_id', 'id'); |
225
|
|
|
} |
226
|
|
|
|
227
|
|
|
/* |
228
|
|
|
|-------------------------------------------------------------------------- |
229
|
|
|
| SCOPES |
230
|
|
|
|-------------------------------------------------------------------------- |
231
|
|
|
*/ |
232
|
|
|
|
233
|
|
|
/* |
234
|
|
|
|-------------------------------------------------------------------------- |
235
|
|
|
| ACCESSORS |
236
|
|
|
|-------------------------------------------------------------------------- |
237
|
|
|
*/ |
238
|
|
|
|
239
|
|
|
/* |
240
|
|
|
|-------------------------------------------------------------------------- |
241
|
|
|
| MUTATORS |
242
|
|
|
|-------------------------------------------------------------------------- |
243
|
|
|
*/ |
244
|
|
|
} |
245
|
|
|
|