Материалов
% Среднее за день
\app\models\base\News::find()->select(["SUBSTRING_INDEX(`editors`,',',1) as e"])->andwhere(['between', 'dt_pub', $b_date , $e_date])->groupBy(["e"]),
"pagination" =>false
]
);
$cnt = $newsDataProvidera->getCount();
$newsDataProvidera = new \yii\data\ActiveDataProvider(
[
"query"=>\app\models\base\News::find()->select('count(author)')->andwhere(['between', 'dt_pub', $b_date , $e_date])->andwhere(['<>', 'author', '5'])->groupBy(["author"]),
"pagination" =>false
]
);
$cnt2 = $newsDataProvidera->getCount();
$newsDataProvidera = new \yii\data\ActiveDataProvider(
[
"query"=>\app\models\base\News::find()->select('count(*)')->andwhere(['between', 'dt_pub', $b_date , $e_date])->andwhere(['<>', 'author', '5'])->andWhere(['show_author'=>'Y'])->groupBy(["author"]),
"pagination" =>false
]
);
$cnt3 = $newsDataProvidera->getCount();
?>
Авторов на ленте
(подписаны материалы: )
Указаны авторы