belongsTo not working with array about eloquent-json-relations

[staudenmeir]

The relationship requires routeParams to be an array:

{"icon": "img/categorias/automotivo.png", "route": "website.listaLocais",
  "routeParams": [{"slug": "automotivo"}]}
                 ^                      ^

Is payload an attribute in the Category model?

[thiago-slb]

That's right, created like this $table->json('payload');

[staudenmeir]

You'll have to use the inverse relationship:

public function categories() {
    return $this->hasManyJson(Category::class, 'payload->routeParams[]->slug', 'slug');
}

[staudenmeir]

Does it work for you?

[thiago-slb]

I haven't had the time to test it just yet, I'll try it tomorrow, thanks. Em dom, 3 de fev de 2019 13:09, Jonas Staudenmeir <[email protected] escreveu:

…

Does it work for you? — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#6 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABlS82y-1P6tXqWnwYaT8h2pyWvek_TUks5vJvubgaJpZM4afDjM> .

[thiago-slb]

It didn't work, I copied your code at first, but also change to this:

public function option() {
    return $this->hasManyJson(Category::class, 'payload->routeParams[]->slug', 'slug');
}

and this

public function option() {
    return $this->hasMany(Category::class, 'payload->routeParams[]->slug', 'slug');
}

[thiago-slb]

What i'm trying to achive is:

Each option has one category (slug at the moment), but the category slug is stored inside a json attribute, is that possible to do? I can store the category id instead of the slug if that helps... would that change anything?

I'm trying to loop through the data like this =>

foreach($options as $option){
    $option->payload->icon;
    $option->category->title;
    etc...
}

[staudenmeir]

I see, I thought there can be multiple categories.

Use this and the original JSON data ("routeParams": {"slug": "automotivo"}):

public function category() {
    return $this->hasMany(Category::class, 'payload->routeParams->slug', 'slug');
}

[staudenmeir]

Does it work for you?

[thiago-slb]

No, the error is gone, but it doesn't find the relationship.

[staudenmeir]

How are you using the relationship?

[thiago-slb]

I had to give up since the deadline is soon, when I finish I'll get back to this and try again, but thanks anyway it help me understand a bit more about how the package works.

[staudenmeir]

Can I close this?