Eloquent Localization

posted 10 years ago

I am trying to solve mine N+1 problems with SQL queries. I have managed to reduce the number of queries by half, but I am having problems with queries that fetch localized data.

This are my tables relationships:

Realestate
- id
- city_id
City
- id
City_translation
- id
- name
- city_id
- language_id
Language
- id
- code (hr, en ...)

How can I fetch all realestates from database and then display the localized city name in language x for each realestate fetched using eloquent.


$all = Realestate::with('city')->get();

//And then in my view

@foreach($all as $single)
$single->city->translation(App::getLocale())->name
//or
$single->city->name
// and it should return the translated
@endforeach

Any ideas?

Last updated 2 years ago.

mabasic

replied 10 years ago

Solution

Ok, I have solved this for my projects and have created a package for anyone that comes into this situation again: TranslateThatModel

Last updated 2 years ago.

vinkla

replied 10 years ago

Here is another approach on translating Eloquent objects: https://github.com/vinkla/translator

Last updated 2 years ago.

igaster

replied 9 years ago

Hello,

I 've created a package igaster/laravel-translate-eloquent that adds translation to any Eloquent Model. It requires only one additional table in your DB where all the translations will be stored...

You can get/set a translated key as it was a normal Eloquent key (eg $article->title), when actually the correct translation will be looked up and returned from the Translations table...
Of course you can request a translation to any locale.
It supports a fallback locale if there is no translation in the current locale.

Hope it is usefull... Cheers!

Moderators