Blame view

backend/controllers/ParserController.php 3.67 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,
              ],
          ]);
  
28253169   Mihail   add converter as ...
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
      }
  
28253169   Mihail   add converter as ...
120
  
474f35bf   Mihail   add DynamicFormHe...
121
122
123
      //CustomVarDamp::dumpAndDie($model);
      if ($model->validate()) {
          $arr = $model->toArray();
aa518ad3   Mihail   finishing with co...
124
125
          $data = json_decode( Yii::$app->getCache()->get( 'parser_data' ),true );
  
28253169   Mihail   add converter as ...
126
127
128
          $data = \Yii::$app->multiparser->convertToAssocArray( $data, $arr, 'attr_' );
          $data[1]['BOX'] = \Yii::$app->multiparser->convertToFloat( $data[1]['BOX'] );
          CustomVarDamp::dumpAndDie($data);
474f35bf   Mihail   add DynamicFormHe...
129
130
131
      }
  
  
3cf42f5c   Mihail   init commit - bas...
132
  
e774f057   Mihail   work with custome...
133
  }
3cf42f5c   Mihail   init commit - bas...
134
135
  
  }