Yarik / artbox-shop

  <?php

      namespace common\models;
      

      use artbox\catalog\models\Category;
      use artbox\catalog\models\Product;

      use yii\base\Model;

      use yii\db\ActiveQuery;

      
      /**
       * Class SearchForm for performing search around site.
       */
      class SearchForm extends Model
      {
          /**
           * @var string $word
           */
          public $word;
          
          /**
           * @inheritdoc
           */
          public function rules()
          {
              return [
                  [
                      [ 'word' ],

                      'required',
                      'message' => \Yii::t('app', 'Write text to search for.'),
                  ],
                  [
                      [ 'word' ],

                      'string',

                      'min'      => 3,
                      'message'  => \Yii::t('app', 'Write at least 3 symbols.'),
                      'tooShort' => \Yii::t('app', 'Write at least 3 symbols.'),

                  ],
              ];
          }
          
          /**
           * @inheritdoc
           */
          public function attributeLabels()
          {
              return [
                  'word' => \Yii::t('app', 'Поиск по сайту'),
              ];
          }

          
          public function search()
          {
              return Product::find()
                            ->joinWith('lang')
                            ->joinWith('variants.lang')
                            ->andWhere(
                                [
                                    'product.status' => true,
                                    'variant.status' => true,
                                ]
                            )
                            ->andWhere(
                                [
                                    'like',
                                    'product_lang.title',
                                    $this->word,
                                ]
                            )
                            ->orWhere(
                                [
                                    'like',
                                    'variant_lang.title',
                                    $this->word,
                                ]
                            )
                            ->orWhere([ 'variant.sku' => $this->word ])
                            ->groupBy('product.id');
          }
          
          public function searchCategory(Category $category, ActiveQuery $query)
          {
              return $query->joinWith('productToCategories')
                           ->andWhere(
                               [
                                   'product_to_category.category_id' => $category->id,
                               ]
                           );
          }

      }