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
|
}
|