/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create(config('guardian.table.permission'), function (Blueprint $table) {
$table->increments('id');
$table->string('name')->unique();
$table->string('table');
$table->string('foreign_id_column');
$table->string('user_id_column');
$table->timestamps();
});
Schema::create(config('guardian.table.role'), function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->boolean('locked')->default(false);
if (Guardian::hasClients()) {
$table->integer(Guardian::getClientColumn())->unsigned();
}
$table->timestamps();
if (Guardian::hasClients()) {
$table->foreign(Guardian::getClientColumn())->references(Guardian::getClientKey())->on(Guardian::getClientTable())->onDelete('cascade');
}
});
Schema::create(config('guardian.table.role') . '_' . config('guardian.table.permission'), function (Blueprint $table) {
$table->integer('permission_id')->unsigned();
$table->integer('role_id')->unsigned();
$table->timestamps();
$table->foreign('permission_id')->references('id')->on(config('guardian.table.permission'))->onDelete('cascade');
$table->foreign('role_id')->references('id')->on(config('guardian.table.role'))->onDelete('cascade');
});
Schema::create(Guardian::getUserTable() . '_' . config('guardian.table.role'), function (Blueprint $table) {
$table->integer('user_id')->unsigned();
$table->integer('role_id')->unsigned();
$table->timestamps();
$table->foreign('user_id')->references(Guardian::getUserKey())->on(Guardian::getUserTable())->onDelete('cascade');
$table->foreign('role_id')->references('id')->on(config('guardian.table.role'))->onDelete('cascade');
});
}
/**
* Create a new Permission controller instance.
*
* PermissionsController constructor.
*/
public function __construct()
{
$this->rules = ['name' => 'required|unique:' . Guardian::getPermissionTable()];
}
/**
* Get all roles the user is attached to.
*
* @return EloquentCollection
*/
public function roles()
{
return $this->belongsToMany(Role::class, Guardian::getUsersRolesTable());
}
/**
* Create a new Permission model instance.
*
* @param array $attributes
*/
public function __construct(array $attributes = [])
{
$this->table = Guardian::getPermissionTable();
parent::__construct($attributes);
}
/**
* Scope to require client ID is met.
*
* @param $query
* @return mixed
*/
public function scopeClient($query)
{
if (!Guardian::hasClients()) {
return $query;
}
return $query->where('client_id', Guardian::getClientId());
}
