Campaigns.php
3.23 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
<?php
namespace App\Models;
use App\Models\Pivots\CampaignVariable;
use App\Models\Pivots\DictionaryCampaign;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
class Campaigns extends Model
{
use HasFactory;
protected $fillable = [
'external_id',
'token',
'name',
'time_targeting',
'negative_keywords',
'blocked_ips',
'excluded_sites',
'daily_budget',
'text_campaign_strategy_search',
'text_campaign_strategy_network',
'settings',
'counter_ids',
'relevant_keywords_setting_budget_percent',
'relevant_keywords_setting_optimize_goal_id',
'attribution_model',
'updated',
'manage',
'enabled',
];
protected $casts = [
'external_id' => 'int',
'manage' => 'boolean',
'enabled' => 'boolean',
'groups_loaded_at' => 'datetime',
];
public static function boot()
{
parent::boot();
static::updated(function(Campaigns $campaign)
{
if ($campaign->manage !== $campaign->getOriginal('manage')) {
if ($campaign->manage) {
Dictionary::whereNotNull('token_id')->each(function (Dictionary $dictionary) use ($campaign) {
$campaign->dictionaries()->syncWithoutDetaching([
$dictionary->getKey() => DictionaryCampaign::copyPropertyInCampaign($campaign),
]);
});
} else {
$campaign->dictionaries()->detach();
//$campaign->variables()->detach();
}
}
});
/*
static::deleting(function(Campaigns $campaign_delete)
{
$campaign_delete->dictionaries()->detach();
$campaign_delete->variables()->detach();
$campaign_delete->groups()->delete();
});
*/
}
public function groups()
{
return $this->hasMany(AdGroup::class, 'campaign_id');
}
public function variables()
{
return $this->belongsToMany(Variable::class, 'campaign_variables', 'campaign_id', 'variable_id')
->using(CampaignVariable::class)
->withPivot(CampaignVariable::getWithPivot())
->withTimestamps();
}
public function dictionaries()
{
return $this->belongsToMany(Dictionary::class, 'dictionary_campaigns', 'campaign_id', 'dictionary_id')
->using(DictionaryCampaign::class)
->withPivot(DictionaryCampaign::getWithPivot())
->withTimestamps();
}
public function scopeForUpdated($query)
{
$query->whereNotNull('updated');
}
public function scopeForGroupsLoadable($query)
{
$query->whereNull('groups_loaded_at');
}
public function scopeForManaged($query)
{
$query->where('manage', true);
}
public function scopeNotForManaged($query)
{
$query->where('manage', false);
}
public function scopeForEnabled($query)
{
$query->where('enabled', true);
}
public function scopeNotForEnabled($query)
{
$query->where('enabled', false);
}
}