問題描述
問題是查詢找不到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)
推薦答案
發(fā)生這種情況是因為belongsTo 關系沒有像您期望的那樣執(zhí)行join 查詢(正如您從錯誤中看到的得到).它執(zhí)行另一個查詢以獲取相關模型.因此，您將無法通過相關模型列訂購原始模型.
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.
基本上，會發(fā)生 2 個查詢:
Basically, 2 queries happen:
使用
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.
您需要執(zhí)行實際的join能夠以您想要的方式訂購.
You will need to perform an actual join to be able to order the way you want it to.
這篇關于如何在與 Laravel Eloquent 方法 WITH 連接的元素上使用 orderby的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！