Tukukkk

// user with roles

$user = User::where('id', Auth::User()->id)

    ->with('roles')

    ->first();



// Get the RoleParentId

$roleParentId = collect($user->roles)->min('parent_id');



// Get the all the children of the role parent Id with it's children and users

$role = AppModelRole::where('parent_id', $roleParentId)

    ->with('allChildren.users')

    ->first();



// Loop to get the Collection of children users

$childrenUsers = collect();

foreach($role->allChildren as $children){

    $childrenUsers->push($children->users);

}



// Loop to get the Collection of user

$users = collect();

foreach($childrenUsers as $nCollect){

    foreach($nCollect as $user){

        $users->push($user);

    }

}



return response()->json($users);

// user with roles

$user = User::where('id', Auth::User()->id)

    ->with('roles')

    ->first();



// Get the RoleParentId

$roleParentId = collect($user->roles)->min('parent_id');



// Get the all the children of the role parent Id with it's children and users

$role = AppModelRole::where('parent_id', $roleParentId)

    ->with('allChildren.users')

    ->first();



// Loop to get the Collection of children users

$childrenUsers = collect();

foreach($role->allChildren as $children){

    $childrenUsers->push($children->users);

}



// Loop to get the Collection of user

$users = collect();

foreach($childrenUsers as $nCollect){

    foreach($nCollect as $user){

        $users->push($user);

    }

}



return response()->json($users);

// user with roles

$user = User::where('id', Auth::User()->id)

    ->with('roles')

    ->first();



// Get the RoleParentId

$roleParentId = collect($user->roles)->min('parent_id');



// Get the all the children of the role parent Id with it's children and users

$role = AppModelRole::where('parent_id', $roleParentId)

    ->with('allChildren.users')

    ->first();



// Loop to get the Collection of children users

$childrenUsers = collect();

foreach($role->allChildren as $children){

    $childrenUsers->push($children->users);

}



// Loop to get the Collection of user

$users = collect();

foreach($childrenUsers as $nCollect){

    foreach($nCollect as $user){

        $users->push($user);

    }

}



return response()->json($users);

// user with roles

$user = User::where('id', Auth::User()->id)

    ->with('roles')

    ->first();



// Get the RoleParentId

$roleParentId = collect($user->roles)->min('parent_id');



// Get the all the children of the role parent Id with it's children and users

$role = AppModelRole::where('parent_id', $roleParentId)

    ->with('allChildren.users')

    ->first();



// Loop to get the Collection of children users

$childrenUsers = collect();

foreach($role->allChildren as $children){

    $childrenUsers->push($children->users);

}



// Loop to get the Collection of user

$users = collect();

foreach($childrenUsers as $nCollect){

    foreach($nCollect as $user){

        $users->push($user);

    }

}



return response()->json($users);

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

active

oldest

votes

$users = User::whereHas('roles', function() {

    //Get the roles where the parent_id is the (minimum) parent_id from the user roles

    return $query->where('parent_id', Auth::user()->roles()->orderBy('parent_id', 'ASC')->first()->parent_id);

});

$users = User::whereHas('roles', function() {

    //Get the roles where the parent_id is the (minimum) parent_id from the user roles

    return $query->where('parent_id', Auth::user()->roles()->orderBy('parent_id', 'ASC')->first()->parent_id);

});

$users = User::whereHas('roles', function() {

    //Get the roles where the parent_id is the (minimum) parent_id from the user roles

    return $query->where('parent_id', Auth::user()->roles()->orderBy('parent_id', 'ASC')->first()->parent_id);

});

$users = User::whereHas('roles', function() {

    //Get the roles where the parent_id is the (minimum) parent_id from the user roles

    return $query->where('parent_id', Auth::user()->roles()->orderBy('parent_id', 'ASC')->first()->parent_id);

});

add a comment |