frontend/controllers/CatalogController.php

<?php
namespace frontend\controllers;
use common\modules\product\Filter;
use common\modules\product\helpers\ProductHelper;
use common\modules\rubrication\models\TaxOptionSearch;
use frontend\models\ProductFrontendSearch;
use Yii;
use common\modules\product\models\Brand;
use common\modules\product\models\BrandSearch;
use common\modules\product\models\Category;
use common\modules\product\models\CategorySearch;
use common\modules\product\models\Product;
use common\modules\product\models\ProductCategory;
use common\modules\product\models\ProductOption;
use common\modules\product\models\ProductSearch;
use common\modules\product\models\ProductVariant;
use common\modules\rubrication\models\TaxGroup;
use common\modules\rubrication\models\TaxOption;
use common\modules\rubrication\models\TaxValueString;
use yii\data\ActiveDataProvider;
use yii\data\Pagination;
use yii\data\Sort;
use yii\db\ActiveQuery;
use yii\helpers\ArrayHelper;
use yii\web\HttpException;
use yii\helpers\VarDumper;
class CatalogController extends \yii\web\Controller
{
    public function actionSearch() {
        // @todo
    }
    public function actionCategory()
    {
        /** @var Category $category */
        $category = Yii::$app->request->get('category');
        $filter = Yii::$app->request->get('filters', [ ]);
        $filter_check = $filter;
        if(empty( $category->category_id ) && empty( $word )) {
            return $this->render('catalog');
        }
        ProductHelper::addLastCategory($category->category_id);
        $params = [ ];
        $optionsList = ArrayHelper::getColumn(TaxGroup::find()
            ->where([ 'is_filter' => 'TRUE' ])
            ->all(), 'alias');
        if(!empty( $filter[ 'brands' ] )) {
            unset( $filter_check[ 'brands' ] );
            $brands = Brand::find()
                ->select('brand_id')
                ->where([
                    'in',
                    'alias',
                    $filter[ 'brands' ],
                ])
                ->all();
            $params[ 'brands' ] = [ ];
            foreach($brands as $brand) {
                $params[ 'brands' ][] = $brand->brand_id;
            }
        }
        if(!empty( $filter[ 'special' ] )) {
            unset( $filter_check[ 'special' ] );
            if(!is_array($filter[ 'special' ])) {
                $filter[ 'special' ] = [ $filter[ 'special' ] ];
            }
            if(in_array('new', $filter[ 'special' ])) {
                $params[ 'special' ][ 'is_new' ] = true;
            }
            if(in_array('top', $filter[ 'special' ])) {
                $params[ 'special' ][ 'is_top' ] = true;
            }
            if(in_array('promo', $filter[ 'special' ])) {
                $params[ 'special' ][ 'akciya' ] = true;
            }
        }
        if(!empty( $filter[ 'prices' ] )) {
            unset( $filter_check[ 'prices' ] );
            $params[ 'prices' ] = $filter[ 'prices' ];
        }
        foreach($optionsList as $optionList) {
            if(isset( $filter[ $optionList ] )) {
                unset( $filter_check[ $optionList ] );
                $params[ $optionList ] = $filter[ $optionList ];
            }
        }
        if(!empty( $filter_check )) {
            $filter = array_diff_key($filter, $filter_check);
            Yii::$app->response->redirect([
                'catalog/category',
                'category' => $category,
                'filters'  => $filter,
            ], 301);
        }
        $productModel = new ProductFrontendSearch();
        //$productQuery = $productModel->getSearchQuery($category, $params);
        $productProvider = $productModel->search($category, $params);
        $brandModel = new BrandSearch();
        $brands = $brandModel->getBrands($category, $params)
            ->all();
        $groups = $category->getActiveFilters()->all();
        $groups = ArrayHelper::index($groups, null, 'name');
        $priceLimits = $productModel->priceLimits($category, $params);
        /*
         * Greedy search for comments and rating
         */
        $query = $productProvider->query;
        $query->with([
            'variant',
            'comments',
            'averageRating',
        ]);
        /*
         * End of greedy search for rating and comments
         */
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
            'pagination' => [
                'pageSize' => 15,
            ],
        ]);
        $products = Product::find()->joinWith('categories')
            ->where([
                'category.category_id' => $category->getChildrenByDepth(2)->column(),
            ]);
        $productsProvider = new ActiveDataProvider([
            'query' => $products,
            'pagination' => [
                'pageSize' => 15,
            ],
        ]);
        $stockProgram = Category::find()
            ->where([
                'stock_program' => true,
                'parent_id' => $category->category_id,
            ])->all();
        $onOrder = Category::find()
            ->where([
                'on_order' => true,
                'parent_id' => $category->category_id,
            ])->all();
        return $this->render('products', [
            'category'        => $category,
            'brandModel'      => $brandModel,
            'dataProvider' => $dataProvider,
            'brands'          => $brands,
            'filter'          => $filter,
            'params'          => $params,
            'productModel'    => $productModel,
            'productsProvider' => $dataProvider,
            'groups'            => $groups,
            'priceLimits'     => $priceLimits,
            'stockProgram' => $stockProgram,
            'onOrder' => $onOrder,
        ]);
    }
    /**
     * @param string $product
     * @param string $variant
     * @return string
     */
    public function actionProduct($product, $variant)
    {
        $product = Product::find()
            ->joinWith([
                'variants' => function($query) {
                    $query->indexBy('sku');
                }
            ], true, 'INNER JOIN')
            ->where([
                'product.alias' => $product,
                'product_variant.sku' => $variant,
            ])->with('category.parent')->one();
        $variant = $product->variants[$variant];
        $variants = $product->variants;
        return $this->render('view', [
            'variants' => $variants,
            'product' => $product,
            'variant' => $variant,
        ]);
    }
    public function actionBrands()
    {
        $dataProvider = new ActiveDataProvider([
            'query' => Brand::find()->orderBy('name'),
            'pagination' => [
                'pageSize' => -1,
            ]
        ]);
        return $this->render('brands', [
            'dataProvider' => $dataProvider,
        ]);
    }
    public function actionBrand($brand)
    {
        $brand = BrandSearch::findByAlias($brand);
        $params = [
            'brands' => $brand->brand_id,
        ];
        $productModel = new ProductFrontendSearch();
        $productProvider = $productModel->search(null, $params);
        $priceLimits = $productModel->priceLimits(null, $params);
        return $this->render('brand', [
            'productModel'      => $productModel,
            'productProvider'   => $productProvider,
            'brand'             => $brand,
            'priceLimits'       => $priceLimits,
        ]);
    }
}