Filament•3y ago•

2 replies

TableWidget with morphTo and groupedBy

I have a Eloquent model

StatisticsClick

StatisticsClick

with the following columns:

- id
- model_type
- model_id
- created_at

I have defined a morphTo relationshop:

public function model(): MorphTo
{
    return $this->morphTo();
}

public function model(): MorphTo
{
    return $this->morphTo();
}

The morphTo goes (for now) only to the

Product

Product

model.

For this, I wanna create a widget to show the most clicked elements, with the name and the counted number of

StatisticsClick

StatisticsClick

entries. Something like this result:

| name | count |
|-----------|-------|
| Product 3 | 44 |
| Product 1 | 32 |
| Product 2 | 18 |

To get this, I would write:

\DB::query()
    ->selectRaw("products.id, products.name, COUNT(*) as count")
    ->from("statistics_clicks")
    ->where("model_type", "Shop")
    ->join("products", "products.id", "=", "statistics_clicks.model_id")
    ->groupBy("products.id")
    ->orderBy("count")

\DB::query()
    ->selectRaw("products.id, products.name, COUNT(*) as count")
    ->from("statistics_clicks")
    ->where("model_type", "Shop")
    ->join("products", "products.id", "=", "statistics_clicks.model_id")
    ->groupBy("products.id")
    ->orderBy("count")

The problem is, that a table widgets

getTableQuery

getTableQuery

only accept

Illuminate\Database\Eloquent\Builder

Illuminate\Database\Eloquent\Builder

as return values and no

Illuminate\Database\Query\Builder

Illuminate\Database\Query\Builder

. This is my starting point:

class ProductExternalClickTableWidget extends TableWidget
{
    protected int | string | array $columnSpan = "full";


    protected function getTableQuery(): Builder
    {
        return StatisticsClick::query()
            ->with("model");
    }

    protected function getTableColumns(): array
    {
        return [
            Tables\Columns\TextColumn::make("model.name")
        ];
    }
}

class ProductExternalClickTableWidget extends TableWidget
{
    protected int | string | array $columnSpan = "full";


    protected function getTableQuery(): Builder
    {
        return StatisticsClick::query()
            ->with("model");
    }

    protected function getTableColumns(): array
    {
        return [
            Tables\Columns\TextColumn::make("model.name")
        ];
    }
}

This shows me the table with a list of all clicks, by the name of the related product. But how to group now after product.id and get the count?

Any ideas?

TableWidget with morphTo and groupedBy

I have a Eloquent model

StatisticsClick

StatisticsClick

with the following columns:

- id
- model_type
- model_id
- created_at

I have defined a morphTo relationshop:

public function model(): MorphTo
{
    return $this->morphTo();
}

public function model(): MorphTo
{
    return $this->morphTo();
}

The morphTo goes (for now) only to the

Product

Product

model.

For this, I wanna create a widget to show the most clicked elements, with the name and the counted number of

StatisticsClick

StatisticsClick

entries. Something like this result:

| name | count |
|-----------|-------|
| Product 3 | 44 |
| Product 1 | 32 |
| Product 2 | 18 |

To get this, I would write:

\DB::query()
    ->selectRaw("products.id, products.name, COUNT(*) as count")
    ->from("statistics_clicks")
    ->where("model_type", "Shop")
    ->join("products", "products.id", "=", "statistics_clicks.model_id")
    ->groupBy("products.id")
    ->orderBy("count")

\DB::query()
    ->selectRaw("products.id, products.name, COUNT(*) as count")
    ->from("statistics_clicks")
    ->where("model_type", "Shop")
    ->join("products", "products.id", "=", "statistics_clicks.model_id")
    ->groupBy("products.id")
    ->orderBy("count")

The problem is, that a table widgets

getTableQuery

getTableQuery

only accept

Illuminate\Database\Eloquent\Builder

Illuminate\Database\Eloquent\Builder

as return values and no

Illuminate\Database\Query\Builder

Illuminate\Database\Query\Builder

. This is my starting point:

class ProductExternalClickTableWidget extends TableWidget
{
    protected int | string | array $columnSpan = "full";


    protected function getTableQuery(): Builder
    {
        return StatisticsClick::query()
            ->with("model");
    }

    protected function getTableColumns(): array
    {
        return [
            Tables\Columns\TextColumn::make("model.name")
        ];
    }
}

class ProductExternalClickTableWidget extends TableWidget
{
    protected int | string | array $columnSpan = "full";


    protected function getTableQuery(): Builder
    {
        return StatisticsClick::query()
            ->with("model");
    }

    protected function getTableColumns(): array
    {
        return [
            Tables\Columns\TextColumn::make("model.name")
        ];
    }
}

This shows me the table with a list of all clicks, by the name of the related product. But how to group now after product.id and get the count?

Any ideas?

TableWidget with morphTo and groupedBy

Similar Threads

TableWidget with morphTo and groupedBy

Similar Threads

Similar Threads

Similar Threads