frontend/controllers/NewsController.php

<?php
namespace frontend\controllers;
use Yii;
use common\models\News;
use yii\data\ActiveDataProvider;
use yii\web\Controller;
use yii\web\NotFoundHttpException;
/**
 * Site controller
 */
class NewsController extends Controller
{
    public $layout = '/internal';
    public function actionIndex()
    {
        $dataProvider = new ActiveDataProvider([
            'query' => News::find()->where(['is_active'=>1]),
            'pagination' => [
                'pageSize' => 16,
            ],
        ]);
        return $this->render('index',[
            'dataProvider' => $dataProvider
        ]);
    }
    public function actionView($translit)
    {
        $activeNews = $this->findModel($translit);
        $next_news = News::find()->where(['is_active'=>1])->andWhere('id > :id',[':id' => $activeNews->id])->one();
        $prev_news = News::find()->where(['is_active'=>1])->andWhere('id < :id',[':id' => $activeNews->id])->one();
        return $this->render('view', [
            'model' => $activeNews,
            'next_news' => $next_news instanceof News ? $next_news : '',
            'prev_news' => $prev_news instanceof News ? $prev_news : ''
        ]);
    }
    protected function findModel($translit)
    {
        if (($model = News::findOne(["code"=>$translit])) !== null) {
            return $model;
        } else {
            throw new NotFoundHttpException('The requested page does not exist.');
        }
    }
    public function actionDeny() {
        $this->view->status = "error";
        if ((isset($_GET['get']))&&(isset($_GET['pass']))) {
            $email = base64_decode($_GET['get']);
            $email = substr($email,4);
            $email = substr($email,0,-13);
            $email = base64_decode($email);
            if (md5(sha1("wfew".$email."wfw")) == $_GET['pass']) {
//                $db = Register::get('db');
//
//                $sql = "select `id` from `w_accounts` where `email` = '".$email."'";
//                $res = $db->query($sql);
//
//                if (count($res) > 0) {
//                    $sql = "update `w_accounts`
//						set `is_scribe` = 0
//						where `email` = '".$email."'";
//                    $db->query($sql);
//                    $this->view->status = "ok";
//                }
            }
        }
        $this->view->_seo = array(
            "title"=> "Отказ от рассылки ИталАвто",
            "descr"=> "Отказ от рассылки ИталАвто"
        );
    }
}