database/migrations/2018_09_27_100017_update_rules.php
<?php
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
use App\Models\Role;
use App\Models\Rule;
class UpdateRules extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$user_role_id = 2;
$manager_role_id = 5;
$blocked_role_id = 255;
$role_ids = Role::where('id', '<>', $blocked_role_id)
->pluck('id')
->toArray();
if (in_array($user_role_id, $role_ids)) {
// Allows users to edit time intervals.
// (Needed to change tasks on programmer's dashboard.)
Rule::updateOrCreate([
'role_id' => $user_role_id,
'object' => 'time-intervals',
'action' => 'edit',
], [
'allow' => true,
]);
}
if (in_array($manager_role_id, $role_ids)) {
// Allows manager access to the dashboard,
// project report, screenshots, time intervals.
$new_manager_rules = [
['dashboard', 'manager_access'],
['project-report', 'manager_access'],
['screenshots', 'manager_access'],
['time-intervals', 'manager_access'],
];
foreach ($new_manager_rules as $rule) {
[$object, $action] = $rule;
Rule::updateOrCreate([
'role_id' => $manager_role_id,
'object' => $object,
'action' => $action,
], [
'allow' => true,
]);
}
}
// Allows all roles to show time use report and time duration.
$new_rules = [
['time-use-report', 'list'],
['time-duration', 'list'],
];
foreach ($role_ids as $role_id) {
foreach ($new_rules as $rule) {
[$object, $action] = $rule;
Rule::updateOrCreate([
'role_id' => $role_id,
'object' => $object,
'action' => $action,
], [
'allow' => true,
]);
}
}
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
}
}