Administrator / test_1

  <?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;

  
  /**
   * 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 HttpException('не удалось удалить прайс из базы данных');
          }

  
      }

  }