dimsav / laravel-translatable

     *

     * @return \Illuminate\Database\Eloquent\Builder|static

     */

    public function scopeWhereTranslation(Builder $query, $key, $value, $locale = null)

    {

        return $query->whereHas('translations', function (Builder $query) use ($key, $value, $locale) {

            $query->where($this->getTranslationsTable().'.'.$key, $value);

            if ($locale) {

                $query->where($this->getTranslationsTable().'.'.$this->getLocaleKey(), $locale);

            }

        });

    }

    /**

     * This scope filters results by checking the translation fields.

     *

     * @return \Illuminate\Database\Eloquent\Builder|static

     */

    public function scopeWhereTranslationLike(Builder $query, $key, $value, $locale = null)

    {

        return $query->whereHas('translations', function (Builder $query) use ($key, $value, $locale) {

            $query->where($this->getTranslationsTable().'.'.$key, 'LIKE', $value);

            if ($locale) {

                $query->where($this->getTranslationsTable().'.'.$this->getLocaleKey(), 'LIKE', $locale);

            }

        });

    }

    /**

     * @return array