GetKeywords.php

<?php

namespace App\Service\Requests\Direct;

use App\Jobs\ProcessCallLimitedAPI;
use App\Models\AdGroup;
use App\Models\Campaigns;
use App\Models\Keyword;
use App\Models\Pivots\GoalAdGroup;
use App\Models\Pivots\GoalKeyword;
use App\Service\Contract\APIRequest;
use App\Service\Requests\DirectRequest;
use Carbon\Carbon;
use Illuminate\Support\Facades\Log;

class GetKeywords extends DirectRequest
{
    protected $max_count = -1;
    protected $max_count_CampaignIds = 10;
    protected $max_count_AdGroupIds = 1000;
    protected $max_count_Ids = 10000;

    function call($params = null)
    {
        $this->requestPrepare($params);
        $process = new ProcessCallLimitedAPI($this);
        dispatch($process)->onQueue('limits');
    }

    public function getObjectsCount()
    {
        $params = $this->getParams();
        if (isset($params['SelectionCriteria']['CampaignIds'])) {
            return -1;
        }
        if (isset($params['SelectionCriteria']['AdGroupIds'])) {
            return -1;
        }
        if (isset($params['SelectionCriteria']['Ids'])) {
            return count($params['SelectionCriteria']['Ids']);
        }
        return -1;
    }

    public function slice($maxObjects): ?APIRequest
    {
        $params = $this->getParams();

        if (isset($params['SelectionCriteria']['Ids'])) {
            return $this->sliceByKey($maxObjects, ['SelectionCriteria', 'Ids']);
        }

        return null;
    }

    function handle($response)
    {
        try {
            $external_ids = [];

            if (!isset($response['result']['Keywords'])) {
                return;
            }

            foreach ($response['result']['Keywords'] as $keyword) {
                $adGroupId = (string)$keyword['AdGroupId'];

                if (isset($external_ids[$adGroupId])) {
                    continue;
                }
                $external_ids[$adGroupId] = true;
            }

            if (!count($external_ids)) {
                return;
            }

            if ($this->getToken()->isMain()) {
                $ad_groups = AdGroup::whereIn('external_id', array_keys($external_ids))
                    ->get()
                    ->keyBy('external_id');
            } else {
                $ad_groups = GoalAdGroup::whereIn('external_id', array_keys($external_ids))
                    ->get()
                    ->keyBy('external_id');
            }

            $ids = [];
            $campaign_ids_synced_need = [];

            foreach ($response['result']['Keywords'] as $keyword) {

                $ad_group = $ad_groups->get((string)$keyword['AdGroupId']);

                if (!$ad_group) {
                    continue;
                }


                $external_id = (string)$keyword['Id'];

                if ($this->getToken()->isMain()) {

                    $data = [
                        'external_id' => $external_id,
                        'campaign_external_id' => $ad_group->campaign->external_id,
                        'ad_group_external_id' => $ad_group->external_id,
                        'ad_group_id' => $ad_group->getKey(),
                        'campaign_id' => $ad_group->campaign->getKey(),
                        'keyword' => $keyword['Keyword'],
                        'user_param_1' => $keyword['UserParam1'] ?? null,
                        'user_param_2' => $keyword['UserParam2'] ?? null,
                        'bid' => $keyword['Bid'],
                        'context_bid' => $keyword['ContextBid'],
                        'strategy_priority' => $keyword['StrategyPriority'] ?? null,
                        'state' => $keyword['State'],
                        'status' => $keyword['Status'],
                        'serving_status' => $keyword['ServingStatus'],
                    ];

                    $keyword = Keyword::updateOrCreate([
                        'external_id' => $external_id
                    ], $data);

                    if ($keyword->wasRecentlyCreated) {
                        $campaign_ids_synced_need[$keyword->campaign_id] = true;
                    } elseif ($keyword->wasChanged(['campaign_id'])) {
                        $campaign_ids_synced_need[$keyword->campaign_id] = true;
                    } elseif ($keyword->wasChanged($keyword::getPropertiesWatch()->toArray())) {
                        $keyword->goalKeywords()->has('dictionaryCampaign')->forExternal()->update([
                            'updated_need' => Carbon::now(),
                        ]);
                    }

                    $ids[] = $keyword->getKey();

                } else {
                    $goalKeyword = GoalKeyword::firstWhere('external_id', $external_id);

                    if (!$goalKeyword)
                        continue;

                    $ids[] = $goalKeyword->getKey();

                    $data = [
                        'external_updated_at' => Carbon::now(),
                    ];

                    if ($goalKeyword->dictionaryCampaign->updated) {
                        $data['updated_need'] = Carbon::now();
                    }

                    $goalKeyword->update($data);

                }

            }

            if ($this->getToken()->isMain()) {

                if (isset($this->getParams()['SelectionCriteria']['AdGroupIds'])) {
                    AdGroup::whereIn('external_id', $this->getParams()['SelectionCriteria']['AdGroupIds'])
                        ->update([
                            'keywords_loaded_at' => Carbon::now(),
                        ]);
                }

                if (count($campaign_ids_synced_need)) {
                    Campaigns::findMany(array_keys($campaign_ids_synced_need))->each(function (Campaigns $campaign) {
                       $campaign->dictionaryCampaigns()->update([
                           'synced_need' => Carbon::now(),
                       ]);
                    });
                }

                $keywordQuery = Keyword::query();

                if (isset($this->getParams()['SelectionCriteria']['AdGroupIds'])) {
                    $keywordQuery->whereIn('ad_group_external_id', $this->getParams()['SelectionCriteria']['AdGroupIds']);
                } else {
                    $keywordQuery->whereIn('ad_group_id', $ad_groups->pluck('id'));
                }

            } else {
                $keywordQuery = GoalKeyword::query()
                    ->whereIn('goal_ad_group_id', $ad_groups->pluck('id'));
            }

            if (count($ids)) {
                $keywordQuery->whereNotIn('id', $ids);
            }

            $keywordQuery->get()->each(function ($goalKeyword) {
                /* @var $goalKeyword GoalKeyword|Keyword */
                $goalKeyword->delete();
            });

        } catch (\Exception $e) {
            Log::debug($e);
            throw $e;
        }
    }

    private function requestPrepare($filter)
    {
        $this->setService('Keywords');
        $this->setMethod('get');
        $params = [
            "FieldNames" => [
                "Id", "Keyword", "AdGroupId", "CampaignId",
                "UserParam1", "UserParam2", "Bid",
                "ContextBid", "State", "Status", "ServingStatus",
            ],
        ];
        if (isset($filter['CampaignIds'])) {

            $this->max_count = $this->max_count_CampaignIds;

            $params['SelectionCriteria'] = [
                'CampaignIds' => $filter['CampaignIds'],
            ];
        }
        if (isset($filter['AdGroupIds'])) {

            $this->max_count = $this->max_count_AdGroupIds;

            $params['SelectionCriteria'] = [
                'AdGroupIds' => $filter['AdGroupIds'],
            ];
        }
        if (isset($filter['Ids'])) {

            $this->max_count = $this->max_count_Ids;

            $params['SelectionCriteria'] = [
                'Ids' => $filter['Ids'],
            ];
        }
        $this->setParams($params);
    }
}