Get single item with particular value on hasMany relation Laravel

Question

I have two tables:

items (
    id
    name
    description
)

images (
    id
    item_id
    number     // 0 -> main image ; 1,2,3,4 ...  -> gallery_image
)

with this basic relation:

#Item.php

public function images()
{
    return $this->hasMany('Image');
}

And

#Image.php

public function item()
{
    return $this->belongsTo('Item');
}

To show in my index.php all items with main image I want to get all items and the relations, but the relations only when "number" equals to "0" (main image).

If a use:

$all = $this->item->get();
foreach ($all as $one) {
        var_dump ($one->images);
}

Then I get all items (perfect) and also all images of each item. But I want a collection with all items and one image per item.

What is the best method?

Thanks.

This is what you need http://softonsofa.com/tweaking-eloquent-relations-how-to-get-latest-related-model/ - use `orderBy('number', 'asc')` on the relation — Jarek Tkaczyk, Jul 30 '14 at 11:17
perfect! thanks public function main_image() { $this->hasOne('Image')->orderBy('number', 'asc')->latest(); } — kurtko, Jul 30 '14 at 11:48
Accept the answer in order to help others facing the same issue. — Jarek Tkaczyk, Jul 30 '14 at 15:39

score 3 · Answer 1 · edited Nov 25 '14 at 20:34

The easiest way is to use 'helper' relation hasOne.

It lets you eager load that single related model:

// Use camelCase name, otherwise dynamic property won't work
public function mainImage()
{
  return $this->hasOne('Image')
    ->orderBy('number', 'asc'); 
    // or:      
    // ->where('number', 0);
}

Then you can use it and eager load it as given below:

$item->mainImage->number; // 0

$items = Item::with('mainImage')->get();

Get single item with particular value on hasMany relation Laravel

1 Answers1