How to get data using related table?

[rappasoft]

How to get data using related table?

[rappasoft]

If you have a specific role you can grab the users with the relationship, as specified here:

https://github.com/rappasoft/laravel-5-boilerplate/blob/master/app/Role.php

$role = Role::find(1)->users

[xnhinzkyx]

Thanks for this but I'm new to laravel can you show me how to display it using this function?

public function getUsersPaginated($per_page, $status = 1, $order_by = 'id', $sort = 'asc') {
return User::where('status', $status)->orderBy($order_by, $sort)->paginate($per_page);
}

Thanks.

[rappasoft]

I'm confused, exactly what are you trying to display with a function?

[xnhinzkyx]

I'm trying to display users with a role moderator for example using that function getUsersPaginated().

Like return User::where('status', $status)->orderBy($order_by, $sort)->paginate($per_page)->role('moderator');

[rappasoft]

Try something like:

User::whereHas('role', function($q) {
    $q->where('name', '=', 'moderator');
})->where('status', $status)->orderBy($order_by, $sort)->paginate($per_page);

That may work, untested.

[xnhinzkyx]

Thanks but it gives me an error:

BadMethodCallException in Builder.php line 2003:
Call to undefined method Illuminate\Database\Query\Builder::role()

Do i need to add something?

[rappasoft]

It might be roles instead. Or it might not work at all because it's a pivot table.

[xnhinzkyx]

Yeah it doesn't work for me but still thank you for your support.