<?php namespace app\controllers; use app\components\Collection; use app\models\Host; use Yii; use yii\filters\AccessControl; use yii\web\Controller; use yii\web\Response; use yii\filters\VerbFilter; use app\models\LoginForm; use app\models\ContactForm; use yii\web\View; class SiteController extends Controller { /** * {@inheritdoc} */ public function behaviors() { return [ 'access' => [ 'class' => AccessControl::className(), 'rules' => [ [ 'actions' => ['index', 'logout'], 'allow' => true, 'roles' => ['@'], ], ], ], 'verbs' => [ 'class' => VerbFilter::className(), 'actions' => [ 'logout' => ['post'], ], ], ]; } /** * {@inheritdoc} */ public function actions() { return [ 'error' => [ 'class' => 'yii\web\ErrorAction', ], 'captcha' => [ 'class' => 'yii\captcha\CaptchaAction', 'fixedVerifyCode' => YII_ENV_TEST ? 'testme' : null, ], ]; } /** * Displays homepage. * * @return string */ public function actionIndex() { //var_dump(Yii::$app->user->isGuest); //var_dump(Yii::$app->user->identity); $statistics = ['csv_date' => '']; $statistics['c_status'] = (new yii\db\Query()) ->select(['COUNT(*) AS cnt', 'wis_status']) ->from('{{%host}}') ->groupBy(['csv_date']) ->all(); $csv = Host::find()->select(['csv_date'])->orderBy('csv_date ASC')->one(); if ($csv) { $statistics['csv_date'] = $csv['csv_date']; } return $this->render('index', ['statistics'=>$statistics]); } }