wpdatatables / lib / phpoffice / phpspreadsheet / src / PhpSpreadsheet / Reader / Ods / PageSettings.php

PageSettings.php in wpDataTables – WordPress Data Table, Dynamic Tables & Table Charts Plugin 6.5.1.7, at lib/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Reader/Ods/PageSettings.php

185 lines 7.9 KB

Raw Download Zip

1	<?php
2
3	namespace PhpOffice\PhpSpreadsheet\Reader\Ods;
4
5	use DOMDocument;
6	use PhpOffice\PhpSpreadsheet\Worksheet\PageSetup;
7	use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
8
9	class PageSettings
10	{
11	/**
12	* @var string
13	*/
14	private $officeNs;
15
16	/**
17	* @var string
18	*/
19	private $stylesNs;
20
21	/**
22	* @var string
23	*/
24	private $stylesFo;
25
26	/**
27	* @var string
28	*/
29	private $tableNs;
30
31	/**
32	* @var string[]
33	*/
34	private $tableStylesCrossReference = [];
35
36	/** @var array */
37	private $pageLayoutStyles = [];
38
39	/**
40	* @var string[]
41	*/
42	private $masterStylesCrossReference = [];
43
44	/**
45	* @var string[]
46	*/
47	private $masterPrintStylesCrossReference = [];
48
49	public function __construct(DOMDocument $styleDom)
50	{
51	$this->setDomNameSpaces($styleDom);
52	$this->readPageSettingStyles($styleDom);
53	$this->readStyleMasterLookup($styleDom);
54	}
55
56	private function setDomNameSpaces(DOMDocument $styleDom): void
57	{
58	$this->officeNs = $styleDom->lookupNamespaceUri('office');
59	$this->stylesNs = $styleDom->lookupNamespaceUri('style');
60	$this->stylesFo = $styleDom->lookupNamespaceUri('fo');
61	$this->tableNs = $styleDom->lookupNamespaceUri('table');
62	}
63
64	private function readPageSettingStyles(DOMDocument $styleDom): void
65	{
66	$item0 = $styleDom->getElementsByTagNameNS($this->officeNs, 'automatic-styles')->item(0);
67	$styles = ($item0 === null) ? [] : $item0->getElementsByTagNameNS($this->stylesNs, 'page-layout');
68
69	foreach ($styles as $styleSet) {
70	$styleName = $styleSet->getAttributeNS($this->stylesNs, 'name');
71	$pageLayoutProperties = $styleSet->getElementsByTagNameNS($this->stylesNs, 'page-layout-properties')[0];
72	$styleOrientation = $pageLayoutProperties->getAttributeNS($this->stylesNs, 'print-orientation');
73	$styleScale = $pageLayoutProperties->getAttributeNS($this->stylesNs, 'scale-to');
74	$stylePrintOrder = $pageLayoutProperties->getAttributeNS($this->stylesNs, 'print-page-order');
75	$centered = $pageLayoutProperties->getAttributeNS($this->stylesNs, 'table-centering');
76
77	$marginLeft = $pageLayoutProperties->getAttributeNS($this->stylesFo, 'margin-left');
78	$marginRight = $pageLayoutProperties->getAttributeNS($this->stylesFo, 'margin-right');
79	$marginTop = $pageLayoutProperties->getAttributeNS($this->stylesFo, 'margin-top');
80	$marginBottom = $pageLayoutProperties->getAttributeNS($this->stylesFo, 'margin-bottom');
81	$header = $styleSet->getElementsByTagNameNS($this->stylesNs, 'header-style')[0];
82	$headerProperties = $header->getElementsByTagNameNS($this->stylesNs, 'header-footer-properties')[0];
83	$marginHeader = isset($headerProperties) ? $headerProperties->getAttributeNS($this->stylesFo, 'min-height') : null;
84	$footer = $styleSet->getElementsByTagNameNS($this->stylesNs, 'footer-style')[0];
85	$footerProperties = $footer->getElementsByTagNameNS($this->stylesNs, 'header-footer-properties')[0];
86	$marginFooter = isset($footerProperties) ? $footerProperties->getAttributeNS($this->stylesFo, 'min-height') : null;
87
88	$this->pageLayoutStyles[$styleName] = (object) [
89	'orientation' => $styleOrientation ?: PageSetup::ORIENTATION_DEFAULT,
90	'scale' => $styleScale ?: 100,
91	'printOrder' => $stylePrintOrder,
92	'horizontalCentered' => $centered === 'horizontal' \|\| $centered === 'both',
93	'verticalCentered' => $centered === 'vertical' \|\| $centered === 'both',
94	// margin size is already stored in inches, so no UOM conversion is required
95	'marginLeft' => (float) ($marginLeft ?? 0.7),
96	'marginRight' => (float) ($marginRight ?? 0.7),
97	'marginTop' => (float) ($marginTop ?? 0.3),
98	'marginBottom' => (float) ($marginBottom ?? 0.3),
99	'marginHeader' => (float) ($marginHeader ?? 0.45),
100	'marginFooter' => (float) ($marginFooter ?? 0.45),
101	];
102	}
103	}
104
105	private function readStyleMasterLookup(DOMDocument $styleDom): void
106	{
107	$item0 = $styleDom->getElementsByTagNameNS($this->officeNs, 'master-styles')->item(0);
108	$styleMasterLookup = ($item0 === null) ? [] : $item0->getElementsByTagNameNS($this->stylesNs, 'master-page');
109
110	foreach ($styleMasterLookup as $styleMasterSet) {
111	$styleMasterName = $styleMasterSet->getAttributeNS($this->stylesNs, 'name');
112	$pageLayoutName = $styleMasterSet->getAttributeNS($this->stylesNs, 'page-layout-name');
113	$this->masterPrintStylesCrossReference[$styleMasterName] = $pageLayoutName;
114	}
115	}
116
117	public function readStyleCrossReferences(DOMDocument $contentDom): void
118	{
119	$item0 = $contentDom->getElementsByTagNameNS($this->officeNs, 'automatic-styles')->item(0);
120	$styleXReferences = ($item0 === null) ? [] : $item0->getElementsByTagNameNS($this->stylesNs, 'style');
121
122	foreach ($styleXReferences as $styleXreferenceSet) {
123	$styleXRefName = $styleXreferenceSet->getAttributeNS($this->stylesNs, 'name');
124	$stylePageLayoutName = $styleXreferenceSet->getAttributeNS($this->stylesNs, 'master-page-name');
125	$styleFamilyName = $styleXreferenceSet->getAttributeNS($this->stylesNs, 'family');
126	if (!empty($styleFamilyName) && $styleFamilyName === 'table') {
127	$styleVisibility = 'true';
128	foreach ($styleXreferenceSet->getElementsByTagNameNS($this->stylesNs, 'table-properties') as $tableProperties) {
129	$styleVisibility = $tableProperties->getAttributeNS($this->tableNs, 'display');
130	}
131	$this->tableStylesCrossReference[$styleXRefName] = $styleVisibility;
132	}
133	if (!empty($stylePageLayoutName)) {
134	$this->masterStylesCrossReference[$styleXRefName] = $stylePageLayoutName;
135	}
136	}
137	}
138
139	public function setVisibilityForWorksheet(Worksheet $worksheet, string $styleName): void
140	{
141	if (!array_key_exists($styleName, $this->tableStylesCrossReference)) {
142	return;
143	}
144
145	$worksheet->setSheetState(
146	$this->tableStylesCrossReference[$styleName] === 'false'
147	? Worksheet::SHEETSTATE_HIDDEN
148	: Worksheet::SHEETSTATE_VISIBLE
149	);
150	}
151
152	public function setPrintSettingsForWorksheet(Worksheet $worksheet, string $styleName): void
153	{
154	if (!array_key_exists($styleName, $this->masterStylesCrossReference)) {
155	return;
156	}
157	$masterStyleName = $this->masterStylesCrossReference[$styleName];
158
159	if (!array_key_exists($masterStyleName, $this->masterPrintStylesCrossReference)) {
160	return;
161	}
162	$printSettingsIndex = $this->masterPrintStylesCrossReference[$masterStyleName];
163
164	if (!array_key_exists($printSettingsIndex, $this->pageLayoutStyles)) {
165	return;
166	}
167	$printSettings = $this->pageLayoutStyles[$printSettingsIndex];
168
169	$worksheet->getPageSetup()
170	->setOrientation($printSettings->orientation ?? PageSetup::ORIENTATION_DEFAULT)
171	->setPageOrder($printSettings->printOrder === 'ltr' ? PageSetup::PAGEORDER_OVER_THEN_DOWN : PageSetup::PAGEORDER_DOWN_THEN_OVER)
172	->setScale((int) trim($printSettings->scale, '%'))
173	->setHorizontalCentered($printSettings->horizontalCentered)
174	->setVerticalCentered($printSettings->verticalCentered);
175
176	$worksheet->getPageMargins()
177	->setLeft($printSettings->marginLeft)
178	->setRight($printSettings->marginRight)
179	->setTop($printSettings->marginTop)
180	->setBottom($printSettings->marginBottom)
181	->setHeader($printSettings->marginHeader)
182	->setFooter($printSettings->marginFooter);
183	}
184	}
185