Disable translations for specific query

[rafailml]

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?

[Gummibeer]

Have you set $with property in the category class? otherwise the translations are only queried if you access a translated attribute.

[rafailml]

No, I didn't.
I have only
public $translatedAttributes = ['name'];
in my Category model

[Gummibeer]

And in which situation you find-out/see that the translations are also loaded? After your query no translation should be available.

[rafailml]

In fact every query, even in other models returns translations. And I don't have $with anywhere.

[Gummibeer]

This package doesn't have any join - so the original query can't load translations. So what are you doing/your code that you see the translations? Do you use toArray() on the model?

laravel-translatable/src/config/translatable.php

Lines 108 to 117 in 5f19c5b

	/*
	|--------------------------------------------------------------------------
	| Always load translations when converting to array
	|--------------------------------------------------------------------------
	| Setting this to false will have a performance improvement but will
	| not return the translations when using toArray(), unless the
	| translations relationship is already loaded.
	|
	*/
	'to_array_always_loads_translations' => true,

[rafailml]

No, I do not use toArray()

Here is my model:

class Category extends Model
{
    use \Dimsav\Translatable\Translatable;
    use SoftDeletes;

    public $translatedAttributes = ['name'];

    public function media()
    {
        return $this->hasOne('App\Media', 'model_id', 'id');
    }

    public function products()
    {
        return $this->belongsToMany('App\Product');
    }
}

If I set 'to_array_always_loads_translations' => false
It returns what I want - no translations, but I need to refactor all my other queries somehow to get translations.

[Gummibeer]

And what's the code you execute where you see the translated fields?
It's impossible to tell you why you see translated fields if you don't show us what you do.

[rafailml]

Thats is the code:

public function simpleCategories()
{
        $categories = Category::select('id')
            ->get();
       return response()->json($categories);
}

[Gummibeer]

And this executes toArray() on your model. ;)
json calls toJson on the model which calls toArray.
You should fix this by adding a pluck('id')

public function simpleCategories()
{
    $categoryIds = Category::select('id')->get()->pluck('id');
    return response()->json($categoryIds);
}

[rafailml]

Thanks @Gummibeer , that works great, but how can I get that result in more complex query as in my first post?

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

return response()->json($product);

[Gummibeer]

You could try to do it by https://laravel.com/docs/5.6/collections#method-only or play around with the other collection methods.

But I would tinker with the toArrayAlwaysLoadsTranslations or attributesToArray method. My idea is to compare available attributes with all fillables or check if eloquent has a property to detect a not complete database record.
I don't have a ready to use solution but would be happy with a PR to add this feature, in best case with a new config.

The 100% best solution for me is a makeTranslationsHidden and makeTranslationsVisible method like https://laravel.com/docs/5.6/eloquent-serialization#hiding-attributes-from-json that changes a property on the model which is used in the attributesToArray method.

But this method has to be called on every model instance - not rly nice for your problem. But for an API I would go for the way to disable translations by default and enable/load them if needed via eloquent eager loading.

[rafailml]

Thanks @Gummibeer !