<?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)
    {
        $query = GoodsView::find();

//        $pagination = [
//            'pageSize' => 20,
//        ];


        $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']);

        $dataProvider = new ActiveDataProvider([
            'query' => $query,
            'key' => 'article',
            'sort' => [
                'attributes' => [
                    'box',
                    'delivery',
                    'price'
                ],
            ],

        ]);

        return $dataProvider;
    }
    public function searchCrosses($params)
    {
        $query = GoodsView::find()->innerJoin('w_details_crosses', '`w_details_crosses`.`CROSS_ARTICLE` = `name` and `w_details_crosses`.`CROSS_BRAND` = w_goods_view.`brand`');

//        $pagination = [
//            'pageSize' => 20,
//        ];


        $this->load($params);

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

        $query->andFilterWhere([
            'w_details_crosses.ARTICLE' => $this->name,
            'w_details_crosses.BRAND' => $this->brand,
        ]);

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

        $dataProvider = new ActiveDataProvider([
            'query' => $query,
            'key' => 'article',
            'sort' => [
                'attributes' => [
                    'box',
                    'delivery',
                    'price'
                ],
            ],

        ]);

        return $dataProvider;
    }
}