diff options
Diffstat (limited to 'admin/survey/excel/PHPExcel/Chart/DataSeriesValues.php')
| -rw-r--r-- | admin/survey/excel/PHPExcel/Chart/DataSeriesValues.php | 321 |
1 files changed, 321 insertions, 0 deletions
diff --git a/admin/survey/excel/PHPExcel/Chart/DataSeriesValues.php b/admin/survey/excel/PHPExcel/Chart/DataSeriesValues.php new file mode 100644 index 0000000..223aa82 --- /dev/null +++ b/admin/survey/excel/PHPExcel/Chart/DataSeriesValues.php @@ -0,0 +1,321 @@ +<?php
+/**
+ * PHPExcel
+ *
+ * Copyright (c) 2006 - 2012 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 - 2012 PHPExcel (http://www.codeplex.com/PHPExcel)
+ * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
+ * @version 1.7.8, 2012-10-12
+ */
+
+
+/**
+ * PHPExcel_Chart_DataSeriesValues
+ *
+ * @category PHPExcel
+ * @package PHPExcel_Chart
+ * @copyright Copyright (c) 2006 - 2012 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();
+ $newDataValues = PHPExcel_Calculation::_unwrapResult(
+ $calcEngine->_calculateFormulaValue(
+ '='.$this->_dataSource,
+ NULL,
+ $worksheet->getCell('A1')
+ )
+ );
+ if ($flatten) {
+ $this->_dataValues = PHPExcel_Calculation_Functions::flattenArray($newDataValues);
+ } 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);
+ }
+
+ }
+
+}
|