filament-excel icon indicating copy to clipboard operation
filament-excel copied to clipboard

Include summaries in export

Open bloodykheeng opened this issue 9 months ago • 6 comments

i have a table with summaries at the bottom but i acnt bulk export the table with those summaries Inthat when i click bulk select the row for summaries isnt among the selectable ones Below are some of the columns ive defined with summaries

TextColumn::make('sku') ->summarize(Range::make()->limit(5))

TextColumn::make('group_total') ->label('Total # of Group Members') ->sortable() ->numeric( decimalPlaces: 0, decimalSeparator: '.', thousandsSeparator: ',', ) ->searchable()->toggleable(isToggledHiddenByDefault: false) ->summarize(Sum::make()->numeric()->label("")),

TextColumn::make('female_total') ->label('# of Female members') ->numeric( decimalPlaces: 0, decimalSeparator: '.', thousandsSeparator: ',', ) ->sortable()->searchable()->toggleable(isToggledHiddenByDefault: false) ->summarize(Sum::make()->numeric()->label("")),

TextColumn::make('below_35_total') ->label('Total # of members below 35 years') ->numeric( decimalPlaces: 0, decimalSeparator: '.', thousandsSeparator: ',', ) ->sortable()->searchable()->toggleable(isToggledHiddenByDefault: false) ->summarize(Sum::make()->numeric()->label("")),

            TextColumn::make('on_time_total')
                ->label('# of on-time payments')
                ->numeric(
                    decimalPlaces: 0,
                    decimalSeparator: '.',
                    thousandsSeparator: ',',
                )
                ->sortable()->searchable()->toggleable(isToggledHiddenByDefault: false)
                ->summarize(Sum::make()->numeric()->label("")),

TextColumn::make('surplus_total') ->label('Surplus/Deficit') ->numeric( decimalPlaces: 0, decimalSeparator: '.', thousandsSeparator: ',', ) ->sortable()->searchable()->toggleable(isToggledHiddenByDefault: false) ->summarize(Sum::make()->numeric()->label("")),

            TextColumn::make('opd_total')
                ->label('# Member OPD')
                ->numeric(
                    decimalPlaces: 0,
                    decimalSeparator: '.',
                    thousandsSeparator: ',',
                )
                ->sortable()->searchable()->toggleable(isToggledHiddenByDefault: false)
                ->summarize(Sum::make()->numeric()->label("")),

            TextColumn::make('ipd_total')
                ->label('# Member IPD')
                ->numeric(
                    decimalPlaces: 0,
                    decimalSeparator: '.',
                    thousandsSeparator: ',',
                )
                ->sortable()->searchable()->toggleable(isToggledHiddenByDefault: false)
                ->summarize(Sum::make()->numeric()->label("")),

            TextColumn::make('percent_ontime_total')
                ->label('% paid ontime')
                ->numeric(
                    decimalPlaces: 0,
                    decimalSeparator: '.',
                    thousandsSeparator: ',',
                )
                ->suffix('%')
                ->sortable()->searchable()->toggleable(isToggledHiddenByDefault: false),
            // ->summarize(Average::make()->numeric()->label("")),

            TextColumn::make('f_anc_attendance_total')
                ->label('Total 4th ANC visits')
                ->numeric(
                    decimalPlaces: 0,
                    decimalSeparator: '.',
                    thousandsSeparator: ',',
                )
                ->sortable()->searchable()->toggleable(isToggledHiddenByDefault: false)
                ->summarize(Sum::make()->numeric()->label("")),

            TextColumn::make('f_anc_school_total')
                ->label('# 4th ANC school visits')
                ->numeric(
                    decimalPlaces: 0,
                    decimalSeparator: '.',
                    thousandsSeparator: ',',
                )
                ->sortable()->searchable()->toggleable(isToggledHiddenByDefault: false)
                ->summarize(Sum::make()->numeric()->label("")),

am using fillament v3

Any one to help

bloodykheeng avatar Nov 16 '23 12:11 bloodykheeng

There is just no support for it currently.

pxlrbt avatar Nov 16 '23 13:11 pxlrbt

Any suggestions or ideas on how i can archieve it as i wait for future updates

bloodykheeng avatar Nov 20 '23 11:11 bloodykheeng

Not really, sorry. It's probably easiest to create a custom export via the underlying maatswebiste/laravel-excel package

pxlrbt avatar Nov 20 '23 13:11 pxlrbt

ok thanks lemi hope in future you add that. thaks fir the support though

bloodykheeng avatar Nov 20 '23 15:11 bloodykheeng

Would this be added in any time soon? seems important

zindazed avatar Dec 21 '23 13:12 zindazed

@zindazed I am not using Summaries anywhere in my projects, so I haven't implemented this yet. I am open for a clean PR though.

pxlrbt avatar Dec 21 '23 13:12 pxlrbt