
有些时候,需要多表关联查询,使用SqlDataProvider比较灵活
Controller中
use yii\data\SqlDataProvider;
$dataProvider = new SqlDataProvider([
'sql' =>$sql,
'totalCount' => $totalCount,
'pagination' => [
'pageSize' => ,
],
]);
$gridcolumn[]=['class'=>'kartik\grid\SerialColumn'];
$gridcolumn[]=['label'=>'AA','value'=>"name"];
//省略
View中
<?= GridView::widget([
'dataProvider' => $dataProvider,
'columns' =>$gridcolumn,
]); ?>