Campaigns.php

<?php

namespace App\Models;

use App\Models\Pivots\DictionaryCampaignVariable;
use App\Models\Pivots\DictionaryCampaign;
use App\Models\Pivots\GoalAdGroup;
use App\Models\Pivots\GoalKeyword;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Collection;

/**
 * App\Models\Campaigns
 *
 * @property int $id
 * @property int $token
 * @property int $external_id
 * @property string|null $name
 * @property array|null $time_targeting
 * @property array|null $negative_keywords
 * @property array|null $blocked_ips
 * @property array|null $excluded_sites
 * @property array|null $daily_budget
 * @property array|null $bidding_strategy
 * @property array|null $settings
 * @property array|null $counter_ids
 * @property array|null $relevant_keywords
 * @property string|null $attribution_model
 * @property array|null $priority_goals
 * @property string|null $updated_self
 * @property string|null $updated_children
 * @property bool $manage
 * @property bool $enabled
 * @property \Illuminate\Support\Carbon|null $groups_loaded_at
 * @property \Illuminate\Support\Carbon|null $disabled_at
 * @property \Illuminate\Support\Carbon|null $created_at
 * @property \Illuminate\Support\Carbon|null $updated_at
 * @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\Dictionary[] $dictionaries
 * @property-read int|null $dictionaries_count
 * @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\AdGroup[] $groups
 * @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\AdGroup[] $groupsForKeywordsLoadable
 * @property-read int|null $groups_count
 * @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\Variable[] $dictionaryCampaignVariables
 * @property-read int|null $dictionary_campaign_variables_count
 * @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\Variable[] $dictionaryCampaigns
 * @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\Variable[] $dictionaryCampaignSynchronized
 * @property-read \Illuminate\Database\Eloquent\Collection|\App\Models\Variable[] $dictionaryCampaignSynchronizedNeedSynced
 * @property-read int|null $dictionary_campaigns_count
 * @property string|null $keywords_loaded_at
 * @method static Builder|Campaigns whereKeywordsLoadedAt($value)
 * @method static Builder|Campaigns forGroupsLoadable()
 * @method static Builder|Campaigns forNotGroupsLoadable()
 * @method static Builder|Campaigns forManaged($value = true)
 * @method static Builder|Campaigns forEnabled($value = true)
 * @method static Builder|Campaigns notDisabled()
 * @method static Builder|Campaigns disabled()
 * @method static Builder|Campaigns forUpdatedSelf()
 * @method static Builder|Campaigns forUpdatedChildren()
 * @method static Builder|Campaigns newModelQuery()
 * @method static Builder|Campaigns newQuery()
 * @method static Builder|Campaigns query()
 * @method static Builder|Campaigns whereAttributionModel($value)
 * @method static Builder|Campaigns whereBlockedIps($value)
 * @method static Builder|Campaigns whereCounterIds($value)
 * @method static Builder|Campaigns whereCreatedAt($value)
 * @method static Builder|Campaigns whereDailyBudget($value)
 * @method static Builder|Campaigns whereEnabled($value)
 * @method static Builder|Campaigns whereExcludedSites($value)
 * @method static Builder|Campaigns whereExternalId($value)
 * @method static Builder|Campaigns whereGroupsLoadedAt($value)
 * @method static Builder|Campaigns whereId($value)
 * @method static Builder|Campaigns whereManage($value)
 * @method static Builder|Campaigns whereName($value)
 * @method static Builder|Campaigns whereNegativeKeywords($value)
 * @method static Builder|Campaigns wherePriorityGoals($value)
 * @method static Builder|Campaigns whereRelevantKeywordsSettingBudgetPercent($value)
 * @method static Builder|Campaigns whereRelevantKeywordsSettingOptimizeGoalId($value)
 * @method static Builder|Campaigns whereSettings($value)
 * @method static Builder|Campaigns whereTextCampaignStrategyNetwork($value)
 * @method static Builder|Campaigns whereTextCampaignStrategySearch($value)
 * @method static Builder|Campaigns whereTimeTargeting($value)
 * @method static Builder|Campaigns whereToken($value)
 * @method static Builder|Campaigns whereUpdatedSelf($value)
 * @method static Builder|Campaigns whereUpdatedChildren($value)
 * @method static Builder|Campaigns whereBiddingStrategy($value)
 * @method static Builder|Campaigns whereDisabledAt($value)
 * @method static Builder|Campaigns whereRelevantKeywords($value)
 * @method static Builder|Campaigns whereUpdatedAt($value)
 * @mixin \Eloquent
 */
class Campaigns extends Model
{
    use HasFactory;

    protected $fillable = [
        'external_id',
        'token',
        'name',
        'time_targeting',
        'negative_keywords',
        'blocked_ips',
        'excluded_sites',
        'daily_budget',
        'bidding_strategy',
        'settings',
        'counter_ids',
        'relevant_keywords',
        'attribution_model',
        'priority_goals',
        'groups_loaded_at',
        'updated_self',
        'updated_children',
        'manage',
        'enabled',
        'disabled_at',
    ];

    protected $casts = [
        'time_targeting' => 'json',
        'negative_keywords' => 'array',
        'blocked_ips' => 'array',
        'bidding_strategy' => 'json',
        'settings' => 'array',
        'counter_ids' => 'array',
        'relevant_keywords' => 'json',
        'excluded_sites' => 'array',
        'daily_budget' => 'array',
        'priority_goals' => 'array',
        'groups_loaded_at' => 'datetime',
        'updated_self' => 'datetime',
        'updated_children' => 'datetime',
        'manage' => 'boolean',
        'enabled' => 'boolean',
        'disabled_at' => 'datetime',
    ];

    /**
     * @return Collection
     */
    static public function getPropertiesWatch()
    {
        return collect([
            'name',
            'negative_keywords',
            'blocked_ips',
            'excluded_sites',
            'daily_budget',
            'bidding_strategy',
            'settings',
            'counter_ids',
            'relevant_keywords',
            'attribution_model',
            'priority_goals',
        ]);
    }

    /**
     * @return array
     */
    static public function getSettingOptionsAllow()
    {
        return [
            'ADD_METRICA_TAG',
            'ADD_OPENSTAT_TAG',
            'ADD_TO_FAVORITES',
            'ENABLE_AREA_OF_INTEREST_TARGETING',
            'ENABLE_COMPANY_INFO',
            'ENABLE_SITE_MONITORING',
            'EXCLUDE_PAUSED_COMPETING_ADS',
            'MAINTAIN_NETWORK_CPC',
            'REQUIRE_SERVICING',
            'CAMPAIGN_EXACT_PHRASE_MATCHING_ENABLED',
        ];
    }

    public static function boot()
    {
        parent::boot();

        static::created(function (Campaigns $campaign) {
            if ($campaign->manage) {
                $campaign->copyInGoalCampaign();
            }
        });

        static::updated(function (Campaigns $campaign) {

            if ($campaign->manage !== $campaign->getOriginal('manage')) {
                if ($campaign->manage) {
                    $campaign->copyInGoalCampaign();
                } else {
                    $campaign->dictionaryCampaigns()->get()->each(function (DictionaryCampaign $dictionaryCampaign) {
                        $dictionaryCampaign->delete();
                    });
                }
            } elseif ($campaign->manage) {
                $campaign->copyInGoalCampaign();
            }

            if (self::getPropertiesWatch()->first(function ($property_name) use ($campaign) {
                return $campaign->{$property_name} !== $campaign->getOriginal($property_name);
            })) {
                $campaign->dictionaryCampaigns()->forExternal()->update([
                    'updated_need' => Carbon::now(),
                ]);
            }

        });
    }

    public function copyInGoalCampaign()
    {
        $campaign = $this;

        Dictionary::whereNotNull('token_id')->get()->each(function (Dictionary $dictionary) use ($campaign) {

            DictionaryCampaign::updateOrCreateByMain($campaign, $dictionary, true);

        });
    }

    public function copyGroupInGoalGroup()
    {
        $campaign = $this;

        $campaign->dictionaryCampaignSynchronized->each(function (DictionaryCampaign $dictionaryCampaign) use ($campaign) {

            $campaign->groups->each(function (AdGroup $adGroup) use ($dictionaryCampaign) {

                GoalAdGroup::updateOrCreateByMain($adGroup, $dictionaryCampaign);

            });

        });
    }

    public function copyGroupInGoalKeyword()
    {
        $campaign = $this;


        $campaign->dictionaryCampaignSynchronized->each(function (DictionaryCampaign $dictionaryCampaign) use ($campaign) {

            $dictionaryCampaign->groups->each(function (GoalAdGroup $goalAdGroup) use ($campaign, $dictionaryCampaign) {

                $goalAdGroup->group->keywords()->where('campaign_id', $campaign->getKey())->get()->each(function (Keyword $keyword) use ($dictionaryCampaign, $goalAdGroup) {

                    GoalKeyword::updateOrCreateByMain($keyword, $goalAdGroup, $dictionaryCampaign);

                });

            });

        });
    }

    public function getBiddingStrategyAttribute($bidding_strategy)
    {
        $bidding_strategy = json_decode($bidding_strategy, true);

        if (!$bidding_strategy)
            return $bidding_strategy;

        if (!isset($bidding_strategy['Network']['NetworkDefault']) && $bidding_strategy['Network']['BiddingStrategyType'] === 'NETWORK_DEFAULT') {
            $bidding_strategy['Network']['NetworkDefault'] = (object)[];
        } elseif (isset($bidding_strategy['Network']['NetworkDefault']) && is_null($bidding_strategy['Network']['NetworkDefault']['LimitPercent'])) {
            unset($bidding_strategy['Network']['NetworkDefault']);
        }

        if (isset($bidding_strategy['Network']['WbMaximumClicks']) && is_null($bidding_strategy['Network']['WbMaximumClicks']['BidCeiling'])) {
            unset($bidding_strategy['Network']['WbMaximumClicks']['BidCeiling']);
        }

        if (isset($bidding_strategy['Network']['WbMaximumConversionRate']) && is_null($bidding_strategy['Network']['WbMaximumConversionRate']['BidCeiling'])) {
            unset($bidding_strategy['Network']['WbMaximumConversionRate']['BidCeiling']);
        }

        if (isset($bidding_strategy['Network']['AverageCpc']) && is_null($bidding_strategy['Network']['AverageCpc']['BidCeiling'])) {
            unset($bidding_strategy['Network']['AverageCpc']['BidCeiling']);
        }

        if (isset($bidding_strategy['Network']['WeeklyClickPackage']) && is_null($bidding_strategy['Network']['WeeklyClickPackage']['BidCeiling'])) {
            unset($bidding_strategy['Network']['WeeklyClickPackage']['BidCeiling']);
        }

        if (isset($bidding_strategy['Network']['AverageRoi']) && is_null($bidding_strategy['Network']['AverageRoi']['BidCeiling'])) {
            unset($bidding_strategy['Network']['AverageRoi']['BidCeiling']);
        }

        if (isset($bidding_strategy['Network']['PayForConversion']) && is_null($bidding_strategy['Network']['PayForConversion']['WeeklySpendLimit'])) {
            unset($bidding_strategy['Network']['PayForConversion']['WeeklySpendLimit']);
        }

        if (isset($bidding_strategy['Search']['WbMaximumClicks']) && is_null($bidding_strategy['Search']['WbMaximumClicks']['BidCeiling'])) {
            unset($bidding_strategy['Search']['WbMaximumClicks']['BidCeiling']);
        }

        if (isset($bidding_strategy['Search']['WbMaximumConversionRate']) && is_null($bidding_strategy['Search']['WbMaximumConversionRate']['BidCeiling'])) {
            unset($bidding_strategy['Search']['WbMaximumConversionRate']['BidCeiling']);
        }

        if (isset($bidding_strategy['Search']['AverageCpc']) && is_null($bidding_strategy['Search']['AverageCpc']['BidCeiling'])) {
            unset($bidding_strategy['Search']['AverageCpc']['BidCeiling']);
        }

        if (isset($bidding_strategy['Search']['AverageCpa']) && is_null($bidding_strategy['Search']['AverageCpa']['BidCeiling'])) {
            unset($bidding_strategy['Search']['AverageCpa']['BidCeiling']);
        }

        if (isset($bidding_strategy['Search']['AverageCpa']) && is_null($bidding_strategy['Search']['AverageCpa']['WeeklySpendLimit'])) {
            unset($bidding_strategy['Search']['AverageCpa']['WeeklySpendLimit']);
        }

        if (isset($bidding_strategy['Search']['AverageRoi']) && is_null($bidding_strategy['Search']['AverageRoi']['BidCeiling'])) {
            unset($bidding_strategy['Search']['AverageRoi']['BidCeiling']);
        }

        if (isset($bidding_strategy['Search']['AverageRoi']) && is_null($bidding_strategy['Search']['AverageRoi']['WeeklySpendLimit'])) {
            unset($bidding_strategy['Search']['AverageRoi']['WeeklySpendLimit']);
        }

        if (isset($bidding_strategy['Search']['AverageRoi']) && is_null($bidding_strategy['Search']['AverageRoi']['Profitability'])) {
            unset($bidding_strategy['Search']['AverageRoi']['Profitability']);
        }

        if (isset($bidding_strategy['Search']['PayForConversion']) && is_null($bidding_strategy['Search']['PayForConversion']['WeeklySpendLimit'])) {
            unset($bidding_strategy['Search']['PayForConversion']['WeeklySpendLimit']);
        }

        return $bidding_strategy;
    }

    public function groups()
    {
        return $this->hasMany(AdGroup::class, 'campaign_id');
    }

    public function groupsForKeywordsLoadable()
    {
        return $this->groups()->forKeywordsLoadable();
    }

    public function dictionaryCampaigns()
    {
        return $this->hasMany(DictionaryCampaign::class, 'campaign_id');
    }

    public function dictionaryCampaignSynchronized()
    {
        return $this->dictionaryCampaigns()->synchronized();
    }

    public function dictionaryCampaignSynchronizedNeedSynced()
    {
        return $this->dictionaryCampaigns()->synchronized()->needSynced();
    }

    public function dictionaryCampaignVariables()
    {
        return $this->hasManyThrough(DictionaryCampaignVariable::class, DictionaryCampaign::class, 'campaign_id', 'dictionary_campaign_id');
    }

    public function dictionaries()
    {
        return $this->belongsToMany(Dictionary::class, 'dictionary_campaigns', 'campaign_id', 'dictionary_id')
            ->using(DictionaryCampaign::class)
            ->withPivot(DictionaryCampaign::getWithPivot())
            ->withTimestamps();
    }

    /**
     * @param Builder $query
     * @return Builder
     */
    public function scopeForUpdatedSelf($query)
    {
        return $query->whereNotNull('updated_self');
    }

    /**
     * @param Builder $query
     * @return Builder
     */
    public function scopeForUpdatedChildren($query)
    {
        return $query->whereNotNull('updated_children');
    }

    /**
     * @param Builder $query
     * @return Builder
     */
    public function scopeForGroupsLoadable($query)
    {
        return $query->whereNull('groups_loaded_at');
    }

    /**
     * @param Builder $query
     * @return Builder
     */
    public function scopeForNotGroupsLoadable($query)
    {
        return $query->whereNotNull('groups_loaded_at');
    }

    /**
     * @param Builder $query
     * @param bool $manage
     * @return Builder
     */
    public function scopeForManaged($query, $manage = true)
    {
        return $query->where('manage', $manage);
    }

    /**
     * @param Builder $query
     * @param bool $enabled
     * @return Builder
     */
    public function scopeForEnabled($query, $enabled = true)
    {
        return $query->where('enabled', $enabled);
    }

    /**
     * @param Builder $query
     * @return Builder
     */
    public function scopeDisabled($query)
    {
        return $query->whereNotNull('disabled_at');
    }

    /**
     * @param Builder $query
     * @return Builder
     */
    public function scopeNotDisabled($query)
    {
        return $query->whereNull('disabled_at');
    }

}