CSVインポート時にデリミタがエスケープされていることがある

[izayoi256]

環境 (environment)

• EC-CUBE: 4.1.0

概要(Overview)

参考: https://sites.google.com/site/fudist/Home/grep/sjis-damemoji-jp/table

sjis.csv

"hoge","テスト機構","fuga"

PHP

$csv = new CsvImportService(new SplFileObject(__DIR__ . '/sjis.csv'));
foreach ($csv as $row) {
    echo count($row), ' ', var_export($row, true), '<br />';
}

実行結果

2 array ( 0 => 'hoge', 1 => '�e�X�g�@�\\",fuga"', )

修正案

CsvImportService::__construct()

    public function __construct(\SplFileObject $file, $delimiter = ',', $enclosure = '"', $escape = '\\')
     {
         ini_set('auto_detect_line_endings', true);
 
-        $this->file = $file;
+        $tempFile = tmpfile();
+        foreach ($file as $line) {
+            $encoded = mb_convert_encoding($line, 'UTF-8', 'SJIS-win');
+            fwrite($tempFile, $encoded);
+        }
+
+        $meta = stream_get_meta_data($tempFile);
+        $this->file = new SplFileObject($meta['uri'], 'r');
+        fclose($tempFile);
+
         $this->file->setFlags(
             \SplFileObject::READ_CSV |
             \SplFileObject::SKIP_EMPTY |

実行結果

3 array ( 0 => 'hoge', 1 => 'テスト機構', 2 => 'fuga', )

[chihiro-adachi]

#5407 で対応