Polymorphic Many to Many Relationship

Polymorphic Many to Many Relationship

Demo details:

Business Rules:

Relations Diagram:

Relationship Details:

Eloquent Models:

class Valet
{
    public function cars()
    {
        return $this->morphToMany(Car::class, 'driver');
    }
}

class Owner
{
    public function cars()
    {
        return $this->morphToMany(Car::class, 'driver');
    }
}

class Car
{
    public function valets()
    {
        return $this->morphedByMany(Valet::class, 'driver');
    }

    public function owners()
    {
        return $this->morphedByMany(Owner::class, 'driver');
    }
}

Database Migrations:

Schema::create('valets', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name');
});

Schema::create('owners', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name');
});

Schema::create('drivers', function (Blueprint $table) {
    $table->increments('id');

    $table->integer('driver_id')->unsigned()->index();
    $table->string('driver_type');
    // or use $table->morphs(‘driver’); instead of "driver_id" and "driver_type"

    $table->integer('car_id')->unsigned()->index();
    $table->foreign('car_id')->references('id')->on('cars')->onDelete('cascade');
});

Store Records:

// Create relation between driver (Valet/Owner) and Car.

$valet->cars()->saveMany([$car1, $car2]);
$owner->cars()->saveMany([$car1, $car2]);

// Or use the save() function for single model.

$valet->cars()->save($car1);
$owner->cars()->save($car1);

// Create relation between Car and driver (Valet/Owner).

$car->valets()->attach([
    $valet1->id,
    $valet2->id,
]);

$car->owners()->attach([
    $owner1->id,
    $owner2->id,
]);

// Or use the sync() function to prevent duplicated relations.

$car->valets()->sync([
    $valet1->id,
    $valet2->id,
]);

$car->owners()->sync([
    $owner1->id,
    $owner2->id,
]);

Retrieve Records:

// Get driver (Valet/Owner) Cars

$valet->cars
$owner->cars

// Get Car drivers (Valet and Owner)

$car->owners
$car->valets