如何利用像素资源laravel将多个关系合并成一维数组？

Question

关系的定义如下：

class Rfid extends Model
{
    use HasFactory;

    public function logs()
    {
        return $this->hasMany('App\Models\ComponentLog', 'rfid_id');
    }
}

class ComponentLog extends Model
{
    use HasFactory;

    public function reader()
    {
        return $this->belongsTo('App\Models\RfidReader','rfid_reader_id');
    }
}

class RfidReader extends Model implements AuthenticatableContract
{
    use HasFactory;
    use HasApiTokens;
    use Authenticatable;

    public function department()
    {
        return $this->belongsTo('App\Models\Department', 'department_id');
    }
}

在查询时，Rfid::with('logs.reader.department')->get()给出了如下结果：

App\Models\Rfid {#4554
         id: 13,
         RFID: "KDtCgimCJJ",
         department_id: 6,
         component_id: 13,
         created_at: "2020-10-12 10:48:32",
         updated_at: "2020-10-12 10:48:32",
         logs: Illuminate\Database\Eloquent\Collection {#4599
           all: [
             App\Models\ComponentLog {#4576
               id: 13,
               rfid_id: 13,
               check_in: "2020-10-12 10:48:32",
               check_out: null,
               rfid_reader_id: 4,
               created_at: null,
               updated_at: null,
               reader: App\Models\RfidReader {#4421},
             },
           ],
         },
       },...

然而，我希望它的关系被合并使用芹菜资源。

Answer 1

步骤1:定义ComponentLog -> Rfid belongsTo关系

class ComponentLog extends Model
{
    use HasFactory;

    public function reader()
    {
        return $this->belongsTo('App\Models\RfidReader','rfid_reader_id');
    }

    public function rfid()
    {
        return $this->belongsTo('App\Models\Rfid', 'rfid_id');
    }
}

步骤2:从ComponentLog获得结果以避免hasMany关系

$logs = ComponentLog::with(['rfid', 'reader.department'])->get();

步骤3:映射结果

$logs->transform(function ($log) {
    return [
        'rfid' => $log->rfid->rfid,
        'department_name' => $log->reader->department->department_name,
        'rfid_reader_id' => $log->rfid_reader_id,
        'check_in' => $log->check_in,
        'check_out' => $log->check_out
    ];
});

你也可以内联.

$logs = ComponentLog::with(['rfid', 'reader.department'])
->get()
->transform(function ($log) {
    return [
        'rfid' => $log->rfid->rfid,
        'department_name' => $log->reader->department->department_name,
        'rfid_reader_id' => $log->rfid_reader_id,
        'check_in' => $log->check_in,
        'check_out' => $log->check_out
    ];
});