Eloquent反向预加载问题：基于动态表的预加载需求

Hey Jeff, let's tackle this Eloquent preloading issue with your dynamic table. I’ve run into similar scenarios before, so here’s how you can get that exact collection structure you need—each entry with outer diameter, material, and an array of manufacturer part numbers.

First, Confirm Your Model Relationships #

Assuming your database structure looks like this (adjust names to match your actual tables):

• A dynamic part_specifications table storing outer_diameter, material, and a primary key (e.g., id)
• A manufacturer_parts table with part_specification_id (foreign key to the dynamic table) and manufacturer_part_number

Define these relationships in your models:

// app/Models/PartSpecification.php
class PartSpecification extends Model
{
    protected $table = 'part_specifications'; // Your dynamic table name

    public function manufacturerParts()
    {
        return $this->hasMany(ManufacturerPart::class, 'part_specification_id');
    }
}

// app/Models/ManufacturerPart.php
class ManufacturerPart extends Model
{
    protected $table = 'manufacturer_parts';

    public function partSpecification()
    {
        return $this->belongsTo(PartSpecification::class, 'part_specification_id');
    }
}

The Eloquent Query to Get Your Desired Structure #

This query uses preloading to avoid N+1 database issues, then transforms the collection into your exact desired format:

$partCollection = PartSpecification::select('id', 'outer_diameter', 'material')
    // Preload only the fields we need from the related manufacturer parts
    ->with(['manufacturerParts' => function ($query) {
        $query->select('part_specification_id', 'manufacturer_part_number');
    }])
    ->get()
    // Map the results to the structure you want
    ->map(function ($spec) {
        return [
            'outer_diameter' => $spec->outer_diameter,
            'material' => $spec->material,
            'manufacturer_part_numbers' => $spec->manufacturerParts->pluck('manufacturer_part_number')->toArray()
        ];
    });

Key Notes to Avoid Common Pitfalls #

• Always include foreign keys in selects: When using select() on the parent model, don’t forget to include the primary key (id here)—Eloquent needs it to match related records during preloading.
• Limit preloaded fields: The closure in with() ensures we only fetch the necessary fields from manufacturer_parts, keeping the query efficient.
• Dynamic table adjustments: If your dynamic table has variable fields, you can replace the explicit select() with get() (but still include the primary key) to fetch all available fields, then adjust the map() closure to include them.

If Your Core Model Is Different #

If your main entry point is a Part model (instead of the dynamic specs table), adjust the query like this:

$partCollection = Part::with([
    'specification:id,part_id,outer_diameter,material', // Preload dynamic specs
    'manufacturerParts:id,part_id,manufacturer_part_number' // Preload part numbers
])
->get()
->map(function ($part) {
    return [
        'outer_diameter' => $part->specification->outer_diameter,
        'material' => $part->specification->material,
        'manufacturer_part_numbers' => $part->manufacturerParts->pluck('manufacturer_part_number')->toArray()
    ];
});

Just make sure your Part model has the correct specification (belongsTo) and manufacturerParts (hasMany) relationships defined.

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