'yii\filters\HttpCache', 'only' => ['index'], 'enabled' => true, 'cacheControlHeader' => 'public, max-age=120', 'lastModified' => function ($action, $params) { return time(); } ], ]; } public function actionIndex($topic=NULL) { $url = \Yii::$app->request->pathInfo; if( $url == 'news/' ){ $queryString = \Yii::$app->request->queryString?'?'.\Yii::$app->request->queryString:''; $this->redirect('/news'.$queryString, 301); return ''; } $gets = \Yii::$app->request->get(); $valid_get = array_filter($gets, function($k) { $valid = ['page'=>true,'daterange'=>true,'topic'=>true]; return isset( $valid[$k] ); }, ARRAY_FILTER_USE_KEY); if( count($gets) != count($valid_get) ){ $url = Url::toRoute(['news/index']+$valid_get); $this->redirect($url, 301); return ''; } if(\Yii::$app->request->get("page",0)>500) { \Yii::$app->request->setQueryParams(["page"=>500]); } $url = $topic; $topic = NewsTopic::findOne(['url'=>$topic,'active'=>1]); if(!$topic instanceof NewsTopic){ $topic = new \stdClass(); $topic->id = NULL; } if( $url && !$topic->id ) throw new NotFoundHttpException("Раздел не найден"); $pages = null; if( $topic->id ){ // $news_query = \app\models\front\News::find()->leftJoin('news_topic_relation t', 't.news_id = id')->andWhere(['t.topic_id'=>$topic->id]); $news_query = News::find() ->from(new Expression("news FORCE INDEX (top,calendar) , news_topic_relation t USE index(news_id)")) ->andWhere(new Expression('t.news_id=id')) ->andWhere(['t.topic_id'=>$topic->id]); $dateRange = \Yii::$app->request->get('daterange',NULL); $dateRanges = $dateRange; if(!is_null($dateRange) && $dateRange!=""){ $dateRange = explode(" — ",$dateRange); $dateRange[0] = date("Y-m-d 00:00:01",strtotime($dateRange[0])); $dateRange[1] = isset($dateRange[1])?date("Y-m-d 23:59:59",strtotime($dateRange[1])):date("Y-m-d 23:59:59",strtotime($dateRange[0])); $news_query->andWhere(["BETWEEN","dt_pub",$dateRange[0],$dateRange[1]]); } $cnt = \Yii::$app->cache->getOrSet('topic_cnt_'.$topic->id."_$dateRanges", function () use ($news_query){ return $news_query->count(); },7200); /* * Оптимизировано но не понятно как убрать автоматический offset при пагинации во внешнем селекте 4с->0.7c $sub_query = News::find()->select('news.id')->from(new Expression("news as news USE INDEX (calendar)")) ->join('inner join', 'news_topic_relation', 'news_topic_relation.news_id=news.id AND news_topic_relation.topic_id='.$topic->id)->offset($pages->offset)->limit($pages->limit); $news_query = News::find() ->from( 'news' ) ->join( 'join',['nl'=>$sub_query], 'news.id=nl.id' ); */ }else{ $news_query = \app\models\front\News::findFilter(); $keyadd = \app\models\front\News::keyFilter(); $dateRange = \Yii::$app->request->get('daterange',NULL); $dateRanges = crc32($dateRange); if(!is_null($dateRange) && $dateRange!=""){ $dateRange = explode(" — ",$dateRange); $dateRange[0] = date("Y-m-d 00:00:01",strtotime($dateRange[0])); $dateRange[1] = isset($dateRange[1])?date("Y-m-d 23:59:59",strtotime($dateRange[1])):date("Y-m-d 23:59:59",strtotime($dateRange[0])); $news_query->andWhere(["BETWEEN","dt_pub",$dateRange[0],$dateRange[1]]); } $cnt = \Yii::$app->cache->getOrSet('topic_cnt'.$keyadd."_$dateRanges", function () use ($news_query){ return $news_query->count(); },7200); } $cnt = ($cnt/20 > 500)?500*20:$cnt; $pages = new \yii\data\Pagination(['totalCount' => $cnt, 'pageSize'=>20]); if($topic instanceof NewsTopic){ /* Приведение к каноническому маршруту в пагинации */ unset($valid_get['topic']); $pages->params = $valid_get; $pages->route = 'news/'.$topic->url; // // Нормализация к каноническому URL // $queryString = \Yii::$app->request->queryString?'?'.\Yii::$app->request->queryString:''; if( \Yii::$app->request->url != '/'.$pages->route.$queryString ){ $url = Url::toRoute(['news/'.$topic->url]+$valid_get); /* echo \Yii::$app->request->url.'
'; echo $pages->route.$queryString.'
'; echo $url; */ $this->redirect($url, 301); return ''; } } //$pages->urlManager = Url::toRoute(['news/index']+$valid_get); // $headers = Yii::$app->response->headers; // $headers->set('Expires', gmdate('D, d M Y H:i:s \G\M\T', time() + (60 * 2))); return $this->render("index",["topic"=>$topic,"daterange"=>$dateRange,"news_query"=>$news_query,"pages"=>$pages,"keycahe"=>isset($keyadd)?$keyadd:'']); } public function actionStory($topic=NULL) { $topic = Story::findOne(['url'=>$topic]); if(!$topic instanceof Story){ $topic = new \stdClass(); $topic->id = NULL; } if( $topic->id ){ $news_query = \app\models\front\News::find()->leftJoin('story_relation t', 't.news_id = id')->andWhere(['t.topic_id'=>$topic->id]); //joinWith('topics t')->andFilterWhere(['t.id'=>$topic->id]); // print_r($news_query->createCommand()->rawSQL);exit; }else{ $news_query = \app\models\front\News::find(); // optimized } $cnt = \Yii::$app->cache->getOrSet('story_cnt_'.$topic->id, function () use ($news_query){ return $news_query->count(); },7200); $pages = new \yii\data\Pagination(['totalCount' => $cnt, 'pageSize'=>20]); $dateRange = \Yii::$app->request->get('daterange',NULL); if(!is_null($dateRange) && $dateRange!=""){ $dateRange = explode(" — ",$dateRange); $dateRange[0] = date("Y-m-d 00:00:01",strtotime($dateRange[0])); $dateRange[1] = isset($dateRange[1])?date("Y-m-d 23:59:59",strtotime($dateRange[1])):date("Y-m-d 23:59:59",strtotime($dateRange[0])); $news_query->andWhere(["BETWEEN","dt_pub",$dateRange[0],$dateRange[1]]); } return $this->render("index",["topic"=>$topic,"daterange"=>$dateRange,"news_query"=>$news_query,"pages"=>$pages]); } /** * @param int $id */ public function actionView(int $id) { $model = $this->findModel($id); if(!$model instanceof News) throw new NotFoundHttpException("Новость не найдена"); if( $link = trim( $model->link ) ){ $link = str_replace( 'http://www.amic.ru', '', $link); $this->redirect($link, 301); return ''; } $queryString = \Yii::$app->request->queryString?'?'.\Yii::$app->request->queryString:''; if( \Yii::$app->request->url != $model->getUrl().$queryString ){ $this->redirect($model->getUrl(true).$queryString, 301); return ''; } if(\Yii::$app->request->isPost){ $capcha_result = base64_decode(\Yii::$app->request->post('capcha_salt'))/3.14; if( \Yii::$app->request->post('capcha')=="" || \Yii::$app->request->post('capcha')!= $capcha_result ){ \Yii::$app->session->setFlash('danger','Ошибка размещения комментария, пример решен неверно. Правильный ответ был: '.$capcha_result); } else { if(\Yii::$app->request->post('message')!=""){ $comment = new Comments(); if( $comment::$conf->isActive() ){ $comment->fakename = str_replace('"',"'", (\Yii::$app->request->post('fakename'))); $comment->message = strip_tags(\Yii::$app->request->post('message'),''); $comment->news_id = $model->id; $comment->visible = ( $comment::$conf->isPreModerate() )?'N':'Y'; //если пользователь зареген поставить true $comment->ip_address = \Yii::$app->request->getRemoteIP().",".\Yii::$app->request->getUserIP(); $comment->user_agent = \Yii::$app->request->userAgent; $comment->created_at = date("Y-m-d H:i:s"); $comment->parent_id = \Yii::$app->request->post('parent_id'); $res = $comment->save(); if($res){ \Yii::$app->session->setFlash('success','Комментарий успешно отправлен на модерацию'); $this->redirect($model->getUrl()."#comments"); \Yii::$app->end(); } else { \Yii::$app->session->setFlash('danger','Ошибка размещения комментария'); } } } } } return $this->render('view',['model'=>$model]); } /** * @param string $uid * @return string */ public function actionUidView(string $uid):string { if( Uuid::isvalid($uid) ){ $model = \app\models\News::find()->andWhere(['uid'=>$uid])->one(); if(!$model instanceof \app\models\News) throw new NotFoundHttpException("Новость не найдена"); if( $model->active == 'N' || strtotime($model->dt_pub) > time() ){ return $this->render('view',['model'=>$model]); }else{ $this->redirect($model->geturl()); return ''; } }else{ throw new NotFoundHttpException("Новость не найдена"); } } public function actionStoryslugView($storyslug):string { $model = News::find()->andWhere(['alias'=>$storyslug])->one(); if(!$model instanceof News) throw new NotFoundHttpException("Новость не найдена"); return $this->render('view',['model'=>$model]); } public function actionInfinityNewsfeed($post_id,$last_post_id=NULL,$amount=0){ if($last_post_id=="null"){ $last_post = News::find()->limit(1)->one(); } else { $last_post = News::findOne(["id"=>$last_post_id]); } $feed = News::find() ->andWhere(['!=','id',$post_id]) //->andFilterWhere(['<','id',$last_post_id]) ->andFilterWhere(['<','dt_pub',$last_post->dt_pub]) ->limit(1) ->one(); if(!is_null($feed)){ return $this->asJson([ "id"=>$feed->id, "html"=>$this->renderPartial('/news/view/infinity_newsfeed/_item',["model"=>$feed,"index"=>$amount]) ]); } return NULL; } public function actionClike(){ if(\Yii::$app->request->isPost){ if(\Yii::$app->request->post('id') && \Yii::$app->request->post('grd') ){ $id = (int) \Yii::$app->request->post('id'); //комент $nid = (int) \Yii::$app->request->post('nid'); //новость $grd = (int) \Yii::$app->request->post('grd'); //градиент if( Comments::isUserLike($id) ) return $this->asJson(['err']); if( $id > 0 && ( $grd == 1 || $grd == -1 ) ){ $comment = Comments::findOne($id); $comment->likeed += $grd; if( $comment->save() ){ Comments::setUserLike($nid, $id); } } } } return $this->asJson(['ok']); } public function actionSsearch() { if (Yii::$app->request->isGet && $get = Yii::$app->request->get('query')){ $model = new Story(); $gets = mb_strlen( $get ) < 6?$get.'*':$get; $items = $model->search($gets, 10); $res = array(); $json = '{}'; $resj = json_decode($json); $resj->query = $get; if( $items && is_array( $items ) ){ foreach( $items as $item ){ $res[] = array( 'data'=>$item['id']*1, 'value'=>$item['title'] ); } $resj->suggestions = $res; return json_encode( $resj ); } } $json = '{}'; $resj = json_decode($json); $resj->query = $get; $resj->suggestions = []; return json_encode( $resj ); } private function findModel($id) { return News::find()->andWhere(['id'=>$id])->limit(1)->one(); } }