<?php

namespace App\Http\Controllers\user;

use App\Http\Controllers\Controller;
use App\Models\Role;
use App\Models\RolePermission;
use App\Models\UserModule;
use App\Models\UserRole;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Auth;
use Validator;
use Yajra\DataTables\Facades\DataTables;
use Illuminate\Validation\Rule;
use Illuminate\Support\Facades\DB;

class RoleController extends Controller
{
    /**
     * Display a listing of the resource.
     */
    public function index(Request $request)
    {
        if ($request->ajax()) {
            $search_keyword = '';

            $request_data = $request->all();
            if ($request->has('search_keyword')) {
                $search_keyword = $request->search_keyword;
            }
            // 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 = Role::query();

            $user = auth()->user();

$main_query = Role::query()
    ->where(function ($query) use ($user) {
      
        $query->where('created_by', '=', $user->id);

       
        if (!is_null($user->parent_id)) {
            $query->orWhere('created_by', '=', $user->parent_id);
        }

        
        if (!is_null($user->parent_id)) {
            $query->orWhereIn('created_by', function ($subQuery) use ($user) {
                $subQuery->select('id')
                    ->from('users')
                    ->where('parent_id', '=', $user->parent_id) 
                    ->where('id', '!=', $user->id);
            });
        }

        
        $query->orWhereIn('created_by', function ($subQuery) use ($user) {
            $subQuery->select('id')
                ->from('users')
                ->where('parent_id', '=', $user->id); 
        });
    });



            $query = $main_query;
            if (!empty($search_keyword)) {
                $query = $query->where('name', 'LIKE', '%' . $search_keyword . '%');
            }
            if (!empty($sort_column_key)) {
                $query = $query->orderBy($sort_column_key, $sort_column_dir);
            } else {
                $query = $query->latest();
            }

            $data = $query->with('user')->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;
                })
                ->addColumn('created_by', function ($row) {
                    return isset($row->user) ? $row->user->first_name . $row->user->last_name : 'null';
                })

                ->addColumn('action', function ($row) {

                    return view('users.roles.partially.delete', compact('row'));
                })

                ->rawColumns(['action', 'created_by'])
                ->with([
                    "recordsTotal"    => $count_total,
                    "recordsFiltered" => $count_filter,
                ])
                ->make(true);
        }

        return view('users.roles.index');
    }

    /**
     * Show the form for creating a new resource.
     */
    public function create()
    {
        $user_modules = UserModule::with('permissions')->get();

        return view('users.roles.create', ['user_modules' => $user_modules]);
    }

    /**
     * Store a newly created resource in storage.
     */
    public function store(Request $request)
    {
        $validator = Validator::make($request->all(), [
            'name' => [
                'required',
                'string',
                Rule::unique('roles')->where(function ($query) {
                    return $query->where('created_by', auth()->id()); // Ensure the role name is unique per admin
                })
            ],
            'description' => 'required|string',
        ]);
        
        
        if ($validator->fails()) {
            return redirect()->back()->withErrors($validator)->withInput();
        }
        DB::beginTransaction();
        try {
            $user_role = new Role;
            $user_role->name = $request->input('name');
            $user_role->description = $request->input('description');

            $adminIds = getAdminId();
            $user_role->created_by = $adminIds->created_by;
            $user_role->save();


            $user_permissions = $request->input('permission');
            if (count($user_permissions)) {
                foreach ($user_permissions as $permission) {
                    $user_role_permission = new RolePermission();
                    $user_role_permission->role_id = $user_role->id;
                    $user_role_permission->permission_id = $permission;
                    $user_role_permission->save();
                    DB::commit();
                }
            }
            return redirect()->route('role.index')->with('success', 'Role added Successfully');
        } catch (\Exception $e) {
            DB::rollback();
            return response()->json(['success' => false, 'message' => $e->getMessage()]);
        }
    }

    /**
     * Display the specified resource.
     */
    public function show(string $id)
    {
        $user_role = Role::with('rolePermission')->find($id);
        $user_role_permission = [];
        $user_modules = UserModule::with('permissions')->get();
        $user_role_permission = $user_role->rolePermission->pluck('permission_id')->toArray();
        return view('users.roles.show', compact('user_role', 'user_modules', 'user_role_permission'));
    }

    /**
     * Show the form for editing the specified resource.
     */
    public function edit(string $id)
    {
        $user_role = Role::with('rolePermission')->find($id);
        // dd($user_role->rolePermission);

        $user_role_permission = []; // Initialize the variable outside the if condition

        if ($user_role && $user_role->rolePermission) {
            // Check if $user_role->rolePermissions is not null before counting
            $user_role_permission = $user_role->rolePermission->pluck('permission_id')->toArray();
        }

        $user_modules = UserModule::with('permissions')->get();


        if ($user_role) {
            return view('users.roles.edit', ['user_role' => $user_role, 'user_modules' => $user_modules, 'user_role_permission' => $user_role_permission]);
        } else {
            return back()->with('error', 'Role 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('roles')->ignore($id)],
            'description' => 'required|string',

        ]);

        if ($validator->fails()) {
            return redirect()->back()->withErrors($validator)->withInput();
        }


        DB::beginTransaction();
        try {
            $user_role = Role::find($id);
            if (isset($user_role)) {
                $user_role->name = $request->input('name');
                $user_role->description = $request->input('description');
                $user_role->save();

                $user_permissions = $request->input('permission');
                if (count($user_permissions)) {
                    RolePermission::where('role_id', $id)->delete();
                    foreach ($user_permissions as $permission) {

                        $user_role_permission = new RolePermission();
                        $user_role_permission->role_id = $user_role->id;
                        $user_role_permission->permission_id = $permission;
                        $user_role_permission->save();
                        DB::commit();
                    }
                }

                return redirect()->route('role.index')->with('success', 'Role has been updated successfully.');
            } else {
                return back()->with('error', 'Role not found.');
            }
        } catch (\Exception $e) {
            DB::rollback();
            return response()->json(['success' => false, 'message' => $e->getMessage()]);
        }
    }

    /**
     * Remove the specified resource from storage.
     */
    public function destroy(string $id)
    {
        $user_role = Role::find($id);
        if (isset($user_role)) {
            $user_role->delete();
            RolePermission::where('role_id', $id)->delete();
            // for delete role_id in userRole migration
            $user_role = UserRole::where('role_id', $id)->delete();
            return redirect()->back()->with('success', 'Role has been deleted successfully.');
        } else {
            return back()->with('error', 'Role not found.');
        }
    }
}