pxlrbt / filament-excel

Excel Export for Filament Admin Resources
MIT License
323 stars 68 forks source link

Include summaries in export #146

Open bloodykheeng opened 8 months ago

bloodykheeng commented 8 months ago

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

pxlrbt commented 8 months ago

There is just no support for it currently.

bloodykheeng commented 8 months ago

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

pxlrbt commented 8 months ago

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

bloodykheeng commented 8 months ago

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

zindazed commented 7 months ago

Would this be added in any time soon? seems important

pxlrbt commented 7 months ago

@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.