Need help with showing posts by category

Looking at their documentation (the country example), the field you use to select the category should actually be a field in the category table.

In their example they have the country_code in the countries table, and the name etc. in the translations table.

Which makes sense, because the slug within the translations doesn't have to be unique anymore

But if you really want to, you can override the route model binding yourself: This should work (untested)

class TranslatableServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap the application services.
     *
     * @return void
     */
    public function boot()
    {
        Route::bind('category', function ($value) {
            return Category::whereHas('translations', function ($query) use ($value) {
                $query->where('locale', App::getLocale())->where('slug', $value);
            })->first();
        });
        // add other translatable models here as well
    }
}

Hi, lostdreamer_nl. Thank you for your answer.

I've tried that too before.

With

public function teamCategory(Category $category) {

      return $category;
    }

I'm getting json result succesfuly , but when I tried like this:

public function teamCategory(Category $category) {

      return $category->teams;
    }

I'm getting this error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'teams.category_id' in 'where clause' (SQL: select * from `teams` where `teams`.`category_id` = 1 and `teams`.`category_id` is not null)

Any help?

In your original post you say:

teams: id, created_at, updated_at

teams_translations: id, team_id, locale, title, slug, image, body, created_at, updated_at

But in your Team model you have category_id as fillable, and a belongsTo relationship.

I dont see the category_id on your team table. Did you forget to put it in it's migration?

I have category_id in the team_translations table, otherwise I won't get any category values in the team list pages in the admin page. In Team model I'm passing the category_id in $translatedAttributes array.

I'm sorry, when I was writing here, I've missed to put category_id.

As far as I can see from the error it's not passing category_id properly into team_translations, because the function is looking at team table and there's no category_id column there.

lostdreamer_nl, I've followed your advice by adding the TranslatableServiceProvider class as a new service provider, I've deleted the category_id from team_translations table and moved that column to teams table. Finally I see results when I check with controller with this code:

public function teamCategory(Category $category) {

      return $category->teams;
    }

Later, I've set that with view and it's filtering great! Yay!!! :)

But, now when I enter the admin section and try to edit some category, for an example /en/admin/categories/10/edit I'm getting this error:

Missing argument 1 for App\Http\Controllers\CategoriesController::edit()

That's because of the custom service provider and in the admin section I'm using $id (10 is the id), not $category...damn...

Is there any fix for that? How can I set that service provider to act only on specific place?

So the problem is now that you have implemented custom binding, you'll need to use that binding everywhere (or use a different name in the route).

So there are 3 fixes:

1. Use the slug in the admin panel instead of the ID
2. in your routing for the admin panel, use a different name for {category} in the route
3. have the server provider check if you're using a (translated) slug or it's ID

I think option 1 and 2 speak for themselves. For option 3 you could perhaps do the following in the service provider:

        Route::bind('category', function ($value) {
            if(intval($value) != 0) {
                // using the category id
                return $query->where('id', $value)->first();
            } else {
                // using the translated slug
                return Category::whereHas('translations', function ($query) use ($value) {
                    $query->where('locale', App::getLocale())->where('slug', $value);
                })->first();
            }
        });

Thank you very much for your explanation, lostdreamer_nl! Maybe I'm gonna try the first or second option later, but I've tried now using your code and I'm getting this error:

Undefined variable: query

@emco83 Oops, my mistake, that's what you get for posting untested code:. This should be working:

        Route::bind('category', function ($value) {
            if(intval($value) != 0) {
                // using the category id
                return Category::where('id', $value)->first();
            } else {
                // using the translated slug
                return Category::whereHas('translations', function ($query) use ($value) {
                    $query->where('locale', App::getLocale())->where('slug', $value);
                })->first();
            }
        });

I've just tried again and now I'm getting this error:

Property [id] does not exist on this collection instance. 

Thanks to @Funfare I've fixed this problem by using the second option suggested by @lostdreamer_nl : changing the route with this code:

Route::resource('/admin/categories', 'CategoriesController', ['parameters' => [
    'categories' => 'cat'
]]);

Now everything works great! :)