pxlrbt/filament-excel
2
0
Fork 0
Code Issues 3 Pull requests Projects Releases 65 Packages Activity

Include summaries in export #146

New issue
Closed
opened 2023-11-16 12:57:47 +00:00 by bloodykheeng · 7 comments
bloodykheeng commented 2023-11-16 12:57:47 +00:00 (Migrated from github.com)
Copy link

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

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
👍 1
pxlrbt commented 2023-11-16 13:35:01 +00:00 (Migrated from github.com)
Copy link

There is just no support for it currently.

There is just no support for it currently.
bloodykheeng commented 2023-11-20 11:31:26 +00:00 (Migrated from github.com)
Copy link

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

Any suggestions or ideas on how i can archieve it as i wait for future updates
pxlrbt commented 2023-11-20 13:16:20 +00:00 (Migrated from github.com)
Copy link

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

Not really, sorry. It's probably easiest to create a custom export via the underlying `maatswebiste/laravel-excel` package
bloodykheeng commented 2023-11-20 15:46:43 +00:00 (Migrated from github.com)
Copy link

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

ok thanks lemi hope in future you add that. thaks fir the support though
zindazed commented 2023-12-21 13:15:25 +00:00 (Migrated from github.com)
Copy link

Would this be added in any time soon? seems important

Would this be added in any time soon? seems important
pxlrbt commented 2023-12-21 13:16:37 +00:00 (Migrated from github.com)
Copy link

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

@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.
thetahayasin commented 2025-04-04 18:38:18 +00:00 (Migrated from github.com)
Copy link

facing same issue summaries not in export no workaround found

facing same issue summaries not in export no workaround found
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
tests/recent-fixes
fix/date-format-closures
fix/multi-server-queue
fix/require-filament-tables-only
fix/prune-directory-type-error
feature/laravel-excel-v4
fix/notification-type-error
feat/non-table-pages
feat/csv-settings
feat/better-extension-support
feat/queue-name
fix/cache-check
feat/user-on-queue
fix/numeric-money-date-modifiers
fix/false-values-empty
fix/reset-column-action
fix/ci
feat/relationships
2.x
Mahi-Mahi/main
db-locale
1.x
fix/signed-middleware-bug
fix/signed-middleware
feature/database-notification
feature/fix-table-action
feature/rtl
feature/use-table-query
fix/param-evaluation
fix/missing-table-record
feature/fix-export-form
feature/ignore-formatting
fix/v3-queue
filament-v3
feat/combine-common-configs
fix/docs-chunk-size
better-query-integration
better-column-attributes-inference
fix/fix-tables
refactor/exportables
v4.1.0
v4.0.0
v3.6.1
v3.6.0
v3.5.0
v3.4.1
v3.4.0
v3.3.0
v3.2.1
v3.2.0
v3.1.1
v3.1.0
v2.5.0
v3.0.0
v2.4.3
v2.4.2
v2.4.1
v2.4.0
v2.3.6
v2.3.5
v1.1.15
v1.1.14
v2.3.4
v2.3.3
v2.3.2
v2.3.1
v2.3.0
v2.2.3
v2.2.2
v2.2.1
v2.2.0
v2.1.8
v2.1.7
v2.1.6
v2.1.5
v2.1.4
v2.1.3
v2.1.2
v2.1.1
v2.1.0
v2.0.1
v2.0.0
v1.1.13
v1.1.12
v2.0.0-alpha
v1.1.11
v1.1.10
v1.1.9
v1.1.8
v1.1.7
v1.1.6
v1.1.5
v1.1.4
v1.1.3
v1.1.2
v1.1.1
v1.1.0
v1.0.2
v1.0.1
v1.0.0
v1.0.0-beta2
v1.0.0-beta
0.1.4
0.1.3
0.1.2
0.1.1
0.1.0
Labels
Clear labels   
bug
Something isn't working

  
documentation
Improvements or additions to documentation

  
duplicate
This issue or pull request already exists

  
enhancement
New feature or request

  
good first issue
Good for newcomers

  
help wanted
Extra attention is needed

  
invalid
This doesn't seem right

  
missing information
Further information is requested

  
wontfix
This will not be worked on

No labels
bug
documentation
duplicate
enhancement
good first issue
help wanted
invalid
missing information
wontfix
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
pxlrbt/filament-excel#146
No description provided.