如何在与 Laravel Eloquent 方法 WITH 连接的元素上使用 orderby

2021-12-26 00:00:00 php mysql laravel eloquent

问题是查询找不到specific_method(specific_method, specific_model,SpecificModel,specificMethod etc...),应该与Laravel Eloquent中的WITH方法连接.任何想法如何解决它?我的代码:

The problem is that the query can't find the specific_method(specific_method, specific_model,SpecificModel,specificMethod etc...), that should been joined with the method WITH from Laravel Eloquent. Any ideas how to solve it? My code:

//SpecificModel
<?php
namespace AppModels;
use IlluminateDatabaseEloquentModel;

class SpecificModel extends Model {

    protected $guard_name = 'web';
    protected $table = 'SpecificTable';
    protected $guarded = ['id'];

    public function specificMethod(){
        return $this->belongsTo('AppModelsAnotherModel','AnotherModel_id');
    }
}


//AnotherModel
<?php
namespace AppModels;
use IlluminateDatabaseEloquentModel;

class AnotherModel extends Model {

    protected $guard_name = 'web';
    protected $table = 'AnotherTable';
    protected $guarded = ['id'];
}

//Query method
$model = app('AppModelsSpecificModel');
$query = $model::with('specificMethod:id,title');
$query = $query->orderBy('specific_method.title','desc');
return $query->get();


//Error
Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 
'"specific_method.title"' in 'order clause' (SQL: select * from 
`SpecificModel` where `SpecificModel`.`deleted_at` is null order by 
`specific_method`.`title` desc)

推荐答案

发生这种情况是因为belongsTo 关系没有像您期望的那样执行join 查询(正如您从错误中看到的得到).它执行另一个查询以获取相关模型.因此,您将无法通过相关模型列订购原始模型.

This happens because the belongsTo relationship does not execute a join query as you expect it to (as you can see from the error you get). It executes another query to get the related model(s). As such you will not be able to order the original model by related models columns.

基本上,会发生 2 个查询:

Basically, 2 queries happen:

  1. 使用 SELECT * from originalModel ...*

使用 SELECT * from relatedModel where in id (originalModelForeignKeys)

然后 Laravel 做了一些魔术,将第二个查询中的模型附加到第一个查询中的正确模型上.

Then Laravel does some magic and attaches the models from the 2nd query to the correct models from the first query.

您需要执行实际的join能够以您想要的方式订购.

You will need to perform an actual join to be able to order the way you want it to.

相关文章