src/Plugin/ConditionalFormatFixer.php


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

<?php

namespace PHPExcelFixer\StyleFixer\Plugin;

use PHPExcelFixer\StyleFixer\Util\Book as BookUtil;
use PHPExcelFixer\StyleFixer\Util\XmlNamespace;

/**
 * Class ConditionalFormatFixer
 * PHPExcelが壊した条件付き書式を修復する
 */
class ConditionalFormatFixer implements Plugin
{
    /**
     * @var \PHPExcelFixer\StyleFixer\Util\Book
     */
    private $bookUtil;

    public function __construct(BookUtil $bookUtil = null)
    {
        $this->bookUtil = $bookUtil ? $bookUtil : new BookUtil;
    }

    /**
     * 各ワークシート内の条件付き書式設定を修復する
     *
     * @param \ZipArchive $output
     * @param \ZipArchive $template
     */
    public function execute(\ZipArchive $output, \ZipArchive $template)
    {
        // テンプレート側のシート名のマッピング
        $srcSheetMap = $this->bookUtil->makeSheetMap($template);
        // 出力ファイル側のシート名のマッピング
        $distSheetMap = $this->bookUtil->makeSheetMap($output);

        foreach ($distSheetMap as $sheetName => $distSheetPath) {
            $distXml = $output->getFromName($distSheetPath);
            if (false !== strpos($distXml, 'conditionalFormatting')) {
                $distDom = new \DOMDocument;
                $distDom->loadXML($distXml);
                $distXPath = new \DOMXPath($distDom);
                $distXPath->registerNamespace('s', XmlNamespace::SPREADSHEETML_NS_URL);
                $distRoot = $distXPath->query('//s:worksheet')->item(0);
                $distConditionalFormattings = $distXPath->query('//s:worksheet/s:conditionalFormatting');
                $elementAfterConditionalFormatting = null;
                foreach ($distConditionalFormattings as $distConditionalFormatting) {
                    $elementAfterConditionalFormatting = $distConditionalFormatting->nextSibling;
                    $distRoot->removeChild($distConditionalFormatting);
                }

                while ($elementAfterConditionalFormatting instanceOf \DOMNode && !$elementAfterConditionalFormatting instanceOf \DOMElement) {
                    $elementAfterConditionalFormatting = $elementAfterConditionalFormatting->nextSibling;
                }
                if (!$elementAfterConditionalFormatting instanceOf \DOMElement) {
                    break;
                }

                $srcSheetPath = $srcSheetMap[$sheetName];
                $srcXml = $template->getFromName($srcSheetPath);
                $srcDom = new \DOMDocument;
                $srcDom->loadXML($srcXml);
                $srcXPath = new \DOMXPath($srcDom);
                $srcXPath->registerNamespace('s', XmlNamespace::SPREADSHEETML_NS_URL);
                
                $conditionalFormattings = $srcXPath->query('//s:worksheet/s:conditionalFormatting');
                foreach ($conditionalFormattings as $conditionalFormatting) {
                    /** @var \DOMElement $conditionalFormatting */
                    $newDistConditionalFormatting = $distDom->importNode($conditionalFormatting, true);
                    $distRoot->insertBefore($newDistConditionalFormatting, $elementAfterConditionalFormatting);
                }

                $output->addFromString($distSheetPath, $distDom->saveXML());
            }
        }
    }
}