php - 限制在 WhereHas 内

Question

所以我想获得最后状态等于给定状态的请求我试过 first() 但它给了我一个错误并且限制不起作用

$requests = Request::whereHas('requestStatus', function ($query) use ($status) {
            return $query->where('status',$status)->orderBy('updated_at', 'desc')->limit(1);
        })->get();

Controller

    public function listByStatus($status)
    {   

        $requests = Request::whereHas('requestStatus', function ($query) use ($status) {
        return $query->where('status',$status)->orderBy('updated_at', 'desc')->limit(1);
    })->get();


        return view('admin.request.list',compact('requests','status'));
    }

模型请求

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

迁移请求状态

Schema::create('request_status', function (Blueprint $table) {
    $table->increments('id');
    $table->integer('request_id')->unsigned();;
    $table->foreign('request_id')->references('id')->on('requests');
    $table->string('status');
    $table->string('image')->nullable();
    $table->timestamps();
});

Answer 1

试试这个:

$requests = Request::select('requests.*')
    ->join('request_status', 'requests.id', 'request_status.request_id')
    ->where('request_status.status', $status)
    ->where('request_status.id', function($query) {
        $query->select('id')
            ->from('request_status')
            ->whereColumn('request_id', 'requests.id')
            ->orderByDesc('updated_at')
            ->limit(1);
    })
    ->get();