<?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' => '', 'whois_status'=>[], 'itx_status'=>[]];
        $statistics['whois_status'] = (new yii\db\Query())
            ->select(['COUNT(*) AS cnt', 'wis_status', 'status'])
            ->from('{{%host}}')
            ->groupBy(['wis_status', 'status'])
            ->all();

        $statistics['itx_status'] = (new yii\db\Query())
            ->select(['COUNT(*) AS cnt', 'tix_status', 'status'])
            ->from('{{%host}}')
            ->groupBy(['tix_status', 'status'])
            ->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]);
    }

}