123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680 |
- <?php
- class PHPExcel_Chart
- {
-
- private $name = '';
-
- private $worksheet;
-
- private $title;
-
- private $legend;
-
- private $xAxisLabel;
-
- private $yAxisLabel;
-
- private $plotArea;
-
- private $plotVisibleOnly = true;
-
- private $displayBlanksAs = '0';
-
- private $yAxis;
-
- private $xAxis;
-
- private $majorGridlines;
-
- private $minorGridlines;
-
- private $topLeftCellRef = 'A1';
-
- private $topLeftXOffset = 0;
-
- private $topLeftYOffset = 0;
-
- private $bottomRightCellRef = 'A1';
-
- private $bottomRightXOffset = 10;
-
- private $bottomRightYOffset = 10;
-
- public function __construct($name, PHPExcel_Chart_Title $title = null, PHPExcel_Chart_Legend $legend = null, PHPExcel_Chart_PlotArea $plotArea = null, $plotVisibleOnly = true, $displayBlanksAs = '0', PHPExcel_Chart_Title $xAxisLabel = null, PHPExcel_Chart_Title $yAxisLabel = null, PHPExcel_Chart_Axis $xAxis = null, PHPExcel_Chart_Axis $yAxis = null, PHPExcel_Chart_GridLines $majorGridlines = null, PHPExcel_Chart_GridLines $minorGridlines = null)
- {
- $this->name = $name;
- $this->title = $title;
- $this->legend = $legend;
- $this->xAxisLabel = $xAxisLabel;
- $this->yAxisLabel = $yAxisLabel;
- $this->plotArea = $plotArea;
- $this->plotVisibleOnly = $plotVisibleOnly;
- $this->displayBlanksAs = $displayBlanksAs;
- $this->xAxis = $xAxis;
- $this->yAxis = $yAxis;
- $this->majorGridlines = $majorGridlines;
- $this->minorGridlines = $minorGridlines;
- }
-
- public function getName()
- {
- return $this->name;
- }
-
- public function getWorksheet()
- {
- return $this->worksheet;
- }
-
- public function setWorksheet(PHPExcel_Worksheet $pValue = null)
- {
- $this->worksheet = $pValue;
- return $this;
- }
-
- public function getTitle()
- {
- return $this->title;
- }
-
- public function setTitle(PHPExcel_Chart_Title $title)
- {
- $this->title = $title;
- return $this;
- }
-
- public function getLegend()
- {
- return $this->legend;
- }
-
- public function setLegend(PHPExcel_Chart_Legend $legend)
- {
- $this->legend = $legend;
- return $this;
- }
-
- public function getXAxisLabel()
- {
- return $this->xAxisLabel;
- }
-
- public function setXAxisLabel(PHPExcel_Chart_Title $label)
- {
- $this->xAxisLabel = $label;
- return $this;
- }
-
- public function getYAxisLabel()
- {
- return $this->yAxisLabel;
- }
-
- public function setYAxisLabel(PHPExcel_Chart_Title $label)
- {
- $this->yAxisLabel = $label;
- return $this;
- }
-
- public function getPlotArea()
- {
- return $this->plotArea;
- }
-
- public function getPlotVisibleOnly()
- {
- return $this->plotVisibleOnly;
- }
-
- public function setPlotVisibleOnly($plotVisibleOnly = true)
- {
- $this->plotVisibleOnly = $plotVisibleOnly;
- return $this;
- }
-
- public function getDisplayBlanksAs()
- {
- return $this->displayBlanksAs;
- }
-
- public function setDisplayBlanksAs($displayBlanksAs = '0')
- {
- $this->displayBlanksAs = $displayBlanksAs;
- }
-
- public function getChartAxisY()
- {
- if ($this->yAxis !== null) {
- return $this->yAxis;
- }
- return new PHPExcel_Chart_Axis();
- }
-
- public function getChartAxisX()
- {
- if ($this->xAxis !== null) {
- return $this->xAxis;
- }
- return new PHPExcel_Chart_Axis();
- }
-
- public function getMajorGridlines()
- {
- if ($this->majorGridlines !== null) {
- return $this->majorGridlines;
- }
- return new PHPExcel_Chart_GridLines();
- }
-
- public function getMinorGridlines()
- {
- if ($this->minorGridlines !== null) {
- return $this->minorGridlines;
- }
- return new PHPExcel_Chart_GridLines();
- }
-
- public function setTopLeftPosition($cell, $xOffset = null, $yOffset = null)
- {
- $this->topLeftCellRef = $cell;
- if (!is_null($xOffset)) {
- $this->setTopLeftXOffset($xOffset);
- }
- if (!is_null($yOffset)) {
- $this->setTopLeftYOffset($yOffset);
- }
- return $this;
- }
-
- public function getTopLeftPosition()
- {
- return array(
- 'cell' => $this->topLeftCellRef,
- 'xOffset' => $this->topLeftXOffset,
- 'yOffset' => $this->topLeftYOffset
- );
- }
-
- public function getTopLeftCell()
- {
- return $this->topLeftCellRef;
- }
-
- public function setTopLeftCell($cell)
- {
- $this->topLeftCellRef = $cell;
- return $this;
- }
-
- public function setTopLeftOffset($xOffset = null, $yOffset = null)
- {
- if (!is_null($xOffset)) {
- $this->setTopLeftXOffset($xOffset);
- }
- if (!is_null($yOffset)) {
- $this->setTopLeftYOffset($yOffset);
- }
- return $this;
- }
-
- public function getTopLeftOffset()
- {
- return array(
- 'X' => $this->topLeftXOffset,
- 'Y' => $this->topLeftYOffset
- );
- }
- public function setTopLeftXOffset($xOffset)
- {
- $this->topLeftXOffset = $xOffset;
- return $this;
- }
- public function getTopLeftXOffset()
- {
- return $this->topLeftXOffset;
- }
- public function setTopLeftYOffset($yOffset)
- {
- $this->topLeftYOffset = $yOffset;
- return $this;
- }
- public function getTopLeftYOffset()
- {
- return $this->topLeftYOffset;
- }
-
- public function setBottomRightPosition($cell, $xOffset = null, $yOffset = null)
- {
- $this->bottomRightCellRef = $cell;
- if (!is_null($xOffset)) {
- $this->setBottomRightXOffset($xOffset);
- }
- if (!is_null($yOffset)) {
- $this->setBottomRightYOffset($yOffset);
- }
- return $this;
- }
-
- public function getBottomRightPosition()
- {
- return array(
- 'cell' => $this->bottomRightCellRef,
- 'xOffset' => $this->bottomRightXOffset,
- 'yOffset' => $this->bottomRightYOffset
- );
- }
- public function setBottomRightCell($cell)
- {
- $this->bottomRightCellRef = $cell;
- return $this;
- }
-
- public function getBottomRightCell()
- {
- return $this->bottomRightCellRef;
- }
-
- public function setBottomRightOffset($xOffset = null, $yOffset = null)
- {
- if (!is_null($xOffset)) {
- $this->setBottomRightXOffset($xOffset);
- }
- if (!is_null($yOffset)) {
- $this->setBottomRightYOffset($yOffset);
- }
- return $this;
- }
-
- public function getBottomRightOffset()
- {
- return array(
- 'X' => $this->bottomRightXOffset,
- 'Y' => $this->bottomRightYOffset
- );
- }
- public function setBottomRightXOffset($xOffset)
- {
- $this->bottomRightXOffset = $xOffset;
- return $this;
- }
- public function getBottomRightXOffset()
- {
- return $this->bottomRightXOffset;
- }
- public function setBottomRightYOffset($yOffset)
- {
- $this->bottomRightYOffset = $yOffset;
- return $this;
- }
- public function getBottomRightYOffset()
- {
- return $this->bottomRightYOffset;
- }
- public function refresh()
- {
- if ($this->worksheet !== null) {
- $this->plotArea->refresh($this->worksheet);
- }
- }
- public function render($outputDestination = null)
- {
- $libraryName = PHPExcel_Settings::getChartRendererName();
- if (is_null($libraryName)) {
- return false;
- }
-
- $this->refresh();
- $libraryPath = PHPExcel_Settings::getChartRendererPath();
- $includePath = str_replace('\\', '/', get_include_path());
- $rendererPath = str_replace('\\', '/', $libraryPath);
- if (strpos($rendererPath, $includePath) === false) {
- set_include_path(get_include_path() . PATH_SEPARATOR . $libraryPath);
- }
- $rendererName = 'PHPExcel_Chart_Renderer_'.$libraryName;
- $renderer = new $rendererName($this);
- if ($outputDestination == 'php://output') {
- $outputDestination = null;
- }
- return $renderer->render($outputDestination);
- }
- }
|