Many to Many collection displayed as select #98
Comments
|
This should do the trick: $this
->add('languages', 'collection', [
'type' => 'select',
'property' => 'name',
'options' => [
'choices' => $this->model->languages()->lists('id', 'name')
]
])You have example in first code block here which says Probably it's not descriptive enough. |
|
The 'choices' you wrote doesn't work for me: it only lists already associated languages. 'choices' => Language::all()->lists('name', 'id') //they have to be inverted: name will be the option text, id will be the option valueBut I don't know how to select the currently associated language. EDIT: ->add('languages', 'collection', [
'type' => 'select',
'property' => 'id',
'options' => [
'choices' => Language::all()->lists('name', 'id'),
'label' => false,
]
])It automagically selects the correct one. |
|
Sorry about the multiple comments. //MovieForm
->add('languages', 'choice', [ //I switched to a multiselect instead of multiple separate select
'choices' => Language::all()->lists('name', 'id'),
'selected' => $this->model->languages()->lists('id'),
'multiple' => true,
])
->add('screenings', 'collection', [
'type' => 'form',
'options' => [
'class' => 'App\Forms\ScreeningForm',
'label' => false,
]
])
//ScreeningForm
->add('languages', 'choice', [
'choices' => Language::all()->lists('name', 'id'),
'selected' => $this->model->languages()->lists('id'), //$this->model is NULL here
'multiple' => true,
])
->add('Save', 'submit', [
'attr' => ['class' => 'btn btn-primary pull-right']
])Issues here: $this->model is NULL in Screening so I can't set the selected options. |
|
If your model structure is good, and you eager load all your relationships on your models, you don't need to set up Basically get model with something like this: |
|
@kristijanhusak I already eager load my relationships like this: $movie = Movie::with(['screenings.languages', 'languages'])->findOrFail($id);As you can see, I also eager load screening languages. If I add languages to the form like this: ->add('languages', 'choice', [
'choices' => Language::all()->lists('name', 'id'),
//'selected' => $this->model->languages()->lists('id'),
'multiple' => true,
])It won't select the already associated languages, even though var_dumping $this->model->languages correctly shows the 2 languages associated with it. The child form for screenings won't select associated languages either. As said before, $this->model is NULL within ScreeningForm, so I can't explicitly set the 'selected' array element either. Do I need to somehow pass the screening model to the child form? I also still can't remove the 'Save' button from the child form. |
|
@koichirose Can you please give me the dump of this call: $movie = Movie::with(['screenings.languages', 'languages'])->findOrFail($id);
dd($movie->toArray());So I can analyze this and see what needs to be fixed? |
|
Sure. Here's the full code: $movie = Movie::with('screenings.languages', 'languages')->findOrFail($id);
dd($movie->toArray());
$form = $formBuilder->create('Moviedb\Forms\MovieForm', [
'method' => 'PUT',
'url' => route('movies.update', $movie),
'model' => $movie,
]);
return $this->view('movies.edit', compact('form'));Result of the dd of a movie with 2 languages and 2 screenings with one language each (some elements are removed/collapsed): |
|
Thanks.
Soe for example, something like this should work: $this->add('languages', 'choice', [
'choices' => Languages::all()->lists('name', 'id')
'selected' => [2,4]
'multiple' => true
]);It's just how laravels form builder accepts values for selection. If it's string, it tracks that value and selects/checks it. If it's array, it loops over it and selects all values that are found. In your case, languages are returned as object/associative arrays, and then it doesn't know which value to get. i would suggest to correct your languages method in the model to return something like this: public function languagesRelationship()
{
return $this->hasMany('App\Languages');
}
public function languages()
{
return $this->languagesRelationship()->lists('id');
}Hope this solves your problem. It's a bit common issue, check here. I'll definitely look into this problem to find a better solution for these kind of problems. |
|
Got it, thank you. I'd rather set the 'selected' attribute of my forms manually rather than changing my models. Also, I receive the following error when changing my Movie model as you suggested (leaving the controller as it was before): Could it be because movie-languages is a belongsToMany relationship (not hasMany) ? I'm sorry if I'm asking obvious questions, but this is one of my first Laravel apps. So, I'd like to set the 'selected' attribute and to do that on the child form I'd need to set the 'data' attribute as you suggested, right? Is this still related to the issue we just discussed? Thanks again |
|
Ok try this in model: class Languages extends Model {
protected $appends = ['languages'];
public function languagesData()
{
return $this->hasMany('App\Languages');
}
public function getLanguagesAttribute()
{
return $this->languagesData()->lists('id');
}
}And in controller call I think it should work, $model->lanaguages should be array of ids. |
|
And for FormBuilder::create('App\Languages')->add('save', 'submit'); |
|
Ok for the save button. Changing my models like that works within the form, but apparently breaks everything else, since accessing $movie->languages now only returns ids and not the full language object. I need to investigate further though. Before you answered, I tried passing the model to the child form (did you manage to find out why it would be NULL in the child form?). Since the screening form is added to movies as a collection, I don't know how to get the first or second (or third..etc.) from within the ScreeningForm. I'd find it cleaner to manually set the 'selected' attribute instead of adding new attributes to all my Models to have multiple attributes. |
|
Yes, it's a bit hacky. I found a problem why model is null in the child form, and i fixed it. Pull the dev version and see if it works for you. If it's ok, i'll tag a release. |
|
I switched to dev-master and removed all the model edits. I switched back to using the 'selected' array key: //controller
$movie = Movie::with('screenings.languages', 'languages')->findOrFail($id);
$form = $formBuilder->create('Moviedb\Forms\MovieForm', [
'method' => 'PUT',
'url' => route('movies.update', $movie),
'model' => $movie,
]);
//MovieForm
->add('screenings', 'collection', [
'type' => 'form',
'options' => [
'class' => 'Moviedb\Forms\ScreeningForm',
'label' => false,
]
])
->add('languages', 'choice', [
'choices' => Language::all()->lists('name', 'id'),
'selected' => $this->model->languages()->lists('id'),
'multiple' => true,
])
//ScreeningForm
->add('languages', 'choice', [
'choices' => Language::all()->lists('name', 'id'),
'selected' => $this->model->languages()->lists('id'),
'multiple' => true,
])$this->model is no longer NULL in ScreeningForm, but the values are not selected. Languages look correct: //in ScreeningForm
dd($this->model->languages()->lists('id')):
array:2 [▼
0 => "4"
1 => "2"
] |
|
Yes, you are right. I'm working on fix for that. |
|
Ok, do a composer update and see if it works now. |
|
Now it selects values of both screenings, but they are not correct. In my previous comment I mentioned that $this->model->languages()->lists('id') in ScreeningForm looked correct but it doesn't, it contains values 4 and 2 which are the languages associated with the parent movie and not the screening. It should be '1' for the first screening and '4' for the second. I'd need to set 'selected' as the language ids of the current iteration of the screening, I guess. |
|
Yes, that's why i suggested to use that handling through model like in comment #98 (comment) That way data will be properly fetched for each screening. You shouldn't have any issue with that, only everywhere where you are syncing I'll try to figure out some better way that could handle this in the form automatically, or to provide some way to fetch data properly. At this moment, this is the best I can do. |
|
Thank you, solved it like this, for those having this issue: //controller
$movie = Movie::with('screenings', 'languages')->findOrFail($id);
//MovieForm
->add('languages_ids', 'choice', [
'choices' => Language::all()->lists('name', 'id'),
//'selected' => $this->model->languages()->lists('id'), //Not Needed!
'multiple' => true,
])
//ScreeningForm same as MovieForm
//Movie Model
protected $appends = ['languages_ids'];
public function getLanguagesIdsAttribute()
{
return $this->languages()->lists('id');
}
//Screening Model same as Movie Model |
|
@koichirose $this->add('language', 'choice', [
'choices' => Language::all()->lists('name', 'id'),
'multiple' => true,
'selected' => function($data) {
// $data is the value passed to the choice field, you can modify it here and return it as you wish
// Example of data:
// $data = [
// [
// "id" => "4"
// "name" => "Japanese"
// "created_at" => "2012-01-12 22:22:45"
// "updated_at" => "2015-03-21 16:31:34"
// "pivot" => []
// ],
// [
// "id" => "2"
// "name" => "English"
// "created_at" => "2012-01-12 22:22:43"
// "updated_at" => "2015-04-20 11:20:24"
// "pivot" => [
// "movie_id" => "178"
// "language_id" => "2"
// ]
// ]
// ];
// This will return array of id's from data above
return array_pluck($data, 'id');
}
]);It should also work on the collection, where |
|
@kristijanhusak I don't know if it was your typo, but it's the same with add('language'..) or add('languages'..) EDIT: sorry I forgot to pull the latest dev. I get another error now, but it looks like it's on my side (even though it worked before undoing my changes and pulling). Investigating. |
|
@kristijanhusak I had a custom field named 'dateonly', with a custom field view with this for the Screening date: <?= Form::input($type, $name, $options['default_value']->toDateString(), $options['attr']) ?>This returned a new error: removing 'toDateString()' shows the form but:
->add('countries', 'collection', [
'type' => 'text',
'property' => 'name', // Which property to use on the tags model for value, defualts to id
'data' => [], // Data is automatically bound from model, here we can override it
'options' => [ // these are options for a single type
'label' => false,
'attr' => [],
]
//resulting input text:
[{"id":"4","name":"Japan","iso":null,"description":null,"flag":"Japan.png","created_at":"2012-01-12 22:22:43","updated_at":"2015-04-27 11:10:47","pivot":{"movie_id":"178","country_id":"4"}}]This is the current status with latest dev. It's the same with both versions of my code (the one with 'languages_ids' additional model attribute workaround, and without it). Let me know if you need anything else to fix this. |
|
@koichirose Edit: |
|
@koichirose |
|
Here it is: It looks like I don't have a Screening object at all in there with the latest dev, so I don't know if the custom field is relevant. //ScreeningForm
->add('screening_date', 'dateonly')
//app/Forms/Fields/Dateonly.php
<?php namespace Moviedb\Forms\Fields;
use Kris\LaravelFormBuilder\Fields\FormField;
class Dateonly extends FormField {
protected function getTemplate()
{
// At first it tries to load config variable,
// and if fails falls back to loading view
// resources/views/fields/datetime.blade.php
return 'vendor.laravel-form-builder.dateonly';
}
public function render(array $options = [], $showLabel = true, $showField = true, $showError = true)
{
return parent::render($options, $showLabel, $showField, $showError);
}
}
//resources/views/vendor/laravel-form-builder/dateonly.php
<?php if ($showLabel && $showField): ?>
<?php if ($options['wrapper'] !== false): ?>
<div <?= $options['wrapperAttrs'] ?> >
<?php endif; ?>
<?php endif; ?>
<?php if ($showLabel && $options['label'] !== false): ?>
<?= Form::label($name, $options['label'], $options['label_attr']) ?>
<?php endif; ?>
<?php if ($showField): $type = 'date'; ?>
<?= Form::input($type, $name, $options['default_value']->toDateString(), $options['attr']) ?>
<?php if ($options['help_block']['text']): ?>
<<?= $options['help_block']['tag'] ?> <?= $options['help_block']['helpBlockAttrs'] ?>>
<?= $options['help_block']['text'] ?>
</<?= $options['help_block']['tag'] ?>>
<?php endif; ?>
<?php endif; ?>
<?php if ($showError && isset($errors)): ?>
<?php foreach ($errors->get($nameKey) as $err): ?>
<div <?= $options['errorAttrs'] ?>><?= $err ?></div>
<?php endforeach; ?>
<?php endif; ?>
<?php if ($showLabel && $showField): ?>
<?php if ($options['wrapper'] !== false): ?>
</div>
<?php endif; ?>
<?php endif; ?> |
|
Everything looks fine. You don't need render method in your custom form class, so you can remove it, and only leave template name. Did you update to the latest version ( Also, are you sure you have |
|
Just pulled latest dev. Using this for both Movie and Screening: ->add('languages', 'choice', [
'choices' => Language::all()->lists('name', 'id'),
//'selected' => $this->model->languages()->lists('id'),
'multiple' => true,
'label' => 'Languages',
'selected' => function($data) {
return array_pluck($data, 'id');
}
])$data within the 'selected' Closure is an empty array in Screening. It's correct in Movie. Fetching the movie like this, even though I noticed it doesn't change much if I eager load languages or not: $movie = Movie::with('screenings.languages', 'languages')->findOrFail($id);Thanks again |
|
@koichirose |
|
Confirmed, everything is working as expected :) $data within the Closure in Screening languages is still an empty array, but it's working. It is an Eloquent collection in Movie languages. Thank you again, closing this for now. |
|
@koichirose How you know it's empty in the screening languages, you did |
|
Yes, I'm var dumping $data. |
|
Are you doing |
|
Yes, but I'm var dumping before that: ->add('languages', 'choice', [
'choices' => Language::all()->lists('name', 'id'),
'multiple' => true,
'label' => 'Languages',
'selected' => function($data) {
//var_dump($data);die();
return array_pluck($data, 'id');
}
]) |
|
Try without |
|
It does :) thanks |
|
Hello, But i am getting this error: Maybe anyone knows what could be the issue? Thanks |
Not really an issue but I wouldn't know where else to ask.
I have a Movie with a belongsToMany languages association.
Let's say a Movie has 2 languages (english and spanish).
I'm trying to show 2 selects with a list of all languages, where the first one has 'english' as selected and the second one has 'spanish'. option value should be the language id.
This is my attempt, within MovieForm:
This is obviously wrong (shows an empty select), but I'm not sure how to accomplish this, the documentation is not very clear about this.
I'd like to avoid using a child LanguageForm as it would just display a select.
The text was updated successfully, but these errors were encountered: