PHP app\models NewsItem::query Beispiele

Beispiel #1

Datei: index.php Projekt: Makeyko/galaxysss

            class="featurette-image img-responsive center-block"
            src="/images/index/x_83bd0a57.jpg"
            alt="Generic placeholder image"
            >

    </div>
</div>

<!-- Новости -->
<div>
    <hr class="featurette-divider">
    <div class="col-lg-12">
        <h1 class="page-header">Последние новости Планеты Земля</h1>
    </div>
    <?php 
foreach (\app\models\NewsItem::query()->orderBy(['date_insert' => SORT_DESC])->limit(3)->all() as $row) {
    echo \app\services\GsssHtml::newsItem($row);
}
?>
    <div class="col-lg-12">
        <a
            class="btn btn-default"
            style="width:100%"
            href="<?php 
echo Url::to(['page/news']);
?>
"
            >Все новости</a>
    </div>
</div>

Beispiel #2

Datei: PageController.php Projekt: Makeyko/galaxysss

 public function actionNews_item($year, $month, $day, $id)
 {
     $date = $year . $month . $day;
     $newsItem = NewsItem::find(['date' => $date, 'id_string' => $id]);
     if (is_null($newsItem)) {
         throw new Exception('Нет такой новости');
     }
     $newsItem->incViewCounter();
     $row = $newsItem->getFields();
     return $this->render(['newsItem' => $newsItem->getFields(), 'lastList' => NewsItem::query()->where(['not in', 'id', $row['id']])->orderBy(['date_insert' => SORT_DESC])->limit(3)->all()]);
 }

Beispiel #3

Datei: AdminController.php Projekt: Makeyko/galaxysss

 public function actionNews()
 {
     return $this->render(['items' => NewsItem::query()->orderBy(['date_insert' => SORT_DESC])->all()]);
 }