sorting multiple tables by time

barantr90

posted 10 years ago

Database Eloquent

hello to every one, I am trying to sort multiple tables like this;

//Controller http://laravel.io/bin/BBz16

//Output http://laravel.io/bin/LyjrV

normally output is gonna be(by id) 66,1, 65, 2. How can I do that? :(

Last updated 2 years ago.

pmall

replied 10 years ago

Solution

You can merge two collections

$posts = Post::orderBy('created_at', 'DESC')->get(); 
$org = Organization::orderBy('created_at', 'DESC')->get();

$all = $posts->merge($org);

Then you can sort it

$all_sorted = $all->sort(function($a, $b){
  // classic sort callback
});

However it seems you want to make a sort of timeline, maybe another model that represents a timeline event would be suited in that case.

Last updated 2 years ago.

barantr90

replied 10 years ago

pmall said:

You can merge two collections

$posts = Post::orderBy('created_at', 'DESC')->get(); 
$org = Organization::orderBy('created_at', 'DESC')->get();

$all = $posts->merge($org);

Then you can sort it

$all_sorted = $all->sort(function($a, $b){
 // classic sort callback
});

Thank you so much but can u explain this, pls?

$all_sorted = $all->sort(function($a, $b){
  // classic sort callback
});

Last updated 2 years ago.

pmall

replied 10 years ago

see the sort method

However a basic understanding of php is required to use laravel at its full potential, using a callback function to sort an array is a common thing.

Last updated 2 years ago.

barantr90

replied 10 years ago

pmall said:

see the sort method

However a basic understanding of php is required to use laravel at its full potential, using a callback function to sort an array is a common thing.

thank you so much. I finally got it :)

Last updated 2 years ago.

Moderators