GridView多表关联

时间:2023-03-09 13:08:01
GridView多表关联

有些时候,需要多表关联查询,使用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,
    
]); ?>