$itemsQuery = BlogPost::find()->where(['is_active'=>true])->limit(10)->orderBy('date DESC'); if ($tag){ $tag=Tag::find()->where(['tag'=>$tag])->one(); $itemsQuery->andWhere(['exists',(new Query())->from('blog_post_tag_link')->where(['tag_id'=>$tag->id])->andWhere('blog_post.id=blog_post_tag_link.blog_post_id')]); } $tags = Tag::find() ->select(['tag.*','posts_count'=>'max(cl.cn)',]) ->leftJoin(['cl'=>(new Query())->select(['tag_id','cn'=>'(CASE WHEN count(*) IS NUll THEN 0 ELSE count(*) END)'])->from('blog_post_tag_link')->groupBy(['blog_post_tag_link.tag_id'])],'cl.tag_id=tag.id') ->where('cl.cn is not null') ->groupBy('tag.id')
$itemsQuery = BlogPost::find()->where(['is_active'=>true])->limit(10)->orderBy('date DESC'); if ($tag){ $tag=Tag::find()->where(['tag'=>$tag])->one(); $itemsQuery->andWhere(['exists',(new Query())->from('blog_post_tag_link')->where(['tag_id'=>$tag->id])->andWhere('blog_post.id=blog_post_tag_link.blog_post_id')]); } $tags = Tag::find() ->select(['tag.*','posts_count'=>'max(cl.cn)',]) ->leftJoin(['cl'=>(new Query())->select(['tag_id','cn'=>'(CASE WHEN count(*) IS NUll THEN 0 ELSE count(*) END)'])->from('blog_post_tag_link')->groupBy(['blog_post_tag_link.tag_id'])],'cl.tag_id=tag.id')
$args = $this->controller->bindActionParams($this, $params); Yii::trace('Running action: ' . get_class($this->controller) . '::' . $this->actionMethod . '()', __METHOD__); if (Yii::$app->requestedParams === null) { Yii::$app->requestedParams = $args; } return call_user_func_array([$this->controller, $this->actionMethod], $args); } }
} $result = null; if ($runAction && $this->beforeAction($action)) { // run the action $result = $action->runWithParams($params); $result = $this->afterAction($action, $result); // call afterAction on modules foreach ($modules as $module) { /* @var $module Module */
$parts = $this->createController($route); if (is_array($parts)) { /* @var $controller Controller */ list($controller, $actionID) = $parts; $oldController = Yii::$app->controller; Yii::$app->controller = $controller; $result = $controller->runAction($actionID, $params); if ($oldController !== null) { Yii::$app->controller = $oldController; } return $result; }
$params = $this->catchAll; unset($params[0]); } try { Yii::trace("Route requested: '$route'", __METHOD__); $this->requestedRoute = $route; $result = $this->runAction($route, $params); if ($result instanceof Response) { return $result; } else { $response = $this->getResponse(); if ($result !== null) { $response->data = $result;
try { $this->state = self::STATE_BEFORE_REQUEST; $this->trigger(self::EVENT_BEFORE_REQUEST); $this->state = self::STATE_HANDLING_REQUEST; $response = $this->handleRequest($this->getRequest()); $this->state = self::STATE_AFTER_REQUEST; $this->trigger(self::EVENT_AFTER_REQUEST); $this->state = self::STATE_SENDING_RESPONSE; $response->send();
require(__DIR__ . '/../../common/config/main.php'), require(__DIR__ . '/../../common/config/main-local.php'), require(__DIR__ . '/../config/main.php'), require(__DIR__ . '/../config/main-local.php') ); (new yii\web\Application($config))->run();
$_GET = [ 'tag' => '%D0%BF%D0%BE%D0%BB%D0%B5%D0%B7%D0%BD%D0%B0%D1%8F %D0%B8%D0%BD%D1%84%D0%BE%D1%80%D0%BC%D0%B0%D1%86%D0%B8%D1%8F', ];