HtmlNumberFormatTest::testFormatValueWithMaskDate() - Code Metrics - Inspection of "Improve HTML Writer (#1464)" - PHPOffice/PhpSpreadsheet - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 4f6d4a...97a80f )

by Adrien

created 2020-05-18 03:43 UTC

testFormatValueWithMaskDate() A

↳ Parent: HtmlNumberFormatTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	22
Code Lines	16

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	16
nc	1
nop	3
dl	0
loc	22
rs	9.7333
c	1
b	0
f	0

<?php

namespace PhpOffice\PhpSpreadsheetTests\Writer\Html;

use PhpOffice\PhpSpreadsheet\Shared\StringHelper;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Html;
use PhpOffice\PhpSpreadsheetTests\Functional;

class HtmlNumberFormatTest extends Functional\AbstractFunctional
{
    private $decsep;

    private $thosep;

    protected function setUp(): void
    {
        $this->decsep = StringHelper::getDecimalSeparator();
        StringHelper::setDecimalSeparator('.');
        $this->thosep = StringHelper::getThousandsSeparator();
        StringHelper::setThousandsSeparator(',');
    }

    protected function tearDown(): void
    {
        StringHelper::setDecimalSeparator($this->decsep);
        StringHelper::setThousandsSeparator($this->thosep);
    }

    public function testColorNumberFormat()
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setCellValue('A1', -50);
        $sheet->setCellValue('A2', 3000);
        $sheet->setCellValue('A3', 0);
        $sheet->setCellValue('A4', '<br>');
        $fmt = '[Blue]$#,##0;[Red]$#,##0;$#,##0';
        $sheet->getStyle('A1:A4')->getNumberFormat()->setFormatCode($fmt);

        $writer = new Html($spreadsheet);
        $html = $writer->generateHTMLAll();
        $dom = new \DOMDocument();
        $dom->loadHTML($html);
        $body = $dom->getElementsByTagName('body')[0];
        $divs = $body->getElementsByTagName('div');

        $tabl = $divs[0]->getElementsByTagName('table');
        $tbod = $tabl[0]->getElementsByTagName('tbody');
        $rows = $tbod[0]->getElementsByTagName('tr');
        self::assertCount(4, $rows);

        $tds = $rows[0]->getElementsByTagName('td');
        self::assertCount(1, $tds);
        $spans = $tds[0]->getElementsByTagName('span');
        self::assertCount(1, $spans);
        $style = $spans[0]->getAttribute('style');
        self::assertEquals(1, preg_match('/color:red/', $style));
        self::assertEquals('$50', $spans[0]->textContent);

        $tds = $rows[1]->getElementsByTagName('td');
        self::assertCount(1, $tds);
        $spans = $tds[0]->getElementsByTagName('span');
        self::assertCount(1, $spans);
        $style = $spans[0]->getAttribute('style');
        self::assertEquals(1, preg_match('/color:blue/', $style));
        self::assertEquals('$3,000', $spans[0]->textContent);

        $tds = $rows[2]->getElementsByTagName('td');
        self::assertCount(1, $tds);
        $spans = $tds[0]->getElementsByTagName('span');
        self::assertCount(0, $spans);
        self::assertEquals('$0', $tds[0]->textContent);

        $tds = $rows[3]->getElementsByTagName('td');
        self::assertCount(1, $tds);
        $spans = $tds[0]->getElementsByTagName('span');
        self::assertCount(0, $spans);
        self::assertEquals('<br>', $tds[0]->textContent);

        $this->writeAndReload($spreadsheet, 'Html');
    }

    public function testColorNumberFormatComplex()
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setCellValue('A1', -50);
        $sheet->setCellValue('A2', 3000.75);
        $sheet->setCellValue('A3', 0);
        $sheet->setCellValue('A4', 3000.25);
        $fmt = '[Blue][>=3000.5]$#,##0.00;[Red][<0]$#,##0.00;$#,##0.00';
        $sheet->getStyle('A1:A4')->getNumberFormat()->setFormatCode($fmt);

        $writer = new Html($spreadsheet);
        $html = $writer->generateHTMLAll();
        $dom = new \DOMDocument();
        $dom->loadHTML($html);
        $body = $dom->getElementsByTagName('body')[0];
        $divs = $body->getElementsByTagName('div');

        $tabl = $divs[0]->getElementsByTagName('table');
        $tbod = $tabl[0]->getElementsByTagName('tbody');
        $rows = $tbod[0]->getElementsByTagName('tr');
        self::assertCount(4, $rows);

        $tds = $rows[0]->getElementsByTagName('td');
        self::assertCount(1, $tds);
        $spans = $tds[0]->getElementsByTagName('span');
        self::assertCount(1, $spans);
        $style = $spans[0]->getAttribute('style');
        self::assertEquals(1, preg_match('/color:red/', $style));
        self::assertEquals('$50.00', $spans[0]->textContent);

        $tds = $rows[1]->getElementsByTagName('td');
        self::assertCount(1, $tds);
        $spans = $tds[0]->getElementsByTagName('span');
        self::assertCount(1, $spans);
        $style = $spans[0]->getAttribute('style');
        self::assertEquals(1, preg_match('/color:blue/', $style));
        self::assertEquals('$3,000.75', $spans[0]->textContent);

        $tds = $rows[2]->getElementsByTagName('td');
        self::assertCount(1, $tds);
        $spans = $tds[0]->getElementsByTagName('span');
        self::assertCount(0, $spans);
        self::assertEquals('$0.00', $tds[0]->textContent);

        $tds = $rows[3]->getElementsByTagName('td');
        self::assertCount(1, $tds);
        $spans = $tds[0]->getElementsByTagName('span');
        self::assertCount(0, $spans);
        self::assertEquals('$3,000.25', $tds[0]->textContent);

        $this->writeAndReload($spreadsheet, 'Html');
    }

    /**
     * @dataProvider providerNumberFormat
     *
     * @param mixed $expectedResult
     * @param mixed $val
     * @param mixed $fmt
     */
    public function testFormatValueWithMask($expectedResult, $val, $fmt)
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->getCell('A1')->setValue($val)->getStyle()->getNumberFormat()->setFormatCode($fmt);

        $writer = new Html($spreadsheet);
        $html = $writer->generateHTMLAll();
        $dom = new \DOMDocument();
        $dom->loadHTML($html);
        $body = $dom->getElementsByTagName('body')[0];
        $divs = $body->getElementsByTagName('div');

        $tabl = $divs[0]->getElementsByTagName('table');
        $tbod = $tabl[0]->getElementsByTagName('tbody');
        $rows = $tbod[0]->getElementsByTagName('tr');

        $tds = $rows[0]->getElementsByTagName('td');
        $nbsp = html_entity_decode('&nbsp;');
        self::assertEquals($expectedResult, str_replace($nbsp, ' ', $tds[0]->textContent));

        $this->writeAndReload($spreadsheet, 'Html');
    }

    public function providerNumberFormat()
    {
        return require __DIR__ . '/../../../data/Style/NumberFormat.php';
    }

    /**
     * @dataProvider providerNumberFormatDates
     *
     * @param mixed $expectedResult
     * @param mixed $val
     * @param mixed $fmt
     */
    public function testFormatValueWithMaskDate($expectedResult, $val, $fmt)
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->getCell('A1')->setValue($val)->getStyle()->getNumberFormat()->setFormatCode($fmt);

        $writer = new Html($spreadsheet);
        $html = $writer->generateHTMLAll();
        $dom = new \DOMDocument();
        $dom->loadHTML($html);
        $body = $dom->getElementsByTagName('body')[0];
        $divs = $body->getElementsByTagName('div');

        $tabl = $divs[0]->getElementsByTagName('table');
        $tbod = $tabl[0]->getElementsByTagName('tbody');
        $rows = $tbod[0]->getElementsByTagName('tr');

        $tds = $rows[0]->getElementsByTagName('td');
        $nbsp = html_entity_decode('&nbsp;');
        self::assertEquals($expectedResult, str_replace($nbsp, ' ', $tds[0]->textContent));

        $this->writeAndReload($spreadsheet, 'Html');
    }

    public function providerNumberFormatDates()
    {
        return require __DIR__ . '/../../../data/Style/NumberFormatDates.php';
    }
}


1			<?php
2
3			namespace PhpOffice\PhpSpreadsheetTests\Writer\Html;
4
5			use PhpOffice\PhpSpreadsheet\Shared\StringHelper;
6			use PhpOffice\PhpSpreadsheet\Spreadsheet;
7			use PhpOffice\PhpSpreadsheet\Writer\Html;
8			use PhpOffice\PhpSpreadsheetTests\Functional;
9
10			class HtmlNumberFormatTest extends Functional\AbstractFunctional
11			{
12			private $decsep;
13
14			private $thosep;
15
16			protected function setUp(): void
17			{
18			$this->decsep = StringHelper::getDecimalSeparator();
19			StringHelper::setDecimalSeparator('.');
20			$this->thosep = StringHelper::getThousandsSeparator();
21			StringHelper::setThousandsSeparator(',');
22			}
23
24			protected function tearDown(): void
25			{
26			StringHelper::setDecimalSeparator($this->decsep);
27			StringHelper::setThousandsSeparator($this->thosep);
28			}
29
30			public function testColorNumberFormat()
31			{
32			$spreadsheet = new Spreadsheet();
33			$sheet = $spreadsheet->getActiveSheet();
34			$sheet->setCellValue('A1', -50);
35			$sheet->setCellValue('A2', 3000);
36			$sheet->setCellValue('A3', 0);
37			$sheet->setCellValue('A4', '<br>');
38			$fmt = '[Blue]$#,##0;[Red]$#,##0;$#,##0';
39			$sheet->getStyle('A1:A4')->getNumberFormat()->setFormatCode($fmt);
40
41			$writer = new Html($spreadsheet);
42			$html = $writer->generateHTMLAll();
43			$dom = new \DOMDocument();
44			$dom->loadHTML($html);
45			$body = $dom->getElementsByTagName('body')[0];
46			$divs = $body->getElementsByTagName('div');
47
48			$tabl = $divs[0]->getElementsByTagName('table');
49			$tbod = $tabl[0]->getElementsByTagName('tbody');
50			$rows = $tbod[0]->getElementsByTagName('tr');
51			self::assertCount(4, $rows);
52
53			$tds = $rows[0]->getElementsByTagName('td');
54			self::assertCount(1, $tds);
55			$spans = $tds[0]->getElementsByTagName('span');
56			self::assertCount(1, $spans);
57			$style = $spans[0]->getAttribute('style');
58			self::assertEquals(1, preg_match('/color:red/', $style));
59			self::assertEquals('$50', $spans[0]->textContent);
60
61			$tds = $rows[1]->getElementsByTagName('td');
62			self::assertCount(1, $tds);
63			$spans = $tds[0]->getElementsByTagName('span');
64			self::assertCount(1, $spans);
65			$style = $spans[0]->getAttribute('style');
66			self::assertEquals(1, preg_match('/color:blue/', $style));
67			self::assertEquals('$3,000', $spans[0]->textContent);
68
69			$tds = $rows[2]->getElementsByTagName('td');
70			self::assertCount(1, $tds);
71			$spans = $tds[0]->getElementsByTagName('span');
72			self::assertCount(0, $spans);
73			self::assertEquals('$0', $tds[0]->textContent);
74
75			$tds = $rows[3]->getElementsByTagName('td');
76			self::assertCount(1, $tds);
77			$spans = $tds[0]->getElementsByTagName('span');
78			self::assertCount(0, $spans);
79			self::assertEquals('<br>', $tds[0]->textContent);
80
81			$this->writeAndReload($spreadsheet, 'Html');
82			}
83
84			public function testColorNumberFormatComplex()
85			{
86			$spreadsheet = new Spreadsheet();
87			$sheet = $spreadsheet->getActiveSheet();
88			$sheet->setCellValue('A1', -50);
89			$sheet->setCellValue('A2', 3000.75);
90			$sheet->setCellValue('A3', 0);
91			$sheet->setCellValue('A4', 3000.25);
92			$fmt = '[Blue][>=3000.5]$#,##0.00;[Red][<0]$#,##0.00;$#,##0.00';
93			$sheet->getStyle('A1:A4')->getNumberFormat()->setFormatCode($fmt);
94
95			$writer = new Html($spreadsheet);
96			$html = $writer->generateHTMLAll();
97			$dom = new \DOMDocument();
98			$dom->loadHTML($html);
99			$body = $dom->getElementsByTagName('body')[0];
100			$divs = $body->getElementsByTagName('div');
101
102			$tabl = $divs[0]->getElementsByTagName('table');
103			$tbod = $tabl[0]->getElementsByTagName('tbody');
104			$rows = $tbod[0]->getElementsByTagName('tr');
105			self::assertCount(4, $rows);
106
107			$tds = $rows[0]->getElementsByTagName('td');
108			self::assertCount(1, $tds);
109			$spans = $tds[0]->getElementsByTagName('span');
110			self::assertCount(1, $spans);
111			$style = $spans[0]->getAttribute('style');
112			self::assertEquals(1, preg_match('/color:red/', $style));
113			self::assertEquals('$50.00', $spans[0]->textContent);
114
115			$tds = $rows[1]->getElementsByTagName('td');
116			self::assertCount(1, $tds);
117			$spans = $tds[0]->getElementsByTagName('span');
118			self::assertCount(1, $spans);
119			$style = $spans[0]->getAttribute('style');
120			self::assertEquals(1, preg_match('/color:blue/', $style));
121			self::assertEquals('$3,000.75', $spans[0]->textContent);
122
123			$tds = $rows[2]->getElementsByTagName('td');
124			self::assertCount(1, $tds);
125			$spans = $tds[0]->getElementsByTagName('span');
126			self::assertCount(0, $spans);
127			self::assertEquals('$0.00', $tds[0]->textContent);
128
129			$tds = $rows[3]->getElementsByTagName('td');
130			self::assertCount(1, $tds);
131			$spans = $tds[0]->getElementsByTagName('span');
132			self::assertCount(0, $spans);
133			self::assertEquals('$3,000.25', $tds[0]->textContent);
134
135			$this->writeAndReload($spreadsheet, 'Html');
136			}
137
138			/**
139			* @dataProvider providerNumberFormat
140			*
141			* @param mixed $expectedResult
142			* @param mixed $val
143			* @param mixed $fmt
144			*/
145			public function testFormatValueWithMask($expectedResult, $val, $fmt)
146			{
147			$spreadsheet = new Spreadsheet();
148			$sheet = $spreadsheet->getActiveSheet();
149			$sheet->getCell('A1')->setValue($val)->getStyle()->getNumberFormat()->setFormatCode($fmt);
150
151			$writer = new Html($spreadsheet);
152			$html = $writer->generateHTMLAll();
153			$dom = new \DOMDocument();
154			$dom->loadHTML($html);
155			$body = $dom->getElementsByTagName('body')[0];
156			$divs = $body->getElementsByTagName('div');
157
158			$tabl = $divs[0]->getElementsByTagName('table');
159			$tbod = $tabl[0]->getElementsByTagName('tbody');
160			$rows = $tbod[0]->getElementsByTagName('tr');
161
162			$tds = $rows[0]->getElementsByTagName('td');
163			$nbsp = html_entity_decode(' ');
164			self::assertEquals($expectedResult, str_replace($nbsp, ' ', $tds[0]->textContent));
165
166			$this->writeAndReload($spreadsheet, 'Html');
167			}
168
169			public function providerNumberFormat()
170			{
171			return require __DIR__ . '/../../../data/Style/NumberFormat.php';
172			}
173
174			/**
175			* @dataProvider providerNumberFormatDates
176			*
177			* @param mixed $expectedResult
178			* @param mixed $val
179			* @param mixed $fmt
180			*/
181			public function testFormatValueWithMaskDate($expectedResult, $val, $fmt)
182			{
183			$spreadsheet = new Spreadsheet();
184			$sheet = $spreadsheet->getActiveSheet();
185			$sheet->getCell('A1')->setValue($val)->getStyle()->getNumberFormat()->setFormatCode($fmt);
186
187			$writer = new Html($spreadsheet);
188			$html = $writer->generateHTMLAll();
189			$dom = new \DOMDocument();
190			$dom->loadHTML($html);
191			$body = $dom->getElementsByTagName('body')[0];
192			$divs = $body->getElementsByTagName('div');
193
194			$tabl = $divs[0]->getElementsByTagName('table');
195			$tbod = $tabl[0]->getElementsByTagName('tbody');
196			$rows = $tbod[0]->getElementsByTagName('tr');
197
198			$tds = $rows[0]->getElementsByTagName('td');
199			$nbsp = html_entity_decode(' ');
200			self::assertEquals($expectedResult, str_replace($nbsp, ' ', $tds[0]->textContent));
201
202			$this->writeAndReload($spreadsheet, 'Html');
203			}
204
205			public function providerNumberFormatDates()
206			{
207			return require __DIR__ . '/../../../data/Style/NumberFormatDates.php';
208			}
209			}
210

PHPOffice / PhpSpreadsheet

Push — master ( 4f6d4a...97a80f )

testFormatValueWithMaskDate() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like