A Laravel package that adds JSON-based multilingual support to your Eloquent models. It provides:

• QueryFieldLocalizer: Utility to localize JSON fields to the current locale.
• SearchQueryBuilder: Trait for case-insensitive, multi-locale JSON field searching.
• LocaleResolver: Default resolver that returns app.locale and app.fallback_locale.

Require the package via Composer:

composer require labrodev/laravel-translatable

Optionally, publish the configuration (if you add a config file later):

php artisan vendor:publish --provider="Labrodev\Translatable\TranslatableServiceProvider"

Note: No configuration file is required out of the box—this is here for future customization.

QueryFieldLocalizer helps you build locale-specific JSON paths for query fields:

use Labrodev\Translatable\Utilities\QueryFieldLocalizer; // Assume the `title` column contains JSON: // { "en": "Hello", "es": "Hola" } $localized = QueryFieldLocalizer::translatableField('title'); // On locale `es`, returns: "title->es" // Use in query: $posts = Post::whereRaw("{$localized} = ?", ['Hola'])->get();

Add the SearchQueryBuilder trait to your Eloquent model:

use Illuminate\Database\Eloquent\Model; use Labrodev\Translatable\Base\Traits\SearchQueryBuilder; class Article extends Model { use SearchQueryBuilder; protected $casts = [ 'titles' => 'array', ]; }

Perform a case-insensitive search across all configured locales:

// Searches "manzana" in `titles` JSON for locales [en, es] $results = Article::query() ->where(function ($q) { $this->searchField($q, 'manzana', 'titles'); }) ->get();

Or chain with existing conditions:

$posts = Article::query() ->where('published', true) ->orWhere(function ($q) { $this->searchFieldOr($q, 'orange', 'titles'); }) ->get();

By default, locales come from app.locale and app.fallback_locale. To customize, bind your own LocaleResolver implementation:

use Labrodev\Translatable\Contracts\LocaleResolver; $this->app->singleton(LocaleResolver::class, function ($app) { return new class implements LocaleResolver { public function all(): array { return ['en', 'fr', 'es']; } }; });

This package uses Pest with Orchestra Testbench for testing and PHPStan for static analysis. This package uses Pest with Orchestra Testbench for testing and PHPStan for static analysis

1. Install dependencies:

   composer install

2. Run static analysis:

   composer analyse

3. Run tests:

   composer test

Tests cover:

• QueryFieldLocalizer::translatableField() outputs correct JSON path.
• SearchQueryBuilder builds proper SQL & bindings for multilingual JSON searches.
• DefaultLocaleResolverTest resolve locales array.

If you discover any security-related issues, please email contact@labrodev.com instead of using the issue tracker.

Please see CHANGELOG for more information on what has changed recently.

• Labro Dev

Feel free to open issues or submit pull requests. Check Coding Standards:

• PSR-12
• Strict types enabled

MIT © Labro Dev