CsvParser.php
2.8 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
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
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
<?php
/**
* Created by PhpStorm.
* User: Cibermag
* Date: 26.08.2015
* Time: 17:00
*/
namespace backend\components;
use Yii;
use yii\base\ErrorException;
use common\components\debug\CustomVarDamp;
class CsvParser implements \IteratorAggregate {
/** @var bool */
private $hasHeaderRow;
/** @var resource */
private $file;
/** @var out encoding charset */
private $out_charset = 'UTF-8';
/** @var out encoding charset */
private $in_charset;
/** @var int - first line for parsing */
private $first_line;
/** @var int - first column for parsing */
private $first_column;
/** @var array - array of headers values */
private $keys;
public function setup( $file, $first_line, $first_column, $hasHeaderRow = TRUE, $delimiter = ';')
{
$this->first_line = $first_line;
$this->first_column = $first_column;
$this->file = $file;
$this->file->setCsvControl($delimiter);
$this->file->setFlags(\SplFileObject::READ_CSV);
$this->file->seek( $this->first_line );
$this->in_charset = 'windows-1251';
$this->hasHeaderRow = $hasHeaderRow;
}
public function getIterator()
{
return new \ArrayIterator($this->read());
}
/**
* @return array
* @throws InvalidFileException
* @deprecated Use ::read instead.
*/
public function parseAll()
{
return $this->read();
}
/**
* @return array
* @throws InvalidFileException
*/
public function read()
{
// @todo add comments
$return = [];
$line = 0;
$this->keys = NULL;
while (($row = $this->readRow()) !== FALSE) {
$line++;
if ($this->hasHeaderRow) {
if ($this->keys === NULL) {
$this->keys = array_values($row);
} else {
if (count($this->keys) !== count($row)) {
//
Yii::warning("Invalid columns detected on line #$line .");
return $return;
}
$return[] = array_combine($this->keys, $row);
}
} else {
$return[] = $row;
}
}
$this->closeHandler();
return $return;
}
private function closeHandler()
{
$this->file = NULL;
}
private function readRow()
// @todo add comments
{
$dirt_value_arr = $this->file->fgetcsv( );
$dirt_value_arr = array_slice( $dirt_value_arr, $this->first_column );
$clear_arr = Encoder::encodeArray( $this->in_charset, $this->out_charset, $dirt_value_arr );
// if ($this->keys !== NULL)
// @$clear_arr[3] = ValueFilter::pricefilter($clear_arr[3]);
return $clear_arr;
}
}