Categoria: Softwares

Per creare un legame molti a molti serve innanzitutto una tabella che leghi i due modelli, quindi vai di

MIGRATION

Schema::create('destination_user', function (Blueprint $table) {
        $table->id();
        $table->foreignId('user_id')->constrained()->onUpdate('cascade')->onDelete('cascade');
        $table->foreignId('destination_id')->constrained()->onUpdate('cascade')->onDelete('cascade');
        $table->timestamps();                                    
        $table->softDeletes();              
    });

quindi aggiorniamo i:

MODEL

class User extends Authenticatable
{
    public function destinations()
    {
        return $this->belongsToMany(Destination::class);
    }
}

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

e ora modifichiamo i blade:

CREATE BLADE

<div class="row mb-3" style="display: none" id="destinations_select">
  <label for="destinations_id" class="col-md-4 col-form-label text-md-right">{{ __('Destinations access') }}</label>

<div class="col-md-6">                       
 <select name="destinations_id" id="destinations_id" multiple class="form-select" >    
   @foreach($array['destinations'] as $destination)                                    
     <option value="{{$destination->id}}"  @if ($array['filter']->input('destinations_id') == $destination->id) selected @endif >
      {{ __($destination->name) }}</option>                                    
   @endforeach
 </select> 
</div>
</div> 

EDIT BLADE

<select name="destinations_id[]" id="destinations_id" multiple class="form-select" >    
 @foreach($array['destinations'] as $destination) 
  <option value="{{$destination->id}}" 
     @foreach ($array['user']->destinations->all() as $us_destination)  
        @if ($destination->id == $us_destination->id) selected @endif 
     @endforeach 
  >{{__($destination->name)}}</option> 
 @endforeach 
</select>

STORE CONTROLLER

$user = new User($input);
$user->push();    

UPDATE CONTROLLER

$user->destinations()->sync($input['destinations_id']);