F
Filament•2mo ago
bernhard

Sum of 2 columns of a relation

I have a model Order which hasMany orderPositions. A order position contains the columns product_price and amount. How can I now show the "value" of an order in a table. With value I mean the sum of all orderPositions prices times it amounts. I tried to use the aggregate functions: 
TextColumn::make('order_positions_sum_product_price')
  ->money("EUR")
  ->sum('orderPositions', 'product_price'),
TextColumn::make('order_positions_sum_product_price')
  ->money("EUR")
  ->sum('orderPositions', 'product_price'),
But this gives me obviously only the sum of the prices and ignores the amount of the positions. 
TextColumn::make('order_positions_sum_product_price')
  ->money("EUR")
  ->sum([
      'orderPositions' => fn (Builder $query) => $query->selectRaw('(product_price * amount) as product_price'),
  ], 'product_price'),
TextColumn::make('order_positions_sum_product_price')
  ->money("EUR")
  ->sum([
      'orderPositions' => fn (Builder $query) => $query->selectRaw('(product_price * amount) as product_price'),
  ], 'product_price'),
doesnt change anything? Any ideas?
Solution:
Nevermind, found it: ```php TextColumn::make('order_positions_sum_product_price') ->money("EUR")...
Jump to solution
3 Replies
LeandroFerreira
LeandroFerreira•2mo ago
Maybe a virtual column?
Solution
bernhard
bernhard•2mo ago
Nevermind, found it: 
TextColumn::make('order_positions_sum_product_price')
    ->money("EUR")
    ->sum(
        ['orderPositions' => fn (Builder $query) => $query->select(\DB::raw('SUM(product_price * amount)'))],
        'product_price'
    ),
TextColumn::make('order_positions_sum_product_price')
    ->money("EUR")
    ->sum(
        ['orderPositions' => fn (Builder $query) => $query->select(\DB::raw('SUM(product_price * amount)'))],
        'product_price'
    ),
bernhard
bernhardOP•2mo ago
Using ->selectRaw adds another column, using ->select overwrites the default select part

Did you find this page helpful?