horat1us/yii2-criteria

Criteria implementation for Yii2

Yii2 Criteria

This package helps dealing with multiple search params., _(*1)

Installing

Using composer:, _(*2)

composer require horat1us/yii2-criteria

Requires PHP >= 7.0, yii2 >= 2.0.13, _(*3)

Usage

This code will find SomeActiveRecord with specified id (from URL)., _(*4)

<?php

use YourApp\SomeActiveRecord;

use yii\db\Query;
use yii\base\Model;

use Horat1us\Yii\Criteria\Interfaces\CriteriaInterface;
use Horat1us\Yii\Criteria\Factories\QueryFactory;

$query = SomeActiveRecord::find();
$factory = new QueryFactory($query);

$factory->push(new class extends Model implements CriteriaInterface {

    public $id;

    public function rules()
    {
        return [['id', 'integer',]];
    }

    public function formName()
    {
        return 'IdCriteria';
    }

    public function apply(Query $query): Query {
        return $query->andWhere(['=', 'id', (int)$this->id]);
    }

});

$record = $factory->apply(\Yii::$app->request->queryParams)->one();
print_r($record->id, $_GET['IdCriteria']['id']); // true

Pre-cooked criteria

• SortCriteria
• SearchCriteria
• PaginationCriteria

Factories

• AggregationFactory
• QueryFactory

Tips

To set default params for criteria (for example, PaginationCriteria) configure your yii\db\Container in bootstrap.php file:, _(*5)

<?php

use Horat1us\Yii\Criteria\PaginationCriteria;

Yii::$container->set(
    PaginationCriteria::class,
    [
        'class' => PaginationCriteria::class,

        'page' => 1,
        'pageSize' => 10,

        'allowedPageSize' => [1, 5, 10,],
    ]
);

Contributors

Alexander Letnikow, _(*6)

License

MIT, _(*7)

Todo

• Tests