Completed
Pull Request — develop (#412)
by Franck
53:01 queued 32:55
created

PptCharts::writeTypePie3D()   C

Complexity

Conditions 13
Paths 9

Size

Total Lines 154

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 77
CRAP Score 13

Importance

Changes 0
Metric Value
dl 0
loc 154
rs 5.2933
c 0
b 0
f 0
ccs 77
cts 77
cp 1
cc 13
nc 9
nop 3
crap 13

How to fix   Long Method    Complexity   

Long Method

Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.

For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.

Commonly applied refactorings include:

1
<?php
2
3
namespace PhpOffice\PhpPresentation\Writer\PowerPoint2007;
4
5
use PhpOffice\Common\Drawing as CommonDrawing;
6
use PhpOffice\Common\XMLWriter;
7
use PhpOffice\PhpPresentation\PhpPresentation;
8
use PhpOffice\PhpPresentation\Shape\Chart;
9
use PhpOffice\PhpPresentation\Shape\Chart\Gridlines;
10
use PhpOffice\PhpPresentation\Shape\Chart\Legend;
11
use PhpOffice\PhpPresentation\Shape\Chart\PlotArea;
12
use PhpOffice\PhpPresentation\Shape\Chart\Title;
13
use PhpOffice\PhpPresentation\Shape\Chart\Type\Area;
14
use PhpOffice\PhpPresentation\Shape\Chart\Type\Bar;
15
use PhpOffice\PhpPresentation\Shape\Chart\Type\Bar3D;
16
use PhpOffice\PhpPresentation\Shape\Chart\Type\Radar;
17
use PhpOffice\PhpPresentation\Shape\Chart\Type\Doughnut;
18
use PhpOffice\PhpPresentation\Shape\Chart\Type\Line;
19
use PhpOffice\PhpPresentation\Shape\Chart\Type\Pie;
20
use PhpOffice\PhpPresentation\Shape\Chart\Type\Pie3D;
21
use PhpOffice\PhpPresentation\Shape\Chart\Type\Scatter;
22
use PhpOffice\PhpPresentation\Style\Border;
23
use PhpOffice\PhpPresentation\Style\Fill;
24
25
class PptCharts extends AbstractDecoratorWriter
26
{
27
    /**
28
     * @return \PhpOffice\Common\Adapter\Zip\ZipInterface
29
     * @throws \Exception
30 115
     */
31
    public function render()
32 115
    {
33 45
        for ($i = 0; $i < $this->getDrawingHashTable()->count(); ++$i) {
34 45
            $shape = $this->getDrawingHashTable()->getByIndex($i);
35 36
            if ($shape instanceof Chart) {
36
                $this->getZip()->addFromString('ppt/charts/' . $shape->getIndexedFilename(), $this->writeChart($shape));
37 35
38
                if ($shape->hasIncludedSpreadsheet()) {
39
                    $this->getZip()->addFromString('ppt/charts/_rels/' . $shape->getIndexedFilename() . '.rels', $this->writeChartRelationships($shape));
40
                    $pFilename = tempnam(sys_get_temp_dir(), 'PHPExcel');
41
                    $this->getZip()->addFromString('ppt/embeddings/' . $shape->getIndexedFilename() . '.xlsx', $this->writeSpreadsheet($this->getPresentation(), $shape, $pFilename . '.xlsx'));
42
                    
43
                    // remove temp file
44
                    if (@unlink($pFilename) === false) {
45
                        throw new \Exception('The file ' . $pFilename . ' could not removed.');
46
                    }
47
                }
48
            }
49 114
        }
50
        return $this->getZip();
51
    }
52
53
54
    /**
55
     * Write chart to XML format
56
     *
57
     * @param  \PhpOffice\PhpPresentation\Shape\Chart $chart
58
     * @return string                    XML Output
59
     * @throws \Exception
60 36
     */
61
    public function writeChart(Chart $chart)
62
    {
63 36
        // Create XML writer
64
        $objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
65
66 36
        // XML header
67
        $objWriter->startDocument('1.0', 'UTF-8', 'yes');
68
69 36
        // c:chartSpace
70 36
        $objWriter->startElement('c:chartSpace');
71 36
        $objWriter->writeAttribute('xmlns:c', 'http://schemas.openxmlformats.org/drawingml/2006/chart');
72 36
        $objWriter->writeAttribute('xmlns:a', 'http://schemas.openxmlformats.org/drawingml/2006/main');
73
        $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
74
75 36
        // c:date1904
76 36
        $objWriter->startElement('c:date1904');
77 36
        $objWriter->writeAttribute('val', '1');
78
        $objWriter->endElement();
79
80 36
        // c:lang
81 36
        $objWriter->startElement('c:lang');
82 36
        $objWriter->writeAttribute('val', 'en-US');
83
        $objWriter->endElement();
84
85 36
        // c:chart
86
        $objWriter->startElement('c:chart');
87
88 36
        // Title?
89
        if ($chart->getTitle()->isVisible()) {
90 35
            // Write title
91
            $this->writeTitle($objWriter, $chart->getTitle());
92
        }
93
94 36
        // c:autoTitleDeleted
95 36
        $objWriter->startElement('c:autoTitleDeleted');
96 36
        $objWriter->writeAttribute('val', $chart->getTitle()->isVisible() ? '0' : '1');
97
        $objWriter->endElement();
98
99 36
        // c:view3D
100
        $objWriter->startElement('c:view3D');
101
102 36
        // c:rotX
103 36
        $objWriter->startElement('c:rotX');
104 36
        $objWriter->writeAttribute('val', $chart->getView3D()->getRotationX());
105
        $objWriter->endElement();
106
107 36
        // c:hPercent
108 36
        $hPercent = $chart->getView3D()->getHeightPercent();
109
        $objWriter->writeElementIf($hPercent != null, 'c:hPercent', 'val', $hPercent);
110
111 36
        // c:rotY
112 36
        $objWriter->startElement('c:rotY');
113 36
        $objWriter->writeAttribute('val', $chart->getView3D()->getRotationY());
114
        $objWriter->endElement();
115
116 36
        // c:depthPercent
117 36
        $objWriter->startElement('c:depthPercent');
118 36
        $objWriter->writeAttribute('val', $chart->getView3D()->getDepthPercent());
119
        $objWriter->endElement();
120
121 36
        // c:rAngAx
122 36
        $objWriter->startElement('c:rAngAx');
123 36
        $objWriter->writeAttribute('val', $chart->getView3D()->hasRightAngleAxes() ? '1' : '0');
124
        $objWriter->endElement();
125
126 36
        // c:perspective
127 36
        $objWriter->startElement('c:perspective');
128 36
        $objWriter->writeAttribute('val', $chart->getView3D()->getPerspective());
129
        $objWriter->endElement();
130 36
131
        $objWriter->endElement();
132
133 36
        // Write plot area
134
        $this->writePlotArea($objWriter, $chart->getPlotArea(), $chart);
135
136 35
        // Legend?
137
        if ($chart->getLegend()->isVisible()) {
138 35
            // Write legend
139
            $this->writeLegend($objWriter, $chart->getLegend());
140
        }
141
142 35
        // c:plotVisOnly
143 35
        $objWriter->startElement('c:plotVisOnly');
144 35
        $objWriter->writeAttribute('val', '1');
145
        $objWriter->endElement();
146 35
147
        $objWriter->endElement();
148
149 35
        // c:spPr
150
        $objWriter->startElement('c:spPr');
151
152 35
        // Fill
153
        $this->writeFill($objWriter, $chart->getFill());
154
155 35
        // Border
156 1
        if ($chart->getBorder()->getLineStyle() != Border::LINE_NONE) {
157
            $this->writeBorder($objWriter, $chart->getBorder(), '');
158
        }
159
160 35
        // Shadow
161
        if ($chart->getShadow()->isVisible()) {
162 1
            // a:effectLst
163
            $objWriter->startElement('a:effectLst');
164
165 1
            // a:outerShdw
166 1
            $objWriter->startElement('a:outerShdw');
167 1
            $objWriter->writeAttribute('blurRad', CommonDrawing::pixelsToEmu($chart->getShadow()->getBlurRadius()));
168 1
            $objWriter->writeAttribute('dist', CommonDrawing::pixelsToEmu($chart->getShadow()->getDistance()));
169 1
            $objWriter->writeAttribute('dir', CommonDrawing::degreesToAngle($chart->getShadow()->getDirection()));
170 1
            $objWriter->writeAttribute('algn', $chart->getShadow()->getAlignment());
171
            $objWriter->writeAttribute('rotWithShape', '0');
172 1
173
            $this->writeColor($objWriter, $chart->getShadow()->getColor(), $chart->getShadow()->getAlpha());
174 1
175
            $objWriter->endElement();
176 1
177
            $objWriter->endElement();
178
        }
179 35
180
        $objWriter->endElement();
181
182 35
        // External data?
183
        if ($chart->hasIncludedSpreadsheet()) {
184
            // c:externalData
185
            $objWriter->startElement('c:externalData');
186
            $objWriter->writeAttribute('r:id', 'rId1');
187
188
            // c:autoUpdate
189
            $objWriter->startElement('c:autoUpdate');
190
            $objWriter->writeAttribute('val', '0');
191
            $objWriter->endElement();
192
193
            $objWriter->endElement();
194
        }
195 35
196
        $objWriter->endElement();
197
198 35
        // Return
199
        return $objWriter->getData();
200
    }
201
202
    /**
203
     * Write chart to XML format
204
     *
205
     * @param  PhpPresentation $presentation
206
     * @param  \PhpOffice\PhpPresentation\Shape\Chart $chart
207
     * @param  string $tempName
208
     * @return string                    String output
209
     * @throws \Exception
210
     */
211
    public function writeSpreadsheet(PhpPresentation $presentation, $chart, $tempName)
212
    {
213
        // Need output?
214
        if (!$chart->hasIncludedSpreadsheet()) {
215
            throw new \Exception('No spreadsheet output is required for the given chart.');
216
        }
217
218
        // Verify PHPExcel
219
        if (!class_exists('PHPExcel')) {
220
            throw new \Exception('PHPExcel has not been loaded. Include PHPExcel.php in your script, e.g. require_once \'PHPExcel.php\'.');
221
        }
222
223
        // Create new spreadsheet
224
        $workbook = new \PHPExcel();
225
226
        // Set properties
227
        $title = $chart->getTitle()->getText();
228
        if (strlen($title) == 0) {
229
            $title = 'Chart';
230
        }
231
        $workbook->getProperties()->setCreator($presentation->getDocumentProperties()->getCreator())->setLastModifiedBy($presentation->getDocumentProperties()->getLastModifiedBy())->setTitle($title);
232
233
        // Add chart data
234
        $sheet = $workbook->setActiveSheetIndex(0);
235
        $sheet->setTitle('Sheet1');
236
237
        // Write series
238
        $seriesIndex = 0;
239
        foreach ($chart->getPlotArea()->getType()->getSeries() as $series) {
240
            // Title
241
            $sheet->setCellValueByColumnAndRow(1 + $seriesIndex, 1, $series->getTitle());
242
243
            // X-axis
244
            $axisXData = array_keys($series->getValues());
245
            $numAxisXData = count($axisXData);
246
            for ($i = 0; $i < $numAxisXData; $i++) {
247
                $sheet->setCellValueByColumnAndRow(0, $i + 2, $axisXData[$i]);
248
            }
249
250
            // Y-axis
251
            $axisYData = array_values($series->getValues());
252
            $numAxisYData = count($axisYData);
253
            for ($i = 0; $i < $numAxisYData; $i++) {
254
                $sheet->setCellValueByColumnAndRow(1 + $seriesIndex, $i + 2, $axisYData[$i]);
255
            }
256
257
            ++$seriesIndex;
258
        }
259
260
        // Save to string
261
        $writer = \PHPExcel_IOFactory::createWriter($workbook, 'Excel2007');
262
        $writer->save($tempName);
263
264
        // Load file in memory
265
        $returnValue = file_get_contents($tempName);
266
        if (@unlink($tempName) === false) {
267
            throw new \Exception('The file ' . $tempName . ' could not removed.');
268
        }
269
270
        return $returnValue;
271
    }
272
273
    /**
274
     * Write element with value attribute
275
     *
276
     * @param \PhpOffice\Common\XMLWriter $objWriter XML Writer
277
     * @param string $elementName
278
     * @param string $value
279 31
     */
280
    protected function writeElementWithValAttribute($objWriter, $elementName, $value)
281 31
    {
282 31
        $objWriter->startElement($elementName);
283 31
        $objWriter->writeAttribute('val', $value);
284 31
        $objWriter->endElement();
285
    }
286
287
    /**
288
     * Write single value or reference
289
     *
290
     * @param \PhpOffice\Common\XMLWriter $objWriter XML Writer
291
     * @param boolean $isReference
292
     * @param mixed $value
293
     * @param string $reference
294 31
     */
295
    protected function writeSingleValueOrReference($objWriter, $isReference, $value, $reference)
296 31
    {
297
        if (!$isReference) {
298 31
            // Value
299 31
            $objWriter->writeElement('c:v', $value);
300
            return;
301
        }
302
303
        // Reference and cache
304
        $objWriter->startElement('c:strRef');
305
        $objWriter->writeElement('c:f', $reference);
306
        $objWriter->startElement('c:strCache');
307
        $objWriter->startElement('c:ptCount');
308
        $objWriter->writeAttribute('val', '1');
309
        $objWriter->endElement();
310
311
        $objWriter->startElement('c:pt');
312
        $objWriter->writeAttribute('idx', '0');
313
        $objWriter->writeElement('c:v', $value);
314
        $objWriter->endElement();
315
        $objWriter->endElement();
316
        $objWriter->endElement();
317
    }
318
319
    /**
320
     * Write series value or reference
321
     *
322
     * @param \PhpOffice\Common\XMLWriter $objWriter XML Writer
323
     * @param boolean $isReference
324
     * @param mixed $values
325
     * @param string $reference
326 31
     */
327
    protected function writeMultipleValuesOrReference($objWriter, $isReference, $values, $reference)
328
    {
329
        // c:strLit / c:numLit
330 31
        // c:strRef / c:numRef
331 31
        $referenceType = ($isReference ? 'Ref' : 'Lit');
332 31
        $dataType = 'str';
333 31
        if (is_int($values[0]) || is_float($values[0])) {
334
            $dataType = 'num';
335 31
        }
336
        $objWriter->startElement('c:' . $dataType . $referenceType);
337 31
338 31
        $numValues = count($values);
339
        if (!$isReference) {
340
            // Value
341
342 31
            // c:ptCount
343 31
            $objWriter->startElement('c:ptCount');
344 31
            $objWriter->writeAttribute('val', count($values));
345
            $objWriter->endElement();
346
347 31
            // Add points
348
            for ($i = 0; $i < $numValues; $i++) {
349 31
                // c:pt
350 31
                $objWriter->startElement('c:pt');
351 31
                $objWriter->writeAttribute('idx', $i);
352 31
                $objWriter->writeElement('c:v', $values[$i]);
353
                $objWriter->endElement();
354
            }
355
        } else {
356
            // Reference
357
            $objWriter->writeElement('c:f', $reference);
358
            $objWriter->startElement('c:' . $dataType . 'Cache');
359
360
            // c:ptCount
361
            $objWriter->startElement('c:ptCount');
362
            $objWriter->writeAttribute('val', count($values));
363
            $objWriter->endElement();
364
365
            // Add points
366
            for ($i = 0; $i < $numValues; $i++) {
367
                // c:pt
368
                $objWriter->startElement('c:pt');
369
                $objWriter->writeAttribute('idx', $i);
370
                $objWriter->writeElement('c:v', $values[$i]);
371
                $objWriter->endElement();
372
            }
373
374
            $objWriter->endElement();
375
        }
376 31
377 31
        $objWriter->endElement();
378
    }
379
380
    /**
381
     * Write Title
382
     *
383
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
384
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Title $subject
385
     * @throws \Exception
386 35
     */
387
    protected function writeTitle(XMLWriter $objWriter, Title $subject)
388
    {
389 35
        // c:title
390
        $objWriter->startElement('c:title');
391
392 35
        // c:tx
393
        $objWriter->startElement('c:tx');
394
395 35
        // c:rich
396
        $objWriter->startElement('c:rich');
397
398 35
        // a:bodyPr
399
        $objWriter->writeElement('a:bodyPr', null);
400
401 35
        // a:lstStyle
402
        $objWriter->writeElement('a:lstStyle', null);
403
404 35
        // a:p
405
        $objWriter->startElement('a:p');
406
407 35
        // a:pPr
408 35
        $objWriter->startElement('a:pPr');
409 35
        $objWriter->writeAttribute('algn', $subject->getAlignment()->getHorizontal());
410 35
        $objWriter->writeAttribute('fontAlgn', $subject->getAlignment()->getVertical());
411 35
        $objWriter->writeAttribute('marL', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginLeft()));
412 35
        $objWriter->writeAttribute('marR', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginRight()));
413 35
        $objWriter->writeAttribute('indent', CommonDrawing::pixelsToEmu($subject->getAlignment()->getIndent()));
414
        $objWriter->writeAttribute('lvl', $subject->getAlignment()->getLevel());
415
416 35
        // a:defRPr
417
        $objWriter->writeElement('a:defRPr', null);
418 35
419
        $objWriter->endElement();
420
421 35
        // a:r
422
        $objWriter->startElement('a:r');
423
424 35
        // a:rPr
425 35
        $objWriter->startElement('a:rPr');
426 35
        $objWriter->writeAttribute('lang', 'en-US');
427
        $objWriter->writeAttribute('dirty', '0');
428 35
429 35
        $objWriter->writeAttribute('b', ($subject->getFont()->isBold() ? 'true' : 'false'));
430 35
        $objWriter->writeAttribute('i', ($subject->getFont()->isItalic() ? 'true' : 'false'));
431 35
        $objWriter->writeAttribute('strike', ($subject->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
432 35
        $objWriter->writeAttribute('sz', ($subject->getFont()->getSize() * 100));
433 35
        $objWriter->writeAttribute('u', $subject->getFont()->getUnderline());
434 35
        $objWriter->writeAttributeIf($subject->getFont()->isSuperScript(), 'baseline', '30000');
435
        $objWriter->writeAttributeIf($subject->getFont()->isSubScript(), 'baseline', '-25000');
436
437 35
        // Font - a:solidFill
438
        $objWriter->startElement('a:solidFill');
439 35
440
        $this->writeColor($objWriter, $subject->getFont()->getColor());
441 35
442
        $objWriter->endElement();
443
444 35
        // Font - a:latin
445 35
        $objWriter->startElement('a:latin');
446 35
        $objWriter->writeAttribute('typeface', $subject->getFont()->getName());
447
        $objWriter->endElement();
448 35
449
        $objWriter->endElement();
450
451 35
        // a:t
452
        $objWriter->writeElement('a:t', $subject->getText());
453 35
454
        $objWriter->endElement();
455
456 35
        // a:endParaRPr
457 35
        $objWriter->startElement('a:endParaRPr');
458 35
        $objWriter->writeAttribute('lang', 'en-US');
459 35
        $objWriter->writeAttribute('dirty', '0');
460
        $objWriter->endElement();
461 35
462
        $objWriter->endElement();
463 35
464
        $objWriter->endElement();
465 35
466
        $objWriter->endElement();
467
468 35
        // Write layout
469
        $this->writeLayout($objWriter, $subject);
470
471 35
        // c:overlay
472 35
        $objWriter->startElement('c:overlay');
473 35
        $objWriter->writeAttribute('val', '0');
474
        $objWriter->endElement();
475 35
476 35
        $objWriter->endElement();
477
    }
478
479
    /**
480
     * Write Plot Area
481
     *
482
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
483
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\PlotArea $subject
484
     * @param  \PhpOffice\PhpPresentation\Shape\Chart $chart
485
     * @throws \Exception
486 36
     */
487
    protected function writePlotArea(XMLWriter $objWriter, PlotArea $subject, Chart $chart)
488
    {
489 36
        // c:plotArea
490
        $objWriter->startElement('c:plotArea');
491
492 36
        // Write layout
493
        $this->writeLayout($objWriter, $subject);
494
495 36
        // Write chart
496 36
        $chartType = $subject->getType();
497 1
        if ($chartType instanceof Area) {
498 35
            $this->writeTypeArea($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
499 3
        } elseif ($chartType instanceof Bar) {
500 32
            $this->writeTypeBar($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
501 4
        } elseif ($chartType instanceof Bar3D) {
502 28
            $this->writeTypeBar3D($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
503 1
        } elseif ($chartType instanceof Doughnut) {
504 27
            $this->writeTypeDoughnut($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
505 2
        } elseif ($chartType instanceof Pie) {
506 25
            $this->writeTypePie($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
507 4
        } elseif ($chartType instanceof Pie3D) {
508 21
            $this->writeTypePie3D($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
509 15
        } elseif ($chartType instanceof Line) {
510 6
            $this->writeTypeLine($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
511 5
        } elseif ($chartType instanceof Radar) {
512
            $this->writeTypeRadar($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
513 1
        } elseif ($chartType instanceof Scatter) {
514
            $this->writeTypeScatter($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
515
        } else {
516
            throw new \Exception('The chart type provided could not be rendered.');
517 35
        }
518 28
519
        // Write X axis?
520
        if ($chartType->hasAxisX()) {
521
            $this->writeAxis($objWriter, $subject->getAxisX(), Chart\Axis::AXIS_X, $chartType);
522 35
        }
523 28
524
        // Write Y axis?
525
        if ($chartType->hasAxisY()) {
526 35
            $this->writeAxis($objWriter, $subject->getAxisY(), Chart\Axis::AXIS_Y, $chartType);
527 35
        }
528
529
        $objWriter->endElement();
530
    }
531
532
    /**
533
     * Write Legend
534
     *
535
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
536 35
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Legend $subject
537
     * @throws \Exception
538
     */
539 35
    protected function writeLegend(XMLWriter $objWriter, Legend $subject)
540
    {
541
        // c:legend
542 35
        $objWriter->startElement('c:legend');
543 35
544 35
        // c:legendPos
545
        $objWriter->startElement('c:legendPos');
546
        $objWriter->writeAttribute('val', $subject->getPosition());
547 35
        $objWriter->endElement();
548
549
        // Write layout
550 35
        $this->writeLayout($objWriter, $subject);
551 35
552 35
        // c:overlay
553
        $objWriter->startElement('c:overlay');
554
        $objWriter->writeAttribute('val', '0');
555 35
        $objWriter->endElement();
556
557
        // c:spPr
558 35
        $objWriter->startElement('c:spPr');
559
560
        // Fill
561 35
        $this->writeFill($objWriter, $subject->getFill());
562 35
563
        // Border
564
        if ($subject->getBorder()->getLineStyle() != Border::LINE_NONE) {
565 35
            $this->writeBorder($objWriter, $subject->getBorder(), '');
566
        }
567
568 35
        $objWriter->endElement();
569
570
        // c:txPr
571 35
        $objWriter->startElement('c:txPr');
572
573
        // a:bodyPr
574 35
        $objWriter->writeElement('a:bodyPr', null);
575
576
        // a:lstStyle
577 35
        $objWriter->writeElement('a:lstStyle', null);
578
579
        // a:p
580 35
        $objWriter->startElement('a:p');
581 35
582 35
        // a:pPr
583 35
        $objWriter->startElement('a:pPr');
584 35
        $objWriter->writeAttribute('algn', $subject->getAlignment()->getHorizontal());
585 35
        $objWriter->writeAttribute('fontAlgn', $subject->getAlignment()->getVertical());
586 35
        $objWriter->writeAttribute('marL', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginLeft()));
587
        $objWriter->writeAttribute('marR', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginRight()));
588
        $objWriter->writeAttribute('indent', CommonDrawing::pixelsToEmu($subject->getAlignment()->getIndent()));
589 35
        $objWriter->writeAttribute('lvl', $subject->getAlignment()->getLevel());
590
591 35
        // a:defRPr
592 35
        $objWriter->startElement('a:defRPr');
593 35
594 35
        $objWriter->writeAttribute('b', ($subject->getFont()->isBold() ? 'true' : 'false'));
595 35
        $objWriter->writeAttribute('i', ($subject->getFont()->isItalic() ? 'true' : 'false'));
596 35
        $objWriter->writeAttribute('strike', ($subject->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
597 35
        $objWriter->writeAttribute('sz', ($subject->getFont()->getSize() * 100));
598
        $objWriter->writeAttribute('u', $subject->getFont()->getUnderline());
599
        $objWriter->writeAttributeIf($subject->getFont()->isSuperScript(), 'baseline', '30000');
600 35
        $objWriter->writeAttributeIf($subject->getFont()->isSubScript(), 'baseline', '-25000');
601
602 35
        // Font - a:solidFill
603
        $objWriter->startElement('a:solidFill');
604 35
605
        $this->writeColor($objWriter, $subject->getFont()->getColor());
606
607 35
        $objWriter->endElement();
608 35
609 35
        // Font - a:latin
610
        $objWriter->startElement('a:latin');
611 35
        $objWriter->writeAttribute('typeface', $subject->getFont()->getName());
612
        $objWriter->endElement();
613 35
614
        $objWriter->endElement();
615
616 35
        $objWriter->endElement();
617 35
618 35
        // a:endParaRPr
619 35
        $objWriter->startElement('a:endParaRPr');
620
        $objWriter->writeAttribute('lang', 'en-US');
621 35
        $objWriter->writeAttribute('dirty', '0');
622
        $objWriter->endElement();
623 35
624
        $objWriter->endElement();
625 35
626 35
        $objWriter->endElement();
627
628
        $objWriter->endElement();
629
    }
630
631
    /**
632
     * Write Layout
633
     *
634
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
635 36
     * @param  mixed $subject
636
     * @throws \Exception
637
     */
638 36
    protected function writeLayout(XMLWriter $objWriter, $subject)
639
    {
640
        // c:layout
641 36
        $objWriter->startElement('c:layout');
642
643 36
        // c:manualLayout
644 36
        $objWriter->startElement('c:manualLayout');
645 36
        // c:xMode
646
        $objWriter->startElement('c:xMode');
647
        $objWriter->writeAttribute('val', 'edge');
648 36
        $objWriter->endElement();
649 36
650 36
        // c:yMode
651
        $objWriter->startElement('c:yMode');
652 36
        $objWriter->writeAttribute('val', 'edge');
653
        $objWriter->endElement();
654 35
655 35
        if ($subject->getOffsetX() != 0) {
656 35
            // c:x
657
            $objWriter->startElement('c:x');
658
            $objWriter->writeAttribute('val', $subject->getOffsetX());
659 36
            $objWriter->endElement();
660
        }
661 35
662 35
        if ($subject->getOffsetY() != 0) {
663 35
            // c:y
664
            $objWriter->startElement('c:y');
665
            $objWriter->writeAttribute('val', $subject->getOffsetY());
666 36
            $objWriter->endElement();
667
        }
668
669
        if ($subject->getWidth() != 0) {
670
            // c:w
671
            $objWriter->startElement('c:w');
672
            $objWriter->writeAttribute('val', $subject->getWidth());
673 36
            $objWriter->endElement();
674
        }
675
676
        if ($subject->getHeight() != 0) {
677
            // c:h
678
            $objWriter->startElement('c:h');
679
            $objWriter->writeAttribute('val', $subject->getHeight());
680 36
            $objWriter->endElement();
681 36
        }
682 36
683
        $objWriter->endElement();
684
        $objWriter->endElement();
685
    }
686
687
    /**
688
     * Write Type Area
689
     *
690
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
691
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Area $subject
692 1
     * @param  boolean $includeSheet
693
     * @throws \Exception
694
     */
695 1
    protected function writeTypeArea(XMLWriter $objWriter, Area $subject, $includeSheet = false)
696
    {
697
        // c:lineChart
698 1
        $objWriter->startElement('c:areaChart');
699 1
700 1
        // c:grouping
701
        $objWriter->startElement('c:grouping');
702
        $objWriter->writeAttribute('val', 'standard');
703 1
        $objWriter->endElement();
704 1
705
        // Write series
706 1
        $seriesIndex = 0;
707
        foreach ($subject->getSeries() as $series) {
708
            // c:ser
709 1
            $objWriter->startElement('c:ser');
710 1
711 1
            // c:ser > c:idx
712
            $objWriter->startElement('c:idx');
713
            $objWriter->writeAttribute('val', $seriesIndex);
714 1
            $objWriter->endElement();
715 1
716 1
            // c:ser > c:order
717
            $objWriter->startElement('c:order');
718
            $objWriter->writeAttribute('val', $seriesIndex);
719 1
            $objWriter->endElement();
720 1
721 1
            // c:ser > c:tx
722 1
            $objWriter->startElement('c:tx');
723
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
724
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
725
            $objWriter->endElement();
726 1
727
            // c:ser > c:dLbls
728
            // @link : https://msdn.microsoft.com/en-us/library/documentformat.openxml.drawing.charts.areachartseries.aspx
729 1
            $objWriter->startElement('c:dLbls');
730
731
            // c:ser > c:dLbls > c:showVal
732 1
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
733
734
            // c:ser > c:dLbls > c:showCatName
735 1
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
736
737
            // c:ser > c:dLbls > c:showSerName
738 1
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
739
740
            // c:ser > c:dLbls > c:showPercent
741 1
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
742
743 1
            // c:ser > ##c:dLbls
744
            $objWriter->endElement();
745
746
            if ($series->getFill()->getFillType() != Fill::FILL_NONE) {
747
                // c:spPr
748
                $objWriter->startElement('c:spPr');
749
                // Write fill
750
                $this->writeFill($objWriter, $series->getFill());
751
                // ## c:spPr
752
                $objWriter->endElement();
753 1
            }
754
755
            // Write X axis data
756 1
            $axisXData = array_keys($series->getValues());
757 1
758 1
            // c:cat
759
            $objWriter->startElement('c:cat');
760
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
761 1
            $objWriter->endElement();
762
763
            // Write Y axis data
764 1
            $axisYData = array_values($series->getValues());
765 1
766 1
            // c:val
767 1
            $objWriter->startElement('c:val');
768
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
769 1
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
770
            $objWriter->endElement();
771 1
772
            $objWriter->endElement();
773
774
            ++$seriesIndex;
775 1
        }
776 1
777 1
        // c:axId
778
        $objWriter->startElement('c:axId');
779
        $objWriter->writeAttribute('val', '52743552');
780 1
        $objWriter->endElement();
781 1
782 1
        // c:axId
783
        $objWriter->startElement('c:axId');
784 1
        $objWriter->writeAttribute('val', '52749440');
785 1
        $objWriter->endElement();
786
787
        $objWriter->endElement();
788
    }
789
790
    /**
791
     * Write Type Bar
792
     *
793
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
794
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Bar $subject
795 3
     * @param  boolean $includeSheet
796
     * @throws \Exception
797
     */
798 3
    protected function writeTypeBar(XMLWriter $objWriter, Bar $subject, $includeSheet = false)
799
    {
800
        // c:bar3DChart
801 3
        $objWriter->startElement('c:barChart');
802 3
803 3
        // c:barDir
804
        $objWriter->startElement('c:barDir');
805
        $objWriter->writeAttribute('val', $subject->getBarDirection());
806 3
        $objWriter->endElement();
807 3
808 3
        // c:grouping
809
        $objWriter->startElement('c:grouping');
810
        $objWriter->writeAttribute('val', $subject->getBarGrouping());
811 3
        $objWriter->endElement();
812 3
813
        // Write series
814 3
        $seriesIndex = 0;
815
        foreach ($subject->getSeries() as $series) {
816
            // c:ser
817 3
            $objWriter->startElement('c:ser');
818 3
819 3
            // c:idx
820
            $objWriter->startElement('c:idx');
821
            $objWriter->writeAttribute('val', $seriesIndex);
822 3
            $objWriter->endElement();
823 3
824 3
            // c:order
825
            $objWriter->startElement('c:order');
826
            $objWriter->writeAttribute('val', $seriesIndex);
827 3
            $objWriter->endElement();
828 3
829 3
            // c:tx
830 3
            $objWriter->startElement('c:tx');
831
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
832
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
833 3
            $objWriter->endElement();
834 3
835
            // Fills for points?
836 1
            $dataPointFills = $series->getDataPointFills();
837
            foreach ($dataPointFills as $key => $value) {
838
                // c:dPt
839 1
                $objWriter->startElement('c:dPt');
840
841 1
                // c:idx
842
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
843 1
844
                if ($value->getFillType() != Fill::FILL_NONE) {
845 1
                    // c:spPr
846
                    $objWriter->startElement('c:spPr');
847 1
                    // Write fill
848
                    $this->writeFill($objWriter, $value);
849
                    // ## c:spPr
850
                    $objWriter->endElement();
851 1
                }
852
853
                // ## c:dPt
854
                $objWriter->endElement();
855 3
            }
856
857 3
            // c:dLbls
858
            $objWriter->startElement('c:dLbls');
859
860
            if ($series->hasDlblNumFormat()) {
861
                //c:numFmt
862
                $objWriter->startElement('c:numFmt');
863
                $objWriter->writeAttribute('formatCode', $series->getDlblNumFormat());
864
                $objWriter->writeAttribute('sourceLinked', '0');
865
                $objWriter->endElement();
866 3
            }
867
868
            // c:txPr
869 3
            $objWriter->startElement('c:txPr');
870
871
            // a:bodyPr
872 3
            $objWriter->writeElement('a:bodyPr', null);
873
874
            // a:lstStyle
875 3
            $objWriter->writeElement('a:lstStyle', null);
876
877
            // a:p
878 3
            $objWriter->startElement('a:p');
879
880
            // a:pPr
881 3
            $objWriter->startElement('a:pPr');
882
883 3
            // a:defRPr
884 3
            $objWriter->startElement('a:defRPr');
885 3
886 3
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
887 3
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
888 3
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
889 3
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
890
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
891
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
892 3
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
893
894 3
            // Font - a:solidFill
895
            $objWriter->startElement('a:solidFill');
896 3
897
            $this->writeColor($objWriter, $series->getFont()->getColor());
898
899 3
            $objWriter->endElement();
900 3
901 3
            // Font - a:latin
902
            $objWriter->startElement('a:latin');
903 3
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
904
            $objWriter->endElement();
905 3
906
            $objWriter->endElement();
907
908 3
            $objWriter->endElement();
909 3
910 3
            // a:endParaRPr
911 3
            $objWriter->startElement('a:endParaRPr');
912
            $objWriter->writeAttribute('lang', 'en-US');
913 3
            $objWriter->writeAttribute('dirty', '0');
914
            $objWriter->endElement();
915 3
916
            $objWriter->endElement();
917
918 3
            $objWriter->endElement();
919
920
            // c:dLblPos
921 3
            $this->writeElementWithValAttribute($objWriter, 'c:dLblPos', $series->getLabelPosition());
922
923
            // c:showVal
924 3
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
925
926
            // c:showCatName
927 3
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
928
929
            // c:showSerName
930 3
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
931
932
            // c:showPercent
933 3
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
934
935
            // c:showLeaderLines
936 3
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
937
938 3
            // c:separator
939
            $objWriter->writeElementIf($series->hasShowSeparator(), 'c:separator', 'val', $series->getSeparator());
940
941 3
            $objWriter->endElement();
942
943
            // c:spPr
944
            if ($series->getFill()->getFillType() != Fill::FILL_NONE) {
945
                // c:spPr
946
                $objWriter->startElement('c:spPr');
947
                // Write fill
948
                $this->writeFill($objWriter, $series->getFill());
949
                // ## c:spPr
950
                $objWriter->endElement();
951 3
            }
952
953
            // Write X axis data
954 3
            $axisXData = array_keys($series->getValues());
955 3
956 3
            // c:cat
957
            $objWriter->startElement('c:cat');
958
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
959 3
            $objWriter->endElement();
960
961
            // Write Y axis data
962 3
            $axisYData = array_values($series->getValues());
963 3
964 3
            // c:val
965 3
            $objWriter->startElement('c:val');
966
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
967 3
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
968
            $objWriter->endElement();
969 3
970
            $objWriter->endElement();
971
972
            ++$seriesIndex;
973 3
        }
974 3
975 3
        // c:overlap
976
        $objWriter->startElement('c:overlap');
977
        if ($subject->getBarGrouping() == Bar::GROUPING_CLUSTERED) {
978
            $objWriter->writeAttribute('val', '0');
979 3
        } elseif ($subject->getBarGrouping() == Bar::GROUPING_STACKED || $subject->getBarGrouping() == Bar::GROUPING_PERCENTSTACKED) {
980
            $objWriter->writeAttribute('val', '100');
981
        }
982 3
        $objWriter->endElement();
983 3
984 3
        // c:gapWidth
985
        $objWriter->startElement('c:gapWidth');
986
        $objWriter->writeAttribute('val', $subject->getGapWidthPercent());
987 3
        $objWriter->endElement();
988 3
989 3
        // c:shape
990
        $objWriter->startElement('c:shape');
991
        $objWriter->writeAttribute('val', 'box');
992 3
        $objWriter->endElement();
993 3
994 3
        // c:axId
995
        $objWriter->startElement('c:axId');
996
        $objWriter->writeAttribute('val', '52743552');
997 3
        $objWriter->endElement();
998 3
999 3
        // c:axId
1000
        $objWriter->startElement('c:axId');
1001
        $objWriter->writeAttribute('val', '52749440');
1002 3
        $objWriter->endElement();
1003 3
1004 3
        // c:axId
1005
        $objWriter->startElement('c:axId');
1006 3
        $objWriter->writeAttribute('val', '0');
1007 3
        $objWriter->endElement();
1008
1009
        $objWriter->endElement();
1010
    }
1011
1012
    /**
1013
     * Write Type Bar3D
1014
     *
1015
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
1016
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Bar3D $subject
1017 4
     * @param  boolean $includeSheet
1018
     * @throws \Exception
1019
     */
1020 4
    protected function writeTypeBar3D(XMLWriter $objWriter, Bar3D $subject, $includeSheet = false)
1021
    {
1022
        // c:bar3DChart
1023 4
        $objWriter->startElement('c:bar3DChart');
1024 4
1025 4
        // c:barDir
1026
        $objWriter->startElement('c:barDir');
1027
        $objWriter->writeAttribute('val', $subject->getBarDirection());
1028 4
        $objWriter->endElement();
1029 4
1030 4
        // c:grouping
1031
        $objWriter->startElement('c:grouping');
1032
        $objWriter->writeAttribute('val', $subject->getBarGrouping());
1033 4
        $objWriter->endElement();
1034 4
1035
        // Write series
1036 4
        $seriesIndex = 0;
1037
        foreach ($subject->getSeries() as $series) {
1038
            // c:ser
1039 4
            $objWriter->startElement('c:ser');
1040 4
1041 4
            // c:idx
1042
            $objWriter->startElement('c:idx');
1043
            $objWriter->writeAttribute('val', $seriesIndex);
1044 4
            $objWriter->endElement();
1045 4
1046 4
            // c:order
1047
            $objWriter->startElement('c:order');
1048
            $objWriter->writeAttribute('val', $seriesIndex);
1049 4
            $objWriter->endElement();
1050 4
1051 4
            // c:tx
1052 4
            $objWriter->startElement('c:tx');
1053
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1054
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1055 4
            $objWriter->endElement();
1056 4
1057
            // Fills for points?
1058 1
            $dataPointFills = $series->getDataPointFills();
1059
            foreach ($dataPointFills as $key => $value) {
1060
                // c:dPt
1061 1
                $objWriter->startElement('c:dPt');
1062
1063 1
                // c:idx
1064
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
1065 1
1066
                if ($value->getFillType() != Fill::FILL_NONE) {
1067 1
                    // c:spPr
1068
                    $objWriter->startElement('c:spPr');
1069 1
                    // Write fill
1070
                    $this->writeFill($objWriter, $value);
1071
                    // ## c:spPr
1072
                    $objWriter->endElement();
1073 1
                }
1074
1075
                // ## c:dPt
1076
                $objWriter->endElement();
1077 4
            }
1078
1079
            // c:dLbls
1080 4
            $objWriter->startElement('c:dLbls');
1081
1082
            // c:txPr
1083 4
            $objWriter->startElement('c:txPr');
1084
1085
            // a:bodyPr
1086 4
            $objWriter->writeElement('a:bodyPr', null);
1087
1088
            // a:lstStyle
1089 4
            $objWriter->writeElement('a:lstStyle', null);
1090
1091
            // a:p
1092 4
            $objWriter->startElement('a:p');
1093
1094
            // a:pPr
1095 4
            $objWriter->startElement('a:pPr');
1096
1097 4
            // a:defRPr
1098 4
            $objWriter->startElement('a:defRPr');
1099 4
1100 4
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1101 4
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1102 4
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1103 4
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1104
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1105
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1106 4
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1107
1108 4
            // Font - a:solidFill
1109
            $objWriter->startElement('a:solidFill');
1110 4
1111
            $this->writeColor($objWriter, $series->getFont()->getColor());
1112
1113 4
            $objWriter->endElement();
1114 4
1115 4
            // Font - a:latin
1116
            $objWriter->startElement('a:latin');
1117 4
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1118
            $objWriter->endElement();
1119 4
1120
            $objWriter->endElement();
1121
1122 4
            $objWriter->endElement();
1123 4
1124 4
            // a:endParaRPr
1125 4
            $objWriter->startElement('a:endParaRPr');
1126
            $objWriter->writeAttribute('lang', 'en-US');
1127 4
            $objWriter->writeAttribute('dirty', '0');
1128
            $objWriter->endElement();
1129 4
1130
            $objWriter->endElement();
1131
1132 4
            $objWriter->endElement();
1133
1134
            // c:showVal
1135 4
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1136
1137
            // c:showCatName
1138 4
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1139
1140
            // c:showSerName
1141 4
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1142
1143
            // c:showPercent
1144 4
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1145
1146
            // c:showLeaderLines
1147 4
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1148
1149 4
            // c:separator
1150
            $objWriter->writeElementIf($series->hasShowSeparator(), 'c:separator', 'val', $series->getSeparator());
1151
1152 4
            $objWriter->endElement();
1153
1154
            // c:spPr
1155
            if ($series->getFill()->getFillType() != Fill::FILL_NONE) {
1156
                // c:spPr
1157
                $objWriter->startElement('c:spPr');
1158
                // Write fill
1159
                $this->writeFill($objWriter, $series->getFill());
1160
                // ## c:spPr
1161
                $objWriter->endElement();
1162 4
            }
1163
1164
            // Write X axis data
1165 4
            $axisXData = array_keys($series->getValues());
1166 4
1167 4
            // c:cat
1168
            $objWriter->startElement('c:cat');
1169
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1170 4
            $objWriter->endElement();
1171
1172
            // Write Y axis data
1173 4
            $axisYData = array_values($series->getValues());
1174 4
1175 4
            // c:val
1176 4
            $objWriter->startElement('c:val');
1177
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1178 4
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1179
            $objWriter->endElement();
1180 4
1181
            $objWriter->endElement();
1182
1183
            ++$seriesIndex;
1184 4
        }
1185 4
1186 4
        // c:gapWidth
1187
        $objWriter->startElement('c:gapWidth');
1188
        $objWriter->writeAttribute('val', $subject->getGapWidthPercent());
1189 4
        $objWriter->endElement();
1190 4
1191 4
        // c:shape
1192
        $objWriter->startElement('c:shape');
1193
        $objWriter->writeAttribute('val', 'box');
1194 4
        $objWriter->endElement();
1195 4
1196 4
        // c:axId
1197
        $objWriter->startElement('c:axId');
1198
        $objWriter->writeAttribute('val', '52743552');
1199 4
        $objWriter->endElement();
1200 4
1201 4
        // c:axId
1202
        $objWriter->startElement('c:axId');
1203
        $objWriter->writeAttribute('val', '52749440');
1204 4
        $objWriter->endElement();
1205 4
1206 4
        // c:axId
1207
        $objWriter->startElement('c:axId');
1208 4
        $objWriter->writeAttribute('val', '0');
1209 4
        $objWriter->endElement();
1210
1211
        $objWriter->endElement();
1212
    }
1213
1214
    /**
1215
     * Write Type Pie
1216
     *
1217
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
1218
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Doughnut $subject
1219 1
     * @param  boolean $includeSheet
1220
     * @throws \Exception
1221
     */
1222 1
    protected function writeTypeDoughnut(XMLWriter $objWriter, Doughnut $subject, $includeSheet = false)
1223
    {
1224
        // c:pieChart
1225 1
        $objWriter->startElement('c:doughnutChart');
1226 1
1227 1
        // c:varyColors
1228
        $objWriter->startElement('c:varyColors');
1229
        $objWriter->writeAttribute('val', '1');
1230 1
        $objWriter->endElement();
1231 1
1232
        // Write series
1233 1
        $seriesIndex = 0;
1234
        foreach ($subject->getSeries() as $series) {
1235
            // c:ser
1236 1
            $objWriter->startElement('c:ser');
1237 1
1238 1
            // c:idx
1239
            $objWriter->startElement('c:idx');
1240
            $objWriter->writeAttribute('val', $seriesIndex);
1241 1
            $objWriter->endElement();
1242 1
1243 1
            // c:order
1244
            $objWriter->startElement('c:order');
1245
            $objWriter->writeAttribute('val', $seriesIndex);
1246 1
            $objWriter->endElement();
1247 1
1248 1
            // c:tx
1249 1
            $objWriter->startElement('c:tx');
1250
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1251
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1252 1
            $objWriter->endElement();
1253 1
1254
            // Fills for points?
1255 1
            $dataPointFills = $series->getDataPointFills();
1256 1
            foreach ($dataPointFills as $key => $value) {
1257
                // c:dPt
1258 1
                $objWriter->startElement('c:dPt');
1259 1
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
1260
                // c:dPt/c:spPr
1261 1
                $objWriter->startElement('c:spPr');
1262
                $this->writeFill($objWriter, $value);
1263 1
                // c:dPt/##c:spPr
1264
                $objWriter->endElement();
1265
                // ##c:dPt
1266
                $objWriter->endElement();
1267 1
            }
1268
1269
            // Write X axis data
1270 1
            $axisXData = array_keys($series->getValues());
1271 1
1272 1
            // c:cat
1273
            $objWriter->startElement('c:cat');
1274
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1275 1
            $objWriter->endElement();
1276
1277
            // Write Y axis data
1278 1
            $axisYData = array_values($series->getValues());
1279 1
1280 1
            // c:val
1281 1
            $objWriter->startElement('c:val');
1282
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1283 1
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1284
            $objWriter->endElement();
1285 1
1286
            $objWriter->endElement();
1287
1288
            ++$seriesIndex;
1289 1
        }
1290
1291 1
        // c:dLbls
1292 1
        $objWriter->startElement('c:dLbls');
1293 1
1294 1
        $this->writeElementWithValAttribute($objWriter, 'c:showLegendKey', $series->hasShowLegendKey() ? '1' : '0');
0 ignored issues
show
Bug introduced by
The variable $series seems to be defined by a foreach iteration on line 1234. Are you sure the iterator is never empty, otherwise this variable is not defined?

It seems like you are relying on a variable being defined by an iteration:

foreach ($a as $b) {
}

// $b is defined here only if $a has elements, for example if $a is array()
// then $b would not be defined here. To avoid that, we recommend to set a
// default value for $b.


// Better
$b = 0; // or whatever default makes sense in your context
foreach ($a as $b) {
}

// $b is now guaranteed to be defined here.
Loading history...
1295 1
        $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1296 1
        $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1297 1
        $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1298
        $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1299 1
        $this->writeElementWithValAttribute($objWriter, 'c:showBubbleSize', '0');
1300
        $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1301
1302
        if ($series->hasDlblNumFormat()) {
1303
            //c:numFmt
1304
            $objWriter->startElement('c:numFmt');
1305
            $objWriter->writeAttribute('formatCode', $series->getDlblNumFormat());
1306
            $objWriter->writeAttribute('sourceLinked', '0');
1307
            $objWriter->endElement();
1308 1
        }
1309 1
1310 1
        // c:dLbls\c:txPr
1311
        $objWriter->startElement('c:txPr');
1312
        $objWriter->writeElement('a:bodyPr', null);
1313 1
        $objWriter->writeElement('a:lstStyle', null);
1314
1315
        // c:dLbls\c:txPr\a:p
1316 1
        $objWriter->startElement('a:p');
1317
1318
        // c:dLbls\c:txPr\a:p\a:pPr
1319 1
        $objWriter->startElement('a:pPr');
1320 1
1321 1
        // c:dLbls\c:txPr\a:p\a:pPr\a:defRPr
1322 1
        $objWriter->startElement('a:defRPr');
1323 1
        $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1324 1
        $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1325 1
        $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1326 1
        $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1327
        $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1328
        $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1329 1
        $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1330 1
1331 1
        // c:dLbls\c:txPr\a:p\a:pPr\a:defRPr\a:solidFill
1332
        $objWriter->startElement('a:solidFill');
1333
        $this->writeColor($objWriter, $series->getFont()->getColor());
1334 1
        $objWriter->endElement();
1335 1
1336 1
        // c:dLbls\c:txPr\a:p\a:pPr\a:defRPr\a:latin
1337
        $objWriter->startElement('a:latin');
1338
        $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1339 1
        $objWriter->endElement();
1340
1341 1
        // c:dLbls\c:txPr\a:p\a:pPr\a:defRPr\
1342
        $objWriter->endElement();
1343
        // c:dLbls\c:txPr\a:p\a:pPr\
1344 1
        $objWriter->endElement();
1345 1
1346 1
        // c:dLbls\c:txPr\a:p\a:endParaRPr
1347 1
        $objWriter->startElement('a:endParaRPr');
1348
        $objWriter->writeAttribute('lang', 'en-US');
1349
        $objWriter->writeAttribute('dirty', '0');
1350 1
        $objWriter->endElement();
1351
1352 1
        // c:dLbls\c:txPr\a:p\
1353
        $objWriter->endElement();
1354 1
        // c:dLbls\c:txPr\
1355 1
        $objWriter->endElement();
1356
1357 1
        $separator = $series->getSeparator();
1358
        if (!empty($separator) && $separator != PHP_EOL) {
1359
            // c:dLbls\c:separator
1360
            $objWriter->writeElement('c:separator', $separator);
1361 1
        }
1362
1363 1
        // c:dLbls\
1364 1
        $objWriter->endElement();
1365
1366 1
        $this->writeElementWithValAttribute($objWriter, 'c:firstSliceAng', '0');
1367 1
        $this->writeElementWithValAttribute($objWriter, 'c:holeSize', $subject->getHoleSize());
1368
1369
        $objWriter->endElement();
1370
    }
1371
1372
    /**
1373
     * Write Type Pie
1374
     *
1375
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
1376
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Pie $subject
1377 2
     * @param  boolean $includeSheet
1378
     * @throws \Exception
1379
     */
1380 2
    protected function writeTypePie(XMLWriter $objWriter, Pie $subject, $includeSheet = false)
1381
    {
1382
        // c:pieChart
1383 2
        $objWriter->startElement('c:pieChart');
1384 2
1385 2
        // c:varyColors
1386
        $objWriter->startElement('c:varyColors');
1387
        $objWriter->writeAttribute('val', '1');
1388 2
        $objWriter->endElement();
1389 2
1390
        // Write series
1391 2
        $seriesIndex = 0;
1392
        foreach ($subject->getSeries() as $series) {
1393
            // c:ser
1394 2
            $objWriter->startElement('c:ser');
1395 2
1396 2
            // c:idx
1397
            $objWriter->startElement('c:idx');
1398
            $objWriter->writeAttribute('val', $seriesIndex);
1399 2
            $objWriter->endElement();
1400 2
1401 2
            // c:order
1402
            $objWriter->startElement('c:order');
1403
            $objWriter->writeAttribute('val', $seriesIndex);
1404 2
            $objWriter->endElement();
1405 2
1406 2
            // c:tx
1407 2
            $objWriter->startElement('c:tx');
1408
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1409
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1410 2
            $objWriter->endElement();
1411 2
1412
            // Fills for points?
1413 1
            $dataPointFills = $series->getDataPointFills();
1414 1
            foreach ($dataPointFills as $key => $value) {
1415
                // c:dPt
1416 1
                $objWriter->startElement('c:dPt');
1417 1
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
1418
                // c:dPt/c:spPr
1419 1
                $objWriter->startElement('c:spPr');
1420
                $this->writeFill($objWriter, $value);
1421 1
                // c:dPt/##c:spPr
1422
                $objWriter->endElement();
1423
                // ##c:dPt
1424
                $objWriter->endElement();
1425 2
            }
1426
1427 2
            // c:dLbls
1428
            $objWriter->startElement('c:dLbls');
1429
1430
            if ($series->hasDlblNumFormat()) {
1431
                //c:numFmt
1432
                $objWriter->startElement('c:numFmt');
1433
                $objWriter->writeAttribute('formatCode', $series->getDlblNumFormat());
1434
                $objWriter->writeAttribute('sourceLinked', '0');
1435
                $objWriter->endElement();
1436 2
            }
1437
1438
            // c:txPr
1439 2
            $objWriter->startElement('c:txPr');
1440
1441
            // a:bodyPr
1442 2
            $objWriter->writeElement('a:bodyPr', null);
1443
1444
            // a:lstStyle
1445 2
            $objWriter->writeElement('a:lstStyle', null);
1446
1447
            // a:p
1448 2
            $objWriter->startElement('a:p');
1449
1450
            // a:pPr
1451 2
            $objWriter->startElement('a:pPr');
1452
1453 2
            // a:defRPr
1454 2
            $objWriter->startElement('a:defRPr');
1455 2
1456 2
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1457 2
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1458 2
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1459 2
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1460
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1461
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1462 2
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1463
1464 2
            // Font - a:solidFill
1465
            $objWriter->startElement('a:solidFill');
1466 2
1467
            $this->writeColor($objWriter, $series->getFont()->getColor());
1468
1469 2
            $objWriter->endElement();
1470 2
1471 2
            // Font - a:latin
1472
            $objWriter->startElement('a:latin');
1473 2
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1474
            $objWriter->endElement();
1475 2
1476
            $objWriter->endElement();
1477
1478 2
            $objWriter->endElement();
1479 2
1480 2
            // a:endParaRPr
1481 2
            $objWriter->startElement('a:endParaRPr');
1482
            $objWriter->writeAttribute('lang', 'en-US');
1483 2
            $objWriter->writeAttribute('dirty', '0');
1484
            $objWriter->endElement();
1485 2
1486
            $objWriter->endElement();
1487
1488 2
            $objWriter->endElement();
1489
1490
            // c:dLblPos
1491 2
            $this->writeElementWithValAttribute($objWriter, 'c:dLblPos', $series->getLabelPosition());
1492
1493
            // c:showLegendKey
1494 2
            $this->writeElementWithValAttribute($objWriter, 'c:showLegendKey', $series->hasShowLegendKey() ? '1' : '0');
1495
1496
            // c:showVal
1497 2
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1498
1499
            // c:showCatName
1500 2
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1501
1502
            // c:showSerName
1503 2
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1504
1505
            // c:showPercent
1506 2
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1507
1508
            // c:showLeaderLines
1509 2
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1510
1511 2
            // c:separator
1512
            $objWriter->writeElementIf($series->hasShowSeparator(), 'c:separator', 'val', $series->getSeparator());
1513
1514 2
            $objWriter->endElement();
1515
1516
            // Write X axis data
1517 2
            $axisXData = array_keys($series->getValues());
1518 2
1519 2
            // c:cat
1520
            $objWriter->startElement('c:cat');
1521
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1522 2
            $objWriter->endElement();
1523
1524
            // Write Y axis data
1525 2
            $axisYData = array_values($series->getValues());
1526 2
1527 2
            // c:val
1528 2
            $objWriter->startElement('c:val');
1529
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1530 2
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1531
            $objWriter->endElement();
1532 2
1533
            $objWriter->endElement();
1534
1535 2
            ++$seriesIndex;
1536 2
        }
1537
1538
        $objWriter->endElement();
1539
    }
1540
1541
    /**
1542
     * Write Type Pie3D
1543
     *
1544
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
1545
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Pie3D $subject
1546 4
     * @param  boolean $includeSheet
1547
     * @throws \Exception
1548
     */
1549 4
    protected function writeTypePie3D(XMLWriter $objWriter, Pie3D $subject, $includeSheet = false)
1550
    {
1551
        // c:pie3DChart
1552 4
        $objWriter->startElement('c:pie3DChart');
1553 4
1554 4
        // c:varyColors
1555
        $objWriter->startElement('c:varyColors');
1556
        $objWriter->writeAttribute('val', '1');
1557 4
        $objWriter->endElement();
1558 4
1559
        // Write series
1560 4
        $seriesIndex = 0;
1561
        foreach ($subject->getSeries() as $series) {
1562
            // c:ser
1563 4
            $objWriter->startElement('c:ser');
1564 4
1565 4
            // c:idx
1566
            $objWriter->startElement('c:idx');
1567
            $objWriter->writeAttribute('val', $seriesIndex);
1568 4
            $objWriter->endElement();
1569 4
1570 4
            // c:order
1571
            $objWriter->startElement('c:order');
1572
            $objWriter->writeAttribute('val', $seriesIndex);
1573 4
            $objWriter->endElement();
1574 4
1575 4
            // c:tx
1576 4
            $objWriter->startElement('c:tx');
1577
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1578
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1579 4
            $objWriter->endElement();
1580 4
1581 4
            // c:explosion
1582
            $objWriter->startElement('c:explosion');
1583
            $objWriter->writeAttribute('val', $subject->getExplosion());
1584 4
            $objWriter->endElement();
1585 4
1586
            // Fills for points?
1587 1
            $dataPointFills = $series->getDataPointFills();
1588 1
            foreach ($dataPointFills as $key => $value) {
1589
                // c:dPt
1590 1
                $objWriter->startElement('c:dPt');
1591 1
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
1592
                // c:dPt/c:spPr
1593 1
                $objWriter->startElement('c:spPr');
1594
                $this->writeFill($objWriter, $value);
1595 1
                // c:dPt/##c:spPr
1596
                $objWriter->endElement();
1597
                // ##c:dPt
1598
                $objWriter->endElement();
1599 4
            }
1600
1601
            // c:dLbls
1602 4
            $objWriter->startElement('c:dLbls');
1603
1604
            // c:txPr
1605 4
            $objWriter->startElement('c:txPr');
1606
1607
            // a:bodyPr
1608 4
            $objWriter->writeElement('a:bodyPr', null);
1609
1610
            // a:lstStyle
1611 4
            $objWriter->writeElement('a:lstStyle', null);
1612
1613
            // a:p
1614 4
            $objWriter->startElement('a:p');
1615
1616
            // a:pPr
1617 4
            $objWriter->startElement('a:pPr');
1618
1619 4
            // a:defRPr
1620 4
            $objWriter->startElement('a:defRPr');
1621 4
1622 4
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1623 4
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1624 4
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1625 4
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1626
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1627
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1628 4
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1629
1630 4
            // Font - a:solidFill
1631
            $objWriter->startElement('a:solidFill');
1632 4
1633
            $this->writeColor($objWriter, $series->getFont()->getColor());
1634
1635 4
            $objWriter->endElement();
1636 4
1637 4
            // Font - a:latin
1638
            $objWriter->startElement('a:latin');
1639 4
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1640
            $objWriter->endElement();
1641 4
1642
            $objWriter->endElement();
1643
1644 4
            $objWriter->endElement();
1645 4
1646 4
            // a:endParaRPr
1647 4
            $objWriter->startElement('a:endParaRPr');
1648
            $objWriter->writeAttribute('lang', 'en-US');
1649 4
            $objWriter->writeAttribute('dirty', '0');
1650
            $objWriter->endElement();
1651 4
1652
            $objWriter->endElement();
1653
1654 4
            $objWriter->endElement();
1655
1656
            // c:dLblPos
1657 4
            $this->writeElementWithValAttribute($objWriter, 'c:dLblPos', $series->getLabelPosition());
1658
1659
            // c:showVal
1660 4
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1661
1662
            // c:showCatName
1663 4
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1664
1665
            // c:showSerName
1666 4
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1667
1668
            // c:showPercent
1669 4
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1670
1671
            // c:showLeaderLines
1672 4
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1673
1674 4
            // c:separator
1675
            $objWriter->writeElementIf($series->hasShowSeparator(), 'c:separator', 'val', $series->getSeparator());
1676
1677 4
            $objWriter->endElement();
1678
1679
            // Write X axis data
1680 4
            $axisXData = array_keys($series->getValues());
1681 4
1682 4
            // c:cat
1683
            $objWriter->startElement('c:cat');
1684
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1685 4
            $objWriter->endElement();
1686
1687
            // Write Y axis data
1688 4
            $axisYData = array_values($series->getValues());
1689 4
1690 4
            // c:val
1691 4
            $objWriter->startElement('c:val');
1692
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1693 4
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1694
            $objWriter->endElement();
1695 4
1696
            $objWriter->endElement();
1697
1698 4
            ++$seriesIndex;
1699 4
        }
1700
1701
        $objWriter->endElement();
1702
    }
1703
1704
    /**
1705
     * Write Type Line
1706
     *
1707
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
1708
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Line $subject
1709 15
     * @param  boolean $includeSheet
1710
     * @throws \Exception
1711
     */
1712 15
    protected function writeTypeLine(XMLWriter $objWriter, Line $subject, $includeSheet = false)
1713
    {
1714
        // c:lineChart
1715 15
        $objWriter->startElement('c:lineChart');
1716 15
1717 15
        // c:grouping
1718
        $objWriter->startElement('c:grouping');
1719
        $objWriter->writeAttribute('val', 'standard');
1720 15
        $objWriter->endElement();
1721 15
1722
        // Write series
1723 11
        $seriesIndex = 0;
1724
        foreach ($subject->getSeries() as $series) {
1725
            // c:ser
1726 11
            $objWriter->startElement('c:ser');
1727 11
1728 11
            // c:idx
1729
            $objWriter->startElement('c:idx');
1730
            $objWriter->writeAttribute('val', $seriesIndex);
1731 11
            $objWriter->endElement();
1732 11
1733 11
            // c:order
1734
            $objWriter->startElement('c:order');
1735
            $objWriter->writeAttribute('val', $seriesIndex);
1736 11
            $objWriter->endElement();
1737 11
1738 11
            // c:tx
1739 11
            $objWriter->startElement('c:tx');
1740
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1741
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1742 11
            $objWriter->endElement();
1743
1744 11
            // c:spPr
1745
            $objWriter->startElement('c:spPr');
1746 11
            // Write fill
1747
            $this->writeFill($objWriter, $series->getFill());
1748 11
            // Write outline
1749
            $this->writeOutline($objWriter, $series->getOutline());
1750
            // ## c:spPr
1751 11
            $objWriter->endElement();
1752
1753
            // Marker
1754 11
            $this->writeSeriesMarker($objWriter, $series->getMarker());
1755
1756
            // c:dLbls
1757 11
            $objWriter->startElement('c:dLbls');
1758
1759
            // c:txPr
1760 11
            $objWriter->startElement('c:txPr');
1761
1762
            // a:bodyPr
1763 11
            $objWriter->writeElement('a:bodyPr', null);
1764
1765
            // a:lstStyle
1766 11
            $objWriter->writeElement('a:lstStyle', null);
1767
1768
            // a:p
1769 11
            $objWriter->startElement('a:p');
1770
1771
            // a:pPr
1772 11
            $objWriter->startElement('a:pPr');
1773
1774 11
            // a:defRPr
1775 11
            $objWriter->startElement('a:defRPr');
1776 11
1777 11
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1778 11
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1779 11
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1780 11
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1781
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1782
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1783 11
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1784
1785 11
            // Font - a:solidFill
1786
            $objWriter->startElement('a:solidFill');
1787 11
1788
            $this->writeColor($objWriter, $series->getFont()->getColor());
1789
1790 11
            $objWriter->endElement();
1791 11
1792 11
            // Font - a:latin
1793
            $objWriter->startElement('a:latin');
1794 11
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1795
            $objWriter->endElement();
1796 11
1797
            $objWriter->endElement();
1798
1799 11
            $objWriter->endElement();
1800 11
1801 11
            // a:endParaRPr
1802 11
            $objWriter->startElement('a:endParaRPr');
1803
            $objWriter->writeAttribute('lang', 'en-US');
1804 11
            $objWriter->writeAttribute('dirty', '0');
1805
            $objWriter->endElement();
1806 11
1807
            $objWriter->endElement();
1808
1809 11
            $objWriter->endElement();
1810
1811
            // c:showVal
1812 11
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1813
1814
            // c:showCatName
1815 11
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1816
1817
            // c:showSerName
1818 11
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1819
1820
            // c:showPercent
1821 11
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1822
1823
            // c:showLeaderLines
1824 11
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1825
1826
            // c:separator
1827 11
            $objWriter->writeElementIf($series->hasShowSeparator(), 'c:separator', 'val', $series->getSeparator());
1828
1829
            // > c:dLbls
1830 11
            $objWriter->endElement();
1831
1832
            // Write X axis data
1833 11
            $axisXData = array_keys($series->getValues());
1834 11
1835 11
            // c:cat
1836
            $objWriter->startElement('c:cat');
1837
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1838 11
            $objWriter->endElement();
1839
1840
            // Write Y axis data
1841 11
            $axisYData = array_values($series->getValues());
1842 11
1843 11
            // c:val
1844 11
            $objWriter->startElement('c:val');
1845
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1846 11
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1847
            $objWriter->endElement();
1848 11
1849
            $objWriter->endElement();
1850
1851
            ++$seriesIndex;
1852 15
        }
1853 15
1854 15
        // c:marker
1855
        $objWriter->startElement('c:marker');
1856
        $objWriter->writeAttribute('val', '1');
1857 15
        $objWriter->endElement();
1858 15
1859 15
        // c:smooth
1860
        $objWriter->startElement('c:smooth');
1861
        $objWriter->writeAttribute('val', '0');
1862 15
        $objWriter->endElement();
1863 15
1864 15
        // c:axId
1865
        $objWriter->startElement('c:axId');
1866
        $objWriter->writeAttribute('val', '52743552');
1867 15
        $objWriter->endElement();
1868 15
1869 15
        // c:axId
1870
        $objWriter->startElement('c:axId');
1871 15
        $objWriter->writeAttribute('val', '52749440');
1872 15
        $objWriter->endElement();
1873
1874
        $objWriter->endElement();
1875
    }
1876
1877
    /**
1878
     * Write Type Radar
1879
     *
1880
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
1881
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Radar $subject
1882 5
     * @param  boolean $includeSheet
1883
     * @throws \Exception
1884
     */
1885 5
    protected function writeTypeRadar(XMLWriter $objWriter, Radar $subject, $includeSheet = false)
1886
    {
1887
        // c:scatterChart
1888 5
        $objWriter->startElement('c:radarChart');
1889 5
1890 5
        // c:radarStyle
1891
        $objWriter->startElement('c:radarStyle');
1892
        $objWriter->writeAttribute('val', 'marker');
1893 5
        $objWriter->endElement();
1894 5
1895 5
        // c:varyColors
1896
        $objWriter->startElement('c:varyColors');
1897
        $objWriter->writeAttribute('val', '0');
1898 5
        $objWriter->endElement();
1899 5
1900
        // Write series
1901 5
        $seriesIndex = 0;
1902
        foreach ($subject->getSeries() as $series) {
1903
            // c:ser
1904 5
            $objWriter->startElement('c:ser');
1905 5
1906 5
            // c:idx
1907
            $objWriter->startElement('c:idx');
1908
            $objWriter->writeAttribute('val', $seriesIndex);
1909 5
            $objWriter->endElement();
1910 5
1911 5
            // c:order
1912
            $objWriter->startElement('c:order');
1913
            $objWriter->writeAttribute('val', $seriesIndex);
1914 5
            $objWriter->endElement();
1915 5
1916 5
            // c:tx
1917 5
            $objWriter->startElement('c:tx');
1918
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1919
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1920 5
            $objWriter->endElement();
1921
1922
            // Marker
1923 5
            $this->writeSeriesMarker($objWriter, $series->getMarker());
1924
1925
            // c:dLbls
1926 5
            $objWriter->startElement('c:dLbls');
1927
1928
            // c:txPr
1929 5
            $objWriter->startElement('c:txPr');
1930
1931
            // a:bodyPr
1932 5
            $objWriter->writeElement('a:bodyPr', null);
1933
1934
            // a:lstStyle
1935 5
            $objWriter->writeElement('a:lstStyle', null);
1936
1937
            // a:p
1938 5
            $objWriter->startElement('a:p');
1939
1940
            // a:pPr
1941 5
            $objWriter->startElement('a:pPr');
1942
1943 5
            // a:defRPr
1944 5
            $objWriter->startElement('a:defRPr');
1945 5
1946 5
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1947 5
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1948 5
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1949 5
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1950
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1951
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1952 5
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1953
1954 5
            // Font - a:solidFill
1955
            $objWriter->startElement('a:solidFill');
1956 5
1957
            $this->writeColor($objWriter, $series->getFont()->getColor());
1958
1959 5
            $objWriter->endElement();
1960 5
1961 5
            // Font - a:latin
1962
            $objWriter->startElement('a:latin');
1963 5
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1964
            $objWriter->endElement();
1965 5
1966
            $objWriter->endElement();
1967
1968 5
            $objWriter->endElement();
1969 5
1970 5
            // a:endParaRPr
1971 5
            $objWriter->startElement('a:endParaRPr');
1972
            $objWriter->writeAttribute('lang', 'en-US');
1973 5
            $objWriter->writeAttribute('dirty', '0');
1974
            $objWriter->endElement();
1975 5
1976
            $objWriter->endElement();
1977
1978 5
            $objWriter->endElement();
1979
1980
            // c:showLegendKey
1981 5
            $this->writeElementWithValAttribute($objWriter, 'c:showLegendKey', $series->hasShowLegendKey() ? '1' : '0');
1982
1983
            // c:showVal
1984 5
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1985
1986
            // c:showCatName
1987 5
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1988
1989
            // c:showSerName
1990 5
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1991
1992
            // c:showPercent
1993 5
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1994
1995
            // c:showLeaderLines
1996 5
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1997
1998 5
            $objWriter->endElement();
1999
2000
            // c:spPr
2001 5
            $objWriter->startElement('c:spPr');
2002
            // Write fill
2003 5
            $this->writeFill($objWriter, $series->getFill());
2004
            // Write outline
2005 5
            $this->writeOutline($objWriter, $series->getOutline());
2006
            // ## c:spPr
2007 5
            $objWriter->endElement();
2008
2009
            // Write X axis data
2010 5
            $axisXData = array_keys($series->getValues());
2011
2012
            // c:cat
2013 5
            $objWriter->startElement('c:cat');
2014 5
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
2015 5
            $objWriter->endElement();
2016
2017
            // Write Y axis data
2018 5
            $axisYData = array_values($series->getValues());
2019
2020
            // c:val
2021 5
            $objWriter->startElement('c:val');
2022 5
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
2023 5
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
2024 5
            $objWriter->endElement();
2025
2026
            // c:smooth
2027 5
            $objWriter->startElement('c:smooth');
2028 5
            $objWriter->writeAttribute('val', '0');
2029 5
            $objWriter->endElement();
2030
2031 5
            $objWriter->endElement();
2032
2033 5
            ++$seriesIndex;
2034
        }
2035
2036
        // c:axId
2037 5
        $objWriter->startElement('c:axId');
2038 5
        $objWriter->writeAttribute('val', '52743552');
2039 5
        $objWriter->endElement();
2040
2041
        // c:axId
2042 5
        $objWriter->startElement('c:axId');
2043 5
        $objWriter->writeAttribute('val', '52749440');
2044 5
        $objWriter->endElement();
2045
2046 5
        $objWriter->endElement();
2047 5
    }
2048
2049
    /**
2050
     * Write Type Scatter
2051
     *
2052
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
2053
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Scatter $subject
2054
     * @param  boolean $includeSheet
2055
     * @throws \Exception
2056
     */
2057
    protected function writeTypeScatter(XMLWriter $objWriter, Scatter $subject, $includeSheet = false)
2058
    {
2059
        // c:scatterChart
2060
        $objWriter->startElement('c:scatterChart');
2061
2062
        // c:scatterStyle
2063
        $objWriter->startElement('c:scatterStyle');
2064
        $objWriter->writeAttribute('val', 'lineMarker');
2065
        $objWriter->endElement();
2066
2067
        // c:varyColors
2068
        $objWriter->startElement('c:varyColors');
2069
        $objWriter->writeAttribute('val', '0');
2070
        $objWriter->endElement();
2071
2072
        // Write series
2073
        $seriesIndex = 0;
2074
        foreach ($subject->getSeries() as $series) {
2075
            // c:ser
2076
            $objWriter->startElement('c:ser');
2077
2078
            // c:idx
2079
            $objWriter->startElement('c:idx');
2080
            $objWriter->writeAttribute('val', $seriesIndex);
2081
            $objWriter->endElement();
2082
2083 16
            // c:order
2084
            $objWriter->startElement('c:order');
2085
            $objWriter->writeAttribute('val', $seriesIndex);
2086 16
            $objWriter->endElement();
2087
2088 16
            // c:tx
2089 16
            $objWriter->startElement('c:tx');
2090 16
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
2091
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
2092
            $objWriter->endElement();
2093 16
2094 2
            // Marker
2095 2
            $this->writeSeriesMarker($objWriter, $series->getMarker());
2096 2
2097
            // c:dLbls
2098 2
            $objWriter->startElement('c:dLbls');
2099 2
2100
            // c:txPr
2101
            $objWriter->startElement('c:txPr');
2102
2103
            // a:bodyPr
2104
            $objWriter->writeElement('a:bodyPr', null);
2105
2106
            // a:lstStyle
2107 2
            $objWriter->writeElement('a:lstStyle', null);
2108 2
2109 2
            // a:p
2110
            $objWriter->startElement('a:p');
2111 16
2112 16
            // a:pPr
2113
            $objWriter->startElement('a:pPr');
2114
2115
            // a:defRPr
2116
            $objWriter->startElement('a:defRPr');
2117
2118
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
2119
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
2120
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
2121 28
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
2122
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
2123 28
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
2124
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
2125
2126
            // Font - a:solidFill
2127 28
            $objWriter->startElement('a:solidFill');
2128 28
2129 28
            $this->writeColor($objWriter, $series->getFont()->getColor());
2130 28
2131 28
            $objWriter->endElement();
2132
2133 28
            // Font - a:latin
2134 28
            $objWriter->startElement('a:latin');
2135 28
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
2136 28
            $objWriter->endElement();
2137
2138
            $objWriter->endElement();
2139
2140 28
            $objWriter->endElement();
2141
2142
            // a:endParaRPr
2143 28
            $objWriter->startElement('a:endParaRPr');
2144 28
            $objWriter->writeAttribute('lang', 'en-US');
2145 28
            $objWriter->writeAttribute('dirty', '0');
2146
            $objWriter->endElement();
2147
2148 28
            $objWriter->endElement();
2149
2150
            $objWriter->endElement();
2151 28
2152 28
            // c:showLegendKey
2153 28
            $this->writeElementWithValAttribute($objWriter, 'c:showLegendKey', $series->hasShowLegendKey() ? '1' : '0');
2154
2155 28
            // c:showVal
2156 1
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
2157 1
2158 1
            // c:showCatName
2159
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
2160
2161 28
            // c:showSerName
2162 1
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
2163 1
2164 1
            // c:showPercent
2165
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
2166
2167
            // c:showLeaderLines
2168 28
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
2169
2170
            // c:separator
2171 28
            $objWriter->writeElementIf($series->hasShowSeparator(), 'c:separator', 'val', $series->getSeparator());
2172 28
2173 28
            $objWriter->endElement();
2174
2175
            // c:spPr
2176 28
            $objWriter->startElement('c:spPr');
2177 28
            // Write fill
2178 28
            $this->writeFill($objWriter, $series->getFill());
2179
            // Write outline
2180 28
            $this->writeOutline($objWriter, $series->getOutline());
2181 28
            // ## c:spPr
2182 1
            $objWriter->endElement();
2183
2184 1
            // Write X axis data
2185
            $axisXData = array_keys($series->getValues());
2186 1
2187
            // c:xVal
2188
            $objWriter->startElement('c:xVal');
2189 28
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
2190 28
            $objWriter->endElement();
2191 1
2192
            // Write Y axis data
2193 1
            $axisYData = array_values($series->getValues());
2194
2195 1
            // c:yVal
2196
            $objWriter->startElement('c:yVal');
2197
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
2198 28
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
2199
            $objWriter->endElement();
2200 28
2201
            // c:smooth
2202
            $objWriter->startElement('c:smooth');
2203 28
            $objWriter->writeAttribute('val', '0');
2204
            $objWriter->endElement();
2205
2206 28
            $objWriter->endElement();
2207
2208
            ++$seriesIndex;
2209 28
        }
2210
2211
        // c:axId
2212 28
        $objWriter->startElement('c:axId');
2213
        $objWriter->writeAttribute('val', '52743552');
2214
        $objWriter->endElement();
2215 28
2216
        // c:axId
2217
        $objWriter->startElement('c:axId');
2218 28
        $objWriter->writeAttribute('val', '52749440');
2219
        $objWriter->endElement();
2220
2221 28
        $objWriter->endElement();
2222
    }
2223 28
2224 28
    /**
2225 28
     * Write chart relationships to XML format
2226 28
     *
2227 28
     * @param  \PhpOffice\PhpPresentation\Shape\Chart $pChart
2228 28
     * @return string                    XML Output
2229 28
     * @throws \Exception
2230
     */
2231
    public function writeChartRelationships(Chart $pChart)
2232 28
    {
2233 28
        // Create XML writer
2234 28
        $objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
2235
2236
        // XML header
2237 28
        $objWriter->startDocument('1.0', 'UTF-8', 'yes');
2238 28
2239 28
        // Relationships
2240
        $objWriter->startElement('Relationships');
2241 28
        $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/package/2006/relationships');
2242
2243
        // Write spreadsheet relationship?
2244 28
        if ($pChart->hasIncludedSpreadsheet()) {
2245
            $this->writeRelationship($objWriter, 1, 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/package', '../embeddings/' . $pChart->getIndexedFilename() . '.xlsx');
2246
        }
2247 28
2248
        $objWriter->endElement();
2249
2250 28
        // Return
2251 28
        return $objWriter->getData();
2252 28
    }
2253 28
2254
    /**
2255
     * @param XMLWriter $objWriter
2256 28
     * @param Chart\Marker $oMarker
2257
     */
2258
    protected function writeSeriesMarker(XMLWriter $objWriter, Chart\Marker $oMarker)
2259 28
    {
2260
        // c:marker
2261
        $objWriter->startElement('c:marker');
2262 28
        // c:marker > c:symbol
2263 28
        $objWriter->startElement('c:symbol');
2264 28
        $objWriter->writeAttribute('val', $oMarker->getSymbol());
2265 28
        $objWriter->endElement();
2266
2267
        // Size if different of none
2268 28
        if ($oMarker->getSymbol() != Chart\Marker::SYMBOL_NONE) {
2269
            $markerSize = (int)$oMarker->getSize();
2270
            if ($markerSize < 2) {
2271 28
                $markerSize = 2;
2272
            }
2273
            if ($markerSize > 72) {
2274 28
                $markerSize = 72;
2275
            }
2276
2277 28
            /**
2278
             * c:marker > c:size
2279
             * Size in points
2280
             * @link : https://msdn.microsoft.com/en-us/library/hh658135(v=office.12).aspx
2281 28
             */
2282 28
            $objWriter->startElement('c:size');
2283 28
            $objWriter->writeAttribute('val', $markerSize);
2284 28
            $objWriter->endElement();
2285
        }
2286
        $objWriter->endElement();
2287 28
    }
2288 28
2289 28
    /**
2290
     * @param XMLWriter $objWriter
2291
     * @param Chart\Axis $oAxis
2292 28
     * @param $typeAxis
2293 28
     * @param Chart\Type\AbstractType $typeChart
2294 28
     * @throws \Exception
2295
     */
2296
    protected function writeAxis(XMLWriter $objWriter, Chart\Axis $oAxis, $typeAxis, Chart\Type\AbstractType $typeChart)
2297 28
    {
2298 28
        if ($typeAxis != Chart\Axis::AXIS_X && $typeAxis != Chart\Axis::AXIS_Y) {
2299 28
            return;
2300
        }
2301
2302 28
        if ($typeAxis == Chart\Axis::AXIS_X) {
2303
            $mainElement = 'c:catAx';
2304 28
            $axIdVal = '52743552';
2305
            $axPosVal = 'b';
2306 28
            $crossAxVal = '52749440';
2307
        } else {
2308
            $mainElement = 'c:valAx';
2309 28
            $axIdVal = '52749440';
2310 28
            $axPosVal = 'l';
2311 28
            $crossAxVal = '52743552';
2312
        }
2313
2314 28
        // $mainElement
2315 28
        $objWriter->startElement($mainElement);
2316 28
2317
        // $mainElement > c:axId
2318 28
        $objWriter->startElement('c:axId');
2319
        $objWriter->writeAttribute('val', $axIdVal);
2320 28
        $objWriter->endElement();
2321 28
2322 28
        // $mainElement > c:scaling
2323
        $objWriter->startElement('c:scaling');
2324
2325 28
        // $mainElement > c:scaling > c:orientation
2326 28
        $objWriter->startElement('c:orientation');
2327 28
        $objWriter->writeAttribute('val', 'minMax');
2328
        $objWriter->endElement();
2329
2330 28
        if ($oAxis->getMaxBounds() != null) {
0 ignored issues
show
Bug Best Practice introduced by
It seems like you are loosely comparing $oAxis->getMaxBounds() of type integer|null against null; this is ambiguous if the integer can be zero. Consider using a strict comparison !== instead.
Loading history...
2331
            $objWriter->startElement('c:max');
2332 28
            $objWriter->writeAttribute('val', $oAxis->getMaxBounds());
2333
            $objWriter->endElement();
2334
        }
2335 28
2336 1
        if ($oAxis->getMinBounds() != null) {
0 ignored issues
show
Bug Best Practice introduced by
It seems like you are loosely comparing $oAxis->getMinBounds() of type integer|null against null; this is ambiguous if the integer can be zero. Consider using a strict comparison !== instead.
Loading history...
2337
            $objWriter->startElement('c:min');
2338 27
            $objWriter->writeAttribute('val', $oAxis->getMinBounds());
2339
            $objWriter->endElement();
2340 28
        }
2341
2342
        // $mainElement > ##c:scaling
2343 28
        $objWriter->endElement();
2344 1
2345 1
        // $mainElement > c:delete
2346 1
        $objWriter->startElement('c:delete');
2347
        $objWriter->writeAttribute('val', $oAxis->isVisible() ? '0' : '1');
2348
        $objWriter->endElement();
2349
2350 28
        // $mainElement > c:axPos
2351 1
        $objWriter->startElement('c:axPos');
2352 1
        $objWriter->writeAttribute('val', $axPosVal);
2353 1
        $objWriter->endElement();
2354
2355
        $oMajorGridlines = $oAxis->getMajorGridlines();
2356
        if ($oMajorGridlines instanceof Gridlines) {
2357 28
            $objWriter->startElement('c:majorGridlines');
2358 28
2359
            $this->writeAxisGridlines($objWriter, $oMajorGridlines);
2360
2361
            $objWriter->endElement();
2362
        }
2363
2364
        $oMinorGridlines = $oAxis->getMinorGridlines();
2365 1
        if ($oMinorGridlines instanceof Gridlines) {
2366
            $objWriter->startElement('c:minorGridlines');
2367
2368 1
            $this->writeAxisGridlines($objWriter, $oMinorGridlines);
2369
2370
            $objWriter->endElement();
2371 1
        }
2372
2373
        if ($oAxis->getTitle() != '') {
2374 1
            // c:title
2375 1
            $objWriter->startElement('c:title');
2376
2377
            // c:tx
2378
            $objWriter->startElement('c:tx');
2379
2380
            // c:rich
2381
            $objWriter->startElement('c:rich');
2382
2383
            // a:bodyPr
2384
            $objWriter->writeElement('a:bodyPr', null);
2385
2386
            // a:lstStyle
2387
            $objWriter->writeElement('a:lstStyle', null);
2388
2389
            // a:p
2390
            $objWriter->startElement('a:p');
2391
2392
            // a:pPr
2393
            $objWriter->startElement('a:pPr');
2394
2395
            // a:defRPr
2396
            $objWriter->startElement('a:defRPr');
2397
2398
            $objWriter->writeAttribute('b', ($oAxis->getFont()->isBold() ? 'true' : 'false'));
2399
            $objWriter->writeAttribute('i', ($oAxis->getFont()->isItalic() ? 'true' : 'false'));
2400
            $objWriter->writeAttribute('strike', ($oAxis->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
2401
            $objWriter->writeAttribute('sz', ($oAxis->getFont()->getSize() * 100));
2402
            $objWriter->writeAttribute('u', $oAxis->getFont()->getUnderline());
2403
            $objWriter->writeAttributeIf($oAxis->getFont()->isSuperScript(), 'baseline', '30000');
2404
            $objWriter->writeAttributeIf($oAxis->getFont()->isSubScript(), 'baseline', '-25000');
2405
2406
            // Font - a:solidFill
2407
            $objWriter->startElement('a:solidFill');
2408
            $this->writeColor($objWriter, $oAxis->getFont()->getColor());
2409
            $objWriter->endElement();
2410
2411
            // Font - a:latin
2412
            $objWriter->startElement('a:latin');
2413
            $objWriter->writeAttribute('typeface', $oAxis->getFont()->getName());
2414
            $objWriter->endElement();
2415
2416
            $objWriter->endElement();
2417
2418
            // ## a:pPr
2419
            $objWriter->endElement();
2420
2421
            // a:r
2422
            $objWriter->startElement('a:r');
2423
2424
            // a:rPr
2425
            $objWriter->startElement('a:rPr');
2426
            $objWriter->writeAttribute('lang', 'en-US');
2427
            $objWriter->writeAttribute('dirty', '0');
2428
            $objWriter->endElement();
2429
2430
            // a:t
2431
            $objWriter->writeElement('a:t', $oAxis->getTitle());
2432
2433
            // ## a:r
2434
            $objWriter->endElement();
2435
2436
            // a:endParaRPr
2437
            $objWriter->startElement('a:endParaRPr');
2438
            $objWriter->writeAttribute('lang', 'en-US');
2439
            $objWriter->writeAttribute('dirty', '0');
2440
            $objWriter->endElement();
2441
2442
            // ## a:p
2443
            $objWriter->endElement();
2444
2445
            // ## c:rich
2446
            $objWriter->endElement();
2447
2448
            // ## c:tx
2449
            $objWriter->endElement();
2450
2451
            // ## c:title
2452
            $objWriter->endElement();
2453
        }
2454
2455
        // c:numFmt
2456
        $objWriter->startElement('c:numFmt');
2457
        $objWriter->writeAttribute('formatCode', $oAxis->getFormatCode());
2458
        $objWriter->writeAttribute('sourceLinked', '1');
2459
        $objWriter->endElement();
2460
2461
        // c:majorTickMark
2462
        $objWriter->startElement('c:majorTickMark');
2463
        $objWriter->writeAttribute('val', $oAxis->getMajorTickMark());
2464
        $objWriter->endElement();
2465
2466
        // c:minorTickMark
2467
        $objWriter->startElement('c:minorTickMark');
2468
        $objWriter->writeAttribute('val', $oAxis->getMinorTickMark());
2469
        $objWriter->endElement();
2470
2471
        // c:tickLblPos
2472
        $objWriter->startElement('c:tickLblPos');
2473
        $objWriter->writeAttribute('val', 'nextTo');
2474
        $objWriter->endElement();
2475
2476
        // c:spPr
2477
        $objWriter->startElement('c:spPr');
2478
        // Outline
2479
        $this->writeOutline($objWriter, $oAxis->getOutline());
2480
        // ##c:spPr
2481
        $objWriter->endElement();
2482
2483
        // c:crossAx
2484
        $objWriter->startElement('c:crossAx');
2485
        $objWriter->writeAttribute('val', $crossAxVal);
2486
        $objWriter->endElement();
2487
2488
        // c:crosses
2489
        $objWriter->startElement('c:crosses');
2490
        $objWriter->writeAttribute('val', 'autoZero');
2491
        $objWriter->endElement();
2492
2493
        if ($typeAxis == Chart\Axis::AXIS_X) {
2494
            // c:lblAlgn
2495
            $objWriter->startElement('c:lblAlgn');
2496
            $objWriter->writeAttribute('val', 'ctr');
2497
            $objWriter->endElement();
2498
2499
            // c:lblOffset
2500
            $objWriter->startElement('c:lblOffset');
2501
            $objWriter->writeAttribute('val', '100');
2502
            $objWriter->endElement();
2503
        }
2504
2505
        if ($typeAxis == Chart\Axis::AXIS_Y) {
2506
            // c:crossBetween
2507
            $objWriter->startElement('c:crossBetween');
2508
            // midCat : Position Axis On Tick Marks
2509
            // between : Between Tick Marks
2510
            if ($typeChart instanceof Area) {
2511
                $objWriter->writeAttribute('val', 'midCat');
2512
            } else {
2513
                $objWriter->writeAttribute('val', 'between');
2514
            }
2515
            $objWriter->endElement();
2516
2517
            // c:majorUnit
2518
            if ($oAxis->getMajorUnit() != null) {
2519
                $objWriter->startElement('c:majorUnit');
2520
                $objWriter->writeAttribute('val', $oAxis->getMajorUnit());
2521
                $objWriter->endElement();
2522
            }
2523
2524
            // c:minorUnit
2525
            if ($oAxis->getMinorUnit() != null) {
2526
                $objWriter->startElement('c:minorUnit');
2527
                $objWriter->writeAttribute('val', $oAxis->getMinorUnit());
2528
                $objWriter->endElement();
2529
            }
2530
        }
2531
2532
        $objWriter->endElement();
2533
    }
2534
2535
    /**
2536
     * @param XMLWriter $objWriter
2537
     * @param Gridlines $oGridlines
2538
     * @throws \Exception
2539
     */
2540
    protected function writeAxisGridlines(XMLWriter $objWriter, Gridlines $oGridlines)
2541
    {
2542
        // c:spPr
2543
        $objWriter->startElement('c:spPr');
2544
2545
        // Outline
2546
        $this->writeOutline($objWriter, $oGridlines->getOutline());
2547
2548
        // ##c:spPr
2549
        $objWriter->endElement();
2550
    }
2551
}
2552