laravel - Eloquent -如何在hasMany关系中添加联接？

Question

我有一个典型的hasMany方法:

public function earmarks() {
    return $this->hasMany('App\Earmark');
}

但是，当我使用 ->with('earmarks')检索它们时，如何为该关系添加联接和一些其他条件？我要添加:

->join('locations', 'locations.id', '=', 'earmarks.location')
->select('earmarks.*', 'locations.location AS em_location')
->orderBy('date', 'asc');

Answer 1

OK，发现我需要在with()子句中关闭，如下所示:

    $updated_laptops = Laptop::with([
        'earmarks' => function($q) {
            $q
            ->join('locations', 'locations.id', '=', 'earmarks.location')
            ->select('earmarks.*', 'locations.location AS em_location')
            ->orderBy('date', 'asc');
        }
    ])->addJoins()->selectListCols()->find($request->IDs)->keyBy('id');