@@ -42,82 +42,82 @@ discard block |
||
42 | 42 | */ |
43 | 43 | private $_path; |
44 | 44 | |
45 | - /** |
|
46 | - * Create a new PHPExcel_Worksheet_Drawing |
|
47 | - */ |
|
48 | - public function __construct() |
|
49 | - { |
|
50 | - // Initialise values |
|
51 | - $this->_path = ''; |
|
45 | + /** |
|
46 | + * Create a new PHPExcel_Worksheet_Drawing |
|
47 | + */ |
|
48 | + public function __construct() |
|
49 | + { |
|
50 | + // Initialise values |
|
51 | + $this->_path = ''; |
|
52 | 52 | |
53 | - // Initialize parent |
|
54 | - parent::__construct(); |
|
55 | - } |
|
53 | + // Initialize parent |
|
54 | + parent::__construct(); |
|
55 | + } |
|
56 | 56 | |
57 | - /** |
|
58 | - * Get Filename |
|
59 | - * |
|
60 | - * @return string |
|
61 | - */ |
|
62 | - public function getFilename() { |
|
63 | - return basename($this->_path); |
|
64 | - } |
|
57 | + /** |
|
58 | + * Get Filename |
|
59 | + * |
|
60 | + * @return string |
|
61 | + */ |
|
62 | + public function getFilename() { |
|
63 | + return basename($this->_path); |
|
64 | + } |
|
65 | 65 | |
66 | - /** |
|
67 | - * Get indexed filename (using image index) |
|
68 | - * |
|
69 | - * @return string |
|
70 | - */ |
|
71 | - public function getIndexedFilename() { |
|
72 | - $fileName = $this->getFilename(); |
|
73 | - $fileName = str_replace(' ', '_', $fileName); |
|
74 | - return str_replace('.' . $this->getExtension(), '', $fileName) . $this->getImageIndex() . '.' . $this->getExtension(); |
|
75 | - } |
|
66 | + /** |
|
67 | + * Get indexed filename (using image index) |
|
68 | + * |
|
69 | + * @return string |
|
70 | + */ |
|
71 | + public function getIndexedFilename() { |
|
72 | + $fileName = $this->getFilename(); |
|
73 | + $fileName = str_replace(' ', '_', $fileName); |
|
74 | + return str_replace('.' . $this->getExtension(), '', $fileName) . $this->getImageIndex() . '.' . $this->getExtension(); |
|
75 | + } |
|
76 | 76 | |
77 | - /** |
|
78 | - * Get Extension |
|
79 | - * |
|
80 | - * @return string |
|
81 | - */ |
|
82 | - public function getExtension() { |
|
83 | - $exploded = explode(".", basename($this->_path)); |
|
84 | - return $exploded[count($exploded) - 1]; |
|
85 | - } |
|
77 | + /** |
|
78 | + * Get Extension |
|
79 | + * |
|
80 | + * @return string |
|
81 | + */ |
|
82 | + public function getExtension() { |
|
83 | + $exploded = explode(".", basename($this->_path)); |
|
84 | + return $exploded[count($exploded) - 1]; |
|
85 | + } |
|
86 | 86 | |
87 | - /** |
|
88 | - * Get Path |
|
89 | - * |
|
90 | - * @return string |
|
91 | - */ |
|
92 | - public function getPath() { |
|
93 | - return $this->_path; |
|
94 | - } |
|
87 | + /** |
|
88 | + * Get Path |
|
89 | + * |
|
90 | + * @return string |
|
91 | + */ |
|
92 | + public function getPath() { |
|
93 | + return $this->_path; |
|
94 | + } |
|
95 | 95 | |
96 | - /** |
|
97 | - * Set Path |
|
98 | - * |
|
99 | - * @param string $pValue File path |
|
100 | - * @param boolean $pVerifyFile Verify file |
|
101 | - * @throws Exception |
|
102 | - * @return PHPExcel_Worksheet_Drawing |
|
103 | - */ |
|
104 | - public function setPath($pValue = '', $pVerifyFile = true) { |
|
105 | - if ($pVerifyFile) { |
|
106 | - if (file_exists($pValue)) { |
|
107 | - $this->_path = $pValue; |
|
96 | + /** |
|
97 | + * Set Path |
|
98 | + * |
|
99 | + * @param string $pValue File path |
|
100 | + * @param boolean $pVerifyFile Verify file |
|
101 | + * @throws Exception |
|
102 | + * @return PHPExcel_Worksheet_Drawing |
|
103 | + */ |
|
104 | + public function setPath($pValue = '', $pVerifyFile = true) { |
|
105 | + if ($pVerifyFile) { |
|
106 | + if (file_exists($pValue)) { |
|
107 | + $this->_path = $pValue; |
|
108 | 108 | |
109 | - if ($this->_width == 0 && $this->_height == 0) { |
|
110 | - // Get width/height |
|
111 | - list($this->_width, $this->_height) = getimagesize($pValue); |
|
112 | - } |
|
113 | - } else { |
|
114 | - throw new Exception("File $pValue not found!"); |
|
115 | - } |
|
116 | - } else { |
|
117 | - $this->_path = $pValue; |
|
118 | - } |
|
119 | - return $this; |
|
120 | - } |
|
109 | + if ($this->_width == 0 && $this->_height == 0) { |
|
110 | + // Get width/height |
|
111 | + list($this->_width, $this->_height) = getimagesize($pValue); |
|
112 | + } |
|
113 | + } else { |
|
114 | + throw new Exception("File $pValue not found!"); |
|
115 | + } |
|
116 | + } else { |
|
117 | + $this->_path = $pValue; |
|
118 | + } |
|
119 | + return $this; |
|
120 | + } |
|
121 | 121 | |
122 | 122 | /** |
123 | 123 | * Get hash code |
@@ -125,12 +125,12 @@ discard block |
||
125 | 125 | * @return string Hash code |
126 | 126 | */ |
127 | 127 | public function getHashCode() { |
128 | - return md5( |
|
129 | - $this->_path |
|
130 | - . parent::getHashCode() |
|
131 | - . __CLASS__ |
|
132 | - ); |
|
133 | - } |
|
128 | + return md5( |
|
129 | + $this->_path |
|
130 | + . parent::getHashCode() |
|
131 | + . __CLASS__ |
|
132 | + ); |
|
133 | + } |
|
134 | 134 | |
135 | 135 | /** |
136 | 136 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -48,7 +48,7 @@ discard block |
||
48 | 48 | public function __construct() |
49 | 49 | { |
50 | 50 | // Initialise values |
51 | - $this->_path = ''; |
|
51 | + $this->_path = ''; |
|
52 | 52 | |
53 | 53 | // Initialize parent |
54 | 54 | parent::__construct(); |
@@ -71,7 +71,7 @@ discard block |
||
71 | 71 | public function getIndexedFilename() { |
72 | 72 | $fileName = $this->getFilename(); |
73 | 73 | $fileName = str_replace(' ', '_', $fileName); |
74 | - return str_replace('.' . $this->getExtension(), '', $fileName) . $this->getImageIndex() . '.' . $this->getExtension(); |
|
74 | + return str_replace('.'.$this->getExtension(), '', $fileName).$this->getImageIndex().'.'.$this->getExtension(); |
|
75 | 75 | } |
76 | 76 | |
77 | 77 | /** |
@@ -37,13 +37,13 @@ discard block |
||
37 | 37 | { |
38 | 38 | /* Shadow alignment */ |
39 | 39 | const SHADOW_BOTTOM = 'b'; |
40 | - const SHADOW_BOTTOM_LEFT = 'bl'; |
|
41 | - const SHADOW_BOTTOM_RIGHT = 'br'; |
|
40 | + const SHADOW_BOTTOM_LEFT = 'bl'; |
|
41 | + const SHADOW_BOTTOM_RIGHT = 'br'; |
|
42 | 42 | const SHADOW_CENTER = 'ctr'; |
43 | - const SHADOW_LEFT = 'l'; |
|
44 | - const SHADOW_TOP = 't'; |
|
45 | - const SHADOW_TOP_LEFT = 'tl'; |
|
46 | - const SHADOW_TOP_RIGHT = 'tr'; |
|
43 | + const SHADOW_LEFT = 'l'; |
|
44 | + const SHADOW_TOP = 't'; |
|
45 | + const SHADOW_TOP_LEFT = 'tl'; |
|
46 | + const SHADOW_TOP_RIGHT = 'tr'; |
|
47 | 47 | |
48 | 48 | /** |
49 | 49 | * Visible |
@@ -105,7 +105,7 @@ discard block |
||
105 | 105 | { |
106 | 106 | // Initialise values |
107 | 107 | $this->_visible = false; |
108 | - $this->_blurRadius = 6; |
|
108 | + $this->_blurRadius = 6; |
|
109 | 109 | $this->_distance = 2; |
110 | 110 | $this->_direction = 0; |
111 | 111 | $this->_alignment = PHPExcel_Worksheet_Drawing_Shadow::SHADOW_BOTTOM_RIGHT; |
@@ -98,161 +98,161 @@ discard block |
||
98 | 98 | */ |
99 | 99 | private $_alpha; |
100 | 100 | |
101 | - /** |
|
102 | - * Create a new PHPExcel_Worksheet_Drawing_Shadow |
|
103 | - */ |
|
104 | - public function __construct() |
|
105 | - { |
|
106 | - // Initialise values |
|
107 | - $this->_visible = false; |
|
108 | - $this->_blurRadius = 6; |
|
109 | - $this->_distance = 2; |
|
110 | - $this->_direction = 0; |
|
111 | - $this->_alignment = PHPExcel_Worksheet_Drawing_Shadow::SHADOW_BOTTOM_RIGHT; |
|
112 | - $this->_color = new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_BLACK); |
|
113 | - $this->_alpha = 50; |
|
114 | - } |
|
101 | + /** |
|
102 | + * Create a new PHPExcel_Worksheet_Drawing_Shadow |
|
103 | + */ |
|
104 | + public function __construct() |
|
105 | + { |
|
106 | + // Initialise values |
|
107 | + $this->_visible = false; |
|
108 | + $this->_blurRadius = 6; |
|
109 | + $this->_distance = 2; |
|
110 | + $this->_direction = 0; |
|
111 | + $this->_alignment = PHPExcel_Worksheet_Drawing_Shadow::SHADOW_BOTTOM_RIGHT; |
|
112 | + $this->_color = new PHPExcel_Style_Color(PHPExcel_Style_Color::COLOR_BLACK); |
|
113 | + $this->_alpha = 50; |
|
114 | + } |
|
115 | 115 | |
116 | - /** |
|
117 | - * Get Visible |
|
118 | - * |
|
119 | - * @return boolean |
|
120 | - */ |
|
121 | - public function getVisible() { |
|
122 | - return $this->_visible; |
|
123 | - } |
|
116 | + /** |
|
117 | + * Get Visible |
|
118 | + * |
|
119 | + * @return boolean |
|
120 | + */ |
|
121 | + public function getVisible() { |
|
122 | + return $this->_visible; |
|
123 | + } |
|
124 | 124 | |
125 | - /** |
|
126 | - * Set Visible |
|
127 | - * |
|
128 | - * @param boolean $pValue |
|
129 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
130 | - */ |
|
131 | - public function setVisible($pValue = false) { |
|
132 | - $this->_visible = $pValue; |
|
133 | - return $this; |
|
134 | - } |
|
125 | + /** |
|
126 | + * Set Visible |
|
127 | + * |
|
128 | + * @param boolean $pValue |
|
129 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
130 | + */ |
|
131 | + public function setVisible($pValue = false) { |
|
132 | + $this->_visible = $pValue; |
|
133 | + return $this; |
|
134 | + } |
|
135 | 135 | |
136 | - /** |
|
137 | - * Get Blur radius |
|
138 | - * |
|
139 | - * @return int |
|
140 | - */ |
|
141 | - public function getBlurRadius() { |
|
142 | - return $this->_blurRadius; |
|
143 | - } |
|
136 | + /** |
|
137 | + * Get Blur radius |
|
138 | + * |
|
139 | + * @return int |
|
140 | + */ |
|
141 | + public function getBlurRadius() { |
|
142 | + return $this->_blurRadius; |
|
143 | + } |
|
144 | 144 | |
145 | - /** |
|
146 | - * Set Blur radius |
|
147 | - * |
|
148 | - * @param int $pValue |
|
149 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
150 | - */ |
|
151 | - public function setBlurRadius($pValue = 6) { |
|
152 | - $this->_blurRadius = $pValue; |
|
153 | - return $this; |
|
154 | - } |
|
145 | + /** |
|
146 | + * Set Blur radius |
|
147 | + * |
|
148 | + * @param int $pValue |
|
149 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
150 | + */ |
|
151 | + public function setBlurRadius($pValue = 6) { |
|
152 | + $this->_blurRadius = $pValue; |
|
153 | + return $this; |
|
154 | + } |
|
155 | 155 | |
156 | - /** |
|
157 | - * Get Shadow distance |
|
158 | - * |
|
159 | - * @return int |
|
160 | - */ |
|
161 | - public function getDistance() { |
|
162 | - return $this->_distance; |
|
163 | - } |
|
156 | + /** |
|
157 | + * Get Shadow distance |
|
158 | + * |
|
159 | + * @return int |
|
160 | + */ |
|
161 | + public function getDistance() { |
|
162 | + return $this->_distance; |
|
163 | + } |
|
164 | 164 | |
165 | - /** |
|
166 | - * Set Shadow distance |
|
167 | - * |
|
168 | - * @param int $pValue |
|
169 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
170 | - */ |
|
171 | - public function setDistance($pValue = 2) { |
|
172 | - $this->_distance = $pValue; |
|
173 | - return $this; |
|
174 | - } |
|
165 | + /** |
|
166 | + * Set Shadow distance |
|
167 | + * |
|
168 | + * @param int $pValue |
|
169 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
170 | + */ |
|
171 | + public function setDistance($pValue = 2) { |
|
172 | + $this->_distance = $pValue; |
|
173 | + return $this; |
|
174 | + } |
|
175 | 175 | |
176 | - /** |
|
177 | - * Get Shadow direction (in degrees) |
|
178 | - * |
|
179 | - * @return int |
|
180 | - */ |
|
181 | - public function getDirection() { |
|
182 | - return $this->_direction; |
|
183 | - } |
|
176 | + /** |
|
177 | + * Get Shadow direction (in degrees) |
|
178 | + * |
|
179 | + * @return int |
|
180 | + */ |
|
181 | + public function getDirection() { |
|
182 | + return $this->_direction; |
|
183 | + } |
|
184 | 184 | |
185 | - /** |
|
186 | - * Set Shadow direction (in degrees) |
|
187 | - * |
|
188 | - * @param int $pValue |
|
189 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
190 | - */ |
|
191 | - public function setDirection($pValue = 0) { |
|
192 | - $this->_direction = $pValue; |
|
193 | - return $this; |
|
194 | - } |
|
185 | + /** |
|
186 | + * Set Shadow direction (in degrees) |
|
187 | + * |
|
188 | + * @param int $pValue |
|
189 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
190 | + */ |
|
191 | + public function setDirection($pValue = 0) { |
|
192 | + $this->_direction = $pValue; |
|
193 | + return $this; |
|
194 | + } |
|
195 | 195 | |
196 | 196 | /** |
197 | - * Get Shadow alignment |
|
198 | - * |
|
199 | - * @return int |
|
200 | - */ |
|
201 | - public function getAlignment() { |
|
202 | - return $this->_alignment; |
|
203 | - } |
|
197 | + * Get Shadow alignment |
|
198 | + * |
|
199 | + * @return int |
|
200 | + */ |
|
201 | + public function getAlignment() { |
|
202 | + return $this->_alignment; |
|
203 | + } |
|
204 | 204 | |
205 | - /** |
|
206 | - * Set Shadow alignment |
|
207 | - * |
|
208 | - * @param int $pValue |
|
209 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
210 | - */ |
|
211 | - public function setAlignment($pValue = 0) { |
|
212 | - $this->_alignment = $pValue; |
|
213 | - return $this; |
|
214 | - } |
|
205 | + /** |
|
206 | + * Set Shadow alignment |
|
207 | + * |
|
208 | + * @param int $pValue |
|
209 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
210 | + */ |
|
211 | + public function setAlignment($pValue = 0) { |
|
212 | + $this->_alignment = $pValue; |
|
213 | + return $this; |
|
214 | + } |
|
215 | 215 | |
216 | 216 | /** |
217 | - * Get Color |
|
218 | - * |
|
219 | - * @return PHPExcel_Style_Color |
|
220 | - */ |
|
221 | - public function getColor() { |
|
222 | - return $this->_color; |
|
223 | - } |
|
217 | + * Get Color |
|
218 | + * |
|
219 | + * @return PHPExcel_Style_Color |
|
220 | + */ |
|
221 | + public function getColor() { |
|
222 | + return $this->_color; |
|
223 | + } |
|
224 | 224 | |
225 | - /** |
|
226 | - * Set Color |
|
227 | - * |
|
228 | - * @param PHPExcel_Style_Color $pValue |
|
229 | - * @throws Exception |
|
230 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
231 | - */ |
|
232 | - public function setColor(PHPExcel_Style_Color $pValue = null) { |
|
225 | + /** |
|
226 | + * Set Color |
|
227 | + * |
|
228 | + * @param PHPExcel_Style_Color $pValue |
|
229 | + * @throws Exception |
|
230 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
231 | + */ |
|
232 | + public function setColor(PHPExcel_Style_Color $pValue = null) { |
|
233 | 233 | $this->_color = $pValue; |
234 | 234 | return $this; |
235 | - } |
|
235 | + } |
|
236 | 236 | |
237 | 237 | /** |
238 | - * Get Alpha |
|
239 | - * |
|
240 | - * @return int |
|
241 | - */ |
|
242 | - public function getAlpha() { |
|
243 | - return $this->_alpha; |
|
244 | - } |
|
238 | + * Get Alpha |
|
239 | + * |
|
240 | + * @return int |
|
241 | + */ |
|
242 | + public function getAlpha() { |
|
243 | + return $this->_alpha; |
|
244 | + } |
|
245 | 245 | |
246 | - /** |
|
247 | - * Set Alpha |
|
248 | - * |
|
249 | - * @param int $pValue |
|
250 | - * @return PHPExcel_Worksheet_Drawing_Shadow |
|
251 | - */ |
|
252 | - public function setAlpha($pValue = 0) { |
|
253 | - $this->_alpha = $pValue; |
|
254 | - return $this; |
|
255 | - } |
|
246 | + /** |
|
247 | + * Set Alpha |
|
248 | + * |
|
249 | + * @param int $pValue |
|
250 | + * @return PHPExcel_Worksheet_Drawing_Shadow |
|
251 | + */ |
|
252 | + public function setAlpha($pValue = 0) { |
|
253 | + $this->_alpha = $pValue; |
|
254 | + return $this; |
|
255 | + } |
|
256 | 256 | |
257 | 257 | /** |
258 | 258 | * Get hash code |
@@ -260,17 +260,17 @@ discard block |
||
260 | 260 | * @return string Hash code |
261 | 261 | */ |
262 | 262 | public function getHashCode() { |
263 | - return md5( |
|
264 | - ($this->_visible ? 't' : 'f') |
|
265 | - . $this->_blurRadius |
|
266 | - . $this->_distance |
|
267 | - . $this->_direction |
|
268 | - . $this->_alignment |
|
269 | - . $this->_color->getHashCode() |
|
270 | - . $this->_alpha |
|
271 | - . __CLASS__ |
|
272 | - ); |
|
273 | - } |
|
263 | + return md5( |
|
264 | + ($this->_visible ? 't' : 'f') |
|
265 | + . $this->_blurRadius |
|
266 | + . $this->_distance |
|
267 | + . $this->_direction |
|
268 | + . $this->_alignment |
|
269 | + . $this->_color->getHashCode() |
|
270 | + . $this->_alpha |
|
271 | + . __CLASS__ |
|
272 | + ); |
|
273 | + } |
|
274 | 274 | |
275 | 275 | /** |
276 | 276 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -108,70 +108,70 @@ discard block |
||
108 | 108 | * |
109 | 109 | * @var string |
110 | 110 | */ |
111 | - private $_oddHeader = ''; |
|
111 | + private $_oddHeader = ''; |
|
112 | 112 | |
113 | 113 | /** |
114 | 114 | * OddFooter |
115 | 115 | * |
116 | 116 | * @var string |
117 | 117 | */ |
118 | - private $_oddFooter = ''; |
|
118 | + private $_oddFooter = ''; |
|
119 | 119 | |
120 | 120 | /** |
121 | 121 | * EvenHeader |
122 | 122 | * |
123 | 123 | * @var string |
124 | 124 | */ |
125 | - private $_evenHeader = ''; |
|
125 | + private $_evenHeader = ''; |
|
126 | 126 | |
127 | 127 | /** |
128 | 128 | * EvenFooter |
129 | 129 | * |
130 | 130 | * @var string |
131 | 131 | */ |
132 | - private $_evenFooter = ''; |
|
132 | + private $_evenFooter = ''; |
|
133 | 133 | |
134 | 134 | /** |
135 | 135 | * FirstHeader |
136 | 136 | * |
137 | 137 | * @var string |
138 | 138 | */ |
139 | - private $_firstHeader = ''; |
|
139 | + private $_firstHeader = ''; |
|
140 | 140 | |
141 | 141 | /** |
142 | 142 | * FirstFooter |
143 | 143 | * |
144 | 144 | * @var string |
145 | 145 | */ |
146 | - private $_firstFooter = ''; |
|
146 | + private $_firstFooter = ''; |
|
147 | 147 | |
148 | 148 | /** |
149 | 149 | * Different header for Odd/Even, defaults to false |
150 | 150 | * |
151 | 151 | * @var boolean |
152 | 152 | */ |
153 | - private $_differentOddEven = false; |
|
153 | + private $_differentOddEven = false; |
|
154 | 154 | |
155 | 155 | /** |
156 | 156 | * Different header for first page, defaults to false |
157 | 157 | * |
158 | 158 | * @var boolean |
159 | 159 | */ |
160 | - private $_differentFirst = false; |
|
160 | + private $_differentFirst = false; |
|
161 | 161 | |
162 | 162 | /** |
163 | 163 | * Scale with document, defaults to true |
164 | 164 | * |
165 | 165 | * @var boolean |
166 | 166 | */ |
167 | - private $_scaleWithDocument = true; |
|
167 | + private $_scaleWithDocument = true; |
|
168 | 168 | |
169 | 169 | /** |
170 | 170 | * Align with margins, defaults to true |
171 | 171 | * |
172 | 172 | * @var boolean |
173 | 173 | */ |
174 | - private $_alignWithMargins = true; |
|
174 | + private $_alignWithMargins = true; |
|
175 | 175 | |
176 | 176 | /** |
177 | 177 | * Header/footer images |
@@ -422,7 +422,7 @@ discard block |
||
422 | 422 | * @return PHPExcel_Worksheet_HeaderFooter |
423 | 423 | */ |
424 | 424 | public function setImages($images) { |
425 | - if (!is_array($images)) { |
|
425 | + if ( ! is_array($images)) { |
|
426 | 426 | throw new Exception('Invalid parameter!'); |
427 | 427 | } |
428 | 428 | |
@@ -438,12 +438,12 @@ discard block |
||
438 | 438 | public function getImages() { |
439 | 439 | // Sort array |
440 | 440 | $images = array(); |
441 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
442 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
443 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
444 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
445 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
446 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
441 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
442 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
443 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
444 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
445 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
446 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
447 | 447 | $this->_headerFooterImages = $images; |
448 | 448 | |
449 | 449 | return $this->_headerFooterImages; |
@@ -438,12 +438,24 @@ |
||
438 | 438 | public function getImages() { |
439 | 439 | // Sort array |
440 | 440 | $images = array(); |
441 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
442 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
443 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
444 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
445 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
446 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
441 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) { |
|
442 | + $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
443 | + } |
|
444 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) { |
|
445 | + $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
446 | + } |
|
447 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) { |
|
448 | + $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
449 | + } |
|
450 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) { |
|
451 | + $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
452 | + } |
|
453 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) { |
|
454 | + $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
455 | + } |
|
456 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) { |
|
457 | + $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
458 | + } |
|
447 | 459 | $this->_headerFooterImages = $images; |
448 | 460 | |
449 | 461 | return $this->_headerFooterImages; |
@@ -180,274 +180,274 @@ |
||
180 | 180 | */ |
181 | 181 | private $_headerFooterImages = array(); |
182 | 182 | |
183 | - /** |
|
184 | - * Create a new PHPExcel_Worksheet_HeaderFooter |
|
185 | - */ |
|
186 | - public function __construct() |
|
187 | - { |
|
188 | - } |
|
189 | - |
|
190 | - /** |
|
191 | - * Get OddHeader |
|
192 | - * |
|
193 | - * @return string |
|
194 | - */ |
|
195 | - public function getOddHeader() { |
|
196 | - return $this->_oddHeader; |
|
197 | - } |
|
198 | - |
|
199 | - /** |
|
200 | - * Set OddHeader |
|
201 | - * |
|
202 | - * @param string $pValue |
|
203 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
204 | - */ |
|
205 | - public function setOddHeader($pValue) { |
|
206 | - $this->_oddHeader = $pValue; |
|
207 | - return $this; |
|
208 | - } |
|
209 | - |
|
210 | - /** |
|
211 | - * Get OddFooter |
|
212 | - * |
|
213 | - * @return string |
|
214 | - */ |
|
215 | - public function getOddFooter() { |
|
216 | - return $this->_oddFooter; |
|
217 | - } |
|
218 | - |
|
219 | - /** |
|
220 | - * Set OddFooter |
|
221 | - * |
|
222 | - * @param string $pValue |
|
223 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
224 | - */ |
|
225 | - public function setOddFooter($pValue) { |
|
226 | - $this->_oddFooter = $pValue; |
|
227 | - return $this; |
|
228 | - } |
|
229 | - |
|
230 | - /** |
|
231 | - * Get EvenHeader |
|
232 | - * |
|
233 | - * @return string |
|
234 | - */ |
|
235 | - public function getEvenHeader() { |
|
236 | - return $this->_evenHeader; |
|
237 | - } |
|
238 | - |
|
239 | - /** |
|
240 | - * Set EvenHeader |
|
241 | - * |
|
242 | - * @param string $pValue |
|
243 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
244 | - */ |
|
245 | - public function setEvenHeader($pValue) { |
|
246 | - $this->_evenHeader = $pValue; |
|
247 | - return $this; |
|
248 | - } |
|
249 | - |
|
250 | - /** |
|
251 | - * Get EvenFooter |
|
252 | - * |
|
253 | - * @return string |
|
254 | - */ |
|
255 | - public function getEvenFooter() { |
|
256 | - return $this->_evenFooter; |
|
257 | - } |
|
258 | - |
|
259 | - /** |
|
260 | - * Set EvenFooter |
|
261 | - * |
|
262 | - * @param string $pValue |
|
263 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
264 | - */ |
|
265 | - public function setEvenFooter($pValue) { |
|
266 | - $this->_evenFooter = $pValue; |
|
267 | - return $this; |
|
268 | - } |
|
269 | - |
|
270 | - /** |
|
271 | - * Get FirstHeader |
|
272 | - * |
|
273 | - * @return string |
|
274 | - */ |
|
275 | - public function getFirstHeader() { |
|
276 | - return $this->_firstHeader; |
|
277 | - } |
|
278 | - |
|
279 | - /** |
|
280 | - * Set FirstHeader |
|
281 | - * |
|
282 | - * @param string $pValue |
|
283 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
284 | - */ |
|
285 | - public function setFirstHeader($pValue) { |
|
286 | - $this->_firstHeader = $pValue; |
|
287 | - return $this; |
|
288 | - } |
|
289 | - |
|
290 | - /** |
|
291 | - * Get FirstFooter |
|
292 | - * |
|
293 | - * @return string |
|
294 | - */ |
|
295 | - public function getFirstFooter() { |
|
296 | - return $this->_firstFooter; |
|
297 | - } |
|
298 | - |
|
299 | - /** |
|
300 | - * Set FirstFooter |
|
301 | - * |
|
302 | - * @param string $pValue |
|
303 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
304 | - */ |
|
305 | - public function setFirstFooter($pValue) { |
|
306 | - $this->_firstFooter = $pValue; |
|
307 | - return $this; |
|
308 | - } |
|
309 | - |
|
310 | - /** |
|
311 | - * Get DifferentOddEven |
|
312 | - * |
|
313 | - * @return boolean |
|
314 | - */ |
|
315 | - public function getDifferentOddEven() { |
|
316 | - return $this->_differentOddEven; |
|
317 | - } |
|
318 | - |
|
319 | - /** |
|
320 | - * Set DifferentOddEven |
|
321 | - * |
|
322 | - * @param boolean $pValue |
|
323 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
324 | - */ |
|
325 | - public function setDifferentOddEven($pValue = false) { |
|
326 | - $this->_differentOddEven = $pValue; |
|
327 | - return $this; |
|
328 | - } |
|
329 | - |
|
330 | - /** |
|
331 | - * Get DifferentFirst |
|
332 | - * |
|
333 | - * @return boolean |
|
334 | - */ |
|
335 | - public function getDifferentFirst() { |
|
336 | - return $this->_differentFirst; |
|
337 | - } |
|
338 | - |
|
339 | - /** |
|
340 | - * Set DifferentFirst |
|
341 | - * |
|
342 | - * @param boolean $pValue |
|
343 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
344 | - */ |
|
345 | - public function setDifferentFirst($pValue = false) { |
|
346 | - $this->_differentFirst = $pValue; |
|
347 | - return $this; |
|
348 | - } |
|
349 | - |
|
350 | - /** |
|
351 | - * Get ScaleWithDocument |
|
352 | - * |
|
353 | - * @return boolean |
|
354 | - */ |
|
355 | - public function getScaleWithDocument() { |
|
356 | - return $this->_scaleWithDocument; |
|
357 | - } |
|
358 | - |
|
359 | - /** |
|
360 | - * Set ScaleWithDocument |
|
361 | - * |
|
362 | - * @param boolean $pValue |
|
363 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
364 | - */ |
|
365 | - public function setScaleWithDocument($pValue = true) { |
|
366 | - $this->_scaleWithDocument = $pValue; |
|
367 | - return $this; |
|
368 | - } |
|
369 | - |
|
370 | - /** |
|
371 | - * Get AlignWithMargins |
|
372 | - * |
|
373 | - * @return boolean |
|
374 | - */ |
|
375 | - public function getAlignWithMargins() { |
|
376 | - return $this->_alignWithMargins; |
|
377 | - } |
|
378 | - |
|
379 | - /** |
|
380 | - * Set AlignWithMargins |
|
381 | - * |
|
382 | - * @param boolean $pValue |
|
383 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
384 | - */ |
|
385 | - public function setAlignWithMargins($pValue = true) { |
|
386 | - $this->_alignWithMargins = $pValue; |
|
387 | - return $this; |
|
388 | - } |
|
389 | - |
|
390 | - /** |
|
391 | - * Add header/footer image |
|
392 | - * |
|
393 | - * @param PHPExcel_Worksheet_HeaderFooterDrawing $image |
|
394 | - * @param string $location |
|
395 | - * @throws Exception |
|
396 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
397 | - */ |
|
398 | - public function addImage(PHPExcel_Worksheet_HeaderFooterDrawing $image = null, $location = self::IMAGE_HEADER_LEFT) { |
|
399 | - $this->_headerFooterImages[$location] = $image; |
|
400 | - return $this; |
|
401 | - } |
|
402 | - |
|
403 | - /** |
|
404 | - * Remove header/footer image |
|
405 | - * |
|
406 | - * @param string $location |
|
407 | - * @throws Exception |
|
408 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
409 | - */ |
|
410 | - public function removeImage($location = self::IMAGE_HEADER_LEFT) { |
|
411 | - if (isset($this->_headerFooterImages[$location])) { |
|
412 | - unset($this->_headerFooterImages[$location]); |
|
413 | - } |
|
414 | - return $this; |
|
415 | - } |
|
416 | - |
|
417 | - /** |
|
418 | - * Set header/footer images |
|
419 | - * |
|
420 | - * @param PHPExcel_Worksheet_HeaderFooterDrawing[] $images |
|
421 | - * @throws Exception |
|
422 | - * @return PHPExcel_Worksheet_HeaderFooter |
|
423 | - */ |
|
424 | - public function setImages($images) { |
|
425 | - if (!is_array($images)) { |
|
426 | - throw new Exception('Invalid parameter!'); |
|
427 | - } |
|
428 | - |
|
429 | - $this->_headerFooterImages = $images; |
|
430 | - return $this; |
|
431 | - } |
|
432 | - |
|
433 | - /** |
|
434 | - * Get header/footer images |
|
435 | - * |
|
436 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing[] |
|
437 | - */ |
|
438 | - public function getImages() { |
|
439 | - // Sort array |
|
440 | - $images = array(); |
|
441 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
442 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
443 | - if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
444 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
445 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
446 | - if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
447 | - $this->_headerFooterImages = $images; |
|
448 | - |
|
449 | - return $this->_headerFooterImages; |
|
450 | - } |
|
183 | + /** |
|
184 | + * Create a new PHPExcel_Worksheet_HeaderFooter |
|
185 | + */ |
|
186 | + public function __construct() |
|
187 | + { |
|
188 | + } |
|
189 | + |
|
190 | + /** |
|
191 | + * Get OddHeader |
|
192 | + * |
|
193 | + * @return string |
|
194 | + */ |
|
195 | + public function getOddHeader() { |
|
196 | + return $this->_oddHeader; |
|
197 | + } |
|
198 | + |
|
199 | + /** |
|
200 | + * Set OddHeader |
|
201 | + * |
|
202 | + * @param string $pValue |
|
203 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
204 | + */ |
|
205 | + public function setOddHeader($pValue) { |
|
206 | + $this->_oddHeader = $pValue; |
|
207 | + return $this; |
|
208 | + } |
|
209 | + |
|
210 | + /** |
|
211 | + * Get OddFooter |
|
212 | + * |
|
213 | + * @return string |
|
214 | + */ |
|
215 | + public function getOddFooter() { |
|
216 | + return $this->_oddFooter; |
|
217 | + } |
|
218 | + |
|
219 | + /** |
|
220 | + * Set OddFooter |
|
221 | + * |
|
222 | + * @param string $pValue |
|
223 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
224 | + */ |
|
225 | + public function setOddFooter($pValue) { |
|
226 | + $this->_oddFooter = $pValue; |
|
227 | + return $this; |
|
228 | + } |
|
229 | + |
|
230 | + /** |
|
231 | + * Get EvenHeader |
|
232 | + * |
|
233 | + * @return string |
|
234 | + */ |
|
235 | + public function getEvenHeader() { |
|
236 | + return $this->_evenHeader; |
|
237 | + } |
|
238 | + |
|
239 | + /** |
|
240 | + * Set EvenHeader |
|
241 | + * |
|
242 | + * @param string $pValue |
|
243 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
244 | + */ |
|
245 | + public function setEvenHeader($pValue) { |
|
246 | + $this->_evenHeader = $pValue; |
|
247 | + return $this; |
|
248 | + } |
|
249 | + |
|
250 | + /** |
|
251 | + * Get EvenFooter |
|
252 | + * |
|
253 | + * @return string |
|
254 | + */ |
|
255 | + public function getEvenFooter() { |
|
256 | + return $this->_evenFooter; |
|
257 | + } |
|
258 | + |
|
259 | + /** |
|
260 | + * Set EvenFooter |
|
261 | + * |
|
262 | + * @param string $pValue |
|
263 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
264 | + */ |
|
265 | + public function setEvenFooter($pValue) { |
|
266 | + $this->_evenFooter = $pValue; |
|
267 | + return $this; |
|
268 | + } |
|
269 | + |
|
270 | + /** |
|
271 | + * Get FirstHeader |
|
272 | + * |
|
273 | + * @return string |
|
274 | + */ |
|
275 | + public function getFirstHeader() { |
|
276 | + return $this->_firstHeader; |
|
277 | + } |
|
278 | + |
|
279 | + /** |
|
280 | + * Set FirstHeader |
|
281 | + * |
|
282 | + * @param string $pValue |
|
283 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
284 | + */ |
|
285 | + public function setFirstHeader($pValue) { |
|
286 | + $this->_firstHeader = $pValue; |
|
287 | + return $this; |
|
288 | + } |
|
289 | + |
|
290 | + /** |
|
291 | + * Get FirstFooter |
|
292 | + * |
|
293 | + * @return string |
|
294 | + */ |
|
295 | + public function getFirstFooter() { |
|
296 | + return $this->_firstFooter; |
|
297 | + } |
|
298 | + |
|
299 | + /** |
|
300 | + * Set FirstFooter |
|
301 | + * |
|
302 | + * @param string $pValue |
|
303 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
304 | + */ |
|
305 | + public function setFirstFooter($pValue) { |
|
306 | + $this->_firstFooter = $pValue; |
|
307 | + return $this; |
|
308 | + } |
|
309 | + |
|
310 | + /** |
|
311 | + * Get DifferentOddEven |
|
312 | + * |
|
313 | + * @return boolean |
|
314 | + */ |
|
315 | + public function getDifferentOddEven() { |
|
316 | + return $this->_differentOddEven; |
|
317 | + } |
|
318 | + |
|
319 | + /** |
|
320 | + * Set DifferentOddEven |
|
321 | + * |
|
322 | + * @param boolean $pValue |
|
323 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
324 | + */ |
|
325 | + public function setDifferentOddEven($pValue = false) { |
|
326 | + $this->_differentOddEven = $pValue; |
|
327 | + return $this; |
|
328 | + } |
|
329 | + |
|
330 | + /** |
|
331 | + * Get DifferentFirst |
|
332 | + * |
|
333 | + * @return boolean |
|
334 | + */ |
|
335 | + public function getDifferentFirst() { |
|
336 | + return $this->_differentFirst; |
|
337 | + } |
|
338 | + |
|
339 | + /** |
|
340 | + * Set DifferentFirst |
|
341 | + * |
|
342 | + * @param boolean $pValue |
|
343 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
344 | + */ |
|
345 | + public function setDifferentFirst($pValue = false) { |
|
346 | + $this->_differentFirst = $pValue; |
|
347 | + return $this; |
|
348 | + } |
|
349 | + |
|
350 | + /** |
|
351 | + * Get ScaleWithDocument |
|
352 | + * |
|
353 | + * @return boolean |
|
354 | + */ |
|
355 | + public function getScaleWithDocument() { |
|
356 | + return $this->_scaleWithDocument; |
|
357 | + } |
|
358 | + |
|
359 | + /** |
|
360 | + * Set ScaleWithDocument |
|
361 | + * |
|
362 | + * @param boolean $pValue |
|
363 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
364 | + */ |
|
365 | + public function setScaleWithDocument($pValue = true) { |
|
366 | + $this->_scaleWithDocument = $pValue; |
|
367 | + return $this; |
|
368 | + } |
|
369 | + |
|
370 | + /** |
|
371 | + * Get AlignWithMargins |
|
372 | + * |
|
373 | + * @return boolean |
|
374 | + */ |
|
375 | + public function getAlignWithMargins() { |
|
376 | + return $this->_alignWithMargins; |
|
377 | + } |
|
378 | + |
|
379 | + /** |
|
380 | + * Set AlignWithMargins |
|
381 | + * |
|
382 | + * @param boolean $pValue |
|
383 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
384 | + */ |
|
385 | + public function setAlignWithMargins($pValue = true) { |
|
386 | + $this->_alignWithMargins = $pValue; |
|
387 | + return $this; |
|
388 | + } |
|
389 | + |
|
390 | + /** |
|
391 | + * Add header/footer image |
|
392 | + * |
|
393 | + * @param PHPExcel_Worksheet_HeaderFooterDrawing $image |
|
394 | + * @param string $location |
|
395 | + * @throws Exception |
|
396 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
397 | + */ |
|
398 | + public function addImage(PHPExcel_Worksheet_HeaderFooterDrawing $image = null, $location = self::IMAGE_HEADER_LEFT) { |
|
399 | + $this->_headerFooterImages[$location] = $image; |
|
400 | + return $this; |
|
401 | + } |
|
402 | + |
|
403 | + /** |
|
404 | + * Remove header/footer image |
|
405 | + * |
|
406 | + * @param string $location |
|
407 | + * @throws Exception |
|
408 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
409 | + */ |
|
410 | + public function removeImage($location = self::IMAGE_HEADER_LEFT) { |
|
411 | + if (isset($this->_headerFooterImages[$location])) { |
|
412 | + unset($this->_headerFooterImages[$location]); |
|
413 | + } |
|
414 | + return $this; |
|
415 | + } |
|
416 | + |
|
417 | + /** |
|
418 | + * Set header/footer images |
|
419 | + * |
|
420 | + * @param PHPExcel_Worksheet_HeaderFooterDrawing[] $images |
|
421 | + * @throws Exception |
|
422 | + * @return PHPExcel_Worksheet_HeaderFooter |
|
423 | + */ |
|
424 | + public function setImages($images) { |
|
425 | + if (!is_array($images)) { |
|
426 | + throw new Exception('Invalid parameter!'); |
|
427 | + } |
|
428 | + |
|
429 | + $this->_headerFooterImages = $images; |
|
430 | + return $this; |
|
431 | + } |
|
432 | + |
|
433 | + /** |
|
434 | + * Get header/footer images |
|
435 | + * |
|
436 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing[] |
|
437 | + */ |
|
438 | + public function getImages() { |
|
439 | + // Sort array |
|
440 | + $images = array(); |
|
441 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_LEFT])) $images[self::IMAGE_HEADER_LEFT] = $this->_headerFooterImages[self::IMAGE_HEADER_LEFT]; |
|
442 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_CENTER])) $images[self::IMAGE_HEADER_CENTER] = $this->_headerFooterImages[self::IMAGE_HEADER_CENTER]; |
|
443 | + if (isset($this->_headerFooterImages[self::IMAGE_HEADER_RIGHT])) $images[self::IMAGE_HEADER_RIGHT] = $this->_headerFooterImages[self::IMAGE_HEADER_RIGHT]; |
|
444 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_LEFT])) $images[self::IMAGE_FOOTER_LEFT] = $this->_headerFooterImages[self::IMAGE_FOOTER_LEFT]; |
|
445 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_CENTER])) $images[self::IMAGE_FOOTER_CENTER] = $this->_headerFooterImages[self::IMAGE_FOOTER_CENTER]; |
|
446 | + if (isset($this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT])) $images[self::IMAGE_FOOTER_RIGHT] = $this->_headerFooterImages[self::IMAGE_FOOTER_RIGHT]; |
|
447 | + $this->_headerFooterImages = $images; |
|
448 | + |
|
449 | + return $this->_headerFooterImages; |
|
450 | + } |
|
451 | 451 | |
452 | 452 | /** |
453 | 453 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -94,9 +94,9 @@ discard block |
||
94 | 94 | $this->_name = ''; |
95 | 95 | $this->_offsetX = 0; |
96 | 96 | $this->_offsetY = 0; |
97 | - $this->_width = 0; |
|
98 | - $this->_height = 0; |
|
99 | - $this->_resizeProportional = true; |
|
97 | + $this->_width = 0; |
|
98 | + $this->_height = 0; |
|
99 | + $this->_resizeProportional = true; |
|
100 | 100 | } |
101 | 101 | |
102 | 102 | /** |
@@ -231,12 +231,12 @@ discard block |
||
231 | 231 | public function setWidthAndHeight($width = 0, $height = 0) { |
232 | 232 | $xratio = $width / $this->_width; |
233 | 233 | $yratio = $height / $this->_height; |
234 | - if ($this->_resizeProportional && !($width == 0 || $height == 0)) { |
|
234 | + if ($this->_resizeProportional && ! ($width == 0 || $height == 0)) { |
|
235 | 235 | if (($xratio * $this->_height) < $height) { |
236 | 236 | $this->_height = ceil($xratio * $this->_height); |
237 | 237 | $this->_width = $width; |
238 | 238 | } else { |
239 | - $this->_width = ceil($yratio * $this->_width); |
|
239 | + $this->_width = ceil($yratio * $this->_width); |
|
240 | 240 | $this->_height = $height; |
241 | 241 | } |
242 | 242 | } |
@@ -84,150 +84,150 @@ discard block |
||
84 | 84 | */ |
85 | 85 | protected $_resizeProportional; |
86 | 86 | |
87 | - /** |
|
88 | - * Create a new PHPExcel_Worksheet_HeaderFooterDrawing |
|
89 | - */ |
|
90 | - public function __construct() |
|
91 | - { |
|
92 | - // Initialise values |
|
93 | - $this->_path = ''; |
|
94 | - $this->_name = ''; |
|
95 | - $this->_offsetX = 0; |
|
96 | - $this->_offsetY = 0; |
|
97 | - $this->_width = 0; |
|
98 | - $this->_height = 0; |
|
99 | - $this->_resizeProportional = true; |
|
100 | - } |
|
101 | - |
|
102 | - /** |
|
103 | - * Get Name |
|
104 | - * |
|
105 | - * @return string |
|
106 | - */ |
|
107 | - public function getName() { |
|
108 | - return $this->_name; |
|
109 | - } |
|
110 | - |
|
111 | - /** |
|
112 | - * Set Name |
|
113 | - * |
|
114 | - * @param string $pValue |
|
115 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
116 | - */ |
|
117 | - public function setName($pValue = '') { |
|
118 | - $this->_name = $pValue; |
|
119 | - return $this; |
|
120 | - } |
|
121 | - |
|
122 | - /** |
|
123 | - * Get OffsetX |
|
124 | - * |
|
125 | - * @return int |
|
126 | - */ |
|
127 | - public function getOffsetX() { |
|
128 | - return $this->_offsetX; |
|
129 | - } |
|
130 | - |
|
131 | - /** |
|
132 | - * Set OffsetX |
|
133 | - * |
|
134 | - * @param int $pValue |
|
135 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
136 | - */ |
|
137 | - public function setOffsetX($pValue = 0) { |
|
138 | - $this->_offsetX = $pValue; |
|
139 | - return $this; |
|
140 | - } |
|
141 | - |
|
142 | - /** |
|
143 | - * Get OffsetY |
|
144 | - * |
|
145 | - * @return int |
|
146 | - */ |
|
147 | - public function getOffsetY() { |
|
148 | - return $this->_offsetY; |
|
149 | - } |
|
150 | - |
|
151 | - /** |
|
152 | - * Set OffsetY |
|
153 | - * |
|
154 | - * @param int $pValue |
|
155 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
156 | - */ |
|
157 | - public function setOffsetY($pValue = 0) { |
|
158 | - $this->_offsetY = $pValue; |
|
159 | - return $this; |
|
160 | - } |
|
161 | - |
|
162 | - /** |
|
163 | - * Get Width |
|
164 | - * |
|
165 | - * @return int |
|
166 | - */ |
|
167 | - public function getWidth() { |
|
168 | - return $this->_width; |
|
169 | - } |
|
170 | - |
|
171 | - /** |
|
172 | - * Set Width |
|
173 | - * |
|
174 | - * @param int $pValue |
|
175 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
176 | - */ |
|
177 | - public function setWidth($pValue = 0) { |
|
178 | - // Resize proportional? |
|
179 | - if ($this->_resizeProportional && $pValue != 0) { |
|
180 | - $ratio = $this->_width / $this->_height; |
|
181 | - $this->_height = round($ratio * $pValue); |
|
182 | - } |
|
183 | - |
|
184 | - // Set width |
|
185 | - $this->_width = $pValue; |
|
186 | - |
|
187 | - return $this; |
|
188 | - } |
|
189 | - |
|
190 | - /** |
|
191 | - * Get Height |
|
192 | - * |
|
193 | - * @return int |
|
194 | - */ |
|
195 | - public function getHeight() { |
|
196 | - return $this->_height; |
|
197 | - } |
|
198 | - |
|
199 | - /** |
|
200 | - * Set Height |
|
201 | - * |
|
202 | - * @param int $pValue |
|
203 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
204 | - */ |
|
205 | - public function setHeight($pValue = 0) { |
|
206 | - // Resize proportional? |
|
207 | - if ($this->_resizeProportional && $pValue != 0) { |
|
208 | - $ratio = $this->_width / $this->_height; |
|
209 | - $this->_width = round($ratio * $pValue); |
|
210 | - } |
|
211 | - |
|
212 | - // Set height |
|
213 | - $this->_height = $pValue; |
|
214 | - |
|
215 | - return $this; |
|
216 | - } |
|
217 | - |
|
218 | - /** |
|
219 | - * Set width and height with proportional resize |
|
87 | + /** |
|
88 | + * Create a new PHPExcel_Worksheet_HeaderFooterDrawing |
|
89 | + */ |
|
90 | + public function __construct() |
|
91 | + { |
|
92 | + // Initialise values |
|
93 | + $this->_path = ''; |
|
94 | + $this->_name = ''; |
|
95 | + $this->_offsetX = 0; |
|
96 | + $this->_offsetY = 0; |
|
97 | + $this->_width = 0; |
|
98 | + $this->_height = 0; |
|
99 | + $this->_resizeProportional = true; |
|
100 | + } |
|
101 | + |
|
102 | + /** |
|
103 | + * Get Name |
|
104 | + * |
|
105 | + * @return string |
|
106 | + */ |
|
107 | + public function getName() { |
|
108 | + return $this->_name; |
|
109 | + } |
|
110 | + |
|
111 | + /** |
|
112 | + * Set Name |
|
113 | + * |
|
114 | + * @param string $pValue |
|
115 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
116 | + */ |
|
117 | + public function setName($pValue = '') { |
|
118 | + $this->_name = $pValue; |
|
119 | + return $this; |
|
120 | + } |
|
121 | + |
|
122 | + /** |
|
123 | + * Get OffsetX |
|
124 | + * |
|
125 | + * @return int |
|
126 | + */ |
|
127 | + public function getOffsetX() { |
|
128 | + return $this->_offsetX; |
|
129 | + } |
|
130 | + |
|
131 | + /** |
|
132 | + * Set OffsetX |
|
133 | + * |
|
134 | + * @param int $pValue |
|
135 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
136 | + */ |
|
137 | + public function setOffsetX($pValue = 0) { |
|
138 | + $this->_offsetX = $pValue; |
|
139 | + return $this; |
|
140 | + } |
|
141 | + |
|
142 | + /** |
|
143 | + * Get OffsetY |
|
144 | + * |
|
145 | + * @return int |
|
146 | + */ |
|
147 | + public function getOffsetY() { |
|
148 | + return $this->_offsetY; |
|
149 | + } |
|
150 | + |
|
151 | + /** |
|
152 | + * Set OffsetY |
|
153 | + * |
|
154 | + * @param int $pValue |
|
155 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
156 | + */ |
|
157 | + public function setOffsetY($pValue = 0) { |
|
158 | + $this->_offsetY = $pValue; |
|
159 | + return $this; |
|
160 | + } |
|
161 | + |
|
162 | + /** |
|
163 | + * Get Width |
|
164 | + * |
|
165 | + * @return int |
|
166 | + */ |
|
167 | + public function getWidth() { |
|
168 | + return $this->_width; |
|
169 | + } |
|
170 | + |
|
171 | + /** |
|
172 | + * Set Width |
|
173 | + * |
|
174 | + * @param int $pValue |
|
175 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
176 | + */ |
|
177 | + public function setWidth($pValue = 0) { |
|
178 | + // Resize proportional? |
|
179 | + if ($this->_resizeProportional && $pValue != 0) { |
|
180 | + $ratio = $this->_width / $this->_height; |
|
181 | + $this->_height = round($ratio * $pValue); |
|
182 | + } |
|
183 | + |
|
184 | + // Set width |
|
185 | + $this->_width = $pValue; |
|
186 | + |
|
187 | + return $this; |
|
188 | + } |
|
189 | + |
|
190 | + /** |
|
191 | + * Get Height |
|
192 | + * |
|
193 | + * @return int |
|
194 | + */ |
|
195 | + public function getHeight() { |
|
196 | + return $this->_height; |
|
197 | + } |
|
198 | + |
|
199 | + /** |
|
200 | + * Set Height |
|
201 | + * |
|
202 | + * @param int $pValue |
|
203 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
204 | + */ |
|
205 | + public function setHeight($pValue = 0) { |
|
206 | + // Resize proportional? |
|
207 | + if ($this->_resizeProportional && $pValue != 0) { |
|
208 | + $ratio = $this->_width / $this->_height; |
|
209 | + $this->_width = round($ratio * $pValue); |
|
210 | + } |
|
211 | + |
|
212 | + // Set height |
|
213 | + $this->_height = $pValue; |
|
214 | + |
|
215 | + return $this; |
|
216 | + } |
|
217 | + |
|
218 | + /** |
|
219 | + * Set width and height with proportional resize |
|
220 | 220 | * Example: |
221 | 221 | * <code> |
222 | - * $objDrawing->setResizeProportional(true); |
|
223 | - * $objDrawing->setWidthAndHeight(160,120); |
|
222 | + * $objDrawing->setResizeProportional(true); |
|
223 | + * $objDrawing->setWidthAndHeight(160,120); |
|
224 | 224 | * </code> |
225 | 225 | * |
226 | - * @author Vincent@luo MSN:[email protected] |
|
227 | - * @param int $width |
|
228 | - * @param int $height |
|
229 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
230 | - */ |
|
226 | + * @author Vincent@luo MSN:[email protected] |
|
227 | + * @param int $width |
|
228 | + * @param int $height |
|
229 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
230 | + */ |
|
231 | 231 | public function setWidthAndHeight($width = 0, $height = 0) { |
232 | 232 | $xratio = $width / $this->_width; |
233 | 233 | $yratio = $height / $this->_height; |
@@ -243,79 +243,79 @@ discard block |
||
243 | 243 | return $this; |
244 | 244 | } |
245 | 245 | |
246 | - /** |
|
247 | - * Get ResizeProportional |
|
248 | - * |
|
249 | - * @return boolean |
|
250 | - */ |
|
251 | - public function getResizeProportional() { |
|
252 | - return $this->_resizeProportional; |
|
253 | - } |
|
254 | - |
|
255 | - /** |
|
256 | - * Set ResizeProportional |
|
257 | - * |
|
258 | - * @param boolean $pValue |
|
259 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
260 | - */ |
|
261 | - public function setResizeProportional($pValue = true) { |
|
262 | - $this->_resizeProportional = $pValue; |
|
263 | - return $this; |
|
264 | - } |
|
265 | - |
|
266 | - /** |
|
267 | - * Get Filename |
|
268 | - * |
|
269 | - * @return string |
|
270 | - */ |
|
271 | - public function getFilename() { |
|
272 | - return basename($this->_path); |
|
273 | - } |
|
274 | - |
|
275 | - /** |
|
276 | - * Get Extension |
|
277 | - * |
|
278 | - * @return string |
|
279 | - */ |
|
280 | - public function getExtension() { |
|
281 | - $parts = explode(".", basename($this->_path)); |
|
282 | - return end($parts); |
|
283 | - } |
|
284 | - |
|
285 | - /** |
|
286 | - * Get Path |
|
287 | - * |
|
288 | - * @return string |
|
289 | - */ |
|
290 | - public function getPath() { |
|
291 | - return $this->_path; |
|
292 | - } |
|
293 | - |
|
294 | - /** |
|
295 | - * Set Path |
|
296 | - * |
|
297 | - * @param string $pValue File path |
|
298 | - * @param boolean $pVerifyFile Verify file |
|
299 | - * @throws Exception |
|
300 | - * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
301 | - */ |
|
302 | - public function setPath($pValue = '', $pVerifyFile = true) { |
|
303 | - if ($pVerifyFile) { |
|
304 | - if (file_exists($pValue)) { |
|
305 | - $this->_path = $pValue; |
|
306 | - |
|
307 | - if ($this->_width == 0 && $this->_height == 0) { |
|
308 | - // Get width/height |
|
309 | - list($this->_width, $this->_height) = getimagesize($pValue); |
|
310 | - } |
|
311 | - } else { |
|
312 | - throw new Exception("File $pValue not found!"); |
|
313 | - } |
|
314 | - } else { |
|
315 | - $this->_path = $pValue; |
|
316 | - } |
|
317 | - return $this; |
|
318 | - } |
|
246 | + /** |
|
247 | + * Get ResizeProportional |
|
248 | + * |
|
249 | + * @return boolean |
|
250 | + */ |
|
251 | + public function getResizeProportional() { |
|
252 | + return $this->_resizeProportional; |
|
253 | + } |
|
254 | + |
|
255 | + /** |
|
256 | + * Set ResizeProportional |
|
257 | + * |
|
258 | + * @param boolean $pValue |
|
259 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
260 | + */ |
|
261 | + public function setResizeProportional($pValue = true) { |
|
262 | + $this->_resizeProportional = $pValue; |
|
263 | + return $this; |
|
264 | + } |
|
265 | + |
|
266 | + /** |
|
267 | + * Get Filename |
|
268 | + * |
|
269 | + * @return string |
|
270 | + */ |
|
271 | + public function getFilename() { |
|
272 | + return basename($this->_path); |
|
273 | + } |
|
274 | + |
|
275 | + /** |
|
276 | + * Get Extension |
|
277 | + * |
|
278 | + * @return string |
|
279 | + */ |
|
280 | + public function getExtension() { |
|
281 | + $parts = explode(".", basename($this->_path)); |
|
282 | + return end($parts); |
|
283 | + } |
|
284 | + |
|
285 | + /** |
|
286 | + * Get Path |
|
287 | + * |
|
288 | + * @return string |
|
289 | + */ |
|
290 | + public function getPath() { |
|
291 | + return $this->_path; |
|
292 | + } |
|
293 | + |
|
294 | + /** |
|
295 | + * Set Path |
|
296 | + * |
|
297 | + * @param string $pValue File path |
|
298 | + * @param boolean $pVerifyFile Verify file |
|
299 | + * @throws Exception |
|
300 | + * @return PHPExcel_Worksheet_HeaderFooterDrawing |
|
301 | + */ |
|
302 | + public function setPath($pValue = '', $pVerifyFile = true) { |
|
303 | + if ($pVerifyFile) { |
|
304 | + if (file_exists($pValue)) { |
|
305 | + $this->_path = $pValue; |
|
306 | + |
|
307 | + if ($this->_width == 0 && $this->_height == 0) { |
|
308 | + // Get width/height |
|
309 | + list($this->_width, $this->_height) = getimagesize($pValue); |
|
310 | + } |
|
311 | + } else { |
|
312 | + throw new Exception("File $pValue not found!"); |
|
313 | + } |
|
314 | + } else { |
|
315 | + $this->_path = $pValue; |
|
316 | + } |
|
317 | + return $this; |
|
318 | + } |
|
319 | 319 | |
320 | 320 | /** |
321 | 321 | * Get hash code |
@@ -323,16 +323,16 @@ discard block |
||
323 | 323 | * @return string Hash code |
324 | 324 | */ |
325 | 325 | public function getHashCode() { |
326 | - return md5( |
|
327 | - $this->_path |
|
328 | - . $this->_name |
|
329 | - . $this->_offsetX |
|
330 | - . $this->_offsetY |
|
331 | - . $this->_width |
|
332 | - . $this->_height |
|
333 | - . __CLASS__ |
|
334 | - ); |
|
335 | - } |
|
326 | + return md5( |
|
327 | + $this->_path |
|
328 | + . $this->_name |
|
329 | + . $this->_offsetX |
|
330 | + . $this->_offsetY |
|
331 | + . $this->_width |
|
332 | + . $this->_height |
|
333 | + . __CLASS__ |
|
334 | + ); |
|
335 | + } |
|
336 | 336 | |
337 | 337 | /** |
338 | 338 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -36,16 +36,16 @@ discard block |
||
36 | 36 | class PHPExcel_Worksheet_MemoryDrawing extends PHPExcel_Worksheet_BaseDrawing implements PHPExcel_IComparable |
37 | 37 | { |
38 | 38 | /* Rendering functions */ |
39 | - const RENDERING_DEFAULT = 'imagepng'; |
|
39 | + const RENDERING_DEFAULT = 'imagepng'; |
|
40 | 40 | const RENDERING_PNG = 'imagepng'; |
41 | 41 | const RENDERING_GIF = 'imagegif'; |
42 | 42 | const RENDERING_JPEG = 'imagejpeg'; |
43 | 43 | |
44 | 44 | /* MIME types */ |
45 | - const MIMETYPE_DEFAULT = 'image/png'; |
|
45 | + const MIMETYPE_DEFAULT = 'image/png'; |
|
46 | 46 | const MIMETYPE_PNG = 'image/png'; |
47 | 47 | const MIMETYPE_GIF = 'image/gif'; |
48 | - const MIMETYPE_JPEG = 'image/jpeg'; |
|
48 | + const MIMETYPE_JPEG = 'image/jpeg'; |
|
49 | 49 | |
50 | 50 | /** |
51 | 51 | * Image resource |
@@ -81,10 +81,10 @@ discard block |
||
81 | 81 | public function __construct() |
82 | 82 | { |
83 | 83 | // Initialise values |
84 | - $this->_imageResource = null; |
|
85 | - $this->_renderingFunction = self::RENDERING_DEFAULT; |
|
86 | - $this->_mimeType = self::MIMETYPE_DEFAULT; |
|
87 | - $this->_uniqueName = md5(rand(0, 9999). time() . rand(0, 9999)); |
|
84 | + $this->_imageResource = null; |
|
85 | + $this->_renderingFunction = self::RENDERING_DEFAULT; |
|
86 | + $this->_mimeType = self::MIMETYPE_DEFAULT; |
|
87 | + $this->_uniqueName = md5(rand(0, 9999).time().rand(0, 9999)); |
|
88 | 88 | |
89 | 89 | // Initialize parent |
90 | 90 | parent::__construct(); |
@@ -108,10 +108,10 @@ discard block |
||
108 | 108 | public function setImageResource($value = null) { |
109 | 109 | $this->_imageResource = $value; |
110 | 110 | |
111 | - if (!is_null($this->_imageResource)) { |
|
111 | + if ( ! is_null($this->_imageResource)) { |
|
112 | 112 | // Get width/height |
113 | - $this->_width = imagesx($this->_imageResource); |
|
114 | - $this->_height = imagesy($this->_imageResource); |
|
113 | + $this->_width = imagesx($this->_imageResource); |
|
114 | + $this->_height = imagesy($this->_imageResource); |
|
115 | 115 | } |
116 | 116 | return $this; |
117 | 117 | } |
@@ -166,7 +166,7 @@ discard block |
||
166 | 166 | $extension = explode('/', $extension); |
167 | 167 | $extension = $extension[1]; |
168 | 168 | |
169 | - return $this->_uniqueName . $this->getImageIndex() . '.' . $extension; |
|
169 | + return $this->_uniqueName.$this->getImageIndex().'.'.$extension; |
|
170 | 170 | } |
171 | 171 | |
172 | 172 | /** |
@@ -75,99 +75,99 @@ discard block |
||
75 | 75 | */ |
76 | 76 | private $_uniqueName; |
77 | 77 | |
78 | - /** |
|
79 | - * Create a new PHPExcel_Worksheet_MemoryDrawing |
|
80 | - */ |
|
81 | - public function __construct() |
|
82 | - { |
|
83 | - // Initialise values |
|
84 | - $this->_imageResource = null; |
|
85 | - $this->_renderingFunction = self::RENDERING_DEFAULT; |
|
86 | - $this->_mimeType = self::MIMETYPE_DEFAULT; |
|
87 | - $this->_uniqueName = md5(rand(0, 9999). time() . rand(0, 9999)); |
|
88 | - |
|
89 | - // Initialize parent |
|
90 | - parent::__construct(); |
|
91 | - } |
|
92 | - |
|
93 | - /** |
|
94 | - * Get image resource |
|
95 | - * |
|
96 | - * @return resource |
|
97 | - */ |
|
98 | - public function getImageResource() { |
|
99 | - return $this->_imageResource; |
|
100 | - } |
|
101 | - |
|
102 | - /** |
|
103 | - * Set image resource |
|
104 | - * |
|
105 | - * @param $value resource |
|
106 | - * @return PHPExcel_Worksheet_MemoryDrawing |
|
107 | - */ |
|
108 | - public function setImageResource($value = null) { |
|
109 | - $this->_imageResource = $value; |
|
110 | - |
|
111 | - if (!is_null($this->_imageResource)) { |
|
112 | - // Get width/height |
|
113 | - $this->_width = imagesx($this->_imageResource); |
|
114 | - $this->_height = imagesy($this->_imageResource); |
|
115 | - } |
|
116 | - return $this; |
|
117 | - } |
|
118 | - |
|
119 | - /** |
|
120 | - * Get rendering function |
|
121 | - * |
|
122 | - * @return string |
|
123 | - */ |
|
124 | - public function getRenderingFunction() { |
|
125 | - return $this->_renderingFunction; |
|
126 | - } |
|
127 | - |
|
128 | - /** |
|
129 | - * Set rendering function |
|
130 | - * |
|
131 | - * @param string $value |
|
132 | - * @return PHPExcel_Worksheet_MemoryDrawing |
|
133 | - */ |
|
134 | - public function setRenderingFunction($value = PHPExcel_Worksheet_MemoryDrawing::RENDERING_DEFAULT) { |
|
135 | - $this->_renderingFunction = $value; |
|
136 | - return $this; |
|
137 | - } |
|
138 | - |
|
139 | - /** |
|
140 | - * Get mime type |
|
141 | - * |
|
142 | - * @return string |
|
143 | - */ |
|
144 | - public function getMimeType() { |
|
145 | - return $this->_mimeType; |
|
146 | - } |
|
147 | - |
|
148 | - /** |
|
149 | - * Set mime type |
|
150 | - * |
|
151 | - * @param string $value |
|
152 | - * @return PHPExcel_Worksheet_MemoryDrawing |
|
153 | - */ |
|
154 | - public function setMimeType($value = PHPExcel_Worksheet_MemoryDrawing::MIMETYPE_DEFAULT) { |
|
155 | - $this->_mimeType = $value; |
|
156 | - return $this; |
|
157 | - } |
|
158 | - |
|
159 | - /** |
|
160 | - * Get indexed filename (using image index) |
|
161 | - * |
|
162 | - * @return string |
|
163 | - */ |
|
164 | - public function getIndexedFilename() { |
|
78 | + /** |
|
79 | + * Create a new PHPExcel_Worksheet_MemoryDrawing |
|
80 | + */ |
|
81 | + public function __construct() |
|
82 | + { |
|
83 | + // Initialise values |
|
84 | + $this->_imageResource = null; |
|
85 | + $this->_renderingFunction = self::RENDERING_DEFAULT; |
|
86 | + $this->_mimeType = self::MIMETYPE_DEFAULT; |
|
87 | + $this->_uniqueName = md5(rand(0, 9999). time() . rand(0, 9999)); |
|
88 | + |
|
89 | + // Initialize parent |
|
90 | + parent::__construct(); |
|
91 | + } |
|
92 | + |
|
93 | + /** |
|
94 | + * Get image resource |
|
95 | + * |
|
96 | + * @return resource |
|
97 | + */ |
|
98 | + public function getImageResource() { |
|
99 | + return $this->_imageResource; |
|
100 | + } |
|
101 | + |
|
102 | + /** |
|
103 | + * Set image resource |
|
104 | + * |
|
105 | + * @param $value resource |
|
106 | + * @return PHPExcel_Worksheet_MemoryDrawing |
|
107 | + */ |
|
108 | + public function setImageResource($value = null) { |
|
109 | + $this->_imageResource = $value; |
|
110 | + |
|
111 | + if (!is_null($this->_imageResource)) { |
|
112 | + // Get width/height |
|
113 | + $this->_width = imagesx($this->_imageResource); |
|
114 | + $this->_height = imagesy($this->_imageResource); |
|
115 | + } |
|
116 | + return $this; |
|
117 | + } |
|
118 | + |
|
119 | + /** |
|
120 | + * Get rendering function |
|
121 | + * |
|
122 | + * @return string |
|
123 | + */ |
|
124 | + public function getRenderingFunction() { |
|
125 | + return $this->_renderingFunction; |
|
126 | + } |
|
127 | + |
|
128 | + /** |
|
129 | + * Set rendering function |
|
130 | + * |
|
131 | + * @param string $value |
|
132 | + * @return PHPExcel_Worksheet_MemoryDrawing |
|
133 | + */ |
|
134 | + public function setRenderingFunction($value = PHPExcel_Worksheet_MemoryDrawing::RENDERING_DEFAULT) { |
|
135 | + $this->_renderingFunction = $value; |
|
136 | + return $this; |
|
137 | + } |
|
138 | + |
|
139 | + /** |
|
140 | + * Get mime type |
|
141 | + * |
|
142 | + * @return string |
|
143 | + */ |
|
144 | + public function getMimeType() { |
|
145 | + return $this->_mimeType; |
|
146 | + } |
|
147 | + |
|
148 | + /** |
|
149 | + * Set mime type |
|
150 | + * |
|
151 | + * @param string $value |
|
152 | + * @return PHPExcel_Worksheet_MemoryDrawing |
|
153 | + */ |
|
154 | + public function setMimeType($value = PHPExcel_Worksheet_MemoryDrawing::MIMETYPE_DEFAULT) { |
|
155 | + $this->_mimeType = $value; |
|
156 | + return $this; |
|
157 | + } |
|
158 | + |
|
159 | + /** |
|
160 | + * Get indexed filename (using image index) |
|
161 | + * |
|
162 | + * @return string |
|
163 | + */ |
|
164 | + public function getIndexedFilename() { |
|
165 | 165 | $extension = strtolower($this->getMimeType()); |
166 | 166 | $extension = explode('/', $extension); |
167 | 167 | $extension = $extension[1]; |
168 | 168 | |
169 | - return $this->_uniqueName . $this->getImageIndex() . '.' . $extension; |
|
170 | - } |
|
169 | + return $this->_uniqueName . $this->getImageIndex() . '.' . $extension; |
|
170 | + } |
|
171 | 171 | |
172 | 172 | /** |
173 | 173 | * Get hash code |
@@ -175,14 +175,14 @@ discard block |
||
175 | 175 | * @return string Hash code |
176 | 176 | */ |
177 | 177 | public function getHashCode() { |
178 | - return md5( |
|
179 | - $this->_renderingFunction |
|
180 | - . $this->_mimeType |
|
181 | - . $this->_uniqueName |
|
182 | - . parent::getHashCode() |
|
183 | - . __CLASS__ |
|
184 | - ); |
|
185 | - } |
|
178 | + return md5( |
|
179 | + $this->_renderingFunction |
|
180 | + . $this->_mimeType |
|
181 | + . $this->_uniqueName |
|
182 | + . parent::getHashCode() |
|
183 | + . __CLASS__ |
|
184 | + ); |
|
185 | + } |
|
186 | 186 | |
187 | 187 | /** |
188 | 188 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -40,42 +40,42 @@ |
||
40 | 40 | * |
41 | 41 | * @var double |
42 | 42 | */ |
43 | - private $_left = 0.7; |
|
43 | + private $_left = 0.7; |
|
44 | 44 | |
45 | 45 | /** |
46 | 46 | * Right |
47 | 47 | * |
48 | 48 | * @var double |
49 | 49 | */ |
50 | - private $_right = 0.7; |
|
50 | + private $_right = 0.7; |
|
51 | 51 | |
52 | 52 | /** |
53 | 53 | * Top |
54 | 54 | * |
55 | 55 | * @var double |
56 | 56 | */ |
57 | - private $_top = 0.75; |
|
57 | + private $_top = 0.75; |
|
58 | 58 | |
59 | 59 | /** |
60 | 60 | * Bottom |
61 | 61 | * |
62 | 62 | * @var double |
63 | 63 | */ |
64 | - private $_bottom = 0.75; |
|
64 | + private $_bottom = 0.75; |
|
65 | 65 | |
66 | 66 | /** |
67 | 67 | * Header |
68 | 68 | * |
69 | 69 | * @var double |
70 | 70 | */ |
71 | - private $_header = 0.3; |
|
71 | + private $_header = 0.3; |
|
72 | 72 | |
73 | 73 | /** |
74 | 74 | * Footer |
75 | 75 | * |
76 | 76 | * @var double |
77 | 77 | */ |
78 | - private $_footer = 0.3; |
|
78 | + private $_footer = 0.3; |
|
79 | 79 | |
80 | 80 | /** |
81 | 81 | * Create a new PHPExcel_Worksheet_PageMargins |
@@ -77,132 +77,132 @@ |
||
77 | 77 | */ |
78 | 78 | private $_footer = 0.3; |
79 | 79 | |
80 | - /** |
|
81 | - * Create a new PHPExcel_Worksheet_PageMargins |
|
82 | - */ |
|
83 | - public function __construct() |
|
84 | - { |
|
85 | - } |
|
86 | - |
|
87 | - /** |
|
88 | - * Get Left |
|
89 | - * |
|
90 | - * @return double |
|
91 | - */ |
|
92 | - public function getLeft() { |
|
93 | - return $this->_left; |
|
94 | - } |
|
95 | - |
|
96 | - /** |
|
97 | - * Set Left |
|
98 | - * |
|
99 | - * @param double $pValue |
|
100 | - * @return PHPExcel_Worksheet_PageMargins |
|
101 | - */ |
|
102 | - public function setLeft($pValue) { |
|
103 | - $this->_left = $pValue; |
|
104 | - return $this; |
|
105 | - } |
|
106 | - |
|
107 | - /** |
|
108 | - * Get Right |
|
109 | - * |
|
110 | - * @return double |
|
111 | - */ |
|
112 | - public function getRight() { |
|
113 | - return $this->_right; |
|
114 | - } |
|
115 | - |
|
116 | - /** |
|
117 | - * Set Right |
|
118 | - * |
|
119 | - * @param double $pValue |
|
120 | - * @return PHPExcel_Worksheet_PageMargins |
|
121 | - */ |
|
122 | - public function setRight($pValue) { |
|
123 | - $this->_right = $pValue; |
|
124 | - return $this; |
|
125 | - } |
|
126 | - |
|
127 | - /** |
|
128 | - * Get Top |
|
129 | - * |
|
130 | - * @return double |
|
131 | - */ |
|
132 | - public function getTop() { |
|
133 | - return $this->_top; |
|
134 | - } |
|
135 | - |
|
136 | - /** |
|
137 | - * Set Top |
|
138 | - * |
|
139 | - * @param double $pValue |
|
140 | - * @return PHPExcel_Worksheet_PageMargins |
|
141 | - */ |
|
142 | - public function setTop($pValue) { |
|
143 | - $this->_top = $pValue; |
|
144 | - return $this; |
|
145 | - } |
|
146 | - |
|
147 | - /** |
|
148 | - * Get Bottom |
|
149 | - * |
|
150 | - * @return double |
|
151 | - */ |
|
152 | - public function getBottom() { |
|
153 | - return $this->_bottom; |
|
154 | - } |
|
155 | - |
|
156 | - /** |
|
157 | - * Set Bottom |
|
158 | - * |
|
159 | - * @param double $pValue |
|
160 | - * @return PHPExcel_Worksheet_PageMargins |
|
161 | - */ |
|
162 | - public function setBottom($pValue) { |
|
163 | - $this->_bottom = $pValue; |
|
164 | - return $this; |
|
165 | - } |
|
166 | - |
|
167 | - /** |
|
168 | - * Get Header |
|
169 | - * |
|
170 | - * @return double |
|
171 | - */ |
|
172 | - public function getHeader() { |
|
173 | - return $this->_header; |
|
174 | - } |
|
175 | - |
|
176 | - /** |
|
177 | - * Set Header |
|
178 | - * |
|
179 | - * @param double $pValue |
|
180 | - * @return PHPExcel_Worksheet_PageMargins |
|
181 | - */ |
|
182 | - public function setHeader($pValue) { |
|
183 | - $this->_header = $pValue; |
|
184 | - return $this; |
|
185 | - } |
|
186 | - |
|
187 | - /** |
|
188 | - * Get Footer |
|
189 | - * |
|
190 | - * @return double |
|
191 | - */ |
|
192 | - public function getFooter() { |
|
193 | - return $this->_footer; |
|
194 | - } |
|
195 | - |
|
196 | - /** |
|
197 | - * Set Footer |
|
198 | - * |
|
199 | - * @param double $pValue |
|
200 | - * @return PHPExcel_Worksheet_PageMargins |
|
201 | - */ |
|
202 | - public function setFooter($pValue) { |
|
203 | - $this->_footer = $pValue; |
|
204 | - return $this; |
|
205 | - } |
|
80 | + /** |
|
81 | + * Create a new PHPExcel_Worksheet_PageMargins |
|
82 | + */ |
|
83 | + public function __construct() |
|
84 | + { |
|
85 | + } |
|
86 | + |
|
87 | + /** |
|
88 | + * Get Left |
|
89 | + * |
|
90 | + * @return double |
|
91 | + */ |
|
92 | + public function getLeft() { |
|
93 | + return $this->_left; |
|
94 | + } |
|
95 | + |
|
96 | + /** |
|
97 | + * Set Left |
|
98 | + * |
|
99 | + * @param double $pValue |
|
100 | + * @return PHPExcel_Worksheet_PageMargins |
|
101 | + */ |
|
102 | + public function setLeft($pValue) { |
|
103 | + $this->_left = $pValue; |
|
104 | + return $this; |
|
105 | + } |
|
106 | + |
|
107 | + /** |
|
108 | + * Get Right |
|
109 | + * |
|
110 | + * @return double |
|
111 | + */ |
|
112 | + public function getRight() { |
|
113 | + return $this->_right; |
|
114 | + } |
|
115 | + |
|
116 | + /** |
|
117 | + * Set Right |
|
118 | + * |
|
119 | + * @param double $pValue |
|
120 | + * @return PHPExcel_Worksheet_PageMargins |
|
121 | + */ |
|
122 | + public function setRight($pValue) { |
|
123 | + $this->_right = $pValue; |
|
124 | + return $this; |
|
125 | + } |
|
126 | + |
|
127 | + /** |
|
128 | + * Get Top |
|
129 | + * |
|
130 | + * @return double |
|
131 | + */ |
|
132 | + public function getTop() { |
|
133 | + return $this->_top; |
|
134 | + } |
|
135 | + |
|
136 | + /** |
|
137 | + * Set Top |
|
138 | + * |
|
139 | + * @param double $pValue |
|
140 | + * @return PHPExcel_Worksheet_PageMargins |
|
141 | + */ |
|
142 | + public function setTop($pValue) { |
|
143 | + $this->_top = $pValue; |
|
144 | + return $this; |
|
145 | + } |
|
146 | + |
|
147 | + /** |
|
148 | + * Get Bottom |
|
149 | + * |
|
150 | + * @return double |
|
151 | + */ |
|
152 | + public function getBottom() { |
|
153 | + return $this->_bottom; |
|
154 | + } |
|
155 | + |
|
156 | + /** |
|
157 | + * Set Bottom |
|
158 | + * |
|
159 | + * @param double $pValue |
|
160 | + * @return PHPExcel_Worksheet_PageMargins |
|
161 | + */ |
|
162 | + public function setBottom($pValue) { |
|
163 | + $this->_bottom = $pValue; |
|
164 | + return $this; |
|
165 | + } |
|
166 | + |
|
167 | + /** |
|
168 | + * Get Header |
|
169 | + * |
|
170 | + * @return double |
|
171 | + */ |
|
172 | + public function getHeader() { |
|
173 | + return $this->_header; |
|
174 | + } |
|
175 | + |
|
176 | + /** |
|
177 | + * Set Header |
|
178 | + * |
|
179 | + * @param double $pValue |
|
180 | + * @return PHPExcel_Worksheet_PageMargins |
|
181 | + */ |
|
182 | + public function setHeader($pValue) { |
|
183 | + $this->_header = $pValue; |
|
184 | + return $this; |
|
185 | + } |
|
186 | + |
|
187 | + /** |
|
188 | + * Get Footer |
|
189 | + * |
|
190 | + * @return double |
|
191 | + */ |
|
192 | + public function getFooter() { |
|
193 | + return $this->_footer; |
|
194 | + } |
|
195 | + |
|
196 | + /** |
|
197 | + * Set Footer |
|
198 | + * |
|
199 | + * @param double $pValue |
|
200 | + * @return PHPExcel_Worksheet_PageMargins |
|
201 | + */ |
|
202 | + public function setFooter($pValue) { |
|
203 | + $this->_footer = $pValue; |
|
204 | + return $this; |
|
205 | + } |
|
206 | 206 | |
207 | 207 | /** |
208 | 208 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -40,119 +40,119 @@ discard block |
||
40 | 40 | * |
41 | 41 | * @var boolean |
42 | 42 | */ |
43 | - private $_sheet = false; |
|
43 | + private $_sheet = false; |
|
44 | 44 | |
45 | 45 | /** |
46 | 46 | * Objects |
47 | 47 | * |
48 | 48 | * @var boolean |
49 | 49 | */ |
50 | - private $_objects = false; |
|
50 | + private $_objects = false; |
|
51 | 51 | |
52 | 52 | /** |
53 | 53 | * Scenarios |
54 | 54 | * |
55 | 55 | * @var boolean |
56 | 56 | */ |
57 | - private $_scenarios = false; |
|
57 | + private $_scenarios = false; |
|
58 | 58 | |
59 | 59 | /** |
60 | 60 | * Format cells |
61 | 61 | * |
62 | 62 | * @var boolean |
63 | 63 | */ |
64 | - private $_formatCells = false; |
|
64 | + private $_formatCells = false; |
|
65 | 65 | |
66 | 66 | /** |
67 | 67 | * Format columns |
68 | 68 | * |
69 | 69 | * @var boolean |
70 | 70 | */ |
71 | - private $_formatColumns = false; |
|
71 | + private $_formatColumns = false; |
|
72 | 72 | |
73 | 73 | /** |
74 | 74 | * Format rows |
75 | 75 | * |
76 | 76 | * @var boolean |
77 | 77 | */ |
78 | - private $_formatRows = false; |
|
78 | + private $_formatRows = false; |
|
79 | 79 | |
80 | 80 | /** |
81 | 81 | * Insert columns |
82 | 82 | * |
83 | 83 | * @var boolean |
84 | 84 | */ |
85 | - private $_insertColumns = false; |
|
85 | + private $_insertColumns = false; |
|
86 | 86 | |
87 | 87 | /** |
88 | 88 | * Insert rows |
89 | 89 | * |
90 | 90 | * @var boolean |
91 | 91 | */ |
92 | - private $_insertRows = false; |
|
92 | + private $_insertRows = false; |
|
93 | 93 | |
94 | 94 | /** |
95 | 95 | * Insert hyperlinks |
96 | 96 | * |
97 | 97 | * @var boolean |
98 | 98 | */ |
99 | - private $_insertHyperlinks = false; |
|
99 | + private $_insertHyperlinks = false; |
|
100 | 100 | |
101 | 101 | /** |
102 | 102 | * Delete columns |
103 | 103 | * |
104 | 104 | * @var boolean |
105 | 105 | */ |
106 | - private $_deleteColumns = false; |
|
106 | + private $_deleteColumns = false; |
|
107 | 107 | |
108 | 108 | /** |
109 | 109 | * Delete rows |
110 | 110 | * |
111 | 111 | * @var boolean |
112 | 112 | */ |
113 | - private $_deleteRows = false; |
|
113 | + private $_deleteRows = false; |
|
114 | 114 | |
115 | 115 | /** |
116 | 116 | * Select locked cells |
117 | 117 | * |
118 | 118 | * @var boolean |
119 | 119 | */ |
120 | - private $_selectLockedCells = false; |
|
120 | + private $_selectLockedCells = false; |
|
121 | 121 | |
122 | 122 | /** |
123 | 123 | * Sort |
124 | 124 | * |
125 | 125 | * @var boolean |
126 | 126 | */ |
127 | - private $_sort = false; |
|
127 | + private $_sort = false; |
|
128 | 128 | |
129 | 129 | /** |
130 | 130 | * AutoFilter |
131 | 131 | * |
132 | 132 | * @var boolean |
133 | 133 | */ |
134 | - private $_autoFilter = false; |
|
134 | + private $_autoFilter = false; |
|
135 | 135 | |
136 | 136 | /** |
137 | 137 | * Pivot tables |
138 | 138 | * |
139 | 139 | * @var boolean |
140 | 140 | */ |
141 | - private $_pivotTables = false; |
|
141 | + private $_pivotTables = false; |
|
142 | 142 | |
143 | 143 | /** |
144 | 144 | * Select unlocked cells |
145 | 145 | * |
146 | 146 | * @var boolean |
147 | 147 | */ |
148 | - private $_selectUnlockedCells = false; |
|
148 | + private $_selectUnlockedCells = false; |
|
149 | 149 | |
150 | 150 | /** |
151 | 151 | * Password |
152 | 152 | * |
153 | 153 | * @var string |
154 | 154 | */ |
155 | - private $_password = ''; |
|
155 | + private $_password = ''; |
|
156 | 156 | |
157 | 157 | /** |
158 | 158 | * Create a new PHPExcel_Worksheet_Protection |
@@ -522,7 +522,7 @@ discard block |
||
522 | 522 | * @return PHPExcel_Worksheet_Protection |
523 | 523 | */ |
524 | 524 | function setPassword($pValue = '', $pAlreadyHashed = false) { |
525 | - if (!$pAlreadyHashed) { |
|
525 | + if ( ! $pAlreadyHashed) { |
|
526 | 526 | $pValue = PHPExcel_Shared_PasswordHasher::hashPassword($pValue); |
527 | 527 | } |
528 | 528 | $this->_password = $pValue; |
@@ -154,20 +154,20 @@ discard block |
||
154 | 154 | */ |
155 | 155 | private $_password = ''; |
156 | 156 | |
157 | - /** |
|
158 | - * Create a new PHPExcel_Worksheet_Protection |
|
159 | - */ |
|
160 | - public function __construct() |
|
161 | - { |
|
162 | - } |
|
163 | - |
|
164 | - /** |
|
165 | - * Is some sort of protection enabled? |
|
166 | - * |
|
167 | - * @return boolean |
|
168 | - */ |
|
169 | - function isProtectionEnabled() { |
|
170 | - return $this->_sheet || |
|
157 | + /** |
|
158 | + * Create a new PHPExcel_Worksheet_Protection |
|
159 | + */ |
|
160 | + public function __construct() |
|
161 | + { |
|
162 | + } |
|
163 | + |
|
164 | + /** |
|
165 | + * Is some sort of protection enabled? |
|
166 | + * |
|
167 | + * @return boolean |
|
168 | + */ |
|
169 | + function isProtectionEnabled() { |
|
170 | + return $this->_sheet || |
|
171 | 171 | $this->_objects || |
172 | 172 | $this->_scenarios || |
173 | 173 | $this->_formatCells || |
@@ -183,351 +183,351 @@ discard block |
||
183 | 183 | $this->_autoFilter || |
184 | 184 | $this->_pivotTables || |
185 | 185 | $this->_selectUnlockedCells; |
186 | - } |
|
187 | - |
|
188 | - /** |
|
189 | - * Get Sheet |
|
190 | - * |
|
191 | - * @return boolean |
|
192 | - */ |
|
193 | - function getSheet() { |
|
194 | - return $this->_sheet; |
|
195 | - } |
|
196 | - |
|
197 | - /** |
|
198 | - * Set Sheet |
|
199 | - * |
|
200 | - * @param boolean $pValue |
|
201 | - * @return PHPExcel_Worksheet_Protection |
|
202 | - */ |
|
203 | - function setSheet($pValue = false) { |
|
204 | - $this->_sheet = $pValue; |
|
205 | - return $this; |
|
206 | - } |
|
207 | - |
|
208 | - /** |
|
209 | - * Get Objects |
|
210 | - * |
|
211 | - * @return boolean |
|
212 | - */ |
|
213 | - function getObjects() { |
|
214 | - return $this->_objects; |
|
215 | - } |
|
216 | - |
|
217 | - /** |
|
218 | - * Set Objects |
|
219 | - * |
|
220 | - * @param boolean $pValue |
|
221 | - * @return PHPExcel_Worksheet_Protection |
|
222 | - */ |
|
223 | - function setObjects($pValue = false) { |
|
224 | - $this->_objects = $pValue; |
|
225 | - return $this; |
|
226 | - } |
|
227 | - |
|
228 | - /** |
|
229 | - * Get Scenarios |
|
230 | - * |
|
231 | - * @return boolean |
|
232 | - */ |
|
233 | - function getScenarios() { |
|
234 | - return $this->_scenarios; |
|
235 | - } |
|
236 | - |
|
237 | - /** |
|
238 | - * Set Scenarios |
|
239 | - * |
|
240 | - * @param boolean $pValue |
|
241 | - * @return PHPExcel_Worksheet_Protection |
|
242 | - */ |
|
243 | - function setScenarios($pValue = false) { |
|
244 | - $this->_scenarios = $pValue; |
|
245 | - return $this; |
|
246 | - } |
|
247 | - |
|
248 | - /** |
|
249 | - * Get FormatCells |
|
250 | - * |
|
251 | - * @return boolean |
|
252 | - */ |
|
253 | - function getFormatCells() { |
|
254 | - return $this->_formatCells; |
|
255 | - } |
|
256 | - |
|
257 | - /** |
|
258 | - * Set FormatCells |
|
259 | - * |
|
260 | - * @param boolean $pValue |
|
261 | - * @return PHPExcel_Worksheet_Protection |
|
262 | - */ |
|
263 | - function setFormatCells($pValue = false) { |
|
264 | - $this->_formatCells = $pValue; |
|
265 | - return $this; |
|
266 | - } |
|
267 | - |
|
268 | - /** |
|
269 | - * Get FormatColumns |
|
270 | - * |
|
271 | - * @return boolean |
|
272 | - */ |
|
273 | - function getFormatColumns() { |
|
274 | - return $this->_formatColumns; |
|
275 | - } |
|
276 | - |
|
277 | - /** |
|
278 | - * Set FormatColumns |
|
279 | - * |
|
280 | - * @param boolean $pValue |
|
281 | - * @return PHPExcel_Worksheet_Protection |
|
282 | - */ |
|
283 | - function setFormatColumns($pValue = false) { |
|
284 | - $this->_formatColumns = $pValue; |
|
285 | - return $this; |
|
286 | - } |
|
287 | - |
|
288 | - /** |
|
289 | - * Get FormatRows |
|
290 | - * |
|
291 | - * @return boolean |
|
292 | - */ |
|
293 | - function getFormatRows() { |
|
294 | - return $this->_formatRows; |
|
295 | - } |
|
296 | - |
|
297 | - /** |
|
298 | - * Set FormatRows |
|
299 | - * |
|
300 | - * @param boolean $pValue |
|
301 | - * @return PHPExcel_Worksheet_Protection |
|
302 | - */ |
|
303 | - function setFormatRows($pValue = false) { |
|
304 | - $this->_formatRows = $pValue; |
|
305 | - return $this; |
|
306 | - } |
|
307 | - |
|
308 | - /** |
|
309 | - * Get InsertColumns |
|
310 | - * |
|
311 | - * @return boolean |
|
312 | - */ |
|
313 | - function getInsertColumns() { |
|
314 | - return $this->_insertColumns; |
|
315 | - } |
|
316 | - |
|
317 | - /** |
|
318 | - * Set InsertColumns |
|
319 | - * |
|
320 | - * @param boolean $pValue |
|
321 | - * @return PHPExcel_Worksheet_Protection |
|
322 | - */ |
|
323 | - function setInsertColumns($pValue = false) { |
|
324 | - $this->_insertColumns = $pValue; |
|
325 | - return $this; |
|
326 | - } |
|
327 | - |
|
328 | - /** |
|
329 | - * Get InsertRows |
|
330 | - * |
|
331 | - * @return boolean |
|
332 | - */ |
|
333 | - function getInsertRows() { |
|
334 | - return $this->_insertRows; |
|
335 | - } |
|
336 | - |
|
337 | - /** |
|
338 | - * Set InsertRows |
|
339 | - * |
|
340 | - * @param boolean $pValue |
|
341 | - * @return PHPExcel_Worksheet_Protection |
|
342 | - */ |
|
343 | - function setInsertRows($pValue = false) { |
|
344 | - $this->_insertRows = $pValue; |
|
345 | - return $this; |
|
346 | - } |
|
347 | - |
|
348 | - /** |
|
349 | - * Get InsertHyperlinks |
|
350 | - * |
|
351 | - * @return boolean |
|
352 | - */ |
|
353 | - function getInsertHyperlinks() { |
|
354 | - return $this->_insertHyperlinks; |
|
355 | - } |
|
356 | - |
|
357 | - /** |
|
358 | - * Set InsertHyperlinks |
|
359 | - * |
|
360 | - * @param boolean $pValue |
|
361 | - * @return PHPExcel_Worksheet_Protection |
|
362 | - */ |
|
363 | - function setInsertHyperlinks($pValue = false) { |
|
364 | - $this->_insertHyperlinks = $pValue; |
|
365 | - return $this; |
|
366 | - } |
|
367 | - |
|
368 | - /** |
|
369 | - * Get DeleteColumns |
|
370 | - * |
|
371 | - * @return boolean |
|
372 | - */ |
|
373 | - function getDeleteColumns() { |
|
374 | - return $this->_deleteColumns; |
|
375 | - } |
|
376 | - |
|
377 | - /** |
|
378 | - * Set DeleteColumns |
|
379 | - * |
|
380 | - * @param boolean $pValue |
|
381 | - * @return PHPExcel_Worksheet_Protection |
|
382 | - */ |
|
383 | - function setDeleteColumns($pValue = false) { |
|
384 | - $this->_deleteColumns = $pValue; |
|
385 | - return $this; |
|
386 | - } |
|
387 | - |
|
388 | - /** |
|
389 | - * Get DeleteRows |
|
390 | - * |
|
391 | - * @return boolean |
|
392 | - */ |
|
393 | - function getDeleteRows() { |
|
394 | - return $this->_deleteRows; |
|
395 | - } |
|
396 | - |
|
397 | - /** |
|
398 | - * Set DeleteRows |
|
399 | - * |
|
400 | - * @param boolean $pValue |
|
401 | - * @return PHPExcel_Worksheet_Protection |
|
402 | - */ |
|
403 | - function setDeleteRows($pValue = false) { |
|
404 | - $this->_deleteRows = $pValue; |
|
405 | - return $this; |
|
406 | - } |
|
407 | - |
|
408 | - /** |
|
409 | - * Get SelectLockedCells |
|
410 | - * |
|
411 | - * @return boolean |
|
412 | - */ |
|
413 | - function getSelectLockedCells() { |
|
414 | - return $this->_selectLockedCells; |
|
415 | - } |
|
416 | - |
|
417 | - /** |
|
418 | - * Set SelectLockedCells |
|
419 | - * |
|
420 | - * @param boolean $pValue |
|
421 | - * @return PHPExcel_Worksheet_Protection |
|
422 | - */ |
|
423 | - function setSelectLockedCells($pValue = false) { |
|
424 | - $this->_selectLockedCells = $pValue; |
|
425 | - return $this; |
|
426 | - } |
|
427 | - |
|
428 | - /** |
|
429 | - * Get Sort |
|
430 | - * |
|
431 | - * @return boolean |
|
432 | - */ |
|
433 | - function getSort() { |
|
434 | - return $this->_sort; |
|
435 | - } |
|
436 | - |
|
437 | - /** |
|
438 | - * Set Sort |
|
439 | - * |
|
440 | - * @param boolean $pValue |
|
441 | - * @return PHPExcel_Worksheet_Protection |
|
442 | - */ |
|
443 | - function setSort($pValue = false) { |
|
444 | - $this->_sort = $pValue; |
|
445 | - return $this; |
|
446 | - } |
|
447 | - |
|
448 | - /** |
|
449 | - * Get AutoFilter |
|
450 | - * |
|
451 | - * @return boolean |
|
452 | - */ |
|
453 | - function getAutoFilter() { |
|
454 | - return $this->_autoFilter; |
|
455 | - } |
|
456 | - |
|
457 | - /** |
|
458 | - * Set AutoFilter |
|
459 | - * |
|
460 | - * @param boolean $pValue |
|
461 | - * @return PHPExcel_Worksheet_Protection |
|
462 | - */ |
|
463 | - function setAutoFilter($pValue = false) { |
|
464 | - $this->_autoFilter = $pValue; |
|
465 | - return $this; |
|
466 | - } |
|
467 | - |
|
468 | - /** |
|
469 | - * Get PivotTables |
|
470 | - * |
|
471 | - * @return boolean |
|
472 | - */ |
|
473 | - function getPivotTables() { |
|
474 | - return $this->_pivotTables; |
|
475 | - } |
|
476 | - |
|
477 | - /** |
|
478 | - * Set PivotTables |
|
479 | - * |
|
480 | - * @param boolean $pValue |
|
481 | - * @return PHPExcel_Worksheet_Protection |
|
482 | - */ |
|
483 | - function setPivotTables($pValue = false) { |
|
484 | - $this->_pivotTables = $pValue; |
|
485 | - return $this; |
|
486 | - } |
|
487 | - |
|
488 | - /** |
|
489 | - * Get SelectUnlockedCells |
|
490 | - * |
|
491 | - * @return boolean |
|
492 | - */ |
|
493 | - function getSelectUnlockedCells() { |
|
494 | - return $this->_selectUnlockedCells; |
|
495 | - } |
|
496 | - |
|
497 | - /** |
|
498 | - * Set SelectUnlockedCells |
|
499 | - * |
|
500 | - * @param boolean $pValue |
|
501 | - * @return PHPExcel_Worksheet_Protection |
|
502 | - */ |
|
503 | - function setSelectUnlockedCells($pValue = false) { |
|
504 | - $this->_selectUnlockedCells = $pValue; |
|
505 | - return $this; |
|
506 | - } |
|
507 | - |
|
508 | - /** |
|
509 | - * Get Password (hashed) |
|
510 | - * |
|
511 | - * @return string |
|
512 | - */ |
|
513 | - function getPassword() { |
|
514 | - return $this->_password; |
|
515 | - } |
|
516 | - |
|
517 | - /** |
|
518 | - * Set Password |
|
519 | - * |
|
520 | - * @param string $pValue |
|
521 | - * @param boolean $pAlreadyHashed If the password has already been hashed, set this to true |
|
522 | - * @return PHPExcel_Worksheet_Protection |
|
523 | - */ |
|
524 | - function setPassword($pValue = '', $pAlreadyHashed = false) { |
|
525 | - if (!$pAlreadyHashed) { |
|
526 | - $pValue = PHPExcel_Shared_PasswordHasher::hashPassword($pValue); |
|
527 | - } |
|
186 | + } |
|
187 | + |
|
188 | + /** |
|
189 | + * Get Sheet |
|
190 | + * |
|
191 | + * @return boolean |
|
192 | + */ |
|
193 | + function getSheet() { |
|
194 | + return $this->_sheet; |
|
195 | + } |
|
196 | + |
|
197 | + /** |
|
198 | + * Set Sheet |
|
199 | + * |
|
200 | + * @param boolean $pValue |
|
201 | + * @return PHPExcel_Worksheet_Protection |
|
202 | + */ |
|
203 | + function setSheet($pValue = false) { |
|
204 | + $this->_sheet = $pValue; |
|
205 | + return $this; |
|
206 | + } |
|
207 | + |
|
208 | + /** |
|
209 | + * Get Objects |
|
210 | + * |
|
211 | + * @return boolean |
|
212 | + */ |
|
213 | + function getObjects() { |
|
214 | + return $this->_objects; |
|
215 | + } |
|
216 | + |
|
217 | + /** |
|
218 | + * Set Objects |
|
219 | + * |
|
220 | + * @param boolean $pValue |
|
221 | + * @return PHPExcel_Worksheet_Protection |
|
222 | + */ |
|
223 | + function setObjects($pValue = false) { |
|
224 | + $this->_objects = $pValue; |
|
225 | + return $this; |
|
226 | + } |
|
227 | + |
|
228 | + /** |
|
229 | + * Get Scenarios |
|
230 | + * |
|
231 | + * @return boolean |
|
232 | + */ |
|
233 | + function getScenarios() { |
|
234 | + return $this->_scenarios; |
|
235 | + } |
|
236 | + |
|
237 | + /** |
|
238 | + * Set Scenarios |
|
239 | + * |
|
240 | + * @param boolean $pValue |
|
241 | + * @return PHPExcel_Worksheet_Protection |
|
242 | + */ |
|
243 | + function setScenarios($pValue = false) { |
|
244 | + $this->_scenarios = $pValue; |
|
245 | + return $this; |
|
246 | + } |
|
247 | + |
|
248 | + /** |
|
249 | + * Get FormatCells |
|
250 | + * |
|
251 | + * @return boolean |
|
252 | + */ |
|
253 | + function getFormatCells() { |
|
254 | + return $this->_formatCells; |
|
255 | + } |
|
256 | + |
|
257 | + /** |
|
258 | + * Set FormatCells |
|
259 | + * |
|
260 | + * @param boolean $pValue |
|
261 | + * @return PHPExcel_Worksheet_Protection |
|
262 | + */ |
|
263 | + function setFormatCells($pValue = false) { |
|
264 | + $this->_formatCells = $pValue; |
|
265 | + return $this; |
|
266 | + } |
|
267 | + |
|
268 | + /** |
|
269 | + * Get FormatColumns |
|
270 | + * |
|
271 | + * @return boolean |
|
272 | + */ |
|
273 | + function getFormatColumns() { |
|
274 | + return $this->_formatColumns; |
|
275 | + } |
|
276 | + |
|
277 | + /** |
|
278 | + * Set FormatColumns |
|
279 | + * |
|
280 | + * @param boolean $pValue |
|
281 | + * @return PHPExcel_Worksheet_Protection |
|
282 | + */ |
|
283 | + function setFormatColumns($pValue = false) { |
|
284 | + $this->_formatColumns = $pValue; |
|
285 | + return $this; |
|
286 | + } |
|
287 | + |
|
288 | + /** |
|
289 | + * Get FormatRows |
|
290 | + * |
|
291 | + * @return boolean |
|
292 | + */ |
|
293 | + function getFormatRows() { |
|
294 | + return $this->_formatRows; |
|
295 | + } |
|
296 | + |
|
297 | + /** |
|
298 | + * Set FormatRows |
|
299 | + * |
|
300 | + * @param boolean $pValue |
|
301 | + * @return PHPExcel_Worksheet_Protection |
|
302 | + */ |
|
303 | + function setFormatRows($pValue = false) { |
|
304 | + $this->_formatRows = $pValue; |
|
305 | + return $this; |
|
306 | + } |
|
307 | + |
|
308 | + /** |
|
309 | + * Get InsertColumns |
|
310 | + * |
|
311 | + * @return boolean |
|
312 | + */ |
|
313 | + function getInsertColumns() { |
|
314 | + return $this->_insertColumns; |
|
315 | + } |
|
316 | + |
|
317 | + /** |
|
318 | + * Set InsertColumns |
|
319 | + * |
|
320 | + * @param boolean $pValue |
|
321 | + * @return PHPExcel_Worksheet_Protection |
|
322 | + */ |
|
323 | + function setInsertColumns($pValue = false) { |
|
324 | + $this->_insertColumns = $pValue; |
|
325 | + return $this; |
|
326 | + } |
|
327 | + |
|
328 | + /** |
|
329 | + * Get InsertRows |
|
330 | + * |
|
331 | + * @return boolean |
|
332 | + */ |
|
333 | + function getInsertRows() { |
|
334 | + return $this->_insertRows; |
|
335 | + } |
|
336 | + |
|
337 | + /** |
|
338 | + * Set InsertRows |
|
339 | + * |
|
340 | + * @param boolean $pValue |
|
341 | + * @return PHPExcel_Worksheet_Protection |
|
342 | + */ |
|
343 | + function setInsertRows($pValue = false) { |
|
344 | + $this->_insertRows = $pValue; |
|
345 | + return $this; |
|
346 | + } |
|
347 | + |
|
348 | + /** |
|
349 | + * Get InsertHyperlinks |
|
350 | + * |
|
351 | + * @return boolean |
|
352 | + */ |
|
353 | + function getInsertHyperlinks() { |
|
354 | + return $this->_insertHyperlinks; |
|
355 | + } |
|
356 | + |
|
357 | + /** |
|
358 | + * Set InsertHyperlinks |
|
359 | + * |
|
360 | + * @param boolean $pValue |
|
361 | + * @return PHPExcel_Worksheet_Protection |
|
362 | + */ |
|
363 | + function setInsertHyperlinks($pValue = false) { |
|
364 | + $this->_insertHyperlinks = $pValue; |
|
365 | + return $this; |
|
366 | + } |
|
367 | + |
|
368 | + /** |
|
369 | + * Get DeleteColumns |
|
370 | + * |
|
371 | + * @return boolean |
|
372 | + */ |
|
373 | + function getDeleteColumns() { |
|
374 | + return $this->_deleteColumns; |
|
375 | + } |
|
376 | + |
|
377 | + /** |
|
378 | + * Set DeleteColumns |
|
379 | + * |
|
380 | + * @param boolean $pValue |
|
381 | + * @return PHPExcel_Worksheet_Protection |
|
382 | + */ |
|
383 | + function setDeleteColumns($pValue = false) { |
|
384 | + $this->_deleteColumns = $pValue; |
|
385 | + return $this; |
|
386 | + } |
|
387 | + |
|
388 | + /** |
|
389 | + * Get DeleteRows |
|
390 | + * |
|
391 | + * @return boolean |
|
392 | + */ |
|
393 | + function getDeleteRows() { |
|
394 | + return $this->_deleteRows; |
|
395 | + } |
|
396 | + |
|
397 | + /** |
|
398 | + * Set DeleteRows |
|
399 | + * |
|
400 | + * @param boolean $pValue |
|
401 | + * @return PHPExcel_Worksheet_Protection |
|
402 | + */ |
|
403 | + function setDeleteRows($pValue = false) { |
|
404 | + $this->_deleteRows = $pValue; |
|
405 | + return $this; |
|
406 | + } |
|
407 | + |
|
408 | + /** |
|
409 | + * Get SelectLockedCells |
|
410 | + * |
|
411 | + * @return boolean |
|
412 | + */ |
|
413 | + function getSelectLockedCells() { |
|
414 | + return $this->_selectLockedCells; |
|
415 | + } |
|
416 | + |
|
417 | + /** |
|
418 | + * Set SelectLockedCells |
|
419 | + * |
|
420 | + * @param boolean $pValue |
|
421 | + * @return PHPExcel_Worksheet_Protection |
|
422 | + */ |
|
423 | + function setSelectLockedCells($pValue = false) { |
|
424 | + $this->_selectLockedCells = $pValue; |
|
425 | + return $this; |
|
426 | + } |
|
427 | + |
|
428 | + /** |
|
429 | + * Get Sort |
|
430 | + * |
|
431 | + * @return boolean |
|
432 | + */ |
|
433 | + function getSort() { |
|
434 | + return $this->_sort; |
|
435 | + } |
|
436 | + |
|
437 | + /** |
|
438 | + * Set Sort |
|
439 | + * |
|
440 | + * @param boolean $pValue |
|
441 | + * @return PHPExcel_Worksheet_Protection |
|
442 | + */ |
|
443 | + function setSort($pValue = false) { |
|
444 | + $this->_sort = $pValue; |
|
445 | + return $this; |
|
446 | + } |
|
447 | + |
|
448 | + /** |
|
449 | + * Get AutoFilter |
|
450 | + * |
|
451 | + * @return boolean |
|
452 | + */ |
|
453 | + function getAutoFilter() { |
|
454 | + return $this->_autoFilter; |
|
455 | + } |
|
456 | + |
|
457 | + /** |
|
458 | + * Set AutoFilter |
|
459 | + * |
|
460 | + * @param boolean $pValue |
|
461 | + * @return PHPExcel_Worksheet_Protection |
|
462 | + */ |
|
463 | + function setAutoFilter($pValue = false) { |
|
464 | + $this->_autoFilter = $pValue; |
|
465 | + return $this; |
|
466 | + } |
|
467 | + |
|
468 | + /** |
|
469 | + * Get PivotTables |
|
470 | + * |
|
471 | + * @return boolean |
|
472 | + */ |
|
473 | + function getPivotTables() { |
|
474 | + return $this->_pivotTables; |
|
475 | + } |
|
476 | + |
|
477 | + /** |
|
478 | + * Set PivotTables |
|
479 | + * |
|
480 | + * @param boolean $pValue |
|
481 | + * @return PHPExcel_Worksheet_Protection |
|
482 | + */ |
|
483 | + function setPivotTables($pValue = false) { |
|
484 | + $this->_pivotTables = $pValue; |
|
485 | + return $this; |
|
486 | + } |
|
487 | + |
|
488 | + /** |
|
489 | + * Get SelectUnlockedCells |
|
490 | + * |
|
491 | + * @return boolean |
|
492 | + */ |
|
493 | + function getSelectUnlockedCells() { |
|
494 | + return $this->_selectUnlockedCells; |
|
495 | + } |
|
496 | + |
|
497 | + /** |
|
498 | + * Set SelectUnlockedCells |
|
499 | + * |
|
500 | + * @param boolean $pValue |
|
501 | + * @return PHPExcel_Worksheet_Protection |
|
502 | + */ |
|
503 | + function setSelectUnlockedCells($pValue = false) { |
|
504 | + $this->_selectUnlockedCells = $pValue; |
|
505 | + return $this; |
|
506 | + } |
|
507 | + |
|
508 | + /** |
|
509 | + * Get Password (hashed) |
|
510 | + * |
|
511 | + * @return string |
|
512 | + */ |
|
513 | + function getPassword() { |
|
514 | + return $this->_password; |
|
515 | + } |
|
516 | + |
|
517 | + /** |
|
518 | + * Set Password |
|
519 | + * |
|
520 | + * @param string $pValue |
|
521 | + * @param boolean $pAlreadyHashed If the password has already been hashed, set this to true |
|
522 | + * @return PHPExcel_Worksheet_Protection |
|
523 | + */ |
|
524 | + function setPassword($pValue = '', $pAlreadyHashed = false) { |
|
525 | + if (!$pAlreadyHashed) { |
|
526 | + $pValue = PHPExcel_Shared_PasswordHasher::hashPassword($pValue); |
|
527 | + } |
|
528 | 528 | $this->_password = $pValue; |
529 | 529 | return $this; |
530 | - } |
|
530 | + } |
|
531 | 531 | |
532 | 532 | /** |
533 | 533 | * Implement PHP __clone to create a deep clone, not just a shallow copy. |
@@ -59,8 +59,8 @@ |
||
59 | 59 | */ |
60 | 60 | public function __construct(PHPExcel_Worksheet $parent = null, $rowIndex = 1) { |
61 | 61 | // Set parent and row index |
62 | - $this->_parent = $parent; |
|
63 | - $this->_rowIndex = $rowIndex; |
|
62 | + $this->_parent = $parent; |
|
63 | + $this->_rowIndex = $rowIndex; |
|
64 | 64 | } |
65 | 65 | |
66 | 66 | /** |
@@ -133,8 +133,9 @@ |
||
133 | 133 | * Set the iterator to its previous value |
134 | 134 | */ |
135 | 135 | public function prev() { |
136 | - if ($this->_position > 1) |
|
137 | - --$this->_position; |
|
136 | + if ($this->_position > 1) { |
|
137 | + --$this->_position; |
|
138 | + } |
|
138 | 139 | } |
139 | 140 | |
140 | 141 | /** |