How to implement data output by the yii2 LinkPager widget according to a certain criterion?

Question

Yii

There is a LinkPager widget and Yii2. The widget displays multiple entries per page. The rest is paginated.
How can I make it show posts only with the selected criteria?
For example, according to the filled field "publication"? If the value is 1, then outputs. If there is no value, then it does not display.

Answer 1

Initially, the paginator code in the controller was like this:

public function actionIndex()
    {

        $query = Orders::find();

        $pagination = new Pagination([
            'defaultPageSize' => 5,
            'totalCount' => $query->count(),
        ]);

        $orderies = $query->orderBy('id')
            ->offset($pagination->offset)
            ->limit($pagination->limit)
            ->all();

        return $this->render('index', [
            'orderies' => $orderies,
            'pagination' => $pagination,
        ]);
    }

Added to the controller in the line
Such a line This line
will turn out
Then, in all models, added active. Added an active column to the database.
Now, with a value of 0, which is written to the database when sending, the record does not get into pagination. If you change in the CRUD editor to one, then it is displayed.

Answer 2

One of the parameters of the LinkPager widget is DataProvider, in the controller (if you used Gii) it is created as $dataProvider = $searchModel->search(Yii::$app->request->queryParams); you can add your terms.