File: /var/www/html/owlcrm/app/Http/Controllers/admin/PermissionController.php
<?php
namespace App\Http\Controllers\admin;
use App\Http\Controllers\Controller;
use App\Models\SuperPermission;
use Yajra\DataTables\DataTables;
use App\Models\Module;
use App\Models\SuperRolePermission;
use Illuminate\Validation\Rule;
use Validator;
use Illuminate\Http\Request;
class PermissionController extends Controller
{
/**
* Display a listing of the resource.
*/
public function index(Request $request)
{
if ($request->ajax()) {
$search_keyword = '';
$status = 'all'; // all status
$request_data = $request->all();
if ($request->has('search_keyword')) {
$search_keyword = $request->search_keyword;
}
if ($request->has('status_filter')) {
$status = $request->status_filter;
}
// avoid zero column as it's checkbox so we can't sort by it
if ($request->has('order') && $request->order[0]['column'] != 0) {
$sort_column_number = $request->order[0]['column'];
$sort_column_dir = $request->order[0]['dir'];
$sort_column_key = $request->columns[$sort_column_number]['data'];
}
$main_query = SuperPermission::query();
$query = $main_query;
if (!empty($search_keyword)) {
$query = $query->where('name', 'LIKE', '%' . $search_keyword . '%');
}
if ($status != 'all' && $status != '') {
$query = $query->where('status', $status);
}
if (!empty($sort_column_key)) {
$query = $query->orderBy($sort_column_key, $sort_column_dir);
} else {
$query = $query->latest();
}
$data = $query->with('module')->get();
$count_total = $main_query->count();
$count_filter = $count_total;
return DataTables::of($data)
->addColumn('name', function ($row) {
return $row->name;
})
->addColumn('description', function ($row) {
return $row->description;
})
->editColumn('status', function ($row) {
$update_url = route('admin.update.permission.status', $row->id);
return setStatus($row, $update_url);
})
->addColumn('module', function ($row) {
if (isset($row->module)) {
return $row->module->name;
}
})
->addColumn('action', function ($row) {
return view('admin.Permissions.partially.delete', compact('row'));
})
->rawColumns(['action', 'status'])
->with([
"recordsTotal" => $count_total,
"recordsFiltered" => $count_filter,
])
->make(true);
}
return view('admin.permissions.index');
}
/**
* Show the form for creating a new resource.
*/
public function create()
{
$modules = Module::get();
return view('admin.permissions.create', ['modules' => $modules]);
}
/**
* Store a newly created resource in storage.
*/
public function store(Request $request)
{
$validator = Validator::make($request->all(), [
'name' => [
'required', 'string',
Rule::unique('super_permissions')->where(function ($query) use ($request) {
return $query->where('module_id', $request->input('module_id'));
})
],
'key' => 'required|string',
'description' => 'required|string',
]);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput();
}
$permission = new SuperPermission();
if (isset($permission)) {
$permission->name = $request->input('name');
$permission->key = $request->input('key');
$permission->description = $request->input('description');
$permission->status = $request->input('status');
$permission->module_id = $request->input('module_id');
$permission->save();
return redirect()->route('permission.index')->with('success', 'Permission Add Successfully');
} else {
return back()->with('error', 'Permission does not exist');
}
}
/**
* Display the specified resource.
*/
public function show(string $id)
{
//
}
/**
* Show the form for editing the specified resource.
*/
public function edit(string $id)
{
$permission = SuperPermission::find($id);
$modules = Module::get();
if (isset($permission)) {
return view('admin.Permissions.edit', ['permission' => $permission, 'modules' => $modules]);
} else {
return back()->with('error', 'Permission does not exist');
}
}
/**
* Update the specified resource in storage.
*/
public function update(Request $request, string $id)
{
$validator = Validator::make($request->all(), [
'name' => [
'required', 'string',
Rule::unique('super_permissions')->ignore($id)->where(function ($query) use ($request) {
return $query->where('module_id', $request->input('module_id'));
})
],
'key' => 'required|string',
'description' => 'required|string',
]);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput();
}
$permission = SuperPermission::find($id);
if (isset($permission)) {
$permission->name = $request->input('name');
$permission->key = $request->input('key');
$permission->description = $request->input('description');
$permission->status = $request->input('status');
$permission->module_id = $request->input('module_id');
$permission->save();
return redirect()->route('permission.index')->with('success', 'Permission has been updated successfully.');
} else {
return back()->with('error', 'Permission not found.');
}
}
/**
* Remove the specified resource from storage.
*/
public function destroy(string $id)
{
$permission = SuperPermission::find($id);
if (isset($permission)) {
$permission->delete();
// for delete permission_id in SuperRolePermission migration
$super_role_permission = SuperRolePermission::where('permission_id', $id)->delete();
return redirect()->back()->with('success', 'Permission has been deleted successfully.');
} else {
return back()->with('error', 'Permission does not exist');
}
}
public function updatePermissionStatus(Request $request, $id)
{
if ($request->has('new_status')) {
$permission = SuperPermission::find($id);
if ($permission) {
$permission->status = $request->new_status;
$permission->save();
return response()->json(['status' => 'success', 'message' => 'Permission status updated successfully']);
} else {
return response()->json(['status' => 'error', 'message' => 'permission not found'], 404);
}
} else {
return response()->json(['status' => 'error', 'message' => 'Missing status value'], 404);
}
}
}