GridlinesTest::testRichText() - 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

GridlinesTest::testRichText() B

↳ Parent: GridlinesTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	101
Code Lines	92

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	92
c	1
b	0
f	0
nc	1
nop	0
dl	0
loc	101
rs	8.1745

How to fix Long Method

<?php

namespace PhpOffice\PhpSpreadsheetTests\Writer\Html;

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Color;
use PhpOffice\PhpSpreadsheet\Writer\Html;
use PhpOffice\PhpSpreadsheetTests\Functional;

class GridlinesTest extends Functional\AbstractFunctional
{
    public function testGridlines()
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setShowGridlines(true)->setPrintGridlines(true);
        $sheet->setCellValue('A1', 1);
        $sheet = $spreadsheet->createSheet();
        $sheet->setShowGridlines(true)->setPrintGridlines(false);
        $sheet->setCellValue('A1', 1);
        $sheet = $spreadsheet->createSheet();
        $sheet->setShowGridlines(false)->setPrintGridlines(true);
        $sheet->setCellValue('A1', 1);
        $sheet = $spreadsheet->createSheet();
        $sheet->setShowGridlines(false)->setPrintGridlines(false);
        $sheet->setCellValue('A1', 1);

        $writer = new Html($spreadsheet);
        $writer->writeAllSheets();

        $html = $writer->generateHTMLAll();
        $dom = new \DOMDocument();
        $dom->loadHTML($html);
        $body = $dom->getElementsByTagName('body')[0];
        $divs = $body->getElementsByTagName('div');
        self::assertCount(4, $divs);

        $tbl = $divs[0]->getElementsByTagName('table')[0];
        $cls = $tbl->getAttribute('class');
        self::assertEquals('sheet0 gridlines gridlinesp', $cls);
        $tbl = $divs[1]->getElementsByTagName('table')[0];
        $cls = $tbl->getAttribute('class');
        self::assertEquals('sheet1 gridlines', $cls);
        $tbl = $divs[2]->getElementsByTagName('table')[0];
        $cls = $tbl->getAttribute('class');
        self::assertEquals('sheet2 gridlinesp', $cls);
        $tbl = $divs[3]->getElementsByTagName('table')[0];
        $cls = $tbl->getAttribute('class');
        self::assertEquals('sheet3', $cls);

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

    public function testGridlinesInline()
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $sheet->setShowGridlines(true)->setPrintGridlines(true);
        $sheet->setCellValue('A1', 1);
        $sheet = $spreadsheet->createSheet();
        $sheet->setShowGridlines(true)->setPrintGridlines(false);
        $sheet->setCellValue('A1', 1);
        $sheet = $spreadsheet->createSheet();
        $sheet->setShowGridlines(false)->setPrintGridlines(true);
        $sheet->setCellValue('A1', 1);
        $sheet = $spreadsheet->createSheet();
        $sheet->setShowGridlines(false)->setPrintGridlines(false);
        $sheet->setCellValue('A1', 1);

        $writer = new Html($spreadsheet);
        $writer->writeAllSheets();
        $writer->setUseInlineCss(true);

        $html = $writer->generateHTMLAll();
        $dom = new \DOMDocument();
        $dom->loadHTML($html);
        $body = $dom->getElementsByTagName('body')[0];
        $divs = $body->getElementsByTagName('div');
        self::assertCount(4, $divs);

        $tbl = $divs[0]->getElementsByTagName('table')[0];
        $cls = $tbl->getAttribute('class');
        self::assertEquals('gridlines gridlinesp', $cls);
        $tbl = $divs[1]->getElementsByTagName('table')[0];
        $cls = $tbl->getAttribute('class');
        self::assertEquals('gridlines', $cls);
        $tbl = $divs[2]->getElementsByTagName('table')[0];
        $cls = $tbl->getAttribute('class');
        self::assertEquals('gridlinesp', $cls);
        $tbl = $divs[3]->getElementsByTagName('table')[0];
        $cls = $tbl->getAttribute('class');
        self::assertEquals('', $cls);

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

    public function testRichText()
    {
        $spreadsheet = new Spreadsheet();
        $sheet = $spreadsheet->getActiveSheet();
        $emc2 = new \PhpOffice\PhpSpreadsheet\RichText\RichText();
        $part1 = $emc2->createTextRun('e=mc');
        $part1->getFont()->getColor()->setARGB(Color::COLOR_BLUE);
        $part2 = $emc2->createTextRun('2');
        $font = $part2->getFont();
        $font->getColor()->setARGB(Color::COLOR_DARKGREEN);
        $font->setSuperScript(true);
        $sheet->setCellValue('A1', $emc2);
        $h2o = new \PhpOffice\PhpSpreadsheet\RichText\RichText();
        $h2o->createTextRun('H');
        $part2 = $h2o->createTextRun('2');
        $font = $part2->getFont();
        $font->setSubScript(true);
        $font->getColor()->setARGB(Color::COLOR_RED);
        $h2o->createTextRun('O');
        $sheet->setCellValue('A2', $h2o);
        $h2so4 = new \PhpOffice\PhpSpreadsheet\RichText\RichText();
        $h2so4->createTextRun('H');
        $part2 = $h2so4->createTextRun('2');
        $font = $part2->getFont();
        $font->setSubScript(true);
        $h2so4->createTextRun('SO');
        $part4 = $h2so4->createTextRun('4');
        $part4->getFont()->setSubScript(true);
        $sheet->setCellValue('A3', $h2so4);
        $sheet->setCellValue('A4', '5');
        $sheet->getCell('A4')->getStyle()->getFont()->setSuperScript(true);
        $sheet->setCellValue('A5', '6');
        $sheet->getCell('A5')->getStyle()->getFont()->setSubScript(true);

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

        $tabl = $divs[0]->getElementsByTagName('table');
        $tbod = $tabl[0]->getElementsByTagName('tbody');
        $rows = $tbod[0]->getElementsByTagName('tr');
        self::assertCount(5, $rows);
        $tds = $rows[0]->getElementsByTagName('td');
        self::assertCount(1, $tds);
        $spans = $tds[0]->getElementsByTagName('span');
        self::assertCount(2, $spans);
        self::assertEquals('e=mc', $spans[0]->textContent);
        $style = $spans[0]->getAttribute('style');
        self::assertEquals(1, preg_match('/color:#0000FF/', $style));
        $style = $spans[1]->getAttribute('style');
        self::assertEquals(1, preg_match('/color:#008000/', $style));
        $sups = $spans[1]->getElementsByTagName('sup');
        self::assertCount(1, $sups);
        assert('2' == $sups[0]->textContent);

        $tds = $rows[1]->getElementsByTagName('td');
        assert(1 == count($tds));
        $spans = $tds[0]->getElementsByTagName('span');
        assert(3 == count($spans));
        assert('H' == $spans[0]->textContent);
        $style = $spans[1]->getAttribute('style');
        assert(1 == preg_match('/color:#FF0000/', $style));
        $subs = $spans[1]->getElementsByTagName('sub');
        assert(1 == count($subs));
        assert('2' == $subs[0]->textContent);
        assert('O' == $spans[2]->textContent);

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

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

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

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


1			<?php
2
3			namespace PhpOffice\PhpSpreadsheetTests\Writer\Html;
4
5			use PhpOffice\PhpSpreadsheet\Spreadsheet;
6			use PhpOffice\PhpSpreadsheet\Style\Color;
7			use PhpOffice\PhpSpreadsheet\Writer\Html;
8			use PhpOffice\PhpSpreadsheetTests\Functional;
9
10			class GridlinesTest extends Functional\AbstractFunctional
11			{
12			public function testGridlines()
13			{
14			$spreadsheet = new Spreadsheet();
15			$sheet = $spreadsheet->getActiveSheet();
16			$sheet->setShowGridlines(true)->setPrintGridlines(true);
17			$sheet->setCellValue('A1', 1);
18			$sheet = $spreadsheet->createSheet();
19			$sheet->setShowGridlines(true)->setPrintGridlines(false);
20			$sheet->setCellValue('A1', 1);
21			$sheet = $spreadsheet->createSheet();
22			$sheet->setShowGridlines(false)->setPrintGridlines(true);
23			$sheet->setCellValue('A1', 1);
24			$sheet = $spreadsheet->createSheet();
25			$sheet->setShowGridlines(false)->setPrintGridlines(false);
26			$sheet->setCellValue('A1', 1);
27
28			$writer = new Html($spreadsheet);
29			$writer->writeAllSheets();
30
31			$html = $writer->generateHTMLAll();
32			$dom = new \DOMDocument();
33			$dom->loadHTML($html);
34			$body = $dom->getElementsByTagName('body')[0];
35			$divs = $body->getElementsByTagName('div');
36			self::assertCount(4, $divs);
37
38			$tbl = $divs[0]->getElementsByTagName('table')[0];
39			$cls = $tbl->getAttribute('class');
40			self::assertEquals('sheet0 gridlines gridlinesp', $cls);
41			$tbl = $divs[1]->getElementsByTagName('table')[0];
42			$cls = $tbl->getAttribute('class');
43			self::assertEquals('sheet1 gridlines', $cls);
44			$tbl = $divs[2]->getElementsByTagName('table')[0];
45			$cls = $tbl->getAttribute('class');
46			self::assertEquals('sheet2 gridlinesp', $cls);
47			$tbl = $divs[3]->getElementsByTagName('table')[0];
48			$cls = $tbl->getAttribute('class');
49			self::assertEquals('sheet3', $cls);
50
51			$this->writeAndReload($spreadsheet, 'Html');
52			}
53
54			public function testGridlinesInline()
55			{
56			$spreadsheet = new Spreadsheet();
57			$sheet = $spreadsheet->getActiveSheet();
58			$sheet->setShowGridlines(true)->setPrintGridlines(true);
59			$sheet->setCellValue('A1', 1);
60			$sheet = $spreadsheet->createSheet();
61			$sheet->setShowGridlines(true)->setPrintGridlines(false);
62			$sheet->setCellValue('A1', 1);
63			$sheet = $spreadsheet->createSheet();
64			$sheet->setShowGridlines(false)->setPrintGridlines(true);
65			$sheet->setCellValue('A1', 1);
66			$sheet = $spreadsheet->createSheet();
67			$sheet->setShowGridlines(false)->setPrintGridlines(false);
68			$sheet->setCellValue('A1', 1);
69
70			$writer = new Html($spreadsheet);
71			$writer->writeAllSheets();
72			$writer->setUseInlineCss(true);
73
74			$html = $writer->generateHTMLAll();
75			$dom = new \DOMDocument();
76			$dom->loadHTML($html);
77			$body = $dom->getElementsByTagName('body')[0];
78			$divs = $body->getElementsByTagName('div');
79			self::assertCount(4, $divs);
80
81			$tbl = $divs[0]->getElementsByTagName('table')[0];
82			$cls = $tbl->getAttribute('class');
83			self::assertEquals('gridlines gridlinesp', $cls);
84			$tbl = $divs[1]->getElementsByTagName('table')[0];
85			$cls = $tbl->getAttribute('class');
86			self::assertEquals('gridlines', $cls);
87			$tbl = $divs[2]->getElementsByTagName('table')[0];
88			$cls = $tbl->getAttribute('class');
89			self::assertEquals('gridlinesp', $cls);
90			$tbl = $divs[3]->getElementsByTagName('table')[0];
91			$cls = $tbl->getAttribute('class');
92			self::assertEquals('', $cls);
93
94			$this->writeAndReload($spreadsheet, 'Html');
95			}
96
97			public function testRichText()
98			{
99			$spreadsheet = new Spreadsheet();
100			$sheet = $spreadsheet->getActiveSheet();
101			$emc2 = new \PhpOffice\PhpSpreadsheet\RichText\RichText();
102			$part1 = $emc2->createTextRun('e=mc');
103			$part1->getFont()->getColor()->setARGB(Color::COLOR_BLUE);
104			$part2 = $emc2->createTextRun('2');
105			$font = $part2->getFont();
106			$font->getColor()->setARGB(Color::COLOR_DARKGREEN);
107			$font->setSuperScript(true);
108			$sheet->setCellValue('A1', $emc2);
109			$h2o = new \PhpOffice\PhpSpreadsheet\RichText\RichText();
110			$h2o->createTextRun('H');
111			$part2 = $h2o->createTextRun('2');
112			$font = $part2->getFont();
113			$font->setSubScript(true);
114			$font->getColor()->setARGB(Color::COLOR_RED);
115			$h2o->createTextRun('O');
116			$sheet->setCellValue('A2', $h2o);
117			$h2so4 = new \PhpOffice\PhpSpreadsheet\RichText\RichText();
118			$h2so4->createTextRun('H');
119			$part2 = $h2so4->createTextRun('2');
120			$font = $part2->getFont();
121			$font->setSubScript(true);
122			$h2so4->createTextRun('SO');
123			$part4 = $h2so4->createTextRun('4');
124			$part4->getFont()->setSubScript(true);
125			$sheet->setCellValue('A3', $h2so4);
126			$sheet->setCellValue('A4', '5');
127			$sheet->getCell('A4')->getStyle()->getFont()->setSuperScript(true);
128			$sheet->setCellValue('A5', '6');
129			$sheet->getCell('A5')->getStyle()->getFont()->setSubScript(true);
130
131			$writer = new Html($spreadsheet);
132			$html = $writer->generateHTMLAll();
133			$dom = new \DOMDocument();
134			$dom->loadHTML($html);
135			$body = $dom->getElementsByTagName('body')[0];
136			$divs = $body->getElementsByTagName('div');
137			self::assertCount(1, $divs);
138
139			$tabl = $divs[0]->getElementsByTagName('table');
140			$tbod = $tabl[0]->getElementsByTagName('tbody');
141			$rows = $tbod[0]->getElementsByTagName('tr');
142			self::assertCount(5, $rows);
143			$tds = $rows[0]->getElementsByTagName('td');
144			self::assertCount(1, $tds);
145			$spans = $tds[0]->getElementsByTagName('span');
146			self::assertCount(2, $spans);
147			self::assertEquals('e=mc', $spans[0]->textContent);
148			$style = $spans[0]->getAttribute('style');
149			self::assertEquals(1, preg_match('/color:#0000FF/', $style));
150			$style = $spans[1]->getAttribute('style');
151			self::assertEquals(1, preg_match('/color:#008000/', $style));
152			$sups = $spans[1]->getElementsByTagName('sup');
153			self::assertCount(1, $sups);
154			assert('2' == $sups[0]->textContent);
155
156			$tds = $rows[1]->getElementsByTagName('td');
157			assert(1 == count($tds));
158			$spans = $tds[0]->getElementsByTagName('span');
159			assert(3 == count($spans));
160			assert('H' == $spans[0]->textContent);
161			$style = $spans[1]->getAttribute('style');
162			assert(1 == preg_match('/color:#FF0000/', $style));
163			$subs = $spans[1]->getElementsByTagName('sub');
164			assert(1 == count($subs));
165			assert('2' == $subs[0]->textContent);
166			assert('O' == $spans[2]->textContent);
167
168			$tds = $rows[2]->getElementsByTagName('td');
169			self::assertCount(1, $tds);
170			$spans = $tds[0]->getElementsByTagName('span');
171			self::assertCount(4, $spans);
172			self::assertEquals('H', $spans[0]->textContent);
173			$subs = $spans[1]->getElementsByTagName('sub');
174			self::assertCount(1, $subs);
175			self::assertEquals('2', $subs[0]->textContent);
176			self::assertEquals('SO', $spans[2]->textContent);
177			$subs = $spans[3]->getElementsByTagName('sub');
178			self::assertCount(1, $subs);
179			self::assertEquals('4', $subs[0]->textContent);
180
181			$tds = $rows[3]->getElementsByTagName('td');
182			self::assertCount(1, $tds);
183			$spans = $tds[0]->getElementsByTagName('span');
184			self::assertCount(0, $spans);
185			$sups = $tds[0]->getElementsByTagName('sup');
186			self::assertCount(1, $sups);
187			self::assertEquals('5', $sups[0]->textContent);
188
189			$tds = $rows[4]->getElementsByTagName('td');
190			self::assertCount(1, $tds);
191			$spans = $tds[0]->getElementsByTagName('span');
192			self::assertCount(0, $spans);
193			$subs = $tds[0]->getElementsByTagName('sub');
194			self::assertCount(1, $subs);
195			self::assertEquals('6', $subs[0]->textContent);
196
197			$this->writeAndReload($spreadsheet, 'Html');
198			}
199			}
200

PHPOffice / PhpSpreadsheet

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

GridlinesTest::testRichText() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like