Get featured listings from sub categories (while parent category)

posted 10 years ago

Hello guys,

I'm trying to show featured listings from sub categories in a category view.

I can check children categories and then get featured listings in each child category. But it does not seem to a good method. Could somebody please give me a hint if I can do it with eloquent relationship?

Last updated 3 years ago.

rdelorier

replied 10 years ago

Can you provide your model relationships and which data from each model your looking for

almamundinajpuri

replied 9 years ago

Hi RDelorier,

I've a Category and a Listing model

Category with parent id is Sub Category
Each category has some sub categories

public function children(){
        return $this->hasMany('App\Cat','parent_id')->whereStatus(1);
}

(Sub) category hasMany Listings

public function listings(){
        return $this->hasMany('App\Listing')->whereStatus(1);
}

and 4. in Listing model

public function cat(){
        return $this->belongsTo('App\Cat');
}

Now, when I'm in category, I want to fetch all featured items all of its sub categories. Home this makes sense.

Last updated 9 years ago.

jimgwhit

replied 9 years ago

See ==http://laravel.io/forum/04-04-2015-looping-through-collection. Plus there are Laracast on this.

Moderators