Categoria: Laravel

USER -> ROLES

MODEL:

USER

public function roles()
{
    return $this->belongsToMany(Role::class);
}

ROLE

public function users()
{
    return $this->belongsToMany(User::class);
}

MIGRATION

public function up()
{
Schema::create('role_user', function (Blueprint $table) {
      $table->id();
      $table->bigInteger('user_id')->unsigned();
      $table->bigInteger('role_id')->unsigned();
      $table->timestamps();
      $table->foreign('user_id')->references('id')->on('users');
      $table->foreign('role_id')->references('id')->on('roles');
    });
}

USER CONTROLLER

class UserController extends Controller
{
public function __construct() {
$this->middleware(‘auth’);
}

public function index()
{
    $users = User::all();       
    return view('users.index', compact('users'));
}

/**
 * Show the form for creating a new resource.
 *
 * @return \Illuminate\Http\Response
 */
public function create()
{
     $roles = Role::all();
     return view('users.create',compact('roles'));
}

/**
 * Store a newly created resource in storage.
 *
 * @param  \Illuminate\Http\Request  $request
 * @return \Illuminate\Http\Response
 */
public function store(Request $request)
{
    $user = new User($request->all());
    $user->save();        
    $user->roles()->sync($request['role_id']);         

    return redirect(route('users.index'));
}

/**
 * Show the form for editing the specified resource.
 *
 * @param  int  $id
 * @return \Illuminate\Http\Response
 */
public function edit($id)
{
    $user = User::find($id); 
    $roles = Role::all();

    $array = array(
                'user'=> $user,
                'roles'=> $roles,                    
                );

    return view('users.edit',compact('array'));

}

/**
 * Update the specified resource in storage.
 *
 * @param  \Illuminate\Http\Request  $request
 * @param  int  $id
 * @return \Illuminate\Http\Response
 */
public function update(Request $request, $id)
{
    $user = User::find($id);         
    $input = $request->all();

    $user->update($input);

    $user->roles()->sync($input['role_id']);        
    //prende i role_id dalla request, e dice al model di User di sincronizzare la tabella pivot con i dati delle request

    return redirect(route('users.index'));
}



}

BLADE

{{ __(‘Role’) }}

        <div class="col-md-6">
            <select name="role_id[]" multiple>

                @foreach($array['roles'] as $v)
                <option value="{{$v->id}}" 

                        @foreach( $array['user']->roles->all() as $role)                        
                    @if ($v->id == $role->id)
                    selected
                    @endif
                    @endforeach   
                    >

                    {{$v->name}}

                </option>
                @endforeach
            </select>
        </div>

da questo post: https://stackoverflow.com/questions/30231862/laravel-eloquent-has-with-wherehas-what-do-they-mean

With

Carica l’oggetto, completo dell’oggetto agganciato via chiave esterna.
User > hasMany > Post

$users = User::with('posts')->get();
foreach($users as $user){
    $users->posts; // i post dell'utente sono già stati caricati con la query iniziale
}

Has

Per filtrare gli oggetti che hanno una certa relazione.

$users = User::has('posts')->get();
// solo utenti che hanno almeno un post

WhereHas

Per filtrare oggetti, in base alla proprietà di un oggetto referenziato.

$users = User::whereHas('posts', function($q){
    $q->where('created_at', '>=', '2015-01-01 00:00:00');
})->get();
// solo utenti che hanno post creati dopo il 2015