<?php
namespace App\Http\Controllers;
use App\Models\Menurole;
use App\Models\RoleHierarchy;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use Spatie\Permission\Models\Role;
class RolesController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$roles = DB::table('roles')
->leftJoin('role_hierarchy', 'roles.id', 'role_hierarchy.role_id')
->select('roles.*', 'role_hierarchy.hierarchy')
->orderBy('hierarchy', 'asc')
->get();
return view("roles.index")->with(compact('roles'));
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
return view('roles.create');
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$role = new Role();
$role->name = $request->input('name');
$role->save();
$hierarchy = RoleHierarchy::select('hierarchy')
->orderBy('hierarchy', 'desc')->first();
if (empty($hierarchy)) {
$hierarchy = 0;
} else {
$hierarchy = $hierarchy['hierarchy'];
}
$hierarchy = ((int)$hierarchy) + 1;
$roleHierarchy = new RoleHierarchy();
$roleHierarchy->role_id = $role->id;
$roleHierarchy->hierarchy = $hierarchy;
$roleHierarchy->save();
$request->session()->flash('message', 'Successfully created role');
return redirect()->route('roles.create');
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
return view('roles.show', array(
'role' => Role::where('id', $id)->first()
));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
return view('roles.edit', array(
'role' => Role::where('id', $id)->first()
));
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$role = Role::where('id', $id)->first();
$role->name = $request->input('name');
$role->save();
$request->session()->flash('message', 'Successfully updated role');
return redirect()->route('roles.edit', $id);
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy(Request $request, $id)
{
$role = Role::where('id', '=', $id)->first();
$roleHierarchy = RoleHierarchy::where('role_id', $id)->first();
$menuRole = Menurole::where('role_name', $role->name)->first();
if (!empty($menuRole)) {
$request->session()->flash('message', "Can't delete. Role has assigned one or more menu elements.");
$request->session()->flash('back', 'roles.index');
return view('dashboard.shared.universal-info');
} else {
$role->delete();
$roleHierarchy->delete();
$request->session()->flash('message', "Successfully deleted role");
$request->session()->flash('back', 'roles.index');
return view('dashboard.shared.universal-info');
}
}
}