Laravel中如何实现Card与Service的hasMany关联？含数据库结构及代码调整

Hey there! Let's walk through how to convert your single-service-per-card setup to allow a Card to have multiple Services in Laravel. This calls for a many-to-many relationship (since a Service might be linked to multiple Cards too, which is a common use case). Here's the step-by-step breakdown:

First, we need to get rid of the single service_id column on the cards table and create a pivot table to handle the many-to-many links between Cards and Services.

1. Remove the service_id column from cards
   Generate a migration to drop the column:

   php artisan make:migration remove_service_id_from_cards_table --table=cards
   

   Open the new migration file and update it like this:

   public function up()
   {
       Schema::table('cards', function (Blueprint $table) {
           // Drop the foreign key constraint first (if you added one originally)
           if (Schema::hasColumn('cards', 'service_id')) {
               $table->dropForeign(['service_id']);
               $table->dropColumn('service_id');
           }
       });
   }
   
   public function down()
   {
       Schema::table('cards', function (Blueprint $table) {
           $table->foreignId('service_id')->constrained();
       });
   }
   

2. Create the pivot table (card_service)
   Laravel follows a naming convention for pivot tables: use the singular names of both models, ordered alphabetically. Generate the migration:

   php artisan make:migration create_card_service_table
   

   Update the migration to define the pivot columns with foreign keys:

   public function up()
   {
       Schema::create('card_service', function (Blueprint $table) {
           $table->foreignId('card_id')->constrained()->onDelete('cascade');
           $table->foreignId('service_id')->constrained()->onDelete('cascade');
           // Add a composite primary key to prevent duplicate links between the same Card and Service
           $table->primary(['card_id', 'service_id']);
       });
   }
   
   public function down()
   {
       Schema::dropIfExists('card_service');
   }
   

3. Run the migrations
   Execute the migrations to apply these changes:

   php artisan migrate
   

Now, define the many-to-many relationships in your Card and Service models.

In app/Models/Card.php: #

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;

class Card extends Model
{
    // ... existing code

    public function services(): BelongsToMany
    {
        return $this->belongsToMany(Service::class);
    }
}

(Optional) In app/Models/Service.php (for reverse lookup): #

If you need to fetch all Cards linked to a Service, add this reverse relationship:

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsToMany;

class Service extends Model
{
    // ... existing code

    public function cards(): BelongsToMany
    {
        return $this->belongsToMany(Card::class);
    }
}

Your original code only handles a single service_id, so we need to adjust it to accept an array of service IDs and link them to the new Card.

public function store(Request $request) { 
    $validator = \Validator::make($request->all(), [ 
        'user_id' => 'required|unique:cards|exists:users,id', 
        // Update validation to accept an array of valid Service IDs
        'service_id' => 'required|array|exists:services,id', 
        'numPhone' => 'required', 
        'location' => 'required', 
    ],[],[ 
        'user_id' => '( User id )', 
        'service_id' => 'service id', 
        'numPhone' => 'Phone Number', 
    ]); 

    if ($validator->fails()){ 
        return $this->apiResponse(null, $validator->errors()->all(), 'Some input required'); 
    } 

    // Create the Card without the service_id array (we'll link them separately)
    $card = Card::create($request->except('service_id')); 

    // Attach all the selected Services to the Card
    $card->services()->attach($request->service_id); 

    return $this->apiResponse(new CardResource($card), 'Add card Successfully', 201); 
}

If you want your API response to include the linked Services, update your CardResource to load and return them:

namespace App\Http\Resources;

use Illuminate\Http\Resources\Json\JsonResource;

class CardResource extends JsonResource
{
    public function toArray($request)
    {
        return [
            'id' => $this->id,
            'user_id' => $this->user_id,
            'numPhone' => $this->numPhone,
            'location' => $this->location,
            // Load the related Services (use whenLoaded to avoid eager loading unnecessarily)
            'services' => ServiceResource::collection($this->whenLoaded('services')),
            // ... any other fields you want to return
        ];
    }
}

Just make sure you have a ServiceResource defined to format the Service data properly!

内容的提问来源于stack exchange，提问作者user12016340