Sum (quantity * price)

Hello,
Tried for hours to get a total for orders , there's something I'm doing wrong?

public function items()
    {
        return $this->hasMany(OrderItem::class);
    }

Forms\Components\Placeholder::make('total')
->content(fn ($record) => $record->items->sum(\DB::raw('quantity * price')))

public function items()
    {
        return $this->hasMany(OrderItem::class);
    }

Forms\Components\Placeholder::make('total')
->content(fn ($record) => $record->items->sum(\DB::raw('quantity * price')))

or trough an attribute

  public function getTotalAttribute()
  {
    return $this->quantity * $this->price;
  }

Forms\Components\Placeholder::make('total')
->content(fn ($record) => $record->items->total)

  public function getTotalAttribute()
  {
    return $this->quantity * $this->price;
  }

Forms\Components\Placeholder::make('total')
->content(fn ($record) => $record->items->total)

Filament•3y ago•

36 replies

Pasteko

Sum (quantity * price)

Hello,
Tried for hours to get a total for orders , there's something I'm doing wrong?

public function items()
    {
        return $this->hasMany(OrderItem::class);
    }

Forms\Components\Placeholder::make('total')
->content(fn ($record) => $record->items->sum(\DB::raw('quantity * price')))

public function items()
    {
        return $this->hasMany(OrderItem::class);
    }

Forms\Components\Placeholder::make('total')
->content(fn ($record) => $record->items->sum(\DB::raw('quantity * price')))

or trough an attribute

  public function getTotalAttribute()
  {
    return $this->quantity * $this->price;
  }

Forms\Components\Placeholder::make('total')
->content(fn ($record) => $record->items->total)

  public function getTotalAttribute()
  {
    return $this->quantity * $this->price;
  }

Forms\Components\Placeholder::make('total')
->content(fn ($record) => $record->items->total)

Sum (quantity * price)

Similar Threads

Sum (quantity * price)

Similar Threads

Similar Threads

Similar Threads