Filament•2mo ago

How to add a dropdown and access the selected item in base query

I am using seperate schemas in Postgres with tenancyforlaravel. I want a dropdown to select the tenant, then I can view the table/create/edit etc... I want to switch to tenant db connection before query basically. So how to make a dropdown and then access the current tenant in getEloquentQuery. This is working rn:

public static function getEloquentQuery(): Builder
{
    $tenant = Tenant::first();
    tenancy()->initialize($tenant);

    return parent::getEloquentQuery();
}

public static function getEloquentQuery(): Builder
{
    $tenant = Tenant::first();
    tenancy()->initialize($tenant);

    return parent::getEloquentQuery();
}

Solution:

I fixed it. Forgot to give error message and code. I override route function in every page like List etc, just add custom middleware that reads tenant param. ```php public static function route(string $path): PageRegistration...

Jump to solution

11 Replies

Dennis Koch•2mo ago

I want to switch to tenant db connection before query basically.

The query should be based on the current tenant anyway. All you need is a Livewire component – whereever you want to place that – that switches the tenant and reloads the page.

razorOP•2mo ago

The query should be based on the current tenant anyway

Wdym? I am doing this in central admin panel, there is no tenant in that, I am not using the tenant feature of Filament also. How can I place a select dropdown inside a filament resource? And how to reload the page? Thanks in advance.

Dennis Koch•2mo ago

I am doing this in central admin panel, there is no tenant in that,

You didn't mention that part 😅

How can I place a select dropdown inside a filament resource?

I'd build a Livewire component with your select and see whether you can inject it in some proper place with a Render hook. Otherwise you need to overwrite the ListPage blade file.

And how to reload the page?

I think a redirect on a Livewire page should do it. Otherwise try $this->js('window.location.reload()');

razorOP•2mo ago

Component working fine and switches to tenant connection but the table doesn't reload even with the JS code. I switched to a different approch with route parameters. But in index page I get missing route error with custom page. I customized the mount method to accept $tenant but how to fix missing route error?

Dennis Koch•2mo ago

but the table doesn't reload even with the JS code.

That's weird. You are sure the code was actually excuted?

but how to fix missing route error?

You didn't provide any code nor the full error message. I have no idea

razorOP•2mo ago

Yes reload was executed and I see the refresh.

Solution

razor•2mo ago

I fixed it. Forgot to give error message and code. I override route function in every page like List etc, just add custom middleware that reads tenant param.

public static function route(string $path): PageRegistration
    {
        return new PageRegistration(
            page: static::class,
            route: fn(Panel $panel): Route => RouteFacade::get($path, static::class)
                ->middleware(static::getRouteMiddleware($panel))
                ->middleware(InitializeTenancyBySubdomain::class)
                ->withoutMiddleware(static::getWithoutRouteMiddleware($panel)),
        );
    }

public static function route(string $path): PageRegistration
    {
        return new PageRegistration(
            page: static::class,
            route: fn(Panel $panel): Route => RouteFacade::get($path, static::class)
                ->middleware(static::getRouteMiddleware($panel))
                ->middleware(InitializeTenancyBySubdomain::class)
                ->withoutMiddleware(static::getWithoutRouteMiddleware($panel)),
        );
    }

InitializeTenancyBySubdomain.php

<?php

namespace App\Http\Middleware;

use App\Models\Tenant;
use Closure;
use Illuminate\Http\Request;

class InitializeTenancyBySubdomain
{
    public function handle(Request $request, Closure $next): mixed
    {
        $route = $request->route();
        $record = $route->parameter('tenant');

        if ($record && $tenant = Tenant::findOrFail($record)) {
            tenancy()->initialize($tenant);
        }

        return $next($request);
    }
}

<?php

namespace App\Http\Middleware;

use App\Models\Tenant;
use Closure;
use Illuminate\Http\Request;

class InitializeTenancyBySubdomain
{
    public function handle(Request $request, Closure $next): mixed
    {
        $route = $request->route();
        $record = $route->parameter('tenant');

        if ($record && $tenant = Tenant::findOrFail($record)) {
            tenancy()->initialize($tenant);
        }

        return $next($request);
    }
}

Example only for index

public static function getPages(): array
    {
        return [
            'index' => Pages\ListUsers::route('/{tenant?}'),
            'create' => Pages\CreateUser::route('/create'),
            'edit' => Pages\EditUser::route('/{record}/edit'),
        ];
    }

public static function getPages(): array
    {
        return [
            'index' => Pages\ListUsers::route('/{tenant?}'),
            'create' => Pages\CreateUser::route('/create'),
            'edit' => Pages\EditUser::route('/{record}/edit'),
        ];
    }

razorOP•2mo ago

Keep tenant route param as optional because getUrl parameters will be null

razorOP•2mo ago

But now I am facing an issue with Tailwind classes not applied to livewire components

razorOP•2mo ago

<div class="mt-8 bg-red-500">
    <h1>Select tenant ({{ $tenant }}):</h1>
    ...
</div>

<div class="mt-8 bg-red-500">
    <h1>Select tenant ({{ $tenant }}):</h1>
    ...
</div>

Dennis Koch•2mo ago

But now I am facing an issue with Tailwind classes not applied to livewire components

You need a theme. Check the docs.

Gaming

Programming

How to add a dropdown and access the selected item in base query

Did you find this page helpful?