Sync three way pivot

A three way pivot is hell.

In this situation try to introduce another model to get back to classic two sided relationship. Here try to add a model representig the couple User/Project, which has a classic hasMany relationship with Role.

@kazehaya You're doing it wrong ;)

$user->projects()->sync([
   1 => ['role_id' => $roles],
   4 => ['role_id' => $roles],
   9 => ['role_id' => $roles],
]);

This is how sync works when you want to update existing rows (as well as insert new ones). 1, 4 and 9 are projects ids, so just build an array that looks like this.

For triple pivot you can use this https://github.com/jarektkaczyk/Eloquent-triple-pivot/ , however mind that it is not complete and I'm not working on it anymore.

@JarekTkaczyk Thanks for helping me on the right pad! I think i have come up with a solution, just need to get the key of the projects:)

this is what i have done:

        $syncArray = array_build($roles, function ($key, $value) {
            return [$key, ['role_id' => $value]];
        });

This is what i get in return:

array:2 [▼
  0 => array:1 [▼
    "role_id" => "5"
  ]
  1 => array:1 [▼
    "role_id" => "1"
  ]
]

Do you want to help me so the keys above match to that of the project id's? :)

@JarekTkaczyk I came up with a solution myself!

What do you think of this? ;)

        $syncArray = [];
        foreach($projects as $project_id) {
            $syncArray += array_build($roles, function ($project_id, $value) use ($project_id) {
                return [$project_id, ['role_id' => $value]];
            });
        }

@kazehaya If that works for you, then use it. Here's something I would do to build that array https://laracasts.com/discuss/channels/general-discussion/sync-question

@JarekTkaczyk Thanks so much!!

This is how i get it working!

        $data = array_build($roles, function ($key, $value) {
            return [$key, ['role_id' => $value]];
        });

        $syncArray = array_combine($projects, $data);

        $user->projects()->sync($syncArray);

Again big thanks for helping me and sharing your knowledge, it means a lot to me and i think to others here on the forum as well!