Tokens.php

<?php

namespace App\Models;

use App\Models\Pivots\TokenDictionaryPivot;
use Illuminate\Database\Eloquent\Model;

class Tokens extends Model
{
    CONST MAIN = 'main';
    CONST GOAL = 'goal';

    protected $fillable = ['token', 'login', 'type'];

    public function scopeFilter($query, array $filters)
    {
        $query->when($filters['login'] ?? null, function ($query, $search) {
            $query->where('login', 'like', '%'.$search.'%');
        })->when($filters['type'] ?? null, function ($query, $type) {
            $query->where('type', $type);
        })->when($filters['api'] ?? null, function ($query, $api) {
            $query->where('api', $api);
        });
    }

    public function isMain()
    {
        return $this->type === $this::MAIN;
    }

    public function limits()
    {
        return $this->hasMany(Limits::class, 'token', 'id')->orderBy('updated_at', 'DESC');
    }

    public function campaigns()
    {
        return $this->hasMany(Campaigns::class, 'token', 'id')->orderBy('updated_at', 'DESC');
    }

    public function cities()
    {
        return $this->belongsToMany(Dictionary::class, 'token_dictionaries', 'token_id', 'dictionary_id')
            ->using(TokenDictionaryPivot::class)
            ->withPivot('updated')
            ->withTimestamps()
            ->orderBy('token_dictionaries.created_at', 'desc');
    }

    public function campaignsForManaged()
    {
        return $this->campaigns()->forManaged();
    }

    public function campaignsNotForManaged()
    {
        return $this->campaigns()->notForManaged();
    }
}