despark/laravel-db-localization

Database localization package for laravel framework

Tuesday, May 22, 2018
by tbanov
Repository
9 Watchers
11 Stars
316 Installations

PHP
0 Dependents
0 Suggesters
4 Forks
0 Open issues
19 Versions
1 % Grown

The README.md

Laravel DB Localization for version 5.1

Note: if you are looking for the version for Laravel 4.2 check out v1 branch., _(*1)

Installation

Open composer.json file of your project and add the following to the require array:, _(*2)

"despark/laravel-db-localization": "2.0.*"

Now run composer update to install the new requirement., _(*3)

Once it's installed, you need to register the service provider in config/app.php in the providers array:, _(*4)

'providers' => array(
  ...
  Despark\LaravelDbLocalization\LaravelDbLocalizationServiceProvider::class,
);

Publish config file: php artisan vendor:publish --provider="Despark\LaravelDbLocalization\LaravelDbLocalizationServiceProvider" --tag="config", _(*5)

Publish migrations: php artisan vendor:publish --provider="Despark\LaravelDbLocalization\LaravelDbLocalizationServiceProvider" --tag="migrations", _(*6)

How to use it

Database Example

First you need to create your languages table

Schema::create('i18n', function (Blueprint $table) {
        $table->increments('id');
        $table->string('locale')->unique()->index();
        $table->string('name')->index();
        $table->timestamps();
});

Example of translatable table

Schema::create('contacts', function (Blueprint $table) {
        $table->increments('id');

        // untranslatable columns
        $table->string('fax');
        $table->string('phone');
        $table->timestamps();
});

Example of translations table

Schema::create('contacts_i18n', function (Blueprint $table) {

        $table->integer('contact_id')->unsigned();
        $table->foreign('contact_id')->references('id')->on('contacts')->onDelete('cascade');
        $table->integer('i18n_id')->unsigned();
        $table->foreign('i18n_id')->references('id')->on('i18n')->onDelete('cascade');

        // translatable columns
        $table->string('name', 100);
        $table->string('location', 100);

        $table->unique(['contact_id', 'i18n_id']);
        $table->primary(['contact_id', 'i18n_id']);
        $table->timestamps();
});

Model Example


use Despark\LaravelDbLocalization\i18nModelTrait;

class Contacts extends Eloquent
{
    use i18nModelTrait; // You must use i18nModelTrait

    protected $fillable = [
        'fax',
        'phone',
    ];

    protected $translator = 'Despark\LaravelDbLocalization\ContactsI18n'; // Here you need to add your translations table model name

    protected $translatorField = 'contact_id'; // your translator field name

    protected $localeField = 'i18n_id'; // here is your locale field name

    protected $translatedAttributes = ['contact_id', 'i18n_id', 'name', 'location']; // translatable fillables
}

class ContactsI18n extends Eloquent
{
    protected $table = 'contacts_i18n';
}

View example

Create, _(*7)

{!! Form::text("fax", null) !!}
{!! Form::text("phone", null) !!}

@foreach($languages as $language)
    {!! Form::text("name[name_$language->id]", null) !!}  // Follow this convention array( fieldname_languageId );
    {!! Form::text("location[location_$language->id]", null) !!}
@endforeach

Retrieve, _(*8)

    // locale string
    $contacts->translate('en'); // all fields
    $contacts->translate('en')->location; // specific field

    // locale id
    $i18nId = 2;
    $contacts->translate($i18nId); // all fields
    $contacts->translate($i18nId)->location; // specific field

Config Example

config/laravel-db-localization.php
    'locale_class' => 'Despark\LaravelDbLocalization\I18n', // Eloquent model that handles your languages.

The Versions

22/05 2018

v3.x-dev

3.9999999.9999999.9999999-dev

Database localization package for laravel framework

library laravel-db-localization

Database localization package for laravel framework

despark/laravel-db-localization

The README.md

Laravel DB Localization for version 5.1

Installation

How to use it

Database Example

Model Example

View example

Config Example

The Versions

v3.x-dev

The Requires

The Development Requires

by Ludmil Simeonov

by Anton Geshev

by Tihomir Banov

v3.1

The Requires

The Development Requires

by Ludmil Simeonov

by Anton Geshev

by Tihomir Banov

v3.0

The Requires

The Development Requires

by Ludmil Simeonov

by Anton Geshev

by Tihomir Banov

v2.x-dev

The Requires

The Development Requires

by Tihomir Banov

v1.x-dev

The Requires

by Tihomir Banov

0.0.1

The Requires

The Development Requires

by Tihomir Banov

dev-master

The Requires

by Tihomir Banov

v2.0.2

The Requires

by Tihomir Banov

v2.0.1

The Requires

by Tihomir Banov

v2.0.0

The Requires

by Tihomir Banov

v1.2.3

The Requires

by Tihomir Banov

v1.2.2

The Requires

by Tihomir Banov

v1.2.1

The Requires

by Tihomir Banov

v1.2.0

The Requires

by Tihomir Banov

v1.1.8

The Requires

by Tihomir Banov

v1.1.7

The Requires

by Tihomir Banov

v1.1.6

The Requires

by Tihomir Banov

v1.1.5

The Requires

by Tihomir Banov

v1.1.4

The Requires

by Tihomir Banov