Allows searching/filtering of an array. This component is very useful when displaying array data in GridViews with an ArrayDataProvider.
The preferred way to install this extension is through composer.
Either run
php composer.phar require --prefer-dist yii2mod/yii2-array-query "*"
or add
"yii2mod/yii2-array-query": "*"
to the require section of your composer.json.
You may execute complex query on the array data using [[\yii2mod\query\ArrayQuery]] class. This class works similar to regular [[\yii\db\Query]] and uses same syntax. For example:
$data = [
[
'id' => 1,
'username' => 'admin',
'email' => '[email protected]'
],
[
'id' => 2,
'username' => 'test',
'email' => '[email protected]'
],
];
$query = new ArrayQuery();
$query->from($data);
$query->where(['username' => 'admin']);
$rows = $query->all();You may perform filtering using [[\yii2mod\query\ArrayQuery]] class. For example:
<?php
// Some search model
/**
* Setup search function for filtering and sorting.
* @param $params
* @return ArrayDataProvider
*/
public function search($params)
{
$models = User::find()->asArray()->all();
$query = new ArrayQuery();
$query->from($models);
// load the search form data and validate
if ($this->load($params) && $this->validate()) {
// adjust the query by adding the filters
$query->andFilterWhere(['id' => $this->id]);
$query->andFilterWhere(['status' => $this->status]);
$query->andFilterWhere(['like', 'username', $this->username]);
$query->andFilterWhere(['like', 'email', $this->email]);
}
// prepare the ArrayDataProvider
return new ArrayDataProvider([
'allModels' => $query->indexBy('id')->all(),
'sort' => [
'attributes' => ['id', 'username', 'email', 'status'],
],
'pagination' => [
'pageSize' => 10
],
]);
}Does your business depend on our contributions? Reach out and support us on Patreon. All pledges will be dedicated to allocating workforce on maintenance and new awesome stuff.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent