Laravel Eloquent Sum of关系的列

2021-12-26 00:00:00 php laravel eloquent relation

我一直在开发一个购物车应用程序，现在我遇到了以下问题..

I've been working on a shopping cart application and now I've come to the following issue..

有一个用户、一个产品和一个购物车对象.

  • 购物车表仅包含以下列:id、user_id、product_id 和时间戳.
  • UserModel hasMany Carts(因为一个用户可以存储多个产品).
  • CartModel belongsTo 用户和 CartModel hasMany 产品.
  • The Cart table only contains the following columns: id, user_id, product_id and timestamps.
  • The UserModel hasMany Carts (because a user can store multiple products).
  • The CartModel belongsTo a User and CartModel hasMany Products.

现在计算我可以调用的总产品数:Auth::user()->cart()->count().

Now to calculate the total products I can just call: Auth::user()->cart()->count().

我的问题是:如何获得该用户购物车中产品的价格(一列产品)的SUM()?
我想使用 Eloquent 而不是使用查询来完成此操作(主要是因为我认为它更简洁).

My question is: How can I get the SUM() of prices (a column of product) of the products in cart by this User?
I would like to accomplish this with Eloquent and not by using a query (mainly because I believe it is a lot cleaner).

推荐答案

Auth::user()->products->sum('price');

文档对某些 Collection 方法略显简单，但除了 avg() 之外，所有查询构建器聚合似乎都可用，可在 http://laravel.com/docs/queries#aggregates.

The documentation is a little light for some of the Collection methods but all the query builder aggregates are seemingly available besides avg() that can be found at http://laravel.com/docs/queries#aggregates.

相关文章