Laravel ?? ??? ?? ??: ?? ??? ?? ??? ????? ?? ?? ??? ?????.

???? ??? ???? ?? ????? ??? ??????? ?? ??? ?? ? ???? ????. ??? ????????? ?? ??? ???? ???? ???? ??? ?????. ?? ??? ???? ???? ?? ???(??, ?? ?? ??)? ??????? ??? ? ??? ?? ???? ??? ?? ?????.

?? ??? Laravel ?????? ???? ?? ??? ???? ??? ? ?? ??? ?????. ? ???? Laravel? ?? ??? ?? ?? ??? ????? ?? ??? ???? ??? ???? ???? ?? ??? ?????.

?? ??? ??? ??? ? ?? ?? ???? ??? ???? ???. Laravel??? ?? ???? ?? Eloquent ??? ??? ? ????. ??? ??? ??? ?? ?????:

<?php

namespace AppModels;

use IlluminateDatabaseEloquentModel;

class Tenant extends Model
{
    protected $guarded = [];

    // 租戶和用戶之間的關(guān)聯(lián)關(guān)系
    public function users()
    {
        return $this->hasMany(User::class);
    }
}

????, ? ???? ?? ???? ??????? ???? Laravel?? ?? ?????? ??? ???? ???. config/database.php ?? ???? ??? ?????? ??? ??? ?? ??? ? ????.

<?php

return [

    // 默認數(shù)據(jù)庫連接
    'default' => env('DB_CONNECTION', 'mysql'),

    'connections' => [

        'mysql' => [
            'driver' => 'mysql',
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => true,
            'engine' => null,
        ],

        'tenant' => [
            'driver' => 'mysql',
            'host' => env('TENANT_DB_HOST', '127.0.0.1'),
            'port' => env('TENANT_DB_PORT', '3306'),
            'database' => env('TENANT_DB_DATABASE', 'forge'),
            'username' => env('TENANT_DB_USERNAME', 'forge'),
            'password' => env('TENANT_DB_PASSWORD', ''),
            'unix_socket' => env('TENANT_DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'strict' => true,
            'engine' => null,
        ],

    ],

    // ...
];

? ?? ???? ????? ?????? ??? ???? .env ??? ?? ??? ??????. ??? ??? ????.

TENANT_DB_HOST=127.0.0.1
TENANT_DB_PORT=3306
TENANT_DB_DATABASE=tenant_db
TENANT_DB_USERNAME=root
TENANT_DB_PASSWORD=secret

???? ?? ??? ?? ??? ???? ?? Laravel?? ????? ???? ???. ????? ???? ??? ???? ??? ???? ?? ???? ???? ?? ???? ????? ???? ?? ??? ??? ? ????. ??? ??? ???? ?????.

<?php

namespace AppHttpMiddleware;

use Closure;
use IlluminateSupportFacadesAuth;
use IlluminateSupportFacadesDB;

class TenantMiddleware
{
    public function handle($request, Closure $next)
    {
        $tenantId = $request->route('tenantId');
        $user = Auth::user();

        if ($user && $tenantId != $user->tenant_id) {
            abort(403, 'Access denied.');
        }

        $this->switchConnection($tenantId);

        return $next($request);
    }

    private function switchConnection($tenantId)
    {
        // 切換到對應租戶的數(shù)據(jù)庫連接
        config(['database.connections.tenant.database' => "tenant_{$tenantId}"]);

        DB::purge('tenant');
    }
}

? ????? ?? Auth::user() ???? ?? ?? ???? ???? ??? ????, ?? ???? ?? ???? ??? ???? ????? ?????. ???? ???? ??? 403 ??? ?????. ?? ??, switchConnection() ???? ?? ?? ???? ?????? ??? ?????.

????? ??? ??? ????? ???? ?? ??? ??? ???? ???.

<?php

use IlluminateSupportFacadesRoute;

// ...

Route::group(['middleware' => ['auth', 'tenant']], function () {
    Route::get('/dashboard', [DashboardController::class, 'index']);
    Route::get('/reports', [ReportsController::class, 'index']);
});

? ????? ? ?? ????? ??????. auth? ??? ??? ??? ???? ? ???? ???? ???? ? ?????. ?? ??? ?? ??. Auth::user() ???? ???? ?? ???? ???? ??? ?? ?????? ??? ? ????.

?? ?? ??? ?? ??? ???? ?? ?? ????? ?? ?????. ?? ?? ?????? ????? ? ??? ? ??? ?? ?? ??? ?? ?? ?? ? ??? ??? ? ????. ??? ?? ???? ??? Laravel? ??? ?? ??? ???? ????? ???? ?? ??? ????? ?? ??? ???? ?? ?? ??? ?? ??? ???? ??? ??? ? ????.

? ??? Laravel ?? ??? ?? ??: ?? ??? ?? ??? ???? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!