Blame view

backend/controllers/ParserController.php 3.42 KB
3cf42f5c   Mihail   init commit - bas...
1
2
3
4
5
  <?php
  namespace backend\controllers;
  
  use Yii;
  use yii\filters\AccessControl;
693c46cb   Mihail   add base classes ...
6
  use backend\components\base\BaseController;
3cf42f5c   Mihail   init commit - bas...
7
  use yii\filters\VerbFilter;
b13b1c83   Mihail   final version par...
8
  use backend\models\UploadFileParsingForm;
3cf42f5c   Mihail   init commit - bas...
9
  use yii\web\UploadedFile;
fcd9278e   Mihail   parser csv v1
10
  use yii\data\ArrayDataProvider;
74072a2a   Mihail   add first version...
11
  use yii\multiparser\DynamicFormHelper;
474f35bf   Mihail   add DynamicFormHe...
12
  use backend\components\parsers\CustomParserConfigurator;
500b481a   Administrator   JSON
13
  
e774f057   Mihail   work with custome...
14
  use common\components\CustomVarDamp;
3cf42f5c   Mihail   init commit - bas...
15
16
  
  /**
b13b1c83   Mihail   final version par...
17
   * Parser controller
3cf42f5c   Mihail   init commit - bas...
18
   */
b13b1c83   Mihail   final version par...
19
  
693c46cb   Mihail   add base classes ...
20
  class ParserController extends BaseController
3cf42f5c   Mihail   init commit - bas...
21
  {
500b481a   Administrator   JSON
22
      public $layout = "/column";
3cf42f5c   Mihail   init commit - bas...
23
24
25
26
27
28
29
30
31
32
      /**
       * @inheritdoc
       */
      public function behaviors()
      {
          return [
              'access' => [
                  'class' => AccessControl::className(),
                  'rules' => [
                      [
e774f057   Mihail   work with custome...
33
                          'actions' => ['index','results','write'],
3cf42f5c   Mihail   init commit - bas...
34
35
36
37
38
                          'allow' => true,
                          'roles' => ['@'],
                      ],
                  ],
              ],
e774f057   Mihail   work with custome...
39
40
41
42
43
44
  //            'verbs' => [
  //                'class' => VerbFilter::className(),
  //                'actions' => [
  //                    'logout' => ['post'],
  //                ],
  //            ],
3cf42f5c   Mihail   init commit - bas...
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
          ];
      }
  
      /**
       * @inheritdoc
       */
      public function actions()
      {
          return [
              'error' => [
                  'class' => 'yii\web\ErrorAction',
              ],
          ];
      }
  
500b481a   Administrator   JSON
60
61
  
  
3cf42f5c   Mihail   init commit - bas...
62
63
      public function actionIndex()
      {
77422ce3   Mihail   edit upload form
64
          $model = new UploadFileParsingForm();
3cf42f5c   Mihail   init commit - bas...
65
  
500b481a   Administrator   JSON
66
67
68
69
70
71
          return $this->render('index', ['model' => $model]);
      }
  
      public function actionResults(){
  
          $model = new UploadFileParsingForm();
474f35bf   Mihail   add DynamicFormHe...
72
          $data = [];
b13b1c83   Mihail   final version par...
73
          if ($model->load(Yii::$app->request->post())) {
3cf42f5c   Mihail   init commit - bas...
74
75
              $model->file = UploadedFile::getInstance($model, 'file');
  
3663f570   Mihail   draft commit
76
              if ($model->validate()) {
fcd9278e   Mihail   parser csv v1
77
                  $filePath = Yii::getAlias('@webroot') . '/uploads/' . $model->file->baseName . '.' . $model->file->extension;
500b481a   Administrator   JSON
78
  
fcd9278e   Mihail   parser csv v1
79
                  $model->file->saveAs( $filePath );
500b481a   Administrator   JSON
80
81
                  $data = $model->readFile($filePath);
  
474f35bf   Mihail   add DynamicFormHe...
82
                  Yii::$app->getCache()->set( 'parser_data', json_encode($data) );
500b481a   Administrator   JSON
83
  
3cf42f5c   Mihail   init commit - bas...
84
              }
500b481a   Administrator   JSON
85
86
87
  
          } else if( Yii::$app->getCache()->get( 'parser_data' )) {
  
474f35bf   Mihail   add DynamicFormHe...
88
              $data = json_decode( Yii::$app->getCache()->get( 'parser_data' ),true );
500b481a   Administrator   JSON
89
  
3cf42f5c   Mihail   init commit - bas...
90
91
          }
  
474f35bf   Mihail   add DynamicFormHe...
92
93
94
95
96
97
98
          $provider = new ArrayDataProvider([
              'allModels' => $data,
              'pagination' => [
                  'pageSize' => 10,
              ],
          ]);
  
74072a2a   Mihail   add first version...
99
         // CustomVarDamp::dumpAndDie($data);
474f35bf   Mihail   add DynamicFormHe...
100
101
          $header_model = DynamicFormHelper::CreateDynamicModel( count( $data[0] ) );
  
74072a2a   Mihail   add first version...
102
       //   CustomVarDamp::dumpAndDie(Yii::$app->multiparser->getConfiguration('csv','basic_column'));
474f35bf   Mihail   add DynamicFormHe...
103
104
105
          return $this->render('results',
              ['model' => $data,
                  'header_model' => $header_model,
74072a2a   Mihail   add first version...
106
                  'basic_column' =>  Yii::$app->multiparser->getConfiguration('csv','basic_column'),
474f35bf   Mihail   add DynamicFormHe...
107
                  'dataProvider' => $provider]);
3cf42f5c   Mihail   init commit - bas...
108
      }
474f35bf   Mihail   add DynamicFormHe...
109
  
e774f057   Mihail   work with custome...
110
111
  public function actionWrite()
  {
474f35bf   Mihail   add DynamicFormHe...
112
113
114
115
116
      //CustomVarDamp::dumpAndDie(Yii::$app->request->post());
  
      $arr_attributes = Yii::$app->request->post()['DynamicModel'];
      $model = DynamicFormHelper::CreateDynamicModel( $arr_attributes );
      foreach ($arr_attributes as $key => $value) {
74072a2a   Mihail   add first version...
117
          $model->addRule($key, 'in', ['range' => array_keys( Yii::$app->multiparser->getConfiguration('csv','basic_column') )]);
474f35bf   Mihail   add DynamicFormHe...
118
119
120
121
122
123
124
125
126
      }
  
      //CustomVarDamp::dumpAndDie($model);
      if ($model->validate()) {
          $arr = $model->toArray();
          CustomVarDamp::dumpAndDie($arr);
      }
  
  
3cf42f5c   Mihail   init commit - bas...
127
  
e774f057   Mihail   work with custome...
128
  }
3cf42f5c   Mihail   init commit - bas...
129
130
  
  }