dongzhenqi2015 2016-02-17 23:29
浏览 34
已采纳

laravel Lazy Eager正在加载orderBy相关模型

I need to lazy eager load some related models with custom order. Something like:

$season->load(['championships' => function ($query) {
    $query->orderBy('country', 'desc');
}]);

But the problem is that championships do not have country property. In Championship model I use getCountryAttribute function:

public function getCountryAttribute()
{
    return $this->masterChampionship->country;
}

public function masterChampionship()
{
    return $this->belongsTo('App\MasterChampionship');
}

And I get next results:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'country' in 'order clause' (SQL: select * from `championships` where `championships`.`season_id` in (41) order by `country` desc)

If i don't use load in controller and access championships from blade template

@foreach($season->championships->sortBy('country') as $championship)
    ....
@endforeach

everything works fine. But I want to cleanup template and move logic to controller. Is there any possibility to solve my case using built-in laravel features, without building custom BD query.

  • 写回答

1条回答 默认 最新

  • doukuanyong1939 2016-02-18 00:20
    关注

    Youll have to change the table names, as I don't know what they are, but I think this would work:

    $season->load(['championships' => function($query){
    
        $query->select('championships.*')
            ->join('master_championships', 'championships.master_championships_id', '=', 'master_championships.id')
            ->orderBy('master_championships.country', 'desc');
    
    }]);
    

    I don't think you can order the query without using a join, seeing as you have to access the third table to get the country attribute. You may save a bunch of queries from hitting the database if you do

    $season->load(['championships','championships.masterChampionships']);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥60 pb数据库修改或者求完整pb库存系统,需为pb自带数据库
  • ¥15 spss统计中二分类变量和有序变量的相关性分析可以用kendall相关分析吗?
  • ¥15 拟通过pc下指令到安卓系统,如果追求响应速度,尽可能无延迟,是不是用安卓模拟器会优于实体的安卓手机?如果是,可以快多少毫秒?
  • ¥20 神经网络Sequential name=sequential, built=False
  • ¥16 Qphython 用xlrd读取excel报错
  • ¥15 单片机学习顺序问题!!
  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路