5 table relation $?%$&

Hi,

Table1::with('table2.table3.table4.table5')->get();

Like so

This return me a full json off all table but i want only table 5 item in my json. Else i can concat all array of table 5 together to make my full table 5 item. Do you have something more optimize ?

@jak645 something is wrong here if you want to go from table1 to table5 through 3 tables ( just to grab table 5 ). Can you add for example relationships between table1 and table5?

You don't seem to have anything relating table 1 and table 2 ?

Join table between 1 and 2 but i miss write my join table

Tabe 1 <--> Table 2 Contain Table1_id : Table2_id

So table 1 can have many table 2

Therefore table 1 to table 3 will be many table 3.

Without real names for things its really difficult to illustrate

$table5s = Table1::table2s()->table3()->table4()->table5()->get();

There my table

Users, Users_Homes, Homes, Rooms, Box, Items,

Users Homes have many to many relation. Rooms have one Homes. Box have one Rooms. Items have one Box.

i try to get all Items from users ^^

@Snapey Table1::table2() dont call table 2 has static methode ?

Sorry, you need to specify user

eg,

$items = Auth::user()->homes()->rooms()->boxes()->items();

or if you have user

$items = $user->homes()->rooms()->boxes()->items();

Method Illuminate\Database\Query\Builder::rooms does not exist.

Method rooms() is existing in homes() model

$user = User::find($id); return $user->homes()->rooms()->box()->get();

return Box::whereHas('rooms',function ($query){
            $query->whereHas('homes', function ($query){
                $query->whereHas('users', function ($query){
                    $query->where('users_id','=' ,1);
                });
            });
        })->get();

damm how i can optimize this

Show your Home model?

class Home extends Model
{
    use SoftDeletes;

    protected $table = 'homes';

    protected $fillable = ['title','description','adresse'];

    protected $guarded = ['id','deleted_at'];

    public function users(){
        return $this->belongsToMany('App\User','homes_users','homes_id','users_id');
    }

    public function rooms(){
        return $this->hasMany('App\Room','home_id');
    }
}

return Box::whereHas('rooms.homes.users', function ($q) { $q->where('users_id',$this->id); });