如何从Laravel 7中的多个模型中获得查询结果？

Question

我有两个模型奖学金和水平，他们有多对多的关系。为此，我在数据库中有两个表作为奖学金和级别，还有一个数据透视表级别。我想根据奖学金（头衔、申请截止日期）和级别（姓名）查询是否获得奖学金

柱：

我的级别表有：id、名称、slug、创建时间、更新时间

我的奖学金表有：id，标题，段塞，描述，图像，大学，app_deadline，截止日期，备注，place_id，created_at，updated_at

和级别奖学金有：id，奖学金id，级别id，创建时间，更新时间

我的奖学金模式

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Scholarship extends Model
  {

      public function levels(){
        return $this->belongsToMany('App\Level')->withTimestamps();
      }

}

我的关卡模型

<?php

  namespace App;

  use Illuminate\Database\Eloquent\Model;

  class Level extends Model
     {
        public function scholarships(){
          return $this->belongsToMany('App\Scholarship')->withTimestamps();
     }
  }

我可以查询奖学金模型，但如何关联级别模型

 $query = $request->input('query');

    $field = Field::where('title','LIKE',"%$query%")->first();
    $fieldId = $field->id;

    $scholarships = $field->scholarships()->latest()->paginate(10);;

    $scholarship = Scholarship::where('title','LIKE',"%$query%")
        ->orWhere('app_deadline','LIKE',"%$query%")
        ->orWhere(scholarship()->levels()->name,'LIKE',"%$query%")
        ->latest()->get();

Answer 1

您可以这样做：

 $query = $request->input('query');
 $field = Field::where('title','LIKE','%' . $query. '%')->first();
 $fieldId = $field->id;
 $scholarships = $field->scholarships()->latest()->paginate(10);

 $scholarship = Scholarship::whereHas('levels' , function($q) use($query) {
      $q->where('name', 'LIKE', '%' . $query. '%');
 })
 ->where('title','LIKE','%' . $query. '%')
 ->orWhere('app_deadline','LIKE','%' . $query. '%')
 ->latest()->get();

试试这个它会帮助你：

编辑1：

$query = $request->input('query');
 $field = Field::where('title','LIKE','%' . $query. '%')->first();
 $fieldId = $field->id;
 $scholarships = $field->scholarships()->latest()->paginate(10);

 $scholarship = Scholarship::with(['levels' , function($q) use($query) {
      $q->where('name','LIKE','%' . $query. '%');
 }])
 ->where('title','LIKE','%' . $query. '%')
 ->orWhere('app_deadline','LIKE','%' . $query. '%')
 ->latest()->get();