Код: Выделить всё
$myDataProvider1 = new SqlDataProvider([
'sql' => 'SELECT b2b.user_list.name as list,
b2b.goods.article as article, b2b.goods.name as name, b2b.goods.id as good_id FROM b2b.listgoods, b2b.user_list, b2b.goods where b2b.listgoods.lisy_id=b2b.user_list.id
and b2b.listgoods.good_id=b2b.goods.id and user_id=:user_id ORDER BY list ASC',
'params' => [':user_id' => $user_id],
'sort' => [
'attributes' => [
'good_id',
'view_count',
'created_at',
],
],
'pagination' => [
'pageSize' => 100,
],
]);
Код: Выделить всё
echo GridView::widget([
'dataProvider' => $myDataProvider1,