/** * Search products * @param $data StoreCategory|string * @param string $view */ public function doSearch($data, $view) { $this->query = new StoreProduct(null); $this->query->attachBehaviors($this->query->behaviors()); $this->query->applyAttributes($this->activeAttributes)->active(); if ($data instanceof StoreCategory) { $this->query->applyCategories($this->model); } else { $cr = new CDbCriteria(); $cr->with = array('translate' => array('together' => true)); $cr->addSearchCondition('translate.name', $data); $this->query->getDbCriteria()->mergeWith($cr); } // Filter by manufacturer if (Yii::app()->request->getQuery('manufacturer')) { $manufacturers = explode(';', Yii::app()->request->getParam('manufacturer', '')); $this->query->applyManufacturers($manufacturers); } // Create clone of the current query to use later to get min and max prices. $this->currentQuery = clone $this->query->getDbCriteria(); // Filter products by price range if we have min_price or max_price in request $this->applyPricesFilter(); $per_page = $this->allowedPageLimit[0]; if (isset($_GET['per_page']) && in_array((int) $_GET['per_page'], $this->allowedPageLimit)) { $per_page = (int) $_GET['per_page']; } $this->provider = new CActiveDataProvider($this->query, array('id' => false, 'pagination' => array('pageSize' => $per_page))); $this->provider->sort = StoreProduct::getCSort(); $this->render($view, array('provider' => $this->provider, 'itemView' => isset($_GET['view']) && $_GET['view'] === 'wide' ? '_product_wide' : '_product')); }
/** * Display products by manufacturer * * @param $url * @throws CHttpException */ public function actionIndex($url) { $this->model = StoreManufacturer::model()->findByAttributes(array('url' => $url)); if (!$this->model) { throw new CHttpException(404, Yii::t('StoreModule.core', 'Производитель не найден.')); } $query = new StoreProduct(null); $query->attachBehaviors($query->behaviors()); $query->active(); $query->applyManufacturers($this->model->id); $provider = new CActiveDataProvider($query, array('id' => false, 'pagination' => array('pageSize' => $this->allowedPageLimit[0]))); $this->render('index', array('provider' => $provider)); }
/** * Count products by attribute and option * @param StoreAttribute $attribute * @param string $option option id to search * @todo Optimize attributes merging * @return string */ public function countAttributeProducts($attribute, $option) { $model = new StoreProduct(null); $model->attachBehaviors($model->behaviors()); $model->active()->applyCategories($this->model)->applyMinPrice($this->convertCurrency(Yii::app()->request->getQuery('min_price')))->applyMaxPrice($this->convertCurrency(Yii::app()->request->getQuery('max_price'))); if (Yii::app()->request->getParam('manufacturer')) { $model->applyManufacturers(explode(';', Yii::app()->request->getParam('manufacturer'))); } $data = array($attribute->name => $option->id); $current = $this->getOwner()->activeAttributes; $newData = array(); foreach ($current as $key => $row) { if (!isset($newData[$key])) { $newData[$key] = array(); } if (is_array($row)) { foreach ($row as $v) { $newData[$key][] = $v; } } else { $newData[$key][] = $row; } } $newData[$attribute->name][] = $option->id; return $model->withEavAttributes($newData)->count(); }