visualizer / vendor / phpoffice / phpexcel / Classes / PHPExcel / Chart / Properties.php

Properties.php in Visualizer – Tables & Charts Manager with Built-in AI Generator 3.0.3, at vendor/phpoffice/phpexcel/Classes/PHPExcel/Chart/Properties.php

359 lines 9.9 KB

Raw Download Zip

1	<?php
2	/**
3	* Created by PhpStorm.
4	* User: nhw2h8s
5	* Date: 7/2/14
6	* Time: 5:45 PM
7	*/
8
9	abstract class PHPExcel_Properties {
10
11	const
12	EXCEL_COLOR_TYPE_STANDARD = 'prstClr',
13	EXCEL_COLOR_TYPE_SCHEME = 'schemeClr',
14	EXCEL_COLOR_TYPE_ARGB = 'srgbClr';
15
16	const
17	AXIS_LABELS_LOW = 'low',
18	AXIS_LABELS_HIGH = 'high',
19	AXIS_LABELS_NEXT_TO = 'nextTo',
20	AXIS_LABELS_NONE = 'none';
21
22	const
23	TICK_MARK_NONE = 'none',
24	TICK_MARK_INSIDE = 'in',
25	TICK_MARK_OUTSIDE = 'out',
26	TICK_MARK_CROSS = 'cross';
27
28	const
29	HORIZONTAL_CROSSES_AUTOZERO = 'autoZero',
30	HORIZONTAL_CROSSES_MAXIMUM = 'max';
31
32	const
33	FORMAT_CODE_GENERAL = 'General',
34	FORMAT_CODE_NUMBER = '#,##0.00',
35	FORMAT_CODE_CURRENCY = '$#,##0.00',
36	FORMAT_CODE_ACCOUNTING = '_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)',
37	FORMAT_CODE_DATE = 'm/d/yyyy',
38	FORMAT_CODE_TIME = '[$-F400]h:mm:ss AM/PM',
39	FORMAT_CODE_PERCENTAGE = '0.00%',
40	FORMAT_CODE_FRACTION = '# ?/?',
41	FORMAT_CODE_SCIENTIFIC = '0.00E+00',
42	FORMAT_CODE_TEXT = '@',
43	FORMAT_CODE_SPECIAL = '00000';
44
45	const
46	ORIENTATION_NORMAL = 'minMax',
47	ORIENTATION_REVERSED = 'maxMin';
48
49	const
50	LINE_STYLE_COMPOUND_SIMPLE = 'sng',
51	LINE_STYLE_COMPOUND_DOUBLE = 'dbl',
52	LINE_STYLE_COMPOUND_THICKTHIN = 'thickThin',
53	LINE_STYLE_COMPOUND_THINTHICK = 'thinThick',
54	LINE_STYLE_COMPOUND_TRIPLE = 'tri',
55
56	LINE_STYLE_DASH_SOLID = 'solid',
57	LINE_STYLE_DASH_ROUND_DOT = 'sysDot',
58	LINE_STYLE_DASH_SQUERE_DOT = 'sysDash',
59	LINE_STYPE_DASH_DASH = 'dash',
60	LINE_STYLE_DASH_DASH_DOT = 'dashDot',
61	LINE_STYLE_DASH_LONG_DASH = 'lgDash',
62	LINE_STYLE_DASH_LONG_DASH_DOT = 'lgDashDot',
63	LINE_STYLE_DASH_LONG_DASH_DOT_DOT = 'lgDashDotDot',
64
65	LINE_STYLE_CAP_SQUARE = 'sq',
66	LINE_STYLE_CAP_ROUND = 'rnd',
67	LINE_STYLE_CAP_FLAT = 'flat',
68
69	LINE_STYLE_JOIN_ROUND = 'bevel',
70	LINE_STYLE_JOIN_MITER = 'miter',
71	LINE_STYLE_JOIN_BEVEL = 'bevel',
72
73	LINE_STYLE_ARROW_TYPE_NOARROW = NULL,
74	LINE_STYLE_ARROW_TYPE_ARROW = 'triangle',
75	LINE_STYLE_ARROW_TYPE_OPEN = 'arrow',
76	LINE_STYLE_ARROW_TYPE_STEALTH = 'stealth',
77	LINE_STYLE_ARROW_TYPE_DIAMOND = 'diamond',
78	LINE_STYLE_ARROW_TYPE_OVAL = 'oval',
79
80	LINE_STYLE_ARROW_SIZE_1 = 1,
81	LINE_STYLE_ARROW_SIZE_2 = 2,
82	LINE_STYLE_ARROW_SIZE_3 = 3,
83	LINE_STYLE_ARROW_SIZE_4 = 4,
84	LINE_STYLE_ARROW_SIZE_5 = 5,
85	LINE_STYLE_ARROW_SIZE_6 = 6,
86	LINE_STYLE_ARROW_SIZE_7 = 7,
87	LINE_STYLE_ARROW_SIZE_8 = 8,
88	LINE_STYLE_ARROW_SIZE_9 = 9;
89
90	const
91	SHADOW_PRESETS_NOSHADOW = NULL,
92	SHADOW_PRESETS_OUTER_BOTTTOM_RIGHT = 1,
93	SHADOW_PRESETS_OUTER_BOTTOM = 2,
94	SHADOW_PRESETS_OUTER_BOTTOM_LEFT = 3,
95	SHADOW_PRESETS_OUTER_RIGHT = 4,
96	SHADOW_PRESETS_OUTER_CENTER = 5,
97	SHADOW_PRESETS_OUTER_LEFT = 6,
98	SHADOW_PRESETS_OUTER_TOP_RIGHT = 7,
99	SHADOW_PRESETS_OUTER_TOP = 8,
100	SHADOW_PRESETS_OUTER_TOP_LEFT = 9,
101	SHADOW_PRESETS_INNER_BOTTTOM_RIGHT = 10,
102	SHADOW_PRESETS_INNER_BOTTOM = 11,
103	SHADOW_PRESETS_INNER_BOTTOM_LEFT = 12,
104	SHADOW_PRESETS_INNER_RIGHT = 13,
105	SHADOW_PRESETS_INNER_CENTER = 14,
106	SHADOW_PRESETS_INNER_LEFT = 15,
107	SHADOW_PRESETS_INNER_TOP_RIGHT = 16,
108	SHADOW_PRESETS_INNER_TOP = 17,
109	SHADOW_PRESETS_INNER_TOP_LEFT = 18,
110	SHADOW_PRESETS_PERSPECTIVE_BELOW = 19,
111	SHADOW_PRESETS_PERSPECTIVE_UPPER_RIGHT = 20,
112	SHADOW_PRESETS_PERSPECTIVE_UPPER_LEFT = 21,
113	SHADOW_PRESETS_PERSPECTIVE_LOWER_RIGHT = 22,
114	SHADOW_PRESETS_PERSPECTIVE_LOWER_LEFT = 23;
115
116	protected function getExcelPointsWidth($width) {
117	return $width * 12700;
118	}
119
120	protected function getExcelPointsAngle($angle) {
121	return $angle * 60000;
122	}
123
124	protected function getTrueAlpha($alpha) {
125	return (string) 100 - $alpha . '000';
126	}
127
128	protected function setColorProperties($color, $alpha, $type) {
129	return array(
130	'type' => (string) $type,
131	'value' => (string) $color,
132	'alpha' => (string) $this->getTrueAlpha($alpha)
133	);
134	}
135
136	protected function getLineStyleArrowSize($array_selector, $array_kay_selector) {
137	$sizes = array(
138	1 => array('w' => 'sm', 'len' => 'sm'),
139	2 => array('w' => 'sm', 'len' => 'med'),
140	3 => array('w' => 'sm', 'len' => 'lg'),
141	4 => array('w' => 'med', 'len' => 'sm'),
142	5 => array('w' => 'med', 'len' => 'med'),
143	6 => array('w' => 'med', 'len' => 'lg'),
144	7 => array('w' => 'lg', 'len' => 'sm'),
145	8 => array('w' => 'lg', 'len' => 'med'),
146	9 => array('w' => 'lg', 'len' => 'lg')
147	);
148
149	return $sizes[$array_selector][$array_kay_selector];
150	}
151
152	protected function getShadowPresetsMap($shadow_presets_option) {
153	$presets_options = array(
154	//OUTER
155	1 => array(
156	'effect' => 'outerShdw',
157	'blur' => '50800',
158	'distance' => '38100',
159	'direction' => '2700000',
160	'algn' => 'tl',
161	'rotWithShape' => '0'
162	),
163	2 => array(
164	'effect' => 'outerShdw',
165	'blur' => '50800',
166	'distance' => '38100',
167	'direction' => '5400000',
168	'algn' => 't',
169	'rotWithShape' => '0'
170	),
171	3 => array(
172	'effect' => 'outerShdw',
173	'blur' => '50800',
174	'distance' => '38100',
175	'direction' => '8100000',
176	'algn' => 'tr',
177	'rotWithShape' => '0'
178	),
179	4 => array(
180	'effect' => 'outerShdw',
181	'blur' => '50800',
182	'distance' => '38100',
183	'algn' => 'l',
184	'rotWithShape' => '0'
185	),
186	5 => array(
187	'effect' => 'outerShdw',
188	'size' => array(
189	'sx' => '102000',
190	'sy' => '102000'
191	)
192	,
193	'blur' => '63500',
194	'distance' => '38100',
195	'algn' => 'ctr',
196	'rotWithShape' => '0'
197	),
198	6 => array(
199	'effect' => 'outerShdw',
200	'blur' => '50800',
201	'distance' => '38100',
202	'direction' => '10800000',
203	'algn' => 'r',
204	'rotWithShape' => '0'
205	),
206	7 => array(
207	'effect' => 'outerShdw',
208	'blur' => '50800',
209	'distance' => '38100',
210	'direction' => '18900000',
211	'algn' => 'bl',
212	'rotWithShape' => '0'
213	),
214	8 => array(
215	'effect' => 'outerShdw',
216	'blur' => '50800',
217	'distance' => '38100',
218	'direction' => '16200000',
219	'rotWithShape' => '0'
220	),
221	9 => array(
222	'effect' => 'outerShdw',
223	'blur' => '50800',
224	'distance' => '38100',
225	'direction' => '13500000',
226	'algn' => 'br',
227	'rotWithShape' => '0'
228	),
229	//INNER
230	10 => array(
231	'effect' => 'innerShdw',
232	'blur' => '63500',
233	'distance' => '50800',
234	'direction' => '2700000',
235	),
236	11 => array(
237	'effect' => 'innerShdw',
238	'blur' => '63500',
239	'distance' => '50800',
240	'direction' => '5400000',
241	),
242	12 => array(
243	'effect' => 'innerShdw',
244	'blur' => '63500',
245	'distance' => '50800',
246	'direction' => '8100000',
247	),
248	13 => array(
249	'effect' => 'innerShdw',
250	'blur' => '63500',
251	'distance' => '50800',
252	),
253	14 => array(
254	'effect' => 'innerShdw',
255	'blur' => '114300',
256	),
257	15 => array(
258	'effect' => 'innerShdw',
259	'blur' => '63500',
260	'distance' => '50800',
261	'direction' => '10800000',
262	),
263	16 => array(
264	'effect' => 'innerShdw',
265	'blur' => '63500',
266	'distance' => '50800',
267	'direction' => '18900000',
268	),
269	17 => array(
270	'effect' => 'innerShdw',
271	'blur' => '63500',
272	'distance' => '50800',
273	'direction' => '16200000',
274	),
275	18 => array(
276	'effect' => 'innerShdw',
277	'blur' => '63500',
278	'distance' => '50800',
279	'direction' => '13500000',
280	),
281	//perspective
282	19 => array(
283	'effect' => 'outerShdw',
284	'blur' => '152400',
285	'distance' => '317500',
286	'size' => array(
287	'sx' => '90000',
288	'sy' => '-19000',
289	),
290	'direction' => '5400000',
291	'rotWithShape' => '0',
292	),
293	20 => array(
294	'effect' => 'outerShdw',
295	'blur' => '76200',
296	'direction' => '18900000',
297	'size' => array(
298	'sy' => '23000',
299	'kx' => '-1200000',
300	),
301	'algn' => 'bl',
302	'rotWithShape' => '0',
303	),
304	21 => array(
305	'effect' => 'outerShdw',
306	'blur' => '76200',
307	'direction' => '13500000',
308	'size' => array(
309	'sy' => '23000',
310	'kx' => '1200000',
311	),
312	'algn' => 'br',
313	'rotWithShape' => '0',
314	),
315	22 => array(
316	'effect' => 'outerShdw',
317	'blur' => '76200',
318	'distance' => '12700',
319	'direction' => '2700000',
320	'size' => array(
321	'sy' => '-23000',
322	'kx' => '-800400',
323	),
324	'algn' => 'bl',
325	'rotWithShape' => '0',
326	),
327	23 => array(
328	'effect' => 'outerShdw',
329	'blur' => '76200',
330	'distance' => '12700',
331	'direction' => '8100000',
332	'size' => array(
333	'sy' => '-23000',
334	'kx' => '800400',
335	),
336	'algn' => 'br',
337	'rotWithShape' => '0',
338	),
339	);
340
341	return $presets_options[$shadow_presets_option];
342	}
343
344	protected function getArrayElementsValue($properties, $elements) {
345	$reference = & $properties;
346	if (!is_array($elements)) {
347	return $reference[$elements];
348	} else {
349	foreach ($elements as $keys) {
350	$reference = & $reference[$keys];
351	}
352
353	return $reference;
354	}
355
356	return $this;
357	}
358
359	}