@@ -245,7 +245,6 @@ |
||
245 | 245 | /** |
246 | 246 | * Creates a 4.1 member price discount |
247 | 247 | * @global type $wpdb |
248 | - * @param type $old_price |
|
249 | 248 | * @return int |
250 | 249 | */ |
251 | 250 | private function _insert_new_global_surcharge_price($org_options){ |
@@ -191,7 +191,7 @@ |
||
191 | 191 | $c->organization->logo_url = $value;break; |
192 | 192 | case 'event_page_id': |
193 | 193 | |
194 | - //also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS |
|
194 | + //also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS |
|
195 | 195 | //to ESPRESSO_THANK_YOU |
196 | 196 | $reg_page_post = get_post($value); |
197 | 197 | $reg_page_post->post_content = str_replace("[ESPRESSO_EVENTS]","[ESPRESSO_CHECKOUT]",$reg_page_post->post_content); |
@@ -100,30 +100,30 @@ discard block |
||
100 | 100 | * |
101 | 101 | * @todo: inform clients that messages have COMPLETELY changed in 4.1; themeroller isn't in there; event list page is no more; |
102 | 102 | */ |
103 | -class EE_DMS_4_1_0_org_options extends EE_Data_Migration_Script_Stage{ |
|
103 | +class EE_DMS_4_1_0_org_options extends EE_Data_Migration_Script_Stage { |
|
104 | 104 | |
105 | - function _migration_step($num_items=50){ |
|
105 | + function _migration_step($num_items = 50) { |
|
106 | 106 | |
107 | 107 | $items_actually_migrated = 0; |
108 | 108 | $old_org_options = get_option('events_organization_settings'); |
109 | - foreach($this->_org_options_we_know_how_to_migrate as $option_name){ |
|
109 | + foreach ($this->_org_options_we_know_how_to_migrate as $option_name) { |
|
110 | 110 | //only bother migrating if there's a setting to migrate. Otherwise we'll just use the default |
111 | - if(isset($old_org_options[$option_name])){ |
|
111 | + if (isset($old_org_options[$option_name])) { |
|
112 | 112 | $this->_handle_org_option($option_name, $old_org_options[$option_name]); |
113 | 113 | } |
114 | - if($option_name=='surcharge'){ |
|
114 | + if ($option_name == 'surcharge') { |
|
115 | 115 | $this->_insert_new_global_surcharge_price($old_org_options); |
116 | 116 | } |
117 | 117 | $items_actually_migrated++; |
118 | 118 | } |
119 | 119 | |
120 | - $success = EE_Config::instance()->update_espresso_config(FALSE,TRUE); |
|
121 | - if( ! $success ) { |
|
122 | - $this->add_error( sprintf( __( 'Could not save EE Config during org options stage. Reason: %s', 'event_espresso' ), EE_Error::get_notices( FALSE )) ); |
|
120 | + $success = EE_Config::instance()->update_espresso_config(FALSE, TRUE); |
|
121 | + if ( ! $success) { |
|
122 | + $this->add_error(sprintf(__('Could not save EE Config during org options stage. Reason: %s', 'event_espresso'), EE_Error::get_notices(FALSE))); |
|
123 | 123 | EE_Error::overwrite_errors(); |
124 | 124 | } |
125 | - EE_Network_Config::instance()->update_config(FALSE,FALSE); |
|
126 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
125 | + EE_Network_Config::instance()->update_config(FALSE, FALSE); |
|
126 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
127 | 127 | //we may have added new pages and this might be necessary |
128 | 128 | flush_rewrite_rules(); |
129 | 129 | $this->set_completed(); |
@@ -136,65 +136,65 @@ discard block |
||
136 | 136 | } |
137 | 137 | function __construct() { |
138 | 138 | $this->_pretty_name = __("Organization Options/Config", "event_espresso"); |
139 | - $this->_org_options_we_know_how_to_migrate = apply_filters( 'FHEE__EE_DMS_4_1_0_org_options__org_options_we_know_how_to_migrate',$this->_org_options_we_know_how_to_migrate ); |
|
139 | + $this->_org_options_we_know_how_to_migrate = apply_filters('FHEE__EE_DMS_4_1_0_org_options__org_options_we_know_how_to_migrate', $this->_org_options_we_know_how_to_migrate); |
|
140 | 140 | parent::__construct(); |
141 | 141 | } |
142 | 142 | |
143 | - private function _handle_org_option($option_name,$value){ |
|
143 | + private function _handle_org_option($option_name, $value) { |
|
144 | 144 | $c = EE_Config::instance(); |
145 | 145 | $cn = EE_Network_Config::instance(); |
146 | - switch($option_name){ |
|
146 | + switch ($option_name) { |
|
147 | 147 | case 'organization': |
148 | - $c->organization->name = $value;break; |
|
148 | + $c->organization->name = $value; break; |
|
149 | 149 | case 'organization_street1': |
150 | - $c->organization->address_1 = $value;break; |
|
150 | + $c->organization->address_1 = $value; break; |
|
151 | 151 | case 'organization_street2': |
152 | - $c->organization->address_2 = $value;break; |
|
152 | + $c->organization->address_2 = $value; break; |
|
153 | 153 | case 'organization_city': |
154 | - $c->organization->city = $value;break; |
|
154 | + $c->organization->city = $value; break; |
|
155 | 155 | case 'organization_state': |
156 | - try{ |
|
156 | + try { |
|
157 | 157 | $state = $this->get_migration_script()->get_or_create_state($value); |
158 | 158 | $state_id = $state['STA_ID']; |
159 | 159 | $c->organization->STA_ID = $state_id; |
160 | - }catch(EE_Error $e){}break; |
|
160 | + } catch (EE_Error $e) {}break; |
|
161 | 161 | case 'organization_zip': |
162 | - $c->organization->zip = $value;break; |
|
162 | + $c->organization->zip = $value; break; |
|
163 | 163 | case 'contact_email': |
164 | - $c->organization->email = $value;break; |
|
164 | + $c->organization->email = $value; break; |
|
165 | 165 | case 'default_payment_status': |
166 | - $c->registration->default_STS_ID = $this->get_migration_script()->convert_3_1_payment_status_to_4_1_STS_ID($value);break; |
|
166 | + $c->registration->default_STS_ID = $this->get_migration_script()->convert_3_1_payment_status_to_4_1_STS_ID($value); break; |
|
167 | 167 | case 'organization_country': |
168 | - $iso =$this->get_migration_script()->get_iso_from_3_1_country_id($value); |
|
168 | + $iso = $this->get_migration_script()->get_iso_from_3_1_country_id($value); |
|
169 | 169 | $c->organization->CNT_ISO = $iso; |
170 | 170 | $country_row = $this->get_migration_script()->get_or_create_country($iso); |
171 | - if( ! $country_row){ |
|
172 | - $this->add_error(sprintf(__("Could not set country's currency config because no country exists for ISO %s", "event_espresso"),$iso)); |
|
171 | + if ( ! $country_row) { |
|
172 | + $this->add_error(sprintf(__("Could not set country's currency config because no country exists for ISO %s", "event_espresso"), $iso)); |
|
173 | 173 | } |
174 | 174 | //can't use EE_Currency_Config's handy constructor because the models are off-limits right now (and it uses them) |
175 | - $c->currency->code = $country_row['CNT_cur_code']; // currency code: USD, CAD, EUR |
|
176 | - $c->currency->name = $country_row['CNT_cur_single']; // Dollar |
|
177 | - $c->currency->plural = $country_row['CNT_cur_plural']; // Dollars |
|
178 | - $c->currency->sign = $country_row['CNT_cur_sign']; // currency sign: $ |
|
179 | - $c->currency->sign_b4 = intval($country_row['CNT_cur_sign_b4']); // currency sign before or after: $TRUE or FALSE$ |
|
180 | - $c->currency->dec_plc = intval($country_row['CNT_cur_dec_plc']); // decimal places: 2 = 0.00 3 = 0.000 |
|
181 | - $c->currency->dec_mrk = $country_row['CNT_cur_dec_mrk']; // decimal mark: (comma) ',' = 0,01 or (decimal) '.' = 0.01 |
|
182 | - $c->currency->thsnds = $country_row['CNT_cur_thsnds']; // thousands separator: (comma) ',' = 1,000 or (decimal) '.' = 1.000 |
|
175 | + $c->currency->code = $country_row['CNT_cur_code']; // currency code: USD, CAD, EUR |
|
176 | + $c->currency->name = $country_row['CNT_cur_single']; // Dollar |
|
177 | + $c->currency->plural = $country_row['CNT_cur_plural']; // Dollars |
|
178 | + $c->currency->sign = $country_row['CNT_cur_sign']; // currency sign: $ |
|
179 | + $c->currency->sign_b4 = intval($country_row['CNT_cur_sign_b4']); // currency sign before or after: $TRUE or FALSE$ |
|
180 | + $c->currency->dec_plc = intval($country_row['CNT_cur_dec_plc']); // decimal places: 2 = 0.00 3 = 0.000 |
|
181 | + $c->currency->dec_mrk = $country_row['CNT_cur_dec_mrk']; // decimal mark: (comma) ',' = 0,01 or (decimal) '.' = 0.01 |
|
182 | + $c->currency->thsnds = $country_row['CNT_cur_thsnds']; // thousands separator: (comma) ',' = 1,000 or (decimal) '.' = 1.000 |
|
183 | 183 | // $c->currency = new EE_Currency_Config($c->organization->CNT_ISO);break; |
184 | 184 | // case 'currency_symbol': ignore the currency symbol. we'll just go by their country. |
185 | 185 | // $c->currency->sign = $value;break; |
186 | 186 | case 'show_pending_payment_options': |
187 | - $c->registration->show_pending_payment_options = ($value == 'Y');break; |
|
187 | + $c->registration->show_pending_payment_options = ($value == 'Y'); break; |
|
188 | 188 | case 'display_address_in_regform': |
189 | - $c->template_settings->display_address_in_regform = ($value == 'Y');break; |
|
189 | + $c->template_settings->display_address_in_regform = ($value == 'Y'); break; |
|
190 | 190 | case 'default_logo_url': |
191 | - $c->organization->logo_url = $value;break; |
|
191 | + $c->organization->logo_url = $value; break; |
|
192 | 192 | case 'event_page_id': |
193 | 193 | |
194 | 194 | //also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS |
195 | 195 | //to ESPRESSO_THANK_YOU |
196 | 196 | $reg_page_post = get_post($value); |
197 | - $reg_page_post->post_content = str_replace("[ESPRESSO_EVENTS]","[ESPRESSO_CHECKOUT]",$reg_page_post->post_content); |
|
197 | + $reg_page_post->post_content = str_replace("[ESPRESSO_EVENTS]", "[ESPRESSO_CHECKOUT]", $reg_page_post->post_content); |
|
198 | 198 | wp_update_post($reg_page_post); |
199 | 199 | $c->core->reg_page_id = $value; |
200 | 200 | break; |
@@ -202,7 +202,7 @@ discard block |
||
202 | 202 | //also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS |
203 | 203 | //to ESPRESSO_THANK_YOU |
204 | 204 | $thank_you_page_post = get_post($value); |
205 | - $thank_you_page_post->post_content = str_replace("[ESPRESSO_PAYMENTS]","[ESPRESSO_THANK_YOU]",$thank_you_page_post->post_content); |
|
205 | + $thank_you_page_post->post_content = str_replace("[ESPRESSO_PAYMENTS]", "[ESPRESSO_THANK_YOU]", $thank_you_page_post->post_content); |
|
206 | 206 | wp_update_post($thank_you_page_post); |
207 | 207 | $c->core->thank_you_page_id = $value; |
208 | 208 | break; |
@@ -216,15 +216,15 @@ discard block |
||
216 | 216 | case 'use_captcha': |
217 | 217 | $c->registration->use_captcha = ($value == 'Y'); break; |
218 | 218 | case 'recaptcha_publickey': |
219 | - $c->registration->recaptcha_publickey = $value;break; |
|
219 | + $c->registration->recaptcha_publickey = $value; break; |
|
220 | 220 | case 'recaptcha_privatekey': |
221 | - $c->registration->recaptcha_privatekey = $value;break; |
|
221 | + $c->registration->recaptcha_privatekey = $value; break; |
|
222 | 222 | case 'recaptcha_theme': |
223 | - $c->registration->recaptcha_theme = $value;break; |
|
223 | + $c->registration->recaptcha_theme = $value; break; |
|
224 | 224 | case 'recaptcha_width': |
225 | - $c->registration->recaptcha_width = $value;break; |
|
225 | + $c->registration->recaptcha_width = $value; break; |
|
226 | 226 | case 'recaptcha_language': |
227 | - $c->registration->recaptcha_language = $value;break; |
|
227 | + $c->registration->recaptcha_language = $value; break; |
|
228 | 228 | case 'espresso_dashboard_widget': |
229 | 229 | $c->admin->use_dashboard_widget = ($value == 'Y'); break; |
230 | 230 | case 'use_personnel_manager': |
@@ -232,13 +232,13 @@ discard block |
||
232 | 232 | case 'use_event_timezones': |
233 | 233 | $c->admin->use_event_timezones = ($value == 'Y'); break; |
234 | 234 | case 'full_logging': |
235 | - $c->admin->use_full_logging = ($value == 'Y');break; |
|
235 | + $c->admin->use_full_logging = ($value == 'Y'); break; |
|
236 | 236 | case 'affiliate_id': |
237 | - $c->admin->affiliate_id = $value;break; |
|
237 | + $c->admin->affiliate_id = $value; break; |
|
238 | 238 | case 'site_license_key': |
239 | - $cn->core->site_license_key = $value;break; |
|
239 | + $cn->core->site_license_key = $value; break; |
|
240 | 240 | default: |
241 | - do_action( 'AHEE__EE_DMS_4_1_0__handle_org_option',$option_name,$value ); |
|
241 | + do_action('AHEE__EE_DMS_4_1_0__handle_org_option', $option_name, $value); |
|
242 | 242 | } |
243 | 243 | } |
244 | 244 | |
@@ -248,15 +248,15 @@ discard block |
||
248 | 248 | * @param type $old_price |
249 | 249 | * @return int |
250 | 250 | */ |
251 | - private function _insert_new_global_surcharge_price($org_options){ |
|
251 | + private function _insert_new_global_surcharge_price($org_options) { |
|
252 | 252 | $amount = floatval($org_options['surcharge']); |
253 | 253 | //dont createa a price if the surcharge is 0 |
254 | - if($amount <=.01){ |
|
254 | + if ($amount <= .01) { |
|
255 | 255 | return 0; |
256 | 256 | } |
257 | - if($org_options['surcharge_type'] == 'flat_rate'){ |
|
257 | + if ($org_options['surcharge_type'] == 'flat_rate') { |
|
258 | 258 | $price_type = EE_DMS_4_1_0_prices::price_type_flat_surcharge; |
259 | - }else{ |
|
259 | + } else { |
|
260 | 260 | $price_type = EE_DMS_4_1_0_prices::price_type_percent_surcharge; |
261 | 261 | } |
262 | 262 | global $wpdb; |
@@ -272,18 +272,18 @@ discard block |
||
272 | 272 | |
273 | 273 | ); |
274 | 274 | $datatypes = array( |
275 | - '%d',//PRT_ID |
|
276 | - '%f',//PRT_amount |
|
277 | - '%s',//PRC_name |
|
278 | - '%d',//PRC_is_default |
|
279 | - '%d',//PRC_overrides |
|
280 | - '%d',//PRC_order |
|
281 | - '%d',//PRC_deleted |
|
282 | - '%d',//PRC_parent |
|
275 | + '%d', //PRT_ID |
|
276 | + '%f', //PRT_amount |
|
277 | + '%s', //PRC_name |
|
278 | + '%d', //PRC_is_default |
|
279 | + '%d', //PRC_overrides |
|
280 | + '%d', //PRC_order |
|
281 | + '%d', //PRC_deleted |
|
282 | + '%d', //PRC_parent |
|
283 | 283 | ); |
284 | 284 | $price_table = $wpdb->prefix."esp_price"; |
285 | - $success = $wpdb->insert($price_table,$cols_n_values,$datatypes); |
|
286 | - if ( ! $success){ |
|
285 | + $success = $wpdb->insert($price_table, $cols_n_values, $datatypes); |
|
286 | + if ( ! $success) { |
|
287 | 287 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion('org_options', |
288 | 288 | array( |
289 | 289 | 'surcharge'=>$org_options['surcharge'], |
@@ -308,8 +308,8 @@ discard block |
||
308 | 308 | 'payment_message', |
309 | 309 | 'message', |
310 | 310 | 'default_payment_status', |
311 | - 'surcharge',//unused? |
|
312 | - 'country_id',//unused? |
|
311 | + 'surcharge', //unused? |
|
312 | + 'country_id', //unused? |
|
313 | 313 | 'organization_country', |
314 | 314 | // 'currency_symbol', |
315 | 315 | 'expire_on_registration_end', |
@@ -321,13 +321,13 @@ discard block |
||
321 | 321 | 'show_pending_payment_options', |
322 | 322 | 'show_reg_footer', |
323 | 323 | 'skip_confirmation_page', |
324 | - 'allow_mer_discounts',//no equiv |
|
325 | - 'allow_mer_vouchers',//no equiv |
|
324 | + 'allow_mer_discounts', //no equiv |
|
325 | + 'allow_mer_vouchers', //no equiv |
|
326 | 326 | 'display_short_description_in_event_list', |
327 | 327 | 'display_description_on_multi_reg_page', |
328 | 328 | 'display_address_in_event_list', |
329 | 329 | 'display_address_in_regform', |
330 | - 'use_custom_post_types',//no equiv |
|
330 | + 'use_custom_post_types', //no equiv |
|
331 | 331 | 'display_ical_download', |
332 | 332 | 'display_featured_image', |
333 | 333 | 'themeroller', |
@@ -346,11 +346,11 @@ discard block |
||
346 | 346 | 'espresso_dashboard_widget', |
347 | 347 | 'time_reg_limit', |
348 | 348 | // 'use_attendee_pre_approval', removed in 4.1- instead this is factored into the default reg status |
349 | - 'use_personnel_manager',//no equiv |
|
349 | + 'use_personnel_manager', //no equiv |
|
350 | 350 | 'use_event_timezones', |
351 | 351 | 'full_logging', |
352 | - 'surcharge_type',//unused |
|
353 | - 'surcharge_text',//unused |
|
352 | + 'surcharge_type', //unused |
|
353 | + 'surcharge_text', //unused |
|
354 | 354 | 'affiliate_id', |
355 | 355 | 'site_license_key', |
356 | 356 | ); |
@@ -157,7 +157,7 @@ discard block |
||
157 | 157 | $state = $this->get_migration_script()->get_or_create_state($value); |
158 | 158 | $state_id = $state['STA_ID']; |
159 | 159 | $c->organization->STA_ID = $state_id; |
160 | - }catch(EE_Error $e){}break; |
|
160 | + } catch(EE_Error $e){}break; |
|
161 | 161 | case 'organization_zip': |
162 | 162 | $c->organization->zip = $value;break; |
163 | 163 | case 'contact_email': |
@@ -256,7 +256,7 @@ discard block |
||
256 | 256 | } |
257 | 257 | if($org_options['surcharge_type'] == 'flat_rate'){ |
258 | 258 | $price_type = EE_DMS_4_1_0_prices::price_type_flat_surcharge; |
259 | - }else{ |
|
259 | + } else{ |
|
260 | 260 | $price_type = EE_DMS_4_1_0_prices::price_type_percent_surcharge; |
261 | 261 | } |
262 | 262 | global $wpdb; |
@@ -345,8 +345,8 @@ discard block |
||
345 | 345 | /** |
346 | 346 | * Adds a join between a ticket and a price |
347 | 347 | * @global type $wpdb |
348 | - * @param type $new_ticket_id |
|
349 | - * @param type $new_price_id |
|
348 | + * @param integer $new_ticket_id |
|
349 | + * @param integer $new_price_id |
|
350 | 350 | * @return int |
351 | 351 | */ |
352 | 352 | private function _insert_ticket_price_relation($new_ticket_id,$new_price_id){ |
@@ -371,8 +371,7 @@ discard block |
||
371 | 371 | /** |
372 | 372 | * Adds a join between a ticket and a datetime |
373 | 373 | * @global type $wpdb |
374 | - * @param type $new_ticket_id |
|
375 | - * @param type $new_price_id |
|
374 | + * @param integer $new_ticket_id |
|
376 | 375 | * @return int |
377 | 376 | */ |
378 | 377 | private function _insert_datetime_ticket_relation($new_datetime_id,$new_ticket_id){ |
@@ -86,7 +86,7 @@ discard block |
||
86 | 86 | )); |
87 | 87 | */ |
88 | 88 | |
89 | -class EE_DMS_4_1_0_prices extends EE_Data_Migration_Script_Stage_Table{ |
|
89 | +class EE_DMS_4_1_0_prices extends EE_Data_Migration_Script_Stage_Table { |
|
90 | 90 | private $_new_price_table; |
91 | 91 | private $_new_ticket_table; |
92 | 92 | private $_new_ticket_price_table; |
@@ -122,10 +122,10 @@ discard block |
||
122 | 122 | // $member_price_discount_id = 0; |
123 | 123 | // } |
124 | 124 | //create the surcharge if there is any |
125 | - if(floatval($old_row['surcharge']) >= 0.01){ |
|
125 | + if (floatval($old_row['surcharge']) >= 0.01) { |
|
126 | 126 | $surcharge_price_id = $this->_insert_new_surcharge_price($old_row); |
127 | - $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_price_table, array($new_price_id,$surcharge_price_id)); |
|
128 | - }else{ |
|
127 | + $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_price_table, array($new_price_id, $surcharge_price_id)); |
|
128 | + } else { |
|
129 | 129 | $surcharge_price_id = 0; |
130 | 130 | $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_price_table, array($new_price_id)); |
131 | 131 | } |
@@ -145,7 +145,7 @@ discard block |
||
145 | 145 | // } |
146 | 146 | //create a ticket for each old price -old datetime combo |
147 | 147 | $tickets_for_old_price = array(); |
148 | - foreach($this->_get_datetime_ids_for_old_event_id($old_row['event_id']) as $new_datetime_id){ |
|
148 | + foreach ($this->_get_datetime_ids_for_old_event_id($old_row['event_id']) as $new_datetime_id) { |
|
149 | 149 | $ticket_id = $this->_insert_new_ticket($old_row); |
150 | 150 | $tickets_for_old_price[] = $ticket_id; |
151 | 151 | //associate to old prices |
@@ -162,7 +162,7 @@ discard block |
||
162 | 162 | * @param type $old_price |
163 | 163 | * @return int |
164 | 164 | */ |
165 | - private function _insert_new_price($old_price){ |
|
165 | + private function _insert_new_price($old_price) { |
|
166 | 166 | global $wpdb; |
167 | 167 | $cols_n_values = array( |
168 | 168 | 'PRT_ID'=>self::price_type_base, |
@@ -176,17 +176,17 @@ discard block |
||
176 | 176 | |
177 | 177 | ); |
178 | 178 | $datatypes = array( |
179 | - '%d',//PRT_ID |
|
180 | - '%f',//PRT_amount |
|
181 | - '%s',//PRC_name |
|
182 | - '%d',//PRC_is_default |
|
183 | - '%d',//PRC_overrides |
|
184 | - '%d',//PRC_order |
|
185 | - '%d',//PRC_deleted |
|
186 | - '%d',//PRC_parent |
|
179 | + '%d', //PRT_ID |
|
180 | + '%f', //PRT_amount |
|
181 | + '%s', //PRC_name |
|
182 | + '%d', //PRC_is_default |
|
183 | + '%d', //PRC_overrides |
|
184 | + '%d', //PRC_order |
|
185 | + '%d', //PRC_deleted |
|
186 | + '%d', //PRC_parent |
|
187 | 187 | ); |
188 | - $success = $wpdb->insert($this->_new_price_table,$cols_n_values,$datatypes); |
|
189 | - if ( ! $success){ |
|
188 | + $success = $wpdb->insert($this->_new_price_table, $cols_n_values, $datatypes); |
|
189 | + if ( ! $success) { |
|
190 | 190 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_price, $this->_new_price_table, $cols_n_values, $datatypes)); |
191 | 191 | return 0; |
192 | 192 | } |
@@ -237,11 +237,11 @@ discard block |
||
237 | 237 | * @param type $old_price |
238 | 238 | * @return int |
239 | 239 | */ |
240 | - private function _insert_new_surcharge_price($old_price){ |
|
240 | + private function _insert_new_surcharge_price($old_price) { |
|
241 | 241 | |
242 | - if($old_price['surcharge_type'] == 'flat_rate'){ |
|
242 | + if ($old_price['surcharge_type'] == 'flat_rate') { |
|
243 | 243 | $price_type = self::price_type_flat_surcharge; |
244 | - }else{ |
|
244 | + } else { |
|
245 | 245 | $price_type = self::price_type_percent_surcharge; |
246 | 246 | } |
247 | 247 | global $wpdb; |
@@ -257,17 +257,17 @@ discard block |
||
257 | 257 | |
258 | 258 | ); |
259 | 259 | $datatypes = array( |
260 | - '%d',//PRT_ID |
|
261 | - '%f',//PRT_amount |
|
262 | - '%s',//PRC_name |
|
263 | - '%d',//PRC_is_default |
|
264 | - '%d',//PRC_overrides |
|
265 | - '%d',//PRC_order |
|
266 | - '%d',//PRC_deleted |
|
267 | - '%d',//PRC_parent |
|
260 | + '%d', //PRT_ID |
|
261 | + '%f', //PRT_amount |
|
262 | + '%s', //PRC_name |
|
263 | + '%d', //PRC_is_default |
|
264 | + '%d', //PRC_overrides |
|
265 | + '%d', //PRC_order |
|
266 | + '%d', //PRC_deleted |
|
267 | + '%d', //PRC_parent |
|
268 | 268 | ); |
269 | - $success = $wpdb->insert($this->_new_price_table,$cols_n_values,$datatypes); |
|
270 | - if ( ! $success){ |
|
269 | + $success = $wpdb->insert($this->_new_price_table, $cols_n_values, $datatypes); |
|
270 | + if ( ! $success) { |
|
271 | 271 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_price, $this->_new_price_table, $cols_n_values, $datatypes)); |
272 | 272 | return 0; |
273 | 273 | } |
@@ -282,18 +282,18 @@ discard block |
||
282 | 282 | * @param $new_surcharge_id int |
283 | 283 | * @return int new ticket id |
284 | 284 | */ |
285 | - private function _insert_new_ticket($old_price_row){ |
|
285 | + private function _insert_new_ticket($old_price_row) { |
|
286 | 286 | global $wpdb; |
287 | 287 | $event_row = $this->_get_event_row($old_price_row['event_id']); |
288 | - if($old_price_row['surcharge_type'] == 'flat_rate'){ |
|
288 | + if ($old_price_row['surcharge_type'] == 'flat_rate') { |
|
289 | 289 | $final_ticket_price = floatval($old_price_row['event_cost']) + floatval($old_price_row['surcharge']); |
290 | - }else{//percent surcharge |
|
291 | - $final_ticket_price = floatval($old_price_row['event_cost']) * (1 + floatval($old_price_row['surcharge'])/100); |
|
290 | + } else {//percent surcharge |
|
291 | + $final_ticket_price = floatval($old_price_row['event_cost']) * (1 + floatval($old_price_row['surcharge']) / 100); |
|
292 | 292 | } |
293 | 293 | $start_date = $event_row['registration_start']." ".$this->get_migration_script()->convertTimeFromAMPM($event_row['registration_startT']); |
294 | - $start_date_utc = $this->get_migration_script()->convert_date_string_to_utc($this,$old_price_row,$start_date,$event_row['timezone_string']); |
|
294 | + $start_date_utc = $this->get_migration_script()->convert_date_string_to_utc($this, $old_price_row, $start_date, $event_row['timezone_string']); |
|
295 | 295 | $end_date = $event_row['registration_end']." ".$this->get_migration_script()->convertTimeFromAMPM($event_row['registration_endT']); |
296 | - $end_date_utc = $this->get_migration_script()->convert_date_string_to_utc($this,$old_price_row,$end_date,$event_row['timezone_string']); |
|
296 | + $end_date_utc = $this->get_migration_script()->convert_date_string_to_utc($this, $old_price_row, $end_date, $event_row['timezone_string']); |
|
297 | 297 | $cols_n_values = array( |
298 | 298 | 'TTM_ID'=>0, |
299 | 299 | 'TKT_name'=>$old_price_row['price_type'], |
@@ -303,38 +303,38 @@ discard block |
||
303 | 303 | 'TKT_min'=>0, |
304 | 304 | 'TKT_max'=>-1, |
305 | 305 | 'TKT_price'=>$final_ticket_price, |
306 | - 'TKT_sold'=> 0,//note: this will get calculated as we actually add registrations during the migration |
|
306 | + 'TKT_sold'=> 0, //note: this will get calculated as we actually add registrations during the migration |
|
307 | 307 | 'TKT_qty'=> -1, |
308 | 308 | 'TKT_uses'=> 1, |
309 | - 'TKT_taxable'=>false,//so by default, old prices are NOT taxable. This way they don't suddenly have a sudden spike in prices |
|
309 | + 'TKT_taxable'=>false, //so by default, old prices are NOT taxable. This way they don't suddenly have a sudden spike in prices |
|
310 | 310 | 'TKT_is_default'=>false, |
311 | 311 | 'TKT_order'=>$this->_get_ticket_count(), |
312 | - 'TKT_row'=>0,//doesn't matter because UI reset this on first save anyways |
|
312 | + 'TKT_row'=>0, //doesn't matter because UI reset this on first save anyways |
|
313 | 313 | 'TKT_deleted'=>false, |
314 | 314 | 'TKT_parent'=>0 |
315 | 315 | |
316 | 316 | ); |
317 | 317 | $datatypes = array( |
318 | - '%d',//TTM_ID |
|
319 | - '%s',//TKT_name |
|
320 | - '%s',//TKT_description |
|
321 | - '%s',//TKT_start_date |
|
322 | - '%s',//TKT_end_date |
|
323 | - '%d',//TKT_min |
|
324 | - '%d',//TKT_max |
|
325 | - '%f',//TKT_price |
|
326 | - '%d',//TKT_sold |
|
327 | - '%d',//TKT_qty |
|
328 | - '%d',//TKT_uses |
|
329 | - '%d',//TKT_taxable |
|
330 | - '%d',//TKT_is_default |
|
331 | - '%d',//TKT_order |
|
332 | - '%d',//TKT_row |
|
333 | - '%d',//TKT_deleted |
|
334 | - '%d',//TKT_parent |
|
318 | + '%d', //TTM_ID |
|
319 | + '%s', //TKT_name |
|
320 | + '%s', //TKT_description |
|
321 | + '%s', //TKT_start_date |
|
322 | + '%s', //TKT_end_date |
|
323 | + '%d', //TKT_min |
|
324 | + '%d', //TKT_max |
|
325 | + '%f', //TKT_price |
|
326 | + '%d', //TKT_sold |
|
327 | + '%d', //TKT_qty |
|
328 | + '%d', //TKT_uses |
|
329 | + '%d', //TKT_taxable |
|
330 | + '%d', //TKT_is_default |
|
331 | + '%d', //TKT_order |
|
332 | + '%d', //TKT_row |
|
333 | + '%d', //TKT_deleted |
|
334 | + '%d', //TKT_parent |
|
335 | 335 | ); |
336 | - $success = $wpdb->insert($this->_new_ticket_table,$cols_n_values,$datatypes); |
|
337 | - if ( ! $success){ |
|
336 | + $success = $wpdb->insert($this->_new_ticket_table, $cols_n_values, $datatypes); |
|
337 | + if ( ! $success) { |
|
338 | 338 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_price_row, $this->_new_ticket_table, $cols_n_values, $datatypes)); |
339 | 339 | return 0; |
340 | 340 | } |
@@ -349,19 +349,19 @@ discard block |
||
349 | 349 | * @param type $new_price_id |
350 | 350 | * @return int |
351 | 351 | */ |
352 | - private function _insert_ticket_price_relation($new_ticket_id,$new_price_id){ |
|
352 | + private function _insert_ticket_price_relation($new_ticket_id, $new_price_id) { |
|
353 | 353 | global $wpdb; |
354 | 354 | $cols_n_values = array( |
355 | 355 | 'TKT_ID'=>$new_ticket_id, |
356 | 356 | 'PRC_ID'=>$new_price_id, |
357 | 357 | ); |
358 | 358 | $datatypes = array( |
359 | - '%d',//TKT_ID |
|
360 | - '%d',//PRC_ID |
|
359 | + '%d', //TKT_ID |
|
360 | + '%d', //PRC_ID |
|
361 | 361 | ); |
362 | - $success = $wpdb->insert($this->_new_ticket_price_table,$cols_n_values,$datatypes); |
|
363 | - if ( ! $success){ |
|
364 | - $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, array('ticket id'=>$new_ticket_id,'price id'=>$new_price_id), $this->_new_ticket_price_table, $cols_n_values, $datatypes)); |
|
362 | + $success = $wpdb->insert($this->_new_ticket_price_table, $cols_n_values, $datatypes); |
|
363 | + if ( ! $success) { |
|
364 | + $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, array('ticket id'=>$new_ticket_id, 'price id'=>$new_price_id), $this->_new_ticket_price_table, $cols_n_values, $datatypes)); |
|
365 | 365 | return 0; |
366 | 366 | } |
367 | 367 | $new_id = $wpdb->insert_id; |
@@ -375,19 +375,19 @@ discard block |
||
375 | 375 | * @param type $new_price_id |
376 | 376 | * @return int |
377 | 377 | */ |
378 | - private function _insert_datetime_ticket_relation($new_datetime_id,$new_ticket_id){ |
|
378 | + private function _insert_datetime_ticket_relation($new_datetime_id, $new_ticket_id) { |
|
379 | 379 | global $wpdb; |
380 | 380 | $cols_n_values = array( |
381 | 381 | 'TKT_ID'=>$new_ticket_id, |
382 | 382 | 'DTT_ID'=>$new_datetime_id, |
383 | 383 | ); |
384 | 384 | $datatypes = array( |
385 | - '%d',//TKT_ID |
|
386 | - '%d',//DTT_ID |
|
385 | + '%d', //TKT_ID |
|
386 | + '%d', //DTT_ID |
|
387 | 387 | ); |
388 | - $success = $wpdb->insert($this->_new_datetime_ticket_table,$cols_n_values,$datatypes); |
|
389 | - if ( ! $success){ |
|
390 | - $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, array('ticket id'=>$new_ticket_id,'datetime id'=>$new_datetime_id), $this->_new_datetime_ticket_table, $cols_n_values, $datatypes)); |
|
388 | + $success = $wpdb->insert($this->_new_datetime_ticket_table, $cols_n_values, $datatypes); |
|
389 | + if ( ! $success) { |
|
390 | + $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, array('ticket id'=>$new_ticket_id, 'datetime id'=>$new_datetime_id), $this->_new_datetime_ticket_table, $cols_n_values, $datatypes)); |
|
391 | 391 | return 0; |
392 | 392 | } |
393 | 393 | $new_id = $wpdb->insert_id; |
@@ -400,17 +400,17 @@ discard block |
||
400 | 400 | * @param type $event_id |
401 | 401 | * @return array |
402 | 402 | */ |
403 | - private function _get_event_row($event_id){ |
|
403 | + private function _get_event_row($event_id) { |
|
404 | 404 | global $wpdb; |
405 | 405 | $old_event_table = $wpdb->prefix."events_detail"; |
406 | - return $wpdb->get_row($wpdb->prepare("SELECT * FROM $old_event_table WHERE id=%d",$event_id),ARRAY_A); |
|
406 | + return $wpdb->get_row($wpdb->prepare("SELECT * FROM $old_event_table WHERE id=%d", $event_id), ARRAY_A); |
|
407 | 407 | } |
408 | 408 | /** |
409 | 409 | * Gets a higher ticket count than last time it was called (and is persisted between HTTP requests). |
410 | 410 | * Yes we COULD run a query joining events->datetimes->ticket_datetimes->tickets, but this should work fine too |
411 | 411 | * @return int |
412 | 412 | */ |
413 | - private function _get_ticket_count(){ |
|
413 | + private function _get_ticket_count() { |
|
414 | 414 | return $this->_ticket_count++; |
415 | 415 | } |
416 | 416 | |
@@ -419,10 +419,10 @@ discard block |
||
419 | 419 | * @param int $old_event_id |
420 | 420 | * @return array where values are datetime ids |
421 | 421 | */ |
422 | - private function _get_datetime_ids_for_old_event_id($old_event_id){ |
|
422 | + private function _get_datetime_ids_for_old_event_id($old_event_id) { |
|
423 | 423 | global $wpdb; |
424 | 424 | $new_cpt_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_detail", $old_event_id, $wpdb->posts); |
425 | - $datetime_ids = $wpdb->get_col($wpdb->prepare("SELECT DTT_ID FROM {$wpdb->prefix}esp_datetime WHERE EVT_ID=%d",$new_cpt_id)); |
|
425 | + $datetime_ids = $wpdb->get_col($wpdb->prepare("SELECT DTT_ID FROM {$wpdb->prefix}esp_datetime WHERE EVT_ID=%d", $new_cpt_id)); |
|
426 | 426 | return $datetime_ids; |
427 | 427 | } |
428 | 428 | } |
@@ -125,7 +125,7 @@ discard block |
||
125 | 125 | if(floatval($old_row['surcharge']) >= 0.01){ |
126 | 126 | $surcharge_price_id = $this->_insert_new_surcharge_price($old_row); |
127 | 127 | $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_price_table, array($new_price_id,$surcharge_price_id)); |
128 | - }else{ |
|
128 | + } else{ |
|
129 | 129 | $surcharge_price_id = 0; |
130 | 130 | $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_price_table, array($new_price_id)); |
131 | 131 | } |
@@ -241,7 +241,7 @@ discard block |
||
241 | 241 | |
242 | 242 | if($old_price['surcharge_type'] == 'flat_rate'){ |
243 | 243 | $price_type = self::price_type_flat_surcharge; |
244 | - }else{ |
|
244 | + } else{ |
|
245 | 245 | $price_type = self::price_type_percent_surcharge; |
246 | 246 | } |
247 | 247 | global $wpdb; |
@@ -287,7 +287,7 @@ discard block |
||
287 | 287 | $event_row = $this->_get_event_row($old_price_row['event_id']); |
288 | 288 | if($old_price_row['surcharge_type'] == 'flat_rate'){ |
289 | 289 | $final_ticket_price = floatval($old_price_row['event_cost']) + floatval($old_price_row['surcharge']); |
290 | - }else{//percent surcharge |
|
290 | + } else{//percent surcharge |
|
291 | 291 | $final_ticket_price = floatval($old_price_row['event_cost']) * (1 + floatval($old_price_row['surcharge'])/100); |
292 | 292 | } |
293 | 293 | $start_date = $event_row['registration_start']." ".$this->get_migration_script()->convertTimeFromAMPM($event_row['registration_startT']); |
@@ -126,7 +126,7 @@ |
||
126 | 126 | * being address info, and 0 being neither) |
127 | 127 | * @global type $wpdb |
128 | 128 | * @param type $new_question_group_id |
129 | - * @return boolean |
|
129 | + * @return integer |
|
130 | 130 | */ |
131 | 131 | private function _is_system_question_group($new_question_group_id){ |
132 | 132 | global $wpdb; |
@@ -12,8 +12,6 @@ |
||
12 | 12 | KEY `group_id` (`group_id`), |
13 | 13 | KEY `question_id` (`question_id`) |
14 | 14 | ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8$$ |
15 | - |
|
16 | - |
|
17 | 15 | * 4.1 question group question model's tables and fields: |
18 | 16 | $this->_tables = array( |
19 | 17 | 'Question_Group_Question'=>new EE_Primary_Table('esp_question_group_question','QGQ_ID') |
@@ -27,20 +27,20 @@ discard block |
||
27 | 27 | ); |
28 | 28 | * |
29 | 29 | */ |
30 | -class EE_DMS_4_1_0_question_group_question extends EE_Data_Migration_Script_Stage{ |
|
30 | +class EE_DMS_4_1_0_question_group_question extends EE_Data_Migration_Script_Stage { |
|
31 | 31 | private $_old_table; |
32 | 32 | private $_new_table; |
33 | - function _migration_step($num_items=50){ |
|
33 | + function _migration_step($num_items = 50) { |
|
34 | 34 | |
35 | 35 | global $wpdb; |
36 | 36 | $start_at_record = $this->count_records_migrated(); |
37 | - $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A); |
|
37 | + $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A); |
|
38 | 38 | $items_actually_migrated = 0; |
39 | - foreach($rows as $question_group_question){ |
|
39 | + foreach ($rows as $question_group_question) { |
|
40 | 40 | $this->_insert_new_question_group_question($question_group_question); |
41 | 41 | $items_actually_migrated++; |
42 | 42 | } |
43 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
43 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
44 | 44 | $this->set_completed(); |
45 | 45 | } |
46 | 46 | return $items_actually_migrated; |
@@ -64,39 +64,39 @@ discard block |
||
64 | 64 | * @param array $old_question_group_question |
65 | 65 | * @return int |
66 | 66 | */ |
67 | - private function _insert_new_question_group_question($old_question_group_question){ |
|
67 | + private function _insert_new_question_group_question($old_question_group_question) { |
|
68 | 68 | global $wpdb; |
69 | 69 | $new_question_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_question", $old_question_group_question['question_id'], $wpdb->prefix."esp_question"); |
70 | 70 | $new_question_group_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_qst_group", $old_question_group_question['group_id'], $wpdb->prefix."esp_question_group"); |
71 | - if( ! $new_question_id){ |
|
72 | - $this->add_error(sprintf(__("Could not find 4.1 question id for 3.1 question #%d.", "event_espresso"),$old_question_group_question['question_id'])); |
|
71 | + if ( ! $new_question_id) { |
|
72 | + $this->add_error(sprintf(__("Could not find 4.1 question id for 3.1 question #%d.", "event_espresso"), $old_question_group_question['question_id'])); |
|
73 | 73 | return 0; |
74 | 74 | } |
75 | - if( ! $new_question_group_id){ |
|
76 | - $this->add_error(sprintf(__("Could not find 4.1 question group id for 3.1 question group #%d.", "event_espresso"),$old_question_group_question['group_id'])); |
|
75 | + if ( ! $new_question_group_id) { |
|
76 | + $this->add_error(sprintf(__("Could not find 4.1 question group id for 3.1 question group #%d.", "event_espresso"), $old_question_group_question['group_id'])); |
|
77 | 77 | return 0; |
78 | 78 | } |
79 | 79 | //if it's a system question, it needs to be in the right system group. otherwise no dice! |
80 | - if( |
|
81 | - ($this->_is_system_question_group($new_question_group_id) == $this->_is_system_question_for_question_group($new_question_id) ) |
|
80 | + if ( |
|
81 | + ($this->_is_system_question_group($new_question_group_id) == $this->_is_system_question_for_question_group($new_question_id)) |
|
82 | 82 | || |
83 | 83 | ! $this->_is_system_question_for_question_group($new_question_id) |
84 | - ){ |
|
84 | + ) { |
|
85 | 85 | $cols_n_values = array( |
86 | 86 | 'QSG_ID'=>$new_question_group_id, |
87 | 87 | 'QST_ID'=>$new_question_id |
88 | 88 | ); |
89 | 89 | $datatypes = array( |
90 | - '%d',//QSG_ID |
|
91 | - '%d',//QST_ID |
|
90 | + '%d', //QSG_ID |
|
91 | + '%d', //QST_ID |
|
92 | 92 | ); |
93 | - $success = $wpdb->insert($this->_new_table,$cols_n_values,$datatypes); |
|
94 | - if ( ! $success){ |
|
93 | + $success = $wpdb->insert($this->_new_table, $cols_n_values, $datatypes); |
|
94 | + if ( ! $success) { |
|
95 | 95 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_question_group_question, $this->_new_table, $cols_n_values, $datatypes)); |
96 | 96 | return 0; |
97 | 97 | } |
98 | 98 | return $wpdb->insert_id; |
99 | - }else{ |
|
99 | + } else { |
|
100 | 100 | return false; |
101 | 101 | } |
102 | 102 | |
@@ -109,14 +109,14 @@ discard block |
||
109 | 109 | * @param type $new_question_id |
110 | 110 | * @return int |
111 | 111 | */ |
112 | - private function _is_system_question_for_question_group($new_question_id){ |
|
112 | + private function _is_system_question_for_question_group($new_question_id) { |
|
113 | 113 | global $wpdb; |
114 | - $system_id = $wpdb->get_var($wpdb->prepare("SELECT QST_system FROM ".$wpdb->prefix."esp_question WHERE QST_ID=%d",$new_question_id)); |
|
115 | - if(in_array($system_id, array('fname','lname','email'))){ |
|
114 | + $system_id = $wpdb->get_var($wpdb->prepare("SELECT QST_system FROM ".$wpdb->prefix."esp_question WHERE QST_ID=%d", $new_question_id)); |
|
115 | + if (in_array($system_id, array('fname', 'lname', 'email'))) { |
|
116 | 116 | return 1; |
117 | - }elseif($system_id!='' && $system_id){ |
|
117 | + }elseif ($system_id != '' && $system_id) { |
|
118 | 118 | return 2; |
119 | - }else{ |
|
119 | + } else { |
|
120 | 120 | return 0; |
121 | 121 | } |
122 | 122 | } |
@@ -128,9 +128,9 @@ discard block |
||
128 | 128 | * @param type $new_question_group_id |
129 | 129 | * @return boolean |
130 | 130 | */ |
131 | - private function _is_system_question_group($new_question_group_id){ |
|
131 | + private function _is_system_question_group($new_question_group_id) { |
|
132 | 132 | global $wpdb; |
133 | - $system_id = $wpdb->get_var($wpdb->prepare("SELECT QSG_system FROM ".$wpdb->prefix."esp_question_group WHERE QSG_ID=%d",$new_question_group_id)); |
|
133 | + $system_id = $wpdb->get_var($wpdb->prepare("SELECT QSG_system FROM ".$wpdb->prefix."esp_question_group WHERE QSG_ID=%d", $new_question_group_id)); |
|
134 | 134 | return intval($system_id); |
135 | 135 | } |
136 | 136 |
@@ -96,7 +96,7 @@ discard block |
||
96 | 96 | return 0; |
97 | 97 | } |
98 | 98 | return $wpdb->insert_id; |
99 | - }else{ |
|
99 | + } else{ |
|
100 | 100 | return false; |
101 | 101 | } |
102 | 102 | |
@@ -114,9 +114,9 @@ discard block |
||
114 | 114 | $system_id = $wpdb->get_var($wpdb->prepare("SELECT QST_system FROM ".$wpdb->prefix."esp_question WHERE QST_ID=%d",$new_question_id)); |
115 | 115 | if(in_array($system_id, array('fname','lname','email'))){ |
116 | 116 | return 1; |
117 | - }elseif($system_id!='' && $system_id){ |
|
117 | + } elseif($system_id!='' && $system_id){ |
|
118 | 118 | return 2; |
119 | - }else{ |
|
119 | + } else{ |
|
120 | 120 | return 0; |
121 | 121 | } |
122 | 122 | } |
@@ -196,7 +196,7 @@ |
||
196 | 196 | |
197 | 197 | /** |
198 | 198 | * Inserts into the venue_meta table |
199 | - * @param type $cpt_id |
|
199 | + * @param integer $cpt_id |
|
200 | 200 | * @param type $old_venue |
201 | 201 | * @return int |
202 | 202 | */ |
@@ -206,7 +206,7 @@ discard block |
||
206 | 206 | try{ |
207 | 207 | $country = $this->get_migration_script()->get_or_create_country(stripslashes($old_venue['country'])); |
208 | 208 | $country_iso = $country['CNT_ISO']; |
209 | - }catch(EE_Error $e){ |
|
209 | + } catch(EE_Error $e){ |
|
210 | 210 | $this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue))); |
211 | 211 | $country_iso = null; |
212 | 212 | } |
@@ -214,7 +214,7 @@ discard block |
||
214 | 214 | try{ |
215 | 215 | $state = $this->get_migration_script()->get_or_create_state(stripslashes($old_venue['state']),isset($country['CNT_name']) ? $country['CNT_name'] : strip_tags($old_venue['country'])); |
216 | 216 | $state_id = $state['STA_ID']; |
217 | - }catch(EE_Error $e){ |
|
217 | + } catch(EE_Error $e){ |
|
218 | 218 | $this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue))); |
219 | 219 | $state_id = 0; |
220 | 220 | } |
@@ -61,44 +61,44 @@ discard block |
||
61 | 61 | // )); |
62 | 62 | * |
63 | 63 | */ |
64 | -class EE_DMS_4_1_0_venues extends EE_Data_Migration_Script_Stage{ |
|
64 | +class EE_DMS_4_1_0_venues extends EE_Data_Migration_Script_Stage { |
|
65 | 65 | private $_old_table; |
66 | 66 | private $_new_table; |
67 | 67 | private $_new_meta_table; |
68 | -function _migration_step($num_items=50){ |
|
68 | +function _migration_step($num_items = 50) { |
|
69 | 69 | global $wpdb; |
70 | 70 | $start_at_record = $this->count_records_migrated(); |
71 | - $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM ".$this->_old_table." LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A); |
|
71 | + $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM ".$this->_old_table." LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A); |
|
72 | 72 | $items_actually_migrated = 0; |
73 | - foreach($rows as $old_venue){ |
|
74 | - if ( ! $new_id = $this->_insert_into_posts($old_venue)){ |
|
73 | + foreach ($rows as $old_venue) { |
|
74 | + if ( ! $new_id = $this->_insert_into_posts($old_venue)) { |
|
75 | 75 | $items_actually_migrated++; |
76 | 76 | continue; |
77 | 77 | } |
78 | 78 | $this->get_migration_script()->set_mapping($this->_old_table, $old_venue['id'], $this->_new_table, $new_id); |
79 | - if( ! $new_meta_id = $this->_insert_into_meta_table($new_id,$old_venue)){ |
|
79 | + if ( ! $new_meta_id = $this->_insert_into_meta_table($new_id, $old_venue)) { |
|
80 | 80 | $items_actually_migrated++; |
81 | 81 | continue; |
82 | 82 | } |
83 | 83 | $this->get_migration_script()->set_mapping($this->_old_table, $old_venue['id'], $this->_new_meta_table, $new_meta_id); |
84 | 84 | //lastly, save the 'contact' as post meta, because it doesn't exist anywhere else but someone may still want it |
85 | 85 | $venue_meta = maybe_unserialize($old_venue['meta']); |
86 | - if(isset($venue_meta['contact']) && $venue_meta['contact']){ |
|
87 | - add_post_meta($new_id,'contact',$venue_meta['contact']); |
|
86 | + if (isset($venue_meta['contact']) && $venue_meta['contact']) { |
|
87 | + add_post_meta($new_id, 'contact', $venue_meta['contact']); |
|
88 | 88 | } |
89 | 89 | //is there an image on this venue? |
90 | 90 | $guid = isset($venue_meta['image']) && $venue_meta['image'] ? $venue_meta['image'] : NULL; |
91 | - if($guid){ |
|
92 | - $this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid,$new_id,$this); |
|
91 | + if ($guid) { |
|
92 | + $this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid, $new_id, $this); |
|
93 | 93 | } |
94 | 94 | $items_actually_migrated++; |
95 | - if($guid){ |
|
95 | + if ($guid) { |
|
96 | 96 | //if there was an image, we may have had to download it etc and it may have taken |
97 | 97 | //longer, then let's not bother migrating anymore on this step |
98 | 98 | break; |
99 | 99 | } |
100 | 100 | } |
101 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
101 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
102 | 102 | $this->set_completed(); |
103 | 103 | } |
104 | 104 | return $items_actually_migrated; |
@@ -122,42 +122,42 @@ discard block |
||
122 | 122 | * @param array $old_venue keys are cols, values are col values |
123 | 123 | * @return int |
124 | 124 | */ |
125 | - private function _insert_into_posts($old_venue){ |
|
125 | + private function _insert_into_posts($old_venue) { |
|
126 | 126 | global $wpdb; |
127 | 127 | $meta = maybe_unserialize($old_venue['meta']); |
128 | - $slug = $this->_find_unique_slug( $old_venue[ 'name' ], $old_venue[ 'identifier' ] ); |
|
128 | + $slug = $this->_find_unique_slug($old_venue['name'], $old_venue['identifier']); |
|
129 | 129 | $insertion_array = array( |
130 | - 'post_title'=>stripslashes($old_venue['name']),//VNU_name |
|
131 | - 'post_content'=>isset($meta['description']) ? stripslashes(strip_tags($meta['description'])) : '',//VNU_desc |
|
132 | - 'post_name'=> $slug,//VNU_identifier |
|
133 | - 'post_date'=>current_time('mysql'),//VNU_created |
|
134 | - 'post_date_gmt'=> current_time('mysql',true), |
|
135 | - 'post_excerpt'=>'',//wp_trim_words($meta['description'] ? $meta['description'] : '',50),//VNU_short_desc arbitraty only 50 characters |
|
136 | - 'post_modified'=>current_time('mysql'),//VNU_modified |
|
137 | - 'post_modified_gmt'=>current_time('mysql',true), |
|
138 | - 'post_author'=>$old_venue['wp_user'],//VNU_wp_user |
|
139 | - 'post_parent'=>0,//parent |
|
140 | - 'menu_order'=>0,//VNU_order |
|
130 | + 'post_title'=>stripslashes($old_venue['name']), //VNU_name |
|
131 | + 'post_content'=>isset($meta['description']) ? stripslashes(strip_tags($meta['description'])) : '', //VNU_desc |
|
132 | + 'post_name'=> $slug, //VNU_identifier |
|
133 | + 'post_date'=>current_time('mysql'), //VNU_created |
|
134 | + 'post_date_gmt'=> current_time('mysql', true), |
|
135 | + 'post_excerpt'=>'', //wp_trim_words($meta['description'] ? $meta['description'] : '',50),//VNU_short_desc arbitraty only 50 characters |
|
136 | + 'post_modified'=>current_time('mysql'), //VNU_modified |
|
137 | + 'post_modified_gmt'=>current_time('mysql', true), |
|
138 | + 'post_author'=>$old_venue['wp_user'], //VNU_wp_user |
|
139 | + 'post_parent'=>0, //parent |
|
140 | + 'menu_order'=>0, //VNU_order |
|
141 | 141 | 'post_type'=>'espresso_venues'//post_type |
142 | 142 | ); |
143 | 143 | $datatypes_array = array( |
144 | - '%s',//VNU_name |
|
145 | - '%s',//VNU_desc |
|
146 | - '%s',//VNU_identifier |
|
147 | - '%s',//VNU_created |
|
144 | + '%s', //VNU_name |
|
145 | + '%s', //VNU_desc |
|
146 | + '%s', //VNU_identifier |
|
147 | + '%s', //VNU_created |
|
148 | 148 | '%s', |
149 | - '%s',//VNU_short_desc |
|
150 | - '%s',//VNU_modified |
|
149 | + '%s', //VNU_short_desc |
|
150 | + '%s', //VNU_modified |
|
151 | 151 | '%s', |
152 | - '%d',//VNU_wp_user |
|
153 | - '%d',//parent |
|
154 | - '%d',//VNU_order |
|
155 | - '%s',//post_type |
|
152 | + '%d', //VNU_wp_user |
|
153 | + '%d', //parent |
|
154 | + '%d', //VNU_order |
|
155 | + '%s', //post_type |
|
156 | 156 | ); |
157 | 157 | $success = $wpdb->insert($this->_new_table, |
158 | 158 | $insertion_array, |
159 | 159 | $datatypes_array); |
160 | - if( ! $success ){ |
|
160 | + if ( ! $success) { |
|
161 | 161 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_venue, $this->_new_table, $insertion_array, $datatypes_array)); |
162 | 162 | return 0; |
163 | 163 | } |
@@ -171,11 +171,11 @@ discard block |
||
171 | 171 | * @param string $post_name |
172 | 172 | * @return string |
173 | 173 | */ |
174 | - private function _find_unique_slug($post_name, $old_identifier = '' ){ |
|
174 | + private function _find_unique_slug($post_name, $old_identifier = '') { |
|
175 | 175 | $count = 0; |
176 | - $original_name = $post_name ? sanitize_title( $post_name ) : $old_identifier; |
|
176 | + $original_name = $post_name ? sanitize_title($post_name) : $old_identifier; |
|
177 | 177 | $event_slug = $original_name; |
178 | - while( $this->_other_post_exists_with_that_slug($event_slug) && $count<50){ |
|
178 | + while ($this->_other_post_exists_with_that_slug($event_slug) && $count < 50) { |
|
179 | 179 | $event_slug = sanitize_title($original_name."-".++$count); |
180 | 180 | } |
181 | 181 | return $event_slug; |
@@ -187,11 +187,11 @@ discard block |
||
187 | 187 | * @param type $slug |
188 | 188 | * @return boolean |
189 | 189 | */ |
190 | - private function _other_post_exists_with_that_slug($slug){ |
|
190 | + private function _other_post_exists_with_that_slug($slug) { |
|
191 | 191 | global $wpdb; |
192 | - $query = $wpdb->prepare("SELECT COUNT(ID) FROM ".$this->_new_table." WHERE post_name = %s",$slug); |
|
192 | + $query = $wpdb->prepare("SELECT COUNT(ID) FROM ".$this->_new_table." WHERE post_name = %s", $slug); |
|
193 | 193 | $count = $wpdb->get_var($query); |
194 | - return (boolean)intval($count); |
|
194 | + return (boolean) intval($count); |
|
195 | 195 | } |
196 | 196 | |
197 | 197 | /** |
@@ -200,60 +200,60 @@ discard block |
||
200 | 200 | * @param type $old_venue |
201 | 201 | * @return int |
202 | 202 | */ |
203 | - private function _insert_into_meta_table($cpt_id,$old_venue){ |
|
203 | + private function _insert_into_meta_table($cpt_id, $old_venue) { |
|
204 | 204 | global $wpdb; |
205 | 205 | //get a country with the same name, or insert one |
206 | - try{ |
|
206 | + try { |
|
207 | 207 | $country = $this->get_migration_script()->get_or_create_country(stripslashes($old_venue['country'])); |
208 | 208 | $country_iso = $country['CNT_ISO']; |
209 | - }catch(EE_Error $e){ |
|
210 | - $this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue))); |
|
209 | + } catch (EE_Error $e) { |
|
210 | + $this->add_error(sprintf(__("%s for venue %s", "event_espresso"), $e->getMessage(), $this->_json_encode($old_venue))); |
|
211 | 211 | $country_iso = null; |
212 | 212 | } |
213 | 213 | //get a state with the same name, if possible |
214 | - try{ |
|
215 | - $state = $this->get_migration_script()->get_or_create_state(stripslashes($old_venue['state']),isset($country['CNT_name']) ? $country['CNT_name'] : strip_tags($old_venue['country'])); |
|
214 | + try { |
|
215 | + $state = $this->get_migration_script()->get_or_create_state(stripslashes($old_venue['state']), isset($country['CNT_name']) ? $country['CNT_name'] : strip_tags($old_venue['country'])); |
|
216 | 216 | $state_id = $state['STA_ID']; |
217 | - }catch(EE_Error $e){ |
|
218 | - $this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue))); |
|
217 | + } catch (EE_Error $e) { |
|
218 | + $this->add_error(sprintf(__("%s for venue %s", "event_espresso"), $e->getMessage(), $this->_json_encode($old_venue))); |
|
219 | 219 | $state_id = 0; |
220 | 220 | } |
221 | 221 | $meta = maybe_unserialize($old_venue['meta']); |
222 | 222 | //now insert into meta table |
223 | 223 | $insertion_array = array( |
224 | - 'VNU_ID'=>$cpt_id,//VNU_ID_fk |
|
225 | - 'VNU_address'=>stripslashes($old_venue['address']),//VNU_address |
|
226 | - 'VNU_address2'=>stripslashes($old_venue['address2']),//VNU_address2 |
|
227 | - 'VNU_city'=>stripslashes($old_venue['city']),//VNU_city |
|
228 | - 'STA_ID'=>$state_id,//STA_ID |
|
229 | - 'CNT_ISO'=>$country_iso,//CNT_ISO |
|
230 | - 'VNU_zip'=>stripslashes($old_venue['zip']),//VNU_zip |
|
231 | - 'VNU_phone'=>isset($meta['phone']) ? stripslashes($meta['phone']) : '',//VNU_phone |
|
232 | - 'VNU_capacity'=>-1,//VNU_capacity |
|
233 | - 'VNU_url'=>isset($meta['website']) ? stripslashes($meta['website']) : '',//VNU_url |
|
234 | - 'VNU_virtual_phone'=>'',//VNU_virtual_phone |
|
235 | - 'VNU_virtual_url'=>'',//VNU_virtual_url |
|
236 | - 'VNU_google_map_link'=>'',//VNU_google_map_link |
|
224 | + 'VNU_ID'=>$cpt_id, //VNU_ID_fk |
|
225 | + 'VNU_address'=>stripslashes($old_venue['address']), //VNU_address |
|
226 | + 'VNU_address2'=>stripslashes($old_venue['address2']), //VNU_address2 |
|
227 | + 'VNU_city'=>stripslashes($old_venue['city']), //VNU_city |
|
228 | + 'STA_ID'=>$state_id, //STA_ID |
|
229 | + 'CNT_ISO'=>$country_iso, //CNT_ISO |
|
230 | + 'VNU_zip'=>stripslashes($old_venue['zip']), //VNU_zip |
|
231 | + 'VNU_phone'=>isset($meta['phone']) ? stripslashes($meta['phone']) : '', //VNU_phone |
|
232 | + 'VNU_capacity'=>-1, //VNU_capacity |
|
233 | + 'VNU_url'=>isset($meta['website']) ? stripslashes($meta['website']) : '', //VNU_url |
|
234 | + 'VNU_virtual_phone'=>'', //VNU_virtual_phone |
|
235 | + 'VNU_virtual_url'=>'', //VNU_virtual_url |
|
236 | + 'VNU_google_map_link'=>'', //VNU_google_map_link |
|
237 | 237 | 'VNU_enable_for_gmap'=>true //VNU_enable_for_gmap |
238 | 238 | ); |
239 | 239 | $datatypes = array( |
240 | - '%d',//VNU_ID_fk |
|
241 | - '%s',//VNU_address |
|
242 | - '%s',//VNU_address2 |
|
243 | - '%s',//VNU_city |
|
244 | - '%d',//STA_ID |
|
245 | - '%s',//CNT_ISO |
|
246 | - '%s',//VNU_zip |
|
247 | - '%s',//VNU_phone |
|
248 | - '%d',//VNU_capacity |
|
249 | - '%s',//VNU_url |
|
250 | - '%s',//VNU_virtual_phone |
|
251 | - '%s',//VNU_virtual_url |
|
252 | - '%s',//VNU_google_map_link |
|
253 | - '%d',//VNU_enable_for_gmap |
|
240 | + '%d', //VNU_ID_fk |
|
241 | + '%s', //VNU_address |
|
242 | + '%s', //VNU_address2 |
|
243 | + '%s', //VNU_city |
|
244 | + '%d', //STA_ID |
|
245 | + '%s', //CNT_ISO |
|
246 | + '%s', //VNU_zip |
|
247 | + '%s', //VNU_phone |
|
248 | + '%d', //VNU_capacity |
|
249 | + '%s', //VNU_url |
|
250 | + '%s', //VNU_virtual_phone |
|
251 | + '%s', //VNU_virtual_url |
|
252 | + '%s', //VNU_google_map_link |
|
253 | + '%d', //VNU_enable_for_gmap |
|
254 | 254 | ); |
255 | - $success = $wpdb->insert($this->_new_meta_table,$insertion_array,$datatypes); |
|
256 | - if( ! $success ){ |
|
255 | + $success = $wpdb->insert($this->_new_meta_table, $insertion_array, $datatypes); |
|
256 | + if ( ! $success) { |
|
257 | 257 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_venue, $this->_new_meta_table, $insertion_array, $datatypes)); |
258 | 258 | return 0; |
259 | 259 | } |
@@ -128,6 +128,9 @@ discard block |
||
128 | 128 | return $items_actually_migrated; |
129 | 129 | } |
130 | 130 | |
131 | + /** |
|
132 | + * @param integer $num_items_to_migrate |
|
133 | + */ |
|
131 | 134 | private function _gather_relations_to_add($num_items_to_migrate) { |
132 | 135 | $relations_to_add_this_step = array(); |
133 | 136 | $migrate_up_to_count = $this->count_records_migrated() + $num_items_to_migrate; |
@@ -158,8 +161,6 @@ discard block |
||
158 | 161 | |
159 | 162 | /** |
160 | 163 | * Adds teh relation between the payment method and the currencies it can be used for |
161 | - * @param int $id |
|
162 | - * @param string $gateway_slug |
|
163 | 164 | */ |
164 | 165 | private function _add_currency_relations($pm_id,$currency_code){ |
165 | 166 | global $wpdb; |
@@ -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 | |
@@ -13,7 +13,7 @@ discard block |
||
13 | 13 | * @author Mike Nelson |
14 | 14 | * |
15 | 15 | */ |
16 | -class EE_DMS_4_6_0_payment_method_currencies extends EE_Data_Migration_Script_Stage{ |
|
16 | +class EE_DMS_4_6_0_payment_method_currencies extends EE_Data_Migration_Script_Stage { |
|
17 | 17 | protected $_currency_table_name; |
18 | 18 | protected $_currency_payment_method_table_name; |
19 | 19 | protected $_payment_method_table_name; |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | ); |
90 | 90 | public function __construct() { |
91 | 91 | global $wpdb; |
92 | - $this->_pretty_name = __( 'Payment Method Currencies', 'event_espresso' ); |
|
92 | + $this->_pretty_name = __('Payment Method Currencies', 'event_espresso'); |
|
93 | 93 | $this->_payment_method_table_name = $wpdb->prefix.'esp_payment_method'; |
94 | 94 | $this->_currency_payment_method_table_name = $wpdb->prefix.'esp_currency_payment_method'; |
95 | 95 | $this->_currency_table_name = $wpdb->prefix.'esp_currency'; |
@@ -98,8 +98,8 @@ discard block |
||
98 | 98 | |
99 | 99 | protected function _count_records_to_migrate() { |
100 | 100 | $count = 0; |
101 | - foreach($this->_gateway_currencies as $currencies){ |
|
102 | - if( $currencies == 'all'){ |
|
101 | + foreach ($this->_gateway_currencies as $currencies) { |
|
102 | + if ($currencies == 'all') { |
|
103 | 103 | $currencies = $this->_get_all_currencies(); |
104 | 104 | } |
105 | 105 | $count += count($currencies); |
@@ -109,20 +109,20 @@ discard block |
||
109 | 109 | |
110 | 110 | |
111 | 111 | |
112 | - protected function _migration_step( $num_items_to_migrate = 50 ) { |
|
112 | + protected function _migration_step($num_items_to_migrate = 50) { |
|
113 | 113 | $items_actually_migrated = 0; |
114 | 114 | $relations_to_add_this_step = $this->_gather_relations_to_add($num_items_to_migrate); |
115 | - foreach($relations_to_add_this_step as $pm_slug => $currencies){ |
|
115 | + foreach ($relations_to_add_this_step as $pm_slug => $currencies) { |
|
116 | 116 | |
117 | - $id = $this->get_migration_script()->get_mapping_new_pk( 'EE_Gateway_Config', $pm_slug, $this->_payment_method_table_name ); |
|
118 | - foreach( $currencies as $currency ){ |
|
119 | - if( $id ){ |
|
120 | - $this->_add_currency_relations( $id, $currency ); |
|
117 | + $id = $this->get_migration_script()->get_mapping_new_pk('EE_Gateway_Config', $pm_slug, $this->_payment_method_table_name); |
|
118 | + foreach ($currencies as $currency) { |
|
119 | + if ($id) { |
|
120 | + $this->_add_currency_relations($id, $currency); |
|
121 | 121 | } |
122 | 122 | $items_actually_migrated++; |
123 | 123 | } |
124 | 124 | } |
125 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
125 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
126 | 126 | $this->set_completed(); |
127 | 127 | } |
128 | 128 | return $items_actually_migrated; |
@@ -132,14 +132,14 @@ discard block |
||
132 | 132 | $relations_to_add_this_step = array(); |
133 | 133 | $migrate_up_to_count = $this->count_records_migrated() + $num_items_to_migrate; |
134 | 134 | $iterator = 0; |
135 | - foreach($this->_gateway_currencies as $pm_slug => $currencies){ |
|
136 | - if( $currencies == 'all' ){ |
|
135 | + foreach ($this->_gateway_currencies as $pm_slug => $currencies) { |
|
136 | + if ($currencies == 'all') { |
|
137 | 137 | $currencies = $this->_get_all_currencies(); |
138 | 138 | } |
139 | - foreach($currencies as $currency_code){ |
|
140 | - if( $this->count_records_migrated() <= $iterator && |
|
141 | - $iterator < $migrate_up_to_count ){ |
|
142 | - $relations_to_add_this_step[ $pm_slug ] [] = $currency_code; |
|
139 | + foreach ($currencies as $currency_code) { |
|
140 | + if ($this->count_records_migrated() <= $iterator && |
|
141 | + $iterator < $migrate_up_to_count) { |
|
142 | + $relations_to_add_this_step[$pm_slug] [] = $currency_code; |
|
143 | 143 | } |
144 | 144 | $iterator++; |
145 | 145 | } |
@@ -150,7 +150,7 @@ discard block |
||
150 | 150 | * Gets all the currency codes in the database |
151 | 151 | * @return array |
152 | 152 | */ |
153 | - private function _get_all_currencies(){ |
|
153 | + private function _get_all_currencies() { |
|
154 | 154 | global $wpdb; |
155 | 155 | $currencies = $wpdb->get_col("SELECT CUR_code FROM {$this->_currency_table_name}"); |
156 | 156 | return $currencies; |
@@ -161,7 +161,7 @@ discard block |
||
161 | 161 | * @param int $id |
162 | 162 | * @param string $gateway_slug |
163 | 163 | */ |
164 | - private function _add_currency_relations($pm_id,$currency_code){ |
|
164 | + private function _add_currency_relations($pm_id, $currency_code) { |
|
165 | 165 | global $wpdb; |
166 | 166 | $cur_pm_relation = array( |
167 | 167 | 'CUR_code'=>$currency_code, |
@@ -170,11 +170,11 @@ discard block |
||
170 | 170 | $success = $wpdb->insert($this->_currency_payment_method_table_name, |
171 | 171 | $cur_pm_relation, |
172 | 172 | array( |
173 | - '%s',//CUR_code |
|
174 | - '%d',//PMD_ID |
|
173 | + '%s', //CUR_code |
|
174 | + '%d', //PMD_ID |
|
175 | 175 | )); |
176 | - if( ! $success ){ |
|
177 | - $this->add_error( sprintf( __( 'Could not add currency relation %s because %s', "event_espresso" ), json_encode( $cur_pm_relation ), $wpdb->last_error ) ); |
|
176 | + if ( ! $success) { |
|
177 | + $this->add_error(sprintf(__('Could not add currency relation %s because %s', "event_espresso"), json_encode($cur_pm_relation), $wpdb->last_error)); |
|
178 | 178 | } |
179 | 179 | } |
180 | 180 | } |
@@ -49,7 +49,6 @@ |
||
49 | 49 | /** |
50 | 50 | * |
51 | 51 | * @global type $wpdb |
52 | - * @param int $id |
|
53 | 52 | * @return string |
54 | 53 | */ |
55 | 54 | protected function _get_payment_method_id_by_gateway_name( $gateway_name ){ |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | -if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
3 | - exit( 'No direct script access allowed' ); |
|
2 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
3 | + exit('No direct script access allowed'); |
|
4 | 4 | } |
5 | 5 | |
6 | 6 | /** |
@@ -12,38 +12,38 @@ discard block |
||
12 | 12 | * @author Mike Nelson |
13 | 13 | * |
14 | 14 | */ |
15 | -class EE_DMS_4_6_0_transactions extends EE_Data_Migration_Script_Stage_Table{ |
|
15 | +class EE_DMS_4_6_0_transactions extends EE_Data_Migration_Script_Stage_Table { |
|
16 | 16 | protected $_transaction_table; |
17 | 17 | protected $_payment_method_table; |
18 | - function __construct(){ |
|
18 | + function __construct() { |
|
19 | 19 | global $wpdb; |
20 | - $this->_old_table = $wpdb->prefix . 'esp_extra_meta'; |
|
21 | - $this->_transaction_table = $wpdb->prefix . 'esp_transaction'; |
|
22 | - $this->_payment_method_table = $wpdb->prefix . 'esp_payment_method'; |
|
20 | + $this->_old_table = $wpdb->prefix.'esp_extra_meta'; |
|
21 | + $this->_transaction_table = $wpdb->prefix.'esp_transaction'; |
|
22 | + $this->_payment_method_table = $wpdb->prefix.'esp_payment_method'; |
|
23 | 23 | $this->_pretty_name = __('Transaction Payment Method Relations', 'event_espresso'); |
24 | 24 | $this->_extra_where_sql = "WHERE EXM_key = 'gateway' AND EXM_type = 'Transaction'"; |
25 | 25 | parent::__construct(); |
26 | 26 | } |
27 | - protected function _migrate_old_row( $extra_meta_row ) { |
|
27 | + protected function _migrate_old_row($extra_meta_row) { |
|
28 | 28 | global $wpdb; |
29 | 29 | //get the payment method's ID |
30 | - $PMD_ID = $this->_get_payment_method_id_by_gateway_name( $extra_meta_row[ 'EXM_value' ] ); |
|
31 | - if( ! $PMD_ID ){ |
|
32 | - $this->add_error( sprintf( __( 'Could not find payment method with PMD_type = \'%1$s\' when migrating extra meta row %2$s', 'event_espresso' ), $extra_meta_row[ 'EXM_value' ], $this->_json_encode( $extra_meta_row ) ) ); |
|
30 | + $PMD_ID = $this->_get_payment_method_id_by_gateway_name($extra_meta_row['EXM_value']); |
|
31 | + if ( ! $PMD_ID) { |
|
32 | + $this->add_error(sprintf(__('Could not find payment method with PMD_type = \'%1$s\' when migrating extra meta row %2$s', 'event_espresso'), $extra_meta_row['EXM_value'], $this->_json_encode($extra_meta_row))); |
|
33 | 33 | return; |
34 | 34 | } |
35 | - $new_values = array( 'PMD_ID' => $PMD_ID ); |
|
36 | - $wheres = array( 'TXN_ID' => $extra_meta_row[ 'OBJ_ID' ] ); |
|
37 | - $new_value_datatypes = array( '%d' ); |
|
38 | - $where_datatypes = array( '%d' ); |
|
39 | - $success = $wpdb->update( $this->_transaction_table, |
|
35 | + $new_values = array('PMD_ID' => $PMD_ID); |
|
36 | + $wheres = array('TXN_ID' => $extra_meta_row['OBJ_ID']); |
|
37 | + $new_value_datatypes = array('%d'); |
|
38 | + $where_datatypes = array('%d'); |
|
39 | + $success = $wpdb->update($this->_transaction_table, |
|
40 | 40 | $new_values, |
41 | 41 | $wheres, |
42 | 42 | $new_value_datatypes, |
43 | 43 | $where_datatypes |
44 | 44 | ); |
45 | - if( ! $success ){ |
|
46 | - $this->add_error( sprintf( __( 'Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso' ), $this->_json_encode( $new_values ), $this->_transaction_table, $this->_json_encode( $wheres ) ) ); |
|
45 | + if ( ! $success) { |
|
46 | + $this->add_error(sprintf(__('Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso'), $this->_json_encode($new_values), $this->_transaction_table, $this->_json_encode($wheres))); |
|
47 | 47 | } |
48 | 48 | } |
49 | 49 | /** |
@@ -52,9 +52,9 @@ discard block |
||
52 | 52 | * @param int $id |
53 | 53 | * @return string |
54 | 54 | */ |
55 | - protected function _get_payment_method_id_by_gateway_name( $gateway_name ){ |
|
55 | + protected function _get_payment_method_id_by_gateway_name($gateway_name) { |
|
56 | 56 | global $wpdb; |
57 | - return $wpdb->get_var( $wpdb->prepare( "SELECT PMD_ID FROM " . $wpdb->prefix . "esp_payment_method WHERE PMD_type = %s", $gateway_name ) ); |
|
57 | + return $wpdb->get_var($wpdb->prepare("SELECT PMD_ID FROM ".$wpdb->prefix."esp_payment_method WHERE PMD_type = %s", $gateway_name)); |
|
58 | 58 | } |
59 | 59 | |
60 | 60 |
@@ -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(); |
@@ -17,7 +17,7 @@ discard block |
||
17 | 17 | |
18 | 18 | |
19 | 19 | |
20 | -abstract class EE_Data_Migration_Class_Base{ |
|
20 | +abstract class EE_Data_Migration_Class_Base { |
|
21 | 21 | /** |
22 | 22 | * @var $records_to_migrate int count of all that have been migrated |
23 | 23 | */ |
@@ -50,7 +50,7 @@ discard block |
||
50 | 50 | * Just initializes the status of the migration |
51 | 51 | * @throws EE_Error |
52 | 52 | */ |
53 | - public function __construct(){ |
|
53 | + public function __construct() { |
|
54 | 54 | $this->set_status(EE_Data_Migration_Manager::status_continue); |
55 | 55 | } |
56 | 56 | |
@@ -61,9 +61,9 @@ discard block |
||
61 | 61 | * @throws EE_Error |
62 | 62 | * @return string |
63 | 63 | */ |
64 | - public function pretty_name(){ |
|
65 | - if($this->_pretty_name === null){ |
|
66 | - 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))); |
|
64 | + public function pretty_name() { |
|
65 | + if ($this->_pretty_name === null) { |
|
66 | + 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))); |
|
67 | 67 | } |
68 | 68 | return $this->_pretty_name; |
69 | 69 | } |
@@ -71,8 +71,8 @@ discard block |
||
71 | 71 | * |
72 | 72 | * @return int |
73 | 73 | */ |
74 | - public function count_records_to_migrate(){ |
|
75 | - if( $this->_records_to_migrate == null){ |
|
74 | + public function count_records_to_migrate() { |
|
75 | + if ($this->_records_to_migrate == null) { |
|
76 | 76 | $this->_records_to_migrate = $this->_count_records_to_migrate(); |
77 | 77 | } |
78 | 78 | return $this->_records_to_migrate; |
@@ -92,9 +92,9 @@ discard block |
||
92 | 92 | * @return string one of EE_Data_Migration_Manager::status_* constants |
93 | 93 | * @throws EE_Error |
94 | 94 | */ |
95 | - public function get_status(){ |
|
96 | - if($this->_status === null){ |
|
97 | - 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))); |
|
95 | + public function get_status() { |
|
96 | + if ($this->_status === null) { |
|
97 | + 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))); |
|
98 | 98 | } |
99 | 99 | return $this->_status; |
100 | 100 | } |
@@ -103,7 +103,7 @@ discard block |
||
103 | 103 | * @param string $status |
104 | 104 | * @return void |
105 | 105 | */ |
106 | - protected function set_status($status){ |
|
106 | + protected function set_status($status) { |
|
107 | 107 | $this->_status = $status; |
108 | 108 | } |
109 | 109 | /** |
@@ -115,11 +115,11 @@ discard block |
||
115 | 115 | * Returns the last error that occurred. If none occurred, returns null |
116 | 116 | * @return string |
117 | 117 | */ |
118 | - public function get_last_error(){ |
|
118 | + public function get_last_error() { |
|
119 | 119 | $errors = $this->get_errors(); |
120 | - if($errors){ |
|
120 | + if ($errors) { |
|
121 | 121 | return end($errors); |
122 | - }else{ |
|
122 | + } else { |
|
123 | 123 | return null; |
124 | 124 | } |
125 | 125 | } |
@@ -128,26 +128,26 @@ discard block |
||
128 | 128 | * @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. |
129 | 129 | * @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 |
130 | 130 | */ |
131 | - public function add_error($error, $force = FALSE ){ |
|
132 | - if( ! defined( 'EE_DMS_ERROR_LIMIT' ) ){ |
|
131 | + public function add_error($error, $force = FALSE) { |
|
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 |
138 | - if( is_string( $this->_errors ) ){ |
|
139 | - $this->_errors = array( $this->_errors ); |
|
138 | + if (is_string($this->_errors)) { |
|
139 | + $this->_errors = array($this->_errors); |
|
140 | 140 | } |
141 | - if(count($this->_errors) >= $limit ){ |
|
142 | - if( $force ){ |
|
141 | + if (count($this->_errors) >= $limit) { |
|
142 | + if ($force) { |
|
143 | 143 | //get rid of the first half of the errors and any above the limit |
144 | - $this->_errors = array_slice( $this->_errors, $limit / 2, $limit / 2 ); |
|
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{ |
|
148 | - $this->_errors[ $limit ] = 'More, but limit reached...'; |
|
147 | + } else { |
|
148 | + $this->_errors[$limit] = 'More, but limit reached...'; |
|
149 | 149 | } |
150 | - }else{ |
|
150 | + } else { |
|
151 | 151 | $this->_errors[] = $error; |
152 | 152 | } |
153 | 153 | } |
@@ -156,57 +156,57 @@ discard block |
||
156 | 156 | * Indicates there was a fatal error and the migration cannot possibly continue |
157 | 157 | * @return boolean |
158 | 158 | */ |
159 | - public function is_broken(){ |
|
159 | + public function is_broken() { |
|
160 | 160 | return $this->get_status() == EE_Data_Migration_Manager::status_fatal_error; |
161 | 161 | } |
162 | 162 | /** |
163 | 163 | * @deprecated since 4.6.12 |
164 | 164 | */ |
165 | - public function is_borked(){ |
|
166 | - 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'); |
|
165 | + public function is_borked() { |
|
166 | + 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'); |
|
167 | 167 | return $this->is_broken(); |
168 | 168 | } |
169 | 169 | /** |
170 | 170 | * Sets the status to as having a fatal error |
171 | 171 | */ |
172 | - public function set_broken(){ |
|
172 | + public function set_broken() { |
|
173 | 173 | $this->_status = EE_Data_Migration_Manager::status_fatal_error; |
174 | 174 | } |
175 | 175 | /** |
176 | 176 | * |
177 | 177 | * @deprecated since 4.6.12 |
178 | 178 | */ |
179 | - public function set_borked(){ |
|
180 | - 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'); |
|
179 | + public function set_borked() { |
|
180 | + 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'); |
|
181 | 181 | return $this->set_broken(); |
182 | 182 | } |
183 | 183 | /** |
184 | 184 | * Checks if this thing believes it is completed |
185 | 185 | * @return boolean |
186 | 186 | */ |
187 | - public function is_completed(){ |
|
187 | + public function is_completed() { |
|
188 | 188 | return $this->get_status() == EE_Data_Migration_Manager::status_completed; |
189 | 189 | } |
190 | 190 | /** |
191 | 191 | * Checks if the current script has more to do or not (ie, if it's status is CONTINUE) |
192 | 192 | * @return boolean |
193 | 193 | */ |
194 | - public function has_more_to_do(){ |
|
194 | + public function has_more_to_do() { |
|
195 | 195 | return $this->get_status() == EE_Data_Migration_Manager::status_continue; |
196 | 196 | } |
197 | 197 | /** |
198 | 198 | * Marks that we believe this migration thing is completed |
199 | 199 | */ |
200 | - public function set_completed(){ |
|
200 | + public function set_completed() { |
|
201 | 201 | $this->_status = EE_Data_Migration_Manager::status_completed; |
202 | 202 | } |
203 | 203 | |
204 | 204 | /** |
205 | 205 | * Marks that we think this migration class can continue to migrate |
206 | 206 | */ |
207 | - public function reattempt(){ |
|
207 | + public function reattempt() { |
|
208 | 208 | $this->_status = EE_Data_Migration_Manager::status_continue; |
209 | - $this->add_error( __( 'Reattempt migration', 'event_espresso' ), TRUE ); |
|
209 | + $this->add_error(__('Reattempt migration', 'event_espresso'), TRUE); |
|
210 | 210 | } |
211 | 211 | |
212 | 212 | /** |
@@ -215,8 +215,8 @@ discard block |
||
215 | 215 | * possible that this class is defined when it goes to sleep, but NOT available when it |
216 | 216 | * awakes (eg, this class is part of an addon that is deactivated at some point). |
217 | 217 | */ |
218 | - public function properties_as_array(){ |
|
219 | - $properties = get_object_vars($this); |
|
218 | + public function properties_as_array() { |
|
219 | + $properties = get_object_vars($this); |
|
220 | 220 | $properties['class'] = get_class($this); |
221 | 221 | unset($properties['_migration_script']); |
222 | 222 | return $properties; |
@@ -237,22 +237,22 @@ discard block |
||
237 | 237 | * @param array $data_types numerically indexed |
238 | 238 | * @return string |
239 | 239 | */ |
240 | - protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types){ |
|
240 | + protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types) { |
|
241 | 241 | global $wpdb; |
242 | 242 | $old_columns_and_values_for_string = array(); |
243 | - foreach($old_row_as_array as $column => $value){ |
|
243 | + foreach ($old_row_as_array as $column => $value) { |
|
244 | 244 | $old_columns_and_values_for_string[] = "$column => $value"; |
245 | 245 | } |
246 | 246 | $new_columns_and_values_for_string = array(); |
247 | 247 | $count = 0; |
248 | - foreach($new_row_as_array as $column => $value){ |
|
248 | + foreach ($new_row_as_array as $column => $value) { |
|
249 | 249 | $new_columns_and_values_for_string[] = " $column => $value (".$data_types[$count++].")"; |
250 | 250 | } |
251 | 251 | return sprintf( |
252 | 252 | __('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"), |
253 | - implode(", ",$new_columns_and_values_for_string), |
|
253 | + implode(", ", $new_columns_and_values_for_string), |
|
254 | 254 | $new_table, |
255 | - implode(", ",$old_columns_and_values_for_string), |
|
255 | + implode(", ", $old_columns_and_values_for_string), |
|
256 | 256 | $old_table, |
257 | 257 | '<br/>', |
258 | 258 | $wpdb->last_error |
@@ -267,12 +267,12 @@ discard block |
||
267 | 267 | * @param array $array_of_data |
268 | 268 | * @return string |
269 | 269 | */ |
270 | - protected function _json_encode($array_of_data){ |
|
270 | + protected function _json_encode($array_of_data) { |
|
271 | 271 | //we'd rather NOT serialize the transaction details |
272 | 272 | $fields_to_include = array(); |
273 | - foreach($array_of_data as $name => $value){ |
|
273 | + foreach ($array_of_data as $name => $value) { |
|
274 | 274 | $unserialized_data = @unserialize($value); |
275 | - if($unserialized_data === FALSE){ |
|
275 | + if ($unserialized_data === FALSE) { |
|
276 | 276 | $fields_to_include[$name] = $value; |
277 | 277 | } |
278 | 278 | } |
@@ -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 | } |
@@ -1434,7 +1434,6 @@ discard block |
||
1434 | 1434 | /** |
1435 | 1435 | * Makes sure the 3.1's image url is converted to an image attachment post to the 4.1 CPT event |
1436 | 1436 | * and sets it as the featured image on the CPT event |
1437 | - * @param type $old_event |
|
1438 | 1437 | * @param type $new_cpt_id |
1439 | 1438 | * @param EE_Data_Migration_Script_Stage $migration_stage the stage which called this, where errors should be added |
1440 | 1439 | * @return boolean whether or not we had to do the big job of creating an image attachment |
@@ -1482,7 +1481,7 @@ discard block |
||
1482 | 1481 | /** |
1483 | 1482 | * Creates an image attachment post for the GUID. If the GUID points to a remote image, |
1484 | 1483 | * we download it to our uploads directory so that it can be properly processed (eg, creates different sizes of thumbnails) |
1485 | - * @param type $guid |
|
1484 | + * @param string $guid |
|
1486 | 1485 | * @param EE_Data_Migration_Script_Stage $migration_stage |
1487 | 1486 | * @return int |
1488 | 1487 | */ |
@@ -1558,7 +1557,7 @@ discard block |
||
1558 | 1557 | /** |
1559 | 1558 | * Returns a mysql-formatted DATETIME in UTC time, given a $DATETIME_string |
1560 | 1559 | * (and optionally a timezone; if none is given, the wp DEFAULT is used) |
1561 | - * @param EE_Data_Migration_Script_base $stage |
|
1560 | + * @param EE_Data_Migration_Script_Stage $stage |
|
1562 | 1561 | * @param array $row_of_data, the row from the DB (as an array) we're trying to find the UTC time for |
1563 | 1562 | * @param string $DATETIME_string |
1564 | 1563 | * @param string $timezone |
@@ -1607,19 +1607,19 @@ |
||
1607 | 1607 | private function timezone_convert_to_string_from_offset($offset){ |
1608 | 1608 | //shamelessly taken from bottom comment at http://ca1.php.net/manual/en/function.timezone-name-from-abbr.php because timezone_name_from_abbr() did NOT work as expected - its not reliable |
1609 | 1609 | $offset *= 3600; // convert hour offset to seconds |
1610 | - $abbrarray = timezone_abbreviations_list(); |
|
1611 | - foreach ($abbrarray as $abbr){ |
|
1612 | - foreach ($abbr as $city) |
|
1613 | - { |
|
1614 | - if ($city['offset'] == $offset) |
|
1615 | - { |
|
1616 | - |
|
1617 | - return $city['timezone_id']; |
|
1618 | - } |
|
1619 | - } |
|
1620 | - } |
|
1621 | - |
|
1622 | - return FALSE; |
|
1610 | + $abbrarray = timezone_abbreviations_list(); |
|
1611 | + foreach ($abbrarray as $abbr){ |
|
1612 | + foreach ($abbr as $city) |
|
1613 | + { |
|
1614 | + if ($city['offset'] == $offset) |
|
1615 | + { |
|
1616 | + |
|
1617 | + return $city['timezone_id']; |
|
1618 | + } |
|
1619 | + } |
|
1620 | + } |
|
1621 | + |
|
1622 | + return FALSE; |
|
1623 | 1623 | } |
1624 | 1624 | |
1625 | 1625 | public function migration_page_hooks(){ |
@@ -72,7 +72,7 @@ discard block |
||
72 | 72 | $results = $wpdb->get_results("SHOW TABLES LIKE '".$wpdb->prefix."events_attendee_checkin"."'"); |
73 | 73 | if($results){ |
74 | 74 | return true; |
75 | - }else{ |
|
75 | + } else{ |
|
76 | 76 | return false; |
77 | 77 | } |
78 | 78 | } |
@@ -81,12 +81,12 @@ discard block |
||
81 | 81 | if($version_string < '4.0.0' && $version_string > '3.1.26' ){ |
82 | 82 | // echo "$version_string can be migrated fro"; |
83 | 83 | return true; |
84 | - }elseif( ! $version_string ){ |
|
84 | + } elseif( ! $version_string ){ |
|
85 | 85 | // echo "no version string provided: $version_string"; |
86 | 86 | //no version string provided... this must be pre 4.1 |
87 | 87 | //because since 4.1 we're |
88 | 88 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
89 | - }else{ |
|
89 | + } else{ |
|
90 | 90 | // echo "$version_string doesnt apply"; |
91 | 91 | return false; |
92 | 92 | } |
@@ -1088,7 +1088,7 @@ discard block |
||
1088 | 1088 | try{ |
1089 | 1089 | $country = $this->get_or_create_country($country_name); |
1090 | 1090 | $country_iso = $country['CNT_ISO']; |
1091 | - }catch(EE_Error $e){ |
|
1091 | + } catch(EE_Error $e){ |
|
1092 | 1092 | $country_iso = $this->get_default_country_iso(); |
1093 | 1093 | } |
1094 | 1094 | global $wpdb; |
@@ -1132,7 +1132,7 @@ discard block |
||
1132 | 1132 | if( ! $matches || count($matches)<3){ |
1133 | 1133 | $hour = '00'; |
1134 | 1134 | $minutes = '00'; |
1135 | - }else{ |
|
1135 | + } else{ |
|
1136 | 1136 | $hour = intval($matches[1]); |
1137 | 1137 | $minutes = $matches[2]; |
1138 | 1138 | } |
@@ -1408,7 +1408,7 @@ discard block |
||
1408 | 1408 | //EE team can read the related discussion: https://app.asana.com/0/2400967562914/9418495544455 |
1409 | 1409 | if($this_thing_required_pre_approval){ |
1410 | 1410 | return 'RNA'; |
1411 | - }else{ |
|
1411 | + } else{ |
|
1412 | 1412 | $mapping = $default_reg_stati_conversions=array( |
1413 | 1413 | 'Completed'=>'RAP', |
1414 | 1414 | ''=>'RPP', |
@@ -1453,7 +1453,7 @@ discard block |
||
1453 | 1453 | //double-check we actually have an attachment post |
1454 | 1454 | if( $attachment_post_id){ |
1455 | 1455 | update_post_meta($new_cpt_id,'_thumbnail_id',$attachment_post_id); |
1456 | - }else{ |
|
1456 | + } else{ |
|
1457 | 1457 | $migration_stage->add_error(sprintf(__("Could not update event image %s for CPT with ID %d, but attachments post ID is %d", "event_espresso"),$guid,$new_cpt_id,$attachment_post_id)); |
1458 | 1458 | } |
1459 | 1459 | } |
@@ -1474,7 +1474,7 @@ discard block |
||
1474 | 1474 | $head_response = wp_remote_head($original_guid); |
1475 | 1475 | if( ! $head_response instanceof WP_Error && $head_response['response']['message'] == 'OK'){ |
1476 | 1476 | return $original_guid; |
1477 | - }else{ |
|
1477 | + } else{ |
|
1478 | 1478 | return $guid_in_old_event; |
1479 | 1479 | } |
1480 | 1480 | } |
@@ -1510,7 +1510,7 @@ discard block |
||
1510 | 1510 | fwrite($savefile, $contents); |
1511 | 1511 | fclose($savefile); |
1512 | 1512 | $guid = str_replace($wp_upload_dir['path'],$wp_upload_dir['url'],$local_filepath); |
1513 | - }else{ |
|
1513 | + } else{ |
|
1514 | 1514 | $local_filepath = str_replace($wp_upload_dir['url'],$wp_upload_dir['path'],$guid); |
1515 | 1515 | } |
1516 | 1516 | |
@@ -1576,7 +1576,7 @@ discard block |
||
1576 | 1576 | try{ |
1577 | 1577 | $date_obj = new DateTime( $DATETIME_string, new DateTimeZone( $timezone ) ); |
1578 | 1578 | $date_obj->setTimezone(new DateTimeZone('UTC')); |
1579 | - }catch(Exception $e){ |
|
1579 | + } catch(Exception $e){ |
|
1580 | 1580 | $stage->add_error(sprintf(__("Could not convert time string '%s' using timezone '%s' into a proper DATETIME. Using current time instead.", "event_espresso"),$DATETIME_string,$timezone)); |
1581 | 1581 | $date_obj = new DateTime(); |
1582 | 1582 | } |
@@ -8,15 +8,15 @@ discard block |
||
8 | 8 | //(all other times it gets resurrected from a wordpress option) |
9 | 9 | $stages = glob(EE_CORE.'data_migration_scripts/4_1_0_stages/*'); |
10 | 10 | $class_to_filepath = array(); |
11 | -if ( ! empty( $stages ) ) { |
|
12 | - foreach($stages as $filepath){ |
|
11 | +if ( ! empty($stages)) { |
|
12 | + foreach ($stages as $filepath) { |
|
13 | 13 | $matches = array(); |
14 | - preg_match('~4_1_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
14 | + preg_match('~4_1_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
15 | 15 | $class_to_filepath[$matches[1]] = $filepath; |
16 | 16 | } |
17 | 17 | } |
18 | 18 | //give addons a chance to autoload their stages too |
19 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_1_0__autoloaded_stages',$class_to_filepath); |
|
19 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_1_0__autoloaded_stages', $class_to_filepath); |
|
20 | 20 | EEH_Autoloader::register_autoloader($class_to_filepath); |
21 | 21 | |
22 | 22 | /** |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | * --a function named update_espresso_config() which saves the EE_Config object to the database |
35 | 35 | * --...and all its subclasses... really, you're best off copying the whole thin gwhen 4.1 is released into this file and wrapping its declaration in if( ! class_exists()){...} |
36 | 36 | */ |
37 | -class EE_DMS_Core_4_1_0 extends EE_Data_Migration_Script_Base{ |
|
37 | +class EE_DMS_Core_4_1_0 extends EE_Data_Migration_Script_Base { |
|
38 | 38 | |
39 | 39 | |
40 | 40 | |
@@ -67,26 +67,26 @@ discard block |
||
67 | 67 | * @global type $wpdb |
68 | 68 | * @return boolean |
69 | 69 | */ |
70 | - private function _checkin_table_exists(){ |
|
70 | + private function _checkin_table_exists() { |
|
71 | 71 | global $wpdb; |
72 | 72 | $results = $wpdb->get_results("SHOW TABLES LIKE '".$wpdb->prefix."events_attendee_checkin"."'"); |
73 | - if($results){ |
|
73 | + if ($results) { |
|
74 | 74 | return true; |
75 | - }else{ |
|
75 | + } else { |
|
76 | 76 | return false; |
77 | 77 | } |
78 | 78 | } |
79 | 79 | public function can_migrate_from_version($version_array) { |
80 | 80 | $version_string = $version_array['Core']; |
81 | - if($version_string < '4.0.0' && $version_string > '3.1.26' ){ |
|
81 | + if ($version_string < '4.0.0' && $version_string > '3.1.26') { |
|
82 | 82 | // echo "$version_string can be migrated fro"; |
83 | 83 | return true; |
84 | - }elseif( ! $version_string ){ |
|
84 | + }elseif ( ! $version_string) { |
|
85 | 85 | // echo "no version string provided: $version_string"; |
86 | 86 | //no version string provided... this must be pre 4.1 |
87 | 87 | //because since 4.1 we're |
88 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
89 | - }else{ |
|
88 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
89 | + } else { |
|
90 | 90 | // echo "$version_string doesnt apply"; |
91 | 91 | return false; |
92 | 92 | } |
@@ -96,15 +96,15 @@ discard block |
||
96 | 96 | } |
97 | 97 | public function schema_changes_before_migration() { |
98 | 98 | //relies on 4.1's EEH_Activation::create_table |
99 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
99 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
100 | 100 | |
101 | - $table_name='esp_answer'; |
|
102 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
101 | + $table_name = 'esp_answer'; |
|
102 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
103 | 103 | REG_ID INT UNSIGNED NOT NULL, |
104 | 104 | QST_ID INT UNSIGNED NOT NULL, |
105 | 105 | ANS_value TEXT NOT NULL, |
106 | 106 | PRIMARY KEY (ANS_ID)"; |
107 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
107 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
108 | 108 | |
109 | 109 | $table_name = 'esp_attendee_meta'; |
110 | 110 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -144,7 +144,7 @@ discard block |
||
144 | 144 | CNT_is_EU TINYINT(1) DEFAULT '0', |
145 | 145 | CNT_active TINYINT(1) DEFAULT '0', |
146 | 146 | PRIMARY KEY (CNT_ISO)"; |
147 | - $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
147 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
148 | 148 | |
149 | 149 | |
150 | 150 | |
@@ -165,7 +165,7 @@ discard block |
||
165 | 165 | |
166 | 166 | |
167 | 167 | |
168 | - $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
168 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
169 | 169 | $table_name = 'esp_event_meta'; |
170 | 170 | $sql = " |
171 | 171 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -182,41 +182,41 @@ discard block |
||
182 | 182 | EVT_external_URL VARCHAR(200) NULL, |
183 | 183 | EVT_donations TINYINT(1) NULL, |
184 | 184 | PRIMARY KEY (EVTM_ID)"; |
185 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
185 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
186 | 186 | |
187 | 187 | |
188 | 188 | |
189 | - $table_name='esp_event_question_group'; |
|
190 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
189 | + $table_name = 'esp_event_question_group'; |
|
190 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
191 | 191 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
192 | 192 | QSG_ID INT UNSIGNED NOT NULL, |
193 | 193 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
194 | 194 | PRIMARY KEY (EQG_ID)"; |
195 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
195 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
196 | 196 | |
197 | 197 | |
198 | 198 | |
199 | - $table_name='esp_event_venue'; |
|
200 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
199 | + $table_name = 'esp_event_venue'; |
|
200 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
201 | 201 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
202 | 202 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
203 | 203 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
204 | 204 | PRIMARY KEY (EVV_ID)"; |
205 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
205 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
206 | 206 | |
207 | 207 | |
208 | 208 | |
209 | - $table_name='esp_extra_meta'; |
|
210 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
209 | + $table_name = 'esp_extra_meta'; |
|
210 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
211 | 211 | OBJ_ID INT(11) DEFAULT NULL, |
212 | 212 | EXM_type VARCHAR(45) DEFAULT NULL, |
213 | 213 | EXM_key VARCHAR(45) DEFAULT NULL, |
214 | 214 | EXM_value TEXT, |
215 | 215 | PRIMARY KEY (EXM_ID)"; |
216 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
216 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
217 | 217 | |
218 | - $table_name='esp_line_item'; |
|
219 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
218 | + $table_name = 'esp_line_item'; |
|
219 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
220 | 220 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
221 | 221 | TXN_ID INT(11) DEFAULT NULL, |
222 | 222 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -232,7 +232,7 @@ discard block |
||
232 | 232 | OBJ_ID INT(11) DEFAULT NULL, |
233 | 233 | OBJ_type VARCHAR(45)DEFAULT NULL, |
234 | 234 | PRIMARY KEY (LIN_ID)"; |
235 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB' ); |
|
235 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
236 | 236 | |
237 | 237 | $table_name = 'esp_message_template'; |
238 | 238 | $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -259,7 +259,7 @@ discard block |
||
259 | 259 | PRIMARY KEY (GRP_ID), |
260 | 260 | KEY EVT_ID (EVT_ID), |
261 | 261 | KEY MTP_user_id (MTP_user_id)"; |
262 | - $this->_table_is_new_in_this_version( $table_name, $sql, 'ENGINE=InnoDB'); |
|
262 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
263 | 263 | |
264 | 264 | |
265 | 265 | |
@@ -367,8 +367,8 @@ discard block |
||
367 | 367 | |
368 | 368 | |
369 | 369 | |
370 | - $table_name='esp_question'; |
|
371 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
370 | + $table_name = 'esp_question'; |
|
371 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
372 | 372 | QST_display_text TEXT NOT NULL, |
373 | 373 | QST_admin_label VARCHAR(255) NOT NULL, |
374 | 374 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -380,12 +380,12 @@ discard block |
||
380 | 380 | QST_wp_user BIGINT UNSIGNED NULL, |
381 | 381 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
382 | 382 | PRIMARY KEY (QST_ID)'; |
383 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
383 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
384 | 384 | |
385 | - EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
385 | + EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
386 | 386 | |
387 | 387 | $table_name = 'esp_question_group'; |
388 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
388 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
389 | 389 | QSG_name VARCHAR(255) NOT NULL, |
390 | 390 | QSG_identifier VARCHAR(100) NOT NULL, |
391 | 391 | QSG_desc TEXT NULL, |
@@ -396,27 +396,27 @@ discard block |
||
396 | 396 | QSG_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
397 | 397 | PRIMARY KEY (QSG_ID), |
398 | 398 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
399 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
399 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
400 | 400 | |
401 | 401 | |
402 | 402 | |
403 | - $table_name='esp_question_group_question'; |
|
404 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
403 | + $table_name = 'esp_question_group_question'; |
|
404 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
405 | 405 | QSG_ID INT UNSIGNED NOT NULL, |
406 | 406 | QST_ID INT UNSIGNED NOT NULL, |
407 | 407 | PRIMARY KEY (QGQ_ID) "; |
408 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
408 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
409 | 409 | |
410 | 410 | |
411 | 411 | |
412 | - $table_name='esp_question_option'; |
|
413 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
412 | + $table_name = 'esp_question_option'; |
|
413 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
414 | 414 | QSO_value VARCHAR(255) NOT NULL, |
415 | 415 | QSO_desc TEXT NOT NULL, |
416 | 416 | QST_ID INT UNSIGNED NOT NULL, |
417 | 417 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
418 | 418 | PRIMARY KEY (QSO_ID)"; |
419 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
419 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
420 | 420 | |
421 | 421 | |
422 | 422 | |
@@ -449,8 +449,8 @@ discard block |
||
449 | 449 | |
450 | 450 | |
451 | 451 | |
452 | - $table_name='esp_checkin'; |
|
453 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
452 | + $table_name = 'esp_checkin'; |
|
453 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
454 | 454 | REG_ID INT(10) UNSIGNED NOT NULL, |
455 | 455 | DTT_ID INT(10) UNSIGNED NOT NULL, |
456 | 456 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -557,12 +557,12 @@ discard block |
||
557 | 557 | |
558 | 558 | global $wpdb; |
559 | 559 | $state_table = $wpdb->prefix."esp_state"; |
560 | - if ( EEH_Activation::table_exists( $state_table ) ) { |
|
560 | + if (EEH_Activation::table_exists($state_table)) { |
|
561 | 561 | |
562 | - $SQL = "SELECT COUNT('STA_ID') FROM " . $state_table; |
|
562 | + $SQL = "SELECT COUNT('STA_ID') FROM ".$state_table; |
|
563 | 563 | $states = $wpdb->get_var($SQL); |
564 | - if ( ! $states ) { |
|
565 | - $SQL = "INSERT INTO " . $state_table . " |
|
564 | + if ( ! $states) { |
|
565 | + $SQL = "INSERT INTO ".$state_table." |
|
566 | 566 | (STA_ID, CNT_ISO, STA_abbrev, STA_name, STA_active) VALUES |
567 | 567 | (1, 'US', 'AK', 'Alaska', 1), |
568 | 568 | (2, 'US', 'AL', 'Alabama', 1), |
@@ -649,12 +649,12 @@ discard block |
||
649 | 649 | |
650 | 650 | global $wpdb; |
651 | 651 | $country_table = $wpdb->prefix."esp_country"; |
652 | - if ( EEH_Activation::table_exists( $country_table ) ) { |
|
652 | + if (EEH_Activation::table_exists($country_table)) { |
|
653 | 653 | |
654 | - $SQL = "SELECT COUNT('CNT_ISO') FROM " . $country_table; |
|
654 | + $SQL = "SELECT COUNT('CNT_ISO') FROM ".$country_table; |
|
655 | 655 | $countries = $wpdb->get_var($SQL); |
656 | - if ( ! $countries ) { |
|
657 | - $SQL = "INSERT INTO " . $country_table . " |
|
656 | + if ( ! $countries) { |
|
657 | + $SQL = "INSERT INTO ".$country_table." |
|
658 | 658 | (CNT_ISO, CNT_ISO3, RGN_ID, CNT_name, CNT_cur_code, CNT_cur_single, CNT_cur_plural, CNT_cur_sign, CNT_cur_sign_b4, CNT_cur_dec_plc, CNT_tel_code, CNT_is_EU, CNT_active) VALUES |
659 | 659 | ('AD', 'AND', 0, 'Andorra', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+376', 0, 0), |
660 | 660 | ('AE', 'ARE', 0, 'United Arab Emirates', 'AED', 'Dirham', 'Dirhams', 'د.إ', 1, 2, '+971', 0, 0), |
@@ -901,20 +901,20 @@ discard block |
||
901 | 901 | global $wpdb; |
902 | 902 | $price_type_table = $wpdb->prefix."esp_price_type"; |
903 | 903 | |
904 | - if ( EEH_Activation::table_exists( $price_type_table ) ) { |
|
904 | + if (EEH_Activation::table_exists($price_type_table)) { |
|
905 | 905 | |
906 | - $SQL = 'SELECT COUNT(PRT_ID) FROM ' . $price_type_table; |
|
907 | - $price_types_exist = $wpdb->get_var( $SQL ); |
|
906 | + $SQL = 'SELECT COUNT(PRT_ID) FROM '.$price_type_table; |
|
907 | + $price_types_exist = $wpdb->get_var($SQL); |
|
908 | 908 | |
909 | - if ( ! $price_types_exist ) { |
|
909 | + if ( ! $price_types_exist) { |
|
910 | 910 | $SQL = "INSERT INTO $price_type_table ( PRT_ID, PRT_name, PBT_ID, PRT_is_percent, PRT_order, PRT_deleted ) VALUES |
911 | - (1, '" . __('Base Price', 'event_espresso') . "', 1, 0, 0, 0), |
|
912 | - (2, '" . __('Percent Discount', 'event_espresso') . "', 2, 1, 20, 0), |
|
913 | - (3, '" . __('Fixed Discount', 'event_espresso') . "', 2, 0, 30, 0), |
|
914 | - (4, '" . __('Percent Surcharge', 'event_espresso') . "', 3, 1, 40, 0), |
|
915 | - (5, '" . __('Fixed Surcharge', 'event_espresso') . "', 3, 0, 50, 0);"; |
|
916 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_price_types__SQL', $SQL ); |
|
917 | - $wpdb->query( $SQL ); |
|
911 | + (1, '".__('Base Price', 'event_espresso')."', 1, 0, 0, 0), |
|
912 | + (2, '" . __('Percent Discount', 'event_espresso')."', 2, 1, 20, 0), |
|
913 | + (3, '" . __('Fixed Discount', 'event_espresso')."', 2, 0, 30, 0), |
|
914 | + (4, '" . __('Percent Surcharge', 'event_espresso')."', 3, 1, 40, 0), |
|
915 | + (5, '" . __('Fixed Surcharge', 'event_espresso')."', 3, 0, 50, 0);"; |
|
916 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_price_types__SQL', $SQL); |
|
917 | + $wpdb->query($SQL); |
|
918 | 918 | } |
919 | 919 | } |
920 | 920 | } |
@@ -934,16 +934,16 @@ discard block |
||
934 | 934 | global $wpdb; |
935 | 935 | $price_table = $wpdb->prefix."esp_price"; |
936 | 936 | |
937 | - if ( EEH_Activation::table_exists( $price_table ) ) { |
|
937 | + if (EEH_Activation::table_exists($price_table)) { |
|
938 | 938 | |
939 | - $SQL = 'SELECT COUNT(PRC_ID) FROM ' .$price_table; |
|
940 | - $prices_exist = $wpdb->get_var( $SQL ); |
|
939 | + $SQL = 'SELECT COUNT(PRC_ID) FROM '.$price_table; |
|
940 | + $prices_exist = $wpdb->get_var($SQL); |
|
941 | 941 | |
942 | - if ( ! $prices_exist ) { |
|
942 | + if ( ! $prices_exist) { |
|
943 | 943 | $SQL = "INSERT INTO $price_table |
944 | 944 | (PRC_ID, PRT_ID, PRC_amount, PRC_name, PRC_desc, PRC_is_default, PRC_overrides, PRC_order, PRC_deleted, PRC_parent ) VALUES |
945 | 945 | (1, 1, '0.00', 'Free Admission', '', 1, NULL, 0, 0, 0);"; |
946 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_prices__SQL', $SQL ); |
|
946 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_prices__SQL', $SQL); |
|
947 | 947 | $wpdb->query($SQL); |
948 | 948 | } |
949 | 949 | } |
@@ -960,34 +960,34 @@ discard block |
||
960 | 960 | |
961 | 961 | global $wpdb; |
962 | 962 | $ticket_table = $wpdb->prefix."esp_ticket"; |
963 | - if ( EEH_Activation::table_exists( $ticket_table ) ) { |
|
963 | + if (EEH_Activation::table_exists($ticket_table)) { |
|
964 | 964 | |
965 | - $SQL = 'SELECT COUNT(TKT_ID) FROM ' . $ticket_table; |
|
965 | + $SQL = 'SELECT COUNT(TKT_ID) FROM '.$ticket_table; |
|
966 | 966 | $tickets_exist = $wpdb->get_var($SQL); |
967 | 967 | |
968 | - if ( ! $tickets_exist ) { |
|
968 | + if ( ! $tickets_exist) { |
|
969 | 969 | $SQL = "INSERT INTO $ticket_table |
970 | 970 | ( TKT_ID, TTM_ID, TKT_name, TKT_description, TKT_qty, TKT_sold, TKT_uses, TKT_min, TKT_max, TKT_price, TKT_start_date, TKT_end_date, TKT_taxable, TKT_order, TKT_row, TKT_is_default, TKT_parent, TKT_deleted ) VALUES |
971 | - ( 1, 0, '" . __("Free Ticket", "event_espresso") . "', '', 100, 0, -1, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);"; |
|
972 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL ); |
|
971 | + ( 1, 0, '".__("Free Ticket", "event_espresso")."', '', 100, 0, -1, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);"; |
|
972 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL); |
|
973 | 973 | $wpdb->query($SQL); |
974 | 974 | } |
975 | 975 | } |
976 | 976 | $ticket_price_table = $wpdb->prefix."esp_ticket_price"; |
977 | 977 | |
978 | - if ( EEH_Activation::table_exists( $ticket_price_table ) ) { |
|
978 | + if (EEH_Activation::table_exists($ticket_price_table)) { |
|
979 | 979 | |
980 | - $SQL = 'SELECT COUNT(TKP_ID) FROM ' . $ticket_price_table; |
|
980 | + $SQL = 'SELECT COUNT(TKP_ID) FROM '.$ticket_price_table; |
|
981 | 981 | $ticket_prc_exist = $wpdb->get_var($SQL); |
982 | 982 | |
983 | - if ( ! $ticket_prc_exist ) { |
|
983 | + if ( ! $ticket_prc_exist) { |
|
984 | 984 | |
985 | 985 | $SQL = "INSERT INTO $ticket_price_table |
986 | 986 | ( TKP_ID, TKT_ID, PRC_ID ) VALUES |
987 | 987 | ( 1, 1, 1 ) |
988 | 988 | "; |
989 | 989 | |
990 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL ); |
|
990 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL); |
|
991 | 991 | $wpdb->query($SQL); |
992 | 992 | } |
993 | 993 | } |
@@ -1000,20 +1000,20 @@ discard block |
||
1000 | 1000 | * @param string $country_name |
1001 | 1001 | * @return array where keys are columns, values are column values |
1002 | 1002 | */ |
1003 | - public function get_or_create_country($country_name){ |
|
1004 | - if( ! $country_name ){ |
|
1003 | + public function get_or_create_country($country_name) { |
|
1004 | + if ( ! $country_name) { |
|
1005 | 1005 | throw new EE_Error(__("Could not get a country because country name is blank", "event_espresso")); |
1006 | 1006 | } |
1007 | 1007 | global $wpdb; |
1008 | 1008 | $country_table = $wpdb->prefix."esp_country"; |
1009 | - if(is_int($country_name)){ |
|
1009 | + if (is_int($country_name)) { |
|
1010 | 1010 | $country_name = $this->get_iso_from_3_1_country_id($country_name); |
1011 | 1011 | } |
1012 | 1012 | $country = $wpdb->get_row($wpdb->prepare("SELECT * FROM $country_table WHERE |
1013 | 1013 | CNT_ISO LIKE %s OR |
1014 | 1014 | CNT_ISO3 LIKE %s OR |
1015 | - CNT_name LIKE %s LIMIT 1",$country_name,$country_name,$country_name),ARRAY_A); |
|
1016 | - if( ! $country ){ |
|
1015 | + CNT_name LIKE %s LIMIT 1", $country_name, $country_name, $country_name), ARRAY_A); |
|
1016 | + if ( ! $country) { |
|
1017 | 1017 | //insert a new one then |
1018 | 1018 | $cols_n_values = array( |
1019 | 1019 | 'CNT_ISO'=> $this->_find_available_country_iso(2), |
@@ -1033,26 +1033,26 @@ discard block |
||
1033 | 1033 | 'CNT_active'=>true |
1034 | 1034 | ); |
1035 | 1035 | $data_types = array( |
1036 | - '%s',//CNT_ISO |
|
1037 | - '%s',//CNT_ISO3 |
|
1038 | - '%d',//RGN_ID |
|
1039 | - '%s',//CNT_name |
|
1040 | - '%s',//CNT_cur_code |
|
1041 | - '%s',//CNT_cur_single |
|
1042 | - '%s',//CNT_cur_plural |
|
1043 | - '%s',//CNT_cur_sign |
|
1044 | - '%d',//CNT_cur_sign_b4 |
|
1045 | - '%d',//CNT_cur_dec_plc |
|
1046 | - '%s',//CNT_cur_dec_mrk |
|
1047 | - '%s',//CNT_cur_thsnds |
|
1048 | - '%s',//CNT_tel_code |
|
1049 | - '%d',//CNT_is_EU |
|
1050 | - '%d',//CNT_active |
|
1036 | + '%s', //CNT_ISO |
|
1037 | + '%s', //CNT_ISO3 |
|
1038 | + '%d', //RGN_ID |
|
1039 | + '%s', //CNT_name |
|
1040 | + '%s', //CNT_cur_code |
|
1041 | + '%s', //CNT_cur_single |
|
1042 | + '%s', //CNT_cur_plural |
|
1043 | + '%s', //CNT_cur_sign |
|
1044 | + '%d', //CNT_cur_sign_b4 |
|
1045 | + '%d', //CNT_cur_dec_plc |
|
1046 | + '%s', //CNT_cur_dec_mrk |
|
1047 | + '%s', //CNT_cur_thsnds |
|
1048 | + '%s', //CNT_tel_code |
|
1049 | + '%d', //CNT_is_EU |
|
1050 | + '%d', //CNT_active |
|
1051 | 1051 | ); |
1052 | 1052 | $success = $wpdb->insert($country_table, |
1053 | 1053 | $cols_n_values, |
1054 | 1054 | $data_types); |
1055 | - if( ! $success){ |
|
1055 | + if ( ! $success) { |
|
1056 | 1056 | throw new EE_Error($this->_create_error_message_for_db_insertion('N/A', array('country_id'=>$country_name), $country_table, $cols_n_values, $data_types)); |
1057 | 1057 | } |
1058 | 1058 | $country = $cols_n_values; |
@@ -1064,13 +1064,13 @@ discard block |
||
1064 | 1064 | * @global type $wpdb |
1065 | 1065 | * @return string |
1066 | 1066 | */ |
1067 | - private function _find_available_country_iso($num_letters = 2){ |
|
1067 | + private function _find_available_country_iso($num_letters = 2) { |
|
1068 | 1068 | global $wpdb; |
1069 | 1069 | $country_table = $wpdb->prefix."esp_country"; |
1070 | - do{ |
|
1070 | + do { |
|
1071 | 1071 | $current_iso = strtoupper(wp_generate_password($num_letters, false)); |
1072 | - $country_with_that_iso = $wpdb->get_var($wpdb->prepare("SELECT count(CNT_ISO) FROM ".$country_table." WHERE CNT_ISO=%s",$current_iso)); |
|
1073 | - }while(intval($country_with_that_iso)); |
|
1072 | + $country_with_that_iso = $wpdb->get_var($wpdb->prepare("SELECT count(CNT_ISO) FROM ".$country_table." WHERE CNT_ISO=%s", $current_iso)); |
|
1073 | + }while (intval($country_with_that_iso)); |
|
1074 | 1074 | return $current_iso; |
1075 | 1075 | } |
1076 | 1076 | |
@@ -1081,14 +1081,14 @@ discard block |
||
1081 | 1081 | * @param string $state_name |
1082 | 1082 | * @return array where keys are columns, values are column values |
1083 | 1083 | */ |
1084 | - public function get_or_create_state($state_name,$country_name = ''){ |
|
1085 | - if( ! $state_name ){ |
|
1084 | + public function get_or_create_state($state_name, $country_name = '') { |
|
1085 | + if ( ! $state_name) { |
|
1086 | 1086 | throw new EE_Error(__("Could not get-or-create state because no state name was provided", "event_espresso")); |
1087 | 1087 | } |
1088 | - try{ |
|
1088 | + try { |
|
1089 | 1089 | $country = $this->get_or_create_country($country_name); |
1090 | 1090 | $country_iso = $country['CNT_ISO']; |
1091 | - }catch(EE_Error $e){ |
|
1091 | + } catch (EE_Error $e) { |
|
1092 | 1092 | $country_iso = $this->get_default_country_iso(); |
1093 | 1093 | } |
1094 | 1094 | global $wpdb; |
@@ -1096,24 +1096,24 @@ discard block |
||
1096 | 1096 | $state = $wpdb->get_row($wpdb->prepare("SELECT * FROM $state_table WHERE |
1097 | 1097 | (STA_abbrev LIKE %s OR |
1098 | 1098 | STA_name LIKE %s) AND |
1099 | - CNT_ISO LIKE %s LIMIT 1",$state_name,$state_name,$country_iso),ARRAY_A); |
|
1100 | - if ( ! $state){ |
|
1099 | + CNT_ISO LIKE %s LIMIT 1", $state_name, $state_name, $country_iso), ARRAY_A); |
|
1100 | + if ( ! $state) { |
|
1101 | 1101 | //insert a new one then |
1102 | 1102 | $cols_n_values = array( |
1103 | 1103 | 'CNT_ISO'=>$country_iso, |
1104 | - 'STA_abbrev'=>substr($state_name,0,6), |
|
1104 | + 'STA_abbrev'=>substr($state_name, 0, 6), |
|
1105 | 1105 | 'STA_name'=>$state_name, |
1106 | 1106 | 'STA_active'=>true |
1107 | 1107 | ); |
1108 | 1108 | $data_types = array( |
1109 | - '%s',//CNT_ISO |
|
1110 | - '%s',//STA_abbrev |
|
1111 | - '%s',//STA_name |
|
1112 | - '%d',//STA_active |
|
1109 | + '%s', //CNT_ISO |
|
1110 | + '%s', //STA_abbrev |
|
1111 | + '%s', //STA_name |
|
1112 | + '%d', //STA_active |
|
1113 | 1113 | ); |
1114 | - $success = $wpdb->insert($state_table,$cols_n_values,$data_types); |
|
1115 | - if ( ! $success ){ |
|
1116 | - throw new EE_Error($this->_create_error_message_for_db_insertion('N/A', array('state'=>$state_name,'country_id'=>$country_name), $state_table, $cols_n_values, $data_types)); |
|
1114 | + $success = $wpdb->insert($state_table, $cols_n_values, $data_types); |
|
1115 | + if ( ! $success) { |
|
1116 | + throw new EE_Error($this->_create_error_message_for_db_insertion('N/A', array('state'=>$state_name, 'country_id'=>$country_name), $state_table, $cols_n_values, $data_types)); |
|
1117 | 1117 | } |
1118 | 1118 | $state = $cols_n_values; |
1119 | 1119 | $state['STA_ID'] = $wpdb->insert_id; |
@@ -1126,21 +1126,21 @@ discard block |
||
1126 | 1126 | * @param type $timeString |
1127 | 1127 | * @return string in the php DATETIME format: "G:i" (24-hour format hour with leading zeros, a colon, and minutes with leading zeros) |
1128 | 1128 | */ |
1129 | - public function convertTimeFromAMPM($timeString){ |
|
1129 | + public function convertTimeFromAMPM($timeString) { |
|
1130 | 1130 | $matches = array(); |
1131 | - preg_match("~(\\d*):(\\d*)~",$timeString,$matches); |
|
1132 | - if( ! $matches || count($matches)<3){ |
|
1131 | + preg_match("~(\\d*):(\\d*)~", $timeString, $matches); |
|
1132 | + if ( ! $matches || count($matches) < 3) { |
|
1133 | 1133 | $hour = '00'; |
1134 | 1134 | $minutes = '00'; |
1135 | - }else{ |
|
1135 | + } else { |
|
1136 | 1136 | $hour = intval($matches[1]); |
1137 | 1137 | $minutes = $matches[2]; |
1138 | 1138 | } |
1139 | - if(strpos($timeString, 'PM') || strpos($timeString, 'pm')){ |
|
1139 | + if (strpos($timeString, 'PM') || strpos($timeString, 'pm')) { |
|
1140 | 1140 | $hour = intval($hour) + 12; |
1141 | 1141 | } |
1142 | - $hour = str_pad( "$hour", 2, '0',STR_PAD_LEFT); |
|
1143 | - $minutes = str_pad( "$minutes", 2, '0',STR_PAD_LEFT); |
|
1142 | + $hour = str_pad("$hour", 2, '0', STR_PAD_LEFT); |
|
1143 | + $minutes = str_pad("$minutes", 2, '0', STR_PAD_LEFT); |
|
1144 | 1144 | return "$hour:$minutes"; |
1145 | 1145 | } |
1146 | 1146 | |
@@ -1149,7 +1149,7 @@ discard block |
||
1149 | 1149 | * @param int $country_id |
1150 | 1150 | * @return string the country's ISO3 code |
1151 | 1151 | */ |
1152 | - public function get_iso_from_3_1_country_id($country_id){ |
|
1152 | + public function get_iso_from_3_1_country_id($country_id) { |
|
1153 | 1153 | $old_countries = array( |
1154 | 1154 | array(64, 'United States', 'US', 'USA', 1), |
1155 | 1155 | array(15, 'Australia', 'AU', 'AUS', 1), |
@@ -1375,9 +1375,9 @@ discard block |
||
1375 | 1375 | array(226, 'Zimbabwe', 'ZW', 'ZWE', 1)); |
1376 | 1376 | |
1377 | 1377 | $country_iso = 'US'; |
1378 | - foreach($old_countries as $country_array){ |
|
1378 | + foreach ($old_countries as $country_array) { |
|
1379 | 1379 | //note: index 0 is the 3.1 country ID |
1380 | - if($country_array[0] == $country_id){ |
|
1380 | + if ($country_array[0] == $country_id) { |
|
1381 | 1381 | //note: index 2 is the ISO |
1382 | 1382 | $country_iso = $country_array[2]; |
1383 | 1383 | break; |
@@ -1390,8 +1390,8 @@ discard block |
||
1390 | 1390 | * Gets the ISO3 for the |
1391 | 1391 | * @return string |
1392 | 1392 | */ |
1393 | - public function get_default_country_iso(){ |
|
1394 | - $old_org_options= get_option('events_organization_settings'); |
|
1393 | + public function get_default_country_iso() { |
|
1394 | + $old_org_options = get_option('events_organization_settings'); |
|
1395 | 1395 | $iso = $this->get_iso_from_3_1_country_id($old_org_options['organization_country']); |
1396 | 1396 | return $iso; |
1397 | 1397 | } |
@@ -1403,13 +1403,13 @@ discard block |
||
1403 | 1403 | * the event's DEFAULT payment status, or the attendee's payment status) required pre-approval. |
1404 | 1404 | * @return string STS_ID for use in 4.1 |
1405 | 1405 | */ |
1406 | - public function convert_3_1_payment_status_to_4_1_STS_ID($payment_status, $this_thing_required_pre_approval = false){ |
|
1406 | + public function convert_3_1_payment_status_to_4_1_STS_ID($payment_status, $this_thing_required_pre_approval = false) { |
|
1407 | 1407 | |
1408 | 1408 | //EE team can read the related discussion: https://app.asana.com/0/2400967562914/9418495544455 |
1409 | - if($this_thing_required_pre_approval){ |
|
1409 | + if ($this_thing_required_pre_approval) { |
|
1410 | 1410 | return 'RNA'; |
1411 | - }else{ |
|
1412 | - $mapping = $default_reg_stati_conversions=array( |
|
1411 | + } else { |
|
1412 | + $mapping = $default_reg_stati_conversions = array( |
|
1413 | 1413 | 'Completed'=>'RAP', |
1414 | 1414 | ''=>'RPP', |
1415 | 1415 | 'Incomplete'=>'RPP', |
@@ -1439,22 +1439,22 @@ discard block |
||
1439 | 1439 | * @param EE_Data_Migration_Script_Stage $migration_stage the stage which called this, where errors should be added |
1440 | 1440 | * @return boolean whether or not we had to do the big job of creating an image attachment |
1441 | 1441 | */ |
1442 | - public function convert_image_url_to_attachment_and_attach_to_post($guid,$new_cpt_id, EE_Data_Migration_Script_Stage $migration_stage){ |
|
1442 | + public function convert_image_url_to_attachment_and_attach_to_post($guid, $new_cpt_id, EE_Data_Migration_Script_Stage $migration_stage) { |
|
1443 | 1443 | $created_attachment_post = false; |
1444 | 1444 | $guid = $this->_get_original_guid($guid); |
1445 | - if($guid){ |
|
1445 | + if ($guid) { |
|
1446 | 1446 | //check for an existing attachment post with this guid |
1447 | 1447 | $attachment_post_id = $this->_get_image_attachment_id_by_GUID($guid); |
1448 | - if( ! $attachment_post_id){ |
|
1448 | + if ( ! $attachment_post_id) { |
|
1449 | 1449 | //post thumbnail with that GUID doesn't exist, we should create one |
1450 | 1450 | $attachment_post_id = $this->_create_image_attachment_from_GUID($guid, $migration_stage); |
1451 | 1451 | $created_attachment_post = true; |
1452 | 1452 | } |
1453 | 1453 | //double-check we actually have an attachment post |
1454 | - if( $attachment_post_id){ |
|
1455 | - update_post_meta($new_cpt_id,'_thumbnail_id',$attachment_post_id); |
|
1456 | - }else{ |
|
1457 | - $migration_stage->add_error(sprintf(__("Could not update event image %s for CPT with ID %d, but attachments post ID is %d", "event_espresso"),$guid,$new_cpt_id,$attachment_post_id)); |
|
1454 | + if ($attachment_post_id) { |
|
1455 | + update_post_meta($new_cpt_id, '_thumbnail_id', $attachment_post_id); |
|
1456 | + } else { |
|
1457 | + $migration_stage->add_error(sprintf(__("Could not update event image %s for CPT with ID %d, but attachments post ID is %d", "event_espresso"), $guid, $new_cpt_id, $attachment_post_id)); |
|
1458 | 1458 | } |
1459 | 1459 | } |
1460 | 1460 | return $created_attachment_post; |
@@ -1468,13 +1468,13 @@ discard block |
||
1468 | 1468 | * @param string $guid_in_old_event |
1469 | 1469 | * @return string either the original guid, or $guid_in_old_event if we couldn't figure out what the original was |
1470 | 1470 | */ |
1471 | - private function _get_original_guid($guid_in_old_event){ |
|
1472 | - $original_guid = preg_replace('~-\d*x\d*\.~','.',$guid_in_old_event,1); |
|
1471 | + private function _get_original_guid($guid_in_old_event) { |
|
1472 | + $original_guid = preg_replace('~-\d*x\d*\.~', '.', $guid_in_old_event, 1); |
|
1473 | 1473 | //do a head request to verify the file exists |
1474 | 1474 | $head_response = wp_remote_head($original_guid); |
1475 | - if( ! $head_response instanceof WP_Error && $head_response['response']['message'] == 'OK'){ |
|
1475 | + if ( ! $head_response instanceof WP_Error && $head_response['response']['message'] == 'OK') { |
|
1476 | 1476 | return $original_guid; |
1477 | - }else{ |
|
1477 | + } else { |
|
1478 | 1478 | return $guid_in_old_event; |
1479 | 1479 | } |
1480 | 1480 | } |
@@ -1486,32 +1486,32 @@ discard block |
||
1486 | 1486 | * @param EE_Data_Migration_Script_Stage $migration_stage |
1487 | 1487 | * @return int |
1488 | 1488 | */ |
1489 | - private function _create_image_attachment_from_GUID($guid, EE_Data_Migration_Script_Stage $migration_stage){ |
|
1490 | - if ( ! $guid){ |
|
1489 | + private function _create_image_attachment_from_GUID($guid, EE_Data_Migration_Script_Stage $migration_stage) { |
|
1490 | + if ( ! $guid) { |
|
1491 | 1491 | $migration_stage->add_error(sprintf(__("Cannot create image attachment for a blank GUID!", "event_espresso"))); |
1492 | 1492 | return 0; |
1493 | 1493 | } |
1494 | - $wp_filetype = wp_check_filetype(basename($guid), null ); |
|
1494 | + $wp_filetype = wp_check_filetype(basename($guid), null); |
|
1495 | 1495 | $wp_upload_dir = wp_upload_dir(); |
1496 | 1496 | //if the file is located remotely, download it to our uploads DIR, because wp_genereate_attachmnet_metadata needs the file to be local |
1497 | - if(strpos($guid,$wp_upload_dir['url']) === FALSE){ |
|
1497 | + if (strpos($guid, $wp_upload_dir['url']) === FALSE) { |
|
1498 | 1498 | //image is located remotely. download it and place it in the uploads directory |
1499 | - if( ! is_readable($guid)){ |
|
1500 | - $migration_stage->add_error(sprintf(__("Could not create image attachment from non-existent file: %s", "event_espresso"),$guid)); |
|
1499 | + if ( ! is_readable($guid)) { |
|
1500 | + $migration_stage->add_error(sprintf(__("Could not create image attachment from non-existent file: %s", "event_espresso"), $guid)); |
|
1501 | 1501 | return 0; |
1502 | 1502 | } |
1503 | - $contents= file_get_contents($guid); |
|
1504 | - if($contents === FALSE){ |
|
1505 | - $migration_stage->add_error(sprintf(__("Could not read image at %s, and therefore couldnt create an attachment post for it.", "event_espresso"),$guid)); |
|
1503 | + $contents = file_get_contents($guid); |
|
1504 | + if ($contents === FALSE) { |
|
1505 | + $migration_stage->add_error(sprintf(__("Could not read image at %s, and therefore couldnt create an attachment post for it.", "event_espresso"), $guid)); |
|
1506 | 1506 | return false; |
1507 | 1507 | } |
1508 | - $local_filepath = $wp_upload_dir['path'].DS.basename($guid); |
|
1508 | + $local_filepath = $wp_upload_dir['path'].DS.basename($guid); |
|
1509 | 1509 | $savefile = fopen($local_filepath, 'w'); |
1510 | 1510 | fwrite($savefile, $contents); |
1511 | 1511 | fclose($savefile); |
1512 | - $guid = str_replace($wp_upload_dir['path'],$wp_upload_dir['url'],$local_filepath); |
|
1513 | - }else{ |
|
1514 | - $local_filepath = str_replace($wp_upload_dir['url'],$wp_upload_dir['path'],$guid); |
|
1512 | + $guid = str_replace($wp_upload_dir['path'], $wp_upload_dir['url'], $local_filepath); |
|
1513 | + } else { |
|
1514 | + $local_filepath = str_replace($wp_upload_dir['url'], $wp_upload_dir['path'], $guid); |
|
1515 | 1515 | } |
1516 | 1516 | |
1517 | 1517 | $attachment = array( |
@@ -1521,24 +1521,24 @@ discard block |
||
1521 | 1521 | 'post_content' => '', |
1522 | 1522 | 'post_status' => 'inherit' |
1523 | 1523 | ); |
1524 | - $attach_id = wp_insert_attachment( $attachment, $guid ); |
|
1525 | - if( ! $attach_id ){ |
|
1526 | - $migration_stage->add_error(sprintf(__("Could not create image attachment post from image '%s'. Attachment data was %s.", "event_espresso"),$guid,$this->_json_encode($attachment))); |
|
1524 | + $attach_id = wp_insert_attachment($attachment, $guid); |
|
1525 | + if ( ! $attach_id) { |
|
1526 | + $migration_stage->add_error(sprintf(__("Could not create image attachment post from image '%s'. Attachment data was %s.", "event_espresso"), $guid, $this->_json_encode($attachment))); |
|
1527 | 1527 | return $attach_id; |
1528 | 1528 | } |
1529 | 1529 | |
1530 | 1530 | // you must first include the image.php file |
1531 | 1531 | // for the function wp_generate_attachment_metadata() to work |
1532 | - require_once(ABSPATH . 'wp-admin/includes/image.php'); |
|
1532 | + require_once(ABSPATH.'wp-admin/includes/image.php'); |
|
1533 | 1533 | |
1534 | - $attach_data = wp_generate_attachment_metadata( $attach_id, $local_filepath ); |
|
1535 | - if( ! $attach_data){ |
|
1536 | - $migration_stage->add_error(sprintf(__("Coudl not genereate attachment metadata for attachment post %d with filepath %s and GUID %s. Please check the file was downloaded properly.", "event_espresso"),$attach_id,$local_filepath,$guid)); |
|
1534 | + $attach_data = wp_generate_attachment_metadata($attach_id, $local_filepath); |
|
1535 | + if ( ! $attach_data) { |
|
1536 | + $migration_stage->add_error(sprintf(__("Coudl not genereate attachment metadata for attachment post %d with filepath %s and GUID %s. Please check the file was downloaded properly.", "event_espresso"), $attach_id, $local_filepath, $guid)); |
|
1537 | 1537 | return $attach_id; |
1538 | 1538 | } |
1539 | - $metadata_save_result = wp_update_attachment_metadata( $attach_id, $attach_data ); |
|
1540 | - if( ! $metadata_save_result ){ |
|
1541 | - $migration_stage->add_error(sprintf(__("Could not update attachment metadata for attachment %d with data %s", "event_espresso"),$attach_id,$this->_json_encode($attach_data))); |
|
1539 | + $metadata_save_result = wp_update_attachment_metadata($attach_id, $attach_data); |
|
1540 | + if ( ! $metadata_save_result) { |
|
1541 | + $migration_stage->add_error(sprintf(__("Could not update attachment metadata for attachment %d with data %s", "event_espresso"), $attach_id, $this->_json_encode($attach_data))); |
|
1542 | 1542 | } |
1543 | 1543 | return $attach_id; |
1544 | 1544 | } |
@@ -1550,9 +1550,9 @@ discard block |
||
1550 | 1550 | * @param string $guid |
1551 | 1551 | * @return int |
1552 | 1552 | */ |
1553 | - private function _get_image_attachment_id_by_GUID($guid){ |
|
1553 | + private function _get_image_attachment_id_by_GUID($guid) { |
|
1554 | 1554 | global $wpdb; |
1555 | - $attachment_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid=%s LIMIT 1",$guid)); |
|
1555 | + $attachment_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid=%s LIMIT 1", $guid)); |
|
1556 | 1556 | return $attachment_id; |
1557 | 1557 | } |
1558 | 1558 | /** |
@@ -1564,20 +1564,20 @@ discard block |
||
1564 | 1564 | * @param string $timezone |
1565 | 1565 | * @return string |
1566 | 1566 | */ |
1567 | - public function convert_date_string_to_utc(EE_Data_Migration_Script_Stage $stage, $row_of_data, $DATETIME_string,$timezone = null){ |
|
1567 | + public function convert_date_string_to_utc(EE_Data_Migration_Script_Stage $stage, $row_of_data, $DATETIME_string, $timezone = null) { |
|
1568 | 1568 | $original_tz = $timezone; |
1569 | - if( ! $timezone){ |
|
1569 | + if ( ! $timezone) { |
|
1570 | 1570 | $timezone = $this->_get_wp_timezone(); |
1571 | 1571 | } |
1572 | - if( ! $timezone){ |
|
1573 | - $stage->add_error(sprintf(__("Could not find timezone given %s for %s", "event_espresso"),$original_tz,$row_of_data)); |
|
1572 | + if ( ! $timezone) { |
|
1573 | + $stage->add_error(sprintf(__("Could not find timezone given %s for %s", "event_espresso"), $original_tz, $row_of_data)); |
|
1574 | 1574 | $timezone = 'UTC'; |
1575 | 1575 | } |
1576 | - try{ |
|
1577 | - $date_obj = new DateTime( $DATETIME_string, new DateTimeZone( $timezone ) ); |
|
1576 | + try { |
|
1577 | + $date_obj = new DateTime($DATETIME_string, new DateTimeZone($timezone)); |
|
1578 | 1578 | $date_obj->setTimezone(new DateTimeZone('UTC')); |
1579 | - }catch(Exception $e){ |
|
1580 | - $stage->add_error(sprintf(__("Could not convert time string '%s' using timezone '%s' into a proper DATETIME. Using current time instead.", "event_espresso"),$DATETIME_string,$timezone)); |
|
1579 | + } catch (Exception $e) { |
|
1580 | + $stage->add_error(sprintf(__("Could not convert time string '%s' using timezone '%s' into a proper DATETIME. Using current time instead.", "event_espresso"), $DATETIME_string, $timezone)); |
|
1581 | 1581 | $date_obj = new DateTime(); |
1582 | 1582 | } |
1583 | 1583 | |
@@ -1588,14 +1588,14 @@ discard block |
||
1588 | 1588 | * Gets the DEFAULT timezone string from wordpress (even if they set a gmt offset) |
1589 | 1589 | * @return string |
1590 | 1590 | */ |
1591 | - private function _get_wp_timezone(){ |
|
1592 | - $timezone = empty( $timezone ) ? get_option('timezone_string') : $timezone; |
|
1591 | + private function _get_wp_timezone() { |
|
1592 | + $timezone = empty($timezone) ? get_option('timezone_string') : $timezone; |
|
1593 | 1593 | |
1594 | 1594 | //if timezone is STILL empty then let's get the GMT offset and then set the timezone_string using our converter |
1595 | - if ( empty( $timezone ) ) { |
|
1595 | + if (empty($timezone)) { |
|
1596 | 1596 | //let's get a the WordPress UTC offset |
1597 | 1597 | $offset = get_option('gmt_offset'); |
1598 | - $timezone = $this->timezone_convert_to_string_from_offset( $offset ); |
|
1598 | + $timezone = $this->timezone_convert_to_string_from_offset($offset); |
|
1599 | 1599 | } |
1600 | 1600 | return $timezone; |
1601 | 1601 | } |
@@ -1604,11 +1604,11 @@ discard block |
||
1604 | 1604 | * @param int $offset |
1605 | 1605 | * @return boolean |
1606 | 1606 | */ |
1607 | - private function timezone_convert_to_string_from_offset($offset){ |
|
1607 | + private function timezone_convert_to_string_from_offset($offset) { |
|
1608 | 1608 | //shamelessly taken from bottom comment at http://ca1.php.net/manual/en/function.timezone-name-from-abbr.php because timezone_name_from_abbr() did NOT work as expected - its not reliable |
1609 | 1609 | $offset *= 3600; // convert hour offset to seconds |
1610 | 1610 | $abbrarray = timezone_abbreviations_list(); |
1611 | - foreach ($abbrarray as $abbr){ |
|
1611 | + foreach ($abbrarray as $abbr) { |
|
1612 | 1612 | foreach ($abbr as $city) |
1613 | 1613 | { |
1614 | 1614 | if ($city['offset'] == $offset) |
@@ -1622,32 +1622,32 @@ discard block |
||
1622 | 1622 | return FALSE; |
1623 | 1623 | } |
1624 | 1624 | |
1625 | - public function migration_page_hooks(){ |
|
1626 | - add_filter('FHEE__ee_migration_page__header',array($this,'_migrate_page_hook_simplify_version_strings'),10,3); |
|
1627 | - add_filter('FHEE__ee_migration_page__p_after_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2); |
|
1628 | - add_filter('FHEE__ee_migration_page__option_1_main',array($this,'_migrate_page_hook_simplify_version_strings'),10,3); |
|
1629 | - add_filter('FHEE__ee_migration_page__option_1_button_text',array($this,'_migrate_page_hook_simplify_version_strings'),10,3); |
|
1630 | - add_action('AHEE__ee_migration_page__option_1_extra_details',array($this,'_migration_page_hook_option_1_extra_details'),10,3); |
|
1631 | - add_filter('FHEE__ee_migration_page__option_2_main',array($this,'_migrate_page_hook_simplify_version_strings'),10,4); |
|
1632 | - add_filter('FHEE__ee_migration_page__option_2_button_text',array($this,'_migration_page_hook_simplify_next_db_state'),10,2); |
|
1633 | - add_filter('FHEE__ee_migration_page__option_2_details',array($this,'_migration_page_hook_simplify_next_db_state'),10,2); |
|
1634 | - add_action('AHEE__ee_migration_page__after_migration_options_table',array($this,'_migration_page_hook_after_migration_options_table')); |
|
1635 | - add_filter('FHEE__ee_migration_page__done_migration_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2); |
|
1636 | - add_filter('FHEE__ee_migration_page__p_after_done_migration_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2); |
|
1625 | + public function migration_page_hooks() { |
|
1626 | + add_filter('FHEE__ee_migration_page__header', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3); |
|
1627 | + add_filter('FHEE__ee_migration_page__p_after_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2); |
|
1628 | + add_filter('FHEE__ee_migration_page__option_1_main', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3); |
|
1629 | + add_filter('FHEE__ee_migration_page__option_1_button_text', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3); |
|
1630 | + add_action('AHEE__ee_migration_page__option_1_extra_details', array($this, '_migration_page_hook_option_1_extra_details'), 10, 3); |
|
1631 | + add_filter('FHEE__ee_migration_page__option_2_main', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 4); |
|
1632 | + add_filter('FHEE__ee_migration_page__option_2_button_text', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2); |
|
1633 | + add_filter('FHEE__ee_migration_page__option_2_details', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2); |
|
1634 | + add_action('AHEE__ee_migration_page__after_migration_options_table', array($this, '_migration_page_hook_after_migration_options_table')); |
|
1635 | + add_filter('FHEE__ee_migration_page__done_migration_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2); |
|
1636 | + add_filter('FHEE__ee_migration_page__p_after_done_migration_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2); |
|
1637 | 1637 | } |
1638 | 1638 | |
1639 | - public function _migrate_page_hook_simplify_version_strings($old_content,$current_db_state,$next_db_state,$ultimate_db_state = NULL){ |
|
1640 | - return str_replace(array($current_db_state,$next_db_state,$ultimate_db_state),array(__('EE3','event_espresso'),__('EE4','event_espresso'), __("EE4", 'event_espresso')),$old_content); |
|
1639 | + public function _migrate_page_hook_simplify_version_strings($old_content, $current_db_state, $next_db_state, $ultimate_db_state = NULL) { |
|
1640 | + return str_replace(array($current_db_state, $next_db_state, $ultimate_db_state), array(__('EE3', 'event_espresso'), __('EE4', 'event_espresso'), __("EE4", 'event_espresso')), $old_content); |
|
1641 | 1641 | } |
1642 | - public function _migration_page_hook_simplify_next_db_state($old_content,$next_db_state){ |
|
1643 | - return str_replace($next_db_state, __("EE4", 'event_espresso'),$old_content); |
|
1642 | + public function _migration_page_hook_simplify_next_db_state($old_content, $next_db_state) { |
|
1643 | + return str_replace($next_db_state, __("EE4", 'event_espresso'), $old_content); |
|
1644 | 1644 | } |
1645 | - public function _migration_page_hook_option_1_extra_details(){ |
|
1646 | - ?><p><?php printf(__("Note: many of your EE3 shortcodes will be changed to EE4 shortcodes during this migration (among many other things). Should you revert to EE3, then you should restore to your backup or manually change the EE4 shortcodes back to their EE3 equivalents", "event_espresso"));?></p><?php |
|
1645 | + public function _migration_page_hook_option_1_extra_details() { |
|
1646 | + ?><p><?php printf(__("Note: many of your EE3 shortcodes will be changed to EE4 shortcodes during this migration (among many other things). Should you revert to EE3, then you should restore to your backup or manually change the EE4 shortcodes back to their EE3 equivalents", "event_espresso")); ?></p><?php |
|
1647 | 1647 | } |
1648 | - public function _migration_page_hook_after_migration_options_table(){ |
|
1648 | + public function _migration_page_hook_after_migration_options_table() { |
|
1649 | 1649 | ?><p class="ee-attention"> |
1650 | - <strong><span class="reminder-spn"><?php _e("Important note to those using Event Espresso 3 addons: ", "event_espresso");?></span></strong><br/><?php _e("Unless an addon's description on our website explicitly states that it is compatible with EE4, you should consider it incompatible and know that it WILL NOT WORK correctly with this new version of Event Espresso 4 (EE4). As well, any data for incompatible addons will NOT BE MIGRATED until an updated EE4 compatible version of the addon is available. If you want, or need to keep using your EE3 addons, you should simply continue using EE3 until EE4 compatible versions of your addons become available. To continue using EE3 for now, just deactivate EE4 and reactivate EE3.", "event_espresso"); ?> |
|
1650 | + <strong><span class="reminder-spn"><?php _e("Important note to those using Event Espresso 3 addons: ", "event_espresso"); ?></span></strong><br/><?php _e("Unless an addon's description on our website explicitly states that it is compatible with EE4, you should consider it incompatible and know that it WILL NOT WORK correctly with this new version of Event Espresso 4 (EE4). As well, any data for incompatible addons will NOT BE MIGRATED until an updated EE4 compatible version of the addon is available. If you want, or need to keep using your EE3 addons, you should simply continue using EE3 until EE4 compatible versions of your addons become available. To continue using EE3 for now, just deactivate EE4 and reactivate EE3.", "event_espresso"); ?> |
|
1651 | 1651 | </p><?php |
1652 | 1652 | } |
1653 | 1653 | } |
@@ -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 |