I am looking for a way to take one query in Eloquent to get all search results, and then take those results, group them by type, and output the different types.

I currently have this setup to get all my search results:

$listings = Listing::where('listings.expiration_date', $date_operator, date('Y-m-d H:i:s'));$listing->where(function($query) use ($keyword) {                         $query->where('listings.lot_number', 'LIKE', '%'.$keyword.'%')                                    ->orWhere('listings.title', 'LIKE', '%'.$keyword.'%')                                    ->orWhere('listings.brand', 'LIKE', '%'.$keyword.'%')                                    ->orWhere('listings.grade', 'LIKE', '%'.$keyword.'%')                                    ->orWhere('listings.tags', 'LIKE', '%'.$keyword.'%')                                    ->orWhere('listings.player', 'LIKE', '%'.$keyword.'%');                         })->leftJoin('bids', function($join){                                $join->on('bids.listing_id', '=', 'listings.id')                                ->on('bids.id', '=', DB::raw("(select max(id) from bids WHERE bids.listing_id = listings.id)"));                            })->leftJoin('media', function($join) {                                $join->on('media.listing_id', '=', 'listings.lot_number')                                ->where('media.group_order', '=', '1')->groupBy('media.group');                            });$listings = $listings->get();

The resulting $listings shows all the search results that I want to appear. Each listing has a specific type (item_type) assigned to them (i.e. Card, Ball, Bat, etc). I'd like to take all those results and group the types so that I can get a unique list of types to display in the menu. I've tried GroupBy on the Collection but that doesn't seem to be working.

Thank You

1 Answer1

Start asking to get answers

Find the answer to your question by asking.

Explore related questions

See similar questions with these tags.