Filter by word instead of 0 or 1 (tinyint)

Yii 2.0 General Discussions
1

My DB fields “estado” and “visible” are tinyint but I want to filter by “activada” instead of 1 and “desactivada” instead of 0 in the gridview

<?=
    GridView::widget([
        'dataProvider' => $dataProvider,
        'filterModel' => $searchModel,
        'columns' => [
            ['class' => 'yii\grid\SerialColumn'],
            ['class' => 'yii\grid\CheckBoxColumn', 'checkboxOptions' => function ($model, $key, $index, $column) {
                    return ['value' => $model->id];
                },
            ],
//            'id',
            'nombre',
            [//Jaula
                'attribute' => 'jaula',
                'format' => 'raw',
                'value' => function ($model) {
                    if ($model->id_jaula != null) {
                        return $model->jaula->NOMBRE;
                    }
                }
            ],
            [//Linea
                'attribute' => 'Linea',
                'format' => 'raw',
                'value' => function ($model) {
                    if ($model->jaula->linea->NOMBRE != null) {
                        return $model->jaula->linea->NOMBRE;
                    }
                }
            ],
            [//Estado
                'attribute' => 'estado',
                'value' => function($model) {
                    if ($model->estado == '0') {
                        return 'Desactivada';
                    } else {
                        return 'Activada';
                    }
                },
                'contentOptions' => function($model) {
                    return ['style' => 'color:' . (($model->estado == 0) ? 'red' : 'green')];
                }
            ],
            [//Visible
                'attribute' => 'visible',
                'value' => function($model) {
                    if ($model->visible == 1) {
                        return 'Sí';
                    } else {
                        return 'No';
                    }
                },
                'contentOptions' => function($model) {
                    return ['style' => 'color:' . (($model->visible == 0) ? 'red' : 'green')];
                }
            ],
            [//Streaming
                'attribute' => 'streaming',
                'label' => 'Pantalla',
                'format' => 'raw',
                'value' => function ($model) {
                    if ($model->id_streaming != null) {
                        return $model->streaming->nombre;
                    }
                }
            ],
            [//Canal
                'attribute' => 'canal',
                'value' => function($model) {
                    if ($model->canal != null && $model->canal[-1] == 1) {
                        return 'Mainstream';
                    } else if ($model->canal != null && $model->canal[-1] == 2) {
                        return 'Substream';
                    }
                }
            ],
//            'marca',
//            'modelo',
            'ip',
//            'websocket',
            'puerto',
            //'user',
            //'pass',
            ['class' => 'yii\grid\ActionColumn'],
        ],
    ]);
    ?>

How can I accomplish this?

2 
       [//Estado
            'attribute' => 'estado',
            'value' => function($model) {
                if ($model->estado == '0') {
                    return 'Desactivada';
                } else {
                    return 'Activada';
                }
            },
            'contentOptions' => function($model) {
                return ['style' => 'color:' . (($model->estado == 0) ? 'red' : 'green')];
            },
            'filter' => ['1' => 'Activada', '0' => 'Desactivada'],
        ],
2 Likes
3

Thank you, it works like a charm!