Ian Tasker Comments - Answer Overflow

Ian Tasker

Posts Comments

FFilament

•Created by Andrew Wallo on 8/5/2023 in #❓┊help

Understanding Multi-Tenant Architecture in Filament V3

On point 3 it looks like it will need a custom page like breezy has for the user profile.

5 replies

FFilament

•Created by Andrew Wallo on 8/5/2023 in #❓┊help

Understanding Multi-Tenant Architecture in Filament V3

1. There is a event for TenantSet which you can listen to to update the field on the user to store which tenant they are one. 2. Afaik Filement will use the tenant returned in getDefaultTenant as the current tenant. 3. I am at this point, so far I found no way to display users for a tenant using a relation manger or other method when using the existing Profile method.

5 replies

FFilament

•Created by qcol on 7/31/2023 in #❓┊help

summarize and custom model attribute

<?php

namespace App\Tables\Components\Columns\Summarizers;

use Exception;
use Filament\Tables\Columns\Summarizers\Summarizer;
use Illuminate\Database\Query\Builder;
use Illuminate\Support\Facades\Schema;

class SumAttribute extends Summarizer
{
    protected function setUp(): void
    {
        parent::setUp();

        $this->numeric();
    }

    /**
     * @return int | float | array<string, array<string, int>> | null
     */
    public function summarize(Builder $query, string $attribute): int | float | array | null
    {
        $column = $this->getColumn();
        $isField = Schema::hasColumn($this->getQuery()->getModel(), $column->getName());

        if ($isField) {
            throw new Exception("The [{$column->getName()}] column must be an Attribute.");
        }
        
        $limit = $this->getQuery()->getQuery()->limit;
        $offset = $this->getQuery()->getQuery()->offset;
        return $this->getQuery()->getModel()->get()->skip($offset)->take($limit)->pluck($attribute)->sum();
    }
}

<?php

namespace App\Tables\Components\Columns\Summarizers;

use Exception;
use Filament\Tables\Columns\Summarizers\Summarizer;
use Illuminate\Database\Query\Builder;
use Illuminate\Support\Facades\Schema;

class SumAttribute extends Summarizer
{
    protected function setUp(): void
    {
        parent::setUp();

        $this->numeric();
    }

    /**
     * @return int | float | array<string, array<string, int>> | null
     */
    public function summarize(Builder $query, string $attribute): int | float | array | null
    {
        $column = $this->getColumn();
        $isField = Schema::hasColumn($this->getQuery()->getModel(), $column->getName());

        if ($isField) {
            throw new Exception("The [{$column->getName()}] column must be an Attribute.");
        }
        
        $limit = $this->getQuery()->getQuery()->limit;
        $offset = $this->getQuery()->getQuery()->offset;
        return $this->getQuery()->getModel()->get()->skip($offset)->take($limit)->pluck($attribute)->sum();
    }
}