@@ -234,7 +234,7 @@ |
||
234 | 234 | * @param array $old_row_as_array |
235 | 235 | * @param string $new_table |
236 | 236 | * @param array $new_row_as_array columns=>values like used in wpdb->insert |
237 | - * @param array $data_types numerically indexed |
|
237 | + * @param string[] $data_types numerically indexed |
|
238 | 238 | * @return string |
239 | 239 | */ |
240 | 240 | protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types){ |
@@ -264,9 +264,9 @@ |
||
264 | 264 | /** |
265 | 265 | * Same as json_encode, just avoids putting |
266 | 266 | * serialized arrays into the http build query, as that would |
267 | - * @param array $array_of_data |
|
268 | - * @return string |
|
269 | - */ |
|
267 | + * @param array $array_of_data |
|
268 | + * @return string |
|
269 | + */ |
|
270 | 270 | protected function _json_encode($array_of_data){ |
271 | 271 | //we'd rather NOT serialize the transaction details |
272 | 272 | $fields_to_include = array(); |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | $errors = $this->get_errors(); |
120 | 120 | if($errors){ |
121 | 121 | return end($errors); |
122 | - }else{ |
|
122 | + } else{ |
|
123 | 123 | return null; |
124 | 124 | } |
125 | 125 | } |
@@ -131,7 +131,7 @@ discard block |
||
131 | 131 | public function add_error($error, $force = FALSE ){ |
132 | 132 | if( ! defined( 'EE_DMS_ERROR_LIMIT' ) ){ |
133 | 133 | $limit = 50; |
134 | - }else{ |
|
134 | + } else{ |
|
135 | 135 | $limit = EE_DMS_ERROR_LIMIT; |
136 | 136 | } |
137 | 137 | //make sure errors is an array, see ticket #8261 |
@@ -144,10 +144,10 @@ discard block |
||
144 | 144 | $this->_errors = array_slice( $this->_errors, $limit / 2, $limit / 2 ); |
145 | 145 | $this->_errors[] = "Limit reached; removed first half of errors to save space"; |
146 | 146 | $this->_errors[] = $error; |
147 | - }else{ |
|
147 | + } else{ |
|
148 | 148 | $this->_errors[ $limit ] = 'More, but limit reached...'; |
149 | 149 | } |
150 | - }else{ |
|
150 | + } else{ |
|
151 | 151 | $this->_errors[] = $error; |
152 | 152 | } |
153 | 153 | } |
@@ -20,7 +20,7 @@ discard block |
||
20 | 20 | |
21 | 21 | |
22 | 22 | |
23 | -abstract class EE_Data_Migration_Class_Base{ |
|
23 | +abstract class EE_Data_Migration_Class_Base { |
|
24 | 24 | |
25 | 25 | /** |
26 | 26 | * @var $records_to_migrate int count of all that have been migrated |
@@ -72,7 +72,7 @@ discard block |
||
72 | 72 | * @param TableManager $table_manager |
73 | 73 | * @param TableAnalysis $table_analysis |
74 | 74 | */ |
75 | - public function __construct( TableManager $table_manager = null, TableAnalysis $table_analysis = null ){ |
|
75 | + public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null) { |
|
76 | 76 | $this->_table_manager = $table_manager; |
77 | 77 | $this->_table_analysis = $table_analysis; |
78 | 78 | $this->set_status(EE_Data_Migration_Manager::status_continue); |
@@ -85,9 +85,9 @@ discard block |
||
85 | 85 | * @throws EE_Error |
86 | 86 | * @return string |
87 | 87 | */ |
88 | - public function pretty_name(){ |
|
89 | - if($this->_pretty_name === null){ |
|
90 | - throw new EE_Error(sprintf(__("Please give a pretty name to the migration script stage %s by assigning the property _pretty_name in the constructor", "event_espresso"),get_class($this))); |
|
88 | + public function pretty_name() { |
|
89 | + if ($this->_pretty_name === null) { |
|
90 | + throw new EE_Error(sprintf(__("Please give a pretty name to the migration script stage %s by assigning the property _pretty_name in the constructor", "event_espresso"), get_class($this))); |
|
91 | 91 | } |
92 | 92 | return $this->_pretty_name; |
93 | 93 | } |
@@ -95,8 +95,8 @@ discard block |
||
95 | 95 | * |
96 | 96 | * @return int |
97 | 97 | */ |
98 | - public function count_records_to_migrate(){ |
|
99 | - if( $this->_records_to_migrate == null){ |
|
98 | + public function count_records_to_migrate() { |
|
99 | + if ($this->_records_to_migrate == null) { |
|
100 | 100 | $this->_records_to_migrate = $this->_count_records_to_migrate(); |
101 | 101 | } |
102 | 102 | return $this->_records_to_migrate; |
@@ -116,9 +116,9 @@ discard block |
||
116 | 116 | * @return string one of EE_Data_Migration_Manager::status_* constants |
117 | 117 | * @throws EE_Error |
118 | 118 | */ |
119 | - public function get_status(){ |
|
120 | - if($this->_status === null){ |
|
121 | - throw new EE_Error(sprintf(__("Trying to get status of Migration class %s, but it has not been initialized yet. It should be set in the constructor.", "event_espresso"),get_class($this))); |
|
119 | + public function get_status() { |
|
120 | + if ($this->_status === null) { |
|
121 | + throw new EE_Error(sprintf(__("Trying to get status of Migration class %s, but it has not been initialized yet. It should be set in the constructor.", "event_espresso"), get_class($this))); |
|
122 | 122 | } |
123 | 123 | return $this->_status; |
124 | 124 | } |
@@ -127,7 +127,7 @@ discard block |
||
127 | 127 | * @param string $status |
128 | 128 | * @return void |
129 | 129 | */ |
130 | - protected function set_status($status){ |
|
130 | + protected function set_status($status) { |
|
131 | 131 | $this->_status = $status; |
132 | 132 | } |
133 | 133 | /** |
@@ -139,11 +139,11 @@ discard block |
||
139 | 139 | * Returns the last error that occurred. If none occurred, returns null |
140 | 140 | * @return string |
141 | 141 | */ |
142 | - public function get_last_error(){ |
|
142 | + public function get_last_error() { |
|
143 | 143 | $errors = $this->get_errors(); |
144 | - if($errors){ |
|
144 | + if ($errors) { |
|
145 | 145 | return end($errors); |
146 | - }else{ |
|
146 | + } else { |
|
147 | 147 | return null; |
148 | 148 | } |
149 | 149 | } |
@@ -152,26 +152,26 @@ discard block |
||
152 | 152 | * @param string $error a string describing the error that will be useful for debugging. Consider including all the data that led to the error, and a stack trace etc. |
153 | 153 | * @param boolean $force force the error to be added (because otherwise we have a limit). If forcing and errors are already at their limit, we will purposefully forget the first half |
154 | 154 | */ |
155 | - public function add_error($error, $force = FALSE ){ |
|
156 | - if( ! defined( 'EE_DMS_ERROR_LIMIT' ) ){ |
|
155 | + public function add_error($error, $force = FALSE) { |
|
156 | + if ( ! defined('EE_DMS_ERROR_LIMIT')) { |
|
157 | 157 | $limit = 50; |
158 | - }else{ |
|
158 | + } else { |
|
159 | 159 | $limit = EE_DMS_ERROR_LIMIT; |
160 | 160 | } |
161 | 161 | //make sure errors is an array, see ticket #8261 |
162 | - if( is_string( $this->_errors ) ){ |
|
163 | - $this->_errors = array( $this->_errors ); |
|
162 | + if (is_string($this->_errors)) { |
|
163 | + $this->_errors = array($this->_errors); |
|
164 | 164 | } |
165 | - if(count($this->_errors) >= $limit ){ |
|
166 | - if( $force ){ |
|
165 | + if (count($this->_errors) >= $limit) { |
|
166 | + if ($force) { |
|
167 | 167 | //get rid of the first half of the errors and any above the limit |
168 | - $this->_errors = array_slice( $this->_errors, $limit / 2, $limit / 2 ); |
|
168 | + $this->_errors = array_slice($this->_errors, $limit / 2, $limit / 2); |
|
169 | 169 | $this->_errors[] = "Limit reached; removed first half of errors to save space"; |
170 | 170 | $this->_errors[] = $error; |
171 | - }else{ |
|
172 | - $this->_errors[ $limit ] = 'More, but limit reached...'; |
|
171 | + } else { |
|
172 | + $this->_errors[$limit] = 'More, but limit reached...'; |
|
173 | 173 | } |
174 | - }else{ |
|
174 | + } else { |
|
175 | 175 | $this->_errors[] = $error; |
176 | 176 | } |
177 | 177 | } |
@@ -180,57 +180,57 @@ discard block |
||
180 | 180 | * Indicates there was a fatal error and the migration cannot possibly continue |
181 | 181 | * @return boolean |
182 | 182 | */ |
183 | - public function is_broken(){ |
|
183 | + public function is_broken() { |
|
184 | 184 | return $this->get_status() == EE_Data_Migration_Manager::status_fatal_error; |
185 | 185 | } |
186 | 186 | /** |
187 | 187 | * @deprecated since 4.6.12 |
188 | 188 | */ |
189 | - public function is_borked(){ |
|
190 | - EE_Error::doing_it_wrong('is_borked', __( 'The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso' ), '4.6.12'); |
|
189 | + public function is_borked() { |
|
190 | + EE_Error::doing_it_wrong('is_borked', __('The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso'), '4.6.12'); |
|
191 | 191 | return $this->is_broken(); |
192 | 192 | } |
193 | 193 | /** |
194 | 194 | * Sets the status to as having a fatal error |
195 | 195 | */ |
196 | - public function set_broken(){ |
|
196 | + public function set_broken() { |
|
197 | 197 | $this->_status = EE_Data_Migration_Manager::status_fatal_error; |
198 | 198 | } |
199 | 199 | /** |
200 | 200 | * |
201 | 201 | * @deprecated since 4.6.12 |
202 | 202 | */ |
203 | - public function set_borked(){ |
|
204 | - EE_Error::doing_it_wrong('is_borked', __( 'The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso' ), '4.6.12'); |
|
203 | + public function set_borked() { |
|
204 | + EE_Error::doing_it_wrong('is_borked', __('The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso'), '4.6.12'); |
|
205 | 205 | return $this->set_broken(); |
206 | 206 | } |
207 | 207 | /** |
208 | 208 | * Checks if this thing believes it is completed |
209 | 209 | * @return boolean |
210 | 210 | */ |
211 | - public function is_completed(){ |
|
211 | + public function is_completed() { |
|
212 | 212 | return $this->get_status() == EE_Data_Migration_Manager::status_completed; |
213 | 213 | } |
214 | 214 | /** |
215 | 215 | * Checks if the current script has more to do or not (ie, if it's status is CONTINUE) |
216 | 216 | * @return boolean |
217 | 217 | */ |
218 | - public function has_more_to_do(){ |
|
218 | + public function has_more_to_do() { |
|
219 | 219 | return $this->get_status() == EE_Data_Migration_Manager::status_continue; |
220 | 220 | } |
221 | 221 | /** |
222 | 222 | * Marks that we believe this migration thing is completed |
223 | 223 | */ |
224 | - public function set_completed(){ |
|
224 | + public function set_completed() { |
|
225 | 225 | $this->_status = EE_Data_Migration_Manager::status_completed; |
226 | 226 | } |
227 | 227 | |
228 | 228 | /** |
229 | 229 | * Marks that we think this migration class can continue to migrate |
230 | 230 | */ |
231 | - public function reattempt(){ |
|
231 | + public function reattempt() { |
|
232 | 232 | $this->_status = EE_Data_Migration_Manager::status_continue; |
233 | - $this->add_error( __( 'Reattempt migration', 'event_espresso' ), TRUE ); |
|
233 | + $this->add_error(__('Reattempt migration', 'event_espresso'), TRUE); |
|
234 | 234 | } |
235 | 235 | |
236 | 236 | /** |
@@ -239,8 +239,8 @@ discard block |
||
239 | 239 | * possible that this class is defined when it goes to sleep, but NOT available when it |
240 | 240 | * awakes (eg, this class is part of an addon that is deactivated at some point). |
241 | 241 | */ |
242 | - public function properties_as_array(){ |
|
243 | - $properties = get_object_vars($this); |
|
242 | + public function properties_as_array() { |
|
243 | + $properties = get_object_vars($this); |
|
244 | 244 | $properties['class'] = get_class($this); |
245 | 245 | unset($properties['_migration_script']); |
246 | 246 | return $properties; |
@@ -261,22 +261,22 @@ discard block |
||
261 | 261 | * @param array $data_types numerically indexed |
262 | 262 | * @return string |
263 | 263 | */ |
264 | - protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types){ |
|
264 | + protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types) { |
|
265 | 265 | global $wpdb; |
266 | 266 | $old_columns_and_values_for_string = array(); |
267 | - foreach($old_row_as_array as $column => $value){ |
|
267 | + foreach ($old_row_as_array as $column => $value) { |
|
268 | 268 | $old_columns_and_values_for_string[] = "$column => $value"; |
269 | 269 | } |
270 | 270 | $new_columns_and_values_for_string = array(); |
271 | 271 | $count = 0; |
272 | - foreach($new_row_as_array as $column => $value){ |
|
272 | + foreach ($new_row_as_array as $column => $value) { |
|
273 | 273 | $new_columns_and_values_for_string[] = " $column => $value (".$data_types[$count++].")"; |
274 | 274 | } |
275 | 275 | return sprintf( |
276 | 276 | __('Received error "%6$s" inserting row %5$s %1$s %5$s into table %2$s.%5$s Data used was %5$s %3$s %5$s from table %4%s.', "event_espresso"), |
277 | - implode(", ",$new_columns_and_values_for_string), |
|
277 | + implode(", ", $new_columns_and_values_for_string), |
|
278 | 278 | $new_table, |
279 | - implode(", ",$old_columns_and_values_for_string), |
|
279 | + implode(", ", $old_columns_and_values_for_string), |
|
280 | 280 | $old_table, |
281 | 281 | '<br/>', |
282 | 282 | $wpdb->last_error |
@@ -291,12 +291,12 @@ discard block |
||
291 | 291 | * @param array $array_of_data |
292 | 292 | * @return string |
293 | 293 | */ |
294 | - protected function _json_encode($array_of_data){ |
|
294 | + protected function _json_encode($array_of_data) { |
|
295 | 295 | //we'd rather NOT serialize the transaction details |
296 | 296 | $fields_to_include = array(); |
297 | - foreach($array_of_data as $name => $value){ |
|
297 | + foreach ($array_of_data as $name => $value) { |
|
298 | 298 | $unserialized_data = @unserialize($value); |
299 | - if($unserialized_data === FALSE){ |
|
299 | + if ($unserialized_data === FALSE) { |
|
300 | 300 | $fields_to_include[$name] = $value; |
301 | 301 | } |
302 | 302 | } |
@@ -309,13 +309,13 @@ discard block |
||
309 | 309 | * @throws EE_Error |
310 | 310 | */ |
311 | 311 | protected function _get_table_manager() { |
312 | - if( $this->_table_manager instanceof TableManager ) { |
|
312 | + if ($this->_table_manager instanceof TableManager) { |
|
313 | 313 | return $this->_table_manager; |
314 | 314 | } else { |
315 | 315 | throw new EE_Error( |
316 | 316 | sprintf( |
317 | - __( 'Table manager on migration class %1$s is not set properly.', 'event_espresso'), |
|
318 | - get_class( $this ) |
|
317 | + __('Table manager on migration class %1$s is not set properly.', 'event_espresso'), |
|
318 | + get_class($this) |
|
319 | 319 | ) |
320 | 320 | ); |
321 | 321 | } |
@@ -327,13 +327,13 @@ discard block |
||
327 | 327 | * @throws EE_Error |
328 | 328 | */ |
329 | 329 | protected function _get_table_analysis() { |
330 | - if( $this->_table_analysis instanceof TableAnalysis ) { |
|
330 | + if ($this->_table_analysis instanceof TableAnalysis) { |
|
331 | 331 | return $this->_table_analysis; |
332 | 332 | } else { |
333 | 333 | throw new EE_Error( |
334 | 334 | sprintf( |
335 | - __( 'Table analysis class on migration class %1$s is not set properly.', 'event_espresso'), |
|
336 | - get_class( $this ) |
|
335 | + __('Table analysis class on migration class %1$s is not set properly.', 'event_espresso'), |
|
336 | + get_class($this) |
|
337 | 337 | ) |
338 | 338 | ); |
339 | 339 | } |
@@ -287,7 +287,7 @@ discard block |
||
287 | 287 | * Sends HTTP headers to indicate that the browser should download a file, |
288 | 288 | * and starts writing the file to PHP's output. Returns the file handle so other functions can |
289 | 289 | * also write to it |
290 | - * @param string $new_filename the name of the file that the user will download |
|
290 | + * @param string|false $filename the name of the file that the user will download |
|
291 | 291 | * @return resource, like the results of fopen(), which can be used for fwrite, fputcsv2, etc. |
292 | 292 | */ |
293 | 293 | public function begin_sending_csv($filename){ |
@@ -343,9 +343,7 @@ discard block |
||
343 | 343 | /** |
344 | 344 | * Writes $data to the csv file open in $filehandle. uses the array indices of $data for column headers |
345 | 345 | * @param array $data 2D array, first numerically-indexed, and next-level-down preferably indexed by string |
346 | - * @param boolean $add_csv_column_names whether or not we should add the keys in the bottom-most array as a row for headers in the CSV. |
|
347 | - * Eg, if $data looked like array(0=>array('EVT_ID'=>1,'EVT_name'=>'monkey'...), 1=>array(...),...)) |
|
348 | - * then the first row we'd write to the CSV would be "EVT_ID,EVT_name,..." |
|
346 | + * @param resource $filehandle |
|
349 | 347 | * @return boolean if we successfully wrote to the CSV or not. If there's no $data, we consider that a success (because we wrote everything there was...nothing) |
350 | 348 | */ |
351 | 349 | public function write_data_array_to_csv($filehandle, $data){ |
@@ -427,7 +425,7 @@ discard block |
||
427 | 425 | * @param array $model_data_array is assumed to be a 3d array: 1st layer has keys of model names (eg 'Event'), |
428 | 426 | * next layer is numerically indexed to represent each model object (eg, each individual event), and the last layer |
429 | 427 | * has all the attributes o fthat model object (eg, the event's id, name, etc) |
430 | - * @return boolean success |
|
428 | + * @return boolean|null success |
|
431 | 429 | */ |
432 | 430 | public function write_model_data_to_csv($filehandle,$model_data_array){ |
433 | 431 | $this->write_metadata_to_csv($filehandle); |
@@ -456,8 +454,8 @@ discard block |
||
456 | 454 | * Writes the CSV file to the output buffer, with rows corresponding to $model_data_array, |
457 | 455 | * and dies (in order to avoid other plugins from messing up the csv output) |
458 | 456 | * @param string $filename the filename you want to give the file |
459 | - * @param array $model_data_array 3d array, as described in EE_CSV::write_model_data_to_csv() |
|
460 | - * @return bool | void writes CSV file to output and dies |
|
457 | + * @param boolean $model_data_array 3d array, as described in EE_CSV::write_model_data_to_csv() |
|
458 | + * @return boolean|null | void writes CSV file to output and dies |
|
461 | 459 | */ |
462 | 460 | public function export_multiple_model_data_to_csv($filename,$model_data_array){ |
463 | 461 | $filehandle = $this->begin_sending_csv($filename); |
@@ -469,7 +467,7 @@ discard block |
||
469 | 467 | * @access public |
470 | 468 | * @param array $data - the array of data to be converted to csv and exported |
471 | 469 | * @param string $filename - name for newly created csv file |
472 | - * @return TRUE on success, FALSE on fail |
|
470 | + * @return false|null on success, FALSE on fail |
|
473 | 471 | */ |
474 | 472 | public function export_array_to_csv( $data = FALSE, $filename = FALSE ) { |
475 | 473 |
@@ -1,4 +1,6 @@ discard block |
||
1 | -<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | +} |
|
2 | 4 | /** |
3 | 5 | * CSV Import Export class |
4 | 6 | * |
@@ -105,8 +107,9 @@ discard block |
||
105 | 107 | $fc = $fc . $c; |
106 | 108 | } |
107 | 109 | } |
108 | - if ((ord(substr($fc,0,1)) == 255) && (ord(substr($fc,1,1)) == 254)) |
|
109 | - $fc = substr($fc,2); |
|
110 | + if ((ord(substr($fc,0,1)) == 255) && (ord(substr($fc,1,1)) == 254)) { |
|
111 | + $fc = substr($fc,2); |
|
112 | + } |
|
110 | 113 | return ($fc); |
111 | 114 | } |
112 | 115 | |
@@ -144,7 +147,7 @@ discard block |
||
144 | 147 | while(($data = fgetcsv($file_handle, 0, ',', '"' )) !== FALSE){ |
145 | 148 | $csvarray[]= $data; |
146 | 149 | } |
147 | - }else{ |
|
150 | + } else{ |
|
148 | 151 | // loop through each row of the file |
149 | 152 | while (( $data = fgetcsv( $file_handle, 0, ',', '"', '\\' )) !== FALSE ) { |
150 | 153 | $csvarray[]=$data; |
@@ -153,7 +156,7 @@ discard block |
||
153 | 156 | # Close the File. |
154 | 157 | fclose($file_handle); |
155 | 158 | return $csvarray; |
156 | - }else{ |
|
159 | + } else{ |
|
157 | 160 | EE_Error::add_error( sprintf(__("An error occurred - the file: %s could not opened.", "event_espresso"),$path_to_file), __FILE__, __FUNCTION__, __LINE__ ); |
158 | 161 | return false; |
159 | 162 | } |
@@ -234,7 +237,7 @@ discard block |
||
234 | 237 | $matches = array(); |
235 | 238 | if($model_name == EE_CSV::metadata_header){ |
236 | 239 | $headers[$i] = $column_name; |
237 | - }else{ |
|
240 | + } else{ |
|
238 | 241 | //now get the db table name from it (the part between square brackets) |
239 | 242 | $success = preg_match('~(.*)\[(.*)\]~', $column_name,$matches); |
240 | 243 | if (!$success){ |
@@ -244,7 +247,7 @@ discard block |
||
244 | 247 | $headers[$i] = $matches[2]; |
245 | 248 | } |
246 | 249 | |
247 | - }else{ |
|
250 | + } else{ |
|
248 | 251 | // no column names means our final array will just use counters for keys |
249 | 252 | $model_entry[$headers[$i]] = $data[$i]; |
250 | 253 | $headers[$i] = $i; |
@@ -371,7 +374,7 @@ discard block |
||
371 | 374 | echo $this->fputcsv2($filehandle, $data_row); |
372 | 375 | } |
373 | 376 | return true; |
374 | - }else{ |
|
377 | + } else{ |
|
375 | 378 | //no data TO write... so we can assume that's a success |
376 | 379 | return true; |
377 | 380 | } |
@@ -438,7 +441,7 @@ discard block |
||
438 | 441 | |
439 | 442 | if( ! empty($model_instance_arrays) ){ |
440 | 443 | $this->write_data_array_to_csv($filehandle, $model_instance_arrays); |
441 | - }else{ |
|
444 | + } else{ |
|
442 | 445 | // echo "no data to write... so just write the headers"; |
443 | 446 | //so there's actually NO model objects for that model. |
444 | 447 | //probably still want to show the columns |
@@ -315,7 +315,7 @@ |
||
315 | 315 | // header("Content-Type: application/download"); |
316 | 316 | header('Content-disposition: attachment; filename='.$filename); |
317 | 317 | header("Content-Type: text/csv; charset=utf-8"); |
318 | - do_action( 'AHEE__EE_CSV__begin_sending_csv__headers' ); |
|
318 | + do_action( 'AHEE__EE_CSV__begin_sending_csv__headers' ); |
|
319 | 319 | echo apply_filters('FHEE__EE_CSV__begin_sending_csv__start_writing', "\xEF\xBB\xBF" ); // makes excel open it as UTF-8. UTF-8 BOM, see http://stackoverflow.com/a/4440143/2773835 |
320 | 320 | $fh = fopen('php://output', 'w'); |
321 | 321 | return $fh; |
@@ -1,4 +1,4 @@ discard block |
||
1 | -<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
2 | 2 | /** |
3 | 3 | * CSV Import Export class |
4 | 4 | * |
@@ -45,31 +45,31 @@ discard block |
||
45 | 45 | global $wpdb; |
46 | 46 | |
47 | 47 | $this->_primary_keys = array( |
48 | - $wpdb->prefix . 'esp_answer' => array( 'ANS_ID' ), |
|
49 | - $wpdb->prefix . 'esp_attendee' => array( 'ATT_ID' ), |
|
50 | - $wpdb->prefix . 'esp_datetime' => array( 'DTT_ID' ), |
|
51 | - $wpdb->prefix . 'esp_event_question_group' => array( 'EQG_ID' ), |
|
52 | - $wpdb->prefix . 'esp_message_template' => array( 'MTP_ID' ), |
|
53 | - $wpdb->prefix . 'esp_payment' => array( 'PAY_ID' ), |
|
54 | - $wpdb->prefix . 'esp_price' => array( 'PRC_ID' ), |
|
55 | - $wpdb->prefix . 'esp_price_type' => array( 'PRT_ID' ), |
|
56 | - $wpdb->prefix . 'esp_question' => array( 'QST_ID' ), |
|
57 | - $wpdb->prefix . 'esp_question_group' => array( 'QSG_ID' ), |
|
58 | - $wpdb->prefix . 'esp_question_group_question' => array( 'QGQ_ID' ), |
|
59 | - $wpdb->prefix . 'esp_question_option' => array( 'QSO_ID' ), |
|
60 | - $wpdb->prefix . 'esp_registration' => array( 'REG_ID' ), |
|
61 | - $wpdb->prefix . 'esp_status' => array( 'STS_ID' ), |
|
62 | - $wpdb->prefix . 'esp_transaction' => array( 'TXN_ID' ), |
|
63 | - $wpdb->prefix . 'esp_transaction' => array( 'TXN_ID' ), |
|
64 | - $wpdb->prefix . 'events_detail' => array( 'id' ), |
|
65 | - $wpdb->prefix . 'events_category_detail' => array( 'id' ), |
|
66 | - $wpdb->prefix . 'events_category_rel' => array( 'id' ), |
|
67 | - $wpdb->prefix . 'events_venue' => array( 'id' ), |
|
68 | - $wpdb->prefix . 'events_venue_rel' => array( 'emeta_id' ), |
|
69 | - $wpdb->prefix . 'events_locale' => array( 'id' ), |
|
70 | - $wpdb->prefix . 'events_locale_rel' => array( 'id' ), |
|
71 | - $wpdb->prefix . 'events_personnel' => array( 'id' ), |
|
72 | - $wpdb->prefix . 'events_personnel_rel' => array( 'id' ), |
|
48 | + $wpdb->prefix.'esp_answer' => array('ANS_ID'), |
|
49 | + $wpdb->prefix.'esp_attendee' => array('ATT_ID'), |
|
50 | + $wpdb->prefix.'esp_datetime' => array('DTT_ID'), |
|
51 | + $wpdb->prefix.'esp_event_question_group' => array('EQG_ID'), |
|
52 | + $wpdb->prefix.'esp_message_template' => array('MTP_ID'), |
|
53 | + $wpdb->prefix.'esp_payment' => array('PAY_ID'), |
|
54 | + $wpdb->prefix.'esp_price' => array('PRC_ID'), |
|
55 | + $wpdb->prefix.'esp_price_type' => array('PRT_ID'), |
|
56 | + $wpdb->prefix.'esp_question' => array('QST_ID'), |
|
57 | + $wpdb->prefix.'esp_question_group' => array('QSG_ID'), |
|
58 | + $wpdb->prefix.'esp_question_group_question' => array('QGQ_ID'), |
|
59 | + $wpdb->prefix.'esp_question_option' => array('QSO_ID'), |
|
60 | + $wpdb->prefix.'esp_registration' => array('REG_ID'), |
|
61 | + $wpdb->prefix.'esp_status' => array('STS_ID'), |
|
62 | + $wpdb->prefix.'esp_transaction' => array('TXN_ID'), |
|
63 | + $wpdb->prefix.'esp_transaction' => array('TXN_ID'), |
|
64 | + $wpdb->prefix.'events_detail' => array('id'), |
|
65 | + $wpdb->prefix.'events_category_detail' => array('id'), |
|
66 | + $wpdb->prefix.'events_category_rel' => array('id'), |
|
67 | + $wpdb->prefix.'events_venue' => array('id'), |
|
68 | + $wpdb->prefix.'events_venue_rel' => array('emeta_id'), |
|
69 | + $wpdb->prefix.'events_locale' => array('id'), |
|
70 | + $wpdb->prefix.'events_locale_rel' => array('id'), |
|
71 | + $wpdb->prefix.'events_personnel' => array('id'), |
|
72 | + $wpdb->prefix.'events_personnel_rel' => array('id'), |
|
73 | 73 | ); |
74 | 74 | |
75 | 75 | } |
@@ -81,9 +81,9 @@ discard block |
||
81 | 81 | * @ access public |
82 | 82 | * @return EE_CSV |
83 | 83 | */ |
84 | - public static function instance ( ) { |
|
84 | + public static function instance( ) { |
|
85 | 85 | // check if class object is instantiated |
86 | - if ( self::$_instance === NULL or ! is_object( self::$_instance ) or ! ( self::$_instance instanceof EE_CSV )) { |
|
86 | + if (self::$_instance === NULL or ! is_object(self::$_instance) or ! (self::$_instance instanceof EE_CSV)) { |
|
87 | 87 | self::$_instance = new self(); |
88 | 88 | } |
89 | 89 | return self::$_instance; |
@@ -95,22 +95,22 @@ discard block |
||
95 | 95 | * @return string |
96 | 96 | * @throws EE_Error |
97 | 97 | */ |
98 | - private function read_unicode_file($file_path){ |
|
98 | + private function read_unicode_file($file_path) { |
|
99 | 99 | $fc = ""; |
100 | - $fh = fopen($file_path,"rb"); |
|
101 | - if( ! $fh ){ |
|
102 | - throw new EE_Error( sprintf( __("Cannot open file for read: %s<br>\n", 'event_espresso'), $file_path ) ); |
|
100 | + $fh = fopen($file_path, "rb"); |
|
101 | + if ( ! $fh) { |
|
102 | + throw new EE_Error(sprintf(__("Cannot open file for read: %s<br>\n", 'event_espresso'), $file_path)); |
|
103 | 103 | } |
104 | 104 | $flen = filesize($file_path); |
105 | 105 | $bc = fread($fh, $flen); |
106 | - for ($i=0; $i<$flen; $i++){ |
|
107 | - $c = substr($bc,$i,1); |
|
108 | - if ((ord($c) != 0) && (ord($c) != 13)){ |
|
109 | - $fc = $fc . $c; |
|
106 | + for ($i = 0; $i < $flen; $i++) { |
|
107 | + $c = substr($bc, $i, 1); |
|
108 | + if ((ord($c) != 0) && (ord($c) != 13)) { |
|
109 | + $fc = $fc.$c; |
|
110 | 110 | } |
111 | 111 | } |
112 | - if ((ord(substr($fc,0,1)) == 255) && (ord(substr($fc,1,1)) == 254)) |
|
113 | - $fc = substr($fc,2); |
|
112 | + if ((ord(substr($fc, 0, 1)) == 255) && (ord(substr($fc, 1, 1)) == 254)) |
|
113 | + $fc = substr($fc, 2); |
|
114 | 114 | return ($fc); |
115 | 115 | } |
116 | 116 | |
@@ -122,15 +122,15 @@ discard block |
||
122 | 122 | * @param string $path_to_file |
123 | 123 | * @return array of arrays. Top-level array has rows, second-level array has each item |
124 | 124 | */ |
125 | - public function import_csv_to_multi_dimensional_array($path_to_file){ |
|
125 | + public function import_csv_to_multi_dimensional_array($path_to_file) { |
|
126 | 126 | // needed to deal with Mac line endings |
127 | - ini_set('auto_detect_line_endings',TRUE); |
|
127 | + ini_set('auto_detect_line_endings', TRUE); |
|
128 | 128 | |
129 | 129 | // because fgetcsv does not correctly deal with backslashed quotes such as \" |
130 | 130 | // we'll read the file into a string |
131 | - $file_contents = $this->read_unicode_file( $path_to_file ); |
|
131 | + $file_contents = $this->read_unicode_file($path_to_file); |
|
132 | 132 | // replace backslashed quotes with CSV enclosures |
133 | - $file_contents = str_replace ( '\\"', '"""', $file_contents ); |
|
133 | + $file_contents = str_replace('\\"', '"""', $file_contents); |
|
134 | 134 | // HEY YOU! PUT THAT FILE BACK!!! |
135 | 135 | file_put_contents($path_to_file, $file_contents); |
136 | 136 | |
@@ -140,25 +140,25 @@ discard block |
||
140 | 140 | $csvarray = array(); |
141 | 141 | |
142 | 142 | // in PHP 5.3 fgetcsv accepts a 5th parameter, but the pre 5.3 versions of fgetcsv choke if passed more than 4 - is that crazy or what? |
143 | - if ( version_compare( PHP_VERSION, '5.3.0' ) < 0 ) { |
|
143 | + if (version_compare(PHP_VERSION, '5.3.0') < 0) { |
|
144 | 144 | |
145 | 145 | // PHP 5.2- version |
146 | 146 | |
147 | 147 | // loop through each row of the file |
148 | - while(($data = fgetcsv($file_handle, 0, ',', '"' )) !== FALSE){ |
|
149 | - $csvarray[]= $data; |
|
148 | + while (($data = fgetcsv($file_handle, 0, ',', '"')) !== FALSE) { |
|
149 | + $csvarray[] = $data; |
|
150 | 150 | } |
151 | - }else{ |
|
151 | + } else { |
|
152 | 152 | // loop through each row of the file |
153 | - while (( $data = fgetcsv( $file_handle, 0, ',', '"', '\\' )) !== FALSE ) { |
|
154 | - $csvarray[]=$data; |
|
153 | + while (($data = fgetcsv($file_handle, 0, ',', '"', '\\')) !== FALSE) { |
|
154 | + $csvarray[] = $data; |
|
155 | 155 | } |
156 | 156 | } |
157 | 157 | # Close the File. |
158 | 158 | fclose($file_handle); |
159 | 159 | return $csvarray; |
160 | - }else{ |
|
161 | - EE_Error::add_error( sprintf(__("An error occurred - the file: %s could not opened.", "event_espresso"),$path_to_file), __FILE__, __FUNCTION__, __LINE__ ); |
|
160 | + } else { |
|
161 | + EE_Error::add_error(sprintf(__("An error occurred - the file: %s could not opened.", "event_espresso"), $path_to_file), __FILE__, __FUNCTION__, __LINE__); |
|
162 | 162 | return false; |
163 | 163 | } |
164 | 164 | } |
@@ -188,9 +188,9 @@ discard block |
||
188 | 188 | * ... |
189 | 189 | * ) |
190 | 190 | */ |
191 | - public function import_csv_to_model_data_array( $path_to_file, $model_name = FALSE, $first_row_is_headers = TRUE ) { |
|
191 | + public function import_csv_to_model_data_array($path_to_file, $model_name = FALSE, $first_row_is_headers = TRUE) { |
|
192 | 192 | $multi_dimensional_array = $this->import_csv_to_multi_dimensional_array($path_to_file); |
193 | - if( ! $multi_dimensional_array ){ |
|
193 | + if ( ! $multi_dimensional_array) { |
|
194 | 194 | return false; |
195 | 195 | } |
196 | 196 | // gotta start somewhere |
@@ -199,9 +199,9 @@ discard block |
||
199 | 199 | $ee_formatted_data = array(); |
200 | 200 | // array to store headers (column names) |
201 | 201 | $headers = array(); |
202 | - foreach($multi_dimensional_array as $data){ |
|
202 | + foreach ($multi_dimensional_array as $data) { |
|
203 | 203 | // if first cell is MODEL, then second cell is the MODEL name |
204 | - if ( $data[0] == 'MODEL' ) { |
|
204 | + if ($data[0] == 'MODEL') { |
|
205 | 205 | $model_name = $data[1]; |
206 | 206 | //don't bother looking for model data in this row. The rest of this |
207 | 207 | //row should be blank |
@@ -211,7 +211,7 @@ discard block |
||
211 | 211 | $headers = array(); |
212 | 212 | continue; |
213 | 213 | } |
214 | - if( strpos( $data[0], EE_CSV::metadata_header ) !==FALSE ){ |
|
214 | + if (strpos($data[0], EE_CSV::metadata_header) !== FALSE) { |
|
215 | 215 | $model_name = EE_CSV::metadata_header; |
216 | 216 | //store like model data, we just won't try importing it etc. |
217 | 217 | $row = 1; |
@@ -224,31 +224,31 @@ discard block |
||
224 | 224 | |
225 | 225 | $model_entry = array(); |
226 | 226 | // loop through each column |
227 | - for ( $i=0; $i < $columns; $i++ ) { |
|
227 | + for ($i = 0; $i < $columns; $i++) { |
|
228 | 228 | |
229 | 229 | //replace csv_enclosures with backslashed quotes |
230 | - $data[$i] = str_replace ( '"""', '\\"', $data[$i] ); |
|
230 | + $data[$i] = str_replace('"""', '\\"', $data[$i]); |
|
231 | 231 | // do we need to grab the column names? |
232 | - if ( $row === 1){ |
|
233 | - if( $first_row_is_headers ) { |
|
232 | + if ($row === 1) { |
|
233 | + if ($first_row_is_headers) { |
|
234 | 234 | // store the column names to use for keys |
235 | 235 | $column_name = $data[$i]; |
236 | 236 | //check it's not blank... sometimes CSV editign programs adda bunch of empty columns onto the end... |
237 | - if(!$column_name){continue;} |
|
237 | + if ( ! $column_name) {continue; } |
|
238 | 238 | $matches = array(); |
239 | - if($model_name == EE_CSV::metadata_header){ |
|
239 | + if ($model_name == EE_CSV::metadata_header) { |
|
240 | 240 | $headers[$i] = $column_name; |
241 | - }else{ |
|
241 | + } else { |
|
242 | 242 | //now get the db table name from it (the part between square brackets) |
243 | - $success = preg_match('~(.*)\[(.*)\]~', $column_name,$matches); |
|
244 | - if (!$success){ |
|
245 | - EE_Error::add_error( sprintf(__("The column titled %s is invalid for importing. It must be be in the format of 'Nice Name[model_field_name]' in row %s", "event_espresso"),$column_name,implode(",",$data)), __FILE__, __FUNCTION__, __LINE__ ); |
|
243 | + $success = preg_match('~(.*)\[(.*)\]~', $column_name, $matches); |
|
244 | + if ( ! $success) { |
|
245 | + EE_Error::add_error(sprintf(__("The column titled %s is invalid for importing. It must be be in the format of 'Nice Name[model_field_name]' in row %s", "event_espresso"), $column_name, implode(",", $data)), __FILE__, __FUNCTION__, __LINE__); |
|
246 | 246 | return false; |
247 | 247 | } |
248 | 248 | $headers[$i] = $matches[2]; |
249 | 249 | } |
250 | 250 | |
251 | - }else{ |
|
251 | + } else { |
|
252 | 252 | // no column names means our final array will just use counters for keys |
253 | 253 | $model_entry[$headers[$i]] = $data[$i]; |
254 | 254 | $headers[$i] = $i; |
@@ -256,14 +256,14 @@ discard block |
||
256 | 256 | // and we need to store csv data |
257 | 257 | } else { |
258 | 258 | // this column isn' ta header, store it if there is a header for it |
259 | - if(isset($headers[$i])){ |
|
259 | + if (isset($headers[$i])) { |
|
260 | 260 | $model_entry[$headers[$i]] = $data[$i]; |
261 | 261 | } |
262 | 262 | } |
263 | 263 | |
264 | 264 | } |
265 | 265 | //save the row's data IF it's a non-header-row |
266 | - if( ! $first_row_is_headers || ($first_row_is_headers && $row > 1)){ |
|
266 | + if ( ! $first_row_is_headers || ($first_row_is_headers && $row > 1)) { |
|
267 | 267 | $ee_formatted_data[$model_name][] = $model_entry; |
268 | 268 | } |
269 | 269 | // advance to next row |
@@ -282,9 +282,9 @@ discard block |
||
282 | 282 | } |
283 | 283 | |
284 | 284 | |
285 | - public function save_csv_to_db( $csv_data_array, $model_name = FALSE ) { |
|
286 | - EE_Error::doing_it_wrong('save_csv_to_db', __( 'Function moved to EE_Import and renamed to save_csv_data_array_to_db', 'event_espresso' ), '4.6.7' ); |
|
287 | - return EE_Import::instance()->save_csv_data_array_to_db( $csv_data_array, $model_name ); |
|
285 | + public function save_csv_to_db($csv_data_array, $model_name = FALSE) { |
|
286 | + EE_Error::doing_it_wrong('save_csv_to_db', __('Function moved to EE_Import and renamed to save_csv_data_array_to_db', 'event_espresso'), '4.6.7'); |
|
287 | + return EE_Import::instance()->save_csv_data_array_to_db($csv_data_array, $model_name); |
|
288 | 288 | } |
289 | 289 | |
290 | 290 | /** |
@@ -294,11 +294,11 @@ discard block |
||
294 | 294 | * @param string $new_filename the name of the file that the user will download |
295 | 295 | * @return resource, like the results of fopen(), which can be used for fwrite, fputcsv2, etc. |
296 | 296 | */ |
297 | - public function begin_sending_csv($filename){ |
|
297 | + public function begin_sending_csv($filename) { |
|
298 | 298 | // grab file extension |
299 | 299 | $ext = substr(strrchr($filename, '.'), 1); |
300 | - if ( $ext == '.csv' or $ext == '.xls' ) { |
|
301 | - str_replace( $ext, '', $filename ); |
|
300 | + if ($ext == '.csv' or $ext == '.xls') { |
|
301 | + str_replace($ext, '', $filename); |
|
302 | 302 | } |
303 | 303 | $filename .= '.csv'; |
304 | 304 | |
@@ -319,8 +319,8 @@ discard block |
||
319 | 319 | // header("Content-Type: application/download"); |
320 | 320 | header('Content-disposition: attachment; filename='.$filename); |
321 | 321 | header("Content-Type: text/csv; charset=utf-8"); |
322 | - do_action( 'AHEE__EE_CSV__begin_sending_csv__headers' ); |
|
323 | - echo apply_filters('FHEE__EE_CSV__begin_sending_csv__start_writing', "\xEF\xBB\xBF" ); // makes excel open it as UTF-8. UTF-8 BOM, see http://stackoverflow.com/a/4440143/2773835 |
|
322 | + do_action('AHEE__EE_CSV__begin_sending_csv__headers'); |
|
323 | + echo apply_filters('FHEE__EE_CSV__begin_sending_csv__start_writing', "\xEF\xBB\xBF"); // makes excel open it as UTF-8. UTF-8 BOM, see http://stackoverflow.com/a/4440143/2773835 |
|
324 | 324 | $fh = fopen('php://output', 'w'); |
325 | 325 | return $fh; |
326 | 326 | } |
@@ -330,10 +330,10 @@ discard block |
||
330 | 330 | * mentioning the version and timezone |
331 | 331 | * @param resource $filehandle |
332 | 332 | */ |
333 | - public function write_metadata_to_csv($filehandle){ |
|
334 | - $data_row = array(EE_CSV::metadata_header);//do NOT translate because this exact string is used when importing |
|
333 | + public function write_metadata_to_csv($filehandle) { |
|
334 | + $data_row = array(EE_CSV::metadata_header); //do NOT translate because this exact string is used when importing |
|
335 | 335 | $this->fputcsv2($filehandle, $data_row); |
336 | - $meta_data = array( 0=> array( |
|
336 | + $meta_data = array(0=> array( |
|
337 | 337 | 'version'=>espresso_version(), |
338 | 338 | 'timezone'=> EEH_DTT_Helper::get_timezone(), |
339 | 339 | 'time_of_export'=>current_time('mysql'), |
@@ -351,29 +351,29 @@ discard block |
||
351 | 351 | * then the first row we'd write to the CSV would be "EVT_ID,EVT_name,..." |
352 | 352 | * @return boolean if we successfully wrote to the CSV or not. If there's no $data, we consider that a success (because we wrote everything there was...nothing) |
353 | 353 | */ |
354 | - public function write_data_array_to_csv($filehandle, $data){ |
|
354 | + public function write_data_array_to_csv($filehandle, $data) { |
|
355 | 355 | |
356 | 356 | |
357 | 357 | //determine if $data is actually a 2d array |
358 | - if ( $data && is_array($data) && is_array(EEH_Array::get_one_item_from_array($data))){ |
|
358 | + if ($data && is_array($data) && is_array(EEH_Array::get_one_item_from_array($data))) { |
|
359 | 359 | //make sure top level is numerically indexed, |
360 | 360 | |
361 | - if( EEH_Array::is_associative_array($data)){ |
|
362 | - throw new EE_Error(sprintf(__("top-level array must be numerically indexed. Does these look like numbers to you? %s","event_espresso"),implode(",",array_keys($data)))); |
|
361 | + if (EEH_Array::is_associative_array($data)) { |
|
362 | + throw new EE_Error(sprintf(__("top-level array must be numerically indexed. Does these look like numbers to you? %s", "event_espresso"), implode(",", array_keys($data)))); |
|
363 | 363 | } |
364 | 364 | $item_in_top_level_array = EEH_Array::get_one_item_from_array($data); |
365 | 365 | //now, is the last item in the top-level array of $data an associative or numeric array? |
366 | - if(EEH_Array::is_associative_array($item_in_top_level_array)){ |
|
366 | + if (EEH_Array::is_associative_array($item_in_top_level_array)) { |
|
367 | 367 | //its associative, so we want to output its keys as column headers |
368 | 368 | $keys = array_keys($item_in_top_level_array); |
369 | 369 | echo $this->fputcsv2($filehandle, $keys); |
370 | 370 | } |
371 | 371 | //start writing data |
372 | - foreach($data as $data_row){ |
|
372 | + foreach ($data as $data_row) { |
|
373 | 373 | echo $this->fputcsv2($filehandle, $data_row); |
374 | 374 | } |
375 | 375 | return true; |
376 | - }else{ |
|
376 | + } else { |
|
377 | 377 | //no data TO write... so we can assume that's a success |
378 | 378 | return true; |
379 | 379 | } |
@@ -418,7 +418,7 @@ discard block |
||
418 | 418 | * Calls exit to prevent polluting the CSV file with other junk |
419 | 419 | * @param resource $fh filehandle where we're writing the CSV to |
420 | 420 | */ |
421 | - public function end_sending_csv($fh){ |
|
421 | + public function end_sending_csv($fh) { |
|
422 | 422 | fclose($fh); |
423 | 423 | exit(0); |
424 | 424 | } |
@@ -431,23 +431,23 @@ discard block |
||
431 | 431 | * has all the attributes o fthat model object (eg, the event's id, name, etc) |
432 | 432 | * @return boolean success |
433 | 433 | */ |
434 | - public function write_model_data_to_csv($filehandle,$model_data_array){ |
|
434 | + public function write_model_data_to_csv($filehandle, $model_data_array) { |
|
435 | 435 | $this->write_metadata_to_csv($filehandle); |
436 | - foreach($model_data_array as $model_name => $model_instance_arrays){ |
|
436 | + foreach ($model_data_array as $model_name => $model_instance_arrays) { |
|
437 | 437 | //first: output a special row stating the model |
438 | - echo $this->fputcsv2($filehandle,array('MODEL',$model_name)); |
|
438 | + echo $this->fputcsv2($filehandle, array('MODEL', $model_name)); |
|
439 | 439 | //if we have items to put in the CSV, do it normally |
440 | 440 | |
441 | - if( ! empty($model_instance_arrays) ){ |
|
441 | + if ( ! empty($model_instance_arrays)) { |
|
442 | 442 | $this->write_data_array_to_csv($filehandle, $model_instance_arrays); |
443 | - }else{ |
|
443 | + } else { |
|
444 | 444 | // echo "no data to write... so just write the headers"; |
445 | 445 | //so there's actually NO model objects for that model. |
446 | 446 | //probably still want to show the columns |
447 | 447 | $model = EE_Registry::instance()->load_model($model_name); |
448 | 448 | $column_names = array(); |
449 | - foreach($model->field_settings() as $field){ |
|
450 | - $column_names[$field->get_nicename()."[".$field->get_name()."]"] = null ; |
|
449 | + foreach ($model->field_settings() as $field) { |
|
450 | + $column_names[$field->get_nicename()."[".$field->get_name()."]"] = null; |
|
451 | 451 | } |
452 | 452 | $this->write_data_array_to_csv($filehandle, array($column_names)); |
453 | 453 | } |
@@ -461,7 +461,7 @@ discard block |
||
461 | 461 | * @param array $model_data_array 3d array, as described in EE_CSV::write_model_data_to_csv() |
462 | 462 | * @return bool | void writes CSV file to output and dies |
463 | 463 | */ |
464 | - public function export_multiple_model_data_to_csv($filename,$model_data_array){ |
|
464 | + public function export_multiple_model_data_to_csv($filename, $model_data_array) { |
|
465 | 465 | $filehandle = $this->begin_sending_csv($filename); |
466 | 466 | $this->write_model_data_to_csv($filehandle, $model_data_array); |
467 | 467 | $this->end_sending_csv($filehandle); |
@@ -473,15 +473,15 @@ discard block |
||
473 | 473 | * @param string $filename - name for newly created csv file |
474 | 474 | * @return TRUE on success, FALSE on fail |
475 | 475 | */ |
476 | - public function export_array_to_csv( $data = FALSE, $filename = FALSE ) { |
|
476 | + public function export_array_to_csv($data = FALSE, $filename = FALSE) { |
|
477 | 477 | |
478 | 478 | // no data file?? get outta here |
479 | - if ( ! $data or ! is_array( $data ) or empty( $data ) ) { |
|
479 | + if ( ! $data or ! is_array($data) or empty($data)) { |
|
480 | 480 | return FALSE; |
481 | 481 | } |
482 | 482 | |
483 | 483 | // no filename?? get outta here |
484 | - if ( ! $filename ) { |
|
484 | + if ( ! $filename) { |
|
485 | 485 | return FALSE; |
486 | 486 | } |
487 | 487 | |
@@ -507,11 +507,11 @@ discard block |
||
507 | 507 | * @param int $percent_of_max - desired percentage of the max upload_mb |
508 | 508 | * @return int KB |
509 | 509 | */ |
510 | - public function get_max_upload_size ( $percent_of_max = FALSE ) { |
|
510 | + public function get_max_upload_size($percent_of_max = FALSE) { |
|
511 | 511 | |
512 | - $max_upload = (int)(ini_get('upload_max_filesize')); |
|
513 | - $max_post = (int)(ini_get('post_max_size')); |
|
514 | - $memory_limit = (int)(ini_get('memory_limit')); |
|
512 | + $max_upload = (int) (ini_get('upload_max_filesize')); |
|
513 | + $max_post = (int) (ini_get('post_max_size')); |
|
514 | + $memory_limit = (int) (ini_get('memory_limit')); |
|
515 | 515 | |
516 | 516 | // determine the smallest of the three values from above |
517 | 517 | $upload_mb = min($max_upload, $max_post, $memory_limit); |
@@ -520,9 +520,9 @@ discard block |
||
520 | 520 | $upload_mb = $upload_mb * 1024; |
521 | 521 | |
522 | 522 | // don't want the full monty? then reduce the max uplaod size |
523 | - if ( $percent_of_max ) { |
|
523 | + if ($percent_of_max) { |
|
524 | 524 | // is percent_of_max like this -> 50 or like this -> 0.50 ? |
525 | - if ( $percent_of_max > 1 ) { |
|
525 | + if ($percent_of_max > 1) { |
|
526 | 526 | // chnages 50 to 0.50 |
527 | 527 | $percent_of_max = $percent_of_max / 100; |
528 | 528 | } |
@@ -544,17 +544,17 @@ discard block |
||
544 | 544 | * @param string $mysql_null - allows php NULL to be overridden with MySQl's insertable NULL value |
545 | 545 | * @return void |
546 | 546 | */ |
547 | - private function fputcsv2 ($fh, array $row, $delimiter = ',', $enclosure = '"', $mysql_null = FALSE) { |
|
547 | + private function fputcsv2($fh, array $row, $delimiter = ',', $enclosure = '"', $mysql_null = FALSE) { |
|
548 | 548 | //Allow user to filter the csv delimiter and enclosure for other countries csv standards |
549 | - $delimiter = apply_filters( 'FHEE__EE_CSV__fputcsv2__delimiter', $delimiter ); |
|
550 | - $enclosure = apply_filters( 'FHEE__EE_CSV__fputcsv2__enclosure', $enclosure ); |
|
549 | + $delimiter = apply_filters('FHEE__EE_CSV__fputcsv2__delimiter', $delimiter); |
|
550 | + $enclosure = apply_filters('FHEE__EE_CSV__fputcsv2__enclosure', $enclosure); |
|
551 | 551 | |
552 | 552 | $delimiter_esc = preg_quote($delimiter, '/'); |
553 | 553 | $enclosure_esc = preg_quote($enclosure, '/'); |
554 | 554 | |
555 | 555 | $output = array(); |
556 | 556 | foreach ($row as $field_value) { |
557 | - if(is_object($field_value) || is_array($field_value)){ |
|
557 | + if (is_object($field_value) || is_array($field_value)) { |
|
558 | 558 | $field_value = serialize($field_value); |
559 | 559 | } |
560 | 560 | if ($field_value === null && $mysql_null) { |
@@ -563,10 +563,10 @@ discard block |
||
563 | 563 | } |
564 | 564 | |
565 | 565 | $output[] = preg_match("/(?:${delimiter_esc}|${enclosure_esc}|\s)/", $field_value) ? |
566 | - ( $enclosure . str_replace($enclosure, $enclosure . $enclosure, $field_value) . $enclosure ) : $field_value; |
|
566 | + ($enclosure.str_replace($enclosure, $enclosure.$enclosure, $field_value).$enclosure) : $field_value; |
|
567 | 567 | } |
568 | 568 | |
569 | - fwrite($fh, join($delimiter, $output) . PHP_EOL); |
|
569 | + fwrite($fh, join($delimiter, $output).PHP_EOL); |
|
570 | 570 | } |
571 | 571 | |
572 | 572 | |
@@ -604,8 +604,8 @@ discard block |
||
604 | 604 | * @param string $current_format |
605 | 605 | * @return string |
606 | 606 | */ |
607 | - public function get_date_format_for_csv( $current_format = null ) { |
|
608 | - return apply_filters( 'FHEE__EE_CSV__get_date_format_for_csv__format', 'Y-m-d', $current_format ); |
|
607 | + public function get_date_format_for_csv($current_format = null) { |
|
608 | + return apply_filters('FHEE__EE_CSV__get_date_format_for_csv__format', 'Y-m-d', $current_format); |
|
609 | 609 | } |
610 | 610 | |
611 | 611 | /** |
@@ -613,8 +613,8 @@ discard block |
||
613 | 613 | * @param string $current_format |
614 | 614 | * @return string |
615 | 615 | */ |
616 | - public function get_time_format_for_csv( $current_format = null ) { |
|
617 | - return apply_filters( 'FHEE__EE_CSV__get_time_format_for_csv__format', 'H:i:s', $current_format ); |
|
616 | + public function get_time_format_for_csv($current_format = null) { |
|
617 | + return apply_filters('FHEE__EE_CSV__get_time_format_for_csv__format', 'H:i:s', $current_format); |
|
618 | 618 | } |
619 | 619 | |
620 | 620 |
@@ -59,7 +59,7 @@ |
||
59 | 59 | * @param array $props_n_values incoming values from the database |
60 | 60 | * @param string $timezone incoming timezone as set by the model. If not set the timezone for |
61 | 61 | * the website will be used. |
62 | - * @return EE_Attendee |
|
62 | + * @return EE_Currency_Payment_Method |
|
63 | 63 | */ |
64 | 64 | public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
65 | 65 | return new self( $props_n_values, TRUE, $timezone ); |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if (!defined('EVENT_ESPRESSO_VERSION')) |
|
3 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) |
|
4 | 4 | exit('No direct script access allowed'); |
5 | 5 | |
6 | 6 | /** |
@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | * |
27 | 27 | * ------------------------------------------------------------------------ |
28 | 28 | */ |
29 | -class EE_Currency_Payment_Method extends EE_Base_Class{ |
|
29 | +class EE_Currency_Payment_Method extends EE_Base_Class { |
|
30 | 30 | |
31 | 31 | /** Currency to Payment Method Link ID @var CPM_ID*/ |
32 | 32 | protected $_CPM_ID = NULL; |
@@ -48,9 +48,9 @@ discard block |
||
48 | 48 | * date_format and the second value is the time format |
49 | 49 | * @return EE_Attendee |
50 | 50 | */ |
51 | - public static function new_instance( $props_n_values = array(), $timezone = null, $date_formats = array() ) { |
|
52 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__, $timezone, $date_formats ); |
|
53 | - return $has_object ? $has_object : new self( $props_n_values, false, $timezone, $date_formats ); |
|
51 | + public static function new_instance($props_n_values = array(), $timezone = null, $date_formats = array()) { |
|
52 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__, $timezone, $date_formats); |
|
53 | + return $has_object ? $has_object : new self($props_n_values, false, $timezone, $date_formats); |
|
54 | 54 | } |
55 | 55 | |
56 | 56 | |
@@ -61,8 +61,8 @@ discard block |
||
61 | 61 | * the website will be used. |
62 | 62 | * @return EE_Attendee |
63 | 63 | */ |
64 | - public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
|
65 | - return new self( $props_n_values, TRUE, $timezone ); |
|
64 | + public static function new_instance_from_db($props_n_values = array(), $timezone = null) { |
|
65 | + return new self($props_n_values, TRUE, $timezone); |
|
66 | 66 | } |
67 | 67 | |
68 | 68 | } |
@@ -1,7 +1,8 @@ |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if (!defined('EVENT_ESPRESSO_VERSION')) |
|
3 | +if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
4 | 4 | exit('No direct script access allowed'); |
5 | +} |
|
5 | 6 | |
6 | 7 | /** |
7 | 8 | * Event Espresso |
@@ -46,7 +46,7 @@ |
||
46 | 46 | * @param array $props_n_values incoming values from the database |
47 | 47 | * @param string $timezone incoming timezone as set by the model. If not set the timezone for |
48 | 48 | * the website will be used. |
49 | - * @return EE_Attendee |
|
49 | + * @return EE_Datetime_Ticket |
|
50 | 50 | */ |
51 | 51 | public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
52 | 52 | return new self( $props_n_values, TRUE, $timezone ); |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
2 | - exit( 'No direct script access allowed' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | 3 | } |
4 | 4 | /** |
5 | 5 | * Event Espresso |
@@ -35,9 +35,9 @@ discard block |
||
35 | 35 | * date_format and the second value is the time format |
36 | 36 | * @return EE_Attendee |
37 | 37 | */ |
38 | - public static function new_instance( $props_n_values = array(), $timezone = null, $date_formats = array() ) { |
|
39 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__, $timezone, $date_formats ); |
|
40 | - return $has_object ? $has_object : new self( $props_n_values, false, $timezone, $date_formats ); |
|
38 | + public static function new_instance($props_n_values = array(), $timezone = null, $date_formats = array()) { |
|
39 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__, $timezone, $date_formats); |
|
40 | + return $has_object ? $has_object : new self($props_n_values, false, $timezone, $date_formats); |
|
41 | 41 | } |
42 | 42 | |
43 | 43 | |
@@ -48,7 +48,7 @@ discard block |
||
48 | 48 | * the website will be used. |
49 | 49 | * @return EE_Attendee |
50 | 50 | */ |
51 | - public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) { |
|
52 | - return new self( $props_n_values, TRUE, $timezone ); |
|
51 | + public static function new_instance_from_db($props_n_values = array(), $timezone = null) { |
|
52 | + return new self($props_n_values, TRUE, $timezone); |
|
53 | 53 | } |
54 | 54 | } //end EE_Datetime_Ticket class |
@@ -69,7 +69,7 @@ discard block |
||
69 | 69 | /** |
70 | 70 | * @Export Event Espresso data - routes export requests |
71 | 71 | * @access public |
72 | - * @return void | bool |
|
72 | + * @return false|null | bool |
|
73 | 73 | */ |
74 | 74 | public function export() { |
75 | 75 | |
@@ -605,7 +605,7 @@ discard block |
||
605 | 605 | * @recursive function for exporting table data and merging the results with the next results |
606 | 606 | * @access private |
607 | 607 | * @param array $models_to_export keys are model names (eg 'Event', 'Attendee', etc.) and values are arrays of query params like on EEM_Base::get_all |
608 | - * @return array on success, FALSE on fail |
|
608 | + * @return boolean on success, FALSE on fail |
|
609 | 609 | */ |
610 | 610 | private function _get_export_data_for_models( $models_to_export = array() ) { |
611 | 611 | $table_data = FALSE; |
@@ -500,11 +500,11 @@ |
||
500 | 500 | }else{ |
501 | 501 | $question_label = sprintf( __( 'Question $s', 'event_espresso' ), $answer_row[ 'Answer.QST_ID' ] ); |
502 | 502 | } |
503 | - if( isset( $answer_row[ 'Question.QST_type'] ) && $answer_row[ 'Question.QST_type' ] == EEM_Question::QST_type_state ) { |
|
504 | - $reg_csv_array[ $question_label ] = EEM_State::instance()->get_state_name_by_ID( $answer_row[ 'Answer.ANS_value' ] ); |
|
505 | - } else { |
|
506 | - $reg_csv_array[ $question_label ] = $this->_prepare_value_from_db_for_display( EEM_Answer::instance(), 'ANS_value', $answer_row[ 'Answer.ANS_value' ] ); |
|
507 | - } |
|
503 | + if( isset( $answer_row[ 'Question.QST_type'] ) && $answer_row[ 'Question.QST_type' ] == EEM_Question::QST_type_state ) { |
|
504 | + $reg_csv_array[ $question_label ] = EEM_State::instance()->get_state_name_by_ID( $answer_row[ 'Answer.ANS_value' ] ); |
|
505 | + } else { |
|
506 | + $reg_csv_array[ $question_label ] = $this->_prepare_value_from_db_for_display( EEM_Answer::instance(), 'ANS_value', $answer_row[ 'Answer.ANS_value' ] ); |
|
507 | + } |
|
508 | 508 | } |
509 | 509 | $registrations_csv_ready_array[] = apply_filters( 'FHEE__EE_Export__report_registrations__reg_csv_array', $reg_csv_array, $reg_row ); |
510 | 510 | } |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
2 | -do_action( 'AHEE_log', __FILE__, __FUNCTION__, '' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
2 | +do_action('AHEE_log', __FILE__, __FUNCTION__, ''); |
|
3 | 3 | /** |
4 | 4 | * EE_Export class |
5 | 5 | * |
@@ -39,11 +39,11 @@ discard block |
||
39 | 39 | * @access private |
40 | 40 | * @param array $request_data |
41 | 41 | */ |
42 | - private function __construct( $request_data = array() ) { |
|
42 | + private function __construct($request_data = array()) { |
|
43 | 43 | $this->_req_data = $request_data; |
44 | - $this->today = date("Y-m-d",time()); |
|
45 | - require_once( EE_CLASSES . 'EE_CSV.class.php' ); |
|
46 | - $this->EE_CSV= EE_CSV::instance(); |
|
44 | + $this->today = date("Y-m-d", time()); |
|
45 | + require_once(EE_CLASSES.'EE_CSV.class.php'); |
|
46 | + $this->EE_CSV = EE_CSV::instance(); |
|
47 | 47 | } |
48 | 48 | |
49 | 49 | |
@@ -55,10 +55,10 @@ discard block |
||
55 | 55 | * @param array $request_data |
56 | 56 | * @return \EE_Export |
57 | 57 | */ |
58 | - public static function instance( $request_data = array() ) { |
|
58 | + public static function instance($request_data = array()) { |
|
59 | 59 | // check if class object is instantiated |
60 | - if ( self::$_instance === NULL or ! is_object( self::$_instance ) or ! ( self::$_instance instanceof EE_Export )) { |
|
61 | - self::$_instance = new self( $request_data ); |
|
60 | + if (self::$_instance === NULL or ! is_object(self::$_instance) or ! (self::$_instance instanceof EE_Export)) { |
|
61 | + self::$_instance = new self($request_data); |
|
62 | 62 | } |
63 | 63 | return self::$_instance; |
64 | 64 | } |
@@ -72,15 +72,15 @@ discard block |
||
72 | 72 | public function export() { |
73 | 73 | |
74 | 74 | // in case of bulk exports, the "actual" action will be in action2, but first check regular action for "export" keyword |
75 | - if ( isset( $this->_req_data['action'] ) && strpos( $this->_req_data['action'], 'export' ) === FALSE ) { |
|
75 | + if (isset($this->_req_data['action']) && strpos($this->_req_data['action'], 'export') === FALSE) { |
|
76 | 76 | // check if action2 has export action |
77 | - if ( isset( $this->_req_data['action2'] ) && strpos( $this->_req_data['action2'], 'export' ) !== FALSE ) { |
|
77 | + if (isset($this->_req_data['action2']) && strpos($this->_req_data['action2'], 'export') !== FALSE) { |
|
78 | 78 | // whoop! there it is! |
79 | 79 | $this->_req_data['action'] = $this->_req_data['action2']; |
80 | 80 | } |
81 | 81 | } |
82 | 82 | |
83 | - $this->_req_data['export'] = isset( $this->_req_data['export'] ) ? $this->_req_data['export'] : ''; |
|
83 | + $this->_req_data['export'] = isset($this->_req_data['export']) ? $this->_req_data['export'] : ''; |
|
84 | 84 | |
85 | 85 | switch ($this->_req_data['export']) { |
86 | 86 | case 'report': |
@@ -94,7 +94,7 @@ discard block |
||
94 | 94 | break; |
95 | 95 | |
96 | 96 | case 'registrations_report_for_event': |
97 | - $this->report_registrations_for_event( $this->_req_data['EVT_ID'] ); |
|
97 | + $this->report_registrations_for_event($this->_req_data['EVT_ID']); |
|
98 | 98 | break; |
99 | 99 | |
100 | 100 | case 'attendees': |
@@ -106,7 +106,7 @@ discard block |
||
106 | 106 | break; |
107 | 107 | |
108 | 108 | default: |
109 | - EE_Error::add_error(__('An error occurred! The requested export report could not be found.','event_espresso'), __FILE__, __FUNCTION__, __LINE__ ) ; |
|
109 | + EE_Error::add_error(__('An error occurred! The requested export report could not be found.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
110 | 110 | return FALSE; |
111 | 111 | break; |
112 | 112 | |
@@ -124,7 +124,7 @@ discard block |
||
124 | 124 | * Downloads a CSV file with all the columns, but no data. This should be used for importing |
125 | 125 | * @return null kills execution |
126 | 126 | */ |
127 | - function export_sample(){ |
|
127 | + function export_sample() { |
|
128 | 128 | $event = EEM_Event::instance()->get_one(); |
129 | 129 | $this->_req_data['EVT_ID'] = $event->ID(); |
130 | 130 | $this->export_all_event_data(); |
@@ -150,23 +150,23 @@ discard block |
||
150 | 150 | $state_country_query_params = array(); |
151 | 151 | $question_group_query_params = array(); |
152 | 152 | $question_query_params = array(); |
153 | - if ( isset( $this->_req_data['EVT_ID'] )) { |
|
153 | + if (isset($this->_req_data['EVT_ID'])) { |
|
154 | 154 | // do we have an array of IDs ? |
155 | 155 | |
156 | - if ( is_array( $this->_req_data['EVT_ID'] )) { |
|
157 | - $EVT_IDs = array_map( 'sanitize_text_field', $this->_req_data['EVT_ID'] ); |
|
158 | - $value_to_equal = array('IN',$EVT_IDs); |
|
156 | + if (is_array($this->_req_data['EVT_ID'])) { |
|
157 | + $EVT_IDs = array_map('sanitize_text_field', $this->_req_data['EVT_ID']); |
|
158 | + $value_to_equal = array('IN', $EVT_IDs); |
|
159 | 159 | $filename = 'events'; |
160 | 160 | } else { |
161 | 161 | // generate regular where = clause |
162 | - $EVT_ID = absint( $this->_req_data['EVT_ID'] ); |
|
162 | + $EVT_ID = absint($this->_req_data['EVT_ID']); |
|
163 | 163 | $value_to_equal = $EVT_ID; |
164 | 164 | $event = EE_Registry::instance()->load_model('Event')->get_one_by_ID($EVT_ID); |
165 | 165 | |
166 | - $filename = 'event-' . ( $event instanceof EE_Event ? $event->slug() : __( 'unknown', 'event_espresso' ) ); |
|
166 | + $filename = 'event-'.($event instanceof EE_Event ? $event->slug() : __('unknown', 'event_espresso')); |
|
167 | 167 | |
168 | 168 | } |
169 | - $event_query_params[0]['EVT_ID'] =$value_to_equal; |
|
169 | + $event_query_params[0]['EVT_ID'] = $value_to_equal; |
|
170 | 170 | $related_models_query_params[0]['Event.EVT_ID'] = $value_to_equal; |
171 | 171 | $related_through_reg_query_params[0]['Registration.EVT_ID'] = $value_to_equal; |
172 | 172 | $datetime_ticket_query_params[0]['Datetime.EVT_ID'] = $value_to_equal; |
@@ -210,42 +210,42 @@ discard block |
||
210 | 210 | |
211 | 211 | ); |
212 | 212 | |
213 | - $model_data = $this->_get_export_data_for_models( $models_to_export ); |
|
213 | + $model_data = $this->_get_export_data_for_models($models_to_export); |
|
214 | 214 | |
215 | - $filename = $this->generate_filename ( $filename ); |
|
215 | + $filename = $this->generate_filename($filename); |
|
216 | 216 | |
217 | - if ( ! $this->EE_CSV->export_multiple_model_data_to_csv( $filename, $model_data )) { |
|
218 | - EE_Error::add_error(__("'An error occurred and the Event details could not be exported from the database.'", "event_espresso"), __FILE__, __FUNCTION__, __LINE__ ); |
|
217 | + if ( ! $this->EE_CSV->export_multiple_model_data_to_csv($filename, $model_data)) { |
|
218 | + EE_Error::add_error(__("'An error occurred and the Event details could not be exported from the database.'", "event_espresso"), __FILE__, __FUNCTION__, __LINE__); |
|
219 | 219 | } |
220 | 220 | } |
221 | 221 | |
222 | - function report_attendees(){ |
|
222 | + function report_attendees() { |
|
223 | 223 | $attendee_rows = EEM_Attendee::instance()->get_all_wpdb_results( |
224 | 224 | array( |
225 | - 'force_join' => array( 'State', 'Country' ), |
|
225 | + 'force_join' => array('State', 'Country'), |
|
226 | 226 | 'caps' => EEM_Base::caps_read_admin |
227 | 227 | ) |
228 | 228 | ); |
229 | 229 | $csv_data = array(); |
230 | - foreach( $attendee_rows as $attendee_row ){ |
|
230 | + foreach ($attendee_rows as $attendee_row) { |
|
231 | 231 | $csv_row = array(); |
232 | - foreach( EEM_Attendee::instance()->field_settings() as $field_name => $field_obj ){ |
|
233 | - if( $field_name == 'STA_ID' ){ |
|
234 | - $state_name_field = EEM_State::instance()->field_settings_for( 'STA_name' ); |
|
235 | - $csv_row[ __( 'State', 'event_espresso' ) ] = $attendee_row[ $state_name_field->get_qualified_column() ]; |
|
236 | - }elseif( $field_name == 'CNT_ISO' ){ |
|
237 | - $country_name_field = EEM_Country::instance()->field_settings_for( 'CNT_name' ); |
|
238 | - $csv_row[ __( 'Country', 'event_espresso' ) ] = $attendee_row[ $country_name_field->get_qualified_column() ]; |
|
239 | - }else{ |
|
240 | - $csv_row[ $field_obj->get_nicename() ] = $attendee_row[ $field_obj->get_qualified_column() ]; |
|
232 | + foreach (EEM_Attendee::instance()->field_settings() as $field_name => $field_obj) { |
|
233 | + if ($field_name == 'STA_ID') { |
|
234 | + $state_name_field = EEM_State::instance()->field_settings_for('STA_name'); |
|
235 | + $csv_row[__('State', 'event_espresso')] = $attendee_row[$state_name_field->get_qualified_column()]; |
|
236 | + }elseif ($field_name == 'CNT_ISO') { |
|
237 | + $country_name_field = EEM_Country::instance()->field_settings_for('CNT_name'); |
|
238 | + $csv_row[__('Country', 'event_espresso')] = $attendee_row[$country_name_field->get_qualified_column()]; |
|
239 | + } else { |
|
240 | + $csv_row[$field_obj->get_nicename()] = $attendee_row[$field_obj->get_qualified_column()]; |
|
241 | 241 | } |
242 | 242 | } |
243 | 243 | $csv_data[] = $csv_row; |
244 | 244 | } |
245 | 245 | |
246 | - $filename = $this->generate_filename ( 'contact-list-report' ); |
|
246 | + $filename = $this->generate_filename('contact-list-report'); |
|
247 | 247 | |
248 | - $handle = $this->EE_CSV->begin_sending_csv( $filename); |
|
248 | + $handle = $this->EE_CSV->begin_sending_csv($filename); |
|
249 | 249 | $this->EE_CSV->write_data_array_to_csv($handle, $csv_data); |
250 | 250 | $this->EE_CSV->end_sending_csv($handle); |
251 | 251 | } |
@@ -262,18 +262,18 @@ discard block |
||
262 | 262 | $countries_that_have_an_attendee = EEM_Country::instance()->get_all(array(0=>array('Attendee.ATT_ID'=>array('IS NOT NULL')))); |
263 | 263 | // $states_to_export_query_params |
264 | 264 | $models_to_export = array( |
265 | - 'Country'=>array(array('CNT_ISO'=>array('IN',array_keys($countries_that_have_an_attendee)))), |
|
266 | - 'State'=>array(array('STA_ID'=>array('IN',array_keys($states_that_have_an_attendee)))), |
|
265 | + 'Country'=>array(array('CNT_ISO'=>array('IN', array_keys($countries_that_have_an_attendee)))), |
|
266 | + 'State'=>array(array('STA_ID'=>array('IN', array_keys($states_that_have_an_attendee)))), |
|
267 | 267 | 'Attendee'=>array(), |
268 | 268 | ); |
269 | 269 | |
270 | 270 | |
271 | 271 | |
272 | - $model_data = $this->_get_export_data_for_models( $models_to_export ); |
|
273 | - $filename = $this->generate_filename ( 'all-attendees' ); |
|
272 | + $model_data = $this->_get_export_data_for_models($models_to_export); |
|
273 | + $filename = $this->generate_filename('all-attendees'); |
|
274 | 274 | |
275 | - if ( ! $this->EE_CSV->export_multiple_model_data_to_csv( $filename, $model_data )) { |
|
276 | - EE_Error::add_error(__('An error occurred and the Attendee data could not be exported from the database.','event_espresso'), __FILE__, __FUNCTION__, __LINE__ ); |
|
275 | + if ( ! $this->EE_CSV->export_multiple_model_data_to_csv($filename, $model_data)) { |
|
276 | + EE_Error::add_error(__('An error occurred and the Attendee data could not be exported from the database.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
277 | 277 | } |
278 | 278 | } |
279 | 279 | |
@@ -285,19 +285,19 @@ discard block |
||
285 | 285 | * @param boolean|string $pretty_schema true to display pretty, a string to use a specific "Schema", or false to NOT display pretty |
286 | 286 | * @return string |
287 | 287 | */ |
288 | - protected function _prepare_value_from_db_for_display( $model, $field_name, $raw_db_value, $pretty_schema = true ) { |
|
289 | - $field_obj = $model->field_settings_for( $field_name ); |
|
290 | - $value_on_model_obj = $field_obj->prepare_for_set_from_db( $raw_db_value ); |
|
291 | - if( $field_obj instanceof EE_Datetime_Field ) { |
|
292 | - $field_obj->set_date_format( EE_CSV::instance()->get_date_format_for_csv( $field_obj->get_date_format( $pretty_schema ) ), $pretty_schema ); |
|
293 | - $field_obj->set_time_format( EE_CSV::instance()->get_time_format_for_csv( $field_obj->get_time_format( $pretty_schema ) ), $pretty_schema ); |
|
288 | + protected function _prepare_value_from_db_for_display($model, $field_name, $raw_db_value, $pretty_schema = true) { |
|
289 | + $field_obj = $model->field_settings_for($field_name); |
|
290 | + $value_on_model_obj = $field_obj->prepare_for_set_from_db($raw_db_value); |
|
291 | + if ($field_obj instanceof EE_Datetime_Field) { |
|
292 | + $field_obj->set_date_format(EE_CSV::instance()->get_date_format_for_csv($field_obj->get_date_format($pretty_schema)), $pretty_schema); |
|
293 | + $field_obj->set_time_format(EE_CSV::instance()->get_time_format_for_csv($field_obj->get_time_format($pretty_schema)), $pretty_schema); |
|
294 | 294 | } |
295 | - if( $pretty_schema === true){ |
|
296 | - return $field_obj->prepare_for_pretty_echoing( $value_on_model_obj ); |
|
297 | - }elseif( is_string( $pretty_schema ) ) { |
|
298 | - return $field_obj->prepare_for_pretty_echoing($value_on_model_obj, $pretty_schema ); |
|
299 | - }else{ |
|
300 | - return $field_obj->prepare_for_get( $value_on_model_obj ); |
|
295 | + if ($pretty_schema === true) { |
|
296 | + return $field_obj->prepare_for_pretty_echoing($value_on_model_obj); |
|
297 | + }elseif (is_string($pretty_schema)) { |
|
298 | + return $field_obj->prepare_for_pretty_echoing($value_on_model_obj, $pretty_schema); |
|
299 | + } else { |
|
300 | + return $field_obj->prepare_for_get($value_on_model_obj); |
|
301 | 301 | } |
302 | 302 | } |
303 | 303 | |
@@ -306,7 +306,7 @@ discard block |
||
306 | 306 | * and the questions associated with the registrations |
307 | 307 | * @param int $event_id |
308 | 308 | */ |
309 | - function report_registrations_for_event( $event_id = NULL ){ |
|
309 | + function report_registrations_for_event($event_id = NULL) { |
|
310 | 310 | $reg_fields_to_include = array( |
311 | 311 | 'TXN_ID', |
312 | 312 | 'ATT_ID', |
@@ -338,126 +338,126 @@ discard block |
||
338 | 338 | array( |
339 | 339 | 'OR' => array( |
340 | 340 | //don't include registrations from failed or abandoned transactions... |
341 | - 'Transaction.STS_ID' => array( 'NOT IN', array( EEM_Transaction::failed_status_code, EEM_Transaction::abandoned_status_code ) ), |
|
341 | + 'Transaction.STS_ID' => array('NOT IN', array(EEM_Transaction::failed_status_code, EEM_Transaction::abandoned_status_code)), |
|
342 | 342 | //unless the registration is approved, in which case include it regardless of transaction status |
343 | 343 | 'STS_ID' => EEM_Registration::status_id_approved |
344 | 344 | ), |
345 | - 'Ticket.TKT_deleted' => array( 'IN', array( true, false ) ) |
|
345 | + 'Ticket.TKT_deleted' => array('IN', array(true, false)) |
|
346 | 346 | ), |
347 | - 'order_by' => array('Transaction.TXN_ID'=>'asc','REG_count'=>'asc'), |
|
348 | - 'force_join' => array( 'Transaction', 'Ticket', 'Attendee' ), |
|
347 | + 'order_by' => array('Transaction.TXN_ID'=>'asc', 'REG_count'=>'asc'), |
|
348 | + 'force_join' => array('Transaction', 'Ticket', 'Attendee'), |
|
349 | 349 | 'caps' => EEM_Base::caps_read_admin |
350 | 350 | ), |
351 | 351 | $event_id |
352 | 352 | ); |
353 | - if( $event_id ){ |
|
354 | - $query_params[0]['EVT_ID'] = $event_id; |
|
355 | - }else{ |
|
356 | - $query_params[ 'force_join' ][] = 'Event'; |
|
353 | + if ($event_id) { |
|
354 | + $query_params[0]['EVT_ID'] = $event_id; |
|
355 | + } else { |
|
356 | + $query_params['force_join'][] = 'Event'; |
|
357 | 357 | } |
358 | - $registration_rows = $reg_model->get_all_wpdb_results( $query_params ); |
|
358 | + $registration_rows = $reg_model->get_all_wpdb_results($query_params); |
|
359 | 359 | //get all questions which relate to someone in this group |
360 | 360 | $registration_ids = array(); |
361 | - foreach( $registration_rows as $reg_row ) { |
|
362 | - $registration_ids[] = intval( $reg_row[ 'Registration.REG_ID'] ); |
|
361 | + foreach ($registration_rows as $reg_row) { |
|
362 | + $registration_ids[] = intval($reg_row['Registration.REG_ID']); |
|
363 | 363 | } |
364 | 364 | // EEM_Question::instance()->show_next_x_db_queries(); |
365 | - $questions_for_these_regs_rows = EEM_Question::instance()->get_all_wpdb_results(array(array('Answer.REG_ID'=>array('IN',$registration_ids)))); |
|
366 | - foreach($registration_rows as $reg_row){ |
|
367 | - if ( is_array( $reg_row ) ) { |
|
365 | + $questions_for_these_regs_rows = EEM_Question::instance()->get_all_wpdb_results(array(array('Answer.REG_ID'=>array('IN', $registration_ids)))); |
|
366 | + foreach ($registration_rows as $reg_row) { |
|
367 | + if (is_array($reg_row)) { |
|
368 | 368 | $reg_csv_array = array(); |
369 | - if( ! $event_id ){ |
|
369 | + if ( ! $event_id) { |
|
370 | 370 | //get the event's name and Id |
371 | - $reg_csv_array[ __( 'Event', 'event_espresso' ) ] = sprintf( __( '%1$s (%2$s)', 'event_espresso' ), $this->_prepare_value_from_db_for_display( EEM_Event::instance(), 'EVT_name', $reg_row[ 'Event_CPT.post_title'] ), $reg_row[ 'Event_CPT.ID' ] ); |
|
371 | + $reg_csv_array[__('Event', 'event_espresso')] = sprintf(__('%1$s (%2$s)', 'event_espresso'), $this->_prepare_value_from_db_for_display(EEM_Event::instance(), 'EVT_name', $reg_row['Event_CPT.post_title']), $reg_row['Event_CPT.ID']); |
|
372 | 372 | } |
373 | - $is_primary_reg = $reg_row[ 'Registration.REG_count' ] == '1' ? true : false; |
|
373 | + $is_primary_reg = $reg_row['Registration.REG_count'] == '1' ? true : false; |
|
374 | 374 | /*@var $reg_row EE_Registration */ |
375 | - foreach($reg_fields_to_include as $field_name){ |
|
375 | + foreach ($reg_fields_to_include as $field_name) { |
|
376 | 376 | $field = $reg_model->field_settings_for($field_name); |
377 | - if($field_name == 'REG_final_price'){ |
|
378 | - $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_final_price'], 'localized_float' ); |
|
379 | - }elseif( $field_name == 'REG_count' ){ |
|
380 | - $value = sprintf( __( '%s of %s', 'event_espresso' ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_count', $reg_row['Registration.REG_count'] ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_group_size', $reg_row['Registration.REG_group_size' ] ) ); |
|
381 | - }elseif( $field_name == 'REG_date' ) { |
|
382 | - $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_date'], 'no_html' ); |
|
383 | - }else{ |
|
384 | - $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ $field->get_qualified_column() ] ); |
|
377 | + if ($field_name == 'REG_final_price') { |
|
378 | + $value = $this->_prepare_value_from_db_for_display($reg_model, $field_name, $reg_row['Registration.REG_final_price'], 'localized_float'); |
|
379 | + }elseif ($field_name == 'REG_count') { |
|
380 | + $value = sprintf(__('%s of %s', 'event_espresso'), $this->_prepare_value_from_db_for_display($reg_model, 'REG_count', $reg_row['Registration.REG_count']), $this->_prepare_value_from_db_for_display($reg_model, 'REG_group_size', $reg_row['Registration.REG_group_size'])); |
|
381 | + }elseif ($field_name == 'REG_date') { |
|
382 | + $value = $this->_prepare_value_from_db_for_display($reg_model, $field_name, $reg_row['Registration.REG_date'], 'no_html'); |
|
383 | + } else { |
|
384 | + $value = $this->_prepare_value_from_db_for_display($reg_model, $field_name, $reg_row[$field->get_qualified_column()]); |
|
385 | 385 | } |
386 | 386 | $reg_csv_array[$this->_get_column_name_for_field($field)] = $value; |
387 | - if($field_name == 'REG_final_price'){ |
|
387 | + if ($field_name == 'REG_final_price') { |
|
388 | 388 | //add a column named Currency after the final price |
389 | 389 | $reg_csv_array[__("Currency", "event_espresso")] = EE_Config::instance()->currency->code; |
390 | 390 | } |
391 | 391 | } |
392 | 392 | //get pretty status |
393 | - $stati = EEM_Status::instance()->localized_status( array( |
|
394 | - $reg_row[ 'Registration.STS_ID' ] => __( 'unknown', 'event_espresso' ), |
|
395 | - $reg_row[ 'TransactionTable.STS_ID' ] => __( 'unknown', 'event_espresso' ) ), |
|
393 | + $stati = EEM_Status::instance()->localized_status(array( |
|
394 | + $reg_row['Registration.STS_ID'] => __('unknown', 'event_espresso'), |
|
395 | + $reg_row['TransactionTable.STS_ID'] => __('unknown', 'event_espresso') ), |
|
396 | 396 | FALSE, |
397 | - 'sentence' ); |
|
398 | - $reg_csv_array[__("Registration Status", 'event_espresso')] = $stati[ $reg_row[ 'Registration.STS_ID' ] ]; |
|
397 | + 'sentence'); |
|
398 | + $reg_csv_array[__("Registration Status", 'event_espresso')] = $stati[$reg_row['Registration.STS_ID']]; |
|
399 | 399 | //get pretty trnasaction status |
400 | - $reg_csv_array[__("Transaction Status", 'event_espresso')] = $stati[ $reg_row[ 'TransactionTable.STS_ID' ] ]; |
|
401 | - $reg_csv_array[ __( 'Transaction Amount Due', 'event_espresso' ) ] = $is_primary_reg ? $this->_prepare_value_from_db_for_display( EEM_Transaction::instance(), 'TXN_total', $reg_row[ 'TransactionTable.TXN_total' ], 'localized_float' ) : '0.00'; |
|
402 | - $reg_csv_array[ __( 'Amount Paid', 'event_espresso' )] = $is_primary_reg ? $this->_prepare_value_from_db_for_display( EEM_Transaction::instance(), 'TXN_paid', $reg_row[ 'TransactionTable.TXN_paid' ], 'localized_float' ) : '0.00'; |
|
400 | + $reg_csv_array[__("Transaction Status", 'event_espresso')] = $stati[$reg_row['TransactionTable.STS_ID']]; |
|
401 | + $reg_csv_array[__('Transaction Amount Due', 'event_espresso')] = $is_primary_reg ? $this->_prepare_value_from_db_for_display(EEM_Transaction::instance(), 'TXN_total', $reg_row['TransactionTable.TXN_total'], 'localized_float') : '0.00'; |
|
402 | + $reg_csv_array[__('Amount Paid', 'event_espresso')] = $is_primary_reg ? $this->_prepare_value_from_db_for_display(EEM_Transaction::instance(), 'TXN_paid', $reg_row['TransactionTable.TXN_paid'], 'localized_float') : '0.00'; |
|
403 | 403 | $payment_methods = array(); |
404 | 404 | $gateway_txn_ids_etc = array(); |
405 | 405 | $payment_times = array(); |
406 | - if( $is_primary_reg && $reg_row[ 'TransactionTable.TXN_ID' ] ){ |
|
406 | + if ($is_primary_reg && $reg_row['TransactionTable.TXN_ID']) { |
|
407 | 407 | $payments_info = EEM_Payment::instance()->get_all_wpdb_results( |
408 | 408 | array( |
409 | 409 | array( |
410 | - 'TXN_ID' => $reg_row[ 'TransactionTable.TXN_ID' ], |
|
410 | + 'TXN_ID' => $reg_row['TransactionTable.TXN_ID'], |
|
411 | 411 | 'STS_ID' => EEM_Payment::status_id_approved |
412 | 412 | ), |
413 | - 'force_join' => array( 'Payment_Method' ), |
|
413 | + 'force_join' => array('Payment_Method'), |
|
414 | 414 | |
415 | 415 | ), |
416 | 416 | ARRAY_A, |
417 | 417 | 'Payment_Method.PMD_admin_name as name, Payment.PAY_txn_id_chq_nmbr as gateway_txn_id, Payment.PAY_timestamp as payment_time' ); |
418 | 418 | |
419 | - foreach( $payments_info as $payment_method_and_gateway_txn_id ){ |
|
420 | - $payment_methods[] = isset( $payment_method_and_gateway_txn_id[ 'name' ] ) ? $payment_method_and_gateway_txn_id[ 'name' ] : __( 'Unknown', 'event_espresso' ); |
|
421 | - $gateway_txn_ids_etc[] = isset( $payment_method_and_gateway_txn_id[ 'gateway_txn_id' ] ) ? $payment_method_and_gateway_txn_id[ 'gateway_txn_id' ] : ''; |
|
422 | - $payment_times[] = isset( $payment_method_and_gateway_txn_id[ 'payment_time' ] ) ? $payment_method_and_gateway_txn_id[ 'payment_time' ] : ''; |
|
419 | + foreach ($payments_info as $payment_method_and_gateway_txn_id) { |
|
420 | + $payment_methods[] = isset($payment_method_and_gateway_txn_id['name']) ? $payment_method_and_gateway_txn_id['name'] : __('Unknown', 'event_espresso'); |
|
421 | + $gateway_txn_ids_etc[] = isset($payment_method_and_gateway_txn_id['gateway_txn_id']) ? $payment_method_and_gateway_txn_id['gateway_txn_id'] : ''; |
|
422 | + $payment_times[] = isset($payment_method_and_gateway_txn_id['payment_time']) ? $payment_method_and_gateway_txn_id['payment_time'] : ''; |
|
423 | 423 | } |
424 | 424 | |
425 | 425 | } |
426 | - $reg_csv_array[ __( 'Payment Date(s)', 'event_espresso' ) ] = implode( ',', $payment_times ); |
|
427 | - $reg_csv_array[ __( 'Payment Method(s)', 'event_espresso' ) ] = implode( ",", $payment_methods ); |
|
428 | - $reg_csv_array[ __( 'Gateway Transaction ID(s)', 'event_espresso' )] = implode( ',', $gateway_txn_ids_etc ); |
|
426 | + $reg_csv_array[__('Payment Date(s)', 'event_espresso')] = implode(',', $payment_times); |
|
427 | + $reg_csv_array[__('Payment Method(s)', 'event_espresso')] = implode(",", $payment_methods); |
|
428 | + $reg_csv_array[__('Gateway Transaction ID(s)', 'event_espresso')] = implode(',', $gateway_txn_ids_etc); |
|
429 | 429 | |
430 | 430 | //get whether or not the user has checked in |
431 | - $reg_csv_array[__("Check-Ins", "event_espresso")] = $reg_model->count_related( $reg_row[ 'Registration.REG_ID'] , 'Checkin' ); |
|
431 | + $reg_csv_array[__("Check-Ins", "event_espresso")] = $reg_model->count_related($reg_row['Registration.REG_ID'], 'Checkin'); |
|
432 | 432 | //get ticket of registration and its price |
433 | 433 | $ticket_model = EE_Registry::instance()->load_model('Ticket'); |
434 | - if( $reg_row[ 'Ticket.TKT_ID'] ) { |
|
435 | - $ticket_name = $this->_prepare_value_from_db_for_display( $ticket_model, 'TKT_name', $reg_row[ 'Ticket.TKT_name' ] ); |
|
434 | + if ($reg_row['Ticket.TKT_ID']) { |
|
435 | + $ticket_name = $this->_prepare_value_from_db_for_display($ticket_model, 'TKT_name', $reg_row['Ticket.TKT_name']); |
|
436 | 436 | $datetimes_strings = array(); |
437 | - foreach( EEM_Datetime::instance()->get_all_wpdb_results( array( array( 'Ticket.TKT_ID' => $reg_row[ 'Ticket.TKT_ID' ] ), 'order_by' => array( 'DTT_EVT_start' => 'ASC' ), 'default_where_conditions' => 'none' ) ) as $datetime){ |
|
438 | - $datetimes_strings[] = $this->_prepare_value_from_db_for_display( EEM_Datetime::instance(), 'DTT_EVT_start', $datetime[ 'Datetime.DTT_EVT_start'] ); |
|
437 | + foreach (EEM_Datetime::instance()->get_all_wpdb_results(array(array('Ticket.TKT_ID' => $reg_row['Ticket.TKT_ID']), 'order_by' => array('DTT_EVT_start' => 'ASC'), 'default_where_conditions' => 'none')) as $datetime) { |
|
438 | + $datetimes_strings[] = $this->_prepare_value_from_db_for_display(EEM_Datetime::instance(), 'DTT_EVT_start', $datetime['Datetime.DTT_EVT_start']); |
|
439 | 439 | } |
440 | 440 | |
441 | 441 | } else { |
442 | - $ticket_name = __( 'Unknown', 'event_espresso' ); |
|
443 | - $datetimes_strings = array( __( 'Unknown', 'event_espresso' ) ); |
|
442 | + $ticket_name = __('Unknown', 'event_espresso'); |
|
443 | + $datetimes_strings = array(__('Unknown', 'event_espresso')); |
|
444 | 444 | } |
445 | 445 | $reg_csv_array[$ticket_model->field_settings_for('TKT_name')->get_nicename()] = $ticket_name; |
446 | 446 | $reg_csv_array[__("Datetimes of Ticket", "event_espresso")] = implode(", ", $datetimes_strings); |
447 | 447 | //get datetime(s) of registration |
448 | 448 | |
449 | 449 | //add attendee columns |
450 | - foreach($att_fields_to_include as $att_field_name){ |
|
450 | + foreach ($att_fields_to_include as $att_field_name) { |
|
451 | 451 | $field_obj = EEM_Attendee::instance()->field_settings_for($att_field_name); |
452 | - if( $reg_row[ 'Attendee_CPT.ID' ]){ |
|
453 | - if($att_field_name == 'STA_ID'){ |
|
454 | - $value = EEM_State::instance()->get_var( array( array( 'STA_ID' => $reg_row[ 'Attendee_Meta.STA_ID' ] ) ), 'STA_name' ); |
|
455 | - }elseif($att_field_name == 'CNT_ISO'){ |
|
456 | - $value = EEM_Country::instance()->get_var( array( array( 'CNT_ISO' => $reg_row[ 'Attendee_Meta.CNT_ISO' ] ) ), 'CNT_name' ); |
|
457 | - }else{ |
|
458 | - $value = $this->_prepare_value_from_db_for_display( EEM_Attendee::instance(), $att_field_name, $reg_row[ $field_obj->get_qualified_column() ] ); |
|
452 | + if ($reg_row['Attendee_CPT.ID']) { |
|
453 | + if ($att_field_name == 'STA_ID') { |
|
454 | + $value = EEM_State::instance()->get_var(array(array('STA_ID' => $reg_row['Attendee_Meta.STA_ID'])), 'STA_name'); |
|
455 | + }elseif ($att_field_name == 'CNT_ISO') { |
|
456 | + $value = EEM_Country::instance()->get_var(array(array('CNT_ISO' => $reg_row['Attendee_Meta.CNT_ISO'])), 'CNT_name'); |
|
457 | + } else { |
|
458 | + $value = $this->_prepare_value_from_db_for_display(EEM_Attendee::instance(), $att_field_name, $reg_row[$field_obj->get_qualified_column()]); |
|
459 | 459 | } |
460 | - }else{ |
|
460 | + } else { |
|
461 | 461 | $value = ''; |
462 | 462 | } |
463 | 463 | |
@@ -465,56 +465,56 @@ discard block |
||
465 | 465 | } |
466 | 466 | |
467 | 467 | //make sure each registration has the same questions in the same order |
468 | - foreach($questions_for_these_regs_rows as $question_row){ |
|
469 | - if( ! isset($reg_csv_array[$question_row[ 'Question.QST_admin_label']])){ |
|
470 | - $reg_csv_array[$question_row[ 'Question.QST_admin_label' ] ] = null; |
|
468 | + foreach ($questions_for_these_regs_rows as $question_row) { |
|
469 | + if ( ! isset($reg_csv_array[$question_row['Question.QST_admin_label']])) { |
|
470 | + $reg_csv_array[$question_row['Question.QST_admin_label']] = null; |
|
471 | 471 | } |
472 | 472 | } |
473 | 473 | //now fill out the questions THEY answered |
474 | - foreach( EEM_Answer::instance()->get_all_wpdb_results( array( array( 'REG_ID' => $reg_row[ 'Registration.REG_ID' ] ), 'force_join' => array( 'Question' ) ) ) as $answer_row){ |
|
474 | + foreach (EEM_Answer::instance()->get_all_wpdb_results(array(array('REG_ID' => $reg_row['Registration.REG_ID']), 'force_join' => array('Question'))) as $answer_row) { |
|
475 | 475 | /* @var $answer EE_Answer */ |
476 | - if( $answer_row[ 'Question.QST_ID' ] ){ |
|
477 | - $question_label = $this->_prepare_value_from_db_for_display( EEM_Question::instance(), 'QST_admin_label', $answer_row[ 'Question.QST_admin_label' ] ); |
|
478 | - }else{ |
|
479 | - $question_label = sprintf( __( 'Question $s', 'event_espresso' ), $answer_row[ 'Answer.QST_ID' ] ); |
|
476 | + if ($answer_row['Question.QST_ID']) { |
|
477 | + $question_label = $this->_prepare_value_from_db_for_display(EEM_Question::instance(), 'QST_admin_label', $answer_row['Question.QST_admin_label']); |
|
478 | + } else { |
|
479 | + $question_label = sprintf(__('Question $s', 'event_espresso'), $answer_row['Answer.QST_ID']); |
|
480 | 480 | } |
481 | - if( isset( $answer_row[ 'Question.QST_type'] ) && $answer_row[ 'Question.QST_type' ] == EEM_Question::QST_type_state ) { |
|
482 | - $reg_csv_array[ $question_label ] = EEM_State::instance()->get_state_name_by_ID( $answer_row[ 'Answer.ANS_value' ] ); |
|
481 | + if (isset($answer_row['Question.QST_type']) && $answer_row['Question.QST_type'] == EEM_Question::QST_type_state) { |
|
482 | + $reg_csv_array[$question_label] = EEM_State::instance()->get_state_name_by_ID($answer_row['Answer.ANS_value']); |
|
483 | 483 | } else { |
484 | - $reg_csv_array[ $question_label ] = $this->_prepare_value_from_db_for_display( EEM_Answer::instance(), 'ANS_value', $answer_row[ 'Answer.ANS_value' ] ); |
|
484 | + $reg_csv_array[$question_label] = $this->_prepare_value_from_db_for_display(EEM_Answer::instance(), 'ANS_value', $answer_row['Answer.ANS_value']); |
|
485 | 485 | } |
486 | 486 | } |
487 | - $registrations_csv_ready_array[] = apply_filters( 'FHEE__EE_Export__report_registrations__reg_csv_array', $reg_csv_array, $reg_row ); |
|
487 | + $registrations_csv_ready_array[] = apply_filters('FHEE__EE_Export__report_registrations__reg_csv_array', $reg_csv_array, $reg_row); |
|
488 | 488 | } |
489 | 489 | } |
490 | 490 | |
491 | 491 | //if we couldn't export anything, we want to at least show the column headers |
492 | - if(empty($registrations_csv_ready_array)){ |
|
492 | + if (empty($registrations_csv_ready_array)) { |
|
493 | 493 | $reg_csv_array = array(); |
494 | 494 | $model_and_fields_to_include = array( |
495 | 495 | 'Registration' => $reg_fields_to_include, |
496 | 496 | 'Attendee' => $att_fields_to_include |
497 | 497 | ); |
498 | - foreach($model_and_fields_to_include as $model_name => $field_list){ |
|
498 | + foreach ($model_and_fields_to_include as $model_name => $field_list) { |
|
499 | 499 | $model = EE_Registry::instance()->load_model($model_name); |
500 | - foreach($field_list as $field_name){ |
|
500 | + foreach ($field_list as $field_name) { |
|
501 | 501 | $field = $model->field_settings_for($field_name); |
502 | - $reg_csv_array[$this->_get_column_name_for_field($field)] = null;//$registration->get($field->get_name()); |
|
502 | + $reg_csv_array[$this->_get_column_name_for_field($field)] = null; //$registration->get($field->get_name()); |
|
503 | 503 | } |
504 | 504 | } |
505 | 505 | $registrations_csv_ready_array [] = $reg_csv_array; |
506 | 506 | } |
507 | - if( $event_id ){ |
|
508 | - $event_slug = EEM_Event::instance()->get_var( array( array( 'EVT_ID' => $event_id ) ), 'EVT_slug' ); |
|
509 | - if( ! $event_slug ) { |
|
510 | - $event_slug = __( 'unknown', 'event_espresso' ); |
|
507 | + if ($event_id) { |
|
508 | + $event_slug = EEM_Event::instance()->get_var(array(array('EVT_ID' => $event_id)), 'EVT_slug'); |
|
509 | + if ( ! $event_slug) { |
|
510 | + $event_slug = __('unknown', 'event_espresso'); |
|
511 | 511 | } |
512 | - }else{ |
|
513 | - $event_slug = __( 'all', 'event_espresso' ); |
|
512 | + } else { |
|
513 | + $event_slug = __('all', 'event_espresso'); |
|
514 | 514 | } |
515 | - $filename = sprintf( "registrations-for-%s", $event_slug ); |
|
515 | + $filename = sprintf("registrations-for-%s", $event_slug); |
|
516 | 516 | |
517 | - $handle = $this->EE_CSV->begin_sending_csv( $filename); |
|
517 | + $handle = $this->EE_CSV->begin_sending_csv($filename); |
|
518 | 518 | $this->EE_CSV->write_data_array_to_csv($handle, $registrations_csv_ready_array); |
519 | 519 | $this->EE_CSV->end_sending_csv($handle); |
520 | 520 | } |
@@ -524,7 +524,7 @@ discard block |
||
524 | 524 | * @param EE_Model_Field_Base $field |
525 | 525 | * @return string |
526 | 526 | */ |
527 | - protected function _get_column_name_for_field(EE_Model_Field_Base $field){ |
|
527 | + protected function _get_column_name_for_field(EE_Model_Field_Base $field) { |
|
528 | 528 | return $field->get_nicename()."[".$field->get_name()."]"; |
529 | 529 | } |
530 | 530 | |
@@ -537,17 +537,17 @@ discard block |
||
537 | 537 | function export_categories() { |
538 | 538 | // are any Event IDs set? |
539 | 539 | $query_params = array(); |
540 | - if ( isset( $this->_req_data['EVT_CAT_ID'] )) { |
|
540 | + if (isset($this->_req_data['EVT_CAT_ID'])) { |
|
541 | 541 | // do we have an array of IDs ? |
542 | - if ( is_array( $this->_req_data['EVT_CAT_ID'] )) { |
|
542 | + if (is_array($this->_req_data['EVT_CAT_ID'])) { |
|
543 | 543 | // generate an "IN (CSV)" where clause |
544 | - $EVT_CAT_IDs = array_map( 'sanitize_text_field', $this->_req_data['EVT_CAT_ID'] ); |
|
544 | + $EVT_CAT_IDs = array_map('sanitize_text_field', $this->_req_data['EVT_CAT_ID']); |
|
545 | 545 | $filename = 'event-categories'; |
546 | - $query_params[0]['term_taxonomy_id'] = array('IN',$EVT_CAT_IDs); |
|
546 | + $query_params[0]['term_taxonomy_id'] = array('IN', $EVT_CAT_IDs); |
|
547 | 547 | } else { |
548 | 548 | // generate regular where = clause |
549 | - $EVT_CAT_ID = absint( $this->_req_data['EVT_CAT_ID'] ); |
|
550 | - $filename = 'event-category#' . $EVT_CAT_ID; |
|
549 | + $EVT_CAT_ID = absint($this->_req_data['EVT_CAT_ID']); |
|
550 | + $filename = 'event-category#'.$EVT_CAT_ID; |
|
551 | 551 | $query_params[0]['term_taxonomy_id'] = $EVT_CAT_ID; |
552 | 552 | } |
553 | 553 | } else { |
@@ -559,11 +559,11 @@ discard block |
||
559 | 559 | 'Term_Taxonomy' => $query_params |
560 | 560 | ); |
561 | 561 | |
562 | - $table_data = $this->_get_export_data_for_models( $tables_to_export ); |
|
563 | - $filename = $this->generate_filename ( $filename ); |
|
562 | + $table_data = $this->_get_export_data_for_models($tables_to_export); |
|
563 | + $filename = $this->generate_filename($filename); |
|
564 | 564 | |
565 | - if ( ! $this->EE_CSV->export_multiple_model_data_to_csv( $filename, $table_data )) { |
|
566 | - EE_Error::add_error(__('An error occurred and the Category details could not be exported from the database.','event_espresso'), __FILE__, __FUNCTION__, __LINE__ ); |
|
565 | + if ( ! $this->EE_CSV->export_multiple_model_data_to_csv($filename, $table_data)) { |
|
566 | + EE_Error::add_error(__('An error occurred and the Category details could not be exported from the database.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
567 | 567 | } |
568 | 568 | } |
569 | 569 | |
@@ -574,13 +574,13 @@ discard block |
||
574 | 574 | * @param string - export_name |
575 | 575 | * @return string on success, FALSE on fail |
576 | 576 | */ |
577 | - private function generate_filename ( $export_name = '' ) { |
|
578 | - if ( $export_name != '' ) { |
|
579 | - $filename = get_bloginfo('name') . '-' . $export_name; |
|
580 | - $filename = sanitize_key( $filename ) . '-' . $this->today; |
|
577 | + private function generate_filename($export_name = '') { |
|
578 | + if ($export_name != '') { |
|
579 | + $filename = get_bloginfo('name').'-'.$export_name; |
|
580 | + $filename = sanitize_key($filename).'-'.$this->today; |
|
581 | 581 | return $filename; |
582 | - } else { |
|
583 | - EE_Error::add_error(__("No filename was provided", "event_espresso"), __FILE__, __FUNCTION__, __LINE__ ); |
|
582 | + } else { |
|
583 | + EE_Error::add_error(__("No filename was provided", "event_espresso"), __FILE__, __FUNCTION__, __LINE__); |
|
584 | 584 | } |
585 | 585 | return false; |
586 | 586 | } |
@@ -593,12 +593,12 @@ discard block |
||
593 | 593 | * @param array $models_to_export keys are model names (eg 'Event', 'Attendee', etc.) and values are arrays of query params like on EEM_Base::get_all |
594 | 594 | * @return array on success, FALSE on fail |
595 | 595 | */ |
596 | - private function _get_export_data_for_models( $models_to_export = array() ) { |
|
596 | + private function _get_export_data_for_models($models_to_export = array()) { |
|
597 | 597 | $table_data = FALSE; |
598 | - if ( is_array( $models_to_export ) ) { |
|
599 | - foreach ( $models_to_export as $model_name => $query_params ) { |
|
598 | + if (is_array($models_to_export)) { |
|
599 | + foreach ($models_to_export as $model_name => $query_params) { |
|
600 | 600 | //check for a numerically-indexed array. in that case, $model_name is the value!! |
601 | - if(is_int($model_name)){ |
|
601 | + if (is_int($model_name)) { |
|
602 | 602 | $model_name = $query_params; |
603 | 603 | $query_params = array(); |
604 | 604 | } |
@@ -606,17 +606,17 @@ discard block |
||
606 | 606 | $model_objects = $model->get_all($query_params); |
607 | 607 | |
608 | 608 | $table_data[$model_name] = array(); |
609 | - foreach($model_objects as $model_object){ |
|
609 | + foreach ($model_objects as $model_object) { |
|
610 | 610 | $model_data_array = array(); |
611 | 611 | $fields = $model->field_settings(); |
612 | - foreach($fields as $field){ |
|
612 | + foreach ($fields as $field) { |
|
613 | 613 | $column_name = $field->get_nicename()."[".$field->get_name()."]"; |
614 | - if($field instanceof EE_Datetime_Field){ |
|
614 | + if ($field instanceof EE_Datetime_Field) { |
|
615 | 615 | // $field->set_date_format('Y-m-d'); |
616 | 616 | // $field->set_time_format('H:i:s'); |
617 | - $model_data_array[$column_name] = $model_object->get_datetime($field->get_name(),'Y-m-d','H:i:s'); |
|
617 | + $model_data_array[$column_name] = $model_object->get_datetime($field->get_name(), 'Y-m-d', 'H:i:s'); |
|
618 | 618 | } |
619 | - else{ |
|
619 | + else { |
|
620 | 620 | $model_data_array[$column_name] = $model_object->get($field->get_name()); |
621 | 621 | } |
622 | 622 | } |
@@ -1,4 +1,6 @@ discard block |
||
1 | -<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | +} |
|
2 | 4 | do_action( 'AHEE_log', __FILE__, __FUNCTION__, '' ); |
3 | 5 | /** |
4 | 6 | * EE_Export class |
@@ -233,10 +235,10 @@ discard block |
||
233 | 235 | if( $field_name == 'STA_ID' ){ |
234 | 236 | $state_name_field = EEM_State::instance()->field_settings_for( 'STA_name' ); |
235 | 237 | $csv_row[ __( 'State', 'event_espresso' ) ] = $attendee_row[ $state_name_field->get_qualified_column() ]; |
236 | - }elseif( $field_name == 'CNT_ISO' ){ |
|
238 | + } elseif( $field_name == 'CNT_ISO' ){ |
|
237 | 239 | $country_name_field = EEM_Country::instance()->field_settings_for( 'CNT_name' ); |
238 | 240 | $csv_row[ __( 'Country', 'event_espresso' ) ] = $attendee_row[ $country_name_field->get_qualified_column() ]; |
239 | - }else{ |
|
241 | + } else{ |
|
240 | 242 | $csv_row[ $field_obj->get_nicename() ] = $attendee_row[ $field_obj->get_qualified_column() ]; |
241 | 243 | } |
242 | 244 | } |
@@ -294,9 +296,9 @@ discard block |
||
294 | 296 | } |
295 | 297 | if( $pretty_schema === true){ |
296 | 298 | return $field_obj->prepare_for_pretty_echoing( $value_on_model_obj ); |
297 | - }elseif( is_string( $pretty_schema ) ) { |
|
299 | + } elseif( is_string( $pretty_schema ) ) { |
|
298 | 300 | return $field_obj->prepare_for_pretty_echoing($value_on_model_obj, $pretty_schema ); |
299 | - }else{ |
|
301 | + } else{ |
|
300 | 302 | return $field_obj->prepare_for_get( $value_on_model_obj ); |
301 | 303 | } |
302 | 304 | } |
@@ -352,7 +354,7 @@ discard block |
||
352 | 354 | ); |
353 | 355 | if( $event_id ){ |
354 | 356 | $query_params[0]['EVT_ID'] = $event_id; |
355 | - }else{ |
|
357 | + } else{ |
|
356 | 358 | $query_params[ 'force_join' ][] = 'Event'; |
357 | 359 | } |
358 | 360 | $registration_rows = $reg_model->get_all_wpdb_results( $query_params ); |
@@ -376,11 +378,11 @@ discard block |
||
376 | 378 | $field = $reg_model->field_settings_for($field_name); |
377 | 379 | if($field_name == 'REG_final_price'){ |
378 | 380 | $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_final_price'], 'localized_float' ); |
379 | - }elseif( $field_name == 'REG_count' ){ |
|
381 | + } elseif( $field_name == 'REG_count' ){ |
|
380 | 382 | $value = sprintf( __( '%s of %s', 'event_espresso' ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_count', $reg_row['Registration.REG_count'] ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_group_size', $reg_row['Registration.REG_group_size' ] ) ); |
381 | - }elseif( $field_name == 'REG_date' ) { |
|
383 | + } elseif( $field_name == 'REG_date' ) { |
|
382 | 384 | $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_date'], 'no_html' ); |
383 | - }else{ |
|
385 | + } else{ |
|
384 | 386 | $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ $field->get_qualified_column() ] ); |
385 | 387 | } |
386 | 388 | $reg_csv_array[$this->_get_column_name_for_field($field)] = $value; |
@@ -452,12 +454,12 @@ discard block |
||
452 | 454 | if( $reg_row[ 'Attendee_CPT.ID' ]){ |
453 | 455 | if($att_field_name == 'STA_ID'){ |
454 | 456 | $value = EEM_State::instance()->get_var( array( array( 'STA_ID' => $reg_row[ 'Attendee_Meta.STA_ID' ] ) ), 'STA_name' ); |
455 | - }elseif($att_field_name == 'CNT_ISO'){ |
|
457 | + } elseif($att_field_name == 'CNT_ISO'){ |
|
456 | 458 | $value = EEM_Country::instance()->get_var( array( array( 'CNT_ISO' => $reg_row[ 'Attendee_Meta.CNT_ISO' ] ) ), 'CNT_name' ); |
457 | - }else{ |
|
459 | + } else{ |
|
458 | 460 | $value = $this->_prepare_value_from_db_for_display( EEM_Attendee::instance(), $att_field_name, $reg_row[ $field_obj->get_qualified_column() ] ); |
459 | 461 | } |
460 | - }else{ |
|
462 | + } else{ |
|
461 | 463 | $value = ''; |
462 | 464 | } |
463 | 465 | |
@@ -475,7 +477,7 @@ discard block |
||
475 | 477 | /* @var $answer EE_Answer */ |
476 | 478 | if( $answer_row[ 'Question.QST_ID' ] ){ |
477 | 479 | $question_label = $this->_prepare_value_from_db_for_display( EEM_Question::instance(), 'QST_admin_label', $answer_row[ 'Question.QST_admin_label' ] ); |
478 | - }else{ |
|
480 | + } else{ |
|
479 | 481 | $question_label = sprintf( __( 'Question $s', 'event_espresso' ), $answer_row[ 'Answer.QST_ID' ] ); |
480 | 482 | } |
481 | 483 | if( isset( $answer_row[ 'Question.QST_type'] ) && $answer_row[ 'Question.QST_type' ] == EEM_Question::QST_type_state ) { |
@@ -509,7 +511,7 @@ discard block |
||
509 | 511 | if( ! $event_slug ) { |
510 | 512 | $event_slug = __( 'unknown', 'event_espresso' ); |
511 | 513 | } |
512 | - }else{ |
|
514 | + } else{ |
|
513 | 515 | $event_slug = __( 'all', 'event_espresso' ); |
514 | 516 | } |
515 | 517 | $filename = sprintf( "registrations-for-%s", $event_slug ); |
@@ -579,7 +581,7 @@ discard block |
||
579 | 581 | $filename = get_bloginfo('name') . '-' . $export_name; |
580 | 582 | $filename = sanitize_key( $filename ) . '-' . $this->today; |
581 | 583 | return $filename; |
582 | - } else { |
|
584 | + } else { |
|
583 | 585 | EE_Error::add_error(__("No filename was provided", "event_espresso"), __FILE__, __FUNCTION__, __LINE__ ); |
584 | 586 | } |
585 | 587 | return false; |
@@ -615,8 +617,7 @@ discard block |
||
615 | 617 | // $field->set_date_format('Y-m-d'); |
616 | 618 | // $field->set_time_format('H:i:s'); |
617 | 619 | $model_data_array[$column_name] = $model_object->get_datetime($field->get_name(),'Y-m-d','H:i:s'); |
618 | - } |
|
619 | - else{ |
|
620 | + } else{ |
|
620 | 621 | $model_data_array[$column_name] = $model_object->get($field->get_name()); |
621 | 622 | } |
622 | 623 | } |
@@ -226,7 +226,7 @@ discard block |
||
226 | 226 | * generate_question_form_inputs_for_object |
227 | 227 | * |
228 | 228 | * @access protected |
229 | - * @param bool|object $object $object |
|
229 | + * @param EE_Base_Class|null $object $object |
|
230 | 230 | * @param array $input_types |
231 | 231 | * @return array |
232 | 232 | */ |
@@ -324,7 +324,7 @@ discard block |
||
324 | 324 | * add_temp_option |
325 | 325 | * @access public |
326 | 326 | * @param \EE_Question_Option $QSO EE_Question_Option |
327 | - * @return boolean |
|
327 | + * @return boolean|null |
|
328 | 328 | */ |
329 | 329 | public function add_temp_option( EE_Question_Option $QSO ) { |
330 | 330 | $this->_QST->add_temp_option( $QSO ); |
@@ -336,8 +336,8 @@ discard block |
||
336 | 336 | * set property values for question form input |
337 | 337 | * @access public |
338 | 338 | * @param string $property |
339 | - * @param mixed $value |
|
340 | - * @return mixed |
|
339 | + * @param boolean $value |
|
340 | + * @return boolean|null |
|
341 | 341 | */ |
342 | 342 | public function set( $property = NULL, $value = NULL ) { |
343 | 343 | if ( ! empty( $property ) ) { |
@@ -376,7 +376,7 @@ discard block |
||
376 | 376 | /** |
377 | 377 | * get_meta |
378 | 378 | * @access public |
379 | - * @param mixed $key |
|
379 | + * @param string $key |
|
380 | 380 | * @return mixed |
381 | 381 | */ |
382 | 382 | public function get_meta( $key = FALSE ) { |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
2 | - exit( 'No direct script access allowed' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | 3 | } |
4 | 4 | /** |
5 | 5 | * Event Espresso |
@@ -82,14 +82,14 @@ discard block |
||
82 | 82 | * @access public |
83 | 83 | * @return \EE_Question_Form_Input |
84 | 84 | */ |
85 | - public function __construct( EE_Question $QST = NULL, EE_Answer $ANS = NULL, $q_meta = array() ) { |
|
86 | - if ( empty( $QST ) || empty( $ANS ) ) { |
|
87 | - EE_Error::add_error( __( 'An error occurred. A valid EE_Question or EE_Answer object was not received.', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ ); |
|
85 | + public function __construct(EE_Question $QST = NULL, EE_Answer $ANS = NULL, $q_meta = array()) { |
|
86 | + if (empty($QST) || empty($ANS)) { |
|
87 | + EE_Error::add_error(__('An error occurred. A valid EE_Question or EE_Answer object was not received.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
88 | 88 | return NULL; |
89 | 89 | } |
90 | 90 | $this->_QST = $QST; |
91 | 91 | $this->_ANS = $ANS; |
92 | - $this->set_question_form_input_meta( $q_meta ); |
|
92 | + $this->set_question_form_input_meta($q_meta); |
|
93 | 93 | $this->set_question_form_input_init(); |
94 | 94 | } |
95 | 95 | |
@@ -101,9 +101,9 @@ discard block |
||
101 | 101 | * @param array $q_meta |
102 | 102 | * @return void |
103 | 103 | */ |
104 | - public function set_question_form_input_meta( $q_meta = array() ) { |
|
105 | - $default_q_meta = array( 'att_nmbr' => 1, 'ticket_id' => '', 'date' => '', 'time' => '', 'input_name' => '', 'input_id' => '', 'input_class' => '', 'input_prefix' => 'qstn', 'append_qstn_id' => TRUE, 'htmlentities' => TRUE, 'allow_null' => FALSE ); |
|
106 | - $this->_QST_meta = array_merge( $default_q_meta, $q_meta ); |
|
104 | + public function set_question_form_input_meta($q_meta = array()) { |
|
105 | + $default_q_meta = array('att_nmbr' => 1, 'ticket_id' => '', 'date' => '', 'time' => '', 'input_name' => '', 'input_id' => '', 'input_class' => '', 'input_prefix' => 'qstn', 'append_qstn_id' => TRUE, 'htmlentities' => TRUE, 'allow_null' => FALSE); |
|
106 | + $this->_QST_meta = array_merge($default_q_meta, $q_meta); |
|
107 | 107 | } |
108 | 108 | |
109 | 109 | |
@@ -115,10 +115,10 @@ discard block |
||
115 | 115 | */ |
116 | 116 | public function set_question_form_input_init() { |
117 | 117 | $qstn_id = $this->_QST->system_ID() ? $this->_QST->system_ID() : $this->_QST->ID(); |
118 | - $this->_set_input_name( $qstn_id ); |
|
119 | - $this->_set_input_id( $qstn_id ); |
|
120 | - $this->_set_input_class( $qstn_id ); |
|
121 | - $this->set_question_form_input_answer( $qstn_id ); |
|
118 | + $this->_set_input_name($qstn_id); |
|
119 | + $this->_set_input_id($qstn_id); |
|
120 | + $this->_set_input_class($qstn_id); |
|
121 | + $this->set_question_form_input_answer($qstn_id); |
|
122 | 122 | } |
123 | 123 | |
124 | 124 | |
@@ -129,12 +129,12 @@ discard block |
||
129 | 129 | * @param $qstn_id |
130 | 130 | * @return void |
131 | 131 | */ |
132 | - private function _set_input_name( $qstn_id ) { |
|
133 | - if ( ! empty( $qstn_id ) ) { |
|
134 | - $ANS_ID = $this->get( 'ANS_ID' ); |
|
135 | - $qstn_id = ! empty( $ANS_ID ) ? '[' . $qstn_id . '][' . $ANS_ID . ']' : '[' . $qstn_id . ']'; |
|
132 | + private function _set_input_name($qstn_id) { |
|
133 | + if ( ! empty($qstn_id)) { |
|
134 | + $ANS_ID = $this->get('ANS_ID'); |
|
135 | + $qstn_id = ! empty($ANS_ID) ? '['.$qstn_id.']['.$ANS_ID.']' : '['.$qstn_id.']'; |
|
136 | 136 | } |
137 | - $this->QST_input_name = $this->_QST_meta[ 'append_qstn_id' ] && ! empty( $qstn_id ) ? $this->_QST_meta[ 'input_prefix' ] . $this->_QST_meta[ 'input_name' ] . $qstn_id : $this->_QST_meta[ 'input_prefix' ] . $this->_QST_meta[ 'input_name' ]; |
|
137 | + $this->QST_input_name = $this->_QST_meta['append_qstn_id'] && ! empty($qstn_id) ? $this->_QST_meta['input_prefix'].$this->_QST_meta['input_name'].$qstn_id : $this->_QST_meta['input_prefix'].$this->_QST_meta['input_name']; |
|
138 | 138 | } |
139 | 139 | |
140 | 140 | |
@@ -145,13 +145,13 @@ discard block |
||
145 | 145 | * @param string $property |
146 | 146 | * @return mixed |
147 | 147 | */ |
148 | - public function get( $property = NULL ) { |
|
149 | - if ( ! empty( $property ) ) { |
|
150 | - if ( EEM_Question::instance()->has_field( $property ) ) { |
|
151 | - return $this->_QST->get( $property ); |
|
152 | - } else if ( EEM_Answer::instance()->has_field( $property ) ) { |
|
153 | - return $this->_ANS->get( $property ); |
|
154 | - } else if ( $this->_question_form_input_property_exists( __CLASS__, $property ) ) { |
|
148 | + public function get($property = NULL) { |
|
149 | + if ( ! empty($property)) { |
|
150 | + if (EEM_Question::instance()->has_field($property)) { |
|
151 | + return $this->_QST->get($property); |
|
152 | + } else if (EEM_Answer::instance()->has_field($property)) { |
|
153 | + return $this->_ANS->get($property); |
|
154 | + } else if ($this->_question_form_input_property_exists(__CLASS__, $property)) { |
|
155 | 155 | return $this->{$property}; |
156 | 156 | } |
157 | 157 | } |
@@ -167,13 +167,13 @@ discard block |
||
167 | 167 | * @param string $property |
168 | 168 | * @return boolean |
169 | 169 | */ |
170 | - private function _question_form_input_property_exists( $classname, $property ) { |
|
170 | + private function _question_form_input_property_exists($classname, $property) { |
|
171 | 171 | // first try regular property exists method which works as expected in PHP 5.3+ |
172 | - $prop = EEH_Class_Tools::has_property( $classname, $property ); |
|
173 | - if ( ! $prop ) { |
|
172 | + $prop = EEH_Class_Tools::has_property($classname, $property); |
|
173 | + if ( ! $prop) { |
|
174 | 174 | // use reflection for < PHP 5.3 as a double check when property is not found, possible due to access restriction |
175 | - $reflector = new ReflectionClass( $classname ); |
|
176 | - $prop = $reflector->hasProperty( $property ); |
|
175 | + $reflector = new ReflectionClass($classname); |
|
176 | + $prop = $reflector->hasProperty($property); |
|
177 | 177 | } |
178 | 178 | return $prop; |
179 | 179 | } |
@@ -186,9 +186,9 @@ discard block |
||
186 | 186 | * @param $qstn_id |
187 | 187 | * @return void |
188 | 188 | */ |
189 | - private function _set_input_id( $qstn_id ) { |
|
190 | - $input_id = isset( $this->_QST_meta[ 'input_id' ] ) && ! empty( $this->_QST_meta[ 'input_id' ] ) ? $this->_QST_meta[ 'input_id' ] : sanitize_key( strip_tags( $this->_QST->get( 'QST_display_text' ) ) ); |
|
191 | - $this->QST_input_id = $this->_QST_meta[ 'append_qstn_id' ] && ! empty( $qstn_id ) ? $input_id . '-' . $qstn_id : $input_id; |
|
189 | + private function _set_input_id($qstn_id) { |
|
190 | + $input_id = isset($this->_QST_meta['input_id']) && ! empty($this->_QST_meta['input_id']) ? $this->_QST_meta['input_id'] : sanitize_key(strip_tags($this->_QST->get('QST_display_text'))); |
|
191 | + $this->QST_input_id = $this->_QST_meta['append_qstn_id'] && ! empty($qstn_id) ? $input_id.'-'.$qstn_id : $input_id; |
|
192 | 192 | } |
193 | 193 | |
194 | 194 | |
@@ -199,7 +199,7 @@ discard block |
||
199 | 199 | * @return void |
200 | 200 | */ |
201 | 201 | private function _set_input_class() { |
202 | - $this->QST_input_class = isset( $this->_QST_meta[ 'input_class' ] ) ? $this->_QST_meta[ 'input_class' ] : ''; |
|
202 | + $this->QST_input_class = isset($this->_QST_meta['input_class']) ? $this->_QST_meta['input_class'] : ''; |
|
203 | 203 | } |
204 | 204 | |
205 | 205 | |
@@ -210,12 +210,12 @@ discard block |
||
210 | 210 | * @param mixed int | string $qstn_id |
211 | 211 | * @return void |
212 | 212 | */ |
213 | - public function set_question_form_input_answer( $qstn_id ) { |
|
213 | + public function set_question_form_input_answer($qstn_id) { |
|
214 | 214 | // check for answer in $_REQUEST in case we are reprocessing a form after an error |
215 | - if ( isset( $this->_QST_meta[ 'EVT_ID' ] ) && isset( $this->_QST_meta[ 'att_nmbr' ] ) && isset( $this->_QST_meta[ 'date' ] ) && isset( $this->_QST_meta[ 'time' ] ) && isset( $this->_QST_meta[ 'price_id' ] ) ) { |
|
216 | - if ( isset( $_REQUEST[ 'qstn' ][ $this->_QST_meta[ 'EVT_ID' ] ][ $this->_QST_meta[ 'att_nmbr' ] ][ $this->_QST_meta[ 'date' ] ][ $this->_QST_meta[ 'time' ] ][ $this->_QST_meta[ 'price_id' ] ][ $qstn_id ] ) ) { |
|
217 | - $answer = $_REQUEST[ 'qstn' ][ $this->_QST_meta[ 'EVT_ID' ] ][ $this->_QST_meta[ 'att_nmbr' ] ][ $this->_QST_meta[ 'date' ] ][ $this->_QST_meta[ 'time' ] ][ $this->_QST_meta[ 'price_id' ] ][ $qstn_id ]; |
|
218 | - $this->_ANS->set( 'ANS_value', $answer ); |
|
215 | + if (isset($this->_QST_meta['EVT_ID']) && isset($this->_QST_meta['att_nmbr']) && isset($this->_QST_meta['date']) && isset($this->_QST_meta['time']) && isset($this->_QST_meta['price_id'])) { |
|
216 | + if (isset($_REQUEST['qstn'][$this->_QST_meta['EVT_ID']][$this->_QST_meta['att_nmbr']][$this->_QST_meta['date']][$this->_QST_meta['time']][$this->_QST_meta['price_id']][$qstn_id])) { |
|
217 | + $answer = $_REQUEST['qstn'][$this->_QST_meta['EVT_ID']][$this->_QST_meta['att_nmbr']][$this->_QST_meta['date']][$this->_QST_meta['time']][$this->_QST_meta['price_id']][$qstn_id]; |
|
218 | + $this->_ANS->set('ANS_value', $answer); |
|
219 | 219 | } |
220 | 220 | } |
221 | 221 | } |
@@ -230,40 +230,40 @@ discard block |
||
230 | 230 | * @param array $input_types |
231 | 231 | * @return array |
232 | 232 | */ |
233 | - static function generate_question_form_inputs_for_object( $object = FALSE, $input_types = array() ) { |
|
234 | - if ( ! is_object( $object ) ) { |
|
233 | + static function generate_question_form_inputs_for_object($object = FALSE, $input_types = array()) { |
|
234 | + if ( ! is_object($object)) { |
|
235 | 235 | return FALSE; |
236 | 236 | } |
237 | 237 | $inputs = array(); |
238 | - $fields = $object->get_model()->field_settings( FALSE ); |
|
238 | + $fields = $object->get_model()->field_settings(FALSE); |
|
239 | 239 | // $pk = $object->ID(); <<< NO! |
240 | 240 | // EEH_Debug_Tools::printr( $object, get_class( $object ) . '<br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
241 | 241 | // EEH_Debug_Tools::printr( $fields, '$fields <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
242 | 242 | // EEH_Debug_Tools::printr( $input_types, '$input_types <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
243 | - foreach ( $fields as $field_ID => $field ) { |
|
244 | - if ( $field instanceof EE_Model_Field_Base ) { |
|
243 | + foreach ($fields as $field_ID => $field) { |
|
244 | + if ($field instanceof EE_Model_Field_Base) { |
|
245 | 245 | // echo '<h4>$field_ID : ' . $field_ID . ' <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span></h4>'; |
246 | 246 | // EEH_Debug_Tools::printr( $field, '$field <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
247 | - if ( isset( $input_types[ $field_ID ] ) ) { |
|
247 | + if (isset($input_types[$field_ID])) { |
|
248 | 248 | // get saved value for field |
249 | - $value = $object->get( $field_ID ); |
|
249 | + $value = $object->get($field_ID); |
|
250 | 250 | // echo '<h4>$value : ' . $value . ' <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span></h4>'; |
251 | 251 | // if no saved value, then use default |
252 | 252 | $value = $value !== NULL ? $value : $field->get_default_value(); |
253 | 253 | // if ( $field_ID == 'CNT_active' ) |
254 | 254 | // echo '<h4>$value : ' . $value . ' <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span></h4>'; |
255 | 255 | // determine question type |
256 | - $type = isset( $input_types[ $field_ID ] ) ? $input_types[ $field_ID ][ 'type' ] : 'TEXT'; |
|
256 | + $type = isset($input_types[$field_ID]) ? $input_types[$field_ID]['type'] : 'TEXT'; |
|
257 | 257 | // input name |
258 | - $input_name = isset( $input_types[ $field_ID ] ) && isset( $input_types[ $field_ID ][ 'input_name' ] ) ? $input_types[ $field_ID ][ 'input_name' ] . '[' . $field_ID . ']' : $field_ID; |
|
258 | + $input_name = isset($input_types[$field_ID]) && isset($input_types[$field_ID]['input_name']) ? $input_types[$field_ID]['input_name'].'['.$field_ID.']' : $field_ID; |
|
259 | 259 | // css class for input |
260 | - $class = isset( $input_types[ $field_ID ][ 'class' ] ) && ! empty( $input_types[ $field_ID ][ 'class' ] ) ? ' ' . $input_types[ $field_ID ][ 'class' ] : ''; |
|
260 | + $class = isset($input_types[$field_ID]['class']) && ! empty($input_types[$field_ID]['class']) ? ' '.$input_types[$field_ID]['class'] : ''; |
|
261 | 261 | // whether to apply htmlentities to answer |
262 | - $htmlentities = isset( $input_types[ $field_ID ][ 'htmlentities' ] ) ? $input_types[ $field_ID ][ 'htmlentities' ] : TRUE; |
|
262 | + $htmlentities = isset($input_types[$field_ID]['htmlentities']) ? $input_types[$field_ID]['htmlentities'] : TRUE; |
|
263 | 263 | // whether to apply htmlentities to answer |
264 | - $label_b4 = isset( $input_types[ $field_ID ][ 'label_b4' ] ) ? $input_types[ $field_ID ][ 'label_b4' ] : FALSE; |
|
264 | + $label_b4 = isset($input_types[$field_ID]['label_b4']) ? $input_types[$field_ID]['label_b4'] : FALSE; |
|
265 | 265 | // whether to apply htmlentities to answer |
266 | - $use_desc_4_label = isset( $input_types[ $field_ID ][ 'use_desc_4_label' ] ) ? $input_types[ $field_ID ][ 'use_desc_4_label' ] : FALSE; |
|
266 | + $use_desc_4_label = isset($input_types[$field_ID]['use_desc_4_label']) ? $input_types[$field_ID]['use_desc_4_label'] : FALSE; |
|
267 | 267 | |
268 | 268 | // create EE_Question_Form_Input object |
269 | 269 | $QFI = new EE_Question_Form_Input( |
@@ -283,9 +283,9 @@ discard block |
||
283 | 283 | ) |
284 | 284 | ), |
285 | 285 | array( |
286 | - 'input_id' => $field_ID . '-' . $object->ID(), |
|
286 | + 'input_id' => $field_ID.'-'.$object->ID(), |
|
287 | 287 | 'input_name' => $input_name, |
288 | - 'input_class' => $field_ID . $class, |
|
288 | + 'input_class' => $field_ID.$class, |
|
289 | 289 | 'input_prefix' => '', |
290 | 290 | 'append_qstn_id' => FALSE, |
291 | 291 | 'htmlentities' => $htmlentities, |
@@ -294,21 +294,21 @@ discard block |
||
294 | 294 | ) |
295 | 295 | ); |
296 | 296 | // does question type have options ? |
297 | - if ( in_array( $type, array( 'DROPDOWN', 'RADIO_BTN', 'CHECKBOX' ) ) && isset ( $input_types[ $field_ID ] ) && isset ( $input_types[ $field_ID ][ 'options' ] ) ) { |
|
298 | - foreach ( $input_types[ $field_ID ][ 'options' ] as $option ) { |
|
299 | - $option = stripslashes_deep( $option ); |
|
300 | - $option_id = ! empty( $option[ 'id' ] ) ? $option[ 'id' ] : 0; |
|
301 | - $QSO = EE_Question_Option::new_instance( array( 'QSO_value' => (string)$option_id, 'QSO_desc' => $option[ 'text' ], 'QSO_deleted' => FALSE ) ); |
|
297 | + if (in_array($type, array('DROPDOWN', 'RADIO_BTN', 'CHECKBOX')) && isset ($input_types[$field_ID]) && isset ($input_types[$field_ID]['options'])) { |
|
298 | + foreach ($input_types[$field_ID]['options'] as $option) { |
|
299 | + $option = stripslashes_deep($option); |
|
300 | + $option_id = ! empty($option['id']) ? $option['id'] : 0; |
|
301 | + $QSO = EE_Question_Option::new_instance(array('QSO_value' => (string) $option_id, 'QSO_desc' => $option['text'], 'QSO_deleted' => FALSE)); |
|
302 | 302 | // all QST (and ANS) properties can be accessed indirectly thru QFI |
303 | - $QFI->add_temp_option( $QSO ); |
|
303 | + $QFI->add_temp_option($QSO); |
|
304 | 304 | } |
305 | 305 | } |
306 | 306 | // we don't want ppl manually changing primary keys cuz that would just lead to total craziness man |
307 | - if ( $field_ID == $object->get_model()->primary_key_name() ) { |
|
308 | - $QFI->set( 'QST_disabled', TRUE ); |
|
307 | + if ($field_ID == $object->get_model()->primary_key_name()) { |
|
308 | + $QFI->set('QST_disabled', TRUE); |
|
309 | 309 | } |
310 | 310 | //EEH_Debug_Tools::printr( $QFI, '$QFI <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
311 | - $inputs[ $field_ID ] = $QFI; |
|
311 | + $inputs[$field_ID] = $QFI; |
|
312 | 312 | // if ( $field_ID == 'CNT_active' ) { |
313 | 313 | // EEH_Debug_Tools::printr( $QFI, '$QFI <br /><span style="font-size:10px;font-weight:normal;">' . __FILE__ . '<br />line no: ' . __LINE__ . '</span>', 'auto' ); |
314 | 314 | // } |
@@ -326,8 +326,8 @@ discard block |
||
326 | 326 | * @param \EE_Question_Option $QSO EE_Question_Option |
327 | 327 | * @return boolean |
328 | 328 | */ |
329 | - public function add_temp_option( EE_Question_Option $QSO ) { |
|
330 | - $this->_QST->add_temp_option( $QSO ); |
|
329 | + public function add_temp_option(EE_Question_Option $QSO) { |
|
330 | + $this->_QST->add_temp_option($QSO); |
|
331 | 331 | } |
332 | 332 | |
333 | 333 | |
@@ -339,13 +339,13 @@ discard block |
||
339 | 339 | * @param mixed $value |
340 | 340 | * @return mixed |
341 | 341 | */ |
342 | - public function set( $property = NULL, $value = NULL ) { |
|
343 | - if ( ! empty( $property ) ) { |
|
344 | - if ( EEM_Question::instance()->has_field( $property ) ) { |
|
345 | - $this->_QST->set( $property, $value ); |
|
346 | - } else if ( EEM_Answer::instance()->has_field( $property ) ) { |
|
347 | - $this->_ANS->set( $property, $value ); |
|
348 | - } else if ( $this->_question_form_input_property_exists( __CLASS__, $property ) ) { |
|
342 | + public function set($property = NULL, $value = NULL) { |
|
343 | + if ( ! empty($property)) { |
|
344 | + if (EEM_Question::instance()->has_field($property)) { |
|
345 | + $this->_QST->set($property, $value); |
|
346 | + } else if (EEM_Answer::instance()->has_field($property)) { |
|
347 | + $this->_ANS->set($property, $value); |
|
348 | + } else if ($this->_question_form_input_property_exists(__CLASS__, $property)) { |
|
349 | 349 | echo "<hr>$property is a prop of QFI"; |
350 | 350 | $this->{$property} = $value; |
351 | 351 | return TRUE; |
@@ -366,9 +366,9 @@ discard block |
||
366 | 366 | * whether it was trashed or not. |
367 | 367 | * @return EE_Question_Option |
368 | 368 | */ |
369 | - public function options( $notDeletedOptionsOnly = TRUE, $selected_value_to_always_include = NULL ) { |
|
369 | + public function options($notDeletedOptionsOnly = TRUE, $selected_value_to_always_include = NULL) { |
|
370 | 370 | $temp_options = $this->_QST->temp_options(); |
371 | - return ! empty( $temp_options ) ? $temp_options : $this->_QST->options( $notDeletedOptionsOnly, $selected_value_to_always_include ); |
|
371 | + return ! empty($temp_options) ? $temp_options : $this->_QST->options($notDeletedOptionsOnly, $selected_value_to_always_include); |
|
372 | 372 | } |
373 | 373 | |
374 | 374 | |
@@ -379,8 +379,8 @@ discard block |
||
379 | 379 | * @param mixed $key |
380 | 380 | * @return mixed |
381 | 381 | */ |
382 | - public function get_meta( $key = FALSE ) { |
|
383 | - return $key && isset( $this->_QST_meta[ $key ] ) ? $this->_QST_meta[ $key ] : FALSE; |
|
382 | + public function get_meta($key = FALSE) { |
|
383 | + return $key && isset($this->_QST_meta[$key]) ? $this->_QST_meta[$key] : FALSE; |
|
384 | 384 | } |
385 | 385 | |
386 | 386 |
@@ -117,7 +117,7 @@ discard block |
||
117 | 117 | * @param string $log_type !see the acceptable values of LOG_type in EEM__Change_Log::__construct |
118 | 118 | * @param mixed $message array|string of the message you want to record |
119 | 119 | * @param EE_Base_Class $related_model_obj |
120 | - * @return EE_Change_Log |
|
120 | + * @return EE_Attendee |
|
121 | 121 | */ |
122 | 122 | public function log($log_type,$message,$related_model_obj){ |
123 | 123 | if($related_model_obj instanceof EE_Base_Class){ |
@@ -145,7 +145,7 @@ discard block |
||
145 | 145 | * @param mixed $related_obj_id |
146 | 146 | * @param string $related_obj_type |
147 | 147 | * @throws EE_Error |
148 | - * @return EE_Change_Log |
|
148 | + * @return EE_Attendee |
|
149 | 149 | */ |
150 | 150 | public function gateway_log( $message, $related_obj_id, $related_obj_type ){ |
151 | 151 | if( ! EE_Registry::instance()->is_model_name($related_obj_type)){ |
@@ -1,7 +1,8 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if (!defined('EVENT_ESPRESSO_VERSION')) |
|
3 | +if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
4 | 4 | exit('No direct script access allowed'); |
5 | +} |
|
5 | 6 | |
6 | 7 | /** |
7 | 8 | * Event Espresso |
@@ -99,7 +100,7 @@ discard block |
||
99 | 100 | foreach($models_this_can_attach_to as $model){ |
100 | 101 | if( $model == 'WP_User' ){ |
101 | 102 | $this->_model_relations[ $model ] = new EE_Belongs_To_Relation(); |
102 | - }elseif( $model != 'Change_Log' ) { |
|
103 | + } elseif( $model != 'Change_Log' ) { |
|
103 | 104 | $this->_model_relations[$model] = new EE_Belongs_To_Any_Relation(); |
104 | 105 | } |
105 | 106 | } |
@@ -123,7 +124,7 @@ discard block |
||
123 | 124 | if($related_model_obj instanceof EE_Base_Class){ |
124 | 125 | $obj_id = $related_model_obj->ID(); |
125 | 126 | $obj_type = $related_model_obj->get_model()->get_this_model_name(); |
126 | - }else{ |
|
127 | + } else{ |
|
127 | 128 | $obj_id = NULL; |
128 | 129 | $obj_type = NULL; |
129 | 130 | } |
@@ -174,22 +174,22 @@ |
||
174 | 174 | |
175 | 175 | |
176 | 176 | |
177 | - /** |
|
178 | - * Executes a database query to delete gateway logs. Does not affect model objects, so if you attempt to use |
|
179 | - * models after this, they may be out-of-sync with the database |
|
180 | - * @param DateTime $datetime |
|
181 | - * @return false|int |
|
182 | - */ |
|
177 | + /** |
|
178 | + * Executes a database query to delete gateway logs. Does not affect model objects, so if you attempt to use |
|
179 | + * models after this, they may be out-of-sync with the database |
|
180 | + * @param DateTime $datetime |
|
181 | + * @return false|int |
|
182 | + */ |
|
183 | 183 | public function delete_gateway_logs_older_than(DateTime $datetime ) { |
184 | - global $wpdb; |
|
185 | - return $wpdb->query( |
|
186 | - $wpdb->prepare( |
|
187 | - 'DELETE FROM ' . $this->table() . ' WHERE LOG_type = %s AND LOG_time < %s', |
|
188 | - EEM_Change_Log::type_gateway, |
|
189 | - $datetime->format(EE_Datetime_Field::mysql_timestamp_format) |
|
190 | - ) |
|
191 | - ); |
|
192 | - } |
|
184 | + global $wpdb; |
|
185 | + return $wpdb->query( |
|
186 | + $wpdb->prepare( |
|
187 | + 'DELETE FROM ' . $this->table() . ' WHERE LOG_type = %s AND LOG_time < %s', |
|
188 | + EEM_Change_Log::type_gateway, |
|
189 | + $datetime->format(EE_Datetime_Field::mysql_timestamp_format) |
|
190 | + ) |
|
191 | + ); |
|
192 | + } |
|
193 | 193 | |
194 | 194 | |
195 | 195 | } |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if (!defined('EVENT_ESPRESSO_VERSION')) |
|
3 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) |
|
4 | 4 | exit('No direct script access allowed'); |
5 | 5 | |
6 | 6 | /** |
@@ -25,7 +25,7 @@ discard block |
||
25 | 25 | * |
26 | 26 | * ------------------------------------------------------------------------ |
27 | 27 | */ |
28 | -class EEM_Change_Log extends EEM_Base{ |
|
28 | +class EEM_Change_Log extends EEM_Base { |
|
29 | 29 | |
30 | 30 | /** |
31 | 31 | * the related object was created log type |
@@ -68,19 +68,19 @@ discard block |
||
68 | 68 | * @access protected |
69 | 69 | * @return EEM_Change_Log |
70 | 70 | */ |
71 | - protected function __construct( $timezone = null ){ |
|
71 | + protected function __construct($timezone = null) { |
|
72 | 72 | global $current_user; |
73 | - $this->singular_item = __('Log','event_espresso'); |
|
74 | - $this->plural_item = __('Logs','event_espresso'); |
|
73 | + $this->singular_item = __('Log', 'event_espresso'); |
|
74 | + $this->plural_item = __('Logs', 'event_espresso'); |
|
75 | 75 | $this->_tables = array( |
76 | 76 | 'Log'=> new EE_Primary_Table('esp_log', 'LOG_ID') |
77 | 77 | ); |
78 | 78 | $models_this_can_attach_to = array_keys(EE_Registry::instance()->non_abstract_db_models); |
79 | 79 | $this->_fields = array( |
80 | 80 | 'Log'=>array( |
81 | - 'LOG_ID'=> new EE_Primary_Key_Int_Field('LOG_ID', __('Log ID','event_espresso')), |
|
82 | - 'LOG_time'=>new EE_Datetime_Field('LOG_time', __("Log Time", 'event_espresso'), false, EE_Datetime_Field::now ), |
|
83 | - 'OBJ_ID'=>new EE_Foreign_Key_String_Field('OBJ_ID', __("Object ID (int or string)", 'event_espresso'), true, NULL,$models_this_can_attach_to), |
|
81 | + 'LOG_ID'=> new EE_Primary_Key_Int_Field('LOG_ID', __('Log ID', 'event_espresso')), |
|
82 | + 'LOG_time'=>new EE_Datetime_Field('LOG_time', __("Log Time", 'event_espresso'), false, EE_Datetime_Field::now), |
|
83 | + 'OBJ_ID'=>new EE_Foreign_Key_String_Field('OBJ_ID', __("Object ID (int or string)", 'event_espresso'), true, NULL, $models_this_can_attach_to), |
|
84 | 84 | 'OBJ_type'=>new EE_Any_Foreign_Model_Name_Field('OBJ_type', __("Object Type", 'event_espresso'), true, NULL, $models_this_can_attach_to), |
85 | 85 | 'LOG_type'=>new EE_Enum_Text_Field('LOG_type', __("Type of log entry", "event_espresso"), false, self::type_debug, |
86 | 86 | array( |
@@ -92,24 +92,24 @@ discard block |
||
92 | 92 | self::type_gateway=> __("Gateway Interaction (IPN or Direct Payment)", 'event_espresso'), |
93 | 93 | )), |
94 | 94 | 'LOG_message'=>new EE_Maybe_Serialized_Text_Field('LOG_message', __("Log Message (body)", 'event_espresso'), true), |
95 | - 'LOG_wp_user' => new EE_WP_User_Field('LOG_wp_user', __("User who was logged in while this occurred", 'event_espresso'), true ), |
|
95 | + 'LOG_wp_user' => new EE_WP_User_Field('LOG_wp_user', __("User who was logged in while this occurred", 'event_espresso'), true), |
|
96 | 96 | |
97 | 97 | )); |
98 | 98 | $this->_model_relations = array(); |
99 | - foreach($models_this_can_attach_to as $model){ |
|
100 | - if( $model == 'WP_User' ){ |
|
101 | - $this->_model_relations[ $model ] = new EE_Belongs_To_Relation(); |
|
102 | - }elseif( $model != 'Change_Log' ) { |
|
99 | + foreach ($models_this_can_attach_to as $model) { |
|
100 | + if ($model == 'WP_User') { |
|
101 | + $this->_model_relations[$model] = new EE_Belongs_To_Relation(); |
|
102 | + }elseif ($model != 'Change_Log') { |
|
103 | 103 | $this->_model_relations[$model] = new EE_Belongs_To_Any_Relation(); |
104 | 104 | } |
105 | 105 | } |
106 | 106 | //use completely custom caps for this |
107 | 107 | $this->_cap_restriction_generators = false; |
108 | 108 | //caps-wise this is all-or-nothing: if you have the default role you can access anything, otherwise nothing |
109 | - foreach( $this->_cap_contexts_to_cap_action_map as $cap_context => $action ) { |
|
110 | - $this->_cap_restrictions[ $cap_context ][ EE_Restriction_Generator_Base::get_default_restrictions_cap() ] = new EE_Return_None_Where_Conditions(); |
|
109 | + foreach ($this->_cap_contexts_to_cap_action_map as $cap_context => $action) { |
|
110 | + $this->_cap_restrictions[$cap_context][EE_Restriction_Generator_Base::get_default_restrictions_cap()] = new EE_Return_None_Where_Conditions(); |
|
111 | 111 | } |
112 | - parent::__construct( $timezone ); |
|
112 | + parent::__construct($timezone); |
|
113 | 113 | } |
114 | 114 | |
115 | 115 | /** |
@@ -119,11 +119,11 @@ discard block |
||
119 | 119 | * @param EE_Base_Class $related_model_obj |
120 | 120 | * @return EE_Change_Log |
121 | 121 | */ |
122 | - public function log($log_type,$message,$related_model_obj){ |
|
123 | - if($related_model_obj instanceof EE_Base_Class){ |
|
122 | + public function log($log_type, $message, $related_model_obj) { |
|
123 | + if ($related_model_obj instanceof EE_Base_Class) { |
|
124 | 124 | $obj_id = $related_model_obj->ID(); |
125 | 125 | $obj_type = $related_model_obj->get_model()->get_this_model_name(); |
126 | - }else{ |
|
126 | + } else { |
|
127 | 127 | $obj_id = NULL; |
128 | 128 | $obj_type = NULL; |
129 | 129 | } |
@@ -147,9 +147,9 @@ discard block |
||
147 | 147 | * @throws EE_Error |
148 | 148 | * @return EE_Change_Log |
149 | 149 | */ |
150 | - public function gateway_log( $message, $related_obj_id, $related_obj_type ){ |
|
151 | - if( ! EE_Registry::instance()->is_model_name($related_obj_type)){ |
|
152 | - throw new EE_Error(sprintf(__("'%s' is not a model name. A model name must be provided when making a gateway log. Eg, 'Payment', 'Payment_Method', etc", "event_espresso"),$related_obj_type)); |
|
150 | + public function gateway_log($message, $related_obj_id, $related_obj_type) { |
|
151 | + if ( ! EE_Registry::instance()->is_model_name($related_obj_type)) { |
|
152 | + throw new EE_Error(sprintf(__("'%s' is not a model name. A model name must be provided when making a gateway log. Eg, 'Payment', 'Payment_Method', etc", "event_espresso"), $related_obj_type)); |
|
153 | 153 | } |
154 | 154 | $log = EE_Change_Log::new_instance(array( |
155 | 155 | 'LOG_type'=>EEM_Change_Log::type_gateway, |
@@ -168,7 +168,7 @@ discard block |
||
168 | 168 | * @param array $query_params @see EEM_Base::get_all |
169 | 169 | * @return array of arrays |
170 | 170 | */ |
171 | - public function get_all_efficiently($query_params){ |
|
171 | + public function get_all_efficiently($query_params) { |
|
172 | 172 | return $this->_get_all_wpdb_results($query_params); |
173 | 173 | } |
174 | 174 | |
@@ -180,11 +180,11 @@ discard block |
||
180 | 180 | * @param DateTime $datetime |
181 | 181 | * @return false|int |
182 | 182 | */ |
183 | - public function delete_gateway_logs_older_than(DateTime $datetime ) { |
|
183 | + public function delete_gateway_logs_older_than(DateTime $datetime) { |
|
184 | 184 | global $wpdb; |
185 | 185 | return $wpdb->query( |
186 | 186 | $wpdb->prepare( |
187 | - 'DELETE FROM ' . $this->table() . ' WHERE LOG_type = %s AND LOG_time < %s', |
|
187 | + 'DELETE FROM '.$this->table().' WHERE LOG_type = %s AND LOG_time < %s', |
|
188 | 188 | EEM_Change_Log::type_gateway, |
189 | 189 | $datetime->format(EE_Datetime_Field::mysql_timestamp_format) |
190 | 190 | ) |
@@ -43,7 +43,7 @@ discard block |
||
43 | 43 | /** |
44 | 44 | * return an array of Base types. Keys are INTs which are used in the database, |
45 | 45 | * values are text-representations of the base type. |
46 | - * @return array |
|
46 | + * @return integer |
|
47 | 47 | */ |
48 | 48 | public function get_base_types(){ |
49 | 49 | return $this->base_types; |
@@ -121,7 +121,7 @@ discard block |
||
121 | 121 | * instantiate a new price type object with blank/empty properties |
122 | 122 | * |
123 | 123 | * @access public |
124 | - * @return mixed array on success, FALSE on fail |
|
124 | + * @return EE_Price_Type array on success, FALSE on fail |
|
125 | 125 | */ |
126 | 126 | public function get_new_price_type() { |
127 | 127 | return EE_Price_Type::new_instance(); |
@@ -33,11 +33,11 @@ discard block |
||
33 | 33 | public $type = NULL; |
34 | 34 | |
35 | 35 | /** |
36 | - * Price Base types |
|
37 | - * |
|
38 | - * @access private |
|
39 | - * @var int |
|
40 | - */ |
|
36 | + * Price Base types |
|
37 | + * |
|
38 | + * @access private |
|
39 | + * @var int |
|
40 | + */ |
|
41 | 41 | public $base_types = null; |
42 | 42 | |
43 | 43 | /** |
@@ -144,8 +144,8 @@ discard block |
||
144 | 144 | * |
145 | 145 | * @param type $query_params |
146 | 146 | * @param boolean $allow_blocking if TRUE, matched objects will only be deleted if there is no related model info |
147 | - * that blocks it (ie, there' sno other data that depends on this data); if false, deletes regardless of other objects |
|
148 | - * which may depend on it. Its generally advisable to always leave this as TRUE, otherwise you could easily corrupt your DB |
|
147 | + * that blocks it (ie, there' sno other data that depends on this data); if false, deletes regardless of other objects |
|
148 | + * which may depend on it. Its generally advisable to always leave this as TRUE, otherwise you could easily corrupt your DB |
|
149 | 149 | * @return boolean |
150 | 150 | */ |
151 | 151 | public function delete_permanently($query_params = array(), $allow_blocking = true) { |
@@ -21,8 +21,8 @@ discard block |
||
21 | 21 | * |
22 | 22 | * ------------------------------------------------------------------------ |
23 | 23 | */ |
24 | -require_once ( EE_MODELS . 'EEM_Soft_Delete_Base.model.php' ); |
|
25 | -require_once ( EE_CLASSES . 'EE_Price_Type.class.php' ); |
|
24 | +require_once (EE_MODELS.'EEM_Soft_Delete_Base.model.php'); |
|
25 | +require_once (EE_CLASSES.'EE_Price_Type.class.php'); |
|
26 | 26 | |
27 | 27 | |
28 | 28 | class EEM_Price_Type extends EEM_Soft_Delete_Base { |
@@ -45,7 +45,7 @@ discard block |
||
45 | 45 | * values are text-representations of the base type. |
46 | 46 | * @return array |
47 | 47 | */ |
48 | - public function get_base_types(){ |
|
48 | + public function get_base_types() { |
|
49 | 49 | return $this->base_types; |
50 | 50 | } |
51 | 51 | |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | * @param type $base_type_int |
55 | 55 | * @return type |
56 | 56 | */ |
57 | - public function get_base_type_name($base_type_int){ |
|
57 | + public function get_base_type_name($base_type_int) { |
|
58 | 58 | return $this->base_types[$base_type_int]; |
59 | 59 | } |
60 | 60 | |
@@ -79,27 +79,27 @@ discard block |
||
79 | 79 | * @access protected |
80 | 80 | * @return void |
81 | 81 | */ |
82 | - protected function __construct( $timezone = NULL ) { |
|
82 | + protected function __construct($timezone = NULL) { |
|
83 | 83 | $this->base_types = array( |
84 | - EEM_Price_Type::base_type_base_price => __('Price','event_espresso'), |
|
85 | - EEM_Price_Type::base_type_discount => __('Discount','event_espresso'), |
|
86 | - EEM_Price_Type::base_type_surcharge => __('Surcharge','event_espresso'), |
|
87 | - EEM_Price_Type::base_type_tax => __('Tax','event_espresso') ); |
|
88 | - $this->singular_item = __('Price Type','event_espresso'); |
|
89 | - $this->plural_item = __('Price Types','event_espresso'); |
|
84 | + EEM_Price_Type::base_type_base_price => __('Price', 'event_espresso'), |
|
85 | + EEM_Price_Type::base_type_discount => __('Discount', 'event_espresso'), |
|
86 | + EEM_Price_Type::base_type_surcharge => __('Surcharge', 'event_espresso'), |
|
87 | + EEM_Price_Type::base_type_tax => __('Tax', 'event_espresso') ); |
|
88 | + $this->singular_item = __('Price Type', 'event_espresso'); |
|
89 | + $this->plural_item = __('Price Types', 'event_espresso'); |
|
90 | 90 | |
91 | 91 | $this->_tables = array( |
92 | - 'Price_Type'=>new EE_Primary_Table('esp_price_type','PRT_ID') |
|
92 | + 'Price_Type'=>new EE_Primary_Table('esp_price_type', 'PRT_ID') |
|
93 | 93 | ); |
94 | 94 | $this->_fields = array( |
95 | 95 | 'Price_Type'=>array( |
96 | - 'PRT_ID'=>new EE_Primary_Key_Int_Field('PRT_ID', __('Price Type ID','event_espresso')), |
|
97 | - 'PRT_name'=>new EE_Plain_Text_Field('PRT_name', __('Price Type Name','event_espresso'), false, ''), |
|
98 | - 'PBT_ID'=>new EE_Enum_Integer_Field('PBT_ID', __('Price Base type ID, 1 = Price , 2 = Discount , 3 = Surcharge , 4 = Tax','event_espresso'), false, EEM_Price_Type::base_type_base_price, $this->base_types), |
|
99 | - 'PRT_is_percent'=>new EE_Boolean_Field('PRT_is_percent', __('Flag indicating price is a percentage','event_espresso'), false, false), |
|
100 | - 'PRT_order'=>new EE_Integer_Field('PRT_order', __('Order in which price should be applied. ','event_espresso'), false, 0), |
|
101 | - 'PRT_deleted'=>new EE_Trashed_Flag_Field('PRT_deleted', __('Flag indicating price type has been trashed','event_espresso'), false, false), |
|
102 | - 'PRT_wp_user' => new EE_WP_User_Field('PRT_wp_user', __('Price Type Creator ID', 'event_espresso'), FALSE ), |
|
96 | + 'PRT_ID'=>new EE_Primary_Key_Int_Field('PRT_ID', __('Price Type ID', 'event_espresso')), |
|
97 | + 'PRT_name'=>new EE_Plain_Text_Field('PRT_name', __('Price Type Name', 'event_espresso'), false, ''), |
|
98 | + 'PBT_ID'=>new EE_Enum_Integer_Field('PBT_ID', __('Price Base type ID, 1 = Price , 2 = Discount , 3 = Surcharge , 4 = Tax', 'event_espresso'), false, EEM_Price_Type::base_type_base_price, $this->base_types), |
|
99 | + 'PRT_is_percent'=>new EE_Boolean_Field('PRT_is_percent', __('Flag indicating price is a percentage', 'event_espresso'), false, false), |
|
100 | + 'PRT_order'=>new EE_Integer_Field('PRT_order', __('Order in which price should be applied. ', 'event_espresso'), false, 0), |
|
101 | + 'PRT_deleted'=>new EE_Trashed_Flag_Field('PRT_deleted', __('Flag indicating price type has been trashed', 'event_espresso'), false, false), |
|
102 | + 'PRT_wp_user' => new EE_WP_User_Field('PRT_wp_user', __('Price Type Creator ID', 'event_espresso'), FALSE), |
|
103 | 103 | ) |
104 | 104 | ); |
105 | 105 | $this->_model_relations = array( |
@@ -107,10 +107,10 @@ discard block |
||
107 | 107 | 'WP_User' => new EE_Belongs_To_Relation(), |
108 | 108 | ); |
109 | 109 | //this model is generally available for reading |
110 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = new EE_Restriction_Generator_Public(); |
|
110 | + $this->_cap_restriction_generators[EEM_Base::caps_read] = new EE_Restriction_Generator_Public(); |
|
111 | 111 | //all price types are "default" in terms of capability names |
112 | 112 | $this->_caps_slug = 'default_price_types'; |
113 | - parent::__construct( $timezone ); |
|
113 | + parent::__construct($timezone); |
|
114 | 114 | |
115 | 115 | } |
116 | 116 | |
@@ -156,15 +156,15 @@ discard block |
||
156 | 156 | $ID = $query_params[0][$this->get_primary_key_field()->get_name()]; |
157 | 157 | |
158 | 158 | //check if any prices use this price type |
159 | - $prc_query_params = array(array('PRT_ID'=>array('IN',$would_be_deleted_price_type_ids))); |
|
160 | - if ( $prices = $this->get_all_related($ID,'Price',$prc_query_params)) { |
|
159 | + $prc_query_params = array(array('PRT_ID'=>array('IN', $would_be_deleted_price_type_ids))); |
|
160 | + if ($prices = $this->get_all_related($ID, 'Price', $prc_query_params)) { |
|
161 | 161 | $prices_names_and_ids = array(); |
162 | - foreach($prices as $price){ |
|
162 | + foreach ($prices as $price) { |
|
163 | 163 | /* @var $price EE_Price */ |
164 | 164 | $prices_names_and_ids[] = $price->name()."(".$price->ID().")"; |
165 | 165 | } |
166 | - $msg = sprintf(__('The Price Type(s) could not be deleted because there are existing Prices that currently use this Price Type. If you still wish to delete this Price Type, then either delete those Prices or change them to use other Price Types.The prices are: %s', 'event_espresso'),implode(",",$prices_names_and_ids)); |
|
167 | - EE_Error::add_error( $msg, __FILE__, __FUNCTION__, __LINE__ ); |
|
166 | + $msg = sprintf(__('The Price Type(s) could not be deleted because there are existing Prices that currently use this Price Type. If you still wish to delete this Price Type, then either delete those Prices or change them to use other Price Types.The prices are: %s', 'event_espresso'), implode(",", $prices_names_and_ids)); |
|
167 | + EE_Error::add_error($msg, __FILE__, __FUNCTION__, __LINE__); |
|
168 | 168 | return FALSE; |
169 | 169 | } |
170 | 170 |
@@ -1,4 +1,6 @@ |
||
1 | -<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | +} |
|
2 | 4 | /** |
3 | 5 | * Event Espresso |
4 | 6 | * |
@@ -165,7 +165,7 @@ |
||
165 | 165 | * |
166 | 166 | * @access public |
167 | 167 | * @param $STA_ID |
168 | - * @return mixed array on success, FALSE on fail |
|
168 | + * @return boolean array on success, FALSE on fail |
|
169 | 169 | */ |
170 | 170 | public function delete_by_ID( $STA_ID = FALSE ) { |
171 | 171 |
@@ -64,11 +64,11 @@ discard block |
||
64 | 64 | |
65 | 65 | |
66 | 66 | /** |
67 | - * reset_cached_states |
|
68 | - * |
|
69 | - * @access private |
|
70 | - * @return void |
|
71 | - */ |
|
67 | + * reset_cached_states |
|
68 | + * |
|
69 | + * @access private |
|
70 | + * @return void |
|
71 | + */ |
|
72 | 72 | public function reset_cached_states() { |
73 | 73 | EEM_State::$_active_states = array(); |
74 | 74 | EEM_State::$_all_states = array(); |
@@ -78,11 +78,11 @@ discard block |
||
78 | 78 | |
79 | 79 | |
80 | 80 | /** |
81 | - * _get_states |
|
82 | - * |
|
83 | - * @access private |
|
84 | - * @return array |
|
85 | - */ |
|
81 | + * _get_states |
|
82 | + * |
|
83 | + * @access private |
|
84 | + * @return array |
|
85 | + */ |
|
86 | 86 | public function get_all_states() { |
87 | 87 | if ( ! self::$_all_states ) { |
88 | 88 | self::$_all_states = $this->get_all( array( 'order_by'=>array( 'STA_name'=>'ASC' ), 'limit'=> array( 0, 99999 ))); |
@@ -161,12 +161,12 @@ discard block |
||
161 | 161 | |
162 | 162 | |
163 | 163 | /** |
164 | - * delete a single state from db via their ID |
|
165 | - * |
|
166 | - * @access public |
|
167 | - * @param $STA_ID |
|
168 | - * @return mixed array on success, FALSE on fail |
|
169 | - */ |
|
164 | + * delete a single state from db via their ID |
|
165 | + * |
|
166 | + * @access public |
|
167 | + * @param $STA_ID |
|
168 | + * @return mixed array on success, FALSE on fail |
|
169 | + */ |
|
170 | 170 | public function delete_by_ID( $STA_ID = FALSE ) { |
171 | 171 | |
172 | 172 | if ( ! $STA_ID ) { |
@@ -21,8 +21,8 @@ discard block |
||
21 | 21 | * |
22 | 22 | * ------------------------------------------------------------------------ |
23 | 23 | */ |
24 | -require_once ( EE_MODELS . 'EEM_Base.model.php' ); |
|
25 | -require_once ( EE_CLASSES . 'EE_State.class.php' ); |
|
24 | +require_once (EE_MODELS.'EEM_Base.model.php'); |
|
25 | +require_once (EE_CLASSES.'EE_State.class.php'); |
|
26 | 26 | |
27 | 27 | class EEM_State extends EEM_Base { |
28 | 28 | |
@@ -33,9 +33,9 @@ discard block |
||
33 | 33 | // array of all active states |
34 | 34 | private static $_active_states = FALSE; |
35 | 35 | |
36 | - protected function __construct( $timezone = NULL ) { |
|
37 | - $this->singular_item = __('State/Province','event_espresso'); |
|
38 | - $this->plural_item = __('States/Provinces','event_espresso'); |
|
36 | + protected function __construct($timezone = NULL) { |
|
37 | + $this->singular_item = __('State/Province', 'event_espresso'); |
|
38 | + $this->plural_item = __('States/Provinces', 'event_espresso'); |
|
39 | 39 | |
40 | 40 | $this->_tables = array( |
41 | 41 | 'State'=> new EE_Primary_Table('esp_state', 'STA_ID') |
@@ -43,10 +43,10 @@ discard block |
||
43 | 43 | |
44 | 44 | $this->_fields = array( |
45 | 45 | 'State'=>array( |
46 | - 'STA_ID'=> new EE_Primary_Key_Int_Field('STA_ID', __('State ID','event_espresso')), |
|
47 | - 'CNT_ISO'=> new EE_Foreign_Key_String_Field('CNT_ISO', __('Country ISO Code','event_espresso'), false, NULL, 'Country'), |
|
48 | - 'STA_abbrev' => new EE_Plain_Text_Field('STA_abbrev', __('State Abbreviation','event_espresso'), false, ''), |
|
49 | - 'STA_name' => new EE_Plain_Text_Field('STA_name', __('State Name','event_espresso'), false, ''), |
|
46 | + 'STA_ID'=> new EE_Primary_Key_Int_Field('STA_ID', __('State ID', 'event_espresso')), |
|
47 | + 'CNT_ISO'=> new EE_Foreign_Key_String_Field('CNT_ISO', __('Country ISO Code', 'event_espresso'), false, NULL, 'Country'), |
|
48 | + 'STA_abbrev' => new EE_Plain_Text_Field('STA_abbrev', __('State Abbreviation', 'event_espresso'), false, ''), |
|
49 | + 'STA_name' => new EE_Plain_Text_Field('STA_name', __('State Name', 'event_espresso'), false, ''), |
|
50 | 50 | 'STA_active'=> new EE_Boolean_Field('STA_active', __('State Active Flag', 'event_espresso'), false, false) |
51 | 51 | )); |
52 | 52 | $this->_model_relations = array( |
@@ -55,9 +55,9 @@ discard block |
||
55 | 55 | 'Venue'=>new EE_Has_Many_Relation(), |
56 | 56 | ); |
57 | 57 | //this model is generally available for reading |
58 | - $this->_cap_restriction_generators[ EEM_Base::caps_read ] = new EE_Restriction_Generator_Public(); |
|
58 | + $this->_cap_restriction_generators[EEM_Base::caps_read] = new EE_Restriction_Generator_Public(); |
|
59 | 59 | //@todo: only show STA_active |
60 | - parent::__construct( $timezone ); |
|
60 | + parent::__construct($timezone); |
|
61 | 61 | } |
62 | 62 | |
63 | 63 | |
@@ -84,8 +84,8 @@ discard block |
||
84 | 84 | * @return array |
85 | 85 | */ |
86 | 86 | public function get_all_states() { |
87 | - if ( ! self::$_all_states ) { |
|
88 | - self::$_all_states = $this->get_all( array( 'order_by'=>array( 'STA_name'=>'ASC' ), 'limit'=> array( 0, 99999 ))); |
|
87 | + if ( ! self::$_all_states) { |
|
88 | + self::$_all_states = $this->get_all(array('order_by'=>array('STA_name'=>'ASC'), 'limit'=> array(0, 99999))); |
|
89 | 89 | } |
90 | 90 | return self::$_all_states; |
91 | 91 | } |
@@ -100,14 +100,14 @@ discard block |
||
100 | 100 | * @param bool $flush_cache |
101 | 101 | * @return array |
102 | 102 | */ |
103 | - public function get_all_active_states( $countries = array(), $flush_cache = FALSE ) { |
|
104 | - if ( ! self::$_active_states || $flush_cache ) { |
|
105 | - $countries = is_array( $countries ) && ! empty( $countries ) ? $countries : EEM_Country::instance()->get_all_active_countries(); |
|
106 | - self::$_active_states = $this->get_all( array( |
|
107 | - array( 'STA_active' => TRUE, 'CNT_ISO' => array( 'IN', array_keys( $countries ))), |
|
108 | - 'order_by' => array( 'STA_name'=>'ASC' ), |
|
109 | - 'limit' => array( 0, 99999 ), |
|
110 | - 'force_join' => array( 'Country' ) |
|
103 | + public function get_all_active_states($countries = array(), $flush_cache = FALSE) { |
|
104 | + if ( ! self::$_active_states || $flush_cache) { |
|
105 | + $countries = is_array($countries) && ! empty($countries) ? $countries : EEM_Country::instance()->get_all_active_countries(); |
|
106 | + self::$_active_states = $this->get_all(array( |
|
107 | + array('STA_active' => TRUE, 'CNT_ISO' => array('IN', array_keys($countries))), |
|
108 | + 'order_by' => array('STA_name'=>'ASC'), |
|
109 | + 'limit' => array(0, 99999), |
|
110 | + 'force_join' => array('Country') |
|
111 | 111 | )); |
112 | 112 | } |
113 | 113 | return self::$_active_states; |
@@ -119,8 +119,8 @@ discard block |
||
119 | 119 | * get_all_states_of_active_countries |
120 | 120 | * @return array |
121 | 121 | */ |
122 | - public function get_all_states_of_active_countries(){ |
|
123 | - if ( $states = $this->get_all( array( array( 'Country.CNT_active' => TRUE, 'STA_active' => TRUE ), 'order_by' => array( 'Country.CNT_name' => 'ASC', 'STA_name' => 'ASC' )))) { |
|
122 | + public function get_all_states_of_active_countries() { |
|
123 | + if ($states = $this->get_all(array(array('Country.CNT_active' => TRUE, 'STA_active' => TRUE), 'order_by' => array('Country.CNT_name' => 'ASC', 'STA_name' => 'ASC')))) { |
|
124 | 124 | return $states; |
125 | 125 | } |
126 | 126 | return FALSE; |
@@ -132,11 +132,11 @@ discard block |
||
132 | 132 | * get_all_states_of_active_countries |
133 | 133 | * @return array |
134 | 134 | */ |
135 | - public function get_all_active_states_for_these_countries( $countries ){ |
|
136 | - if ( ! $countries ) { |
|
135 | + public function get_all_active_states_for_these_countries($countries) { |
|
136 | + if ( ! $countries) { |
|
137 | 137 | return FALSE; |
138 | 138 | } |
139 | - if ( $states = $this->get_all( array( array( 'Country.CNT_ISO' => array( 'IN', array_keys( $countries )), 'STA_active' => TRUE ), 'order_by' => array( 'Country.CNT_name' => 'ASC', 'STA_name' => 'ASC' )))) { |
|
139 | + if ($states = $this->get_all(array(array('Country.CNT_ISO' => array('IN', array_keys($countries)), 'STA_active' => TRUE), 'order_by' => array('Country.CNT_name' => 'ASC', 'STA_name' => 'ASC')))) { |
|
140 | 140 | return $states; |
141 | 141 | } |
142 | 142 | return FALSE; |
@@ -148,11 +148,11 @@ discard block |
||
148 | 148 | * get_all_states_of_active_countries |
149 | 149 | * @return array |
150 | 150 | */ |
151 | - public function get_all_states_for_these_countries( $countries ){ |
|
152 | - if ( ! $countries ) { |
|
151 | + public function get_all_states_for_these_countries($countries) { |
|
152 | + if ( ! $countries) { |
|
153 | 153 | return FALSE; |
154 | 154 | } |
155 | - if ( $states = $this->get_all( array( array( 'Country.CNT_ISO' => array( 'IN', array_keys( $countries ))), 'order_by' => array( 'Country.CNT_name' => 'ASC', 'STA_name' => 'ASC' )))) { |
|
155 | + if ($states = $this->get_all(array(array('Country.CNT_ISO' => array('IN', array_keys($countries))), 'order_by' => array('Country.CNT_name' => 'ASC', 'STA_name' => 'ASC')))) { |
|
156 | 156 | return $states; |
157 | 157 | } |
158 | 158 | return FALSE; |
@@ -167,15 +167,15 @@ discard block |
||
167 | 167 | * @param $STA_ID |
168 | 168 | * @return mixed array on success, FALSE on fail |
169 | 169 | */ |
170 | - public function delete_by_ID( $STA_ID = FALSE ) { |
|
170 | + public function delete_by_ID($STA_ID = FALSE) { |
|
171 | 171 | |
172 | - if ( ! $STA_ID ) { |
|
172 | + if ( ! $STA_ID) { |
|
173 | 173 | return FALSE; |
174 | 174 | } |
175 | 175 | |
176 | 176 | // retrieve a particular transaction |
177 | - $where_cols_n_values = array( array( 'STA_ID' => $STA_ID )); |
|
178 | - if ( $answer = $this->delete ( $where_cols_n_values )) { |
|
177 | + $where_cols_n_values = array(array('STA_ID' => $STA_ID)); |
|
178 | + if ($answer = $this->delete($where_cols_n_values)) { |
|
179 | 179 | return TRUE; |
180 | 180 | } else { |
181 | 181 | return FALSE; |
@@ -188,15 +188,15 @@ discard block |
||
188 | 188 | * @param string $state_ID |
189 | 189 | * @return string |
190 | 190 | */ |
191 | - public function get_state_name_by_ID( $state_ID ){ |
|
192 | - if( isset( self::$_all_states[ $state_ID ] ) && |
|
193 | - self::$_all_states[ $state_ID ] instanceof EE_State ){ |
|
194 | - return self::$_all_states[ $state_ID ]->name(); |
|
191 | + public function get_state_name_by_ID($state_ID) { |
|
192 | + if (isset(self::$_all_states[$state_ID]) && |
|
193 | + self::$_all_states[$state_ID] instanceof EE_State) { |
|
194 | + return self::$_all_states[$state_ID]->name(); |
|
195 | 195 | } |
196 | - $names = $this->get_col( array( array( 'STA_ID' => $state_ID ), 'limit' => 1), 'STA_name' ); |
|
197 | - if( is_array( $names ) && ! empty( $names ) ){ |
|
198 | - return reset( $names ); |
|
199 | - }else{ |
|
196 | + $names = $this->get_col(array(array('STA_ID' => $state_ID), 'limit' => 1), 'STA_name'); |
|
197 | + if (is_array($names) && ! empty($names)) { |
|
198 | + return reset($names); |
|
199 | + } else { |
|
200 | 200 | return ''; |
201 | 201 | } |
202 | 202 | } |
@@ -1,4 +1,6 @@ discard block |
||
1 | -<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | +} |
|
2 | 4 | /** |
3 | 5 | * Event Espresso |
4 | 6 | * |
@@ -196,7 +198,7 @@ discard block |
||
196 | 198 | $names = $this->get_col( array( array( 'STA_ID' => $state_ID ), 'limit' => 1), 'STA_name' ); |
197 | 199 | if( is_array( $names ) && ! empty( $names ) ){ |
198 | 200 | return reset( $names ); |
199 | - }else{ |
|
201 | + } else{ |
|
200 | 202 | return ''; |
201 | 203 | } |
202 | 204 | } |