Completed
Pull Request — develop (#335)
by Franck
12:56 queued 03:02
created

PptCharts::writeTypeLine()   C

Complexity

Conditions 12
Paths 5

Size

Total Lines 161
Code Lines 81

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 83
CRAP Score 12

Importance

Changes 0
Metric Value
dl 0
loc 161
ccs 83
cts 83
cp 1
rs 5.034
c 0
b 0
f 0
cc 12
eloc 81
nc 5
nop 3
crap 12

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\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 104
    public function render()
30
    {
31 104
        for ($i = 0; $i < $this->getDrawingHashTable()->count(); ++$i) {
32 35
            $shape = $this->getDrawingHashTable()->getByIndex($i);
33 35
            if ($shape instanceof Chart) {
34 27
                $this->getZip()->addFromString('ppt/charts/' . $shape->getIndexedFilename(), $this->writeChart($shape));
35
36 26
                if ($shape->hasIncludedSpreadsheet()) {
37
                    $this->getZip()->addFromString('ppt/charts/_rels/' . $shape->getIndexedFilename() . '.rels', $this->writeChartRelationships($shape));
38
                    $pFilename = tempnam(sys_get_temp_dir(), 'PHPExcel');
39
                    $this->getZip()->addFromString('ppt/embeddings/' . $shape->getIndexedFilename() . '.xlsx', $this->writeSpreadsheet($this->getPresentation(), $shape, $pFilename . '.xlsx'));
40
                }
41 26
            }
42 34
        }
43 103
        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 27
    public function writeChart(Chart $chart)
55
    {
56
        // Create XML writer
57 27
        $objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
58
59
        // XML header
60 27
        $objWriter->startDocument('1.0', 'UTF-8', 'yes');
61
62
        // c:chartSpace
63 27
        $objWriter->startElement('c:chartSpace');
64 27
        $objWriter->writeAttribute('xmlns:c', 'http://schemas.openxmlformats.org/drawingml/2006/chart');
65 27
        $objWriter->writeAttribute('xmlns:a', 'http://schemas.openxmlformats.org/drawingml/2006/main');
66 27
        $objWriter->writeAttribute('xmlns:r', 'http://schemas.openxmlformats.org/officeDocument/2006/relationships');
67
68
        // c:date1904
69 27
        $objWriter->startElement('c:date1904');
70 27
        $objWriter->writeAttribute('val', '1');
71 27
        $objWriter->endElement();
72
73
        // c:lang
74 27
        $objWriter->startElement('c:lang');
75 27
        $objWriter->writeAttribute('val', 'en-US');
76 27
        $objWriter->endElement();
77
78
        // c:chart
79 27
        $objWriter->startElement('c:chart');
80
81
        // Title?
82 27
        if ($chart->getTitle()->isVisible()) {
83
            // Write title
84 26
            $this->writeTitle($objWriter, $chart->getTitle());
85 26
        }
86
87
        // c:autoTitleDeleted
88 27
        $objWriter->startElement('c:autoTitleDeleted');
89 27
        $objWriter->writeAttribute('val', $chart->getTitle()->isVisible() ? '0' : '1');
90 27
        $objWriter->endElement();
91
92
        // c:view3D
93 27
        $objWriter->startElement('c:view3D');
94
95
        // c:rotX
96 27
        $objWriter->startElement('c:rotX');
97 27
        $objWriter->writeAttribute('val', $chart->getView3D()->getRotationX());
98 27
        $objWriter->endElement();
99
100
        // c:hPercent
101 27
        $objWriter->startElement('c:hPercent');
102 27
        $objWriter->writeAttribute('val', $chart->getView3D()->getHeightPercent());
103 27
        $objWriter->endElement();
104
105
        // c:rotY
106 27
        $objWriter->startElement('c:rotY');
107 27
        $objWriter->writeAttribute('val', $chart->getView3D()->getRotationY());
108 27
        $objWriter->endElement();
109
110
        // c:depthPercent
111 27
        $objWriter->startElement('c:depthPercent');
112 27
        $objWriter->writeAttribute('val', $chart->getView3D()->getDepthPercent());
113 27
        $objWriter->endElement();
114
115
        // c:rAngAx
116 27
        $objWriter->startElement('c:rAngAx');
117 27
        $objWriter->writeAttribute('val', $chart->getView3D()->hasRightAngleAxes() ? '1' : '0');
118 27
        $objWriter->endElement();
119
120
        // c:perspective
121 27
        $objWriter->startElement('c:perspective');
122 27
        $objWriter->writeAttribute('val', $chart->getView3D()->getPerspective());
123 27
        $objWriter->endElement();
124
125 27
        $objWriter->endElement();
126
127
        // Write plot area
128 27
        $this->writePlotArea($objWriter, $chart->getPlotArea(), $chart);
129
130
        // Legend?
131 26
        if ($chart->getLegend()->isVisible()) {
132
            // Write legend
133 26
            $this->writeLegend($objWriter, $chart->getLegend());
134 26
        }
135
136
        // c:plotVisOnly
137 26
        $objWriter->startElement('c:plotVisOnly');
138 26
        $objWriter->writeAttribute('val', '1');
139 26
        $objWriter->endElement();
140
141 26
        $objWriter->endElement();
142
143
        // c:spPr
144 26
        $objWriter->startElement('c:spPr');
145
146
        // Fill
147 26
        $this->writeFill($objWriter, $chart->getFill());
148
149
        // Border
150 26
        if ($chart->getBorder()->getLineStyle() != Border::LINE_NONE) {
151
            $this->writeBorder($objWriter, $chart->getBorder(), '');
152
        }
153
154
        // Shadow
155 26
        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 26
        $objWriter->endElement();
175
176
        // External data?
177 26
        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 26
        $objWriter->endElement();
191
192
        // Return
193 26
        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 24
    protected function writeElementWithValAttribute($objWriter, $elementName, $value)
275
    {
276 24
        $objWriter->startElement($elementName);
277 24
        $objWriter->writeAttribute('val', $value);
278 24
        $objWriter->endElement();
279 24
    }
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 24
    protected function writeSingleValueOrReference($objWriter, $isReference, $value, $reference)
290
    {
291 24
        if (!$isReference) {
292
            // Value
293 24
            $objWriter->writeElement('c:v', $value);
294 24
            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 24
    protected function writeMultipleValuesOrReference($objWriter, $isReference, $values, $reference)
322
    {
323
        // c:strLit / c:numLit
324
        // c:strRef / c:numRef
325 24
        $referenceType = ($isReference ? 'Ref' : 'Lit');
326 24
        $dataType = 'str';
327 24
        if (is_int($values[0]) || is_float($values[0])) {
328 24
            $dataType = 'num';
329 24
        }
330 24
        $objWriter->startElement('c:' . $dataType . $referenceType);
331
332 24
        $numValues = count($values);
333 24
        if (!$isReference) {
334
            // Value
335
336
            // c:ptCount
337 24
            $objWriter->startElement('c:ptCount');
338 24
            $objWriter->writeAttribute('val', count($values));
339 24
            $objWriter->endElement();
340
341
            // Add points
342 24
            for ($i = 0; $i < $numValues; $i++) {
343
                // c:pt
344 24
                $objWriter->startElement('c:pt');
345 24
                $objWriter->writeAttribute('idx', $i);
346 24
                $objWriter->writeElement('c:v', $values[$i]);
347 24
                $objWriter->endElement();
348 24
            }
349 24
        } 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 24
        $objWriter->endElement();
372 24
    }
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 26
    protected function writeTitle(XMLWriter $objWriter, Title $subject)
382
    {
383
        // c:title
384 26
        $objWriter->startElement('c:title');
385
386
        // c:tx
387 26
        $objWriter->startElement('c:tx');
388
389
        // c:rich
390 26
        $objWriter->startElement('c:rich');
391
392
        // a:bodyPr
393 26
        $objWriter->writeElement('a:bodyPr', null);
394
395
        // a:lstStyle
396 26
        $objWriter->writeElement('a:lstStyle', null);
397
398
        // a:p
399 26
        $objWriter->startElement('a:p');
400
401
        // a:pPr
402 26
        $objWriter->startElement('a:pPr');
403 26
        $objWriter->writeAttribute('algn', $subject->getAlignment()->getHorizontal());
404 26
        $objWriter->writeAttribute('fontAlgn', $subject->getAlignment()->getVertical());
405 26
        $objWriter->writeAttribute('marL', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginLeft()));
406 26
        $objWriter->writeAttribute('marR', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginRight()));
407 26
        $objWriter->writeAttribute('indent', CommonDrawing::pixelsToEmu($subject->getAlignment()->getIndent()));
408 26
        $objWriter->writeAttribute('lvl', $subject->getAlignment()->getLevel());
409
410
        // a:defRPr
411 26
        $objWriter->writeElement('a:defRPr', null);
412
413 26
        $objWriter->endElement();
414
415
        // a:r
416 26
        $objWriter->startElement('a:r');
417
418
        // a:rPr
419 26
        $objWriter->startElement('a:rPr');
420 26
        $objWriter->writeAttribute('lang', 'en-US');
421 26
        $objWriter->writeAttribute('dirty', '0');
422
423 26
        $objWriter->writeAttribute('b', ($subject->getFont()->isBold() ? 'true' : 'false'));
424 26
        $objWriter->writeAttribute('i', ($subject->getFont()->isItalic() ? 'true' : 'false'));
425 26
        $objWriter->writeAttribute('strike', ($subject->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
426 26
        $objWriter->writeAttribute('sz', ($subject->getFont()->getSize() * 100));
427 26
        $objWriter->writeAttribute('u', $subject->getFont()->getUnderline());
428 26
        $objWriter->writeAttributeIf($subject->getFont()->isSuperScript(), 'baseline', '30000');
429 26
        $objWriter->writeAttributeIf($subject->getFont()->isSubScript(), 'baseline', '-25000');
430
431
        // Font - a:solidFill
432 26
        $objWriter->startElement('a:solidFill');
433
434 26
        $this->writeColor($objWriter, $subject->getFont()->getColor());
435
436 26
        $objWriter->endElement();
437
438
        // Font - a:latin
439 26
        $objWriter->startElement('a:latin');
440 26
        $objWriter->writeAttribute('typeface', $subject->getFont()->getName());
441 26
        $objWriter->endElement();
442
443 26
        $objWriter->endElement();
444
445
        // a:t
446 26
        $objWriter->writeElement('a:t', $subject->getText());
447
448 26
        $objWriter->endElement();
449
450
        // a:endParaRPr
451 26
        $objWriter->startElement('a:endParaRPr');
452 26
        $objWriter->writeAttribute('lang', 'en-US');
453 26
        $objWriter->writeAttribute('dirty', '0');
454 26
        $objWriter->endElement();
455
456 26
        $objWriter->endElement();
457
458 26
        $objWriter->endElement();
459
460 26
        $objWriter->endElement();
461
462
        // Write layout
463 26
        $this->writeLayout($objWriter, $subject);
464
465
        // c:overlay
466 26
        $objWriter->startElement('c:overlay');
467 26
        $objWriter->writeAttribute('val', '0');
468 26
        $objWriter->endElement();
469
470 26
        $objWriter->endElement();
471 26
    }
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 27
    protected function writePlotArea(XMLWriter $objWriter, PlotArea $subject, Chart $chart)
482
    {
483
        // c:plotArea
484 27
        $objWriter->startElement('c:plotArea');
485
486
        // Write layout
487 27
        $this->writeLayout($objWriter, $subject);
488
489
        // Write chart
490 27
        $chartType = $subject->getType();
491 27
        if ($chartType instanceof Area) {
492 1
            $this->writeTypeArea($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
493 27
        } elseif ($chartType instanceof Bar) {
494 2
            $this->writeTypeBar($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
495 26
        } elseif ($chartType instanceof Bar3D) {
496 4
            $this->writeTypeBar3D($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
497 24
        } elseif ($chartType instanceof Pie) {
498 1
            $this->writeTypePie($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
499 20
        } elseif ($chartType instanceof Pie3D) {
500 4
            $this->writeTypePie3D($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
501 19
        } elseif ($chartType instanceof Line) {
502 9
            $this->writeTypeLine($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
503 15
        } elseif ($chartType instanceof Scatter) {
504 5
            $this->writeTypeScatter($objWriter, $chartType, $chart->hasIncludedSpreadsheet());
505 5
        } else {
506 1
            throw new \Exception('The chart type provided could not be rendered.');
507
        }
508
509
        // Write X axis?
510 26
        if ($chartType->hasAxisX()) {
511 21
            $this->writeAxis($objWriter, $subject->getAxisX(), Chart\Axis::AXIS_X, $chartType);
512 21
        }
513
514
        // Write Y axis?
515 26
        if ($chartType->hasAxisY()) {
516 21
            $this->writeAxis($objWriter, $subject->getAxisY(), Chart\Axis::AXIS_Y, $chartType);
517 21
        }
518
519 26
        $objWriter->endElement();
520 26
    }
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 26
    protected function writeLegend(XMLWriter $objWriter, Legend $subject)
530
    {
531
        // c:legend
532 26
        $objWriter->startElement('c:legend');
533
534
        // c:legendPos
535 26
        $objWriter->startElement('c:legendPos');
536 26
        $objWriter->writeAttribute('val', $subject->getPosition());
537 26
        $objWriter->endElement();
538
539
        // Write layout
540 26
        $this->writeLayout($objWriter, $subject);
541
542
        // c:overlay
543 26
        $objWriter->startElement('c:overlay');
544 26
        $objWriter->writeAttribute('val', '0');
545 26
        $objWriter->endElement();
546
547
        // c:spPr
548 26
        $objWriter->startElement('c:spPr');
549
550
        // Fill
551 26
        $this->writeFill($objWriter, $subject->getFill());
552
553
        // Border
554 26
        if ($subject->getBorder()->getLineStyle() != Border::LINE_NONE) {
555 26
            $this->writeBorder($objWriter, $subject->getBorder(), '');
556 26
        }
557
558 26
        $objWriter->endElement();
559
560
        // c:txPr
561 26
        $objWriter->startElement('c:txPr');
562
563
        // a:bodyPr
564 26
        $objWriter->writeElement('a:bodyPr', null);
565
566
        // a:lstStyle
567 26
        $objWriter->writeElement('a:lstStyle', null);
568
569
        // a:p
570 26
        $objWriter->startElement('a:p');
571
572
        // a:pPr
573 26
        $objWriter->startElement('a:pPr');
574 26
        $objWriter->writeAttribute('algn', $subject->getAlignment()->getHorizontal());
575 26
        $objWriter->writeAttribute('fontAlgn', $subject->getAlignment()->getVertical());
576 26
        $objWriter->writeAttribute('marL', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginLeft()));
577 26
        $objWriter->writeAttribute('marR', CommonDrawing::pixelsToEmu($subject->getAlignment()->getMarginRight()));
578 26
        $objWriter->writeAttribute('indent', CommonDrawing::pixelsToEmu($subject->getAlignment()->getIndent()));
579 26
        $objWriter->writeAttribute('lvl', $subject->getAlignment()->getLevel());
580
581
        // a:defRPr
582 26
        $objWriter->startElement('a:defRPr');
583
584 26
        $objWriter->writeAttribute('b', ($subject->getFont()->isBold() ? 'true' : 'false'));
585 26
        $objWriter->writeAttribute('i', ($subject->getFont()->isItalic() ? 'true' : 'false'));
586 26
        $objWriter->writeAttribute('strike', ($subject->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
587 26
        $objWriter->writeAttribute('sz', ($subject->getFont()->getSize() * 100));
588 26
        $objWriter->writeAttribute('u', $subject->getFont()->getUnderline());
589 26
        $objWriter->writeAttributeIf($subject->getFont()->isSuperScript(), 'baseline', '30000');
590 26
        $objWriter->writeAttributeIf($subject->getFont()->isSubScript(), 'baseline', '-25000');
591
592
        // Font - a:solidFill
593 26
        $objWriter->startElement('a:solidFill');
594
595 26
        $this->writeColor($objWriter, $subject->getFont()->getColor());
596
597 26
        $objWriter->endElement();
598
599
        // Font - a:latin
600 26
        $objWriter->startElement('a:latin');
601 26
        $objWriter->writeAttribute('typeface', $subject->getFont()->getName());
602 26
        $objWriter->endElement();
603
604 26
        $objWriter->endElement();
605
606 26
        $objWriter->endElement();
607
608
        // a:endParaRPr
609 26
        $objWriter->startElement('a:endParaRPr');
610 26
        $objWriter->writeAttribute('lang', 'en-US');
611 26
        $objWriter->writeAttribute('dirty', '0');
612 26
        $objWriter->endElement();
613
614 26
        $objWriter->endElement();
615
616 26
        $objWriter->endElement();
617
618 26
        $objWriter->endElement();
619 26
    }
620
621
    /**
622
     * Write Layout
623
     *
624
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
625
     * @param  mixed $subject
626
     * @throws \Exception
627
     */
628 27
    protected function writeLayout(XMLWriter $objWriter, $subject)
629
    {
630
        // c:layout
631 27
        $objWriter->startElement('c:layout');
632
633
        // c:manualLayout
634 27
        $objWriter->startElement('c:manualLayout');
635
        // c:xMode
636 27
        $objWriter->startElement('c:xMode');
637 27
        $objWriter->writeAttribute('val', 'edge');
638 27
        $objWriter->endElement();
639
640
        // c:yMode
641 27
        $objWriter->startElement('c:yMode');
642 27
        $objWriter->writeAttribute('val', 'edge');
643 27
        $objWriter->endElement();
644
645 27
        if ($subject->getOffsetX() != 0) {
646
            // c:x
647 26
            $objWriter->startElement('c:x');
648 26
            $objWriter->writeAttribute('val', $subject->getOffsetX());
649 26
            $objWriter->endElement();
650 26
        }
651
652 27
        if ($subject->getOffsetY() != 0) {
653
            // c:y
654 26
            $objWriter->startElement('c:y');
655 26
            $objWriter->writeAttribute('val', $subject->getOffsetY());
656 26
            $objWriter->endElement();
657 26
        }
658
659 27
        if ($subject->getWidth() != 0) {
660
            // c:w
661
            $objWriter->startElement('c:w');
662
            $objWriter->writeAttribute('val', $subject->getWidth());
663
            $objWriter->endElement();
664
        }
665
666 27
        if ($subject->getHeight() != 0) {
667
            // c:h
668
            $objWriter->startElement('c:h');
669
            $objWriter->writeAttribute('val', $subject->getHeight());
670
            $objWriter->endElement();
671
        }
672
673 27
        $objWriter->endElement();
674 27
        $objWriter->endElement();
675 27
    }
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 1
        }
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 1
                }
842
843
                // ## c:dPt
844 1
                $objWriter->endElement();
845 2
            }
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:dLblPos
911 2
            $this->writeElementWithValAttribute($objWriter, 'c:dLblPos', $series->getLabelPosition());
912
913
            // c:showVal
914 2
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
915
916
            // c:showCatName
917 2
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
918
919
            // c:showSerName
920 2
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
921
922
            // c:showPercent
923 2
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
924
925
            // c:showLeaderLines
926 2
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
927
928 2
            $objWriter->endElement();
929
930
            // c:spPr
931 2
            if ($series->getFill()->getFillType() != Fill::FILL_NONE) {
932
                // c:spPr
933
                $objWriter->startElement('c:spPr');
934
                // Write fill
935
                $this->writeFill($objWriter, $series->getFill());
936
                // ## c:spPr
937
                $objWriter->endElement();
938
            }
939
940
            // Write X axis data
941 2
            $axisXData = array_keys($series->getValues());
942
943
            // c:cat
944 2
            $objWriter->startElement('c:cat');
945 2
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
946 2
            $objWriter->endElement();
947
948
            // Write Y axis data
949 2
            $axisYData = array_values($series->getValues());
950
951
            // c:val
952 2
            $objWriter->startElement('c:val');
953 2
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
954 2
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
955 2
            $objWriter->endElement();
956
957 2
            $objWriter->endElement();
958
959 2
            ++$seriesIndex;
960 2
        }
961
962
        // c:overlap
963 2
        $objWriter->startElement('c:overlap');
964 2
        if ($subject->getBarGrouping() == Bar::GROUPING_CLUSTERED) {
965 2
            $objWriter->writeAttribute('val', '0');
966 2
        } elseif ($subject->getBarGrouping() == Bar::GROUPING_STACKED || $subject->getBarGrouping() == Bar::GROUPING_PERCENTSTACKED) {
967
            $objWriter->writeAttribute('val', '100');
968
        }
969 2
        $objWriter->endElement();
970
971
        // c:gapWidth
972 2
        $objWriter->startElement('c:gapWidth');
973 2
        $objWriter->writeAttribute('val', '75');
974 2
        $objWriter->endElement();
975
976
        // c:shape
977 2
        $objWriter->startElement('c:shape');
978 2
        $objWriter->writeAttribute('val', 'box');
979 2
        $objWriter->endElement();
980
981
        // c:axId
982 2
        $objWriter->startElement('c:axId');
983 2
        $objWriter->writeAttribute('val', '52743552');
984 2
        $objWriter->endElement();
985
986
        // c:axId
987 2
        $objWriter->startElement('c:axId');
988 2
        $objWriter->writeAttribute('val', '52749440');
989 2
        $objWriter->endElement();
990
991
        // c:axId
992 2
        $objWriter->startElement('c:axId');
993 2
        $objWriter->writeAttribute('val', '0');
994 2
        $objWriter->endElement();
995
996 2
        $objWriter->endElement();
997 2
    }
998
999
    /**
1000
     * Write Type Bar3D
1001
     *
1002
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
1003
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Bar3D $subject
1004
     * @param  boolean $includeSheet
1005
     * @throws \Exception
1006
     */
1007 4
    protected function writeTypeBar3D(XMLWriter $objWriter, Bar3D $subject, $includeSheet = false)
1008
    {
1009
        // c:bar3DChart
1010 4
        $objWriter->startElement('c:bar3DChart');
1011
1012
        // c:barDir
1013 4
        $objWriter->startElement('c:barDir');
1014 4
        $objWriter->writeAttribute('val', $subject->getBarDirection());
1015 4
        $objWriter->endElement();
1016
1017
        // c:grouping
1018 4
        $objWriter->startElement('c:grouping');
1019 4
        $objWriter->writeAttribute('val', $subject->getBarGrouping());
1020 4
        $objWriter->endElement();
1021
1022
        // Write series
1023 4
        $seriesIndex = 0;
1024 4
        foreach ($subject->getSeries() as $series) {
1025
            // c:ser
1026 4
            $objWriter->startElement('c:ser');
1027
1028
            // c:idx
1029 4
            $objWriter->startElement('c:idx');
1030 4
            $objWriter->writeAttribute('val', $seriesIndex);
1031 4
            $objWriter->endElement();
1032
1033
            // c:order
1034 4
            $objWriter->startElement('c:order');
1035 4
            $objWriter->writeAttribute('val', $seriesIndex);
1036 4
            $objWriter->endElement();
1037
1038
            // c:tx
1039 4
            $objWriter->startElement('c:tx');
1040 4
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1041 4
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1042 4
            $objWriter->endElement();
1043
1044
            // Fills for points?
1045 4
            $dataPointFills = $series->getDataPointFills();
1046 4
            foreach ($dataPointFills as $key => $value) {
1047
                // c:dPt
1048 1
                $objWriter->startElement('c:dPt');
1049
1050
                // c:idx
1051 1
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
1052
1053 1
                if ($value->getFillType() != Fill::FILL_NONE) {
1054
                    // c:spPr
1055 1
                    $objWriter->startElement('c:spPr');
1056
                    // Write fill
1057 1
                    $this->writeFill($objWriter, $value);
1058
                    // ## c:spPr
1059 1
                    $objWriter->endElement();
1060 1
                }
1061
1062
                // ## c:dPt
1063 1
                $objWriter->endElement();
1064 4
            }
1065
1066
            // c:dLbls
1067 4
            $objWriter->startElement('c:dLbls');
1068
1069
            // c:txPr
1070 4
            $objWriter->startElement('c:txPr');
1071
1072
            // a:bodyPr
1073 4
            $objWriter->writeElement('a:bodyPr', null);
1074
1075
            // a:lstStyle
1076 4
            $objWriter->writeElement('a:lstStyle', null);
1077
1078
            // a:p
1079 4
            $objWriter->startElement('a:p');
1080
1081
            // a:pPr
1082 4
            $objWriter->startElement('a:pPr');
1083
1084
            // a:defRPr
1085 4
            $objWriter->startElement('a:defRPr');
1086
1087 4
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1088 4
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1089 4
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1090 4
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1091 4
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1092 4
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1093 4
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1094
1095
            // Font - a:solidFill
1096 4
            $objWriter->startElement('a:solidFill');
1097
1098 4
            $this->writeColor($objWriter, $series->getFont()->getColor());
1099
1100 4
            $objWriter->endElement();
1101
1102
            // Font - a:latin
1103 4
            $objWriter->startElement('a:latin');
1104 4
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1105 4
            $objWriter->endElement();
1106
1107 4
            $objWriter->endElement();
1108
1109 4
            $objWriter->endElement();
1110
1111
            // a:endParaRPr
1112 4
            $objWriter->startElement('a:endParaRPr');
1113 4
            $objWriter->writeAttribute('lang', 'en-US');
1114 4
            $objWriter->writeAttribute('dirty', '0');
1115 4
            $objWriter->endElement();
1116
1117 4
            $objWriter->endElement();
1118
1119 4
            $objWriter->endElement();
1120
1121
            // c:showVal
1122 4
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1123
1124
            // c:showCatName
1125 4
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1126
1127
            // c:showSerName
1128 4
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1129
1130
            // c:showPercent
1131 4
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1132
1133
            // c:showLeaderLines
1134 4
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1135
1136 4
            $objWriter->endElement();
1137
1138
            // c:spPr
1139 4
            if ($series->getFill()->getFillType() != Fill::FILL_NONE) {
1140
                // c:spPr
1141
                $objWriter->startElement('c:spPr');
1142
                // Write fill
1143
                $this->writeFill($objWriter, $series->getFill());
1144
                // ## c:spPr
1145
                $objWriter->endElement();
1146
            }
1147
1148
            // Write X axis data
1149 4
            $axisXData = array_keys($series->getValues());
1150
1151
            // c:cat
1152 4
            $objWriter->startElement('c:cat');
1153 4
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1154 4
            $objWriter->endElement();
1155
1156
            // Write Y axis data
1157 4
            $axisYData = array_values($series->getValues());
1158
1159
            // c:val
1160 4
            $objWriter->startElement('c:val');
1161 4
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1162 4
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1163 4
            $objWriter->endElement();
1164
1165 4
            $objWriter->endElement();
1166
1167 4
            ++$seriesIndex;
1168 4
        }
1169
1170
        // c:gapWidth
1171 4
        $objWriter->startElement('c:gapWidth');
1172 4
        $objWriter->writeAttribute('val', '75');
1173 4
        $objWriter->endElement();
1174
1175
        // c:shape
1176 4
        $objWriter->startElement('c:shape');
1177 4
        $objWriter->writeAttribute('val', 'box');
1178 4
        $objWriter->endElement();
1179
1180
        // c:axId
1181 4
        $objWriter->startElement('c:axId');
1182 4
        $objWriter->writeAttribute('val', '52743552');
1183 4
        $objWriter->endElement();
1184
1185
        // c:axId
1186 4
        $objWriter->startElement('c:axId');
1187 4
        $objWriter->writeAttribute('val', '52749440');
1188 4
        $objWriter->endElement();
1189
1190
        // c:axId
1191 4
        $objWriter->startElement('c:axId');
1192 4
        $objWriter->writeAttribute('val', '0');
1193 4
        $objWriter->endElement();
1194
1195 4
        $objWriter->endElement();
1196 4
    }
1197
1198
    /**
1199
     * Write Type Pie
1200
     *
1201
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
1202
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Pie $subject
1203
     * @param  boolean $includeSheet
1204
     * @throws \Exception
1205
     */
1206 1
    protected function writeTypePie(XMLWriter $objWriter, Pie $subject, $includeSheet = false)
1207
    {
1208
        // c:pieChart
1209 1
        $objWriter->startElement('c:pieChart');
1210
1211
        // c:varyColors
1212 1
        $objWriter->startElement('c:varyColors');
1213 1
        $objWriter->writeAttribute('val', '1');
1214 1
        $objWriter->endElement();
1215
1216
        // Write series
1217 1
        $seriesIndex = 0;
1218 1
        foreach ($subject->getSeries() as $series) {
1219
            // c:ser
1220 1
            $objWriter->startElement('c:ser');
1221
1222
            // c:idx
1223 1
            $objWriter->startElement('c:idx');
1224 1
            $objWriter->writeAttribute('val', $seriesIndex);
1225 1
            $objWriter->endElement();
1226
1227
            // c:order
1228 1
            $objWriter->startElement('c:order');
1229 1
            $objWriter->writeAttribute('val', $seriesIndex);
1230 1
            $objWriter->endElement();
1231
1232
            // c:tx
1233 1
            $objWriter->startElement('c:tx');
1234 1
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1235 1
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1236 1
            $objWriter->endElement();
1237
1238
            // Fills for points?
1239 1
            $dataPointFills = $series->getDataPointFills();
1240 1
            foreach ($dataPointFills as $key => $value) {
1241
                // c:dPt
1242 1
                $objWriter->startElement('c:dPt');
1243
1244
                // c:idx
1245 1
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
1246
1247
                // c:spPr
1248 1
                $objWriter->startElement('c:spPr');
1249
1250
                // Write fill
1251 1
                $this->writeFill($objWriter, $value);
1252
1253 1
                $objWriter->endElement();
1254
1255 1
                $objWriter->endElement();
1256 1
            }
1257
1258
            // c:dLbls
1259 1
            $objWriter->startElement('c:dLbls');
1260
1261 1
            if ($series->hasDlblNumFormat()) {
1262
                //c:numFmt
1263
                $objWriter->startElement('c:numFmt');
1264
                $objWriter->writeAttribute('formatCode', $series->getDlblNumFormat());
1265
                $objWriter->writeAttribute('sourceLinked', '0');
1266
                $objWriter->endElement();
1267
            }
1268
1269
            // c:txPr
1270 1
            $objWriter->startElement('c:txPr');
1271
1272
            // a:bodyPr
1273 1
            $objWriter->writeElement('a:bodyPr', null);
1274
1275
            // a:lstStyle
1276 1
            $objWriter->writeElement('a:lstStyle', null);
1277
1278
            // a:p
1279 1
            $objWriter->startElement('a:p');
1280
1281
            // a:pPr
1282 1
            $objWriter->startElement('a:pPr');
1283
1284
            // a:defRPr
1285 1
            $objWriter->startElement('a:defRPr');
1286
1287 1
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1288 1
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1289 1
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1290 1
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1291 1
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1292 1
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1293 1
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1294
1295
            // Font - a:solidFill
1296 1
            $objWriter->startElement('a:solidFill');
1297
1298 1
            $this->writeColor($objWriter, $series->getFont()->getColor());
1299
1300 1
            $objWriter->endElement();
1301
1302
            // Font - a:latin
1303 1
            $objWriter->startElement('a:latin');
1304 1
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1305 1
            $objWriter->endElement();
1306
1307 1
            $objWriter->endElement();
1308
1309 1
            $objWriter->endElement();
1310
1311
            // a:endParaRPr
1312 1
            $objWriter->startElement('a:endParaRPr');
1313 1
            $objWriter->writeAttribute('lang', 'en-US');
1314 1
            $objWriter->writeAttribute('dirty', '0');
1315 1
            $objWriter->endElement();
1316
1317 1
            $objWriter->endElement();
1318
1319 1
            $objWriter->endElement();
1320
1321
            // c:dLblPos
1322 1
            $this->writeElementWithValAttribute($objWriter, 'c:dLblPos', $series->getLabelPosition());
1323
1324
            // c:showVal
1325 1
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1326
1327
            // c:showCatName
1328 1
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1329
1330
            // c:showSerName
1331 1
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1332
1333
            // c:showPercent
1334 1
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1335
1336
            // c:showLeaderLines
1337 1
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1338
1339 1
            $objWriter->endElement();
1340
1341
            // Write X axis data
1342 1
            $axisXData = array_keys($series->getValues());
1343
1344
            // c:cat
1345 1
            $objWriter->startElement('c:cat');
1346 1
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1347 1
            $objWriter->endElement();
1348
1349
            // Write Y axis data
1350 1
            $axisYData = array_values($series->getValues());
1351
1352
            // c:val
1353 1
            $objWriter->startElement('c:val');
1354 1
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1355 1
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1356 1
            $objWriter->endElement();
1357
1358 1
            $objWriter->endElement();
1359
1360 1
            ++$seriesIndex;
1361 1
        }
1362
1363 1
        $objWriter->endElement();
1364 1
    }
1365
1366
    /**
1367
     * Write Type Pie3D
1368
     *
1369
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
1370
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Pie3D $subject
1371
     * @param  boolean $includeSheet
1372
     * @throws \Exception
1373
     */
1374 4
    protected function writeTypePie3D(XMLWriter $objWriter, Pie3D $subject, $includeSheet = false)
1375
    {
1376
        // c:pie3DChart
1377 4
        $objWriter->startElement('c:pie3DChart');
1378
1379
        // c:varyColors
1380 4
        $objWriter->startElement('c:varyColors');
1381 4
        $objWriter->writeAttribute('val', '1');
1382 4
        $objWriter->endElement();
1383
1384
        // Write series
1385 4
        $seriesIndex = 0;
1386 4
        foreach ($subject->getSeries() as $series) {
1387
            // c:ser
1388 4
            $objWriter->startElement('c:ser');
1389
1390
            // c:idx
1391 4
            $objWriter->startElement('c:idx');
1392 4
            $objWriter->writeAttribute('val', $seriesIndex);
1393 4
            $objWriter->endElement();
1394
1395
            // c:order
1396 4
            $objWriter->startElement('c:order');
1397 4
            $objWriter->writeAttribute('val', $seriesIndex);
1398 4
            $objWriter->endElement();
1399
1400
            // c:tx
1401 4
            $objWriter->startElement('c:tx');
1402 4
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1403 4
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1404 4
            $objWriter->endElement();
1405
1406
            // c:explosion
1407 4
            $objWriter->startElement('c:explosion');
1408 4
            $objWriter->writeAttribute('val', $subject->getExplosion());
1409 4
            $objWriter->endElement();
1410
1411
            // Fills for points?
1412 4
            $dataPointFills = $series->getDataPointFills();
1413 4
            foreach ($dataPointFills as $key => $value) {
1414
                // c:dPt
1415 1
                $objWriter->startElement('c:dPt');
1416
1417
                // c:idx
1418 1
                $this->writeElementWithValAttribute($objWriter, 'c:idx', $key);
1419
1420
                // c:spPr
1421 1
                $objWriter->startElement('c:spPr');
1422
1423
                // Write fill
1424 1
                $this->writeFill($objWriter, $value);
1425
1426 1
                $objWriter->endElement();
1427
1428 1
                $objWriter->endElement();
1429 4
            }
1430
1431
            // c:dLbls
1432 4
            $objWriter->startElement('c:dLbls');
1433
1434
            // c:txPr
1435 4
            $objWriter->startElement('c:txPr');
1436
1437
            // a:bodyPr
1438 4
            $objWriter->writeElement('a:bodyPr', null);
1439
1440
            // a:lstStyle
1441 4
            $objWriter->writeElement('a:lstStyle', null);
1442
1443
            // a:p
1444 4
            $objWriter->startElement('a:p');
1445
1446
            // a:pPr
1447 4
            $objWriter->startElement('a:pPr');
1448
1449
            // a:defRPr
1450 4
            $objWriter->startElement('a:defRPr');
1451
1452 4
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1453 4
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1454 4
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1455 4
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1456 4
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1457 4
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1458 4
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1459
1460
            // Font - a:solidFill
1461 4
            $objWriter->startElement('a:solidFill');
1462
1463 4
            $this->writeColor($objWriter, $series->getFont()->getColor());
1464
1465 4
            $objWriter->endElement();
1466
1467
            // Font - a:latin
1468 4
            $objWriter->startElement('a:latin');
1469 4
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1470 4
            $objWriter->endElement();
1471
1472 4
            $objWriter->endElement();
1473
1474 4
            $objWriter->endElement();
1475
1476
            // a:endParaRPr
1477 4
            $objWriter->startElement('a:endParaRPr');
1478 4
            $objWriter->writeAttribute('lang', 'en-US');
1479 4
            $objWriter->writeAttribute('dirty', '0');
1480 4
            $objWriter->endElement();
1481
1482 4
            $objWriter->endElement();
1483
1484 4
            $objWriter->endElement();
1485
1486
            // c:dLblPos
1487 4
            $this->writeElementWithValAttribute($objWriter, 'c:dLblPos', $series->getLabelPosition());
1488
1489
            // c:showVal
1490 4
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1491
1492
            // c:showCatName
1493 4
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1494
1495
            // c:showSerName
1496 4
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1497
1498
            // c:showPercent
1499 4
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1500
1501
            // c:showLeaderLines
1502 4
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1503
1504 4
            $objWriter->endElement();
1505
1506
            // Write X axis data
1507 4
            $axisXData = array_keys($series->getValues());
1508
1509
            // c:cat
1510 4
            $objWriter->startElement('c:cat');
1511 4
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1512 4
            $objWriter->endElement();
1513
1514
            // Write Y axis data
1515 4
            $axisYData = array_values($series->getValues());
1516
1517
            // c:val
1518 4
            $objWriter->startElement('c:val');
1519 4
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1520 4
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1521 4
            $objWriter->endElement();
1522
1523 4
            $objWriter->endElement();
1524
1525 4
            ++$seriesIndex;
1526 4
        }
1527
1528 4
        $objWriter->endElement();
1529 4
    }
1530
1531
    /**
1532
     * Write Type Line
1533
     *
1534
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
1535
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Line $subject
1536
     * @param  boolean $includeSheet
1537
     * @throws \Exception
1538
     */
1539 9
    protected function writeTypeLine(XMLWriter $objWriter, Line $subject, $includeSheet = false)
1540
    {
1541
        // c:lineChart
1542 9
        $objWriter->startElement('c:lineChart');
1543
1544
        // c:grouping
1545 9
        $objWriter->startElement('c:grouping');
1546 9
        $objWriter->writeAttribute('val', 'standard');
1547 9
        $objWriter->endElement();
1548
1549
        // Write series
1550 9
        $seriesIndex = 0;
1551 9
        foreach ($subject->getSeries() as $series) {
1552
            // c:ser
1553 7
            $objWriter->startElement('c:ser');
1554
1555
            // c:idx
1556 7
            $objWriter->startElement('c:idx');
1557 7
            $objWriter->writeAttribute('val', $seriesIndex);
1558 7
            $objWriter->endElement();
1559
1560
            // c:order
1561 7
            $objWriter->startElement('c:order');
1562 7
            $objWriter->writeAttribute('val', $seriesIndex);
1563 7
            $objWriter->endElement();
1564
1565
            // c:tx
1566 7
            $objWriter->startElement('c:tx');
1567 7
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1568 7
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1569 7
            $objWriter->endElement();
1570
1571
            // Marker
1572 7
            $this->writeSeriesMarker($objWriter, $series->getMarker());
1573
1574
            // c:dLbls
1575 7
            $objWriter->startElement('c:dLbls');
1576
1577
            // c:txPr
1578 7
            $objWriter->startElement('c:txPr');
1579
1580
            // a:bodyPr
1581 7
            $objWriter->writeElement('a:bodyPr', null);
1582
1583
            // a:lstStyle
1584 7
            $objWriter->writeElement('a:lstStyle', null);
1585
1586
            // a:p
1587 7
            $objWriter->startElement('a:p');
1588
1589
            // a:pPr
1590 7
            $objWriter->startElement('a:pPr');
1591
1592
            // a:defRPr
1593 7
            $objWriter->startElement('a:defRPr');
1594
1595 7
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1596 7
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1597 7
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1598 7
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1599 7
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1600 7
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1601 7
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1602
1603
            // Font - a:solidFill
1604 7
            $objWriter->startElement('a:solidFill');
1605
1606 7
            $this->writeColor($objWriter, $series->getFont()->getColor());
1607
1608 7
            $objWriter->endElement();
1609
1610
            // Font - a:latin
1611 7
            $objWriter->startElement('a:latin');
1612 7
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1613 7
            $objWriter->endElement();
1614
1615 7
            $objWriter->endElement();
1616
1617 7
            $objWriter->endElement();
1618
1619
            // a:endParaRPr
1620 7
            $objWriter->startElement('a:endParaRPr');
1621 7
            $objWriter->writeAttribute('lang', 'en-US');
1622 7
            $objWriter->writeAttribute('dirty', '0');
1623 7
            $objWriter->endElement();
1624
1625 7
            $objWriter->endElement();
1626
1627 7
            $objWriter->endElement();
1628
1629
            // c:showVal
1630 7
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1631
1632
            // c:showCatName
1633 7
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1634
1635
            // c:showSerName
1636 7
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1637
1638
            // c:showPercent
1639 7
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1640
1641
            // c:showLeaderLines
1642 7
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1643
1644
            // > c:dLbls
1645 7
            $objWriter->endElement();
1646
1647
            // c:spPr
1648 7
            $objWriter->startElement('c:spPr');
1649
            // Write fill
1650 7
            $this->writeFill($objWriter, $series->getFill());
1651
            // Write outline
1652 7
            $this->writeOutline($objWriter, $series->getOutline());
1653
            // ## c:spPr
1654 7
            $objWriter->endElement();
1655
1656
            // Write X axis data
1657 7
            $axisXData = array_keys($series->getValues());
1658
1659
            // c:cat
1660 7
            $objWriter->startElement('c:cat');
1661 7
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1662 7
            $objWriter->endElement();
1663
1664
            // Write Y axis data
1665 7
            $axisYData = array_values($series->getValues());
1666
1667
            // c:val
1668 7
            $objWriter->startElement('c:val');
1669 7
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1670 7
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1671 7
            $objWriter->endElement();
1672
1673 7
            $objWriter->endElement();
1674
1675 7
            ++$seriesIndex;
1676 9
        }
1677
1678
        // c:marker
1679 9
        $objWriter->startElement('c:marker');
1680 9
        $objWriter->writeAttribute('val', '1');
1681 9
        $objWriter->endElement();
1682
1683
        // c:smooth
1684 9
        $objWriter->startElement('c:smooth');
1685 9
        $objWriter->writeAttribute('val', '0');
1686 9
        $objWriter->endElement();
1687
1688
        // c:axId
1689 9
        $objWriter->startElement('c:axId');
1690 9
        $objWriter->writeAttribute('val', '52743552');
1691 9
        $objWriter->endElement();
1692
1693
        // c:axId
1694 9
        $objWriter->startElement('c:axId');
1695 9
        $objWriter->writeAttribute('val', '52749440');
1696 9
        $objWriter->endElement();
1697
1698 9
        $objWriter->endElement();
1699 9
    }
1700
1701
    /**
1702
     * Write Type Scatter
1703
     *
1704
     * @param  \PhpOffice\Common\XMLWriter $objWriter XML Writer
1705
     * @param  \PhpOffice\PhpPresentation\Shape\Chart\Type\Scatter $subject
1706
     * @param  boolean $includeSheet
1707
     * @throws \Exception
1708
     */
1709 5
    protected function writeTypeScatter(XMLWriter $objWriter, Scatter $subject, $includeSheet = false)
1710
    {
1711
        // c:scatterChart
1712 5
        $objWriter->startElement('c:scatterChart');
1713
1714
        // c:scatterStyle
1715 5
        $objWriter->startElement('c:scatterStyle');
1716 5
        $objWriter->writeAttribute('val', 'lineMarker');
1717 5
        $objWriter->endElement();
1718
1719
        // c:varyColors
1720 5
        $objWriter->startElement('c:varyColors');
1721 5
        $objWriter->writeAttribute('val', '0');
1722 5
        $objWriter->endElement();
1723
1724
        // Write series
1725 5
        $seriesIndex = 0;
1726 5
        foreach ($subject->getSeries() as $series) {
1727
            // c:ser
1728 5
            $objWriter->startElement('c:ser');
1729
1730
            // c:idx
1731 5
            $objWriter->startElement('c:idx');
1732 5
            $objWriter->writeAttribute('val', $seriesIndex);
1733 5
            $objWriter->endElement();
1734
1735
            // c:order
1736 5
            $objWriter->startElement('c:order');
1737 5
            $objWriter->writeAttribute('val', $seriesIndex);
1738 5
            $objWriter->endElement();
1739
1740
            // c:tx
1741 5
            $objWriter->startElement('c:tx');
1742 5
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex(1 + $seriesIndex) . '$1' : '');
1743 5
            $this->writeSingleValueOrReference($objWriter, $includeSheet, $series->getTitle(), $coords);
1744 5
            $objWriter->endElement();
1745
1746
            // Marker
1747 5
            $this->writeSeriesMarker($objWriter, $series->getMarker());
1748
1749
            // c:dLbls
1750 5
            $objWriter->startElement('c:dLbls');
1751
1752
            // c:txPr
1753 5
            $objWriter->startElement('c:txPr');
1754
1755
            // a:bodyPr
1756 5
            $objWriter->writeElement('a:bodyPr', null);
1757
1758
            // a:lstStyle
1759 5
            $objWriter->writeElement('a:lstStyle', null);
1760
1761
            // a:p
1762 5
            $objWriter->startElement('a:p');
1763
1764
            // a:pPr
1765 5
            $objWriter->startElement('a:pPr');
1766
1767
            // a:defRPr
1768 5
            $objWriter->startElement('a:defRPr');
1769
1770 5
            $objWriter->writeAttribute('b', ($series->getFont()->isBold() ? 'true' : 'false'));
1771 5
            $objWriter->writeAttribute('i', ($series->getFont()->isItalic() ? 'true' : 'false'));
1772 5
            $objWriter->writeAttribute('strike', ($series->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
1773 5
            $objWriter->writeAttribute('sz', ($series->getFont()->getSize() * 100));
1774 5
            $objWriter->writeAttribute('u', $series->getFont()->getUnderline());
1775 5
            $objWriter->writeAttributeIf($series->getFont()->isSuperScript(), 'baseline', '30000');
1776 5
            $objWriter->writeAttributeIf($series->getFont()->isSubScript(), 'baseline', '-25000');
1777
1778
            // Font - a:solidFill
1779 5
            $objWriter->startElement('a:solidFill');
1780
1781 5
            $this->writeColor($objWriter, $series->getFont()->getColor());
1782
1783 5
            $objWriter->endElement();
1784
1785
            // Font - a:latin
1786 5
            $objWriter->startElement('a:latin');
1787 5
            $objWriter->writeAttribute('typeface', $series->getFont()->getName());
1788 5
            $objWriter->endElement();
1789
1790 5
            $objWriter->endElement();
1791
1792 5
            $objWriter->endElement();
1793
1794
            // a:endParaRPr
1795 5
            $objWriter->startElement('a:endParaRPr');
1796 5
            $objWriter->writeAttribute('lang', 'en-US');
1797 5
            $objWriter->writeAttribute('dirty', '0');
1798 5
            $objWriter->endElement();
1799
1800 5
            $objWriter->endElement();
1801
1802 5
            $objWriter->endElement();
1803
1804
            // c:showLegendKey
1805 5
            $this->writeElementWithValAttribute($objWriter, 'c:showLegendKey', '0');
1806
1807
            // c:showVal
1808 5
            $this->writeElementWithValAttribute($objWriter, 'c:showVal', $series->hasShowValue() ? '1' : '0');
1809
1810
            // c:showCatName
1811 5
            $this->writeElementWithValAttribute($objWriter, 'c:showCatName', $series->hasShowCategoryName() ? '1' : '0');
1812
1813
            // c:showSerName
1814 5
            $this->writeElementWithValAttribute($objWriter, 'c:showSerName', $series->hasShowSeriesName() ? '1' : '0');
1815
1816
            // c:showPercent
1817 5
            $this->writeElementWithValAttribute($objWriter, 'c:showPercent', $series->hasShowPercentage() ? '1' : '0');
1818
1819
            // c:showLeaderLines
1820 5
            $this->writeElementWithValAttribute($objWriter, 'c:showLeaderLines', $series->hasShowLeaderLines() ? '1' : '0');
1821
1822 5
            $objWriter->endElement();
1823
1824
            // c:spPr
1825 5
            $objWriter->startElement('c:spPr');
1826
            // Write fill
1827 5
            $this->writeFill($objWriter, $series->getFill());
1828
            // Write outline
1829 5
            $this->writeOutline($objWriter, $series->getOutline());
1830
            // ## c:spPr
1831 5
            $objWriter->endElement();
1832
1833
            // Write X axis data
1834 5
            $axisXData = array_keys($series->getValues());
1835
1836
            // c:xVal
1837 5
            $objWriter->startElement('c:xVal');
1838 5
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisXData, 'Sheet1!$A$2:$A$' . (1 + count($axisXData)));
1839 5
            $objWriter->endElement();
1840
1841
            // Write Y axis data
1842 5
            $axisYData = array_values($series->getValues());
1843
1844
            // c:yVal
1845 5
            $objWriter->startElement('c:yVal');
1846 5
            $coords = ($includeSheet ? 'Sheet1!$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$2:$' . \PHPExcel_Cell::stringFromColumnIndex($seriesIndex + 1) . '$' . (1 + count($axisYData)) : '');
1847 5
            $this->writeMultipleValuesOrReference($objWriter, $includeSheet, $axisYData, $coords);
1848 5
            $objWriter->endElement();
1849
1850
            // c:smooth
1851 5
            $objWriter->startElement('c:smooth');
1852 5
            $objWriter->writeAttribute('val', '0');
1853 5
            $objWriter->endElement();
1854
1855 5
            $objWriter->endElement();
1856
1857 5
            ++$seriesIndex;
1858 5
        }
1859
1860
        // c:axId
1861 5
        $objWriter->startElement('c:axId');
1862 5
        $objWriter->writeAttribute('val', '52743552');
1863 5
        $objWriter->endElement();
1864
1865
        // c:axId
1866 5
        $objWriter->startElement('c:axId');
1867 5
        $objWriter->writeAttribute('val', '52749440');
1868 5
        $objWriter->endElement();
1869
1870 5
        $objWriter->endElement();
1871 5
    }
1872
1873
    /**
1874
     * Write chart relationships to XML format
1875
     *
1876
     * @param  \PhpOffice\PhpPresentation\Shape\Chart $pChart
1877
     * @return string                    XML Output
1878
     * @throws \Exception
1879
     */
1880
    public function writeChartRelationships(Chart $pChart)
1881
    {
1882
        // Create XML writer
1883
        $objWriter = new XMLWriter(XMLWriter::STORAGE_MEMORY);
1884
1885
        // XML header
1886
        $objWriter->startDocument('1.0', 'UTF-8', 'yes');
1887
1888
        // Relationships
1889
        $objWriter->startElement('Relationships');
1890
        $objWriter->writeAttribute('xmlns', 'http://schemas.openxmlformats.org/package/2006/relationships');
1891
1892
        // Write spreadsheet relationship?
1893
        if ($pChart->hasIncludedSpreadsheet()) {
1894
            $this->writeRelationship($objWriter, 1, 'http://schemas.openxmlformats.org/officeDocument/2006/relationships/package', '../embeddings/' . $pChart->getIndexedFilename() . '.xlsx');
1895
        }
1896
1897
        $objWriter->endElement();
1898
1899
        // Return
1900
        return $objWriter->getData();
1901
    }
1902
1903
    /**
1904
     * @param XMLWriter $objWriter
1905
     * @param Chart\Marker $oMarker
1906
     */
1907 12
    protected function writeSeriesMarker(XMLWriter $objWriter, Chart\Marker $oMarker)
1908
    {
1909
        // c:marker
1910 12
        $objWriter->startElement('c:marker');
1911
        // c:marker > c:symbol
1912 12
        $objWriter->startElement('c:symbol');
1913 12
        $objWriter->writeAttribute('val', $oMarker->getSymbol());
1914 12
        $objWriter->endElement();
1915
1916
        // Size if different of none
1917 12
        if ($oMarker->getSymbol() != Chart\Marker::SYMBOL_NONE) {
1918 2
            $markerSize = (int)$oMarker->getSize();
1919 2
            if ($markerSize < 2) {
1920 2
                $markerSize = 2;
1921 2
            }
1922 2
            if ($markerSize > 72) {
1923 2
                $markerSize = 72;
1924 2
            }
1925
1926
            /**
1927
             * c:marker > c:size
1928
             * Size in points
1929
             * @link : https://msdn.microsoft.com/en-us/library/hh658135(v=office.12).aspx
1930
             */
1931 2
            $objWriter->startElement('c:size');
1932 2
            $objWriter->writeAttribute('val', $markerSize);
1933 2
            $objWriter->endElement();
1934 2
        }
1935 12
        $objWriter->endElement();
1936 12
    }
1937
1938
    /**
1939
     * @param XMLWriter $objWriter
1940
     * @param Chart\Axis $oAxis
1941
     * @param $typeAxis
1942
     * @param Chart\Type\AbstractType $typeChart
1943
     */
1944 21
    protected function writeAxis(XMLWriter $objWriter, Chart\Axis $oAxis, $typeAxis, Chart\Type\AbstractType $typeChart)
1945
    {
1946 21
        if ($typeAxis != Chart\Axis::AXIS_X && $typeAxis != Chart\Axis::AXIS_Y) {
1947
            return;
1948
        }
1949
1950 21
        if ($typeAxis == Chart\Axis::AXIS_X) {
1951 21
            $mainElement = 'c:catAx';
1952 21
            $axIdVal = '52743552';
1953 21
            $axPosVal = 'b';
1954 21
            $crossAxVal = '52749440';
1955 21
        } else {
1956 21
            $mainElement = 'c:valAx';
1957 21
            $axIdVal = '52749440';
1958 21
            $axPosVal = 'l';
1959 21
            $crossAxVal = '52743552';
1960
        }
1961
1962
        // $mainElement
1963 21
        $objWriter->startElement($mainElement);
1964
1965
        // $mainElement > c:axId
1966 21
        $objWriter->startElement('c:axId');
1967 21
        $objWriter->writeAttribute('val', $axIdVal);
1968 21
        $objWriter->endElement();
1969
1970
        // $mainElement > c:scaling
1971 21
        $objWriter->startElement('c:scaling');
1972
1973
        // $mainElement > c:scaling > c:orientation
1974 21
        $objWriter->startElement('c:orientation');
1975 21
        $objWriter->writeAttribute('val', 'minMax');
1976 21
        $objWriter->endElement();
1977
1978 21
        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...
1979 1
            $objWriter->startElement('c:max');
1980 1
            $objWriter->writeAttribute('val', $oAxis->getMaxBounds());
1981 1
            $objWriter->endElement();
1982 1
        }
1983
1984 21
        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...
1985 1
            $objWriter->startElement('c:min');
1986 1
            $objWriter->writeAttribute('val', $oAxis->getMinBounds());
1987 1
            $objWriter->endElement();
1988 1
        }
1989
1990
        // $mainElement > ##c:scaling
1991 21
        $objWriter->endElement();
1992
1993
        // $mainElement > c:axPos
1994 21
        $objWriter->startElement('c:axPos');
1995 21
        $objWriter->writeAttribute('val', $axPosVal);
1996 21
        $objWriter->endElement();
1997
1998 21
        $oMajorGridlines = $oAxis->getMajorGridlines();
1999 21
        if ($oMajorGridlines instanceof Gridlines) {
2000 1
            $objWriter->startElement('c:majorGridlines');
2001
2002 1
            $this->writeAxisGridlines($objWriter, $oMajorGridlines);
2003
2004 1
            $objWriter->endElement();
2005 1
        }
2006
2007 21
        $oMinorGridlines = $oAxis->getMinorGridlines();
2008 21
        if ($oMinorGridlines instanceof Gridlines) {
2009 1
            $objWriter->startElement('c:minorGridlines');
2010
2011 1
            $this->writeAxisGridlines($objWriter, $oMinorGridlines);
2012
2013 1
            $objWriter->endElement();
2014 1
        }
2015
2016
        // c:numFmt
2017 21
        $objWriter->startElement('c:numFmt');
2018 21
        $objWriter->writeAttribute('formatCode', $oAxis->getFormatCode());
2019 21
        $objWriter->writeAttribute('sourceLinked', '1');
2020 21
        $objWriter->endElement();
2021
2022
        // c:majorTickMark
2023 21
        $objWriter->startElement('c:majorTickMark');
2024 21
        $objWriter->writeAttribute('val', 'none');
2025 21
        $objWriter->endElement();
2026
2027
        // c:tickLblPos
2028 21
        $objWriter->startElement('c:tickLblPos');
2029 21
        $objWriter->writeAttribute('val', 'nextTo');
2030 21
        $objWriter->endElement();
2031
2032
        // c:title
2033 21
        $objWriter->startElement('c:title');
2034
2035
        // c:tx
2036 21
        $objWriter->startElement('c:tx');
2037
2038
        // c:rich
2039 21
        $objWriter->startElement('c:rich');
2040
2041
        // a:bodyPr
2042 21
        $objWriter->writeElement('a:bodyPr', null);
2043
2044
        // a:lstStyle
2045 21
        $objWriter->writeElement('a:lstStyle', null);
2046
2047
        // a:p
2048 21
        $objWriter->startElement('a:p');
2049
2050
        // a:pPr
2051 21
        $objWriter->startElement('a:pPr');
2052
2053
        // a:defRPr
2054 21
        $objWriter->startElement('a:defRPr');
2055
2056 21
        $objWriter->writeAttribute('b', ($oAxis->getFont()->isBold() ? 'true' : 'false'));
2057 21
        $objWriter->writeAttribute('i', ($oAxis->getFont()->isItalic() ? 'true' : 'false'));
2058 21
        $objWriter->writeAttribute('strike', ($oAxis->getFont()->isStrikethrough() ? 'sngStrike' : 'noStrike'));
2059 21
        $objWriter->writeAttribute('sz', ($oAxis->getFont()->getSize() * 100));
2060 21
        $objWriter->writeAttribute('u', $oAxis->getFont()->getUnderline());
2061 21
        $objWriter->writeAttributeIf($oAxis->getFont()->isSuperScript(), 'baseline', '30000');
2062 21
        $objWriter->writeAttributeIf($oAxis->getFont()->isSubScript(), 'baseline', '-25000');
2063
2064
        // Font - a:solidFill
2065 21
        $objWriter->startElement('a:solidFill');
2066
2067 21
        $this->writeColor($objWriter, $oAxis->getFont()->getColor());
2068
2069 21
        $objWriter->endElement();
2070
2071
        // Font - a:latin
2072 21
        $objWriter->startElement('a:latin');
2073 21
        $objWriter->writeAttribute('typeface', $oAxis->getFont()->getName());
2074 21
        $objWriter->endElement();
2075
2076 21
        $objWriter->endElement();
2077
2078
        // ## a:pPr
2079 21
        $objWriter->endElement();
2080
2081
        // a:r
2082 21
        $objWriter->startElement('a:r');
2083
2084
        // a:rPr
2085 21
        $objWriter->startElement('a:rPr');
2086 21
        $objWriter->writeAttribute('lang', 'en-US');
2087 21
        $objWriter->writeAttribute('dirty', '0');
2088 21
        $objWriter->endElement();
2089
2090
        // a:t
2091 21
        $objWriter->writeElement('a:t', $oAxis->getTitle());
2092
2093
        // ## a:r
2094 21
        $objWriter->endElement();
2095
2096
        // a:endParaRPr
2097 21
        $objWriter->startElement('a:endParaRPr');
2098 21
        $objWriter->writeAttribute('lang', 'en-US');
2099 21
        $objWriter->writeAttribute('dirty', '0');
2100 21
        $objWriter->endElement();
2101
2102
        // ## a:p
2103 21
        $objWriter->endElement();
2104
2105
        // ## c:rich
2106 21
        $objWriter->endElement();
2107
2108
        // ## c:tx
2109 21
        $objWriter->endElement();
2110
2111
        // ## c:title
2112 21
        $objWriter->endElement();
2113
2114
        // c:crossAx
2115 21
        $objWriter->startElement('c:crossAx');
2116 21
        $objWriter->writeAttribute('val', $crossAxVal);
2117 21
        $objWriter->endElement();
2118
2119
        // c:crosses
2120 21
        $objWriter->startElement('c:crosses');
2121 21
        $objWriter->writeAttribute('val', 'autoZero');
2122 21
        $objWriter->endElement();
2123
2124 21
        if ($typeAxis == Chart\Axis::AXIS_X) {
2125
            // c:lblAlgn
2126 21
            $objWriter->startElement('c:lblAlgn');
2127 21
            $objWriter->writeAttribute('val', 'ctr');
2128 21
            $objWriter->endElement();
2129
2130
            // c:lblOffset
2131 21
            $objWriter->startElement('c:lblOffset');
2132 21
            $objWriter->writeAttribute('val', '100');
2133 21
            $objWriter->endElement();
2134 21
        }
2135
2136 21
        if ($typeAxis == Chart\Axis::AXIS_Y) {
2137
            // c:crossBetween
2138 21
            $objWriter->startElement('c:crossBetween');
2139
            // midCat : Position Axis On Tick Marks
2140
            // between : Between Tick Marks
2141 21
            if ($typeChart instanceof Area) {
2142 1
                $objWriter->writeAttribute('val', 'midCat');
2143 1
            } else {
2144 20
                $objWriter->writeAttribute('val', 'between');
2145
            }
2146 21
            $objWriter->endElement();
2147 21
        }
2148
2149 21
        $objWriter->endElement();
2150 21
    }
2151
2152
    /**
2153
     * @param XMLWriter $objWriter
2154
     * @param Gridlines $oGridlines
2155
     */
2156 1
    protected function writeAxisGridlines(XMLWriter $objWriter, Gridlines $oGridlines)
2157
    {
2158
        // c:spPr
2159 1
        $objWriter->startElement('c:spPr');
2160
2161
        // Outline
2162 1
        $this->writeOutline($objWriter, $oGridlines->getOutline());
2163
2164
        // ##c:spPr
2165 1
        $objWriter->endElement();
2166 1
    }
2167
}
2168