检索两个模型并按日期排序

Question

I'm trying to retrive the 20 most recent elements from two differents models Post and Link and rank them by the field created_at in descending order.

Here is the link class

class Link extends \Illuminate\Database\Eloquent\Model {
  public $incrementing = false;

  public function author() {
    return $this->belongsTo('App\Models\Author');
  }

  public function category() {
    return $this->belongsTo('App\Models\Category');
  }
}

And here the post class

class Post extends \Illuminate\Database\Eloquent\Model {
  public $incrementing = false;

  public function author() {
    return $this->belongsTo('App\Models\Author');
  }

  public function category() {
    return $this->belongsTo('App\Models\Category');
  }
}

How can I do that with eloquent (I'm using it outside Laravel, with Slim)?

Answer 1

The merge method was the answer :

$posts = \App\Models\Post::where('draft', false)->orderBy('created_at', 'desc')->take(20)->get();
$links = \App\Models\Link::orderBy('created_at', 'desc')->take(20)->get();

$result = $posts->merge($links)->sortByDesc('created_at')->take(20);