Variable.php
2.58 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
<?php
namespace App\Models;
use App\Models\Pivots\DictionaryCampaign;
use App\Models\Pivots\DictionaryCampaignVariable;
use Illuminate\Database\Eloquent\Builder;
/**
* App\Models\Variable
*
* @property int $id
* @property string $name
* @property string $default_value
* @property \Illuminate\Support\Carbon|null $created_at
* @property \Illuminate\Support\Carbon|null $updated_at
* @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\Campaigns[] $campaigns
* @property-read int|null $campaigns_count
* @property-read \Illuminate\Database\Eloquent\Collection|DictionaryCampaignVariable[] $values
* @property-read int|null $values_count
* @method static Builder|Variable defaultOrderBy()
* @method static Builder|Variable newModelQuery()
* @method static Builder|Variable newQuery()
* @method static Builder|Variable query()
* @method static Builder|Variable whereCreatedAt($value)
* @method static Builder|Variable whereId($value)
* @method static Builder|Variable whereName($value)
* @method static Builder|Variable whereDefaultValue($value)
* @method static Builder|Variable whereUpdatedAt($value)
* @mixin \Eloquent
*/
class Variable extends Model
{
protected $fillable = [
'name',
'default_value',
];
/**
* @param string|integer|DictionaryCampaign
* @param null|Variable[] $variables
*
* @return array
*/
public static function getListVariablesByDictionaryCampaign($dictionary_campaign_id, $variables = null)
{
$variable_list = [
'vars' => [],
'values' => [],
];
if (!$variables) {
$variables = Variable::all();
}
foreach ($variables as $variable) {
$dictionaryCampaignVariable = $variable->findValue($dictionary_campaign_id);
$value = (
$dictionaryCampaignVariable
? $dictionaryCampaignVariable->value
: $variable->default_value
);
$variable_list['vars'][] = $variable->name;
$variable_list['values'][] = $value;
}
return $variable_list;
}
/**
* @param Builder $query
* @return Builder
*/
public function scopeDefaultOrderBy($query)
{
return $query->orderBy('name');
}
public function findValue($dictionary_campaign_id)
{
return $this->values()
->where('dictionary_campaign_id', $dictionary_campaign_id)
->first();
}
public function values()
{
return $this->hasMany(DictionaryCampaignVariable::class, 'variable_id');
}
}