public function run()
{
$bars = [];
if (BackendAccessControl::checkPermissionAccess(UserController::BACKEND_PERMISSION)) {
$usersCount = User::find()->where(['status' => User::STATUS_ACTIVE])->count();
$bars[] = ['bgClass' => 'bg-blue', 'label' => Yii::t('b/radiata/common', 'Total users'), 'data' => $usersCount, 'icon' => 'fa-user', 'url' => Url::to(['user/index'])];
}
if (BackendAccessControl::checkPermissionAccess(NewsController::BACKEND_PERMISSION)) {
$newsCount = News::find()->count();
$bars[] = ['bgClass' => 'bg-olive', 'label' => Yii::t('b/news', 'Total news'), 'data' => $newsCount, 'icon' => 'fa-bars', 'url' => Url::to(['/news/news/index'])];
}
if (BackendAccessControl::checkPermissionAccess(VoteController::BACKEND_PERMISSION)) {
$newsCount = Vote::find()->count();
$bars[] = ['bgClass' => 'bg-aqua', 'label' => Yii::t('b/vote', 'Total votes'), 'data' => $newsCount, 'icon' => 'fa-question-circle', 'url' => Url::to(['/vote/vote/index'])];
}
if (BackendAccessControl::checkPermissionAccess(BannerController::BACKEND_PERMISSION)) {
$newsCount = Banner::find()->count();
$bars[] = ['bgClass' => 'bg-maroon', 'label' => Yii::t('b/banner', 'Total banners'), 'data' => $newsCount, 'icon' => 'fa-flag', 'url' => Url::to(['/vote/vote/index'])];
}
if (BackendAccessControl::checkRoleAccess('developer')) {
$migrator = new Migrator();
$migrations = $migrator->findNewMigrations();
if (count($migrations) > 0) {
$bars[] = ['bgClass' => 'bg-gold', 'label' => Yii::t('b/radiata/common', 'New migrations'), 'data' => count($migrations), 'icon' => 'fa-database', 'url' => Url::to(['radiata/apply-migrations']), 'more' => Yii::t('b/radiata/common', 'Apply migrations')];
}
}
if (count($bars) > 0) {
return $this->render('SiteStatsBars', ['bars' => $bars]);
}
}
/**
* Drop table by name (need to manually drop all tables from DB since phpunit clears only data)
*
* @param array $tables
* @throws \yii\base\NotSupportedException
* @throws \yii\db\Exception
*/
public function dropTables($tables)
{
foreach ($tables as $table) {
if ($table[0] == '{') {
$this->migrator->getDbConnection()->createCommand("DROP TABLE IF EXISTS " . $table)->execute();
} else {
$this->migrator->getDbConnection()->createCommand("DROP TABLE IF EXISTS " . $this->migrator->getDbConnection()->getSchema()->quoteTableName($table))->execute();
}
}
}
/**
* Migrations perform
*
* @param array $config
* @return array
*/
public function migrate($config = [])
{
$migrator = new Migrator($config);
$migrations = $migrator->migrate();
if (is_object($migrator->error)) {
return ['error' => $migrator->error->getMessage()];
} else {
return ['migrations' => $migrations];
}
}
public function actionApplyMigrations()
{
if (Yii::$app->request->isAjax) {
$migrator = new Migrator();
$migrator->migrate();
Yii::$app->response->format = Response::FORMAT_JSON;
$result = [];
if ($migrator->error) {
$result['error'] = $migrator->error->getMessage();
} else {
$result['success'] = Yii::t('b/radiata/common', 'Migrations were applied successfully');
}
return $result;
}
}
