f0dbd829
Mihail
add PriceWriter a...
|
1
|
<?php
|
db543d22
Mihail
temp commit - wor...
|
2
3
|
namespace console\controllers;
|
78684ed4
Mihail
add multiply pric...
|
4
|
use common\components\CustomVarDamp;
|
f0dbd829
Mihail
add PriceWriter a...
|
5
|
use yii\console\Controller;
|
1fe29bbe
Mihail
fixed parser and ...
|
6
7
8
|
use yii\helpers\Console;
use common\components\PriceWriter;
use backend\models\ImportersFiles;
|
ef41533d
Mihail
temp commit - wor...
|
9
10
|
use backend\models\Importers;
use yii\base\ErrorException;
|
f0dbd829
Mihail
add PriceWriter a...
|
11
|
|
48b58a13
Mihail
finish with xml a...
|
12
13
|
class ParserController extends Controller
{
|
48b58a13
Mihail
finish with xml a...
|
14
|
public function actionParseCsv()
|
f0dbd829
Mihail
add PriceWriter a...
|
15
|
{
|
48b58a13
Mihail
finish with xml a...
|
16
17
18
19
|
\Yii::info('Начало загрузки файлов прайсов csv', 'parser');
foreach (glob(\Yii::getAlias('@auto_upload') . '/*.csv') as $file_path) {
$file_name = basename($file_path, ".csv");
\Yii::info("Обработка файла - $file_path", 'parser');
|
ea4ecf3d
Mihail
console csv parsing
|
20
|
$importer_id = ImportersFiles::findOne(['id' => $file_name])->importer_id;
|
78684ed4
Mihail
add multiply pric...
|
21
22
23
24
25
26
27
28
29
|
$current_importer = Importers::findOne(['id' => $importer_id]);
$keys = $current_importer->keys;
$mult_array = $current_importer->multiply;
// получим настройки ценообразования и передадим их отдельно в конвертер
$sign = '';
$multiplier = '';
extract( $mult_array );
|
ef41533d
Mihail
temp commit - wor...
|
30
|
|
ea4ecf3d
Mihail
console csv parsing
|
31
32
33
|
$config = ['record_id' => $file_name,
'importer_id' => $importer_id,
'parser_config' => ['keys' => $keys,
|
78684ed4
Mihail
add multiply pric...
|
34
35
36
|
'converter_conf' =>
['sign' => $sign,
'multiplier' => $multiplier],
|
ea4ecf3d
Mihail
console csv parsing
|
37
38
|
'mode' => 'console']
];
|
48b58a13
Mihail
finish with xml a...
|
39
40
41
42
43
|
if ($this->parseFileConsole($file_path, $config)) {
unlink(\Yii::getAlias('@temp_upload') . '/' . $file_name . '.csv');
\Yii::info("Загрузка файла - $file_path успешно завершена", 'parser');
} else {
\Yii::error("Загрузка файла - $file_path завершена с ошибкой", 'parser');
|
ea4ecf3d
Mihail
console csv parsing
|
44
|
}
|
48b58a13
Mihail
finish with xml a...
|
45
46
|
//при любом завершении скрипта файл с очереди автозагрузки нужно удалить
unlink(\Yii::getAlias('@auto_upload') . '/' . $file_name . '.csv');
|
ea4ecf3d
Mihail
console csv parsing
|
47
|
}
|
ef41533d
Mihail
temp commit - wor...
|
48
|
|
f0dbd829
Mihail
add PriceWriter a...
|
49
|
}
|
ef41533d
Mihail
temp commit - wor...
|
50
|
|
f0dbd829
Mihail
add PriceWriter a...
|
51
|
|
1fe29bbe
Mihail
fixed parser and ...
|
52
|
protected function parseFileConsole( $file_path, $configuration ){
|
ef41533d
Mihail
temp commit - wor...
|
53
54
|
if( !file_exists( $file_path ) )
|
ea4ecf3d
Mihail
console csv parsing
|
55
|
throw new ErrorException("$file_path - файл не найден!");
|
ef41533d
Mihail
temp commit - wor...
|
56
|
|
1fe29bbe
Mihail
fixed parser and ...
|
57
58
59
60
|
$parser_config = [];
if ( isset( $configuration['parser_config'] ) ) {
$parser_config = $configuration['parser_config'];
}
|
ef41533d
Mihail
temp commit - wor...
|
61
|
$data = \Yii::$app->multiparser->parse( $file_path, $parser_config );
|
78684ed4
Mihail
add multiply pric...
|
62
|
if ( ! $data ) {
|
ea4ecf3d
Mihail
console csv parsing
|
63
64
65
|
// @todo переделать, что бы ошибка автоматически останавливала сценарий
return false;
}
|
f0dbd829
Mihail
add PriceWriter a...
|
66
|
|
1fe29bbe
Mihail
fixed parser and ...
|
67
68
69
70
|
$writer = new PriceWriter();
$writer->configuration = $configuration;
$writer->data = $data;
$writer->mode = 1; //console-режим
|
ea4ecf3d
Mihail
console csv parsing
|
71
|
|
1fe29bbe
Mihail
fixed parser and ...
|
72
|
if ( $writer->writeDataToDB() ){
|
ea4ecf3d
Mihail
console csv parsing
|
73
|
|
1fe29bbe
Mihail
fixed parser and ...
|
74
75
|
return true;
}
|
f0dbd829
Mihail
add PriceWriter a...
|
76
|
|
1fe29bbe
Mihail
fixed parser and ...
|
77
|
return false;
|
f0dbd829
Mihail
add PriceWriter a...
|
78
|
}
|
db543d22
Mihail
temp commit - wor...
|
79
|
|
ea4ecf3d
Mihail
console csv parsing
|
80
81
|
public function actionParseXml ()
{
|
48b58a13
Mihail
finish with xml a...
|
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
|
\Yii::info('Начало загрузки файлов прайсов xml', 'parser');
foreach (glob(\Yii::getAlias('@auto_upload') . '/*.xml') as $file_path) {
$file_name = basename($file_path, ".xml");
\Yii::info("Обработка файла - $file_path", 'parser');
$files_model = new ImportersFiles();
// id поставщика всегда = 1 - Склад
$files_model->importer_id = 1;
try {
$files_model->save();
} catch (ErrorException $e) {
throw $e;
}
// получим id только что записанной записи
$record_id = $files_model->find()
->where(['importer_id' => $files_model->importer_id])
->orderBy(['id' => SORT_DESC])
->one()
->id;
$config = ['record_id' => $record_id,
'importer_id' => 1,
'parser_config' => [
'mode' => 'console']
];
|
ea4ecf3d
Mihail
console csv parsing
|
107
|
|
48b58a13
Mihail
finish with xml a...
|
108
109
110
111
112
113
114
|
if ($this->parseFileConsole($file_path, $config)) {
unlink(\Yii::getAlias('@auto_upload') . '/' . $file_name . '.xml');
\Yii::info("Загрузка файла - $file_path успешно завершена", 'parser');
} else {
\Yii::error("Загрузка файла - $file_path завершена с ошибкой", 'parser');
}
}
|
ea4ecf3d
Mihail
console csv parsing
|
115
116
|
}
|
48b58a13
Mihail
finish with xml a...
|
117
|
public function actionTest()
|
db543d22
Mihail
temp commit - wor...
|
118
|
{
|
ef41533d
Mihail
temp commit - wor...
|
119
|
Console::output('It is working ');
|
48b58a13
Mihail
finish with xml a...
|
120
|
\Yii::info('2', 'parser');
|
db543d22
Mihail
temp commit - wor...
|
121
122
|
}
|
f0dbd829
Mihail
add PriceWriter a...
|
123
|
}
|