How to use orderby on element that was joined with Laravel Eloquent method WITH(如何在与 Laravel Eloquent 方法 WITH 连接的元素上使用 orderby)
问题描述
问题是查询找不到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:
使用
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.
这篇关于如何在与 Laravel Eloquent 方法 WITH 连接的元素上使用 orderby的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!
本文标题为:如何在与 Laravel Eloquent 方法 WITH 连接的元素上使用 orderby


- 如何在 Symfony2 中正确使用 webSockets 2021-01-01
- 如何从数据库中获取数据以在 laravel 中查看页面? 2022-01-01
- Laravel 5:Model.php 中的 MassAssignmentException 2021-01-01
- 使用 GD 和 libjpeg 支持编译 PHP 2022-01-01
- PHP foreach() 与数组中的数组? 2022-01-01
- PHP - if 语句中的倒序 2021-01-01
- 覆盖 Magento 社区模块控制器的问题 2022-01-01
- openssl_digest vs hash vs hash_hmac?盐与盐的区别HMAC? 2022-01-01
- Oracle 即时客户端 DYLD_LIBRARY_PATH 错误 2022-01-01
- 如何使用 Google API 在团队云端硬盘中创建文件夹? 2022-01-01