public function actionIndex() { //deve ser feito um switch futuramente para carregamentos do pjax. $count = Yii::$app->db->createCommand(' SELECT COUNT(*) FROM (SELECT * FROM (SELECT * FROM `meican_topo_change` ORDER BY `applied_at` DESC) as t1 GROUP BY `domain`) as t2 ')->queryScalar(); $changeProvider = new SqlDataProvider(['sql' => 'SELECT * FROM (SELECT * FROM `meican_topo_change` ORDER BY `applied_at` DESC) as t1 GROUP BY `domain` ORDER BY `applied_at` DESC', 'totalCount' => $count, 'pagination' => ['pageSize' => 18], 'sort' => false]); $taskProvider = new ActiveDataProvider(['query' => DiscoveryTask::find()->orderBy('id DESC'), 'sort' => false, 'pagination' => ['pageSize' => 5]]); $ruleProvider = new ActiveDataProvider(['query' => DiscoveryRule::find(), 'sort' => false, 'pagination' => ['pageSize' => 5]]); $changeProvider->pagination->pageParam = 'change-page'; $ruleProvider->pagination->pageParam = 'rule-page'; $taskProvider->pagination->pageParam = 'task-page'; return $this->render('index', array('changeProvider' => $changeProvider, 'ruleProvider' => $ruleProvider, 'taskProvider' => $taskProvider)); }
public function getTasks() { return DiscoveryTask::find()->where(['sync_id' => $this->id])->orderBy(['started_at' => SORT_DESC]); }