where condition with HasOne laravel

Question

In login model I have implement relation with picture table

function picture () {
   return $this->hasOne('App\Picture');
}

Now I want data where Picture.picture_status = 1 and User.user_status = 1

Login::with('picture')->where('picture_status', 1)->where('user_status',1);

but where condition is not working with picture table, how can i implement and condition on both table

score 14 · Answer 1 · answered May 14 '19 at 21:26

14

class Login extends Model
{
    protected $primaryKey = 'id';

    function picture () {
       return $this->hasOne('App\Picture', 'id', 'user_id')->where('picture_status', 1)->where('user_status',1)->first();
    }
}

You can call like this;

$usersWithProfilePictures = Login::with('picture')->get();

answered May 14 '19 at 21:26

Mehmet

170
1
7

12

There's no need to append `first()` at the end. – user8555937 Dec 29 '20 at 09:26
2

If you add `first()` at the end, `$login->picture` will return `null`. Since you treat `picture` as a method, not a model property. You should remove the `first()`, and then you can call it just like model property, `$login->picture`. – ibnɘꟻ Jun 19 '21 at 04:45

score 9 · Answer 2 · answered Jul 14 '16 at 10:20

This should do it:

Login::with(['picture' => function ($query) {
    $query->where('picture_status', 1)->where('user_status',1);
}])->get();

Sometimes you may wish to eager load a relationship, but also specify additional query constraints for the eager loading query https://laravel.com/docs/5.2/eloquent-relationships#constraining-eager-loads

score 2 · Answer 3 · answered Jul 14 '16 at 10:24

class Login extends Model
{
    protected $primaryKey = 'id';

    function picture () {
       return $this->hasOne('App\Picture', 'id', 'user_id');
    }

    ................
    public function myF(){
         self::with('picture')->where('picture_status', 1)->where('user_status',1)->get();
    }
}

score 0 · Answer 4 · answered Apr 23 '20 at 08:41

In case someone still stumbles upon this problem. The best way to retrieve correct records would be to use Laravel Query Builder with join:

$logins = DB::table('logins')
            ->join('pictures', 'logins.id', '=', 'pictures.login_id')
            ->select('logins.*', 'pictures.status')
            ->where('logins.status', 1)
            ->where('pictures.status', 1)
            ->get();

You can learn more at https://laravel.com/docs/6.x/queries#joins

score 0 · Answer 5 · answered Jan 23 '23 at 21:18

You have to use ofMany Laravel function wich means the Model has one of many

function picture()
{
    return $this->hasOne('App\Picture', 'id', 'user_id')->ofMany(
        function ($query) {
            return $query->where('picture_status', 1)->where('user_status', 1);
        });
}

where condition with HasOne laravel

5 Answers5

Linked