How to get relation of relation Count in laravel?

Question

i have laravel models

Category: id,name

public function posts(){
    return $this->hasMany(PostCategory::class,'category_id','id');
}

PostCategory : post_id, category_id

public function post(){
    return $this->belongsTo(Post::class,'post_id');
}

POST: id, ..so on

public function solutions(){
    return $this->hasMany(PostSolution::class,'post_id','id');
 }

I need to get count of all posts fall under a category and also solutions under one category.. there is no direct relation of category and solution so how to get count of solutions in one category.

$categories = Category::withCount('posts')->get();

Are you sure, that a post category belongs to a single post? Shouldn't it be the other way around (or that a post belongs to many post categories)? — Basharmal
– Basharmal, Commented Mar 25, 2021 at 12:27
The person who answered this has deleted their comment so i am not able to upvote. — Neha
– Neha, Commented Mar 25, 2021 at 12:49
@Basharmal yes you are right! single post belongs to many categories — Neha
– Neha, Commented Mar 25, 2021 at 12:50

Basharmal · Accepted Answer · 2021-03-25 12:35:28Z

1

I think use hasManyThrough relation

// Category Class

public function solutions()
{
    return $this->hasManyThrough(PostSolution::class, Post::class);
}

// Then get the data in the same old manner
$categories = Category::->withCount('posts')->get();

I hope this will help

answered Mar 25, 2021 at 12:35

Basharmal

1,3941 gold badge14 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get relation of relation Count in laravel?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related