Completed
Branch FET-9413-questions-refactor (7aebbc)
by
unknown
89:53 queued 78:26
created
core/data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_venues.dmsstage.php 3 patches
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -196,7 +196,7 @@
 block discarded – undo
196 196
 
197 197
 	/**
198 198
 	 * Inserts into the venue_meta table
199
-	 * @param type $cpt_id
199
+	 * @param integer $cpt_id
200 200
 	 * @param type $old_venue
201 201
 	 * @return int
202 202
 	 */
Please login to merge, or discard this patch.
Braces   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -206,7 +206,7 @@  discard block
 block discarded – undo
206 206
 		try{
207 207
 			$country = $this->get_migration_script()->get_or_create_country(stripslashes($old_venue['country']));
208 208
 			$country_iso = $country['CNT_ISO'];
209
-		}catch(EE_Error $e){
209
+		} catch(EE_Error $e){
210 210
 			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue)));
211 211
 			$country_iso = null;
212 212
 		}
@@ -214,7 +214,7 @@  discard block
 block discarded – undo
214 214
 		try{
215 215
 			$state = $this->get_migration_script()->get_or_create_state(stripslashes($old_venue['state']),isset($country['CNT_name']) ? $country['CNT_name'] : strip_tags($old_venue['country']));
216 216
 			$state_id = $state['STA_ID'];
217
-		}catch(EE_Error $e){
217
+		} catch(EE_Error $e){
218 218
 			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue)));
219 219
 			$state_id = 0;
220 220
 		}
Please login to merge, or discard this patch.
Spacing   +79 added lines, -79 removed lines patch added patch discarded remove patch
@@ -61,44 +61,44 @@  discard block
 block discarded – undo
61 61
 //			));
62 62
  *
63 63
  */
64
-class EE_DMS_4_1_0_venues extends EE_Data_Migration_Script_Stage{
64
+class EE_DMS_4_1_0_venues extends EE_Data_Migration_Script_Stage {
65 65
 	private $_old_table;
66 66
 	private $_new_table;
67 67
 	private $_new_meta_table;
68
-function _migration_step($num_items=50){
68
+function _migration_step($num_items = 50) {
69 69
 	global $wpdb;
70 70
 	$start_at_record = $this->count_records_migrated();
71
-	$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM ".$this->_old_table." LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A);
71
+	$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM ".$this->_old_table." LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A);
72 72
 	$items_actually_migrated = 0;
73
-	foreach($rows as $old_venue){
74
-		if ( ! $new_id = $this->_insert_into_posts($old_venue)){
73
+	foreach ($rows as $old_venue) {
74
+		if ( ! $new_id = $this->_insert_into_posts($old_venue)) {
75 75
 			$items_actually_migrated++;
76 76
 			continue;
77 77
 		}
78 78
 		$this->get_migration_script()->set_mapping($this->_old_table, $old_venue['id'], $this->_new_table, $new_id);
79
-		if( ! $new_meta_id = $this->_insert_into_meta_table($new_id,$old_venue)){
79
+		if ( ! $new_meta_id = $this->_insert_into_meta_table($new_id, $old_venue)) {
80 80
 			$items_actually_migrated++;
81 81
 			continue;
82 82
 		}
83 83
 		$this->get_migration_script()->set_mapping($this->_old_table, $old_venue['id'], $this->_new_meta_table, $new_meta_id);
84 84
 		//lastly, save the 'contact' as post meta, because it doesn't exist anywhere else but someone may still want it
85 85
 		$venue_meta = maybe_unserialize($old_venue['meta']);
86
-		if(isset($venue_meta['contact']) && $venue_meta['contact']){
87
-			add_post_meta($new_id,'contact',$venue_meta['contact']);
86
+		if (isset($venue_meta['contact']) && $venue_meta['contact']) {
87
+			add_post_meta($new_id, 'contact', $venue_meta['contact']);
88 88
 		}
89 89
 		//is there an image on this venue?
90 90
 		$guid = isset($venue_meta['image']) && $venue_meta['image'] ? $venue_meta['image'] : NULL;
91
-		if($guid){
92
-			$this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid,$new_id,$this);
91
+		if ($guid) {
92
+			$this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid, $new_id, $this);
93 93
 		}
94 94
 		$items_actually_migrated++;
95
-		if($guid){
95
+		if ($guid) {
96 96
 			//if there was an image, we may have had to download it etc and it may have taken
97 97
 			//longer, then let's not bother migrating anymore on this step
98 98
 			break;
99 99
 		}
100 100
 	}
101
-	if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
101
+	if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
102 102
 		$this->set_completed();
103 103
 	}
104 104
 	return $items_actually_migrated;
@@ -122,42 +122,42 @@  discard block
 block discarded – undo
122 122
 	 * @param array $old_venue keys are cols, values are col values
123 123
 	 * @return int
124 124
 	 */
125
-	private function _insert_into_posts($old_venue){
125
+	private function _insert_into_posts($old_venue) {
126 126
 		global $wpdb;
127 127
 		$meta = maybe_unserialize($old_venue['meta']);
128
-		$slug = $this->_find_unique_slug( $old_venue[ 'name' ], $old_venue[ 'identifier' ] );
128
+		$slug = $this->_find_unique_slug($old_venue['name'], $old_venue['identifier']);
129 129
 		$insertion_array = array(
130
-					'post_title'=>stripslashes($old_venue['name']),//VNU_name
131
-					'post_content'=>isset($meta['description']) ? stripslashes(strip_tags($meta['description'])) : '',//VNU_desc
132
-					'post_name'=> $slug,//VNU_identifier
133
-					'post_date'=>current_time('mysql'),//VNU_created
134
-					'post_date_gmt'=>  current_time('mysql',true),
135
-					'post_excerpt'=>'',//wp_trim_words($meta['description'] ? $meta['description'] : '',50),//VNU_short_desc arbitraty only 50 characters
136
-					'post_modified'=>current_time('mysql'),//VNU_modified
137
-					'post_modified_gmt'=>current_time('mysql',true),
138
-					'post_author'=>$old_venue['wp_user'],//VNU_wp_user
139
-					'post_parent'=>0,//parent
140
-					'menu_order'=>0,//VNU_order
130
+					'post_title'=>stripslashes($old_venue['name']), //VNU_name
131
+					'post_content'=>isset($meta['description']) ? stripslashes(strip_tags($meta['description'])) : '', //VNU_desc
132
+					'post_name'=> $slug, //VNU_identifier
133
+					'post_date'=>current_time('mysql'), //VNU_created
134
+					'post_date_gmt'=>  current_time('mysql', true),
135
+					'post_excerpt'=>'', //wp_trim_words($meta['description'] ? $meta['description'] : '',50),//VNU_short_desc arbitraty only 50 characters
136
+					'post_modified'=>current_time('mysql'), //VNU_modified
137
+					'post_modified_gmt'=>current_time('mysql', true),
138
+					'post_author'=>$old_venue['wp_user'], //VNU_wp_user
139
+					'post_parent'=>0, //parent
140
+					'menu_order'=>0, //VNU_order
141 141
 					'post_type'=>'espresso_venues'//post_type
142 142
 				);
143 143
 		$datatypes_array = array(
144
-					'%s',//VNU_name
145
-					'%s',//VNU_desc
146
-					'%s',//VNU_identifier
147
-					'%s',//VNU_created
144
+					'%s', //VNU_name
145
+					'%s', //VNU_desc
146
+					'%s', //VNU_identifier
147
+					'%s', //VNU_created
148 148
 					'%s',
149
-					'%s',//VNU_short_desc
150
-					'%s',//VNU_modified
149
+					'%s', //VNU_short_desc
150
+					'%s', //VNU_modified
151 151
 					'%s',
152
-					'%d',//VNU_wp_user
153
-					'%d',//parent
154
-					'%d',//VNU_order
155
-					'%s',//post_type
152
+					'%d', //VNU_wp_user
153
+					'%d', //parent
154
+					'%d', //VNU_order
155
+					'%s', //post_type
156 156
 				);
157 157
 		$success = $wpdb->insert($this->_new_table,
158 158
 				$insertion_array,
159 159
 				$datatypes_array);
160
-		if( ! $success ){
160
+		if ( ! $success) {
161 161
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_venue, $this->_new_table, $insertion_array, $datatypes_array));
162 162
 			return 0;
163 163
 		}
@@ -171,11 +171,11 @@  discard block
 block discarded – undo
171 171
 	 * @param string $post_name
172 172
 	 * @return string
173 173
 	 */
174
-	private function _find_unique_slug($post_name, $old_identifier = '' ){
174
+	private function _find_unique_slug($post_name, $old_identifier = '') {
175 175
 		$count = 0;
176
-		$original_name = $post_name ? sanitize_title( $post_name ) : $old_identifier;
176
+		$original_name = $post_name ? sanitize_title($post_name) : $old_identifier;
177 177
 		$event_slug = $original_name;
178
-		while( $this->_other_post_exists_with_that_slug($event_slug) && $count<50){
178
+		while ($this->_other_post_exists_with_that_slug($event_slug) && $count < 50) {
179 179
 			$event_slug = sanitize_title($original_name."-".++$count);
180 180
 		}
181 181
 		return $event_slug;
@@ -187,11 +187,11 @@  discard block
 block discarded – undo
187 187
 	 * @param type $slug
188 188
 	 * @return boolean
189 189
 	 */
190
-	private function _other_post_exists_with_that_slug($slug){
190
+	private function _other_post_exists_with_that_slug($slug) {
191 191
 		global $wpdb;
192
-		$query = $wpdb->prepare("SELECT COUNT(ID) FROM ".$this->_new_table." WHERE post_name = %s",$slug);
192
+		$query = $wpdb->prepare("SELECT COUNT(ID) FROM ".$this->_new_table." WHERE post_name = %s", $slug);
193 193
 		$count = $wpdb->get_var($query);
194
-		return (boolean)intval($count);
194
+		return (boolean) intval($count);
195 195
 	}
196 196
 
197 197
 	/**
@@ -200,60 +200,60 @@  discard block
 block discarded – undo
200 200
 	 * @param type $old_venue
201 201
 	 * @return int
202 202
 	 */
203
-	private function _insert_into_meta_table($cpt_id,$old_venue){
203
+	private function _insert_into_meta_table($cpt_id, $old_venue) {
204 204
 		global $wpdb;
205 205
 		//get a country with the same name, or insert one
206
-		try{
206
+		try {
207 207
 			$country = $this->get_migration_script()->get_or_create_country(stripslashes($old_venue['country']));
208 208
 			$country_iso = $country['CNT_ISO'];
209
-		}catch(EE_Error $e){
210
-			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue)));
209
+		} catch (EE_Error $e) {
210
+			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"), $e->getMessage(), $this->_json_encode($old_venue)));
211 211
 			$country_iso = null;
212 212
 		}
213 213
 		//get a state with the same name, if possible
214
-		try{
215
-			$state = $this->get_migration_script()->get_or_create_state(stripslashes($old_venue['state']),isset($country['CNT_name']) ? $country['CNT_name'] : strip_tags($old_venue['country']));
214
+		try {
215
+			$state = $this->get_migration_script()->get_or_create_state(stripslashes($old_venue['state']), isset($country['CNT_name']) ? $country['CNT_name'] : strip_tags($old_venue['country']));
216 216
 			$state_id = $state['STA_ID'];
217
-		}catch(EE_Error $e){
218
-			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue)));
217
+		} catch (EE_Error $e) {
218
+			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"), $e->getMessage(), $this->_json_encode($old_venue)));
219 219
 			$state_id = 0;
220 220
 		}
221 221
 		$meta = maybe_unserialize($old_venue['meta']);
222 222
 		//now insert into meta table
223 223
 		$insertion_array = array(
224
-			'VNU_ID'=>$cpt_id,//VNU_ID_fk
225
-			'VNU_address'=>stripslashes($old_venue['address']),//VNU_address
226
-			'VNU_address2'=>stripslashes($old_venue['address2']),//VNU_address2
227
-			'VNU_city'=>stripslashes($old_venue['city']),//VNU_city
228
-			'STA_ID'=>$state_id,//STA_ID
229
-			'CNT_ISO'=>$country_iso,//CNT_ISO
230
-			'VNU_zip'=>stripslashes($old_venue['zip']),//VNU_zip
231
-			'VNU_phone'=>isset($meta['phone']) ? stripslashes($meta['phone']) : '',//VNU_phone
232
-			'VNU_capacity'=>-1,//VNU_capacity
233
-			'VNU_url'=>isset($meta['website']) ? stripslashes($meta['website']) : '',//VNU_url
234
-			'VNU_virtual_phone'=>'',//VNU_virtual_phone
235
-			'VNU_virtual_url'=>'',//VNU_virtual_url
236
-			'VNU_google_map_link'=>'',//VNU_google_map_link
224
+			'VNU_ID'=>$cpt_id, //VNU_ID_fk
225
+			'VNU_address'=>stripslashes($old_venue['address']), //VNU_address
226
+			'VNU_address2'=>stripslashes($old_venue['address2']), //VNU_address2
227
+			'VNU_city'=>stripslashes($old_venue['city']), //VNU_city
228
+			'STA_ID'=>$state_id, //STA_ID
229
+			'CNT_ISO'=>$country_iso, //CNT_ISO
230
+			'VNU_zip'=>stripslashes($old_venue['zip']), //VNU_zip
231
+			'VNU_phone'=>isset($meta['phone']) ? stripslashes($meta['phone']) : '', //VNU_phone
232
+			'VNU_capacity'=>-1, //VNU_capacity
233
+			'VNU_url'=>isset($meta['website']) ? stripslashes($meta['website']) : '', //VNU_url
234
+			'VNU_virtual_phone'=>'', //VNU_virtual_phone
235
+			'VNU_virtual_url'=>'', //VNU_virtual_url
236
+			'VNU_google_map_link'=>'', //VNU_google_map_link
237 237
 			'VNU_enable_for_gmap'=>true	//VNU_enable_for_gmap
238 238
 		);
239 239
 		$datatypes = array(
240
-			'%d',//VNU_ID_fk
241
-			'%s',//VNU_address
242
-			'%s',//VNU_address2
243
-			'%s',//VNU_city
244
-			'%d',//STA_ID
245
-			'%s',//CNT_ISO
246
-			'%s',//VNU_zip
247
-			'%s',//VNU_phone
248
-			'%d',//VNU_capacity
249
-			'%s',//VNU_url
250
-			'%s',//VNU_virtual_phone
251
-			'%s',//VNU_virtual_url
252
-			'%s',//VNU_google_map_link
253
-			'%d',//VNU_enable_for_gmap
240
+			'%d', //VNU_ID_fk
241
+			'%s', //VNU_address
242
+			'%s', //VNU_address2
243
+			'%s', //VNU_city
244
+			'%d', //STA_ID
245
+			'%s', //CNT_ISO
246
+			'%s', //VNU_zip
247
+			'%s', //VNU_phone
248
+			'%d', //VNU_capacity
249
+			'%s', //VNU_url
250
+			'%s', //VNU_virtual_phone
251
+			'%s', //VNU_virtual_url
252
+			'%s', //VNU_google_map_link
253
+			'%d', //VNU_enable_for_gmap
254 254
 		);
255
-		$success = $wpdb->insert($this->_new_meta_table,$insertion_array,$datatypes);
256
-		if( ! $success ){
255
+		$success = $wpdb->insert($this->_new_meta_table, $insertion_array, $datatypes);
256
+		if ( ! $success) {
257 257
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_venue, $this->_new_meta_table, $insertion_array, $datatypes));
258 258
 			return 0;
259 259
 		}
Please login to merge, or discard this patch.
4_6_0_stages/EE_DMS_4_6_0_payment_method_currencies.dmsstage.php 2 patches
Doc Comments   +3 added lines, -2 removed lines patch added patch discarded remove patch
@@ -128,6 +128,9 @@  discard block
 block discarded – undo
128 128
 		return $items_actually_migrated;
129 129
 	}
130 130
 
131
+	/**
132
+	 * @param integer $num_items_to_migrate
133
+	 */
131 134
 	private function _gather_relations_to_add($num_items_to_migrate) {
132 135
 		$relations_to_add_this_step = array();
133 136
 		$migrate_up_to_count = $this->count_records_migrated() + $num_items_to_migrate;
@@ -158,8 +161,6 @@  discard block
 block discarded – undo
158 161
 
159 162
 	/**
160 163
 	 * Adds teh relation between the payment method and the currencies it can be used for
161
-	 * @param int $id
162
-	 * @param string $gateway_slug
163 164
 	 */
164 165
 	private function _add_currency_relations($pm_id,$currency_code){
165 166
 		global $wpdb;
Please login to merge, or discard this patch.
Spacing   +24 added lines, -24 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
1 1
 <?php
2 2
 
3
-if (!defined('EVENT_ESPRESSO_VERSION')) {
3
+if ( ! defined('EVENT_ESPRESSO_VERSION')) {
4 4
 	exit('No direct script access allowed');
5 5
 }
6 6
 
@@ -13,7 +13,7 @@  discard block
 block discarded – undo
13 13
  * @author				Mike Nelson
14 14
  *
15 15
  */
16
-class EE_DMS_4_6_0_payment_method_currencies extends EE_Data_Migration_Script_Stage{
16
+class EE_DMS_4_6_0_payment_method_currencies extends EE_Data_Migration_Script_Stage {
17 17
 	protected $_currency_table_name;
18 18
 	protected $_currency_payment_method_table_name;
19 19
 	protected $_payment_method_table_name;
@@ -89,7 +89,7 @@  discard block
 block discarded – undo
89 89
 	);
90 90
 	public function __construct() {
91 91
 		global $wpdb;
92
-		$this->_pretty_name = __( 'Payment Method Currencies', 'event_espresso' );
92
+		$this->_pretty_name = __('Payment Method Currencies', 'event_espresso');
93 93
 		$this->_payment_method_table_name = $wpdb->prefix.'esp_payment_method';
94 94
 		$this->_currency_payment_method_table_name = $wpdb->prefix.'esp_currency_payment_method';
95 95
 		$this->_currency_table_name = $wpdb->prefix.'esp_currency';
@@ -98,8 +98,8 @@  discard block
 block discarded – undo
98 98
 
99 99
 	protected function _count_records_to_migrate() {
100 100
 		$count = 0;
101
-		foreach($this->_gateway_currencies as $currencies){
102
-			if( $currencies == 'all'){
101
+		foreach ($this->_gateway_currencies as $currencies) {
102
+			if ($currencies == 'all') {
103 103
 				$currencies = $this->_get_all_currencies();
104 104
 			}
105 105
 			$count += count($currencies);
@@ -109,20 +109,20 @@  discard block
 block discarded – undo
109 109
 
110 110
 
111 111
 
112
-	protected function _migration_step( $num_items_to_migrate = 50 ) {
112
+	protected function _migration_step($num_items_to_migrate = 50) {
113 113
 		$items_actually_migrated = 0;
114 114
 		$relations_to_add_this_step = $this->_gather_relations_to_add($num_items_to_migrate);
115
-		foreach($relations_to_add_this_step as $pm_slug => $currencies){
115
+		foreach ($relations_to_add_this_step as $pm_slug => $currencies) {
116 116
 
117
-			$id = $this->get_migration_script()->get_mapping_new_pk( 'EE_Gateway_Config', $pm_slug, $this->_payment_method_table_name );
118
-			foreach( $currencies as $currency ){
119
-				if( $id ){
120
-					$this->_add_currency_relations( $id, $currency );
117
+			$id = $this->get_migration_script()->get_mapping_new_pk('EE_Gateway_Config', $pm_slug, $this->_payment_method_table_name);
118
+			foreach ($currencies as $currency) {
119
+				if ($id) {
120
+					$this->_add_currency_relations($id, $currency);
121 121
 				}
122 122
 				$items_actually_migrated++;
123 123
 			}
124 124
 		}
125
-		if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
125
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
126 126
 			$this->set_completed();
127 127
 		}
128 128
 		return $items_actually_migrated;
@@ -132,14 +132,14 @@  discard block
 block discarded – undo
132 132
 		$relations_to_add_this_step = array();
133 133
 		$migrate_up_to_count = $this->count_records_migrated() + $num_items_to_migrate;
134 134
 		$iterator = 0;
135
-		foreach($this->_gateway_currencies as $pm_slug => $currencies){
136
-			if( $currencies == 'all' ){
135
+		foreach ($this->_gateway_currencies as $pm_slug => $currencies) {
136
+			if ($currencies == 'all') {
137 137
 				$currencies = $this->_get_all_currencies();
138 138
 			}
139
-			foreach($currencies as $currency_code){
140
-				if( $this->count_records_migrated() <= $iterator &&
141
-						$iterator < $migrate_up_to_count ){
142
-					$relations_to_add_this_step[ $pm_slug ] [] = $currency_code;
139
+			foreach ($currencies as $currency_code) {
140
+				if ($this->count_records_migrated() <= $iterator &&
141
+						$iterator < $migrate_up_to_count) {
142
+					$relations_to_add_this_step[$pm_slug] [] = $currency_code;
143 143
 				}
144 144
 				$iterator++;
145 145
 			}
@@ -150,7 +150,7 @@  discard block
 block discarded – undo
150 150
 	 * Gets all the currency codes in the database
151 151
 	 * @return array
152 152
 	 */
153
-	private function _get_all_currencies(){
153
+	private function _get_all_currencies() {
154 154
 		global $wpdb;
155 155
 		$currencies = $wpdb->get_col("SELECT CUR_code FROM {$this->_currency_table_name}");
156 156
 		return $currencies;
@@ -161,7 +161,7 @@  discard block
 block discarded – undo
161 161
 	 * @param int $id
162 162
 	 * @param string $gateway_slug
163 163
 	 */
164
-	private function _add_currency_relations($pm_id,$currency_code){
164
+	private function _add_currency_relations($pm_id, $currency_code) {
165 165
 		global $wpdb;
166 166
 		$cur_pm_relation = array(
167 167
 					'CUR_code'=>$currency_code,
@@ -170,11 +170,11 @@  discard block
 block discarded – undo
170 170
 		$success = $wpdb->insert($this->_currency_payment_method_table_name,
171 171
 				$cur_pm_relation,
172 172
 				array(
173
-					'%s',//CUR_code
174
-					'%d',//PMD_ID
173
+					'%s', //CUR_code
174
+					'%d', //PMD_ID
175 175
 				));
176
-		if( ! $success ){
177
-			$this->add_error( sprintf( __( 'Could not add currency relation %s because %s', "event_espresso" ), json_encode( $cur_pm_relation ), $wpdb->last_error ) );
176
+		if ( ! $success) {
177
+			$this->add_error(sprintf(__('Could not add currency relation %s because %s', "event_espresso"), json_encode($cur_pm_relation), $wpdb->last_error));
178 178
 		}
179 179
 	}
180 180
 }
Please login to merge, or discard this patch.
core/data_migration_scripts/4_6_0_stages/EE_DMS_4_6_0_payments.dmsstage.php 2 patches
Doc Comments   -1 removed lines patch added patch discarded remove patch
@@ -57,7 +57,6 @@
 block discarded – undo
57 57
 			'IV'=>  __("Invoice", 'event_espresso'),
58 58
 			'MO'=>  __("Money Order", 'event_espresso'),
59 59
 	 * @global type $wpdb
60
-	 * @param int $id
61 60
 	 * @return string
62 61
 	 */
63 62
 	protected function _get_payment_method_id_by_gateway_name( $gateway_name, $old_pay_method_column ){
Please login to merge, or discard this patch.
Spacing   +21 added lines, -21 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
1 1
 <?php
2
-if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) {
3
-	exit( 'No direct script access allowed' );
2
+if ( ! defined('EVENT_ESPRESSO_VERSION')) {
3
+	exit('No direct script access allowed');
4 4
 }
5 5
 
6 6
 /**
@@ -12,37 +12,37 @@  discard block
 block discarded – undo
12 12
  * @author				Mike Nelson
13 13
  *
14 14
  */
15
-class EE_DMS_4_6_0_payments extends EE_Data_Migration_Script_Stage_Table{
15
+class EE_DMS_4_6_0_payments extends EE_Data_Migration_Script_Stage_Table {
16 16
 	protected $_payment_method_table;
17
-	function __construct(){
17
+	function __construct() {
18 18
 		global $wpdb;
19
-		$this->_old_table = $wpdb->prefix . 'esp_payment';
20
-		$this->_payment_method_table = $wpdb->prefix . 'esp_payment_method';
19
+		$this->_old_table = $wpdb->prefix.'esp_payment';
20
+		$this->_payment_method_table = $wpdb->prefix.'esp_payment_method';
21 21
 		$this->_pretty_name = __('Payment-Payment Method Relations', 'event_espresso');
22 22
 		parent::__construct();
23 23
 	}
24
-	protected function _migrate_old_row( $payment_row ) {
24
+	protected function _migrate_old_row($payment_row) {
25 25
 		global $wpdb;
26 26
 		//get the payment method's ID
27
-		$PMD_ID = apply_filters( 'FHEE__EE_DMS_4_6_0_payments__migrate_old_row__PMD_ID', $this->_get_payment_method_id_by_gateway_name( $payment_row[ 'PAY_gateway' ], $payment_row[ 'PAY_method'] ) );
28
-		if( ! $PMD_ID ){
29
-			$this->add_error( sprintf( __( 'Could not find payment method with PMD_type = \'%1$s\' when migrating payment row %2$s so just assigned it an unknown payment method', 'event_espresso' ), $payment_row[ 'PAY_gateway' ], $this->_json_encode( $payment_row ) ) );
27
+		$PMD_ID = apply_filters('FHEE__EE_DMS_4_6_0_payments__migrate_old_row__PMD_ID', $this->_get_payment_method_id_by_gateway_name($payment_row['PAY_gateway'], $payment_row['PAY_method']));
28
+		if ( ! $PMD_ID) {
29
+			$this->add_error(sprintf(__('Could not find payment method with PMD_type = \'%1$s\' when migrating payment row %2$s so just assigned it an unknown payment method', 'event_espresso'), $payment_row['PAY_gateway'], $this->_json_encode($payment_row)));
30 30
 			$PMD_ID = 0;
31 31
 		}
32 32
 		$new_values = array(
33 33
 			'PMD_ID' => $PMD_ID,
34
-			'PAY_source' => ( $payment_row[ 'PAY_via_admin' ] ? 'ADMIN' : 'CART' ) );
35
-		$wheres = array( 'PAY_ID' => $payment_row[ 'PAY_ID' ] );
36
-		$new_value_datatypes = array( '%d', '%s' );
37
-		$where_datatypes = array( '%d' );
38
-		$success = $wpdb->update( $this->_old_table,
34
+			'PAY_source' => ($payment_row['PAY_via_admin'] ? 'ADMIN' : 'CART') );
35
+		$wheres = array('PAY_ID' => $payment_row['PAY_ID']);
36
+		$new_value_datatypes = array('%d', '%s');
37
+		$where_datatypes = array('%d');
38
+		$success = $wpdb->update($this->_old_table,
39 39
 				$new_values,
40 40
 				$wheres,
41 41
 				$new_value_datatypes,
42 42
 				$where_datatypes
43 43
 				);
44
-		if( ! $success ){
45
-			$this->add_error( sprintf( __( 'Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso' ), $this->_json_encode( $new_values ), $this->_old_table, $this->_json_encode( $wheres ) ) );
44
+		if ( ! $success) {
45
+			$this->add_error(sprintf(__('Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso'), $this->_json_encode($new_values), $this->_old_table, $this->_json_encode($wheres)));
46 46
 		}
47 47
 	}
48 48
 	/**
@@ -60,11 +60,11 @@  discard block
 block discarded – undo
60 60
 	 * @param int $id
61 61
 	 * @return string
62 62
 	 */
63
-	protected function _get_payment_method_id_by_gateway_name( $gateway_name, $old_pay_method_column ){
63
+	protected function _get_payment_method_id_by_gateway_name($gateway_name, $old_pay_method_column) {
64 64
 		global $wpdb;
65 65
 		//convert from old known PAY_method values to their corresponding
66 66
 		//PMD_type or default PMD_name
67
-		switch( $old_pay_method_column ) {
67
+		switch ($old_pay_method_column) {
68 68
 			case 'PP':
69 69
 				$pmd_type = 'Paypal_Standard';
70 70
 				break;
@@ -92,8 +92,8 @@  discard block
 block discarded – undo
92 92
 			default:
93 93
 				$pmd_type = $gateway_name;
94 94
 		}
95
-		$pmd_name = str_replace( "_", " ", $pmd_type );
96
-		return $wpdb->get_var( $wpdb->prepare( "SELECT PMD_ID FROM " . $wpdb->prefix . "esp_payment_method WHERE PMD_type = %s OR PMD_name = %s", $pmd_type, $pmd_name ) );
95
+		$pmd_name = str_replace("_", " ", $pmd_type);
96
+		return $wpdb->get_var($wpdb->prepare("SELECT PMD_ID FROM ".$wpdb->prefix."esp_payment_method WHERE PMD_type = %s OR PMD_name = %s", $pmd_type, $pmd_name));
97 97
 	}
98 98
 
99 99
 
Please login to merge, or discard this patch.
data_migration_scripts/4_6_0_stages/EE_DMS_4_6_0_transactions.dmsstage.php 2 patches
Doc Comments   -1 removed lines patch added patch discarded remove patch
@@ -49,7 +49,6 @@
 block discarded – undo
49 49
 	/**
50 50
 	 *
51 51
 	 * @global type $wpdb
52
-	 * @param int $id
53 52
 	 * @return string
54 53
 	 */
55 54
 	protected function _get_payment_method_id_by_gateway_name( $gateway_name ){
Please login to merge, or discard this patch.
Spacing   +20 added lines, -20 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
1 1
 <?php
2
-if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) {
3
-	exit( 'No direct script access allowed' );
2
+if ( ! defined('EVENT_ESPRESSO_VERSION')) {
3
+	exit('No direct script access allowed');
4 4
 }
5 5
 
6 6
 /**
@@ -12,38 +12,38 @@  discard block
 block discarded – undo
12 12
  * @author				Mike Nelson
13 13
  *
14 14
  */
15
-class EE_DMS_4_6_0_transactions extends EE_Data_Migration_Script_Stage_Table{
15
+class EE_DMS_4_6_0_transactions extends EE_Data_Migration_Script_Stage_Table {
16 16
 	protected $_transaction_table;
17 17
 	protected $_payment_method_table;
18
-	function __construct(){
18
+	function __construct() {
19 19
 		global $wpdb;
20
-		$this->_old_table = $wpdb->prefix . 'esp_extra_meta';
21
-		$this->_transaction_table = $wpdb->prefix . 'esp_transaction';
22
-		$this->_payment_method_table = $wpdb->prefix . 'esp_payment_method';
20
+		$this->_old_table = $wpdb->prefix.'esp_extra_meta';
21
+		$this->_transaction_table = $wpdb->prefix.'esp_transaction';
22
+		$this->_payment_method_table = $wpdb->prefix.'esp_payment_method';
23 23
 		$this->_pretty_name = __('Transaction Payment Method Relations', 'event_espresso');
24 24
 		$this->_extra_where_sql = "WHERE EXM_key = 'gateway' AND EXM_type = 'Transaction'";
25 25
 		parent::__construct();
26 26
 	}
27
-	protected function _migrate_old_row( $extra_meta_row ) {
27
+	protected function _migrate_old_row($extra_meta_row) {
28 28
 		global $wpdb;
29 29
 		//get the payment method's ID
30
-		$PMD_ID = $this->_get_payment_method_id_by_gateway_name( $extra_meta_row[ 'EXM_value' ] );
31
-		if( ! $PMD_ID ){
32
-			$this->add_error( sprintf( __( 'Could not find payment method with PMD_type = \'%1$s\' when migrating extra meta row %2$s', 'event_espresso' ), $extra_meta_row[ 'EXM_value' ], $this->_json_encode( $extra_meta_row ) ) );
30
+		$PMD_ID = $this->_get_payment_method_id_by_gateway_name($extra_meta_row['EXM_value']);
31
+		if ( ! $PMD_ID) {
32
+			$this->add_error(sprintf(__('Could not find payment method with PMD_type = \'%1$s\' when migrating extra meta row %2$s', 'event_espresso'), $extra_meta_row['EXM_value'], $this->_json_encode($extra_meta_row)));
33 33
 			return;
34 34
 		}
35
-		$new_values = array( 'PMD_ID' => $PMD_ID );
36
-		$wheres = array( 'TXN_ID' => $extra_meta_row[ 'OBJ_ID' ] );
37
-		$new_value_datatypes = array( '%d' );
38
-		$where_datatypes = array( '%d' );
39
-		$success = $wpdb->update( $this->_transaction_table,
35
+		$new_values = array('PMD_ID' => $PMD_ID);
36
+		$wheres = array('TXN_ID' => $extra_meta_row['OBJ_ID']);
37
+		$new_value_datatypes = array('%d');
38
+		$where_datatypes = array('%d');
39
+		$success = $wpdb->update($this->_transaction_table,
40 40
 				$new_values,
41 41
 				$wheres,
42 42
 				$new_value_datatypes,
43 43
 				$where_datatypes
44 44
 				);
45
-		if( ! $success ){
46
-			$this->add_error( sprintf( __( 'Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso' ), $this->_json_encode( $new_values ), $this->_transaction_table, $this->_json_encode( $wheres ) ) );
45
+		if ( ! $success) {
46
+			$this->add_error(sprintf(__('Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso'), $this->_json_encode($new_values), $this->_transaction_table, $this->_json_encode($wheres)));
47 47
 		}
48 48
 	}
49 49
 	/**
@@ -52,9 +52,9 @@  discard block
 block discarded – undo
52 52
 	 * @param int $id
53 53
 	 * @return string
54 54
 	 */
55
-	protected function _get_payment_method_id_by_gateway_name( $gateway_name ){
55
+	protected function _get_payment_method_id_by_gateway_name($gateway_name) {
56 56
 		global $wpdb;
57
-		return $wpdb->get_var( $wpdb->prepare( "SELECT PMD_ID FROM " . $wpdb->prefix . "esp_payment_method WHERE PMD_type = %s", $gateway_name ) );
57
+		return $wpdb->get_var($wpdb->prepare("SELECT PMD_ID FROM ".$wpdb->prefix."esp_payment_method WHERE PMD_type = %s", $gateway_name));
58 58
 	}
59 59
 
60 60
 
Please login to merge, or discard this patch.
4_7_0_stages/EE_DMS_4_7_0_Registration_Payments.dmsstage.php 2 patches
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -125,7 +125,7 @@
 block discarded – undo
125 125
 	 *
126 126
 	 * @param stdClass $payment
127 127
 	 * @param array $registrations
128
-	 * @return bool
128
+	 * @return boolean|null
129 129
 	 */
130 130
 	protected function _process_registration_payments( $payment, $registrations = array() ){
131 131
 		// how much is available to apply to registrations?
Please login to merge, or discard this patch.
Spacing   +50 added lines, -50 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
1 1
 <?php
2
-if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) {
3
-	exit( 'No direct script access allowed' );
2
+if ( ! defined('EVENT_ESPRESSO_VERSION')) {
3
+	exit('No direct script access allowed');
4 4
 }
5 5
 
6 6
 /**
@@ -12,7 +12,7 @@  discard block
 block discarded – undo
12 12
  * @author				Brent Christensen
13 13
  *
14 14
  */
15
-class EE_DMS_4_7_0_Registration_Payments extends EE_Data_Migration_Script_Stage_Table{
15
+class EE_DMS_4_7_0_Registration_Payments extends EE_Data_Migration_Script_Stage_Table {
16 16
 
17 17
 	protected $_payment_table;
18 18
 
@@ -20,15 +20,15 @@  discard block
 block discarded – undo
20 20
 
21 21
 	protected $_registration_payment_table;
22 22
 
23
-	function __construct(){
23
+	function __construct() {
24 24
 		/** @type WPDB $wpdb */
25 25
 		global $wpdb;
26
-		$this->_pretty_name = __( 'Registration Payment Record Generation', 'event_espresso' );
26
+		$this->_pretty_name = __('Registration Payment Record Generation', 'event_espresso');
27 27
 		// define tables
28
-		$this->_old_table 									= $wpdb->prefix . 'esp_transaction';
29
-		$this->_payment_table 						= $wpdb->prefix . 'esp_payment';
30
-		$this->_registration_table 					= $wpdb->prefix . 'esp_registration';
31
-		$this->_registration_payment_table 	= $wpdb->prefix . 'esp_registration_payment';
28
+		$this->_old_table = $wpdb->prefix.'esp_transaction';
29
+		$this->_payment_table = $wpdb->prefix.'esp_payment';
30
+		$this->_registration_table = $wpdb->prefix.'esp_registration';
31
+		$this->_registration_payment_table = $wpdb->prefix.'esp_registration_payment';
32 32
 		// build SQL WHERE clauses
33 33
 		$this->_extra_where_sql = "WHERE STS_ID IN ( 'TIN', 'TCM' ) AND TXN_Total != '0.000'";
34 34
 		parent::__construct();
@@ -40,14 +40,14 @@  discard block
 block discarded – undo
40 40
 	 * @param array $transaction
41 41
 	 * @return void
42 42
 	 */
43
-	protected function _migrate_old_row( $transaction ) {
43
+	protected function _migrate_old_row($transaction) {
44 44
 		/** @type WPDB $wpdb */
45 45
 		global $wpdb;
46
-		$TXN_ID = absint( $transaction[ 'TXN_ID' ] );
47
-		if ( ! $TXN_ID ) {
46
+		$TXN_ID = absint($transaction['TXN_ID']);
47
+		if ( ! $TXN_ID) {
48 48
 			$this->add_error(
49 49
 				sprintf(
50
-					__( 'Invalid transaction with ID=%1$d. Error: "%2$s"', 'event_espresso' ),
50
+					__('Invalid transaction with ID=%1$d. Error: "%2$s"', 'event_espresso'),
51 51
 					$TXN_ID,
52 52
 					$wpdb->last_error
53 53
 				)
@@ -55,19 +55,19 @@  discard block
 block discarded – undo
55 55
 			return;
56 56
 		}
57 57
 		// get all payments for the TXN
58
-		$payments = $this->_get_payments( $TXN_ID );
59
-		if ( empty( $payments ) ) {
58
+		$payments = $this->_get_payments($TXN_ID);
59
+		if (empty($payments)) {
60 60
 			return;
61 61
 		}
62 62
 		// then the registrants
63
-		$registrations = $this->_get_registrations( $TXN_ID );
64
-		if ( empty( $registrations ) ) {
63
+		$registrations = $this->_get_registrations($TXN_ID);
64
+		if (empty($registrations)) {
65 65
 			return;
66 66
 		}
67 67
 		// now loop thru each payment and apply it to each of the registrations
68
-		foreach ( $payments as $PAY_ID => $payment ) {
69
-			if ( $payment->STS_ID === 'PAP' && $payment->PAY_amount > 0 ) {
70
-				$this->_process_registration_payments( $payment, $registrations );
68
+		foreach ($payments as $PAY_ID => $payment) {
69
+			if ($payment->STS_ID === 'PAP' && $payment->PAY_amount > 0) {
70
+				$this->_process_registration_payments($payment, $registrations);
71 71
 			}
72 72
 		}
73 73
 	}
@@ -80,11 +80,11 @@  discard block
 block discarded – undo
80 80
 	 * @param int $TXN_ID
81 81
 	 * @return array
82 82
 	 */
83
-	protected function _get_registrations( $TXN_ID ) {
83
+	protected function _get_registrations($TXN_ID) {
84 84
 		/** @type WPDB $wpdb */
85 85
 		global $wpdb;
86 86
 		$SQL = "SELECT * FROM {$this->_registration_table} WHERE TXN_ID = %d AND STS_ID IN ( 'RPP', 'RAP' )";
87
-		return $wpdb->get_results( $wpdb->prepare( $SQL, $TXN_ID ), OBJECT_K );
87
+		return $wpdb->get_results($wpdb->prepare($SQL, $TXN_ID), OBJECT_K);
88 88
 	}
89 89
 
90 90
 
@@ -95,10 +95,10 @@  discard block
 block discarded – undo
95 95
 	 * @param int $TXN_ID
96 96
 	 * @return array
97 97
 	 */
98
-	protected function _get_payments( $TXN_ID ) {
98
+	protected function _get_payments($TXN_ID) {
99 99
 		/** @type WPDB $wpdb */
100 100
 		global $wpdb;
101
-		return $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$this->_payment_table} WHERE TXN_ID = %d", $TXN_ID ), OBJECT_K );
101
+		return $wpdb->get_results($wpdb->prepare("SELECT * FROM {$this->_payment_table} WHERE TXN_ID = %d", $TXN_ID), OBJECT_K);
102 102
 	}
103 103
 
104 104
 
@@ -109,10 +109,10 @@  discard block
 block discarded – undo
109 109
 	 * @param int $REG_ID
110 110
 	 * @return array
111 111
 	 */
112
-	protected function _get_possibly_updated_REG_paid( $REG_ID ) {
112
+	protected function _get_possibly_updated_REG_paid($REG_ID) {
113 113
 		/** @type WPDB $wpdb */
114 114
 		global $wpdb;
115
-		return $wpdb->get_var( $wpdb->prepare( "SELECT REG_paid FROM {$this->_registration_table} WHERE REG_ID = %d", $REG_ID ) );
115
+		return $wpdb->get_var($wpdb->prepare("SELECT REG_paid FROM {$this->_registration_table} WHERE REG_ID = %d", $REG_ID));
116 116
 	}
117 117
 
118 118
 
@@ -127,40 +127,40 @@  discard block
 block discarded – undo
127 127
 	 * @param array $registrations
128 128
 	 * @return bool
129 129
 	 */
130
-	protected function _process_registration_payments( $payment, $registrations = array() ){
130
+	protected function _process_registration_payments($payment, $registrations = array()) {
131 131
 		// how much is available to apply to registrations?
132 132
 		$available_payment_amount = $payment->PAY_amount;
133
-		foreach ( $registrations as $REG_ID => $registration ) {
133
+		foreach ($registrations as $REG_ID => $registration) {
134 134
 			// nothing left, then we are done here?
135
-			if ( ! $available_payment_amount > 0 ) {
135
+			if ( ! $available_payment_amount > 0) {
136 136
 				break;
137 137
 			}
138 138
 			// ensure REG_final_price has a valid value, and skip if it turns out to be zero
139
-			$registration->REG_final_price = ! empty( $registration->REG_final_price ) ? (float)$registration->REG_final_price : 0.00;
140
-			if ( ! $registration->REG_final_price > 0 ) {
139
+			$registration->REG_final_price = ! empty($registration->REG_final_price) ? (float) $registration->REG_final_price : 0.00;
140
+			if ( ! $registration->REG_final_price > 0) {
141 141
 				continue;
142 142
 			}
143 143
 			// because REG_paid may have been updated by a previous payment, we need to retrieve the value from the db
144
-			$possibly_updated_REG_paid = $this->_get_possibly_updated_REG_paid( $REG_ID );
145
-			if ( is_float( $possibly_updated_REG_paid ) ) {
144
+			$possibly_updated_REG_paid = $this->_get_possibly_updated_REG_paid($REG_ID);
145
+			if (is_float($possibly_updated_REG_paid)) {
146 146
 				$registration->REG_paid = $possibly_updated_REG_paid;
147 147
 			}
148 148
 			// and ensure REG_paid has a valid value
149
-			$registration->REG_paid = ! empty( $registration->REG_paid ) ? (float)$registration->REG_paid : 0.00;
149
+			$registration->REG_paid = ! empty($registration->REG_paid) ? (float) $registration->REG_paid : 0.00;
150 150
 			// calculate amount owing, and skip if it turns out to be zero
151 151
 			$owing = $registration->REG_final_price - $registration->REG_paid;
152
-			if ( ! $owing > 0 ) {
152
+			if ( ! $owing > 0) {
153 153
 				continue;
154 154
 			}
155 155
 			// don't allow payment amount to exceed the available payment amount, OR the amount owing
156
-			$payment_amount = min( $available_payment_amount, $owing );
156
+			$payment_amount = min($available_payment_amount, $owing);
157 157
 			// update $available_payment_amount
158 158
 			$available_payment_amount = $available_payment_amount - $payment_amount;
159 159
 			// add relation between registration and payment and set amount
160
-			if ( $this->_insert_registration_payment( $registration->REG_ID, $payment->PAY_ID, $payment_amount )) {
160
+			if ($this->_insert_registration_payment($registration->REG_ID, $payment->PAY_ID, $payment_amount)) {
161 161
 				//calculate and set new REG_paid
162 162
 				$registration->REG_paid = $registration->REG_paid + $payment_amount;
163
-				$this->_update_registration_paid( $registration->REG_ID, $registration->REG_paid );
163
+				$this->_update_registration_paid($registration->REG_ID, $registration->REG_paid);
164 164
 			}
165 165
 		}
166 166
 	}
@@ -175,18 +175,18 @@  discard block
 block discarded – undo
175 175
 	 * @param float $PAY_amount
176 176
 	 * @return bool
177 177
 	 */
178
-	protected function _insert_registration_payment( $REG_ID = 0, $PAY_ID = 0, $PAY_amount = 0.00 ){
178
+	protected function _insert_registration_payment($REG_ID = 0, $PAY_ID = 0, $PAY_amount = 0.00) {
179 179
 		/** @type WPDB $wpdb */
180 180
 		global $wpdb;
181 181
 		$success = $wpdb->insert(
182 182
 			$this->_registration_payment_table,
183
-			array( 'REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount, ),  // data
184
-			array( '%f' )   // data format
183
+			array('REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount,), // data
184
+			array('%f')   // data format
185 185
 		);
186
-		if ( $success === false ) {
186
+		if ($success === false) {
187 187
 			$this->add_error(
188 188
 				sprintf(
189
-					__( 'Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso' ),
189
+					__('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'),
190 190
 					$REG_ID,
191 191
 					$wpdb->last_error
192 192
 				)
@@ -205,20 +205,20 @@  discard block
 block discarded – undo
205 205
 	 * @param float $REG_paid
206 206
 	 * @return bool
207 207
 	 */
208
-	protected function _update_registration_paid( $REG_ID = 0, $REG_paid = 0.00 ) {
208
+	protected function _update_registration_paid($REG_ID = 0, $REG_paid = 0.00) {
209 209
 		/** @type WPDB $wpdb */
210 210
 		global $wpdb;
211 211
 		$success = $wpdb->update(
212 212
 			$this->_registration_table,
213
-			array( 'REG_paid' => $REG_paid ),  // data
214
-			array( 'REG_ID' => $REG_ID ),  // where
215
-			array( '%f' ),   // data format
216
-			array( '%d' )  // where format
213
+			array('REG_paid' => $REG_paid), // data
214
+			array('REG_ID' => $REG_ID), // where
215
+			array('%f'), // data format
216
+			array('%d')  // where format
217 217
 		);
218
-		if ( $success === false ) {
218
+		if ($success === false) {
219 219
 			$this->add_error(
220 220
 				sprintf(
221
-					__( 'Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso' ),
221
+					__('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'),
222 222
 					$REG_ID,
223 223
 					$wpdb->last_error
224 224
 				)
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_Data_Migration_Class_Base.core.php 4 patches
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -234,7 +234,7 @@
 block discarded – undo
234 234
 	 * @param array $old_row_as_array
235 235
 	 * @param string $new_table
236 236
 	 * @param array $new_row_as_array columns=>values like used in wpdb->insert
237
-	 * @param array $data_types numerically indexed
237
+	 * @param string[] $data_types numerically indexed
238 238
 	 * @return string
239 239
 	 */
240 240
 	protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types){
Please login to merge, or discard this patch.
Indentation   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -264,9 +264,9 @@
 block discarded – undo
264 264
 	/**
265 265
 	 * Same as json_encode, just avoids putting
266 266
 	 * serialized arrays into the http build query, as that would
267
-	* @param array $array_of_data
268
-	* @return string
269
-	*/
267
+	 * @param array $array_of_data
268
+	 * @return string
269
+	 */
270 270
 	protected function _json_encode($array_of_data){
271 271
 		//we'd rather NOT serialize the transaction details
272 272
 		$fields_to_include = array();
Please login to merge, or discard this patch.
Braces   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -119,7 +119,7 @@  discard block
 block discarded – undo
119 119
 		$errors = $this->get_errors();
120 120
 		if($errors){
121 121
 			return end($errors);
122
-		}else{
122
+		} else{
123 123
 			return null;
124 124
 		}
125 125
 	}
@@ -131,7 +131,7 @@  discard block
 block discarded – undo
131 131
 	public function add_error($error, $force = FALSE ){
132 132
 		if( ! defined( 'EE_DMS_ERROR_LIMIT' ) ){
133 133
 			$limit = 50;
134
-		}else{
134
+		} else{
135 135
 			$limit = EE_DMS_ERROR_LIMIT;
136 136
 		}
137 137
 		//make sure errors is an array, see ticket #8261
@@ -144,10 +144,10 @@  discard block
 block discarded – undo
144 144
 				$this->_errors = array_slice( $this->_errors, $limit / 2, $limit / 2 );
145 145
 				$this->_errors[] = "Limit reached; removed first half of errors to save space";
146 146
 				$this->_errors[] = $error;
147
-			}else{
147
+			} else{
148 148
 				$this->_errors[ $limit ] = 'More, but limit reached...';
149 149
 			}
150
-		}else{
150
+		} else{
151 151
 			$this->_errors[] = $error;
152 152
 		}
153 153
 	}
Please login to merge, or discard this patch.
Spacing   +52 added lines, -52 removed lines patch added patch discarded remove patch
@@ -20,7 +20,7 @@  discard block
 block discarded – undo
20 20
 
21 21
 
22 22
 
23
-abstract class EE_Data_Migration_Class_Base{
23
+abstract class EE_Data_Migration_Class_Base {
24 24
 
25 25
 	/**
26 26
 	 * @var $records_to_migrate int count of all that have been migrated
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
 	 * @param TableManager  $table_manager
73 73
 	 * @param TableAnalysis $table_analysis
74 74
 	 */
75
-	public function __construct( TableManager $table_manager = null, TableAnalysis $table_analysis = null ){
75
+	public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null) {
76 76
 		$this->_table_manager = $table_manager;
77 77
 		$this->_table_analysis = $table_analysis;
78 78
 		$this->set_status(EE_Data_Migration_Manager::status_continue);
@@ -85,9 +85,9 @@  discard block
 block discarded – undo
85 85
 	 * @throws EE_Error
86 86
 	 * @return string
87 87
 	 */
88
-	public function pretty_name(){
89
-		if($this->_pretty_name === null){
90
-			throw new EE_Error(sprintf(__("Please give a pretty name to the migration script stage %s by assigning the property _pretty_name in the constructor", "event_espresso"),get_class($this)));
88
+	public function pretty_name() {
89
+		if ($this->_pretty_name === null) {
90
+			throw new EE_Error(sprintf(__("Please give a pretty name to the migration script stage %s by assigning the property _pretty_name in the constructor", "event_espresso"), get_class($this)));
91 91
 		}
92 92
 		return $this->_pretty_name;
93 93
 	}
@@ -95,8 +95,8 @@  discard block
 block discarded – undo
95 95
 	 *
96 96
 	 * @return int
97 97
 	 */
98
-	public function count_records_to_migrate(){
99
-		if( $this->_records_to_migrate == null){
98
+	public function count_records_to_migrate() {
99
+		if ($this->_records_to_migrate == null) {
100 100
 			$this->_records_to_migrate = $this->_count_records_to_migrate();
101 101
 		}
102 102
 		return $this->_records_to_migrate;
@@ -116,9 +116,9 @@  discard block
 block discarded – undo
116 116
 	 * @return string one of EE_Data_Migration_Manager::status_* constants
117 117
 	 * @throws EE_Error
118 118
 	 */
119
-	public function get_status(){
120
-		if($this->_status === null){
121
-			throw new EE_Error(sprintf(__("Trying to get status of Migration class %s, but it has not been initialized yet. It should be set in the constructor.", "event_espresso"),get_class($this)));
119
+	public function get_status() {
120
+		if ($this->_status === null) {
121
+			throw new EE_Error(sprintf(__("Trying to get status of Migration class %s, but it has not been initialized yet. It should be set in the constructor.", "event_espresso"), get_class($this)));
122 122
 		}
123 123
 		return $this->_status;
124 124
 	}
@@ -127,7 +127,7 @@  discard block
 block discarded – undo
127 127
 	 * @param string $status
128 128
 	 * @return void
129 129
 	 */
130
-	protected function set_status($status){
130
+	protected function set_status($status) {
131 131
 		$this->_status = $status;
132 132
 	}
133 133
 	/**
@@ -139,11 +139,11 @@  discard block
 block discarded – undo
139 139
 	 * Returns the last error that occurred. If none occurred, returns null
140 140
 	 * @return string
141 141
 	 */
142
-	public function get_last_error(){
142
+	public function get_last_error() {
143 143
 		$errors = $this->get_errors();
144
-		if($errors){
144
+		if ($errors) {
145 145
 			return end($errors);
146
-		}else{
146
+		} else {
147 147
 			return null;
148 148
 		}
149 149
 	}
@@ -152,26 +152,26 @@  discard block
 block discarded – undo
152 152
 	 * @param string $error a string describing the error that will be useful for debugging. Consider including all the data that led to the error, and a stack trace etc.
153 153
 	 * @param boolean $force force the error to be added (because otherwise we have a limit). If forcing and errors are already at their limit, we will purposefully forget the first half
154 154
 	 */
155
-	public function add_error($error, $force = FALSE ){
156
-		if( ! defined( 'EE_DMS_ERROR_LIMIT' ) ){
155
+	public function add_error($error, $force = FALSE) {
156
+		if ( ! defined('EE_DMS_ERROR_LIMIT')) {
157 157
 			$limit = 50;
158
-		}else{
158
+		} else {
159 159
 			$limit = EE_DMS_ERROR_LIMIT;
160 160
 		}
161 161
 		//make sure errors is an array, see ticket #8261
162
-		if( is_string( $this->_errors ) ){
163
-			$this->_errors = array( $this->_errors );
162
+		if (is_string($this->_errors)) {
163
+			$this->_errors = array($this->_errors);
164 164
 		}
165
-		if(count($this->_errors) >= $limit ){
166
-			if( $force ){
165
+		if (count($this->_errors) >= $limit) {
166
+			if ($force) {
167 167
 				//get rid of the first half of the errors and any above the limit
168
-				$this->_errors = array_slice( $this->_errors, $limit / 2, $limit / 2 );
168
+				$this->_errors = array_slice($this->_errors, $limit / 2, $limit / 2);
169 169
 				$this->_errors[] = "Limit reached; removed first half of errors to save space";
170 170
 				$this->_errors[] = $error;
171
-			}else{
172
-				$this->_errors[ $limit ] = 'More, but limit reached...';
171
+			} else {
172
+				$this->_errors[$limit] = 'More, but limit reached...';
173 173
 			}
174
-		}else{
174
+		} else {
175 175
 			$this->_errors[] = $error;
176 176
 		}
177 177
 	}
@@ -180,57 +180,57 @@  discard block
 block discarded – undo
180 180
 	 * Indicates there was a fatal error and the migration cannot possibly continue
181 181
 	 * @return boolean
182 182
 	 */
183
-	public function is_broken(){
183
+	public function is_broken() {
184 184
 		return $this->get_status() == EE_Data_Migration_Manager::status_fatal_error;
185 185
 	}
186 186
 	/**
187 187
 	 * @deprecated since 4.6.12
188 188
 	 */
189
-	public function is_borked(){
190
-		EE_Error::doing_it_wrong('is_borked', __( 'The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso' ), '4.6.12');
189
+	public function is_borked() {
190
+		EE_Error::doing_it_wrong('is_borked', __('The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso'), '4.6.12');
191 191
 		return $this->is_broken();
192 192
 	}
193 193
 	/**
194 194
 	 * Sets the status to as having a fatal error
195 195
 	 */
196
-	public function set_broken(){
196
+	public function set_broken() {
197 197
 		$this->_status = EE_Data_Migration_Manager::status_fatal_error;
198 198
 	}
199 199
 	/**
200 200
 	 *
201 201
 	 * @deprecated since 4.6.12
202 202
 	 */
203
-	public function set_borked(){
204
-		EE_Error::doing_it_wrong('is_borked', __( 'The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso' ), '4.6.12');
203
+	public function set_borked() {
204
+		EE_Error::doing_it_wrong('is_borked', __('The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso'), '4.6.12');
205 205
 		return $this->set_broken();
206 206
 	}
207 207
 	/**
208 208
 	 * Checks if this thing believes it is completed
209 209
 	 * @return boolean
210 210
 	 */
211
-	public function is_completed(){
211
+	public function is_completed() {
212 212
 		return $this->get_status() == EE_Data_Migration_Manager::status_completed;
213 213
 	}
214 214
 	/**
215 215
 	 * Checks if the current script has more to do or not (ie, if it's status is CONTINUE)
216 216
 	 * @return boolean
217 217
 	 */
218
-	public function has_more_to_do(){
218
+	public function has_more_to_do() {
219 219
 		return $this->get_status() == EE_Data_Migration_Manager::status_continue;
220 220
 	}
221 221
 	/**
222 222
 	 * Marks that we believe this migration thing is completed
223 223
 	 */
224
-	public function set_completed(){
224
+	public function set_completed() {
225 225
 		$this->_status = EE_Data_Migration_Manager::status_completed;
226 226
 	}
227 227
 
228 228
 	/**
229 229
 	 * Marks that we think this migration class can continue to migrate
230 230
 	 */
231
-	public function reattempt(){
231
+	public function reattempt() {
232 232
 		$this->_status = EE_Data_Migration_Manager::status_continue;
233
-		$this->add_error( __( 'Reattempt migration', 'event_espresso' ), TRUE );
233
+		$this->add_error(__('Reattempt migration', 'event_espresso'), TRUE);
234 234
 	}
235 235
 
236 236
 	/**
@@ -239,8 +239,8 @@  discard block
 block discarded – undo
239 239
 	 * possible that this class is defined when it goes to sleep, but NOT available when it
240 240
 	 * awakes (eg, this class is part of an addon that is deactivated at some point).
241 241
 	 */
242
-	public function properties_as_array(){
243
-		$properties =  get_object_vars($this);
242
+	public function properties_as_array() {
243
+		$properties = get_object_vars($this);
244 244
 		$properties['class'] = get_class($this);
245 245
 		unset($properties['_migration_script']);
246 246
 		return $properties;
@@ -261,22 +261,22 @@  discard block
 block discarded – undo
261 261
 	 * @param array $data_types numerically indexed
262 262
 	 * @return string
263 263
 	 */
264
-	protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types){
264
+	protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types) {
265 265
 		global $wpdb;
266 266
 		$old_columns_and_values_for_string = array();
267
-		foreach($old_row_as_array as $column => $value){
267
+		foreach ($old_row_as_array as $column => $value) {
268 268
 			$old_columns_and_values_for_string[] = "$column => $value";
269 269
 		}
270 270
 		$new_columns_and_values_for_string = array();
271 271
 		$count = 0;
272
-		foreach($new_row_as_array as $column => $value){
272
+		foreach ($new_row_as_array as $column => $value) {
273 273
 			$new_columns_and_values_for_string[] = " $column => $value (".$data_types[$count++].")";
274 274
 		}
275 275
 		return sprintf(
276 276
 			__('Received error "%6$s" inserting row %5$s %1$s %5$s into table %2$s.%5$s Data used was %5$s %3$s %5$s from table %4%s.', "event_espresso"),
277
-			implode(", ",$new_columns_and_values_for_string),
277
+			implode(", ", $new_columns_and_values_for_string),
278 278
 			$new_table,
279
-			implode(", ",$old_columns_and_values_for_string),
279
+			implode(", ", $old_columns_and_values_for_string),
280 280
 			$old_table,
281 281
 			'<br/>',
282 282
 			$wpdb->last_error
@@ -291,12 +291,12 @@  discard block
 block discarded – undo
291 291
 	* @param array $array_of_data
292 292
 	* @return string
293 293
 	*/
294
-	protected function _json_encode($array_of_data){
294
+	protected function _json_encode($array_of_data) {
295 295
 		//we'd rather NOT serialize the transaction details
296 296
 		$fields_to_include = array();
297
-		foreach($array_of_data as $name => $value){
297
+		foreach ($array_of_data as $name => $value) {
298 298
 			$unserialized_data = @unserialize($value);
299
-			if($unserialized_data === FALSE){
299
+			if ($unserialized_data === FALSE) {
300 300
 				$fields_to_include[$name] = $value;
301 301
 			}
302 302
 		}
@@ -309,13 +309,13 @@  discard block
 block discarded – undo
309 309
 	 * @throws EE_Error
310 310
 	 */
311 311
 	protected function _get_table_manager() {
312
-		if( $this->_table_manager instanceof TableManager ) {
312
+		if ($this->_table_manager instanceof TableManager) {
313 313
 			return $this->_table_manager;
314 314
 		} else {
315 315
 			throw new EE_Error( 
316 316
 				sprintf( 
317
-					__( 'Table manager on migration class %1$s is not set properly.', 'event_espresso'), 
318
-					get_class( $this ) 
317
+					__('Table manager on migration class %1$s is not set properly.', 'event_espresso'), 
318
+					get_class($this) 
319 319
 				) 	
320 320
 			);
321 321
 		}
@@ -327,13 +327,13 @@  discard block
 block discarded – undo
327 327
 	 * @throws EE_Error
328 328
 	 */
329 329
 	protected function _get_table_analysis() {
330
-		if( $this->_table_analysis instanceof TableAnalysis ) {
330
+		if ($this->_table_analysis instanceof TableAnalysis) {
331 331
 			return $this->_table_analysis;
332 332
 		} else {
333 333
 			throw new EE_Error( 
334 334
 				sprintf( 
335
-					__( 'Table analysis class on migration class %1$s is not set properly.', 'event_espresso'), 
336
-					get_class( $this ) 
335
+					__('Table analysis class on migration class %1$s is not set properly.', 'event_espresso'), 
336
+					get_class($this) 
337 337
 				) 
338 338
 			);
339 339
 		}
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_DMS_Core_4_1_0.dms.php 4 patches
Doc Comments   +2 added lines, -3 removed lines patch added patch discarded remove patch
@@ -1434,7 +1434,6 @@  discard block
 block discarded – undo
1434 1434
 	/**
1435 1435
 	 * Makes sure the 3.1's image url is converted to an image attachment post to the 4.1 CPT event
1436 1436
 	 * and sets it as the featured image on the CPT event
1437
-	 * @param type $old_event
1438 1437
 	 * @param type $new_cpt_id
1439 1438
 	 * @param  EE_Data_Migration_Script_Stage $migration_stage the stage which called this, where errors should be added
1440 1439
 	 * @return boolean whether or not we had to do the big job of creating an image attachment
@@ -1482,7 +1481,7 @@  discard block
 block discarded – undo
1482 1481
 	/**
1483 1482
 	 * Creates an image attachment post for the GUID. If the GUID points to a remote image,
1484 1483
 	 * we download it to our uploads directory so that it can be properly processed (eg, creates different sizes of thumbnails)
1485
-	 * @param type $guid
1484
+	 * @param string $guid
1486 1485
 	 * @param EE_Data_Migration_Script_Stage $migration_stage
1487 1486
 	 * @return int
1488 1487
 	 */
@@ -1558,7 +1557,7 @@  discard block
 block discarded – undo
1558 1557
 	/**
1559 1558
 	 * Returns a mysql-formatted DATETIME in UTC time, given a $DATETIME_string
1560 1559
 	 * (and optionally a timezone; if none is given, the wp DEFAULT is used)
1561
-	 * @param EE_Data_Migration_Script_base $stage
1560
+	 * @param EE_Data_Migration_Script_Stage $stage
1562 1561
 	 * @param array $row_of_data, the row from the DB (as an array) we're trying to find the UTC time for
1563 1562
 	 * @param string $DATETIME_string
1564 1563
 	 * @param string $timezone
Please login to merge, or discard this patch.
Indentation   +13 added lines, -13 removed lines patch added patch discarded remove patch
@@ -1607,19 +1607,19 @@
 block discarded – undo
1607 1607
 	private function timezone_convert_to_string_from_offset($offset){
1608 1608
 		//shamelessly taken from bottom comment at http://ca1.php.net/manual/en/function.timezone-name-from-abbr.php because timezone_name_from_abbr() did NOT work as expected - its not reliable
1609 1609
 		$offset *= 3600; // convert hour offset to seconds
1610
-        $abbrarray = timezone_abbreviations_list();
1611
-        foreach ($abbrarray as $abbr){
1612
-                foreach ($abbr as $city)
1613
-                {
1614
-                        if ($city['offset'] == $offset)
1615
-                        {
1616
-
1617
-                                return $city['timezone_id'];
1618
-                        }
1619
-                }
1620
-        }
1621
-
1622
-        return FALSE;
1610
+		$abbrarray = timezone_abbreviations_list();
1611
+		foreach ($abbrarray as $abbr){
1612
+				foreach ($abbr as $city)
1613
+				{
1614
+						if ($city['offset'] == $offset)
1615
+						{
1616
+
1617
+								return $city['timezone_id'];
1618
+						}
1619
+				}
1620
+		}
1621
+
1622
+		return FALSE;
1623 1623
 	}
1624 1624
 
1625 1625
 	public function migration_page_hooks(){
Please login to merge, or discard this patch.
Braces   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
 		$results = $wpdb->get_results("SHOW TABLES LIKE '".$wpdb->prefix."events_attendee_checkin"."'");
73 73
 		if($results){
74 74
 			return true;
75
-		}else{
75
+		} else{
76 76
 			return false;
77 77
 		}
78 78
 	}
@@ -81,12 +81,12 @@  discard block
 block discarded – undo
81 81
 		if($version_string < '4.0.0' && $version_string > '3.1.26' ){
82 82
 //			echo "$version_string can be migrated fro";
83 83
 			return true;
84
-		}elseif( ! $version_string ){
84
+		} elseif( ! $version_string ){
85 85
 //			echo "no version string provided: $version_string";
86 86
 			//no version string provided... this must be pre 4.1
87 87
 			//because since 4.1 we're
88 88
 			return false;//changed mind. dont want people thinking they should migrate yet because they cant
89
-		}else{
89
+		} else{
90 90
 //			echo "$version_string doesnt apply";
91 91
 			return false;
92 92
 		}
@@ -1088,7 +1088,7 @@  discard block
 block discarded – undo
1088 1088
 		try{
1089 1089
 			$country = $this->get_or_create_country($country_name);
1090 1090
 			$country_iso = $country['CNT_ISO'];
1091
-		}catch(EE_Error $e){
1091
+		} catch(EE_Error $e){
1092 1092
 			$country_iso = $this->get_default_country_iso();
1093 1093
 		}
1094 1094
 		global $wpdb;
@@ -1132,7 +1132,7 @@  discard block
 block discarded – undo
1132 1132
 		if( ! $matches || count($matches)<3){
1133 1133
 			$hour = '00';
1134 1134
 			$minutes = '00';
1135
-		}else{
1135
+		} else{
1136 1136
 			$hour = intval($matches[1]);
1137 1137
 			$minutes = $matches[2];
1138 1138
 		}
@@ -1408,7 +1408,7 @@  discard block
 block discarded – undo
1408 1408
 		//EE team can read the related discussion: https://app.asana.com/0/2400967562914/9418495544455
1409 1409
 		if($this_thing_required_pre_approval){
1410 1410
 				return 'RNA';
1411
-		}else{
1411
+		} else{
1412 1412
 				$mapping = $default_reg_stati_conversions=array(
1413 1413
 			'Completed'=>'RAP',
1414 1414
 			''=>'RPP',
@@ -1453,7 +1453,7 @@  discard block
 block discarded – undo
1453 1453
 			//double-check we actually have an attachment post
1454 1454
 			if( $attachment_post_id){
1455 1455
 				update_post_meta($new_cpt_id,'_thumbnail_id',$attachment_post_id);
1456
-			}else{
1456
+			} else{
1457 1457
 				$migration_stage->add_error(sprintf(__("Could not update event image %s for CPT with ID %d, but attachments post ID is %d", "event_espresso"),$guid,$new_cpt_id,$attachment_post_id));
1458 1458
 			}
1459 1459
 		}
@@ -1474,7 +1474,7 @@  discard block
 block discarded – undo
1474 1474
 		$head_response = wp_remote_head($original_guid);
1475 1475
 		if( ! $head_response instanceof WP_Error && $head_response['response']['message'] == 'OK'){
1476 1476
 			return $original_guid;
1477
-		}else{
1477
+		} else{
1478 1478
 			return $guid_in_old_event;
1479 1479
 		}
1480 1480
 	}
@@ -1510,7 +1510,7 @@  discard block
 block discarded – undo
1510 1510
 			fwrite($savefile, $contents);
1511 1511
 			fclose($savefile);
1512 1512
 			$guid = str_replace($wp_upload_dir['path'],$wp_upload_dir['url'],$local_filepath);
1513
-		}else{
1513
+		} else{
1514 1514
 			$local_filepath = str_replace($wp_upload_dir['url'],$wp_upload_dir['path'],$guid);
1515 1515
 		}
1516 1516
 
@@ -1576,7 +1576,7 @@  discard block
 block discarded – undo
1576 1576
 		try{
1577 1577
 			$date_obj = new DateTime( $DATETIME_string, new DateTimeZone( $timezone ) );
1578 1578
 			$date_obj->setTimezone(new DateTimeZone('UTC'));
1579
-		}catch(Exception $e){
1579
+		} catch(Exception $e){
1580 1580
 			$stage->add_error(sprintf(__("Could not convert time string '%s' using timezone '%s' into a proper DATETIME. Using current time instead.", "event_espresso"),$DATETIME_string,$timezone));
1581 1581
 			$date_obj = new DateTime();
1582 1582
 		}
Please login to merge, or discard this patch.
Spacing   +202 added lines, -202 removed lines patch added patch discarded remove patch
@@ -20,7 +20,7 @@  discard block
 block discarded – undo
20 20
  * really, you're best off copying the whole thing when 4.1 is released into this file
21 21
  * and wrapping its declaration in if( ! class_exists()){...}
22 22
  */
23
-class EE_DMS_Core_4_1_0 extends EE_Data_Migration_Script_Base{
23
+class EE_DMS_Core_4_1_0 extends EE_Data_Migration_Script_Base {
24 24
 
25 25
 
26 26
 
@@ -31,7 +31,7 @@  discard block
 block discarded – undo
31 31
 	 * @param TableAnalysis $table_analysis
32 32
 	 * @throws \EE_Error
33 33
 	 */
34
-	public function __construct( TableManager $table_manager = null, TableAnalysis $table_analysis = null ) {
34
+	public function __construct(TableManager $table_manager = null, TableAnalysis $table_analysis = null) {
35 35
 		$this->_load_script_stages();
36 36
 		$this->_pretty_name = __("Data Migration to Event Espresso 4.1.0P", "event_espresso");
37 37
 		$this->_priority = 10;
@@ -54,7 +54,7 @@  discard block
 block discarded – undo
54 54
 			new EE_DMS_4_1_0_answers(),
55 55
 			new EE_DMS_4_1_0_checkins(),
56 56
 		);
57
-		parent::__construct( $table_manager, $table_analysis );
57
+		parent::__construct($table_manager, $table_analysis);
58 58
 	}
59 59
 
60 60
 
@@ -65,27 +65,27 @@  discard block
 block discarded – undo
65 65
 	 * @global wpdb $wpdb
66 66
 	 * @return boolean
67 67
 	 */
68
-	private function _checkin_table_exists(){
68
+	private function _checkin_table_exists() {
69 69
 		global $wpdb;
70 70
 		$results = $wpdb->get_results("SHOW TABLES LIKE '".$wpdb->prefix."events_attendee_checkin"."'");
71
-		if($results){
71
+		if ($results) {
72 72
 			return true;
73
-		}else{
73
+		} else {
74 74
 			return false;
75 75
 		}
76 76
 	}
77 77
 
78 78
 	public function can_migrate_from_version($version_array) {
79 79
 		$version_string = $version_array['Core'];
80
-		if($version_string < '4.0.0' && $version_string > '3.1.26' ){
80
+		if ($version_string < '4.0.0' && $version_string > '3.1.26') {
81 81
 //			echo "$version_string can be migrated fro";
82 82
 			return true;
83
-		}elseif( ! $version_string ){
83
+		}elseif ( ! $version_string) {
84 84
 //			echo "no version string provided: $version_string";
85 85
 			//no version string provided... this must be pre 4.1
86 86
 			//because since 4.1 we're
87
-			return false;//changed mind. dont want people thinking they should migrate yet because they cant
88
-		}else{
87
+			return false; //changed mind. dont want people thinking they should migrate yet because they cant
88
+		} else {
89 89
 //			echo "$version_string doesnt apply";
90 90
 			return false;
91 91
 		}
@@ -95,15 +95,15 @@  discard block
 block discarded – undo
95 95
 	}
96 96
 	public function schema_changes_before_migration() {
97 97
 		//relies on 4.1's EEH_Activation::create_table
98
-		require_once( EE_HELPERS . 'EEH_Activation.helper.php' );
98
+		require_once(EE_HELPERS.'EEH_Activation.helper.php');
99 99
 
100
-		$table_name='esp_answer';
101
-		$sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
100
+		$table_name = 'esp_answer';
101
+		$sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
102 102
 					REG_ID INT UNSIGNED NOT NULL,
103 103
 					QST_ID INT UNSIGNED NOT NULL,
104 104
 					ANS_value TEXT NOT NULL,
105 105
 					PRIMARY KEY  (ANS_ID)";
106
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
106
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
107 107
 
108 108
 		$table_name = 'esp_attendee_meta';
109 109
 		$sql = "ATTM_ID INT(10) UNSIGNED NOT	NULL AUTO_INCREMENT,
@@ -143,7 +143,7 @@  discard block
 block discarded – undo
143 143
 					  CNT_is_EU TINYINT(1) DEFAULT '0',
144 144
 					  CNT_active TINYINT(1) DEFAULT '0',
145 145
 					  PRIMARY KEY  (CNT_ISO)";
146
-		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB' );
146
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
147 147
 
148 148
 
149 149
 
@@ -164,7 +164,7 @@  discard block
 block discarded – undo
164 164
 
165 165
 
166 166
 
167
-		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB' );
167
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
168 168
 		$table_name = 'esp_event_meta';
169 169
 		$sql = "
170 170
 			EVTM_ID INT NOT NULL AUTO_INCREMENT,
@@ -181,41 +181,41 @@  discard block
 block discarded – undo
181 181
 			EVT_external_URL VARCHAR(200) NULL,
182 182
 			EVT_donations TINYINT(1) NULL,
183 183
 			PRIMARY KEY  (EVTM_ID)";
184
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
184
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
185 185
 
186 186
 
187 187
 
188
-		$table_name='esp_event_question_group';
189
-		$sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
188
+		$table_name = 'esp_event_question_group';
189
+		$sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
190 190
 					EVT_ID BIGINT(20) UNSIGNED NOT NULL,
191 191
 					QSG_ID INT UNSIGNED NOT NULL,
192 192
 					EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
193 193
 					PRIMARY KEY  (EQG_ID)";
194
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
194
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
195 195
 
196 196
 
197 197
 
198
-		$table_name='esp_event_venue';
199
-		$sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT,
198
+		$table_name = 'esp_event_venue';
199
+		$sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT,
200 200
 				EVT_ID BIGINT(20) UNSIGNED NOT NULL,
201 201
 				VNU_ID BIGINT(20) UNSIGNED NOT NULL,
202 202
 				EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
203 203
 				PRIMARY KEY  (EVV_ID)";
204
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
204
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
205 205
 
206 206
 
207 207
 
208
-		$table_name='esp_extra_meta';
209
-		$sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT,
208
+		$table_name = 'esp_extra_meta';
209
+		$sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT,
210 210
 				OBJ_ID INT(11) DEFAULT NULL,
211 211
 				EXM_type VARCHAR(45) DEFAULT NULL,
212 212
 				EXM_key VARCHAR(45) DEFAULT NULL,
213 213
 				EXM_value TEXT,
214 214
 				PRIMARY KEY  (EXM_ID)";
215
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
215
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
216 216
 
217
-		$table_name='esp_line_item';
218
-		$sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT,
217
+		$table_name = 'esp_line_item';
218
+		$sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT,
219 219
 				LIN_code VARCHAR(245) NOT NULL DEFAULT '',
220 220
 				TXN_ID INT(11) DEFAULT NULL,
221 221
 				LIN_name VARCHAR(245) NOT NULL DEFAULT '',
@@ -231,7 +231,7 @@  discard block
 block discarded – undo
231 231
 				OBJ_ID INT(11) DEFAULT NULL,
232 232
 				OBJ_type VARCHAR(45)DEFAULT NULL,
233 233
 				PRIMARY KEY  (LIN_ID)";
234
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB' );
234
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
235 235
 
236 236
 		$table_name = 'esp_message_template';
237 237
 		$sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -258,7 +258,7 @@  discard block
 block discarded – undo
258 258
 					PRIMARY KEY  (GRP_ID),
259 259
 					KEY EVT_ID (EVT_ID),
260 260
 					KEY MTP_user_id (MTP_user_id)";
261
-		$this->_table_is_new_in_this_version( $table_name, $sql, 'ENGINE=InnoDB');
261
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
262 262
 
263 263
 
264 264
 
@@ -366,8 +366,8 @@  discard block
 block discarded – undo
366 366
 
367 367
 
368 368
 
369
-		$table_name='esp_question';
370
-		$sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
369
+		$table_name = 'esp_question';
370
+		$sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
371 371
 					QST_display_text TEXT NOT NULL,
372 372
 					QST_admin_label VARCHAR(255) NOT NULL,
373 373
 					QST_system VARCHAR(25) DEFAULT NULL,
@@ -379,12 +379,12 @@  discard block
 block discarded – undo
379 379
 					QST_wp_user BIGINT UNSIGNED NULL,
380 380
 					QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0,
381 381
 					PRIMARY KEY  (QST_ID)';
382
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
382
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
383 383
 
384
-		$this->_get_table_manager()->dropIndex( 'esp_question_group', 'QSG_identifier_UNIQUE' );
384
+		$this->_get_table_manager()->dropIndex('esp_question_group', 'QSG_identifier_UNIQUE');
385 385
 
386 386
 		$table_name = 'esp_question_group';
387
-		$sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
387
+		$sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
388 388
 					QSG_name VARCHAR(255) NOT NULL,
389 389
 					QSG_identifier VARCHAR(100) NOT NULL,
390 390
 					QSG_desc TEXT NULL,
@@ -395,27 +395,27 @@  discard block
 block discarded – undo
395 395
 					QSG_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
396 396
 					PRIMARY KEY  (QSG_ID),
397 397
 					UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)';
398
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
398
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
399 399
 
400 400
 
401 401
 
402
-		$table_name='esp_question_group_question';
403
-		$sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
402
+		$table_name = 'esp_question_group_question';
403
+		$sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
404 404
 					QSG_ID INT UNSIGNED NOT NULL,
405 405
 					QST_ID INT UNSIGNED NOT NULL,
406 406
 					PRIMARY KEY  (QGQ_ID) ";
407
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
407
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
408 408
 
409 409
 
410 410
 
411
-		$table_name='esp_question_option';
412
-		$sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
411
+		$table_name = 'esp_question_option';
412
+		$sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
413 413
 					QSO_value VARCHAR(255) NOT NULL,
414 414
 					QSO_desc TEXT NOT NULL,
415 415
 					QST_ID INT UNSIGNED NOT NULL,
416 416
 					QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
417 417
 					PRIMARY KEY  (QSO_ID)";
418
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
418
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
419 419
 
420 420
 
421 421
 
@@ -448,8 +448,8 @@  discard block
 block discarded – undo
448 448
 
449 449
 
450 450
 
451
-		$table_name='esp_checkin';
452
-		$sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
451
+		$table_name = 'esp_checkin';
452
+		$sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
453 453
 					REG_ID INT(10) UNSIGNED NOT NULL,
454 454
 					DTT_ID INT(10) UNSIGNED NOT NULL,
455 455
 					CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
@@ -556,12 +556,12 @@  discard block
 block discarded – undo
556 556
 
557 557
 		global $wpdb;
558 558
 		$state_table = $wpdb->prefix."esp_state";
559
-		if ( $this->_get_table_analysis()->tableExists( $state_table ) ) {
559
+		if ($this->_get_table_analysis()->tableExists($state_table)) {
560 560
 
561
-			$SQL = "SELECT COUNT('STA_ID') FROM " . $state_table;
561
+			$SQL = "SELECT COUNT('STA_ID') FROM ".$state_table;
562 562
 			$states = $wpdb->get_var($SQL);
563
-			if ( ! $states ) {
564
-				$SQL = "INSERT INTO " . $state_table . "
563
+			if ( ! $states) {
564
+				$SQL = "INSERT INTO ".$state_table."
565 565
 				(STA_ID, CNT_ISO, STA_abbrev, STA_name, STA_active) VALUES
566 566
 				(1, 'US', 'AK', 'Alaska', 1),
567 567
 				(2, 'US', 'AL', 'Alabama', 1),
@@ -648,12 +648,12 @@  discard block
 block discarded – undo
648 648
 
649 649
 		global $wpdb;
650 650
 		$country_table = $wpdb->prefix."esp_country";
651
-		if ( $this->_get_table_analysis()->tableExists( $country_table ) ) {
651
+		if ($this->_get_table_analysis()->tableExists($country_table)) {
652 652
 
653
-			$SQL = "SELECT COUNT('CNT_ISO') FROM " . $country_table;
653
+			$SQL = "SELECT COUNT('CNT_ISO') FROM ".$country_table;
654 654
 			$countries = $wpdb->get_var($SQL);
655
-			if ( ! $countries ) {
656
-				$SQL = "INSERT INTO " . $country_table . "
655
+			if ( ! $countries) {
656
+				$SQL = "INSERT INTO ".$country_table."
657 657
 				(CNT_ISO, CNT_ISO3, RGN_ID, CNT_name, CNT_cur_code, CNT_cur_single, CNT_cur_plural, CNT_cur_sign, CNT_cur_sign_b4, CNT_cur_dec_plc, CNT_tel_code, CNT_is_EU, CNT_active) VALUES
658 658
 				('AD', 'AND', 0, 'Andorra', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+376', 0, 0),
659 659
 				('AE', 'ARE', 0, 'United Arab Emirates', 'AED', 'Dirham', 'Dirhams', 'د.إ', 1, 2, '+971', 0, 0),
@@ -900,20 +900,20 @@  discard block
 block discarded – undo
900 900
 		global $wpdb;
901 901
 		$price_type_table = $wpdb->prefix."esp_price_type";
902 902
 
903
-		if ( $this->_get_table_analysis()->tableExists( $price_type_table ) ) {
903
+		if ($this->_get_table_analysis()->tableExists($price_type_table)) {
904 904
 
905
-			$SQL = 'SELECT COUNT(PRT_ID) FROM ' . $price_type_table;
906
-			$price_types_exist = $wpdb->get_var( $SQL );
905
+			$SQL = 'SELECT COUNT(PRT_ID) FROM '.$price_type_table;
906
+			$price_types_exist = $wpdb->get_var($SQL);
907 907
 
908
-			if ( ! $price_types_exist ) {
908
+			if ( ! $price_types_exist) {
909 909
 				$SQL = "INSERT INTO $price_type_table ( PRT_ID, PRT_name, PBT_ID, PRT_is_percent, PRT_order, PRT_deleted ) VALUES
910
-							(1, '" . __('Base Price', 'event_espresso') . "', 1,  0, 0, 0),
911
-							(2, '" . __('Percent Discount', 'event_espresso') . "', 2,  1, 20, 0),
912
-							(3, '" . __('Fixed Discount', 'event_espresso') . "', 2,  0, 30, 0),
913
-							(4, '" . __('Percent Surcharge', 'event_espresso') . "', 3,  1, 40, 0),
914
-							(5, '" . __('Fixed Surcharge', 'event_espresso') . "', 3,  0, 50, 0);";
915
-				$SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_price_types__SQL', $SQL );
916
-				$wpdb->query( $SQL );
910
+							(1, '".__('Base Price', 'event_espresso')."', 1,  0, 0, 0),
911
+							(2, '" . __('Percent Discount', 'event_espresso')."', 2,  1, 20, 0),
912
+							(3, '" . __('Fixed Discount', 'event_espresso')."', 2,  0, 30, 0),
913
+							(4, '" . __('Percent Surcharge', 'event_espresso')."', 3,  1, 40, 0),
914
+							(5, '" . __('Fixed Surcharge', 'event_espresso')."', 3,  0, 50, 0);";
915
+				$SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_price_types__SQL', $SQL);
916
+				$wpdb->query($SQL);
917 917
 			}
918 918
 		}
919 919
 	}
@@ -933,16 +933,16 @@  discard block
 block discarded – undo
933 933
 		global $wpdb;
934 934
 		$price_table = $wpdb->prefix."esp_price";
935 935
 
936
-		if ( $this->_get_table_analysis()->tableExists(  $price_table ) ) {
936
+		if ($this->_get_table_analysis()->tableExists($price_table)) {
937 937
 
938
-			$SQL = 'SELECT COUNT(PRC_ID) FROM ' .$price_table;
939
-			$prices_exist = $wpdb->get_var( $SQL );
938
+			$SQL = 'SELECT COUNT(PRC_ID) FROM '.$price_table;
939
+			$prices_exist = $wpdb->get_var($SQL);
940 940
 
941
-			if ( ! $prices_exist ) {
941
+			if ( ! $prices_exist) {
942 942
 				$SQL = "INSERT INTO $price_table
943 943
 							(PRC_ID, PRT_ID, PRC_amount, PRC_name, PRC_desc,  PRC_is_default, PRC_overrides, PRC_order, PRC_deleted, PRC_parent ) VALUES
944 944
 							(1, 1, '0.00', 'Free Admission', '', 1, NULL, 0, 0, 0);";
945
-				$SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_prices__SQL', $SQL );
945
+				$SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_prices__SQL', $SQL);
946 946
 				$wpdb->query($SQL);
947 947
 			}
948 948
 		}
@@ -959,34 +959,34 @@  discard block
 block discarded – undo
959 959
 
960 960
 		global $wpdb;
961 961
 		$ticket_table = $wpdb->prefix."esp_ticket";
962
-		if ( $this->_get_table_analysis()->tableExists( $ticket_table ) ) {
962
+		if ($this->_get_table_analysis()->tableExists($ticket_table)) {
963 963
 
964
-			$SQL = 'SELECT COUNT(TKT_ID) FROM ' . $ticket_table;
964
+			$SQL = 'SELECT COUNT(TKT_ID) FROM '.$ticket_table;
965 965
 			$tickets_exist = $wpdb->get_var($SQL);
966 966
 
967
-			if ( ! $tickets_exist ) {
967
+			if ( ! $tickets_exist) {
968 968
 				$SQL = "INSERT INTO $ticket_table
969 969
 					( TKT_ID, TTM_ID, TKT_name, TKT_description, TKT_qty, TKT_sold, TKT_uses, TKT_min, TKT_max, TKT_price, TKT_start_date, TKT_end_date, TKT_taxable, TKT_order, TKT_row, TKT_is_default, TKT_parent, TKT_deleted ) VALUES
970
-					( 1, 0, '" . __("Free Ticket", "event_espresso") . "', '', 100, 0, -1, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);";
971
-				$SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL );
970
+					( 1, 0, '".__("Free Ticket", "event_espresso")."', '', 100, 0, -1, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);";
971
+				$SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL);
972 972
 				$wpdb->query($SQL);
973 973
 			}
974 974
 		}
975 975
 		$ticket_price_table = $wpdb->prefix."esp_ticket_price";
976 976
 
977
-		if ( $this->_get_table_analysis()->tableExists( $ticket_price_table ) ) {
977
+		if ($this->_get_table_analysis()->tableExists($ticket_price_table)) {
978 978
 
979
-			$SQL = 'SELECT COUNT(TKP_ID) FROM ' . $ticket_price_table;
979
+			$SQL = 'SELECT COUNT(TKP_ID) FROM '.$ticket_price_table;
980 980
 			$ticket_prc_exist = $wpdb->get_var($SQL);
981 981
 
982
-			if ( ! $ticket_prc_exist ) {
982
+			if ( ! $ticket_prc_exist) {
983 983
 
984 984
 				$SQL = "INSERT INTO $ticket_price_table
985 985
 				( TKP_ID, TKT_ID, PRC_ID ) VALUES
986 986
 				( 1, 1, 1 )
987 987
 				";
988 988
 
989
-				$SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL );
989
+				$SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL);
990 990
 				$wpdb->query($SQL);
991 991
 			}
992 992
 		}
@@ -999,20 +999,20 @@  discard block
 block discarded – undo
999 999
 	 * @param string $country_name
1000 1000
 	 * @return array where keys are columns, values are column values
1001 1001
 	 */
1002
-	public function get_or_create_country($country_name){
1003
-		if( ! $country_name ){
1002
+	public function get_or_create_country($country_name) {
1003
+		if ( ! $country_name) {
1004 1004
 			throw new EE_Error(__("Could not get a country because country name is blank", "event_espresso"));
1005 1005
 		}
1006 1006
 		global $wpdb;
1007 1007
 		$country_table = $wpdb->prefix."esp_country";
1008
-		if(is_int($country_name)){
1008
+		if (is_int($country_name)) {
1009 1009
 			$country_name = $this->get_iso_from_3_1_country_id($country_name);
1010 1010
 		}
1011 1011
 		$country = $wpdb->get_row($wpdb->prepare("SELECT * FROM $country_table WHERE
1012 1012
 			CNT_ISO LIKE %s OR
1013 1013
 			CNT_ISO3 LIKE %s OR
1014
-			CNT_name LIKE %s LIMIT 1",$country_name,$country_name,$country_name),ARRAY_A);
1015
-		if( ! $country ){
1014
+			CNT_name LIKE %s LIMIT 1", $country_name, $country_name, $country_name), ARRAY_A);
1015
+		if ( ! $country) {
1016 1016
 			//insert a new one then
1017 1017
 			$cols_n_values = array(
1018 1018
 				'CNT_ISO'=> $this->_find_available_country_iso(2),
@@ -1032,26 +1032,26 @@  discard block
 block discarded – undo
1032 1032
 				'CNT_active'=>true
1033 1033
 			);
1034 1034
 			$data_types = array(
1035
-				'%s',//CNT_ISO
1036
-				'%s',//CNT_ISO3
1037
-				'%d',//RGN_ID
1038
-				'%s',//CNT_name
1039
-				'%s',//CNT_cur_code
1040
-				'%s',//CNT_cur_single
1041
-				'%s',//CNT_cur_plural
1042
-				'%s',//CNT_cur_sign
1043
-				'%d',//CNT_cur_sign_b4
1044
-				'%d',//CNT_cur_dec_plc
1045
-				'%s',//CNT_cur_dec_mrk
1046
-				'%s',//CNT_cur_thsnds
1047
-				'%s',//CNT_tel_code
1048
-				'%d',//CNT_is_EU
1049
-				'%d',//CNT_active
1035
+				'%s', //CNT_ISO
1036
+				'%s', //CNT_ISO3
1037
+				'%d', //RGN_ID
1038
+				'%s', //CNT_name
1039
+				'%s', //CNT_cur_code
1040
+				'%s', //CNT_cur_single
1041
+				'%s', //CNT_cur_plural
1042
+				'%s', //CNT_cur_sign
1043
+				'%d', //CNT_cur_sign_b4
1044
+				'%d', //CNT_cur_dec_plc
1045
+				'%s', //CNT_cur_dec_mrk
1046
+				'%s', //CNT_cur_thsnds
1047
+				'%s', //CNT_tel_code
1048
+				'%d', //CNT_is_EU
1049
+				'%d', //CNT_active
1050 1050
 			);
1051 1051
 			$success = $wpdb->insert($country_table,
1052 1052
 					$cols_n_values,
1053 1053
 					$data_types);
1054
-			if( ! $success){
1054
+			if ( ! $success) {
1055 1055
 				throw new EE_Error($this->_create_error_message_for_db_insertion('N/A', array('country_id'=>$country_name), $country_table, $cols_n_values, $data_types));
1056 1056
 			}
1057 1057
 			$country = $cols_n_values;
@@ -1063,13 +1063,13 @@  discard block
 block discarded – undo
1063 1063
 	 * @global type $wpdb
1064 1064
 	 * @return string
1065 1065
 	 */
1066
-	private function _find_available_country_iso($num_letters = 2){
1066
+	private function _find_available_country_iso($num_letters = 2) {
1067 1067
 		global $wpdb;
1068 1068
 		$country_table = $wpdb->prefix."esp_country";
1069
-		do{
1069
+		do {
1070 1070
 			$current_iso = strtoupper(wp_generate_password($num_letters, false));
1071
-			$country_with_that_iso = $wpdb->get_var($wpdb->prepare("SELECT count(CNT_ISO) FROM ".$country_table." WHERE CNT_ISO=%s",$current_iso));
1072
-		}while(intval($country_with_that_iso));
1071
+			$country_with_that_iso = $wpdb->get_var($wpdb->prepare("SELECT count(CNT_ISO) FROM ".$country_table." WHERE CNT_ISO=%s", $current_iso));
1072
+		}while (intval($country_with_that_iso));
1073 1073
 		return $current_iso;
1074 1074
 	}
1075 1075
 
@@ -1080,14 +1080,14 @@  discard block
 block discarded – undo
1080 1080
 	 * @param string $state_name
1081 1081
 	 * @return array where keys are columns, values are column values
1082 1082
 	 */
1083
-	public function get_or_create_state($state_name,$country_name = ''){
1084
-		if( ! $state_name ){
1083
+	public function get_or_create_state($state_name, $country_name = '') {
1084
+		if ( ! $state_name) {
1085 1085
 			throw new EE_Error(__("Could not get-or-create state because no state name was provided", "event_espresso"));
1086 1086
 		}
1087
-		try{
1087
+		try {
1088 1088
 			$country = $this->get_or_create_country($country_name);
1089 1089
 			$country_iso = $country['CNT_ISO'];
1090
-		}catch(EE_Error $e){
1090
+		} catch (EE_Error $e) {
1091 1091
 			$country_iso = $this->get_default_country_iso();
1092 1092
 		}
1093 1093
 		global $wpdb;
@@ -1095,24 +1095,24 @@  discard block
 block discarded – undo
1095 1095
 		$state = $wpdb->get_row($wpdb->prepare("SELECT * FROM $state_table WHERE
1096 1096
 			(STA_abbrev LIKE %s OR
1097 1097
 			STA_name LIKE %s) AND
1098
-			CNT_ISO LIKE %s LIMIT 1",$state_name,$state_name,$country_iso),ARRAY_A);
1099
-		if ( ! $state){
1098
+			CNT_ISO LIKE %s LIMIT 1", $state_name, $state_name, $country_iso), ARRAY_A);
1099
+		if ( ! $state) {
1100 1100
 			//insert a new one then
1101 1101
 			$cols_n_values = array(
1102 1102
 				'CNT_ISO'=>$country_iso,
1103
-				'STA_abbrev'=>substr($state_name,0,6),
1103
+				'STA_abbrev'=>substr($state_name, 0, 6),
1104 1104
 				'STA_name'=>$state_name,
1105 1105
 				'STA_active'=>true
1106 1106
 			);
1107 1107
 			$data_types = array(
1108
-				'%s',//CNT_ISO
1109
-				'%s',//STA_abbrev
1110
-				'%s',//STA_name
1111
-				'%d',//STA_active
1108
+				'%s', //CNT_ISO
1109
+				'%s', //STA_abbrev
1110
+				'%s', //STA_name
1111
+				'%d', //STA_active
1112 1112
 			);
1113
-			$success = $wpdb->insert($state_table,$cols_n_values,$data_types);
1114
-			if ( ! $success ){
1115
-				throw new EE_Error($this->_create_error_message_for_db_insertion('N/A', array('state'=>$state_name,'country_id'=>$country_name), $state_table, $cols_n_values, $data_types));
1113
+			$success = $wpdb->insert($state_table, $cols_n_values, $data_types);
1114
+			if ( ! $success) {
1115
+				throw new EE_Error($this->_create_error_message_for_db_insertion('N/A', array('state'=>$state_name, 'country_id'=>$country_name), $state_table, $cols_n_values, $data_types));
1116 1116
 			}
1117 1117
 			$state = $cols_n_values;
1118 1118
 			$state['STA_ID'] = $wpdb->insert_id;
@@ -1125,21 +1125,21 @@  discard block
 block discarded – undo
1125 1125
 	 * @param type $timeString
1126 1126
 	 * @return string in the php DATETIME format: "G:i" (24-hour format hour with leading zeros, a colon, and minutes with leading zeros)
1127 1127
 	 */
1128
-	public function convertTimeFromAMPM($timeString){
1128
+	public function convertTimeFromAMPM($timeString) {
1129 1129
 		$matches = array();
1130
-		preg_match("~(\\d*):(\\d*)~",$timeString,$matches);
1131
-		if( ! $matches || count($matches)<3){
1130
+		preg_match("~(\\d*):(\\d*)~", $timeString, $matches);
1131
+		if ( ! $matches || count($matches) < 3) {
1132 1132
 			$hour = '00';
1133 1133
 			$minutes = '00';
1134
-		}else{
1134
+		} else {
1135 1135
 			$hour = intval($matches[1]);
1136 1136
 			$minutes = $matches[2];
1137 1137
 		}
1138
-		if(strpos($timeString, 'PM') || strpos($timeString, 'pm')){
1138
+		if (strpos($timeString, 'PM') || strpos($timeString, 'pm')) {
1139 1139
 			$hour = intval($hour) + 12;
1140 1140
 		}
1141
-		$hour = str_pad( "$hour", 2, '0',STR_PAD_LEFT);
1142
-		$minutes = str_pad( "$minutes", 2, '0',STR_PAD_LEFT);
1141
+		$hour = str_pad("$hour", 2, '0', STR_PAD_LEFT);
1142
+		$minutes = str_pad("$minutes", 2, '0', STR_PAD_LEFT);
1143 1143
 		return "$hour:$minutes";
1144 1144
 	}
1145 1145
 
@@ -1148,7 +1148,7 @@  discard block
 block discarded – undo
1148 1148
 	 * @param int $country_id
1149 1149
 	 * @return string the country's ISO3 code
1150 1150
 	 */
1151
-	public function get_iso_from_3_1_country_id($country_id){
1151
+	public function get_iso_from_3_1_country_id($country_id) {
1152 1152
 		$old_countries = array(
1153 1153
 			array(64, 'United States', 'US', 'USA', 1),
1154 1154
 			array(15, 'Australia', 'AU', 'AUS', 1),
@@ -1374,9 +1374,9 @@  discard block
 block discarded – undo
1374 1374
 			array(226, 'Zimbabwe', 'ZW', 'ZWE', 1));
1375 1375
 
1376 1376
 		$country_iso = 'US';
1377
-		foreach($old_countries as $country_array){
1377
+		foreach ($old_countries as $country_array) {
1378 1378
 			//note: index 0 is the 3.1 country ID
1379
-			if($country_array[0] == $country_id){
1379
+			if ($country_array[0] == $country_id) {
1380 1380
 				//note: index 2 is the ISO
1381 1381
 				$country_iso = $country_array[2];
1382 1382
 				break;
@@ -1389,8 +1389,8 @@  discard block
 block discarded – undo
1389 1389
 	 * Gets the ISO3 for the
1390 1390
 	 * @return string
1391 1391
 	 */
1392
-	public function get_default_country_iso(){
1393
-		$old_org_options= get_option('events_organization_settings');
1392
+	public function get_default_country_iso() {
1393
+		$old_org_options = get_option('events_organization_settings');
1394 1394
 		$iso = $this->get_iso_from_3_1_country_id($old_org_options['organization_country']);
1395 1395
 		return $iso;
1396 1396
 	}
@@ -1402,13 +1402,13 @@  discard block
 block discarded – undo
1402 1402
 	 * the event's DEFAULT payment status, or the attendee's payment status) required pre-approval.
1403 1403
 	 * @return string STS_ID for use in 4.1
1404 1404
 	 */
1405
-	public function convert_3_1_payment_status_to_4_1_STS_ID($payment_status, $this_thing_required_pre_approval = false){
1405
+	public function convert_3_1_payment_status_to_4_1_STS_ID($payment_status, $this_thing_required_pre_approval = false) {
1406 1406
 
1407 1407
 		//EE team can read the related discussion: https://app.asana.com/0/2400967562914/9418495544455
1408
-		if($this_thing_required_pre_approval){
1408
+		if ($this_thing_required_pre_approval) {
1409 1409
 				return 'RNA';
1410
-		}else{
1411
-				$mapping = $default_reg_stati_conversions=array(
1410
+		} else {
1411
+				$mapping = $default_reg_stati_conversions = array(
1412 1412
 			'Completed'=>'RAP',
1413 1413
 			''=>'RPP',
1414 1414
 			'Incomplete'=>'RPP',
@@ -1438,22 +1438,22 @@  discard block
 block discarded – undo
1438 1438
 	 * @param  EE_Data_Migration_Script_Stage $migration_stage the stage which called this, where errors should be added
1439 1439
 	 * @return boolean whether or not we had to do the big job of creating an image attachment
1440 1440
 	 */
1441
-	public function convert_image_url_to_attachment_and_attach_to_post($guid,$new_cpt_id,  EE_Data_Migration_Script_Stage $migration_stage){
1441
+	public function convert_image_url_to_attachment_and_attach_to_post($guid, $new_cpt_id, EE_Data_Migration_Script_Stage $migration_stage) {
1442 1442
 		$created_attachment_post = false;
1443 1443
 		$guid = $this->_get_original_guid($guid);
1444
-		if($guid){
1444
+		if ($guid) {
1445 1445
 			//check for an existing attachment post with this guid
1446 1446
 			$attachment_post_id = $this->_get_image_attachment_id_by_GUID($guid);
1447
-			if( ! $attachment_post_id){
1447
+			if ( ! $attachment_post_id) {
1448 1448
 				//post thumbnail with that GUID doesn't exist, we should create one
1449 1449
 				$attachment_post_id = $this->_create_image_attachment_from_GUID($guid, $migration_stage);
1450 1450
 				$created_attachment_post = true;
1451 1451
 			}
1452 1452
 			//double-check we actually have an attachment post
1453
-			if( $attachment_post_id){
1454
-				update_post_meta($new_cpt_id,'_thumbnail_id',$attachment_post_id);
1455
-			}else{
1456
-				$migration_stage->add_error(sprintf(__("Could not update event image %s for CPT with ID %d, but attachments post ID is %d", "event_espresso"),$guid,$new_cpt_id,$attachment_post_id));
1453
+			if ($attachment_post_id) {
1454
+				update_post_meta($new_cpt_id, '_thumbnail_id', $attachment_post_id);
1455
+			} else {
1456
+				$migration_stage->add_error(sprintf(__("Could not update event image %s for CPT with ID %d, but attachments post ID is %d", "event_espresso"), $guid, $new_cpt_id, $attachment_post_id));
1457 1457
 			}
1458 1458
 		}
1459 1459
 		return $created_attachment_post;
@@ -1467,13 +1467,13 @@  discard block
 block discarded – undo
1467 1467
 	 * @param string $guid_in_old_event
1468 1468
 	 * @return string either the original guid, or $guid_in_old_event if we couldn't figure out what the original was
1469 1469
 	 */
1470
-	private function _get_original_guid($guid_in_old_event){
1471
-		$original_guid = preg_replace('~-\d*x\d*\.~','.',$guid_in_old_event,1);
1470
+	private function _get_original_guid($guid_in_old_event) {
1471
+		$original_guid = preg_replace('~-\d*x\d*\.~', '.', $guid_in_old_event, 1);
1472 1472
 		//do a head request to verify the file exists
1473 1473
 		$head_response = wp_remote_head($original_guid);
1474
-		if( ! $head_response instanceof WP_Error && $head_response['response']['message'] == 'OK'){
1474
+		if ( ! $head_response instanceof WP_Error && $head_response['response']['message'] == 'OK') {
1475 1475
 			return $original_guid;
1476
-		}else{
1476
+		} else {
1477 1477
 			return $guid_in_old_event;
1478 1478
 		}
1479 1479
 	}
@@ -1485,32 +1485,32 @@  discard block
 block discarded – undo
1485 1485
 	 * @param EE_Data_Migration_Script_Stage $migration_stage
1486 1486
 	 * @return int
1487 1487
 	 */
1488
-	private function _create_image_attachment_from_GUID($guid, EE_Data_Migration_Script_Stage $migration_stage){
1489
-		if ( ! $guid){
1488
+	private function _create_image_attachment_from_GUID($guid, EE_Data_Migration_Script_Stage $migration_stage) {
1489
+		if ( ! $guid) {
1490 1490
 			$migration_stage->add_error(sprintf(__("Cannot create image attachment for a blank GUID!", "event_espresso")));
1491 1491
 			return 0;
1492 1492
 		}
1493
-		$wp_filetype = wp_check_filetype(basename($guid), null );
1493
+		$wp_filetype = wp_check_filetype(basename($guid), null);
1494 1494
 		$wp_upload_dir = wp_upload_dir();
1495 1495
 		//if the file is located remotely, download it to our uploads DIR, because wp_genereate_attachmnet_metadata needs the file to be local
1496
-		if(strpos($guid,$wp_upload_dir['url']) === FALSE){
1496
+		if (strpos($guid, $wp_upload_dir['url']) === FALSE) {
1497 1497
 			//image is located remotely. download it and place it in the uploads directory
1498
-			if( ! is_readable($guid)){
1499
-				$migration_stage->add_error(sprintf(__("Could not create image attachment from non-existent file: %s", "event_espresso"),$guid));
1498
+			if ( ! is_readable($guid)) {
1499
+				$migration_stage->add_error(sprintf(__("Could not create image attachment from non-existent file: %s", "event_espresso"), $guid));
1500 1500
 				return 0;
1501 1501
 			}
1502
-			$contents= file_get_contents($guid);
1503
-			if($contents === FALSE){
1504
-				$migration_stage->add_error(sprintf(__("Could not read image at %s, and therefore couldnt create an attachment post for it.", "event_espresso"),$guid));
1502
+			$contents = file_get_contents($guid);
1503
+			if ($contents === FALSE) {
1504
+				$migration_stage->add_error(sprintf(__("Could not read image at %s, and therefore couldnt create an attachment post for it.", "event_espresso"), $guid));
1505 1505
 				return false;
1506 1506
 			}
1507
-			$local_filepath  = $wp_upload_dir['path'].DS.basename($guid);
1507
+			$local_filepath = $wp_upload_dir['path'].DS.basename($guid);
1508 1508
 			$savefile = fopen($local_filepath, 'w');
1509 1509
 			fwrite($savefile, $contents);
1510 1510
 			fclose($savefile);
1511
-			$guid = str_replace($wp_upload_dir['path'],$wp_upload_dir['url'],$local_filepath);
1512
-		}else{
1513
-			$local_filepath = str_replace($wp_upload_dir['url'],$wp_upload_dir['path'],$guid);
1511
+			$guid = str_replace($wp_upload_dir['path'], $wp_upload_dir['url'], $local_filepath);
1512
+		} else {
1513
+			$local_filepath = str_replace($wp_upload_dir['url'], $wp_upload_dir['path'], $guid);
1514 1514
 		}
1515 1515
 
1516 1516
 		$attachment = array(
@@ -1520,24 +1520,24 @@  discard block
 block discarded – undo
1520 1520
 		   'post_content' => '',
1521 1521
 		   'post_status' => 'inherit'
1522 1522
 		);
1523
-		$attach_id = wp_insert_attachment( $attachment, $guid );
1524
-		if( ! $attach_id ){
1525
-			$migration_stage->add_error(sprintf(__("Could not create image attachment post from image '%s'. Attachment data was %s.", "event_espresso"),$guid,$this->_json_encode($attachment)));
1523
+		$attach_id = wp_insert_attachment($attachment, $guid);
1524
+		if ( ! $attach_id) {
1525
+			$migration_stage->add_error(sprintf(__("Could not create image attachment post from image '%s'. Attachment data was %s.", "event_espresso"), $guid, $this->_json_encode($attachment)));
1526 1526
 			return $attach_id;
1527 1527
 		}
1528 1528
 
1529 1529
 		// you must first include the image.php file
1530 1530
 		// for the function wp_generate_attachment_metadata() to work
1531
-		require_once(ABSPATH . 'wp-admin/includes/image.php');
1531
+		require_once(ABSPATH.'wp-admin/includes/image.php');
1532 1532
 
1533
-		$attach_data = wp_generate_attachment_metadata( $attach_id, $local_filepath );
1534
-		if( ! $attach_data){
1535
-			$migration_stage->add_error(sprintf(__("Coudl not genereate attachment metadata for attachment post %d with filepath %s and GUID %s. Please check the file was downloaded properly.", "event_espresso"),$attach_id,$local_filepath,$guid));
1533
+		$attach_data = wp_generate_attachment_metadata($attach_id, $local_filepath);
1534
+		if ( ! $attach_data) {
1535
+			$migration_stage->add_error(sprintf(__("Coudl not genereate attachment metadata for attachment post %d with filepath %s and GUID %s. Please check the file was downloaded properly.", "event_espresso"), $attach_id, $local_filepath, $guid));
1536 1536
 			return $attach_id;
1537 1537
 		}
1538
-		$metadata_save_result = wp_update_attachment_metadata( $attach_id, $attach_data );
1539
-		if( ! $metadata_save_result ){
1540
-			$migration_stage->add_error(sprintf(__("Could not update attachment metadata for attachment %d with data %s", "event_espresso"),$attach_id,$this->_json_encode($attach_data)));
1538
+		$metadata_save_result = wp_update_attachment_metadata($attach_id, $attach_data);
1539
+		if ( ! $metadata_save_result) {
1540
+			$migration_stage->add_error(sprintf(__("Could not update attachment metadata for attachment %d with data %s", "event_espresso"), $attach_id, $this->_json_encode($attach_data)));
1541 1541
 		}
1542 1542
 		return $attach_id;
1543 1543
 	}
@@ -1549,9 +1549,9 @@  discard block
 block discarded – undo
1549 1549
 	 * @param string $guid
1550 1550
 	 * @return int
1551 1551
 	 */
1552
-	private function _get_image_attachment_id_by_GUID($guid){
1552
+	private function _get_image_attachment_id_by_GUID($guid) {
1553 1553
 		global $wpdb;
1554
-		$attachment_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid=%s LIMIT 1",$guid));
1554
+		$attachment_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid=%s LIMIT 1", $guid));
1555 1555
 		return $attachment_id;
1556 1556
 	}
1557 1557
 	/**
@@ -1563,20 +1563,20 @@  discard block
 block discarded – undo
1563 1563
 	 * @param string $timezone
1564 1564
 	 * @return string
1565 1565
 	 */
1566
-	public function convert_date_string_to_utc(EE_Data_Migration_Script_Stage $stage, $row_of_data, $DATETIME_string,$timezone = null){
1566
+	public function convert_date_string_to_utc(EE_Data_Migration_Script_Stage $stage, $row_of_data, $DATETIME_string, $timezone = null) {
1567 1567
 		$original_tz = $timezone;
1568
-		if( ! $timezone){
1568
+		if ( ! $timezone) {
1569 1569
 			$timezone = $this->_get_wp_timezone();
1570 1570
 		}
1571
-		if( ! $timezone){
1572
-			$stage->add_error(sprintf(__("Could not find timezone given %s for %s", "event_espresso"),$original_tz,$row_of_data));
1571
+		if ( ! $timezone) {
1572
+			$stage->add_error(sprintf(__("Could not find timezone given %s for %s", "event_espresso"), $original_tz, $row_of_data));
1573 1573
 			$timezone = 'UTC';
1574 1574
 		}
1575
-		try{
1576
-			$date_obj = new DateTime( $DATETIME_string, new DateTimeZone( $timezone ) );
1575
+		try {
1576
+			$date_obj = new DateTime($DATETIME_string, new DateTimeZone($timezone));
1577 1577
 			$date_obj->setTimezone(new DateTimeZone('UTC'));
1578
-		}catch(Exception $e){
1579
-			$stage->add_error(sprintf(__("Could not convert time string '%s' using timezone '%s' into a proper DATETIME. Using current time instead.", "event_espresso"),$DATETIME_string,$timezone));
1578
+		} catch (Exception $e) {
1579
+			$stage->add_error(sprintf(__("Could not convert time string '%s' using timezone '%s' into a proper DATETIME. Using current time instead.", "event_espresso"), $DATETIME_string, $timezone));
1580 1580
 			$date_obj = new DateTime();
1581 1581
 		}
1582 1582
 
@@ -1587,14 +1587,14 @@  discard block
 block discarded – undo
1587 1587
 	 * Gets the DEFAULT timezone string from wordpress (even if they set a gmt offset)
1588 1588
 	 * @return string
1589 1589
 	 */
1590
-	private function _get_wp_timezone(){
1591
-		$timezone = empty( $timezone ) ? get_option('timezone_string') : $timezone;
1590
+	private function _get_wp_timezone() {
1591
+		$timezone = empty($timezone) ? get_option('timezone_string') : $timezone;
1592 1592
 
1593 1593
 		//if timezone is STILL empty then let's get the GMT offset and then set the timezone_string using our converter
1594
-		if ( empty( $timezone ) ) {
1594
+		if (empty($timezone)) {
1595 1595
 			//let's get a the WordPress UTC offset
1596 1596
 			$offset = get_option('gmt_offset');
1597
-			$timezone = $this->timezone_convert_to_string_from_offset( $offset );
1597
+			$timezone = $this->timezone_convert_to_string_from_offset($offset);
1598 1598
 		}
1599 1599
 		return $timezone;
1600 1600
 	}
@@ -1603,11 +1603,11 @@  discard block
 block discarded – undo
1603 1603
 	 * @param int $offset
1604 1604
 	 * @return boolean
1605 1605
 	 */
1606
-	private function timezone_convert_to_string_from_offset($offset){
1606
+	private function timezone_convert_to_string_from_offset($offset) {
1607 1607
 		//shamelessly taken from bottom comment at http://ca1.php.net/manual/en/function.timezone-name-from-abbr.php because timezone_name_from_abbr() did NOT work as expected - its not reliable
1608 1608
 		$offset *= 3600; // convert hour offset to seconds
1609 1609
         $abbrarray = timezone_abbreviations_list();
1610
-        foreach ($abbrarray as $abbr){
1610
+        foreach ($abbrarray as $abbr) {
1611 1611
                 foreach ($abbr as $city)
1612 1612
                 {
1613 1613
                         if ($city['offset'] == $offset)
@@ -1621,32 +1621,32 @@  discard block
 block discarded – undo
1621 1621
         return FALSE;
1622 1622
 	}
1623 1623
 
1624
-	public function migration_page_hooks(){
1625
-		add_filter('FHEE__ee_migration_page__header',array($this,'_migrate_page_hook_simplify_version_strings'),10,3);
1626
-		add_filter('FHEE__ee_migration_page__p_after_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2);
1627
-		add_filter('FHEE__ee_migration_page__option_1_main',array($this,'_migrate_page_hook_simplify_version_strings'),10,3);
1628
-		add_filter('FHEE__ee_migration_page__option_1_button_text',array($this,'_migrate_page_hook_simplify_version_strings'),10,3);
1629
-		add_action('AHEE__ee_migration_page__option_1_extra_details',array($this,'_migration_page_hook_option_1_extra_details'),10,3);
1630
-		add_filter('FHEE__ee_migration_page__option_2_main',array($this,'_migrate_page_hook_simplify_version_strings'),10,4);
1631
-		add_filter('FHEE__ee_migration_page__option_2_button_text',array($this,'_migration_page_hook_simplify_next_db_state'),10,2);
1632
-		add_filter('FHEE__ee_migration_page__option_2_details',array($this,'_migration_page_hook_simplify_next_db_state'),10,2);
1633
-		add_action('AHEE__ee_migration_page__after_migration_options_table',array($this,'_migration_page_hook_after_migration_options_table'));
1634
-		add_filter('FHEE__ee_migration_page__done_migration_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2);
1635
-		add_filter('FHEE__ee_migration_page__p_after_done_migration_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2);
1624
+	public function migration_page_hooks() {
1625
+		add_filter('FHEE__ee_migration_page__header', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3);
1626
+		add_filter('FHEE__ee_migration_page__p_after_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2);
1627
+		add_filter('FHEE__ee_migration_page__option_1_main', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3);
1628
+		add_filter('FHEE__ee_migration_page__option_1_button_text', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3);
1629
+		add_action('AHEE__ee_migration_page__option_1_extra_details', array($this, '_migration_page_hook_option_1_extra_details'), 10, 3);
1630
+		add_filter('FHEE__ee_migration_page__option_2_main', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 4);
1631
+		add_filter('FHEE__ee_migration_page__option_2_button_text', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2);
1632
+		add_filter('FHEE__ee_migration_page__option_2_details', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2);
1633
+		add_action('AHEE__ee_migration_page__after_migration_options_table', array($this, '_migration_page_hook_after_migration_options_table'));
1634
+		add_filter('FHEE__ee_migration_page__done_migration_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2);
1635
+		add_filter('FHEE__ee_migration_page__p_after_done_migration_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2);
1636 1636
 	}
1637 1637
 
1638
-	public function _migrate_page_hook_simplify_version_strings($old_content,$current_db_state,$next_db_state,$ultimate_db_state = NULL){
1639
-		return str_replace(array($current_db_state,$next_db_state,$ultimate_db_state),array(__('EE3','event_espresso'),__('EE4','event_espresso'),  __("EE4", 'event_espresso')),$old_content);
1638
+	public function _migrate_page_hook_simplify_version_strings($old_content, $current_db_state, $next_db_state, $ultimate_db_state = NULL) {
1639
+		return str_replace(array($current_db_state, $next_db_state, $ultimate_db_state), array(__('EE3', 'event_espresso'), __('EE4', 'event_espresso'), __("EE4", 'event_espresso')), $old_content);
1640 1640
 	}
1641
-	public function _migration_page_hook_simplify_next_db_state($old_content,$next_db_state){
1642
-		return str_replace($next_db_state,  __("EE4", 'event_espresso'),$old_content);
1641
+	public function _migration_page_hook_simplify_next_db_state($old_content, $next_db_state) {
1642
+		return str_replace($next_db_state, __("EE4", 'event_espresso'), $old_content);
1643 1643
 	}
1644
-	public function _migration_page_hook_option_1_extra_details(){
1645
-		?><p><?php	printf(__("Note: many of your EE3 shortcodes will be changed to EE4 shortcodes during this migration (among many other things). Should you revert to EE3, then you should restore to your backup or manually change the EE4 shortcodes back to their EE3 equivalents", "event_espresso"));?></p><?php
1644
+	public function _migration_page_hook_option_1_extra_details() {
1645
+		?><p><?php	printf(__("Note: many of your EE3 shortcodes will be changed to EE4 shortcodes during this migration (among many other things). Should you revert to EE3, then you should restore to your backup or manually change the EE4 shortcodes back to their EE3 equivalents", "event_espresso")); ?></p><?php
1646 1646
 	}
1647
-	public function _migration_page_hook_after_migration_options_table(){
1647
+	public function _migration_page_hook_after_migration_options_table() {
1648 1648
 		?><p class="ee-attention">
1649
-				<strong><span class="reminder-spn"><?php _e("Important note to those using Event Espresso 3 addons: ", "event_espresso");?></span></strong><br/><?php _e("Unless an addon's description on our website explicitly states that it is compatible with EE4, you should consider it incompatible and know that it WILL NOT WORK correctly with this new version of Event Espresso 4 (EE4). As well, any data for incompatible addons will NOT BE MIGRATED until an updated EE4 compatible version of the addon is available. If you want, or need to keep using your EE3 addons, you should simply continue using EE3 until EE4 compatible versions of your addons become available. To continue using EE3 for now, just deactivate EE4 and reactivate EE3.", "event_espresso");	?>
1649
+				<strong><span class="reminder-spn"><?php _e("Important note to those using Event Espresso 3 addons: ", "event_espresso"); ?></span></strong><br/><?php _e("Unless an addon's description on our website explicitly states that it is compatible with EE4, you should consider it incompatible and know that it WILL NOT WORK correctly with this new version of Event Espresso 4 (EE4). As well, any data for incompatible addons will NOT BE MIGRATED until an updated EE4 compatible version of the addon is available. If you want, or need to keep using your EE3 addons, you should simply continue using EE3 until EE4 compatible versions of your addons become available. To continue using EE3 for now, just deactivate EE4 and reactivate EE3.", "event_espresso"); ?>
1650 1650
 			</p><?php
1651 1651
 	}
1652 1652
 }
Please login to merge, or discard this patch.
core/db_classes/EE_CSV.class.php 4 patches
Doc Comments   +6 added lines, -8 removed lines patch added patch discarded remove patch
@@ -287,7 +287,7 @@  discard block
 block discarded – undo
287 287
 	 * Sends HTTP headers to indicate that the browser should download a file,
288 288
 	 * and starts writing the file to PHP's output. Returns the file handle so other functions can
289 289
 	 * also write to it
290
-	 * @param string $new_filename the name of the file that the user will download
290
+	 * @param string|false $filename the name of the file that the user will download
291 291
 	 * @return resource, like the results of fopen(), which can be used for fwrite, fputcsv2, etc.
292 292
 	 */
293 293
 	public function begin_sending_csv($filename){
@@ -343,9 +343,7 @@  discard block
 block discarded – undo
343 343
 	/**
344 344
 	 * Writes $data to the csv file open in $filehandle. uses the array indices of $data for column headers
345 345
 	 * @param array $data 2D array, first numerically-indexed, and next-level-down preferably indexed by string
346
-	 * @param boolean $add_csv_column_names whether or not we should add the keys in the bottom-most array as a row for headers in the CSV.
347
-	 * Eg, if $data looked like array(0=>array('EVT_ID'=>1,'EVT_name'=>'monkey'...), 1=>array(...),...))
348
-	 * then the first row we'd write to the CSV would be "EVT_ID,EVT_name,..."
346
+	 * @param resource $filehandle
349 347
 	 * @return boolean if we successfully wrote to the CSV or not. If there's no $data, we consider that a success (because we wrote everything there was...nothing)
350 348
 	 */
351 349
 	public function write_data_array_to_csv($filehandle, $data){
@@ -427,7 +425,7 @@  discard block
 block discarded – undo
427 425
 	 * @param array $model_data_array is assumed to be a 3d array: 1st layer has keys of model names (eg 'Event'),
428 426
 	 * next layer is numerically indexed to represent each model object (eg, each individual event), and the last layer
429 427
 	 * has all the attributes o fthat model object (eg, the event's id, name, etc)
430
-	 * @return boolean success
428
+	 * @return boolean|null success
431 429
 	 */
432 430
 	public function write_model_data_to_csv($filehandle,$model_data_array){
433 431
 		$this->write_metadata_to_csv($filehandle);
@@ -456,8 +454,8 @@  discard block
 block discarded – undo
456 454
 	 * Writes the CSV file to the output buffer, with rows corresponding to $model_data_array,
457 455
 	 * and dies (in order to avoid other plugins from messing up the csv output)
458 456
 	 * @param string $filename the filename you want to give the file
459
-	 * @param array $model_data_array 3d array, as described in EE_CSV::write_model_data_to_csv()
460
-	 * @return bool | void writes CSV file to output and dies
457
+	 * @param boolean $model_data_array 3d array, as described in EE_CSV::write_model_data_to_csv()
458
+	 * @return boolean|null | void writes CSV file to output and dies
461 459
 	 */
462 460
 	public function export_multiple_model_data_to_csv($filename,$model_data_array){
463 461
 		$filehandle = $this->begin_sending_csv($filename);
@@ -469,7 +467,7 @@  discard block
 block discarded – undo
469 467
 	 *		  @access public
470 468
 	 *			@param array $data - the array of data to be converted to csv and exported
471 469
 	 *			@param string $filename - name for newly created csv file
472
-	 *			@return TRUE on success, FALSE on fail
470
+	 *			@return false|null on success, FALSE on fail
473 471
 	 */
474 472
 	public function export_array_to_csv( $data = FALSE, $filename = FALSE  ) {
475 473
 
Please login to merge, or discard this patch.
Braces   +12 added lines, -9 removed lines patch added patch discarded remove patch
@@ -1,4 +1,6 @@  discard block
 block discarded – undo
1
-<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed');
1
+<?php if (!defined('EVENT_ESPRESSO_VERSION')) {
2
+	exit('No direct script access allowed');
3
+}
2 4
 /**
3 5
  * CSV Import Export class
4 6
  *
@@ -105,8 +107,9 @@  discard block
 block discarded – undo
105 107
 			  $fc = $fc . $c;
106 108
 			}
107 109
 		}
108
-		if ((ord(substr($fc,0,1)) == 255) && (ord(substr($fc,1,1)) == 254))
109
-		$fc = substr($fc,2);
110
+		if ((ord(substr($fc,0,1)) == 255) && (ord(substr($fc,1,1)) == 254)) {
111
+				$fc = substr($fc,2);
112
+		}
110 113
 		return ($fc);
111 114
 }
112 115
 
@@ -144,7 +147,7 @@  discard block
 block discarded – undo
144 147
 				while(($data = fgetcsv($file_handle, 0, ',', '"' )) !== FALSE){
145 148
 					$csvarray[]= $data;
146 149
 				}
147
-			}else{
150
+			} else{
148 151
 				// loop through each row of the file
149 152
 				while (( $data = fgetcsv( $file_handle, 0, ',', '"', '\\' )) !== FALSE ) {
150 153
 					$csvarray[]=$data;
@@ -153,7 +156,7 @@  discard block
 block discarded – undo
153 156
 			# Close the File.
154 157
 			fclose($file_handle);
155 158
 			return $csvarray;
156
-		}else{
159
+		} else{
157 160
 			EE_Error::add_error( sprintf(__("An error occurred - the file: %s could not opened.", "event_espresso"),$path_to_file), __FILE__, __FUNCTION__, __LINE__ );
158 161
 			return false;
159 162
 		}
@@ -234,7 +237,7 @@  discard block
 block discarded – undo
234 237
 						$matches = array();
235 238
 						if($model_name == EE_CSV::metadata_header){
236 239
 							$headers[$i] = $column_name;
237
-						}else{
240
+						} else{
238 241
 							//now get the db table name from it (the part between square brackets)
239 242
 							$success = preg_match('~(.*)\[(.*)\]~', $column_name,$matches);
240 243
 							if (!$success){
@@ -244,7 +247,7 @@  discard block
 block discarded – undo
244 247
 							$headers[$i] = $matches[2];
245 248
 						}
246 249
 
247
-					}else{
250
+					} else{
248 251
 						// no column names means our final array will just use counters for keys
249 252
 						$model_entry[$headers[$i]] = $data[$i];
250 253
 						$headers[$i] = $i;
@@ -371,7 +374,7 @@  discard block
 block discarded – undo
371 374
 				echo $this->fputcsv2($filehandle, $data_row);
372 375
 			}
373 376
 			return true;
374
-		}else{
377
+		} else{
375 378
 			//no data TO write... so we can assume that's a success
376 379
 			return true;
377 380
 		}
@@ -438,7 +441,7 @@  discard block
 block discarded – undo
438 441
 
439 442
 			if( ! empty($model_instance_arrays) ){
440 443
 				$this->write_data_array_to_csv($filehandle, $model_instance_arrays);
441
-			}else{
444
+			} else{
442 445
 //				echo "no data to write... so just write the headers";
443 446
 				//so there's actually NO model objects for that model.
444 447
 				//probably still want to show the columns
Please login to merge, or discard this patch.
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -315,7 +315,7 @@
 block discarded – undo
315 315
 //		header("Content-Type: application/download");
316 316
 		header('Content-disposition: attachment; filename='.$filename);
317 317
 		header("Content-Type: text/csv; charset=utf-8");
318
-                do_action( 'AHEE__EE_CSV__begin_sending_csv__headers' );
318
+				do_action( 'AHEE__EE_CSV__begin_sending_csv__headers' );
319 319
 		echo apply_filters('FHEE__EE_CSV__begin_sending_csv__start_writing', "\xEF\xBB\xBF" ); // makes excel open it as UTF-8. UTF-8 BOM, see http://stackoverflow.com/a/4440143/2773835
320 320
 		$fh = fopen('php://output', 'w');
321 321
 		return $fh;
Please login to merge, or discard this patch.
Spacing   +114 added lines, -114 removed lines patch added patch discarded remove patch
@@ -1,4 +1,4 @@  discard block
 block discarded – undo
1
-<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed');
1
+<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed');
2 2
 /**
3 3
  * CSV Import Export class
4 4
  *
@@ -45,31 +45,31 @@  discard block
 block discarded – undo
45 45
 		global $wpdb;
46 46
 
47 47
 		$this->_primary_keys = array(
48
-				$wpdb->prefix . 'esp_answer' => array( 'ANS_ID' ),
49
-				$wpdb->prefix . 'esp_attendee' => array( 'ATT_ID' ),
50
-				$wpdb->prefix . 'esp_datetime'	=> array( 'DTT_ID' ),
51
-				$wpdb->prefix . 'esp_event_question_group'	=> array( 'EQG_ID' ),
52
-				$wpdb->prefix . 'esp_message_template'	=> array( 'MTP_ID' ),
53
-				$wpdb->prefix . 'esp_payment'	=> array( 'PAY_ID' ),
54
-				$wpdb->prefix . 'esp_price'	=> array( 'PRC_ID' ),
55
-				$wpdb->prefix . 'esp_price_type'	=> array( 'PRT_ID' ),
56
-				$wpdb->prefix . 'esp_question'	=> array( 'QST_ID' ),
57
-				$wpdb->prefix . 'esp_question_group'	=> array( 'QSG_ID' ),
58
-				$wpdb->prefix . 'esp_question_group_question'	=> array( 'QGQ_ID' ),
59
-				$wpdb->prefix . 'esp_question_option'	=> array( 'QSO_ID' ),
60
-				$wpdb->prefix . 'esp_registration'	=> array( 'REG_ID' ),
61
-				$wpdb->prefix . 'esp_status'	=> array( 'STS_ID' ),
62
-				$wpdb->prefix . 'esp_transaction'	=> array( 'TXN_ID' ),
63
-				$wpdb->prefix . 'esp_transaction'	=> array( 'TXN_ID' ),
64
-				$wpdb->prefix . 'events_detail'	=> array( 'id' ),
65
-				$wpdb->prefix . 'events_category_detail'	=> array( 'id' ),
66
-				$wpdb->prefix . 'events_category_rel'	=> array( 'id' ),
67
-				$wpdb->prefix . 'events_venue'	=> array( 'id' ),
68
-				$wpdb->prefix . 'events_venue_rel' =>  array( 'emeta_id' ),
69
-				$wpdb->prefix . 'events_locale'	=> array( 'id' ),
70
-				$wpdb->prefix . 'events_locale_rel'	=> array( 'id' ),
71
-				$wpdb->prefix . 'events_personnel' =>  array( 'id' ),
72
-				$wpdb->prefix . 'events_personnel_rel' =>  array( 'id' ),
48
+				$wpdb->prefix.'esp_answer' => array('ANS_ID'),
49
+				$wpdb->prefix.'esp_attendee' => array('ATT_ID'),
50
+				$wpdb->prefix.'esp_datetime'	=> array('DTT_ID'),
51
+				$wpdb->prefix.'esp_event_question_group'	=> array('EQG_ID'),
52
+				$wpdb->prefix.'esp_message_template'	=> array('MTP_ID'),
53
+				$wpdb->prefix.'esp_payment'	=> array('PAY_ID'),
54
+				$wpdb->prefix.'esp_price'	=> array('PRC_ID'),
55
+				$wpdb->prefix.'esp_price_type'	=> array('PRT_ID'),
56
+				$wpdb->prefix.'esp_question'	=> array('QST_ID'),
57
+				$wpdb->prefix.'esp_question_group'	=> array('QSG_ID'),
58
+				$wpdb->prefix.'esp_question_group_question'	=> array('QGQ_ID'),
59
+				$wpdb->prefix.'esp_question_option'	=> array('QSO_ID'),
60
+				$wpdb->prefix.'esp_registration'	=> array('REG_ID'),
61
+				$wpdb->prefix.'esp_status'	=> array('STS_ID'),
62
+				$wpdb->prefix.'esp_transaction'	=> array('TXN_ID'),
63
+				$wpdb->prefix.'esp_transaction'	=> array('TXN_ID'),
64
+				$wpdb->prefix.'events_detail'	=> array('id'),
65
+				$wpdb->prefix.'events_category_detail'	=> array('id'),
66
+				$wpdb->prefix.'events_category_rel'	=> array('id'),
67
+				$wpdb->prefix.'events_venue'	=> array('id'),
68
+				$wpdb->prefix.'events_venue_rel' =>  array('emeta_id'),
69
+				$wpdb->prefix.'events_locale'	=> array('id'),
70
+				$wpdb->prefix.'events_locale_rel'	=> array('id'),
71
+				$wpdb->prefix.'events_personnel' =>  array('id'),
72
+				$wpdb->prefix.'events_personnel_rel' =>  array('id'),
73 73
 			);
74 74
 
75 75
 	}
@@ -81,9 +81,9 @@  discard block
 block discarded – undo
81 81
 	 *		@ access public
82 82
 	 *		@return EE_CSV
83 83
 	 */
84
-	public static function instance ( ) {
84
+	public static function instance( ) {
85 85
 		// check if class object is instantiated
86
-		if ( self::$_instance === NULL  or ! is_object( self::$_instance ) or ! ( self::$_instance instanceof EE_CSV )) {
86
+		if (self::$_instance === NULL or ! is_object(self::$_instance) or ! (self::$_instance instanceof EE_CSV)) {
87 87
 			self::$_instance = new self();
88 88
 		}
89 89
 		return self::$_instance;
@@ -95,22 +95,22 @@  discard block
 block discarded – undo
95 95
 	 * @return string
96 96
 	 * @throws EE_Error
97 97
 	 */
98
-	private function read_unicode_file($file_path){
98
+	private function read_unicode_file($file_path) {
99 99
 		$fc = "";
100
-		$fh = fopen($file_path,"rb");
101
-		if( ! $fh ){
102
-			throw new EE_Error( sprintf( __("Cannot open file for read: %s<br>\n", 'event_espresso'), $file_path ) );
100
+		$fh = fopen($file_path, "rb");
101
+		if ( ! $fh) {
102
+			throw new EE_Error(sprintf(__("Cannot open file for read: %s<br>\n", 'event_espresso'), $file_path));
103 103
 		}
104 104
 		$flen = filesize($file_path);
105 105
 		$bc = fread($fh, $flen);
106
-		for ($i=0; $i<$flen; $i++){
107
-			$c = substr($bc,$i,1);
108
-			if ((ord($c) != 0) && (ord($c) != 13)){
109
-			  $fc = $fc . $c;
106
+		for ($i = 0; $i < $flen; $i++) {
107
+			$c = substr($bc, $i, 1);
108
+			if ((ord($c) != 0) && (ord($c) != 13)) {
109
+			  $fc = $fc.$c;
110 110
 			}
111 111
 		}
112
-		if ((ord(substr($fc,0,1)) == 255) && (ord(substr($fc,1,1)) == 254))
113
-		$fc = substr($fc,2);
112
+		if ((ord(substr($fc, 0, 1)) == 255) && (ord(substr($fc, 1, 1)) == 254))
113
+		$fc = substr($fc, 2);
114 114
 		return ($fc);
115 115
 }
116 116
 
@@ -122,15 +122,15 @@  discard block
 block discarded – undo
122 122
 	 * @param string $path_to_file
123 123
 	 * @return array of arrays. Top-level array has rows, second-level array has each item
124 124
 	 */
125
-	public function import_csv_to_multi_dimensional_array($path_to_file){
125
+	public function import_csv_to_multi_dimensional_array($path_to_file) {
126 126
 		// needed to deal with Mac line endings
127
-		ini_set('auto_detect_line_endings',TRUE);
127
+		ini_set('auto_detect_line_endings', TRUE);
128 128
 
129 129
 		// because fgetcsv does not correctly deal with backslashed quotes such as \"
130 130
 		// we'll read the file into a string
131
-		$file_contents = $this->read_unicode_file( $path_to_file );
131
+		$file_contents = $this->read_unicode_file($path_to_file);
132 132
 		// replace backslashed quotes with CSV enclosures
133
-		$file_contents = str_replace ( '\\"', '"""', $file_contents );
133
+		$file_contents = str_replace('\\"', '"""', $file_contents);
134 134
 		// HEY YOU! PUT THAT FILE BACK!!!
135 135
 		file_put_contents($path_to_file, $file_contents);
136 136
 
@@ -140,25 +140,25 @@  discard block
 block discarded – undo
140 140
 			$csvarray = array();
141 141
 
142 142
 			// in PHP 5.3 fgetcsv accepts a 5th parameter, but the pre 5.3 versions of fgetcsv choke if passed more than 4 - is that crazy or what?
143
-			if ( version_compare( PHP_VERSION, '5.3.0' ) < 0 ) {
143
+			if (version_compare(PHP_VERSION, '5.3.0') < 0) {
144 144
 
145 145
 				//  PHP 5.2- version
146 146
 
147 147
 				// loop through each row of the file
148
-				while(($data = fgetcsv($file_handle, 0, ',', '"' )) !== FALSE){
149
-					$csvarray[]= $data;
148
+				while (($data = fgetcsv($file_handle, 0, ',', '"')) !== FALSE) {
149
+					$csvarray[] = $data;
150 150
 				}
151
-			}else{
151
+			} else {
152 152
 				// loop through each row of the file
153
-				while (( $data = fgetcsv( $file_handle, 0, ',', '"', '\\' )) !== FALSE ) {
154
-					$csvarray[]=$data;
153
+				while (($data = fgetcsv($file_handle, 0, ',', '"', '\\')) !== FALSE) {
154
+					$csvarray[] = $data;
155 155
 				}
156 156
 			}
157 157
 			# Close the File.
158 158
 			fclose($file_handle);
159 159
 			return $csvarray;
160
-		}else{
161
-			EE_Error::add_error( sprintf(__("An error occurred - the file: %s could not opened.", "event_espresso"),$path_to_file), __FILE__, __FUNCTION__, __LINE__ );
160
+		} else {
161
+			EE_Error::add_error(sprintf(__("An error occurred - the file: %s could not opened.", "event_espresso"), $path_to_file), __FILE__, __FUNCTION__, __LINE__);
162 162
 			return false;
163 163
 		}
164 164
 	}
@@ -188,9 +188,9 @@  discard block
 block discarded – undo
188 188
 	 *						...
189 189
 	 *						)
190 190
 	 */
191
-	public function import_csv_to_model_data_array( $path_to_file, $model_name = FALSE, $first_row_is_headers = TRUE ) {
191
+	public function import_csv_to_model_data_array($path_to_file, $model_name = FALSE, $first_row_is_headers = TRUE) {
192 192
 		$multi_dimensional_array = $this->import_csv_to_multi_dimensional_array($path_to_file);
193
-		if( ! $multi_dimensional_array ){
193
+		if ( ! $multi_dimensional_array) {
194 194
 			return false;
195 195
 		}
196 196
 		// gotta start somewhere
@@ -199,9 +199,9 @@  discard block
 block discarded – undo
199 199
 		$ee_formatted_data = array();
200 200
 		// array to store headers (column names)
201 201
 		$headers = array();
202
-		foreach($multi_dimensional_array as $data){
202
+		foreach ($multi_dimensional_array as $data) {
203 203
 			// if first cell is MODEL, then second cell is the MODEL name
204
-			if ( $data[0]	== 'MODEL' ) {
204
+			if ($data[0] == 'MODEL') {
205 205
 				$model_name = $data[1];
206 206
 				//don't bother looking for model data in this row. The rest of this
207 207
 				//row should be blank
@@ -211,7 +211,7 @@  discard block
 block discarded – undo
211 211
 				$headers = array();
212 212
 				continue;
213 213
 			}
214
-			if( strpos( $data[0], EE_CSV::metadata_header ) !==FALSE ){
214
+			if (strpos($data[0], EE_CSV::metadata_header) !== FALSE) {
215 215
 				$model_name = EE_CSV::metadata_header;
216 216
 				//store like model data, we just won't try importing it etc.
217 217
 				$row = 1;
@@ -224,31 +224,31 @@  discard block
 block discarded – undo
224 224
 
225 225
 			$model_entry = array();
226 226
 			// loop through each column
227
-			for ( $i=0; $i < $columns; $i++ ) {
227
+			for ($i = 0; $i < $columns; $i++) {
228 228
 
229 229
 				//replace csv_enclosures with backslashed quotes
230
-				$data[$i] = str_replace ( '"""', '\\"', $data[$i] );
230
+				$data[$i] = str_replace('"""', '\\"', $data[$i]);
231 231
 				// do we need to grab the column names?
232
-				if ( $row === 1){
233
-					if( $first_row_is_headers ) {
232
+				if ($row === 1) {
233
+					if ($first_row_is_headers) {
234 234
 						// store the column names to use for keys
235 235
 						$column_name = $data[$i];
236 236
 						//check it's not blank... sometimes CSV editign programs adda bunch of empty columns onto the end...
237
-						if(!$column_name){continue;}
237
+						if ( ! $column_name) {continue; }
238 238
 						$matches = array();
239
-						if($model_name == EE_CSV::metadata_header){
239
+						if ($model_name == EE_CSV::metadata_header) {
240 240
 							$headers[$i] = $column_name;
241
-						}else{
241
+						} else {
242 242
 							//now get the db table name from it (the part between square brackets)
243
-							$success = preg_match('~(.*)\[(.*)\]~', $column_name,$matches);
244
-							if (!$success){
245
-								EE_Error::add_error( sprintf(__("The column titled %s is invalid for importing. It must be be in the format of 'Nice Name[model_field_name]' in row %s", "event_espresso"),$column_name,implode(",",$data)), __FILE__, __FUNCTION__, __LINE__ );
243
+							$success = preg_match('~(.*)\[(.*)\]~', $column_name, $matches);
244
+							if ( ! $success) {
245
+								EE_Error::add_error(sprintf(__("The column titled %s is invalid for importing. It must be be in the format of 'Nice Name[model_field_name]' in row %s", "event_espresso"), $column_name, implode(",", $data)), __FILE__, __FUNCTION__, __LINE__);
246 246
 								return false;
247 247
 							}
248 248
 							$headers[$i] = $matches[2];
249 249
 						}
250 250
 
251
-					}else{
251
+					} else {
252 252
 						// no column names means our final array will just use counters for keys
253 253
 						$model_entry[$headers[$i]] = $data[$i];
254 254
 						$headers[$i] = $i;
@@ -256,14 +256,14 @@  discard block
 block discarded – undo
256 256
 					// and we need to store csv data
257 257
 				} else {
258 258
 					// this column isn' ta header, store it if there is a header for it
259
-					if(isset($headers[$i])){
259
+					if (isset($headers[$i])) {
260 260
 						$model_entry[$headers[$i]] = $data[$i];
261 261
 					}
262 262
 				}
263 263
 
264 264
 			}
265 265
 			//save the row's data IF it's a non-header-row
266
-			if( ! $first_row_is_headers || ($first_row_is_headers && $row > 1)){
266
+			if ( ! $first_row_is_headers || ($first_row_is_headers && $row > 1)) {
267 267
 				$ee_formatted_data[$model_name][] = $model_entry;
268 268
 			}
269 269
 			// advance to next row
@@ -282,9 +282,9 @@  discard block
 block discarded – undo
282 282
 	}
283 283
 
284 284
 
285
-	public function save_csv_to_db( $csv_data_array, $model_name = FALSE ) {
286
-		EE_Error::doing_it_wrong('save_csv_to_db', __( 'Function moved to EE_Import and renamed to save_csv_data_array_to_db', 'event_espresso' ), '4.6.7' );
287
-		return EE_Import::instance()->save_csv_data_array_to_db( $csv_data_array, $model_name );
285
+	public function save_csv_to_db($csv_data_array, $model_name = FALSE) {
286
+		EE_Error::doing_it_wrong('save_csv_to_db', __('Function moved to EE_Import and renamed to save_csv_data_array_to_db', 'event_espresso'), '4.6.7');
287
+		return EE_Import::instance()->save_csv_data_array_to_db($csv_data_array, $model_name);
288 288
 	}
289 289
 
290 290
 	/**
@@ -294,11 +294,11 @@  discard block
 block discarded – undo
294 294
 	 * @param string $new_filename the name of the file that the user will download
295 295
 	 * @return resource, like the results of fopen(), which can be used for fwrite, fputcsv2, etc.
296 296
 	 */
297
-	public function begin_sending_csv($filename){
297
+	public function begin_sending_csv($filename) {
298 298
 		// grab file extension
299 299
 		$ext = substr(strrchr($filename, '.'), 1);
300
-		if ( $ext == '.csv' or  $ext == '.xls' ) {
301
-			str_replace( $ext, '', $filename );
300
+		if ($ext == '.csv' or $ext == '.xls') {
301
+			str_replace($ext, '', $filename);
302 302
 		}
303 303
 		$filename .= '.csv';
304 304
 
@@ -319,8 +319,8 @@  discard block
 block discarded – undo
319 319
 //		header("Content-Type: application/download");
320 320
 		header('Content-disposition: attachment; filename='.$filename);
321 321
 		header("Content-Type: text/csv; charset=utf-8");
322
-                do_action( 'AHEE__EE_CSV__begin_sending_csv__headers' );
323
-		echo apply_filters('FHEE__EE_CSV__begin_sending_csv__start_writing', "\xEF\xBB\xBF" ); // makes excel open it as UTF-8. UTF-8 BOM, see http://stackoverflow.com/a/4440143/2773835
322
+                do_action('AHEE__EE_CSV__begin_sending_csv__headers');
323
+		echo apply_filters('FHEE__EE_CSV__begin_sending_csv__start_writing', "\xEF\xBB\xBF"); // makes excel open it as UTF-8. UTF-8 BOM, see http://stackoverflow.com/a/4440143/2773835
324 324
 		$fh = fopen('php://output', 'w');
325 325
 		return $fh;
326 326
 	}
@@ -330,10 +330,10 @@  discard block
 block discarded – undo
330 330
 	 * mentioning the version and timezone
331 331
 	 * @param resource $filehandle
332 332
 	 */
333
-	public function write_metadata_to_csv($filehandle){
334
-		$data_row = array(EE_CSV::metadata_header);//do NOT translate because this exact string is used when importing
333
+	public function write_metadata_to_csv($filehandle) {
334
+		$data_row = array(EE_CSV::metadata_header); //do NOT translate because this exact string is used when importing
335 335
 		$this->fputcsv2($filehandle, $data_row);
336
-		$meta_data = array( 0=> array(
336
+		$meta_data = array(0=> array(
337 337
 			'version'=>espresso_version(),
338 338
 			'timezone'=>  EEH_DTT_Helper::get_timezone(),
339 339
 			'time_of_export'=>current_time('mysql'),
@@ -351,29 +351,29 @@  discard block
 block discarded – undo
351 351
 	 * then the first row we'd write to the CSV would be "EVT_ID,EVT_name,..."
352 352
 	 * @return boolean if we successfully wrote to the CSV or not. If there's no $data, we consider that a success (because we wrote everything there was...nothing)
353 353
 	 */
354
-	public function write_data_array_to_csv($filehandle, $data){
354
+	public function write_data_array_to_csv($filehandle, $data) {
355 355
 
356 356
 
357 357
 		//determine if $data is actually a 2d array
358
-		if ( $data && is_array($data) && is_array(EEH_Array::get_one_item_from_array($data))){
358
+		if ($data && is_array($data) && is_array(EEH_Array::get_one_item_from_array($data))) {
359 359
 			//make sure top level is numerically indexed,
360 360
 
361
-			if( EEH_Array::is_associative_array($data)){
362
-				throw new EE_Error(sprintf(__("top-level array must be numerically indexed. Does these look like numbers to you? %s","event_espresso"),implode(",",array_keys($data))));
361
+			if (EEH_Array::is_associative_array($data)) {
362
+				throw new EE_Error(sprintf(__("top-level array must be numerically indexed. Does these look like numbers to you? %s", "event_espresso"), implode(",", array_keys($data))));
363 363
 			}
364 364
 			$item_in_top_level_array = EEH_Array::get_one_item_from_array($data);
365 365
 			//now, is the last item in the top-level array of $data an associative or numeric array?
366
-			if(EEH_Array::is_associative_array($item_in_top_level_array)){
366
+			if (EEH_Array::is_associative_array($item_in_top_level_array)) {
367 367
 				//its associative, so we want to output its keys as column headers
368 368
 				$keys = array_keys($item_in_top_level_array);
369 369
 				echo $this->fputcsv2($filehandle, $keys);
370 370
 			}
371 371
 			//start writing data
372
-			foreach($data as $data_row){
372
+			foreach ($data as $data_row) {
373 373
 				echo $this->fputcsv2($filehandle, $data_row);
374 374
 			}
375 375
 			return true;
376
-		}else{
376
+		} else {
377 377
 			//no data TO write... so we can assume that's a success
378 378
 			return true;
379 379
 		}
@@ -418,7 +418,7 @@  discard block
 block discarded – undo
418 418
 	 * Calls exit to prevent polluting the CSV file with other junk
419 419
 	 * @param resource $fh filehandle where we're writing the CSV to
420 420
 	 */
421
-	public function end_sending_csv($fh){
421
+	public function end_sending_csv($fh) {
422 422
 		fclose($fh);
423 423
 		exit(0);
424 424
 	}
@@ -431,23 +431,23 @@  discard block
 block discarded – undo
431 431
 	 * has all the attributes o fthat model object (eg, the event's id, name, etc)
432 432
 	 * @return boolean success
433 433
 	 */
434
-	public function write_model_data_to_csv($filehandle,$model_data_array){
434
+	public function write_model_data_to_csv($filehandle, $model_data_array) {
435 435
 		$this->write_metadata_to_csv($filehandle);
436
-		foreach($model_data_array as $model_name => $model_instance_arrays){
436
+		foreach ($model_data_array as $model_name => $model_instance_arrays) {
437 437
 			//first: output a special row stating the model
438
-			echo $this->fputcsv2($filehandle,array('MODEL',$model_name));
438
+			echo $this->fputcsv2($filehandle, array('MODEL', $model_name));
439 439
 			//if we have items to put in the CSV, do it normally
440 440
 
441
-			if( ! empty($model_instance_arrays) ){
441
+			if ( ! empty($model_instance_arrays)) {
442 442
 				$this->write_data_array_to_csv($filehandle, $model_instance_arrays);
443
-			}else{
443
+			} else {
444 444
 //				echo "no data to write... so just write the headers";
445 445
 				//so there's actually NO model objects for that model.
446 446
 				//probably still want to show the columns
447 447
 				$model = EE_Registry::instance()->load_model($model_name);
448 448
 				$column_names = array();
449
-				foreach($model->field_settings() as $field){
450
-					$column_names[$field->get_nicename()."[".$field->get_name()."]"] = null ;
449
+				foreach ($model->field_settings() as $field) {
450
+					$column_names[$field->get_nicename()."[".$field->get_name()."]"] = null;
451 451
 				}
452 452
 				$this->write_data_array_to_csv($filehandle, array($column_names));
453 453
 			}
@@ -461,7 +461,7 @@  discard block
 block discarded – undo
461 461
 	 * @param array $model_data_array 3d array, as described in EE_CSV::write_model_data_to_csv()
462 462
 	 * @return bool | void writes CSV file to output and dies
463 463
 	 */
464
-	public function export_multiple_model_data_to_csv($filename,$model_data_array){
464
+	public function export_multiple_model_data_to_csv($filename, $model_data_array) {
465 465
 		$filehandle = $this->begin_sending_csv($filename);
466 466
 		$this->write_model_data_to_csv($filehandle, $model_data_array);
467 467
 		$this->end_sending_csv($filehandle);
@@ -473,15 +473,15 @@  discard block
 block discarded – undo
473 473
 	 *			@param string $filename - name for newly created csv file
474 474
 	 *			@return TRUE on success, FALSE on fail
475 475
 	 */
476
-	public function export_array_to_csv( $data = FALSE, $filename = FALSE  ) {
476
+	public function export_array_to_csv($data = FALSE, $filename = FALSE) {
477 477
 
478 478
 		// no data file?? get outta here
479
-		if ( ! $data or ! is_array( $data ) or empty( $data ) ) {
479
+		if ( ! $data or ! is_array($data) or empty($data)) {
480 480
 			return FALSE;
481 481
 		}
482 482
 
483 483
 		// no filename?? get outta here
484
-		if ( ! $filename ) {
484
+		if ( ! $filename) {
485 485
 			return FALSE;
486 486
 		}
487 487
 
@@ -507,11 +507,11 @@  discard block
 block discarded – undo
507 507
 	 *			@param int $percent_of_max - desired percentage of the max upload_mb
508 508
 	 *			@return int KB
509 509
 	 */
510
-	public function get_max_upload_size ( $percent_of_max = FALSE ) {
510
+	public function get_max_upload_size($percent_of_max = FALSE) {
511 511
 
512
-		$max_upload = (int)(ini_get('upload_max_filesize'));
513
-		$max_post = (int)(ini_get('post_max_size'));
514
-		$memory_limit = (int)(ini_get('memory_limit'));
512
+		$max_upload = (int) (ini_get('upload_max_filesize'));
513
+		$max_post = (int) (ini_get('post_max_size'));
514
+		$memory_limit = (int) (ini_get('memory_limit'));
515 515
 
516 516
 		// determine the smallest of the three values from above
517 517
 		$upload_mb = min($max_upload, $max_post, $memory_limit);
@@ -520,9 +520,9 @@  discard block
 block discarded – undo
520 520
 		$upload_mb = $upload_mb * 1024;
521 521
 
522 522
 		// don't want the full monty? then reduce the max uplaod size
523
-		if ( $percent_of_max ) {
523
+		if ($percent_of_max) {
524 524
 			// is percent_of_max like this -> 50 or like this -> 0.50 ?
525
-			if ( $percent_of_max > 1 ) {
525
+			if ($percent_of_max > 1) {
526 526
 				// chnages 50 to 0.50
527 527
 				$percent_of_max = $percent_of_max / 100;
528 528
 			}
@@ -544,17 +544,17 @@  discard block
 block discarded – undo
544 544
 	 *			@param string $mysql_null - allows php NULL to be overridden with MySQl's insertable NULL value
545 545
 	 *			@return void
546 546
 	 */
547
-	private function fputcsv2 ($fh, array $row, $delimiter = ',', $enclosure = '"', $mysql_null = FALSE) {
547
+	private function fputcsv2($fh, array $row, $delimiter = ',', $enclosure = '"', $mysql_null = FALSE) {
548 548
 		//Allow user to filter the csv delimiter and enclosure for other countries csv standards
549
-		$delimiter = apply_filters( 'FHEE__EE_CSV__fputcsv2__delimiter', $delimiter );
550
-		$enclosure = apply_filters( 'FHEE__EE_CSV__fputcsv2__enclosure', $enclosure );
549
+		$delimiter = apply_filters('FHEE__EE_CSV__fputcsv2__delimiter', $delimiter);
550
+		$enclosure = apply_filters('FHEE__EE_CSV__fputcsv2__enclosure', $enclosure);
551 551
 
552 552
 		$delimiter_esc = preg_quote($delimiter, '/');
553 553
 		$enclosure_esc = preg_quote($enclosure, '/');
554 554
 
555 555
 		$output = array();
556 556
 		foreach ($row as $field_value) {
557
-			if(is_object($field_value) || is_array($field_value)){
557
+			if (is_object($field_value) || is_array($field_value)) {
558 558
 				$field_value = serialize($field_value);
559 559
 			}
560 560
 			if ($field_value === null && $mysql_null) {
@@ -563,10 +563,10 @@  discard block
 block discarded – undo
563 563
 			}
564 564
 
565 565
 			$output[] = preg_match("/(?:${delimiter_esc}|${enclosure_esc}|\s)/", $field_value) ?
566
-				( $enclosure . str_replace($enclosure, $enclosure . $enclosure, $field_value) . $enclosure ) : $field_value;
566
+				($enclosure.str_replace($enclosure, $enclosure.$enclosure, $field_value).$enclosure) : $field_value;
567 567
 		}
568 568
 
569
-		fwrite($fh, join($delimiter, $output) . PHP_EOL);
569
+		fwrite($fh, join($delimiter, $output).PHP_EOL);
570 570
 	}
571 571
 
572 572
 
@@ -604,8 +604,8 @@  discard block
 block discarded – undo
604 604
 	 * @param string $current_format
605 605
 	 * @return string
606 606
 	 */
607
-	public function get_date_format_for_csv( $current_format = null ) {
608
-		return apply_filters( 'FHEE__EE_CSV__get_date_format_for_csv__format', 'Y-m-d', $current_format );
607
+	public function get_date_format_for_csv($current_format = null) {
608
+		return apply_filters('FHEE__EE_CSV__get_date_format_for_csv__format', 'Y-m-d', $current_format);
609 609
 	}
610 610
 
611 611
 	/**
@@ -613,8 +613,8 @@  discard block
 block discarded – undo
613 613
 	 * @param string $current_format
614 614
 	 * @return string
615 615
 	 */
616
-	public function get_time_format_for_csv( $current_format = null ) {
617
-		return apply_filters( 'FHEE__EE_CSV__get_time_format_for_csv__format', 'H:i:s', $current_format );
616
+	public function get_time_format_for_csv($current_format = null) {
617
+		return apply_filters('FHEE__EE_CSV__get_time_format_for_csv__format', 'H:i:s', $current_format);
618 618
 	}
619 619
 
620 620
 
Please login to merge, or discard this patch.
core/db_classes/EE_Currency_Payment_Method.class.php 3 patches
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -59,7 +59,7 @@
 block discarded – undo
59 59
 	 * @param array $props_n_values  incoming values from the database
60 60
 	 * @param string $timezone  incoming timezone as set by the model.  If not set the timezone for
61 61
 	 *                          		the website will be used.
62
-	 * @return EE_Attendee
62
+	 * @return EE_Currency_Payment_Method
63 63
 	 */
64 64
 	public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) {
65 65
 		return new self( $props_n_values, TRUE, $timezone );
Please login to merge, or discard this patch.
Spacing   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
1 1
 <?php
2 2
 
3
-if (!defined('EVENT_ESPRESSO_VERSION'))
3
+if ( ! defined('EVENT_ESPRESSO_VERSION'))
4 4
 	exit('No direct script access allowed');
5 5
 
6 6
 /**
@@ -26,7 +26,7 @@  discard block
 block discarded – undo
26 26
  *
27 27
  * ------------------------------------------------------------------------
28 28
  */
29
-class EE_Currency_Payment_Method extends EE_Base_Class{
29
+class EE_Currency_Payment_Method extends EE_Base_Class {
30 30
 
31 31
 	/** Currency to Payment Method Link ID @var CPM_ID*/
32 32
 	protected $_CPM_ID = NULL;
@@ -48,9 +48,9 @@  discard block
 block discarded – undo
48 48
 	 *                             		    date_format and the second value is the time format
49 49
 	 * @return EE_Attendee
50 50
 	 */
51
-	public static function new_instance( $props_n_values = array(), $timezone = null, $date_formats = array() ) {
52
-		$has_object = parent::_check_for_object( $props_n_values, __CLASS__, $timezone, $date_formats );
53
-		return $has_object ? $has_object : new self( $props_n_values, false, $timezone, $date_formats );
51
+	public static function new_instance($props_n_values = array(), $timezone = null, $date_formats = array()) {
52
+		$has_object = parent::_check_for_object($props_n_values, __CLASS__, $timezone, $date_formats);
53
+		return $has_object ? $has_object : new self($props_n_values, false, $timezone, $date_formats);
54 54
 	}
55 55
 
56 56
 
@@ -61,8 +61,8 @@  discard block
 block discarded – undo
61 61
 	 *                          		the website will be used.
62 62
 	 * @return EE_Attendee
63 63
 	 */
64
-	public static function new_instance_from_db( $props_n_values = array(), $timezone = null ) {
65
-		return new self( $props_n_values, TRUE, $timezone );
64
+	public static function new_instance_from_db($props_n_values = array(), $timezone = null) {
65
+		return new self($props_n_values, TRUE, $timezone);
66 66
 	}
67 67
 
68 68
 }
Please login to merge, or discard this patch.
Braces   +2 added lines, -1 removed lines patch added patch discarded remove patch
@@ -1,7 +1,8 @@
 block discarded – undo
1 1
 <?php
2 2
 
3
-if (!defined('EVENT_ESPRESSO_VERSION'))
3
+if (!defined('EVENT_ESPRESSO_VERSION')) {
4 4
 	exit('No direct script access allowed');
5
+}
5 6
 
6 7
 /**
7 8
  * Event Espresso
Please login to merge, or discard this patch.