Yii2-Simple-Filter

Simple Yii2 Checkbox Filter Module

  • 所有者: sanex3339/Yii2-Simple-Filter
  • 平台:
  • 许可证:
  • 分类:
  • 主题:
  • 喜欢:
    0
      比较:

Github星跟踪图

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!

主要指标

概览
名称与所有者sanex3339/Yii2-Simple-Filter
主编程语言PHP
编程语言PHP (语言数: 3)
平台
许可证
所有者活动
创建于2015-02-24 14:33:27
推送于2016-03-19 15:54:37
最后一次提交2015-04-10 18:51:02
发布数5
最新版本名称0.9.1 (发布于 )
第一版名称0.7.0 (发布于 )
用户参与
星数17
关注者数5
派生数13
提交数20
已启用问题?
问题数5
打开的问题数4
拉请求数2
打开的拉请求数0
关闭的拉请求数0
项目设置
已启用Wiki?
已存档?
是复刻?
已锁定?
是镜像?
是私有?