laravel 5.6 related models to related models

Question

laravel 5.6 related models to related models

Navigation

#1 by (1 votes)

2

I have in the model Finca.php

public function piscinas(){
    return $this->hasMany(Piscina::class)->select('id' , 'finca_id', 'area' , 'name');
}

And in the Piscina.php

model

public function finca(){
    return $this->belongsTo(Finca::class);
}

public function planificacion(){
    return $this->belongsTo(Planificacion::class);
}

How could you bring me swimming pools on a farm that have no planning?

$finca->piscinas->no_contains_planificacion???

php eloquent laravel-5 model

asked by kevin au tam 14.06.2018 в 00:48

source

1 answer

Spring boot security http basic with oauth2 resource server Problem with conditional

score 1 · Accepted Answer

Try this in your Finca model. Make leftJoin with planificacion and there valid if the field piscina_id is null

return $this->hasMany(DB::table('piscina'))
   ->leftJoin('planificacion', 'planificacion.piscina_id', '=', 'piscina.id')
   ->select('piscina.id' , 'piscina.finca_id', 'piscina.area' , 'piscina.name')
   ->whereNull('planificacion.piscina_id')
   ->get();

Learn more about Laravel's Query Builder in its official documentation