role

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use DB;
use App\User;


class PermissionsController extends Controller
{
   public function index(){
      $permissions = DB::select('select * from permissions');
      // $roles = DB::select('select * from roles');
      $users=User::all();
      $roles = DB::table('users')->join('model_has_roles','model_has_roles.model_id','users.id')
      ->join('roles','roles.id','model_has_roles.role_id')->select('*')
      ->get();
      // dd($roles);
      return view('permission.index')->with('permissions',$permissions)->with('roles', $roles)->with('users',$users);
   }
   public function add(){
      $user->assignRole('writer');
      // $permission=Permission::findByID(4);
      // auth()->user()->hasAllRoles(Role::all());

   }
   public function dependent(Request $request){
         $select=$request->get('select');
         // $value=$request->get('value');

      //    if(!$request->ajax()){
      //       return response()->json(['status'=>'Ajax request fail']);
      //   }
      //   else return response()->json($value);


         $value=$request->get('value');
         $dependent=$request->get('dependent');
         $permissions=DB::table('roles')->join('role_has_permissions','role_has_permissions.role_id','roles.id')
         ->join('permissions','permissions.id','role_has_permissions.permission_id')->select('*')->get();
         dd($permissions);
         $output='<div class="chip">'.


               '</div>';
         foreach($permissions as $permission){
         $output.='<div class="chip">'
                                .$permission->name.

                        '</div>';
         }
          echo $output;
}
}