Laravel 模型 动态选择表

在模型里面写入如下 scopeFromTable方法

<?php

namespace App\Models;

use Illuminate\Notifications\Notifiable;
use Illuminate\Foundation\Auth\User as Authenticatable;

use Tymon\JWTAuth\Contracts\JWTSubject;
use Spatie\Permission\Traits\HasRoles;
class Admin extends Authenticatable implements JWTSubject
{

    use HasRoles,Notifiable;
    protected    $table  = 'admins';

    public function scopeFromTable($query, $suffix)
    {
        $query->from($this->table.$suffix);
    }
}

在controller里面 写入如下，可获取表 admins1的内容而不是admins表的内容

<?php

namespace App\Http\Controllers\Backend;

use App\Http\Controllers\Controller;

use App\Http\Requests\AdminAddRequest;
use App\Http\Resources\AdminCollection;
use App\Http\Resources\AdminResource;
use App\Models\Admin;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Hash;

class AdministratorController extends Controller
{
    /**
     * User: @Liao Yi
     * DateTime: 2021/12/20 15:20
     * Describe:
     * @param Request $request
     * @param Admin $admin_model
     * @return \Illuminate\Http\JsonResponse
     */
    public function index(Request $request)
    {

        $list = Admin::fromTable(1)->orderBy('id','desc')->get();
        return $this->data($list);
    }
 }