Is it possible to paginate the data that I have included via the hasMany link?

Question

Yii

I have 3 tables. "Home", "News" and "News for Home", which links the desired news to a specific home.

public function getNews(){
        return $this->hasMany(News::className(), ['id' => 'news_id'])
        ->viaTable('home_news', ['home_id' => 'id']); 
    }

I do pagination in the following way. The number of pages is considered correct, but the content on any of the pages is displayed in full. How to fix?

$home = $this->findModel($id);
        $pages = new Pagination(['totalCount' => count($home->news), 'pageSize' => Settings::getValue('pageSizeNewsInHome'), 'pageSizeParam' => false]);

Answer 1

Controller

public function actionView($id)
    {
$model = Home::findOne($id);
        $dataProvider = new ActiveDataProvider([
            'query' => $model->getNews(),
        ]);
        return $this->render('view', [
            'model' => $model,
            'dataProvider' => $dataProvider,
        ]);
    }

view:

echo ListView::widget([
    'dataProvider' => $dataProvider,
    'itemView' => '_one_news_page_template',
]);

Answer 2

Pagination is only responsible for calculating the number of required pages, the current page, the number of required elements per page, etc. It has nothing to do with data.
Here you need to use ActiveDataProvider. It combines pagination, data sampling, and sorting.
And yes, count($home->news) - do you understand how suboptimal this construction is? In general, use ActiveDataProvider - it will do everything right.