How to make a colspan for individual column inside ColumnGroup for summary?

[hazwan91]

Package

Panel builder

Package Version

v.3.2^

How can we help you?

i have a headache to make this work. i want to merge all individual columns inside a ColumnGroup for summary.

for example:

my code for the specific column group as such:

ColumnGroup::make($district->district->name, [
                        IconColumn::make('lelaki' . $district->id)
                            ->label('L')
                            ->boolean()
                            ->default(false)
                            ->getStateUsing(function ($record) use ($district) {
                                $sagaRegistrationSport = $district->sagaRegistrationSports->where('saga_sport_id', $record->id)->first();
                                if ($sagaRegistrationSport === null) {
                                    return false;
                                }

                                return $sagaRegistrationSport->lelaki;
                            })
                            ->alignCenter()
                            ->summarize([
                                Summarizer::make('testid')->label('L')->using(
                                    function ($query) use ($district) {
                                        return $district->sagaRegistrationSports->where('lelaki', true)->count();
                                    }
                                ),
                                Summarizer::make()->extraAttributes(['class' => 'last_sum_total'])->label('Jumlah')->using(
                                    function ($query) use ($district) {
                                        $lelaki = $district->sagaRegistrationSports->where('lelaki', true)->count();
                                        $wanita = $district->sagaRegistrationSports->where('wanita', true)->count();
                                        return $lelaki + $wanita;
                                    }
                                ),
                            ]),
                        IconColumn::make('wanita' . $district->id)
                            ->label('W')
                            ->boolean()
                            ->default(false)
                            ->getStateUsing(function ($record) use ($district) {
                                $sagaRegistrationSport = $district->sagaRegistrationSports->where('saga_sport_id', $record->id)->first();
                                if ($sagaRegistrationSport === null) {
                                    return false;
                                }

                                return $sagaRegistrationSport->wanita;
                            })
                            ->alignCenter()
                            ->summarize([
                                Summarizer::make('testid')->label('W')->using(
                                    function ($query) use ($district) {
                                        return $district->sagaRegistrationSports->where('wanita', true)->count();
                                    }
                                ),
                                Summarizer::make()->extraAttributes(['class' => 'last_sum_total col-span-2'])->label('')->using(
                                    function ($query) use ($district) {
                                        return '';
                                    }
                                ),
                            ]),
                    ])->alignCenter();

my table code looks like:

return $table
            ->heading('Senarai Pendaftaran Sukan')
            ->striped()
            ->query(
                SagaSport::query()
                    ->with('saga')
                    // ->join('sports', 'saga_sports.sport_id', '=', 'sports.id')
                    ->with('sport')
                    ->with('sagaRegistrationSports.sagaDistrict.district')
                    ->whereRelation('saga', 'id', '=', $idsaga)
                    ->when($idsaga !== null, function ($query) use ($idsaga) {
                        $query->whereRelation('saga', 'id', $idsaga);
                    })
                // ->orderBy('sports.name')
            )
            ->columns($this->getDynamicColumns($districts));

i also did tried using contentFooter such as:

->contentFooter(view('filament.pages.saga_dashboard_sport_table_footer'));

and the view looks like this:

<tfoot>
    <tr>
        <td>
            skkskd
        </td>
        <td>
            skkskd
        </td>
    </tr>
</tfoot>

i get like this:

i was thinking to just use contentFooter but i face another problem such as styling it like default filament table style and how to bring those $variable itself to the view since i use dynamic columns.

in addition to the contentFooter, i kinda think if produce the query again just for the total in the custom footer, it will become complicated. since all i want is only to merge the columns inside the column group for summary.

please help..

edited:
i think i got it anyway.

my code for the view:

<tfoot>
    <tr>
        <td class="py-2 px-3">
            Jumlah
        </td>
        @foreach ($districts as $district)
        @php
        $total = 0;
        $lelaki = $district->sagaRegistrationSports->where('lelaki', true)->count();
        $wanita = $district->sagaRegistrationSports->where('wanita', true)->count();
        $total = $lelaki + $wanita;
        @endphp
        <td class="text-center py-2 px-3" colspan="2">
            {{ $total }}
        </td>
        @endforeach
    </tr>
</tfoot>

i get what i desire:

but the style is nowhere near filament like padding and etc...is there anyway to use filament default style?

any other alternatives are welcome.