Completed
Branch FET-8162-relation-exists (8f4753)
by
unknown
22:06 queued 12:02
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_Registration_Processor.class.php 2 patches
Doc Comments   +1 added lines patch added patch discarded remove patch
@@ -161,6 +161,7 @@
 block discarded – undo
161 161
 	 *
162 162
 	 * @param int           $att_nmbr
163 163
 	 * @param EE_Line_Item | string $item
164
+	 * @param EE_Line_Item $item
164 165
 	 * @return string
165 166
 	 */
166 167
 	public function generate_reg_url_link( $att_nmbr, $item ) {
Please login to merge, or discard this patch.
Spacing   +61 added lines, -61 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_Registration_Processor
@@ -46,7 +46,7 @@  discard block
 block discarded – undo
46 46
 	 */
47 47
 	public static function instance() {
48 48
 		// check if class object is instantiated
49
-		if ( ! self::$_instance instanceof EE_Registration_Processor ) {
49
+		if ( ! self::$_instance instanceof EE_Registration_Processor) {
50 50
 			self::$_instance = new self();
51 51
 		}
52 52
 		return self::$_instance;
@@ -69,8 +69,8 @@  discard block
 block discarded – undo
69 69
 	 * @param EE_Line_Item | string $item
70 70
 	 * @return string
71 71
 	 */
72
-	public function generate_reg_url_link( $att_nmbr, $item ) {
73
-		return $item instanceof EE_Line_Item ? $att_nmbr . '-' . $item->code() :  $att_nmbr . '-' . $item;
72
+	public function generate_reg_url_link($att_nmbr, $item) {
73
+		return $item instanceof EE_Line_Item ? $att_nmbr.'-'.$item->code() : $att_nmbr.'-'.$item;
74 74
 	}
75 75
 
76 76
 
@@ -81,18 +81,18 @@  discard block
 block discarded – undo
81 81
 	 * @param \EE_Registration $registration
82 82
 	 * @return string
83 83
 	 */
84
-	public function generate_reg_code( EE_Registration $registration ) {
84
+	public function generate_reg_code(EE_Registration $registration) {
85 85
 	// figure out where to start parsing the reg code
86
-		$chars = strpos( $registration->reg_url_link(), '-' ) + 4;
86
+		$chars = strpos($registration->reg_url_link(), '-') + 4;
87 87
 		// TXN_ID + TKT_ID + first 3 and last 3 chars of reg_url_link
88 88
 		$new_reg_code = array(
89 89
 			$registration->transaction_ID(),
90 90
 			$registration->ticket_ID(),
91
-			substr( $registration->reg_url_link(), 0, $chars ) . substr( $registration->reg_url_link(), - 3 )
91
+			substr($registration->reg_url_link(), 0, $chars).substr($registration->reg_url_link(), - 3)
92 92
 		);
93 93
 		// now put it all together
94
-		$new_reg_code = implode( '-', $new_reg_code );
95
-		return apply_filters( 'FHEE__EE_Registration_Processor___generate_reg_code__new_reg_code', $new_reg_code, $registration );
94
+		$new_reg_code = implode('-', $new_reg_code);
95
+		return apply_filters('FHEE__EE_Registration_Processor___generate_reg_code__new_reg_code', $new_reg_code, $registration);
96 96
 	}
97 97
 
98 98
 
@@ -101,8 +101,8 @@  discard block
 block discarded – undo
101 101
 	 * @param int $REG_ID
102 102
 	 * @return string
103 103
 	 */
104
-	public function old_reg_status( $REG_ID ) {
105
-		return isset( $this->_old_reg_status[ $REG_ID ] ) ? $this->_old_reg_status[ $REG_ID ] : null;
104
+	public function old_reg_status($REG_ID) {
105
+		return isset($this->_old_reg_status[$REG_ID]) ? $this->_old_reg_status[$REG_ID] : null;
106 106
 	}
107 107
 
108 108
 
@@ -111,10 +111,10 @@  discard block
 block discarded – undo
111 111
 	 * @param int $REG_ID
112 112
 	 * @param string $old_reg_status
113 113
 	 */
114
-	public function set_old_reg_status( $REG_ID, $old_reg_status ) {
114
+	public function set_old_reg_status($REG_ID, $old_reg_status) {
115 115
 		// only set the first time
116
-		if ( ! isset( $this->_old_reg_status[ $REG_ID ] ) ) {
117
-			$this->_old_reg_status[ $REG_ID ] = $old_reg_status;
116
+		if ( ! isset($this->_old_reg_status[$REG_ID])) {
117
+			$this->_old_reg_status[$REG_ID] = $old_reg_status;
118 118
 		}
119 119
 	}
120 120
 
@@ -124,8 +124,8 @@  discard block
 block discarded – undo
124 124
 	 * @param int $REG_ID
125 125
 	 * @return string
126 126
 	 */
127
-	public function new_reg_status( $REG_ID ) {
128
-		return isset( $this->_new_reg_status[ $REG_ID ] ) ? $this->_new_reg_status[ $REG_ID ] : null;
127
+	public function new_reg_status($REG_ID) {
128
+		return isset($this->_new_reg_status[$REG_ID]) ? $this->_new_reg_status[$REG_ID] : null;
129 129
 	}
130 130
 
131 131
 
@@ -134,8 +134,8 @@  discard block
 block discarded – undo
134 134
 	 * @param int $REG_ID
135 135
 	 * @param string $new_reg_status
136 136
 	 */
137
-	public function set_new_reg_status( $REG_ID, $new_reg_status ) {
138
-		$this->_new_reg_status[ $REG_ID ] = $new_reg_status;
137
+	public function set_new_reg_status($REG_ID, $new_reg_status) {
138
+		$this->_new_reg_status[$REG_ID] = $new_reg_status;
139 139
 	}
140 140
 
141 141
 
@@ -146,8 +146,8 @@  discard block
 block discarded – undo
146 146
 	 * @param int $REG_ID
147 147
 	 * @return bool
148 148
 	 */
149
-	public function reg_status_updated( $REG_ID ) {
150
-		return $this->new_reg_status( $REG_ID ) !== $this->old_reg_status( $REG_ID ) ? true : false;
149
+	public function reg_status_updated($REG_ID) {
150
+		return $this->new_reg_status($REG_ID) !== $this->old_reg_status($REG_ID) ? true : false;
151 151
 	}
152 152
 
153 153
 
@@ -161,24 +161,24 @@  discard block
 block discarded – undo
161 161
 	 * @param bool 	$save TRUE will save the registration if the status is updated, FALSE will leave that up to client code
162 162
 	 * 	@return boolean
163 163
 	 */
164
-	public function manually_update_registration_status( EE_Registration $registration, $new_reg_status = '', $save = true ) {
164
+	public function manually_update_registration_status(EE_Registration $registration, $new_reg_status = '', $save = true) {
165 165
 		// set initial REG_Status
166
-		$this->set_old_reg_status( $registration->ID(), $registration->status_ID() );
166
+		$this->set_old_reg_status($registration->ID(), $registration->status_ID());
167 167
 		// set incoming REG_Status
168
-		$this->set_new_reg_status( $registration->ID(), $new_reg_status );
168
+		$this->set_new_reg_status($registration->ID(), $new_reg_status);
169 169
 		// toggle reg status but only if it has changed and the user can do so
170
-		if ( $this->reg_status_updated( $registration->ID() ) && EE_Registry::instance()->CAP->current_user_can(
170
+		if ($this->reg_status_updated($registration->ID()) && EE_Registry::instance()->CAP->current_user_can(
171 171
 				'ee_edit_registration',
172 172
 				'toggle_registration_status', $registration->ID() )) {
173 173
 			// change status to new value
174
-			if ( $registration->set_status( $this->new_reg_status( $registration->ID() ) )) {
175
-				if ( $save ) {
174
+			if ($registration->set_status($this->new_reg_status($registration->ID()))) {
175
+				if ($save) {
176 176
 					$registration->save();
177 177
 				}
178 178
 				// send messages
179 179
 				$this->trigger_registration_update_notifications(
180 180
 					$registration,
181
-					array( 'manually_updated' 	=> true )
181
+					array('manually_updated' 	=> true)
182 182
 				);
183 183
 			}
184 184
 			return TRUE;
@@ -198,27 +198,27 @@  discard block
 block discarded – undo
198 198
 	 * @param bool 	$save TRUE will save the registration if the status is updated, FALSE will leave that up to client code
199 199
 	 * @return void
200 200
 	 */
201
-	public function toggle_incomplete_registration_status_to_default( EE_Registration $registration, $save = TRUE ) {
201
+	public function toggle_incomplete_registration_status_to_default(EE_Registration $registration, $save = TRUE) {
202 202
 		// set initial REG_Status
203
-		$this->set_old_reg_status( $registration->ID(), $registration->status_ID() );
203
+		$this->set_old_reg_status($registration->ID(), $registration->status_ID());
204 204
 		// is the registration currently incomplete ?
205
-		if ( $registration->status_ID() === EEM_Registration::status_id_incomplete ) {
205
+		if ($registration->status_ID() === EEM_Registration::status_id_incomplete) {
206 206
 			// grab default reg status for the event, if set
207 207
 			$event_default_registration_status = $registration->event()->default_registration_status();
208 208
 			// if no default reg status is set for the event, then use the global value
209
-			$STS_ID = ! empty( $event_default_registration_status ) ? $event_default_registration_status : EE_Registry::instance()->CFG->registration->default_STS_ID;
209
+			$STS_ID = ! empty($event_default_registration_status) ? $event_default_registration_status : EE_Registry::instance()->CFG->registration->default_STS_ID;
210 210
 			// if the event default reg status is approved, then downgrade temporarily to payment pending to ensure that payments are triggered
211 211
 			$STS_ID = $STS_ID === EEM_Registration::status_id_approved ? EEM_Registration::status_id_pending_payment : $STS_ID;
212 212
 			// set incoming REG_Status
213
-			$this->set_new_reg_status( $registration->ID(), $STS_ID );
214
-			$registration->set_status( $STS_ID );
215
-			if ( $save ) {
213
+			$this->set_new_reg_status($registration->ID(), $STS_ID);
214
+			$registration->set_status($STS_ID);
215
+			if ($save) {
216 216
 				$registration->save();
217 217
 			}
218 218
 			// don't trigger notifications during IPNs because they will get triggered by EE_Payment_Processor
219
-			if ( ! EE_Processor_Base::$IPN ) {
219
+			if ( ! EE_Processor_Base::$IPN) {
220 220
 				// otherwise, send out notifications
221
-				add_filter( 'FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10 );
221
+				add_filter('FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10);
222 222
 			}
223 223
 			// DEBUG LOG
224 224
 			//$this->log(
@@ -242,25 +242,25 @@  discard block
 block discarded – undo
242 242
 	 * @param bool 	$save TRUE will save the registration if the status is updated, FALSE will leave that up to client code
243 243
 	 * @return boolean
244 244
 	 */
245
-	public function toggle_registration_status_for_default_approved_events( EE_Registration $registration, $save = TRUE ) {
245
+	public function toggle_registration_status_for_default_approved_events(EE_Registration $registration, $save = TRUE) {
246 246
 		// set initial REG_Status
247
-		$this->set_old_reg_status( $registration->ID(), $registration->status_ID() );
247
+		$this->set_old_reg_status($registration->ID(), $registration->status_ID());
248 248
 		// if not already, toggle reg status to approved IF the event default reg status is approved
249 249
 		if (
250 250
 			$registration->status_ID() !== EEM_Registration::status_id_approved &&
251 251
 			$registration->event()->default_registration_status() == EEM_Registration::status_id_approved
252 252
 		) {
253 253
 			// set incoming REG_Status
254
-			$this->set_new_reg_status( $registration->ID(), EEM_Registration::status_id_approved );
254
+			$this->set_new_reg_status($registration->ID(), EEM_Registration::status_id_approved);
255 255
 			// toggle status to approved
256
-			$registration->set_status( EEM_Registration::status_id_approved );
257
-			if ( $save ) {
256
+			$registration->set_status(EEM_Registration::status_id_approved);
257
+			if ($save) {
258 258
 				$registration->save();
259 259
 			}
260 260
 			// don't trigger notifications during IPNs because they will get triggered by EE_Payment_Processor
261
-			if ( ! EE_Processor_Base::$IPN ) {
261
+			if ( ! EE_Processor_Base::$IPN) {
262 262
 				// otherwise, send out notifications
263
-				add_filter( 'FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10 );
263
+				add_filter('FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10);
264 264
 			}
265 265
 			// DEBUG LOG
266 266
 			//$this->log(
@@ -285,27 +285,27 @@  discard block
 block discarded – undo
285 285
 	 * @param bool 	$save TRUE will save the registration if the status is updated, FALSE will leave that up to client code
286 286
 	 * 	@return boolean
287 287
 	 */
288
-	public function toggle_registration_status_if_no_monies_owing( EE_Registration $registration, $save = TRUE ) {
288
+	public function toggle_registration_status_if_no_monies_owing(EE_Registration $registration, $save = TRUE) {
289 289
 		// set initial REG_Status
290
-		$this->set_old_reg_status( $registration->ID(), $registration->status_ID() );
290
+		$this->set_old_reg_status($registration->ID(), $registration->status_ID());
291 291
 		// toggle reg status to approved IF
292 292
 		if (
293 293
 			// REG status is pending payment
294 294
 			$registration->status_ID() == EEM_Registration::status_id_pending_payment
295 295
 			// AND no monies are owing
296
-			&& ( $registration->transaction()->is_completed() || $registration->transaction()->is_overpaid() || $registration->transaction()->is_free() )
296
+			&& ($registration->transaction()->is_completed() || $registration->transaction()->is_overpaid() || $registration->transaction()->is_free())
297 297
 		) {
298 298
 			// set incoming REG_Status
299
-			$this->set_new_reg_status( $registration->ID(), EEM_Registration::status_id_approved );
299
+			$this->set_new_reg_status($registration->ID(), EEM_Registration::status_id_approved);
300 300
 			// toggle status to approved
301
-			$registration->set_status( EEM_Registration::status_id_approved );
302
-			if ( $save ) {
301
+			$registration->set_status(EEM_Registration::status_id_approved);
302
+			if ($save) {
303 303
 				$registration->save();
304 304
 			}
305 305
 			// don't trigger notifications during IPNs because they will get triggered by EE_Payment_Processor
306
-			if ( ! EE_Processor_Base::$IPN ) {
306
+			if ( ! EE_Processor_Base::$IPN) {
307 307
 				// otherwise, send out notifications
308
-				add_filter( 'FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10 );
308
+				add_filter('FHEE__EED_Messages___maybe_registration__deliver_notifications', '__return_true', 10);
309 309
 			}
310 310
 			// DEBUG LOG
311 311
 			//$this->log(
@@ -331,7 +331,7 @@  discard block
 block discarded – undo
331 331
 	 * @param array 	$additional_details
332 332
 	 * @return void
333 333
 	 */
334
-	public function trigger_registration_update_notifications( EE_Registration $registration, $additional_details = array() ) {
334
+	public function trigger_registration_update_notifications(EE_Registration $registration, $additional_details = array()) {
335 335
 
336 336
 		try {
337 337
 			//do_action(
@@ -365,8 +365,8 @@  discard block
 block discarded – undo
365 365
 				$additional_details
366 366
 			);
367 367
 
368
-		} catch( Exception $e ) {
369
-			EE_Error::add_error( $e->getMessage(), $e->getFile(), '', $e->getLine() );
368
+		} catch (Exception $e) {
369
+			EE_Error::add_error($e->getMessage(), $e->getFile(), '', $e->getLine());
370 370
 		}
371 371
 	}
372 372
 
@@ -379,26 +379,26 @@  discard block
 block discarded – undo
379 379
 	 * @param array 	$additional_details
380 380
 	 * @return bool
381 381
 	 */
382
-	public function update_registration_after_checkout_or_payment(  EE_Registration $registration, $additional_details = array() ) {
382
+	public function update_registration_after_checkout_or_payment(EE_Registration $registration, $additional_details = array()) {
383 383
 		// set initial REG_Status
384
-		$this->set_old_reg_status( $registration->ID(), $registration->status_ID() );
384
+		$this->set_old_reg_status($registration->ID(), $registration->status_ID());
385 385
 
386 386
 		// if the registration status gets updated, then save the registration
387
-		if ( $this->toggle_registration_status_for_default_approved_events( $registration, false ) || $this->toggle_registration_status_if_no_monies_owing( $registration, false )) {
387
+		if ($this->toggle_registration_status_for_default_approved_events($registration, false) || $this->toggle_registration_status_if_no_monies_owing($registration, false)) {
388 388
 			$registration->save();
389 389
 		}
390 390
 
391 391
 		// set new  REG_Status
392
-		$this->set_new_reg_status( $registration->ID(), $registration->status_ID() );
392
+		$this->set_new_reg_status($registration->ID(), $registration->status_ID());
393 393
 		// send messages
394 394
 		$this->trigger_registration_update_notifications(
395 395
 			$registration,
396 396
 			array_merge(
397
-				is_array( $additional_details ) ? $additional_details : array( $additional_details ),
398
-				array( 'checkout_or_payment' 	=> true )
397
+				is_array($additional_details) ? $additional_details : array($additional_details),
398
+				array('checkout_or_payment' 	=> true)
399 399
 			)
400 400
 		);
401
-		return $this->new_reg_status( $registration->ID() ) == EEM_Registration::status_id_approved ? true : false;
401
+		return $this->new_reg_status($registration->ID()) == EEM_Registration::status_id_approved ? true : false;
402 402
 	}
403 403
 
404 404
 
Please login to merge, or discard this patch.
core/business/EE_Transaction_Payments.class.php 2 patches
Doc Comments   +1 added lines, -2 removed lines patch added patch discarded remove patch
@@ -120,7 +120,6 @@  discard block
 block discarded – undo
120 120
 	 * then client code needs to take responsibility for saving the TXN
121 121
 	 * regardless of what happens within EE_Transaction_Payments;
122 122
 	 *
123
-	 * @param EE_Transaction/int $transaction_obj_or_id EE_Transaction or its ID
124 123
 	 * @param 	boolean $update_txn  	whether to save the TXN
125 124
 	 * @return 	boolean 	 	whether the TXN was saved
126 125
 	 */
@@ -158,7 +157,7 @@  discard block
 block discarded – undo
158 157
 	 * 		@access		public
159 158
 	 * 		@param EE_Transaction $transaction
160 159
 	 *		@param	string $payment_status, one of EEM_Payment's statuses, like 'PAP' (Approved). By default, searches for approved payments
161
-	 *		@return 		mixed		float on success, false on fail
160
+	 *		@return 		double		float on success, false on fail
162 161
 	 */
163 162
 	public function recalculate_total_payments_for_transaction( EE_Transaction $transaction, $payment_status = EEM_Payment::status_id_approved ) {
164 163
 		// verify transaction
Please login to merge, or discard this patch.
Spacing   +38 added lines, -38 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_Payments
@@ -44,7 +44,7 @@  discard block
 block discarded – undo
44 44
 	 */
45 45
 	public static function instance() {
46 46
 		// check if class object is instantiated
47
-		if ( ! self::$_instance instanceof EE_Transaction_Payments ) {
47
+		if ( ! self::$_instance instanceof EE_Transaction_Payments) {
48 48
 			self::$_instance = new self();
49 49
 		}
50 50
 		return self::$_instance;
@@ -72,9 +72,9 @@  discard block
 block discarded – undo
72 72
 	/**
73 73
 	 * @param string $old_txn_status
74 74
 	 */
75
-	public function set_old_txn_status( $old_txn_status ) {
75
+	public function set_old_txn_status($old_txn_status) {
76 76
 		// only set the first time
77
-		if ( $this->_old_txn_status === null ) {
77
+		if ($this->_old_txn_status === null) {
78 78
 			$this->_old_txn_status = $old_txn_status;
79 79
 		}
80 80
 	}
@@ -93,7 +93,7 @@  discard block
 block discarded – undo
93 93
 	/**
94 94
 	 * @param string $new_txn_status
95 95
 	 */
96
-	public function set_new_txn_status( $new_txn_status ) {
96
+	public function set_new_txn_status($new_txn_status) {
97 97
 		$this->_new_txn_status = $new_txn_status;
98 98
 	}
99 99
 
@@ -124,22 +124,22 @@  discard block
 block discarded – undo
124 124
 	 * @param 	boolean $update_txn  	whether to save the TXN
125 125
 	 * @return 	boolean 	 	whether the TXN was saved
126 126
 	 */
127
-	public function calculate_total_payments_and_update_status( EE_Transaction $transaction, $update_txn = true ){
127
+	public function calculate_total_payments_and_update_status(EE_Transaction $transaction, $update_txn = true) {
128 128
 		// verify transaction
129
-		if ( ! $transaction instanceof EE_Transaction ) {
130
-			EE_Error::add_error( __( 'Please provide a valid EE_Transaction object.', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ );
129
+		if ( ! $transaction instanceof EE_Transaction) {
130
+			EE_Error::add_error(__('Please provide a valid EE_Transaction object.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__);
131 131
 			return false;
132 132
 		}
133 133
 		// set incoming TXN_Status
134
-		$this->set_old_txn_status( $transaction->status_ID() );
134
+		$this->set_old_txn_status($transaction->status_ID());
135 135
 		// calculate total paid
136
-		$total_paid = $this->recalculate_total_payments_for_transaction( $transaction );
136
+		$total_paid = $this->recalculate_total_payments_for_transaction($transaction);
137 137
 		// if total paid has changed
138
-		if ( $total_paid != $transaction->paid() ) {
139
-			$transaction->set_paid( $total_paid );
138
+		if ($total_paid != $transaction->paid()) {
139
+			$transaction->set_paid($total_paid);
140 140
 			// maybe update status, and make sure to save transaction if not done already
141
-			if ( ! $this->update_transaction_status_based_on_total_paid( $transaction, $update_txn )) {
142
-				if ( $update_txn ) {
141
+			if ( ! $this->update_transaction_status_based_on_total_paid($transaction, $update_txn)) {
142
+				if ($update_txn) {
143 143
 					return $transaction->save() ? TRUE : FALSE;
144 144
 				}
145 145
 			} else {
@@ -160,18 +160,18 @@  discard block
 block discarded – undo
160 160
 	 *		@param	string $payment_status, one of EEM_Payment's statuses, like 'PAP' (Approved). By default, searches for approved payments
161 161
 	 *		@return 		mixed		float on success, false on fail
162 162
 	 */
163
-	public function recalculate_total_payments_for_transaction( EE_Transaction $transaction, $payment_status = EEM_Payment::status_id_approved ) {
163
+	public function recalculate_total_payments_for_transaction(EE_Transaction $transaction, $payment_status = EEM_Payment::status_id_approved) {
164 164
 		// verify transaction
165
-		if ( ! $transaction instanceof EE_Transaction ) {
166
-			EE_Error::add_error( __( 'Please provide a valid EE_Transaction object.', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ );
165
+		if ( ! $transaction instanceof EE_Transaction) {
166
+			EE_Error::add_error(__('Please provide a valid EE_Transaction object.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__);
167 167
 			return false;
168 168
 		}
169 169
 		// ensure Payment model is loaded
170
-		EE_Registry::instance()->load_model( 'Payment' );
170
+		EE_Registry::instance()->load_model('Payment');
171 171
 		// calls EEM_Base::sum()
172 172
 		return EEM_Payment::instance()->sum(
173 173
 			// query params
174
-			array( array( 'TXN_ID' => $transaction->ID(), 'STS_ID' => $payment_status )),
174
+			array(array('TXN_ID' => $transaction->ID(), 'STS_ID' => $payment_status)),
175 175
 			// field to sum
176 176
 			'PAY_amount'
177 177
 		);
@@ -187,37 +187,37 @@  discard block
 block discarded – undo
187 187
 	 * @return 	boolean 	 	whether the TXN was saved
188 188
 	 * @throws \EE_Error
189 189
 	 */
190
-	public function update_transaction_status_based_on_total_paid( EE_Transaction $transaction, $update_txn = TRUE ) {
190
+	public function update_transaction_status_based_on_total_paid(EE_Transaction $transaction, $update_txn = TRUE) {
191 191
 		// verify transaction
192
-		if ( ! $transaction instanceof EE_Transaction ) {
192
+		if ( ! $transaction instanceof EE_Transaction) {
193 193
 			EE_Error::add_error(
194
-				__( 'Please provide a valid EE_Transaction object.', 'event_espresso' ),
194
+				__('Please provide a valid EE_Transaction object.', 'event_espresso'),
195 195
 				__FILE__, __FUNCTION__, __LINE__
196 196
 			);
197 197
 			return FALSE;
198 198
 		}
199
-		EE_Registry::instance()->load_helper( 'Money' );
199
+		EE_Registry::instance()->load_helper('Money');
200 200
 		// set incoming TXN_Status
201
-		$this->set_old_txn_status( $transaction->status_ID() );
201
+		$this->set_old_txn_status($transaction->status_ID());
202 202
 		// set transaction status based on comparison of TXN_paid vs TXN_total
203
-		if ( EEH_Money::compare_floats( $transaction->paid(), $transaction->total(), '>' ) ){
203
+		if (EEH_Money::compare_floats($transaction->paid(), $transaction->total(), '>')) {
204 204
 			$new_txn_status = EEM_Transaction::overpaid_status_code;
205
-		} else if ( EEH_Money::compare_floats( $transaction->paid(), $transaction->total() ) ) {
205
+		} else if (EEH_Money::compare_floats($transaction->paid(), $transaction->total())) {
206 206
 			$new_txn_status = EEM_Transaction::complete_status_code;
207
-		} else if ( EEH_Money::compare_floats( $transaction->paid(), $transaction->total(), '<' ) ) {
207
+		} else if (EEH_Money::compare_floats($transaction->paid(), $transaction->total(), '<')) {
208 208
 			$new_txn_status = EEM_Transaction::incomplete_status_code;
209 209
 		} else {
210 210
 			EE_Error::add_error(
211
-				__( 'The total paid calculation for this transaction is inaccurate.', 'event_espresso' ),
211
+				__('The total paid calculation for this transaction is inaccurate.', 'event_espresso'),
212 212
 				__FILE__, __FUNCTION__, __LINE__
213 213
 			);
214 214
 			return FALSE;
215 215
 		}
216
-		if ( $new_txn_status !== $transaction->status_ID() ) {
216
+		if ($new_txn_status !== $transaction->status_ID()) {
217 217
 			// set incoming TXN_Status
218
-			$this->set_new_txn_status( $new_txn_status );
219
-			$transaction->set_status( $new_txn_status );
220
-			if ( $update_txn ) {
218
+			$this->set_new_txn_status($new_txn_status);
219
+			$transaction->set_status($new_txn_status);
220
+			if ($update_txn) {
221 221
 				return $transaction->save() ? TRUE : FALSE;
222 222
 			}
223 223
 		}
@@ -236,18 +236,18 @@  discard block
 block discarded – undo
236 236
 	 * @param EE_Payment $payment
237 237
 	 * @return boolean
238 238
 	 */
239
-	public function delete_payment_and_update_transaction( EE_Payment $payment ) {
239
+	public function delete_payment_and_update_transaction(EE_Payment $payment) {
240 240
 		// verify payment
241
-		if ( ! $payment instanceof EE_Payment ) {
242
-			EE_Error::add_error( __( 'A valid Payment object was not received.', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ );
241
+		if ( ! $payment instanceof EE_Payment) {
242
+			EE_Error::add_error(__('A valid Payment object was not received.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__);
243 243
 			return FALSE;
244 244
 		}
245 245
 		$transaction = $payment->transaction();
246
-		if ( ! $payment->delete() ) {
247
-			EE_Error::add_error( __( 'The payment could not be deleted.', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ );
246
+		if ( ! $payment->delete()) {
247
+			EE_Error::add_error(__('The payment could not be deleted.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__);
248 248
 			return FALSE;
249 249
 		}
250
-		return $this->calculate_total_payments_and_update_status( $transaction );
250
+		return $this->calculate_total_payments_and_update_status($transaction);
251 251
 	}
252 252
 
253 253
 
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   -1 removed lines patch added patch discarded remove patch
@@ -413,7 +413,6 @@
 block discarded – undo
413 413
 	/**
414 414
 	 * toggle_abandoned_transaction_status
415 415
 	 * upgrades a TXNs status from failed or abandoned to incomplete
416
-
417 416
 	 * 	@access public
418 417
 	 * @param EE_Transaction $transaction
419 418
 	 * 	@return 	boolean
Please login to merge, or discard this patch.
Spacing   +82 added lines, -82 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
@@ -50,10 +50,10 @@  discard block
 block discarded – undo
50 50
 	 * @param array $registration_query_params
51 51
 	 *@return EE_Transaction_Processor instance
52 52
 	 */
53
-	public static function instance( $registration_query_params = array() ) {
53
+	public static function instance($registration_query_params = array()) {
54 54
 		// check if class object is instantiated
55
-		if ( ! self::$_instance instanceof EE_Transaction_Processor ) {
56
-			self::$_instance = new self( $registration_query_params );
55
+		if ( ! self::$_instance instanceof EE_Transaction_Processor) {
56
+			self::$_instance = new self($registration_query_params);
57 57
 		}
58 58
 		return self::$_instance;
59 59
 	}
@@ -64,9 +64,9 @@  discard block
 block discarded – undo
64 64
 	 * @param array $registration_query_params
65 65
 	 * @return EE_Transaction_Processor
66 66
 	 */
67
-	private function __construct( $registration_query_params = array() ) {
67
+	private function __construct($registration_query_params = array()) {
68 68
 		// make sure some query params are set for retrieving registrations
69
-		$this->_set_registration_query_params( $registration_query_params );
69
+		$this->_set_registration_query_params($registration_query_params);
70 70
 	}
71 71
 
72 72
 
@@ -75,8 +75,8 @@  discard block
 block discarded – undo
75 75
 	 * @access private
76 76
 	 * @param array $registration_query_params
77 77
 	 */
78
-	private function _set_registration_query_params( $registration_query_params ) {
79
-		$this->_registration_query_params = ! empty( $registration_query_params ) ? $registration_query_params : array( 'order_by' => array( 'REG_count' => 'ASC' ));
78
+	private function _set_registration_query_params($registration_query_params) {
79
+		$this->_registration_query_params = ! empty($registration_query_params) ? $registration_query_params : array('order_by' => array('REG_count' => 'ASC'));
80 80
 	}
81 81
 
82 82
 
@@ -93,9 +93,9 @@  discard block
 block discarded – undo
93 93
 	/**
94 94
 	 * @param string $old_txn_status
95 95
 	 */
96
-	public function set_old_txn_status( $old_txn_status ) {
96
+	public function set_old_txn_status($old_txn_status) {
97 97
 		// only set the first time
98
-		if ( $this->_old_txn_status === null ) {
98
+		if ($this->_old_txn_status === null) {
99 99
 			$this->_old_txn_status = $old_txn_status;
100 100
 		}
101 101
 	}
@@ -114,7 +114,7 @@  discard block
 block discarded – undo
114 114
 	/**
115 115
 	 * @param string $new_txn_status
116 116
 	 */
117
-	public function set_new_txn_status( $new_txn_status ) {
117
+	public function set_new_txn_status($new_txn_status) {
118 118
 		$this->_new_txn_status = $new_txn_status;
119 119
 	}
120 120
 
@@ -145,17 +145,17 @@  discard block
 block discarded – undo
145 145
 	 * @param bool   $check_all
146 146
 	 * @return boolean | int
147 147
 	 */
148
-	private function _reg_steps_completed( EE_Transaction $transaction, $reg_step_slug = '', $check_all = TRUE ) {
148
+	private function _reg_steps_completed(EE_Transaction $transaction, $reg_step_slug = '', $check_all = TRUE) {
149 149
 		$reg_steps = $transaction->reg_steps();
150
-		if ( ! is_array( $reg_steps ) || empty( $reg_steps )) {
150
+		if ( ! is_array($reg_steps) || empty($reg_steps)) {
151 151
 			return false;
152 152
 		}
153 153
 		// loop thru reg steps array)
154
-		foreach ( $reg_steps as $slug => $reg_step_completed ) {
154
+		foreach ($reg_steps as $slug => $reg_step_completed) {
155 155
 			// if NOT checking ALL steps (only checking one step)
156
-			if ( ! $check_all ) {
156
+			if ( ! $check_all) {
157 157
 				// and this is the one
158
-				if ( $slug == $reg_step_slug ) {
158
+				if ($slug == $reg_step_slug) {
159 159
 					return $reg_step_completed;
160 160
 				} else {
161 161
 					// skip to next reg step in loop
@@ -163,9 +163,9 @@  discard block
 block discarded – undo
163 163
 				}
164 164
 			}
165 165
 			// if any reg step is NOT completed (ignoring any specific steps), then just leave
166
-			if ( $reg_step_completed !== true && $slug != $reg_step_slug ) {
166
+			if ($reg_step_completed !== true && $slug != $reg_step_slug) {
167 167
 				return false;
168
-			} else if ( $slug == $reg_step_slug ) {
168
+			} else 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(),
@@ -190,8 +190,8 @@  discard block
 block discarded – undo
190 190
 	 * @param EE_Transaction $transaction
191 191
 	 * @return boolean
192 192
 	 */
193
-	public function all_reg_steps_completed( EE_Transaction $transaction ) {
194
-		return $this->_reg_steps_completed( $transaction );
193
+	public function all_reg_steps_completed(EE_Transaction $transaction) {
194
+		return $this->_reg_steps_completed($transaction);
195 195
 	}
196 196
 
197 197
 
@@ -208,8 +208,8 @@  discard block
 block discarded – undo
208 208
 	 * @param string $exception
209 209
 	 * @return boolean
210 210
 	 */
211
-	public function all_reg_steps_completed_except( EE_Transaction $transaction, $exception = '' ) {
212
-		return $this->_reg_steps_completed( $transaction, $exception );
211
+	public function all_reg_steps_completed_except(EE_Transaction $transaction, $exception = '') {
212
+		return $this->_reg_steps_completed($transaction, $exception);
213 213
 	}
214 214
 
215 215
 
@@ -225,8 +225,8 @@  discard block
 block discarded – undo
225 225
 	 * @param EE_Transaction $transaction
226 226
 	 * @return boolean
227 227
 	 */
228
-	public function all_reg_steps_completed_except_final_step( EE_Transaction $transaction ) {
229
-		return $this->_reg_steps_completed( $transaction, 'finalize_registration' );
228
+	public function all_reg_steps_completed_except_final_step(EE_Transaction $transaction) {
229
+		return $this->_reg_steps_completed($transaction, 'finalize_registration');
230 230
 	}
231 231
 
232 232
 
@@ -243,8 +243,8 @@  discard block
 block discarded – undo
243 243
 	 * @param string $reg_step_slug
244 244
 	 * @return boolean | int
245 245
 	 */
246
-	public function reg_step_completed( EE_Transaction $transaction, $reg_step_slug ) {
247
-		return $this->_reg_steps_completed( $transaction, $reg_step_slug, FALSE );
246
+	public function reg_step_completed(EE_Transaction $transaction, $reg_step_slug) {
247
+		return $this->_reg_steps_completed($transaction, $reg_step_slug, FALSE);
248 248
 	}
249 249
 
250 250
 
@@ -260,8 +260,8 @@  discard block
 block discarded – undo
260 260
 	 * @param EE_Transaction $transaction
261 261
 	 * @return boolean | int
262 262
 	 */
263
-	public function final_reg_step_completed( EE_Transaction $transaction ) {
264
-		return $this->_reg_steps_completed( $transaction, 'finalize_registration', FALSE );
263
+	public function final_reg_step_completed(EE_Transaction $transaction) {
264
+		return $this->_reg_steps_completed($transaction, 'finalize_registration', FALSE);
265 265
 	}
266 266
 
267 267
 
@@ -275,9 +275,9 @@  discard block
 block discarded – undo
275 275
 	 * @param string          $reg_step_slug
276 276
 	 * @return boolean
277 277
 	 */
278
-	public function set_reg_step_initiated( EE_Transaction $transaction, $reg_step_slug ) {
279
-		$current_time = (int)current_time( 'timestamp' );
280
-		return $this->_set_reg_step_completed_status( $transaction, $reg_step_slug, $current_time );
278
+	public function set_reg_step_initiated(EE_Transaction $transaction, $reg_step_slug) {
279
+		$current_time = (int) current_time('timestamp');
280
+		return $this->_set_reg_step_completed_status($transaction, $reg_step_slug, $current_time);
281 281
 	}
282 282
 
283 283
 
@@ -291,8 +291,8 @@  discard block
 block discarded – undo
291 291
 	 * @param string          $reg_step_slug
292 292
 	 * @return boolean
293 293
 	 */
294
-	public function set_reg_step_completed( EE_Transaction $transaction, $reg_step_slug ) {
295
-		return $this->_set_reg_step_completed_status( $transaction, $reg_step_slug, TRUE );
294
+	public function set_reg_step_completed(EE_Transaction $transaction, $reg_step_slug) {
295
+		return $this->_set_reg_step_completed_status($transaction, $reg_step_slug, TRUE);
296 296
 	}
297 297
 
298 298
 
@@ -306,8 +306,8 @@  discard block
 block discarded – undo
306 306
 	 * @param string          $reg_step_slug
307 307
 	 * @return boolean
308 308
 	 */
309
-	public function set_reg_step_not_completed( EE_Transaction $transaction, $reg_step_slug ) {
310
-		return $this->_set_reg_step_completed_status( $transaction, $reg_step_slug, FALSE );
309
+	public function set_reg_step_not_completed(EE_Transaction $transaction, $reg_step_slug) {
310
+		return $this->_set_reg_step_completed_status($transaction, $reg_step_slug, FALSE);
311 311
 	}
312 312
 
313 313
 
@@ -323,36 +323,36 @@  discard block
 block discarded – undo
323 323
 	 * @param boolean | int $status
324 324
 	 * @return boolean
325 325
 	 */
326
-	private function _set_reg_step_completed_status( EE_Transaction $transaction, $reg_step_slug, $status ) {
326
+	private function _set_reg_step_completed_status(EE_Transaction $transaction, $reg_step_slug, $status) {
327 327
 		// validate status
328
-		$status = is_bool( $status ) || is_numeric( $status ) ? $status : false;
328
+		$status = is_bool($status) || is_numeric($status) ? $status : false;
329 329
 		// get reg steps array
330 330
 		$txn_reg_steps = $transaction->reg_steps();
331 331
 		// if reg step does NOT exist
332
-		if ( ! isset( $txn_reg_steps[ $reg_step_slug ] )) {
332
+		if ( ! isset($txn_reg_steps[$reg_step_slug])) {
333 333
 			return false;
334 334
 		}
335 335
 		// if  we're trying to complete a step that is already completed
336
-		if ( $txn_reg_steps[ $reg_step_slug ] === true ) {
336
+		if ($txn_reg_steps[$reg_step_slug] === true) {
337 337
 			return true;
338 338
 		}
339 339
 		// if  we're trying to complete a step that hasn't even started
340
-		if ( $status === true && $txn_reg_steps[ $reg_step_slug ] === false ) {
340
+		if ($status === true && $txn_reg_steps[$reg_step_slug] === false) {
341 341
 			return false;
342 342
 		}
343 343
 		// if current status value matches the incoming value (no change)
344
-		if ( $txn_reg_steps[ $reg_step_slug ] === $status ) {
344
+		if ($txn_reg_steps[$reg_step_slug] === $status) {
345 345
 			// this will happen in cases where multiple AJAX requests occur during the same step
346 346
 			return true;
347 347
 		}
348 348
 		// if we're trying to set a start time
349
-		if ( is_numeric( $status ) && is_numeric( $txn_reg_steps[ $reg_step_slug ] )) {
349
+		if (is_numeric($status) && is_numeric($txn_reg_steps[$reg_step_slug])) {
350 350
 			// skip the update below, but don't return FALSE so that errors won't be displayed
351 351
 			return true;
352 352
 		}
353 353
 		// update completed status
354
-		$txn_reg_steps[ $reg_step_slug ] = $status;
355
-		$transaction->set_reg_steps( $txn_reg_steps );
354
+		$txn_reg_steps[$reg_step_slug] = $status;
355
+		$transaction->set_reg_steps($txn_reg_steps);
356 356
 		$transaction->save();
357 357
 		// DEBUG LOG
358 358
 		//$this->log(
@@ -378,10 +378,10 @@  discard block
 block discarded – undo
378 378
 	 * @param string $reg_step_slug
379 379
 	 * @return void
380 380
 	 */
381
-	public function remove_reg_step( EE_Transaction $transaction, $reg_step_slug ) {
381
+	public function remove_reg_step(EE_Transaction $transaction, $reg_step_slug) {
382 382
 		// get reg steps array
383 383
 		$txn_reg_steps = $transaction->reg_steps();
384
-		unset( $txn_reg_steps[ $reg_step_slug ] );
384
+		unset($txn_reg_steps[$reg_step_slug]);
385 385
 	}
386 386
 
387 387
 
@@ -395,14 +395,14 @@  discard block
 block discarded – undo
395 395
 	 * @param EE_Transaction $transaction
396 396
 	 * 	@return 	boolean
397 397
 	 */
398
-	public function toggle_failed_transaction_status( EE_Transaction $transaction ) {
398
+	public function toggle_failed_transaction_status(EE_Transaction $transaction) {
399 399
 		// set incoming TXN_Status
400
-		$this->set_old_txn_status( $transaction->status_ID() );
400
+		$this->set_old_txn_status($transaction->status_ID());
401 401
 		// if TXN status is still set as "failed"...
402
-		if ( $transaction->status_ID() == EEM_Transaction::failed_status_code ) {
402
+		if ($transaction->status_ID() == EEM_Transaction::failed_status_code) {
403 403
 			// set incoming TXN_Status
404
-			$this->set_new_txn_status( EEM_Transaction::abandoned_status_code );
405
-			$transaction->set_status( EEM_Transaction::abandoned_status_code );
404
+			$this->set_new_txn_status(EEM_Transaction::abandoned_status_code);
405
+			$transaction->set_status(EEM_Transaction::abandoned_status_code);
406 406
 			return TRUE;
407 407
 		}
408 408
 		return FALSE;
@@ -418,14 +418,14 @@  discard block
 block discarded – undo
418 418
 	 * @param EE_Transaction $transaction
419 419
 	 * 	@return 	boolean
420 420
 	 */
421
-	public function toggle_abandoned_transaction_status( EE_Transaction $transaction ) {
421
+	public function toggle_abandoned_transaction_status(EE_Transaction $transaction) {
422 422
 		// set incoming TXN_Status
423
-		$this->set_old_txn_status( $transaction->status_ID() );
423
+		$this->set_old_txn_status($transaction->status_ID());
424 424
 		// if TXN status has not been updated already due to a payment, and is still set as "failed" or "abandoned"...
425
-		if ( $transaction->status_ID() == EEM_Transaction::failed_status_code || $transaction->status_ID() == EEM_Transaction::abandoned_status_code ) {
425
+		if ($transaction->status_ID() == EEM_Transaction::failed_status_code || $transaction->status_ID() == EEM_Transaction::abandoned_status_code) {
426 426
 			// set incoming TXN_Status
427
-			$this->set_new_txn_status( EEM_Transaction::incomplete_status_code );
428
-			$transaction->set_status( EEM_Transaction::incomplete_status_code );
427
+			$this->set_new_txn_status(EEM_Transaction::incomplete_status_code);
428
+			$transaction->set_status(EEM_Transaction::incomplete_status_code);
429 429
 			return TRUE;
430 430
 		}
431 431
 		return FALSE;
@@ -442,9 +442,9 @@  discard block
 block discarded – undo
442 442
 	 * @param array 	$registration_query_params - array of query WHERE params to use when retrieving cached registrations from a transaction
443 443
 	 * 	@return 	boolean
444 444
 	 */
445
-	public function manually_update_registration_statuses( EE_Transaction $transaction, $new_reg_status = '', $registration_query_params = array() ) {
446
-		$status_updates = $this->_call_method_on_registrations_via_Registration_Processor( 'manually_update_registration_status', $transaction, $registration_query_params, $new_reg_status );
447
-		do_action( 'AHEE__EE_Transaction_Processor__manually_update_registration_statuses', $transaction, $status_updates );
445
+	public function manually_update_registration_statuses(EE_Transaction $transaction, $new_reg_status = '', $registration_query_params = array()) {
446
+		$status_updates = $this->_call_method_on_registrations_via_Registration_Processor('manually_update_registration_status', $transaction, $registration_query_params, $new_reg_status);
447
+		do_action('AHEE__EE_Transaction_Processor__manually_update_registration_statuses', $transaction, $status_updates);
448 448
 		return $status_updates;
449 449
 	}
450 450
 
@@ -458,9 +458,9 @@  discard block
 block discarded – undo
458 458
 	 * @param array 	$registration_query_params - array of query WHERE params to use when retrieving cached registrations from a transaction
459 459
 	 * 	@return 	boolean
460 460
 	 */
461
-	public function toggle_registration_statuses_for_default_approved_events( EE_Transaction $transaction, $registration_query_params = array() ) {
462
-		$status_updates = $this->_call_method_on_registrations_via_Registration_Processor( 'toggle_registration_status_for_default_approved_events', $transaction, $registration_query_params );
463
-		do_action( 'AHEE__EE_Transaction_Processor__toggle_registration_statuses_for_default_approved_events', $transaction, $status_updates );
461
+	public function toggle_registration_statuses_for_default_approved_events(EE_Transaction $transaction, $registration_query_params = array()) {
462
+		$status_updates = $this->_call_method_on_registrations_via_Registration_Processor('toggle_registration_status_for_default_approved_events', $transaction, $registration_query_params);
463
+		do_action('AHEE__EE_Transaction_Processor__toggle_registration_statuses_for_default_approved_events', $transaction, $status_updates);
464 464
 		return $status_updates;
465 465
 	}
466 466
 
@@ -474,9 +474,9 @@  discard block
 block discarded – undo
474 474
 	 * @param array 	$registration_query_params - array of query WHERE params to use when retrieving cached registrations from a transaction
475 475
 	 * 	@return 	boolean
476 476
 	 */
477
-	public function toggle_registration_statuses_if_no_monies_owing( EE_Transaction $transaction, $registration_query_params = array() ) {
478
-		$status_updates = $this->_call_method_on_registrations_via_Registration_Processor( 'toggle_registration_status_if_no_monies_owing', $transaction, $registration_query_params );
479
-		do_action( 'AHEE__EE_Transaction_Processor__toggle_registration_statuses_if_no_monies_owing', $transaction, $status_updates );
477
+	public function toggle_registration_statuses_if_no_monies_owing(EE_Transaction $transaction, $registration_query_params = array()) {
478
+		$status_updates = $this->_call_method_on_registrations_via_Registration_Processor('toggle_registration_status_if_no_monies_owing', $transaction, $registration_query_params);
479
+		do_action('AHEE__EE_Transaction_Processor__toggle_registration_statuses_if_no_monies_owing', $transaction, $status_updates);
480 480
 		return $status_updates;
481 481
 	}
482 482
 
@@ -492,16 +492,16 @@  discard block
 block discarded – undo
492 492
 	 * @throws \EE_Error
493 493
 	 * @return array
494 494
 	 */
495
-	public function update_transaction_and_registrations_after_checkout_or_payment( EE_Transaction $transaction, $payment = NULL, $registration_query_params = array() ) {
495
+	public function update_transaction_and_registrations_after_checkout_or_payment(EE_Transaction $transaction, $payment = NULL, $registration_query_params = array()) {
496 496
 		// set incoming TXN_Status, and consider it new since old status should have been set
497
-		$this->set_new_txn_status( $transaction->status_ID() );
497
+		$this->set_new_txn_status($transaction->status_ID());
498 498
 		// make sure some query params are set for retrieving registrations
499
-		$this->_set_registration_query_params( $registration_query_params );
499
+		$this->_set_registration_query_params($registration_query_params);
500 500
 		// get final reg step status
501
-		$finalized = $this->final_reg_step_completed( $transaction );
501
+		$finalized = $this->final_reg_step_completed($transaction);
502 502
 		// if the 'finalize_registration' step has been initiated (has a timestamp) but has not yet been fully completed (TRUE)
503
-		if ( is_numeric( $finalized ) && $finalized !== true ) {
504
-			$this->set_reg_step_completed( $transaction, 'finalize_registration' );
503
+		if (is_numeric($finalized) && $finalized !== true) {
504
+			$this->set_reg_step_completed($transaction, 'finalize_registration');
505 505
 			$finalized = true;
506 506
 		}
507 507
 		$transaction->save();
@@ -521,7 +521,7 @@  discard block
 block discarded – undo
521 521
 			$this->_registration_query_params,
522 522
 			$update_params
523 523
 		);
524
-		do_action( 'AHEE__EE_Transaction_Processor__update_transaction_and_registrations_after_checkout_or_payment', $transaction, $update_params );
524
+		do_action('AHEE__EE_Transaction_Processor__update_transaction_and_registrations_after_checkout_or_payment', $transaction, $update_params);
525 525
 		return $update_params;
526 526
 	}
527 527
 
@@ -539,23 +539,23 @@  discard block
 block discarded – undo
539 539
 	 * @throws \EE_Error
540 540
 	 * @return boolean
541 541
 	 */
542
-	private function _call_method_on_registrations_via_Registration_Processor( $method_name,  EE_Transaction $transaction, $registration_query_params = array(), $additional_param = NULL ) {
542
+	private function _call_method_on_registrations_via_Registration_Processor($method_name, EE_Transaction $transaction, $registration_query_params = array(), $additional_param = NULL) {
543 543
 		$response = FALSE;
544 544
 		/** @type EE_Registration_Processor $registration_processor */
545
-		$registration_processor = EE_Registry::instance()->load_class( 'Registration_Processor' );
545
+		$registration_processor = EE_Registry::instance()->load_class('Registration_Processor');
546 546
 		// check that method exists
547
-		if ( ! method_exists( $registration_processor, $method_name )) {
548
-			throw new EE_Error( __( 'Method does not exist.', 'event_espresso' ));
547
+		if ( ! method_exists($registration_processor, $method_name)) {
548
+			throw new EE_Error(__('Method does not exist.', 'event_espresso'));
549 549
 		}
550 550
 		// make sure some query params are set for retrieving registrations
551
-		$this->_set_registration_query_params( $registration_query_params );
551
+		$this->_set_registration_query_params($registration_query_params);
552 552
 		// loop through cached registrations
553
-		foreach ( $transaction->registrations( $this->_registration_query_params ) as $registration ) {
554
-			if ( $registration instanceof EE_Registration ) {
555
-				if ( $additional_param ) {
556
-					$response = $registration_processor->$method_name( $registration, $additional_param ) ? TRUE : $response;
553
+		foreach ($transaction->registrations($this->_registration_query_params) as $registration) {
554
+			if ($registration instanceof EE_Registration) {
555
+				if ($additional_param) {
556
+					$response = $registration_processor->$method_name($registration, $additional_param) ? TRUE : $response;
557 557
 				} else {
558
-					$response = $registration_processor->$method_name( $registration ) ? TRUE : $response;
558
+					$response = $registration_processor->$method_name($registration) ? TRUE : $response;
559 559
 				}
560 560
 			}
561 561
 		}
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.
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -71,7 +71,7 @@
 block discarded – undo
71 71
 		$question_type = $this->_get_question_type($new_question_id);
72 72
 		if(in_array($question_type,array('MULTIPLE'))){
73 73
 			$ans_value = serialize(explode(",",stripslashes($old_answer['answer'])));
74
-		}else{
74
+		} else{
75 75
 			$ans_value = stripslashes($old_answer['answer']);
76 76
 		}
77 77
 		$cols_n_values = array(
Please login to merge, or discard this patch.
Spacing   +17 added lines, -17 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,14 +47,14 @@  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);
57
-			if($new_answer_id){
55
+		foreach ($regs as $new_reg_id) {
56
+			$new_answer_id = $this->_insert_new_answer($old_row, $new_reg_id);
57
+			if ($new_answer_id) {
58 58
 				$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_answer_table, $new_answer_id);
59 59
 			}	
60 60
 		}
@@ -66,15 +66,15 @@  discard block
 block discarded – undo
66 66
 	 * @param int $new_reg_id
67 67
 	 * @return int
68 68
 	 */
69
-	private function _insert_new_answer($old_answer,$new_reg_id){		
69
+	private function _insert_new_answer($old_answer, $new_reg_id) {		
70 70
 		global $wpdb;
71 71
 		$old_question_table = $wpdb->prefix."events_question";
72 72
 		$new_question_id = $this->get_migration_script()->get_mapping_new_pk($old_question_table, $old_answer['question_id'], $this->_new_question_table);
73 73
 		
74 74
 		$question_type = $this->_get_question_type($new_question_id);
75
-		if(in_array($question_type,array('MULTIPLE'))){
76
-			$ans_value = serialize(explode(",",stripslashes($old_answer['answer'])));
77
-		}else{
75
+		if (in_array($question_type, array('MULTIPLE'))) {
76
+			$ans_value = serialize(explode(",", stripslashes($old_answer['answer'])));
77
+		} else {
78 78
 			$ans_value = stripslashes($old_answer['answer']);
79 79
 		}
80 80
 		$cols_n_values = array(
@@ -83,12 +83,12 @@  discard block
 block discarded – undo
83 83
 			'ANS_value'=>$ans_value
84 84
 		);
85 85
 		$datatypes = array(
86
-			'%d',//REG_ID
87
-			'%d',//QST_ID
88
-			'%s',//ANS_value
86
+			'%d', //REG_ID
87
+			'%d', //QST_ID
88
+			'%s', //ANS_value
89 89
 		);
90
-		$success = $wpdb->insert($this->_new_answer_table,$cols_n_values,$datatypes);
91
-		if ( ! $success){
90
+		$success = $wpdb->insert($this->_new_answer_table, $cols_n_values, $datatypes);
91
+		if ( ! $success) {
92 92
 			$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));
93 93
 			return 0;
94 94
 		}
@@ -102,9 +102,9 @@  discard block
 block discarded – undo
102 102
 	 * @param type $question_id
103 103
 	 * @return string
104 104
 	 */
105
-	private function _get_question_type($question_id){
105
+	private function _get_question_type($question_id) {
106 106
 		global $wpdb;
107
-		$type = $wpdb->get_var($wpdb->prepare("SELECT QST_type FROM ".$this->_new_question_table." WHERE QST_ID=%d LIMIT 1",$question_id));
107
+		$type = $wpdb->get_var($wpdb->prepare("SELECT QST_type FROM ".$this->_new_question_table." WHERE QST_ID=%d LIMIT 1", $question_id));
108 108
 		return $type;
109 109
 	}
110 110
 	
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.
Indentation   -3 removed lines patch added patch discarded remove patch
@@ -84,9 +84,6 @@
 block discarded – undo
84 84
   KEY `submitted` (`submitted`),
85 85
   KEY `likes` (`likes`)
86 86
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8$$
87
-
88
-
89
-
90 87
  * 4.1 Attendee tables and fields:
91 88
  * $this->_tables = array(
92 89
 			'Attendee_CPT'=> new EE_Primary_Table('posts', 'ID'),
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.
Spacing   +176 added lines, -176 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 524
 				'REG_session'=>$old_attendee['attendee_session'],
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,16 +660,16 @@  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,
@@ -677,44 +677,44 @@  discard block
 block discarded – undo
677 677
 
678 678
 				),
679 679
 				array(
680
-					'%s',//name
681
-					'%d',//qty
682
-					'%d',//price
680
+					'%s', //name
681
+					'%d', //qty
682
+					'%d', //price
683 683
 				));
684 684
 		$ticket_id = $wpdb->insert_id;
685 685
 		//associate the ticket with the datetime we found earlier
686
-		$wpdb->insert( $this->_new_datetime_ticket_table,
686
+		$wpdb->insert($this->_new_datetime_ticket_table,
687 687
 				array(
688 688
 					'DTT_ID' => $datetime_id,
689 689
 					'TKT_ID' => $ticket_id
690 690
 				),
691 691
 				array(
692
-					'%d',//DTT_ID
693
-					'%d',//TKT_ID
692
+					'%d', //DTT_ID
693
+					'%d', //TKT_ID
694 694
 				));
695 695
 		//insert new price
696
-		$wpdb->insert( $this->_new_price_table,
696
+		$wpdb->insert($this->_new_price_table,
697 697
 				array(
698 698
 					'PRC_amount' => $old_att_price,
699 699
 					'PRC_name' => $old_att_price_option,
700 700
 					'PRC_deleted' => TRUE
701 701
 				),
702 702
 				array(
703
-					'%d',//PRC_amount
704
-					'%s',//PRC_name
705
-					'%d',//PRC_deleted
703
+					'%d', //PRC_amount
704
+					'%s', //PRC_name
705
+					'%d', //PRC_deleted
706 706
 				));
707 707
 		$price_id = $wpdb->insert_id;
708 708
 		//associate the price to the ticket
709
-		$wpdb->insert( $this->_new_ticket_price_table,
709
+		$wpdb->insert($this->_new_ticket_price_table,
710 710
 				array(
711 711
 					'TKT_ID' => $ticket_id,
712 712
 					'PRC_ID' => $price_id
713 713
 				),
714 714
 				array(
715
-					'%d',//TKT_ID
716
-					'%d',//PRC_ID
717
-				) );
715
+					'%d', //TKT_ID
716
+					'%d', //PRC_ID
717
+				));
718 718
 		return $ticket_id;
719 719
 	}
720 720
 	/**
@@ -725,12 +725,12 @@  discard block
 block discarded – undo
725 725
 	 * @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
726 726
 	 * @return int
727 727
 	 */
728
-	private function _sum_old_attendees_on_old_txn($old_attendee_row,$count_only_older = false){
728
+	private function _sum_old_attendees_on_old_txn($old_attendee_row, $count_only_older = false) {
729 729
 		global $wpdb;
730
-		$count_only_older_sql = $count_only_older ? $wpdb->prepare(" AND id<%d",$old_attendee_row['id']) : '';
731
-		$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'])));
730
+		$count_only_older_sql = $count_only_older ? $wpdb->prepare(" AND id<%d", $old_attendee_row['id']) : '';
731
+		$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'])));
732 732
 
733
-		if( $this->_mer_tables_exist()){
733
+		if ($this->_mer_tables_exist()) {
734 734
 			//if MER exists, then its a little tricky.
735 735
 			//when users registered by adding items to the cart, and it was a
736 736
 			//group registration requiring additional attendee INFO, then the attendee rows
@@ -739,17 +739,17 @@  discard block
 block discarded – undo
739 739
 			//BUT we want to count all the MER attendee rows for the same registration
740 740
 			$primary_attendee = $this->_find_mer_primary_attendee_using_mer_tables($old_attendee_row['registration_id']);
741 741
 
742
-			$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']));
743
-			$count = max($count_using_mer_table,$count);
742
+			$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']));
743
+			$count = max($count_using_mer_table, $count);
744 744
 		}
745 745
 		return $count;
746 746
 	}
747
-	private function _insert_new_payment($old_attendee,$new_txn_id){
747
+	private function _insert_new_payment($old_attendee, $new_txn_id) {
748 748
 		global $wpdb;
749 749
 		//only add a payment for primary attendees
750
-		$old_pay_stati_indicating_no_payment = array('Pending','Incomplete','Not Completed');
750
+		$old_pay_stati_indicating_no_payment = array('Pending', 'Incomplete', 'Not Completed');
751 751
 		//if this is for a primary 3.1 attendee which WASN'T free and has a completed, cancelled, or declined payment...
752
-		if(intval($old_attendee['is_primary']) && floatval($old_attendee['total_cost']) && ! in_array($old_attendee['payment_status'], $old_pay_stati_indicating_no_payment)){
752
+		if (intval($old_attendee['is_primary']) && floatval($old_attendee['total_cost']) && ! in_array($old_attendee['payment_status'], $old_pay_stati_indicating_no_payment)) {
753 753
 			$pay_status_mapping = array(
754 754
 				'Completed'=>'PAP',
755 755
 				'Payment Declined'=>'PDC',
@@ -757,11 +757,11 @@  discard block
 block discarded – undo
757 757
 				'Declined'=>'PDC'
758 758
 			);
759 759
 			$by_admin = $old_attendee['payment'] == 'Admin';
760
-			$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
760
+			$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
761 761
 			$cols_n_values = array(
762 762
 				'TXN_ID'=>$new_txn_id,
763 763
 				'STS_ID'=>$STS_ID,
764
-				'PAY_timestamp'=>$this->get_migration_script()->convert_date_string_to_utc($this,$old_attendee,$old_attendee['date']),
764
+				'PAY_timestamp'=>$this->get_migration_script()->convert_date_string_to_utc($this, $old_attendee, $old_attendee['date']),
765 765
 				'PAY_method'=>'CART',
766 766
 				'PAY_amount'=>$old_attendee['amount_pd'],
767 767
 				'PAY_gateway'=>$old_attendee['txn_type'],
@@ -772,26 +772,26 @@  discard block
 block discarded – undo
772 772
 
773 773
 			);
774 774
 			$datatypes = array(
775
-				'%d',//TXN_Id
776
-				'%s',//STS_ID
777
-				'%s',//PAY_timestamp
778
-				'%s',//PAY_method
779
-				'%f',//PAY_amount
780
-				'%s',//PAY_gateway
781
-				'%s',//PAY_gateway_response
782
-				'%s',//PAY_txn_id_chq_nmbr
783
-				'%d',//PAY_via_admin
784
-				'%s',//PAY_details
775
+				'%d', //TXN_Id
776
+				'%s', //STS_ID
777
+				'%s', //PAY_timestamp
778
+				'%s', //PAY_method
779
+				'%f', //PAY_amount
780
+				'%s', //PAY_gateway
781
+				'%s', //PAY_gateway_response
782
+				'%s', //PAY_txn_id_chq_nmbr
783
+				'%d', //PAY_via_admin
784
+				'%s', //PAY_details
785 785
 			);
786
-			$success = $wpdb->insert($this->_new_payment_table,$cols_n_values,$datatypes);
787
-			if ( ! $success){
786
+			$success = $wpdb->insert($this->_new_payment_table, $cols_n_values, $datatypes);
787
+			if ( ! $success) {
788 788
 				$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));
789 789
 				return 0;
790 790
 			}
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
 
@@ -804,12 +804,12 @@  discard block
 block discarded – undo
804 804
 	 * @param type $old_registration_id
805 805
 	 * @return array
806 806
 	 */
807
-	private function _find_mer_primary_attendee_using_mer_tables($old_registration_id){
808
-		if (! $this->_mer_tables_exist()){
807
+	private function _find_mer_primary_attendee_using_mer_tables($old_registration_id) {
808
+		if ( ! $this->_mer_tables_exist()) {
809 809
 			return false;
810 810
 		}
811 811
 		global $wpdb;
812
-		$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);
812
+		$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);
813 813
 return $old_att_for_primary_reg;
814 814
 	}
815 815
 
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
@@ -58,7 +58,7 @@
 block discarded – undo
58 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 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);
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.
Indentation   -2 removed lines patch added patch discarded remove patch
@@ -16,8 +16,6 @@
 block discarded – undo
16 16
 			'EQG_primary'=>new EE_Boolean_Field('EQG_primary', __('Flag indicating question is only for primary attendees','event_espresso'), false, false)
17 17
 		)
18 18
 	);
19
-
20
-
21 19
  *
22 20
  */
23 21
 class EE_DMS_4_1_0_event_question_group extends EE_Data_Migration_Script_Stage_Table{
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.
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.
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
 	/**
@@ -261,11 +261,11 @@  discard block
 block discarded – undo
261 261
 	 * @param string $event_name
262 262
 	 * @return string
263 263
 	 */
264
-	private function _find_unique_slug($event_name, $old_identifier = ''){
264
+	private function _find_unique_slug($event_name, $old_identifier = '') {
265 265
 		$count = 0;
266 266
 		$original_name = $event_name ? sanitize_title($event_name) : $old_identifier;
267 267
 		$event_slug = $original_name;
268
-		while( $this->_other_post_exists_with_that_slug($event_slug) && $count<50){
268
+		while ($this->_other_post_exists_with_that_slug($event_slug) && $count < 50) {
269 269
 			$event_slug = sanitize_title($original_name."-".++$count);
270 270
 		}
271 271
 		return $event_slug;
@@ -277,13 +277,13 @@  discard block
 block discarded – undo
277 277
 	 * @param type $slug
278 278
 	 * @return boolean
279 279
 	 */
280
-	private function _other_post_exists_with_that_slug($slug){
280
+	private function _other_post_exists_with_that_slug($slug) {
281 281
 		global $wpdb;
282
-		$query = $wpdb->prepare("SELECT COUNT(ID) FROM ".$this->_new_table." WHERE post_name = %s",$slug);
282
+		$query = $wpdb->prepare("SELECT COUNT(ID) FROM ".$this->_new_table." WHERE post_name = %s", $slug);
283 283
 		$count = $wpdb->get_var($query);
284
-		return (boolean)intval($count);
284
+		return (boolean) intval($count);
285 285
 	}
286
-	private function _insert_cpt($old_event){
286
+	private function _insert_cpt($old_event) {
287 287
 		global $wpdb;
288 288
 		//convert 3.1 event status to 4.1 CPT status
289 289
 		//for refrence, 3.1 event stati available for setting are:
@@ -302,55 +302,55 @@  discard block
 block discarded – undo
302 302
 //		and 3 custom ones: cancelled,postponed,sold_out
303 303
 		$status_conversions = array(
304 304
 			'R'=>'draft',
305
-			'X'=>'draft',//4.1 doesn't have a "not approved for publishing" status. this is what posts are set to that aren't approved
305
+			'X'=>'draft', //4.1 doesn't have a "not approved for publishing" status. this is what posts are set to that aren't approved
306 306
 			'P'=>'pending',
307
-			'IA'=>'draft',//draft and in the past
307
+			'IA'=>'draft', //draft and in the past
308 308
 //IA=inactive in 3.1: events were switched to this when they expired. in 4.1 that's just calculated
309
-			'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'
309
+			'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'
310 310
 			'A'=>'publish',
311
-			'S'=>'draft',//@todo: is it ok to just mark secondary/waitlist events as DRAFTS?
311
+			'S'=>'draft', //@todo: is it ok to just mark secondary/waitlist events as DRAFTS?
312 312
 			'D'=>'trash',
313 313
 		);
314 314
 		$post_status = $status_conversions[$old_event['event_status']];
315 315
 		//check if we've sold out
316
-		if (intval($old_event['reg_limit']) <= self::count_registrations($old_event['id'])){
316
+		if (intval($old_event['reg_limit']) <= self::count_registrations($old_event['id'])) {
317 317
 			$post_status = 'sold_out';
318 318
 		}
319 319
 //		FYI postponed and cancelled don't exist in 3.1
320 320
 		$cols_n_values = array(
321
-			'post_title'=>stripslashes($old_event['event_name']),//EVT_name
322
-			'post_content'=>stripslashes($old_event['event_desc']),//EVT_desc
323
-			'post_name'=>$this->_find_unique_slug($old_event['event_name']),//$old_event['event_identifier'],//EVT_slug
324
-			'post_date'=>$old_event['submitted'],//EVT_created NOT
321
+			'post_title'=>stripslashes($old_event['event_name']), //EVT_name
322
+			'post_content'=>stripslashes($old_event['event_desc']), //EVT_desc
323
+			'post_name'=>$this->_find_unique_slug($old_event['event_name']), //$old_event['event_identifier'],//EVT_slug
324
+			'post_date'=>$old_event['submitted'], //EVT_created NOT
325 325
 			'post_date_gmt'=>get_gmt_from_date($old_event['submitted']),
326
-			'post_excerpt'=>'',//EVT_short_desc
327
-			'post_modified'=>$old_event['submitted'],//EVT_modified
326
+			'post_excerpt'=>'', //EVT_short_desc
327
+			'post_modified'=>$old_event['submitted'], //EVT_modified
328 328
 			'post_modified_gmt'=>get_gmt_from_date($old_event['submitted']),
329
-			'post_author'=>$old_event['wp_user'],//EVT_wp_user
330
-			'post_parent'=>null,//parent maybe get this from some REM field?
331
-			'menu_order'=>null,//EVT_order
332
-			'post_type'=>'espresso_events',//post_type
333
-			'post_status'=>$post_status,//status
329
+			'post_author'=>$old_event['wp_user'], //EVT_wp_user
330
+			'post_parent'=>null, //parent maybe get this from some REM field?
331
+			'menu_order'=>null, //EVT_order
332
+			'post_type'=>'espresso_events', //post_type
333
+			'post_status'=>$post_status, //status
334 334
 		);
335 335
 		$datatypes = array(
336
-			'%s',//EVT_name
337
-			'%s',//EVT_desc
338
-			'%s',//EVT_slug
339
-			'%s',//EVT_created
336
+			'%s', //EVT_name
337
+			'%s', //EVT_desc
338
+			'%s', //EVT_slug
339
+			'%s', //EVT_created
340 340
 			'%s',
341
-			'%s',//EVT_short_desc
342
-			'%s',//EVT_modified
341
+			'%s', //EVT_short_desc
342
+			'%s', //EVT_modified
343 343
 			'%s',
344
-			'%s',//EVT_wp_user
345
-			'%d',//post_parent
346
-			'%d',//EVT_order
347
-			'%s',//post_type
348
-			'%s',//status
344
+			'%s', //EVT_wp_user
345
+			'%d', //post_parent
346
+			'%d', //EVT_order
347
+			'%s', //post_type
348
+			'%s', //status
349 349
 		);
350 350
 		$success = $wpdb->insert($this->_new_table,
351 351
 				$cols_n_values,
352 352
 				$datatypes);
353
-		if( ! $success ){
353
+		if ( ! $success) {
354 354
 			$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));
355 355
 			return 0;
356 356
 		}
@@ -363,13 +363,13 @@  discard block
 block discarded – undo
363 363
 	 * @param type $event_id
364 364
 	 * @return int
365 365
 	 */
366
-	public static function count_registrations($event_id){
366
+	public static function count_registrations($event_id) {
367 367
 		global $wpdb;
368
-		$count = $wpdb->get_var($wpdb->prepare("SELECT sum(quantity) FROM {$wpdb->prefix}events_attendee WHERE event_id=%d",$event_id));
368
+		$count = $wpdb->get_var($wpdb->prepare("SELECT sum(quantity) FROM {$wpdb->prefix}events_attendee WHERE event_id=%d", $event_id));
369 369
 		return intval($count);
370 370
 	}
371 371
 
372
-	private function _insert_event_meta($old_event,$new_cpt_id){
372
+	private function _insert_event_meta($old_event, $new_cpt_id) {
373 373
 		global $wpdb;
374 374
 		$event_meta = maybe_unserialize($old_event['event_meta']);
375 375
 //		for reference, 3.1 'default_payment_status' are: $default_payment_status = array(
@@ -380,10 +380,10 @@  discard block
 block discarded – undo
380 380
 //);
381 381
 		$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']));
382 382
 		$cols_n_values = array(
383
-			'EVT_ID'=>$new_cpt_id,//EVT_ID_fk
383
+			'EVT_ID'=>$new_cpt_id, //EVT_ID_fk
384 384
 			'EVT_display_desc'=> 'Y' == $old_event['display_desc'],
385
-			'EVT_display_ticket_selector'=> 'Y'== $old_event['display_reg_form'],
386
-			'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
385
+			'EVT_display_ticket_selector'=> 'Y' == $old_event['display_reg_form'],
386
+			'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
387 387
 			'EVT_additional_limit'=> $old_event['allow_multiple'] == 'N' ? 1 : $old_event['additional_limit'],
388 388
 			'EVT_default_registration_status' => $default_reg_status,
389 389
 			'EVT_member_only'=>$old_event['member_only'],
@@ -395,31 +395,31 @@  discard block
 block discarded – undo
395 395
 
396 396
 		);
397 397
 		$datatypes = array(
398
-			'%s',//EVT_ID
399
-			'%d',//EVT_display_desc
400
-			'%d',//EVT_display_ticket_selector
401
-			'%s',//EVT_visible_on
402
-			'%d',//EVT_additional_limit
403
-			'%s',//EVT_default_registration_status
404
-			'%d',//EVT_member_only
405
-			'%s',//EVT_phone
406
-			'%d',//EVT_allow_overflow
407
-			'%s',//EVT_timezone_string
408
-			'%s',//EVT_external_URL
409
-			'%d',//EVT_donations
398
+			'%s', //EVT_ID
399
+			'%d', //EVT_display_desc
400
+			'%d', //EVT_display_ticket_selector
401
+			'%s', //EVT_visible_on
402
+			'%d', //EVT_additional_limit
403
+			'%s', //EVT_default_registration_status
404
+			'%d', //EVT_member_only
405
+			'%s', //EVT_phone
406
+			'%d', //EVT_allow_overflow
407
+			'%s', //EVT_timezone_string
408
+			'%s', //EVT_external_URL
409
+			'%d', //EVT_donations
410 410
 		);
411 411
 		$success = $wpdb->insert($this->_new_meta_table,
412 412
 				$cols_n_values,
413 413
 				$datatypes);
414
-		if( ! $success ){
414
+		if ( ! $success) {
415 415
 			$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));
416 416
 			return 0;
417 417
 		}
418 418
 		return $wpdb->insert_id;
419 419
 	}
420 420
 
421
-	private function _maybe_create_venue($old_event){
422
-		if(		$old_event['address'] ||
421
+	private function _maybe_create_venue($old_event) {
422
+		if ($old_event['address'] ||
423 423
 				$old_event['address2'] ||
424 424
 				$old_event['city'] ||
425 425
 				$old_event['state'] ||
@@ -430,21 +430,21 @@  discard block
 block discarded – undo
430 430
 				$old_event['venue_phone'] ||
431 431
 				$old_event['virtual_url'] ||
432 432
 				$old_event['virtual_phone']
433
-				){
434
-			$old_id = $this->_duplicate_venue_exists( $old_event );
435
-			if( $old_id ){
433
+				) {
434
+			$old_id = $this->_duplicate_venue_exists($old_event);
435
+			if ($old_id) {
436 436
 				return $old_id;
437 437
 			}
438 438
 			$new_id = $this->_insert_venue_into_posts($old_event);
439
-			if( $new_id ){
439
+			if ($new_id) {
440 440
 				$this->_insert_venue_into_meta_table($new_id, $old_event);
441
-				$guid = isset($old_event['venue_image']) ? $old_event['venue_image']  : null;
442
-				$this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid, $new_id,$this);
441
+				$guid = isset($old_event['venue_image']) ? $old_event['venue_image'] : null;
442
+				$this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid, $new_id, $this);
443 443
 			}
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
 	}
@@ -455,29 +455,29 @@  discard block
 block discarded – undo
455 455
 	 * @param array $old_event
456 456
 	 * @return int duplicate venue id
457 457
 	 */
458
-	private function _duplicate_venue_exists($old_event){
458
+	private function _duplicate_venue_exists($old_event) {
459 459
 		global $wpdb;
460 460
 		$conditions = array(
461
-			'VNU_address' => $old_event [ 'address' ],
462
-			'VNU_address2' => $old_event[ 'address2' ],
463
-			'VNU_city' => $old_event[ 'city' ],
464
-			'VNU_zip' => $old_event[ 'zip' ],
461
+			'VNU_address' => $old_event ['address'],
462
+			'VNU_address2' => $old_event['address2'],
463
+			'VNU_city' => $old_event['city'],
464
+			'VNU_zip' => $old_event['zip'],
465 465
 			'post_title'=> stripslashes($old_event['venue_title']),
466
-			'VNU_phone'=>$old_event['venue_phone'],//VNU_phone
467
-			'VNU_url'=>$old_event['venue_url'],//VNU_url
468
-			'VNU_virtual_phone'=>$old_event['virtual_phone'],//VNU_virtual_phone
469
-			'VNU_virtual_url'=>$old_event['virtual_url'],//VNU_virtual_url
466
+			'VNU_phone'=>$old_event['venue_phone'], //VNU_phone
467
+			'VNU_url'=>$old_event['venue_url'], //VNU_url
468
+			'VNU_virtual_phone'=>$old_event['virtual_phone'], //VNU_virtual_phone
469
+			'VNU_virtual_url'=>$old_event['virtual_url'], //VNU_virtual_url
470 470
 		);
471 471
 		$sql_conditions = array();
472
-		foreach($conditions as $column => $value){
472
+		foreach ($conditions as $column => $value) {
473 473
 			$sql_conditions [] = "$column = '$value'";
474 474
 		}
475 475
 		$query = "SELECT VNU_ID
476 476
 					FROM
477 477
 		{$wpdb->posts} as p INNER JOIN
478 478
 		{$wpdb->prefix}esp_venue_meta as v ON p.ID = v.VNU_ID
479
-			WHERE " . implode( " AND ",$sql_conditions ) . " LIMIT 1";
480
-		$id = $wpdb->get_var( $query );
479
+			WHERE ".implode(" AND ", $sql_conditions)." LIMIT 1";
480
+		$id = $wpdb->get_var($query);
481 481
 		return $id;
482 482
 	}
483 483
 
@@ -486,40 +486,40 @@  discard block
 block discarded – undo
486 486
 	 * @param array $old_venue keys are cols, values are col values
487 487
 	 * @return int
488 488
 	 */
489
-	private function _insert_venue_into_posts($old_event){
489
+	private function _insert_venue_into_posts($old_event) {
490 490
 		global $wpdb;
491 491
 		$insertion_array = array(
492
-					'post_title'=>$old_event['venue_title'] ? stripslashes($old_event['venue_title']) : stripslashes( sprintf( __( 'Venue of %s', 'event_espresso' ), $old_event['event_name'])),//VNU_name
493
-					'post_content'=>'',//VNU_desc
494
-					'post_name'=> $this->_find_unique_slug( $old_event['venue_title'], sanitize_title( 'venue-of-' . $old_event['event_name'] ) ),//VNU_identifier
495
-					'post_date'=>current_time('mysql'),//VNU_created
492
+					'post_title'=>$old_event['venue_title'] ? stripslashes($old_event['venue_title']) : stripslashes(sprintf(__('Venue of %s', 'event_espresso'), $old_event['event_name'])), //VNU_name
493
+					'post_content'=>'', //VNU_desc
494
+					'post_name'=> $this->_find_unique_slug($old_event['venue_title'], sanitize_title('venue-of-'.$old_event['event_name'])), //VNU_identifier
495
+					'post_date'=>current_time('mysql'), //VNU_created
496 496
 					'post_date_gmt'=>get_gmt_from_date(current_time('mysql')),
497
-					'post_excerpt'=>'',//VNU_short_desc arbitraty only 50 characters
498
-					'post_modified'=>current_time('mysql'),//VNU_modified
497
+					'post_excerpt'=>'', //VNU_short_desc arbitraty only 50 characters
498
+					'post_modified'=>current_time('mysql'), //VNU_modified
499 499
 					'post_modified_gmt'=>get_gmt_from_date(current_time('mysql')),
500
-					'post_author'=>$old_event['wp_user'],//VNU_wp_user
501
-					'post_parent'=>null,//parent
502
-					'menu_order'=>0,//VNU_order
500
+					'post_author'=>$old_event['wp_user'], //VNU_wp_user
501
+					'post_parent'=>null, //parent
502
+					'menu_order'=>0, //VNU_order
503 503
 					'post_type'=>'espresso_venues'//post_type
504 504
 				);
505 505
 		$datatypes_array = array(
506
-					'%s',//VNU_name
507
-					'%s',//VNU_desc
508
-					'%s',//VNU_identifier
509
-					'%s',//VNU_created
506
+					'%s', //VNU_name
507
+					'%s', //VNU_desc
508
+					'%s', //VNU_identifier
509
+					'%s', //VNU_created
510 510
 					'%s',
511
-					'%s',//VNU_short_desc
512
-					'%s',//VNU_modified
511
+					'%s', //VNU_short_desc
512
+					'%s', //VNU_modified
513 513
 					'%s',
514
-					'%d',//VNU_wp_user
515
-					'%d',//parent
516
-					'%d',//VNU_order
517
-					'%s',//post_type
514
+					'%d', //VNU_wp_user
515
+					'%d', //parent
516
+					'%d', //VNU_order
517
+					'%s', //post_type
518 518
 				);
519 519
 		$success = $wpdb->insert($wpdb->posts,
520 520
 				$insertion_array,
521 521
 				$datatypes_array);
522
-		if( ! $success ){
522
+		if ( ! $success) {
523 523
 			$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));
524 524
 			return 0;
525 525
 		}
@@ -532,78 +532,78 @@  discard block
 block discarded – undo
532 532
 	 * @param type $old_event
533 533
 	 * @return int
534 534
 	 */
535
-	private function _insert_venue_into_meta_table($cpt_id,$old_event){
535
+	private function _insert_venue_into_meta_table($cpt_id, $old_event) {
536 536
 		global $wpdb;
537 537
 
538 538
 		//assume the country is the same as the organization's old settings
539 539
 		$country_iso = $this->get_migration_script()->get_default_country_iso();
540 540
 		//find the state from the venue, or the organization, or just guess california
541
-		if( ! $old_event['state']){
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
-		if ( ! $state_name ){
547
+		if ( ! $state_name) {
548 548
 			$state_name = 'CA';
549 549
 		}
550 550
 		//get a state ID with the same name, if possible
551
-		try{
552
-			$state = $this->get_migration_script()->get_or_create_state($state_name,$country_iso);
551
+		try {
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
 		}
558 558
 		//now insert into meta table
559 559
 		$insertion_array = array(
560
-			'VNU_ID'=>$cpt_id,//VNU_ID_fk
561
-			'VNU_address'=>stripslashes($old_event['address']),//VNU_address
562
-			'VNU_address2'=>stripslashes($old_event['address2']),//VNU_address2
563
-			'VNU_city'=>stripslashes($old_event['city']),//VNU_city
564
-			'STA_ID'=>$state_id,//STA_ID
565
-			'CNT_ISO'=>$country_iso,//CNT_ISO
566
-			'VNU_zip'=>$old_event['zip'],//VNU_zip
567
-			'VNU_phone'=>$old_event['venue_phone'],//VNU_phone
568
-			'VNU_capacity'=>-1,//VNU_capacity
569
-			'VNU_url'=>$old_event['venue_url'],//VNU_url
570
-			'VNU_virtual_phone'=>$old_event['virtual_phone'],//VNU_virtual_phone
571
-			'VNU_virtual_url'=>$old_event['virtual_url'],//VNU_virtual_url
572
-			'VNU_google_map_link'=>'',//VNU_google_map_link
560
+			'VNU_ID'=>$cpt_id, //VNU_ID_fk
561
+			'VNU_address'=>stripslashes($old_event['address']), //VNU_address
562
+			'VNU_address2'=>stripslashes($old_event['address2']), //VNU_address2
563
+			'VNU_city'=>stripslashes($old_event['city']), //VNU_city
564
+			'STA_ID'=>$state_id, //STA_ID
565
+			'CNT_ISO'=>$country_iso, //CNT_ISO
566
+			'VNU_zip'=>$old_event['zip'], //VNU_zip
567
+			'VNU_phone'=>$old_event['venue_phone'], //VNU_phone
568
+			'VNU_capacity'=>-1, //VNU_capacity
569
+			'VNU_url'=>$old_event['venue_url'], //VNU_url
570
+			'VNU_virtual_phone'=>$old_event['virtual_phone'], //VNU_virtual_phone
571
+			'VNU_virtual_url'=>$old_event['virtual_url'], //VNU_virtual_url
572
+			'VNU_google_map_link'=>'', //VNU_google_map_link
573 573
 			'VNU_enable_for_gmap'=>true	//VNU_enable_for_gmap
574 574
 		);
575 575
 		$datatypes = array(
576
-			'%d',//VNU_ID_fk
577
-			'%s',//VNU_address
578
-			'%s',//VNU_address2
579
-			'%s',//VNU_city
580
-			'%d',//STA_ID
581
-			'%s',//CNT_ISO
582
-			'%s',//VNU_zip
583
-			'%s',//VNU_phone
584
-			'%d',//VNU_capacity
585
-			'%s',//VNU_url
586
-			'%s',//VNU_virtual_phone
587
-			'%s',//VNU_virtual_url
588
-			'%s',//VNU_google_map_link
589
-			'%d',//VNU_enable_for_gmap
576
+			'%d', //VNU_ID_fk
577
+			'%s', //VNU_address
578
+			'%s', //VNU_address2
579
+			'%s', //VNU_city
580
+			'%d', //STA_ID
581
+			'%s', //CNT_ISO
582
+			'%s', //VNU_zip
583
+			'%s', //VNU_phone
584
+			'%d', //VNU_capacity
585
+			'%s', //VNU_url
586
+			'%s', //VNU_virtual_phone
587
+			'%s', //VNU_virtual_url
588
+			'%s', //VNU_google_map_link
589
+			'%d', //VNU_enable_for_gmap
590 590
 		);
591
-		$success = $wpdb->insert($wpdb->prefix."esp_venue_meta",$insertion_array,$datatypes);
592
-		if( ! $success ){
591
+		$success = $wpdb->insert($wpdb->prefix."esp_venue_meta", $insertion_array, $datatypes);
592
+		if ( ! $success) {
593 593
 			$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));
594 594
 			return 0;
595 595
 		}
596 596
 		return $wpdb->insert_id;
597 597
 	}
598 598
 
599
-	private function _insert_new_venue_to_event($new_event_id,$new_venue_id){
599
+	private function _insert_new_venue_to_event($new_event_id, $new_venue_id) {
600 600
 		global $wpdb;
601
-		if( ! $new_event_id){
602
-			$this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"),$new_event_id));
601
+		if ( ! $new_event_id) {
602
+			$this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"), $new_event_id));
603 603
 			return 0;
604 604
 		}
605
-		if( ! $new_venue_id){
606
-			$this->add_error(sprintf(__("Could not find 4.1 venue id for 3.1 venue #%d.", "event_espresso"),$new_venue_id));
605
+		if ( ! $new_venue_id) {
606
+			$this->add_error(sprintf(__("Could not find 4.1 venue id for 3.1 venue #%d.", "event_espresso"), $new_venue_id));
607 607
 			return 0;
608 608
 		}
609 609
 		$cols_n_values = array(
@@ -612,12 +612,12 @@  discard block
 block discarded – undo
612 612
 			'EVV_primary'=>true
613 613
 		);
614 614
 		$datatypes = array(
615
-			'%d',//EVT_ID
616
-			'%d',//VNU_ID
617
-			'%d',//EVT_primary
615
+			'%d', //EVT_ID
616
+			'%d', //VNU_ID
617
+			'%d', //EVT_primary
618 618
 		);
619
-		$success = $wpdb->insert($wpdb->prefix."esp_event_venue",$cols_n_values,$datatypes);
620
-		if ( ! $success){
619
+		$success = $wpdb->insert($wpdb->prefix."esp_event_venue", $cols_n_values, $datatypes);
620
+		if ( ! $success) {
621 621
 			$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));
622 622
 			return 0;
623 623
 		}
@@ -631,11 +631,11 @@  discard block
 block discarded – undo
631 631
 	 * @param int $new_cpt_id new post ID
632 632
 	 * @return void (if there are errors though, adds them to the stage's error list
633 633
 	 */
634
-	private function _convert_start_end_times($old_event,$new_cpt_id){
634
+	private function _convert_start_end_times($old_event, $new_cpt_id) {
635 635
 		$start_end_times = $this->_get_old_start_end_times($old_event['id']);
636
-		foreach($start_end_times as $start_end_time){
637
-			$datetime_id = $this->_insert_new_datetime($start_end_time,$old_event,$new_cpt_id);
638
-			if($datetime_id){
636
+		foreach ($start_end_times as $start_end_time) {
637
+			$datetime_id = $this->_insert_new_datetime($start_end_time, $old_event, $new_cpt_id);
638
+			if ($datetime_id) {
639 639
 				$this->get_migration_script()->set_mapping($this->_old_start_end_table, $start_end_time['id'], $this->_new_datetime_table, $datetime_id);
640 640
 			}
641 641
 		}
@@ -646,9 +646,9 @@  discard block
 block discarded – undo
646 646
 	 * @param type $old_event_id
647 647
 	 * @return type
648 648
 	 */
649
-	private function _get_old_start_end_times($old_event_id){
649
+	private function _get_old_start_end_times($old_event_id) {
650 650
 		global $wpdb;
651
-		return $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_start_end_table WHERE event_id=%d",$old_event_id),ARRAY_A);
651
+		return $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_start_end_table WHERE event_id=%d", $old_event_id), ARRAY_A);
652 652
 	}
653 653
 	/**
654 654
 	 * Inserts a 4.1 datetime given the 3.1 start_end db row and event_details row
@@ -657,40 +657,40 @@  discard block
 block discarded – undo
657 657
 	 * @param type $new_cpt_id
658 658
 	 * @return int ID of new datetime
659 659
 	 */
660
-	private function _insert_new_datetime($start_end_time_row,$old_event_row,$new_cpt_id){
660
+	private function _insert_new_datetime($start_end_time_row, $old_event_row, $new_cpt_id) {
661 661
 		global $wpdb;
662 662
 		$start_date = $old_event_row['start_date'];
663 663
 		$start_time = $this->get_migration_script()->convertTimeFromAMPM($start_end_time_row['start_time']);
664 664
 		$end_date = $old_event_row['end_date'];
665 665
 		$end_time = $this->get_migration_script()->convertTimeFromAMPM($start_end_time_row['end_time']);
666 666
 		$existing_datetimes = $this->_count_other_datetimes_exist_for_new_event($new_cpt_id);
667
-		$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']);
668
-		$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']);
667
+		$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']);
668
+		$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']);
669 669
 		$cols_n_values = array(
670
-			'EVT_ID'=>$new_cpt_id,//EVT_ID
671
-			'DTT_EVT_start'=>$start_datetime_utc,//DTT_EVT_start
672
-			'DTT_EVT_end'=> $end_datetime_utc,//DTT_EVT_end
673
-			'DTT_reg_limit'=>intval($start_end_time_row['reg_limit']) ? $start_end_time_row['reg_limit'] : $old_event_row['reg_limit'],//DTT_reg_limit
674
-			'DTT_sold'=>0,//note: we will increment this as registrations are added during the migration
670
+			'EVT_ID'=>$new_cpt_id, //EVT_ID
671
+			'DTT_EVT_start'=>$start_datetime_utc, //DTT_EVT_start
672
+			'DTT_EVT_end'=> $end_datetime_utc, //DTT_EVT_end
673
+			'DTT_reg_limit'=>intval($start_end_time_row['reg_limit']) ? $start_end_time_row['reg_limit'] : $old_event_row['reg_limit'], //DTT_reg_limit
674
+			'DTT_sold'=>0, //note: we will increment this as registrations are added during the migration
675 675
 //			'DTT_is_primary'=> 0 == $existing_datetimes ,//DTT_is_primary... if count==0, then we'll call it the 'primary'
676
-			'DTT_order'=> $existing_datetimes,//DTT_order, just give it the same order as the count of how many datetimes already exist
676
+			'DTT_order'=> $existing_datetimes, //DTT_order, just give it the same order as the count of how many datetimes already exist
677 677
 			'DTT_parent'=>0,
678 678
 			'DTT_deleted'=>false
679 679
 		);
680 680
 		$datatypes = array(
681
-			'%d',//EVT_Id
682
-			'%s',//DTT_EVT_start
683
-			'%s',//DTT_EVT_end
684
-			'%d',//DTT_reg_limit
685
-			'%d',//DTT_sold
681
+			'%d', //EVT_Id
682
+			'%s', //DTT_EVT_start
683
+			'%s', //DTT_EVT_end
684
+			'%d', //DTT_reg_limit
685
+			'%d', //DTT_sold
686 686
 //			'%d',//DTT_is_primary
687
-			'%d',//DTT_order
688
-			'%d',//DTT_parent
689
-			'%d',//DTT_deleted
687
+			'%d', //DTT_order
688
+			'%d', //DTT_parent
689
+			'%d', //DTT_deleted
690 690
 		);
691
-		$success = $wpdb->insert($this->_new_datetime_table,$cols_n_values,$datatypes);
692
-		if ( ! $success){
693
-			$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));
691
+		$success = $wpdb->insert($this->_new_datetime_table, $cols_n_values, $datatypes);
692
+		if ( ! $success) {
693
+			$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));
694 694
 			return 0;
695 695
 		}
696 696
 		return $wpdb->insert_id;
@@ -703,9 +703,9 @@  discard block
 block discarded – undo
703 703
 	 * @param type $cpt_event_id
704 704
 	 * @return int
705 705
 	 */
706
-	private function _count_other_datetimes_exist_for_new_event($cpt_event_id){
706
+	private function _count_other_datetimes_exist_for_new_event($cpt_event_id) {
707 707
 		global $wpdb;
708
-		$count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM $this->_new_datetime_table WHERE EVT_ID=%d",$cpt_event_id));
708
+		$count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(*) FROM $this->_new_datetime_table WHERE EVT_ID=%d", $cpt_event_id));
709 709
 		return intval($count);
710 710
 	}
711 711
 
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.