One controller for different roles and query

you can use Laravel Spatie. This package allows you to manage user permissions and roles in a database. it's simple and very fast ti implement. it's also allow you to manage permission on routes, controllers and blade.

@mballaag Thanks for the immediate reply :-). Can I also manage different queries based on the role?

@clusteCode you can easily made 'if' options with blade.

@clusteCode If you have a “CondominiumController” that fetches a condominium and displays different data depending on the role of the user logged in, then I think you want to have a way of switching the view rather than performing different queries.

You could use Laravel’s “Responsable” interface and add it to a view model that picks a view depending on the authenticated user’s role:

namespace App\Http\Controllers;

use App\Condominium;
use App\Http\Views\CondominiumView;

class CondominiumController extends Controller
{
    public function show(Condominium $condominium)
    {
        return new CondominiumView($condominium);
    }
}

namespace App\Http\Views;

use Illuminate\Contracts\Support\Responsable;
use Exception;

class CondominiumView implements Responsable
{
    private $condominium;

    public function __construct(Condominium $condominium)
    {
        $this->condominium = $condominium;
    }

    public function toResponse($request)
    {
        // If your User model has a property called role…
        switch ($request->user()->role) {
            case 'normal_user':
                $path = 'condominium.show.normal_user';
                break;

            case 'admin':
                $path = 'condominium.show.admin';
                break;

            default:
                throw new Exception("No view for role [{$role}].");
        }

        return view($path, [
            'condominium' => $this->condominium,
        ]);
    }
}

So a user can view a single condominium, but the view they get to see depends on their role.

Hello @martinbean, I'm surprised by the immediate response and receive good code :-) Thank you very much.

I did not know 'Responsable' in laravel, I try it now, surely this makes the code cleaner :-P

Unfortunately, in this application every role will have a different query :-(, for you, the only way to solve this problem and insert the IFs inside the controller?

Thanks again for your time and availability.