php - Laravel 所属查询

Question

抱歉，我无法用简单的问题来描述我的问题!所以我要把它写下来以便更好地解释。

我有 2 个表..

订单表:

id - status  
100 - success  
200 - pending  

销售表:

id - order_id - user_id - amount 
1  - 100 - 5 - $20
2  - 200 - 5 - $30 

销售模式

class Sales extends Eloquent
{
    public function parentorder()
    {
        return $this->belongsTo('Order', 'order_id');
    }
}

我只需要获得成功订单的总金额

// get profits 
// this gives me = $50 
$profits = Sales::where('user_id',Auth::user()->id)->sum('amount')

// trying to do something like .. 
$profits = Sales::where('user_id',Auth::user()->id)->where('parentorder.status','Success')->sum('amount');
// so I get the correct total which is $20 (for the success order id=100)

嗯，有什么帮助吗？

Answer 1

查询

$total = Sale::whereHas('orders', function($q)
{
    $q->where('status', '=', 'success');

})->sum('amount');

用法

调用变量$total。