<?php

namespace backend\models;

use Yii;
use yii\base\Model;
use yii\data\ActiveDataProvider;
use common\models\Page;

/**
 * SearchPage represents the model behind the search form about `common\models\Page`.
 */
class SearchPage extends Page
{
    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['page_id', 'image_id', 'show'], 'integer'],
            [['date_add'], '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 = self::getAll(Yii::$app->request->get());
        //$query = Page::find();
        //->joinWith('pagelang');
        $dataProvider = new ActiveDataProvider([
            'query' => $query,
        ]);

        $this->load($params);

        if (!$this->validate()) {
            // uncomment the following line if you do not want to return any records when validation fails
            // $query->where('0=1');
            return $dataProvider;
        }

        $query->andFilterWhere([
            $this->addCondition($query, 'title'),
            
        ]);

        return $dataProvider;
    }
    
    
    static function getList (array $param = array ()) 
    {
        $sql = '
            SELECT
                `page`.date_add, `page`.`show`,
                `page_lang`.*
            FROM `page`
                LEFT JOIN `page_lang` ON `page_lang`.page_id = `page`.page_id
                    AND  `page_lang`.lang_id = '.(int)$param['lang_id'];
        
        $WHERE = array ();
        
        if (isset ($param['page_id']))
        {
            $WHERE[] = '`page_lang`.page_id = '.(int)$param['page_id'];
        }

        if (isset ($param['date_add']))
        {
            $WHERE[] = '`page`.date_add = "'.(int)$param['page_id'].'"';
        }

        if (isset ($param['show']))
        {
            $WHERE[] = '`page`.show = "'.(int)$param['show'].'"';
        }
        
        if (! empty ($WHERE))
        {
            $sql .= ' WHERE '.implode (' AND ', $WHERE);
        }

        return $sql;
    }

}