Hi,

in my project I need to create a model that uses both a nested tree structured and translations. To translate the model I use your package. The nested set structure is provided by https://github.com/etrepat/baum.

If my model extends Baum/Node the translations are not saved at all.

<?php

use Dimsav\Translatable\Translatable;

class Category extends Baum\Node
{
    use Translatable;

    protected $guarded = array('id', 'url');

    public $translatedAttributes = ['name', 'url'];
    public $translationModel = 'CategoryTranslation';

}

When changing Baum/Node to Eloquent the translations are saved correctly.

How can this problem be solved?

Hello,

This might be a stupid question, but I'd like to check if there's a translation before echoing, to avoid the Trying to get property of non-object error.

I've tried:

isset($page->translate($lang)->title) ? $page->translate($lang)->title : ''

is_object($page->translate($lang)) ? $page->translate($lang)->title : ''

$page->translate($lang) ? $page->translate($lang)->title : ''

None work.

Since the a certain version, when a translation doesn't exists, it doesn't return an empty string. It might be nice to return an empty string of no translation exists in the db for that language, to avoid having to make these checks in views all the time.

Thank you.

I've followed this tutorial for build a translatable logic: https://mydnic.be/post/how-to-build-an-efficient-and-seo-friendly-multilingual-architecture-for-your-laravel-application

Right now if I put manually records in the database by using a command from here: https://github.com/mydnic/Laravel-Multilingual-SEO-Example/blob/master/app/Console/Commands/InsertDummyPosts.php

I can retrieve the translated posts succesfully, but how can I create a content end edit using the two tables method with translate package?

This is my code:

PostsController

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Post;
use App\User;
use Session;
use Illuminate\Support\Facades\Auth;

class PostsController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $posts = Post::orderBy('id', 'desc')->paginate(5);
        return view('admin.posts.index', compact('posts'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return view('admin.posts.create');
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
      $this->validate($request, [
        'title' => 'required',
        'body' => 'required',
      ]);

      $input = $request->all();
      $user = Auth::user();

      $user->posts()->create($input);

      session()->flash('created_post', 'The post has been created');

      return redirect('/en/admin/posts');

      // This wont work because it's trying to save the post in posts table, instead of post_translations table.
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        //
    }

    public function posts() {
      $posts = Post::orderBy('id', 'desc')->paginate(5);

      return view('posts', compact('posts'));
    }

    public function post($slug) {
      
      $post = Post::whereTranslation('slug', $slug)->firstOrFail();

      return view('post', compact('post'));
    }
}

From the code you can see the store method and that's working only if I store in one database without translatable package. I need help to change that.

The Post model:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Dimsav\Translatable\Translatable;

class Post extends Model
{
    use Translatable;

    public $translatedAttributes = ['title', 'slug', 'body'];

    protected $fillable = ['title', 'slug', 'body', 'status', 'locale'];

    public function user() {
      return $this->belongsTo('App\User');
    }

    public function posts() {
      return $this->hasMany('App\Post');
    }
}

The PostTranslate model:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Cviebrock\EloquentSluggable\Sluggable;

class PostTranslation extends Model
{
    use Sluggable;

    public $timestamps = false;
    protected $fillable = ['title', 'slug', 'body', 'status', 'locale'];

    /**
     * Return the sluggable configuration array for this model.
     *
     * @return array
     */
     public function sluggable()
    {
        return [
            'slug' => [
                'source' => 'title'
            ]
        ];
    }
}

The User model:

<?php

namespace App;

use Illuminate\Notifications\Notifiable;
use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable
{
    use Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name', 'email', 'password', 'role_id', 'status',
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password', 'remember_token',
    ];

    public function role(){
        return $this->belongsTo('App\Role');
    }

    public function isAdmin() {
      if($this->role->name == 'Administrator') {
        return true;
      }
      return false;
    }

    public function posts() {
      return $this->hasMany('App\Post');
    }
}

database/migrations/2017_09_26_140138_create_posts_table.php

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreatePostsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('posts', function (Blueprint $table) {
            $table->increments('id');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('posts');
    }
}

database/migrations/2017_09_26_140327_create_post_translations_table.php

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreatePostTranslationsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('post_translations', function (Blueprint $table) {
            $table->increments('id');
            $table->integer('post_id')->unsigned();
            $table->string('locale')->index();

            // The actual fields to store the content of your entity. You can add whatever you need.
            $table->string('title');
            $table->string('slug')->unique();
            $table->text('body');
            $table->integer('status')->default(0);

            $table->unique(['post_id', 'locale']);
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('post_translations');
    }
}

resources/view/admin/posts/create.blade.php

@extends('layouts.backend')

@section('content')
  @include('includes.tinymce')
  <h1>Create post</h1>
  <form action="/en/admin/posts" method="post" enctype="multipart/form-data">
    {{ csrf_field() }}
    <div class="form-group">
      <label>Title</label>
      <input type="text" name="title" class="form-control" value="{{old('title')}}">
    </div>
    <div class="form-group">
      <label>Body</label>
      <textarea name="body" class="form-control" rows="10">{{old('body')}}</textarea>
    </div>
    <div class="form-group">
      <label>Language</label>
      <select name="locale">
        <option value="en">English</option>
        <option value="fr">French</option>
      </select>
    </div>
    <div class="form-group">
      <label>Status</label>
      <select name="status" class="form-control">
        <option value="1">Published</option>
        <option value="0">Draft</option>
      </select>
    </div>
    <div class="form-group">
      <input type="submit" class="btn btn-primary" value="Create post">
    </div>
  </form>
  @include('includes.errors')
@endsection

Any help is appreciated.

And another thing: How can I retrieve the local language into the links?

Lets say I have a link for creating a new page: href="/admin/posts/create"

How can I set like this?

href="/en/admin/posts/create"

or

href="/fr/admin/posts/create"

depends from the chosen language. Is there any variable I can use here?

Hello, i'm trying to add translations from json, but they aren't saving.

i send data like this:

en: {summary: "random summary"} ru: {summary: "random summary"}

it creates new record, but without translations. any ideas?

Hi, Thanks a lot for this nice package. I'm using Laravel 5.1, please is there a way to validate fooTranslation attributes ? For example I have the attribute 'name' required and unique in 'foo' model, so how can I update it with this validation ? Example :

class Foo extends Model { use Translatable;
protected $table = 'foos'; public $translatedAttributes = ['name', 'description'];

Hi, First of all, thanks for this amazing package, very useful here in Belgium ;-) ! IO have a little bug when I try to print a translated field like this: echo $article->title;

The app doesn't use the current locale.

I set the locale like that in my controller: App::setLocale('fr');

Inside the view:

This prints 'fr': app()->getLocale()

This works : $article->translate('fr')->title

But not if I use the shortcut directly.

Thanks for your help !

I couldn't find a way to translate pivot values from ManyToMany relationships. In my case, I have a Combination model and an Attribute model which are connected together with a belongsToMany relationship and a pivot value as shown below:

namespace App;

use Illuminate\Database\Eloquent\Model;

class Combination extends Model {
   public function product() {
      return $this->belongsTo('App\Product');
   }

   public function product_attributes() {
      return $this->belongsToMany('App\Attribute')->withPivot('value');
   }
}

The attribute_combination intermediate table looks like this:

+--------------+----------------+-------+ 
| attribute_id | combination_id | value |
|--------------+----------------+-------|
| 1            | 1              | Black |
| 2            | 1              | M     |
| 1            | 2              | Black |
| 2            | 2              | L     |
+--------------+----------------+-------+

Is there a way to retrieve the translation of this pivot value?

I'm using laravel-translatable with laravel-auditing in a single model which causes auditing to create a log entry even though there are no changes.

https://github.com/owen-it/laravel-auditing/issues/221

This PR adds translatable attributes to the $fillable list when requested through getFillable() (which is the recommended way to access the $fillable property.

Moreover, this method is very handy to filter out unwanted request input by simply using $request->only(Model::getFillable()).

By implementing this PR, Laravel Translatable integrates even more gracefully in the fillable features of Eloquent.

Is there a way that I can simply do $country->all(), and the return will retrieve all correct data in arrays to fill in automatically my Form::model binding ?

PS: Sorry for open a Issue, I don't know any extra place that I could put my doubts out!

Here is my case: I have product which have a categories. When I edit the product I don't want to get translated categories. I want only category.id How can I achieve that?

Here is what I'm doing now:

$product = Product::select('id', 'sku',...)
->with(['categories' => function ($query) {
                        $query->select(['categories.id']);
                    }])
->where('id', $id)
->first();

But I'm getting categories with their translations. Is it possible for that query only to get categories without translations?