Filament•14mo ago

summarize time interval

Hi. I have a "hours" field in my database, containig time user works in a task My column is: TextColumn::make('hours') ->label('Duración') ->time() ->summarize(Sum::make()->label('Tiempo trabajado')) ->sortable(), But "total" is not calculated ok. how can I calculate correct time sum?

Solution:

just use the original hours column is enough

Jump to solution

23 Replies

PabloZagniOP•14mo ago

Anyone?

Saade•14mo ago

Use a custom summarizer with a custom query, something like:

SELECT SEC_TO_TIME( SUM( TIME_TO_SEC( `hours` ) ) ) AS totalhours

SELECT SEC_TO_TIME( SUM( TIME_TO_SEC( `hours` ) ) ) AS totalhours

PabloZagniOP•14mo ago

https://filamentphp.com/docs/3.x/tables/summaries Custom summaries are "using" a query... don't know how to implement it

Summaries - Table Builder - Filament

Saade•14mo ago

$query->raw()?

PabloZagniOP•14mo ago

but, how to apply to filtered records?

PabloZagniOP•14mo ago

I've done it for a basic table, but don't know how to do it in filament

PabloZagniOP•14mo ago

Anyone?

toeknee•14mo ago

using $query->sum() ?

awsqed•14mo ago

$query->sum(DB::raw('TIME_TO_SEC(hours)'))

$query->sum(DB::raw('TIME_TO_SEC(hours)'))

then combine with your logic to convert from seconds to H:i:s

PabloZagniOP•14mo ago

I had to create a column "seconds" = TIME_TO_SEC(hours) but when I summarize, it give me sum(seconds), I need to formar it H:i:s now, theres no formatUsing func to Summarize

toeknee•14mo ago

Can you provide the code you are using?

PabloZagniOP•14mo ago

toeknee•14mo ago

so as above see: https://filamentphp.com/docs/3.x/tables/summaries#custom-summaries you can format the display for you. As you are summing duration this is a time which needs diving by 60 etc.

Summaries - Table Builder - Filament

PabloZagniOP•14mo ago

This doesn't work