123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680 |
- <?php
- namespace PhpOffice\PhpSpreadsheet\Chart;
- use PhpOffice\PhpSpreadsheet\Settings;
- use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
- class Chart
- {
- /**
- * Chart Name.
- *
- * @var string
- */
- private $name = '';
- /**
- * Worksheet.
- *
- * @var Worksheet
- */
- private $worksheet;
- /**
- * Chart Title.
- *
- * @var Title
- */
- private $title;
- /**
- * Chart Legend.
- *
- * @var Legend
- */
- private $legend;
- /**
- * X-Axis Label.
- *
- * @var Title
- */
- private $xAxisLabel;
- /**
- * Y-Axis Label.
- *
- * @var Title
- */
- private $yAxisLabel;
- /**
- * Chart Plot Area.
- *
- * @var PlotArea
- */
- private $plotArea;
- /**
- * Plot Visible Only.
- *
- * @var bool
- */
- private $plotVisibleOnly = true;
- /**
- * Display Blanks as.
- *
- * @var string
- */
- private $displayBlanksAs = '0';
- /**
- * Chart Asix Y as.
- *
- * @var Axis
- */
- private $yAxis;
- /**
- * Chart Asix X as.
- *
- * @var Axis
- */
- private $xAxis;
- /**
- * Chart Major Gridlines as.
- *
- * @var GridLines
- */
- private $majorGridlines;
- /**
- * Chart Minor Gridlines as.
- *
- * @var GridLines
- */
- private $minorGridlines;
- /**
- * Top-Left Cell Position.
- *
- * @var string
- */
- private $topLeftCellRef = 'A1';
- /**
- * Top-Left X-Offset.
- *
- * @var int
- */
- private $topLeftXOffset = 0;
- /**
- * Top-Left Y-Offset.
- *
- * @var int
- */
- private $topLeftYOffset = 0;
- /**
- * Bottom-Right Cell Position.
- *
- * @var string
- */
- private $bottomRightCellRef = 'A1';
- /**
- * Bottom-Right X-Offset.
- *
- * @var int
- */
- private $bottomRightXOffset = 10;
- /**
- * Bottom-Right Y-Offset.
- *
- * @var int
- */
- private $bottomRightYOffset = 10;
- /**
- * Create a new Chart.
- *
- * @param mixed $name
- * @param null|Title $title
- * @param null|Legend $legend
- * @param null|PlotArea $plotArea
- * @param mixed $plotVisibleOnly
- * @param mixed $displayBlanksAs
- * @param null|Title $xAxisLabel
- * @param null|Title $yAxisLabel
- * @param null|Axis $xAxis
- * @param null|Axis $yAxis
- * @param null|GridLines $majorGridlines
- * @param null|GridLines $minorGridlines
- */
- public function __construct($name, Title $title = null, Legend $legend = null, PlotArea $plotArea = null, $plotVisibleOnly = true, $displayBlanksAs = '0', Title $xAxisLabel = null, Title $yAxisLabel = null, Axis $xAxis = null, Axis $yAxis = null, GridLines $majorGridlines = null, 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;
- }
- /**
- * Get Name.
- *
- * @return string
- */
- public function getName()
- {
- return $this->name;
- }
- /**
- * Get Worksheet.
- *
- * @return Worksheet
- */
- public function getWorksheet()
- {
- return $this->worksheet;
- }
- /**
- * Set Worksheet.
- *
- * @param Worksheet $pValue
- *
- * @return Chart
- */
- public function setWorksheet(Worksheet $pValue = null)
- {
- $this->worksheet = $pValue;
- return $this;
- }
- /**
- * Get Title.
- *
- * @return Title
- */
- public function getTitle()
- {
- return $this->title;
- }
- /**
- * Set Title.
- *
- * @param Title $title
- *
- * @return Chart
- */
- public function setTitle(Title $title)
- {
- $this->title = $title;
- return $this;
- }
- /**
- * Get Legend.
- *
- * @return Legend
- */
- public function getLegend()
- {
- return $this->legend;
- }
- /**
- * Set Legend.
- *
- * @param Legend $legend
- *
- * @return Chart
- */
- public function setLegend(Legend $legend)
- {
- $this->legend = $legend;
- return $this;
- }
- /**
- * Get X-Axis Label.
- *
- * @return Title
- */
- public function getXAxisLabel()
- {
- return $this->xAxisLabel;
- }
- /**
- * Set X-Axis Label.
- *
- * @param Title $label
- *
- * @return Chart
- */
- public function setXAxisLabel(Title $label)
- {
- $this->xAxisLabel = $label;
- return $this;
- }
- /**
- * Get Y-Axis Label.
- *
- * @return Title
- */
- public function getYAxisLabel()
- {
- return $this->yAxisLabel;
- }
- /**
- * Set Y-Axis Label.
- *
- * @param Title $label
- *
- * @return Chart
- */
- public function setYAxisLabel(Title $label)
- {
- $this->yAxisLabel = $label;
- return $this;
- }
- /**
- * Get Plot Area.
- *
- * @return PlotArea
- */
- public function getPlotArea()
- {
- return $this->plotArea;
- }
- /**
- * Get Plot Visible Only.
- *
- * @return bool
- */
- public function getPlotVisibleOnly()
- {
- return $this->plotVisibleOnly;
- }
- /**
- * Set Plot Visible Only.
- *
- * @param bool $plotVisibleOnly
- *
- * @return Chart
- */
- public function setPlotVisibleOnly($plotVisibleOnly)
- {
- $this->plotVisibleOnly = $plotVisibleOnly;
- return $this;
- }
- /**
- * Get Display Blanks as.
- *
- * @return string
- */
- public function getDisplayBlanksAs()
- {
- return $this->displayBlanksAs;
- }
- /**
- * Set Display Blanks as.
- *
- * @param string $displayBlanksAs
- *
- * @return Chart
- */
- public function setDisplayBlanksAs($displayBlanksAs)
- {
- $this->displayBlanksAs = $displayBlanksAs;
- return $this;
- }
- /**
- * Get yAxis.
- *
- * @return Axis
- */
- public function getChartAxisY()
- {
- if ($this->yAxis !== null) {
- return $this->yAxis;
- }
- return new Axis();
- }
- /**
- * Get xAxis.
- *
- * @return Axis
- */
- public function getChartAxisX()
- {
- if ($this->xAxis !== null) {
- return $this->xAxis;
- }
- return new Axis();
- }
- /**
- * Get Major Gridlines.
- *
- * @return GridLines
- */
- public function getMajorGridlines()
- {
- if ($this->majorGridlines !== null) {
- return $this->majorGridlines;
- }
- return new GridLines();
- }
- /**
- * Get Minor Gridlines.
- *
- * @return GridLines
- */
- public function getMinorGridlines()
- {
- if ($this->minorGridlines !== null) {
- return $this->minorGridlines;
- }
- return new GridLines();
- }
- /**
- * Set the Top Left position for the chart.
- *
- * @param string $cell
- * @param int $xOffset
- * @param int $yOffset
- *
- * @return Chart
- */
- public function setTopLeftPosition($cell, $xOffset = null, $yOffset = null)
- {
- $this->topLeftCellRef = $cell;
- if ($xOffset !== null) {
- $this->setTopLeftXOffset($xOffset);
- }
- if ($yOffset !== null) {
- $this->setTopLeftYOffset($yOffset);
- }
- return $this;
- }
- /**
- * Get the top left position of the chart.
- *
- * @return array an associative array containing the cell address, X-Offset and Y-Offset from the top left of that cell
- */
- public function getTopLeftPosition()
- {
- return [
- 'cell' => $this->topLeftCellRef,
- 'xOffset' => $this->topLeftXOffset,
- 'yOffset' => $this->topLeftYOffset,
- ];
- }
- /**
- * Get the cell address where the top left of the chart is fixed.
- *
- * @return string
- */
- public function getTopLeftCell()
- {
- return $this->topLeftCellRef;
- }
- /**
- * Set the Top Left cell position for the chart.
- *
- * @param string $cell
- *
- * @return Chart
- */
- public function setTopLeftCell($cell)
- {
- $this->topLeftCellRef = $cell;
- return $this;
- }
- /**
- * Set the offset position within the Top Left cell for the chart.
- *
- * @param int $xOffset
- * @param int $yOffset
- *
- * @return Chart
- */
- public function setTopLeftOffset($xOffset, $yOffset)
- {
- if ($xOffset !== null) {
- $this->setTopLeftXOffset($xOffset);
- }
- if ($yOffset !== null) {
- $this->setTopLeftYOffset($yOffset);
- }
- return $this;
- }
- /**
- * Get the offset position within the Top Left cell for the chart.
- *
- * @return int[]
- */
- public function getTopLeftOffset()
- {
- return [
- '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;
- }
- /**
- * Set the Bottom Right position of the chart.
- *
- * @param string $cell
- * @param int $xOffset
- * @param int $yOffset
- *
- * @return Chart
- */
- public function setBottomRightPosition($cell, $xOffset = null, $yOffset = null)
- {
- $this->bottomRightCellRef = $cell;
- if ($xOffset !== null) {
- $this->setBottomRightXOffset($xOffset);
- }
- if ($yOffset !== null) {
- $this->setBottomRightYOffset($yOffset);
- }
- return $this;
- }
- /**
- * Get the bottom right position of the chart.
- *
- * @return array an associative array containing the cell address, X-Offset and Y-Offset from the top left of that cell
- */
- public function getBottomRightPosition()
- {
- return [
- 'cell' => $this->bottomRightCellRef,
- 'xOffset' => $this->bottomRightXOffset,
- 'yOffset' => $this->bottomRightYOffset,
- ];
- }
- public function setBottomRightCell($cell)
- {
- $this->bottomRightCellRef = $cell;
- return $this;
- }
- /**
- * Get the cell address where the bottom right of the chart is fixed.
- *
- * @return string
- */
- public function getBottomRightCell()
- {
- return $this->bottomRightCellRef;
- }
- /**
- * Set the offset position within the Bottom Right cell for the chart.
- *
- * @param int $xOffset
- * @param int $yOffset
- *
- * @return Chart
- */
- public function setBottomRightOffset($xOffset, $yOffset)
- {
- if ($xOffset !== null) {
- $this->setBottomRightXOffset($xOffset);
- }
- if ($yOffset !== null) {
- $this->setBottomRightYOffset($yOffset);
- }
- return $this;
- }
- /**
- * Get the offset position within the Bottom Right cell for the chart.
- *
- * @return int[]
- */
- public function getBottomRightOffset()
- {
- return [
- '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);
- }
- }
- /**
- * Render the chart to given file (or stream).
- *
- * @param string $outputDestination Name of the file render to
- *
- * @return bool true on success
- */
- public function render($outputDestination = null)
- {
- if ($outputDestination == 'php://output') {
- $outputDestination = null;
- }
- $libraryName = Settings::getChartRenderer();
- if ($libraryName === null) {
- return false;
- }
- // Ensure that data series values are up-to-date before we render
- $this->refresh();
- $renderer = new $libraryName($this);
- return $renderer->render($outputDestination);
- }
- }
|