File: /var/www/ivs.kaunokolegija.lt/laravel/app/Http/Controllers/Admin/UsersController.php
<?php
namespace App\Http\Controllers\Admin;
use App\Http\Controllers\Controller;
use App\Http\Requests\MassDestroyUserRequest;
use App\Http\Requests\StoreUserRequest;
use App\Http\Requests\UpdateUserRequest;
use App\Models\Department;
use App\Models\DepartmentSubsection;
use App\Models\Role;
use App\Models\User;
use Gate;
use Illuminate\Http\Request;
use Symfony\Component\HttpFoundation\Response;
use Yajra\DataTables\Facades\DataTables;
class UsersController extends Controller
{
public function index(Request $request)
{
abort_if(Gate::denies('user_access'), Response::HTTP_FORBIDDEN, '403 Forbidden');
if ($request->ajax()) {
$query = User::with(['roles', 'departments', 'departmentsubsections'])->select(sprintf('%s.*', (new User)->table));
$table = Datatables::of($query);
$table->addColumn('placeholder', ' ');
$table->addColumn('actions', ' ');
$table->editColumn('actions', function ($row) {
$viewGate = 'user_show';
$editGate = 'user_edit';
$deleteGate = 'user_delete';
$crudRoutePart = 'users';
return view('partials.datatablesActions', compact(
'viewGate',
'editGate',
'deleteGate',
'crudRoutePart',
'row'
));
});
$table->editColumn('id', function ($row) {
return $row->id ? $row->id : '';
});
$table->editColumn('name', function ($row) {
return $row->name ? $row->name : '';
});
$table->editColumn('email', function ($row) {
return $row->email ? $row->email : '';
});
$table->editColumn('phone', function ($row) {
return $row->phone ? $row->phone : '';
});
$table->editColumn('roles', function ($row) {
$labels = [];
foreach ($row->roles as $role) {
$labels[] = sprintf('<span class="label label-info label-many">%s</span>', $role->title);
}
return implode(' ', $labels);
});
$table->editColumn('department', function ($row) {
$labels = [];
foreach ($row->departments as $department) {
$labels[] = sprintf('<span class="label label-info label-many">%s</span>', $department->name);
}
return implode(' ', $labels);
});
$table->editColumn('departmentsubsection', function ($row) {
$labels = [];
foreach ($row->departmentsubsections as $departmentsubsection) {
$labels[] = sprintf('<span class="label label-info label-many">%s</span>', $departmentsubsection->name);
}
return implode(' ', $labels);
});
$table->rawColumns(['actions', 'placeholder', 'roles', 'department', 'departmentsubsection']);
return $table->make(true);
}
$roles = Role::get();
$departments = Department::get();
$department_subsections = DepartmentSubsection::get();
return view('admin.users.index', compact('roles', 'departments', 'department_subsections'));
}
public function create()
{
abort_if(Gate::denies('user_create'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$roles = Role::pluck('title', 'id');
$departments = Department::pluck('name', 'id');
$departmentsubsections = DepartmentSubsection::pluck('name', 'id');
return view('admin.users.create', compact('departments', 'departmentsubsections', 'roles'));
}
public function store(StoreUserRequest $request)
{
$user = User::create($request->all());
$user->roles()->sync($request->input('roles', []));
$user->departments()->sync($request->input('departments', []));
$user->departmentsubsections()->sync($request->input('departmentsubsections', []));
return redirect()->route('admin.users.index');
}
public function edit(User $user)
{
abort_if(Gate::denies('user_edit'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$roles = Role::pluck('title', 'id');
$departments = Department::pluck('name', 'id');
$departmentsubsections = DepartmentSubsection::pluck('name', 'id');
$user->load('roles', 'departments', 'departmentsubsections');
return view('admin.users.edit', compact('departments', 'departmentsubsections', 'roles', 'user'));
}
public function update(UpdateUserRequest $request, User $user)
{
$user->update($request->all());
$user->roles()->sync($request->input('roles', []));
$user->departments()->sync($request->input('departments', []));
$user->departmentsubsections()->sync($request->input('departmentsubsections', []));
return redirect()->route('admin.users.index');
}
public function destroy(User $user)
{
abort_if(Gate::denies('user_delete'), Response::HTTP_FORBIDDEN, '403 Forbidden');
$user->delete();
return back();
}
public function massDestroy(MassDestroyUserRequest $request)
{
$users = User::find(request('ids'));
foreach ($users as $user) {
$user->delete();
}
return response(null, Response::HTTP_NO_CONTENT);
}
}