@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | -if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
3 | 3 | exit('No direct script access allowed'); |
4 | 4 | } |
5 | 5 | |
@@ -14,7 +14,7 @@ discard block |
||
14 | 14 | * Migrates 4.1-4.5-style gateway settings (which were stores in EE_Config) |
15 | 15 | * to 4.6-style payment methods (which have their database table) |
16 | 16 | */ |
17 | -class EE_DMS_4_6_0_gateways extends EE_Data_Migration_Script_Stage{ |
|
17 | +class EE_DMS_4_6_0_gateways extends EE_Data_Migration_Script_Stage { |
|
18 | 18 | |
19 | 19 | protected $_new_table_name; |
20 | 20 | protected $_extra_meta_table_name; |
@@ -73,11 +73,11 @@ discard block |
||
73 | 73 | */ |
74 | 74 | protected function _migration_step($num_items_to_migrate = 50) { |
75 | 75 | $items_actually_migrated = 0; |
76 | - $gateways_to_deal_with = array_slice(EE_Config::instance()->gateway->payment_settings,$this->count_records_migrated(),$num_items_to_migrate); |
|
77 | - foreach($gateways_to_deal_with as $old_gateway_slug => $old_gateway_settings){ |
|
76 | + $gateways_to_deal_with = array_slice(EE_Config::instance()->gateway->payment_settings, $this->count_records_migrated(), $num_items_to_migrate); |
|
77 | + foreach ($gateways_to_deal_with as $old_gateway_slug => $old_gateway_settings) { |
|
78 | 78 | |
79 | - if( in_array( $old_gateway_slug, $this->_gateway_we_know_to_migrate ) ) { |
|
80 | - if( ! $old_gateway_settings){ |
|
79 | + if (in_array($old_gateway_slug, $this->_gateway_we_know_to_migrate)) { |
|
80 | + if ( ! $old_gateway_settings) { |
|
81 | 81 | //no settings existed for this gateway anyways... weird... |
82 | 82 | $items_actually_migrated++; |
83 | 83 | continue; |
@@ -86,16 +86,16 @@ discard block |
||
86 | 86 | $success = $this->_convert_gateway_settings( |
87 | 87 | $old_gateway_slug, |
88 | 88 | $old_gateway_settings, |
89 | - isset( EE_Config::instance()->gateway->active_gateways[ $old_gateway_slug ] ) ); |
|
90 | - if( $success ) { |
|
91 | - EE_Config::instance()->gateway->payment_settings[ $old_gateway_slug ] = 'Deprecated'; |
|
89 | + isset(EE_Config::instance()->gateway->active_gateways[$old_gateway_slug]) ); |
|
90 | + if ($success) { |
|
91 | + EE_Config::instance()->gateway->payment_settings[$old_gateway_slug] = 'Deprecated'; |
|
92 | 92 | } |
93 | 93 | } |
94 | 94 | $items_actually_migrated++; |
95 | 95 | } |
96 | 96 | |
97 | - EE_Config::instance()->update_espresso_config(false,false); |
|
98 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
97 | + EE_Config::instance()->update_espresso_config(false, false); |
|
98 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
99 | 99 | $this->set_completed(); |
100 | 100 | } |
101 | 101 | return $items_actually_migrated; |
@@ -108,22 +108,22 @@ discard block |
||
108 | 108 | * @param boolean $active indicates the gateway is currently active |
109 | 109 | * @return boolean success |
110 | 110 | */ |
111 | - protected function _convert_gateway_settings($old_gateway_slug,$old_gateway_settings,$active){ |
|
112 | - switch($old_gateway_slug){ |
|
111 | + protected function _convert_gateway_settings($old_gateway_slug, $old_gateway_settings, $active) { |
|
112 | + switch ($old_gateway_slug) { |
|
113 | 113 | case 'Aim': |
114 | 114 | $extra_meta_key_values = array( |
115 | 115 | 'login_id'=>$old_gateway_settings['authnet_aim_login_id'], |
116 | 116 | 'transaction_key'=>$old_gateway_settings['authnet_aim_transaction_key'], |
117 | 117 | 'test_transactions'=>$old_gateway_settings['test_transactions'] |
118 | 118 | ); |
119 | - $desc = __( 'Please provide the following billing information.', 'event_espresso' ); |
|
119 | + $desc = __('Please provide the following billing information.', 'event_espresso'); |
|
120 | 120 | break; |
121 | 121 | case 'Bank': |
122 | 122 | $extra_meta_key_values = array( |
123 | 123 | 'page_title'=>$old_gateway_settings['page_title'], |
124 | 124 | 'payment_instructions'=> |
125 | - sprintf( __('%1$s<br/>Name on Bank Account: %2$s<br/>Bank Account Number: %3$s<br/>Bank Name: %4$s<br/>Bank Address:%5$s', 'event_espresso'), $old_gateway_settings['bank_instructions'] , $old_gateway_settings['account_name'], $old_gateway_settings['account_number'], $old_gateway_settings['bank_name'], $old_gateway_settings['bank_address'] ) ); |
|
126 | - $desc = __( 'Make payment using an electronic funds transfer from your bank.', 'event_espresso' ); |
|
125 | + sprintf(__('%1$s<br/>Name on Bank Account: %2$s<br/>Bank Account Number: %3$s<br/>Bank Name: %4$s<br/>Bank Address:%5$s', 'event_espresso'), $old_gateway_settings['bank_instructions'], $old_gateway_settings['account_name'], $old_gateway_settings['account_number'], $old_gateway_settings['bank_name'], $old_gateway_settings['bank_address']) ); |
|
126 | + $desc = __('Make payment using an electronic funds transfer from your bank.', 'event_espresso'); |
|
127 | 127 | break; |
128 | 128 | case 'Check': |
129 | 129 | $extra_meta_key_values = array( |
@@ -131,7 +131,7 @@ discard block |
||
131 | 131 | 'payment_instructions'=>$old_gateway_settings['check_instructions'], |
132 | 132 | 'address_to_send_payment'=>$old_gateway_settings['payment_address'] |
133 | 133 | ); |
134 | - $desc = __( 'On the next page you will be given instructions on how to make a payment by check.', 'event_espresso' ); |
|
134 | + $desc = __('On the next page you will be given instructions on how to make a payment by check.', 'event_espresso'); |
|
135 | 135 | break; |
136 | 136 | case 'Invoice': |
137 | 137 | $extra_meta_key_values = array( |
@@ -139,23 +139,23 @@ discard block |
||
139 | 139 | 'pdf_payee_email' => $old_gateway_settings['template_invoice_email'], |
140 | 140 | 'pdf_payee_tax_number' => $old_gateway_settings['template_invoice_tax_number'], |
141 | 141 | 'pdf_payee_address' => $old_gateway_settings['template_invoice_address'], |
142 | - 'pdf_instructions' => $old_gateway_settings[ 'template_payment_instructions' ], |
|
143 | - 'pdf_logo_image' => $old_gateway_settings[ 'invoice_logo_url' ], |
|
144 | - 'page_confirmation_text' => isset( $old_gateway_settings[ 'page_instructions' ] ) ? $old_gateway_settings[ 'page_instructions' ] : '', |
|
145 | - 'page_extra_info' => isset( $old_gateway_settings[ 'payment_address' ] ) ? $old_gateway_settings[ 'payment_address' ] : '', |
|
142 | + 'pdf_instructions' => $old_gateway_settings['template_payment_instructions'], |
|
143 | + 'pdf_logo_image' => $old_gateway_settings['invoice_logo_url'], |
|
144 | + 'page_confirmation_text' => isset($old_gateway_settings['page_instructions']) ? $old_gateway_settings['page_instructions'] : '', |
|
145 | + 'page_extra_info' => isset($old_gateway_settings['payment_address']) ? $old_gateway_settings['payment_address'] : '', |
|
146 | 146 | 'legacy_invoice_css' => $old_gateway_settings['invoice_css'] |
147 | 147 | ); |
148 | 148 | //if they didnt want the invoiec gateway to show, pretend it was inactive |
149 | - if( ! $old_gateway_settings['show'] ){ |
|
149 | + if ( ! $old_gateway_settings['show']) { |
|
150 | 150 | $active = FALSE; |
151 | 151 | } |
152 | - $desc = __( 'On the next page you will be able to access your invoice and instructions on how to pay it.', 'event_espresso' ); |
|
152 | + $desc = __('On the next page you will be able to access your invoice and instructions on how to pay it.', 'event_espresso'); |
|
153 | 153 | break; |
154 | 154 | case 'Mijireh': |
155 | 155 | $extra_meta_key_values = array( |
156 | - 'access_key' => $old_gateway_settings[ 'access_key' ] |
|
156 | + 'access_key' => $old_gateway_settings['access_key'] |
|
157 | 157 | ); |
158 | - $desc = __( 'On the next page you will be able to enter your billing information to make the payment.', 'event_espresso' ); |
|
158 | + $desc = __('On the next page you will be able to enter your billing information to make the payment.', 'event_espresso'); |
|
159 | 159 | break; |
160 | 160 | case 'Paypal_Pro': |
161 | 161 | $extra_meta_key_values = array( |
@@ -164,31 +164,31 @@ discard block |
||
164 | 164 | 'signature'=>$old_gateway_settings['signature'], |
165 | 165 | 'credit_card_types'=>$old_gateway_settings['credit_cards'], |
166 | 166 | ); |
167 | - $desc = __( 'Please provide the following billing information.', 'event_espresso' ); |
|
167 | + $desc = __('Please provide the following billing information.', 'event_espresso'); |
|
168 | 168 | break; |
169 | 169 | case 'Paypal_Standard': |
170 | 170 | $extra_meta_key_values = array( |
171 | - 'paypal_id' => $old_gateway_settings[ 'paypal_id' ], |
|
172 | - 'image_url' => $old_gateway_settings[ 'image_url' ], |
|
173 | - 'shipping_details' => isset( $old_gateway_settings[ 'no_shipping' ] ) ? $old_gateway_settings[ 'no_shipping' ] : false, |
|
171 | + 'paypal_id' => $old_gateway_settings['paypal_id'], |
|
172 | + 'image_url' => $old_gateway_settings['image_url'], |
|
173 | + 'shipping_details' => isset($old_gateway_settings['no_shipping']) ? $old_gateway_settings['no_shipping'] : false, |
|
174 | 174 | |
175 | 175 | ); |
176 | - $desc = sprintf( __( 'After clicking \'Finalize Registration\', you will be forwarded to PayPal to make your payment. Make sure you return to this site in order to properly finalize your registration.', 'event_espresso' ), '<strong>','</strong>' ); |
|
176 | + $desc = sprintf(__('After clicking \'Finalize Registration\', you will be forwarded to PayPal to make your payment. Make sure you return to this site in order to properly finalize your registration.', 'event_espresso'), '<strong>', '</strong>'); |
|
177 | 177 | break; |
178 | 178 | default: |
179 | 179 | //if we don't recognize the payment method, just put everything in it into extra meta. At least this way its preserved somewhere |
180 | 180 | $extra_meta_key_values = $old_gateway_settings; |
181 | 181 | $desc = ''; |
182 | 182 | } |
183 | - $pretty_name = isset( $old_gateway_settings[ 'display_name' ] ) ? $old_gateway_settings[ 'display_name' ] : $old_gateway_slug; |
|
184 | - $offline_gateways = array( 'Bank', 'Check', 'Invoice' ); |
|
185 | - if( $active && in_array( $old_gateway_slug, $offline_gateways ) ) { |
|
186 | - $scope = array( 'CART', 'ADMIN'); |
|
187 | - }elseif( $active && ! in_array( $old_gateway_slug, $offline_gateways ) ) { |
|
188 | - $scope = array( 'CART' ); |
|
189 | - }elseif( ! $active && in_array($old_gateway_slug,$offline_gateways ) ) { |
|
190 | - $scope = array( 'ADMIN' ); |
|
191 | - }else{ |
|
183 | + $pretty_name = isset($old_gateway_settings['display_name']) ? $old_gateway_settings['display_name'] : $old_gateway_slug; |
|
184 | + $offline_gateways = array('Bank', 'Check', 'Invoice'); |
|
185 | + if ($active && in_array($old_gateway_slug, $offline_gateways)) { |
|
186 | + $scope = array('CART', 'ADMIN'); |
|
187 | + }elseif ($active && ! in_array($old_gateway_slug, $offline_gateways)) { |
|
188 | + $scope = array('CART'); |
|
189 | + }elseif ( ! $active && in_array($old_gateway_slug, $offline_gateways)) { |
|
190 | + $scope = array('ADMIN'); |
|
191 | + } else { |
|
192 | 192 | $scope = array(); |
193 | 193 | } |
194 | 194 | $payment_method_col_values = array( |
@@ -196,25 +196,25 @@ discard block |
||
196 | 196 | 'PMD_name' => $pretty_name, |
197 | 197 | 'PMD_desc' => $desc, |
198 | 198 | 'PMD_admin_name' => $pretty_name, |
199 | - 'PMD_slug' => sanitize_key( $old_gateway_slug ), |
|
200 | - 'PMD_debug_mode' => isset( $old_gateway_settings[ 'use_sandbox' ] ) ? $old_gateway_settings['use_sandbox'] : FALSE, |
|
201 | - 'PMD_button_url' => isset( $old_gateway_settings[ 'button_url' ] ) ? $old_gateway_settings[ 'button_url' ] : NULL, |
|
202 | - 'PMD_scope' => serialize( $scope ) |
|
199 | + 'PMD_slug' => sanitize_key($old_gateway_slug), |
|
200 | + 'PMD_debug_mode' => isset($old_gateway_settings['use_sandbox']) ? $old_gateway_settings['use_sandbox'] : FALSE, |
|
201 | + 'PMD_button_url' => isset($old_gateway_settings['button_url']) ? $old_gateway_settings['button_url'] : NULL, |
|
202 | + 'PMD_scope' => serialize($scope) |
|
203 | 203 | ); |
204 | 204 | $db_types = array( |
205 | - '%s',//PMD_type |
|
206 | - '%s',//PMD_name |
|
207 | - '%s',//PMD_desc |
|
208 | - '%s',//PMD_admin_name |
|
209 | - '%s',//PMD_slug |
|
210 | - '%d',//PMD_debug_mode |
|
211 | - '%s',//PMD_button_url |
|
212 | - '%s',//PMD_scope |
|
205 | + '%s', //PMD_type |
|
206 | + '%s', //PMD_name |
|
207 | + '%s', //PMD_desc |
|
208 | + '%s', //PMD_admin_name |
|
209 | + '%s', //PMD_slug |
|
210 | + '%d', //PMD_debug_mode |
|
211 | + '%s', //PMD_button_url |
|
212 | + '%s', //PMD_scope |
|
213 | 213 | ); |
214 | 214 | global $wpdb; |
215 | 215 | //first: check if it already exists |
216 | - $id = $wpdb->get_var( $wpdb->prepare( "SELECT PMD_ID FROM {$this->_new_table_name} WHERE PMD_slug=%s", $payment_method_col_values[ 'PMD_slug' ] ) ); |
|
217 | - if( $id ){ |
|
216 | + $id = $wpdb->get_var($wpdb->prepare("SELECT PMD_ID FROM {$this->_new_table_name} WHERE PMD_slug=%s", $payment_method_col_values['PMD_slug'])); |
|
217 | + if ($id) { |
|
218 | 218 | //just update that payment method instead of creating a new one |
219 | 219 | $success = $wpdb->update( |
220 | 220 | $this->_new_table_name, |
@@ -224,27 +224,27 @@ discard block |
||
224 | 224 | ), |
225 | 225 | $db_types, |
226 | 226 | array( |
227 | - '%d',//PMD_ID |
|
227 | + '%d', //PMD_ID |
|
228 | 228 | )); |
229 | - if( ! $success ){ |
|
230 | - $this->add_error(sprintf(__('Could not update payment method %d with properties %s because %s', "event_espresso"),$id,json_encode($payment_method_col_values),$wpdb->last_error)); |
|
229 | + if ( ! $success) { |
|
230 | + $this->add_error(sprintf(__('Could not update payment method %d with properties %s because %s', "event_espresso"), $id, json_encode($payment_method_col_values), $wpdb->last_error)); |
|
231 | 231 | } |
232 | - }else{ |
|
232 | + } else { |
|
233 | 233 | $success = $wpdb->insert( |
234 | 234 | $this->_new_table_name, |
235 | 235 | $payment_method_col_values, |
236 | 236 | $db_types); |
237 | - if ( ! $success ) { |
|
237 | + if ( ! $success) { |
|
238 | 238 | $this->add_error($wpdb->last_error); |
239 | 239 | return false; |
240 | - }else{ |
|
240 | + } else { |
|
241 | 241 | $id = $wpdb->insert_id; |
242 | 242 | } |
243 | 243 | } |
244 | 244 | |
245 | - if( $id ){ |
|
246 | - $this->_convert_extra_meta_values( $id, $extra_meta_key_values ); |
|
247 | - $this->get_migration_script()->set_mapping( 'EE_Gateway_Config', $old_gateway_slug, $this->_new_table_name, $id ); |
|
245 | + if ($id) { |
|
246 | + $this->_convert_extra_meta_values($id, $extra_meta_key_values); |
|
247 | + $this->get_migration_script()->set_mapping('EE_Gateway_Config', $old_gateway_slug, $this->_new_table_name, $id); |
|
248 | 248 | return true; |
249 | 249 | } |
250 | 250 | return false; |
@@ -258,26 +258,26 @@ discard block |
||
258 | 258 | * @param int $id |
259 | 259 | * @param array $extra_meta_key_values |
260 | 260 | */ |
261 | - private function _convert_extra_meta_values($id,$extra_meta_key_values){ |
|
261 | + private function _convert_extra_meta_values($id, $extra_meta_key_values) { |
|
262 | 262 | global $wpdb; |
263 | - foreach( $extra_meta_key_values as $key => $value ){ |
|
263 | + foreach ($extra_meta_key_values as $key => $value) { |
|
264 | 264 | $exm_args = array( |
265 | 265 | 'OBJ_ID'=>$id, |
266 | 266 | 'EXM_type'=>'Payment_Method', |
267 | 267 | 'EXM_key'=>$key, |
268 | - 'EXM_value'=> maybe_serialize($value ) |
|
268 | + 'EXM_value'=> maybe_serialize($value) |
|
269 | 269 | ); |
270 | 270 | $success = $wpdb->insert( |
271 | 271 | $this->_extra_meta_table_name, |
272 | 272 | $exm_args, |
273 | 273 | array( |
274 | - '%d',//OBJ_ID |
|
275 | - '%s',//EXM_type |
|
276 | - '%s',//EXM_key |
|
277 | - '%s',//EXM_value |
|
274 | + '%d', //OBJ_ID |
|
275 | + '%s', //EXM_type |
|
276 | + '%s', //EXM_key |
|
277 | + '%s', //EXM_value |
|
278 | 278 | )); |
279 | - if( ! $success ){ |
|
280 | - $this->add_error(sprintf(__('Could not insert extra meta key with values %s. %s', "event_espresso"),json_encode($exm_args),$wpdb->last_error)); |
|
279 | + if ( ! $success) { |
|
280 | + $this->add_error(sprintf(__('Could not insert extra meta key with values %s. %s', "event_espresso"), json_encode($exm_args), $wpdb->last_error)); |
|
281 | 281 | } |
282 | 282 | } |
283 | 283 | } |
@@ -184,11 +184,11 @@ discard block |
||
184 | 184 | $offline_gateways = array( 'Bank', 'Check', 'Invoice' ); |
185 | 185 | if( $active && in_array( $old_gateway_slug, $offline_gateways ) ) { |
186 | 186 | $scope = array( 'CART', 'ADMIN'); |
187 | - }elseif( $active && ! in_array( $old_gateway_slug, $offline_gateways ) ) { |
|
187 | + } elseif( $active && ! in_array( $old_gateway_slug, $offline_gateways ) ) { |
|
188 | 188 | $scope = array( 'CART' ); |
189 | - }elseif( ! $active && in_array($old_gateway_slug,$offline_gateways ) ) { |
|
189 | + } elseif( ! $active && in_array($old_gateway_slug,$offline_gateways ) ) { |
|
190 | 190 | $scope = array( 'ADMIN' ); |
191 | - }else{ |
|
191 | + } else{ |
|
192 | 192 | $scope = array(); |
193 | 193 | } |
194 | 194 | $payment_method_col_values = array( |
@@ -229,7 +229,7 @@ discard block |
||
229 | 229 | if( ! $success ){ |
230 | 230 | $this->add_error(sprintf(__('Could not update payment method %d with properties %s because %s', "event_espresso"),$id,json_encode($payment_method_col_values),$wpdb->last_error)); |
231 | 231 | } |
232 | - }else{ |
|
232 | + } else{ |
|
233 | 233 | $success = $wpdb->insert( |
234 | 234 | $this->_new_table_name, |
235 | 235 | $payment_method_col_values, |
@@ -237,7 +237,7 @@ discard block |
||
237 | 237 | if ( ! $success ) { |
238 | 238 | $this->add_error($wpdb->last_error); |
239 | 239 | return false; |
240 | - }else{ |
|
240 | + } else{ |
|
241 | 241 | $id = $wpdb->insert_id; |
242 | 242 | } |
243 | 243 | } |
@@ -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,37 +12,37 @@ discard block |
||
12 | 12 | * @author Mike Nelson |
13 | 13 | * |
14 | 14 | */ |
15 | -class EE_DMS_4_6_0_payments extends EE_Data_Migration_Script_Stage_Table{ |
|
15 | +class EE_DMS_4_6_0_payments extends EE_Data_Migration_Script_Stage_Table { |
|
16 | 16 | protected $_payment_method_table; |
17 | - function __construct(){ |
|
17 | + function __construct() { |
|
18 | 18 | global $wpdb; |
19 | - $this->_old_table = $wpdb->prefix . 'esp_payment'; |
|
20 | - $this->_payment_method_table = $wpdb->prefix . 'esp_payment_method'; |
|
19 | + $this->_old_table = $wpdb->prefix.'esp_payment'; |
|
20 | + $this->_payment_method_table = $wpdb->prefix.'esp_payment_method'; |
|
21 | 21 | $this->_pretty_name = __('Payment-Payment Method Relations', 'event_espresso'); |
22 | 22 | parent::__construct(); |
23 | 23 | } |
24 | - protected function _migrate_old_row( $payment_row ) { |
|
24 | + protected function _migrate_old_row($payment_row) { |
|
25 | 25 | global $wpdb; |
26 | 26 | //get the payment method's ID |
27 | - $PMD_ID = apply_filters( 'FHEE__EE_DMS_4_6_0_payments__migrate_old_row__PMD_ID', $this->_get_payment_method_id_by_gateway_name( $payment_row[ 'PAY_gateway' ], $payment_row[ 'PAY_method'] ) ); |
|
28 | - if( ! $PMD_ID ){ |
|
29 | - $this->add_error( sprintf( __( 'Could not find payment method with PMD_type = \'%1$s\' when migrating payment row %2$s so just assigned it an unknown payment method', 'event_espresso' ), $payment_row[ 'PAY_gateway' ], $this->_json_encode( $payment_row ) ) ); |
|
27 | + $PMD_ID = apply_filters('FHEE__EE_DMS_4_6_0_payments__migrate_old_row__PMD_ID', $this->_get_payment_method_id_by_gateway_name($payment_row['PAY_gateway'], $payment_row['PAY_method'])); |
|
28 | + if ( ! $PMD_ID) { |
|
29 | + $this->add_error(sprintf(__('Could not find payment method with PMD_type = \'%1$s\' when migrating payment row %2$s so just assigned it an unknown payment method', 'event_espresso'), $payment_row['PAY_gateway'], $this->_json_encode($payment_row))); |
|
30 | 30 | $PMD_ID = 0; |
31 | 31 | } |
32 | 32 | $new_values = array( |
33 | 33 | 'PMD_ID' => $PMD_ID, |
34 | - 'PAY_source' => ( $payment_row[ 'PAY_via_admin' ] ? 'ADMIN' : 'CART' ) ); |
|
35 | - $wheres = array( 'PAY_ID' => $payment_row[ 'PAY_ID' ] ); |
|
36 | - $new_value_datatypes = array( '%d', '%s' ); |
|
37 | - $where_datatypes = array( '%d' ); |
|
38 | - $success = $wpdb->update( $this->_old_table, |
|
34 | + 'PAY_source' => ($payment_row['PAY_via_admin'] ? 'ADMIN' : 'CART') ); |
|
35 | + $wheres = array('PAY_ID' => $payment_row['PAY_ID']); |
|
36 | + $new_value_datatypes = array('%d', '%s'); |
|
37 | + $where_datatypes = array('%d'); |
|
38 | + $success = $wpdb->update($this->_old_table, |
|
39 | 39 | $new_values, |
40 | 40 | $wheres, |
41 | 41 | $new_value_datatypes, |
42 | 42 | $where_datatypes |
43 | 43 | ); |
44 | - if( ! $success ){ |
|
45 | - $this->add_error( sprintf( __( 'Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso' ), $this->_json_encode( $new_values ), $this->_old_table, $this->_json_encode( $wheres ) ) ); |
|
44 | + if ( ! $success) { |
|
45 | + $this->add_error(sprintf(__('Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso'), $this->_json_encode($new_values), $this->_old_table, $this->_json_encode($wheres))); |
|
46 | 46 | } |
47 | 47 | } |
48 | 48 | /** |
@@ -60,11 +60,11 @@ discard block |
||
60 | 60 | * @param int $id |
61 | 61 | * @return string |
62 | 62 | */ |
63 | - protected function _get_payment_method_id_by_gateway_name( $gateway_name, $old_pay_method_column ){ |
|
63 | + protected function _get_payment_method_id_by_gateway_name($gateway_name, $old_pay_method_column) { |
|
64 | 64 | global $wpdb; |
65 | 65 | //convert from old known PAY_method values to their corresponding |
66 | 66 | //PMD_type or default PMD_name |
67 | - switch( $old_pay_method_column ) { |
|
67 | + switch ($old_pay_method_column) { |
|
68 | 68 | case 'PP': |
69 | 69 | $pmd_type = 'Paypal_Standard'; |
70 | 70 | break; |
@@ -92,8 +92,8 @@ discard block |
||
92 | 92 | default: |
93 | 93 | $pmd_type = $gateway_name; |
94 | 94 | } |
95 | - $pmd_name = str_replace( "_", " ", $pmd_type ); |
|
96 | - return $wpdb->get_var( $wpdb->prepare( "SELECT PMD_ID FROM " . $wpdb->prefix . "esp_payment_method WHERE PMD_type = %s OR PMD_name = %s", $pmd_type, $pmd_name ) ); |
|
95 | + $pmd_name = str_replace("_", " ", $pmd_type); |
|
96 | + return $wpdb->get_var($wpdb->prepare("SELECT PMD_ID FROM ".$wpdb->prefix."esp_payment_method WHERE PMD_type = %s OR PMD_name = %s", $pmd_type, $pmd_name)); |
|
97 | 97 | } |
98 | 98 | |
99 | 99 |
@@ -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 ){ |
@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | */ |
27 | 27 | public function __construct() { |
28 | 28 | global $wpdb; |
29 | - $this->_pretty_name = __( 'Question Types', 'event_espresso' ); |
|
29 | + $this->_pretty_name = __('Question Types', 'event_espresso'); |
|
30 | 30 | $this->_old_table = $wpdb->prefix.'esp_question'; |
31 | 31 | $this->_question_type_conversions = array( |
32 | 32 | 'MULTIPLE' => 'CHECKBOX', |
@@ -35,8 +35,8 @@ discard block |
||
35 | 35 | //when fetching rows, because we automatically use a limit and offset |
36 | 36 | //rows counted before migrating any rows, need to ALSO be counted after a bunch of rows were counted |
37 | 37 | //so we need to include both the migrated rows as well as the non-migrated rows |
38 | - $QST_types_to_count = array_merge( array_keys( $this->_question_type_conversions ), $this->_question_type_conversions ); |
|
39 | - $this->_extra_where_sql = "WHERE QST_type IN ('" . implode( "', '", $QST_types_to_count ) . "')" ; |
|
38 | + $QST_types_to_count = array_merge(array_keys($this->_question_type_conversions), $this->_question_type_conversions); |
|
39 | + $this->_extra_where_sql = "WHERE QST_type IN ('".implode("', '", $QST_types_to_count)."')"; |
|
40 | 40 | parent::__construct(); |
41 | 41 | } |
42 | 42 | |
@@ -44,21 +44,21 @@ discard block |
||
44 | 44 | * @param array $question an associative array where keys are column names and values are their values. |
45 | 45 | * @return null |
46 | 46 | */ |
47 | - protected function _migrate_old_row( $question ) { |
|
47 | + protected function _migrate_old_row($question) { |
|
48 | 48 | global $wpdb; |
49 | - if ( $question['QST_ID'] && isset( $this->_question_type_conversions[ $question['QST_type'] ] )) { |
|
49 | + if ($question['QST_ID'] && isset($this->_question_type_conversions[$question['QST_type']])) { |
|
50 | 50 | $success = $wpdb->update( |
51 | 51 | $this->_old_table, |
52 | - array( 'QST_type' => $this->_question_type_conversions[ $question['QST_type'] ] ), // data |
|
53 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
54 | - array( '%s' ), // data format |
|
55 | - array( '%d' ) // where format |
|
52 | + array('QST_type' => $this->_question_type_conversions[$question['QST_type']]), // data |
|
53 | + array('QST_ID' => $question['QST_ID']), // where |
|
54 | + array('%s'), // data format |
|
55 | + array('%d') // where format |
|
56 | 56 | ); |
57 | - if ( ! $success ) { |
|
57 | + if ( ! $success) { |
|
58 | 58 | $this->add_error( |
59 | 59 | sprintf( |
60 | - __( 'Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso' ), |
|
61 | - json_encode( $question['QST_type'] ), |
|
60 | + __('Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
61 | + json_encode($question['QST_type']), |
|
62 | 62 | $question['QST_ID'], |
63 | 63 | $wpdb->last_error |
64 | 64 | ) |
@@ -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 Brent Christensen |
14 | 14 | * |
15 | 15 | */ |
16 | -class EE_DMS_4_6_0_state_system_question extends EE_Data_Migration_Script_Stage_Table{ |
|
16 | +class EE_DMS_4_6_0_state_system_question extends EE_Data_Migration_Script_Stage_Table { |
|
17 | 17 | |
18 | 18 | |
19 | 19 | |
@@ -24,7 +24,7 @@ discard block |
||
24 | 24 | */ |
25 | 25 | public function __construct() { |
26 | 26 | global $wpdb; |
27 | - $this->_pretty_name = __( 'State - System Question', 'event_espresso' ); |
|
27 | + $this->_pretty_name = __('State - System Question', 'event_espresso'); |
|
28 | 28 | $this->_old_table = $wpdb->prefix.'esp_question'; |
29 | 29 | $this->_extra_where_sql = "WHERE QST_system = 'state'"; |
30 | 30 | parent::__construct(); |
@@ -37,21 +37,21 @@ discard block |
||
37 | 37 | * @param array $question an associative array where keys are column names and values are their values. |
38 | 38 | * @return null |
39 | 39 | */ |
40 | - protected function _migrate_old_row( $question ) { |
|
41 | - if ( $question['QST_ID'] && $question['QST_system'] == 'state' ) { |
|
40 | + protected function _migrate_old_row($question) { |
|
41 | + if ($question['QST_ID'] && $question['QST_system'] == 'state') { |
|
42 | 42 | global $wpdb; |
43 | 43 | $success = $wpdb->update( |
44 | 44 | $this->_old_table, |
45 | - array( 'QST_type' => 'STATE' ), // data |
|
46 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
47 | - array( '%s' ), // data format |
|
48 | - array( '%d' ) // where format |
|
45 | + array('QST_type' => 'STATE'), // data |
|
46 | + array('QST_ID' => $question['QST_ID']), // where |
|
47 | + array('%s'), // data format |
|
48 | + array('%d') // where format |
|
49 | 49 | ); |
50 | - if ( ! $success ) { |
|
50 | + if ( ! $success) { |
|
51 | 51 | $this->add_error( |
52 | 52 | sprintf( |
53 | - __( 'Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso' ), |
|
54 | - json_encode( $question['QST_system'] ), |
|
53 | + __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
54 | + json_encode($question['QST_system']), |
|
55 | 55 | $question['QST_ID'], |
56 | 56 | $wpdb->last_error |
57 | 57 | ) |
@@ -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,20 +12,20 @@ discard block |
||
12 | 12 | * @author Brent Christensen |
13 | 13 | * |
14 | 14 | */ |
15 | -class EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price extends EE_Data_Migration_Script_Stage_Table{ |
|
15 | +class EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price extends EE_Data_Migration_Script_Stage_Table { |
|
16 | 16 | |
17 | 17 | protected $_ticket_table; |
18 | 18 | |
19 | 19 | protected $_line_item_table; |
20 | 20 | |
21 | - function __construct(){ |
|
21 | + function __construct() { |
|
22 | 22 | /** @type WPDB $wpdb */ |
23 | 23 | global $wpdb; |
24 | - $this->_pretty_name = __( 'Registration Final Price Tax Calculations', 'event_espresso' ); |
|
24 | + $this->_pretty_name = __('Registration Final Price Tax Calculations', 'event_espresso'); |
|
25 | 25 | // define tables |
26 | - $this->_old_table = $wpdb->prefix . 'esp_registration'; |
|
27 | - $this->_ticket_table = $wpdb->prefix . 'esp_ticket'; |
|
28 | - $this->_line_item_table = $wpdb->prefix . 'esp_line_item'; |
|
26 | + $this->_old_table = $wpdb->prefix.'esp_registration'; |
|
27 | + $this->_ticket_table = $wpdb->prefix.'esp_ticket'; |
|
28 | + $this->_line_item_table = $wpdb->prefix.'esp_line_item'; |
|
29 | 29 | parent::__construct(); |
30 | 30 | } |
31 | 31 | |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | global $wpdb; |
56 | 56 | $SQL = "SELECT count( reg.REG_ID ) "; |
57 | 57 | $SQL .= $this->_get_rest_of_sql_for_query(); |
58 | - $count = $wpdb->get_var( $SQL ); |
|
58 | + $count = $wpdb->get_var($SQL); |
|
59 | 59 | return $count; |
60 | 60 | } |
61 | 61 | |
@@ -67,13 +67,13 @@ discard block |
||
67 | 67 | * @param int $limit |
68 | 68 | * @return array of arrays like $wpdb->get_results($sql, ARRAY_A) |
69 | 69 | */ |
70 | - protected function _get_rows( $limit ) { |
|
70 | + protected function _get_rows($limit) { |
|
71 | 71 | /** @type WPDB $wpdb */ |
72 | 72 | global $wpdb; |
73 | 73 | $start_at_record = $this->count_records_migrated(); |
74 | 74 | $SQL = "SELECT reg.REG_ID, reg.REG_final_price, line.LIN_ID "; |
75 | 75 | $SQL .= $this->_get_rest_of_sql_for_query(); |
76 | - $SQL .= $wpdb->prepare( "LIMIT %d, %d", $start_at_record, $limit ); |
|
76 | + $SQL .= $wpdb->prepare("LIMIT %d, %d", $start_at_record, $limit); |
|
77 | 77 | |
78 | 78 | // produces something like: |
79 | 79 | /* |
@@ -93,7 +93,7 @@ discard block |
||
93 | 93 | LIMIT 1, 50 |
94 | 94 | */ |
95 | 95 | |
96 | - return $wpdb->get_results( $SQL, ARRAY_A ); |
|
96 | + return $wpdb->get_results($SQL, ARRAY_A); |
|
97 | 97 | } |
98 | 98 | |
99 | 99 | |
@@ -102,38 +102,38 @@ discard block |
||
102 | 102 | * @param array $row |
103 | 103 | * @return void |
104 | 104 | */ |
105 | - protected function _migrate_old_row( $row ) { |
|
105 | + protected function _migrate_old_row($row) { |
|
106 | 106 | /** @type WPDB $wpdb */ |
107 | 107 | global $wpdb; |
108 | 108 | // ensure all required values are present |
109 | - if ( ! isset( $row[ 'REG_ID' ], $row[ 'REG_final_price' ], $row[ 'LIN_ID' ] )) { |
|
109 | + if ( ! isset($row['REG_ID'], $row['REG_final_price'], $row['LIN_ID'])) { |
|
110 | 110 | $this->add_error( |
111 | 111 | sprintf( |
112 | - __( 'Invalid query results returned with the following data:%1$s REG_ID=%2$d, REG_final_price=%3$d, LIN_ID=%4$f. Error: "%5$s"', 'event_espresso' ), |
|
112 | + __('Invalid query results returned with the following data:%1$s REG_ID=%2$d, REG_final_price=%3$d, LIN_ID=%4$f. Error: "%5$s"', 'event_espresso'), |
|
113 | 113 | '<br />', |
114 | - isset( $row[ 'REG_ID' ] ) ? $row[ 'REG_ID' ] : '', |
|
115 | - isset( $row[ 'REG_final_price' ] ) ? $row[ 'REG_final_price' ] : '', |
|
116 | - isset( $row[ 'LIN_ID' ] ) ? $row[ 'LIN_ID' ] : '', |
|
114 | + isset($row['REG_ID']) ? $row['REG_ID'] : '', |
|
115 | + isset($row['REG_final_price']) ? $row['REG_final_price'] : '', |
|
116 | + isset($row['LIN_ID']) ? $row['LIN_ID'] : '', |
|
117 | 117 | $wpdb->last_error |
118 | 118 | ) |
119 | 119 | ); |
120 | 120 | return; |
121 | 121 | } |
122 | 122 | // get tax subtotal |
123 | - $tax_subtotal_line_item_ID = $this->_get_line_item_ID_for_tax_subtotal( $row['LIN_ID'] ); |
|
124 | - if ( ! $tax_subtotal_line_item_ID ) { |
|
123 | + $tax_subtotal_line_item_ID = $this->_get_line_item_ID_for_tax_subtotal($row['LIN_ID']); |
|
124 | + if ( ! $tax_subtotal_line_item_ID) { |
|
125 | 125 | $this->add_error( |
126 | 126 | sprintf( |
127 | - __( 'Invalid line item ID returned. Error: "%1$s"', 'event_espresso' ), |
|
127 | + __('Invalid line item ID returned. Error: "%1$s"', 'event_espresso'), |
|
128 | 128 | $wpdb->last_error |
129 | 129 | ) |
130 | 130 | ); |
131 | 131 | return; |
132 | 132 | } |
133 | 133 | // now get taxes |
134 | - $taxes = $this->_get_tax_amounts( $tax_subtotal_line_item_ID ); |
|
134 | + $taxes = $this->_get_tax_amounts($tax_subtotal_line_item_ID); |
|
135 | 135 | // apply taxes to registration final price |
136 | - $this->_apply_taxes( $row[ 'REG_ID' ], $row[ 'REG_final_price' ], $taxes ); |
|
136 | + $this->_apply_taxes($row['REG_ID'], $row['REG_final_price'], $taxes); |
|
137 | 137 | |
138 | 138 | } |
139 | 139 | |
@@ -145,14 +145,14 @@ discard block |
||
145 | 145 | * @param int $LIN_ID |
146 | 146 | * @return int |
147 | 147 | */ |
148 | - protected function _get_line_item_ID_for_tax_subtotal( $LIN_ID ) { |
|
148 | + protected function _get_line_item_ID_for_tax_subtotal($LIN_ID) { |
|
149 | 149 | /** @type WPDB $wpdb */ |
150 | 150 | global $wpdb; |
151 | 151 | $SQL = "SELECT LIN_ID "; |
152 | 152 | $SQL .= "FROM {$this->_line_item_table} "; |
153 | 153 | $SQL .= "WHERE LIN_parent = %d "; |
154 | 154 | $SQL .= "AND LIN_code = 'taxes'"; |
155 | - return $wpdb->get_var( $wpdb->prepare( $SQL, $LIN_ID ) ); |
|
155 | + return $wpdb->get_var($wpdb->prepare($SQL, $LIN_ID)); |
|
156 | 156 | } |
157 | 157 | |
158 | 158 | |
@@ -163,13 +163,13 @@ discard block |
||
163 | 163 | * @param int $LIN_ID |
164 | 164 | * @return array |
165 | 165 | */ |
166 | - protected function _get_tax_amounts( $LIN_ID ) { |
|
166 | + protected function _get_tax_amounts($LIN_ID) { |
|
167 | 167 | /** @type WPDB $wpdb */ |
168 | 168 | global $wpdb; |
169 | 169 | $SQL = "SELECT LIN_percent "; |
170 | 170 | $SQL .= "FROM {$this->_line_item_table} "; |
171 | 171 | $SQL .= "WHERE LIN_parent = %d"; |
172 | - return $wpdb->get_results( $wpdb->prepare( $SQL, $LIN_ID ), OBJECT_K ); |
|
172 | + return $wpdb->get_results($wpdb->prepare($SQL, $LIN_ID), OBJECT_K); |
|
173 | 173 | } |
174 | 174 | |
175 | 175 | |
@@ -182,14 +182,14 @@ discard block |
||
182 | 182 | * @param array $taxes |
183 | 183 | * @return void |
184 | 184 | */ |
185 | - protected function _apply_taxes( $REG_ID = 0, $final_price = 0.00, $taxes = array() ) { |
|
186 | - if ( is_array( $taxes ) && ! empty( $taxes ) ) { |
|
185 | + protected function _apply_taxes($REG_ID = 0, $final_price = 0.00, $taxes = array()) { |
|
186 | + if (is_array($taxes) && ! empty($taxes)) { |
|
187 | 187 | $total_taxes = 0; |
188 | - foreach ( $taxes as $tax ) { |
|
189 | - $total_taxes += $final_price * ( $tax->LIN_percent / 100 ); |
|
188 | + foreach ($taxes as $tax) { |
|
189 | + $total_taxes += $final_price * ($tax->LIN_percent / 100); |
|
190 | 190 | } |
191 | 191 | $final_price += $total_taxes; |
192 | - $this->_update_registration_final_price( $REG_ID, $final_price ); |
|
192 | + $this->_update_registration_final_price($REG_ID, $final_price); |
|
193 | 193 | } |
194 | 194 | } |
195 | 195 | |
@@ -202,20 +202,20 @@ discard block |
||
202 | 202 | * @param float $REG_final_price |
203 | 203 | * @return void |
204 | 204 | */ |
205 | - protected function _update_registration_final_price( $REG_ID = 0, $REG_final_price = 0.00 ) { |
|
205 | + protected function _update_registration_final_price($REG_ID = 0, $REG_final_price = 0.00) { |
|
206 | 206 | /** @type WPDB $wpdb */ |
207 | 207 | global $wpdb; |
208 | 208 | $success = $wpdb->update( |
209 | 209 | $this->_old_table, |
210 | - array( 'REG_final_price' => $REG_final_price ), // data |
|
211 | - array( 'REG_ID' => $REG_ID ), // where |
|
212 | - array( '%f' ), // data format |
|
213 | - array( '%d' ) // where format |
|
210 | + array('REG_final_price' => $REG_final_price), // data |
|
211 | + array('REG_ID' => $REG_ID), // where |
|
212 | + array('%f'), // data format |
|
213 | + array('%d') // where format |
|
214 | 214 | ); |
215 | - if ( $success === false ) { |
|
215 | + if ($success === false) { |
|
216 | 216 | $this->add_error( |
217 | 217 | sprintf( |
218 | - __( 'Could not update registration final price value for registration ID=%1$d because "%2$s"', 'event_espresso' ), |
|
218 | + __('Could not update registration final price value for registration ID=%1$d because "%2$s"', 'event_espresso'), |
|
219 | 219 | $REG_ID, |
220 | 220 | $wpdb->last_error |
221 | 221 | ) |
@@ -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,7 +12,7 @@ discard block |
||
12 | 12 | * @author Brent Christensen |
13 | 13 | * |
14 | 14 | */ |
15 | -class EE_DMS_4_7_0_Registration_Payments extends EE_Data_Migration_Script_Stage_Table{ |
|
15 | +class EE_DMS_4_7_0_Registration_Payments extends EE_Data_Migration_Script_Stage_Table { |
|
16 | 16 | |
17 | 17 | protected $_payment_table; |
18 | 18 | |
@@ -20,15 +20,15 @@ discard block |
||
20 | 20 | |
21 | 21 | protected $_registration_payment_table; |
22 | 22 | |
23 | - function __construct(){ |
|
23 | + function __construct() { |
|
24 | 24 | /** @type WPDB $wpdb */ |
25 | 25 | global $wpdb; |
26 | - $this->_pretty_name = __( 'Registration Payment Record Generation', 'event_espresso' ); |
|
26 | + $this->_pretty_name = __('Registration Payment Record Generation', 'event_espresso'); |
|
27 | 27 | // define tables |
28 | - $this->_old_table = $wpdb->prefix . 'esp_transaction'; |
|
29 | - $this->_payment_table = $wpdb->prefix . 'esp_payment'; |
|
30 | - $this->_registration_table = $wpdb->prefix . 'esp_registration'; |
|
31 | - $this->_registration_payment_table = $wpdb->prefix . 'esp_registration_payment'; |
|
28 | + $this->_old_table = $wpdb->prefix.'esp_transaction'; |
|
29 | + $this->_payment_table = $wpdb->prefix.'esp_payment'; |
|
30 | + $this->_registration_table = $wpdb->prefix.'esp_registration'; |
|
31 | + $this->_registration_payment_table = $wpdb->prefix.'esp_registration_payment'; |
|
32 | 32 | // build SQL WHERE clauses |
33 | 33 | $this->_extra_where_sql = "WHERE STS_ID IN ( 'TIN', 'TCM' ) AND TXN_Total != '0.000'"; |
34 | 34 | parent::__construct(); |
@@ -40,14 +40,14 @@ discard block |
||
40 | 40 | * @param array $transaction |
41 | 41 | * @return void |
42 | 42 | */ |
43 | - protected function _migrate_old_row( $transaction ) { |
|
43 | + protected function _migrate_old_row($transaction) { |
|
44 | 44 | /** @type WPDB $wpdb */ |
45 | 45 | global $wpdb; |
46 | - $TXN_ID = absint( $transaction[ 'TXN_ID' ] ); |
|
47 | - if ( ! $TXN_ID ) { |
|
46 | + $TXN_ID = absint($transaction['TXN_ID']); |
|
47 | + if ( ! $TXN_ID) { |
|
48 | 48 | $this->add_error( |
49 | 49 | sprintf( |
50 | - __( 'Invalid transaction with ID=%1$d. Error: "%2$s"', 'event_espresso' ), |
|
50 | + __('Invalid transaction with ID=%1$d. Error: "%2$s"', 'event_espresso'), |
|
51 | 51 | $TXN_ID, |
52 | 52 | $wpdb->last_error |
53 | 53 | ) |
@@ -55,19 +55,19 @@ discard block |
||
55 | 55 | return; |
56 | 56 | } |
57 | 57 | // get all payments for the TXN |
58 | - $payments = $this->_get_payments( $TXN_ID ); |
|
59 | - if ( empty( $payments ) ) { |
|
58 | + $payments = $this->_get_payments($TXN_ID); |
|
59 | + if (empty($payments)) { |
|
60 | 60 | return; |
61 | 61 | } |
62 | 62 | // then the registrants |
63 | - $registrations = $this->_get_registrations( $TXN_ID ); |
|
64 | - if ( empty( $registrations ) ) { |
|
63 | + $registrations = $this->_get_registrations($TXN_ID); |
|
64 | + if (empty($registrations)) { |
|
65 | 65 | return; |
66 | 66 | } |
67 | 67 | // now loop thru each payment and apply it to each of the registrations |
68 | - foreach ( $payments as $PAY_ID => $payment ) { |
|
69 | - if ( $payment->STS_ID === 'PAP' && $payment->PAY_amount > 0 ) { |
|
70 | - $this->_process_registration_payments( $payment, $registrations ); |
|
68 | + foreach ($payments as $PAY_ID => $payment) { |
|
69 | + if ($payment->STS_ID === 'PAP' && $payment->PAY_amount > 0) { |
|
70 | + $this->_process_registration_payments($payment, $registrations); |
|
71 | 71 | } |
72 | 72 | } |
73 | 73 | } |
@@ -80,11 +80,11 @@ discard block |
||
80 | 80 | * @param int $TXN_ID |
81 | 81 | * @return array |
82 | 82 | */ |
83 | - protected function _get_registrations( $TXN_ID ) { |
|
83 | + protected function _get_registrations($TXN_ID) { |
|
84 | 84 | /** @type WPDB $wpdb */ |
85 | 85 | global $wpdb; |
86 | 86 | $SQL = "SELECT * FROM {$this->_registration_table} WHERE TXN_ID = %d AND STS_ID IN ( 'RPP', 'RAP' )"; |
87 | - return $wpdb->get_results( $wpdb->prepare( $SQL, $TXN_ID ), OBJECT_K ); |
|
87 | + return $wpdb->get_results($wpdb->prepare($SQL, $TXN_ID), OBJECT_K); |
|
88 | 88 | } |
89 | 89 | |
90 | 90 | |
@@ -95,10 +95,10 @@ discard block |
||
95 | 95 | * @param int $TXN_ID |
96 | 96 | * @return array |
97 | 97 | */ |
98 | - protected function _get_payments( $TXN_ID ) { |
|
98 | + protected function _get_payments($TXN_ID) { |
|
99 | 99 | /** @type WPDB $wpdb */ |
100 | 100 | global $wpdb; |
101 | - return $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$this->_payment_table} WHERE TXN_ID = %d", $TXN_ID ), OBJECT_K ); |
|
101 | + return $wpdb->get_results($wpdb->prepare("SELECT * FROM {$this->_payment_table} WHERE TXN_ID = %d", $TXN_ID), OBJECT_K); |
|
102 | 102 | } |
103 | 103 | |
104 | 104 | |
@@ -109,10 +109,10 @@ discard block |
||
109 | 109 | * @param int $REG_ID |
110 | 110 | * @return array |
111 | 111 | */ |
112 | - protected function _get_possibly_updated_REG_paid( $REG_ID ) { |
|
112 | + protected function _get_possibly_updated_REG_paid($REG_ID) { |
|
113 | 113 | /** @type WPDB $wpdb */ |
114 | 114 | global $wpdb; |
115 | - return $wpdb->get_var( $wpdb->prepare( "SELECT REG_paid FROM {$this->_registration_table} WHERE REG_ID = %d", $REG_ID ) ); |
|
115 | + return $wpdb->get_var($wpdb->prepare("SELECT REG_paid FROM {$this->_registration_table} WHERE REG_ID = %d", $REG_ID)); |
|
116 | 116 | } |
117 | 117 | |
118 | 118 | |
@@ -127,40 +127,40 @@ discard block |
||
127 | 127 | * @param array $registrations |
128 | 128 | * @return bool |
129 | 129 | */ |
130 | - protected function _process_registration_payments( $payment, $registrations = array() ){ |
|
130 | + protected function _process_registration_payments($payment, $registrations = array()) { |
|
131 | 131 | // how much is available to apply to registrations? |
132 | 132 | $available_payment_amount = $payment->PAY_amount; |
133 | - foreach ( $registrations as $REG_ID => $registration ) { |
|
133 | + foreach ($registrations as $REG_ID => $registration) { |
|
134 | 134 | // nothing left, then we are done here? |
135 | - if ( ! $available_payment_amount > 0 ) { |
|
135 | + if ( ! $available_payment_amount > 0) { |
|
136 | 136 | break; |
137 | 137 | } |
138 | 138 | // ensure REG_final_price has a valid value, and skip if it turns out to be zero |
139 | - $registration->REG_final_price = ! empty( $registration->REG_final_price ) ? (float)$registration->REG_final_price : 0.00; |
|
140 | - if ( ! $registration->REG_final_price > 0 ) { |
|
139 | + $registration->REG_final_price = ! empty($registration->REG_final_price) ? (float) $registration->REG_final_price : 0.00; |
|
140 | + if ( ! $registration->REG_final_price > 0) { |
|
141 | 141 | continue; |
142 | 142 | } |
143 | 143 | // because REG_paid may have been updated by a previous payment, we need to retrieve the value from the db |
144 | - $possibly_updated_REG_paid = $this->_get_possibly_updated_REG_paid( $REG_ID ); |
|
145 | - if ( is_float( $possibly_updated_REG_paid ) ) { |
|
144 | + $possibly_updated_REG_paid = $this->_get_possibly_updated_REG_paid($REG_ID); |
|
145 | + if (is_float($possibly_updated_REG_paid)) { |
|
146 | 146 | $registration->REG_paid = $possibly_updated_REG_paid; |
147 | 147 | } |
148 | 148 | // and ensure REG_paid has a valid value |
149 | - $registration->REG_paid = ! empty( $registration->REG_paid ) ? (float)$registration->REG_paid : 0.00; |
|
149 | + $registration->REG_paid = ! empty($registration->REG_paid) ? (float) $registration->REG_paid : 0.00; |
|
150 | 150 | // calculate amount owing, and skip if it turns out to be zero |
151 | 151 | $owing = $registration->REG_final_price - $registration->REG_paid; |
152 | - if ( ! $owing > 0 ) { |
|
152 | + if ( ! $owing > 0) { |
|
153 | 153 | continue; |
154 | 154 | } |
155 | 155 | // don't allow payment amount to exceed the available payment amount, OR the amount owing |
156 | - $payment_amount = min( $available_payment_amount, $owing ); |
|
156 | + $payment_amount = min($available_payment_amount, $owing); |
|
157 | 157 | // update $available_payment_amount |
158 | 158 | $available_payment_amount = $available_payment_amount - $payment_amount; |
159 | 159 | // add relation between registration and payment and set amount |
160 | - if ( $this->_insert_registration_payment( $registration->REG_ID, $payment->PAY_ID, $payment_amount )) { |
|
160 | + if ($this->_insert_registration_payment($registration->REG_ID, $payment->PAY_ID, $payment_amount)) { |
|
161 | 161 | //calculate and set new REG_paid |
162 | 162 | $registration->REG_paid = $registration->REG_paid + $payment_amount; |
163 | - $this->_update_registration_paid( $registration->REG_ID, $registration->REG_paid ); |
|
163 | + $this->_update_registration_paid($registration->REG_ID, $registration->REG_paid); |
|
164 | 164 | } |
165 | 165 | } |
166 | 166 | } |
@@ -175,18 +175,18 @@ discard block |
||
175 | 175 | * @param float $PAY_amount |
176 | 176 | * @return bool |
177 | 177 | */ |
178 | - protected function _insert_registration_payment( $REG_ID = 0, $PAY_ID = 0, $PAY_amount = 0.00 ){ |
|
178 | + protected function _insert_registration_payment($REG_ID = 0, $PAY_ID = 0, $PAY_amount = 0.00) { |
|
179 | 179 | /** @type WPDB $wpdb */ |
180 | 180 | global $wpdb; |
181 | 181 | $success = $wpdb->insert( |
182 | 182 | $this->_registration_payment_table, |
183 | - array( 'REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount, ), // data |
|
184 | - array( '%f' ) // data format |
|
183 | + array('REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount,), // data |
|
184 | + array('%f') // data format |
|
185 | 185 | ); |
186 | - if ( $success === false ) { |
|
186 | + if ($success === false) { |
|
187 | 187 | $this->add_error( |
188 | 188 | sprintf( |
189 | - __( 'Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso' ), |
|
189 | + __('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'), |
|
190 | 190 | $REG_ID, |
191 | 191 | $wpdb->last_error |
192 | 192 | ) |
@@ -205,20 +205,20 @@ discard block |
||
205 | 205 | * @param float $REG_paid |
206 | 206 | * @return bool |
207 | 207 | */ |
208 | - protected function _update_registration_paid( $REG_ID = 0, $REG_paid = 0.00 ) { |
|
208 | + protected function _update_registration_paid($REG_ID = 0, $REG_paid = 0.00) { |
|
209 | 209 | /** @type WPDB $wpdb */ |
210 | 210 | global $wpdb; |
211 | 211 | $success = $wpdb->update( |
212 | 212 | $this->_registration_table, |
213 | - array( 'REG_paid' => $REG_paid ), // data |
|
214 | - array( 'REG_ID' => $REG_ID ), // where |
|
215 | - array( '%f' ), // data format |
|
216 | - array( '%d' ) // where format |
|
213 | + array('REG_paid' => $REG_paid), // data |
|
214 | + array('REG_ID' => $REG_ID), // where |
|
215 | + array('%f'), // data format |
|
216 | + array('%d') // where format |
|
217 | 217 | ); |
218 | - if ( $success === false ) { |
|
218 | + if ($success === false) { |
|
219 | 219 | $this->add_error( |
220 | 220 | sprintf( |
221 | - __( 'Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso' ), |
|
221 | + __('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'), |
|
222 | 222 | $REG_ID, |
223 | 223 | $wpdb->last_error |
224 | 224 | ) |
@@ -26,7 +26,7 @@ |
||
26 | 26 | * just checks the field isn't blank |
27 | 27 | * |
28 | 28 | * @param $normalized_value |
29 | - * @return bool |
|
29 | + * @return boolean|null |
|
30 | 30 | * @throws \EE_Validation_Error |
31 | 31 | */ |
32 | 32 | function validate($normalized_value) { |
@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | -if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
3 | 3 | exit('No direct script access allowed'); |
4 | 4 | } |
5 | 5 | |
@@ -13,7 +13,7 @@ discard block |
||
13 | 13 | * |
14 | 14 | * Migrates line items that used to have LIN_code="tickets" to "pre-tax-total" |
15 | 15 | */ |
16 | -class EE_DMS_4_8_0_pretax_totals extends EE_Data_Migration_Script_Stage{ |
|
16 | +class EE_DMS_4_8_0_pretax_totals extends EE_Data_Migration_Script_Stage { |
|
17 | 17 | |
18 | 18 | protected $_line_item_table_name; |
19 | 19 | |
@@ -53,10 +53,10 @@ discard block |
||
53 | 53 | global $wpdb; |
54 | 54 | $rows_updated = $wpdb->update( |
55 | 55 | $this->_line_item_table_name, |
56 | - array( 'LIN_code' => 'pre-tax-subtotal' ), |
|
57 | - array( 'LIN_code' => 'tickets' ), |
|
58 | - array( '%s' ), |
|
59 | - array( '%s' ) ); |
|
56 | + array('LIN_code' => 'pre-tax-subtotal'), |
|
57 | + array('LIN_code' => 'tickets'), |
|
58 | + array('%s'), |
|
59 | + array('%s') ); |
|
60 | 60 | $this->set_completed(); |
61 | 61 | return 1; |
62 | 62 | } |
@@ -65,11 +65,11 @@ |
||
65 | 65 | if( $version_string <= '4.8.0' && $version_string >= '4.7.0' ){ |
66 | 66 | // echo "$version_string can be migrated from"; |
67 | 67 | return true; |
68 | - }elseif( ! $version_string ){ |
|
68 | + } elseif( ! $version_string ){ |
|
69 | 69 | // echo "no version string provided: $version_string"; |
70 | 70 | //no version string provided... this must be pre 4.3 |
71 | 71 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
72 | - }else{ |
|
72 | + } else{ |
|
73 | 73 | // echo "$version_string doesnt apply"; |
74 | 74 | return false; |
75 | 75 | } |
@@ -715,7 +715,7 @@ |
||
715 | 715 | } |
716 | 716 | } |
717 | 717 | } |
718 | - } |
|
718 | + } |
|
719 | 719 | /** |
720 | 720 | * addresses https://events.codebasehq.com/projects/event-espresso/tickets/8731 |
721 | 721 | * which should just be a temporary issue for folks who installed 4.8.0-4.8.5; |
@@ -16,13 +16,13 @@ discard block |
||
16 | 16 | //(all other times it gets resurrected from a wordpress option) |
17 | 17 | $stages = glob(EE_CORE.'data_migration_scripts/4_8_0_stages/*'); |
18 | 18 | $class_to_filepath = array(); |
19 | -foreach($stages as $filepath){ |
|
19 | +foreach ($stages as $filepath) { |
|
20 | 20 | $matches = array(); |
21 | - preg_match('~4_8_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
21 | + preg_match('~4_8_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
22 | 22 | $class_to_filepath[$matches[1]] = $filepath; |
23 | 23 | } |
24 | 24 | //give addons a chance to autoload their stages too |
25 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_8_0__autoloaded_stages',$class_to_filepath); |
|
25 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_8_0__autoloaded_stages', $class_to_filepath); |
|
26 | 26 | EEH_Autoloader::register_autoloader($class_to_filepath); |
27 | 27 | |
28 | 28 | |
@@ -38,7 +38,7 @@ discard block |
||
38 | 38 | * @since 4.6.0 |
39 | 39 | * |
40 | 40 | */ |
41 | -class EE_DMS_Core_4_8_0 extends EE_Data_Migration_Script_Base{ |
|
41 | +class EE_DMS_Core_4_8_0 extends EE_Data_Migration_Script_Base { |
|
42 | 42 | |
43 | 43 | /** |
44 | 44 | * return EE_DMS_Core_4_8_0 |
@@ -46,14 +46,14 @@ discard block |
||
46 | 46 | * @param TableManager $table_manager |
47 | 47 | * @param TableAnalysis $table_analysis |
48 | 48 | */ |
49 | - public function __construct( TableManager $table_manager = null, TableAnalysis $table_analysis = null ) { |
|
49 | + public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null) { |
|
50 | 50 | $this->_pretty_name = __("Data Migration to Event Espresso 4.8.0.P (for promotions)", "event_espresso"); |
51 | 51 | $this->_priority = 10; |
52 | 52 | $this->_migration_stages = array( |
53 | 53 | new EE_DMS_4_8_0_pretax_totals(), |
54 | 54 | new EE_DMS_4_8_0_event_subtotals(), |
55 | 55 | ); |
56 | - parent::__construct( $table_manager, $table_analysis ); |
|
56 | + parent::__construct($table_manager, $table_analysis); |
|
57 | 57 | } |
58 | 58 | |
59 | 59 | |
@@ -68,14 +68,14 @@ discard block |
||
68 | 68 | */ |
69 | 69 | public function can_migrate_from_version($version_array) { |
70 | 70 | $version_string = $version_array['Core']; |
71 | - if ( version_compare( $version_string, '4.8.0', '<=' ) && version_compare( $version_string, '4.7.0', '>=' ) ) { |
|
71 | + if (version_compare($version_string, '4.8.0', '<=') && version_compare($version_string, '4.7.0', '>=')) { |
|
72 | 72 | // echo "$version_string can be migrated from"; |
73 | 73 | return true; |
74 | - }elseif( ! $version_string ){ |
|
74 | + }elseif ( ! $version_string) { |
|
75 | 75 | // echo "no version string provided: $version_string"; |
76 | 76 | //no version string provided... this must be pre 4.3 |
77 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
78 | - }else{ |
|
77 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
78 | + } else { |
|
79 | 79 | // echo "$version_string doesnt apply"; |
80 | 80 | return false; |
81 | 81 | } |
@@ -96,19 +96,19 @@ discard block |
||
96 | 96 | * @return bool |
97 | 97 | */ |
98 | 98 | public function schema_changes_before_migration() { |
99 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
100 | - $now_in_mysql = current_time( 'mysql', true ); |
|
99 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
100 | + $now_in_mysql = current_time('mysql', true); |
|
101 | 101 | |
102 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
103 | - $table_name='esp_answer'; |
|
104 | - $sql=" ANS_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
102 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
103 | + $table_name = 'esp_answer'; |
|
104 | + $sql = " ANS_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
105 | 105 | REG_ID int(10) unsigned NOT NULL, |
106 | 106 | QST_ID int(10) unsigned NOT NULL, |
107 | 107 | ANS_value text NOT NULL, |
108 | 108 | PRIMARY KEY (ANS_ID), |
109 | 109 | KEY REG_ID (REG_ID), |
110 | 110 | KEY QST_ID (QST_ID)"; |
111 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
111 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
112 | 112 | |
113 | 113 | $table_name = 'esp_attendee_meta'; |
114 | 114 | $sql = "ATTM_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
@@ -148,7 +148,7 @@ discard block |
||
148 | 148 | CNT_is_EU tinyint(1) DEFAULT '0', |
149 | 149 | CNT_active tinyint(1) DEFAULT '0', |
150 | 150 | PRIMARY KEY (CNT_ISO)"; |
151 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB' ); |
|
151 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
152 | 152 | |
153 | 153 | $table_name = 'esp_currency'; |
154 | 154 | $sql = "CUR_code varchar(6) collate utf8_bin NOT NULL, |
@@ -158,7 +158,7 @@ discard block |
||
158 | 158 | CUR_dec_plc varchar(1) collate utf8_bin NOT NULL DEFAULT '2', |
159 | 159 | CUR_active tinyint(1) DEFAULT '0', |
160 | 160 | PRIMARY KEY (CUR_code)"; |
161 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB' ); |
|
161 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
162 | 162 | |
163 | 163 | |
164 | 164 | $table_name = 'esp_currency_payment_method'; |
@@ -188,7 +188,7 @@ discard block |
||
188 | 188 | KEY EVT_ID (EVT_ID), |
189 | 189 | KEY DTT_is_primary (DTT_is_primary)"; |
190 | 190 | |
191 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
191 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
192 | 192 | |
193 | 193 | $table_name = 'esp_event_meta'; |
194 | 194 | $sql = " |
@@ -207,41 +207,41 @@ discard block |
||
207 | 207 | EVT_donations tinyint(1) NULL, |
208 | 208 | PRIMARY KEY (EVTM_ID), |
209 | 209 | KEY EVT_ID (EVT_ID)"; |
210 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
210 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
211 | 211 | |
212 | 212 | |
213 | 213 | |
214 | - $table_name='esp_event_question_group'; |
|
215 | - $sql="EQG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
214 | + $table_name = 'esp_event_question_group'; |
|
215 | + $sql = "EQG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
216 | 216 | EVT_ID bigint(20) unsigned NOT NULL, |
217 | 217 | QSG_ID int(10) unsigned NOT NULL, |
218 | 218 | EQG_primary tinyint(1) unsigned NOT NULL DEFAULT 0, |
219 | 219 | PRIMARY KEY (EQG_ID), |
220 | 220 | KEY EVT_ID (EVT_ID), |
221 | 221 | KEY QSG_ID (QSG_ID)"; |
222 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
222 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
223 | 223 | |
224 | 224 | |
225 | 225 | |
226 | - $table_name='esp_event_venue'; |
|
227 | - $sql="EVV_ID int(11) NOT NULL AUTO_INCREMENT, |
|
226 | + $table_name = 'esp_event_venue'; |
|
227 | + $sql = "EVV_ID int(11) NOT NULL AUTO_INCREMENT, |
|
228 | 228 | EVT_ID bigint(20) unsigned NOT NULL, |
229 | 229 | VNU_ID bigint(20) unsigned NOT NULL, |
230 | 230 | EVV_primary tinyint(1) unsigned NOT NULL DEFAULT 0, |
231 | 231 | PRIMARY KEY (EVV_ID)"; |
232 | - $this->_table_has_not_changed_since_previous($table_name,$sql, 'ENGINE=InnoDB'); |
|
232 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
233 | 233 | |
234 | 234 | |
235 | 235 | |
236 | - $table_name='esp_extra_meta'; |
|
237 | - $sql="EXM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
236 | + $table_name = 'esp_extra_meta'; |
|
237 | + $sql = "EXM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
238 | 238 | OBJ_ID int(11) DEFAULT NULL, |
239 | 239 | EXM_type varchar(45) DEFAULT NULL, |
240 | 240 | EXM_key varchar(45) DEFAULT NULL, |
241 | 241 | EXM_value text, |
242 | 242 | PRIMARY KEY (EXM_ID), |
243 | 243 | KEY EXM_type (EXM_type,OBJ_ID,EXM_key)"; |
244 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
244 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
245 | 245 | |
246 | 246 | $table_name = 'esp_extra_join'; |
247 | 247 | $sql = "EXJ_ID int(11) NOT NULL AUTO_INCREMENT, |
@@ -254,8 +254,8 @@ discard block |
||
254 | 254 | KEY second_model (EXJ_second_model_name,EXJ_second_model_id)"; |
255 | 255 | $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB '); |
256 | 256 | |
257 | - $table_name='esp_line_item'; |
|
258 | - $sql="LIN_ID int(11) NOT NULL AUTO_INCREMENT, |
|
257 | + $table_name = 'esp_line_item'; |
|
258 | + $sql = "LIN_ID int(11) NOT NULL AUTO_INCREMENT, |
|
259 | 259 | LIN_code varchar(245) NOT NULL DEFAULT '', |
260 | 260 | TXN_ID int(11) DEFAULT NULL, |
261 | 261 | LIN_name varchar(245) NOT NULL DEFAULT '', |
@@ -274,7 +274,7 @@ discard block |
||
274 | 274 | PRIMARY KEY (LIN_ID), |
275 | 275 | KEY LIN_code (LIN_code(191)), |
276 | 276 | KEY TXN_ID (TXN_ID)"; |
277 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB' ); |
|
277 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
278 | 278 | |
279 | 279 | $table_name = 'esp_log'; |
280 | 280 | $sql = "LOG_ID int(11) NOT NULL AUTO_INCREMENT, |
@@ -313,7 +313,7 @@ discard block |
||
313 | 313 | MTP_is_active tinyint(1) NOT NULL DEFAULT '1', |
314 | 314 | PRIMARY KEY (GRP_ID), |
315 | 315 | KEY MTP_user_id (MTP_user_id)"; |
316 | - $this->_table_has_not_changed_since_previous( $table_name, $sql, 'ENGINE=InnoDB'); |
|
316 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
317 | 317 | |
318 | 318 | $table_name = 'esp_event_message_template'; |
319 | 319 | $sql = "EMT_ID bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
@@ -322,7 +322,7 @@ discard block |
||
322 | 322 | PRIMARY KEY (EMT_ID), |
323 | 323 | KEY EVT_ID (EVT_ID), |
324 | 324 | KEY GRP_ID (GRP_ID)"; |
325 | - $this->_table_has_not_changed_since_previous( $table_name, $sql, 'ENGINE=InnoDB'); |
|
325 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
326 | 326 | |
327 | 327 | |
328 | 328 | $table_name = 'esp_payment'; |
@@ -395,8 +395,8 @@ discard block |
||
395 | 395 | PRIMARY KEY (TTM_ID)"; |
396 | 396 | $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
397 | 397 | |
398 | - $table_name='esp_question'; |
|
399 | - $sql='QST_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
398 | + $table_name = 'esp_question'; |
|
399 | + $sql = 'QST_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
400 | 400 | QST_display_text text NOT NULL, |
401 | 401 | QST_admin_label varchar(255) NOT NULL, |
402 | 402 | QST_system varchar(25) NOT NULL DEFAULT "", |
@@ -410,22 +410,22 @@ discard block |
||
410 | 410 | QST_deleted tinyint(2) unsigned NOT NULL DEFAULT 0, |
411 | 411 | PRIMARY KEY (QST_ID), |
412 | 412 | KEY QST_order (QST_order)'; |
413 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
413 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
414 | 414 | |
415 | - $table_name='esp_question_group_question'; |
|
416 | - $sql="QGQ_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
415 | + $table_name = 'esp_question_group_question'; |
|
416 | + $sql = "QGQ_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
417 | 417 | QSG_ID int(10) unsigned NOT NULL, |
418 | 418 | QST_ID int(10) unsigned NOT NULL, |
419 | 419 | QGQ_order int(10) unsigned NOT NULL DEFAULT 0, |
420 | 420 | PRIMARY KEY (QGQ_ID), |
421 | 421 | KEY QST_ID (QST_ID), |
422 | 422 | KEY QSG_ID_order (QSG_ID,QGQ_order)"; |
423 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
423 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
424 | 424 | |
425 | 425 | |
426 | 426 | |
427 | - $table_name='esp_question_option'; |
|
428 | - $sql="QSO_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
427 | + $table_name = 'esp_question_option'; |
|
428 | + $sql = "QSO_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
429 | 429 | QSO_value varchar(255) NOT NULL, |
430 | 430 | QSO_desc text NOT NULL, |
431 | 431 | QST_ID int(10) unsigned NOT NULL, |
@@ -435,7 +435,7 @@ discard block |
||
435 | 435 | PRIMARY KEY (QSO_ID), |
436 | 436 | KEY QST_ID (QST_ID), |
437 | 437 | KEY QSO_order (QSO_order)"; |
438 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
438 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
439 | 439 | |
440 | 440 | |
441 | 441 | |
@@ -481,8 +481,8 @@ discard block |
||
481 | 481 | |
482 | 482 | |
483 | 483 | |
484 | - $table_name='esp_checkin'; |
|
485 | - $sql="CHK_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
484 | + $table_name = 'esp_checkin'; |
|
485 | + $sql = "CHK_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
486 | 486 | REG_ID int(10) unsigned NOT NULL, |
487 | 487 | DTT_ID int(10) unsigned NOT NULL, |
488 | 488 | CHK_in tinyint(1) unsigned NOT NULL DEFAULT 1, |
@@ -577,7 +577,7 @@ discard block |
||
577 | 577 | PRC_parent int(10) unsigned DEFAULT 0, |
578 | 578 | PRIMARY KEY (PRC_ID), |
579 | 579 | KEY PRT_ID (PRT_ID)"; |
580 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
580 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
581 | 581 | |
582 | 582 | $table_name = "esp_price_type"; |
583 | 583 | $sql = "PRT_ID tinyint(3) unsigned NOT NULL AUTO_INCREMENT, |
@@ -615,10 +615,10 @@ discard block |
||
615 | 615 | TKT_deleted tinyint(1) NOT NULL DEFAULT '0', |
616 | 616 | PRIMARY KEY (TKT_ID), |
617 | 617 | KEY TKT_start_date (TKT_start_date)"; |
618 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
618 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
619 | 619 | |
620 | 620 | $table_name = 'esp_question_group'; |
621 | - $sql='QSG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
621 | + $sql = 'QSG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
622 | 622 | QSG_name varchar(255) NOT NULL, |
623 | 623 | QSG_identifier varchar(100) NOT NULL, |
624 | 624 | QSG_desc text NULL, |
@@ -631,7 +631,7 @@ discard block |
||
631 | 631 | PRIMARY KEY (QSG_ID), |
632 | 632 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier), |
633 | 633 | KEY QSG_order (QSG_order)'; |
634 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
634 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
635 | 635 | |
636 | 636 | /** @var EE_DMS_Core_4_1_0 $script_4_1_defaults */ |
637 | 637 | $script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
@@ -667,7 +667,7 @@ discard block |
||
667 | 667 | return $script_4_7_defaults->schema_changes_after_migration(); |
668 | 668 | } |
669 | 669 | |
670 | - public function migration_page_hooks(){ |
|
670 | + public function migration_page_hooks() { |
|
671 | 671 | |
672 | 672 | } |
673 | 673 | |
@@ -681,19 +681,19 @@ discard block |
||
681 | 681 | //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 |
682 | 682 | //('AD', 'AND', 0, 'Andorra', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+376', 0, 0), |
683 | 683 | $newer_countries = array( |
684 | - array( 'AX', 'ALA', 0, 'Alan Islands', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+358', 1, 0 ), |
|
685 | - array( 'BL', 'BLM', 0, 'Saint Barthelemy', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0 ), |
|
686 | - array( 'CW', 'CUW', 0, 'Curacao', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+599', 1, 0 ), |
|
687 | - array( 'GG', 'GGY', 0, 'Guernsey', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+44', 0, 0 ), |
|
688 | - array( 'IM', 'IMN', 0, 'Isle of Man', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0 ), |
|
689 | - array( 'JE', 'JEY', 0, 'Jersey', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0 ), |
|
690 | - array( 'MF', 'MAF', 0, 'Saint Martin', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0 ), |
|
691 | - array( 'ME', 'MNE', 0, 'Montenegro', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+382', 0, 0 ), |
|
692 | - array( 'RS', 'SRB', 0, 'Serbia', 'RSD', 'Dinar', 'Dinars', '', 0, 2, '+941', 1, 0 ), |
|
693 | - array( 'SS', 'SSD', 0, 'South Sudan', 'SSP', 'Pound', 'Pounds', '£', 1, 2, '+211', 0, 0 ), |
|
694 | - array( 'SX', 'SXM', 0, 'Sint Maarten', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+1', 1, 0 ), |
|
695 | - array( 'XK', 'XKX', 0, 'Kosovo', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+381', 0, 0 ), |
|
696 | - array( 'YT', 'MYT', 0, 'Mayotte', 'EUR', 'Euro', 'Euros', '€', 0, 2, '+262', 1, 0 ), |
|
684 | + array('AX', 'ALA', 0, 'Alan Islands', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+358', 1, 0), |
|
685 | + array('BL', 'BLM', 0, 'Saint Barthelemy', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0), |
|
686 | + array('CW', 'CUW', 0, 'Curacao', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+599', 1, 0), |
|
687 | + array('GG', 'GGY', 0, 'Guernsey', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+44', 0, 0), |
|
688 | + array('IM', 'IMN', 0, 'Isle of Man', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0), |
|
689 | + array('JE', 'JEY', 0, 'Jersey', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0), |
|
690 | + array('MF', 'MAF', 0, 'Saint Martin', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0), |
|
691 | + array('ME', 'MNE', 0, 'Montenegro', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+382', 0, 0), |
|
692 | + array('RS', 'SRB', 0, 'Serbia', 'RSD', 'Dinar', 'Dinars', '', 0, 2, '+941', 1, 0), |
|
693 | + array('SS', 'SSD', 0, 'South Sudan', 'SSP', 'Pound', 'Pounds', '£', 1, 2, '+211', 0, 0), |
|
694 | + array('SX', 'SXM', 0, 'Sint Maarten', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+1', 1, 0), |
|
695 | + array('XK', 'XKX', 0, 'Kosovo', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+381', 0, 0), |
|
696 | + array('YT', 'MYT', 0, 'Mayotte', 'EUR', 'Euro', 'Euros', '€', 0, 2, '+262', 1, 0), |
|
697 | 697 | ); |
698 | 698 | global $wpdb; |
699 | 699 | $country_table = $wpdb->prefix."esp_country"; |
@@ -712,14 +712,14 @@ discard block |
||
712 | 712 | "CNT_is_EU" => '%d', |
713 | 713 | "CNT_active" => '%d', |
714 | 714 | ); |
715 | - if ( $this->_get_table_analysis()->tableExists( $country_table ) ) { |
|
716 | - foreach( $newer_countries as $country ) { |
|
717 | - $SQL = "SELECT COUNT('CNT_ISO') FROM {$country_table} WHERE CNT_ISO='{$country[0]}' LIMIT 1" ; |
|
715 | + if ($this->_get_table_analysis()->tableExists($country_table)) { |
|
716 | + foreach ($newer_countries as $country) { |
|
717 | + $SQL = "SELECT COUNT('CNT_ISO') FROM {$country_table} WHERE CNT_ISO='{$country[0]}' LIMIT 1"; |
|
718 | 718 | $countries = $wpdb->get_var($SQL); |
719 | - if ( ! $countries ) { |
|
719 | + if ( ! $countries) { |
|
720 | 720 | |
721 | - $wpdb->insert( $country_table, |
|
722 | - array_combine( array_keys( $country_format), $country ), |
|
721 | + $wpdb->insert($country_table, |
|
722 | + array_combine(array_keys($country_format), $country), |
|
723 | 723 | $country_format |
724 | 724 | ); |
725 | 725 | } |
@@ -737,7 +737,7 @@ discard block |
||
737 | 737 | // CUR_code, CUR_single, CUR_plural, CUR_sign, CUR_dec_plc, CUR_active |
738 | 738 | //( 'EUR', 'Euro', 'Euros', '€', 2,1), |
739 | 739 | $newer_currencies = array( |
740 | - array( 'RSD', 'Dinar', 'Dinars', '', 3, 1 ), |
|
740 | + array('RSD', 'Dinar', 'Dinars', '', 3, 1), |
|
741 | 741 | ); |
742 | 742 | global $wpdb; |
743 | 743 | $currency_table = $wpdb->prefix."esp_currency"; |
@@ -749,14 +749,14 @@ discard block |
||
749 | 749 | "CUR_dec_plc" => '%d', |
750 | 750 | "CUR_active" => '%d', |
751 | 751 | ); |
752 | - if ( $this->_get_table_analysis()->tableExists( $currency_table ) ) { |
|
753 | - foreach( $newer_currencies as $currency ) { |
|
754 | - $SQL = "SELECT COUNT('CUR_code') FROM {$currency_table} WHERE CUR_code='{$currency[0]}' LIMIT 1" ; |
|
752 | + if ($this->_get_table_analysis()->tableExists($currency_table)) { |
|
753 | + foreach ($newer_currencies as $currency) { |
|
754 | + $SQL = "SELECT COUNT('CUR_code') FROM {$currency_table} WHERE CUR_code='{$currency[0]}' LIMIT 1"; |
|
755 | 755 | $countries = $wpdb->get_var($SQL); |
756 | - if ( ! $countries ) { |
|
756 | + if ( ! $countries) { |
|
757 | 757 | |
758 | - $wpdb->insert( $currency_table, |
|
759 | - array_combine( array_keys( $currency_format), $currency ), |
|
758 | + $wpdb->insert($currency_table, |
|
759 | + array_combine(array_keys($currency_format), $currency), |
|
760 | 760 | $currency_format |
761 | 761 | ); |
762 | 762 | } |
@@ -768,9 +768,9 @@ discard block |
||
768 | 768 | * which should just be a temporary issue for folks who installed 4.8.0-4.8.5; |
769 | 769 | * we should be able to stop doing this in 4.9 |
770 | 770 | */ |
771 | - public function fix_non_default_taxes(){ |
|
771 | + public function fix_non_default_taxes() { |
|
772 | 772 | global $wpdb; |
773 | - $query = $wpdb->prepare( "UPDATE |
|
773 | + $query = $wpdb->prepare("UPDATE |
|
774 | 774 | {$wpdb->prefix}esp_price p INNER JOIN |
775 | 775 | {$wpdb->prefix}esp_price_type pt ON p.PRT_ID = pt.PRT_ID |
776 | 776 | SET |
@@ -778,7 +778,7 @@ discard block |
||
778 | 778 | WHERE |
779 | 779 | p.PRC_is_default = 0 AND |
780 | 780 | pt.PBT_ID = %d |
781 | - ", EEM_Price_Type::base_type_tax ); |
|
782 | - $wpdb->query( $query ); |
|
781 | + ", EEM_Price_Type::base_type_tax); |
|
782 | + $wpdb->query($query); |
|
783 | 783 | } |
784 | 784 | } |
@@ -306,7 +306,7 @@ discard block |
||
306 | 306 | $records_migrated_during_stage = $stage->migration_step($num_records_to_migrate_limit - $num_records_actually_migrated); |
307 | 307 | $num_records_actually_migrated += $records_migrated_during_stage; |
308 | 308 | $records_migrated_per_stage[$stage->pretty_name()] = $records_migrated_during_stage; |
309 | - }catch(Exception $e){ |
|
309 | + } catch(Exception $e){ |
|
310 | 310 | //yes if we catch an exception here, we consider that migration stage borked. |
311 | 311 | $stage->set_status(EE_Data_Migration_Manager::status_fatal_error); |
312 | 312 | $this->set_status(EE_Data_Migration_Manager::status_fatal_error); |
@@ -332,14 +332,14 @@ discard block |
||
332 | 332 | //this migration script apparently has NO stages... which is super weird, but whatever |
333 | 333 | $this->set_completed(); |
334 | 334 | $this->_maybe_do_schema_changes(false); |
335 | - }else if( $num_records_actually_migrated < $num_records_to_migrate_limit && ! $stage->has_more_to_do()){ |
|
335 | + } else if( $num_records_actually_migrated < $num_records_to_migrate_limit && ! $stage->has_more_to_do()){ |
|
336 | 336 | //apparently we're done, because we couldn't migrate the number we intended to |
337 | 337 | $this->set_completed(); |
338 | 338 | $this->_update_feedback_message(array_reverse($records_migrated_per_stage)); |
339 | 339 | //do schema changes for after the migration now |
340 | 340 | //first double-check we haven't already done this |
341 | 341 | $this->_maybe_do_schema_changes(false); |
342 | - }else{ |
|
342 | + } else{ |
|
343 | 343 | //update feedback message, keeping in mind that we show them with the most recent at the top |
344 | 344 | $this->_update_feedback_message(array_reverse($records_migrated_per_stage)); |
345 | 345 | } |
@@ -378,12 +378,12 @@ discard block |
||
378 | 378 | ob_start(); |
379 | 379 | if($before){ |
380 | 380 | $this->schema_changes_before_migration(); |
381 | - }else{ |
|
381 | + } else{ |
|
382 | 382 | $this->schema_changes_after_migration(); |
383 | 383 | } |
384 | 384 | $output = ob_get_contents(); |
385 | 385 | ob_end_clean(); |
386 | - }catch(Exception $e){ |
|
386 | + } catch(Exception $e){ |
|
387 | 387 | $this->set_status(EE_Data_Migration_Manager::status_fatal_error); |
388 | 388 | throw $e; |
389 | 389 | } |
@@ -511,13 +511,13 @@ discard block |
||
511 | 511 | if( $table_is_new ) { |
512 | 512 | if( $this->_get_req_type_for_plugin_corresponding_to_this_dms() == EE_System::req_type_new_activation || $this->_currently_migrating() ){ |
513 | 513 | return true; |
514 | - }else{ |
|
514 | + } else{ |
|
515 | 515 | return false; |
516 | 516 | } |
517 | - }else{ |
|
517 | + } else{ |
|
518 | 518 | if(in_array($this->_get_req_type_for_plugin_corresponding_to_this_dms(),array(EE_System::req_type_new_activation))){ |
519 | 519 | return true; |
520 | - }else{ |
|
520 | + } else{ |
|
521 | 521 | return false; |
522 | 522 | } |
523 | 523 | } |
@@ -534,7 +534,7 @@ discard block |
||
534 | 534 | EE_Registry::instance()->load_helper('Activation'); |
535 | 535 | try{ |
536 | 536 | EEH_Activation::create_table($table_name,$table_definition_sql, $engine_string, $drop_pre_existing_tables); |
537 | - }catch( EE_Error $e ) { |
|
537 | + } catch( EE_Error $e ) { |
|
538 | 538 | $message = $e->getMessage() . '<br>Stack Trace:' . $e->getTraceAsString(); |
539 | 539 | $this->add_error( $message ); |
540 | 540 | $this->_feedback_message .= $message; |
@@ -551,11 +551,11 @@ discard block |
||
551 | 551 | private function _get_req_type_for_plugin_corresponding_to_this_dms(){ |
552 | 552 | if($this->slug() == 'Core'){ |
553 | 553 | return EE_System::instance()->detect_req_type(); |
554 | - }else{//it must be for an addon |
|
554 | + } else{//it must be for an addon |
|
555 | 555 | $addon_name = $this->slug(); |
556 | 556 | if( EE_Registry::instance()->get_addon_by_name($addon_name)){ |
557 | 557 | return EE_Registry::instance()->get_addon_by_name($addon_name)->detect_req_type(); |
558 | - }else{ |
|
558 | + } else{ |
|
559 | 559 | throw new EE_Error(sprintf(__("The DMS slug '%s' should correspond to the addon's name, which should also be '%s', but no such addon was registered. These are the registered addons' names: %s", "event_espresso"),$this->slug(),$addon_name,implode(",",array_keys( EE_Registry::instance()->get_addons_by_name() ) ) ) ) ; |
560 | 560 | } |
561 | 561 | } |
@@ -2,7 +2,7 @@ discard block |
||
2 | 2 | use EventEspresso\core\services\database\TableAnalysis; |
3 | 3 | use EventEspresso\core\services\database\TableManager; |
4 | 4 | |
5 | -if ( ! defined( 'EVENT_ESPRESSO_VERSION')) { |
|
5 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
6 | 6 | exit('No direct script access allowed'); |
7 | 7 | } |
8 | 8 | |
@@ -124,14 +124,14 @@ discard block |
||
124 | 124 | * @param TableManager $table_manager |
125 | 125 | * @param TableAnalysis $table_analysis |
126 | 126 | */ |
127 | - public function __construct( TableManager $table_manager = null, TableAnalysis $table_analysis = null ) { |
|
128 | - $this->_migration_stages = (array) apply_filters('FHEE__'.get_class($this).'__construct__migration_stages',$this->_migration_stages); |
|
129 | - foreach($this->_migration_stages as $migration_stage){ |
|
130 | - if ( $migration_stage instanceof EE_Data_Migration_Script_Stage ) { |
|
127 | + public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null) { |
|
128 | + $this->_migration_stages = (array) apply_filters('FHEE__'.get_class($this).'__construct__migration_stages', $this->_migration_stages); |
|
129 | + foreach ($this->_migration_stages as $migration_stage) { |
|
130 | + if ($migration_stage instanceof EE_Data_Migration_Script_Stage) { |
|
131 | 131 | $migration_stage->_construct_finalize($this); |
132 | 132 | } |
133 | 133 | } |
134 | - parent::__construct( $table_manager, $table_analysis ); |
|
134 | + parent::__construct($table_manager, $table_analysis); |
|
135 | 135 | } |
136 | 136 | |
137 | 137 | |
@@ -140,7 +140,7 @@ discard block |
||
140 | 140 | * Place to add hooks and filters for tweaking the migrations page, in order |
141 | 141 | * to customize it |
142 | 142 | */ |
143 | - public function migration_page_hooks(){ |
|
143 | + public function migration_page_hooks() { |
|
144 | 144 | //by default none are added because we normally like the default look of the migration page |
145 | 145 | } |
146 | 146 | |
@@ -155,9 +155,9 @@ discard block |
||
155 | 155 | * @param int|string $new_pk eg posts.ID |
156 | 156 | * @return void |
157 | 157 | */ |
158 | - public function set_mapping($old_table,$old_pk,$new_table,$new_pk){ |
|
158 | + public function set_mapping($old_table, $old_pk, $new_table, $new_pk) { |
|
159 | 159 | //make sure it has the needed keys |
160 | - if( ! isset($this->_mappings[$old_table]) || ! isset($this->_mappings[$old_table][$new_table])){ |
|
160 | + if ( ! isset($this->_mappings[$old_table]) || ! isset($this->_mappings[$old_table][$new_table])) { |
|
161 | 161 | $this->_mappings[$old_table][$new_table] = $this->_get_mapping_option($old_table, $new_table); |
162 | 162 | } |
163 | 163 | $this->_mappings[$old_table][$new_table][$old_pk] = $new_pk; |
@@ -173,9 +173,9 @@ discard block |
||
173 | 173 | * @param string $new_table with wpdb prefix (wp_). Eg: wp_posts |
174 | 174 | * @return mixed the primary key on the new table |
175 | 175 | */ |
176 | - public function get_mapping_new_pk($old_table,$old_pk,$new_table){ |
|
177 | - if( ! isset($this->_mappings[$old_table]) || |
|
178 | - ! isset($this->_mappings[$old_table][$new_table])){ |
|
176 | + public function get_mapping_new_pk($old_table, $old_pk, $new_table) { |
|
177 | + if ( ! isset($this->_mappings[$old_table]) || |
|
178 | + ! isset($this->_mappings[$old_table][$new_table])) { |
|
179 | 179 | //try fetching the option |
180 | 180 | $this->_mappings[$old_table][$new_table] = $this->_get_mapping_option($old_table, $new_table); |
181 | 181 | } |
@@ -192,15 +192,15 @@ discard block |
||
192 | 192 | * @param mixed $new_pk |
193 | 193 | * @return mixed |
194 | 194 | */ |
195 | - public function get_mapping_old_pk($old_table,$new_table,$new_pk){ |
|
196 | - if( ! isset($this->_mappings[$old_table]) || |
|
197 | - ! isset($this->_mappings[$old_table][$new_table])){ |
|
195 | + public function get_mapping_old_pk($old_table, $new_table, $new_pk) { |
|
196 | + if ( ! isset($this->_mappings[$old_table]) || |
|
197 | + ! isset($this->_mappings[$old_table][$new_table])) { |
|
198 | 198 | //try fetching the option |
199 | 199 | $this->_mappings[$old_table][$new_table] = $this->_get_mapping_option($old_table, $new_table); |
200 | 200 | } |
201 | - if(isset($this->_mappings[$old_table][$new_table])){ |
|
201 | + if (isset($this->_mappings[$old_table][$new_table])) { |
|
202 | 202 | $new_pk_to_old_pk = array_flip($this->_mappings[$old_table][$new_table]); |
203 | - if(isset($new_pk_to_old_pk[$new_pk])){ |
|
203 | + if (isset($new_pk_to_old_pk[$new_pk])) { |
|
204 | 204 | return $new_pk_to_old_pk[$new_pk]; |
205 | 205 | } |
206 | 206 | } |
@@ -215,8 +215,8 @@ discard block |
||
215 | 215 | * @param string $new_table_name |
216 | 216 | * @return array |
217 | 217 | */ |
218 | - protected function _get_mapping_option($old_table_name,$new_table_name){ |
|
219 | - $option = get_option($this->_get_mapping_option_name($old_table_name, $new_table_name),array()); |
|
218 | + protected function _get_mapping_option($old_table_name, $new_table_name) { |
|
219 | + $option = get_option($this->_get_mapping_option_name($old_table_name, $new_table_name), array()); |
|
220 | 220 | return $option; |
221 | 221 | } |
222 | 222 | |
@@ -229,9 +229,9 @@ discard block |
||
229 | 229 | * @param array $mapping_array |
230 | 230 | * @return boolean success of updating option |
231 | 231 | */ |
232 | - protected function _set_mapping_option($old_table_name,$new_table_name,$mapping_array){ |
|
232 | + protected function _set_mapping_option($old_table_name, $new_table_name, $mapping_array) { |
|
233 | 233 | // echo "set mapping for $old_table_name $new_table_name".count($mapping_array)."<br>"; |
234 | - $success = update_option($this->_get_mapping_option_name($old_table_name, $new_table_name),$mapping_array); |
|
234 | + $success = update_option($this->_get_mapping_option_name($old_table_name, $new_table_name), $mapping_array); |
|
235 | 235 | return $success; |
236 | 236 | } |
237 | 237 | |
@@ -243,12 +243,12 @@ discard block |
||
243 | 243 | * @param string $new_table_name |
244 | 244 | * @return string |
245 | 245 | */ |
246 | - protected function _get_mapping_option_name($old_table_name,$new_table_name){ |
|
246 | + protected function _get_mapping_option_name($old_table_name, $new_table_name) { |
|
247 | 247 | global $wpdb; |
248 | - $old_table_name_sans_wp = str_replace($wpdb->prefix,"",$old_table_name); |
|
249 | - $new_table_name_sans_wp = str_replace($wpdb->prefix,"",$new_table_name); |
|
248 | + $old_table_name_sans_wp = str_replace($wpdb->prefix, "", $old_table_name); |
|
249 | + $new_table_name_sans_wp = str_replace($wpdb->prefix, "", $new_table_name); |
|
250 | 250 | $migrates_to = EE_Data_Migration_Manager::instance()->script_migrates_to_version(get_class($this)); |
251 | - return substr( EE_Data_Migration_Manager::data_migration_script_mapping_option_prefix . $migrates_to [ 'slug' ] . '_' . $migrates_to[ 'version' ] . '_' . $old_table_name_sans_wp . '_' . $new_table_name_sans_wp, 0, 64 ); |
|
251 | + return substr(EE_Data_Migration_Manager::data_migration_script_mapping_option_prefix.$migrates_to ['slug'].'_'.$migrates_to['version'].'_'.$old_table_name_sans_wp.'_'.$new_table_name_sans_wp, 0, 64); |
|
252 | 252 | } |
253 | 253 | |
254 | 254 | |
@@ -265,10 +265,10 @@ discard block |
||
265 | 265 | * 99% until the function "migration_step" returns EE_Data_Migration_Script_Base::status_complete. |
266 | 266 | * @return int |
267 | 267 | */ |
268 | - protected function _count_records_to_migrate(){ |
|
268 | + protected function _count_records_to_migrate() { |
|
269 | 269 | $count = 0; |
270 | - foreach($this->stages() as $stage){ |
|
271 | - $count+= $stage->count_records_to_migrate(); |
|
270 | + foreach ($this->stages() as $stage) { |
|
271 | + $count += $stage->count_records_to_migrate(); |
|
272 | 272 | } |
273 | 273 | return $count; |
274 | 274 | } |
@@ -280,10 +280,10 @@ discard block |
||
280 | 280 | * by just setting a transient and updating it after each migration_step |
281 | 281 | * @return int |
282 | 282 | */ |
283 | - public function count_records_migrated(){ |
|
283 | + public function count_records_migrated() { |
|
284 | 284 | $count = 0; |
285 | - foreach($this->stages() as $stage){ |
|
286 | - $count+= $stage->count_records_migrated(); |
|
285 | + foreach ($this->stages() as $stage) { |
|
286 | + $count += $stage->count_records_migrated(); |
|
287 | 287 | } |
288 | 288 | $this->_records_migrated = $count; |
289 | 289 | return $count; |
@@ -297,24 +297,24 @@ discard block |
||
297 | 297 | * @throws EE_Error |
298 | 298 | * @throws Exception |
299 | 299 | */ |
300 | - public function migration_step($num_records_to_migrate_limit){ |
|
300 | + public function migration_step($num_records_to_migrate_limit) { |
|
301 | 301 | //reset the feedback message |
302 | 302 | $this->_feedback_message = ''; |
303 | 303 | //if we haven't yet done the 1st schema changes, do them now. buffer any output |
304 | 304 | $this->_maybe_do_schema_changes(true); |
305 | 305 | |
306 | - $num_records_actually_migrated =0; |
|
306 | + $num_records_actually_migrated = 0; |
|
307 | 307 | $records_migrated_per_stage = array(); |
308 | 308 | //setup the 'stage' variable, which should hold the last run stage of the migration (or none at all if nothing runs) |
309 | 309 | $stage = null; |
310 | 310 | //get the next stage that isn't complete |
311 | - foreach($this->stages() as $stage){ |
|
312 | - if( $stage->get_status() == EE_Data_Migration_Manager::status_continue){ |
|
313 | - try{ |
|
311 | + foreach ($this->stages() as $stage) { |
|
312 | + if ($stage->get_status() == EE_Data_Migration_Manager::status_continue) { |
|
313 | + try { |
|
314 | 314 | $records_migrated_during_stage = $stage->migration_step($num_records_to_migrate_limit - $num_records_actually_migrated); |
315 | 315 | $num_records_actually_migrated += $records_migrated_during_stage; |
316 | 316 | $records_migrated_per_stage[$stage->pretty_name()] = $records_migrated_during_stage; |
317 | - }catch(Exception $e){ |
|
317 | + } catch (Exception $e) { |
|
318 | 318 | //yes if we catch an exception here, we consider that migration stage borked. |
319 | 319 | $stage->set_status(EE_Data_Migration_Manager::status_fatal_error); |
320 | 320 | $this->set_status(EE_Data_Migration_Manager::status_fatal_error); |
@@ -322,7 +322,7 @@ discard block |
||
322 | 322 | throw $e; |
323 | 323 | } |
324 | 324 | //check that the migration stage didn't mark itself as having a fatal error |
325 | - if($stage->is_broken()){ |
|
325 | + if ($stage->is_broken()) { |
|
326 | 326 | $this->set_broken(); |
327 | 327 | throw new EE_Error($stage->get_last_error()); |
328 | 328 | } |
@@ -330,24 +330,24 @@ discard block |
||
330 | 330 | //once we've migrated all the number we intended to (possibly from different stages), stop migrating |
331 | 331 | //or if we had a fatal error |
332 | 332 | //or if the current script stopped early- its not done, but it's done all it thinks we should do on this step |
333 | - if ($num_records_actually_migrated >= $num_records_to_migrate_limit || $stage->is_broken() || $stage->has_more_to_do()){ |
|
333 | + if ($num_records_actually_migrated >= $num_records_to_migrate_limit || $stage->is_broken() || $stage->has_more_to_do()) { |
|
334 | 334 | break; |
335 | 335 | } |
336 | 336 | } |
337 | 337 | //check if we're all done this data migration... |
338 | 338 | //which is indicated by being done early AND the last stage claims to be done |
339 | - if($stage == NULL){ |
|
339 | + if ($stage == NULL) { |
|
340 | 340 | //this migration script apparently has NO stages... which is super weird, but whatever |
341 | 341 | $this->set_completed(); |
342 | 342 | $this->_maybe_do_schema_changes(false); |
343 | - }else if( $num_records_actually_migrated < $num_records_to_migrate_limit && ! $stage->has_more_to_do()){ |
|
343 | + } else if ($num_records_actually_migrated < $num_records_to_migrate_limit && ! $stage->has_more_to_do()) { |
|
344 | 344 | //apparently we're done, because we couldn't migrate the number we intended to |
345 | 345 | $this->set_completed(); |
346 | 346 | $this->_update_feedback_message(array_reverse($records_migrated_per_stage)); |
347 | 347 | //do schema changes for after the migration now |
348 | 348 | //first double-check we haven't already done this |
349 | 349 | $this->_maybe_do_schema_changes(false); |
350 | - }else{ |
|
350 | + } else { |
|
351 | 351 | //update feedback message, keeping in mind that we show them with the most recent at the top |
352 | 352 | $this->_update_feedback_message(array_reverse($records_migrated_per_stage)); |
353 | 353 | } |
@@ -361,12 +361,12 @@ discard block |
||
361 | 361 | * @param array $records_migrated_per_stage KEYS are pretty names for each stage; values are the count of records migrated from that stage |
362 | 362 | * @return void |
363 | 363 | */ |
364 | - private function _update_feedback_message($records_migrated_per_stage){ |
|
364 | + private function _update_feedback_message($records_migrated_per_stage) { |
|
365 | 365 | $feedback_message_array = array(); |
366 | - foreach($records_migrated_per_stage as $migration_stage_name => $num_records_migrated){ |
|
367 | - $feedback_message_array[] = sprintf(__("Migrated %d records successfully during %s", "event_espresso"),$num_records_migrated,$migration_stage_name) ; |
|
366 | + foreach ($records_migrated_per_stage as $migration_stage_name => $num_records_migrated) { |
|
367 | + $feedback_message_array[] = sprintf(__("Migrated %d records successfully during %s", "event_espresso"), $num_records_migrated, $migration_stage_name); |
|
368 | 368 | } |
369 | - $this->_feedback_message .= implode("<br>",$feedback_message_array); |
|
369 | + $this->_feedback_message .= implode("<br>", $feedback_message_array); |
|
370 | 370 | } |
371 | 371 | |
372 | 372 | |
@@ -378,27 +378,27 @@ discard block |
||
378 | 378 | * @throws Exception |
379 | 379 | * @return void |
380 | 380 | */ |
381 | - private function _maybe_do_schema_changes($before = true){ |
|
381 | + private function _maybe_do_schema_changes($before = true) { |
|
382 | 382 | //so this property will be either _schema_changes_after_migration_ran or _schema_changes_before_migration_ran |
383 | - $property_name = '_schema_changes_'. ($before ? 'before' : 'after').'_migration_ran'; |
|
384 | - if ( ! $this->{$property_name} ){ |
|
385 | - try{ |
|
383 | + $property_name = '_schema_changes_'.($before ? 'before' : 'after').'_migration_ran'; |
|
384 | + if ( ! $this->{$property_name} ) { |
|
385 | + try { |
|
386 | 386 | ob_start(); |
387 | - if($before){ |
|
387 | + if ($before) { |
|
388 | 388 | $this->schema_changes_before_migration(); |
389 | - }else{ |
|
389 | + } else { |
|
390 | 390 | $this->schema_changes_after_migration(); |
391 | 391 | } |
392 | 392 | $output = ob_get_contents(); |
393 | 393 | ob_end_clean(); |
394 | - }catch(Exception $e){ |
|
394 | + } catch (Exception $e) { |
|
395 | 395 | $this->set_status(EE_Data_Migration_Manager::status_fatal_error); |
396 | 396 | throw $e; |
397 | 397 | } |
398 | 398 | //record that we've done these schema changes |
399 | 399 | $this->{$property_name} = true; |
400 | 400 | //if there were any warnings etc, record them as non-fatal errors |
401 | - if( $output ){ |
|
401 | + if ($output) { |
|
402 | 402 | //there were some warnings |
403 | 403 | $this->_errors[] = $output; |
404 | 404 | } |
@@ -425,9 +425,9 @@ discard block |
||
425 | 425 | * @param string $table_definition_sql |
426 | 426 | * @param string $engine_string |
427 | 427 | */ |
428 | - protected function _table_is_new_in_this_version($table_name,$table_definition_sql,$engine_string='ENGINE=InnoDB '){ |
|
428 | + protected function _table_is_new_in_this_version($table_name, $table_definition_sql, $engine_string = 'ENGINE=InnoDB ') { |
|
429 | 429 | // EEH_Debug_Tools::instance()->start_timer( '_table_is_new_in_this_version_' . $table_name ); |
430 | - $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped( true ) ); |
|
430 | + $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(true)); |
|
431 | 431 | // EEH_Debug_Tools::instance()->stop_timer( '_table_is_new_in_this_version_' . $table_name ); |
432 | 432 | } |
433 | 433 | |
@@ -441,9 +441,9 @@ discard block |
||
441 | 441 | * @param string $table_definition_sql |
442 | 442 | * @param string $engine_string |
443 | 443 | */ |
444 | - protected function _table_is_changed_in_this_version($table_name,$table_definition_sql,$engine_string = 'ENGINE=MyISAM'){ |
|
444 | + protected function _table_is_changed_in_this_version($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM') { |
|
445 | 445 | // EEH_Debug_Tools::instance()->start_timer( '_table_is_changed_in_this_version' . $table_name ); |
446 | - $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped( false ) ); |
|
446 | + $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(false)); |
|
447 | 447 | // EEH_Debug_Tools::instance()->stop_timer( '_table_is_changed_in_this_version' . $table_name ); |
448 | 448 | } |
449 | 449 | |
@@ -454,8 +454,8 @@ discard block |
||
454 | 454 | * @param string $table_name |
455 | 455 | * @return boolean |
456 | 456 | */ |
457 | - protected function _old_table_exists( $table_name ) { |
|
458 | - return $this->_get_table_analysis()->tableExists( $table_name ); |
|
457 | + protected function _old_table_exists($table_name) { |
|
458 | + return $this->_get_table_analysis()->tableExists($table_name); |
|
459 | 459 | } |
460 | 460 | |
461 | 461 | |
@@ -465,8 +465,8 @@ discard block |
||
465 | 465 | * @param string $table_name |
466 | 466 | * @return boolean |
467 | 467 | */ |
468 | - protected function _delete_table_if_empty( $table_name ) { |
|
469 | - return EEH_Activation::delete_db_table_if_empty( $table_name ); |
|
468 | + protected function _delete_table_if_empty($table_name) { |
|
469 | + return EEH_Activation::delete_db_table_if_empty($table_name); |
|
470 | 470 | } |
471 | 471 | |
472 | 472 | |
@@ -485,9 +485,9 @@ discard block |
||
485 | 485 | * @param string $table_definition_sql |
486 | 486 | * @param string $engine_string |
487 | 487 | */ |
488 | - protected function _table_should_exist_previously($table_name,$table_definition_sql,$engine_string = 'ENGINE=MyISAM'){ |
|
488 | + protected function _table_should_exist_previously($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM') { |
|
489 | 489 | // EEH_Debug_Tools::instance()->start_timer( '_table_should_exist_previously' . $table_name ); |
490 | - $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped( false ) ); |
|
490 | + $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(false)); |
|
491 | 491 | // EEH_Debug_Tools::instance()->stop_timer( '_table_should_exist_previously' . $table_name ); |
492 | 492 | } |
493 | 493 | |
@@ -502,13 +502,13 @@ discard block |
||
502 | 502 | * @param string $table_definition_sql |
503 | 503 | * @param string $engine_string |
504 | 504 | */ |
505 | - protected function _table_has_not_changed_since_previous( $table_name,$table_definition_sql,$engine_string = 'ENGINE=MyISAM'){ |
|
506 | - if( $this->_currently_migrating() ) { |
|
505 | + protected function _table_has_not_changed_since_previous($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM') { |
|
506 | + if ($this->_currently_migrating()) { |
|
507 | 507 | //if we're doing a migration, and this table apparently already exists, then we don't need do anything right? |
508 | 508 | // EEH_Debug_Tools::instance()->stop_timer( '_table_should_exist_previously' . $table_name ); |
509 | 509 | return; |
510 | 510 | } |
511 | - $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped( false ) ); |
|
511 | + $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(false)); |
|
512 | 512 | } |
513 | 513 | |
514 | 514 | /** |
@@ -518,7 +518,7 @@ discard block |
||
518 | 518 | protected function _currently_migrating() { |
519 | 519 | //we want to know if we are currently performing a migration. We could just believe what was set on the _migrating property, but let's double-check (ie the script should apply and we should be in MM) |
520 | 520 | return $this->_migrating && |
521 | - $this->can_migrate_from_version( EE_Data_Migration_Manager::instance()->ensure_current_database_state_is_set() ) && |
|
521 | + $this->can_migrate_from_version(EE_Data_Migration_Manager::instance()->ensure_current_database_state_is_set()) && |
|
522 | 522 | EE_Maintenance_Mode::instance()->real_level() == EE_Maintenance_Mode::level_2_complete_maintenance; |
523 | 523 | } |
524 | 524 | |
@@ -529,17 +529,17 @@ discard block |
||
529 | 529 | * @param boolean $table_is_new |
530 | 530 | * @return boolean |
531 | 531 | */ |
532 | - protected function _pre_existing_table_should_be_dropped( $table_is_new ) { |
|
533 | - if( $table_is_new ) { |
|
534 | - if( $this->_get_req_type_for_plugin_corresponding_to_this_dms() == EE_System::req_type_new_activation || $this->_currently_migrating() ){ |
|
532 | + protected function _pre_existing_table_should_be_dropped($table_is_new) { |
|
533 | + if ($table_is_new) { |
|
534 | + if ($this->_get_req_type_for_plugin_corresponding_to_this_dms() == EE_System::req_type_new_activation || $this->_currently_migrating()) { |
|
535 | 535 | return true; |
536 | - }else{ |
|
536 | + } else { |
|
537 | 537 | return false; |
538 | 538 | } |
539 | - }else{ |
|
540 | - if(in_array($this->_get_req_type_for_plugin_corresponding_to_this_dms(),array(EE_System::req_type_new_activation))){ |
|
539 | + } else { |
|
540 | + if (in_array($this->_get_req_type_for_plugin_corresponding_to_this_dms(), array(EE_System::req_type_new_activation))) { |
|
541 | 541 | return true; |
542 | - }else{ |
|
542 | + } else { |
|
543 | 543 | return false; |
544 | 544 | } |
545 | 545 | } |
@@ -552,12 +552,12 @@ discard block |
||
552 | 552 | * @param string $engine_string |
553 | 553 | * @param boolean $drop_pre_existing_tables |
554 | 554 | */ |
555 | - private function _create_table_and_catch_errors( $table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM', $drop_pre_existing_tables = FALSE ){ |
|
556 | - try{ |
|
557 | - EEH_Activation::create_table($table_name,$table_definition_sql, $engine_string, $drop_pre_existing_tables); |
|
558 | - }catch( EE_Error $e ) { |
|
559 | - $message = $e->getMessage() . '<br>Stack Trace:' . $e->getTraceAsString(); |
|
560 | - $this->add_error( $message ); |
|
555 | + private function _create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM', $drop_pre_existing_tables = FALSE) { |
|
556 | + try { |
|
557 | + EEH_Activation::create_table($table_name, $table_definition_sql, $engine_string, $drop_pre_existing_tables); |
|
558 | + } catch (EE_Error $e) { |
|
559 | + $message = $e->getMessage().'<br>Stack Trace:'.$e->getTraceAsString(); |
|
560 | + $this->add_error($message); |
|
561 | 561 | $this->_feedback_message .= $message; |
562 | 562 | } |
563 | 563 | } |
@@ -569,15 +569,15 @@ discard block |
||
569 | 569 | * @return int one of EE_System::_req_type_* constants |
570 | 570 | * @throws EE_Error |
571 | 571 | */ |
572 | - private function _get_req_type_for_plugin_corresponding_to_this_dms(){ |
|
573 | - if($this->slug() == 'Core'){ |
|
572 | + private function _get_req_type_for_plugin_corresponding_to_this_dms() { |
|
573 | + if ($this->slug() == 'Core') { |
|
574 | 574 | return EE_System::instance()->detect_req_type(); |
575 | - }else{//it must be for an addon |
|
575 | + } else {//it must be for an addon |
|
576 | 576 | $addon_name = $this->slug(); |
577 | - if( EE_Registry::instance()->get_addon_by_name($addon_name)){ |
|
577 | + if (EE_Registry::instance()->get_addon_by_name($addon_name)) { |
|
578 | 578 | return EE_Registry::instance()->get_addon_by_name($addon_name)->detect_req_type(); |
579 | - }else{ |
|
580 | - throw new EE_Error(sprintf(__("The DMS slug '%s' should correspond to the addon's name, which should also be '%s', but no such addon was registered. These are the registered addons' names: %s", "event_espresso"),$this->slug(),$addon_name,implode(",",array_keys( EE_Registry::instance()->get_addons_by_name() ) ) ) ) ; |
|
579 | + } else { |
|
580 | + throw new EE_Error(sprintf(__("The DMS slug '%s' should correspond to the addon's name, which should also be '%s', but no such addon was registered. These are the registered addons' names: %s", "event_espresso"), $this->slug(), $addon_name, implode(",", array_keys(EE_Registry::instance()->get_addons_by_name())))); |
|
581 | 581 | } |
582 | 582 | } |
583 | 583 | } |
@@ -588,13 +588,13 @@ discard block |
||
588 | 588 | * returns an array of strings describing errors by all the script's stages |
589 | 589 | * @return array |
590 | 590 | */ |
591 | - public function get_errors(){ |
|
591 | + public function get_errors() { |
|
592 | 592 | $all_errors = $this->_errors; |
593 | - if( ! is_array($all_errors)){ |
|
593 | + if ( ! is_array($all_errors)) { |
|
594 | 594 | $all_errors = array(); |
595 | 595 | } |
596 | - foreach($this->stages() as $stage){ |
|
597 | - $all_errors = array_merge($stage->get_errors(),$all_errors); |
|
596 | + foreach ($this->stages() as $stage) { |
|
597 | + $all_errors = array_merge($stage->get_errors(), $all_errors); |
|
598 | 598 | } |
599 | 599 | return $all_errors; |
600 | 600 | } |
@@ -605,8 +605,8 @@ discard block |
||
605 | 605 | * Indicates whether or not this migration script should continue |
606 | 606 | * @return boolean |
607 | 607 | */ |
608 | - public function can_continue(){ |
|
609 | - return in_array($this->get_status(), EE_Data_Migration_Manager::instance()->stati_that_indicate_to_continue_single_migration_script); |
|
608 | + public function can_continue() { |
|
609 | + return in_array($this->get_status(), EE_Data_Migration_Manager::instance()->stati_that_indicate_to_continue_single_migration_script); |
|
610 | 610 | } |
611 | 611 | |
612 | 612 | |
@@ -618,8 +618,8 @@ discard block |
||
618 | 618 | * get ordered by the indexes |
619 | 619 | * @return EE_Data_Migration_Script_Stage[] |
620 | 620 | */ |
621 | - protected function stages(){ |
|
622 | - $stages = apply_filters( 'FHEE__'.get_class($this).'__stages',$this->_migration_stages ); |
|
621 | + protected function stages() { |
|
622 | + $stages = apply_filters('FHEE__'.get_class($this).'__stages', $this->_migration_stages); |
|
623 | 623 | ksort($stages); |
624 | 624 | return $stages; |
625 | 625 | } |
@@ -631,7 +631,7 @@ discard block |
||
631 | 631 | * can be displayed to the user |
632 | 632 | * @return string |
633 | 633 | */ |
634 | - public function get_feedback_message(){ |
|
634 | + public function get_feedback_message() { |
|
635 | 635 | return $this->_feedback_message; |
636 | 636 | } |
637 | 637 | |
@@ -643,16 +643,16 @@ discard block |
||
643 | 643 | * possible that this class is defined when it goes to sleep, but NOT available when it |
644 | 644 | * awakes (eg, this class is part of an addon that is deactivated at some point). |
645 | 645 | */ |
646 | - public function properties_as_array(){ |
|
646 | + public function properties_as_array() { |
|
647 | 647 | $properties = parent::properties_as_array(); |
648 | 648 | $properties['_migration_stages'] = array(); |
649 | - foreach($this->_migration_stages as $migration_stage_priority => $migration_stage_class){ |
|
649 | + foreach ($this->_migration_stages as $migration_stage_priority => $migration_stage_class) { |
|
650 | 650 | $properties['_migration_stages'][$migration_stage_priority] = $migration_stage_class->properties_as_array(); |
651 | 651 | } |
652 | 652 | unset($properties['_mappings']); |
653 | 653 | |
654 | - foreach($this->_mappings as $old_table_name => $mapping_to_new_table){ |
|
655 | - foreach($mapping_to_new_table as $new_table_name => $mapping){ |
|
654 | + foreach ($this->_mappings as $old_table_name => $mapping_to_new_table) { |
|
655 | + foreach ($mapping_to_new_table as $new_table_name => $mapping) { |
|
656 | 656 | $this->_set_mapping_option($old_table_name, $new_table_name, $mapping); |
657 | 657 | } |
658 | 658 | } |
@@ -667,19 +667,19 @@ discard block |
||
667 | 667 | * @param array $array_of_properties like what's produced from properties_as_array() method |
668 | 668 | * @return void |
669 | 669 | */ |
670 | - public function instantiate_from_array_of_properties($array_of_properties){ |
|
670 | + public function instantiate_from_array_of_properties($array_of_properties) { |
|
671 | 671 | $stages_properties_arrays = $array_of_properties['_migration_stages']; |
672 | 672 | unset($array_of_properties['_migration_stages']); |
673 | 673 | unset($array_of_properties['class']); |
674 | - foreach($array_of_properties as $property_name => $property_value){ |
|
674 | + foreach ($array_of_properties as $property_name => $property_value) { |
|
675 | 675 | $this->{$property_name} = $property_value; |
676 | 676 | } |
677 | 677 | //_migration_stages are already instantiated, but have only default data |
678 | - foreach($this->_migration_stages as $stage){ |
|
679 | - $stage_data = $this->_find_migration_stage_data_with_classname(get_class($stage),$stages_properties_arrays); |
|
678 | + foreach ($this->_migration_stages as $stage) { |
|
679 | + $stage_data = $this->_find_migration_stage_data_with_classname(get_class($stage), $stages_properties_arrays); |
|
680 | 680 | //SO, if we found the stage data that was saved, use it. Otherwise, I guess the stage is new? (maybe added by |
681 | 681 | //an addon? Unlikely... not sure why it wouldn't exist, but if it doesn't just treat it like it was never started yet) |
682 | - if($stage_data){ |
|
682 | + if ($stage_data) { |
|
683 | 683 | $stage->instantiate_from_array_of_properties($stage_data); |
684 | 684 | } |
685 | 685 | } |
@@ -695,9 +695,9 @@ discard block |
||
695 | 695 | * @param array $migration_stage_data_arrays |
696 | 696 | * @return null |
697 | 697 | */ |
698 | - private function _find_migration_stage_data_with_classname($classname,$migration_stage_data_arrays){ |
|
699 | - foreach($migration_stage_data_arrays as $migration_stage_data_array){ |
|
700 | - if(isset($migration_stage_data_array['class']) && $migration_stage_data_array['class'] == $classname){ |
|
698 | + private function _find_migration_stage_data_with_classname($classname, $migration_stage_data_arrays) { |
|
699 | + foreach ($migration_stage_data_arrays as $migration_stage_data_array) { |
|
700 | + if (isset($migration_stage_data_array['class']) && $migration_stage_data_array['class'] == $classname) { |
|
701 | 701 | return $migration_stage_data_array; |
702 | 702 | } |
703 | 703 | } |
@@ -713,8 +713,8 @@ discard block |
||
713 | 713 | * @return array where the first key is the plugin's slug, the 2nd is the version of that plugin |
714 | 714 | * that will be updated to. Eg array('Core','4.1.0') |
715 | 715 | */ |
716 | - public final function migrates_to_version(){ |
|
717 | - return EE_Data_Migration_Manager::instance()->script_migrates_to_version( get_class( $this ) ); |
|
716 | + public final function migrates_to_version() { |
|
717 | + return EE_Data_Migration_Manager::instance()->script_migrates_to_version(get_class($this)); |
|
718 | 718 | } |
719 | 719 | |
720 | 720 | |
@@ -726,10 +726,10 @@ discard block |
||
726 | 726 | * Or 'Core' for core (non-addon). |
727 | 727 | * @return string |
728 | 728 | */ |
729 | - public function slug(){ |
|
729 | + public function slug() { |
|
730 | 730 | $migrates_to_version_info = $this->migrates_to_version(); |
731 | 731 | //the slug is the first part of the array |
732 | - return $migrates_to_version_info[ 'slug' ]; |
|
732 | + return $migrates_to_version_info['slug']; |
|
733 | 733 | } |
734 | 734 | |
735 | 735 | |
@@ -743,7 +743,7 @@ discard block |
||
743 | 743 | * the database up so it can run), then you can set "A" to priority 3 or something. |
744 | 744 | * @return int |
745 | 745 | */ |
746 | - public function priority(){ |
|
746 | + public function priority() { |
|
747 | 747 | return $this->_priority; |
748 | 748 | } |
749 | 749 | |
@@ -756,18 +756,18 @@ discard block |
||
756 | 756 | * @param boolean $migrating |
757 | 757 | * @return void |
758 | 758 | */ |
759 | - public function set_migrating( $migrating = TRUE ){ |
|
759 | + public function set_migrating($migrating = TRUE) { |
|
760 | 760 | $this->_migrating = $migrating; |
761 | 761 | } |
762 | 762 | |
763 | 763 | /** |
764 | 764 | * Marks that we think this migration class can continue to migrate |
765 | 765 | */ |
766 | - public function reattempt(){ |
|
766 | + public function reattempt() { |
|
767 | 767 | parent::reattempt(); |
768 | 768 | //also, we want to reattempt any stages that were marked as borked |
769 | - foreach( $this->stages() as $stage ) { |
|
770 | - if( $stage->is_broken() ) { |
|
769 | + foreach ($this->stages() as $stage) { |
|
770 | + if ($stage->is_broken()) { |
|
771 | 771 | $stage->reattempt(); |
772 | 772 | } |
773 | 773 | } |