douju6651
2018-05-07 13:55 阅读 74
已采纳

通过Laravel中的多态关系对数据库结果进行排序

I have an issue for sorting results by polymorphic relation in Laravel . Suppose we have two table like this :

users table : 
- integer id
- string  name 

meta table : 
- integer id
- string  key
- string  value 
- string  owner_type
- integer owner_id 

Relation between users table and meta table is polymorphic relation. So we have some users that each of them has some meta This is a hypothetical example of database records ( with meta )

id      1
name    "user1"
meta : 
   id           3
   key          "test"
   value        "3"
   owner_type   "App\\User"
   owner_id     1

   id           2
   key          "some other key"
   value        "some other value"
   owner_type   "App\\User"
   owner_id     1

id      2
name    "user2"
meta :
   id           3
   key          "test"
   value        "2"
   owner_type   "App\\User"
   owner_id     2

Now I want sort users results by meta value column where key is test . something like this :

$results = User::with(['meta' => function($q){
     $q->where('key' , 'test');
}])->orderBy('meta.value')->get();

But of course the code above does not work

What's your solution ? If we want get users from database and sort results by value of a meta witch has a special key what we should do ?

note : I want sort the data before getting results

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

1条回答 默认 最新

  • 已采纳
    dongyan9950 dongyan9950 2018-05-07 14:26

    What about a join?

    $results = User::join('meta', 'users.id', '=', 'meta.owner_id')
                       ->where('meta.key','=','test')
                       ->orderBy('meta.value')
                       ->select('users.id', 'users.name')
                       ->get();
    
    点赞 评论 复制链接分享

相关推荐