New file |
0,0 → 1,354 |
<?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); |
} |
} |
|
} |