Subversion Repositories eFlore/Applications.cel

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2388 jpm 1
<?php
2
/**
3
 * PHPExcel
4
 *
5
 * Copyright (c) 2006 - 2013 PHPExcel
6
 *
7
 * This library is free software; you can redistribute it and/or
8
 * modify it under the terms of the GNU Lesser General Public
9
 * License as published by the Free Software Foundation; either
10
 * version 2.1 of the License, or (at your option) any later version.
11
 *
12
 * This library is distributed in the hope that it will be useful,
13
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
15
 * Lesser General Public License for more details.
16
 *
17
 * You should have received a copy of the GNU Lesser General Public
18
 * License along with this library; if not, write to the Free Software
19
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
20
 *
21
 * @category	PHPExcel
22
 * @package		PHPExcel_Reader_Excel2007
23
 * @copyright	Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
24
 * @license		http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL
25
 * @version		##VERSION##, ##DATE##
26
 */
27
 
28
/**
29
 * PHPExcel_Reader_Excel2007_Chart
30
 *
31
 * @category	PHPExcel
32
 * @package		PHPExcel_Reader_Excel2007
33
 * @copyright	Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)
34
 */
35
class PHPExcel_Reader_Excel2007_Chart
36
{
37
	private static function _getAttribute($component, $name, $format) {
38
		$attributes = $component->attributes();
39
		if (isset($attributes[$name])) {
40
			if ($format == 'string') {
41
				return (string) $attributes[$name];
42
			} elseif ($format == 'integer') {
43
				return (integer) $attributes[$name];
44
			} elseif ($format == 'boolean') {
45
				return (boolean) ($attributes[$name] === '0' || $attributes[$name] !== 'true') ? false : true;
46
			} else {
47
				return (float) $attributes[$name];
48
			}
49
		}
50
		return null;
51
	}	//	function _getAttribute()
52
 
53
 
54
	private static function _readColor($color,$background=false) {
55
		if (isset($color["rgb"])) {
56
			return (string)$color["rgb"];
57
		} else if (isset($color["indexed"])) {
58
			return PHPExcel_Style_Color::indexedColor($color["indexed"]-7,$background)->getARGB();
59
		}
60
	}
61
 
62
 
63
	public static function readChart($chartElements,$chartName) {
64
		$namespacesChartMeta = $chartElements->getNamespaces(true);
65
		$chartElementsC = $chartElements->children($namespacesChartMeta['c']);
66
 
67
		$XaxisLabel = $YaxisLabel = $legend = $title = NULL;
68
		$dispBlanksAs = $plotVisOnly = NULL;
69
 
70
		foreach($chartElementsC as $chartElementKey => $chartElement) {
71
			switch ($chartElementKey) {
72
				case "chart":
73
					foreach($chartElement as $chartDetailsKey => $chartDetails) {
74
						$chartDetailsC = $chartDetails->children($namespacesChartMeta['c']);
75
						switch ($chartDetailsKey) {
76
							case "plotArea":
77
									$plotAreaLayout = $XaxisLable = $YaxisLable = null;
78
									$plotSeries = $plotAttributes = array();
79
									foreach($chartDetails as $chartDetailKey => $chartDetail) {
80
										switch ($chartDetailKey) {
81
											case "layout":
82
												$plotAreaLayout = self::_chartLayoutDetails($chartDetail,$namespacesChartMeta,'plotArea');
83
												break;
84
											case "catAx":
85
												if (isset($chartDetail->title)) {
86
													$XaxisLabel = self::_chartTitle($chartDetail->title->children($namespacesChartMeta['c']),$namespacesChartMeta,'cat');
87
												}
88
												break;
89
											case "dateAx":
90
												if (isset($chartDetail->title)) {
91
													$XaxisLabel = self::_chartTitle($chartDetail->title->children($namespacesChartMeta['c']),$namespacesChartMeta,'cat');
92
												}
93
												break;
94
											case "valAx":
95
												if (isset($chartDetail->title)) {
96
													$YaxisLabel = self::_chartTitle($chartDetail->title->children($namespacesChartMeta['c']),$namespacesChartMeta,'cat');
97
												}
98
												break;
99
											case "barChart":
100
											case "bar3DChart":
101
												$barDirection = self::_getAttribute($chartDetail->barDir, 'val', 'string');
102
												$plotSer = self::_chartDataSeries($chartDetail,$namespacesChartMeta,$chartDetailKey);
103
												$plotSer->setPlotDirection($barDirection);
104
												$plotSeries[] = $plotSer;
105
												$plotAttributes = self::_readChartAttributes($chartDetail);
106
												break;
107
											case "lineChart":
108
											case "line3DChart":
109
												$plotSeries[] = self::_chartDataSeries($chartDetail,$namespacesChartMeta,$chartDetailKey);
110
												$plotAttributes = self::_readChartAttributes($chartDetail);
111
												break;
112
											case "areaChart":
113
											case "area3DChart":
114
												$plotSeries[] = self::_chartDataSeries($chartDetail,$namespacesChartMeta,$chartDetailKey);
115
												$plotAttributes = self::_readChartAttributes($chartDetail);
116
												break;
117
											case "doughnutChart":
118
											case "pieChart":
119
											case "pie3DChart":
120
												$explosion = isset($chartDetail->ser->explosion);
121
												$plotSer = self::_chartDataSeries($chartDetail,$namespacesChartMeta,$chartDetailKey);
122
												$plotSer->setPlotStyle($explosion);
123
												$plotSeries[] = $plotSer;
124
												$plotAttributes = self::_readChartAttributes($chartDetail);
125
												break;
126
											case "scatterChart":
127
												$scatterStyle = self::_getAttribute($chartDetail->scatterStyle, 'val', 'string');
128
												$plotSer = self::_chartDataSeries($chartDetail,$namespacesChartMeta,$chartDetailKey);
129
												$plotSer->setPlotStyle($scatterStyle);
130
												$plotSeries[] = $plotSer;
131
												$plotAttributes = self::_readChartAttributes($chartDetail);
132
												break;
133
											case "bubbleChart":
134
												$bubbleScale = self::_getAttribute($chartDetail->bubbleScale, 'val', 'integer');
135
												$plotSer = self::_chartDataSeries($chartDetail,$namespacesChartMeta,$chartDetailKey);
136
												$plotSer->setPlotStyle($bubbleScale);
137
												$plotSeries[] = $plotSer;
138
												$plotAttributes = self::_readChartAttributes($chartDetail);
139
												break;
140
											case "radarChart":
141
												$radarStyle = self::_getAttribute($chartDetail->radarStyle, 'val', 'string');
142
												$plotSer = self::_chartDataSeries($chartDetail,$namespacesChartMeta,$chartDetailKey);
143
												$plotSer->setPlotStyle($radarStyle);
144
												$plotSeries[] = $plotSer;
145
												$plotAttributes = self::_readChartAttributes($chartDetail);
146
												break;
147
											case "surfaceChart":
148
											case "surface3DChart":
149
												$wireFrame = self::_getAttribute($chartDetail->wireframe, 'val', 'boolean');
150
												$plotSer = self::_chartDataSeries($chartDetail,$namespacesChartMeta,$chartDetailKey);
151
												$plotSer->setPlotStyle($wireFrame);
152
												$plotSeries[] = $plotSer;
153
												$plotAttributes = self::_readChartAttributes($chartDetail);
154
												break;
155
											case "stockChart":
156
												$plotSeries[] = self::_chartDataSeries($chartDetail,$namespacesChartMeta,$chartDetailKey);
157
												$plotAttributes = self::_readChartAttributes($plotAreaLayout);
158
												break;
159
										}
160
									}
161
									if ($plotAreaLayout == NULL) {
162
										$plotAreaLayout = new PHPExcel_Chart_Layout();
163
									}
164
									$plotArea = new PHPExcel_Chart_PlotArea($plotAreaLayout,$plotSeries);
165
									self::_setChartAttributes($plotAreaLayout,$plotAttributes);
166
									break;
167
							case "plotVisOnly":
168
									$plotVisOnly = self::_getAttribute($chartDetails, 'val', 'string');
169
									break;
170
							case "dispBlanksAs":
171
									$dispBlanksAs = self::_getAttribute($chartDetails, 'val', 'string');
172
									break;
173
							case "title":
174
									$title = self::_chartTitle($chartDetails,$namespacesChartMeta,'title');
175
									break;
176
							case "legend":
177
									$legendPos = 'r';
178
									$legendLayout = null;
179
									$legendOverlay = false;
180
									foreach($chartDetails as $chartDetailKey => $chartDetail) {
181
										switch ($chartDetailKey) {
182
											case "legendPos":
183
												$legendPos = self::_getAttribute($chartDetail, 'val', 'string');
184
												break;
185
											case "overlay":
186
												$legendOverlay = self::_getAttribute($chartDetail, 'val', 'boolean');
187
												break;
188
											case "layout":
189
												$legendLayout = self::_chartLayoutDetails($chartDetail,$namespacesChartMeta,'legend');
190
												break;
191
										}
192
									}
193
									$legend = new PHPExcel_Chart_Legend($legendPos, $legendLayout, $legendOverlay);
194
									break;
195
						}
196
					}
197
			}
198
		}
199
		$chart = new PHPExcel_Chart($chartName,$title,$legend,$plotArea,$plotVisOnly,$dispBlanksAs,$XaxisLabel,$YaxisLabel);
200
 
201
		return $chart;
202
	}	//	function readChart()
203
 
204
 
205
	private static function _chartTitle($titleDetails,$namespacesChartMeta,$type) {
206
		$caption = array();
207
		$titleLayout = null;
208
		foreach($titleDetails as $titleDetailKey => $chartDetail) {
209
			switch ($titleDetailKey) {
210
				case "tx":
211
					$titleDetails = $chartDetail->rich->children($namespacesChartMeta['a']);
212
					foreach($titleDetails as $titleKey => $titleDetail) {
213
						switch ($titleKey) {
214
							case "p":
215
								$titleDetailPart = $titleDetail->children($namespacesChartMeta['a']);
216
								$caption[] = self::_parseRichText($titleDetailPart);
217
						}
218
					}
219
					break;
220
				case "layout":
221
					$titleLayout = self::_chartLayoutDetails($chartDetail,$namespacesChartMeta);
222
					break;
223
			}
224
		}
225
 
226
		return new PHPExcel_Chart_Title($caption, $titleLayout);
227
	}	//	function _chartTitle()
228
 
229
 
230
	private static function _chartLayoutDetails($chartDetail,$namespacesChartMeta) {
231
		if (!isset($chartDetail->manualLayout)) {
232
			return null;
233
		}
234
		$details = $chartDetail->manualLayout->children($namespacesChartMeta['c']);
235
		if (is_null($details)) {
236
			return null;
237
		}
238
		$layout = array();
239
		foreach($details as $detailKey => $detail) {
240
//			echo $detailKey,' => ',self::_getAttribute($detail, 'val', 'string'),PHP_EOL;
241
			$layout[$detailKey] = self::_getAttribute($detail, 'val', 'string');
242
		}
243
		return new PHPExcel_Chart_Layout($layout);
244
	}	//	function _chartLayoutDetails()
245
 
246
 
247
	private static function _chartDataSeries($chartDetail,$namespacesChartMeta,$plotType) {
248
		$multiSeriesType = NULL;
249
		$smoothLine = false;
250
		$seriesLabel = $seriesCategory = $seriesValues = $plotOrder = array();
251
 
252
		$seriesDetailSet = $chartDetail->children($namespacesChartMeta['c']);
253
		foreach($seriesDetailSet as $seriesDetailKey => $seriesDetails) {
254
			switch ($seriesDetailKey) {
255
				case "grouping":
256
					$multiSeriesType = self::_getAttribute($chartDetail->grouping, 'val', 'string');
257
					break;
258
				case "ser":
259
					$marker = NULL;
260
					foreach($seriesDetails as $seriesKey => $seriesDetail) {
261
						switch ($seriesKey) {
262
							case "idx":
263
								$seriesIndex = self::_getAttribute($seriesDetail, 'val', 'integer');
264
								break;
265
							case "order":
266
								$seriesOrder = self::_getAttribute($seriesDetail, 'val', 'integer');
267
								$plotOrder[$seriesIndex] = $seriesOrder;
268
								break;
269
							case "tx":
270
								$seriesLabel[$seriesIndex] = self::_chartDataSeriesValueSet($seriesDetail,$namespacesChartMeta);
271
								break;
272
							case "marker":
273
								$marker = self::_getAttribute($seriesDetail->symbol, 'val', 'string');
274
								break;
275
							case "smooth":
276
								$smoothLine = self::_getAttribute($seriesDetail, 'val', 'boolean');
277
								break;
278
							case "cat":
279
								$seriesCategory[$seriesIndex] = self::_chartDataSeriesValueSet($seriesDetail,$namespacesChartMeta);
280
								break;
281
							case "val":
282
								$seriesValues[$seriesIndex] = self::_chartDataSeriesValueSet($seriesDetail,$namespacesChartMeta,$marker);
283
								break;
284
							case "xVal":
285
								$seriesCategory[$seriesIndex] = self::_chartDataSeriesValueSet($seriesDetail,$namespacesChartMeta,$marker);
286
								break;
287
							case "yVal":
288
								$seriesValues[$seriesIndex] = self::_chartDataSeriesValueSet($seriesDetail,$namespacesChartMeta,$marker);
289
								break;
290
						}
291
					}
292
			}
293
		}
294
		return new PHPExcel_Chart_DataSeries($plotType,$multiSeriesType,$plotOrder,$seriesLabel,$seriesCategory,$seriesValues,$smoothLine);
295
	}	//	function _chartDataSeries()
296
 
297
 
298
	private static function _chartDataSeriesValueSet($seriesDetail, $namespacesChartMeta, $marker = null, $smoothLine = false) {
299
		if (isset($seriesDetail->strRef)) {
300
			$seriesSource = (string) $seriesDetail->strRef->f;
301
			$seriesData = self::_chartDataSeriesValues($seriesDetail->strRef->strCache->children($namespacesChartMeta['c']),'s');
302
 
303
			return new PHPExcel_Chart_DataSeriesValues('String',$seriesSource,$seriesData['formatCode'],$seriesData['pointCount'],$seriesData['dataValues'],$marker,$smoothLine);
304
		} elseif (isset($seriesDetail->numRef)) {
305
			$seriesSource = (string) $seriesDetail->numRef->f;
306
			$seriesData = self::_chartDataSeriesValues($seriesDetail->numRef->numCache->children($namespacesChartMeta['c']));
307
 
308
			return new PHPExcel_Chart_DataSeriesValues('Number',$seriesSource,$seriesData['formatCode'],$seriesData['pointCount'],$seriesData['dataValues'],$marker,$smoothLine);
309
		} elseif (isset($seriesDetail->multiLvlStrRef)) {
310
			$seriesSource = (string) $seriesDetail->multiLvlStrRef->f;
311
			$seriesData = self::_chartDataSeriesValuesMultiLevel($seriesDetail->multiLvlStrRef->multiLvlStrCache->children($namespacesChartMeta['c']),'s');
312
			$seriesData['pointCount'] = count($seriesData['dataValues']);
313
 
314
			return new PHPExcel_Chart_DataSeriesValues('String',$seriesSource,$seriesData['formatCode'],$seriesData['pointCount'],$seriesData['dataValues'],$marker,$smoothLine);
315
		} elseif (isset($seriesDetail->multiLvlNumRef)) {
316
			$seriesSource = (string) $seriesDetail->multiLvlNumRef->f;
317
			$seriesData = self::_chartDataSeriesValuesMultiLevel($seriesDetail->multiLvlNumRef->multiLvlNumCache->children($namespacesChartMeta['c']),'s');
318
			$seriesData['pointCount'] = count($seriesData['dataValues']);
319
 
320
			return new PHPExcel_Chart_DataSeriesValues('String',$seriesSource,$seriesData['formatCode'],$seriesData['pointCount'],$seriesData['dataValues'],$marker,$smoothLine);
321
		}
322
		return null;
323
	}	//	function _chartDataSeriesValueSet()
324
 
325
 
326
	private static function _chartDataSeriesValues($seriesValueSet,$dataType='n') {
327
		$seriesVal = array();
328
		$formatCode = '';
329
		$pointCount = 0;
330
 
331
		foreach($seriesValueSet as $seriesValueIdx => $seriesValue) {
332
			switch ($seriesValueIdx) {
333
				case 'ptCount':
334
					$pointCount = self::_getAttribute($seriesValue, 'val', 'integer');
335
					break;
336
				case 'formatCode':
337
					$formatCode = (string) $seriesValue;
338
					break;
339
				case 'pt':
340
					$pointVal = self::_getAttribute($seriesValue, 'idx', 'integer');
341
					if ($dataType == 's') {
342
						$seriesVal[$pointVal] = (string) $seriesValue->v;
343
					} else {
344
						$seriesVal[$pointVal] = (float) $seriesValue->v;
345
					}
346
					break;
347
			}
348
		}
349
 
350
		if (empty($seriesVal)) {
351
			$seriesVal = NULL;
352
		}
353
 
354
		return array( 'formatCode'	=> $formatCode,
355
					  'pointCount'	=> $pointCount,
356
					  'dataValues'	=> $seriesVal
357
					);
358
	}	//	function _chartDataSeriesValues()
359
 
360
 
361
	private static function _chartDataSeriesValuesMultiLevel($seriesValueSet,$dataType='n') {
362
		$seriesVal = array();
363
		$formatCode = '';
364
		$pointCount = 0;
365
 
366
		foreach($seriesValueSet->lvl as $seriesLevelIdx => $seriesLevel) {
367
			foreach($seriesLevel as $seriesValueIdx => $seriesValue) {
368
				switch ($seriesValueIdx) {
369
					case 'ptCount':
370
						$pointCount = self::_getAttribute($seriesValue, 'val', 'integer');
371
						break;
372
					case 'formatCode':
373
						$formatCode = (string) $seriesValue;
374
						break;
375
					case 'pt':
376
						$pointVal = self::_getAttribute($seriesValue, 'idx', 'integer');
377
						if ($dataType == 's') {
378
							$seriesVal[$pointVal][] = (string) $seriesValue->v;
379
						} else {
380
							$seriesVal[$pointVal][] = (float) $seriesValue->v;
381
						}
382
						break;
383
				}
384
			}
385
		}
386
 
387
		return array( 'formatCode'	=> $formatCode,
388
					  'pointCount'	=> $pointCount,
389
					  'dataValues'	=> $seriesVal
390
					);
391
	}	//	function _chartDataSeriesValuesMultiLevel()
392
 
393
	private static function _parseRichText($titleDetailPart = null) {
394
		$value = new PHPExcel_RichText();
395
 
396
		foreach($titleDetailPart as $titleDetailElementKey => $titleDetailElement) {
397
			if (isset($titleDetailElement->t)) {
398
				$objText = $value->createTextRun( (string) $titleDetailElement->t );
399
			}
400
			if (isset($titleDetailElement->rPr)) {
401
				if (isset($titleDetailElement->rPr->rFont["val"])) {
402
					$objText->getFont()->setName((string) $titleDetailElement->rPr->rFont["val"]);
403
				}
404
 
405
				$fontSize = (self::_getAttribute($titleDetailElement->rPr, 'sz', 'integer'));
406
				if (!is_null($fontSize)) {
407
					$objText->getFont()->setSize(floor($fontSize / 100));
408
				}
409
 
410
				$fontColor = (self::_getAttribute($titleDetailElement->rPr, 'color', 'string'));
411
				if (!is_null($fontColor)) {
412
					$objText->getFont()->setColor( new PHPExcel_Style_Color( self::_readColor($fontColor) ) );
413
				}
414
 
415
				$bold = self::_getAttribute($titleDetailElement->rPr, 'b', 'boolean');
416
				if (!is_null($bold)) {
417
					$objText->getFont()->setBold($bold);
418
				}
419
 
420
				$italic = self::_getAttribute($titleDetailElement->rPr, 'i', 'boolean');
421
				if (!is_null($italic)) {
422
					$objText->getFont()->setItalic($italic);
423
				}
424
 
425
				$baseline = self::_getAttribute($titleDetailElement->rPr, 'baseline', 'integer');
426
				if (!is_null($baseline)) {
427
					if ($baseline > 0) {
428
						$objText->getFont()->setSuperScript(true);
429
					} elseif($baseline < 0) {
430
						$objText->getFont()->setSubScript(true);
431
					}
432
				}
433
 
434
				$underscore = (self::_getAttribute($titleDetailElement->rPr, 'u', 'string'));
435
				if (!is_null($underscore)) {
436
					if ($underscore == 'sng') {
437
						$objText->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
438
					} elseif($underscore == 'dbl') {
439
						$objText->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_DOUBLE);
440
					} else {
441
						$objText->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_NONE);
442
					}
443
				}
444
 
445
				$strikethrough = (self::_getAttribute($titleDetailElement->rPr, 's', 'string'));
446
				if (!is_null($strikethrough)) {
447
					if ($strikethrough == 'noStrike') {
448
						$objText->getFont()->setStrikethrough(false);
449
					} else {
450
						$objText->getFont()->setStrikethrough(true);
451
					}
452
				}
453
			}
454
		}
455
 
456
		return $value;
457
	}
458
 
459
	private static function _readChartAttributes($chartDetail) {
460
		$plotAttributes = array();
461
		if (isset($chartDetail->dLbls)) {
462
			if (isset($chartDetail->dLbls->howLegendKey)) {
463
				$plotAttributes['showLegendKey'] = self::_getAttribute($chartDetail->dLbls->showLegendKey, 'val', 'string');
464
			}
465
			if (isset($chartDetail->dLbls->showVal)) {
466
				$plotAttributes['showVal'] = self::_getAttribute($chartDetail->dLbls->showVal, 'val', 'string');
467
			}
468
			if (isset($chartDetail->dLbls->showCatName)) {
469
				$plotAttributes['showCatName'] = self::_getAttribute($chartDetail->dLbls->showCatName, 'val', 'string');
470
			}
471
			if (isset($chartDetail->dLbls->showSerName)) {
472
				$plotAttributes['showSerName'] = self::_getAttribute($chartDetail->dLbls->showSerName, 'val', 'string');
473
			}
474
			if (isset($chartDetail->dLbls->showPercent)) {
475
				$plotAttributes['showPercent'] = self::_getAttribute($chartDetail->dLbls->showPercent, 'val', 'string');
476
			}
477
			if (isset($chartDetail->dLbls->showBubbleSize)) {
478
				$plotAttributes['showBubbleSize'] = self::_getAttribute($chartDetail->dLbls->showBubbleSize, 'val', 'string');
479
			}
480
			if (isset($chartDetail->dLbls->showLeaderLines)) {
481
				$plotAttributes['showLeaderLines'] = self::_getAttribute($chartDetail->dLbls->showLeaderLines, 'val', 'string');
482
			}
483
		}
484
 
485
		return $plotAttributes;
486
	}
487
 
488
	private static function _setChartAttributes($plotArea,$plotAttributes)
489
	{
490
		foreach($plotAttributes as $plotAttributeKey => $plotAttributeValue) {
491
			switch($plotAttributeKey) {
492
				case 'showLegendKey' :
493
					$plotArea->setShowLegendKey($plotAttributeValue);
494
					break;
495
				case 'showVal' :
496
					$plotArea->setShowVal($plotAttributeValue);
497
					break;
498
				case 'showCatName' :
499
					$plotArea->setShowCatName($plotAttributeValue);
500
					break;
501
				case 'showSerName' :
502
					$plotArea->setShowSerName($plotAttributeValue);
503
					break;
504
				case 'showPercent' :
505
					$plotArea->setShowPercent($plotAttributeValue);
506
					break;
507
				case 'showBubbleSize' :
508
					$plotArea->setShowBubbleSize($plotAttributeValue);
509
					break;
510
				case 'showLeaderLines' :
511
					$plotArea->setShowLeaderLines($plotAttributeValue);
512
					break;
513
			}
514
		}
515
	}
516
 
517
}