//Tag model
public function tasks()
    {
        return $this->belongsToMany(Task::class);
    }
//Task Model
public function tags()
    {
        return $this->belongsToMany(Tag::class, 'task_tag', 'task_id', 'tag_id');
    }

//Tag model
public function tasks()
    {
        return $this->belongsToMany(Task::class);
    }
//Task Model
public function tags()
    {
        return $this->belongsToMany(Tag::class, 'task_tag', 'task_id', 'tag_id');
    }

        Schema::create('task_tag', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('task_id');
            $table->unsignedBigInteger('tag_id');

            $table->foreign('task_id')->references('id')->on('tasks')->onDelete('cascade');
            $table->foreign('tag_id')->references('id')->on('tags')->onDelete('cascade');
        });
    }

        Schema::create('task_tag', function (Blueprint $table) {
            $table->id();
            $table->unsignedBigInteger('task_id');
            $table->unsignedBigInteger('tag_id');

            $table->foreign('task_id')->references('id')->on('tasks')->onDelete('cascade');
            $table->foreign('tag_id')->references('id')->on('tags')->onDelete('cascade');
        });
    }

SELECT
  count(*) AS aggregate
FROM
  task_tag
WHERE
  (tag_id IN (2))

SELECT
  count(*) AS aggregate
FROM
  task_tag
WHERE
  (tag_id IN (2))

    public static function table(Table $table): Table
    {

            $tags = Tag::all();

            $tagOptions = [];
            foreach ($tags as $tag) {
                $tagOptions[$tag->id] = $tag->name;
            }
            return $table

    public static function table(Table $table): Table
    {

            $tags = Tag::all();

            $tagOptions = [];
            foreach ($tags as $tag) {
                $tagOptions[$tag->id] = $tag->name;
            }
            return $table

    Tables\Filters\SelectFilter::make('tags')
                    ->multiple()
                    ->options($tagOptions)
                    ->label('Tags')
                    ->placeholder('Filter by Tags'),
                ])

    Tables\Filters\SelectFilter::make('tags')
                    ->multiple()
                    ->options($tagOptions)
                    ->label('Tags')
                    ->placeholder('Filter by Tags'),
                ])

                Tables\Filters\SelectFilter::make('tags')
                ->relationship('task_id', 'tag_id')
                ->multiple()
                ->options($tagOptions)
                ->label('Tags')
                ->placeholder('Filter by Tags')
            ])

                Tables\Filters\SelectFilter::make('tags')
                ->relationship('task_id', 'tag_id')
                ->multiple()
                ->options($tagOptions)
                ->label('Tags')
                ->placeholder('Filter by Tags')
            ])

class User extends Authenticatable implements FilamentUser
{
    use HasApiTokens, HasFactory, Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var array<int, string>
     */
    protected $fillable = [
        'name',
        'email',
        'password',
    ];

    /**
     * The attributes that should be hidden for serialization.
     *
     * @var array<int, string>
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast.
     *
     * @var array<string, string>
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
        'password' => 'hashed',
    ];

    public function canAccessPanel(Panel $panel): bool {
    return str_ends_with($this->email, '@dev.tribes.work') && $this->user_type === 'admin';
    }
}

class User extends Authenticatable implements FilamentUser
{
    use HasApiTokens, HasFactory, Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var array<int, string>
     */
    protected $fillable = [
        'name',
        'email',
        'password',
    ];

    /**
     * The attributes that should be hidden for serialization.
     *
     * @var array<int, string>
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast.
     *
     * @var array<string, string>
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
        'password' => 'hashed',
    ];

    public function canAccessPanel(Panel $panel): bool {
    return str_ends_with($this->email, '@dev.tribes.work') && $this->user_type === 'admin';
    }
}

public function canAccessFilament(): bol{
        return str_ends_with ($this->email , '@tribes.work.com');
    }

public function canAccessFilament(): bol{
        return str_ends_with ($this->email , '@tribes.work.com');
    }

<?php

namespace App\Models;

// use Illuminate\Contracts\Auth\MustVerifyEmail;
use Laravel\Sanctum\HasApiTokens;
use Illuminate\Notifications\Notifiable;
use Filament\Models\Contracts\FilamentUser;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable implements FilamentUser
{
    use HasApiTokens, HasFactory, Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var array<int, string>
     */
    protected $fillable = [
        'name',
        'email',
        'password',
    ];

    /**
     * The attributes that should be hidden for serialization.
     *
     * @var array<int, string>
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast.
     *
     * @var array<string, string>
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
        'password' => 'hashed',
    ];

    public function canAccessFilament(): bol{
        return str_ends_with ($this->email , '@tribes.work.com');
    }
}

<?php

namespace App\Models;

// use Illuminate\Contracts\Auth\MustVerifyEmail;
use Laravel\Sanctum\HasApiTokens;
use Illuminate\Notifications\Notifiable;
use Filament\Models\Contracts\FilamentUser;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable implements FilamentUser
{
    use HasApiTokens, HasFactory, Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var array<int, string>
     */
    protected $fillable = [
        'name',
        'email',
        'password',
    ];

    /**
     * The attributes that should be hidden for serialization.
     *
     * @var array<int, string>
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast.
     *
     * @var array<string, string>
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
        'password' => 'hashed',
    ];

    public function canAccessFilament(): bol{
        return str_ends_with ($this->email , '@tribes.work.com');
    }
}