<?php

namespace backend\models;

use Yii;
use yii\base\Model;
use yii\data\ActiveDataProvider;
use backend\models\Log;

/**
 * LogSearch represents the model behind the search form about `backend\models\Log`.
 */
class LogSearch extends Log
{
    public $date_to;
    /**
     * @inheritdoc
     */
    public function rules()
    {
        return [
            [['id', 'error', 'record_type', 'importer_id'], 'integer'],
            [['time_start','date_to', 'time_end', 'file_name'], '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 = Log::find();

        $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([
            'error' => $this->error,
            'record_type' => $this->record_type,
            'importer_id' => $this->importer_id,
        ]);

//        $query->andFilterWhere(['like', 'log_msg', $this->log_msg])
//            ->andFilterWhere(['like', 'file_name', $this->file_name]);

        // отбор по дате
        if( !empty( $this->time_start ) || !empty( $this->date_to ) ){
            $date_from = \Yii::$app->converter->convertTo( 'timestamp', $this->time_start );
            // в БД time_start хранится в timestamp, а не в строке unixtimestamp, поэтому нужно преобразовать в mysql timestamp
            $date_from = date('Y-m-d H:i:s', $date_from);

            $date_to = \Yii::$app->converter->convertTo( 'timestamp', $this->date_to, ['begin_of_the_day' => false] );
            $date_to = date('Y-m-d H:i:s', $date_to);

            $query->andFilterWhere([
                'between', 'time_start', $date_from, $date_to
            ]);
        }
        // всегда сортируем по дате
        $query->orderBy('time_start DESC');

        return $dataProvider;
    }
}