Subversion Repositories eFlore/Applications.cel

<?php

/**

 * PHPExcel

 *

 * Copyright (c) 2006 - 2013 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 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)

 * @license		http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt	LGPL

 * @version	##VERSION##, ##DATE##

 */

/**

 * PHPExcel_Chart_DataSeries

 *

 * @category	PHPExcel

 * @package		PHPExcel_Chart

 * @copyright	Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)

 */

class PHPExcel_Chart_DataSeries

{

	const TYPE_BARCHART			= 'barChart';

	const TYPE_BARCHART_3D		= 'bar3DChart';

	const TYPE_LINECHART		= 'lineChart';

	const TYPE_LINECHART_3D		= 'line3DChart';

	const TYPE_AREACHART		= 'areaChart';

	const TYPE_AREACHART_3D		= 'area3DChart';

	const TYPE_PIECHART			= 'pieChart';

	const TYPE_PIECHART_3D		= 'pie3DChart';

	const TYPE_DOUGHTNUTCHART	= 'doughnutChart';

	const TYPE_DONUTCHART		= self::TYPE_DOUGHTNUTCHART;	//	Synonym

	const TYPE_SCATTERCHART		= 'scatterChart';

	const TYPE_SURFACECHART		= 'surfaceChart';

	const TYPE_SURFACECHART_3D	= 'surface3DChart';

	const TYPE_RADARCHART		= 'radarChart';

	const TYPE_BUBBLECHART		= 'bubbleChart';

	const TYPE_STOCKCHART		= 'stockChart';

	const GROUPING_CLUSTERED			= 'clustered';

	const GROUPING_STACKED				= 'stacked';

	const GROUPING_PERCENT_STACKED		= 'percentStacked';

	const GROUPING_STANDARD				= 'standard';

	const DIRECTION_BAR			= 'bar';

	const DIRECTION_HORIZONTAL	= self::DIRECTION_BAR;

	const DIRECTION_COL			= 'col';

	const DIRECTION_COLUMN		= self::DIRECTION_COL;

	const DIRECTION_VERTICAL	= self::DIRECTION_COL;

	const STYLE_LINEMARKER		= 'lineMarker';

	const STYLE_SMOOTHMARKER	= 'smoothMarker';

	const STYLE_MARKER			= 'marker';

	const STYLE_FILLED			= 'filled';

	/**

	 * Series Plot Type

	 *

	 * @var string

	 */

	private $_plotType = null;

	/**

	 * Plot Grouping Type

	 *

	 * @var boolean

	 */

	private $_plotGrouping = null;

	/**

	 * Plot Direction

	 *

	 * @var boolean

	 */

	private $_plotDirection = null;

	/**

	 * Plot Style

	 *

	 * @var string

	 */

	private $_plotStyle = null;

	/**

	 * Order of plots in Series

	 *

	 * @var array of integer

	 */

	private $_plotOrder = array();

	/**

	 * Plot Label

	 *

	 * @var array of PHPExcel_Chart_DataSeriesValues

	 */

	private $_plotLabel = array();

	/**

	 * Plot Category

	 *

	 * @var array of PHPExcel_Chart_DataSeriesValues

	 */

	private $_plotCategory = array();

	/**

	 * Smooth Line

	 *

	 * @var string

	 */

	private $_smoothLine = null;

	/**

	 * Plot Values

	 *

	 * @var array of PHPExcel_Chart_DataSeriesValues

	 */

	private $_plotValues = array();

	/**

	 * Create a new PHPExcel_Chart_DataSeries

	 */

	public function __construct($plotType = null, $plotGrouping = null, $plotOrder = array(), $plotLabel = array(), $plotCategory = array(), $plotValues = array(), $smoothLine = null, $plotStyle = null)

	{

		$this->_plotType = $plotType;

		$this->_plotGrouping = $plotGrouping;

		$this->_plotOrder = $plotOrder;

		$keys = array_keys($plotValues);

		$this->_plotValues = $plotValues;

		if ((count($plotLabel) == 0) || (is_null($plotLabel[$keys[0]]))) {

			$plotLabel[$keys[0]] = new PHPExcel_Chart_DataSeriesValues();

		}

		$this->_plotLabel = $plotLabel;

		if ((count($plotCategory) == 0) || (is_null($plotCategory[$keys[0]]))) {

			$plotCategory[$keys[0]] = new PHPExcel_Chart_DataSeriesValues();

		}

		$this->_plotCategory = $plotCategory;

		$this->_smoothLine = $smoothLine;

		$this->_plotStyle = $plotStyle;

	}

	/**

	 * Get Plot Type

	 *

	 * @return string

	 */

	public function getPlotType() {

		return $this->_plotType;

	}

	/**

	 * Set Plot Type

	 *

	 * @param string $plotType

	 */

	public function setPlotType($plotType = '') {

		$this->_plotType = $plotType;

	}

	/**

	 * Get Plot Grouping Type

	 *

	 * @return string

	 */

	public function getPlotGrouping() {

		return $this->_plotGrouping;

	}

	/**

	 * Set Plot Grouping Type

	 *

	 * @param string $groupingType

	 */

	public function setPlotGrouping($groupingType = null) {

		$this->_plotGrouping = $groupingType;

	}

	/**

	 * Get Plot Direction

	 *

	 * @return string

	 */

	public function getPlotDirection() {

		return $this->_plotDirection;

	}

	/**

	 * Set Plot Direction

	 *

	 * @param string $plotDirection

	 */

	public function setPlotDirection($plotDirection = null) {

		$this->_plotDirection = $plotDirection;

	}

	/**

	 * Get Plot Order

	 *

	 * @return string

	 */

	public function getPlotOrder() {

		return $this->_plotOrder;

	}

	/**

	 * Get Plot Labels

	 *

	 * @return array of PHPExcel_Chart_DataSeriesValues

	 */

	public function getPlotLabels() {

		return $this->_plotLabel;

	}

	/**

	 * Get Plot Label by Index

	 *

	 * @return PHPExcel_Chart_DataSeriesValues

	 */

	public function getPlotLabelByIndex($index) {

		$keys = array_keys($this->_plotLabel);

		if (in_array($index,$keys)) {

			return $this->_plotLabel[$index];

		} elseif(isset($keys[$index])) {

			return $this->_plotLabel[$keys[$index]];

		}

		return false;

	}

	/**

	 * Get Plot Categories

	 *

	 * @return array of PHPExcel_Chart_DataSeriesValues

	 */

	public function getPlotCategories() {

		return $this->_plotCategory;

	}

	/**

	 * Get Plot Category by Index

	 *

	 * @return PHPExcel_Chart_DataSeriesValues

	 */

	public function getPlotCategoryByIndex($index) {

		$keys = array_keys($this->_plotCategory);

		if (in_array($index,$keys)) {

			return $this->_plotCategory[$index];

		} elseif(isset($keys[$index])) {

			return $this->_plotCategory[$keys[$index]];

		}

		return false;

	}

	/**

	 * Get Plot Style

	 *

	 * @return string

	 */

	public function getPlotStyle() {

		return $this->_plotStyle;

	}

	/**

	 * Set Plot Style

	 *

	 * @param string $plotStyle

	 */

	public function setPlotStyle($plotStyle = null) {

		$this->_plotStyle = $plotStyle;

	}

	/**

	 * Get Plot Values

	 *

	 * @return array of PHPExcel_Chart_DataSeriesValues

	 */

	public function getPlotValues() {

		return $this->_plotValues;

	}

	/**

	 * Get Plot Values by Index

	 *

	 * @return PHPExcel_Chart_DataSeriesValues

	 */

	public function getPlotValuesByIndex($index) {

		$keys = array_keys($this->_plotValues);

		if (in_array($index,$keys)) {

			return $this->_plotValues[$index];

		} elseif(isset($keys[$index])) {

			return $this->_plotValues[$keys[$index]];

		}

		return false;

	}

	/**

	 * Get Number of Plot Series

	 *

	 * @return integer

	 */

	public function getPlotSeriesCount() {

		return count($this->_plotValues);

	}

	/**

	 * Get Smooth Line

	 *

	 * @return boolean

	 */

	public function getSmoothLine() {

		return $this->_smoothLine;

	}

	/**

	 * Set Smooth Line

	 *

	 * @param boolean $smoothLine

	 */

	public function setSmoothLine($smoothLine = TRUE) {

		$this->_smoothLine = $smoothLine;

	}

	public function refresh(PHPExcel_Worksheet $worksheet) {

	    foreach($this->_plotValues as $plotValues) {

			if ($plotValues !== NULL)

				$plotValues->refresh($worksheet, TRUE);

		}

		foreach($this->_plotLabel as $plotValues) {

			if ($plotValues !== NULL)

				$plotValues->refresh($worksheet, TRUE);

		}

		foreach($this->_plotCategory as $plotValues) {

			if ($plotValues !== NULL)

				$plotValues->refresh($worksheet, FALSE);

		}

	}

}