File: /var/www/vhost/disk-apps/qas.sports-crowd.com/app/Http/Controllers/RolePermissionController.php
<?php
namespace App\Http\Controllers;
use App\Module;
use App\ModuleRol;
use DataTables;
use App\Rol;
use App\RoleTerm;
use App\Term;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Facades\DB;
class RolePermissionController extends Controller
{
public function index()
{
return view('roles_permissions.list');
}
public function indexAdd()
{
$terms = Term::where('active', true)
->where('type','web')
->pluck('version', 'id');
$instance = new Module();
$modules = json_encode($instance->modulesTree());
return view('roles_permissions.create', compact('modules', 'terms'));
}
public function indexEdit($id)
{
$object = Rol::where('id', $id)->with('role_terms')->first();
if (!$object) {
throw new \Exception(__('messages.role_not_found'));
}
$terms = Term::where('active', true)
->where('type','web')
->pluck('version', 'id');
if ($object->route) {
$module = Module::where('route', substr($object->route, 1))->first();
if ($module)
$object->route = $module->name;
}
$instance = new Module();
$modules = json_encode($instance->modulesTree());
$selectedModules = ModuleRol::where('rol_id', $id)->orderBy('order')->pluck('module_id');
return view('roles_permissions.edit', compact('object', 'modules', 'selectedModules', 'terms'));
}
public function tableFilter()
{
$modules = Module::select('id', 'name', 'route', 'module_id')->get();
DB::statement("SET sql_mode = ''");
$obj = Rol::select(
'rols.id',
'rols.name',
'rols.route',
DB::raw('GROUP_CONCAT(modules.id ORDER BY module_rols.order ASC) AS modules'),
'rols.created_at',
'rols.active',
'terms.version'
)
->leftjoin('module_rols', 'module_rols.rol_id', '=', 'rols.id')
->leftjoin('modules', 'modules.id', '=', 'module_rols.module_id')
->leftjoin('role_terms', 'role_terms.role_id', '=', 'rols.id')
->leftjoin('terms', 'terms.id', '=', 'role_terms.term_id')
->groupBy('rols.id','terms.version');
DB::statement("SET sql_mode = 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'");
return DataTables::of($obj)
->addColumn('actions', function ($obj) {
return '
<i class="fa fa-pencil iconMini" onClick="clickEdit(' . $obj->id . ')" data-id="' . $obj->id . '" title="Editar"></i>
<i class="fa fa-trash iconMini" onClick="clickDelete(' . $obj->id . ')" data-id="' . $obj->id . '" title="Eliminar"></i>
';
})
->editColumn('active', function ($obj) {
if ($obj->active == 0) {
return '<div class="switch"><label><div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chk(' . $obj->id . ')" data-id="' . $obj->id . '" id="Checkactive' . $obj->id . '" name="Checkactivo" /> <span></span>' . __('messages.yes') . ' </label></div> </label> </div>';
} else {
return '<div class="switch"><label> <div class="checkbox checbox-switch switch-success"> <label> ' . __('messages.no') . ' <input type="checkbox" onChange="chk(' . $obj->id . ')" data-id="' . $obj->id . '" id="Checkactive' . $obj->id . '" name="Checkactivo" checked="" />
<span></span> ' . __('messages.yes') . ' </label> </div> </label> </div>';
}
})
->editColumn('route', function ($obj) use ($modules) {
$route = $obj->route;
if ($route) {
$route = substr($route, 1);
$data = $modules->where('route', $route)->first();
if ($data)
$route = $data->name;
}
return $route;
})
->editColumn('modules', function ($obj) use ($modules) {
$response = '<ul>';
$assignedModules = $obj->modules;
if ($assignedModules) {
$response = '<ul class="scroll-ul">';
$level = 1;
$previousParentModule = '';
$parentsModule = [];
foreach (explode(',', $assignedModules) as $item) {
$data = $modules->where('id', $item)->first();
$moduleName = $data->name;
if ($data->module_id) {
if ($data->module_id == $previousParentModule) {
$response .= '<li>' . $moduleName . '</li>';
} else {
if (in_array($data->module_id, $parentsModule)) {
$level--;
$previousParentModule = $data->module_id;
$response .= '</ul> <li>' . $moduleName . '</li>';
} else {
$level++;
$previousParentModule = $data->module_id;
$parentsModule[] = $previousParentModule;
$response .= '<ul> <li>' . $moduleName . '</li>';
}
}
} else {
if ($level > 1) {
$closeUl = '</ul>';
$response .= str_repeat($closeUl, $level - 1);
$level = 1;
}
$response .= '<li>' . $moduleName . '</li>';
}
}
}
$response .= '</ul>';
return $response;
})
->editColumn('created_at', function ($obj) {
return \Carbon\Carbon::parse($obj->created_at)->format('Y-m-d h:i:s A');
})
->rawColumns(['actions', 'active', 'route', 'modules'])
->make(true);
}
public function create(Request $request)
{
try {
if (Rol::where('name', $request->input('name'))->first()) {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('name')]), "data" => null));
} else if (!$request->input('selectedModules')) {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => 'Es necesario que se asignen "Permisos (módulos)" al rol.', "data" => null));
}
$data = $request->only('name', 'route');
if ($data['route']) {
$module = Module::where('name', $data['route'])->first();
if ($module)
$data['route'] = '/' . $module->route;
}
if ($model = Rol::create($data)) {
$term_id = $request->input('term_id');
if ($term_id !== null) {
$role_term = new RoleTerm();
$role_term->term_id = $term_id;
$role_term->role_id = $model->id;
$role_term->save();
}
if ($request->input('selectedModules')) {
foreach (explode(',', $request->input('selectedModules')) as $key => $module) {
if ($module) {
$data = new ModuleRol();
$data->rol_id = $model->id;
$data->module_id = $module;
$data->order = $key + 1;
$data->save();
}
}
}
$this->registerLog(Auth::user()->id, 'Crear rol', json_encode($request->all()), "Create", $this->getModule($request));
return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.created_successfully'), "data" => $model->id));
} else {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_creating'), "data" => null));
}
} catch (\Exception $e) {
return response(
array(
"r" => false,
"type" => "error",
"title" => "Oops...",
"m" => __($e->getMessage()),
"data" => null
)
);
}
}
public function update(Request $request, $id)
{
try {
$term_id = $request->input('term_id');
if ($term_id !== null) {
$role_term = RoleTerm::where('role_id', $id)->first();
if ($role_term) {
$role_term->term_id = $term_id;
$role_term->save();
} else {
$role_term = new RoleTerm();
$role_term->term_id = $term_id;
$role_term->role_id = $id;
$role_term->save();
}
}
$request['id'] = $id;
if (Rol::where([['id', '!=', $id], ['name', $request->input('name')]])->first()) {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.already_exists', ['name' => $request->input('name')]), "data" => null));
} else if (!$request->input('selectedModules')) {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => 'Es necesario que se asignen "Permisos (módulos)" al rol.', "data" => null));
}
$data = $request->only('name', 'route');
if ($data['route']) {
$module = Module::where('name', $data['route'])->first();
if ($module)
$data['route'] = '/' . $module->route;
}
if (Rol::where('id', $id)->update($data)) {
if ($request->input('selectedModules')) {
ModuleRol::where('rol_id', $id)->delete();
foreach (explode(',', $request->input('selectedModules')) as $key => $module) {
if ($module) {
$data = new ModuleRol();
$data->rol_id = $id;
$data->module_id = $module;
$data->order = $key + 1;
$data->save();
}
}
}
$this->registerLog(Auth::user()->id, 'Editar rol', json_encode($request->all()), "Update", $this->getModule($request));
return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.updated_successfully'), "data" => $id));
} else {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_updating'), "data" => null));
}
} catch (\Exception $e) {
return response(
array(
"r" => false,
"type" => "error",
"title" => "Oops...",
"m" => __($e->getMessage()),
"data" => null
)
);
}
}
public function delete(Request $request, $id)
{
try {
$rol = Rol::find($id);
if (Rol::where('id', $id)->delete()) {
$this->registerLog(Auth::user()->id, 'Eliminar rol', json_encode($rol), "Delete", $this->getModule($request));
return response(array("r" => true, "type" => "success", "title" => "", "m" => __('messages.deleted_successfully'), "data" => null));
} else {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.error_removing'), "data" => null));
}
} catch (\Illuminate\Database\QueryException $e) {
return response(array("r" => false, "type" => "error", "title" => "Oops...", "m" => __('messages.delete_relation_data'), "data" => null));
}
}
public function activate(Request $request)
{
try {
$id = $request['id'];
$state = $request['state'];
$rol = Rol::find($id);
$rol->active = $state;
$rol->update();
$this->registerLog(Auth::user()->id, 'Activar/Desactivar rol', json_encode($rol), "Update", $this->getModule($request));
return array('r' => true, 'd' => null, 'm' => __('messages.updated_successfully'));
} catch (\Throwable $th) {
return array('r' => false, 'd' => null, 'm' => __('messages.error_updating'));
}
}
}