تالار گفتمان nCIS.ir

$query = Orders::findBySql('SELECT * From orders Where(confirmed=1)');
$dataProvider = new ActiveDataProvider([
   'query' => $query->orderBy('id DESC'),
   'pagination' => ['pageSize' => 10],
]);

SELECT * FROM orders WHERE (confirmed=1) ORDER BY id DESC