Gummibeer
commented
4 years ago Moin 😉
a short conclusion - if I'm right you want to get all models with a translation in a country based locale de-AT or the corresponding country-less locale de!?
| post_id | locale | title |
|---|---|---|
| 1 | de | post #1 de title |
| 1 | de-AT | post #1 de-AT title |
| 2 | de-AT | post #2 de-AT title |
| 2 | de-DE | post #2 de-DE title |
| 3 | de | post #3 de title |
| 4 | en | post #4 en title |
So this table would result in:
app()->setLocale('de-AT');
$posts = Post::translatedInCountryOrLanguage('de-AT')->get();
foreach($posts as $post) {
$post->title;
}
// post #1 de-AT title
// post #2 de-AT title
// post #3 de titleIf that's your goal I'm not quite sure if I will add a scope to thee package. But II will definitely help/guide you to a solution!
The package translatedIn() scope uses the Laravel/Eloquent default whereHas().
You only have to add one orWhere() to the sub-query - okay, and some logic to prevent or strangeness. 😂
public function scopeTranslatedIn(Builder $builder, ?string $locale = null)
{
$locale = $locale ?: $this->locale();
// build relationship exists condition
return $builder->whereHas(
'translations',
// add conditions the translations have to fulfill to "exist"
function (Builder $query) use ($locale) {
// wrap "or" query in one "where" to prevent strangeness
return $query->where(function (Builder $q) use ($locale) {
// build real translation conditions
return $q
// translation locale has to match
->where($this->getLocaleKey(), $locale)
// when locale is country based
->when(
$this->getLocalesHelper()->isLocaleCountryBased($locale),
// add "or" locale matches language without country
function (Builder $q) use ($locale) {
return $q->orWhere(
$this->getLocaleKey(),
$this->getLocalesHelper()->getLanguageFromCountryBasedLocale($locale)
);
}
);
});
}
);
}I've commented every closure - feel free to reformat it, rename variables or whatever. Possibly you even could reduce it a bit - but I've done the long/excessive version for "better" readability. (it's still a long and too much indented method 😂)
This scope isn't tested but should do exactly wha you've described.
rezaffm
Hello (Hallo, hoff es geht Dir gut!),
I recently added country based locales to my project (de-AT, de-CH) to de. I have noticed that there is no scope that would retrieve all translations for a given country locale. Clearly, it's easy to retrieve all posts (for instance) in de-AT by using Post::translatedIn('de-AT')->get(), but there is no similiar method or scope that would retrieve all posts in de or in de-AT (I hope that makes sense). Also duplicates should be avoided if there is a post available for de and de-AT
I am not a mysql expect, so I asked at Stackoverflow how to design a query for such a scope or method: https://stackoverflow.com/questions/62620047/one-query-for-one-join-that-uses-first-result-in-second-subquery-to-get-all-ro
I noticed that it would be possible to first check per post if a translation at all exist for the given post (once we retrieved all posts) and then, if that's true, we can use the translate method with the current locale and use fall_back set true as a work around.
$posts = Post::withTranslation()->get();in a blade view then:
Demo db according to documentation:
posts
post_translations
If I then browse the website for posts in de-AT, I'd get the desired result:
So my request would be to add a scope or maybe method that retrieves all the translations for a given country based locale. If that's already implemented, happy to learn how to use it tough.
Thank You.