public function search($params) { $query = FilterVariant::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => false]); $this->load($params); if (!$this->validate()) { return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'filter_id' => $this->filter_id]); $query->andFilterWhere(['like', 'value', $this->value]); return $dataProvider; }
public function filtered($filterIds = false, $mode = 0) { if (!$filterIds) { $filterIds = Yii::$app->request->get($this->fieldName); } if (empty($filterIds)) { return $this->owner; } $condition = ['OR']; $variantCount = 0; $filterCount = count($filterIds); foreach ($filterIds as $filterId => $value) { $filter = Filter::findOne($filterId); if ($filter->type == 'range' && is_string($value)) { $value = explode(';', $value); if ($value[0] != $value[1]) { $variants = FilterVariant::find()->where('filter_id = :filterId AND (numeric_value >= :min AND numeric_value <= :max)', [':filterId' => $filterId, ':min' => $value[0], ':max' => $value[1]])->select('id')->all(); } else { $variants = FilterVariant::find()->where('filter_id = :filterId AND numeric_value = :value', [':filterId' => $filterId, ':value' => $value[0]])->select('id')->all(); } $variantIds = ArrayHelper::map($variants, 'id', 'id'); } else { $variantIds = $value; } $condition[] = ['filter_id' => $filterId, 'variant_id' => $variantIds]; if ($mode == 1) { $variantCount += count($variantIds); } else { $variantCount++; } } $filtered = FilterValue::find()->select('item_id')->groupBy('item_id')->andHaving("COUNT(DISTINCT `filter_id`) = {$variantCount}")->andFilterWhere($condition); if ($filtered->count() > 0) { $this->owner->andWhere(['id' => $filtered]); } else { $this->owner->andWhere(['id' => 0]); } return $this->owner; }