Skip to content
Simple Yii2 Checkbox Filter Module
Branch: master
Clone or download
kachalov
kachalov 0.9.1dev fix
Latest commit bdd5eaa Apr 10, 2015
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
assets version 0.7.0 Mar 9, 2015
components 0.9.1dev fix Apr 10, 2015
controllers 0.9.0dev changed way to correcting invalid gridview urls Apr 10, 2015
css 0.9.1dev fix Apr 10, 2015
img version 0.7.0 Mar 9, 2015
js
views/filter 0.9.0dev, ie9 support, refactoring Apr 9, 2015
.gitignore js code refactoring Apr 6, 2015
Bootstrap.php 0.9.0dev remove dead code in js Apr 10, 2015
README.md
README.ru.md 0.9.1dev refactoring, ability to set cache duration, encrypted data i… Apr 10, 2015
SimpleFilter.php 0.9.0dev refactoring Apr 10, 2015
composer.json

README.md

Yii2-Simple-Filter

Yii2 Simple Filter Module

Yii2 Simple Filter Module v0.9.1dev #####Not compatible with older versions, because methods names were changed!

Video: http://www.youtube.com/watch?v=Vah2j5WzXIs

###Installation: How to install and configure modlue on clear Yii2 Base application (video): http://www.youtube.com/watch?v=Wnn_xVcTun0

Install module through composer

Run

$ php composer.phar require --prefer-dist sanex/yii2-simple-filter "dev-master"

or add

"sanex/yii2-simple-filter": "dev-master"

to the require section of composer.json file.

Last step: add 'enablePrettyUrl' => true to the urlManager in config file. ######Module not working with 'enablePrettyUrl' => false!

###How to use?

####Controller: In controller, which has view (main view), where you want show data with filter, you must create object with instance of SimplyFilter module and set to him parameters:

use sanex\simplefilter\SimpleFilter;

...

$model = new Catalog;

$ajaxViewFile = '@sanex/catalog/views/catalog/catalog-ajax';

$filter = SimpleFilter::getInstance();
$filter->setParams([
    'model' => $model,
    'query' => $query,
    'useAjax' => true,
    'useCache' => true,
    'useDataProvider' => true,
]);

$ajaxViewFile - alias (or path) to ajax view, where you want to show data. You must create that view file before continue.

setParams() properties:

model - model, which data need to filter;

query - (optional) - \yii\db\ActiveQuery object, see below;

useAjax - (optional, if not set - true) you can choose between Ajax or non-Ajax filtering by setting this parameter to boolean true or false values;

useCache - (optional, if not set - false) if (bool) true - return cached data, if (int) value - cache duration in seconds;

useDataProvider - (optional, if not set - false) if (bool) true - return data in Ajax View as dataProvider, if (bool) false or not set - return data as model;

As default, result query with filter looks like SELECT COUNT(*) FROM 'catalog' WHERE 'color' IN ('Green', 'Red')

If you want create custom query with filter you must set query parameter in setParams() method with \yii\db\ActiveQuery object as method parameter, that contain query parameters.

$query = new \yii\db\ActiveQuery($model);
$query->select(['id', 'name', 'size', 'price', 'country'])->where(['country' => 'Canada'])->orderBy(['price' => SORT_ASC]); 

Method limit() of \yii\db\ActiveQuery object can set parameter 'pagination' => ['pageSize' => $this->limit], of ActiveDatapProvider object.

$query = new \yii\db\ActiveQuery($model);
$query->limit(25); 

If limit() method not set, then limit for each query will set to default value - 50 rows per page.

If you want to use custom pagination with this filter, you can get offset from GET-paremeter page. Need to know, what for page values 0 and 1, offset value will 0, for all other values - will calculated by formula (page - 1) * limit.

In main view, you must call setFilter() method contain array with filter parameters. ######Note! property must be same as names of table columns which you want to filter, and values must be same as this columns data.

####Main View

$filter->setFilter([
    [
        'property' => 'color',
        'caption' => 'Color',
        'values' => [
            'Red',
            'Green',
            'Blue',
            'Black'
        ],
        'class' => 'horizontal'
    ],
    [
        'property' => 'size',
        'caption' => 'Size',
        'values' => [
            '45x45',
            '50x50',
            '60x60'
        ]
    ]
]);

You can set additional class or classes to each filters group by setting class property. This filter has two default style for checkbox: horizontal and vertical class for vertical checkboxes placement. If class property not set, used horizontal class as default. You can set class value as string: 'class' => 'horizontal additional class' or as array: 'class' => ['vertical', 'additionalClass']

Then, where you want to render ajax view with filtered data, call renderAjaxView() method:

$filter->renderAjaxView($ajaxViewFile, ['testParam' => $testParam]);

$ajaxViewFile - Ajax View file;

(array)$ajaxViewParams - (optional) parameters, that will be send to ajax view.

####Ajax View In ajax view, you can get filtered data (model or dataProvider) through $simpleFilterData variable.

######Note! Module pass to ajax view only data! You must create in that ajax view <table></table> or use GridView widget to show data, same way as with all other Yii2 models!

You can’t perform that action at this time.