Something went wrong. Try again.
Open source inventory management system with php and mysql Invoice generation and easy to download invoice in PDF format Lightweight and ea…
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552<?php/** * PHPExcel * * Copyright (c) 2006 - 2014 PHPExcel * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License as published by the Free Software Foundation; either * version 2.1 of the License, or (at your option) any later version. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA * * @category PHPExcel * @package PHPExcel_Chart * @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel) * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL * @version 1.8.0, 2014-03-02 */
/** * PHPExcel_Chart * * @category PHPExcel * @package PHPExcel_Chart * @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel) */class PHPExcel_Chart{ /** * Chart Name * * @var string */ private $_name = '';
/** * Worksheet * * @var PHPExcel_Worksheet */ private $_worksheet = null;
/** * Chart Title * * @var PHPExcel_Chart_Title */ private $_title = null;
/** * Chart Legend * * @var PHPExcel_Chart_Legend */ private $_legend = null;
/** * X-Axis Label * * @var PHPExcel_Chart_Title */ private $_xAxisLabel = null;
/** * Y-Axis Label * * @var PHPExcel_Chart_Title */ private $_yAxisLabel = null;
/** * Chart Plot Area * * @var PHPExcel_Chart_PlotArea */ private $_plotArea = null;
/** * Plot Visible Only * * @var boolean */ private $_plotVisibleOnly = true;
/** * Display Blanks as * * @var string */ private $_displayBlanksAs = '0';
/** * Top-Left Cell Position * * @var string */ private $_topLeftCellRef = 'A1';
/** * Top-Left X-Offset * * @var integer */ private $_topLeftXOffset = 0;
/** * Top-Left Y-Offset * * @var integer */ private $_topLeftYOffset = 0;
/** * Bottom-Right Cell Position * * @var string */ private $_bottomRightCellRef = 'A1';
/** * Bottom-Right X-Offset * * @var integer */ private $_bottomRightXOffset = 10;
/** * Bottom-Right Y-Offset * * @var integer */ private $_bottomRightYOffset = 10;
/** * Create a new PHPExcel_Chart */ 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) { $this->_name = $name; $this->_title = $title; $this->_legend = $legend; $this->_xAxisLabel = $xAxisLabel; $this->_yAxisLabel = $yAxisLabel; $this->_plotArea = $plotArea; $this->_plotVisibleOnly = $plotVisibleOnly; $this->_displayBlanksAs = $displayBlanksAs; }
/** * Get Name * * @return string */ public function getName() { return $this->_name; }
/** * Get Worksheet * * @return PHPExcel_Worksheet */ public function getWorksheet() { return $this->_worksheet; }
/** * Set Worksheet * * @param PHPExcel_Worksheet $pValue * @throws PHPExcel_Chart_Exception * @return PHPExcel_Chart */ public function setWorksheet(PHPExcel_Worksheet $pValue = null) { $this->_worksheet = $pValue;
return $this; }
/** * Get Title * * @return PHPExcel_Chart_Title */ public function getTitle() { return $this->_title; }
/** * Set Title * * @param PHPExcel_Chart_Title $title * @return PHPExcel_Chart */ public function setTitle(PHPExcel_Chart_Title $title) { $this->_title = $title;
return $this; }
/** * Get Legend * * @return PHPExcel_Chart_Legend */ public function getLegend() { return $this->_legend; }
/** * Set Legend * * @param PHPExcel_Chart_Legend $legend * @return PHPExcel_Chart */ public function setLegend(PHPExcel_Chart_Legend $legend) { $this->_legend = $legend;
return $this; }
/** * Get X-Axis Label * * @return PHPExcel_Chart_Title */ public function getXAxisLabel() { return $this->_xAxisLabel; }
/** * Set X-Axis Label * * @param PHPExcel_Chart_Title $label * @return PHPExcel_Chart */ public function setXAxisLabel(PHPExcel_Chart_Title $label) { $this->_xAxisLabel = $label;
return $this; }
/** * Get Y-Axis Label * * @return PHPExcel_Chart_Title */ public function getYAxisLabel() { return $this->_yAxisLabel; }
/** * Set Y-Axis Label * * @param PHPExcel_Chart_Title $label * @return PHPExcel_Chart */ public function setYAxisLabel(PHPExcel_Chart_Title $label) { $this->_yAxisLabel = $label;
return $this; }
/** * Get Plot Area * * @return PHPExcel_Chart_PlotArea */ public function getPlotArea() { return $this->_plotArea; }
/** * Get Plot Visible Only * * @return boolean */ public function getPlotVisibleOnly() { return $this->_plotVisibleOnly; }
/** * Set Plot Visible Only * * @param boolean $plotVisibleOnly * @return PHPExcel_Chart */ public function setPlotVisibleOnly($plotVisibleOnly = true) { $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 PHPExcel_Chart */ public function setDisplayBlanksAs($displayBlanksAs = '0') { $this->_displayBlanksAs = $displayBlanksAs; }
/** * Set the Top Left position for the chart * * @param string $cell * @param integer $xOffset * @param integer $yOffset * @return PHPExcel_Chart */ 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; }
/** * 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 array( '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 PHPExcel_Chart */ public function setTopLeftCell($cell) { $this->_topLeftCellRef = $cell;
return $this; }
/** * Set the offset position within the Top Left cell for the chart * * @param integer $xOffset * @param integer $yOffset * @return PHPExcel_Chart */ public function setTopLeftOffset($xOffset=null,$yOffset=null) { if (!is_null($xOffset)) $this->setTopLeftXOffset($xOffset); if (!is_null($yOffset)) $this->setTopLeftYOffset($yOffset);
return $this; }
/** * Get the offset position within the Top Left cell for the chart * * @return integer[] */ 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; }
/** * Set the Bottom Right position of the chart * * @param string $cell * @param integer $xOffset * @param integer $yOffset * @return PHPExcel_Chart */ 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; }
/** * 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 array( '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 integer $xOffset * @param integer $yOffset * @return PHPExcel_Chart */ public function setBottomRightOffset($xOffset=null,$yOffset=null) { if (!is_null($xOffset)) $this->setBottomRightXOffset($xOffset); if (!is_null($yOffset)) $this->setBottomRightYOffset($yOffset);
return $this; }
/** * Get the offset position within the Bottom Right cell for the chart * * @return integer[] */ 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; } // Ensure that data series values are up-to-date before we render $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); }
}