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_DataSeriesValues

 *

 * @category	PHPExcel

 * @package		PHPExcel_Chart

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

 */

class PHPExcel_Chart_DataSeriesValues

{

	const DATASERIES_TYPE_STRING	= 'String';

	const DATASERIES_TYPE_NUMBER	= 'Number';

	private static $_dataTypeValues = array(

		self::DATASERIES_TYPE_STRING,

		self::DATASERIES_TYPE_NUMBER,

	);

	/**

	 * Series Data Type

	 *

	 * @var	string

	 */

	private $_dataType = null;

	/**

	 * Series Data Source

	 *

	 * @var	string

	 */

	private $_dataSource = null;

	/**

	 * Format Code

	 *

	 * @var	string

	 */

	private $_formatCode = null;

	/**

	 * Series Point Marker

	 *

	 * @var	string

	 */

	private $_marker = null;

	/**

	 * Point Count (The number of datapoints in the dataseries)

	 *

	 * @var	integer

	 */

	private $_pointCount = 0;

	/**

	 * Data Values

	 *

	 * @var	array of mixed

	 */

	private $_dataValues = array();

	/**

	 * Create a new PHPExcel_Chart_DataSeriesValues object

	 */

	public function __construct($dataType = self::DATASERIES_TYPE_NUMBER, $dataSource = null, $formatCode = null, $pointCount = 0, $dataValues = array(), $marker = null)

	{

		$this->setDataType($dataType);

		$this->_dataSource = $dataSource;

		$this->_formatCode = $formatCode;

		$this->_pointCount = $pointCount;

		$this->_dataValues = $dataValues;

		$this->_marker = $marker;

	}

	/**

	 * Get Series Data Type

	 *

	 * @return	string

	 */

	public function getDataType() {

		return $this->_dataType;

	}

	/**

	 * Set Series Data Type

	 *

	 * @param	string	$dataType	Datatype of this data series

	 *								Typical values are:

	 *									PHPExcel_Chart_DataSeriesValues::DATASERIES_TYPE_STRING

	 *										Normally used for axis point values

	 *									PHPExcel_Chart_DataSeriesValues::DATASERIES_TYPE_NUMBER

	 *										Normally used for chart data values

	 * @return	PHPExcel_Chart_DataSeriesValues

	 */

	public function setDataType($dataType = self::DATASERIES_TYPE_NUMBER) {

		if (!in_array($dataType, self::$_dataTypeValues)) {

    		throw new PHPExcel_Chart_Exception('Invalid datatype for chart data series values');

		}

		$this->_dataType = $dataType;

		return $this;

	}

	/**

	 * Get Series Data Source (formula)

	 *

	 * @return	string

	 */

	public function getDataSource() {

		return $this->_dataSource;

	}

	/**

	 * Set Series Data Source (formula)

	 *

	 * @param	string	$dataSource

	 * @return	PHPExcel_Chart_DataSeriesValues

	 */

	public function setDataSource($dataSource = null, $refreshDataValues = true) {

		$this->_dataSource = $dataSource;

		if ($refreshDataValues) {

			//	TO DO

		}

		return $this;

	}

	/**

	 * Get Point Marker

	 *

	 * @return string

	 */

	public function getPointMarker() {

		return $this->_marker;

	}

	/**

	 * Set Point Marker

	 *

	 * @param	string	$marker

	 * @return	PHPExcel_Chart_DataSeriesValues

	 */

	public function setPointMarker($marker = null) {

		$this->_marker = $marker;

		return $this;

	}

	/**

	 * Get Series Format Code

	 *

	 * @return	string

	 */

	public function getFormatCode() {

		return $this->_formatCode;

	}

	/**

	 * Set Series Format Code

	 *

	 * @param	string	$formatCode

	 * @return	PHPExcel_Chart_DataSeriesValues

	 */

	public function setFormatCode($formatCode = null) {

		$this->_formatCode = $formatCode;

		return $this;

	}

	/**

	 * Get Series Point Count

	 *

	 * @return	integer

	 */

	public function getPointCount() {

		return $this->_pointCount;

	}

	/**

	 * Identify if the Data Series is a multi-level or a simple series

	 *

	 * @return	boolean

	 */

	public function isMultiLevelSeries() {

		if (count($this->_dataValues) > 0) {

			return is_array($this->_dataValues[0]);

		}

		return null;

	}

	/**

	 * Return the level count of a multi-level Data Series

	 *

	 * @return	boolean

	 */

	public function multiLevelCount() {

		$levelCount = 0;

		foreach($this->_dataValues as $dataValueSet) {

			$levelCount = max($levelCount,count($dataValueSet));

		}

		return $levelCount;

	}

	/**

	 * Get Series Data Values

	 *

	 * @return	array of mixed

	 */

	public function getDataValues() {

		return $this->_dataValues;

	}

	/**

	 * Get the first Series Data value

	 *

	 * @return	mixed

	 */

	public function getDataValue() {

		$count = count($this->_dataValues);

		if ($count == 0) {

			return null;

		} elseif ($count == 1) {

			return $this->_dataValues[0];

		}

		return $this->_dataValues;

	}

	/**

	 * Set Series Data Values

	 *

	 * @param	array	$dataValues

	 * @param	boolean	$refreshDataSource

	 *					TRUE - refresh the value of _dataSource based on the values of $dataValues

	 *					FALSE - don't change the value of _dataSource

	 * @return	PHPExcel_Chart_DataSeriesValues

	 */

	public function setDataValues($dataValues = array(), $refreshDataSource = TRUE) {

		$this->_dataValues = PHPExcel_Calculation_Functions::flattenArray($dataValues);

		$this->_pointCount = count($dataValues);

		if ($refreshDataSource) {

			//	TO DO

		}

		return $this;

	}

	private function _stripNulls($var) {

		return $var !== NULL;

	}

	public function refresh(PHPExcel_Worksheet $worksheet, $flatten = TRUE) {

        if ($this->_dataSource !== NULL) {

        	$calcEngine = PHPExcel_Calculation::getInstance($worksheet->getParent());

			$newDataValues = PHPExcel_Calculation::_unwrapResult(

			    $calcEngine->_calculateFormulaValue(

			        '='.$this->_dataSource,

			        NULL,

			        $worksheet->getCell('A1')

			    )

			);

			if ($flatten) {

				$this->_dataValues = PHPExcel_Calculation_Functions::flattenArray($newDataValues);

				foreach($this->_dataValues as &$dataValue) {

					if ((!empty($dataValue)) && ($dataValue[0] == '#')) {

						$dataValue = 0.0;

					}

				}

				unset($dataValue);

			} else {

				$cellRange = explode('!',$this->_dataSource);

				if (count($cellRange) > 1) {

					list(,$cellRange) = $cellRange;

				}

				$dimensions = PHPExcel_Cell::rangeDimension(str_replace('$','',$cellRange));

				if (($dimensions[0] == 1) || ($dimensions[1] == 1)) {

					$this->_dataValues = PHPExcel_Calculation_Functions::flattenArray($newDataValues);

				} else {

					$newArray = array_values(array_shift($newDataValues));

					foreach($newArray as $i => $newDataSet) {

						$newArray[$i] = array($newDataSet);

					}

					foreach($newDataValues as $newDataSet) {

						$i = 0;

						foreach($newDataSet as $newDataVal) {

							array_unshift($newArray[$i++],$newDataVal);

						}

					}

					$this->_dataValues = $newArray;

				}

			}

			$this->_pointCount = count($this->_dataValues);

		}

	}

}