Sortable polymorphic many to many, inverse relationship sorting? about rutorika-sortable HOT 7 CLOSED

@timganter Hello! Thank you :)
can you provide your current database structure?

from rutorika-sortable.

@boxfrommars Sure! I'm going to email it to you if you don't mind. Just don't want to post it here where it's public since it's client work. =)

from rutorika-sortable.

@timganter Got it. Yes, your structure is almost the same as in the demo. Do you need sorting both tags and posts? If you don't, solution is:

1. Remove BelongsToSortedManyTrait and replace ->belongsToSortedMany with default ->belongsToMany in the your Post model
2. Add to the Tag model:

   use BelongsToSortedManyTrait;

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

Note, that now you should use

    $tag->posts()->save($posts);
    $tag->posts()->attach($posts->id);
    $tag->posts()->sync([$postId1, $postId2, /* ...postIds */]);

instead of $post->tags()->...

from rutorika-sortable.

@boxfrommars Thanks Dmitry.

I gave that a shot. I'm using polymorphic relations. So, in my Post model I have...

public function tag()
    {
        return $this->morphedByMany(Tag::class, 'taggable')->withTimestamps();
    }

In my Tag model I have...

public function post()
    {
        return $this->morphToSortedMany(Post::class, 'taggable')->withTimestamps();
    }

However I'm getting an SQL error.

Column not found: 1054 Unknown column 'post_id' in 'field li
  st' (SQL: select `post_id` from `taggables` where `taggable_id` = 2 and `taggable_type` = App\Tag)

Did I hook things up correctly?

Thanks again for your help!

from rutorika-sortable.

@timganter Sorry for waiting.
I've added ->morphedBySortedMany relation and demo for it: http://sortable5.boxfrommars.ru/albums-and-videos

So you need add to your Tag model MorphToSortedManyTrait trait and this relation: (like in the https://github.com/boxfrommars/rutorika-sortable-demo5/blob/master/app/Author.php)

use Rutorika\Sortable\MorphToSortedManyTrait;

class Tag extends Model
{
    use MorphToSortedManyTrait;

    public function posts()
    {
        return $this->morphedBySortedMany('App\Post', 'taggable', 'position');
    }
}

and then you can attach/sync/save posts to this tag (not vice versa):

$tag->posts()->save($posts);
$tag->posts()->attach($posts->id);
$tag->posts()->sync([$postId1, $postId2, /* ...postIds */]);

I'll update readme in a few days (I'm on vacation now)

from rutorika-sortable.

@timganter I've forgot to say, you should update the package to the version 3.1.0 for this functionality

from rutorika-sortable.

@boxfrommars So cool! Thanks again man! =)

from rutorika-sortable.