Summarize Relationship aggregate

Hi, is there a way to custom summarize a relationship sum aggregate?
Something like:

TextColumn::make('totalHours')
  ->label('Total Hours')
  ->state(fn(Model $record) => 
    $record->payroll_items_sum_reg_hours +
    $record->payroll_items_sum_ot_hours)
  ->summarize(Summarizer::make()
      ->label('Total')
      ->using(fn(Builder $query): string =>
        $query->payroll_items_sum_reg_hours +                       $query->payroll_items_sum_ot_hours)),

TextColumn::make('totalHours')
  ->label('Total Hours')
  ->state(fn(Model $record) => 
    $record->payroll_items_sum_reg_hours +
    $record->payroll_items_sum_ot_hours)
  ->summarize(Summarizer::make()
      ->label('Total')
      ->using(fn(Builder $query): string =>
        $query->payroll_items_sum_reg_hours +                       $query->payroll_items_sum_ot_hours)),

This throws a:
Undefined property: Illuminate\Database\Query\Builder::$payroll_items_sum_reg_hours
How could I access the relationship in the summarizer?

Filament•3y ago•

4 replies

AmauryCid

Summarize Relationship aggregate

Hi, is there a way to custom summarize a relationship sum aggregate?
Something like:

TextColumn::make('totalHours')
  ->label('Total Hours')
  ->state(fn(Model $record) => 
    $record->payroll_items_sum_reg_hours +
    $record->payroll_items_sum_ot_hours)
  ->summarize(Summarizer::make()
      ->label('Total')
      ->using(fn(Builder $query): string =>
        $query->payroll_items_sum_reg_hours +                       $query->payroll_items_sum_ot_hours)),

TextColumn::make('totalHours')
  ->label('Total Hours')
  ->state(fn(Model $record) => 
    $record->payroll_items_sum_reg_hours +
    $record->payroll_items_sum_ot_hours)
  ->summarize(Summarizer::make()
      ->label('Total')
      ->using(fn(Builder $query): string =>
        $query->payroll_items_sum_reg_hours +                       $query->payroll_items_sum_ot_hours)),

This throws a:
Undefined property: Illuminate\Database\Query\Builder::$payroll_items_sum_reg_hours
How could I access the relationship in the summarizer?

Summarize Relationship aggregate

Similar Threads

Summarize Relationship aggregate

Similar Threads

Similar Threads

Similar Threads