witam
mam taki kawalek kodu i pytanie
jak do tego dodac filtrowanie ?
$query = \yii::$app->db;
$dataProvider = new \yii\data\ArrayDataProvider([
'allModels'=> $query->createCommand('call baza.pQuery()')->queryAll(),
'pagination'=>[
'pageSize' => 100
],
'sort'=>[
'attributes'=>[
'TimeStampModule',
'Nazwa',
'Fname',
'Fdesc',
'Fvar',
'Ip',
'FlagType',
],
'defaultOrder'=>['TimeStampModule'=>SORT_ASC],
],
]);
return $this->render('index',['dataProvider'=>$dataProvider]);
<?php
$columns =[
['class' => 'kartik\grid\SerialColumn'],
'TimeStampModule',
'Nazwa',
'Fname:ntext',
'Fdesc:ntext',
'Fvar:ntext',
'Ip',
'FlagType',
];
echo DynaGrid::widget([
'columns'=>$columns,
'storage'=>DynaGrid::TYPE_COOKIE,
'gridOptions'=>[
'dataProvider'=>$dataProvider,
'panel'=>['heading'=>'<h3 class="panel-title">Library</h3>'],
'pjax'=>true,
'responsive' => true,
'toolbar'=> [
['content'=>
Html::a('<i class="glyphicon glyphicon-repeat"></i>', ['index'], ['data-pjax'=>0, 'class'=>'btn btn-default', 'title'=> 'Reset Grid'])
],
'{export}',
'{toggleData}',
],
'rowOptions' =>function ($model, $index, $widget, $grid){
switch ($model['FlagType']){
case 'A': return ['class' => 'danger'];
break;
case 'D': return ['class' => 'success'];
break;
case 'R ': return ['class' => 'info'];
break;
}
},
],
'options'=>['id'=>'dynagrid-1']
]);