KeywordsDelete.php

<?php

namespace App\Console\Commands;

use App\Models\Tokens;
use App\Service\Requests\Direct\DeleteKeywords;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

class KeywordsDelete extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'keywords:delete';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Удаление фраз с целевого аккаунта';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        foreach (Tokens::where('type', '!=', Tokens::MAIN)->get() as $token) {
            $sql = "SELECT gk.external_id
                FROM goal_keywords gk
                INNER JOIN keywords k ON gk.keyword_id=k.id
                INNER JOIN dictionary_campaigns c ON c.id=gk.dictionary_campaign_id
                INNER JOIN dictionaries d ON d.id=c.dictionary_id
                WHERE gk.external_id is not null
                    AND d.token_id=" . $token->id ."
                    AND (
                        (k.deleted_at is not null)
                        OR (
                            EXISTS (
                                SELECT 1 FROM goal_ad_groups as gag
                                INNER JOIN ad_groups as ag on gag.ad_group_id = ag.id
                                    AND gag.deleted_at is null
                                    AND ag.deleted_at is not null
                                WHERE gk.goal_ad_group_id = gag.id
                            )
                        )
                    )
                ";


            $result = DB::select($sql);

            $ids = [];
            foreach ($result as $item) {
                $ids[] = $item->external_id;
            }

            if (!count($ids)) {
                continue;
            }

            $request = new DeleteKeywords();
            $request->setToken($token)
                ->call([
                    'ids' => $ids
                ]);
        }

        return 0;
    }
}