Eloquent: Get all items, and set key group

@chrisblackwell Not sure if this helps. try array_fill_keys()
http://www.w3schools.com/php/func_array_fill_keys.asp

$inventory = InventoryItem::orderBy('model', 'desc')->get()->groupBy('model');

$inventory = InventoryItem::orderBy('model', 'desc')->groupBy('model')->get();

Hi All

groupBy('model') will not work because that will take out all the entries, and limit each model to a single entry.

@chrisblackwell re-check my answer. The group by is applied on the collection returned by the query, not at the sql level.

http://laravel.com/api/4.2/Illuminate/Database/Eloquent/Collection.html#method_groupBy

@chrisblackwell what if you create an array of the groups using a loop and then in each group add the items that you want? for example

0 => ["group_name" => "Group A", "data" =>array[0 => "item 1", 1=>"item 2"]]

@giwrgos So far that is what I'm done. Not ideal because I have to run so many queries:

    $inventory = array();

    foreach($models as $model)
    {
      $inventory[$model->model] = InventoryItem::where('model', $model->model)->get();
    }   ```

@chrisblackwell can you provide us with your table fields and some data that may contain?

@pmall You were right! I called it on the collection, not the query, and it worked great :-)

@pmall

Looking at this post, I copied your syntax above:

$contractors = ContractorsController::orderBy('first_name','desc')->get();

and I get and error:

BadMethodCallException in Controller.php line 273: Method [orderBy] does not exist.

I tell you, L5 is flipping confusing between Eloquent, and Query Builder.

I've check the docs and can not see what could be wrong - any ideas??

Many thanks !

@vincej What is ContractorsController ?

@bestmomo

It's Friday afternoon in Calgary and I am being an idiot ... sorry to waste your time .. :o)

Bon Soir et Merci !!

@vincej

I tell you, L5 is flipping confusing between Eloquent, and Query Builder.

I must say I think it is pretty confusing too that some query builder methods and collection methods are named the same. It is kind of laravel haha moment whent you understand the groupBy method is not the same on a query builder and on a collection.