Completed
Branch FET-8476-powered-by-event-espr... (c8a924)
by
unknown
177:34 queued 161:38
created
core/admin/EE_Help_Tour.core.php 3 patches
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -111,7 +111,7 @@
 block discarded – undo
111 111
 	 *
112 112
 	 * @access public
113 113
 	 * @param boolean $caf used to indicate if this tour is happening on caf install or not.
114
-	 * @return void
114
+	 * @return EE_Help_Tour
115 115
 	 */
116 116
 	public function __construct($caf = FALSE) {
117 117
 		$this->_is_caf = $caf;
Please login to merge, or discard this patch.
Spacing   +35 added lines, -35 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
 /**
@@ -115,7 +115,7 @@  discard block
 block discarded – undo
115 115
 	 */
116 116
 	public function __construct($caf = FALSE) {
117 117
 		$this->_is_caf = $caf;
118
-		$this->_req_data = array_merge( $_GET, $_POST );
118
+		$this->_req_data = array_merge($_GET, $_POST);
119 119
 		$this->_set_tour_properties();
120 120
 		$this->_set_tour_stops();
121 121
 		$this->_set_tour_options();
@@ -158,36 +158,36 @@  discard block
 block discarded – undo
158 158
 	 * @access protected
159 159
 	 * @return void
160 160
 	 */
161
-	protected function _set_tour_options( $options = array() ) {
161
+	protected function _set_tour_options($options = array()) {
162 162
 		$defaults = array(
163
-			'tipLocation' => 'bottom',         // 'top', 'bottom', 'right', 'left' in relation to parent
164
-		  	'nubPosition' => 'auto',           // override on a per tooltip bases. can be "auto", "right", "top", "bottom", "left"
165
-		  	'tipAdjustmentY' => 0, 			//allow for adjustment of tip
166
-		  	'tipAdjustmentX' => 0,			//allow for adjustment of tip
163
+			'tipLocation' => 'bottom', // 'top', 'bottom', 'right', 'left' in relation to parent
164
+		  	'nubPosition' => 'auto', // override on a per tooltip bases. can be "auto", "right", "top", "bottom", "left"
165
+		  	'tipAdjustmentY' => 0, //allow for adjustment of tip
166
+		  	'tipAdjustmentX' => 0, //allow for adjustment of tip
167 167
 		  	'scroll' => true, //whether to scrollTo the next step or not
168
-		  	'scrollSpeed' => 300,              // Page scrolling speed in ms
169
-		  	'timer' => 0,	                // 0 = off, all other numbers = time(ms)
170
-		  	'autoStart' => true,			// true or false - false tour starts when restart called
171
-		  	'startTimerOnClick' => true,       // true/false to start timer on first click
172
-		  	'nextButton' => true,              // true/false for next button visibility
168
+		  	'scrollSpeed' => 300, // Page scrolling speed in ms
169
+		  	'timer' => 0, // 0 = off, all other numbers = time(ms)
170
+		  	'autoStart' => true, // true or false - false tour starts when restart called
171
+		  	'startTimerOnClick' => true, // true/false to start timer on first click
172
+		  	'nextButton' => true, // true/false for next button visibility
173 173
 		  	'button_text' => __('Next', 'event_espresso'),
174
-		  	'tipAnimation' => 'fade',           // 'pop' or 'fade' in each tip
175
-		  	'pauseAfter' => array(),                // array of indexes where to pause the tour after
176
-		  	'tipAnimationFadeSpeed' => 300,    // if 'fade'- speed in ms of transition
177
-		  	'cookieMonster' => true,           // true/false for whether cookies are used
178
-		  	'cookieName' => $this->get_slug(),         // choose your own cookie name (setup will add the prefix for the specific page joyride)
179
-	  		'cookieDomain' => false,           // set to false or yoursite.com
174
+		  	'tipAnimation' => 'fade', // 'pop' or 'fade' in each tip
175
+		  	'pauseAfter' => array(), // array of indexes where to pause the tour after
176
+		  	'tipAnimationFadeSpeed' => 300, // if 'fade'- speed in ms of transition
177
+		  	'cookieMonster' => true, // true/false for whether cookies are used
178
+		  	'cookieName' => $this->get_slug(), // choose your own cookie name (setup will add the prefix for the specific page joyride)
179
+	  		'cookieDomain' => false, // set to false or yoursite.com
180 180
 		  	//'tipContainer' => 'body',            // Where the tip be attached if not inline
181
-		  	'modal' => false, 					// Whether to cover page with modal during the tour
182
-		  	'expose' => false,					// Whether to expose the elements at each step in the tour (requires modal:true),
183
-		  	'postExposeCallback' => 'EEHelpTour.postExposeCallback',    // A method to call after an element has been exposed
184
-		  	'preRideCallback' => 'EEHelpTour_preRideCallback',    // A method to call before the tour starts (passed index, tip, and cloned exposed element)
185
-		  	'postRideCallback' => 'EEHelpTour_postRideCallback',       // a method to call once the tour closes.  This will correspond to the name of a js method that will have to be defined in loaded js.
186
-		  	'preStepCallback' => 'EEHelpTour_preStepCallback',    // A method to call before each step
187
-		  	'postStepCallback' => 'EEHelpTour_postStepCallback',        // A method to call after each step (remember this will correspond with a js method that you will have to define in a js file BEFORE ee-help-tour.js loads, if the default methods do not exist, then ee-help-tour.js just substitues empty functions $.noop)/**/
181
+		  	'modal' => false, // Whether to cover page with modal during the tour
182
+		  	'expose' => false, // Whether to expose the elements at each step in the tour (requires modal:true),
183
+		  	'postExposeCallback' => 'EEHelpTour.postExposeCallback', // A method to call after an element has been exposed
184
+		  	'preRideCallback' => 'EEHelpTour_preRideCallback', // A method to call before the tour starts (passed index, tip, and cloned exposed element)
185
+		  	'postRideCallback' => 'EEHelpTour_postRideCallback', // a method to call once the tour closes.  This will correspond to the name of a js method that will have to be defined in loaded js.
186
+		  	'preStepCallback' => 'EEHelpTour_preStepCallback', // A method to call before each step
187
+		  	'postStepCallback' => 'EEHelpTour_postStepCallback', // A method to call after each step (remember this will correspond with a js method that you will have to define in a js file BEFORE ee-help-tour.js loads, if the default methods do not exist, then ee-help-tour.js just substitues empty functions $.noop)/**/
188 188
 			);
189 189
 
190
-		$options = !empty( $options ) && is_array($options)  ? array_merge( $defaults, $options ) : $defaults;
190
+		$options = ! empty($options) && is_array($options) ? array_merge($defaults, $options) : $defaults;
191 191
 		$this->_options = $options;
192 192
 	}
193 193
 
@@ -202,8 +202,8 @@  discard block
 block discarded – undo
202 202
 	 * @return string slug for the tour
203 203
 	 */
204 204
 	public function get_slug() {
205
-		if ( empty( $this->_slug ) )
206
-			throw new EE_Error( sprintf(__('There is no slug set for the help tour class (%s). Make sure that the $_slug property is set in the class constructor', 'event_espresso'), get_class($this) ) );
205
+		if (empty($this->_slug))
206
+			throw new EE_Error(sprintf(__('There is no slug set for the help tour class (%s). Make sure that the $_slug property is set in the class constructor', 'event_espresso'), get_class($this)));
207 207
 		return $this->_slug;
208 208
 	}
209 209
 
@@ -215,8 +215,8 @@  discard block
 block discarded – undo
215 215
 	 * @return string
216 216
 	 */
217 217
 	public function get_label() {
218
-		if ( empty( $this->_label ) )
219
-			throw new EE_Error( sprintf( __('There is no label set for the help tour class (%s). Make sure that the $_label property is set in the class constructor', 'event_espresso'), get_class($this) ) );
218
+		if (empty($this->_label))
219
+			throw new EE_Error(sprintf(__('There is no label set for the help tour class (%s). Make sure that the $_label property is set in the class constructor', 'event_espresso'), get_class($this)));
220 220
 		return $this->_label;
221 221
 	}
222 222
 
@@ -227,8 +227,8 @@  discard block
 block discarded – undo
227 227
 	 * @return array
228 228
 	 */
229 229
 	public function get_stops() {
230
-		foreach( $this->_stops as $ind => $stop ) {
231
-			if ( ! isset( $stop['button_text'] ) ) {
230
+		foreach ($this->_stops as $ind => $stop) {
231
+			if ( ! isset($stop['button_text'])) {
232 232
 				$this->_stops[$ind]['button_text'] = $this->_options['button_text'];
233 233
 			}
234 234
 		}
@@ -243,12 +243,12 @@  discard block
 block discarded – undo
243 243
 	 */
244 244
 	public function get_options() {
245 245
 		//let's make sure there are not pauses set
246
-		foreach ( $this->_stops as $ind => $stop ) {
247
-			if ( isset( $stop['pause_after'] ) && $stop['pause_after'] ) {
246
+		foreach ($this->_stops as $ind => $stop) {
247
+			if (isset($stop['pause_after']) && $stop['pause_after']) {
248 248
 				$this->_options['pauseAfter'][] = $ind;
249 249
 			}
250 250
 		}
251
-		return apply_filters( 'FHEE__' . get_class($this) . '__get_options', $this->_options, $this );
251
+		return apply_filters('FHEE__'.get_class($this).'__get_options', $this->_options, $this);
252 252
 	}
253 253
 
254 254
 }
Please login to merge, or discard this patch.
Braces   +8 added lines, -5 removed lines patch added patch discarded remove patch
@@ -1,6 +1,7 @@  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 6
 /**
6 7
  * Event Espresso
@@ -202,8 +203,9 @@  discard block
 block discarded – undo
202 203
 	 * @return string slug for the tour
203 204
 	 */
204 205
 	public function get_slug() {
205
-		if ( empty( $this->_slug ) )
206
-			throw new EE_Error( sprintf(__('There is no slug set for the help tour class (%s). Make sure that the $_slug property is set in the class constructor', 'event_espresso'), get_class($this) ) );
206
+		if ( empty( $this->_slug ) ) {
207
+					throw new EE_Error( sprintf(__('There is no slug set for the help tour class (%s). Make sure that the $_slug property is set in the class constructor', 'event_espresso'), get_class($this) ) );
208
+		}
207 209
 		return $this->_slug;
208 210
 	}
209 211
 
@@ -215,8 +217,9 @@  discard block
 block discarded – undo
215 217
 	 * @return string
216 218
 	 */
217 219
 	public function get_label() {
218
-		if ( empty( $this->_label ) )
219
-			throw new EE_Error( sprintf( __('There is no label set for the help tour class (%s). Make sure that the $_label property is set in the class constructor', 'event_espresso'), get_class($this) ) );
220
+		if ( empty( $this->_label ) ) {
221
+					throw new EE_Error( sprintf( __('There is no label set for the help tour class (%s). Make sure that the $_label property is set in the class constructor', 'event_espresso'), get_class($this) ) );
222
+		}
220 223
 		return $this->_label;
221 224
 	}
222 225
 
Please login to merge, or discard this patch.
core/business/EE_Transaction_Processor.class.php 3 patches
Doc Comments   +1 added lines patch added patch discarded remove patch
@@ -503,6 +503,7 @@
 block discarded – undo
503 503
 	 * @param EE_Transaction $transaction
504 504
 	 * @param \EE_Payment | NULL    $payment
505 505
 	 * @param array          $registration_query_params - array of query WHERE params to use when retrieving cached registrations from a transaction
506
+	 * @param EE_Payment $payment
506 507
 	 * @throws \EE_Error
507 508
 	 * @return array
508 509
 	 */
Please login to merge, or discard this patch.
Indentation   +2 added lines, -3 removed lines patch added patch discarded remove patch
@@ -7,8 +7,7 @@  discard block
 block discarded – undo
7 7
  * the interaction of EE_Transaction and EE_Registration model objects
8 8
  * Provides methods for manipulating and processing changes to an EE_Transaction
9 9
  * and it's related EE_Registrations with regards to the checkout/registration process
10
-
11
-*
10
+ *
12 11
 *@package     Event Espresso
13 12
  * @subpackage 	core
14 13
  * @author      Brent Christensen
@@ -704,7 +703,7 @@  discard block
 block discarded – undo
704 703
 						foreach ( $available_payment_methods as $available_payment_method ) {
705 704
 							if (
706 705
 								$available_payment_method instanceof EE_Payment_Method
707
-							    && $available_payment_method->open_by_default()
706
+								&& $available_payment_method->open_by_default()
708 707
 							) {
709 708
 								$PMD_ID = $available_payment_method->ID();
710 709
 								break;
Please login to merge, or discard this patch.
Spacing   +120 added lines, -120 removed lines patch added patch discarded remove patch
@@ -1,5 +1,5 @@  discard block
 block discarded – undo
1 1
 <?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { exit('No direct script access allowed'); }
2
-EE_Registry::instance()->load_class( 'Processor_Base' );
2
+EE_Registry::instance()->load_class('Processor_Base');
3 3
 
4 4
 /**
5 5
  * Class EE_Transaction_Processor
@@ -52,10 +52,10 @@  discard block
 block discarded – undo
52 52
 	 * @param array $registration_query_params
53 53
 	 *@return EE_Transaction_Processor instance
54 54
 	 */
55
-	public static function instance( $registration_query_params = array() ) {
55
+	public static function instance($registration_query_params = array()) {
56 56
 		// check if class object is instantiated
57
-		if ( ! self::$_instance instanceof EE_Transaction_Processor ) {
58
-			self::$_instance = new self( $registration_query_params );
57
+		if ( ! self::$_instance instanceof EE_Transaction_Processor) {
58
+			self::$_instance = new self($registration_query_params);
59 59
 		}
60 60
 		return self::$_instance;
61 61
 	}
@@ -66,9 +66,9 @@  discard block
 block discarded – undo
66 66
 	 * @param array $registration_query_params
67 67
 	 * @return EE_Transaction_Processor
68 68
 	 */
69
-	private function __construct( $registration_query_params = array() ) {
69
+	private function __construct($registration_query_params = array()) {
70 70
 		// make sure some query params are set for retrieving registrations
71
-		$this->_set_registration_query_params( $registration_query_params );
71
+		$this->_set_registration_query_params($registration_query_params);
72 72
 	}
73 73
 
74 74
 
@@ -77,8 +77,8 @@  discard block
 block discarded – undo
77 77
 	 * @access private
78 78
 	 * @param array $registration_query_params
79 79
 	 */
80
-	private function _set_registration_query_params( $registration_query_params ) {
81
-		$this->_registration_query_params = ! empty( $registration_query_params ) ? $registration_query_params : array( 'order_by' => array( 'REG_count' => 'ASC' ));
80
+	private function _set_registration_query_params($registration_query_params) {
81
+		$this->_registration_query_params = ! empty($registration_query_params) ? $registration_query_params : array('order_by' => array('REG_count' => 'ASC'));
82 82
 	}
83 83
 
84 84
 
@@ -95,9 +95,9 @@  discard block
 block discarded – undo
95 95
 	/**
96 96
 	 * @param string $old_txn_status
97 97
 	 */
98
-	public function set_old_txn_status( $old_txn_status ) {
98
+	public function set_old_txn_status($old_txn_status) {
99 99
 		// only set the first time
100
-		if ( $this->_old_txn_status === null ) {
100
+		if ($this->_old_txn_status === null) {
101 101
 			$this->_old_txn_status = $old_txn_status;
102 102
 		}
103 103
 	}
@@ -116,7 +116,7 @@  discard block
 block discarded – undo
116 116
 	/**
117 117
 	 * @param string $new_txn_status
118 118
 	 */
119
-	public function set_new_txn_status( $new_txn_status ) {
119
+	public function set_new_txn_status($new_txn_status) {
120 120
 		$this->_new_txn_status = $new_txn_status;
121 121
 	}
122 122
 
@@ -147,17 +147,17 @@  discard block
 block discarded – undo
147 147
 	 * @param bool   $check_all
148 148
 	 * @return boolean | int
149 149
 	 */
150
-	private function _reg_steps_completed( EE_Transaction $transaction, $reg_step_slug = '', $check_all = TRUE ) {
150
+	private function _reg_steps_completed(EE_Transaction $transaction, $reg_step_slug = '', $check_all = TRUE) {
151 151
 		$reg_steps = $transaction->reg_steps();
152
-		if ( ! is_array( $reg_steps ) || empty( $reg_steps )) {
152
+		if ( ! is_array($reg_steps) || empty($reg_steps)) {
153 153
 			return false;
154 154
 		}
155 155
 		// loop thru reg steps array)
156
-		foreach ( $reg_steps as $slug => $reg_step_completed ) {
156
+		foreach ($reg_steps as $slug => $reg_step_completed) {
157 157
 			// if NOT checking ALL steps (only checking one step)
158
-			if ( ! $check_all ) {
158
+			if ( ! $check_all) {
159 159
 				// and this is the one
160
-				if ( $slug === $reg_step_slug ) {
160
+				if ($slug === $reg_step_slug) {
161 161
 					return $reg_step_completed;
162 162
 				} else {
163 163
 					// skip to next reg step in loop
@@ -165,7 +165,7 @@  discard block
 block discarded – undo
165 165
 				}
166 166
 			}
167 167
 			// $check_all must be true, else we would never have gotten to this point
168
-			if ( $slug === $reg_step_slug ) {
168
+			if ($slug === $reg_step_slug) {
169 169
 				// if we reach this point, then we are testing either:
170 170
 				// all_reg_steps_completed_except() or
171 171
 				// all_reg_steps_completed_except_final_step(),
@@ -174,7 +174,7 @@  discard block
 block discarded – undo
174 174
 				// ie: "is everything completed except the final step?"
175 175
 				// "that is correct... the final step is not completed, but all others are."
176 176
 				return $reg_step_completed !== true ? true : false;
177
-			} else if ( $reg_step_completed !== true ) {
177
+			} else if ($reg_step_completed !== true) {
178 178
 				// if any reg step is NOT completed, then ALL steps are not completed
179 179
 				return false;
180 180
 			}
@@ -195,8 +195,8 @@  discard block
 block discarded – undo
195 195
 	 * @param EE_Transaction $transaction
196 196
 	 * @return boolean
197 197
 	 */
198
-	public function all_reg_steps_completed( EE_Transaction $transaction ) {
199
-		return $this->_reg_steps_completed( $transaction );
198
+	public function all_reg_steps_completed(EE_Transaction $transaction) {
199
+		return $this->_reg_steps_completed($transaction);
200 200
 	}
201 201
 
202 202
 
@@ -213,8 +213,8 @@  discard block
 block discarded – undo
213 213
 	 * @param string $exception
214 214
 	 * @return boolean
215 215
 	 */
216
-	public function all_reg_steps_completed_except( EE_Transaction $transaction, $exception = '' ) {
217
-		return $this->_reg_steps_completed( $transaction, $exception );
216
+	public function all_reg_steps_completed_except(EE_Transaction $transaction, $exception = '') {
217
+		return $this->_reg_steps_completed($transaction, $exception);
218 218
 	}
219 219
 
220 220
 
@@ -230,8 +230,8 @@  discard block
 block discarded – undo
230 230
 	 * @param EE_Transaction $transaction
231 231
 	 * @return boolean
232 232
 	 */
233
-	public function all_reg_steps_completed_except_final_step( EE_Transaction $transaction ) {
234
-		return $this->_reg_steps_completed( $transaction, 'finalize_registration' );
233
+	public function all_reg_steps_completed_except_final_step(EE_Transaction $transaction) {
234
+		return $this->_reg_steps_completed($transaction, 'finalize_registration');
235 235
 	}
236 236
 
237 237
 
@@ -248,8 +248,8 @@  discard block
 block discarded – undo
248 248
 	 * @param string $reg_step_slug
249 249
 	 * @return boolean | int
250 250
 	 */
251
-	public function reg_step_completed( EE_Transaction $transaction, $reg_step_slug ) {
252
-		return $this->_reg_steps_completed( $transaction, $reg_step_slug, FALSE );
251
+	public function reg_step_completed(EE_Transaction $transaction, $reg_step_slug) {
252
+		return $this->_reg_steps_completed($transaction, $reg_step_slug, FALSE);
253 253
 	}
254 254
 
255 255
 
@@ -265,8 +265,8 @@  discard block
 block discarded – undo
265 265
 	 * @param EE_Transaction $transaction
266 266
 	 * @return boolean | int
267 267
 	 */
268
-	public function final_reg_step_completed( EE_Transaction $transaction ) {
269
-		return $this->_reg_steps_completed( $transaction, 'finalize_registration', FALSE );
268
+	public function final_reg_step_completed(EE_Transaction $transaction) {
269
+		return $this->_reg_steps_completed($transaction, 'finalize_registration', FALSE);
270 270
 	}
271 271
 
272 272
 
@@ -281,8 +281,8 @@  discard block
 block discarded – undo
281 281
 	 * @return boolean
282 282
 	 * @throws \EE_Error
283 283
 	 */
284
-	public function set_reg_step_initiated( EE_Transaction $transaction, $reg_step_slug ) {
285
-		return $this->_set_reg_step_completed_status( $transaction, $reg_step_slug, time() );
284
+	public function set_reg_step_initiated(EE_Transaction $transaction, $reg_step_slug) {
285
+		return $this->_set_reg_step_completed_status($transaction, $reg_step_slug, time());
286 286
 	}
287 287
 
288 288
 
@@ -297,8 +297,8 @@  discard block
 block discarded – undo
297 297
 	 * @return boolean
298 298
 	 * @throws \EE_Error
299 299
 	 */
300
-	public function set_reg_step_completed( EE_Transaction $transaction, $reg_step_slug ) {
301
-		return $this->_set_reg_step_completed_status( $transaction, $reg_step_slug, true );
300
+	public function set_reg_step_completed(EE_Transaction $transaction, $reg_step_slug) {
301
+		return $this->_set_reg_step_completed_status($transaction, $reg_step_slug, true);
302 302
 	}
303 303
 
304 304
 
@@ -313,8 +313,8 @@  discard block
 block discarded – undo
313 313
 	 * @return boolean
314 314
 	 * @throws \EE_Error
315 315
 	 */
316
-	public function set_reg_step_not_completed( EE_Transaction $transaction, $reg_step_slug ) {
317
-		return $this->_set_reg_step_completed_status( $transaction, $reg_step_slug, false );
316
+	public function set_reg_step_not_completed(EE_Transaction $transaction, $reg_step_slug) {
317
+		return $this->_set_reg_step_completed_status($transaction, $reg_step_slug, false);
318 318
 	}
319 319
 
320 320
 
@@ -330,37 +330,37 @@  discard block
 block discarded – undo
330 330
 	 * @return boolean
331 331
 	 * @throws \EE_Error
332 332
 	 */
333
-	private function _set_reg_step_completed_status( EE_Transaction $transaction, $reg_step_slug, $status ) {
333
+	private function _set_reg_step_completed_status(EE_Transaction $transaction, $reg_step_slug, $status) {
334 334
 		// validate status
335
-		$status = is_bool( $status ) || is_int( $status ) ? $status : false;
335
+		$status = is_bool($status) || is_int($status) ? $status : false;
336 336
 		// get reg steps array
337 337
 		$txn_reg_steps = $transaction->reg_steps();
338 338
 		// if reg step does NOT exist
339
-		if ( ! isset( $txn_reg_steps[ $reg_step_slug ] )) {
339
+		if ( ! isset($txn_reg_steps[$reg_step_slug])) {
340 340
 			return false;
341 341
 		}
342 342
 		// if  we're trying to complete a step that is already completed
343
-		if ( $txn_reg_steps[ $reg_step_slug ] === true ) {
343
+		if ($txn_reg_steps[$reg_step_slug] === true) {
344 344
 			return true;
345 345
 		}
346 346
 		// if  we're trying to complete a step that hasn't even started
347
-		if ( $status === true && $txn_reg_steps[ $reg_step_slug ] === false ) {
347
+		if ($status === true && $txn_reg_steps[$reg_step_slug] === false) {
348 348
 			return false;
349 349
 		}
350 350
 		// if current status value matches the incoming value (no change)
351 351
 		// type casting as int means values should collapse to either 0, 1, or a timestamp like 1234567890
352
-		if ( (int)$txn_reg_steps[ $reg_step_slug ] === (int)$status ) {
352
+		if ((int) $txn_reg_steps[$reg_step_slug] === (int) $status) {
353 353
 			// this will happen in cases where multiple AJAX requests occur during the same step
354 354
 			return true;
355 355
 		}
356 356
 		// if we're trying to set a start time, but it has already been set...
357
-		if ( is_numeric( $status ) && is_numeric( $txn_reg_steps[ $reg_step_slug ] )) {
357
+		if (is_numeric($status) && is_numeric($txn_reg_steps[$reg_step_slug])) {
358 358
 			// skip the update below, but don't return FALSE so that errors won't be displayed
359 359
 			return true;
360 360
 		}
361 361
 		// update completed status
362
-		$txn_reg_steps[ $reg_step_slug ] = $status;
363
-		$transaction->set_reg_steps( $txn_reg_steps );
362
+		$txn_reg_steps[$reg_step_slug] = $status;
363
+		$transaction->set_reg_steps($txn_reg_steps);
364 364
 		$transaction->save();
365 365
 		// DEBUG LOG
366 366
 		//$this->log(
@@ -386,11 +386,11 @@  discard block
 block discarded – undo
386 386
 	 * @param string $reg_step_slug
387 387
 	 * @return void
388 388
 	 */
389
-	public function remove_reg_step( EE_Transaction $transaction, $reg_step_slug ) {
389
+	public function remove_reg_step(EE_Transaction $transaction, $reg_step_slug) {
390 390
 		// get reg steps array
391 391
 		$txn_reg_steps = $transaction->reg_steps();
392
-		unset( $txn_reg_steps[ $reg_step_slug ] );
393
-		$transaction->set_reg_steps( $txn_reg_steps );
392
+		unset($txn_reg_steps[$reg_step_slug]);
393
+		$transaction->set_reg_steps($txn_reg_steps);
394 394
 	}
395 395
 
396 396
 
@@ -405,15 +405,15 @@  discard block
 block discarded – undo
405 405
 	 * @return    boolean
406 406
 	 * @throws \EE_Error
407 407
 	 */
408
-	public function toggle_failed_transaction_status( EE_Transaction $transaction ) {
408
+	public function toggle_failed_transaction_status(EE_Transaction $transaction) {
409 409
 		$existing_txn_status = $transaction->status_ID();
410 410
 		// set incoming TXN_Status
411
-		$this->set_old_txn_status( $existing_txn_status );
411
+		$this->set_old_txn_status($existing_txn_status);
412 412
 		// if TXN status is still set as "failed"...
413
-		if ( $existing_txn_status === EEM_Transaction::failed_status_code ) {
413
+		if ($existing_txn_status === EEM_Transaction::failed_status_code) {
414 414
 			// set incoming TXN_Status
415
-			$this->set_new_txn_status( EEM_Transaction::abandoned_status_code );
416
-			$transaction->set_status( EEM_Transaction::abandoned_status_code );
415
+			$this->set_new_txn_status(EEM_Transaction::abandoned_status_code);
416
+			$transaction->set_status(EEM_Transaction::abandoned_status_code);
417 417
 			$transaction->save();
418 418
 			return TRUE;
419 419
 		}
@@ -430,27 +430,27 @@  discard block
 block discarded – undo
430 430
 	 * @param  EE_Transaction $transaction
431 431
 	 * @return boolean
432 432
 	 */
433
-	public function toggle_abandoned_transaction_status( EE_Transaction $transaction ) {
433
+	public function toggle_abandoned_transaction_status(EE_Transaction $transaction) {
434 434
 		// set incoming TXN_Status
435
-		$this->set_old_txn_status( $transaction->status_ID() );
435
+		$this->set_old_txn_status($transaction->status_ID());
436 436
 		// if TXN status has not been updated already due to a payment, and is still set as "failed" or "abandoned"...
437 437
 		$txn_status = $transaction->status_ID();
438 438
 		if (
439 439
 			$txn_status === EEM_Transaction::failed_status_code
440 440
 			|| $txn_status === EEM_Transaction::abandoned_status_code
441 441
 		) {
442
-			$this->set_new_txn_status( EEM_Transaction::incomplete_status_code );
442
+			$this->set_new_txn_status(EEM_Transaction::incomplete_status_code);
443 443
 			// if a contact record for the primary registrant has been created
444 444
 			if (
445 445
 				$transaction->primary_registration() instanceof EE_Registration
446 446
 				&& $transaction->primary_registration()->attendee() instanceof EE_Attendee
447 447
 			) {
448
-				$transaction->set_status( EEM_Transaction::incomplete_status_code );
449
-				$this->set_new_txn_status( EEM_Transaction::incomplete_status_code );
448
+				$transaction->set_status(EEM_Transaction::incomplete_status_code);
449
+				$this->set_new_txn_status(EEM_Transaction::incomplete_status_code);
450 450
 			} else {
451 451
 				// no contact record? yer abandoned!
452
-				$transaction->set_status( EEM_Transaction::abandoned_status_code );
453
-				$this->set_new_txn_status( EEM_Transaction::abandoned_status_code );
452
+				$transaction->set_status(EEM_Transaction::abandoned_status_code);
453
+				$this->set_new_txn_status(EEM_Transaction::abandoned_status_code);
454 454
 			}
455 455
 			return TRUE;
456 456
 		}
@@ -483,10 +483,10 @@  discard block
 block discarded – undo
483 483
 		);
484 484
 		// send messages
485 485
 		/** @type EE_Registration_Processor $registration_processor */
486
-		$registration_processor = EE_Registry::instance()->load_class( 'Registration_Processor' );
486
+		$registration_processor = EE_Registry::instance()->load_class('Registration_Processor');
487 487
 		$registration_processor->trigger_registration_update_notifications(
488 488
 			$transaction->primary_registration(),
489
-			array( 'manually_updated' 	=> true )
489
+			array('manually_updated' 	=> true)
490 490
 		);
491 491
 		do_action(
492 492
 			'AHEE__EE_Transaction_Processor__manually_update_registration_statuses',
@@ -573,15 +573,15 @@  discard block
 block discarded – undo
573 573
 		$registration_query_params = array()
574 574
 	) {
575 575
 		// set incoming TXN_Status, and consider it new since old status should have been set
576
-		$this->set_new_txn_status( $transaction->status_ID() );
576
+		$this->set_new_txn_status($transaction->status_ID());
577 577
 		// make sure some query params are set for retrieving registrations
578
-		$this->_set_registration_query_params( $registration_query_params );
578
+		$this->_set_registration_query_params($registration_query_params);
579 579
 		// get final reg step status
580
-		$finalized = $this->final_reg_step_completed( $transaction );
580
+		$finalized = $this->final_reg_step_completed($transaction);
581 581
 		// if the 'finalize_registration' step has been initiated (has a timestamp)
582 582
 		// but has not yet been fully completed (TRUE)
583
-		if ( is_int( $finalized ) && $finalized !== false && $finalized !== true ) {
584
-			$this->set_reg_step_completed( $transaction, 'finalize_registration' );
583
+		if (is_int($finalized) && $finalized !== false && $finalized !== true) {
584
+			$this->set_reg_step_completed($transaction, 'finalize_registration');
585 585
 			$finalized = true;
586 586
 		}
587 587
 		$transaction->save();
@@ -604,7 +604,7 @@  discard block
 block discarded – undo
604 604
 
605 605
 		// send messages
606 606
 		/** @type EE_Registration_Processor $registration_processor */
607
-		$registration_processor = EE_Registry::instance()->load_class( 'Registration_Processor' );
607
+		$registration_processor = EE_Registry::instance()->load_class('Registration_Processor');
608 608
 		$registration_processor->trigger_registration_update_notifications(
609 609
 			$transaction->primary_registration(),
610 610
 			$update_params
@@ -635,22 +635,22 @@  discard block
 block discarded – undo
635 635
 		$update_txn = true
636 636
 	) {
637 637
 		// these reg statuses should not be considered in any calculations involving monies owing
638
-		$closed_reg_statuses = ! empty( $closed_reg_statuses ) ? $closed_reg_statuses : EEM_Registration::closed_reg_statuses();
639
-		if ( in_array( $registration->status_ID(), $closed_reg_statuses ) ) {
638
+		$closed_reg_statuses = ! empty($closed_reg_statuses) ? $closed_reg_statuses : EEM_Registration::closed_reg_statuses();
639
+		if (in_array($registration->status_ID(), $closed_reg_statuses)) {
640 640
 			return false;
641 641
 		}
642 642
 		try {
643
-			$transaction = $this->get_transaction_for_registration( $registration );
643
+			$transaction = $this->get_transaction_for_registration($registration);
644 644
 			$ticket_line_item = $this->get_ticket_line_item_for_transaction_registration(
645 645
 				$transaction,
646 646
 				$registration
647 647
 			);
648 648
 			// un-cancel the ticket
649
-			$success = EEH_Line_Item::reinstate_canceled_ticket_line_item( $ticket_line_item );
650
-		} catch ( EE_Error $e ) {
649
+			$success = EEH_Line_Item::reinstate_canceled_ticket_line_item($ticket_line_item);
650
+		} catch (EE_Error $e) {
651 651
 			EE_Error::add_error(
652 652
 				sprintf(
653
-					__( 'The Ticket Line Item for Registration %1$d could not be reinstated because :%2$s%3$s', 'event_espresso' ),
653
+					__('The Ticket Line Item for Registration %1$d could not be reinstated because :%2$s%3$s', 'event_espresso'),
654 654
 					$registration->ID(),
655 655
 					'<br />',
656 656
 					$e->getMessage()
@@ -659,7 +659,7 @@  discard block
 block discarded – undo
659 659
 			);
660 660
 			return false;
661 661
 		}
662
-		if ( $update_txn ) {
662
+		if ($update_txn) {
663 663
 			return $transaction->save() ? $success : false;
664 664
 		}
665 665
 		return $success;
@@ -683,18 +683,18 @@  discard block
 block discarded – undo
683 683
 		$update_txn = true
684 684
 	) {
685 685
 		// these reg statuses should not be considered in any calculations involving monies owing
686
-		$closed_reg_statuses = ! empty( $closed_reg_statuses ) ? $closed_reg_statuses : EEM_Registration::closed_reg_statuses();
687
-		if ( ! in_array( $registration->status_ID(), $closed_reg_statuses ) ) {
686
+		$closed_reg_statuses = ! empty($closed_reg_statuses) ? $closed_reg_statuses : EEM_Registration::closed_reg_statuses();
687
+		if ( ! in_array($registration->status_ID(), $closed_reg_statuses)) {
688 688
 			return false;
689 689
 		}
690 690
 		try {
691
-			$transaction = $this->get_transaction_for_registration( $registration );
692
-			$ticket_line_item = $this->get_ticket_line_item_for_transaction_registration( $transaction, $registration );
693
-			EEH_Line_Item::cancel_ticket_line_item( $ticket_line_item );
694
-		} catch ( EE_Error $e ) {
691
+			$transaction = $this->get_transaction_for_registration($registration);
692
+			$ticket_line_item = $this->get_ticket_line_item_for_transaction_registration($transaction, $registration);
693
+			EEH_Line_Item::cancel_ticket_line_item($ticket_line_item);
694
+		} catch (EE_Error $e) {
695 695
 			EE_Error::add_error(
696 696
 				sprintf(
697
-					__( 'The Ticket Line Item for Registration %1$d could not be cancelled because :%2$s%3$s', 'event_espresso' ),
697
+					__('The Ticket Line Item for Registration %1$d could not be cancelled because :%2$s%3$s', 'event_espresso'),
698 698
 					$registration->ID(),
699 699
 					'<br />',
700 700
 					$e->getMessage()
@@ -703,7 +703,7 @@  discard block
 block discarded – undo
703 703
 			);
704 704
 			return false;
705 705
 		}
706
-		if ( $update_txn ) {
706
+		if ($update_txn) {
707 707
 			return $transaction->save() ? true : false;
708 708
 		}
709 709
 		return true;
@@ -719,12 +719,12 @@  discard block
 block discarded – undo
719 719
 	 * @return 	EE_Transaction
720 720
 	 * @throws 	EE_Error
721 721
 	 */
722
-	public function get_transaction_for_registration( EE_Registration $registration ) {
722
+	public function get_transaction_for_registration(EE_Registration $registration) {
723 723
 		$transaction = $registration->transaction();
724
-		if ( ! $transaction instanceof EE_Transaction ) {
724
+		if ( ! $transaction instanceof EE_Transaction) {
725 725
 			throw new EE_Error(
726 726
 				sprintf(
727
-					__( 'The Transaction for Registration %1$d was not found or is invalid.', 'event_espresso' ),
727
+					__('The Transaction for Registration %1$d was not found or is invalid.', 'event_espresso'),
728 728
 					$registration->ID()
729 729
 				)
730 730
 			);
@@ -747,16 +747,16 @@  discard block
 block discarded – undo
747 747
 		EE_Transaction $transaction,
748 748
 		EE_Registration $registration
749 749
 	) {
750
-		EE_Registry::instance()->load_helper( 'Line_Item' );
750
+		EE_Registry::instance()->load_helper('Line_Item');
751 751
 		$ticket_line_item = EEM_Line_Item::instance()->get_ticket_line_item_for_transaction(
752 752
 			$transaction->ID(),
753 753
 			$registration->ticket_ID()
754 754
 		);
755
-		if ( ! $ticket_line_item instanceof EE_Line_Item ) {
755
+		if ( ! $ticket_line_item instanceof EE_Line_Item) {
756 756
 			throw new EE_Error(
757 757
 				sprintf(
758
-					__( 'The Line Item for Transaction %1$d and Ticket %2$d was not found or is invalid.',
759
-						'event_espresso' ),
758
+					__('The Line Item for Transaction %1$d and Ticket %2$d was not found or is invalid.',
759
+						'event_espresso'),
760 760
 					$transaction->ID(),
761 761
 					$registration->ticket_ID()
762 762
 				)
@@ -789,26 +789,26 @@  discard block
 block discarded – undo
789 789
 		$update_txn = true
790 790
 	) {
791 791
 		// make sure some query params are set for retrieving registrations
792
-		$this->_set_registration_query_params( $registration_query_params );
792
+		$this->_set_registration_query_params($registration_query_params);
793 793
 		// these reg statuses should not be considered in any calculations involving monies owing
794
-		$closed_reg_statuses = ! empty( $closed_reg_statuses ) ? $closed_reg_statuses : EEM_Registration::closed_reg_statuses();
794
+		$closed_reg_statuses = ! empty($closed_reg_statuses) ? $closed_reg_statuses : EEM_Registration::closed_reg_statuses();
795 795
 		// loop through cached registrations
796
-		foreach ( $transaction->registrations( $this->_registration_query_params ) as $registration ) {
796
+		foreach ($transaction->registrations($this->_registration_query_params) as $registration) {
797 797
 			if (
798 798
 				$registration instanceof EE_Registration
799
-				&& ! in_array( $registration->status_ID(), $closed_reg_statuses )
799
+				&& ! in_array($registration->status_ID(), $closed_reg_statuses)
800 800
 			) {
801 801
 				return false;
802 802
 			}
803 803
 		}
804
-		if ( in_array( $new_TXN_status, EEM_Transaction::txn_status_array() ) ) {
804
+		if (in_array($new_TXN_status, EEM_Transaction::txn_status_array())) {
805 805
 			// set incoming TXN_Status
806
-			$this->set_old_txn_status( $transaction->status_ID() );
807
-			$transaction->set_status( $new_TXN_status );
806
+			$this->set_old_txn_status($transaction->status_ID());
807
+			$transaction->set_status($new_TXN_status);
808 808
 			// set new TXN_Status
809
-			$this->set_new_txn_status( $new_TXN_status );
809
+			$this->set_new_txn_status($new_TXN_status);
810 810
 		}
811
-		if ( $update_txn ) {
811
+		if ($update_txn) {
812 812
 			return $transaction->save() ? true : false;
813 813
 		}
814 814
 		return true;
@@ -837,22 +837,22 @@  discard block
 block discarded – undo
837 837
 	) {
838 838
 		$response = false;
839 839
 		/** @type EE_Registration_Processor $registration_processor */
840
-		$registration_processor = EE_Registry::instance()->load_class( 'Registration_Processor' );
840
+		$registration_processor = EE_Registry::instance()->load_class('Registration_Processor');
841 841
 		// check that method exists
842
-		if ( ! method_exists( $registration_processor, $method_name )) {
843
-			throw new EE_Error( __( 'Method does not exist.', 'event_espresso' ));
842
+		if ( ! method_exists($registration_processor, $method_name)) {
843
+			throw new EE_Error(__('Method does not exist.', 'event_espresso'));
844 844
 		}
845 845
 		// make sure some query params are set for retrieving registrations
846
-		$this->_set_registration_query_params( $registration_query_params );
846
+		$this->_set_registration_query_params($registration_query_params);
847 847
 		// loop through cached registrations
848
-		foreach ( $transaction->registrations( $this->_registration_query_params ) as $registration ) {
849
-			if ( $registration instanceof EE_Registration ) {
850
-				if ( $additional_param ) {
851
-					$response = $registration_processor->{$method_name}( $registration, $additional_param )
848
+		foreach ($transaction->registrations($this->_registration_query_params) as $registration) {
849
+			if ($registration instanceof EE_Registration) {
850
+				if ($additional_param) {
851
+					$response = $registration_processor->{$method_name}($registration, $additional_param)
852 852
 						? true
853 853
 						: $response;
854 854
 				} else {
855
-					$response = $registration_processor->{$method_name}( $registration )
855
+					$response = $registration_processor->{$method_name}($registration)
856 856
 						? true
857 857
 						: $response;
858 858
 				}
@@ -879,28 +879,28 @@  discard block
 block discarded – undo
879 879
 	public function set_transaction_payment_method_based_on_registration_statuses(
880 880
 		EE_Registration $edited_registration
881 881
 	) {
882
-		if ( $edited_registration instanceof EE_Registration ) {
882
+		if ($edited_registration instanceof EE_Registration) {
883 883
 			$transaction = $edited_registration->transaction();
884
-			if ( $transaction instanceof EE_Transaction ) {
884
+			if ($transaction instanceof EE_Transaction) {
885 885
 				$all_not_approved = true;
886
-				foreach ( $transaction->registrations() as $registration ) {
887
-					if ( $registration instanceof EE_Registration ) {
886
+				foreach ($transaction->registrations() as $registration) {
887
+					if ($registration instanceof EE_Registration) {
888 888
 						// if any REG != "Not Approved" then toggle to false
889 889
 						$all_not_approved = $registration->is_not_approved() ? $all_not_approved : false;
890 890
 					}
891 891
 				}
892 892
 				// if ALL Registrations are "Not Approved"
893
-				if ( $all_not_approved ) {
894
-					$transaction->set_payment_method_ID( null );
893
+				if ($all_not_approved) {
894
+					$transaction->set_payment_method_ID(null);
895 895
 					$transaction->save();
896 896
 				} else {
897 897
 					$available_payment_methods = EEM_Payment_Method::instance()->get_all_for_transaction(
898 898
 						$transaction,
899 899
 						EEM_Payment_Method::scope_cart
900 900
 					);
901
-					if ( ! empty( $available_payment_methods ) ) {
901
+					if ( ! empty($available_payment_methods)) {
902 902
 						$PMD_ID = 0;
903
-						foreach ( $available_payment_methods as $available_payment_method ) {
903
+						foreach ($available_payment_methods as $available_payment_method) {
904 904
 							if (
905 905
 								$available_payment_method instanceof EE_Payment_Method
906 906
 							    && $available_payment_method->open_by_default()
@@ -909,22 +909,22 @@  discard block
 block discarded – undo
909 909
 								break;
910 910
 							}
911 911
 						}
912
-						if ( ! $PMD_ID ) {
913
-							$first_payment_method = reset( $available_payment_methods );
914
-							if ( $first_payment_method instanceof EE_Payment_Method ) {
912
+						if ( ! $PMD_ID) {
913
+							$first_payment_method = reset($available_payment_methods);
914
+							if ($first_payment_method instanceof EE_Payment_Method) {
915 915
 								$PMD_ID = $first_payment_method->ID();
916 916
 							} else {
917 917
 								EE_Error::add_error(
918
-									__( 'A valid Payment Method could not be determined. Please ensure that at least one Payment Method is activated.', 'event_espresso' ),
918
+									__('A valid Payment Method could not be determined. Please ensure that at least one Payment Method is activated.', 'event_espresso'),
919 919
 									__FILE__, __LINE__, __FUNCTION__
920 920
 								);
921 921
 							}
922 922
 						}
923
-						$transaction->set_payment_method_ID( $PMD_ID );
923
+						$transaction->set_payment_method_ID($PMD_ID);
924 924
 						$transaction->save();
925 925
 					} else {
926 926
 						EE_Error::add_error(
927
-							__( 'Please activate at least one Payment Method in order for things to operate correctly.', 'event_espresso' ),
927
+							__('Please activate at least one Payment Method in order for things to operate correctly.', 'event_espresso'),
928 928
 							__FILE__, __LINE__, __FUNCTION__
929 929
 						);
930 930
 					}
Please login to merge, or discard this patch.
core/data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_answers.dmsstage.php 3 patches
Doc Comments   -1 removed lines patch added patch discarded remove patch
@@ -59,7 +59,6 @@
 block discarded – undo
59 59
 	/**
60 60
 	 * Creates a 4.1 price base type
61 61
 	 * @global type $wpdb
62
-	 * @param array $old_price
63 62
 	 * @param int $new_reg_id
64 63
 	 * @return int
65 64
 	 */
Please login to merge, or discard this patch.
Spacing   +16 added lines, -16 removed lines patch added patch discarded remove patch
@@ -30,7 +30,7 @@  discard block
 block discarded – undo
30 30
 			));
31 31
 */
32 32
 
33
-class EE_DMS_4_1_0_answers extends EE_Data_Migration_Script_Stage_Table{
33
+class EE_DMS_4_1_0_answers extends EE_Data_Migration_Script_Stage_Table {
34 34
 	private $_new_answer_table;
35 35
 	private $_new_question_table;
36 36
 	function __construct() {
@@ -47,13 +47,13 @@  discard block
 block discarded – undo
47 47
 		$old_attendee_table = $wpdb->prefix."events_attendee";
48 48
 		$new_reg_table = $wpdb->prefix."esp_registration";
49 49
 		$regs = $this->get_migration_script()->get_mapping_new_pk($old_attendee_table, $old_row['attendee_id'], $new_reg_table);
50
-		if( ! $regs){
51
-			$this->add_error(sprintf(__("Could not find new registrations for old attendee %d when creating answer %s", "event_espresso"),$old_row['attendee_id'],  $this->_json_encode($old_row)));
50
+		if ( ! $regs) {
51
+			$this->add_error(sprintf(__("Could not find new registrations for old attendee %d when creating answer %s", "event_espresso"), $old_row['attendee_id'], $this->_json_encode($old_row)));
52 52
 			return false;
53 53
 		}
54 54
 		//as inefficient as this sounds, we create an answer per REGISTRATION, (even if the registrations use the same attendee)
55
-		foreach($regs as $new_reg_id){
56
-			$new_answer_id = $this->_insert_new_answer($old_row,$new_reg_id);
55
+		foreach ($regs as $new_reg_id) {
56
+			$new_answer_id = $this->_insert_new_answer($old_row, $new_reg_id);
57 57
 		}
58 58
 	}
59 59
 	/**
@@ -63,15 +63,15 @@  discard block
 block discarded – undo
63 63
 	 * @param int $new_reg_id
64 64
 	 * @return int
65 65
 	 */
66
-	private function _insert_new_answer($old_answer,$new_reg_id){
66
+	private function _insert_new_answer($old_answer, $new_reg_id) {
67 67
 		global $wpdb;
68 68
 		$old_question_table = $wpdb->prefix."events_question";
69 69
 		$new_question_id = $this->get_migration_script()->get_mapping_new_pk($old_question_table, $old_answer['question_id'], $this->_new_question_table);
70 70
 
71 71
 		$question_type = $this->_get_question_type($new_question_id);
72
-		if(in_array($question_type,array('MULTIPLE'))){
73
-			$ans_value = serialize(explode(",",stripslashes($old_answer['answer'])));
74
-		}else{
72
+		if (in_array($question_type, array('MULTIPLE'))) {
73
+			$ans_value = serialize(explode(",", stripslashes($old_answer['answer'])));
74
+		} else {
75 75
 			$ans_value = stripslashes($old_answer['answer']);
76 76
 		}
77 77
 		$cols_n_values = array(
@@ -80,12 +80,12 @@  discard block
 block discarded – undo
80 80
 			'ANS_value'=>$ans_value
81 81
 		);
82 82
 		$datatypes = array(
83
-			'%d',//REG_ID
84
-			'%d',//QST_ID
85
-			'%s',//ANS_value
83
+			'%d', //REG_ID
84
+			'%d', //QST_ID
85
+			'%s', //ANS_value
86 86
 		);
87
-		$success = $wpdb->insert($this->_new_answer_table,$cols_n_values,$datatypes);
88
-		if ( ! $success){
87
+		$success = $wpdb->insert($this->_new_answer_table, $cols_n_values, $datatypes);
88
+		if ( ! $success) {
89 89
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_answer, $this->_new_answer_table, $cols_n_values, $datatypes));
90 90
 			return 0;
91 91
 		}
@@ -99,9 +99,9 @@  discard block
 block discarded – undo
99 99
 	 * @param type $question_id
100 100
 	 * @return string
101 101
 	 */
102
-	private function _get_question_type($question_id){
102
+	private function _get_question_type($question_id) {
103 103
 		global $wpdb;
104
-		$type = $wpdb->get_var($wpdb->prepare("SELECT QST_type FROM ".$this->_new_question_table." WHERE QST_ID=%d LIMIT 1",$question_id));
104
+		$type = $wpdb->get_var($wpdb->prepare("SELECT QST_type FROM ".$this->_new_question_table." WHERE QST_ID=%d LIMIT 1", $question_id));
105 105
 		return $type;
106 106
 	}
107 107
 
Please login to merge, or discard this patch.
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -90,7 +90,7 @@
 block discarded – undo
90 90
 		//so in case teh IPN is arriving later, let's try to process an IPN!
91 91
 		if($_SERVER['REQUEST_METHOD'] == 'POST'){
92 92
 			return $this->handle_ipn($_POST, $transaction );
93
-		}else{
93
+		} else{
94 94
 			return parent::finalize_payment_for( $transaction );
95 95
 		}
96 96
 	}
Please login to merge, or discard this patch.
data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_attendees.dmsstage.php 4 patches
Doc Comments   +6 added lines, -2 removed lines patch added patch discarded remove patch
@@ -565,8 +565,8 @@  discard block
 block discarded – undo
565 565
 	 * that they WILL be added (because the attendees stage runs nearly last during
566 566
 	 * the migration script)
567 567
 	 * @param type $new_ticket_id
568
-	 * @param type $sold
569
-	 * @param type $STS_ID
568
+	 * @param string $STS_ID
569
+	 * @param integer $quantity_sold
570 570
 	 * @return boolean whether they were successfully updated or not
571 571
 	 */
572 572
 	protected function _add_regs_to_ticket_and_datetimes($new_ticket_id,$quantity_sold,$STS_ID){
@@ -744,6 +744,10 @@  discard block
 block discarded – undo
744 744
 		}
745 745
 		return $count;
746 746
 	}
747
+
748
+	/**
749
+	 * @param integer $new_txn_id
750
+	 */
747 751
 	private function _insert_new_payment($old_attendee,$new_txn_id){
748 752
 		global $wpdb;
749 753
 		//only add a payment for primary attendees
Please login to merge, or discard this patch.
Braces   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -339,13 +339,13 @@  discard block
 block discarded – undo
339 339
 		try{
340 340
 			$new_country = $this->get_migration_script()->get_or_create_country(stripslashes($old_attendee['country_id']));
341 341
 			$new_country_iso = $new_country['CNT_ISO'];
342
-		}catch(EE_Error $exception){
342
+		} catch(EE_Error $exception){
343 343
 			$new_country_iso = $this->get_migration_script()->get_default_country_iso();
344 344
 		}
345 345
 		try{
346 346
 			$new_state = $this->get_migration_script()->get_or_create_state(stripslashes($old_attendee['state']),$new_country_iso);
347 347
 			$new_state_id = $new_state['STA_ID'];
348
-		}catch(EE_Error $exception){
348
+		} catch(EE_Error $exception){
349 349
 			$new_state_id = 0;
350 350
 		}
351 351
 		$cols_n_values = array(
@@ -459,7 +459,7 @@  discard block
 block discarded – undo
459 459
 
460 460
 			if( $wpdb->get_var("SHOW TABLES LIKE '{$this->_old_mer_table}'") != $this->_old_mer_table){
461 461
 				$this->_mer_tables_exist = false;
462
-			}else{
462
+			} else{
463 463
 				$this->_mer_tables_exist = true;
464 464
 			}
465 465
 		}
@@ -584,7 +584,7 @@  discard block
 block discarded – undo
584 584
 			if( ! $success_update_dateimtes){
585 585
 				$this->add_error(sprintf(__("Could not update datetimes related to ticket with ID %d's TKT_sold by %d because %s", "event_espresso"),$new_ticket_id,$quantity_sold,$wpdb->last_error));
586 586
 			}
587
-		}else{
587
+		} else{
588 588
 			$this->add_error(sprintf(__("Could not update ticket with ID %d's TKT_sold by %d because %s", "event_espresso"),$new_ticket_id,$quantity_sold,$wpdb->last_error));
589 589
 		}
590 590
 		return true;
@@ -791,7 +791,7 @@  discard block
 block discarded – undo
791 791
 			$new_id = $wpdb->insert_id;
792 792
 			return $new_id;
793 793
 
794
-		}else{
794
+		} else{
795 795
 			return 0;
796 796
 		}
797 797
 
Please login to merge, or discard this patch.
Indentation   -3 removed lines patch added patch discarded remove patch
@@ -25,9 +25,6 @@
 block discarded – undo
25 25
 				
26 26
 			)
27 27
 		);
28
-
29
-
30
-
31 28
  * 
32 29
  */
33 30
 class EE_DMS_4_1_0_event_venue extends EE_Data_Migration_Script_Stage{
Please login to merge, or discard this patch.
Spacing   +182 added lines, -182 removed lines patch added patch discarded remove patch
@@ -214,7 +214,7 @@  discard block
 block discarded – undo
214 214
 			)
215 215
 		);
216 216
  */
217
-class EE_DMS_4_1_0_attendees extends EE_Data_Migration_Script_Stage_Table{
217
+class EE_DMS_4_1_0_attendees extends EE_Data_Migration_Script_Stage_Table {
218 218
 	private $_new_attendee_cpt_table;
219 219
 	private $_new_attendee_meta_table;
220 220
 	private $_new_reg_table;
@@ -237,7 +237,7 @@  discard block
 block discarded – undo
237 237
 		global $wpdb;
238 238
 		$this->_pretty_name = __("Attendees", "event_espresso");
239 239
 		$this->_old_table = $wpdb->prefix."events_attendee";
240
-		$this->_old_mer_table = $wpdb->prefix."events_multi_event_registration_id_group";;
240
+		$this->_old_mer_table = $wpdb->prefix."events_multi_event_registration_id_group"; ;
241 241
 		$this->_new_attendee_cpt_table = $wpdb->posts;
242 242
 		$this->_new_attendee_meta_table = $wpdb->prefix."esp_attendee_meta";
243 243
 		$this->_new_reg_table = $wpdb->prefix."esp_registration";
@@ -256,34 +256,34 @@  discard block
 block discarded – undo
256 256
 	protected function _migrate_old_row($old_row) {
257 257
 		//first check if there's already a new attendee with similar characteristics
258 258
 		$new_att_id = $this->_find_attendee_cpt_matching($old_row);
259
-		if( ! $new_att_id ){
259
+		if ( ! $new_att_id) {
260 260
 			$new_att_id = $this->_insert_new_attendee_cpt($old_row);
261
-			if( ! $new_att_id){
261
+			if ( ! $new_att_id) {
262 262
 				//if we couldnt even make an attendee, abandon all hope
263 263
 				return false;
264 264
 			}
265 265
 			$new_att_meta_id = $this->_insert_attendee_meta_row($old_row, $new_att_id);
266
-			if($new_att_meta_id){
266
+			if ($new_att_meta_id) {
267 267
 				$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_attendee_meta_table, $new_att_meta_id);
268 268
 			}
269 269
 		}
270 270
 		$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_attendee_cpt_table, $new_att_id);
271 271
 
272 272
 		$txn_id = $this->_insert_new_transaction($old_row);
273
-		if( ! $txn_id){
273
+		if ( ! $txn_id) {
274 274
 			//if we couldnt make the transaction, also abandon all hope
275 275
 			return false;
276 276
 		}
277
-		$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_transaction_table, $txn_id);$pay_id = $this->_insert_new_payment($old_row,$txn_id);
278
-		if($pay_id){
279
-			$this->get_migration_script()->set_mapping($this->_old_table,$old_row['id'],$this->_new_payment_table,$pay_id);
277
+		$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_transaction_table, $txn_id); $pay_id = $this->_insert_new_payment($old_row, $txn_id);
278
+		if ($pay_id) {
279
+			$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_payment_table, $pay_id);
280 280
 		}
281 281
 
282 282
 
283 283
 		//even if there was no payment, we can go ahead with adding the reg
284
-		$new_regs = $this->_insert_new_registrations($old_row,$new_att_id,$txn_id);
285
-		if($new_regs){
286
-			$this->get_migration_script()->set_mapping($this->_old_table,$old_row['id'],$this->_new_reg_table,$new_regs);
284
+		$new_regs = $this->_insert_new_registrations($old_row, $new_att_id, $txn_id);
285
+		if ($new_regs) {
286
+			$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_reg_table, $new_regs);
287 287
 		}
288 288
 	}
289 289
 	/**
@@ -293,39 +293,39 @@  discard block
 block discarded – undo
293 293
 	 * @param array $old_attendee
294 294
 	 * @return int
295 295
 	 */
296
-	private function _find_attendee_cpt_matching($old_attendee){
296
+	private function _find_attendee_cpt_matching($old_attendee) {
297 297
 		global $wpdb;
298
-		$existing_attendee_id = $wpdb->get_var($wpdb->prepare("SELECT id FROM ".$this->_new_attendee_cpt_table." AS cpt INNER JOIN ".$this->_new_attendee_meta_table." AS meta ON cpt.ID = meta.ATT_ID WHERE meta.ATT_fname = %s AND meta.ATT_lname = %s AND meta.ATT_email = %s LIMIT 1",$old_attendee['fname'],$old_attendee['lname'],$old_attendee['email']));
298
+		$existing_attendee_id = $wpdb->get_var($wpdb->prepare("SELECT id FROM ".$this->_new_attendee_cpt_table." AS cpt INNER JOIN ".$this->_new_attendee_meta_table." AS meta ON cpt.ID = meta.ATT_ID WHERE meta.ATT_fname = %s AND meta.ATT_lname = %s AND meta.ATT_email = %s LIMIT 1", $old_attendee['fname'], $old_attendee['lname'], $old_attendee['email']));
299 299
 		return intval($existing_attendee_id);
300 300
 	}
301
-	private function _insert_new_attendee_cpt($old_attendee){
301
+	private function _insert_new_attendee_cpt($old_attendee) {
302 302
 		global $wpdb;
303 303
 		$cols_n_values = array(
304
-			'post_title'=>stripslashes($old_attendee['fname']." ".$old_attendee['lname']),//ATT_full_name
305
-			'post_content'=>'',//ATT_bio
306
-			'post_name'=>sanitize_title($old_attendee['fname']."-".$old_attendee['lname']),//ATT_slug
307
-			'post_date'=>$this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,$old_attendee['date']),//ATT_created
308
-			'post_excerpt'=>'',//ATT_short_bio
309
-			'post_modified'=>$this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,$old_attendee['date']),//ATT_modified
310
-			'post_author'=>0,//ATT_author
311
-			'post_parent'=>0,//ATT_parent
312
-			'post_type'=>'espresso_attendees',//post_type
304
+			'post_title'=>stripslashes($old_attendee['fname']." ".$old_attendee['lname']), //ATT_full_name
305
+			'post_content'=>'', //ATT_bio
306
+			'post_name'=>sanitize_title($old_attendee['fname']."-".$old_attendee['lname']), //ATT_slug
307
+			'post_date'=>$this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, $old_attendee['date']), //ATT_created
308
+			'post_excerpt'=>'', //ATT_short_bio
309
+			'post_modified'=>$this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, $old_attendee['date']), //ATT_modified
310
+			'post_author'=>0, //ATT_author
311
+			'post_parent'=>0, //ATT_parent
312
+			'post_type'=>'espresso_attendees', //post_type
313 313
 			'post_status'=>'publish'//status
314 314
 		);
315 315
 		$datatypes = array(
316
-			'%s',//ATT_full_name
317
-			'%s',//ATT_bio
318
-			'%s',//ATT_slug
319
-			'%s',//ATT_created
320
-			'%s',//ATT_short_bio
321
-			'%s',//ATT_modified
322
-			'%d',//ATT_author
323
-			'%d',//ATT_parent
324
-			'%s',//post_type
325
-			'%s',//status
316
+			'%s', //ATT_full_name
317
+			'%s', //ATT_bio
318
+			'%s', //ATT_slug
319
+			'%s', //ATT_created
320
+			'%s', //ATT_short_bio
321
+			'%s', //ATT_modified
322
+			'%d', //ATT_author
323
+			'%d', //ATT_parent
324
+			'%s', //post_type
325
+			'%s', //status
326 326
 		);
327
-		$success = $wpdb->insert($this->_new_attendee_cpt_table,$cols_n_values,$datatypes);
328
-		if ( ! $success){
327
+		$success = $wpdb->insert($this->_new_attendee_cpt_table, $cols_n_values, $datatypes);
328
+		if ( ! $success) {
329 329
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_attendee_cpt_table, $cols_n_values, $datatypes));
330 330
 			return 0;
331 331
 		}
@@ -333,19 +333,19 @@  discard block
 block discarded – undo
333 333
 		return $new_id;
334 334
 	}
335 335
 
336
-	private function _insert_attendee_meta_row($old_attendee,$new_attendee_cpt_id){
336
+	private function _insert_attendee_meta_row($old_attendee, $new_attendee_cpt_id) {
337 337
 		global $wpdb;
338 338
 		//get the state and country ids from the old row
339
-		try{
339
+		try {
340 340
 			$new_country = $this->get_migration_script()->get_or_create_country(stripslashes($old_attendee['country_id']));
341 341
 			$new_country_iso = $new_country['CNT_ISO'];
342
-		}catch(EE_Error $exception){
342
+		} catch (EE_Error $exception) {
343 343
 			$new_country_iso = $this->get_migration_script()->get_default_country_iso();
344 344
 		}
345
-		try{
346
-			$new_state = $this->get_migration_script()->get_or_create_state(stripslashes($old_attendee['state']),$new_country_iso);
345
+		try {
346
+			$new_state = $this->get_migration_script()->get_or_create_state(stripslashes($old_attendee['state']), $new_country_iso);
347 347
 			$new_state_id = $new_state['STA_ID'];
348
-		}catch(EE_Error $exception){
348
+		} catch (EE_Error $exception) {
349 349
 			$new_state_id = 0;
350 350
 		}
351 351
 		$cols_n_values = array(
@@ -362,20 +362,20 @@  discard block
 block discarded – undo
362 362
 			'ATT_phone'=>stripslashes($old_attendee['phone']),
363 363
 		);
364 364
 		$datatypes = array(
365
-			'%d',//ATT_ID
366
-			'%s',//ATT_fname
367
-			'%s',//ATT_lname
368
-			'%s',//ATT_address
369
-			'%s',//ATT_address2
370
-			'%s',//ATT_city
371
-			'%d',//STA_ID
372
-			'%s',//CNT_ISO
373
-			'%s',//ATT_zip
374
-			'%s',//ATT_email
375
-			'%s',//ATT_phone
365
+			'%d', //ATT_ID
366
+			'%s', //ATT_fname
367
+			'%s', //ATT_lname
368
+			'%s', //ATT_address
369
+			'%s', //ATT_address2
370
+			'%s', //ATT_city
371
+			'%d', //STA_ID
372
+			'%s', //CNT_ISO
373
+			'%s', //ATT_zip
374
+			'%s', //ATT_email
375
+			'%s', //ATT_phone
376 376
 		);
377
-		$success = $wpdb->insert($this->_new_attendee_meta_table,$cols_n_values,$datatypes);
378
-		if ( ! $success){
377
+		$success = $wpdb->insert($this->_new_attendee_meta_table, $cols_n_values, $datatypes);
378
+		if ( ! $success) {
379 379
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_attendee_meta_table, $cols_n_values, $datatypes));
380 380
 			return 0;
381 381
 		}
@@ -391,28 +391,28 @@  discard block
 block discarded – undo
391 391
 	 * @param type $old_attendee
392 392
 	 * @return int new transaction id
393 393
 	 */
394
-	private function _insert_new_transaction($old_attendee){
394
+	private function _insert_new_transaction($old_attendee) {
395 395
 		global $wpdb;
396 396
 
397 397
 		//first: let's check for an existing transaction for this old attendee
398
-		if( intval( $old_attendee[ 'is_primary' ] ) ) {//primary attendee, so create txn
399
-			$txn_id = $this->get_migration_script()->get_mapping_new_pk( $this->_old_table, intval($old_attendee['id']), $this->_new_transaction_table );
398
+		if (intval($old_attendee['is_primary'])) {//primary attendee, so create txn
399
+			$txn_id = $this->get_migration_script()->get_mapping_new_pk($this->_old_table, intval($old_attendee['id']), $this->_new_transaction_table);
400 400
 		} else { //non-primary attendee, so find its primary attendee's transaction
401
-			$primary_attendee_old_id = $wpdb->get_var($wpdb->prepare("SELECT id FROM ".$this->_old_table." WHERE is_primary=1 and registration_id=%s",$old_attendee['registration_id']));
402
-			if( ! $primary_attendee_old_id){
401
+			$primary_attendee_old_id = $wpdb->get_var($wpdb->prepare("SELECT id FROM ".$this->_old_table." WHERE is_primary=1 and registration_id=%s", $old_attendee['registration_id']));
402
+			if ( ! $primary_attendee_old_id) {
403 403
 				$primary_attendee = $this->_find_mer_primary_attendee_using_mer_tables($old_attendee['registration_id']);
404 404
 				$primary_attendee_old_id = is_array($primary_attendee) ? $primary_attendee['id'] : NULL;
405 405
 			}
406 406
 			$txn_id = $this->get_migration_script()->get_mapping_new_pk($this->_old_table, intval($primary_attendee_old_id), $this->_new_transaction_table);
407
-			if( ! $txn_id){
408
-				$this->add_error(sprintf(__("Could not find primary attendee's new transaction. Current attendee is: %s, we think the 3.1 primary attendee for it has id %d, but there's no 4.1 transaction for that primary attendee id.", "event_espresso"),  $this->_json_encode($old_attendee),$primary_attendee_old_id));
407
+			if ( ! $txn_id) {
408
+				$this->add_error(sprintf(__("Could not find primary attendee's new transaction. Current attendee is: %s, we think the 3.1 primary attendee for it has id %d, but there's no 4.1 transaction for that primary attendee id.", "event_espresso"), $this->_json_encode($old_attendee), $primary_attendee_old_id));
409 409
 				$txn_id = 0;
410 410
 			}
411 411
 		}
412 412
 		//if there isn't yet a transaction row for this, create one
413 413
 		//(so even if it was a non-primary attendee with no EE3 primary attendee,
414 414
 		// it ought to have SOME transaction, so we'll make one)
415
-		if( ! $txn_id ) {
415
+		if ( ! $txn_id) {
416 416
 			//maps 3.1 payment stati onto 4.1 transaction stati
417 417
 			$txn_status_mapping = array(
418 418
 				'Completed'=>'TCM',
@@ -425,21 +425,21 @@  discard block
 block discarded – undo
425 425
 			);
426 426
 			$STS_ID = isset($txn_status_mapping[$old_attendee['payment_status']]) ? $txn_status_mapping[$old_attendee['payment_status']] : 'TIN';
427 427
 			$cols_n_values = array(
428
-				'TXN_timestamp'=>$this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,$old_attendee['date']),
428
+				'TXN_timestamp'=>$this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, $old_attendee['date']),
429 429
 				'TXN_total'=>floatval($old_attendee['total_cost']),
430 430
 				'TXN_paid'=>floatval($old_attendee['amount_pd']),
431 431
 				'STS_ID'=>$STS_ID,
432 432
 				'TXN_hash_salt'=>$old_attendee['hashSalt']
433 433
 			);
434 434
 			$datatypes = array(
435
-				'%s',//TXN_timestamp
436
-				'%f',//TXN_total
437
-				'%f',//TXN_paid
438
-				'%s',//STS_ID
439
-				'%s',//TXN_hash_salt
435
+				'%s', //TXN_timestamp
436
+				'%f', //TXN_total
437
+				'%f', //TXN_paid
438
+				'%s', //STS_ID
439
+				'%s', //TXN_hash_salt
440 440
 			);
441
-			$success = $wpdb->insert($this->_new_transaction_table,$cols_n_values,$datatypes);
442
-			if ( ! $success){
441
+			$success = $wpdb->insert($this->_new_transaction_table, $cols_n_values, $datatypes);
442
+			if ( ! $success) {
443 443
 				$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_transaction_table, $cols_n_values, $datatypes));
444 444
 				return 0;
445 445
 			}
@@ -453,13 +453,13 @@  discard block
 block discarded – undo
453 453
 	 * @global type $wpdb
454 454
 	 * @return boolean
455 455
 	 */
456
-	private function _mer_tables_exist(){
457
-		if( $this->_mer_tables_exist === NULL){
456
+	private function _mer_tables_exist() {
457
+		if ($this->_mer_tables_exist === NULL) {
458 458
 			global $wpdb;
459 459
 
460
-			if( $wpdb->get_var("SHOW TABLES LIKE '{$this->_old_mer_table}'") != $this->_old_mer_table){
460
+			if ($wpdb->get_var("SHOW TABLES LIKE '{$this->_old_mer_table}'") != $this->_old_mer_table) {
461 461
 				$this->_mer_tables_exist = false;
462
-			}else{
462
+			} else {
463 463
 				$this->_mer_tables_exist = true;
464 464
 			}
465 465
 		}
@@ -473,10 +473,10 @@  discard block
 block discarded – undo
473 473
 	 * @param type $old_attendee_row
474 474
 	 * @return string
475 475
 	 */
476
-	private function _get_reg_status_for_old_payment_status($old_attendee_row){
476
+	private function _get_reg_status_for_old_payment_status($old_attendee_row) {
477 477
 		//need event default reg status and if pre_approval was required
478 478
 		global $wpdb;
479
-		$event_required_pre_approval = $wpdb->get_var($wpdb->prepare("SELECT require_pre_approval FROM ".$wpdb->prefix."events_detail WHERE id = %d",$old_attendee_row['event_id']));
479
+		$event_required_pre_approval = $wpdb->get_var($wpdb->prepare("SELECT require_pre_approval FROM ".$wpdb->prefix."events_detail WHERE id = %d", $old_attendee_row['event_id']));
480 480
 		return $this->get_migration_script()->convert_3_1_payment_status_to_4_1_STS_ID($old_attendee_row['payment_status'],
481 481
 				intval($event_required_pre_approval) && intval($old_attendee_row['pre_approve']));
482 482
 	}
@@ -489,19 +489,19 @@  discard block
 block discarded – undo
489 489
 	 * @param int $new_txn_id
490 490
 	 * @return array of new registratio ids
491 491
 	 */
492
-	private function _insert_new_registrations($old_attendee,$new_attendee_id,$new_txn_id){
492
+	private function _insert_new_registrations($old_attendee, $new_attendee_id, $new_txn_id) {
493 493
 		global $wpdb;
494 494
 
495 495
 		$STS_ID = $this->_get_reg_status_for_old_payment_status($old_attendee);
496 496
 		$new_event_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix.'events_detail', $old_attendee['event_id'], $wpdb->posts);
497
-		if( ! $new_event_id){
498
-			$this->add_error(sprintf(__("Could not find NEW event CPT ID for old event '%d' on old attendee %s", "event_espresso"),$old_attendee['event_id'],$this->_json_encode($old_attendee)));
497
+		if ( ! $new_event_id) {
498
+			$this->add_error(sprintf(__("Could not find NEW event CPT ID for old event '%d' on old attendee %s", "event_espresso"), $old_attendee['event_id'], $this->_json_encode($old_attendee)));
499 499
 		}
500 500
 
501
-		$ticket_id = $this->_try_to_find_new_ticket_id($old_attendee,$new_event_id);
502
-		if( ! $ticket_id){
503
-			$ticket_id = $this->_insert_new_ticket_because_none_found( $old_attendee, $new_event_id );
504
-			$this->add_error( sprintf( __( 'Could not find a ticket for old attendee with id %d for new event %d, so created a new ticket with id %d', 'event_espresso' ), $old_attendee['id'], $new_event_id, $ticket_id ) );
501
+		$ticket_id = $this->_try_to_find_new_ticket_id($old_attendee, $new_event_id);
502
+		if ( ! $ticket_id) {
503
+			$ticket_id = $this->_insert_new_ticket_because_none_found($old_attendee, $new_event_id);
504
+			$this->add_error(sprintf(__('Could not find a ticket for old attendee with id %d for new event %d, so created a new ticket with id %d', 'event_espresso'), $old_attendee['id'], $new_event_id, $ticket_id));
505 505
 		}
506 506
 		$regs_on_this_row = intval($old_attendee['quantity']);
507 507
 		$new_regs = array();
@@ -510,50 +510,50 @@  discard block
 block discarded – undo
510 510
 		//Y old attendee_details rows with a quantity of 1 (no mer) joined by their common registration_id
511 511
 		//Y old attendee_details rows with a quantity of x (because of mer)
512 512
 		//Y old attendee_details rows with a quantity of 1 (because of mer) joined by wp_events_multi_event_registration_id_group
513
-		for($count = 1; $count <= $regs_on_this_row; $count++){
513
+		for ($count = 1; $count <= $regs_on_this_row; $count++) {
514 514
 			//sum regs on older rows
515
-			$regs_on_this_event_and_txn = $this->_sum_old_attendees_on_old_txn($old_attendee,true);
515
+			$regs_on_this_event_and_txn = $this->_sum_old_attendees_on_old_txn($old_attendee, true);
516 516
 			$cols_n_values = array(
517 517
 				'EVT_ID'=>$new_event_id,
518 518
 				'ATT_ID'=>$new_attendee_id,
519 519
 				'TXN_ID'=>$new_txn_id,
520 520
 				'TKT_ID'=>$ticket_id,
521 521
 				'STS_ID'=>$STS_ID,
522
-				'REG_date'=>$this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,$old_attendee['date']),
522
+				'REG_date'=>$this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, $old_attendee['date']),
523 523
 				'REG_final_price'=>$old_attendee['final_price'],
524
-				'REG_session'=> substr( $old_attendee['attendee_session'], 0, 44 ),
524
+				'REG_session'=> substr($old_attendee['attendee_session'], 0, 44),
525 525
 				'REG_code'=>sanitize_key($old_attendee['registration_id']),
526 526
 				'REG_url_link'=>  sanitize_key($old_attendee['registration_id'].'-'.$count),
527 527
 				'REG_count'=>$regs_on_this_event_and_txn + $count,
528
-				'REG_group_size'=>$this->_sum_old_attendees_on_old_txn($old_attendee,false),
528
+				'REG_group_size'=>$this->_sum_old_attendees_on_old_txn($old_attendee, false),
529 529
 				'REG_att_is_going'=>true,
530 530
 				'REG_deleted'=>false
531 531
 			);
532 532
 			$datatypes = array(
533
-				'%d',//EVT_ID
534
-				'%d',//ATT_ID
535
-				'%d',//TXN_ID
536
-				'%d',//TKT_ID
537
-				'%s',//STS_ID
538
-				'%s',//REG_date
539
-				'%f',//REG_final_price
540
-				'%s',//REG_session
541
-				'%s',//REG_code
542
-				'%s',//REG_url_link
543
-				'%d',//REG_count
544
-				'%d',//REG_group_size
545
-				'%d',//REG_att_is_going
546
-				'%d',//REG_deleted
533
+				'%d', //EVT_ID
534
+				'%d', //ATT_ID
535
+				'%d', //TXN_ID
536
+				'%d', //TKT_ID
537
+				'%s', //STS_ID
538
+				'%s', //REG_date
539
+				'%f', //REG_final_price
540
+				'%s', //REG_session
541
+				'%s', //REG_code
542
+				'%s', //REG_url_link
543
+				'%d', //REG_count
544
+				'%d', //REG_group_size
545
+				'%d', //REG_att_is_going
546
+				'%d', //REG_deleted
547 547
 			);
548
-			$success = $wpdb->insert($this->_new_reg_table,$cols_n_values,$datatypes);
549
-			if ( ! $success){
548
+			$success = $wpdb->insert($this->_new_reg_table, $cols_n_values, $datatypes);
549
+			if ( ! $success) {
550 550
 				$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_reg_table, $cols_n_values, $datatypes));
551 551
 				return 0;
552 552
 			}
553 553
 			$cols_n_values['REG_ID'] = $wpdb->insert_id;
554 554
 			$new_regs[] = $wpdb->insert_id;
555 555
 		}
556
-		$this->_add_regs_to_ticket_and_datetimes($ticket_id,count($new_regs),$STS_ID);
556
+		$this->_add_regs_to_ticket_and_datetimes($ticket_id, count($new_regs), $STS_ID);
557 557
 		return $new_regs;
558 558
 	}
559 559
 
@@ -569,23 +569,23 @@  discard block
 block discarded – undo
569 569
 	 * @param type $STS_ID
570 570
 	 * @return boolean whether they were successfully updated or not
571 571
 	 */
572
-	protected function _add_regs_to_ticket_and_datetimes($new_ticket_id,$quantity_sold,$STS_ID){
573
-		if($STS_ID != 'RAP'){
572
+	protected function _add_regs_to_ticket_and_datetimes($new_ticket_id, $quantity_sold, $STS_ID) {
573
+		if ($STS_ID != 'RAP') {
574 574
 			return true;
575 575
 		}
576 576
 		global $wpdb;
577
-		$success = $wpdb->query($wpdb->prepare("UPDATE {$this->_new_ticket_table} SET TKT_sold=TKT_sold+%d WHERE TKT_ID=%d",$quantity_sold,$new_ticket_id));
578
-		if($success){
577
+		$success = $wpdb->query($wpdb->prepare("UPDATE {$this->_new_ticket_table} SET TKT_sold=TKT_sold+%d WHERE TKT_ID=%d", $quantity_sold, $new_ticket_id));
578
+		if ($success) {
579 579
 			//get the ticket's datetimes, and increment them too
580
-			$success_update_dateimtes =  $wpdb->query($wpdb->prepare("UPDATE {$this->_new_ticket_table} TKT
580
+			$success_update_dateimtes = $wpdb->query($wpdb->prepare("UPDATE {$this->_new_ticket_table} TKT
581 581
 				INNER JOIN {$this->_new_ticket_datetime_table} as DTK ON TKT.TKT_ID = DTK.TKT_ID
582 582
 				INNER JOIN {$this->_new_datetime_table} as DTT ON DTK.DTT_ID = DTT.DTT_ID
583
-				SET DTT.DTT_sold = DTT.DTT_sold + %d WHERE TKT.TKT_ID = %d",$quantity_sold,$new_ticket_id));
584
-			if( ! $success_update_dateimtes){
585
-				$this->add_error(sprintf(__("Could not update datetimes related to ticket with ID %d's TKT_sold by %d because %s", "event_espresso"),$new_ticket_id,$quantity_sold,$wpdb->last_error));
583
+				SET DTT.DTT_sold = DTT.DTT_sold + %d WHERE TKT.TKT_ID = %d", $quantity_sold, $new_ticket_id));
584
+			if ( ! $success_update_dateimtes) {
585
+				$this->add_error(sprintf(__("Could not update datetimes related to ticket with ID %d's TKT_sold by %d because %s", "event_espresso"), $new_ticket_id, $quantity_sold, $wpdb->last_error));
586 586
 			}
587
-		}else{
588
-			$this->add_error(sprintf(__("Could not update ticket with ID %d's TKT_sold by %d because %s", "event_espresso"),$new_ticket_id,$quantity_sold,$wpdb->last_error));
587
+		} else {
588
+			$this->add_error(sprintf(__("Could not update ticket with ID %d's TKT_sold by %d because %s", "event_espresso"), $new_ticket_id, $quantity_sold, $wpdb->last_error));
589 589
 		}
590 590
 		return true;
591 591
 	}
@@ -597,7 +597,7 @@  discard block
 block discarded – undo
597 597
 	 * and lastly if none of that works, just use the first ticket for the event we find
598 598
 	 * @param array $old_attendee
599 599
 	 */
600
-	private function _try_to_find_new_ticket_id($old_attendee,$new_event_id){
600
+	private function _try_to_find_new_ticket_id($old_attendee, $new_event_id) {
601 601
 		global $wpdb;
602 602
 		$tickets_table = $this->_new_ticket_table;
603 603
 		$datetime_tickets_table = $this->_new_ticket_datetime_table;
@@ -608,24 +608,24 @@  discard block
 block discarded – undo
608 608
 
609 609
 		$old_att_start_date = $old_attendee['start_date'];
610 610
 		$old_att_start_time = $this->get_migration_script()->convertTimeFromAMPM($old_attendee['event_time']);
611
-		$old_att_datetime = $this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,"$old_att_start_date $old_att_start_time:00");
611
+		$old_att_datetime = $this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, "$old_att_start_date $old_att_start_time:00");
612 612
 		//add all conditions to an array from which we can SHIFT conditions off in order to widen our search
613 613
 		//the most important condition should be last, as it will be array_shift'ed off last
614 614
 		$conditions = array(
615
-			$wpdb->prepare("$datetime_table.DTT_EVT_start = %s",$old_att_datetime),//times match?
616
-			$wpdb->prepare("$tickets_table.TKT_price = %f",$old_att_price),//prices match?
617
-			$wpdb->prepare("$tickets_table.TKT_name = %s",$old_att_price_option),//names match?
618
-			$wpdb->prepare("$datetime_table.EVT_ID = %d",$new_event_id),//events match?
615
+			$wpdb->prepare("$datetime_table.DTT_EVT_start = %s", $old_att_datetime), //times match?
616
+			$wpdb->prepare("$tickets_table.TKT_price = %f", $old_att_price), //prices match?
617
+			$wpdb->prepare("$tickets_table.TKT_name = %s", $old_att_price_option), //names match?
618
+			$wpdb->prepare("$datetime_table.EVT_ID = %d", $new_event_id), //events match?
619 619
 		);
620 620
 		$select_and_join_part = "SELECT $tickets_table.TKT_ID FROM $tickets_table INNER JOIN
621 621
 			$datetime_tickets_table ON $tickets_table.TKT_ID = $datetime_tickets_table.TKT_ID INNER JOIN
622 622
 			$datetime_table ON $datetime_tickets_table.DTT_ID = $datetime_table.DTT_ID";
623 623
 		//start running queries, widening search each time by removing a condition
624
-		do{
625
-			$full_query = $select_and_join_part." WHERE ".implode(" AND ",$conditions)." LIMIT 1";
624
+		do {
625
+			$full_query = $select_and_join_part." WHERE ".implode(" AND ", $conditions)." LIMIT 1";
626 626
 			$ticket_id_found = $wpdb->get_var($full_query);
627 627
 			array_shift($conditions);
628
-		}while( ! $ticket_id_found && $conditions);
628
+		}while ( ! $ticket_id_found && $conditions);
629 629
 		return $ticket_id_found;
630 630
 
631 631
 	}
@@ -636,23 +636,23 @@  discard block
 block discarded – undo
636 636
 	 * the new ticket to that datetime and price.
637 637
 	 * @return int ticket id
638 638
 	 */
639
-	private function _insert_new_ticket_because_none_found( $old_attendee, $new_event_id ) {
639
+	private function _insert_new_ticket_because_none_found($old_attendee, $new_event_id) {
640 640
 		global $wpdb;
641 641
 		$old_att_price_option = $old_attendee['price_option'];
642 642
 		$old_att_price = floatval($old_attendee['orig_price']);
643 643
 
644 644
 		$old_att_start_date = $old_attendee['start_date'];
645 645
 		$old_att_start_time = $this->get_migration_script()->convertTimeFromAMPM($old_attendee['event_time']);
646
-		$old_att_start_datetime = $this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,"$old_att_start_date $old_att_start_time:00");
646
+		$old_att_start_datetime = $this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, "$old_att_start_date $old_att_start_time:00");
647 647
 
648 648
 
649 649
 		//insert new datetime unless we find one
650
-		$datetime_id = $wpdb->get_var( $wpdb->prepare( "SELECT DTT_ID FROM " . $this->_new_datetime_table . " WHERE DTT_EVT_start=%s AND EVT_ID=%d LIMIT 1", $old_att_start_datetime, $new_event_id ), ARRAY_A );
651
-		if( ! $datetime_id ) {
650
+		$datetime_id = $wpdb->get_var($wpdb->prepare("SELECT DTT_ID FROM ".$this->_new_datetime_table." WHERE DTT_EVT_start=%s AND EVT_ID=%d LIMIT 1", $old_att_start_datetime, $new_event_id), ARRAY_A);
651
+		if ( ! $datetime_id) {
652 652
 			$old_att_end_date = $old_attendee['start_date'];
653 653
 			$old_att_end_time = $this->get_migration_script()->convertTimeFromAMPM($old_attendee['event_time']);
654
-			$old_att_end_datetime = $this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,"$old_att_end_date $old_att_end_time:00");
655
-			$wpdb->insert( $this->_new_datetime_table,
654
+			$old_att_end_datetime = $this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, "$old_att_end_date $old_att_end_time:00");
655
+			$wpdb->insert($this->_new_datetime_table,
656 656
 					array(
657 657
 						'EVT_ID' => $new_event_id,
658 658
 						'DTT_EVT_start' => $old_att_start_datetime,
@@ -660,44 +660,44 @@  discard block
 block discarded – undo
660 660
 						'DTT_deleted' => TRUE
661 661
 					),
662 662
 					array(
663
-						'%d',//EVT_ID
664
-						'%s',//DTT_EVT_start
665
-						'%s',//DTT_EVT_end
666
-						'%d',//DTT_deleted
663
+						'%d', //EVT_ID
664
+						'%s', //DTT_EVT_start
665
+						'%s', //DTT_EVT_end
666
+						'%d', //DTT_deleted
667 667
 					));
668 668
 			$datetime_id = $wpdb->insert_id;
669 669
 		}
670 670
 
671 671
 		//insert new ticket
672
-		$success = $wpdb->insert( $wpdb->prefix . 'esp_ticket',
672
+		$success = $wpdb->insert($wpdb->prefix.'esp_ticket',
673 673
 				array(
674 674
 					'TKT_name' => $old_att_price_option,
675 675
 					'TKT_qty' => -1,
676 676
 					'TKT_price' => $old_att_price,
677
-					'TKT_start_date' => $old_att_start_datetime,//we really have no clue what the time should be, but at least it was available when they attended
677
+					'TKT_start_date' => $old_att_start_datetime, //we really have no clue what the time should be, but at least it was available when they attended
678 678
 					'TKT_end_date' => $old_att_end_datetime,
679 679
 
680 680
 				),
681 681
 				array(
682
-					'%s',//name
683
-					'%d',//qty
684
-					'%d',//price
685
-					'%s',//start_date
686
-					'%s',//end_date
682
+					'%s', //name
683
+					'%d', //qty
684
+					'%d', //price
685
+					'%s', //start_date
686
+					'%s', //end_date
687 687
 				));
688 688
 		$ticket_id = $wpdb->insert_id;
689 689
 		//associate the ticket with the datetime we found earlier
690
-		$wpdb->insert( $this->_new_datetime_ticket_table,
690
+		$wpdb->insert($this->_new_datetime_ticket_table,
691 691
 				array(
692 692
 					'DTT_ID' => $datetime_id,
693 693
 					'TKT_ID' => $ticket_id
694 694
 				),
695 695
 				array(
696
-					'%d',//DTT_ID
697
-					'%d',//TKT_ID
696
+					'%d', //DTT_ID
697
+					'%d', //TKT_ID
698 698
 				));
699 699
 		//insert new price
700
-		$wpdb->insert( $this->_new_price_table,
700
+		$wpdb->insert($this->_new_price_table,
701 701
 				array(
702 702
 					'PRC_amount' => $old_att_price,
703 703
 					'PRT_ID' => EE_DMS_4_1_0_prices::price_type_base,
@@ -705,22 +705,22 @@  discard block
 block discarded – undo
705 705
 					'PRC_deleted' => TRUE
706 706
 				),
707 707
 				array(
708
-					'%d',//PRC_amount
709
-					'%d',//PRT_ID
710
-					'%s',//PRC_name
711
-					'%d',//PRC_deleted
708
+					'%d', //PRC_amount
709
+					'%d', //PRT_ID
710
+					'%s', //PRC_name
711
+					'%d', //PRC_deleted
712 712
 				));
713 713
 		$price_id = $wpdb->insert_id;
714 714
 		//associate the price to the ticket
715
-		$wpdb->insert( $this->_new_ticket_price_table,
715
+		$wpdb->insert($this->_new_ticket_price_table,
716 716
 				array(
717 717
 					'TKT_ID' => $ticket_id,
718 718
 					'PRC_ID' => $price_id
719 719
 				),
720 720
 				array(
721
-					'%d',//TKT_ID
722
-					'%d',//PRC_ID
723
-				) );
721
+					'%d', //TKT_ID
722
+					'%d', //PRC_ID
723
+				));
724 724
 		return $ticket_id;
725 725
 	}
726 726
 	/**
@@ -731,12 +731,12 @@  discard block
 block discarded – undo
731 731
 	 * @param boolean $count_only_older true if you want the running count (ie, the total up to this row), and false if you want ALL
732 732
 	 * @return int
733 733
 	 */
734
-	private function _sum_old_attendees_on_old_txn($old_attendee_row,$count_only_older = false){
734
+	private function _sum_old_attendees_on_old_txn($old_attendee_row, $count_only_older = false) {
735 735
 		global $wpdb;
736
-		$count_only_older_sql = $count_only_older ? $wpdb->prepare(" AND id<%d",$old_attendee_row['id']) : '';
737
-		$count = intval($wpdb->get_var($wpdb->prepare("SELECT SUM(quantity) FROM ".$this->_old_table." WHERE registration_id=%s $count_only_older_sql",$old_attendee_row['registration_id'])));
736
+		$count_only_older_sql = $count_only_older ? $wpdb->prepare(" AND id<%d", $old_attendee_row['id']) : '';
737
+		$count = intval($wpdb->get_var($wpdb->prepare("SELECT SUM(quantity) FROM ".$this->_old_table." WHERE registration_id=%s $count_only_older_sql", $old_attendee_row['registration_id'])));
738 738
 
739
-		if( $this->_mer_tables_exist()){
739
+		if ($this->_mer_tables_exist()) {
740 740
 			//if MER exists, then its a little tricky.
741 741
 			//when users registered by adding items to the cart, and it was a
742 742
 			//group registration requiring additional attendee INFO, then the attendee rows
@@ -745,17 +745,17 @@  discard block
 block discarded – undo
745 745
 			//BUT we want to count all the MER attendee rows for the same registration
746 746
 			$primary_attendee = $this->_find_mer_primary_attendee_using_mer_tables($old_attendee_row['registration_id']);
747 747
 
748
-			$count_using_mer_table = $wpdb->get_var($wpdb->prepare("SELECT SUM(quantity) FROM {$this->_old_table} att INNER JOIN {$this->_old_mer_table} mer ON att.registration_id = mer.registration_id WHERE att.event_id=%d AND mer.primary_registration_id = %s $count_only_older_sql",$old_attendee_row['event_id'],$primary_attendee['registration_id']));
749
-			$count = max($count_using_mer_table,$count);
748
+			$count_using_mer_table = $wpdb->get_var($wpdb->prepare("SELECT SUM(quantity) FROM {$this->_old_table} att INNER JOIN {$this->_old_mer_table} mer ON att.registration_id = mer.registration_id WHERE att.event_id=%d AND mer.primary_registration_id = %s $count_only_older_sql", $old_attendee_row['event_id'], $primary_attendee['registration_id']));
749
+			$count = max($count_using_mer_table, $count);
750 750
 		}
751 751
 		return $count;
752 752
 	}
753
-	private function _insert_new_payment($old_attendee,$new_txn_id){
753
+	private function _insert_new_payment($old_attendee, $new_txn_id) {
754 754
 		global $wpdb;
755 755
 		//only add a payment for primary attendees
756
-		$old_pay_stati_indicating_no_payment = array('Pending','Incomplete','Not Completed');
756
+		$old_pay_stati_indicating_no_payment = array('Pending', 'Incomplete', 'Not Completed');
757 757
 		//if this is for a primary 3.1 attendee which WASN'T free and has a completed, cancelled, or declined payment...
758
-		if(intval($old_attendee['is_primary']) && floatval($old_attendee['total_cost']) && ! in_array($old_attendee['payment_status'], $old_pay_stati_indicating_no_payment)){
758
+		if (intval($old_attendee['is_primary']) && floatval($old_attendee['total_cost']) && ! in_array($old_attendee['payment_status'], $old_pay_stati_indicating_no_payment)) {
759 759
 			$pay_status_mapping = array(
760 760
 				'Completed'=>'PAP',
761 761
 				'Payment Declined'=>'PDC',
@@ -763,41 +763,41 @@  discard block
 block discarded – undo
763 763
 				'Declined'=>'PDC'
764 764
 			);
765 765
 			$by_admin = $old_attendee['payment'] == 'Admin';
766
-			$STS_ID = isset($pay_status_mapping[$old_attendee['payment_status']]) ? $pay_status_mapping[$old_attendee['payment_status']] : 'PFL';//IE, if we don't recognize the status, assume payment failed
766
+			$STS_ID = isset($pay_status_mapping[$old_attendee['payment_status']]) ? $pay_status_mapping[$old_attendee['payment_status']] : 'PFL'; //IE, if we don't recognize the status, assume payment failed
767 767
 			$cols_n_values = array(
768 768
 				'TXN_ID'=>$new_txn_id,
769 769
 				'STS_ID'=>$STS_ID,
770
-				'PAY_timestamp'=>$this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,$old_attendee['date']),
770
+				'PAY_timestamp'=>$this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, $old_attendee['date']),
771 771
 				'PAY_method'=>'CART',
772 772
 				'PAY_amount'=>$old_attendee['amount_pd'],
773 773
 				'PAY_gateway'=>$old_attendee['txn_type'],
774 774
 				'PAY_gateway_response'=>'',
775
-				'PAY_txn_id_chq_nmbr'=>substr( $old_attendee['txn_id'], 0, 32 ),
775
+				'PAY_txn_id_chq_nmbr'=>substr($old_attendee['txn_id'], 0, 32),
776 776
 				'PAY_via_admin'=>$by_admin,
777 777
 				'PAY_details'=>$old_attendee['transaction_details']
778 778
 
779 779
 			);
780 780
 			$datatypes = array(
781
-				'%d',//TXN_Id
782
-				'%s',//STS_ID
783
-				'%s',//PAY_timestamp
784
-				'%s',//PAY_method
785
-				'%f',//PAY_amount
786
-				'%s',//PAY_gateway
787
-				'%s',//PAY_gateway_response
788
-				'%s',//PAY_txn_id_chq_nmbr
789
-				'%d',//PAY_via_admin
790
-				'%s',//PAY_details
781
+				'%d', //TXN_Id
782
+				'%s', //STS_ID
783
+				'%s', //PAY_timestamp
784
+				'%s', //PAY_method
785
+				'%f', //PAY_amount
786
+				'%s', //PAY_gateway
787
+				'%s', //PAY_gateway_response
788
+				'%s', //PAY_txn_id_chq_nmbr
789
+				'%d', //PAY_via_admin
790
+				'%s', //PAY_details
791 791
 			);
792
-			$success = $wpdb->insert($this->_new_payment_table,$cols_n_values,$datatypes);
793
-			if ( ! $success){
792
+			$success = $wpdb->insert($this->_new_payment_table, $cols_n_values, $datatypes);
793
+			if ( ! $success) {
794 794
 				$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_attendee_cpt_table, $cols_n_values, $datatypes));
795 795
 				return 0;
796 796
 			}
797 797
 			$new_id = $wpdb->insert_id;
798 798
 			return $new_id;
799 799
 
800
-		}else{
800
+		} else {
801 801
 			return 0;
802 802
 		}
803 803
 
@@ -810,12 +810,12 @@  discard block
 block discarded – undo
810 810
 	 * @param type $old_registration_id
811 811
 	 * @return array
812 812
 	 */
813
-	private function _find_mer_primary_attendee_using_mer_tables($old_registration_id){
814
-		if (! $this->_mer_tables_exist()){
813
+	private function _find_mer_primary_attendee_using_mer_tables($old_registration_id) {
814
+		if ( ! $this->_mer_tables_exist()) {
815 815
 			return false;
816 816
 		}
817 817
 		global $wpdb;
818
-		$old_att_for_primary_reg = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$this->_old_mer_table} AS mer INNER JOIN {$this->_old_table} AS att ON mer.primary_registration_id = att.registration_id WHERE mer.registration_id=%s LIMIT 1",$old_registration_id),ARRAY_A);
818
+		$old_att_for_primary_reg = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$this->_old_mer_table} AS mer INNER JOIN {$this->_old_table} AS att ON mer.primary_registration_id = att.registration_id WHERE mer.registration_id=%s LIMIT 1", $old_registration_id), ARRAY_A);
819 819
 return $old_att_for_primary_reg;
820 820
 	}
821 821
 
Please login to merge, or discard this patch.
core/data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_checkins.dmsstage.php 3 patches
Doc Comments   +2 added lines, -3 removed lines patch added patch discarded remove patch
@@ -78,7 +78,7 @@  discard block
 block discarded – undo
78 78
 	 * (because we know the attendee was for an event as a specific time, and we know
79 79
 	 * the event's OLD ID...)
80 80
 	 * @global type $wpdb
81
-	 * @param array $old_attendee_row
81
+	 * @param array $old_attendee
82 82
 	 * @return array row of datetime from DB
83 83
 	 */
84 84
 	private function _try_to_find_datetime($old_attendee){
@@ -113,8 +113,7 @@  discard block
 block discarded – undo
113 113
 	/**
114 114
 	 * Adds a new Check-in/checkout record according for $new_reg_id,$new_datetime_id,$checking_in, and $timestmap
115 115
 	 * @param int $new_reg_id
116
-	 * @param int $new_datetime_id
117
-	 * @param string $timestamp mysql datetime
116
+	 * @param int $new_datetime
118 117
 	 * @return int new Check-in id
119 118
 	 */
120 119
 	private function _insert_checkin_record($new_reg_id,$new_datetime){
Please login to merge, or discard this patch.
Spacing   +29 added lines, -29 removed lines patch added patch discarded remove patch
@@ -24,7 +24,7 @@  discard block
 block discarded – undo
24 24
 		);
25 25
 */
26 26
 
27
-class EE_DMS_4_1_0_checkins extends EE_Data_Migration_Script_Stage_Table{
27
+class EE_DMS_4_1_0_checkins extends EE_Data_Migration_Script_Stage_Table {
28 28
 	private $_new_table;
29 29
 	function __construct() {
30 30
 		global $wpdb;
@@ -37,10 +37,10 @@  discard block
 block discarded – undo
37 37
 		global $wpdb;
38 38
 		$new_reg_table = $wpdb->prefix."esp_registration";
39 39
 
40
-		$num_to_checkin_at_this_time = max(array(intval($old_row['checked_in_quantity']),intval($old_row['checked_in']))) ;
40
+		$num_to_checkin_at_this_time = max(array(intval($old_row['checked_in_quantity']), intval($old_row['checked_in'])));
41 41
 
42 42
 		$new_registrations_for_attendee = $this->get_migration_script()->get_mapping_new_pk($this->_old_table, $old_row['id'], $new_reg_table);
43
-		if( ! $new_registrations_for_attendee){
43
+		if ( ! $new_registrations_for_attendee) {
44 44
 			$new_registrations_for_attendee = array();
45 45
 		}
46 46
 		$new_datetime = $this->_try_to_find_datetime($old_row);
@@ -48,26 +48,26 @@  discard block
 block discarded – undo
48 48
 		//make sure registrations array is numerically indexed starting at 0 (it probably already is)
49 49
 		$new_registrations_for_attendee = array_values($new_registrations_for_attendee);
50 50
 		$new_checkin_ids = array();
51
-		for($i = 0; $i<abs($num_to_checkin_at_this_time); $i++){
51
+		for ($i = 0; $i < abs($num_to_checkin_at_this_time); $i++) {
52 52
 			$new_reg_id = $new_registrations_for_attendee[$i];
53
-			if( ! $new_reg_id){
53
+			if ( ! $new_reg_id) {
54 54
 				$this->add_error(sprintf(__('It appears we wanted to check-in more registrations than actually exist. The old attendee record (%1$s) indicated we should check-in %2$d registrations, but there are only %3$d registrations for that attendee (%4$s)', "event_espresso"),
55
-					$this->_json_encode($old_row),abs($num_to_checkin_at_this_time),count($new_registrations_for_attendee),  $this->_json_encode($new_registrations_for_attendee)));
55
+					$this->_json_encode($old_row), abs($num_to_checkin_at_this_time), count($new_registrations_for_attendee), $this->_json_encode($new_registrations_for_attendee)));
56 56
 				break;
57 57
 			}
58
-			$new_last_checkin_record = $wpdb->get_row($wpdb->prepare("SELECT * FROM $this->_new_table WHERE REG_ID = %d ORDER BY CHK_ID DESC LIMIT 1",$new_reg_id));
59
-			if( ! $new_last_checkin_record ){
58
+			$new_last_checkin_record = $wpdb->get_row($wpdb->prepare("SELECT * FROM $this->_new_table WHERE REG_ID = %d ORDER BY CHK_ID DESC LIMIT 1", $new_reg_id));
59
+			if ( ! $new_last_checkin_record) {
60 60
 				$is_checked_in = FALSE;
61
-			}else{
61
+			} else {
62 62
 				$is_checked_in = intval($new_last_checkin_record['CHK_in']);
63 63
 			}
64 64
 			$new_id = $this->_insert_checkin_record($new_reg_id, $new_datetime);
65
-			if($new_id){
66
-				$new_checkin_ids[]= $new_id;
65
+			if ($new_id) {
66
+				$new_checkin_ids[] = $new_id;
67 67
 			}
68 68
 
69 69
 		}
70
-		if ($new_checkin_ids){
70
+		if ($new_checkin_ids) {
71 71
 			$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_table, $new_checkin_ids);
72 72
 		}
73 73
 	}
@@ -81,32 +81,32 @@  discard block
 block discarded – undo
81 81
 	 * @param array $old_attendee_row
82 82
 	 * @return array row of datetime from DB
83 83
 	 */
84
-	private function _try_to_find_datetime($old_attendee){
84
+	private function _try_to_find_datetime($old_attendee) {
85 85
 		global $wpdb;
86 86
 
87 87
 		$new_event_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_detail", $old_attendee['event_id'], $wpdb->posts);
88
-		if ( ! $new_event_id){
89
-			$this->add_error(sprintf(__("Could nto find new event ID with old event id '%d', on attendee row %s; and because of that couldnt find the correct datetime for Check-in", "event_espresso"),$old_attendee['event_id'],$this->_json_encode($old_attendee)));
88
+		if ( ! $new_event_id) {
89
+			$this->add_error(sprintf(__("Could nto find new event ID with old event id '%d', on attendee row %s; and because of that couldnt find the correct datetime for Check-in", "event_espresso"), $old_attendee['event_id'], $this->_json_encode($old_attendee)));
90 90
 			return 0;
91 91
 		}
92 92
 		$old_att_start_date = $old_attendee['start_date'];
93 93
 		$old_att_start_time = $this->get_migration_script()->convertTimeFromAMPM($old_attendee['event_time']);
94
-		$old_att_datetime = $this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,"$old_att_start_date $old_att_start_time:00");
94
+		$old_att_datetime = $this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, "$old_att_start_date $old_att_start_time:00");
95 95
 
96 96
 		$datetime_table = $wpdb->prefix."esp_datetime";
97 97
 		//add all conditions to an array from which we can SHIFT conditions off in order to widen our search
98 98
 		//the most important condition should be last, as it will be array_shift'ed off last
99 99
 		$conditions = array(
100
-			$wpdb->prepare("$datetime_table.DTT_EVT_start = %s",$old_att_datetime),//times match?
101
-			$wpdb->prepare("$datetime_table.EVT_ID = %d",$new_event_id),//events match?
100
+			$wpdb->prepare("$datetime_table.DTT_EVT_start = %s", $old_att_datetime), //times match?
101
+			$wpdb->prepare("$datetime_table.EVT_ID = %d", $new_event_id), //events match?
102 102
 		);
103 103
 		//start running queries, widening search each time by removing a condition
104 104
 		$datetime_found = NULL;
105
-		do{
106
-			$full_query = "SELECT * FROM $datetime_table WHERE ".implode(" AND ",$conditions)." LIMIT 1";
107
-			$datetime_found = $wpdb->get_row($full_query,ARRAY_A);
105
+		do {
106
+			$full_query = "SELECT * FROM $datetime_table WHERE ".implode(" AND ", $conditions)." LIMIT 1";
107
+			$datetime_found = $wpdb->get_row($full_query, ARRAY_A);
108 108
 			array_shift($conditions);
109
-		}while( ! $datetime_found && $conditions);
109
+		}while ( ! $datetime_found && $conditions);
110 110
 		return $datetime_found;
111 111
 	}
112 112
 
@@ -117,7 +117,7 @@  discard block
 block discarded – undo
117 117
 	 * @param string $timestamp mysql datetime
118 118
 	 * @return int new Check-in id
119 119
 	 */
120
-	private function _insert_checkin_record($new_reg_id,$new_datetime){
120
+	private function _insert_checkin_record($new_reg_id, $new_datetime) {
121 121
 		global $wpdb;
122 122
 
123 123
 
@@ -129,13 +129,13 @@  discard block
 block discarded – undo
129 129
 			'CHK_timestamp'=>$new_datetime['DTT_EVT_start']
130 130
 		);
131 131
 		$datatypes = array(
132
-			'%d',//REG_ID
133
-			'%d',//DTT_ID
134
-			'%d',//CHK_in
135
-			'%s',//CHK_timestamp
132
+			'%d', //REG_ID
133
+			'%d', //DTT_ID
134
+			'%d', //CHK_in
135
+			'%s', //CHK_timestamp
136 136
 		);
137
-		$success = $wpdb->insert($this->_new_table,$cols_n_values,$datatypes);
138
-		if ( ! $success){
137
+		$success = $wpdb->insert($this->_new_table, $cols_n_values, $datatypes);
138
+		if ( ! $success) {
139 139
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_checkin, $this->_new_table, $cols_n_values, $datatypes));
140 140
 			return 0;
141 141
 		}
Please login to merge, or discard this patch.
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -33,7 +33,7 @@
 block discarded – undo
33 33
 		if( $normalized_value ){
34 34
 			if (filter_var($normalized_value, FILTER_VALIDATE_URL) === false){
35 35
 				throw new EE_Validation_Error( $this->get_validation_error_message(), 'invalid_url');
36
-			}else{
36
+			} else{
37 37
 				EE_Registry::instance()->load_helper('URL');
38 38
 				if( ! EEH_URL::remote_file_exists(
39 39
 						$normalized_value,
Please login to merge, or discard this patch.
4_1_0_stages/EE_DMS_4_1_0_event_question_group.dmsstage.php 3 patches
Doc Comments   +3 added lines patch added patch discarded remove patch
@@ -94,6 +94,9 @@
 block discarded – undo
94 94
 		$this->get_migration_script()->set_mapping($this->_old_table, $old_event['id'], $this->_new_table, $new_event_question_group_ids);
95 95
 	}
96 96
 
97
+	/**
98
+	 * @param boolean $primary
99
+	 */
97 100
 	private function _insert_event_question_group($old_event,$old_question_group_id,$primary){
98 101
 		global $wpdb;
99 102
 		$new_question_group_id =$this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_qst_group", intval($old_question_group_id), $wpdb->prefix."esp_question_group");
Please login to merge, or discard this patch.
Spacing   +22 added lines, -22 removed lines patch added patch discarded remove patch
@@ -20,7 +20,7 @@  discard block
 block discarded – undo
20 20
 
21 21
  *
22 22
  */
23
-class EE_DMS_4_1_0_event_question_group extends EE_Data_Migration_Script_Stage_Table{
23
+class EE_DMS_4_1_0_event_question_group extends EE_Data_Migration_Script_Stage_Table {
24 24
 	private $_new_table;
25 25
 	function _migrate_old_row($old_row) {
26 26
 //		$txn_id = $this->get_migration_script()->get_mapping_new_pk($this->_old_table, $old_row['id'], $this->_new_transaction_table);
@@ -67,23 +67,23 @@  discard block
 block discarded – undo
67 67
 	 * @param array $old_event
68 68
 	 * @return void
69 69
 	 */
70
-	private function _insert_new_event_question_groups($old_event){
70
+	private function _insert_new_event_question_groups($old_event) {
71 71
 		$new_event_question_group_ids = array();
72 72
 		$question_groups_for_primary = maybe_unserialize($old_event['question_groups']);
73
-		if( is_array($question_groups_for_primary ) ){
74
-			foreach($question_groups_for_primary as $old_question_group_id){
75
-				$new_id = $this->_insert_event_question_group($old_event,$old_question_group_id,true);
76
-				if($new_id){
73
+		if (is_array($question_groups_for_primary)) {
74
+			foreach ($question_groups_for_primary as $old_question_group_id) {
75
+				$new_id = $this->_insert_event_question_group($old_event, $old_question_group_id, true);
76
+				if ($new_id) {
77 77
 					$new_event_question_group_ids[] = $new_id;
78 78
 				}
79 79
 			}
80 80
 		}
81 81
 		$event_meta = maybe_unserialize($old_event['event_meta']);
82
-		if(isset($event_meta['add_attendee_question_groups'])){
83
-			if( is_array( $event_meta['add_attendee_question_groups'] )){
84
-				foreach($event_meta['add_attendee_question_groups'] as $old_question_group_id){
85
-					$new_id = $this->_insert_event_question_group($old_event,$old_question_group_id,false);
86
-					if($new_id){
82
+		if (isset($event_meta['add_attendee_question_groups'])) {
83
+			if (is_array($event_meta['add_attendee_question_groups'])) {
84
+				foreach ($event_meta['add_attendee_question_groups'] as $old_question_group_id) {
85
+					$new_id = $this->_insert_event_question_group($old_event, $old_question_group_id, false);
86
+					if ($new_id) {
87 87
 						$new_event_question_group_ids[] = $new_id;
88 88
 					}
89 89
 				}
@@ -94,17 +94,17 @@  discard block
 block discarded – undo
94 94
 		$this->get_migration_script()->set_mapping($this->_old_table, $old_event['id'], $this->_new_table, $new_event_question_group_ids);
95 95
 	}
96 96
 
97
-	private function _insert_event_question_group($old_event,$old_question_group_id,$primary){
97
+	private function _insert_event_question_group($old_event, $old_question_group_id, $primary) {
98 98
 		global $wpdb;
99
-		$new_question_group_id =$this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_qst_group", intval($old_question_group_id), $wpdb->prefix."esp_question_group");
99
+		$new_question_group_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_qst_group", intval($old_question_group_id), $wpdb->prefix."esp_question_group");
100 100
 
101
-		if( ! $new_question_group_id){
102
-			$this->add_error(sprintf(__("Could not find 4.1 question ID for 3.1 question id #%s on event $%s", "event_espresso"),$old_question_group_id,$old_event['id']));
101
+		if ( ! $new_question_group_id) {
102
+			$this->add_error(sprintf(__("Could not find 4.1 question ID for 3.1 question id #%s on event $%s", "event_espresso"), $old_question_group_id, $old_event['id']));
103 103
 			return 0;
104 104
 		}
105 105
 		$new_event_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_detail", intval($old_event['id']), $wpdb->posts);
106
-			if( ! $new_question_group_id){
107
-			$this->add_error(sprintf(__("Could not find 4.1 event 3.1 event id #%s", "event_espresso"),$old_event['id']));
106
+			if ( ! $new_question_group_id) {
107
+			$this->add_error(sprintf(__("Could not find 4.1 event 3.1 event id #%s", "event_espresso"), $old_event['id']));
108 108
 			return 0;
109 109
 		}
110 110
 		$cols_n_values = array(
@@ -113,12 +113,12 @@  discard block
 block discarded – undo
113 113
 			'EQG_primary'=>$primary
114 114
 		);
115 115
 		$datatypes = array(
116
-			'%d',//EVT_ID
117
-			'%d',//QSG_ID
118
-			'%d',//EQG_primary
116
+			'%d', //EVT_ID
117
+			'%d', //QSG_ID
118
+			'%d', //EQG_primary
119 119
 		);
120
-		$success = $wpdb->insert($this->_new_table,$cols_n_values,$datatypes);
121
-		if ( ! $success){
120
+		$success = $wpdb->insert($this->_new_table, $cols_n_values, $datatypes);
121
+		if ( ! $success) {
122 122
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_event, $this->_new_table, $cols_n_values, $datatypes));
123 123
 			return 0;
124 124
 		}
Please login to merge, or discard this patch.
Indentation   -2 removed lines patch added patch discarded remove patch
@@ -12,8 +12,6 @@
 block discarded – undo
12 12
   KEY `group_id` (`group_id`),
13 13
   KEY `question_id` (`question_id`)
14 14
 ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8$$
15
-
16
-
17 15
  * 4.1 question group question model's tables and fields:
18 16
  $this->_tables = array(
19 17
 			'Question_Group_Question'=>new EE_Primary_Table('esp_question_group_question','QGQ_ID')
Please login to merge, or discard this patch.
core/data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_events.dmsstage.php 4 patches
Doc Comments   +6 added lines, -3 removed lines patch added patch discarded remove patch
@@ -483,7 +483,7 @@  discard block
 block discarded – undo
483 483
 
484 484
 	/**
485 485
 	 * Inserts the CPT
486
-	 * @param array $old_venue keys are cols, values are col values
486
+	 * @param array $old_event keys are cols, values are col values
487 487
 	 * @return int
488 488
 	 */
489 489
 	private function _insert_venue_into_posts($old_event){
@@ -528,7 +528,7 @@  discard block
 block discarded – undo
528 528
 
529 529
 	/**
530 530
 	 * Inserts into the venue_meta table
531
-	 * @param type $cpt_id
531
+	 * @param integer $cpt_id
532 532
 	 * @param type $old_event
533 533
 	 * @return int
534 534
 	 */
@@ -596,6 +596,9 @@  discard block
 block discarded – undo
596 596
 		return $wpdb->insert_id;
597 597
 	}
598 598
 
599
+	/**
600
+	 * @param integer $new_venue_id
601
+	 */
599 602
 	private function _insert_new_venue_to_event($new_event_id,$new_venue_id){
600 603
 		global $wpdb;
601 604
 		if( ! $new_event_id){
@@ -654,7 +657,7 @@  discard block
 block discarded – undo
654 657
 	 * Inserts a 4.1 datetime given the 3.1 start_end db row and event_details row
655 658
 	 * @param type $start_end_time_row
656 659
 	 * @param type $old_event_row
657
-	 * @param type $new_cpt_id
660
+	 * @param integer $new_cpt_id
658 661
 	 * @return int ID of new datetime
659 662
 	 */
660 663
 	private function _insert_new_datetime($start_end_time_row,$old_event_row,$new_cpt_id){
Please login to merge, or discard this patch.
Indentation   -5 removed lines patch added patch discarded remove patch
@@ -84,8 +84,6 @@  discard block
 block discarded – undo
84 84
   KEY `submitted` (`submitted`),
85 85
   KEY `likes` (`likes`)
86 86
 ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8$$
87
-
88
-
89 87
  *
90 88
  * 4.1 Event model:
91 89
  * $this->_tables = array(
@@ -124,7 +122,6 @@  discard block
 block discarded – undo
124 122
 				'EVT_donations'=>new EE_Boolean_Field('EVT_donations', __("Accept Donations?", "event_espresso"), false, false)
125 123
 
126 124
 			));
127
-
128 125
  *
129 126
  * 3.1's start end table
130 127
  *
@@ -137,8 +134,6 @@  discard block
 block discarded – undo
137 134
   PRIMARY KEY (`id`),
138 135
   KEY `event_id` (`event_id`)
139 136
 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8$$
140
-
141
-
142 137
  *
143 138
  * and 4.1 Datetime model's tables and fields:
144 139
  * $this->_tables = array(
Please login to merge, or discard this patch.
Braces   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -444,7 +444,7 @@  discard block
 block discarded – undo
444 444
 			//we don't bother recording the conversion from old events to venues as that
445 445
 			//will complicate finding the conversion from old venues to new events
446 446
 			return $new_id;
447
-		}else{
447
+		} else{
448 448
 			return 0;
449 449
 		}
450 450
 	}
@@ -541,7 +541,7 @@  discard block
 block discarded – undo
541 541
 		if( ! $old_event['state']){
542 542
 			$old_org_options = get_option('events_organization_settings');
543 543
 			$state_name = stripslashes($old_org_options['organization_state']);
544
-		}else{
544
+		} else{
545 545
 			$state_name = $old_event['state'];
546 546
 		}
547 547
 		if ( ! $state_name ){
@@ -551,7 +551,7 @@  discard block
 block discarded – undo
551 551
 		try{
552 552
 			$state = $this->get_migration_script()->get_or_create_state($state_name,$country_iso);
553 553
 			$state_id = $state['STA_ID'];
554
-		}catch(EE_Error $e){
554
+		} catch(EE_Error $e){
555 555
 			$this->add_error($e->getMessage());
556 556
 			$state_id = 0;
557 557
 		}
Please login to merge, or discard this patch.
Spacing   +196 added lines, -196 removed lines patch added patch discarded remove patch
@@ -158,7 +158,7 @@  discard block
 block discarded – undo
158 158
 				'DTT_deleted' => new EE_Trashed_Flag_Field('DTT_deleted', __('Flag indicating datetime is archived', 'event_espresso'), false, false ),
159 159
 			));
160 160
  */
161
-class EE_DMS_4_1_0_events extends EE_Data_Migration_Script_Stage{
161
+class EE_DMS_4_1_0_events extends EE_Data_Migration_Script_Stage {
162 162
 	private $_old_table;
163 163
 	private $_old_start_end_table;
164 164
 	private $_new_table;
@@ -184,41 +184,41 @@  discard block
 block discarded – undo
184 184
 	protected function _migration_step($num_items_to_migrate = 50) {
185 185
 		global $wpdb;
186 186
 		//because the migration of each event can be a LOT more work, make each step smaller
187
-		$num_items_to_migrate = max(1,$num_items_to_migrate/5);
188
-		$events = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$this->count_records_migrated(),$num_items_to_migrate),ARRAY_A);
187
+		$num_items_to_migrate = max(1, $num_items_to_migrate / 5);
188
+		$events = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $this->count_records_migrated(), $num_items_to_migrate), ARRAY_A);
189 189
 		$items_migrated_this_step = 0;
190 190
 
191
-		foreach($events as $event_row){
191
+		foreach ($events as $event_row) {
192 192
 			$created_attachment_post = false;
193 193
 			//insert new 4.1 Attendee object using $wpdb
194 194
 			$post_id = $this->_insert_cpt($event_row);
195
-			if($post_id){
195
+			if ($post_id) {
196 196
 				$this->get_migration_script()->set_mapping($this->_old_table, $event_row['id'], $this->_new_table, $post_id);
197 197
 				$meta_id = $this->_insert_event_meta($event_row, $post_id);
198
-				if($meta_id){
198
+				if ($meta_id) {
199 199
 					$this->get_migration_script()->set_mapping($this->_old_table, $event_row['id'], $this->_new_meta_table, $meta_id);
200 200
 				}
201
-				$this->_convert_start_end_times($event_row,$post_id);
201
+				$this->_convert_start_end_times($event_row, $post_id);
202 202
 				$event_meta = maybe_unserialize($event_row['event_meta']);
203 203
 				$guid = isset($event_meta['event_thumbnail_url']) ? $event_meta['event_thumbnail_url'] : null;
204
-				$created_attachment_post = $this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid,$post_id,$this);
204
+				$created_attachment_post = $this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid, $post_id, $this);
205 205
 
206 206
 				//maybe create a venue from info on the event?
207 207
 				$new_venue_id = $this->_maybe_create_venue($event_row);
208
-				if($new_venue_id){
209
-					$this->_insert_new_venue_to_event($post_id,$new_venue_id);
208
+				if ($new_venue_id) {
209
+					$this->_insert_new_venue_to_event($post_id, $new_venue_id);
210 210
 				}
211 211
 				$this->_add_post_metas($event_row, $post_id);
212 212
 
213 213
 			}
214 214
 			$items_migrated_this_step++;
215
-			if($guid){
215
+			if ($guid) {
216 216
 				//if we had to check for an image attachment
217 217
 				//then let's call it a day (avoid timing out, because this took a long time)
218 218
 				break;
219 219
 			}
220 220
 		}
221
-		if($this->count_records_migrated() + $items_migrated_this_step >= $this->count_records_to_migrate()){
221
+		if ($this->count_records_migrated() + $items_migrated_this_step >= $this->count_records_to_migrate()) {
222 222
 			$this->set_status(EE_Data_Migration_Manager::status_completed);
223 223
 		}
224 224
 		return $items_migrated_this_step;
@@ -230,28 +230,28 @@  discard block
 block discarded – undo
230 230
 	 * @param type $post_id
231 231
 	 * @return void
232 232
 	 */
233
-	private function _add_post_metas($old_event,$post_id){
233
+	private function _add_post_metas($old_event, $post_id) {
234 234
 		$event_meta = maybe_unserialize($old_event['event_meta']);
235
-		if( ! $event_meta || ! is_array( $event_meta ) ){
235
+		if ( ! $event_meta || ! is_array($event_meta)) {
236 236
 			return;
237 237
 		}
238
-		unset($event_meta['date_submitted']);//factored into CPT
239
-		unset($event_meta['additional_attendee_reg_info']);//facotred into event meta table
240
-		unset($event_meta['default_payment_status']);//dido
241
-		unset($event_meta['event_thumbnail_url']);//used to find post featured image
242
-		foreach($event_meta as $meta_key => $meta_value){
243
-			if ($meta_key){//if th emeta key is just an empty string, ignore it
244
-				$success = add_post_meta($post_id,$meta_key,$meta_value,true);
245
-				if( ! $success ){
246
-					$this->add_error(sprintf(__("Could not add post meta for CPT with ID #%d. Meta key: '%s',meta value:'%d' for 3.1 event: %s", "event_espresso"),$post_id,$meta_key,$meta_value,implode(",",$old_event)));
238
+		unset($event_meta['date_submitted']); //factored into CPT
239
+		unset($event_meta['additional_attendee_reg_info']); //facotred into event meta table
240
+		unset($event_meta['default_payment_status']); //dido
241
+		unset($event_meta['event_thumbnail_url']); //used to find post featured image
242
+		foreach ($event_meta as $meta_key => $meta_value) {
243
+			if ($meta_key) {//if th emeta key is just an empty string, ignore it
244
+				$success = add_post_meta($post_id, $meta_key, $meta_value, true);
245
+				if ( ! $success) {
246
+					$this->add_error(sprintf(__("Could not add post meta for CPT with ID #%d. Meta key: '%s',meta value:'%d' for 3.1 event: %s", "event_espresso"), $post_id, $meta_key, $meta_value, implode(",", $old_event)));
247 247
 				}
248 248
 			}
249 249
 		}
250
-		if($old_event['alt_email']){
251
-			add_post_meta($post_id,'alt_email',$old_event['alt_email']);
250
+		if ($old_event['alt_email']) {
251
+			add_post_meta($post_id, 'alt_email', $old_event['alt_email']);
252 252
 		}
253
-		if($old_event['recurrence_id']){
254
-			add_post_meta($post_id,'recurrence_id',$old_event['recurrence_id']);
253
+		if ($old_event['recurrence_id']) {
254
+			add_post_meta($post_id, 'recurrence_id', $old_event['recurrence_id']);
255 255
 		}
256 256
 	}
257 257
 	/**
@@ -263,13 +263,13 @@  discard block
 block discarded – undo
263 263
 	 * @param string $new_post_status a post status
264 264
 	 * @return string
265 265
 	 */
266
-	private function _find_unique_slug($event_name, $old_identifier = '', $new_post_status = 'publish'){
266
+	private function _find_unique_slug($event_name, $old_identifier = '', $new_post_status = 'publish') {
267 267
 		$count = 0;
268 268
 		$original_name = $event_name ? sanitize_title($event_name) : $old_identifier;
269
-		return wp_unique_post_slug($original_name, 0, $new_post_status, 'espresso_events', 0 );
269
+		return wp_unique_post_slug($original_name, 0, $new_post_status, 'espresso_events', 0);
270 270
 	}
271 271
 
272
-	private function _insert_cpt($old_event){
272
+	private function _insert_cpt($old_event) {
273 273
 		global $wpdb;
274 274
 		//convert 3.1 event status to 4.1 CPT status
275 275
 		//for refrence, 3.1 event stati available for setting are:
@@ -288,55 +288,55 @@  discard block
 block discarded – undo
288 288
 //		and 3 custom ones: cancelled,postponed,sold_out
289 289
 		$status_conversions = array(
290 290
 			'R'=>'draft',
291
-			'X'=>'draft',//4.1 doesn't have a "not approved for publishing" status. this is what posts are set to that aren't approved
291
+			'X'=>'draft', //4.1 doesn't have a "not approved for publishing" status. this is what posts are set to that aren't approved
292 292
 			'P'=>'pending',
293
-			'IA'=>'draft',//draft and in the past
293
+			'IA'=>'draft', //draft and in the past
294 294
 //IA=inactive in 3.1: events were switched to this when they expired. in 4.1 that's just calculated
295
-			'O'=>'publish',//@todo: will be an event type later; if this is the status, set the end date WAAAY later; and add term for 'ongoing'
295
+			'O'=>'publish', //@todo: will be an event type later; if this is the status, set the end date WAAAY later; and add term for 'ongoing'
296 296
 			'A'=>'publish',
297
-			'S'=>'draft',//@todo: is it ok to just mark secondary/waitlist events as DRAFTS?
297
+			'S'=>'draft', //@todo: is it ok to just mark secondary/waitlist events as DRAFTS?
298 298
 			'D'=>'trash',
299 299
 		);
300 300
 		$post_status = $status_conversions[$old_event['event_status']];
301 301
 		//check if we've sold out
302
-		if (intval($old_event['reg_limit']) <= self::count_registrations($old_event['id'])){
302
+		if (intval($old_event['reg_limit']) <= self::count_registrations($old_event['id'])) {
303 303
 			$post_status = 'sold_out';
304 304
 		}
305 305
 //		FYI postponed and cancelled don't exist in 3.1
306 306
 		$cols_n_values = array(
307
-			'post_title'=>stripslashes($old_event['event_name']),//EVT_name
308
-			'post_content'=>stripslashes($old_event['event_desc']),//EVT_desc
309
-			'post_name'=>$this->_find_unique_slug($old_event['event_name'], $old_event['event_identifier'], $post_status ),//EVT_slug
310
-			'post_date'=>$old_event['submitted'],//EVT_created NOT
307
+			'post_title'=>stripslashes($old_event['event_name']), //EVT_name
308
+			'post_content'=>stripslashes($old_event['event_desc']), //EVT_desc
309
+			'post_name'=>$this->_find_unique_slug($old_event['event_name'], $old_event['event_identifier'], $post_status), //EVT_slug
310
+			'post_date'=>$old_event['submitted'], //EVT_created NOT
311 311
 			'post_date_gmt'=>get_gmt_from_date($old_event['submitted']),
312
-			'post_excerpt'=>'',//EVT_short_desc
313
-			'post_modified'=>$old_event['submitted'],//EVT_modified
312
+			'post_excerpt'=>'', //EVT_short_desc
313
+			'post_modified'=>$old_event['submitted'], //EVT_modified
314 314
 			'post_modified_gmt'=>get_gmt_from_date($old_event['submitted']),
315
-			'post_author'=>$old_event['wp_user'],//EVT_wp_user
316
-			'post_parent'=>0,//parent maybe get this from some REM field?
317
-			'menu_order'=>0,//EVT_order
318
-			'post_type'=>'espresso_events',//post_type
319
-			'post_status'=>$post_status,//status
315
+			'post_author'=>$old_event['wp_user'], //EVT_wp_user
316
+			'post_parent'=>0, //parent maybe get this from some REM field?
317
+			'menu_order'=>0, //EVT_order
318
+			'post_type'=>'espresso_events', //post_type
319
+			'post_status'=>$post_status, //status
320 320
 		);
321 321
 		$datatypes = array(
322
-			'%s',//EVT_name
323
-			'%s',//EVT_desc
324
-			'%s',//EVT_slug
325
-			'%s',//EVT_created
322
+			'%s', //EVT_name
323
+			'%s', //EVT_desc
324
+			'%s', //EVT_slug
325
+			'%s', //EVT_created
326 326
 			'%s',
327
-			'%s',//EVT_short_desc
328
-			'%s',//EVT_modified
327
+			'%s', //EVT_short_desc
328
+			'%s', //EVT_modified
329 329
 			'%s',
330
-			'%s',//EVT_wp_user
331
-			'%d',//post_parent
332
-			'%d',//EVT_order
333
-			'%s',//post_type
334
-			'%s',//status
330
+			'%s', //EVT_wp_user
331
+			'%d', //post_parent
332
+			'%d', //EVT_order
333
+			'%s', //post_type
334
+			'%s', //status
335 335
 		);
336 336
 		$success = $wpdb->insert($this->_new_table,
337 337
 				$cols_n_values,
338 338
 				$datatypes);
339
-		if( ! $success ){
339
+		if ( ! $success) {
340 340
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_event, $this->_new_table, $cols_n_values, $datatypes));
341 341
 			return 0;
342 342
 		}
@@ -349,13 +349,13 @@  discard block
 block discarded – undo
349 349
 	 * @param type $event_id
350 350
 	 * @return int
351 351
 	 */
352
-	public static function count_registrations($event_id){
352
+	public static function count_registrations($event_id) {
353 353
 		global $wpdb;
354
-		$count = $wpdb->get_var($wpdb->prepare("SELECT sum(quantity) FROM {$wpdb->prefix}events_attendee WHERE event_id=%d",$event_id));
354
+		$count = $wpdb->get_var($wpdb->prepare("SELECT sum(quantity) FROM {$wpdb->prefix}events_attendee WHERE event_id=%d", $event_id));
355 355
 		return intval($count);
356 356
 	}
357 357
 
358
-	private function _insert_event_meta($old_event,$new_cpt_id){
358
+	private function _insert_event_meta($old_event, $new_cpt_id) {
359 359
 		global $wpdb;
360 360
 		$event_meta = maybe_unserialize($old_event['event_meta']);
361 361
 //		for reference, 3.1 'default_payment_status' are: $default_payment_status = array(
@@ -366,10 +366,10 @@  discard block
 block discarded – undo
366 366
 //);
367 367
 		$default_reg_status = $this->get_migration_script()->convert_3_1_payment_status_to_4_1_STS_ID(isset($event_meta['default_payment_status']) ? $event_meta['default_payment_status'] : '', intval($old_event['require_pre_approval']));
368 368
 		$cols_n_values = array(
369
-			'EVT_ID'=>$new_cpt_id,//EVT_ID_fk
369
+			'EVT_ID'=>$new_cpt_id, //EVT_ID_fk
370 370
 			'EVT_display_desc'=> 'Y' == $old_event['display_desc'],
371
-			'EVT_display_ticket_selector'=> 'Y'== $old_event['display_reg_form'],
372
-			'EVT_visible_on'=> $this->get_migration_script()->convert_date_string_to_utc($this,$old_event,current_time('mysql'),$old_event['timezone_string']),//don't use the old 'visible_on', as it wasnt ever used
371
+			'EVT_display_ticket_selector'=> 'Y' == $old_event['display_reg_form'],
372
+			'EVT_visible_on'=> $this->get_migration_script()->convert_date_string_to_utc($this, $old_event, current_time('mysql'), $old_event['timezone_string']), //don't use the old 'visible_on', as it wasnt ever used
373 373
 			'EVT_additional_limit'=> $old_event['allow_multiple'] == 'N' ? 1 : $old_event['additional_limit'],
374 374
 			'EVT_default_registration_status' => $default_reg_status,
375 375
 			'EVT_member_only'=>$old_event['member_only'],
@@ -381,31 +381,31 @@  discard block
 block discarded – undo
381 381
 
382 382
 		);
383 383
 		$datatypes = array(
384
-			'%s',//EVT_ID
385
-			'%d',//EVT_display_desc
386
-			'%d',//EVT_display_ticket_selector
387
-			'%s',//EVT_visible_on
388
-			'%d',//EVT_additional_limit
389
-			'%s',//EVT_default_registration_status
390
-			'%d',//EVT_member_only
391
-			'%s',//EVT_phone
392
-			'%d',//EVT_allow_overflow
393
-			'%s',//EVT_timezone_string
394
-			'%s',//EVT_external_URL
395
-			'%d',//EVT_donations
384
+			'%s', //EVT_ID
385
+			'%d', //EVT_display_desc
386
+			'%d', //EVT_display_ticket_selector
387
+			'%s', //EVT_visible_on
388
+			'%d', //EVT_additional_limit
389
+			'%s', //EVT_default_registration_status
390
+			'%d', //EVT_member_only
391
+			'%s', //EVT_phone
392
+			'%d', //EVT_allow_overflow
393
+			'%s', //EVT_timezone_string
394
+			'%s', //EVT_external_URL
395
+			'%d', //EVT_donations
396 396
 		);
397 397
 		$success = $wpdb->insert($this->_new_meta_table,
398 398
 				$cols_n_values,
399 399
 				$datatypes);
400
-		if( ! $success ){
400
+		if ( ! $success) {
401 401
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_event, $this->_new_meta_table, $cols_n_values, $datatypes));
402 402
 			return 0;
403 403
 		}
404 404
 		return $wpdb->insert_id;
405 405
 	}
406 406
 
407
-	private function _maybe_create_venue($old_event){
408
-		if(		$old_event['address'] ||
407
+	private function _maybe_create_venue($old_event) {
408
+		if ($old_event['address'] ||
409 409
 				$old_event['address2'] ||
410 410
 				$old_event['city'] ||
411 411
 				$old_event['state'] ||
@@ -416,21 +416,21 @@  discard block
 block discarded – undo
416 416
 				$old_event['venue_phone'] ||
417 417
 				$old_event['virtual_url'] ||
418 418
 				$old_event['virtual_phone']
419
-				){
420
-			$old_id = $this->_duplicate_venue_exists( $old_event );
421
-			if( $old_id ){
419
+				) {
420
+			$old_id = $this->_duplicate_venue_exists($old_event);
421
+			if ($old_id) {
422 422
 				return $old_id;
423 423
 			}
424 424
 			$new_id = $this->_insert_venue_into_posts($old_event);
425
-			if( $new_id ){
425
+			if ($new_id) {
426 426
 				$this->_insert_venue_into_meta_table($new_id, $old_event);
427
-				$guid = isset($old_event['venue_image']) ? $old_event['venue_image']  : null;
428
-				$this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid, $new_id,$this);
427
+				$guid = isset($old_event['venue_image']) ? $old_event['venue_image'] : null;
428
+				$this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid, $new_id, $this);
429 429
 			}
430 430
 			//we don't bother recording the conversion from old events to venues as that
431 431
 			//will complicate finding the conversion from old venues to new events
432 432
 			return $new_id;
433
-		}else{
433
+		} else {
434 434
 			return 0;
435 435
 		}
436 436
 	}
@@ -441,29 +441,29 @@  discard block
 block discarded – undo
441 441
 	 * @param array $old_event
442 442
 	 * @return int duplicate venue id
443 443
 	 */
444
-	private function _duplicate_venue_exists($old_event){
444
+	private function _duplicate_venue_exists($old_event) {
445 445
 		global $wpdb;
446 446
 		$conditions = array(
447
-			'VNU_address' => $old_event [ 'address' ],
448
-			'VNU_address2' => $old_event[ 'address2' ],
449
-			'VNU_city' => $old_event[ 'city' ],
450
-			'VNU_zip' => $old_event[ 'zip' ],
451
-			'post_title'=> $this->_get_venue_title_for_event( $old_event ),
452
-			'VNU_phone'=>$old_event['venue_phone'],//VNU_phone
453
-			'VNU_url'=>$old_event['venue_url'],//VNU_url
454
-			'VNU_virtual_phone'=>$old_event['virtual_phone'],//VNU_virtual_phone
455
-			'VNU_virtual_url'=>$old_event['virtual_url'],//VNU_virtual_url
447
+			'VNU_address' => $old_event ['address'],
448
+			'VNU_address2' => $old_event['address2'],
449
+			'VNU_city' => $old_event['city'],
450
+			'VNU_zip' => $old_event['zip'],
451
+			'post_title'=> $this->_get_venue_title_for_event($old_event),
452
+			'VNU_phone'=>$old_event['venue_phone'], //VNU_phone
453
+			'VNU_url'=>$old_event['venue_url'], //VNU_url
454
+			'VNU_virtual_phone'=>$old_event['virtual_phone'], //VNU_virtual_phone
455
+			'VNU_virtual_url'=>$old_event['virtual_url'], //VNU_virtual_url
456 456
 		);
457 457
 		$sql_conditions = array();
458
-		foreach($conditions as $column => $value){
458
+		foreach ($conditions as $column => $value) {
459 459
 			$sql_conditions [] = "$column = '$value'";
460 460
 		}
461 461
 		$query = "SELECT VNU_ID
462 462
 					FROM
463 463
 		{$wpdb->posts} as p INNER JOIN
464 464
 		{$wpdb->prefix}esp_venue_meta as v ON p.ID = v.VNU_ID
465
-			WHERE " . implode( " AND ",$sql_conditions ) . " LIMIT 1";
466
-		$id = $wpdb->get_var( $query );
465
+			WHERE ".implode(" AND ", $sql_conditions)." LIMIT 1";
466
+		$id = $wpdb->get_var($query);
467 467
 		return $id;
468 468
 	}
469 469
 	
@@ -472,8 +472,8 @@  discard block
 block discarded – undo
472 472
 	 * @param array $event_data_array keys are events_details columns and valuesa re their values
473 473
 	 * @return string
474 474
 	 */
475
-	protected function _get_venue_title_for_event( $event_data_array ) {
476
-		return $event_data_array['venue_title'] ? stripslashes($event_data_array['venue_title']) : stripslashes( sprintf( __( 'Venue of %s', 'event_espresso' ), $event_data_array['event_name']));
475
+	protected function _get_venue_title_for_event($event_data_array) {
476
+		return $event_data_array['venue_title'] ? stripslashes($event_data_array['venue_title']) : stripslashes(sprintf(__('Venue of %s', 'event_espresso'), $event_data_array['event_name']));
477 477
 	}
478 478
 
479 479
 	/**
@@ -481,40 +481,40 @@  discard block
 block discarded – undo
481 481
 	 * @param array $old_venue keys are cols, values are col values
482 482
 	 * @return int
483 483
 	 */
484
-	private function _insert_venue_into_posts($old_event){
484
+	private function _insert_venue_into_posts($old_event) {
485 485
 		global $wpdb;
486 486
 		$insertion_array = array(
487
-					'post_title'=> $this->_get_venue_title_for_event( $old_event ),//VNU_name
488
-					'post_content'=>'',//VNU_desc
489
-					'post_name'=> $this->_find_unique_slug( $old_event['venue_title'], sanitize_title( 'venue-of-' . $old_event['event_name'] ) ),//VNU_identifier
490
-					'post_date'=>current_time('mysql'),//VNU_created
487
+					'post_title'=> $this->_get_venue_title_for_event($old_event), //VNU_name
488
+					'post_content'=>'', //VNU_desc
489
+					'post_name'=> $this->_find_unique_slug($old_event['venue_title'], sanitize_title('venue-of-'.$old_event['event_name'])), //VNU_identifier
490
+					'post_date'=>current_time('mysql'), //VNU_created
491 491
 					'post_date_gmt'=>get_gmt_from_date(current_time('mysql')),
492
-					'post_excerpt'=>'',//VNU_short_desc arbitraty only 50 characters
493
-					'post_modified'=>current_time('mysql'),//VNU_modified
492
+					'post_excerpt'=>'', //VNU_short_desc arbitraty only 50 characters
493
+					'post_modified'=>current_time('mysql'), //VNU_modified
494 494
 					'post_modified_gmt'=>get_gmt_from_date(current_time('mysql')),
495
-					'post_author'=>$old_event['wp_user'],//VNU_wp_user
496
-					'post_parent'=>0,//parent
497
-					'menu_order'=>0,//VNU_order
495
+					'post_author'=>$old_event['wp_user'], //VNU_wp_user
496
+					'post_parent'=>0, //parent
497
+					'menu_order'=>0, //VNU_order
498 498
 					'post_type'=>'espresso_venues'//post_type
499 499
 				);
500 500
 		$datatypes_array = array(
501
-					'%s',//VNU_name
502
-					'%s',//VNU_desc
503
-					'%s',//VNU_identifier
504
-					'%s',//VNU_created
501
+					'%s', //VNU_name
502
+					'%s', //VNU_desc
503
+					'%s', //VNU_identifier
504
+					'%s', //VNU_created
505 505
 					'%s',
506
-					'%s',//VNU_short_desc
507
-					'%s',//VNU_modified
506
+					'%s', //VNU_short_desc
507
+					'%s', //VNU_modified
508 508
 					'%s',
509
-					'%d',//VNU_wp_user
510
-					'%d',//parent
511
-					'%d',//VNU_order
512
-					'%s',//post_type
509
+					'%d', //VNU_wp_user
510
+					'%d', //parent
511
+					'%d', //VNU_order
512
+					'%s', //post_type
513 513
 				);
514 514
 		$success = $wpdb->insert($wpdb->posts,
515 515
 				$insertion_array,
516 516
 				$datatypes_array);
517
-		if( ! $success ){
517
+		if ( ! $success) {
518 518
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_venue, $this->_new_table, $insertion_array, $datatypes_array));
519 519
 			return 0;
520 520
 		}
@@ -527,78 +527,78 @@  discard block
 block discarded – undo
527 527
 	 * @param type $old_event
528 528
 	 * @return int
529 529
 	 */
530
-	private function _insert_venue_into_meta_table($cpt_id,$old_event){
530
+	private function _insert_venue_into_meta_table($cpt_id, $old_event) {
531 531
 		global $wpdb;
532 532
 
533 533
 		//assume the country is the same as the organization's old settings
534 534
 		$country_iso = $this->get_migration_script()->get_default_country_iso();
535 535
 		//find the state from the venue, or the organization, or just guess california
536
-		if( ! $old_event['state']){
536
+		if ( ! $old_event['state']) {
537 537
 			$old_org_options = get_option('events_organization_settings');
538 538
 			$state_name = stripslashes($old_org_options['organization_state']);
539
-		}else{
539
+		} else {
540 540
 			$state_name = $old_event['state'];
541 541
 		}
542
-		if ( ! $state_name ){
542
+		if ( ! $state_name) {
543 543
 			$state_name = 'CA';
544 544
 		}
545 545
 		//get a state ID with the same name, if possible
546
-		try{
547
-			$state = $this->get_migration_script()->get_or_create_state($state_name,$country_iso);
546
+		try {
547
+			$state = $this->get_migration_script()->get_or_create_state($state_name, $country_iso);
548 548
 			$state_id = $state['STA_ID'];
549
-		}catch(EE_Error $e){
549
+		} catch (EE_Error $e) {
550 550
 			$this->add_error($e->getMessage());
551 551
 			$state_id = 0;
552 552
 		}
553 553
 		//now insert into meta table
554 554
 		$insertion_array = array(
555
-			'VNU_ID'=>$cpt_id,//VNU_ID_fk
556
-			'VNU_address'=>stripslashes($old_event['address']),//VNU_address
557
-			'VNU_address2'=>stripslashes($old_event['address2']),//VNU_address2
558
-			'VNU_city'=>stripslashes($old_event['city']),//VNU_city
559
-			'STA_ID'=>$state_id,//STA_ID
560
-			'CNT_ISO'=>$country_iso,//CNT_ISO
561
-			'VNU_zip'=>$old_event['zip'],//VNU_zip
562
-			'VNU_phone'=>$old_event['venue_phone'],//VNU_phone
563
-			'VNU_capacity'=>-1,//VNU_capacity
564
-			'VNU_url'=>$old_event['venue_url'],//VNU_url
565
-			'VNU_virtual_phone'=>$old_event['virtual_phone'],//VNU_virtual_phone
566
-			'VNU_virtual_url'=>$old_event['virtual_url'],//VNU_virtual_url
567
-			'VNU_google_map_link'=>'',//VNU_google_map_link
555
+			'VNU_ID'=>$cpt_id, //VNU_ID_fk
556
+			'VNU_address'=>stripslashes($old_event['address']), //VNU_address
557
+			'VNU_address2'=>stripslashes($old_event['address2']), //VNU_address2
558
+			'VNU_city'=>stripslashes($old_event['city']), //VNU_city
559
+			'STA_ID'=>$state_id, //STA_ID
560
+			'CNT_ISO'=>$country_iso, //CNT_ISO
561
+			'VNU_zip'=>$old_event['zip'], //VNU_zip
562
+			'VNU_phone'=>$old_event['venue_phone'], //VNU_phone
563
+			'VNU_capacity'=>-1, //VNU_capacity
564
+			'VNU_url'=>$old_event['venue_url'], //VNU_url
565
+			'VNU_virtual_phone'=>$old_event['virtual_phone'], //VNU_virtual_phone
566
+			'VNU_virtual_url'=>$old_event['virtual_url'], //VNU_virtual_url
567
+			'VNU_google_map_link'=>'', //VNU_google_map_link
568 568
 			'VNU_enable_for_gmap'=>true	//VNU_enable_for_gmap
569 569
 		);
570 570
 		$datatypes = array(
571
-			'%d',//VNU_ID_fk
572
-			'%s',//VNU_address
573
-			'%s',//VNU_address2
574
-			'%s',//VNU_city
575
-			'%d',//STA_ID
576
-			'%s',//CNT_ISO
577
-			'%s',//VNU_zip
578
-			'%s',//VNU_phone
579
-			'%d',//VNU_capacity
580
-			'%s',//VNU_url
581
-			'%s',//VNU_virtual_phone
582
-			'%s',//VNU_virtual_url
583
-			'%s',//VNU_google_map_link
584
-			'%d',//VNU_enable_for_gmap
571
+			'%d', //VNU_ID_fk
572
+			'%s', //VNU_address
573
+			'%s', //VNU_address2
574
+			'%s', //VNU_city
575
+			'%d', //STA_ID
576
+			'%s', //CNT_ISO
577
+			'%s', //VNU_zip
578
+			'%s', //VNU_phone
579
+			'%d', //VNU_capacity
580
+			'%s', //VNU_url
581
+			'%s', //VNU_virtual_phone
582
+			'%s', //VNU_virtual_url
583
+			'%s', //VNU_google_map_link
584
+			'%d', //VNU_enable_for_gmap
585 585
 		);
586
-		$success = $wpdb->insert($wpdb->prefix."esp_venue_meta",$insertion_array,$datatypes);
587
-		if( ! $success ){
586
+		$success = $wpdb->insert($wpdb->prefix."esp_venue_meta", $insertion_array, $datatypes);
587
+		if ( ! $success) {
588 588
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_event, $this->_new_meta_table, $insertion_array, $datatypes));
589 589
 			return 0;
590 590
 		}
591 591
 		return $wpdb->insert_id;
592 592
 	}
593 593
 
594
-	private function _insert_new_venue_to_event($new_event_id,$new_venue_id){
594
+	private function _insert_new_venue_to_event($new_event_id, $new_venue_id) {
595 595
 		global $wpdb;
596
-		if( ! $new_event_id){
597
-			$this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"),$new_event_id));
596
+		if ( ! $new_event_id) {
597
+			$this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"), $new_event_id));
598 598
 			return 0;
599 599
 		}
600
-		if( ! $new_venue_id){
601
-			$this->add_error(sprintf(__("Could not find 4.1 venue id for 3.1 venue #%d.", "event_espresso"),$new_venue_id));
600
+		if ( ! $new_venue_id) {
601
+			$this->add_error(sprintf(__("Could not find 4.1 venue id for 3.1 venue #%d.", "event_espresso"), $new_venue_id));
602 602
 			return 0;
603 603
 		}
604 604
 		$cols_n_values = array(
@@ -607,12 +607,12 @@  discard block
 block discarded – undo
607 607
 			'EVV_primary'=>true
608 608
 		);
609 609
 		$datatypes = array(
610
-			'%d',//EVT_ID
611
-			'%d',//VNU_ID
612
-			'%d',//EVT_primary
610
+			'%d', //EVT_ID
611
+			'%d', //VNU_ID
612
+			'%d', //EVT_primary
613 613
 		);
614
-		$success = $wpdb->insert($wpdb->prefix."esp_event_venue",$cols_n_values,$datatypes);
615
-		if ( ! $success){
614
+		$success = $wpdb->insert($wpdb->prefix."esp_event_venue", $cols_n_values, $datatypes);
615
+		if ( ! $success) {
616 616
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_event_venue_rel, $this->_new_table, $cols_n_values, $datatypes));
617 617
 			return 0;
618 618
 		}
@@ -626,11 +626,11 @@  discard block
 block discarded – undo
626 626
 	 * @param int $new_cpt_id new post ID
627 627
 	 * @return void (if there are errors though, adds them to the stage's error list
628 628
 	 */
629
-	private function _convert_start_end_times($old_event,$new_cpt_id){
629
+	private function _convert_start_end_times($old_event, $new_cpt_id) {
630 630
 		$start_end_times = $this->_get_old_start_end_times($old_event['id']);
631
-		foreach($start_end_times as $start_end_time){
632
-			$datetime_id = $this->_insert_new_datetime($start_end_time,$old_event,$new_cpt_id);
633
-			if($datetime_id){
631
+		foreach ($start_end_times as $start_end_time) {
632
+			$datetime_id = $this->_insert_new_datetime($start_end_time, $old_event, $new_cpt_id);
633
+			if ($datetime_id) {
634 634
 				$this->get_migration_script()->set_mapping($this->_old_start_end_table, $start_end_time['id'], $this->_new_datetime_table, $datetime_id);
635 635
 			}
636 636
 		}
@@ -641,9 +641,9 @@  discard block
 block discarded – undo
641 641
 	 * @param type $old_event_id
642 642
 	 * @return type
643 643
 	 */
644
-	private function _get_old_start_end_times($old_event_id){
644
+	private function _get_old_start_end_times($old_event_id) {
645 645
 		global $wpdb;
646
-		return $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_start_end_table WHERE event_id=%d",$old_event_id),ARRAY_A);
646
+		return $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_start_end_table WHERE event_id=%d", $old_event_id), ARRAY_A);
647 647
 	}
648 648
 	/**
649 649
 	 * Inserts a 4.1 datetime given the 3.1 start_end db row and event_details row
@@ -652,40 +652,40 @@  discard block
 block discarded – undo
652 652
 	 * @param type $new_cpt_id
653 653
 	 * @return int ID of new datetime
654 654
 	 */
655
-	private function _insert_new_datetime($start_end_time_row,$old_event_row,$new_cpt_id){
655
+	private function _insert_new_datetime($start_end_time_row, $old_event_row, $new_cpt_id) {
656 656
 		global $wpdb;
657 657
 		$start_date = $old_event_row['start_date'];
658 658
 		$start_time = $this->get_migration_script()->convertTimeFromAMPM($start_end_time_row['start_time']);
659 659
 		$end_date = $old_event_row['end_date'];
660 660
 		$end_time = $this->get_migration_script()->convertTimeFromAMPM($start_end_time_row['end_time']);
661 661
 		$existing_datetimes = $this->_count_other_datetimes_exist_for_new_event($new_cpt_id);
662
-		$start_datetime_utc = $this->get_migration_script()->convert_date_string_to_utc($this,$start_end_time_row,"$start_date $start_time:00",$old_event_row['timezone_string']);
663
-		$end_datetime_utc = $this->get_migration_script()->convert_date_string_to_utc($this,$start_end_time_row,"$end_date $end_time:00",$old_event_row['timezone_string']);
662
+		$start_datetime_utc = $this->get_migration_script()->convert_date_string_to_utc($this, $start_end_time_row, "$start_date $start_time:00", $old_event_row['timezone_string']);
663
+		$end_datetime_utc = $this->get_migration_script()->convert_date_string_to_utc($this, $start_end_time_row, "$end_date $end_time:00", $old_event_row['timezone_string']);
664 664
 		$cols_n_values = array(
665
-			'EVT_ID'=>$new_cpt_id,//EVT_ID
666
-			'DTT_EVT_start'=>$start_datetime_utc,//DTT_EVT_start
667
-			'DTT_EVT_end'=> $end_datetime_utc,//DTT_EVT_end
668
-			'DTT_reg_limit'=>intval($start_end_time_row['reg_limit']) ? $start_end_time_row['reg_limit'] : $old_event_row['reg_limit'],//DTT_reg_limit
669
-			'DTT_sold'=>0,//note: we will increment this as registrations are added during the migration
665
+			'EVT_ID'=>$new_cpt_id, //EVT_ID
666
+			'DTT_EVT_start'=>$start_datetime_utc, //DTT_EVT_start
667
+			'DTT_EVT_end'=> $end_datetime_utc, //DTT_EVT_end
668
+			'DTT_reg_limit'=>intval($start_end_time_row['reg_limit']) ? $start_end_time_row['reg_limit'] : $old_event_row['reg_limit'], //DTT_reg_limit
669
+			'DTT_sold'=>0, //note: we will increment this as registrations are added during the migration
670 670
 //			'DTT_is_primary'=> 0 == $existing_datetimes ,//DTT_is_primary... if count==0, then we'll call it the 'primary'
671
-			'DTT_order'=> $existing_datetimes,//DTT_order, just give it the same order as the count of how many datetimes already exist
671
+			'DTT_order'=> $existing_datetimes, //DTT_order, just give it the same order as the count of how many datetimes already exist
672 672
 			'DTT_parent'=>0,
673 673
 			'DTT_deleted'=>false
674 674
 		);
675 675
 		$datatypes = array(
676
-			'%d',//EVT_Id
677
-			'%s',//DTT_EVT_start
678
-			'%s',//DTT_EVT_end
679
-			'%d',//DTT_reg_limit
680
-			'%d',//DTT_sold
676
+			'%d', //EVT_Id
677
+			'%s', //DTT_EVT_start
678
+			'%s', //DTT_EVT_end
679
+			'%d', //DTT_reg_limit
680
+			'%d', //DTT_sold
681 681
 //			'%d',//DTT_is_primary
682
-			'%d',//DTT_order
683
-			'%d',//DTT_parent
684
-			'%d',//DTT_deleted
682
+			'%d', //DTT_order
683
+			'%d', //DTT_parent
684
+			'%d', //DTT_deleted
685 685
 		);
686
-		$success = $wpdb->insert($this->_new_datetime_table,$cols_n_values,$datatypes);
687
-		if ( ! $success){
688
-			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_start_end_table, array_merge($old_event_row,$start_end_time_row), $this->_new_datetime_table, $cols_n_values, $datatypes));
686
+		$success = $wpdb->insert($this->_new_datetime_table, $cols_n_values, $datatypes);
687
+		if ( ! $success) {
688
+			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_start_end_table, array_merge($old_event_row, $start_end_time_row), $this->_new_datetime_table, $cols_n_values, $datatypes));
689 689
 			return 0;
690 690
 		}
691 691
 		return $wpdb->insert_id;
@@ -698,9 +698,9 @@  discard block
 block discarded – undo
698 698
 	 * @param type $cpt_event_id
699 699
 	 * @return int
700 700
 	 */
701
-	private function _count_other_datetimes_exist_for_new_event($cpt_event_id){
701
+	private function _count_other_datetimes_exist_for_new_event($cpt_event_id) {
702 702
 		global $wpdb;
703
-		$count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM $this->_new_datetime_table WHERE EVT_ID=%d",$cpt_event_id));
703
+		$count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM $this->_new_datetime_table WHERE EVT_ID=%d", $cpt_event_id));
704 704
 		return intval($count);
705 705
 	}
706 706
 
Please login to merge, or discard this patch.
core/data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_gateways.dmsstage.php 3 patches
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -77,7 +77,7 @@
 block discarded – undo
77 77
  * Takes the old array of 3.1 gateway settings for this gateway and converts it
78 78
  * into an array with all the 4.1 gateway setting array keys (often the keys were
79 79
  * changed from 3.1 to 4.1)
80
- * @param array $old_gateway_settings
80
+ * @param string $old_gateway_settings
81 81
  * @param string $new_gateway_slug
82 82
  * @return array
83 83
  */
Please login to merge, or discard this patch.
Spacing   +27 added lines, -27 removed lines patch added patch discarded remove patch
@@ -11,52 +11,52 @@  discard block
 block discarded – undo
11 11
  * which are both arrays
12 12
  * -a function named update_espresso_config() which saves the EE_Config object to the database
13 13
  */
14
-class EE_DMS_4_1_0_gateways extends EE_Data_Migration_Script_Stage{
14
+class EE_DMS_4_1_0_gateways extends EE_Data_Migration_Script_Stage {
15 15
 
16 16
 private $_converted_active_gateways = false;
17 17
 
18
-function _migration_step($num_items=50){
18
+function _migration_step($num_items = 50) {
19 19
 	//loads existing EE_CONfig from DB, if it exists
20 20
 	$new_gateway_config_obj = EE_Config::instance()->gateway;
21 21
 	$items_actually_migrated = 0;
22 22
 	//convert settings
23
-	$gateways_to_deal_with = array_merge($this->_gateways_we_know_how_to_migrate,$this->_gateways_we_leave_alone);
23
+	$gateways_to_deal_with = array_merge($this->_gateways_we_know_how_to_migrate, $this->_gateways_we_leave_alone);
24 24
 	//just do a part of them on this request
25
-	$gateways_to_deal_with = array_slice($gateways_to_deal_with,$this->count_records_migrated(),$num_items);// $this->_gateways_we_know_how_to_migrate;
26
-	foreach($gateways_to_deal_with as $old_gateway_slug => $new_gateway_slug){
25
+	$gateways_to_deal_with = array_slice($gateways_to_deal_with, $this->count_records_migrated(), $num_items); // $this->_gateways_we_know_how_to_migrate;
26
+	foreach ($gateways_to_deal_with as $old_gateway_slug => $new_gateway_slug) {
27 27
 		$old_gateway_wp_option_name = $this->_get_old_gateway_option_name($new_gateway_slug);
28
-		if(isset($this->_gateways_we_know_how_to_migrate[$old_gateway_slug])){
28
+		if (isset($this->_gateways_we_know_how_to_migrate[$old_gateway_slug])) {
29 29
 			//determine the old option's name
30 30
 			$old_gateway_settings = $this->_get_old_gateway_option($new_gateway_slug);
31
-			if( ! $old_gateway_settings){
31
+			if ( ! $old_gateway_settings) {
32 32
 				//no settings existed for this gateway anyways... weird...
33 33
 				$items_actually_migrated++;
34 34
 				continue;
35 35
 			}
36 36
 			//now prepare the settings to make sure they're in the 4.1 format
37
-			$new_gateway_settings = $this->_convert_gateway_settings($old_gateway_settings,$new_gateway_slug);
37
+			$new_gateway_settings = $this->_convert_gateway_settings($old_gateway_settings, $new_gateway_slug);
38 38
 			$new_gateway_config_obj->payment_settings[$new_gateway_slug] = $new_gateway_settings;
39 39
 			//and when we're done, remove the old option. Sometimes we'd prefer to do this in a different stage, but
40 40
 			//I think it's ok to do right away this time (we wont need gateway settings elsewhere)
41 41
 			delete_option($old_gateway_wp_option_name);
42
-		}else{//it must be one of the ones we mostly leave alone
42
+		} else {//it must be one of the ones we mostly leave alone
43 43
 			global $wpdb;
44 44
 			//yeah we could do this all in one query... and if you're reading this and would liek to, go ahead. Although you'll
45 45
 			//only be saving users 50 milliseconds the one time this runs...
46
-			$wpdb->query($wpdb->prepare("UPDATE ".$wpdb->options." SET autoload='no' WHERE option_name=%s",$old_gateway_wp_option_name));
46
+			$wpdb->query($wpdb->prepare("UPDATE ".$wpdb->options." SET autoload='no' WHERE option_name=%s", $old_gateway_wp_option_name));
47 47
 		}
48 48
 		
49 49
 		$items_actually_migrated++;
50 50
 	}
51 51
 	//if we can keep going, and it hasn' tbeen done yet, convert active gateways
52
-	if($items_actually_migrated < $num_items &&  ! $this->_converted_active_gateways){
52
+	if ($items_actually_migrated < $num_items && ! $this->_converted_active_gateways) {
53 53
 		$this->_convert_active_gateways();
54 54
 		$this->_converted_active_gateways = true;
55 55
 		$items_actually_migrated++;
56 56
 	}
57 57
 	
58
-	EE_Config::instance()->update_espresso_config(false,false);
59
-	if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
58
+	EE_Config::instance()->update_espresso_config(false, false);
59
+	if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
60 60
 		$this->set_completed();
61 61
 	}
62 62
 	return $items_actually_migrated;
@@ -66,7 +66,7 @@  discard block
 block discarded – undo
66 66
 	$step_of_setting_active_gateways = 1;
67 67
 	$count_of_gateways_to_leave_alone = count($this->_gateways_we_leave_alone);
68 68
 //	$button_images_to_update = 
69
-	return $count_of_gateways_to_convert +  $step_of_setting_active_gateways + $count_of_gateways_to_leave_alone;
69
+	return $count_of_gateways_to_convert + $step_of_setting_active_gateways + $count_of_gateways_to_leave_alone;
70 70
 }
71 71
 function __construct() {
72 72
 	$this->_pretty_name = __("Gateways", "event_espresso");
@@ -81,9 +81,9 @@  discard block
 block discarded – undo
81 81
  * @param string $new_gateway_slug
82 82
  * @return array
83 83
  */
84
-private function _convert_gateway_settings($old_gateway_settings,$new_gateway_slug){
84
+private function _convert_gateway_settings($old_gateway_settings, $new_gateway_slug) {
85 85
 	$new_gateway_settings = $old_gateway_settings;
86
-	switch($new_gateway_slug){
86
+	switch ($new_gateway_slug) {
87 87
 			case 'Bank':
88 88
 				$new_gateway_settings['account_number'] = $old_gateway_settings['bank_account'];
89 89
 				$new_gateway_settings['page_title'] = $old_gateway_settings['bank_title'];
@@ -96,7 +96,7 @@  discard block
 block discarded – undo
96 96
 				$new_gateway_settings['username'] = $old_gateway_settings['paypal_api_username'];
97 97
 				$new_gateway_settings['password'] = $old_gateway_settings['paypal_api_password'];
98 98
 				$new_gateway_settings['signature'] = $old_gateway_settings['paypal_api_signature'];
99
-				$new_gateway_settings['credit_cards'] = explode(",",$old_gateway_settings['paypal_api_credit_cards']);
99
+				$new_gateway_settings['credit_cards'] = explode(",", $old_gateway_settings['paypal_api_credit_cards']);
100 100
 				$new_gateway_settings['use_sandbox'] = $old_gateway_settings['paypal_pro_use_sandbox'];
101 101
 				break;
102 102
 		}
@@ -107,9 +107,9 @@  discard block
 block discarded – undo
107 107
  * @param string $new_gateway_slug
108 108
  * @return string
109 109
  */
110
-private function _get_old_gateway_option($new_gateway_slug){
110
+private function _get_old_gateway_option($new_gateway_slug) {
111 111
 	$option_name = $this->_get_old_gateway_option_name($new_gateway_slug);
112
-	$settings =  get_option($option_name, NULL);
112
+	$settings = get_option($option_name, NULL);
113 113
 //	if( ! $settings){
114 114
 //		$this->add_error(sprintf(__("There is no wordpress option named %s for gateway %s", "event_espresso"),$option_name,$new_gateway_slug));
115 115
 //	}
@@ -121,12 +121,12 @@  discard block
 block discarded – undo
121 121
  * @param string $new_gateway_slug
122 122
  * @return string
123 123
  */
124
-private function _get_old_gateway_option_name($new_gateway_slug){
125
-	$new_gateway_slugs_to_new = array_flip(array_merge($this->_gateways_we_know_how_to_migrate,$this->_gateways_we_leave_alone));
124
+private function _get_old_gateway_option_name($new_gateway_slug) {
125
+	$new_gateway_slugs_to_new = array_flip(array_merge($this->_gateways_we_know_how_to_migrate, $this->_gateways_we_leave_alone));
126 126
 	$old_gateway_slug = $new_gateway_slugs_to_new[$new_gateway_slug];
127 127
 	$normal_option_prefix = 'event_espresso_';
128 128
 	$normal_option_postfix = '_settings';
129
-	switch($new_gateway_slug){
129
+	switch ($new_gateway_slug) {
130 130
 		case 'Bank':
131 131
 			$option_name = $normal_option_prefix.'bank_deposit'.$normal_option_postfix;
132 132
 			break;
@@ -152,18 +152,18 @@  discard block
 block discarded – undo
152 152
 			$option_name = 'espresso_usaepay_onsite'.$normal_option_postfix;
153 153
 			break;
154 154
 		default:
155
-			$option_name = apply_filters( 'FHEE__EE_DMS_4_1_0_gateways__get_old_gateway_option',$normal_option_prefix.$old_gateway_slug.$normal_option_postfix );
155
+			$option_name = apply_filters('FHEE__EE_DMS_4_1_0_gateways__get_old_gateway_option', $normal_option_prefix.$old_gateway_slug.$normal_option_postfix);
156 156
 	}
157 157
 	return $option_name;
158 158
 }
159 159
 
160
-private function _convert_active_gateways(){
160
+private function _convert_active_gateways() {
161 161
 	//just does it all one big swoop
162 162
 	$old_active_gateways = get_option('event_espresso_active_gateways');
163 163
 	$new_active_gateways = EE_Config::instance()->gateway->active_gateways;
164
-	foreach($old_active_gateways as $old_gateway_slug => $filepath){
165
-		if( ! isset($this->_gateways_we_know_how_to_migrate[$old_gateway_slug])){
166
-			$this->add_error(sprintf(__("The %s gateway does not exist in EE 4.1", "event_espresso"),$old_gateway_slug));
164
+	foreach ($old_active_gateways as $old_gateway_slug => $filepath) {
165
+		if ( ! isset($this->_gateways_we_know_how_to_migrate[$old_gateway_slug])) {
166
+			$this->add_error(sprintf(__("The %s gateway does not exist in EE 4.1", "event_espresso"), $old_gateway_slug));
167 167
 			continue;
168 168
 		}
169 169
 		$new_gateway_slug = $this->_gateways_we_know_how_to_migrate[$old_gateway_slug];
Please login to merge, or discard this patch.
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -39,7 +39,7 @@
 block discarded – undo
39 39
 			//and when we're done, remove the old option. Sometimes we'd prefer to do this in a different stage, but
40 40
 			//I think it's ok to do right away this time (we wont need gateway settings elsewhere)
41 41
 			delete_option($old_gateway_wp_option_name);
42
-		}else{//it must be one of the ones we mostly leave alone
42
+		} else{//it must be one of the ones we mostly leave alone
43 43
 			global $wpdb;
44 44
 			//yeah we could do this all in one query... and if you're reading this and would liek to, go ahead. Although you'll
45 45
 			//only be saving users 50 milliseconds the one time this runs...
Please login to merge, or discard this patch.
data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_org_options.dmsstage.php 4 patches
Doc Comments   -1 removed lines patch added patch discarded remove patch
@@ -245,7 +245,6 @@
 block discarded – undo
245 245
 	/**
246 246
 	 * Creates a 4.1 member price discount
247 247
 	 * @global type $wpdb
248
-	 * @param type $old_price
249 248
 	 * @return int
250 249
 	 */
251 250
 	private function _insert_new_global_surcharge_price($org_options){
Please login to merge, or discard this patch.
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -191,7 +191,7 @@
 block discarded – undo
191 191
 			  $c->organization->logo_url = $value;break;
192 192
 		  case 'event_page_id':
193 193
 
194
-			    //also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS
194
+				//also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS
195 195
 			  //to ESPRESSO_THANK_YOU
196 196
 			  $reg_page_post = get_post($value);
197 197
 			  $reg_page_post->post_content = str_replace("[ESPRESSO_EVENTS]","[ESPRESSO_CHECKOUT]",$reg_page_post->post_content);
Please login to merge, or discard this patch.
Spacing   +69 added lines, -69 removed lines patch added patch discarded remove patch
@@ -100,30 +100,30 @@  discard block
 block discarded – undo
100 100
  *
101 101
  * @todo: inform clients that messages have COMPLETELY changed in 4.1; themeroller isn't in there; event list page is no more;
102 102
  */
103
-class EE_DMS_4_1_0_org_options extends EE_Data_Migration_Script_Stage{
103
+class EE_DMS_4_1_0_org_options extends EE_Data_Migration_Script_Stage {
104 104
 
105
-	function _migration_step($num_items=50){
105
+	function _migration_step($num_items = 50) {
106 106
 
107 107
 		$items_actually_migrated = 0;
108 108
 		$old_org_options = get_option('events_organization_settings');
109
-		foreach($this->_org_options_we_know_how_to_migrate as $option_name){
109
+		foreach ($this->_org_options_we_know_how_to_migrate as $option_name) {
110 110
 			//only bother migrating if there's a setting to migrate. Otherwise we'll just use the default
111
-			if(isset($old_org_options[$option_name])){
111
+			if (isset($old_org_options[$option_name])) {
112 112
 				$this->_handle_org_option($option_name, $old_org_options[$option_name]);
113 113
 			}
114
-			if($option_name=='surcharge'){
114
+			if ($option_name == 'surcharge') {
115 115
 				$this->_insert_new_global_surcharge_price($old_org_options);
116 116
 			}
117 117
 			$items_actually_migrated++;
118 118
 		}
119 119
 
120
-		$success = EE_Config::instance()->update_espresso_config(FALSE,TRUE);
121
-		if( ! $success ) {
122
-			$this->add_error( sprintf( __( 'Could not save EE Config during org options stage. Reason: %s', 'event_espresso' ),  EE_Error::get_notices( FALSE )) );
120
+		$success = EE_Config::instance()->update_espresso_config(FALSE, TRUE);
121
+		if ( ! $success) {
122
+			$this->add_error(sprintf(__('Could not save EE Config during org options stage. Reason: %s', 'event_espresso'), EE_Error::get_notices(FALSE)));
123 123
 			EE_Error::overwrite_errors();
124 124
 		}
125
-		EE_Network_Config::instance()->update_config(FALSE,FALSE);
126
-		if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
125
+		EE_Network_Config::instance()->update_config(FALSE, FALSE);
126
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
127 127
 			//we may have added new pages and this might be necessary
128 128
 			flush_rewrite_rules();
129 129
 			$this->set_completed();
@@ -136,65 +136,65 @@  discard block
 block discarded – undo
136 136
 	}
137 137
 	function __construct() {
138 138
 		$this->_pretty_name = __("Organization Options/Config", "event_espresso");
139
-		$this->_org_options_we_know_how_to_migrate = apply_filters( 'FHEE__EE_DMS_4_1_0_org_options__org_options_we_know_how_to_migrate',$this->_org_options_we_know_how_to_migrate );
139
+		$this->_org_options_we_know_how_to_migrate = apply_filters('FHEE__EE_DMS_4_1_0_org_options__org_options_we_know_how_to_migrate', $this->_org_options_we_know_how_to_migrate);
140 140
 		parent::__construct();
141 141
 	}
142 142
 
143
-	private function _handle_org_option($option_name,$value){
143
+	private function _handle_org_option($option_name, $value) {
144 144
 		$c = EE_Config::instance();
145 145
 		$cn = EE_Network_Config::instance();
146
-		switch($option_name){
146
+		switch ($option_name) {
147 147
 		  case 'organization':
148
-			  $c->organization->name = $value;break;
148
+			  $c->organization->name = $value; break;
149 149
 		  case 'organization_street1':
150
-			  $c->organization->address_1 = $value;break;
150
+			  $c->organization->address_1 = $value; break;
151 151
 		  case 'organization_street2':
152
-			  $c->organization->address_2 = $value;break;
152
+			  $c->organization->address_2 = $value; break;
153 153
 		  case 'organization_city':
154
-			  $c->organization->city = $value;break;
154
+			  $c->organization->city = $value; break;
155 155
 		  case 'organization_state':
156
-			  try{
156
+			  try {
157 157
 			  $state = $this->get_migration_script()->get_or_create_state($value);
158 158
 			  $state_id = $state['STA_ID'];
159 159
 			  $c->organization->STA_ID = $state_id;
160
-			  }catch(EE_Error $e){}break;
160
+			  } catch (EE_Error $e) {}break;
161 161
 		  case 'organization_zip':
162
-			  $c->organization->zip = $value;break;
162
+			  $c->organization->zip = $value; break;
163 163
 		  case 'contact_email':
164
-			  $c->organization->email = $value;break;
164
+			  $c->organization->email = $value; break;
165 165
 		  case 'default_payment_status':
166
-			  $c->registration->default_STS_ID =  $this->get_migration_script()->convert_3_1_payment_status_to_4_1_STS_ID($value);break;
166
+			  $c->registration->default_STS_ID = $this->get_migration_script()->convert_3_1_payment_status_to_4_1_STS_ID($value); break;
167 167
 		  case 'organization_country':
168
-			  $iso =$this->get_migration_script()->get_iso_from_3_1_country_id($value);
168
+			  $iso = $this->get_migration_script()->get_iso_from_3_1_country_id($value);
169 169
 			  $c->organization->CNT_ISO = $iso;
170 170
 			  $country_row = $this->get_migration_script()->get_or_create_country($iso);
171
-			  if( ! $country_row){
172
-				  $this->add_error(sprintf(__("Could not set country's currency config because no country exists for ISO %s", "event_espresso"),$iso));
171
+			  if ( ! $country_row) {
172
+				  $this->add_error(sprintf(__("Could not set country's currency config because no country exists for ISO %s", "event_espresso"), $iso));
173 173
 			  }
174 174
 			  //can't use EE_Currency_Config's handy constructor because the models are off-limits right now (and it uses them)
175
-			$c->currency->code = $country_row['CNT_cur_code']; 			// currency code: USD, CAD, EUR
176
-			$c->currency->name = $country_row['CNT_cur_single'];	// Dollar
177
-			$c->currency->plural = $country_row['CNT_cur_plural']; 	// Dollars
178
-			$c->currency->sign =  $country_row['CNT_cur_sign']; 			// currency sign: $
179
-			$c->currency->sign_b4 = intval($country_row['CNT_cur_sign_b4']); 		// currency sign before or after: $TRUE  or  FALSE$
180
-			$c->currency->dec_plc = intval($country_row['CNT_cur_dec_plc']);	// decimal places: 2 = 0.00  3 = 0.000
181
-			$c->currency->dec_mrk = $country_row['CNT_cur_dec_mrk'];	// decimal mark: (comma) ',' = 0,01   or (decimal) '.' = 0.01
182
-			$c->currency->thsnds = $country_row['CNT_cur_thsnds'];	// thousands separator: (comma) ',' = 1,000   or (decimal) '.' = 1.000
175
+			$c->currency->code = $country_row['CNT_cur_code']; // currency code: USD, CAD, EUR
176
+			$c->currency->name = $country_row['CNT_cur_single']; // Dollar
177
+			$c->currency->plural = $country_row['CNT_cur_plural']; // Dollars
178
+			$c->currency->sign = $country_row['CNT_cur_sign']; // currency sign: $
179
+			$c->currency->sign_b4 = intval($country_row['CNT_cur_sign_b4']); // currency sign before or after: $TRUE  or  FALSE$
180
+			$c->currency->dec_plc = intval($country_row['CNT_cur_dec_plc']); // decimal places: 2 = 0.00  3 = 0.000
181
+			$c->currency->dec_mrk = $country_row['CNT_cur_dec_mrk']; // decimal mark: (comma) ',' = 0,01   or (decimal) '.' = 0.01
182
+			$c->currency->thsnds = $country_row['CNT_cur_thsnds']; // thousands separator: (comma) ',' = 1,000   or (decimal) '.' = 1.000
183 183
 //			  $c->currency = new EE_Currency_Config($c->organization->CNT_ISO);break;
184 184
 //		  case 'currency_symbol': ignore the currency symbol. we'll just go by their country.
185 185
 //			  $c->currency->sign = $value;break;
186 186
 		  case 'show_pending_payment_options':
187
-			  $c->registration->show_pending_payment_options = ($value == 'Y');break;
187
+			  $c->registration->show_pending_payment_options = ($value == 'Y'); break;
188 188
 		  case 'display_address_in_regform':
189
-			  $c->template_settings->display_address_in_regform = ($value == 'Y');break;
189
+			  $c->template_settings->display_address_in_regform = ($value == 'Y'); break;
190 190
 		  case 'default_logo_url':
191
-			  $c->organization->logo_url = $value;break;
191
+			  $c->organization->logo_url = $value; break;
192 192
 		  case 'event_page_id':
193 193
 
194 194
 			    //also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS
195 195
 			  //to ESPRESSO_THANK_YOU
196 196
 			  $reg_page_post = get_post($value);
197
-			  $reg_page_post->post_content = str_replace("[ESPRESSO_EVENTS]","[ESPRESSO_CHECKOUT]",$reg_page_post->post_content);
197
+			  $reg_page_post->post_content = str_replace("[ESPRESSO_EVENTS]", "[ESPRESSO_CHECKOUT]", $reg_page_post->post_content);
198 198
 			  wp_update_post($reg_page_post);
199 199
 			  $c->core->reg_page_id = $value;
200 200
 			  break;
@@ -202,7 +202,7 @@  discard block
 block discarded – undo
202 202
 			  //also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS
203 203
 			  //to ESPRESSO_THANK_YOU
204 204
 			  $thank_you_page_post = get_post($value);
205
-			  $thank_you_page_post->post_content = str_replace("[ESPRESSO_PAYMENTS]","[ESPRESSO_THANK_YOU]",$thank_you_page_post->post_content);
205
+			  $thank_you_page_post->post_content = str_replace("[ESPRESSO_PAYMENTS]", "[ESPRESSO_THANK_YOU]", $thank_you_page_post->post_content);
206 206
 			  wp_update_post($thank_you_page_post);
207 207
 			  $c->core->thank_you_page_id = $value;
208 208
 			   break;
@@ -216,15 +216,15 @@  discard block
 block discarded – undo
216 216
 		  case 'use_captcha':
217 217
 			  $c->registration->use_captcha = ($value == 'Y'); break;
218 218
 		  case 'recaptcha_publickey':
219
-			  $c->registration->recaptcha_publickey = $value;break;
219
+			  $c->registration->recaptcha_publickey = $value; break;
220 220
 		  case 'recaptcha_privatekey':
221
-			  $c->registration->recaptcha_privatekey = $value;break;
221
+			  $c->registration->recaptcha_privatekey = $value; break;
222 222
 		  case 'recaptcha_theme':
223
-			  $c->registration->recaptcha_theme = $value;break;
223
+			  $c->registration->recaptcha_theme = $value; break;
224 224
 		  case 'recaptcha_width':
225
-			  $c->registration->recaptcha_width = $value;break;
225
+			  $c->registration->recaptcha_width = $value; break;
226 226
 		  case 'recaptcha_language':
227
-			  $c->registration->recaptcha_language = $value;break;
227
+			  $c->registration->recaptcha_language = $value; break;
228 228
 		  case 'espresso_dashboard_widget':
229 229
 			  $c->admin->use_dashboard_widget = ($value == 'Y'); break;
230 230
 		  case 'use_personnel_manager':
@@ -232,13 +232,13 @@  discard block
 block discarded – undo
232 232
 		  case 'use_event_timezones':
233 233
 			  $c->admin->use_event_timezones = ($value == 'Y'); break;
234 234
 		  case 'full_logging':
235
-			  $c->admin->use_full_logging = ($value == 'Y');break;
235
+			  $c->admin->use_full_logging = ($value == 'Y'); break;
236 236
 		  case 'affiliate_id':
237
-			  $c->admin->affiliate_id = $value;break;
237
+			  $c->admin->affiliate_id = $value; break;
238 238
 		  case 'site_license_key':
239
-			  $cn->core->site_license_key = $value;break;
239
+			  $cn->core->site_license_key = $value; break;
240 240
 		  default:
241
-			  do_action( 'AHEE__EE_DMS_4_1_0__handle_org_option',$option_name,$value );
241
+			  do_action('AHEE__EE_DMS_4_1_0__handle_org_option', $option_name, $value);
242 242
 		}
243 243
 	}
244 244
 
@@ -248,15 +248,15 @@  discard block
 block discarded – undo
248 248
 	 * @param type $old_price
249 249
 	 * @return int
250 250
 	 */
251
-	private function _insert_new_global_surcharge_price($org_options){
251
+	private function _insert_new_global_surcharge_price($org_options) {
252 252
 		$amount = floatval($org_options['surcharge']);
253 253
 		//dont createa a price if the surcharge is 0
254
-		if($amount <=.01){
254
+		if ($amount <= .01) {
255 255
 			return 0;
256 256
 		}
257
-		if($org_options['surcharge_type'] == 'flat_rate'){
257
+		if ($org_options['surcharge_type'] == 'flat_rate') {
258 258
 			$price_type = EE_DMS_4_1_0_prices::price_type_flat_surcharge;
259
-		}else{
259
+		} else {
260 260
 			$price_type = EE_DMS_4_1_0_prices::price_type_percent_surcharge;
261 261
 		}
262 262
 		global $wpdb;
@@ -272,18 +272,18 @@  discard block
 block discarded – undo
272 272
 
273 273
 		);
274 274
 		$datatypes = array(
275
-			'%d',//PRT_ID
276
-			'%f',//PRT_amount
277
-			'%s',//PRC_name
278
-			'%d',//PRC_is_default
279
-			'%d',//PRC_overrides
280
-			'%d',//PRC_order
281
-			'%d',//PRC_deleted
282
-			'%d',//PRC_parent
275
+			'%d', //PRT_ID
276
+			'%f', //PRT_amount
277
+			'%s', //PRC_name
278
+			'%d', //PRC_is_default
279
+			'%d', //PRC_overrides
280
+			'%d', //PRC_order
281
+			'%d', //PRC_deleted
282
+			'%d', //PRC_parent
283 283
 		);
284 284
 		$price_table = $wpdb->prefix."esp_price";
285
-		$success = $wpdb->insert($price_table,$cols_n_values,$datatypes);
286
-		if ( ! $success){
285
+		$success = $wpdb->insert($price_table, $cols_n_values, $datatypes);
286
+		if ( ! $success) {
287 287
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion('org_options',
288 288
 					array(
289 289
 						'surcharge'=>$org_options['surcharge'],
@@ -308,8 +308,8 @@  discard block
 block discarded – undo
308 308
 	  'payment_message',
309 309
 	  'message',
310 310
 	  'default_payment_status',
311
-	  'surcharge',//unused?
312
-	  'country_id',//unused?
311
+	  'surcharge', //unused?
312
+	  'country_id', //unused?
313 313
 	  'organization_country',
314 314
 //	  'currency_symbol',
315 315
 	  'expire_on_registration_end',
@@ -321,13 +321,13 @@  discard block
 block discarded – undo
321 321
 	  'show_pending_payment_options',
322 322
 	  'show_reg_footer',
323 323
 	  'skip_confirmation_page',
324
-	  'allow_mer_discounts',//no equiv
325
-	  'allow_mer_vouchers',//no equiv
324
+	  'allow_mer_discounts', //no equiv
325
+	  'allow_mer_vouchers', //no equiv
326 326
 	  'display_short_description_in_event_list',
327 327
 	  'display_description_on_multi_reg_page',
328 328
 	  'display_address_in_event_list',
329 329
 	  'display_address_in_regform',
330
-	  'use_custom_post_types',//no equiv
330
+	  'use_custom_post_types', //no equiv
331 331
 	  'display_ical_download',
332 332
 	  'display_featured_image',
333 333
 	  'themeroller',
@@ -346,11 +346,11 @@  discard block
 block discarded – undo
346 346
 	  'espresso_dashboard_widget',
347 347
 	  'time_reg_limit',
348 348
 //	  'use_attendee_pre_approval', removed in 4.1- instead this is factored into the default reg status
349
-	  'use_personnel_manager',//no equiv
349
+	  'use_personnel_manager', //no equiv
350 350
 	  'use_event_timezones',
351 351
 	  'full_logging',
352
-	  'surcharge_type',//unused
353
-	  'surcharge_text',//unused
352
+	  'surcharge_type', //unused
353
+	  'surcharge_text', //unused
354 354
 	  'affiliate_id',
355 355
 	  'site_license_key',
356 356
 	);
Please login to merge, or discard this patch.
Braces   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -157,7 +157,7 @@  discard block
 block discarded – undo
157 157
 			  $state = $this->get_migration_script()->get_or_create_state($value);
158 158
 			  $state_id = $state['STA_ID'];
159 159
 			  $c->organization->STA_ID = $state_id;
160
-			  }catch(EE_Error $e){}break;
160
+			  } catch(EE_Error $e){}break;
161 161
 		  case 'organization_zip':
162 162
 			  $c->organization->zip = $value;break;
163 163
 		  case 'contact_email':
@@ -256,7 +256,7 @@  discard block
 block discarded – undo
256 256
 		}
257 257
 		if($org_options['surcharge_type'] == 'flat_rate'){
258 258
 			$price_type = EE_DMS_4_1_0_prices::price_type_flat_surcharge;
259
-		}else{
259
+		} else{
260 260
 			$price_type = EE_DMS_4_1_0_prices::price_type_percent_surcharge;
261 261
 		}
262 262
 		global $wpdb;
Please login to merge, or discard this patch.