<?php

use Illuminate\Database\Seeder;
use Illuminate\Support\Facades\DB;
use App\Models\{Role, Permission};

class PermissionOrdersSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $roles = Role::where('slug', '<>', Role::admin)->get();
        $permission =             [
            "name"=>'Управление заявками',
            "slug"=>'orders',
            "description"=>'Возможность создавать, редактировать и удалять заявки'
        ];

        $id = DB::table('permissions')->insertGetId($permission);

        foreach ($roles as $role)
        {

            /** @var Permission $permission */
            DB::table('roles_permissions')
                ->insert(
                    [
                        "permission_id"=>$id,
                        "role_id"=>$role->id
                    ]
                );
        }
    }
}