php - Laravel - How to chain Eloquent relationship - Eager Loading -


i'm using laravel 5.4, laravel roles here , eloquent relationships.

i'm trying retrieve users of company along roles.

user::find(1)->roles gets me user's roles id =1

company::find(1)->users gets me users belongs company id =1 (without roles of users).

company::find(1)->users->roles returns error property [roles] not exist on collection instance.

questions

  1. is possible want ?
  2. if so, how should ?

user.php

class user extends authenticatable {     use hasroleandpermission;      public function company()     {         return $this->belongsto('app\company');     }      public function user()     {         return $this->belongsto(user::class);     } }

hasroleandpermission.php

trait hasroleandpermission {     public function roles()     {         return $this->belongstomany(config('roles.models.role'));     } }

company.php

class company extends model {     public function users() {         return $this->hasmany('app\user');     } }

1 company has many users.

1 users has many roles.

you trying roles of collection of users (the property exists 1 user) thus, property doesn't exists collection.

if want roles of users in company, might try above code:

$roles = []; company::find(1)->users->foreach(function($user) {     $roles = array_merge($roles, $user->roles); });

--------- edit ---------

for eager loading roles of users, must use with, suggested @ohgodwhy, i'd refactor little:

$users = user::with('roles')->where('company_id', $companyid)->get();

now have array of users eager loading roles. still can't access directly $users->roles, must first user, roles.


Comments

Post a Comment

Popular posts from this blog

'hasOwnProperty' in javascript -

i use obj.hasownproperty judge whether object has property, when replaced obj[prop] !== undefined , not normal implementation, ask, why behind method can not use it? object.hasownproperty(prop); object[prop] !== undefined; obj[prop] !== undefined wrong 2 reasons: you can explicitly set property undefined , obj[prop] = undefined; . obj.hasownproperty(prop) return true in case. obj[prop] follow prototype chain, return property that's inherited. obj.hasownproperty(prop) returns true if property exists directly in object, returns false inherited properties.
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more

android - Unable to generate FCM token from dynamically instantiated Firebase -

our business logic requires instantiate firebase during runtime. fetch firebase credentials (app id, api key etc.) default firebase location after knowing user's public key , create firebase instance using credentials. this means there 2 firebase instances used within app: the default "index" firebase gives credentials second the actual firebase intend use point forward the second firebase initialised this: firebaseapp app = firebaseapp.initializeapp(<context>, <options>, <app_label>); our problem traditional method of retrieving fcm token using firebaseinstanceidservice , ontokenrefresh() fails since ontokenrefresh() method called first firebase instance. directly calling string token = firebaseinstanceid.getinstance(app).gettoken(); returns null never ready when called. have tried polling test if token generated @ point. no luck. how can generate fcm token reliably firebase instance instantiated during runtime? i...
Read more