What is the syntax for sorting an Eloquent collection by multiple columns?

by

sortBy() takes a closure, allowing you to provide a single value that should be used for sorting comparisons, but you can make it a composite by concatenating several properties together

$posts = $posts->sortBy(function($post) {
    return sprintf('%-12s%s', $post->column1, $post->column2);
});

If you need the sortBy against multiple columns, you probably need to space pad them to ensure that “ABC” and “DEF” comes after “AB” and “DEF”, hence the sprint right padded for each column up to the column’s length (at least for all but the last column)

Note that it’s generally a lot more efficient if you can use an orderBy in your query so the collection is ready-sorted on retrieval from the database

More Related Contents:

  1. Laravel Check If Related Model Exists
  2. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  3. Laravel Eloquent: How to order results of related models?
  4. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  5. How to set a default attribute value for a Laravel / Eloquent model?
  6. Friendship system with Laravel : Many to Many relationship
  7. Laravel merge relationships
  8. Laravel Eloquent – Attach vs Sync
  9. How to create a subquery using Laravel Eloquent?
  10. Update without touching timestamps (Laravel)
  11. Eloquent model mass update
  12. How can I query raw via Eloquent?
  13. Find or Create with Eloquent
  14. Laravel Many to many self referencing table only works one way
  15. How Can I Remove “public/index.php” in the URL Generated Laravel?
  16. Laravel Model with Two Primary Keys update [duplicate]
  17. Laravel eager loading with limit
  18. Laravel pagination pretty URL
  19. Laravel OrderBy relationship count
  20. How to change / Custom password field name for Laravel 4 and Laravel 5 user authentication [duplicate]
  21. Laravel mail: pass string instead of view
  22. Laravel – Database, Table and Column Naming Conventions?
  23. Laravel preg_match(): No ending delimiter ‘/’ found
  24. How to Merge Two Eloquent Collections?
  25. Laravel and view caching in development — can’t see changes right away
  26. Laravel 4.1: How to paginate eloquent eager relationship?
  27. How to send data using redirect with Laravel
  28. Laravel Auth:attempt() will not persist login
  29. Avoid public folder of laravel and open directly the root in web server
  30. Laravel Eloquent update just if changes have been made

Leave a Comment