1 | <?php |
---|
2 | /** |
---|
3 | * PHPExcel |
---|
4 | * |
---|
5 | * Copyright (c) 2006 - 2014 PHPExcel |
---|
6 | * |
---|
7 | * This library is free software; you can redistribute it and/or |
---|
8 | * modify it under the terms of the GNU Lesser General Public |
---|
9 | * License as published by the Free Software Foundation; either |
---|
10 | * version 2.1 of the License, or (at your option) any later version. |
---|
11 | * |
---|
12 | * This library is distributed in the hope that it will be useful, |
---|
13 | * but WITHOUT ANY WARRANTY; without even the implied warranty of |
---|
14 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
---|
15 | * Lesser General Public License for more details. |
---|
16 | * |
---|
17 | * You should have received a copy of the GNU Lesser General Public |
---|
18 | * License along with this library; if not, write to the Free Software |
---|
19 | * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA |
---|
20 | * |
---|
21 | * @category PHPExcel |
---|
22 | * @package PHPExcel_Chart |
---|
23 | * @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel) |
---|
24 | * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL |
---|
25 | * @version 1.8.0, 2014-03-02 |
---|
26 | */ |
---|
27 | |
---|
28 | |
---|
29 | /** |
---|
30 | * PHPExcel_Chart_DataSeries |
---|
31 | * |
---|
32 | * @category PHPExcel |
---|
33 | * @package PHPExcel_Chart |
---|
34 | * @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel) |
---|
35 | */ |
---|
36 | class PHPExcel_Chart_DataSeries |
---|
37 | { |
---|
38 | |
---|
39 | const TYPE_BARCHART = 'barChart'; |
---|
40 | const TYPE_BARCHART_3D = 'bar3DChart'; |
---|
41 | const TYPE_LINECHART = 'lineChart'; |
---|
42 | const TYPE_LINECHART_3D = 'line3DChart'; |
---|
43 | const TYPE_AREACHART = 'areaChart'; |
---|
44 | const TYPE_AREACHART_3D = 'area3DChart'; |
---|
45 | const TYPE_PIECHART = 'pieChart'; |
---|
46 | const TYPE_PIECHART_3D = 'pie3DChart'; |
---|
47 | const TYPE_DOUGHTNUTCHART = 'doughnutChart'; |
---|
48 | const TYPE_DONUTCHART = self::TYPE_DOUGHTNUTCHART; // Synonym |
---|
49 | const TYPE_SCATTERCHART = 'scatterChart'; |
---|
50 | const TYPE_SURFACECHART = 'surfaceChart'; |
---|
51 | const TYPE_SURFACECHART_3D = 'surface3DChart'; |
---|
52 | const TYPE_RADARCHART = 'radarChart'; |
---|
53 | const TYPE_BUBBLECHART = 'bubbleChart'; |
---|
54 | const TYPE_STOCKCHART = 'stockChart'; |
---|
55 | const TYPE_CANDLECHART = self::TYPE_STOCKCHART; // Synonym |
---|
56 | |
---|
57 | const GROUPING_CLUSTERED = 'clustered'; |
---|
58 | const GROUPING_STACKED = 'stacked'; |
---|
59 | const GROUPING_PERCENT_STACKED = 'percentStacked'; |
---|
60 | const GROUPING_STANDARD = 'standard'; |
---|
61 | |
---|
62 | const DIRECTION_BAR = 'bar'; |
---|
63 | const DIRECTION_HORIZONTAL = self::DIRECTION_BAR; |
---|
64 | const DIRECTION_COL = 'col'; |
---|
65 | const DIRECTION_COLUMN = self::DIRECTION_COL; |
---|
66 | const DIRECTION_VERTICAL = self::DIRECTION_COL; |
---|
67 | |
---|
68 | const STYLE_LINEMARKER = 'lineMarker'; |
---|
69 | const STYLE_SMOOTHMARKER = 'smoothMarker'; |
---|
70 | const STYLE_MARKER = 'marker'; |
---|
71 | const STYLE_FILLED = 'filled'; |
---|
72 | |
---|
73 | |
---|
74 | /** |
---|
75 | * Series Plot Type |
---|
76 | * |
---|
77 | * @var string |
---|
78 | */ |
---|
79 | private $_plotType = null; |
---|
80 | |
---|
81 | /** |
---|
82 | * Plot Grouping Type |
---|
83 | * |
---|
84 | * @var boolean |
---|
85 | */ |
---|
86 | private $_plotGrouping = null; |
---|
87 | |
---|
88 | /** |
---|
89 | * Plot Direction |
---|
90 | * |
---|
91 | * @var boolean |
---|
92 | */ |
---|
93 | private $_plotDirection = null; |
---|
94 | |
---|
95 | /** |
---|
96 | * Plot Style |
---|
97 | * |
---|
98 | * @var string |
---|
99 | */ |
---|
100 | private $_plotStyle = null; |
---|
101 | |
---|
102 | /** |
---|
103 | * Order of plots in Series |
---|
104 | * |
---|
105 | * @var array of integer |
---|
106 | */ |
---|
107 | private $_plotOrder = array(); |
---|
108 | |
---|
109 | /** |
---|
110 | * Plot Label |
---|
111 | * |
---|
112 | * @var array of PHPExcel_Chart_DataSeriesValues |
---|
113 | */ |
---|
114 | private $_plotLabel = array(); |
---|
115 | |
---|
116 | /** |
---|
117 | * Plot Category |
---|
118 | * |
---|
119 | * @var array of PHPExcel_Chart_DataSeriesValues |
---|
120 | */ |
---|
121 | private $_plotCategory = array(); |
---|
122 | |
---|
123 | /** |
---|
124 | * Smooth Line |
---|
125 | * |
---|
126 | * @var string |
---|
127 | */ |
---|
128 | private $_smoothLine = null; |
---|
129 | |
---|
130 | /** |
---|
131 | * Plot Values |
---|
132 | * |
---|
133 | * @var array of PHPExcel_Chart_DataSeriesValues |
---|
134 | */ |
---|
135 | private $_plotValues = array(); |
---|
136 | |
---|
137 | /** |
---|
138 | * Create a new PHPExcel_Chart_DataSeries |
---|
139 | */ |
---|
140 | public function __construct($plotType = null, $plotGrouping = null, $plotOrder = array(), $plotLabel = array(), $plotCategory = array(), $plotValues = array(), $smoothLine = null, $plotStyle = null) |
---|
141 | { |
---|
142 | $this->_plotType = $plotType; |
---|
143 | $this->_plotGrouping = $plotGrouping; |
---|
144 | $this->_plotOrder = $plotOrder; |
---|
145 | $keys = array_keys($plotValues); |
---|
146 | $this->_plotValues = $plotValues; |
---|
147 | if ((count($plotLabel) == 0) || (is_null($plotLabel[$keys[0]]))) { |
---|
148 | $plotLabel[$keys[0]] = new PHPExcel_Chart_DataSeriesValues(); |
---|
149 | } |
---|
150 | |
---|
151 | $this->_plotLabel = $plotLabel; |
---|
152 | if ((count($plotCategory) == 0) || (is_null($plotCategory[$keys[0]]))) { |
---|
153 | $plotCategory[$keys[0]] = new PHPExcel_Chart_DataSeriesValues(); |
---|
154 | } |
---|
155 | $this->_plotCategory = $plotCategory; |
---|
156 | $this->_smoothLine = $smoothLine; |
---|
157 | $this->_plotStyle = $plotStyle; |
---|
158 | } |
---|
159 | |
---|
160 | /** |
---|
161 | * Get Plot Type |
---|
162 | * |
---|
163 | * @return string |
---|
164 | */ |
---|
165 | public function getPlotType() { |
---|
166 | return $this->_plotType; |
---|
167 | } |
---|
168 | |
---|
169 | /** |
---|
170 | * Set Plot Type |
---|
171 | * |
---|
172 | * @param string $plotType |
---|
173 | * @return PHPExcel_Chart_DataSeries |
---|
174 | */ |
---|
175 | public function setPlotType($plotType = '') { |
---|
176 | $this->_plotType = $plotType; |
---|
177 | return $this; |
---|
178 | } |
---|
179 | |
---|
180 | /** |
---|
181 | * Get Plot Grouping Type |
---|
182 | * |
---|
183 | * @return string |
---|
184 | */ |
---|
185 | public function getPlotGrouping() { |
---|
186 | return $this->_plotGrouping; |
---|
187 | } |
---|
188 | |
---|
189 | /** |
---|
190 | * Set Plot Grouping Type |
---|
191 | * |
---|
192 | * @param string $groupingType |
---|
193 | * @return PHPExcel_Chart_DataSeries |
---|
194 | */ |
---|
195 | public function setPlotGrouping($groupingType = null) { |
---|
196 | $this->_plotGrouping = $groupingType; |
---|
197 | return $this; |
---|
198 | } |
---|
199 | |
---|
200 | /** |
---|
201 | * Get Plot Direction |
---|
202 | * |
---|
203 | * @return string |
---|
204 | */ |
---|
205 | public function getPlotDirection() { |
---|
206 | return $this->_plotDirection; |
---|
207 | } |
---|
208 | |
---|
209 | /** |
---|
210 | * Set Plot Direction |
---|
211 | * |
---|
212 | * @param string $plotDirection |
---|
213 | * @return PHPExcel_Chart_DataSeries |
---|
214 | */ |
---|
215 | public function setPlotDirection($plotDirection = null) { |
---|
216 | $this->_plotDirection = $plotDirection; |
---|
217 | return $this; |
---|
218 | } |
---|
219 | |
---|
220 | /** |
---|
221 | * Get Plot Order |
---|
222 | * |
---|
223 | * @return string |
---|
224 | */ |
---|
225 | public function getPlotOrder() { |
---|
226 | return $this->_plotOrder; |
---|
227 | } |
---|
228 | |
---|
229 | /** |
---|
230 | * Get Plot Labels |
---|
231 | * |
---|
232 | * @return array of PHPExcel_Chart_DataSeriesValues |
---|
233 | */ |
---|
234 | public function getPlotLabels() { |
---|
235 | return $this->_plotLabel; |
---|
236 | } |
---|
237 | |
---|
238 | /** |
---|
239 | * Get Plot Label by Index |
---|
240 | * |
---|
241 | * @return PHPExcel_Chart_DataSeriesValues |
---|
242 | */ |
---|
243 | public function getPlotLabelByIndex($index) { |
---|
244 | $keys = array_keys($this->_plotLabel); |
---|
245 | if (in_array($index,$keys)) { |
---|
246 | return $this->_plotLabel[$index]; |
---|
247 | } elseif(isset($keys[$index])) { |
---|
248 | return $this->_plotLabel[$keys[$index]]; |
---|
249 | } |
---|
250 | return false; |
---|
251 | } |
---|
252 | |
---|
253 | /** |
---|
254 | * Get Plot Categories |
---|
255 | * |
---|
256 | * @return array of PHPExcel_Chart_DataSeriesValues |
---|
257 | */ |
---|
258 | public function getPlotCategories() { |
---|
259 | return $this->_plotCategory; |
---|
260 | } |
---|
261 | |
---|
262 | /** |
---|
263 | * Get Plot Category by Index |
---|
264 | * |
---|
265 | * @return PHPExcel_Chart_DataSeriesValues |
---|
266 | */ |
---|
267 | public function getPlotCategoryByIndex($index) { |
---|
268 | $keys = array_keys($this->_plotCategory); |
---|
269 | if (in_array($index,$keys)) { |
---|
270 | return $this->_plotCategory[$index]; |
---|
271 | } elseif(isset($keys[$index])) { |
---|
272 | return $this->_plotCategory[$keys[$index]]; |
---|
273 | } |
---|
274 | return false; |
---|
275 | } |
---|
276 | |
---|
277 | /** |
---|
278 | * Get Plot Style |
---|
279 | * |
---|
280 | * @return string |
---|
281 | */ |
---|
282 | public function getPlotStyle() { |
---|
283 | return $this->_plotStyle; |
---|
284 | } |
---|
285 | |
---|
286 | /** |
---|
287 | * Set Plot Style |
---|
288 | * |
---|
289 | * @param string $plotStyle |
---|
290 | * @return PHPExcel_Chart_DataSeries |
---|
291 | */ |
---|
292 | public function setPlotStyle($plotStyle = null) { |
---|
293 | $this->_plotStyle = $plotStyle; |
---|
294 | return $this; |
---|
295 | } |
---|
296 | |
---|
297 | /** |
---|
298 | * Get Plot Values |
---|
299 | * |
---|
300 | * @return array of PHPExcel_Chart_DataSeriesValues |
---|
301 | */ |
---|
302 | public function getPlotValues() { |
---|
303 | return $this->_plotValues; |
---|
304 | } |
---|
305 | |
---|
306 | /** |
---|
307 | * Get Plot Values by Index |
---|
308 | * |
---|
309 | * @return PHPExcel_Chart_DataSeriesValues |
---|
310 | */ |
---|
311 | public function getPlotValuesByIndex($index) { |
---|
312 | $keys = array_keys($this->_plotValues); |
---|
313 | if (in_array($index,$keys)) { |
---|
314 | return $this->_plotValues[$index]; |
---|
315 | } elseif(isset($keys[$index])) { |
---|
316 | return $this->_plotValues[$keys[$index]]; |
---|
317 | } |
---|
318 | return false; |
---|
319 | } |
---|
320 | |
---|
321 | /** |
---|
322 | * Get Number of Plot Series |
---|
323 | * |
---|
324 | * @return integer |
---|
325 | */ |
---|
326 | public function getPlotSeriesCount() { |
---|
327 | return count($this->_plotValues); |
---|
328 | } |
---|
329 | |
---|
330 | /** |
---|
331 | * Get Smooth Line |
---|
332 | * |
---|
333 | * @return boolean |
---|
334 | */ |
---|
335 | public function getSmoothLine() { |
---|
336 | return $this->_smoothLine; |
---|
337 | } |
---|
338 | |
---|
339 | /** |
---|
340 | * Set Smooth Line |
---|
341 | * |
---|
342 | * @param boolean $smoothLine |
---|
343 | * @return PHPExcel_Chart_DataSeries |
---|
344 | */ |
---|
345 | public function setSmoothLine($smoothLine = TRUE) { |
---|
346 | $this->_smoothLine = $smoothLine; |
---|
347 | return $this; |
---|
348 | } |
---|
349 | |
---|
350 | public function refresh(PHPExcel_Worksheet $worksheet) { |
---|
351 | foreach($this->_plotValues as $plotValues) { |
---|
352 | if ($plotValues !== NULL) |
---|
353 | $plotValues->refresh($worksheet, TRUE); |
---|
354 | } |
---|
355 | foreach($this->_plotLabel as $plotValues) { |
---|
356 | if ($plotValues !== NULL) |
---|
357 | $plotValues->refresh($worksheet, TRUE); |
---|
358 | } |
---|
359 | foreach($this->_plotCategory as $plotValues) { |
---|
360 | if ($plotValues !== NULL) |
---|
361 | $plotValues->refresh($worksheet, FALSE); |
---|
362 | } |
---|
363 | } |
---|
364 | |
---|
365 | } |
---|