Laravel Eloquent无法得到简单的hasMany关系工作

Question

Background

I have an internationalized DB that stores its strings for different languages like this:

products
    id
    price

product_translation
    id
    product_id
    language_id
    name
    description

languages
    id
    name (e.g. 'English', 'German')
    code (e.g. 'en', 'de')

With appropriate Models for each table (Product, ProductTranslation, Language). In my views I want to fetch a list of products like this:

// get first 20 products, list name and price.
@foreach(Product::take(20)->get() as $product)
{{$product->translations->name}} {{$product->price}}
@endforeach

Problem

My app will return product names according to what the current App::getLocale() is set to (i.e. en and de).

I'm just starting out with Laravel's Eloquent, I'm unsure how to specify the correct relationships (or if I'm actually doing it correctly at all).

My attempt

I have specified a OneToMany relationship in between Product and ProductTranslation:

class Product extends \Eloquent {

    protected $with = ['translations'];

    public function translations()
    {
        return $this->hasMany('ProductTranslation');
    }
}

This works fine but will return all the translations (we only want the current locale).

I then specify a OneToOne relationship between ProductTranslation and Language:

class ProductTranslation extends \Eloquent {

    protected $with = ['language'];

    public function language()
    {
        return $this->hasOne('Language')
        ->where('code', App::getLocale());
    }
}

I know this doesn't work and I am stumped at what to do next. Does anyone have a cleaner approach?

Answer 1

class ProductTranslation extends \Eloquent {

    protected $with = ['language'];

    public function language()
    {
        return $this->hasOne('Language');
    }
}

In route or controller

ProductTranslation::language()->where('code', '=', App::getLocale())->get();

To keep this in the model do this

public static function getLocale() 
{
    return static::language()->where('code', '=', App::getLocale())->get();;
}

Call the function using ProductTranslation::getLocale()