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
<?php
/**
* Copyright © Magento, Inc. All rights reserved.
* See COPYING.txt for license details.
*/
/**
* Csv parse
*
* @author Magento Core Team <core@magentocommerce.com>
*/
namespace Magento\Framework\File;
class CsvMulty extends \Magento\Framework\File\Csv
{
/**
* Retrieve CSV file data as pairs with duplicates
*
* @param string $file
* @param int $keyIndex
* @param int $valueIndex
* @return array
*/
public function getDataPairs($file, $keyIndex = 0, $valueIndex = 1)
{
$data = [];
$csvData = $this->getData($file);
$lineNumber = 0;
foreach ($csvData as $rowData) {
$lineNumber++;
if (isset($rowData[$keyIndex])) {
if (isset($data[$rowData[$keyIndex]])) {
if (isset($data[$rowData[$keyIndex]]['duplicate'])) {
$data[$rowData[$keyIndex]]['duplicate']['line'] .= ', ' . $lineNumber;
} else {
$tmpValue = $data[$rowData[$keyIndex]]['value'];
$tmpLine = $data[$rowData[$keyIndex]]['line'];
$data[$rowData[$keyIndex]]['duplicate'] = [];
$data[$rowData[$keyIndex]]['duplicate']['line'] = $tmpLine . ' ,' . $lineNumber;
$data[$rowData[$keyIndex]]['duplicate']['value'] = $tmpValue;
}
} else {
$data[$rowData[$keyIndex]] = [];
$data[$rowData[$keyIndex]]['line'] = $lineNumber;
$data[$rowData[$keyIndex]]['value'] = isset($rowData[$valueIndex]) ? $rowData[$valueIndex] : null;
}
}
}
return $data;
}
}