Laravel sync - how to sync an array and also pass additional pivot fields

Question

Official Laravel documentation has this on sync   function    user- gt roles  - gt sync  array  1  2  3        You may also associate other pivot table values with the given IDs    user- gt roles  - gt sync  array  1   gt  array   expires    gt  true          In the latter example only a single pivot row is being added  What I don t understand is how can I associate other pivot table records if there are more than one rows to be synced   Thanks in advance

User · Answer

Putting this here in case I forget it later and Google it again.

In my case I wanted the extra column to have the same data for each row

Where $syncData is an array of IDs:

$syncData = array_map(fn($locationSysid) => ['other_column' => 'foo'], array_flip($syncData));

or without arrow

$syncData = array_map(function($locationSysid) {
      return ['ENTITY' => 'dbo.Cli_Core'];
   }, array_flip($syncData));

(array_flip means we're using the IDs as the index for the array)

User · Answer

Simply just append your fields and their values to the elements    user- gt roles  - gt sync      1   gt    F1    gt   F1 Updated

User · Answer

In order to sync multiple models along with custom pivot data  you need this   user- gt roles  - gt sync        1   gt    expires    gt  true       2   gt    expires    gt  false                Ie  sync       related id   gt    pivot field    gt  value                 edit Answering the comment   speakers     array  Input  get  speakers       related ids  pivotData   array fill 0  count  speakers     is speaker    gt  true     syncData    array combine  speakers   pivotData     user- gt roles  - gt sync  syncData

User · Answer

Add following trait to your project and append it to your model class as a trait  This is helpful  because this adds functionality to use multiple pivots  Probably someone can clean this up a little and improve on it     namespace App Traits   trait AppTraits                  Create pivot array from given values                param array  entities         param array  pivots         return array combined  pivots             public function combinePivot  entities   pivots                        Set array          pivotArray                  Loop through all pivot attributes         foreach   pivots as  pivot   gt   value                   Combine them to pivot array              pivotArray      pivot   gt   value                        Get the total of arrays we need to fill          total   count  entities              Make filler array          filler   array fill 0   total   pivotArray              Combine and return filler pivot array with data         return array combine  entities   filler             Model   namespace App   use Illuminate Database Eloquent Model   class Example extends Model       use Traits AppTraits                 Usage      Get id s  entities    1  2  3      Create pivots  pivots          price    gt  634       name     gt   Example name         Combine the ids and pivots  combination    model- gt combinePivot  entities   pivots      Sync the combination with the related model   pivot  model- gt relation  - gt sync  combination

User · Answer

Attaching   Detaching  Eloquent also provides a few additional helper methods to make working with related models more convenient  For example  let s imagine a user can have many roles and a role can have many users  To attach a role to a user by inserting a record in the intermediate table that joins the models  use the attach method    user   App User  find 1     user- gt roles  - gt attach  roleId     When attaching a relationship to a model  you may also pass an array of additional data to be inserted into the intermediate table    user- gt roles  - gt attach  roleId    expires    gt   expires      You can also use Sync if you want to remove old roles and only keep  the new ones you are attaching now   user- gt roles  - gt sync  1   gt    expires    gt   expires   2   gt    expires    gt   expires      The default behaviour can be changed by passing a  false  as a second        argument  This will attach the roles with ids 1 2 3 without affecting the existing      roles   In this mode sync behaves similar to the attach method    user- gt roles  - gt sync  1   gt    expires    gt   expires   2   gt    expires    gt   expires   false     Reference   https   laravel com docs 5 4 eloquent-relationships

User · Answer

data   array    foreach   request- gt planes as  plan      data plan   array  plan   gt  array  dia    gt   request- gt dia  plan                        array push  data  data plan          user- gt planes  - gt sync  data

User · Answer

This works for me    foreach   photos array as  photo           collect all inserted record IDs      photo id array  photo- gt id      type    gt   Offence            Insert into offence photo table  offence- gt photos  - gt sync  photo id array  false    dont delete old entries   false

[php] Laravel, sync() - how to sync an array and also pass additional pivot fields?

Examples related to php

Examples related to laravel

Examples related to pivot

Examples related to eloquent

Examples related to sync