优雅的方式将雄辩的集合分类为字母组块

Question

I need to sort a collection from my database like this https://www.bodybuilding.com/store/listing.htm

I could write it, but I'd probably also lose the eloquent relationships which isn't ideal.

This feels like something Laravel something can do out of the box, or with very little logic.

Any suggestions?

Answer 1

Checkout the Laravel documentation https://laravel.com/docs/5.7/eloquent#retrieving-models

$listing = App\Store::where('first_letter', 'a')
               ->orderBy('name', 'desc')
               ->take(10)
               ->get();

If you need something more specific, you can always create Scopes and use those in your eloquent models. https://laravel.com/docs/5.7/eloquent#query-scopes