123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333 |
- <?php
- 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,
- );
-
- private $dataType;
-
- private $dataSource;
-
- private $formatCode;
-
- private $pointMarker;
-
- private $pointCount = 0;
-
- private $dataValues = array();
-
- 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->pointMarker = $marker;
- }
-
- public function getDataType()
- {
- return $this->dataType;
- }
-
- 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;
- }
-
- public function getDataSource()
- {
- return $this->dataSource;
- }
-
- public function setDataSource($dataSource = null, $refreshDataValues = true)
- {
- $this->dataSource = $dataSource;
- if ($refreshDataValues) {
-
- }
- return $this;
- }
-
- public function getPointMarker()
- {
- return $this->pointMarker;
- }
-
- public function setPointMarker($marker = null)
- {
- $this->pointMarker = $marker;
- return $this;
- }
-
- public function getFormatCode()
- {
- return $this->formatCode;
- }
-
- public function setFormatCode($formatCode = null)
- {
- $this->formatCode = $formatCode;
- return $this;
- }
-
- public function getPointCount()
- {
- return $this->pointCount;
- }
-
- public function isMultiLevelSeries()
- {
- if (count($this->dataValues) > 0) {
- return is_array($this->dataValues[0]);
- }
- return null;
- }
-
- public function multiLevelCount()
- {
- $levelCount = 0;
- foreach ($this->dataValues as $dataValueSet) {
- $levelCount = max($levelCount, count($dataValueSet));
- }
- return $levelCount;
- }
-
- public function getDataValues()
- {
- return $this->dataValues;
- }
-
- public function getDataValue()
- {
- $count = count($this->dataValues);
- if ($count == 0) {
- return null;
- } elseif ($count == 1) {
- return $this->dataValues[0];
- }
- return $this->dataValues;
- }
-
- public function setDataValues($dataValues = array(), $refreshDataSource = true)
- {
- $this->dataValues = PHPExcel_Calculation_Functions::flattenArray($dataValues);
- $this->pointCount = count($dataValues);
- if ($refreshDataSource) {
-
- }
- 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);
- }
- }
- }
|