Yii2 - Set value for Select2 plugin with Ajax Loading

Question

i've some troubles with Select2 kartik plugin for yii2. I set up my plugin with Ajax Loading and, in my create view works fine, so i can select multiple value and save it on database.

When i show the update view i want to set visible the value that i've saved in my database but it show me only a gray rectangle with x icon.

This is what i've tried.

echo $form->field($model, 'lista_art')->widget(Select2::classname(), [
    'initValueText' => $art_list,// array of text to show in the tag for the selected items 
    'showToggleAll' => false,
    'options' => ['placeholder' => 'Select...',
                  'multiple' =>true,
                  'value' => $value, // array of Id of the selected items
                 ],
    'pluginOptions' => [
        'tags' => true,
        'tokenSeparators' => [',', ' '],
        'allowClear' => true,
        'minimumInputLength' => 3,
        'language' => [
            'errorLoading' => new JsExpression("function () { return 'Waiting for results...'; }"),
        ],
        'ajax' => [
            'url' => \yii\helpers\Url::to(['lista-articoli']),
            'dataType' => 'json',
            'data' => new JsExpression('function(params) { return {q:params.term}; }')
        ],
        'escapeMarkup' => new JsExpression('function (markup) { console.log(markup);return markup; }'),
        'templateResult' => new JsExpression('function(lista_art) { return lista_art.art_modello; }'),
        'templateSelection' => new JsExpression('function (lista_art) { return lista_art.art_modello; }'),
    ],
]);

And this is the result.

$art_list and $value are array's like this

$art_list = ['name1','name2'];
$value= ['id_name1','id_name2'];

If i inspect the code with browser inspector i find this

×

UPDATE I'll find the error, and it is very trivial.. The error is here

 'templateResult' => new JsExpression('function(lista_art) { return lista_art.art_modello; }'),
 'templateSelection' => new JsExpression('function (lista_art) { return lista_art.art_modello; }')

There is no lista_art.art_modello because the object for this element is inthe format id:id_name1 and text:name1 so changing the code like this it will work

'templateResult' => new JsExpression('function(lista_art) { return lista_art.text; }'),
'templateSelection' => new JsExpression('function (lista_art) { return lista_art.text; }')

law_81 · Accepted Answer

Hi guys thanks for responding me. I found a solution for my problem and i'll post an answer for anyone who get same problem.

This is my Select2 Field in my view:

echo $form->field($model, 'lista_art')->widget(Select2::classname(), [
    'initValueText' => $art_list,// array of text to show in the tag for the selected items 
    'showToggleAll' => false,
    'options' => ['placeholder' => 'Seleziona un prodotto',
                  //'tags' => true,
                  'multiple' =>true,
                  'value' => $value, // array of Id of the selected items
                  'class' => 'validatej'
                 ],
    'pluginOptions' => [
        'tags' => true,
        'tokenSeparators' => [',' , ' '],
        'allowClear' => true,
        'minimumInputLength' => 3,
        'language' => [
            'errorLoading' => new JsExpression("function () { return 'Waiting for results...'; }"),
        ],
        'ajax' => [
            'url' => \yii\helpers\Url::to(['lista-articoli']),
            'dataType' => 'json',
            'data' => new JsExpression('function(params) {return {q:params.term}; }')
        ],
        'escapeMarkup' => new JsExpression('function (markup) { return markup; }'),
        'templateResult' => new JsExpression('function(data) {return data.text; }'),
        'templateSelection' => new JsExpression('function (data) {  return data.text; }'),
    ],
]);

The problem isn't here but in the function called by ajax

public function actionGetArt($q = null, $id = null) {
        \Yii::$app->response->format = \yii\web\Response::FORMAT_JSON;//restituisco json
        $out = ['results' => ['id' => '', 'text' => '']];
        if (!is_null($q)) {
            $query = new Query;
            $query->select('art_cod AS id, art_modello AS text') 
                  ->from('art')
                  ->where(['ilike', 'art_modello', $q]);
            $command = $query->createCommand();
            $data = $command->queryAll();
            $out['results'] = array_values($data);
        }
        elseif ($id > 0) {
            $out['results'] = ['id' => $id, 'text' => Catalogo::find($id)->art_modello];
        }

        return $out;
    }

In the line where i call select Sql

$query->select('art_cod AS id, art_modello AS text')

you have to set your id table an your text table(in my case art_modello) AS id and AS text accordly with the select2 widget. This is not specified in the docs so i'll have read the code and found this solution.

Yii2 - Set value for Select2 plugin with Ajax Loading

Answers (2)

Related Questions