Completed
Push — develop ( aca4a2...633916 )
by Franck
11s
created

PptCharts::writeChart()   C

Complexity

Conditions 8
Paths 32

Size

Total Lines 141
Code Lines 71

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 54
CRAP Score 8

Importance

Changes 0
Metric Value
dl 0
loc 141
ccs 54
cts 54
cp 1
rs 5.2676
c 0
b 0
f 0
cc 8
eloc 71
nc 32
nop 1
crap 8

How to fix   Long Method   

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\Line;
17
use PhpOffice\PhpPresentation\Shape\Chart\Type\Pie;
18
use PhpOffice\PhpPresentation\Shape\Chart\Type\Pie3D;
19
use PhpOffice\PhpPresentation\Shape\Chart\Type\Scatter;
20
use PhpOffice\PhpPresentation\Style\Border;
21
use PhpOffice\PhpPresentation\Style\Fill;
22
23
class PptCharts extends AbstractDecoratorWriter
24
{
25
    /**
26
     * @return \PhpOffice\Common\Adapter\Zip\ZipInterface
27
     * @throws \Exception
28
     */
29 98
    public function render()
30
    {
31 98
        for ($i = 0; $i < $this->getDrawingHashTable()->count(); ++$i) {
32 33
            $shape = $this->getDrawingHashTable()->getByIndex($i);
33 33
            if ($shape instanceof Chart) {
34 25
                $this->getZip()->addFromString('ppt/charts/' . $shape->getIndexedFilename(), $this->writeChart($shape));
35
36 24
                if ($shape->hasIncludedSpreadsheet()) {
37
                    $this->getZip()->addFromString('ppt/charts/_rels/' . $shape->getIndexedFilename() . '.rels', $this->writeChartRelationships($shape));
38
                    $pFilename = 'PHPExcel';
39
                    $this->getZip()->addFromString('ppt/embeddings/' . $shape->getIndexedFilename() . '.xlsx', $this->writeSpreadsheet($this->getPresentation(), $shape, $pFilename . '.xlsx'));
40
                }
41
            }
42
        }
43 97
        return $this->getZip();
44
    }
45
46
47
    /**
48
     * Write chart to XML format
49
     *
50
     * @param  \PhpOffice\PhpPresentation\Shape\Chart $chart
51
     * @return string                    XML Output
52
     * @throws \Exception
53
     */
54 25
    public function writeChart(Chart $chart)
55
    {
56
        // Create XML writer
57 25
        $objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
58
59
        // XML header
60 25
        $objWriter->startDocument('1.0', 'UTF-8', 'yes');
61
62
        // c:chartSpace
63 25
        $objWriter->startElement('c:chartSpace');
64 25
        $objWriter->writeAttribute('xmlns:c', 'http://schemas.openxmlformats.org/drawingml/2006/chart');
65 25
        $objWriter->writeAttribute('xmlns:a', 'http://schemas.openxmlformats.org/drawingml/2006/main');
66 25
        $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
67
68
        // c:date1904
69 25
        $objWriter->startElement('c:date1904');
70 25
        $objWriter->writeAttribute('val', '1');
71 25
        $objWriter->endElement();
72
73
        // c:lang
74 25
        $objWriter->startElement('c:lang');
75 25
        $objWriter->writeAttribute('val', 'en-US');
76 25
        $objWriter->endElement();
77
78
        // c:chart
79 25
        $objWriter->startElement('c:chart');
80
81
        // Title?
82 25
        if ($chart->getTitle()->isVisible()) {
83
            // Write title
84 25
            $this->writeTitle($objWriter, $chart->getTitle());
85
        }
86
87
        // c:autoTitleDeleted
88 25
        $objWriter->startElement('c:autoTitleDeleted');
89 25
        $objWriter->writeAttribute('val', $chart->getTitle()->isVisible() ? '0' : '1');
90 25
        $objWriter->endElement();
91
92
        // c:view3D
93 25
        $objWriter->startElement('c:view3D');
94
95
        // c:rotX
96 25
        $objWriter->startElement('c:rotX');
97 25
        $objWriter->writeAttribute('val', $chart->getView3D()->getRotationX());
98 25
        $objWriter->endElement();
99
100
        // c:hPercent
101 25
        $objWriter->startElement('c:hPercent');
102 25
        $objWriter->writeAttribute('val', $chart->getView3D()->getHeightPercent());
103 25
        $objWriter->endElement();
104
105
        // c:rotY
106 25
        $objWriter->startElement('c:rotY');
107 25
        $objWriter->writeAttribute('val', $chart->getView3D()->getRotationY());
108 25
        $objWriter->endElement();
109
110
        // c:depthPercent
111 25
        $objWriter->startElement('c:depthPercent');
112 25
        $objWriter->writeAttribute('val', $chart->getView3D()->getDepthPercent());
113 25
        $objWriter->endElement();
114
115
        // c:rAngAx
116 25
        $objWriter->startElement('c:rAngAx');
117 25
        $objWriter->writeAttribute('val', $chart->getView3D()->hasRightAngleAxes() ? '1' : '0');
118 25
        $objWriter->endElement();
119
120
        // c:perspective
121 25
        $objWriter->startElement('c:perspective');
122 25
        $objWriter->writeAttribute('val', $chart->getView3D()->getPerspective());
123 25
        $objWriter->endElement();
124
125 25
        $objWriter->endElement();
126
127
        // Write plot area
128 25
        $this->writePlotArea($objWriter, $chart->getPlotArea(), $chart);
129
130
        // Legend?
131 24
        if ($chart->getLegend()->isVisible()) {
132
            // Write legend
133 24
            $this->writeLegend($objWriter, $chart->getLegend());
134
        }
135
136
        // c:plotVisOnly
137 24
        $objWriter->startElement('c:plotVisOnly');
138 24
        $objWriter->writeAttribute('val', '1');
139 24
        $objWriter->endElement();
140
141 24
        $objWriter->endElement();
142
143
        // c:spPr
144 24
        $objWriter->startElement('c:spPr');
145
146
        // Fill
147 24
        $this->writeFill($objWriter, $chart->getFill());
148
149
        // Border
150 24
        if ($chart->getBorder()->getLineStyle() != Border::LINE_NONE) {
151
            $this->writeBorder($objWriter, $chart->getBorder(), '');
152
        }
153
154
        // Shadow
155 24
        if ($chart->getShadow()->isVisible()) {
156
            // a:effectLst
157
            $objWriter->startElement('a:effectLst');
158
159
            // a:outerShdw
160
            $objWriter->startElement('a:outerShdw');
161
            $objWriter->writeAttribute('blurRad', CommonDrawing::pixelsToEmu($chart->getShadow()->getBlurRadius()));
162
            $objWriter->writeAttribute('dist', CommonDrawing::pixelsToEmu($chart->getShadow()->getDistance()));
163
            $objWriter->writeAttribute('dir', CommonDrawing::degreesToAngle($chart->getShadow()->getDirection()));
164
            $objWriter->writeAttribute('algn', $chart->getShadow()->getAlignment());
165
            $objWriter->writeAttribute('rotWithShape', '0');
166
167
            $this->writeColor($objWriter, $chart->getShadow()->getColor(), $chart->getShadow()->getAlpha());
168
169
            $objWriter->endElement();
170
171
            $objWriter->endElement();
172
        }
173
174 24
        $objWriter->endElement();
175
176
        // External data?
177 24
        if ($chart->hasIncludedSpreadsheet()) {
178
            // c:externalData
179
            $objWriter->startElement('c:externalData');
180
            $objWriter->writeAttribute('r:id', 'rId1');
181
182
            // c:autoUpdate
183
            $objWriter->startElement('c:autoUpdate');
184
            $objWriter->writeAttribute('val', '0');
185
            $objWriter->endElement();
186
187
            $objWriter->endElement();
188
        }
189
190 24
        $objWriter->endElement();
191
192
        // Return
193 24
        return $objWriter->getData();
194
    }
195
196
    /**
197
     * Write chart to XML format
198
     *
199
     * @param  PhpPresentation             $presentation
200
     * @param  \PhpOffice\PhpPresentation\Shape\Chart $chart
201
     * @param  string                    $tempName
202
     * @return string                    String output
203
     * @throws \Exception
204
     */
205
    public function writeSpreadsheet(PhpPresentation $presentation, $chart, $tempName)
206
    {
207
        // Need output?
208
        if (!$chart->hasIncludedSpreadsheet()) {
209
            throw new \Exception('No spreadsheet output is required for the given chart.');
210
        }
211
212
        // Verify PHPExcel
213
        if (!class_exists('PHPExcel')) {
214
            throw new \Exception('PHPExcel has not been loaded. Include PHPExcel.php in your script, e.g. require_once \'PHPExcel.php\'.');
215
        }
216
217
        // Create new spreadsheet
218
        $workbook = new \PHPExcel();
219
220
        // Set properties
221
        $title = $chart->getTitle()->getText();
222
        if (strlen($title) == 0) {
223
            $title = 'Chart';
224
        }
225
        $workbook->getProperties()->setCreator($presentation->getDocumentProperties()->getCreator())->setLastModifiedBy($presentation->getDocumentProperties()->getLastModifiedBy())->setTitle($title);
226
227
        // Add chart data
228
        $sheet = $workbook->setActiveSheetIndex(0);
229
        $sheet->setTitle('Sheet1');
230
231
        // Write series
232
        $seriesIndex = 0;
233
        foreach ($chart->getPlotArea()->getType()->getSeries() as $series) {
234
            // Title
235
            $sheet->setCellValueByColumnAndRow(1 + $seriesIndex, 1, $series->getTitle());
236
237
            // X-axis
238
            $axisXData = array_keys($series->getValues());
239
            $numAxisXData = count($axisXData);
240
            for ($i = 0; $i < $numAxisXData; $i++) {
241
                $sheet->setCellValueByColumnAndRow(0, $i + 2, $axisXData[$i]);
242
            }
243
244
            // Y-axis
245
            $axisYData = array_values($series->getValues());
246
            $numAxisYData = count($axisYData);
247
            for ($i = 0; $i < $numAxisYData; $i++) {
248
                $sheet->setCellValueByColumnAndRow(1 + $seriesIndex, $i + 2, $axisYData[$i]);
249
            }
250
251
            ++$seriesIndex;
252
        }
253
254
        // Save to string
255
        $writer = \PHPExcel_IOFactory::createWriter($workbook, 'Excel2007');
256
        $writer->save($tempName);
257
258
        // Load file in memory
259
        $returnValue = file_get_contents($tempName);
260
        if (@unlink($tempName) === false) {
261
            throw new \Exception('The file '.$tempName.' could not removed.');
262
        }
263
264
        return $returnValue;
265
    }
266
267
    /**
268
     * Write element with value attribute
269
     *
270
     * @param \PhpOffice\Common\XMLWriter $objWriter   XML Writer
271
     * @param string                         $elementName
272
     * @param string                         $value
273
     */
274 23
    protected function writeElementWithValAttribute($objWriter, $elementName, $value)
275
    {
276 23
        $objWriter->startElement($elementName);
277 23
        $objWriter->writeAttribute('val', $value);
278 23
        $objWriter->endElement();
279 23
    }
280
281
    /**
282
     * Write single value or reference
283
     *
284
     * @param \PhpOffice\Common\XMLWriter $objWriter   XML Writer
285
     * @param boolean                        $isReference
286
     * @param mixed                          $value
287
     * @param string                         $reference
288
     */
289 23
    protected function writeSingleValueOrReference($objWriter, $isReference, $value, $reference)
290
    {
291 23
        if (!$isReference) {
292
            // Value
293 23
            $objWriter->writeElement('c:v', $value);
294 23
            return;
295
        }
296
297
        // Reference and cache
298
        $objWriter->startElement('c:strRef');
299
        $objWriter->writeElement('c:f', $reference);
300
        $objWriter->startElement('c:strCache');
301
        $objWriter->startElement('c:ptCount');
302
        $objWriter->writeAttribute('val', '1');
303
        $objWriter->endElement();
304
305
        $objWriter->startElement('c:pt');
306
        $objWriter->writeAttribute('idx', '0');
307
        $objWriter->writeElement('c:v', $value);
308
        $objWriter->endElement();
309
        $objWriter->endElement();
310
        $objWriter->endElement();
311
    }
312
313
    /**
314
     * Write series value or reference
315
     *
316
     * @param \PhpOffice\Common\XMLWriter $objWriter   XML Writer
317
     * @param boolean                        $isReference
318
     * @param mixed                          $values
319
     * @param string                         $reference
320
     */
321 23
    protected function writeMultipleValuesOrReference($objWriter, $isReference, $values, $reference)
322
    {
323
        // c:strLit / c:numLit
324
        // c:strRef / c:numRef
325 23
        $referenceType = ($isReference ? 'Ref' : 'Lit');
326 23
        $dataType = 'str';
327 23
        if (is_int($values[0]) || is_float($values[0])) {
328 23
            $dataType = 'num';
329
        }
330 23
        $objWriter->startElement('c:' . $dataType . $referenceType);
331
332 23
        $numValues = count($values);
333 23
        if (!$isReference) {
334
            // Value
335
336
            // c:ptCount
337 23
            $objWriter->startElement('c:ptCount');
338 23
            $objWriter->writeAttribute('val', count($values));
339 23
            $objWriter->endElement();
340
341
            // Add points
342 23
            for ($i = 0; $i < $numValues; $i++) {
343
                // c:pt
344 23
                $objWriter->startElement('c:pt');
345 23
                $objWriter->writeAttribute('idx', $i);
346 23
                $objWriter->writeElement('c:v', $values[$i]);
347 23
                $objWriter->endElement();
348
            }
349
        } else {
350
            // Reference
351
            $objWriter->writeElement('c:f', $reference);
352
            $objWriter->startElement('c:' . $dataType . 'Cache');
353
354
            // c:ptCount
355
            $objWriter->startElement('c:ptCount');
356
            $objWriter->writeAttribute('val', count($values));
357
            $objWriter->endElement();
358
359
            // Add points
360
            for ($i = 0; $i < $numValues; $i++) {
361
                // c:pt
362
                $objWriter->startElement('c:pt');
363
                $objWriter->writeAttribute('idx', $i);
364
                $objWriter->writeElement('c:v', $values[$i]);
365
                $objWriter->endElement();
366
            }
367
368
            $objWriter->endElement();
369
        }
370
371 23
        $objWriter->endElement();
372 23
    }
373
374
    /**
375
     * Write Title
376
     *
377
     * @param  \PhpOffice\Common\XMLWriter  $objWriter XML Writer
378
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Title $subject
379
     * @throws \Exception
380
     */
381 25
    protected function writeTitle(XMLWriter $objWriter, Title $subject)
382
    {
383
        // c:title
384 25
        $objWriter->startElement('c:title');
385
386
        // c:tx
387 25
        $objWriter->startElement('c:tx');
388
389
        // c:rich
390 25
        $objWriter->startElement('c:rich');
391
392
        // a:bodyPr
393 25
        $objWriter->writeElement('a:bodyPr', null);
394
395
        // a:lstStyle
396 25
        $objWriter->writeElement('a:lstStyle', null);
397
398
        // a:p
399 25
        $objWriter->startElement('a:p');
400
401
        // a:pPr
402 25
        $objWriter->startElement('a:pPr');
403 25
        $objWriter->writeAttribute('algn', $subject->getAlignment()->getHorizontal());
404 25
        $objWriter->writeAttribute('fontAlgn', $subject->getAlignment()->getVertical());
405 25
        $objWriter->writeAttribute('marL', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginLeft()));
406 25
        $objWriter->writeAttribute('marR', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginRight()));
407 25
        $objWriter->writeAttribute('indent', CommonDrawing::pixelsToEmu($subject->getAlignment()->getIndent()));
408 25
        $objWriter->writeAttribute('lvl', $subject->getAlignment()->getLevel());
409
410
        // a:defRPr
411 25
        $objWriter->writeElement('a:defRPr', null);
412
413 25
        $objWriter->endElement();
414
415
        // a:r
416 25
        $objWriter->startElement('a:r');
417
418
        // a:rPr
419 25
        $objWriter->startElement('a:rPr');
420 25
        $objWriter->writeAttribute('lang', 'en-US');
421 25
        $objWriter->writeAttribute('dirty', '0');
422
423 25
        $objWriter->writeAttribute('b', ($subject->getFont()->isBold() ? 'true' : 'false'));
424 25
        $objWriter->writeAttribute('i', ($subject->getFont()->isItalic() ? 'true' : 'false'));
425 25
        $objWriter->writeAttribute('strike', ($subject->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
426 25
        $objWriter->writeAttribute('sz', ($subject->getFont()->getSize() * 100));
427 25
        $objWriter->writeAttribute('u', $subject->getFont()->getUnderline());
428 25
        $objWriter->writeAttributeIf($subject->getFont()->isSuperScript(), 'baseline', '30000');
429 25
        $objWriter->writeAttributeIf($subject->getFont()->isSubScript(), 'baseline', '-25000');
430
431
        // Font - a:solidFill
432 25
        $objWriter->startElement('a:solidFill');
433
434 25
        $this->writeColor($objWriter, $subject->getFont()->getColor());
435
436 25
        $objWriter->endElement();
437
438
        // Font - a:latin
439 25
        $objWriter->startElement('a:latin');
440 25
        $objWriter->writeAttribute('typeface', $subject->getFont()->getName());
441 25
        $objWriter->endElement();
442
443 25
        $objWriter->endElement();
444
445
        // a:t
446 25
        $objWriter->writeElement('a:t', $subject->getText());
447
448 25
        $objWriter->endElement();
449
450
        // a:endParaRPr
451 25
        $objWriter->startElement('a:endParaRPr');
452 25
        $objWriter->writeAttribute('lang', 'en-US');
453 25
        $objWriter->writeAttribute('dirty', '0');
454 25
        $objWriter->endElement();
455
456 25
        $objWriter->endElement();
457
458 25
        $objWriter->endElement();
459
460 25
        $objWriter->endElement();
461
462
        // Write layout
463 25
        $this->writeLayout($objWriter, $subject);
464
465
        // c:overlay
466 25
        $objWriter->startElement('c:overlay');
467 25
        $objWriter->writeAttribute('val', '0');
468 25
        $objWriter->endElement();
469
470 25
        $objWriter->endElement();
471 25
    }
472
473
    /**
474
     * Write Plot Area
475
     *
476
     * @param  \PhpOffice\Common\XMLWriter     $objWriter XML Writer
477
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\PlotArea $subject
478
     * @param  \PhpOffice\PhpPresentation\Shape\Chart          $chart
479
     * @throws \Exception
480
     */
481 25
    protected function writePlotArea(XMLWriter $objWriter, PlotArea $subject, Chart $chart)
482
    {
483
        // c:plotArea
484 25
        $objWriter->startElement('c:plotArea');
485
486
        // Write layout
487 25
        $this->writeLayout($objWriter, $subject);
488
489
        // Write chart
490 25
        $chartType = $subject->getType();
491 25
        if ($chartType instanceof Area) {
492 1
            $this->writeTypeArea($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
493
        } elseif ($chartType instanceof Bar) {
494 2
            $this->writeTypeBar($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
495
        } elseif ($chartType instanceof Bar3D) {
496 4
            $this->writeTypeBar3D($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
497
        } elseif ($chartType instanceof Pie) {
498 1
            $this->writeTypePie($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
499
        } elseif ($chartType instanceof Pie3D) {
500 4
            $this->writeTypePie3D($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
501
        } elseif ($chartType instanceof Line) {
502 7
            $this->writeTypeLine($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
503
        } elseif ($chartType instanceof Scatter) {
504 5
            $this->writeTypeScatter($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
505
        } else {
506 1
            throw new \Exception('The chart type provided could not be rendered.');
507
        }
508
509
        // Write X axis?
510 24
        if ($chartType->hasAxisX()) {
511 19
            $this->writeAxis($objWriter, $subject->getAxisX(), Chart\Axis::AXIS_X, $chartType);
512
        }
513
514
        // Write Y axis?
515 24
        if ($chartType->hasAxisY()) {
516 19
            $this->writeAxis($objWriter, $subject->getAxisY(), Chart\Axis::AXIS_Y, $chartType);
517
        }
518
519 24
        $objWriter->endElement();
520 24
    }
521
522
    /**
523
     * Write Legend
524
     *
525
     * @param  \PhpOffice\Common\XMLWriter   $objWriter XML Writer
526
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Legend $subject
527
     * @throws \Exception
528
     */
529 24
    protected function writeLegend(XMLWriter $objWriter, Legend $subject)
530
    {
531
        // c:legend
532 24
        $objWriter->startElement('c:legend');
533
534
        // c:legendPos
535 24
        $objWriter->startElement('c:legendPos');
536 24
        $objWriter->writeAttribute('val', $subject->getPosition());
537 24
        $objWriter->endElement();
538
539
        // Write layout
540 24
        $this->writeLayout($objWriter, $subject);
541
542
        // c:overlay
543 24
        $objWriter->startElement('c:overlay');
544 24
        $objWriter->writeAttribute('val', '0');
545 24
        $objWriter->endElement();
546
547
        // c:spPr
548 24
        $objWriter->startElement('c:spPr');
549
550
        // Fill
551 24
        $this->writeFill($objWriter, $subject->getFill());
552
553
        // Border
554 24
        if ($subject->getBorder()->getLineStyle() != Border::LINE_NONE) {
555 24
            $this->writeBorder($objWriter, $subject->getBorder(), '');
556
        }
557
558 24
        $objWriter->endElement();
559
560
        // c:txPr
561 24
        $objWriter->startElement('c:txPr');
562
563
        // a:bodyPr
564 24
        $objWriter->writeElement('a:bodyPr', null);
565
566
        // a:lstStyle
567 24
        $objWriter->writeElement('a:lstStyle', null);
568
569
        // a:p
570 24
        $objWriter->startElement('a:p');
571
572
        // a:pPr
573 24
        $objWriter->startElement('a:pPr');
574 24
        $objWriter->writeAttribute('algn', $subject->getAlignment()->getHorizontal());
575 24
        $objWriter->writeAttribute('fontAlgn', $subject->getAlignment()->getVertical());
576 24
        $objWriter->writeAttribute('marL', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginLeft()));
577 24
        $objWriter->writeAttribute('marR', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginRight()));
578 24
        $objWriter->writeAttribute('indent', CommonDrawing::pixelsToEmu($subject->getAlignment()->getIndent()));
579 24
        $objWriter->writeAttribute('lvl', $subject->getAlignment()->getLevel());
580
581
        // a:defRPr
582 24
        $objWriter->startElement('a:defRPr');
583
584 24
        $objWriter->writeAttribute('b', ($subject->getFont()->isBold() ? 'true' : 'false'));
585 24
        $objWriter->writeAttribute('i', ($subject->getFont()->isItalic() ? 'true' : 'false'));
586 24
        $objWriter->writeAttribute('strike', ($subject->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
587 24
        $objWriter->writeAttribute('sz', ($subject->getFont()->getSize() * 100));
588 24
        $objWriter->writeAttribute('u', $subject->getFont()->getUnderline());
589 24
        $objWriter->writeAttributeIf($subject->getFont()->isSuperScript(), 'baseline', '30000');
590 24
        $objWriter->writeAttributeIf($subject->getFont()->isSubScript(), 'baseline', '-25000');
591
592
        // Font - a:solidFill
593 24
        $objWriter->startElement('a:solidFill');
594
595 24
        $this->writeColor($objWriter, $subject->getFont()->getColor());
596
597 24
        $objWriter->endElement();
598
599
        // Font - a:latin
600 24
        $objWriter->startElement('a:latin');
601 24
        $objWriter->writeAttribute('typeface', $subject->getFont()->getName());
602 24
        $objWriter->endElement();
603
604 24
        $objWriter->endElement();
605
606 24
        $objWriter->endElement();
607
608
        // a:endParaRPr
609 24
        $objWriter->startElement('a:endParaRPr');
610 24
        $objWriter->writeAttribute('lang', 'en-US');
611 24
        $objWriter->writeAttribute('dirty', '0');
612 24
        $objWriter->endElement();
613
614 24
        $objWriter->endElement();
615
616 24
        $objWriter->endElement();
617
618 24
        $objWriter->endElement();
619 24
    }
620
621
    /**
622
     * Write Layout
623
     *
624
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
625
     * @param  mixed                          $subject
626
     * @throws \Exception
627
     */
628 25
    protected function writeLayout(XMLWriter $objWriter, $subject)
629
    {
630
        // c:layout
631 25
        $objWriter->startElement('c:layout');
632
633
        // c:manualLayout
634 25
        $objWriter->startElement('c:manualLayout');
635
        // c:xMode
636 25
        $objWriter->startElement('c:xMode');
637 25
        $objWriter->writeAttribute('val', 'edge');
638 25
        $objWriter->endElement();
639
640
        // c:yMode
641 25
        $objWriter->startElement('c:yMode');
642 25
        $objWriter->writeAttribute('val', 'edge');
643 25
        $objWriter->endElement();
644
645 25
        if ($subject->getOffsetX() != 0) {
646
            // c:x
647 25
            $objWriter->startElement('c:x');
648 25
            $objWriter->writeAttribute('val', $subject->getOffsetX());
649 25
            $objWriter->endElement();
650
        }
651
652 25
        if ($subject->getOffsetY() != 0) {
653
            // c:y
654 25
            $objWriter->startElement('c:y');
655 25
            $objWriter->writeAttribute('val', $subject->getOffsetY());
656 25
            $objWriter->endElement();
657
        }
658
659 25
        if ($subject->getWidth() != 0) {
660
            // c:w
661
            $objWriter->startElement('c:w');
662
            $objWriter->writeAttribute('val', $subject->getWidth());
663
            $objWriter->endElement();
664
        }
665
666 25
        if ($subject->getHeight() != 0) {
667
            // c:h
668
            $objWriter->startElement('c:h');
669
            $objWriter->writeAttribute('val', $subject->getHeight());
670
            $objWriter->endElement();
671
        }
672
673 25
        $objWriter->endElement();
674 25
        $objWriter->endElement();
675 25
    }
676
677
    /**
678
     * Write Type Area
679
     *
680
     * @param  \PhpOffice\Common\XMLWriter      $objWriter    XML Writer
681
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Area $subject
682
     * @param  boolean                             $includeSheet
683
     * @throws \Exception
684
     */
685 1
    protected function writeTypeArea(XMLWriter $objWriter, Area $subject, $includeSheet = false)
686
    {
687
        // c:lineChart
688 1
        $objWriter->startElement('c:areaChart');
689
690
        // c:grouping
691 1
        $objWriter->startElement('c:grouping');
692 1
        $objWriter->writeAttribute('val', 'standard');
693 1
        $objWriter->endElement();
694
695
        // Write series
696 1
        $seriesIndex = 0;
697 1
        foreach ($subject->getSeries() as $series) {
698
            // c:ser
699 1
            $objWriter->startElement('c:ser');
700
701
            // c:ser > c:idx
702 1
            $objWriter->startElement('c:idx');
703 1
            $objWriter->writeAttribute('val', $seriesIndex);
704 1
            $objWriter->endElement();
705
706
            // c:ser > c:order
707 1
            $objWriter->startElement('c:order');
708 1
            $objWriter->writeAttribute('val', $seriesIndex);
709 1
            $objWriter->endElement();
710
711
            // c:ser > c:tx
712 1
            $objWriter->startElement('c:tx');
713 1
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
714 1
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
715 1
            $objWriter->endElement();
716
717
            // c:ser > c:dLbls
718
            // @link : https://msdn.microsoft.com/en-us/library/documentformat.openxml.drawing.charts.areachartseries.aspx
719 1
            $objWriter->startElement('c:dLbls');
720
721
            // c:ser > c:dLbls > c:showVal
722 1
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
723
724
            // c:ser > c:dLbls > c:showCatName
725 1
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
726
727
            // c:ser > c:dLbls > c:showSerName
728 1
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
729
730
            // c:ser > c:dLbls > c:showPercent
731 1
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
732
733
            // c:ser > ##c:dLbls
734 1
            $objWriter->endElement();
735
736 1
            if ($series->getFill()->getFillType() != Fill::FILL_NONE) {
737
                // c:spPr
738
                $objWriter->startElement('c:spPr');
739
                // Write fill
740
                $this->writeFill($objWriter, $series->getFill());
741
                // ## c:spPr
742
                $objWriter->endElement();
743
            }
744
745
            // Write X axis data
746 1
            $axisXData = array_keys($series->getValues());
747
748
            // c:cat
749 1
            $objWriter->startElement('c:cat');
750 1
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
751 1
            $objWriter->endElement();
752
753
            // Write Y axis data
754 1
            $axisYData = array_values($series->getValues());
755
756
            // c:val
757 1
            $objWriter->startElement('c:val');
758 1
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
759 1
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
760 1
            $objWriter->endElement();
761
762 1
            $objWriter->endElement();
763
764 1
            ++$seriesIndex;
765
        }
766
767
        // c:axId
768 1
        $objWriter->startElement('c:axId');
769 1
        $objWriter->writeAttribute('val', '52743552');
770 1
        $objWriter->endElement();
771
772
        // c:axId
773 1
        $objWriter->startElement('c:axId');
774 1
        $objWriter->writeAttribute('val', '52749440');
775 1
        $objWriter->endElement();
776
777 1
        $objWriter->endElement();
778 1
    }
779
780
    /**
781
     * Write Type Bar
782
     *
783
     * @param  \PhpOffice\Common\XMLWriter       $objWriter    XML Writer
784
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Bar $subject
785
     * @param  boolean                              $includeSheet
786
     * @throws \Exception
787
     */
788 2
    protected function writeTypeBar(XMLWriter $objWriter, Bar $subject, $includeSheet = false)
789
    {
790
        // c:bar3DChart
791 2
        $objWriter->startElement('c:barChart');
792
793
        // c:barDir
794 2
        $objWriter->startElement('c:barDir');
795 2
        $objWriter->writeAttribute('val', $subject->getBarDirection());
796 2
        $objWriter->endElement();
797
798
        // c:grouping
799 2
        $objWriter->startElement('c:grouping');
800 2
        $objWriter->writeAttribute('val', $subject->getBarGrouping());
801 2
        $objWriter->endElement();
802
803
        // Write series
804 2
        $seriesIndex = 0;
805 2
        foreach ($subject->getSeries() as $series) {
806
            // c:ser
807 2
            $objWriter->startElement('c:ser');
808
809
            // c:idx
810 2
            $objWriter->startElement('c:idx');
811 2
            $objWriter->writeAttribute('val', $seriesIndex);
812 2
            $objWriter->endElement();
813
814
            // c:order
815 2
            $objWriter->startElement('c:order');
816 2
            $objWriter->writeAttribute('val', $seriesIndex);
817 2
            $objWriter->endElement();
818
819
            // c:tx
820 2
            $objWriter->startElement('c:tx');
821 2
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
822 2
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
823 2
            $objWriter->endElement();
824
825
            // Fills for points?
826 2
            $dataPointFills = $series->getDataPointFills();
827 2
            foreach ($dataPointFills as $key => $value) {
828
                // c:dPt
829 1
                $objWriter->startElement('c:dPt');
830
831
                // c:idx
832 1
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
833
834 1
                if ($value->getFillType() != Fill::FILL_NONE) {
835
                    // c:spPr
836 1
                    $objWriter->startElement('c:spPr');
837
                    // Write fill
838 1
                    $this->writeFill($objWriter, $value);
839
                    // ## c:spPr
840 1
                    $objWriter->endElement();
841
                }
842
843
                // ## c:dPt
844 1
                $objWriter->endElement();
845
            }
846
847
            // c:dLbls
848 2
            $objWriter->startElement('c:dLbls');
849
850 2
            if ($series->hasDlblNumFormat()) {
851
                //c:numFmt
852
                $objWriter->startElement('c:numFmt');
853
                $objWriter->writeAttribute('formatCode', $series->getDlblNumFormat());
854
                $objWriter->writeAttribute('sourceLinked', '0');
855
                $objWriter->endElement();
856
            }
857
858
            // c:txPr
859 2
            $objWriter->startElement('c:txPr');
860
861
            // a:bodyPr
862 2
            $objWriter->writeElement('a:bodyPr', null);
863
864
            // a:lstStyle
865 2
            $objWriter->writeElement('a:lstStyle', null);
866
867
            // a:p
868 2
            $objWriter->startElement('a:p');
869
870
            // a:pPr
871 2
            $objWriter->startElement('a:pPr');
872
873
            // a:defRPr
874 2
            $objWriter->startElement('a:defRPr');
875
876 2
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
877 2
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
878 2
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
879 2
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
880 2
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
881 2
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
882 2
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
883
884
            // Font - a:solidFill
885 2
            $objWriter->startElement('a:solidFill');
886
887 2
            $this->writeColor($objWriter, $series->getFont()->getColor());
888
889 2
            $objWriter->endElement();
890
891
            // Font - a:latin
892 2
            $objWriter->startElement('a:latin');
893 2
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
894 2
            $objWriter->endElement();
895
896 2
            $objWriter->endElement();
897
898 2
            $objWriter->endElement();
899
900
            // a:endParaRPr
901 2
            $objWriter->startElement('a:endParaRPr');
902 2
            $objWriter->writeAttribute('lang', 'en-US');
903 2
            $objWriter->writeAttribute('dirty', '0');
904 2
            $objWriter->endElement();
905
906 2
            $objWriter->endElement();
907
908 2
            $objWriter->endElement();
909
910
            // c:showVal
911 2
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
912
913
            // c:showCatName
914 2
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
915
916
            // c:showSerName
917 2
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
918
919
            // c:showPercent
920 2
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
921
922
            // c:showLeaderLines
923 2
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
924
925 2
            $objWriter->endElement();
926
927
            // c:spPr
928 2
            if ($series->getFill()->getFillType() != Fill::FILL_NONE) {
929
                // c:spPr
930
                $objWriter->startElement('c:spPr');
931
                // Write fill
932
                $this->writeFill($objWriter, $series->getFill());
933
                // ## c:spPr
934
                $objWriter->endElement();
935
            }
936
937
            // Write X axis data
938 2
            $axisXData = array_keys($series->getValues());
939
940
            // c:cat
941 2
            $objWriter->startElement('c:cat');
942 2
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
943 2
            $objWriter->endElement();
944
945
            // Write Y axis data
946 2
            $axisYData = array_values($series->getValues());
947
948
            // c:val
949 2
            $objWriter->startElement('c:val');
950 2
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
951 2
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
952 2
            $objWriter->endElement();
953
954 2
            $objWriter->endElement();
955
956 2
            ++$seriesIndex;
957
        }
958
959
        // c:overlap
960 2
        $objWriter->startElement('c:overlap');
961 2
        if ($subject->getBarGrouping() == Bar::GROUPING_CLUSTERED) {
962 2
            $objWriter->writeAttribute('val', '0');
963
        } elseif ($subject->getBarGrouping() == Bar::GROUPING_STACKED || $subject->getBarGrouping() == Bar::GROUPING_PERCENTSTACKED) {
964
            $objWriter->writeAttribute('val', '100');
965
        }
966 2
        $objWriter->endElement();
967
968
        // c:gapWidth
969 2
        $objWriter->startElement('c:gapWidth');
970 2
        $objWriter->writeAttribute('val', '75');
971 2
        $objWriter->endElement();
972
973
        // c:shape
974 2
        $objWriter->startElement('c:shape');
975 2
        $objWriter->writeAttribute('val', 'box');
976 2
        $objWriter->endElement();
977
978
        // c:axId
979 2
        $objWriter->startElement('c:axId');
980 2
        $objWriter->writeAttribute('val', '52743552');
981 2
        $objWriter->endElement();
982
983
        // c:axId
984 2
        $objWriter->startElement('c:axId');
985 2
        $objWriter->writeAttribute('val', '52749440');
986 2
        $objWriter->endElement();
987
988
        // c:axId
989 2
        $objWriter->startElement('c:axId');
990 2
        $objWriter->writeAttribute('val', '0');
991 2
        $objWriter->endElement();
992
993 2
        $objWriter->endElement();
994 2
    }
995
996
    /**
997
     * Write Type Bar3D
998
     *
999
     * @param  \PhpOffice\Common\XMLWriter       $objWriter    XML Writer
1000
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Bar3D $subject
1001
     * @param  boolean                              $includeSheet
1002
     * @throws \Exception
1003
     */
1004 4
    protected function writeTypeBar3D(XMLWriter $objWriter, Bar3D $subject, $includeSheet = false)
1005
    {
1006
        // c:bar3DChart
1007 4
        $objWriter->startElement('c:bar3DChart');
1008
1009
        // c:barDir
1010 4
        $objWriter->startElement('c:barDir');
1011 4
        $objWriter->writeAttribute('val', $subject->getBarDirection());
1012 4
        $objWriter->endElement();
1013
1014
        // c:grouping
1015 4
        $objWriter->startElement('c:grouping');
1016 4
        $objWriter->writeAttribute('val', $subject->getBarGrouping());
1017 4
        $objWriter->endElement();
1018
1019
        // Write series
1020 4
        $seriesIndex = 0;
1021 4
        foreach ($subject->getSeries() as $series) {
1022
            // c:ser
1023 4
            $objWriter->startElement('c:ser');
1024
1025
            // c:idx
1026 4
            $objWriter->startElement('c:idx');
1027 4
            $objWriter->writeAttribute('val', $seriesIndex);
1028 4
            $objWriter->endElement();
1029
1030
            // c:order
1031 4
            $objWriter->startElement('c:order');
1032 4
            $objWriter->writeAttribute('val', $seriesIndex);
1033 4
            $objWriter->endElement();
1034
1035
            // c:tx
1036 4
            $objWriter->startElement('c:tx');
1037 4
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1038 4
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1039 4
            $objWriter->endElement();
1040
1041
            // Fills for points?
1042 4
            $dataPointFills = $series->getDataPointFills();
1043 4
            foreach ($dataPointFills as $key => $value) {
1044
                // c:dPt
1045 1
                $objWriter->startElement('c:dPt');
1046
1047
                // c:idx
1048 1
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
1049
1050 1
                if ($value->getFillType() != Fill::FILL_NONE) {
1051
                    // c:spPr
1052 1
                    $objWriter->startElement('c:spPr');
1053
                    // Write fill
1054 1
                    $this->writeFill($objWriter, $value);
1055
                    // ## c:spPr
1056 1
                    $objWriter->endElement();
1057
                }
1058
1059
                // ## c:dPt
1060 1
                $objWriter->endElement();
1061
            }
1062
1063
            // c:dLbls
1064 4
            $objWriter->startElement('c:dLbls');
1065
1066
            // c:txPr
1067 4
            $objWriter->startElement('c:txPr');
1068
1069
            // a:bodyPr
1070 4
            $objWriter->writeElement('a:bodyPr', null);
1071
1072
            // a:lstStyle
1073 4
            $objWriter->writeElement('a:lstStyle', null);
1074
1075
            // a:p
1076 4
            $objWriter->startElement('a:p');
1077
1078
            // a:pPr
1079 4
            $objWriter->startElement('a:pPr');
1080
1081
            // a:defRPr
1082 4
            $objWriter->startElement('a:defRPr');
1083
1084 4
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1085 4
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1086 4
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1087 4
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1088 4
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1089 4
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1090 4
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1091
1092
            // Font - a:solidFill
1093 4
            $objWriter->startElement('a:solidFill');
1094
1095 4
            $this->writeColor($objWriter, $series->getFont()->getColor());
1096
1097 4
            $objWriter->endElement();
1098
1099
            // Font - a:latin
1100 4
            $objWriter->startElement('a:latin');
1101 4
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1102 4
            $objWriter->endElement();
1103
1104 4
            $objWriter->endElement();
1105
1106 4
            $objWriter->endElement();
1107
1108
            // a:endParaRPr
1109 4
            $objWriter->startElement('a:endParaRPr');
1110 4
            $objWriter->writeAttribute('lang', 'en-US');
1111 4
            $objWriter->writeAttribute('dirty', '0');
1112 4
            $objWriter->endElement();
1113
1114 4
            $objWriter->endElement();
1115
1116 4
            $objWriter->endElement();
1117
1118
            // c:showVal
1119 4
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1120
1121
            // c:showCatName
1122 4
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1123
1124
            // c:showSerName
1125 4
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1126
1127
            // c:showPercent
1128 4
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1129
1130
            // c:showLeaderLines
1131 4
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1132
1133 4
            $objWriter->endElement();
1134
1135
            // c:spPr
1136 4
            if ($series->getFill()->getFillType() != Fill::FILL_NONE) {
1137
                // c:spPr
1138
                $objWriter->startElement('c:spPr');
1139
                // Write fill
1140
                $this->writeFill($objWriter, $series->getFill());
1141
                // ## c:spPr
1142
                $objWriter->endElement();
1143
            }
1144
1145
            // Write X axis data
1146 4
            $axisXData = array_keys($series->getValues());
1147
1148
            // c:cat
1149 4
            $objWriter->startElement('c:cat');
1150 4
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1151 4
            $objWriter->endElement();
1152
1153
            // Write Y axis data
1154 4
            $axisYData = array_values($series->getValues());
1155
1156
            // c:val
1157 4
            $objWriter->startElement('c:val');
1158 4
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1159 4
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1160 4
            $objWriter->endElement();
1161
1162 4
            $objWriter->endElement();
1163
1164 4
            ++$seriesIndex;
1165
        }
1166
1167
        // c:gapWidth
1168 4
        $objWriter->startElement('c:gapWidth');
1169 4
        $objWriter->writeAttribute('val', '75');
1170 4
        $objWriter->endElement();
1171
1172
        // c:shape
1173 4
        $objWriter->startElement('c:shape');
1174 4
        $objWriter->writeAttribute('val', 'box');
1175 4
        $objWriter->endElement();
1176
1177
        // c:axId
1178 4
        $objWriter->startElement('c:axId');
1179 4
        $objWriter->writeAttribute('val', '52743552');
1180 4
        $objWriter->endElement();
1181
1182
        // c:axId
1183 4
        $objWriter->startElement('c:axId');
1184 4
        $objWriter->writeAttribute('val', '52749440');
1185 4
        $objWriter->endElement();
1186
1187
        // c:axId
1188 4
        $objWriter->startElement('c:axId');
1189 4
        $objWriter->writeAttribute('val', '0');
1190 4
        $objWriter->endElement();
1191
1192 4
        $objWriter->endElement();
1193 4
    }
1194
1195
    /**
1196
     * Write Type Pie
1197
     *
1198
     * @param  \PhpOffice\Common\XMLWriter       $objWriter    XML Writer
1199
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Pie $subject
1200
     * @param  boolean                              $includeSheet
1201
     * @throws \Exception
1202
     */
1203 1
    protected function writeTypePie(XMLWriter $objWriter, Pie $subject, $includeSheet = false)
1204
    {
1205
        // c:pieChart
1206 1
        $objWriter->startElement('c:pieChart');
1207
1208
        // c:varyColors
1209 1
        $objWriter->startElement('c:varyColors');
1210 1
        $objWriter->writeAttribute('val', '1');
1211 1
        $objWriter->endElement();
1212
1213
        // Write series
1214 1
        $seriesIndex = 0;
1215 1
        foreach ($subject->getSeries() as $series) {
1216
            // c:ser
1217 1
            $objWriter->startElement('c:ser');
1218
1219
            // c:idx
1220 1
            $objWriter->startElement('c:idx');
1221 1
            $objWriter->writeAttribute('val', $seriesIndex);
1222 1
            $objWriter->endElement();
1223
1224
            // c:order
1225 1
            $objWriter->startElement('c:order');
1226 1
            $objWriter->writeAttribute('val', $seriesIndex);
1227 1
            $objWriter->endElement();
1228
1229
            // c:tx
1230 1
            $objWriter->startElement('c:tx');
1231 1
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1232 1
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1233 1
            $objWriter->endElement();
1234
1235
            // Fills for points?
1236 1
            $dataPointFills = $series->getDataPointFills();
1237 1
            foreach ($dataPointFills as $key => $value) {
1238
                // c:dPt
1239 1
                $objWriter->startElement('c:dPt');
1240
1241
                // c:idx
1242 1
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
1243
1244
                // c:spPr
1245 1
                $objWriter->startElement('c:spPr');
1246
1247
                // Write fill
1248 1
                $this->writeFill($objWriter, $value);
1249
1250 1
                $objWriter->endElement();
1251
1252 1
                $objWriter->endElement();
1253
            }
1254
1255
            // c:dLbls
1256 1
            $objWriter->startElement('c:dLbls');
1257
1258
            // c:txPr
1259 1
            $objWriter->startElement('c:txPr');
1260
1261
            // a:bodyPr
1262 1
            $objWriter->writeElement('a:bodyPr', null);
1263
1264
            // a:lstStyle
1265 1
            $objWriter->writeElement('a:lstStyle', null);
1266
1267
            // a:p
1268 1
            $objWriter->startElement('a:p');
1269
1270
            // a:pPr
1271 1
            $objWriter->startElement('a:pPr');
1272
1273
            // a:defRPr
1274 1
            $objWriter->startElement('a:defRPr');
1275
1276 1
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1277 1
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1278 1
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1279 1
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1280 1
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1281 1
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1282 1
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1283
1284
            // Font - a:solidFill
1285 1
            $objWriter->startElement('a:solidFill');
1286
1287 1
            $this->writeColor($objWriter, $series->getFont()->getColor());
1288
1289 1
            $objWriter->endElement();
1290
1291
            // Font - a:latin
1292 1
            $objWriter->startElement('a:latin');
1293 1
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1294 1
            $objWriter->endElement();
1295
1296 1
            $objWriter->endElement();
1297
1298 1
            $objWriter->endElement();
1299
1300
            // a:endParaRPr
1301 1
            $objWriter->startElement('a:endParaRPr');
1302 1
            $objWriter->writeAttribute('lang', 'en-US');
1303 1
            $objWriter->writeAttribute('dirty', '0');
1304 1
            $objWriter->endElement();
1305
1306 1
            $objWriter->endElement();
1307
1308 1
            $objWriter->endElement();
1309
1310
            // c:dLblPos
1311 1
            $this->writeElementWithValAttribute($objWriter, 'c:dLblPos', $series->getLabelPosition());
1312
1313
            // c:showVal
1314 1
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1315
1316
            // c:showCatName
1317 1
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1318
1319
            // c:showSerName
1320 1
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1321
1322
            // c:showPercent
1323 1
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1324
1325
            // c:showLeaderLines
1326 1
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1327
1328 1
            $objWriter->endElement();
1329
1330
            // Write X axis data
1331 1
            $axisXData = array_keys($series->getValues());
1332
1333
            // c:cat
1334 1
            $objWriter->startElement('c:cat');
1335 1
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1336 1
            $objWriter->endElement();
1337
1338
            // Write Y axis data
1339 1
            $axisYData = array_values($series->getValues());
1340
1341
            // c:val
1342 1
            $objWriter->startElement('c:val');
1343 1
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1344 1
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1345 1
            $objWriter->endElement();
1346
1347 1
            $objWriter->endElement();
1348
1349 1
            ++$seriesIndex;
1350
        }
1351
1352 1
        $objWriter->endElement();
1353 1
    }
1354
1355
    /**
1356
     * Write Type Pie3D
1357
     *
1358
     * @param  \PhpOffice\Common\XMLWriter       $objWriter    XML Writer
1359
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Pie3D $subject
1360
     * @param  boolean                              $includeSheet
1361
     * @throws \Exception
1362
     */
1363 4
    protected function writeTypePie3D(XMLWriter $objWriter, Pie3D $subject, $includeSheet = false)
1364
    {
1365
        // c:pie3DChart
1366 4
        $objWriter->startElement('c:pie3DChart');
1367
1368
        // c:varyColors
1369 4
        $objWriter->startElement('c:varyColors');
1370 4
        $objWriter->writeAttribute('val', '1');
1371 4
        $objWriter->endElement();
1372
1373
        // Write series
1374 4
        $seriesIndex = 0;
1375 4
        foreach ($subject->getSeries() as $series) {
1376
            // c:ser
1377 4
            $objWriter->startElement('c:ser');
1378
1379
            // c:idx
1380 4
            $objWriter->startElement('c:idx');
1381 4
            $objWriter->writeAttribute('val', $seriesIndex);
1382 4
            $objWriter->endElement();
1383
1384
            // c:order
1385 4
            $objWriter->startElement('c:order');
1386 4
            $objWriter->writeAttribute('val', $seriesIndex);
1387 4
            $objWriter->endElement();
1388
1389
            // c:tx
1390 4
            $objWriter->startElement('c:tx');
1391 4
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1392 4
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1393 4
            $objWriter->endElement();
1394
1395
            // c:explosion
1396 4
            $objWriter->startElement('c:explosion');
1397 4
            $objWriter->writeAttribute('val', $subject->getExplosion());
1398 4
            $objWriter->endElement();
1399
1400
            // Fills for points?
1401 4
            $dataPointFills = $series->getDataPointFills();
1402 4
            foreach ($dataPointFills as $key => $value) {
1403
                // c:dPt
1404 1
                $objWriter->startElement('c:dPt');
1405
1406
                // c:idx
1407 1
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
1408
1409
                // c:spPr
1410 1
                $objWriter->startElement('c:spPr');
1411
1412
                // Write fill
1413 1
                $this->writeFill($objWriter, $value);
1414
1415 1
                $objWriter->endElement();
1416
1417 1
                $objWriter->endElement();
1418
            }
1419
1420
            // c:dLbls
1421 4
            $objWriter->startElement('c:dLbls');
1422
1423
            // c:txPr
1424 4
            $objWriter->startElement('c:txPr');
1425
1426
            // a:bodyPr
1427 4
            $objWriter->writeElement('a:bodyPr', null);
1428
1429
            // a:lstStyle
1430 4
            $objWriter->writeElement('a:lstStyle', null);
1431
1432
            // a:p
1433 4
            $objWriter->startElement('a:p');
1434
1435
            // a:pPr
1436 4
            $objWriter->startElement('a:pPr');
1437
1438
            // a:defRPr
1439 4
            $objWriter->startElement('a:defRPr');
1440
1441 4
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1442 4
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1443 4
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1444 4
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1445 4
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1446 4
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1447 4
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1448
1449
            // Font - a:solidFill
1450 4
            $objWriter->startElement('a:solidFill');
1451
1452 4
            $this->writeColor($objWriter, $series->getFont()->getColor());
1453
1454 4
            $objWriter->endElement();
1455
1456
            // Font - a:latin
1457 4
            $objWriter->startElement('a:latin');
1458 4
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1459 4
            $objWriter->endElement();
1460
1461 4
            $objWriter->endElement();
1462
1463 4
            $objWriter->endElement();
1464
1465
            // a:endParaRPr
1466 4
            $objWriter->startElement('a:endParaRPr');
1467 4
            $objWriter->writeAttribute('lang', 'en-US');
1468 4
            $objWriter->writeAttribute('dirty', '0');
1469 4
            $objWriter->endElement();
1470
1471 4
            $objWriter->endElement();
1472
1473 4
            $objWriter->endElement();
1474
1475
            // c:dLblPos
1476 4
            $this->writeElementWithValAttribute($objWriter, 'c:dLblPos', $series->getLabelPosition());
1477
1478
            // c:showVal
1479 4
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1480
1481
            // c:showCatName
1482 4
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1483
1484
            // c:showSerName
1485 4
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1486
1487
            // c:showPercent
1488 4
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1489
1490
            // c:showLeaderLines
1491 4
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1492
1493 4
            $objWriter->endElement();
1494
1495
            // Write X axis data
1496 4
            $axisXData = array_keys($series->getValues());
1497
1498
            // c:cat
1499 4
            $objWriter->startElement('c:cat');
1500 4
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1501 4
            $objWriter->endElement();
1502
1503
            // Write Y axis data
1504 4
            $axisYData = array_values($series->getValues());
1505
1506
            // c:val
1507 4
            $objWriter->startElement('c:val');
1508 4
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1509 4
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1510 4
            $objWriter->endElement();
1511
1512 4
            $objWriter->endElement();
1513
1514 4
            ++$seriesIndex;
1515
        }
1516
1517 4
        $objWriter->endElement();
1518 4
    }
1519
1520
    /**
1521
     * Write Type Line
1522
     *
1523
     * @param  \PhpOffice\Common\XMLWriter      $objWriter    XML Writer
1524
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Line $subject
1525
     * @param  boolean                             $includeSheet
1526
     * @throws \Exception
1527
     */
1528 7
    protected function writeTypeLine(XMLWriter $objWriter, Line $subject, $includeSheet = false)
1529
    {
1530
        // c:lineChart
1531 7
        $objWriter->startElement('c:lineChart');
1532
1533
        // c:grouping
1534 7
        $objWriter->startElement('c:grouping');
1535 7
        $objWriter->writeAttribute('val', 'standard');
1536 7
        $objWriter->endElement();
1537
1538
        // Write series
1539 7
        $seriesIndex = 0;
1540 7
        foreach ($subject->getSeries() as $series) {
1541
            // c:ser
1542 6
            $objWriter->startElement('c:ser');
1543
1544
            // c:idx
1545 6
            $objWriter->startElement('c:idx');
1546 6
            $objWriter->writeAttribute('val', $seriesIndex);
1547 6
            $objWriter->endElement();
1548
1549
            // c:order
1550 6
            $objWriter->startElement('c:order');
1551 6
            $objWriter->writeAttribute('val', $seriesIndex);
1552 6
            $objWriter->endElement();
1553
1554
            // c:tx
1555 6
            $objWriter->startElement('c:tx');
1556 6
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1557 6
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1558 6
            $objWriter->endElement();
1559
1560
            // Marker
1561 6
            $this->writeSeriesMarker($objWriter, $series->getMarker());
1562
1563
            // c:dLbls
1564 6
            $objWriter->startElement('c:dLbls');
1565
1566
            // c:txPr
1567 6
            $objWriter->startElement('c:txPr');
1568
1569
            // a:bodyPr
1570 6
            $objWriter->writeElement('a:bodyPr', null);
1571
1572
            // a:lstStyle
1573 6
            $objWriter->writeElement('a:lstStyle', null);
1574
1575
            // a:p
1576 6
            $objWriter->startElement('a:p');
1577
1578
            // a:pPr
1579 6
            $objWriter->startElement('a:pPr');
1580
1581
            // a:defRPr
1582 6
            $objWriter->startElement('a:defRPr');
1583
1584 6
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1585 6
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1586 6
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1587 6
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1588 6
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1589 6
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1590 6
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1591
1592
            // Font - a:solidFill
1593 6
            $objWriter->startElement('a:solidFill');
1594
1595 6
            $this->writeColor($objWriter, $series->getFont()->getColor());
1596
1597 6
            $objWriter->endElement();
1598
1599
            // Font - a:latin
1600 6
            $objWriter->startElement('a:latin');
1601 6
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1602 6
            $objWriter->endElement();
1603
1604 6
            $objWriter->endElement();
1605
1606 6
            $objWriter->endElement();
1607
1608
            // a:endParaRPr
1609 6
            $objWriter->startElement('a:endParaRPr');
1610 6
            $objWriter->writeAttribute('lang', 'en-US');
1611 6
            $objWriter->writeAttribute('dirty', '0');
1612 6
            $objWriter->endElement();
1613
1614 6
            $objWriter->endElement();
1615
1616 6
            $objWriter->endElement();
1617
1618
            // c:showVal
1619 6
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1620
1621
            // c:showCatName
1622 6
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1623
1624
            // c:showSerName
1625 6
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1626
1627
            // c:showPercent
1628 6
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1629
1630
            // c:showLeaderLines
1631 6
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1632
1633
            // > c:dLbls
1634 6
            $objWriter->endElement();
1635
1636
            // c:spPr
1637 6
            $objWriter->startElement('c:spPr');
1638
            // Write fill
1639 6
            $this->writeFill($objWriter, $series->getFill());
1640
            // Write outline
1641 6
            $this->writeOutline($objWriter, $series->getOutline());
1642
            // ## c:spPr
1643 6
            $objWriter->endElement();
1644
1645
            // Write X axis data
1646 6
            $axisXData = array_keys($series->getValues());
1647
1648
            // c:cat
1649 6
            $objWriter->startElement('c:cat');
1650 6
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1651 6
            $objWriter->endElement();
1652
1653
            // Write Y axis data
1654 6
            $axisYData = array_values($series->getValues());
1655
1656
            // c:val
1657 6
            $objWriter->startElement('c:val');
1658 6
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1659 6
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1660 6
            $objWriter->endElement();
1661
1662 6
            $objWriter->endElement();
1663
1664 6
            ++$seriesIndex;
1665
        }
1666
1667
        // c:marker
1668 7
        $objWriter->startElement('c:marker');
1669 7
        $objWriter->writeAttribute('val', '1');
1670 7
        $objWriter->endElement();
1671
1672
        // c:smooth
1673 7
        $objWriter->startElement('c:smooth');
1674 7
        $objWriter->writeAttribute('val', '0');
1675 7
        $objWriter->endElement();
1676
1677
        // c:axId
1678 7
        $objWriter->startElement('c:axId');
1679 7
        $objWriter->writeAttribute('val', '52743552');
1680 7
        $objWriter->endElement();
1681
1682
        // c:axId
1683 7
        $objWriter->startElement('c:axId');
1684 7
        $objWriter->writeAttribute('val', '52749440');
1685 7
        $objWriter->endElement();
1686
1687 7
        $objWriter->endElement();
1688 7
    }
1689
1690
    /**
1691
     * Write Type Scatter
1692
     *
1693
     * @param  \PhpOffice\Common\XMLWriter         $objWriter    XML Writer
1694
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Scatter $subject
1695
     * @param  boolean                                $includeSheet
1696
     * @throws \Exception
1697
     */
1698 5
    protected function writeTypeScatter(XMLWriter $objWriter, Scatter $subject, $includeSheet = false)
1699
    {
1700
        // c:scatterChart
1701 5
        $objWriter->startElement('c:scatterChart');
1702
1703
        // c:scatterStyle
1704 5
        $objWriter->startElement('c:scatterStyle');
1705 5
        $objWriter->writeAttribute('val', 'lineMarker');
1706 5
        $objWriter->endElement();
1707
1708
        // c:varyColors
1709 5
        $objWriter->startElement('c:varyColors');
1710 5
        $objWriter->writeAttribute('val', '0');
1711 5
        $objWriter->endElement();
1712
1713
        // Write series
1714 5
        $seriesIndex = 0;
1715 5
        foreach ($subject->getSeries() as $series) {
1716
            // c:ser
1717 5
            $objWriter->startElement('c:ser');
1718
1719
            // c:idx
1720 5
            $objWriter->startElement('c:idx');
1721 5
            $objWriter->writeAttribute('val', $seriesIndex);
1722 5
            $objWriter->endElement();
1723
1724
            // c:order
1725 5
            $objWriter->startElement('c:order');
1726 5
            $objWriter->writeAttribute('val', $seriesIndex);
1727 5
            $objWriter->endElement();
1728
1729
            // c:tx
1730 5
            $objWriter->startElement('c:tx');
1731 5
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1732 5
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1733 5
            $objWriter->endElement();
1734
1735
            // Marker
1736 5
            $this->writeSeriesMarker($objWriter, $series->getMarker());
1737
1738
            // c:dLbls
1739 5
            $objWriter->startElement('c:dLbls');
1740
1741
            // c:txPr
1742 5
            $objWriter->startElement('c:txPr');
1743
1744
            // a:bodyPr
1745 5
            $objWriter->writeElement('a:bodyPr', null);
1746
1747
            // a:lstStyle
1748 5
            $objWriter->writeElement('a:lstStyle', null);
1749
1750
            // a:p
1751 5
            $objWriter->startElement('a:p');
1752
1753
            // a:pPr
1754 5
            $objWriter->startElement('a:pPr');
1755
1756
            // a:defRPr
1757 5
            $objWriter->startElement('a:defRPr');
1758
1759 5
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1760 5
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1761 5
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1762 5
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1763 5
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1764 5
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1765 5
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1766
1767
            // Font - a:solidFill
1768 5
            $objWriter->startElement('a:solidFill');
1769
1770 5
            $this->writeColor($objWriter, $series->getFont()->getColor());
1771
1772 5
            $objWriter->endElement();
1773
1774
            // Font - a:latin
1775 5
            $objWriter->startElement('a:latin');
1776 5
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1777 5
            $objWriter->endElement();
1778
1779 5
            $objWriter->endElement();
1780
1781 5
            $objWriter->endElement();
1782
1783
            // a:endParaRPr
1784 5
            $objWriter->startElement('a:endParaRPr');
1785 5
            $objWriter->writeAttribute('lang', 'en-US');
1786 5
            $objWriter->writeAttribute('dirty', '0');
1787 5
            $objWriter->endElement();
1788
1789 5
            $objWriter->endElement();
1790
1791 5
            $objWriter->endElement();
1792
1793
            // c:showLegendKey
1794 5
            $this->writeElementWithValAttribute($objWriter, 'c:showLegendKey', '0');
1795
1796
            // c:showVal
1797 5
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1798
1799
            // c:showCatName
1800 5
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1801
1802
            // c:showSerName
1803 5
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1804
1805
            // c:showPercent
1806 5
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1807
1808
            // c:showLeaderLines
1809 5
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1810
1811 5
            $objWriter->endElement();
1812
1813
            // c:spPr
1814 5
            $objWriter->startElement('c:spPr');
1815
            // Write fill
1816 5
            $this->writeFill($objWriter, $series->getFill());
1817
            // Write outline
1818 5
            $this->writeOutline($objWriter, $series->getOutline());
1819
            // ## c:spPr
1820 5
            $objWriter->endElement();
1821
1822
            // Write X axis data
1823 5
            $axisXData = array_keys($series->getValues());
1824
1825
            // c:xVal
1826 5
            $objWriter->startElement('c:xVal');
1827 5
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1828 5
            $objWriter->endElement();
1829
1830
            // Write Y axis data
1831 5
            $axisYData = array_values($series->getValues());
1832
1833
            // c:yVal
1834 5
            $objWriter->startElement('c:yVal');
1835 5
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1836 5
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1837 5
            $objWriter->endElement();
1838
1839
            // c:smooth
1840 5
            $objWriter->startElement('c:smooth');
1841 5
            $objWriter->writeAttribute('val', '0');
1842 5
            $objWriter->endElement();
1843
1844 5
            $objWriter->endElement();
1845
1846 5
            ++$seriesIndex;
1847
        }
1848
1849
        // c:axId
1850 5
        $objWriter->startElement('c:axId');
1851 5
        $objWriter->writeAttribute('val', '52743552');
1852 5
        $objWriter->endElement();
1853
1854
        // c:axId
1855 5
        $objWriter->startElement('c:axId');
1856 5
        $objWriter->writeAttribute('val', '52749440');
1857 5
        $objWriter->endElement();
1858
1859 5
        $objWriter->endElement();
1860 5
    }
1861
    /**
1862
     * Write chart relationships to XML format
1863
     *
1864
     * @param  \PhpOffice\PhpPresentation\Shape\Chart $pChart
1865
     * @return string                    XML Output
1866
     * @throws \Exception
1867
     */
1868
    public function writeChartRelationships(Chart $pChart)
1869
    {
1870
        // Create XML writer
1871
        $objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
1872
1873
        // XML header
1874
        $objWriter->startDocument('1.0', 'UTF-8', 'yes');
1875
1876
        // Relationships
1877
        $objWriter->startElement('Relationships');
1878
        $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/package/2006/relationships');
1879
1880
        // Write spreadsheet relationship?
1881
        if ($pChart->hasIncludedSpreadsheet()) {
1882
            $this->writeRelationship($objWriter, 1, 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/package', '../embeddings/' . $pChart->getIndexedFilename() . '.xlsx');
1883
        }
1884
1885
        $objWriter->endElement();
1886
1887
        // Return
1888
        return $objWriter->getData();
1889
    }
1890
1891
    /**
1892
     * @param XMLWriter $objWriter
1893
     * @param Chart\Marker $oMarker
1894
     */
1895 11
    protected function writeSeriesMarker(XMLWriter $objWriter, Chart\Marker $oMarker)
1896
    {
1897 11
        if ($oMarker->getSymbol() != Chart\Marker::SYMBOL_NONE) {
1898 2
            $markerSize = (int)$oMarker->getSize();
1899 2
            if ($markerSize < 2) {
1900 2
                $markerSize = 2;
1901
            }
1902 2
            if ($markerSize > 72) {
1903 2
                $markerSize = 72;
1904
            }
1905
1906
            // c:marker
1907 2
            $objWriter->startElement('c:marker');
1908
1909
            // c:marker > c:symbol
1910 2
            $objWriter->startElement('c:symbol');
1911 2
            $objWriter->writeAttribute('val', $oMarker->getSymbol());
1912 2
            $objWriter->endElement();
1913
            /**
1914
             * c:marker > c:size
1915
             * Size in points
1916
             * @link : https://msdn.microsoft.com/en-us/library/hh658135(v=office.12).aspx
1917
             */
1918 2
            $objWriter->startElement('c:size');
1919 2
            $objWriter->writeAttribute('val', $markerSize);
1920 2
            $objWriter->endElement();
1921
1922 2
            $objWriter->endElement();
1923
        }
1924 11
    }
1925
1926
    /**
1927
     * @param XMLWriter $objWriter
1928
     * @param Chart\Axis $oAxis
1929
     * @param $typeAxis
1930
     * @param Chart\Type\AbstractType $typeChart
1931
     */
1932 19
    protected function writeAxis(XMLWriter $objWriter, Chart\Axis $oAxis, $typeAxis, Chart\Type\AbstractType $typeChart)
1933
    {
1934 19
        if ($typeAxis != Chart\Axis::AXIS_X && $typeAxis != Chart\Axis::AXIS_Y) {
1935
            return;
1936
        }
1937
1938 19
        if ($typeAxis == Chart\Axis::AXIS_X) {
1939 19
            $mainElement = 'c:catAx';
1940 19
            $axIdVal = '52743552';
1941 19
            $axPosVal = 'b';
1942 19
            $crossAxVal = '52749440';
1943
        } else {
1944 19
            $mainElement = 'c:valAx';
1945 19
            $axIdVal = '52749440';
1946 19
            $axPosVal = 'l';
1947 19
            $crossAxVal = '52743552';
1948
        }
1949
1950
        // $mainElement
1951 19
        $objWriter->startElement($mainElement);
1952
1953
        // $mainElement > c:axId
1954 19
        $objWriter->startElement('c:axId');
1955 19
        $objWriter->writeAttribute('val', $axIdVal);
1956 19
        $objWriter->endElement();
1957
1958
        // $mainElement > c:scaling
1959 19
        $objWriter->startElement('c:scaling');
1960
1961
        // $mainElement > c:scaling > c:orientation
1962 19
        $objWriter->startElement('c:orientation');
1963 19
        $objWriter->writeAttribute('val', 'minMax');
1964 19
        $objWriter->endElement();
1965
1966
        // $mainElement > ##c:scaling
1967 19
        $objWriter->endElement();
1968
1969
        // $mainElement > c:axPos
1970 19
        $objWriter->startElement('c:axPos');
1971 19
        $objWriter->writeAttribute('val', $axPosVal);
1972 19
        $objWriter->endElement();
1973
1974 19
        $oMajorGridlines = $oAxis->getMajorGridlines();
1975 19
        if ($oMajorGridlines instanceof Gridlines) {
1976 1
            $objWriter->startElement('c:majorGridlines');
1977
1978 1
            $this->writeAxisGridlines($objWriter, $oMajorGridlines);
1979
1980 1
            $objWriter->endElement();
1981
        }
1982
1983 19
        $oMinorGridlines = $oAxis->getMinorGridlines();
1984 19
        if ($oMinorGridlines instanceof Gridlines) {
1985 1
            $objWriter->startElement('c:minorGridlines');
1986
1987 1
            $this->writeAxisGridlines($objWriter, $oMinorGridlines);
1988
1989 1
            $objWriter->endElement();
1990
        }
1991
1992
        // c:numFmt
1993 19
        $objWriter->startElement('c:numFmt');
1994 19
        $objWriter->writeAttribute('formatCode', $oAxis->getFormatCode());
1995 19
        $objWriter->writeAttribute('sourceLinked', '1');
1996 19
        $objWriter->endElement();
1997
1998
        // c:majorTickMark
1999 19
        $objWriter->startElement('c:majorTickMark');
2000 19
        $objWriter->writeAttribute('val', 'none');
2001 19
        $objWriter->endElement();
2002
2003
        // c:tickLblPos
2004 19
        $objWriter->startElement('c:tickLblPos');
2005 19
        $objWriter->writeAttribute('val', 'nextTo');
2006 19
        $objWriter->endElement();
2007
2008
        // c:txPr
2009 19
        $objWriter->startElement('c:txPr');
2010
2011
        // a:bodyPr
2012 19
        $objWriter->writeElement('a:bodyPr', null);
2013
2014
        // a:lstStyle
2015 19
        $objWriter->writeElement('a:lstStyle', null);
2016
2017
        // a:p
2018 19
        $objWriter->startElement('a:p');
2019
2020
        // a:pPr
2021 19
        $objWriter->startElement('a:pPr');
2022
2023
        // a:defRPr
2024 19
        $objWriter->startElement('a:defRPr');
2025
2026 19
        $objWriter->writeAttribute('b', ($oAxis->getFont()->isBold() ? 'true' : 'false'));
2027 19
        $objWriter->writeAttribute('i', ($oAxis->getFont()->isItalic() ? 'true' : 'false'));
2028 19
        $objWriter->writeAttribute('strike', ($oAxis->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
2029 19
        $objWriter->writeAttribute('sz', ($oAxis->getFont()->getSize() * 100));
2030 19
        $objWriter->writeAttribute('u', $oAxis->getFont()->getUnderline());
2031 19
        $objWriter->writeAttributeIf($oAxis->getFont()->isSuperScript(), 'baseline', '30000');
2032 19
        $objWriter->writeAttributeIf($oAxis->getFont()->isSubScript(), 'baseline', '-25000');
2033
2034
        // Font - a:solidFill
2035 19
        $objWriter->startElement('a:solidFill');
2036
2037 19
        $this->writeColor($objWriter, $oAxis->getFont()->getColor());
2038
2039 19
        $objWriter->endElement();
2040
2041
        // Font - a:latin
2042 19
        $objWriter->startElement('a:latin');
2043 19
        $objWriter->writeAttribute('typeface', $oAxis->getFont()->getName());
2044 19
        $objWriter->endElement();
2045
2046 19
        $objWriter->endElement();
2047
2048
        // ## a:pPr
2049 19
        $objWriter->endElement();
2050
2051
        // a:r
2052 19
        $objWriter->startElement('a:r');
2053
2054
        // a:rPr
2055 19
        $objWriter->startElement('a:rPr');
2056 19
        $objWriter->writeAttribute('lang', 'en-US');
2057 19
        $objWriter->writeAttribute('dirty', '0');
2058 19
        $objWriter->endElement();
2059
2060
        // a:t
2061 19
        $objWriter->writeElement('a:t', $oAxis->getTitle());
2062
2063
        // ## a:r
2064 19
        $objWriter->endElement();
2065
2066
        // a:endParaRPr
2067 19
        $objWriter->startElement('a:endParaRPr');
2068 19
        $objWriter->writeAttribute('lang', 'en-US');
2069 19
        $objWriter->writeAttribute('dirty', '0');
2070 19
        $objWriter->endElement();
2071
2072
        // ## a:p
2073 19
        $objWriter->endElement();
2074
2075
        // ## c:txPr
2076 19
        $objWriter->endElement();
2077
2078
        // c:crossAx
2079 19
        $objWriter->startElement('c:crossAx');
2080 19
        $objWriter->writeAttribute('val', $crossAxVal);
2081 19
        $objWriter->endElement();
2082
2083
        // c:crosses
2084 19
        $objWriter->startElement('c:crosses');
2085 19
        $objWriter->writeAttribute('val', 'autoZero');
2086 19
        $objWriter->endElement();
2087
2088 19
        if ($typeAxis == Chart\Axis::AXIS_X) {
2089
            // c:lblAlgn
2090 19
            $objWriter->startElement('c:lblAlgn');
2091 19
            $objWriter->writeAttribute('val', 'ctr');
2092 19
            $objWriter->endElement();
2093
2094
            // c:lblOffset
2095 19
            $objWriter->startElement('c:lblOffset');
2096 19
            $objWriter->writeAttribute('val', '100');
2097 19
            $objWriter->endElement();
2098
        }
2099
2100 19
        if ($typeAxis == Chart\Axis::AXIS_Y) {
2101
            // c:crossBetween
2102 19
            $objWriter->startElement('c:crossBetween');
2103
            // midCat : Position Axis On Tick Marks
2104
            // between : Between Tick Marks
2105 19
            if ($typeChart instanceof Area) {
2106 1
                $objWriter->writeAttribute('val', 'midCat');
2107
            } else {
2108 18
                $objWriter->writeAttribute('val', 'between');
2109
            }
2110 19
            $objWriter->endElement();
2111
        }
2112
2113 19
        $objWriter->endElement();
2114 19
    }
2115
2116
    /**
2117
     * @param XMLWriter $objWriter
2118
     * @param Gridlines $oGridlines
2119
     */
2120 1
    protected function writeAxisGridlines(XMLWriter $objWriter, Gridlines $oGridlines)
2121
    {
2122
        // c:spPr
2123 1
        $objWriter->startElement('c:spPr');
2124
2125
        // Outline
2126 1
        $this->writeOutline($objWriter, $oGridlines->getOutline());
2127
2128
        // ##c:spPr
2129 1
        $objWriter->endElement();
2130 1
    }
2131
}
2132