Laravel Eloquent Sum of关系的列

时间:2023-03-04
本文介绍了Laravel Eloquent Sum of关系的列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

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

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

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

  • 购物车表仅包含以下列:iduser_idproduct_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.

这篇关于Laravel Eloquent Sum of关系的列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

上一篇:什么是“批量分配"?在 Laravel 中是什么意思? 下一篇:Laravel Eloquent:如何对相关模型的结果进行排序?

相关文章