Administrator / test_1

  <?php
  
  namespace common\models;
  
  use Yii;
  use yii\base\Model;
  use yii\data\ActiveDataProvider;
  use common\models\GoodsView;
  
  /**
   * GoodsViewSearch represents the model behind the search form about `common\models\GoodsView`.
   */
  class GoodsViewSearch extends GoodsView
  {
      /**
       * @inheritdoc
       */
      public function rules()
      {
          return [

              [['name', 'brand'], 'safe'],

          ];
      }
  
      /**
       * @inheritdoc
       */
      public function scenarios()
      {
          // bypass scenarios() implementation in the parent class
          return Model::scenarios();
      }
  
      /**
       * Creates data provider instance with search query applied
       *
       * @param array $params
       *
       * @return ActiveDataProvider
       */

      public function search( $params, $sort )

      {
          $query = GoodsView::find();
  

          $this->load($params);
  
          if ( !$this->validate() ) {
               $query->where('0=1');
          }
  
          $query->andFilterWhere([
              'name' => $this->name,
              'brand' => $this->brand,
          ]);
  

  
          $query->andWhere(['or', 'box > 0', 'add_box > 0'])->orderBy( $sort );

  
          $dataProvider = new ActiveDataProvider([
              'query' => $query,

              'key' => 'name',

          ]);
  
          return $dataProvider;
      }

      public function searchCrosses( $params, $sort )

      {

          $query = GoodsView::find()->innerJoin('w_details_crosses', '`w_details_crosses`.`ARTICLE` = `name` and `w_details_crosses`.`BRAND` = w_goods_view.`brand`')->select('w_goods_view.*, w_details_crosses.CROSS_BRAND as crosses' );

  
          $this->load($params);
  
          if ( !$this->validate() ) {
               $query->where('0=1');
          }
  
          $query->andFilterWhere([

              'w_details_crosses.CROSS_ARTICLE' => $this->name,
              'w_details_crosses.CROSS_BRAND' => $this->brand,

          ]);
  

          $query->andWhere(['or', 'box > 0', 'add_box > 0'])->orderBy( $sort );

  
          $dataProvider = new ActiveDataProvider([
              'query' => $query,

              'key' => 'name',

          ]);
  
          return $dataProvider;
      }
  }