/PHP/Laravel/Laravel adding condition to relation

Laravel adding condition to relation

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
Laravel eloquent pass to next element
PHP Laravel
0 vote372 views1 answer
Seguridad de las api en laravel
PHP Laravel
15 votes420 views3 answers
Laravel target class does not exist
PHP Laravel
15 votes379 views6 answers
Install laravel
PHP Laravel
1 vote379 views1 answer
Run laravel mix
PHP Laravel
-1 vote416 views1 answer
Create user with tinker php laravel
PHP Laravel
-1 vote364 views1 answer
Laravel orderby with relation
PHP Laravel
6 votes338 views2 answers
Laravel migration make column nullable
PHP Laravel
13 votes347 views6 answers
Named route with parameter laravel
PHP Laravel
33 votes357 views6 answers
Create migration command in laravel
PHP Laravel