kylemilloy
commented
6 years ago For anyone else looking to solve this issue I hacked it by doing the following...this guide specifically deals with setting an "order" attribute on the pivot table but you could likely turn it into anything.
Create a custom controller
You'll need a custom controller to handle the pivot attributes. Create a controller and extend the VoyagerBaseController. From here we're going to overwrite the insertUpdateData method. Most of this remains the same but near the very end where we run a foreach call on the $multi_select variable we're going to modify some stuff here. If you're looking to order items, do the following:
// ... insertUpdateData
foreach ($multi_select as $sync_data) {
$attrs = [];
for ($i = 0; $i < $count; $i++) {
$pivot[$i] = ['order' => $i];
}
//
$data->belongsToMany($sync_data['model'], $sync_data['table'])->sync(
array_combine($sync_data['content'], $attrs)
);
}
// ... See Laravel documentation here for the Laravel sync command and what it expects
Include your pivot data in the relationship
On the model you need to include the relationship data for later so add a ->withPivot($column_name) call to the end of your belongsToMany call.
Create custom views
You'll need to overwrite your edit-add view for the slug of the model you're updating. Ex: Updating the "Artist" model? Then create a view at resources/views/vendor/voyager/artists/edit-add.blade.php and copy everything from the base edit-add view. See the doc here. If you're trying to add order you'll also need to make a custom relationship partial at resources/views/vendor/voyager/formfields/relationship-w-pivot.blade.php. Copy the contents of the base voyager relationship.blade.php view. In the custom edit-add view you made change the include relationship call to point at your custom one.
Update some javascript
This is very specific to setting an order and likely won't need to be done. In the edit-add partial you made attach jQuery UI in the javascripts section and add the following at the bottom...feel free to clean this up but I hacked it up with the following:
$('.select2-selection__rendered').sortable({
stop: function(evt, ui) {
$parent = $(evt.target).parents('.form-group');
var select = $parent.find('select');
var option_array = $(evt.target).parents('.form-group').find('.select2-selection__choice').get();
$.each(option_array, function(i, el) {
var id = $(el).attr('id');
var option = select.find('option[value="' + id + '"]')[0];
select.prepend(option);
});
}
});This will make it so the belongsToMany field will be sortable and when it sorts it it will update the order of the select options. Doing this allows us to avoid passing more data to the backend and instead just rely on the order of the options in the select input to tell Laravel what order to assign.
Modify your custom relationship view
For ordering we need to persist the order that they appear. Skip down to the <select multiple> portion (around line 150) and here you will see a call to @php where we assign the $selected_values variable. Everything should remain the same but I modified it a bit to fetch additional pivot info...and then sort by this pivot data. I changed the @php section to be the following:
$selected_values = isset($dataTypeContent)
? $dataTypeContent->belongsToMany($options->model, $options->pivot_table)->withPivot('order')->get()
: array();
$relationshipOptions = app($options->model)->all()->merge($selected_values)->sortByDesc('pivot.order');
$selected_values = $selected_values->pluck($options->key)->toArray();
lablushah
Daniyal-Javani
alexisrazok
devig
g-trema
nagievflash
phillmorgan28
ahmed-meraneh
I have some many-to-many relationships that I'd like to include pivot data with. I don't suppose there's a way to get/set pivot table data within the Voyager UI short of making BREAD for the pivot table?
The use case is: A project belongs to many services. But I don't want to show them in the order they were made. Instead, want to have an "order" column that a user can set to display them as required.
I am assuming I'll need to build something bespoke here...how can I create a custom data type for including pivot data? What part of Voyager would I need to augment?