Filter DB Records by Active Tenant

Now, let's filter the records by my current team. For that, we will add tenant_id column to all the DB tables that should be "tenantable". We create a Trait, and this will be a lesson about Traits and Scopes, similar like we had in one earlier lesson.

So, let's generate two migrations to add tenant_id to projects and tasks tables.

php artisan make:migration "add tenant id to projects table"
php artisan make:migration "add tenant id to tasks table"

database/migrations/xxx_add_tenant_id_to_projects_table.php:

Schema::table('projects', function (Blueprint $table) {
    $table->foreignId('tenant_id')->constrained();
});

database/migrations/xxx_add_tenant_id_to_tasks_table.php:

Schema::table('tasks', function (Blueprint $table) {
    $table->foreignId('tenant_id')->constrained();
});

Now, let's create a trait, FilterByTenant.

php artisan make:trait Traits/FilterByTenant

We will use the same booted() method for the creating event and a global scope in the trait.

app/Traits/FilterByTenant.php:

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Builder;
 
trait FilterByTenant
{
    protected static function booted(): void
    {
        $currentTenantId = auth()->user()->tenants()->first()->id;
 
        static::creating(function (Model $model) use ($currentTenantId) {
            $model->tenant_id = $currentTenantId;
        });
 
        static::addGlobalScope(function (Builder $builder) use ($currentTenantId) {
            $builder->where('tenant_id', $currentTenantId);
        });
    }
}

We haven't added the tenant's relationship to the User Model.

app/Models/User.php:

use Illuminate\Database\Eloquent\Relations\BelongsToMany;
 
class User extends Authenticatable
{
    // ...
 
    public function tenants(): BelongsToMany
    {
        return $this->belongsToMany(Tenant::class);
    }
}

We must add this trait to the Project and Task Models.

app/Models/Project.php:

use App\Traits\FilterByTenant;
 
class Project extends Model
{
    use FilterByTenant;
 
    // ...
}

app/Models/Task.php:

use App\Traits\FilterByTenant;
 
class Task extends Model
{
    use FilterByTenant;
 
    // ...
}

Cool, so we're filtering the records by active tenant. Next, what if the user has multiple tenants? How to switch between them?

Create Tenant at Registration Multiple Tenants and Switching Between Them

Course Content

Laravel 11 Multi-Tenancy: All You Need To Know

Filter DB Records by Active Tenant

Course Content

Intro

User Multi-Tenancy

Team Multi-Tenancy - Single DB: No Packages

Team Multi-Tenancy - Single DB: Invitation System

Multi-Tenancy Single DB: Packages Review

Multi-Tenancy Multiple DB: Package Reviews

Multiple DB: Extra Features of archtechx / tenancy