# Scopes

## translatedIn(?string $locale = null)

Returns all posts being translated in english

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

## notTranslatedIn(?string $locale = null)

Returns all posts not being translated in english

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

## translated()

Returns all posts with existing translations

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

## withTranslation()

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

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

## listsTranslations(string $translationField)

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

```php
Post::listsTranslations('title')->get()->toArray();
```

```php
[
    ['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)

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

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

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

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

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

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

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

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

Sorts the model by a given translation column value

```php
Post::orderByTranslation('title')->get()
```