Completed
Branch BUG-10324-unit-tests-php7.1 (acc21a)
by
unknown
139:31 queued 129:15
created
4_5_0_stages/EE_DMS_4_5_0_update_wp_user_for_price_types.dmsstage.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -21,12 +21,12 @@
 block discarded – undo
21 21
 		$updated = $wpdb->update($this->_old_table,
22 22
 				array('PRT_wp_user'=>$user_id),
23 23
 				array('PRT_ID'=>$old_row['PRT_ID']),
24
-				array('%d',//PRT_wp_user
24
+				array('%d', //PRT_wp_user
25 25
 					),
26
-				array('%d',//PRT_ID
26
+				array('%d', //PRT_ID
27 27
 					));
28
-		if ( FALSE === $updated ) {
29
-			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRT_wp_user = %d where PRT_ID = %d", 'event_espresso'),$user_id,$old_row['PRT_ID']));
28
+		if (FALSE === $updated) {
29
+			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRT_wp_user = %d where PRT_ID = %d", 'event_espresso'), $user_id, $old_row['PRT_ID']));
30 30
 		}
31 31
 	}
32 32
 }
Please login to merge, or discard this patch.
4_5_0_stages/EE_DMS_4_5_0_update_wp_user_for_prices.dmsstage.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -21,12 +21,12 @@
 block discarded – undo
21 21
 		$updated = $wpdb->update($this->_old_table,
22 22
 				array('PRC_wp_user'=>$user_id),
23 23
 				array('PRC_ID'=>$old_row['PRC_ID']),
24
-				array('%d',//PRC_wp_user
24
+				array('%d', //PRC_wp_user
25 25
 					),
26
-				array('%d',//PRC_ID
26
+				array('%d', //PRC_ID
27 27
 					));
28
-		if ( FALSE === $updated ) {
29
-			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRC_wp_user = %d where PRC_ID = %d", 'event_espresso'),$user_id,$old_row['PRC_ID']));
28
+		if (FALSE === $updated) {
29
+			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRC_wp_user = %d where PRC_ID = %d", 'event_espresso'), $user_id, $old_row['PRC_ID']));
30 30
 		}
31 31
 	}
32 32
 }
Please login to merge, or discard this patch.
4_5_0_stages/EE_DMS_4_5_0_update_wp_user_for_question_groups.dmsstage.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -21,12 +21,12 @@
 block discarded – undo
21 21
 		$updated = $wpdb->update($this->_old_table,
22 22
 				array('QSG_wp_user'=>$user_id),
23 23
 				array('QSG_ID'=>$old_row['QSG_ID']),
24
-				array('%d',//QSG_wp_user
24
+				array('%d', //QSG_wp_user
25 25
 					),
26
-				array('%d',//QSG_ID
26
+				array('%d', //QSG_ID
27 27
 					));
28
-		if ( FALSE === $updated ) {
29
-			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting QSG_wp_user = %d where QSG_ID = %d", 'event_espresso'),$user_id,$old_row['QSG_ID']));
28
+		if (FALSE === $updated) {
29
+			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting QSG_wp_user = %d where QSG_ID = %d", 'event_espresso'), $user_id, $old_row['QSG_ID']));
30 30
 		}
31 31
 	}
32 32
 }
Please login to merge, or discard this patch.
4_5_0_stages/EE_DMS_4_5_0_update_wp_user_for_tickets.dmsstage.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -21,12 +21,12 @@
 block discarded – undo
21 21
 		$updated = $wpdb->update($this->_old_table,
22 22
 				array('TKT_wp_user'=>$user_id),
23 23
 				array('TKT_ID'=>$old_row['TKT_ID']),
24
-				array('%d',//TKT_wp_user
24
+				array('%d', //TKT_wp_user
25 25
 					),
26
-				array('%d',//TKT_ID
26
+				array('%d', //TKT_ID
27 27
 					));
28
-		if ( FALSE === $updated ) {
29
-			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting TKT_wp_user = %d where TKT_ID = %d", 'event_espresso'),$user_id,$old_row['TKT_ID']));
28
+		if (FALSE === $updated) {
29
+			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting TKT_wp_user = %d where TKT_ID = %d", 'event_espresso'), $user_id, $old_row['TKT_ID']));
30 30
 		}
31 31
 	}
32 32
 }
Please login to merge, or discard this patch.
data_migration_scripts/4_6_0_stages/EE_DMS_4_6_0_billing_info.dmsstage.php 1 patch
Spacing   +16 added lines, -16 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
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,24 +12,24 @@  discard block
 block discarded – undo
12 12
  * @author				Mike Nelson
13 13
  *
14 14
  */
15
-class EE_DMS_4_6_0_billing_info extends EE_Data_Migration_Script_Stage_Table{
16
-	function __construct(){
15
+class EE_DMS_4_6_0_billing_info extends EE_Data_Migration_Script_Stage_Table {
16
+	function __construct() {
17 17
 		global $wpdb;
18 18
 		$this->_old_table = $wpdb->postmeta;
19 19
 		$this->_pretty_name = __('Billing Info', 'event_espresso');
20 20
 		$this->_extra_where_sql = "WHERE meta_key LIKE 'billing_info_%'";
21 21
 		parent::__construct();
22 22
 	}
23
-	protected function _migrate_old_row( $old_row ) {
23
+	protected function _migrate_old_row($old_row) {
24 24
 		$new_billing_info = array();
25
-		$old_billing_info = maybe_unserialize( $old_row[ 'meta_value' ] );
26
-		$gateway_name = str_replace( "billing_info_",'',$old_row[ 'meta_key' ] );
25
+		$old_billing_info = maybe_unserialize($old_row['meta_value']);
26
+		$gateway_name = str_replace("billing_info_", '', $old_row['meta_key']);
27 27
 		$repetitive_prefix = '_reg-page-billing-';
28
-		$repetitive_suffix = "-" . $gateway_name;
29
-		foreach( $old_billing_info as $old_input_name => $input_value ){
30
-			$old_input_name_important_part = str_replace( array( $repetitive_prefix, $repetitive_suffix ), array( '', ''), $old_input_name );
28
+		$repetitive_suffix = "-".$gateway_name;
29
+		foreach ($old_billing_info as $old_input_name => $input_value) {
30
+			$old_input_name_important_part = str_replace(array($repetitive_prefix, $repetitive_suffix), array('', ''), $old_input_name);
31 31
 
32
-			switch( $old_input_name_important_part ){
32
+			switch ($old_input_name_important_part) {
33 33
 				case 'fname':
34 34
 					$new_input_name = 'first_name';
35 35
 					break;
@@ -39,7 +39,7 @@  discard block
 block discarded – undo
39 39
 				case 'state':
40 40
 					//we used to store the state's id ,but now we just store the name
41 41
 					$new_input_name = $old_input_name_important_part;
42
-					$input_value = $this->_get_state_name_by_ID( $input_value );
42
+					$input_value = $this->_get_state_name_by_ID($input_value);
43 43
 					break;
44 44
 				case 'card-nmbr':
45 45
 					$new_input_name = 'credit_card';
@@ -62,9 +62,9 @@  discard block
 block discarded – undo
62 62
 					$new_input_name = $old_input_name_important_part;
63 63
 
64 64
 			}
65
-			$new_billing_info[ $new_input_name ] = $input_value;
65
+			$new_billing_info[$new_input_name] = $input_value;
66 66
 		}
67
-		update_post_meta( $old_row[ 'post_id' ], $old_row[ 'meta_key' ], $new_billing_info );
67
+		update_post_meta($old_row['post_id'], $old_row['meta_key'], $new_billing_info);
68 68
 	}
69 69
 	/**
70 70
 	 *
@@ -72,9 +72,9 @@  discard block
 block discarded – undo
72 72
 	 * @param int $id
73 73
 	 * @return string
74 74
 	 */
75
-	protected function _get_state_name_by_ID( $id ){
75
+	protected function _get_state_name_by_ID($id) {
76 76
 		global $wpdb;
77
-		return $wpdb->get_var( $wpdb->prepare( "SELECT STA_name FROM " . $wpdb->prefix . "esp_state WHERE STA_ID = %d", $id ) );
77
+		return $wpdb->get_var($wpdb->prepare("SELECT STA_name FROM ".$wpdb->prefix."esp_state WHERE STA_ID = %d", $id));
78 78
 	}
79 79
 
80 80
 
Please login to merge, or discard this patch.
core/data_migration_scripts/4_6_0_stages/EE_DMS_4_6_0_gateways.dmsstage.php 2 patches
Braces   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -184,11 +184,11 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 		}
Please login to merge, or discard this patch.
Spacing   +71 added lines, -71 removed lines patch added patch discarded remove patch
@@ -1,5 +1,5 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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,wp_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, wp_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
 block discarded – undo
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"),wp_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"), wp_json_encode($exm_args), $wpdb->last_error));
281 281
 			}
282 282
 		}
283 283
 	}
Please login to merge, or discard this patch.
core/data_migration_scripts/4_6_0_stages/EE_DMS_4_6_0_payments.dmsstage.php 2 patches
Spacing   +21 added lines, -21 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 
Please login to merge, or discard this patch.
Doc Comments   -1 removed lines patch added patch discarded remove patch
@@ -49,7 +49,6 @@
 block discarded – undo
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 ){
Please login to merge, or discard this patch.
4_7_0_stages/EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price.dmsstage.php 1 patch
Spacing   +39 added lines, -39 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 				)
Please login to merge, or discard this patch.
4_7_0_stages/EE_DMS_4_7_0_Registration_Payments.dmsstage.php 2 patches
Spacing   +50 added lines, -50 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 				)
Please login to merge, or discard this patch.
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -26,7 +26,7 @@
 block discarded – undo
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) {
Please login to merge, or discard this patch.