<?php
namespace backend\controllers;

use backend\models\ImportersCheckPriceSearch;
use common\components\PriceWriter;
use common\models\DetailsCurrency;
use Yii;
use yii\bootstrap\Modal;
use yii\data\ActiveDataProvider;
use yii\filters\AccessControl;
use backend\components\base\BaseController;
use yii\filters\VerbFilter;
use backend\models\Details;
use backend\models\ImportersFiles;
use backend\models\Importers;
use yii\base\ErrorException;

use common\components\CustomVarDamp;
use yii\web\GoneHttpException;
use yii\web\HttpException;
use yii\web\NotFoundHttpException;

/**
 * Parser controller
 */
class CheckPriceController extends BaseController
{
    public $layout = "/column";

    /**
     * @inheritdoc
     */
    public function behaviors()
    {
        return [
            'access' => [
                'class' => AccessControl::className(),
                'rules' => [
                    [
                        'actions' => ['index', 'view', 'delete'],
                        'allow' => true,
                        'roles' => ['@'],
                    ],
                ],
            ],
            'verbs' => [
                'class' => VerbFilter::className(),
                'actions' => [
                    'delete ' => ['post'],
                ],
            ],
        ];
    }

    /**
     * @inheritdoc
     */
    public function actions()
    {
        return [
            'error' => [
                'class' => 'yii\web\ErrorAction',
            ],
        ];
    }


    public function actionIndex()
    {
        //$query = (new Query())->select('*')->from('{{%importer_files}}')->where(['not', ['time_end' => null]])->orderBy(['upload_time' => SORT_DESC]);

        $searchModel = new ImportersCheckPriceSearch();
        $provider = $searchModel->search(Yii::$app->request->queryParams);


        return $this->render('index',
            [
                'searchModel' => $searchModel,
               'dataProvider' => $provider,
           ]);
    }


    public function actionView ($id, $date_update)
    {
        $query = DetailsCurrency::find()->where(['IMPORT_ID' => $id, 'timestamp' => $date_update])->limit(100);


        $importer = Importers::findOne($id)->name;
        $date = Yii::$app->formatter->asDate( $date_update, 'yyyy-MM-dd' );

        $provider = new ActiveDataProvider([
            'query' => $query,
            'pagination' => false,
            'sort' => false,
        ]);

        return $this->renderAjax('view',
            ['dataProvider' => $provider,
            'importer' => $importer,
            'date' => $date,
            ]);
    }

    public function actionDelete ($id, $update_date)
    {
        $price_writer = new PriceWriter();
        $price_writer->setConfiguration(['importer_id' => $id,'update_date' => $update_date]);

        if ( $price_writer->deletePriceFromDB() ) {

            return $this->redirect('index');
        } else {
            throw new NotFoundHttpException('не удалось удалить прайс из базы данных');
        }


    }
}