HEX
Server: Apache/2.4.58 (Ubuntu)
System: Linux ip-172-26-0-120 6.17.0-1009-aws #9~24.04.2-Ubuntu SMP Fri Mar 6 23:50:29 UTC 2026 x86_64
User: ubuntu (1000)
PHP: 8.3.6
Disabled: NONE
Upload Files
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);
        }
    }
}