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));
}
