laravel5.2嵌套Where子句-laravel5.2nestedWhereclause

2  

Change like this

改变这样

$payouts = Stat::where('payed', '1');
        $payouts->where(function ($payouts) {
            $payouts->where('owner_id', Auth::user()->id)
                  ->orWhere('user_id', Auth::user()->id);
        })->get();

0  

Try this

尝试这个

 $payouts = Stat::where('payed', '1')
            ->where(function ($query) {
              $query->where('owner_id', Auth::user()->id)
                        ->orwhere('user_id', Auth::user()->id);
             })->get();

0  

You're close, this should do the trick:

你很接近，这应该做的伎俩：

$payouts = Stat::where('payed', '1')
            ->where(function ($query) {
                $query->where('owner_id', Auth::user()->id)
                      ->orWhere('user_id', Auth::user()->id);
            })->get();

This is looking for where payed = 1 AND (owner_id is the current user ID OR the user_id is the current user ID)

这是在寻找payed = 1 AND（owner_id是当前用户ID或user_id是当前用户ID）