How to return all models in BelongsToMany relationship

Question

I have relationship on User model like below:

public function brands() {
    $roles = config('constants.roles');

    if ($this->hasRole($roles['brand_site_admin'])) {
        return $this->belongsToMany(Brand::class, 'brand_has_users');
    } else 
    if ($this->hasRole($roles['client_admin'])) {
        return $this->belongsToMany(Brand::class, 'brand_has_client_admin');
    }

    // For admin role I want to return all brands, from Brand Model
    // ?? 
}

For Admin role I want to return all rows from Brand model, How can I get that? And that should be instance of BelongsToMany class, then only it won't break code in my controller.

Update:

When I do $user->brands() I want all the brands from brands table if $user is an admin (In above code if it doesn't goes in any condition then it's Admin).

Mr. Pyramid · Answer 1 · 2017-09-13T13:45:20.847

0

I think you should try this as suggested in this SO post, first create the relationships like this

    $roles = config('constants.roles');
public function siteAdminBrands()
    {
        return $this->hasMany(Brand::class, 'brand_has_users');
    }    

    public function clientAdminBrands()
    {
        return $this->hasMany(Brand::class, 'brand_has_client_admin');
    }

    public function brands($query)
    {
        return $query
              ->when($this->hasRole($roles['brand_site_admin']),function($q){
                  return $q->with('siteAdminBrands');
             })
             ->when($this->hasRole($roles['client_admin']),function($q){
                  return $q->with('clientAdminBrands');
             });

    }
}

edited Sep 13 '17 at 13:45

answered Sep 12 '17 at 18:22

Mr. Pyramid

3,855
5
32
56

Thank you for the answer but I think you didn't get the question. – shyammakwana.me Sep 12 '17 at 18:24
yeah I haven't it exactly I just make an assumption please make it clear so that I can try to help you :) – Mr. Pyramid Sep 12 '17 at 18:25
what you have tried share your query you have tried to get the result may be that will clear the things – Mr. Pyramid Sep 12 '17 at 18:26
When I do `$user->brands()` I want all the brands from brands table if `$user` is an admin. – shyammakwana.me Sep 12 '17 at 18:28
ok and what are you currently getting if you type `$user->brands()`?? – Mr. Pyramid Sep 13 '17 at 04:51
Respective brands for other roles. Not for admin. See updated question. – shyammakwana.me Sep 13 '17 at 05:35
hey check the answer i have updated it and let me if it doesn't work – Mr. Pyramid Sep 13 '17 at 06:36
In this scope works on `user` model, so `user->brands()` returns users, not brands. – shyammakwana.me Sep 13 '17 at 12:37
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/154351/discussion-between-mr-pyramid-and-shyammakwana-me). – Mr. Pyramid Sep 13 '17 at 13:45
ok then use hasMany in place of belongsToMany as it has inverse relationship. – Mr. Pyramid Sep 13 '17 at 13:46
Not yet, I've researched something but didn't worked – shyammakwana.me Sep 22 '17 at 05:50
Mm.. ok bro! :) – Mr. Pyramid Sep 22 '17 at 05:52

How to return all models in BelongsToMany relationship

Update:

1 Answers1