Completed
Pull Request — master (#413)
by
unknown
07:08
created

PptCharts::writeTypeDoughnut()   D

Complexity

Conditions 17
Paths 36

Size

Total Lines 149
Code Lines 84

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 81
CRAP Score 17.0301

Importance

Changes 1
Bugs 0 Features 0
Metric Value
c 1
b 0
f 0
dl 0
loc 149
ccs 81
cts 85
cp 0.9529
rs 4.8361
cc 17
eloc 84
nc 36
nop 3
crap 17.0301

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

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

foreach ($a as $b) {
}

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


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

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