/PHP/Laravel/Laravel where condition on relationship

Laravel where condition on relationship

App\Request::where('id',4)
    ->whereHas('quotes', function ($query) {
        $query->where('status','=','3');
    })
    ->with('quotes','sourceTable','destinationTable')
    ->get();

Source: laracasts.com

Laravel adding condition to relation

class Game extends Eloquent {
    // many more stuff here

    // relation without any constraints ...works fine 
    public function videos() {
        return $this->hasMany('Video');
    }

    // results in a "problem", se examples below
    public function available_videos() {
        return $this->videos()->where('available','=', 1)->get();
    }
}

Source: stackoverflow.com

Similar codes

0 vote392 views1 answer
Expression #1 of ORDER BY contains aggregate function and applies to the result of a non-aggregated query laravel
PHP Laravel
8 votes371 views2 answers
Laravel passport
PHP Laravel
-1 vote385 views1 answer
Laravel remove index.php from url
PHP Laravel
21 votes387 views2 answers
Long text in laravel migration
PHP Laravel
50 votes457 views6 answers
Add new column in laravel migration
PHP Laravel
0 vote365 views1 answer
Encryption key has not encrypted laravel
PHP Laravel
0 vote342 views1 answer
Php laravel convert blob type to string
PHP Laravel
0 vote380 views1 answer
Use s3 storage laravel
PHP Laravel
1 vote367 views1 answer
Laravel read origanl value before update
PHP Laravel
0 vote405 views1 answer
Laravel array search blade
PHP Laravel