diff options
author | Anton Luka Šijanec <anton@sijanec.eu> | 2024-05-27 13:12:17 +0200 |
---|---|---|
committer | Anton Luka Šijanec <anton@sijanec.eu> | 2024-05-27 13:12:17 +0200 |
commit | f1ab2f022fdc780aca0944d90e9a0e844a0820d7 (patch) | |
tree | 79942a40514f5ab40c5901349c9fcd30c6c8dc0e /admin/survey/excel/PHPExcel/Chart/DataSeriesValues.php | |
parent | 2024-02-19 upstream (diff) | |
download | 1ka-master.tar 1ka-master.tar.gz 1ka-master.tar.bz2 1ka-master.tar.lz 1ka-master.tar.xz 1ka-master.tar.zst 1ka-master.zip |
Diffstat (limited to 'admin/survey/excel/PHPExcel/Chart/DataSeriesValues.php')
-rw-r--r-- | admin/survey/excel/PHPExcel/Chart/DataSeriesValues.php | 321 |
1 files changed, 0 insertions, 321 deletions
diff --git a/admin/survey/excel/PHPExcel/Chart/DataSeriesValues.php b/admin/survey/excel/PHPExcel/Chart/DataSeriesValues.php deleted file mode 100644 index 223aa82..0000000 --- a/admin/survey/excel/PHPExcel/Chart/DataSeriesValues.php +++ /dev/null @@ -1,321 +0,0 @@ -<?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);
- }
-
- }
-
-}
|