Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
90 lines (59 sloc) 1.82 KB

Scopes

translatedIn(?string $locale = null)

Returns all posts being translated in english

Post::translatedIn('en')->get();

notTranslatedIn(?string $locale = null)

Returns all posts not being translated in english

Post::notTranslatedIn('en')->get();

translated()

Returns all posts not being translated in any locale

Post::translated()->get();

withTranslation()

Eager loads translation relationship only for the default and fallback (if enabled) locale

Post::withTranslation()->get();

listTranslations(string $translationField)

Returns an array containing pairs of post ids and the translated title attribute

Post::listsTranslations('title')->get()->toArray();
[
    ['id' => 1, 'title' => 'My first post'],
    ['id' => 2, 'title' => 'My second post']
]

where translation

Filters posts by checking the translation against the given value

whereTranslation(string $translationField, $value, ?string $locale = null)

Post::whereTranslation('title', 'My first post')->first();

orWhereTranslation(string $translationField, $value, ?string $locale = null)

Post::whereTranslation('title', 'My first post')
    ->orWhereTranslation('title', 'My second post')
    ->get();

whereTranslationLike(string $translationField, $value, ?string $locale = null)

Post::whereTranslationLike('title', '%first%')->first();

orWhereTranslationLike(string $translationField, $value, ?string $locale = null)

Post::whereTranslationLike('title', '%first%')
    ->orWhereTranslationLike('title', '%second%')
    ->get();

orderByTranslation(string $translationField, string $sortMethod = 'asc')

Sorts the model by a given translation column value

Post::orderByTranslation('title')->get()
You can’t perform that action at this time.