How to add a column to model_has_roles and log with the sync() method?

[alexv96]

I am working with a SaaS system where I have the users, roles and permissions in the parent database (Landlord) and I would like to create the tenant_id column because it does not allow me to integrate only the model_has_roles table in the tenant databases (Tenant), then a solution that occurred to me was to create in the table the tenant column, but I do not know how to keep the sync methods and that I register in that column.

[erikn69]

#1827 (comment) add field to migration
overwrite relations or use teams-permissions

[alexv96]

Q: do you added that middleware to kernel?
A: I did add it, I ran a dd() to see if it is working, but it doesn't enter the if when I log in.

I also added it to the kernel but it only enters if I remove the exclamation mark or put an else.

Q: Why Auth::user()->setPermissionsTeamId(7)? must be only setPermissionsTeamId(7) and don´t returns anything
A: Because I was trying to somehow force the display of user roles. 😅 Here I forced with 7 because I was testing in another project that I created a blank one to see this issue to see if there was any other library that made it not work.

Q: Put \Cookie::get('tenant') on dd() too
A: The dd() is to test what data it is bringing me that I am testing it directly from blade.

Cookie::get('tenant') returns the team number.

The difference is that the middlewarePriority in my kernel file was never in Laravel 8 so I read that I had to put it and I put it, maybe that generates that I can't access?

This is my kernel TeamsPermission

<?php

namespace App\Http;

use Illuminate\Foundation\Http\Kernel as HttpKernel;

class Kernel extends HttpKernel
{
    /**
     * The application's global HTTP middleware stack.
     *
     * These middleware are run during every request to your application.
     *
     * @var array
     */
    protected $middleware = [
        // \App\Http\Middleware\TrustHosts::class,
        \App\Http\Middleware\TrustProxies::class,
        \Fruitcake\Cors\HandleCors::class,
        \App\Http\Middleware\PreventRequestsDuringMaintenance::class,
        \Illuminate\Foundation\Http\Middleware\ValidatePostSize::class,
        \App\Http\Middleware\TrimStrings::class,
        \Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull::class,
        // \App\Http\Middleware\TeamsPermission::class,

    ];

    /**
     * The application's route middleware groups.
     *
     * @var array
     */
    protected $middlewareGroups = [
        'web' => [
            \App\Http\Middleware\EncryptCookies::class,
            \Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,
            \Illuminate\Session\Middleware\StartSession::class,
            // \Illuminate\Session\Middleware\AuthenticateSession::class,
            \Illuminate\View\Middleware\ShareErrorsFromSession::class,
            \App\Http\Middleware\VerifyCsrfToken::class,
            \Illuminate\Routing\Middleware\SubstituteBindings::class,
        ],

        'api' => [
            // \Laravel\Sanctum\Http\Middleware\EnsureFrontendRequestsAreStateful::class,
            'throttle:api',
            \Illuminate\Routing\Middleware\SubstituteBindings::class,
        ],

        'tenant' => [
            \Spatie\Multitenancy\Http\Middleware\NeedsTenant::class,
            \Spatie\Multitenancy\Http\Middleware\EnsureValidTenantSession::class,
        ],
    ];

    protected $middlewarePriority = [
        \App\Http\Middleware\TeamsPermission::class,

    ];
}

[erikn69]

Middleware priority it's for set order of the middleware, if you put only one it does nothing, you must set it to web or your middleware group, and do you have another guards? I'm on a cell phone and I can't read everything, but looks like you don't know how to config your kernel

[alexv96]

Don't worry when you can.

I'm sorry that I don't know much about middleware and kernel in Laravel, it's something very basic in this part.

Now I can enter the middleware IF without problems, but I still can not list the roles of all users, or in this case to know what roles I have assigned as a user.

Because in the database the team is registered in the relevant tables.

[erikn69]

Here is my config, but i am using session instead of cookie, when you do use <> for code, set it to php for highlighting and readability

protected $middleware = [
    \App\Http\Middleware\TrustProxies::class,
    \App\Http\Middleware\CheckForMaintenanceMode::class,
    \Illuminate\Foundation\Http\Middleware\ValidatePostSize::class,
    \App\Http\Middleware\TrimStrings::class,
    \Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull::class,
    \Fruitcake\Cors\HandleCors::class,
];
protected $middlewareGroups = [
    'web' => [
        \App\Http\Middleware\EncryptCookies::class,
        \Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse::class,
        \Illuminate\Session\Middleware\StartSession::class,
        \Illuminate\View\Middleware\ShareErrorsFromSession::class,
        \App\Http\Middleware\VerifyCsrfToken::class,
        \Illuminate\Routing\Middleware\SubstituteBindings::class,
        \App\Http\Middleware\TeamsPermission::class,
    ],

    'api' => [
        'throttle:60,1',
        \Illuminate\Routing\Middleware\SubstituteBindings::class,
        \App\Http\Middleware\TeamsPermission::class,
    ],
];
protected $middlewarePriority = [
    \App\Http\Middleware\EncryptCookies::class,
    \Illuminate\Session\Middleware\StartSession::class,
    \Illuminate\View\Middleware\ShareErrorsFromSession::class,
    \App\Http\Middleware\Authenticate::class,
    \Illuminate\Session\Middleware\AuthenticateSession::class,
    \Illuminate\Routing\Middleware\SubstituteBindings::class,

    \App\Http\Middleware\TeamsPermission::class,
    \Illuminate\Auth\Middleware\Authorize::class,

    \Spatie\Permission\Middlewares\RoleMiddleware::class,
    \Spatie\Permission\Middlewares\PermissionMiddleware::class,
    \Spatie\Permission\Middlewares\RoleOrPermissionMiddleware::class,
];

[alexv96]

AAAA that's why it didn't work, now everything works, thank you very much, this middleware was new, it didn't appear in any tutorial I had seen, thank you very much.

Thank you very much, now everything works.