@@ -125,7 +125,7 @@ |
||
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? |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | -if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
3 | - exit( 'No direct script access allowed' ); |
|
2 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
3 | + exit('No direct script access allowed'); |
|
4 | 4 | } |
5 | 5 | |
6 | 6 | /** |
@@ -12,7 +12,7 @@ discard block |
||
12 | 12 | * @author Brent Christensen |
13 | 13 | * |
14 | 14 | */ |
15 | -class EE_DMS_4_7_0_Registration_Payments extends EE_Data_Migration_Script_Stage_Table{ |
|
15 | +class EE_DMS_4_7_0_Registration_Payments extends EE_Data_Migration_Script_Stage_Table { |
|
16 | 16 | |
17 | 17 | protected $_payment_table; |
18 | 18 | |
@@ -20,15 +20,15 @@ discard block |
||
20 | 20 | |
21 | 21 | protected $_registration_payment_table; |
22 | 22 | |
23 | - function __construct(){ |
|
23 | + function __construct() { |
|
24 | 24 | /** @type WPDB $wpdb */ |
25 | 25 | global $wpdb; |
26 | - $this->_pretty_name = __( 'Registration Payment Record Generation', 'event_espresso' ); |
|
26 | + $this->_pretty_name = __('Registration Payment Record Generation', 'event_espresso'); |
|
27 | 27 | // define tables |
28 | - $this->_old_table = $wpdb->prefix . 'esp_transaction'; |
|
29 | - $this->_payment_table = $wpdb->prefix . 'esp_payment'; |
|
30 | - $this->_registration_table = $wpdb->prefix . 'esp_registration'; |
|
31 | - $this->_registration_payment_table = $wpdb->prefix . 'esp_registration_payment'; |
|
28 | + $this->_old_table = $wpdb->prefix.'esp_transaction'; |
|
29 | + $this->_payment_table = $wpdb->prefix.'esp_payment'; |
|
30 | + $this->_registration_table = $wpdb->prefix.'esp_registration'; |
|
31 | + $this->_registration_payment_table = $wpdb->prefix.'esp_registration_payment'; |
|
32 | 32 | // build SQL WHERE clauses |
33 | 33 | $this->_extra_where_sql = "WHERE STS_ID IN ( 'TIN', 'TCM' ) AND TXN_Total != '0.000'"; |
34 | 34 | parent::__construct(); |
@@ -40,14 +40,14 @@ discard block |
||
40 | 40 | * @param array $transaction |
41 | 41 | * @return void |
42 | 42 | */ |
43 | - protected function _migrate_old_row( $transaction ) { |
|
43 | + protected function _migrate_old_row($transaction) { |
|
44 | 44 | /** @type WPDB $wpdb */ |
45 | 45 | global $wpdb; |
46 | - $TXN_ID = absint( $transaction[ 'TXN_ID' ] ); |
|
47 | - if ( ! $TXN_ID ) { |
|
46 | + $TXN_ID = absint($transaction['TXN_ID']); |
|
47 | + if ( ! $TXN_ID) { |
|
48 | 48 | $this->add_error( |
49 | 49 | sprintf( |
50 | - __( 'Invalid transaction with ID=%1$d. Error: "%2$s"', 'event_espresso' ), |
|
50 | + __('Invalid transaction with ID=%1$d. Error: "%2$s"', 'event_espresso'), |
|
51 | 51 | $TXN_ID, |
52 | 52 | $wpdb->last_error |
53 | 53 | ) |
@@ -55,19 +55,19 @@ discard block |
||
55 | 55 | return; |
56 | 56 | } |
57 | 57 | // get all payments for the TXN |
58 | - $payments = $this->_get_payments( $TXN_ID ); |
|
59 | - if ( empty( $payments ) ) { |
|
58 | + $payments = $this->_get_payments($TXN_ID); |
|
59 | + if (empty($payments)) { |
|
60 | 60 | return; |
61 | 61 | } |
62 | 62 | // then the registrants |
63 | - $registrations = $this->_get_registrations( $TXN_ID ); |
|
64 | - if ( empty( $registrations ) ) { |
|
63 | + $registrations = $this->_get_registrations($TXN_ID); |
|
64 | + if (empty($registrations)) { |
|
65 | 65 | return; |
66 | 66 | } |
67 | 67 | // now loop thru each payment and apply it to each of the registrations |
68 | - foreach ( $payments as $PAY_ID => $payment ) { |
|
69 | - if ( $payment->STS_ID === 'PAP' && $payment->PAY_amount > 0 ) { |
|
70 | - $this->_process_registration_payments( $payment, $registrations ); |
|
68 | + foreach ($payments as $PAY_ID => $payment) { |
|
69 | + if ($payment->STS_ID === 'PAP' && $payment->PAY_amount > 0) { |
|
70 | + $this->_process_registration_payments($payment, $registrations); |
|
71 | 71 | } |
72 | 72 | } |
73 | 73 | } |
@@ -80,11 +80,11 @@ discard block |
||
80 | 80 | * @param int $TXN_ID |
81 | 81 | * @return array |
82 | 82 | */ |
83 | - protected function _get_registrations( $TXN_ID ) { |
|
83 | + protected function _get_registrations($TXN_ID) { |
|
84 | 84 | /** @type WPDB $wpdb */ |
85 | 85 | global $wpdb; |
86 | 86 | $SQL = "SELECT * FROM {$this->_registration_table} WHERE TXN_ID = %d AND STS_ID IN ( 'RPP', 'RAP' )"; |
87 | - return $wpdb->get_results( $wpdb->prepare( $SQL, $TXN_ID ), OBJECT_K ); |
|
87 | + return $wpdb->get_results($wpdb->prepare($SQL, $TXN_ID), OBJECT_K); |
|
88 | 88 | } |
89 | 89 | |
90 | 90 | |
@@ -95,10 +95,10 @@ discard block |
||
95 | 95 | * @param int $TXN_ID |
96 | 96 | * @return array |
97 | 97 | */ |
98 | - protected function _get_payments( $TXN_ID ) { |
|
98 | + protected function _get_payments($TXN_ID) { |
|
99 | 99 | /** @type WPDB $wpdb */ |
100 | 100 | global $wpdb; |
101 | - return $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$this->_payment_table} WHERE TXN_ID = %d", $TXN_ID ), OBJECT_K ); |
|
101 | + return $wpdb->get_results($wpdb->prepare("SELECT * FROM {$this->_payment_table} WHERE TXN_ID = %d", $TXN_ID), OBJECT_K); |
|
102 | 102 | } |
103 | 103 | |
104 | 104 | |
@@ -109,10 +109,10 @@ discard block |
||
109 | 109 | * @param int $REG_ID |
110 | 110 | * @return array |
111 | 111 | */ |
112 | - protected function _get_possibly_updated_REG_paid( $REG_ID ) { |
|
112 | + protected function _get_possibly_updated_REG_paid($REG_ID) { |
|
113 | 113 | /** @type WPDB $wpdb */ |
114 | 114 | global $wpdb; |
115 | - return $wpdb->get_var( $wpdb->prepare( "SELECT REG_paid FROM {$this->_registration_table} WHERE REG_ID = %d", $REG_ID ) ); |
|
115 | + return $wpdb->get_var($wpdb->prepare("SELECT REG_paid FROM {$this->_registration_table} WHERE REG_ID = %d", $REG_ID)); |
|
116 | 116 | } |
117 | 117 | |
118 | 118 | |
@@ -127,40 +127,40 @@ discard block |
||
127 | 127 | * @param array $registrations |
128 | 128 | * @return bool |
129 | 129 | */ |
130 | - protected function _process_registration_payments( $payment, $registrations = array() ){ |
|
130 | + protected function _process_registration_payments($payment, $registrations = array()) { |
|
131 | 131 | // how much is available to apply to registrations? |
132 | 132 | $available_payment_amount = $payment->PAY_amount; |
133 | - foreach ( $registrations as $REG_ID => $registration ) { |
|
133 | + foreach ($registrations as $REG_ID => $registration) { |
|
134 | 134 | // nothing left, then we are done here? |
135 | - if ( ! $available_payment_amount > 0 ) { |
|
135 | + if ( ! $available_payment_amount > 0) { |
|
136 | 136 | break; |
137 | 137 | } |
138 | 138 | // ensure REG_final_price has a valid value, and skip if it turns out to be zero |
139 | - $registration->REG_final_price = ! empty( $registration->REG_final_price ) ? (float)$registration->REG_final_price : 0.00; |
|
140 | - if ( ! $registration->REG_final_price > 0 ) { |
|
139 | + $registration->REG_final_price = ! empty($registration->REG_final_price) ? (float) $registration->REG_final_price : 0.00; |
|
140 | + if ( ! $registration->REG_final_price > 0) { |
|
141 | 141 | continue; |
142 | 142 | } |
143 | 143 | // because REG_paid may have been updated by a previous payment, we need to retrieve the value from the db |
144 | - $possibly_updated_REG_paid = $this->_get_possibly_updated_REG_paid( $REG_ID ); |
|
145 | - if ( is_float( $possibly_updated_REG_paid ) ) { |
|
144 | + $possibly_updated_REG_paid = $this->_get_possibly_updated_REG_paid($REG_ID); |
|
145 | + if (is_float($possibly_updated_REG_paid)) { |
|
146 | 146 | $registration->REG_paid = $possibly_updated_REG_paid; |
147 | 147 | } |
148 | 148 | // and ensure REG_paid has a valid value |
149 | - $registration->REG_paid = ! empty( $registration->REG_paid ) ? (float)$registration->REG_paid : 0.00; |
|
149 | + $registration->REG_paid = ! empty($registration->REG_paid) ? (float) $registration->REG_paid : 0.00; |
|
150 | 150 | // calculate amount owing, and skip if it turns out to be zero |
151 | 151 | $owing = $registration->REG_final_price - $registration->REG_paid; |
152 | - if ( ! $owing > 0 ) { |
|
152 | + if ( ! $owing > 0) { |
|
153 | 153 | continue; |
154 | 154 | } |
155 | 155 | // don't allow payment amount to exceed the available payment amount, OR the amount owing |
156 | - $payment_amount = min( $available_payment_amount, $owing ); |
|
156 | + $payment_amount = min($available_payment_amount, $owing); |
|
157 | 157 | // update $available_payment_amount |
158 | 158 | $available_payment_amount = $available_payment_amount - $payment_amount; |
159 | 159 | // add relation between registration and payment and set amount |
160 | - if ( $this->_insert_registration_payment( $registration->REG_ID, $payment->PAY_ID, $payment_amount )) { |
|
160 | + if ($this->_insert_registration_payment($registration->REG_ID, $payment->PAY_ID, $payment_amount)) { |
|
161 | 161 | //calculate and set new REG_paid |
162 | 162 | $registration->REG_paid = $registration->REG_paid + $payment_amount; |
163 | - $this->_update_registration_paid( $registration->REG_ID, $registration->REG_paid ); |
|
163 | + $this->_update_registration_paid($registration->REG_ID, $registration->REG_paid); |
|
164 | 164 | } |
165 | 165 | } |
166 | 166 | } |
@@ -175,18 +175,18 @@ discard block |
||
175 | 175 | * @param float $PAY_amount |
176 | 176 | * @return bool |
177 | 177 | */ |
178 | - protected function _insert_registration_payment( $REG_ID = 0, $PAY_ID = 0, $PAY_amount = 0.00 ){ |
|
178 | + protected function _insert_registration_payment($REG_ID = 0, $PAY_ID = 0, $PAY_amount = 0.00) { |
|
179 | 179 | /** @type WPDB $wpdb */ |
180 | 180 | global $wpdb; |
181 | 181 | $success = $wpdb->insert( |
182 | 182 | $this->_registration_payment_table, |
183 | - array( 'REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount, ), // data |
|
184 | - array( '%f' ) // data format |
|
183 | + array('REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount,), // data |
|
184 | + array('%f') // data format |
|
185 | 185 | ); |
186 | - if ( $success === false ) { |
|
186 | + if ($success === false) { |
|
187 | 187 | $this->add_error( |
188 | 188 | sprintf( |
189 | - __( 'Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso' ), |
|
189 | + __('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'), |
|
190 | 190 | $REG_ID, |
191 | 191 | $wpdb->last_error |
192 | 192 | ) |
@@ -205,20 +205,20 @@ discard block |
||
205 | 205 | * @param float $REG_paid |
206 | 206 | * @return bool |
207 | 207 | */ |
208 | - protected function _update_registration_paid( $REG_ID = 0, $REG_paid = 0.00 ) { |
|
208 | + protected function _update_registration_paid($REG_ID = 0, $REG_paid = 0.00) { |
|
209 | 209 | /** @type WPDB $wpdb */ |
210 | 210 | global $wpdb; |
211 | 211 | $success = $wpdb->update( |
212 | 212 | $this->_registration_table, |
213 | - array( 'REG_paid' => $REG_paid ), // data |
|
214 | - array( 'REG_ID' => $REG_ID ), // where |
|
215 | - array( '%f' ), // data format |
|
216 | - array( '%d' ) // where format |
|
213 | + array('REG_paid' => $REG_paid), // data |
|
214 | + array('REG_ID' => $REG_ID), // where |
|
215 | + array('%f'), // data format |
|
216 | + array('%d') // where format |
|
217 | 217 | ); |
218 | - if ( $success === false ) { |
|
218 | + if ($success === false) { |
|
219 | 219 | $this->add_error( |
220 | 220 | sprintf( |
221 | - __( 'Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso' ), |
|
221 | + __('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'), |
|
222 | 222 | $REG_ID, |
223 | 223 | $wpdb->last_error |
224 | 224 | ) |
@@ -234,7 +234,7 @@ |
||
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){ |
@@ -264,9 +264,9 @@ |
||
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(); |
@@ -17,7 +17,7 @@ discard block |
||
17 | 17 | |
18 | 18 | |
19 | 19 | |
20 | -abstract class EE_Data_Migration_Class_Base{ |
|
20 | +abstract class EE_Data_Migration_Class_Base { |
|
21 | 21 | /** |
22 | 22 | * @var $records_to_migrate int count of all that have been migrated |
23 | 23 | */ |
@@ -50,7 +50,7 @@ discard block |
||
50 | 50 | * Just initializes the status of the migration |
51 | 51 | * @throws EE_Error |
52 | 52 | */ |
53 | - public function __construct(){ |
|
53 | + public function __construct() { |
|
54 | 54 | $this->set_status(EE_Data_Migration_Manager::status_continue); |
55 | 55 | } |
56 | 56 | |
@@ -61,9 +61,9 @@ discard block |
||
61 | 61 | * @throws EE_Error |
62 | 62 | * @return string |
63 | 63 | */ |
64 | - public function pretty_name(){ |
|
65 | - if($this->_pretty_name === null){ |
|
66 | - 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))); |
|
64 | + public function pretty_name() { |
|
65 | + if ($this->_pretty_name === null) { |
|
66 | + 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))); |
|
67 | 67 | } |
68 | 68 | return $this->_pretty_name; |
69 | 69 | } |
@@ -71,8 +71,8 @@ discard block |
||
71 | 71 | * |
72 | 72 | * @return int |
73 | 73 | */ |
74 | - public function count_records_to_migrate(){ |
|
75 | - if( $this->_records_to_migrate == null){ |
|
74 | + public function count_records_to_migrate() { |
|
75 | + if ($this->_records_to_migrate == null) { |
|
76 | 76 | $this->_records_to_migrate = $this->_count_records_to_migrate(); |
77 | 77 | } |
78 | 78 | return $this->_records_to_migrate; |
@@ -92,9 +92,9 @@ discard block |
||
92 | 92 | * @return string one of EE_Data_Migration_Manager::status_* constants |
93 | 93 | * @throws EE_Error |
94 | 94 | */ |
95 | - public function get_status(){ |
|
96 | - if($this->_status === null){ |
|
97 | - 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))); |
|
95 | + public function get_status() { |
|
96 | + if ($this->_status === null) { |
|
97 | + 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))); |
|
98 | 98 | } |
99 | 99 | return $this->_status; |
100 | 100 | } |
@@ -103,7 +103,7 @@ discard block |
||
103 | 103 | * @param string $status |
104 | 104 | * @return void |
105 | 105 | */ |
106 | - protected function set_status($status){ |
|
106 | + protected function set_status($status) { |
|
107 | 107 | $this->_status = $status; |
108 | 108 | } |
109 | 109 | /** |
@@ -115,11 +115,11 @@ discard block |
||
115 | 115 | * Returns the last error that occurred. If none occurred, returns null |
116 | 116 | * @return string |
117 | 117 | */ |
118 | - public function get_last_error(){ |
|
118 | + public function get_last_error() { |
|
119 | 119 | $errors = $this->get_errors(); |
120 | - if($errors){ |
|
120 | + if ($errors) { |
|
121 | 121 | return end($errors); |
122 | - }else{ |
|
122 | + } else { |
|
123 | 123 | return null; |
124 | 124 | } |
125 | 125 | } |
@@ -128,26 +128,26 @@ discard block |
||
128 | 128 | * @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. |
129 | 129 | * @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 |
130 | 130 | */ |
131 | - public function add_error($error, $force = FALSE ){ |
|
132 | - if( ! defined( 'EE_DMS_ERROR_LIMIT' ) ){ |
|
131 | + public function add_error($error, $force = FALSE) { |
|
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 |
138 | - if( is_string( $this->_errors ) ){ |
|
139 | - $this->_errors = array( $this->_errors ); |
|
138 | + if (is_string($this->_errors)) { |
|
139 | + $this->_errors = array($this->_errors); |
|
140 | 140 | } |
141 | - if(count($this->_errors) >= $limit ){ |
|
142 | - if( $force ){ |
|
141 | + if (count($this->_errors) >= $limit) { |
|
142 | + if ($force) { |
|
143 | 143 | //get rid of the first half of the errors and any above the limit |
144 | - $this->_errors = array_slice( $this->_errors, $limit / 2, $limit / 2 ); |
|
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{ |
|
148 | - $this->_errors[ $limit ] = 'More, but limit reached...'; |
|
147 | + } else { |
|
148 | + $this->_errors[$limit] = 'More, but limit reached...'; |
|
149 | 149 | } |
150 | - }else{ |
|
150 | + } else { |
|
151 | 151 | $this->_errors[] = $error; |
152 | 152 | } |
153 | 153 | } |
@@ -156,57 +156,57 @@ discard block |
||
156 | 156 | * Indicates there was a fatal error and the migration cannot possibly continue |
157 | 157 | * @return boolean |
158 | 158 | */ |
159 | - public function is_broken(){ |
|
159 | + public function is_broken() { |
|
160 | 160 | return $this->get_status() == EE_Data_Migration_Manager::status_fatal_error; |
161 | 161 | } |
162 | 162 | /** |
163 | 163 | * @deprecated since 4.6.12 |
164 | 164 | */ |
165 | - public function is_borked(){ |
|
166 | - 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'); |
|
165 | + public function is_borked() { |
|
166 | + 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'); |
|
167 | 167 | return $this->is_broken(); |
168 | 168 | } |
169 | 169 | /** |
170 | 170 | * Sets the status to as having a fatal error |
171 | 171 | */ |
172 | - public function set_broken(){ |
|
172 | + public function set_broken() { |
|
173 | 173 | $this->_status = EE_Data_Migration_Manager::status_fatal_error; |
174 | 174 | } |
175 | 175 | /** |
176 | 176 | * |
177 | 177 | * @deprecated since 4.6.12 |
178 | 178 | */ |
179 | - public function set_borked(){ |
|
180 | - 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'); |
|
179 | + public function set_borked() { |
|
180 | + 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'); |
|
181 | 181 | return $this->set_broken(); |
182 | 182 | } |
183 | 183 | /** |
184 | 184 | * Checks if this thing believes it is completed |
185 | 185 | * @return boolean |
186 | 186 | */ |
187 | - public function is_completed(){ |
|
187 | + public function is_completed() { |
|
188 | 188 | return $this->get_status() == EE_Data_Migration_Manager::status_completed; |
189 | 189 | } |
190 | 190 | /** |
191 | 191 | * Checks if the current script has more to do or not (ie, if it's status is CONTINUE) |
192 | 192 | * @return boolean |
193 | 193 | */ |
194 | - public function has_more_to_do(){ |
|
194 | + public function has_more_to_do() { |
|
195 | 195 | return $this->get_status() == EE_Data_Migration_Manager::status_continue; |
196 | 196 | } |
197 | 197 | /** |
198 | 198 | * Marks that we believe this migration thing is completed |
199 | 199 | */ |
200 | - public function set_completed(){ |
|
200 | + public function set_completed() { |
|
201 | 201 | $this->_status = EE_Data_Migration_Manager::status_completed; |
202 | 202 | } |
203 | 203 | |
204 | 204 | /** |
205 | 205 | * Marks that we think this migration class can continue to migrate |
206 | 206 | */ |
207 | - public function reattempt(){ |
|
207 | + public function reattempt() { |
|
208 | 208 | $this->_status = EE_Data_Migration_Manager::status_continue; |
209 | - $this->add_error( __( 'Reattempt migration', 'event_espresso' ), TRUE ); |
|
209 | + $this->add_error(__('Reattempt migration', 'event_espresso'), TRUE); |
|
210 | 210 | } |
211 | 211 | |
212 | 212 | /** |
@@ -215,8 +215,8 @@ discard block |
||
215 | 215 | * possible that this class is defined when it goes to sleep, but NOT available when it |
216 | 216 | * awakes (eg, this class is part of an addon that is deactivated at some point). |
217 | 217 | */ |
218 | - public function properties_as_array(){ |
|
219 | - $properties = get_object_vars($this); |
|
218 | + public function properties_as_array() { |
|
219 | + $properties = get_object_vars($this); |
|
220 | 220 | $properties['class'] = get_class($this); |
221 | 221 | unset($properties['_migration_script']); |
222 | 222 | return $properties; |
@@ -237,22 +237,22 @@ discard block |
||
237 | 237 | * @param array $data_types numerically indexed |
238 | 238 | * @return string |
239 | 239 | */ |
240 | - protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types){ |
|
240 | + protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types) { |
|
241 | 241 | global $wpdb; |
242 | 242 | $old_columns_and_values_for_string = array(); |
243 | - foreach($old_row_as_array as $column => $value){ |
|
243 | + foreach ($old_row_as_array as $column => $value) { |
|
244 | 244 | $old_columns_and_values_for_string[] = "$column => $value"; |
245 | 245 | } |
246 | 246 | $new_columns_and_values_for_string = array(); |
247 | 247 | $count = 0; |
248 | - foreach($new_row_as_array as $column => $value){ |
|
248 | + foreach ($new_row_as_array as $column => $value) { |
|
249 | 249 | $new_columns_and_values_for_string[] = " $column => $value (".$data_types[$count++].")"; |
250 | 250 | } |
251 | 251 | return sprintf( |
252 | 252 | __('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"), |
253 | - implode(", ",$new_columns_and_values_for_string), |
|
253 | + implode(", ", $new_columns_and_values_for_string), |
|
254 | 254 | $new_table, |
255 | - implode(", ",$old_columns_and_values_for_string), |
|
255 | + implode(", ", $old_columns_and_values_for_string), |
|
256 | 256 | $old_table, |
257 | 257 | '<br/>', |
258 | 258 | $wpdb->last_error |
@@ -267,12 +267,12 @@ discard block |
||
267 | 267 | * @param array $array_of_data |
268 | 268 | * @return string |
269 | 269 | */ |
270 | - protected function _json_encode($array_of_data){ |
|
270 | + protected function _json_encode($array_of_data) { |
|
271 | 271 | //we'd rather NOT serialize the transaction details |
272 | 272 | $fields_to_include = array(); |
273 | - foreach($array_of_data as $name => $value){ |
|
273 | + foreach ($array_of_data as $name => $value) { |
|
274 | 274 | $unserialized_data = @unserialize($value); |
275 | - if($unserialized_data === FALSE){ |
|
275 | + if ($unserialized_data === FALSE) { |
|
276 | 276 | $fields_to_include[$name] = $value; |
277 | 277 | } |
278 | 278 | } |
@@ -119,7 +119,7 @@ discard block |
||
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 |
||
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 |
||
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 | } |
@@ -1434,7 +1434,6 @@ discard block |
||
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 |
||
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 |
||
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 |
@@ -1607,19 +1607,19 @@ |
||
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(){ |
@@ -8,15 +8,15 @@ discard block |
||
8 | 8 | //(all other times it gets resurrected from a wordpress option) |
9 | 9 | $stages = glob(EE_CORE.'data_migration_scripts/4_1_0_stages/*'); |
10 | 10 | $class_to_filepath = array(); |
11 | -if ( ! empty( $stages ) ) { |
|
12 | - foreach($stages as $filepath){ |
|
11 | +if ( ! empty($stages)) { |
|
12 | + foreach ($stages as $filepath) { |
|
13 | 13 | $matches = array(); |
14 | - preg_match('~4_1_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
14 | + preg_match('~4_1_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
15 | 15 | $class_to_filepath[$matches[1]] = $filepath; |
16 | 16 | } |
17 | 17 | } |
18 | 18 | //give addons a chance to autoload their stages too |
19 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_1_0__autoloaded_stages',$class_to_filepath); |
|
19 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_1_0__autoloaded_stages', $class_to_filepath); |
|
20 | 20 | EEH_Autoloader::register_autoloader($class_to_filepath); |
21 | 21 | |
22 | 22 | /** |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | * --a function named update_espresso_config() which saves the EE_Config object to the database |
35 | 35 | * --...and all its subclasses... really, you're best off copying the whole thin gwhen 4.1 is released into this file and wrapping its declaration in if( ! class_exists()){...} |
36 | 36 | */ |
37 | -class EE_DMS_Core_4_1_0 extends EE_Data_Migration_Script_Base{ |
|
37 | +class EE_DMS_Core_4_1_0 extends EE_Data_Migration_Script_Base { |
|
38 | 38 | |
39 | 39 | |
40 | 40 | |
@@ -67,26 +67,26 @@ discard block |
||
67 | 67 | * @global type $wpdb |
68 | 68 | * @return boolean |
69 | 69 | */ |
70 | - private function _checkin_table_exists(){ |
|
70 | + private function _checkin_table_exists() { |
|
71 | 71 | global $wpdb; |
72 | 72 | $results = $wpdb->get_results("SHOW TABLES LIKE '".$wpdb->prefix."events_attendee_checkin"."'"); |
73 | - if($results){ |
|
73 | + if ($results) { |
|
74 | 74 | return true; |
75 | - }else{ |
|
75 | + } else { |
|
76 | 76 | return false; |
77 | 77 | } |
78 | 78 | } |
79 | 79 | public function can_migrate_from_version($version_array) { |
80 | 80 | $version_string = $version_array['Core']; |
81 | - if($version_string < '4.0.0' && $version_string > '3.1.26' ){ |
|
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 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
89 | - }else{ |
|
88 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
89 | + } else { |
|
90 | 90 | // echo "$version_string doesnt apply"; |
91 | 91 | return false; |
92 | 92 | } |
@@ -96,15 +96,15 @@ discard block |
||
96 | 96 | } |
97 | 97 | public function schema_changes_before_migration() { |
98 | 98 | //relies on 4.1's EEH_Activation::create_table |
99 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
99 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
100 | 100 | |
101 | - $table_name='esp_answer'; |
|
102 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
101 | + $table_name = 'esp_answer'; |
|
102 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
103 | 103 | REG_ID INT UNSIGNED NOT NULL, |
104 | 104 | QST_ID INT UNSIGNED NOT NULL, |
105 | 105 | ANS_value TEXT NOT NULL, |
106 | 106 | PRIMARY KEY (ANS_ID)"; |
107 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
107 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
108 | 108 | |
109 | 109 | $table_name = 'esp_attendee_meta'; |
110 | 110 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -144,7 +144,7 @@ discard block |
||
144 | 144 | CNT_is_EU TINYINT(1) DEFAULT '0', |
145 | 145 | CNT_active TINYINT(1) DEFAULT '0', |
146 | 146 | PRIMARY KEY (CNT_ISO)"; |
147 | - $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
147 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
148 | 148 | |
149 | 149 | |
150 | 150 | |
@@ -165,7 +165,7 @@ discard block |
||
165 | 165 | |
166 | 166 | |
167 | 167 | |
168 | - $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
168 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
169 | 169 | $table_name = 'esp_event_meta'; |
170 | 170 | $sql = " |
171 | 171 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -182,41 +182,41 @@ discard block |
||
182 | 182 | EVT_external_URL VARCHAR(200) NULL, |
183 | 183 | EVT_donations TINYINT(1) NULL, |
184 | 184 | PRIMARY KEY (EVTM_ID)"; |
185 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
185 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
186 | 186 | |
187 | 187 | |
188 | 188 | |
189 | - $table_name='esp_event_question_group'; |
|
190 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
189 | + $table_name = 'esp_event_question_group'; |
|
190 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
191 | 191 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
192 | 192 | QSG_ID INT UNSIGNED NOT NULL, |
193 | 193 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
194 | 194 | PRIMARY KEY (EQG_ID)"; |
195 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
195 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
196 | 196 | |
197 | 197 | |
198 | 198 | |
199 | - $table_name='esp_event_venue'; |
|
200 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
199 | + $table_name = 'esp_event_venue'; |
|
200 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
201 | 201 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
202 | 202 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
203 | 203 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
204 | 204 | PRIMARY KEY (EVV_ID)"; |
205 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
205 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
206 | 206 | |
207 | 207 | |
208 | 208 | |
209 | - $table_name='esp_extra_meta'; |
|
210 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
209 | + $table_name = 'esp_extra_meta'; |
|
210 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
211 | 211 | OBJ_ID INT(11) DEFAULT NULL, |
212 | 212 | EXM_type VARCHAR(45) DEFAULT NULL, |
213 | 213 | EXM_key VARCHAR(45) DEFAULT NULL, |
214 | 214 | EXM_value TEXT, |
215 | 215 | PRIMARY KEY (EXM_ID)"; |
216 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
216 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
217 | 217 | |
218 | - $table_name='esp_line_item'; |
|
219 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
218 | + $table_name = 'esp_line_item'; |
|
219 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
220 | 220 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
221 | 221 | TXN_ID INT(11) DEFAULT NULL, |
222 | 222 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -232,7 +232,7 @@ discard block |
||
232 | 232 | OBJ_ID INT(11) DEFAULT NULL, |
233 | 233 | OBJ_type VARCHAR(45)DEFAULT NULL, |
234 | 234 | PRIMARY KEY (LIN_ID)"; |
235 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB' ); |
|
235 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
236 | 236 | |
237 | 237 | $table_name = 'esp_message_template'; |
238 | 238 | $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -259,7 +259,7 @@ discard block |
||
259 | 259 | PRIMARY KEY (GRP_ID), |
260 | 260 | KEY EVT_ID (EVT_ID), |
261 | 261 | KEY MTP_user_id (MTP_user_id)"; |
262 | - $this->_table_is_new_in_this_version( $table_name, $sql, 'ENGINE=InnoDB'); |
|
262 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
263 | 263 | |
264 | 264 | |
265 | 265 | |
@@ -367,8 +367,8 @@ discard block |
||
367 | 367 | |
368 | 368 | |
369 | 369 | |
370 | - $table_name='esp_question'; |
|
371 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
370 | + $table_name = 'esp_question'; |
|
371 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
372 | 372 | QST_display_text TEXT NOT NULL, |
373 | 373 | QST_admin_label VARCHAR(255) NOT NULL, |
374 | 374 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -380,12 +380,12 @@ discard block |
||
380 | 380 | QST_wp_user BIGINT UNSIGNED NULL, |
381 | 381 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
382 | 382 | PRIMARY KEY (QST_ID)'; |
383 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
383 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
384 | 384 | |
385 | - EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
385 | + EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
386 | 386 | |
387 | 387 | $table_name = 'esp_question_group'; |
388 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
388 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
389 | 389 | QSG_name VARCHAR(255) NOT NULL, |
390 | 390 | QSG_identifier VARCHAR(100) NOT NULL, |
391 | 391 | QSG_desc TEXT NULL, |
@@ -396,27 +396,27 @@ discard block |
||
396 | 396 | QSG_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
397 | 397 | PRIMARY KEY (QSG_ID), |
398 | 398 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
399 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
399 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
400 | 400 | |
401 | 401 | |
402 | 402 | |
403 | - $table_name='esp_question_group_question'; |
|
404 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
403 | + $table_name = 'esp_question_group_question'; |
|
404 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
405 | 405 | QSG_ID INT UNSIGNED NOT NULL, |
406 | 406 | QST_ID INT UNSIGNED NOT NULL, |
407 | 407 | PRIMARY KEY (QGQ_ID) "; |
408 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
408 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
409 | 409 | |
410 | 410 | |
411 | 411 | |
412 | - $table_name='esp_question_option'; |
|
413 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
412 | + $table_name = 'esp_question_option'; |
|
413 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
414 | 414 | QSO_value VARCHAR(255) NOT NULL, |
415 | 415 | QSO_desc TEXT NOT NULL, |
416 | 416 | QST_ID INT UNSIGNED NOT NULL, |
417 | 417 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
418 | 418 | PRIMARY KEY (QSO_ID)"; |
419 | - $this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
419 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
420 | 420 | |
421 | 421 | |
422 | 422 | |
@@ -449,8 +449,8 @@ discard block |
||
449 | 449 | |
450 | 450 | |
451 | 451 | |
452 | - $table_name='esp_checkin'; |
|
453 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
452 | + $table_name = 'esp_checkin'; |
|
453 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
454 | 454 | REG_ID INT(10) UNSIGNED NOT NULL, |
455 | 455 | DTT_ID INT(10) UNSIGNED NOT NULL, |
456 | 456 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -557,12 +557,12 @@ discard block |
||
557 | 557 | |
558 | 558 | global $wpdb; |
559 | 559 | $state_table = $wpdb->prefix."esp_state"; |
560 | - if ( $wpdb->get_var( "SHOW TABLES LIKE '" . $state_table . "'") == $state_table ) { |
|
560 | + if ($wpdb->get_var("SHOW TABLES LIKE '".$state_table."'") == $state_table) { |
|
561 | 561 | |
562 | - $SQL = "SELECT COUNT('STA_ID') FROM " . $state_table; |
|
562 | + $SQL = "SELECT COUNT('STA_ID') FROM ".$state_table; |
|
563 | 563 | $states = $wpdb->get_var($SQL); |
564 | - if ( ! $states ) { |
|
565 | - $SQL = "INSERT INTO " . $state_table . " |
|
564 | + if ( ! $states) { |
|
565 | + $SQL = "INSERT INTO ".$state_table." |
|
566 | 566 | (STA_ID, CNT_ISO, STA_abbrev, STA_name, STA_active) VALUES |
567 | 567 | (1, 'US', 'AK', 'Alaska', 1), |
568 | 568 | (2, 'US', 'AL', 'Alabama', 1), |
@@ -649,12 +649,12 @@ discard block |
||
649 | 649 | |
650 | 650 | global $wpdb; |
651 | 651 | $country_table = $wpdb->prefix."esp_country"; |
652 | - if ( $wpdb->get_var( "SHOW TABLES LIKE '" . $country_table . "'") == $country_table ) { |
|
652 | + if ($wpdb->get_var("SHOW TABLES LIKE '".$country_table."'") == $country_table) { |
|
653 | 653 | |
654 | - $SQL = "SELECT COUNT('CNT_ISO') FROM " . $country_table; |
|
654 | + $SQL = "SELECT COUNT('CNT_ISO') FROM ".$country_table; |
|
655 | 655 | $countries = $wpdb->get_var($SQL); |
656 | - if ( ! $countries ) { |
|
657 | - $SQL = "INSERT INTO " . $country_table . " |
|
656 | + if ( ! $countries) { |
|
657 | + $SQL = "INSERT INTO ".$country_table." |
|
658 | 658 | (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 |
659 | 659 | ('AD', 'AND', 0, 'Andorra', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+376', 0, 0), |
660 | 660 | ('AE', 'ARE', 0, 'United Arab Emirates', 'AED', 'Dirham', 'Dirhams', 'د.إ', 1, 2, '+971', 0, 0), |
@@ -903,18 +903,18 @@ discard block |
||
903 | 903 | |
904 | 904 | if ($wpdb->get_var("SHOW TABLES LIKE '$price_type_table'") == $price_type_table) { |
905 | 905 | |
906 | - $SQL = 'SELECT COUNT(PRT_ID) FROM ' . $price_type_table; |
|
907 | - $price_types_exist = $wpdb->get_var( $SQL ); |
|
906 | + $SQL = 'SELECT COUNT(PRT_ID) FROM '.$price_type_table; |
|
907 | + $price_types_exist = $wpdb->get_var($SQL); |
|
908 | 908 | |
909 | - if ( ! $price_types_exist ) { |
|
909 | + if ( ! $price_types_exist) { |
|
910 | 910 | $SQL = "INSERT INTO $price_type_table ( PRT_ID, PRT_name, PBT_ID, PRT_is_percent, PRT_order, PRT_deleted ) VALUES |
911 | - (1, '" . __('Base Price', 'event_espresso') . "', 1, 0, 0, 0), |
|
912 | - (2, '" . __('Percent Discount', 'event_espresso') . "', 2, 1, 20, 0), |
|
913 | - (3, '" . __('Fixed Discount', 'event_espresso') . "', 2, 0, 30, 0), |
|
914 | - (4, '" . __('Percent Surcharge', 'event_espresso') . "', 3, 1, 40, 0), |
|
915 | - (5, '" . __('Fixed Surcharge', 'event_espresso') . "', 3, 0, 50, 0);"; |
|
916 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_price_types__SQL', $SQL ); |
|
917 | - $wpdb->query( $SQL ); |
|
911 | + (1, '".__('Base Price', 'event_espresso')."', 1, 0, 0, 0), |
|
912 | + (2, '" . __('Percent Discount', 'event_espresso')."', 2, 1, 20, 0), |
|
913 | + (3, '" . __('Fixed Discount', 'event_espresso')."', 2, 0, 30, 0), |
|
914 | + (4, '" . __('Percent Surcharge', 'event_espresso')."', 3, 1, 40, 0), |
|
915 | + (5, '" . __('Fixed Surcharge', 'event_espresso')."', 3, 0, 50, 0);"; |
|
916 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_price_types__SQL', $SQL); |
|
917 | + $wpdb->query($SQL); |
|
918 | 918 | } |
919 | 919 | } |
920 | 920 | } |
@@ -936,14 +936,14 @@ discard block |
||
936 | 936 | |
937 | 937 | if ($wpdb->get_var("SHOW TABLES LIKE '$price_table'") == $price_table) { |
938 | 938 | |
939 | - $SQL = 'SELECT COUNT(PRC_ID) FROM ' .$price_table; |
|
940 | - $prices_exist = $wpdb->get_var( $SQL ); |
|
939 | + $SQL = 'SELECT COUNT(PRC_ID) FROM '.$price_table; |
|
940 | + $prices_exist = $wpdb->get_var($SQL); |
|
941 | 941 | |
942 | - if ( ! $prices_exist ) { |
|
942 | + if ( ! $prices_exist) { |
|
943 | 943 | $SQL = "INSERT INTO $price_table |
944 | 944 | (PRC_ID, PRT_ID, PRC_amount, PRC_name, PRC_desc, PRC_is_default, PRC_overrides, PRC_order, PRC_deleted, PRC_parent ) VALUES |
945 | 945 | (1, 1, '0.00', 'Free Admission', '', 1, NULL, 0, 0, 0);"; |
946 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_prices__SQL', $SQL ); |
|
946 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_prices__SQL', $SQL); |
|
947 | 947 | $wpdb->query($SQL); |
948 | 948 | } |
949 | 949 | } |
@@ -960,34 +960,34 @@ discard block |
||
960 | 960 | |
961 | 961 | global $wpdb; |
962 | 962 | $ticket_table = $wpdb->prefix."esp_ticket"; |
963 | - if ( $wpdb->get_var("SHOW TABLES LIKE'$ticket_table'") == $ticket_table ) { |
|
963 | + if ($wpdb->get_var("SHOW TABLES LIKE'$ticket_table'") == $ticket_table) { |
|
964 | 964 | |
965 | - $SQL = 'SELECT COUNT(TKT_ID) FROM ' . $ticket_table; |
|
965 | + $SQL = 'SELECT COUNT(TKT_ID) FROM '.$ticket_table; |
|
966 | 966 | $tickets_exist = $wpdb->get_var($SQL); |
967 | 967 | |
968 | - if ( ! $tickets_exist ) { |
|
968 | + if ( ! $tickets_exist) { |
|
969 | 969 | $SQL = "INSERT INTO $ticket_table |
970 | 970 | ( 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 |
971 | - ( 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);"; |
|
972 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL ); |
|
971 | + ( 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);"; |
|
972 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL); |
|
973 | 973 | $wpdb->query($SQL); |
974 | 974 | } |
975 | 975 | } |
976 | 976 | $ticket_price_table = $wpdb->prefix."esp_ticket_price"; |
977 | 977 | |
978 | - if ( $wpdb->get_var("SHOW TABLES LIKE'$ticket_price_table'") == $ticket_price_table ) { |
|
978 | + if ($wpdb->get_var("SHOW TABLES LIKE'$ticket_price_table'") == $ticket_price_table) { |
|
979 | 979 | |
980 | - $SQL = 'SELECT COUNT(TKP_ID) FROM ' . $ticket_price_table; |
|
980 | + $SQL = 'SELECT COUNT(TKP_ID) FROM '.$ticket_price_table; |
|
981 | 981 | $ticket_prc_exist = $wpdb->get_var($SQL); |
982 | 982 | |
983 | - if ( ! $ticket_prc_exist ) { |
|
983 | + if ( ! $ticket_prc_exist) { |
|
984 | 984 | |
985 | 985 | $SQL = "INSERT INTO $ticket_price_table |
986 | 986 | ( TKP_ID, TKT_ID, PRC_ID ) VALUES |
987 | 987 | ( 1, 1, 1 ) |
988 | 988 | "; |
989 | 989 | |
990 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL ); |
|
990 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL); |
|
991 | 991 | $wpdb->query($SQL); |
992 | 992 | } |
993 | 993 | } |
@@ -1000,20 +1000,20 @@ discard block |
||
1000 | 1000 | * @param string $country_name |
1001 | 1001 | * @return array where keys are columns, values are column values |
1002 | 1002 | */ |
1003 | - public function get_or_create_country($country_name){ |
|
1004 | - if( ! $country_name ){ |
|
1003 | + public function get_or_create_country($country_name) { |
|
1004 | + if ( ! $country_name) { |
|
1005 | 1005 | throw new EE_Error(__("Could not get a country because country name is blank", "event_espresso")); |
1006 | 1006 | } |
1007 | 1007 | global $wpdb; |
1008 | 1008 | $country_table = $wpdb->prefix."esp_country"; |
1009 | - if(is_int($country_name)){ |
|
1009 | + if (is_int($country_name)) { |
|
1010 | 1010 | $country_name = $this->get_iso_from_3_1_country_id($country_name); |
1011 | 1011 | } |
1012 | 1012 | $country = $wpdb->get_row($wpdb->prepare("SELECT * FROM $country_table WHERE |
1013 | 1013 | CNT_ISO LIKE %s OR |
1014 | 1014 | CNT_ISO3 LIKE %s OR |
1015 | - CNT_name LIKE %s LIMIT 1",$country_name,$country_name,$country_name),ARRAY_A); |
|
1016 | - if( ! $country ){ |
|
1015 | + CNT_name LIKE %s LIMIT 1", $country_name, $country_name, $country_name), ARRAY_A); |
|
1016 | + if ( ! $country) { |
|
1017 | 1017 | //insert a new one then |
1018 | 1018 | $cols_n_values = array( |
1019 | 1019 | 'CNT_ISO'=> $this->_find_available_country_iso(2), |
@@ -1033,26 +1033,26 @@ discard block |
||
1033 | 1033 | 'CNT_active'=>true |
1034 | 1034 | ); |
1035 | 1035 | $data_types = array( |
1036 | - '%s',//CNT_ISO |
|
1037 | - '%s',//CNT_ISO3 |
|
1038 | - '%d',//RGN_ID |
|
1039 | - '%s',//CNT_name |
|
1040 | - '%s',//CNT_cur_code |
|
1041 | - '%s',//CNT_cur_single |
|
1042 | - '%s',//CNT_cur_plural |
|
1043 | - '%s',//CNT_cur_sign |
|
1044 | - '%d',//CNT_cur_sign_b4 |
|
1045 | - '%d',//CNT_cur_dec_plc |
|
1046 | - '%s',//CNT_cur_dec_mrk |
|
1047 | - '%s',//CNT_cur_thsnds |
|
1048 | - '%s',//CNT_tel_code |
|
1049 | - '%d',//CNT_is_EU |
|
1050 | - '%d',//CNT_active |
|
1036 | + '%s', //CNT_ISO |
|
1037 | + '%s', //CNT_ISO3 |
|
1038 | + '%d', //RGN_ID |
|
1039 | + '%s', //CNT_name |
|
1040 | + '%s', //CNT_cur_code |
|
1041 | + '%s', //CNT_cur_single |
|
1042 | + '%s', //CNT_cur_plural |
|
1043 | + '%s', //CNT_cur_sign |
|
1044 | + '%d', //CNT_cur_sign_b4 |
|
1045 | + '%d', //CNT_cur_dec_plc |
|
1046 | + '%s', //CNT_cur_dec_mrk |
|
1047 | + '%s', //CNT_cur_thsnds |
|
1048 | + '%s', //CNT_tel_code |
|
1049 | + '%d', //CNT_is_EU |
|
1050 | + '%d', //CNT_active |
|
1051 | 1051 | ); |
1052 | 1052 | $success = $wpdb->insert($country_table, |
1053 | 1053 | $cols_n_values, |
1054 | 1054 | $data_types); |
1055 | - if( ! $success){ |
|
1055 | + if ( ! $success) { |
|
1056 | 1056 | 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)); |
1057 | 1057 | } |
1058 | 1058 | $country = $cols_n_values; |
@@ -1064,13 +1064,13 @@ discard block |
||
1064 | 1064 | * @global type $wpdb |
1065 | 1065 | * @return string |
1066 | 1066 | */ |
1067 | - private function _find_available_country_iso($num_letters = 2){ |
|
1067 | + private function _find_available_country_iso($num_letters = 2) { |
|
1068 | 1068 | global $wpdb; |
1069 | 1069 | $country_table = $wpdb->prefix."esp_country"; |
1070 | - do{ |
|
1070 | + do { |
|
1071 | 1071 | $current_iso = strtoupper(wp_generate_password($num_letters, false)); |
1072 | - $country_with_that_iso = $wpdb->get_var($wpdb->prepare("SELECT count(CNT_ISO) FROM ".$country_table." WHERE CNT_ISO=%s",$current_iso)); |
|
1073 | - }while(intval($country_with_that_iso)); |
|
1072 | + $country_with_that_iso = $wpdb->get_var($wpdb->prepare("SELECT count(CNT_ISO) FROM ".$country_table." WHERE CNT_ISO=%s", $current_iso)); |
|
1073 | + }while (intval($country_with_that_iso)); |
|
1074 | 1074 | return $current_iso; |
1075 | 1075 | } |
1076 | 1076 | |
@@ -1081,14 +1081,14 @@ discard block |
||
1081 | 1081 | * @param string $state_name |
1082 | 1082 | * @return array where keys are columns, values are column values |
1083 | 1083 | */ |
1084 | - public function get_or_create_state($state_name,$country_name = ''){ |
|
1085 | - if( ! $state_name ){ |
|
1084 | + public function get_or_create_state($state_name, $country_name = '') { |
|
1085 | + if ( ! $state_name) { |
|
1086 | 1086 | throw new EE_Error(__("Could not get-or-create state because no state name was provided", "event_espresso")); |
1087 | 1087 | } |
1088 | - try{ |
|
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; |
@@ -1096,24 +1096,24 @@ discard block |
||
1096 | 1096 | $state = $wpdb->get_row($wpdb->prepare("SELECT * FROM $state_table WHERE |
1097 | 1097 | (STA_abbrev LIKE %s OR |
1098 | 1098 | STA_name LIKE %s) AND |
1099 | - CNT_ISO LIKE %s LIMIT 1",$state_name,$state_name,$country_iso),ARRAY_A); |
|
1100 | - if ( ! $state){ |
|
1099 | + CNT_ISO LIKE %s LIMIT 1", $state_name, $state_name, $country_iso), ARRAY_A); |
|
1100 | + if ( ! $state) { |
|
1101 | 1101 | //insert a new one then |
1102 | 1102 | $cols_n_values = array( |
1103 | 1103 | 'CNT_ISO'=>$country_iso, |
1104 | - 'STA_abbrev'=>substr($state_name,0,6), |
|
1104 | + 'STA_abbrev'=>substr($state_name, 0, 6), |
|
1105 | 1105 | 'STA_name'=>$state_name, |
1106 | 1106 | 'STA_active'=>true |
1107 | 1107 | ); |
1108 | 1108 | $data_types = array( |
1109 | - '%s',//CNT_ISO |
|
1110 | - '%s',//STA_abbrev |
|
1111 | - '%s',//STA_name |
|
1112 | - '%d',//STA_active |
|
1109 | + '%s', //CNT_ISO |
|
1110 | + '%s', //STA_abbrev |
|
1111 | + '%s', //STA_name |
|
1112 | + '%d', //STA_active |
|
1113 | 1113 | ); |
1114 | - $success = $wpdb->insert($state_table,$cols_n_values,$data_types); |
|
1115 | - if ( ! $success ){ |
|
1116 | - 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)); |
|
1114 | + $success = $wpdb->insert($state_table, $cols_n_values, $data_types); |
|
1115 | + if ( ! $success) { |
|
1116 | + 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)); |
|
1117 | 1117 | } |
1118 | 1118 | $state = $cols_n_values; |
1119 | 1119 | $state['STA_ID'] = $wpdb->insert_id; |
@@ -1126,21 +1126,21 @@ discard block |
||
1126 | 1126 | * @param type $timeString |
1127 | 1127 | * @return string in the php DATETIME format: "G:i" (24-hour format hour with leading zeros, a colon, and minutes with leading zeros) |
1128 | 1128 | */ |
1129 | - public function convertTimeFromAMPM($timeString){ |
|
1129 | + public function convertTimeFromAMPM($timeString) { |
|
1130 | 1130 | $matches = array(); |
1131 | - preg_match("~(\\d*):(\\d*)~",$timeString,$matches); |
|
1132 | - if( ! $matches || count($matches)<3){ |
|
1131 | + preg_match("~(\\d*):(\\d*)~", $timeString, $matches); |
|
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 | } |
1139 | - if(strpos($timeString, 'PM') || strpos($timeString, 'pm')){ |
|
1139 | + if (strpos($timeString, 'PM') || strpos($timeString, 'pm')) { |
|
1140 | 1140 | $hour = intval($hour) + 12; |
1141 | 1141 | } |
1142 | - $hour = str_pad( "$hour", 2, '0',STR_PAD_LEFT); |
|
1143 | - $minutes = str_pad( "$minutes", 2, '0',STR_PAD_LEFT); |
|
1142 | + $hour = str_pad("$hour", 2, '0', STR_PAD_LEFT); |
|
1143 | + $minutes = str_pad("$minutes", 2, '0', STR_PAD_LEFT); |
|
1144 | 1144 | return "$hour:$minutes"; |
1145 | 1145 | } |
1146 | 1146 | |
@@ -1149,7 +1149,7 @@ discard block |
||
1149 | 1149 | * @param int $country_id |
1150 | 1150 | * @return string the country's ISO3 code |
1151 | 1151 | */ |
1152 | - public function get_iso_from_3_1_country_id($country_id){ |
|
1152 | + public function get_iso_from_3_1_country_id($country_id) { |
|
1153 | 1153 | $old_countries = array( |
1154 | 1154 | array(64, 'United States', 'US', 'USA', 1), |
1155 | 1155 | array(15, 'Australia', 'AU', 'AUS', 1), |
@@ -1375,9 +1375,9 @@ discard block |
||
1375 | 1375 | array(226, 'Zimbabwe', 'ZW', 'ZWE', 1)); |
1376 | 1376 | |
1377 | 1377 | $country_iso = 'US'; |
1378 | - foreach($old_countries as $country_array){ |
|
1378 | + foreach ($old_countries as $country_array) { |
|
1379 | 1379 | //note: index 0 is the 3.1 country ID |
1380 | - if($country_array[0] == $country_id){ |
|
1380 | + if ($country_array[0] == $country_id) { |
|
1381 | 1381 | //note: index 2 is the ISO |
1382 | 1382 | $country_iso = $country_array[2]; |
1383 | 1383 | break; |
@@ -1390,8 +1390,8 @@ discard block |
||
1390 | 1390 | * Gets the ISO3 for the |
1391 | 1391 | * @return string |
1392 | 1392 | */ |
1393 | - public function get_default_country_iso(){ |
|
1394 | - $old_org_options= get_option('events_organization_settings'); |
|
1393 | + public function get_default_country_iso() { |
|
1394 | + $old_org_options = get_option('events_organization_settings'); |
|
1395 | 1395 | $iso = $this->get_iso_from_3_1_country_id($old_org_options['organization_country']); |
1396 | 1396 | return $iso; |
1397 | 1397 | } |
@@ -1403,13 +1403,13 @@ discard block |
||
1403 | 1403 | * the event's DEFAULT payment status, or the attendee's payment status) required pre-approval. |
1404 | 1404 | * @return string STS_ID for use in 4.1 |
1405 | 1405 | */ |
1406 | - public function convert_3_1_payment_status_to_4_1_STS_ID($payment_status, $this_thing_required_pre_approval = false){ |
|
1406 | + public function convert_3_1_payment_status_to_4_1_STS_ID($payment_status, $this_thing_required_pre_approval = false) { |
|
1407 | 1407 | |
1408 | 1408 | //EE team can read the related discussion: https://app.asana.com/0/2400967562914/9418495544455 |
1409 | - if($this_thing_required_pre_approval){ |
|
1409 | + if ($this_thing_required_pre_approval) { |
|
1410 | 1410 | return 'RNA'; |
1411 | - }else{ |
|
1412 | - $mapping = $default_reg_stati_conversions=array( |
|
1411 | + } else { |
|
1412 | + $mapping = $default_reg_stati_conversions = array( |
|
1413 | 1413 | 'Completed'=>'RAP', |
1414 | 1414 | ''=>'RPP', |
1415 | 1415 | 'Incomplete'=>'RPP', |
@@ -1439,22 +1439,22 @@ discard block |
||
1439 | 1439 | * @param EE_Data_Migration_Script_Stage $migration_stage the stage which called this, where errors should be added |
1440 | 1440 | * @return boolean whether or not we had to do the big job of creating an image attachment |
1441 | 1441 | */ |
1442 | - public function convert_image_url_to_attachment_and_attach_to_post($guid,$new_cpt_id, EE_Data_Migration_Script_Stage $migration_stage){ |
|
1442 | + public function convert_image_url_to_attachment_and_attach_to_post($guid, $new_cpt_id, EE_Data_Migration_Script_Stage $migration_stage) { |
|
1443 | 1443 | $created_attachment_post = false; |
1444 | 1444 | $guid = $this->_get_original_guid($guid); |
1445 | - if($guid){ |
|
1445 | + if ($guid) { |
|
1446 | 1446 | //check for an existing attachment post with this guid |
1447 | 1447 | $attachment_post_id = $this->_get_image_attachment_id_by_GUID($guid); |
1448 | - if( ! $attachment_post_id){ |
|
1448 | + if ( ! $attachment_post_id) { |
|
1449 | 1449 | //post thumbnail with that GUID doesn't exist, we should create one |
1450 | 1450 | $attachment_post_id = $this->_create_image_attachment_from_GUID($guid, $migration_stage); |
1451 | 1451 | $created_attachment_post = true; |
1452 | 1452 | } |
1453 | 1453 | //double-check we actually have an attachment post |
1454 | - if( $attachment_post_id){ |
|
1455 | - update_post_meta($new_cpt_id,'_thumbnail_id',$attachment_post_id); |
|
1456 | - }else{ |
|
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)); |
|
1454 | + if ($attachment_post_id) { |
|
1455 | + update_post_meta($new_cpt_id, '_thumbnail_id', $attachment_post_id); |
|
1456 | + } else { |
|
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 | } |
1460 | 1460 | return $created_attachment_post; |
@@ -1468,13 +1468,13 @@ discard block |
||
1468 | 1468 | * @param string $guid_in_old_event |
1469 | 1469 | * @return string either the original guid, or $guid_in_old_event if we couldn't figure out what the original was |
1470 | 1470 | */ |
1471 | - private function _get_original_guid($guid_in_old_event){ |
|
1472 | - $original_guid = preg_replace('~-\d*x\d*\.~','.',$guid_in_old_event,1); |
|
1471 | + private function _get_original_guid($guid_in_old_event) { |
|
1472 | + $original_guid = preg_replace('~-\d*x\d*\.~', '.', $guid_in_old_event, 1); |
|
1473 | 1473 | //do a head request to verify the file exists |
1474 | 1474 | $head_response = wp_remote_head($original_guid); |
1475 | - if( ! $head_response instanceof WP_Error && $head_response['response']['message'] == 'OK'){ |
|
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 | } |
@@ -1486,32 +1486,32 @@ discard block |
||
1486 | 1486 | * @param EE_Data_Migration_Script_Stage $migration_stage |
1487 | 1487 | * @return int |
1488 | 1488 | */ |
1489 | - private function _create_image_attachment_from_GUID($guid, EE_Data_Migration_Script_Stage $migration_stage){ |
|
1490 | - if ( ! $guid){ |
|
1489 | + private function _create_image_attachment_from_GUID($guid, EE_Data_Migration_Script_Stage $migration_stage) { |
|
1490 | + if ( ! $guid) { |
|
1491 | 1491 | $migration_stage->add_error(sprintf(__("Cannot create image attachment for a blank GUID!", "event_espresso"))); |
1492 | 1492 | return 0; |
1493 | 1493 | } |
1494 | - $wp_filetype = wp_check_filetype(basename($guid), null ); |
|
1494 | + $wp_filetype = wp_check_filetype(basename($guid), null); |
|
1495 | 1495 | $wp_upload_dir = wp_upload_dir(); |
1496 | 1496 | //if the file is located remotely, download it to our uploads DIR, because wp_genereate_attachmnet_metadata needs the file to be local |
1497 | - if(strpos($guid,$wp_upload_dir['url']) === FALSE){ |
|
1497 | + if (strpos($guid, $wp_upload_dir['url']) === FALSE) { |
|
1498 | 1498 | //image is located remotely. download it and place it in the uploads directory |
1499 | - if( ! is_readable($guid)){ |
|
1500 | - $migration_stage->add_error(sprintf(__("Could not create image attachment from non-existent file: %s", "event_espresso"),$guid)); |
|
1499 | + if ( ! is_readable($guid)) { |
|
1500 | + $migration_stage->add_error(sprintf(__("Could not create image attachment from non-existent file: %s", "event_espresso"), $guid)); |
|
1501 | 1501 | return 0; |
1502 | 1502 | } |
1503 | - $contents= file_get_contents($guid); |
|
1504 | - if($contents === FALSE){ |
|
1505 | - $migration_stage->add_error(sprintf(__("Could not read image at %s, and therefore couldnt create an attachment post for it.", "event_espresso"),$guid)); |
|
1503 | + $contents = file_get_contents($guid); |
|
1504 | + if ($contents === FALSE) { |
|
1505 | + $migration_stage->add_error(sprintf(__("Could not read image at %s, and therefore couldnt create an attachment post for it.", "event_espresso"), $guid)); |
|
1506 | 1506 | return false; |
1507 | 1507 | } |
1508 | - $local_filepath = $wp_upload_dir['path'].DS.basename($guid); |
|
1508 | + $local_filepath = $wp_upload_dir['path'].DS.basename($guid); |
|
1509 | 1509 | $savefile = fopen($local_filepath, 'w'); |
1510 | 1510 | fwrite($savefile, $contents); |
1511 | 1511 | fclose($savefile); |
1512 | - $guid = str_replace($wp_upload_dir['path'],$wp_upload_dir['url'],$local_filepath); |
|
1513 | - }else{ |
|
1514 | - $local_filepath = str_replace($wp_upload_dir['url'],$wp_upload_dir['path'],$guid); |
|
1512 | + $guid = str_replace($wp_upload_dir['path'], $wp_upload_dir['url'], $local_filepath); |
|
1513 | + } else { |
|
1514 | + $local_filepath = str_replace($wp_upload_dir['url'], $wp_upload_dir['path'], $guid); |
|
1515 | 1515 | } |
1516 | 1516 | |
1517 | 1517 | $attachment = array( |
@@ -1521,24 +1521,24 @@ discard block |
||
1521 | 1521 | 'post_content' => '', |
1522 | 1522 | 'post_status' => 'inherit' |
1523 | 1523 | ); |
1524 | - $attach_id = wp_insert_attachment( $attachment, $guid ); |
|
1525 | - if( ! $attach_id ){ |
|
1526 | - $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))); |
|
1524 | + $attach_id = wp_insert_attachment($attachment, $guid); |
|
1525 | + if ( ! $attach_id) { |
|
1526 | + $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))); |
|
1527 | 1527 | return $attach_id; |
1528 | 1528 | } |
1529 | 1529 | |
1530 | 1530 | // you must first include the image.php file |
1531 | 1531 | // for the function wp_generate_attachment_metadata() to work |
1532 | - require_once(ABSPATH . 'wp-admin/includes/image.php'); |
|
1532 | + require_once(ABSPATH.'wp-admin/includes/image.php'); |
|
1533 | 1533 | |
1534 | - $attach_data = wp_generate_attachment_metadata( $attach_id, $local_filepath ); |
|
1535 | - if( ! $attach_data){ |
|
1536 | - $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)); |
|
1534 | + $attach_data = wp_generate_attachment_metadata($attach_id, $local_filepath); |
|
1535 | + if ( ! $attach_data) { |
|
1536 | + $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)); |
|
1537 | 1537 | return $attach_id; |
1538 | 1538 | } |
1539 | - $metadata_save_result = wp_update_attachment_metadata( $attach_id, $attach_data ); |
|
1540 | - if( ! $metadata_save_result ){ |
|
1541 | - $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))); |
|
1539 | + $metadata_save_result = wp_update_attachment_metadata($attach_id, $attach_data); |
|
1540 | + if ( ! $metadata_save_result) { |
|
1541 | + $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))); |
|
1542 | 1542 | } |
1543 | 1543 | return $attach_id; |
1544 | 1544 | } |
@@ -1550,9 +1550,9 @@ discard block |
||
1550 | 1550 | * @param string $guid |
1551 | 1551 | * @return int |
1552 | 1552 | */ |
1553 | - private function _get_image_attachment_id_by_GUID($guid){ |
|
1553 | + private function _get_image_attachment_id_by_GUID($guid) { |
|
1554 | 1554 | global $wpdb; |
1555 | - $attachment_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid=%s LIMIT 1",$guid)); |
|
1555 | + $attachment_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid=%s LIMIT 1", $guid)); |
|
1556 | 1556 | return $attachment_id; |
1557 | 1557 | } |
1558 | 1558 | /** |
@@ -1564,20 +1564,20 @@ discard block |
||
1564 | 1564 | * @param string $timezone |
1565 | 1565 | * @return string |
1566 | 1566 | */ |
1567 | - public function convert_date_string_to_utc(EE_Data_Migration_Script_Stage $stage, $row_of_data, $DATETIME_string,$timezone = null){ |
|
1567 | + public function convert_date_string_to_utc(EE_Data_Migration_Script_Stage $stage, $row_of_data, $DATETIME_string, $timezone = null) { |
|
1568 | 1568 | $original_tz = $timezone; |
1569 | - if( ! $timezone){ |
|
1569 | + if ( ! $timezone) { |
|
1570 | 1570 | $timezone = $this->_get_wp_timezone(); |
1571 | 1571 | } |
1572 | - if( ! $timezone){ |
|
1573 | - $stage->add_error(sprintf(__("Could not find timezone given %s for %s", "event_espresso"),$original_tz,$row_of_data)); |
|
1572 | + if ( ! $timezone) { |
|
1573 | + $stage->add_error(sprintf(__("Could not find timezone given %s for %s", "event_espresso"), $original_tz, $row_of_data)); |
|
1574 | 1574 | $timezone = 'UTC'; |
1575 | 1575 | } |
1576 | - try{ |
|
1577 | - $date_obj = new DateTime( $DATETIME_string, new DateTimeZone( $timezone ) ); |
|
1576 | + try { |
|
1577 | + $date_obj = new DateTime($DATETIME_string, new DateTimeZone($timezone)); |
|
1578 | 1578 | $date_obj->setTimezone(new DateTimeZone('UTC')); |
1579 | - }catch(Exception $e){ |
|
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)); |
|
1579 | + } catch (Exception $e) { |
|
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 | } |
1583 | 1583 | |
@@ -1588,14 +1588,14 @@ discard block |
||
1588 | 1588 | * Gets the DEFAULT timezone string from wordpress (even if they set a gmt offset) |
1589 | 1589 | * @return string |
1590 | 1590 | */ |
1591 | - private function _get_wp_timezone(){ |
|
1592 | - $timezone = empty( $timezone ) ? get_option('timezone_string') : $timezone; |
|
1591 | + private function _get_wp_timezone() { |
|
1592 | + $timezone = empty($timezone) ? get_option('timezone_string') : $timezone; |
|
1593 | 1593 | |
1594 | 1594 | //if timezone is STILL empty then let's get the GMT offset and then set the timezone_string using our converter |
1595 | - if ( empty( $timezone ) ) { |
|
1595 | + if (empty($timezone)) { |
|
1596 | 1596 | //let's get a the WordPress UTC offset |
1597 | 1597 | $offset = get_option('gmt_offset'); |
1598 | - $timezone = $this->timezone_convert_to_string_from_offset( $offset ); |
|
1598 | + $timezone = $this->timezone_convert_to_string_from_offset($offset); |
|
1599 | 1599 | } |
1600 | 1600 | return $timezone; |
1601 | 1601 | } |
@@ -1604,11 +1604,11 @@ discard block |
||
1604 | 1604 | * @param int $offset |
1605 | 1605 | * @return boolean |
1606 | 1606 | */ |
1607 | - private function timezone_convert_to_string_from_offset($offset){ |
|
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 | 1610 | $abbrarray = timezone_abbreviations_list(); |
1611 | - foreach ($abbrarray as $abbr){ |
|
1611 | + foreach ($abbrarray as $abbr) { |
|
1612 | 1612 | foreach ($abbr as $city) |
1613 | 1613 | { |
1614 | 1614 | if ($city['offset'] == $offset) |
@@ -1622,32 +1622,32 @@ discard block |
||
1622 | 1622 | return FALSE; |
1623 | 1623 | } |
1624 | 1624 | |
1625 | - public function migration_page_hooks(){ |
|
1626 | - add_filter('FHEE__ee_migration_page__header',array($this,'_migrate_page_hook_simplify_version_strings'),10,3); |
|
1627 | - add_filter('FHEE__ee_migration_page__p_after_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2); |
|
1628 | - add_filter('FHEE__ee_migration_page__option_1_main',array($this,'_migrate_page_hook_simplify_version_strings'),10,3); |
|
1629 | - add_filter('FHEE__ee_migration_page__option_1_button_text',array($this,'_migrate_page_hook_simplify_version_strings'),10,3); |
|
1630 | - add_action('AHEE__ee_migration_page__option_1_extra_details',array($this,'_migration_page_hook_option_1_extra_details'),10,3); |
|
1631 | - add_filter('FHEE__ee_migration_page__option_2_main',array($this,'_migrate_page_hook_simplify_version_strings'),10,4); |
|
1632 | - add_filter('FHEE__ee_migration_page__option_2_button_text',array($this,'_migration_page_hook_simplify_next_db_state'),10,2); |
|
1633 | - add_filter('FHEE__ee_migration_page__option_2_details',array($this,'_migration_page_hook_simplify_next_db_state'),10,2); |
|
1634 | - add_action('AHEE__ee_migration_page__after_migration_options_table',array($this,'_migration_page_hook_after_migration_options_table')); |
|
1635 | - add_filter('FHEE__ee_migration_page__done_migration_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2); |
|
1636 | - add_filter('FHEE__ee_migration_page__p_after_done_migration_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2); |
|
1625 | + public function migration_page_hooks() { |
|
1626 | + add_filter('FHEE__ee_migration_page__header', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3); |
|
1627 | + add_filter('FHEE__ee_migration_page__p_after_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2); |
|
1628 | + add_filter('FHEE__ee_migration_page__option_1_main', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3); |
|
1629 | + add_filter('FHEE__ee_migration_page__option_1_button_text', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3); |
|
1630 | + add_action('AHEE__ee_migration_page__option_1_extra_details', array($this, '_migration_page_hook_option_1_extra_details'), 10, 3); |
|
1631 | + add_filter('FHEE__ee_migration_page__option_2_main', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 4); |
|
1632 | + add_filter('FHEE__ee_migration_page__option_2_button_text', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2); |
|
1633 | + add_filter('FHEE__ee_migration_page__option_2_details', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2); |
|
1634 | + add_action('AHEE__ee_migration_page__after_migration_options_table', array($this, '_migration_page_hook_after_migration_options_table')); |
|
1635 | + add_filter('FHEE__ee_migration_page__done_migration_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2); |
|
1636 | + add_filter('FHEE__ee_migration_page__p_after_done_migration_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2); |
|
1637 | 1637 | } |
1638 | 1638 | |
1639 | - public function _migrate_page_hook_simplify_version_strings($old_content,$current_db_state,$next_db_state,$ultimate_db_state = NULL){ |
|
1640 | - 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); |
|
1639 | + public function _migrate_page_hook_simplify_version_strings($old_content, $current_db_state, $next_db_state, $ultimate_db_state = NULL) { |
|
1640 | + 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); |
|
1641 | 1641 | } |
1642 | - public function _migration_page_hook_simplify_next_db_state($old_content,$next_db_state){ |
|
1643 | - return str_replace($next_db_state, __("EE4", 'event_espresso'),$old_content); |
|
1642 | + public function _migration_page_hook_simplify_next_db_state($old_content, $next_db_state) { |
|
1643 | + return str_replace($next_db_state, __("EE4", 'event_espresso'), $old_content); |
|
1644 | 1644 | } |
1645 | - public function _migration_page_hook_option_1_extra_details(){ |
|
1646 | - ?><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 |
|
1645 | + public function _migration_page_hook_option_1_extra_details() { |
|
1646 | + ?><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 |
|
1647 | 1647 | } |
1648 | - public function _migration_page_hook_after_migration_options_table(){ |
|
1648 | + public function _migration_page_hook_after_migration_options_table() { |
|
1649 | 1649 | ?><p class="ee-attention"> |
1650 | - <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 | + <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"); ?> |
|
1651 | 1651 | </p><?php |
1652 | 1652 | } |
1653 | 1653 | } |
@@ -72,7 +72,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | } |
@@ -77,7 +77,7 @@ discard block |
||
77 | 77 | * Set Answer value |
78 | 78 | * |
79 | 79 | * @access public |
80 | - * @param mixed $ANS_value |
|
80 | + * @param string $ANS_value |
|
81 | 81 | */ |
82 | 82 | public function set_value( $ANS_value = '' ) { |
83 | 83 | $this->set( 'ANS_value', $ANS_value ); |
@@ -89,7 +89,7 @@ discard block |
||
89 | 89 | * get Attendee First Name |
90 | 90 | * |
91 | 91 | * @access public |
92 | - * @return int |
|
92 | + * @return boolean |
|
93 | 93 | */ |
94 | 94 | public function registration_ID() { |
95 | 95 | return $this->get( 'REG_ID' ); |
@@ -101,7 +101,7 @@ discard block |
||
101 | 101 | * get Attendee Last Name |
102 | 102 | * |
103 | 103 | * @access public |
104 | - * @return int |
|
104 | + * @return boolean |
|
105 | 105 | */ |
106 | 106 | public function question_ID() { |
107 | 107 | return $this->get( 'QST_ID' ); |
@@ -113,7 +113,7 @@ discard block |
||
113 | 113 | * get Attendee Address |
114 | 114 | * |
115 | 115 | * @access public |
116 | - * @return string |
|
116 | + * @return boolean |
|
117 | 117 | */ |
118 | 118 | public function value() { |
119 | 119 | return $this->get( 'ANS_value' ); |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
2 | - exit( 'No direct script access allowed' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | 3 | } |
4 | 4 | /** |
5 | 5 | * Event Espresso |
@@ -31,9 +31,9 @@ discard block |
||
31 | 31 | * @param array $props_n_values |
32 | 32 | * @return EE_Answer |
33 | 33 | */ |
34 | - public static function new_instance( $props_n_values = array() ) { |
|
35 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__ ); |
|
36 | - return $has_object ? $has_object : new self( $props_n_values ); |
|
34 | + public static function new_instance($props_n_values = array()) { |
|
35 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__); |
|
36 | + return $has_object ? $has_object : new self($props_n_values); |
|
37 | 37 | } |
38 | 38 | |
39 | 39 | |
@@ -43,8 +43,8 @@ discard block |
||
43 | 43 | * @param array $props_n_values |
44 | 44 | * @return EE_Answer |
45 | 45 | */ |
46 | - public static function new_instance_from_db( $props_n_values = array() ) { |
|
47 | - return new self( $props_n_values, TRUE ); |
|
46 | + public static function new_instance_from_db($props_n_values = array()) { |
|
47 | + return new self($props_n_values, TRUE); |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | |
@@ -55,8 +55,8 @@ discard block |
||
55 | 55 | * @access public |
56 | 56 | * @param int $QST_ID |
57 | 57 | */ |
58 | - public function set_question( $QST_ID = 0 ) { |
|
59 | - $this->set( 'QST_ID', $QST_ID ); |
|
58 | + public function set_question($QST_ID = 0) { |
|
59 | + $this->set('QST_ID', $QST_ID); |
|
60 | 60 | } |
61 | 61 | |
62 | 62 | |
@@ -67,8 +67,8 @@ discard block |
||
67 | 67 | * @access public |
68 | 68 | * @param int $REG_ID |
69 | 69 | */ |
70 | - public function set_registration( $REG_ID = 0 ) { |
|
71 | - $this->set( 'REG_ID', $REG_ID ); |
|
70 | + public function set_registration($REG_ID = 0) { |
|
71 | + $this->set('REG_ID', $REG_ID); |
|
72 | 72 | } |
73 | 73 | |
74 | 74 | |
@@ -79,8 +79,8 @@ discard block |
||
79 | 79 | * @access public |
80 | 80 | * @param mixed $ANS_value |
81 | 81 | */ |
82 | - public function set_value( $ANS_value = '' ) { |
|
83 | - $this->set( 'ANS_value', $ANS_value ); |
|
82 | + public function set_value($ANS_value = '') { |
|
83 | + $this->set('ANS_value', $ANS_value); |
|
84 | 84 | } |
85 | 85 | |
86 | 86 | |
@@ -92,7 +92,7 @@ discard block |
||
92 | 92 | * @return int |
93 | 93 | */ |
94 | 94 | public function registration_ID() { |
95 | - return $this->get( 'REG_ID' ); |
|
95 | + return $this->get('REG_ID'); |
|
96 | 96 | } |
97 | 97 | |
98 | 98 | |
@@ -104,7 +104,7 @@ discard block |
||
104 | 104 | * @return int |
105 | 105 | */ |
106 | 106 | public function question_ID() { |
107 | - return $this->get( 'QST_ID' ); |
|
107 | + return $this->get('QST_ID'); |
|
108 | 108 | } |
109 | 109 | |
110 | 110 | |
@@ -116,7 +116,7 @@ discard block |
||
116 | 116 | * @return string |
117 | 117 | */ |
118 | 118 | public function value() { |
119 | - return $this->get( 'ANS_value' ); |
|
119 | + return $this->get('ANS_value'); |
|
120 | 120 | } |
121 | 121 | |
122 | 122 | |
@@ -126,8 +126,8 @@ discard block |
||
126 | 126 | * @param null $schema |
127 | 127 | * @return string |
128 | 128 | */ |
129 | - public function pretty_value( $schema = NULL ) { |
|
130 | - return $this->get_pretty( 'ANS_value', $schema ); |
|
129 | + public function pretty_value($schema = NULL) { |
|
130 | + return $this->get_pretty('ANS_value', $schema); |
|
131 | 131 | } |
132 | 132 | |
133 | 133 | |
@@ -136,8 +136,8 @@ discard block |
||
136 | 136 | * Echoes out a pretty value (even for multi-choice options) |
137 | 137 | * @param string $schema |
138 | 138 | */ |
139 | - public function e_value( $schema = NULL ) { |
|
140 | - $this->e( 'ANS_value', $schema ); |
|
139 | + public function e_value($schema = NULL) { |
|
140 | + $this->e('ANS_value', $schema); |
|
141 | 141 | } |
142 | 142 | |
143 | 143 | |
@@ -147,7 +147,7 @@ discard block |
||
147 | 147 | * @return EE_Question |
148 | 148 | */ |
149 | 149 | public function question() { |
150 | - return $this->get_first_related( 'Question' ); |
|
150 | + return $this->get_first_related('Question'); |
|
151 | 151 | } |
152 | 152 | |
153 | 153 | |
@@ -157,7 +157,7 @@ discard block |
||
157 | 157 | * @return EE_Registration |
158 | 158 | */ |
159 | 159 | public function registration() { |
160 | - return $this->get_first_related( 'Registration' ); |
|
160 | + return $this->get_first_related('Registration'); |
|
161 | 161 | } |
162 | 162 | } |
163 | 163 |
@@ -216,7 +216,7 @@ discard block |
||
216 | 216 | * |
217 | 217 | * @since 4.5.0 |
218 | 218 | * |
219 | - * @return int |
|
219 | + * @return boolean |
|
220 | 220 | */ |
221 | 221 | public function wp_user() { |
222 | 222 | return $this->get( 'ATT_author' ); |
@@ -227,7 +227,7 @@ discard block |
||
227 | 227 | /** |
228 | 228 | * get Attendee First Name |
229 | 229 | * @access public |
230 | - * @return string |
|
230 | + * @return boolean |
|
231 | 231 | */ |
232 | 232 | public function fname() { |
233 | 233 | return $this->get( 'ATT_fname' ); |
@@ -260,7 +260,7 @@ discard block |
||
260 | 260 | /** |
261 | 261 | * get Attendee Last Name |
262 | 262 | * @access public |
263 | - * @return string |
|
263 | + * @return boolean |
|
264 | 264 | */ |
265 | 265 | public function lname() { |
266 | 266 | return $this->get( 'ATT_lname' ); |
@@ -305,7 +305,7 @@ discard block |
||
305 | 305 | |
306 | 306 | /** |
307 | 307 | * get Attendee Address |
308 | - * @return string |
|
308 | + * @return boolean |
|
309 | 309 | */ |
310 | 310 | public function address() { |
311 | 311 | return $this->get( 'ATT_address' ); |
@@ -315,7 +315,7 @@ discard block |
||
315 | 315 | |
316 | 316 | /** |
317 | 317 | * get Attendee Address2 |
318 | - * @return string |
|
318 | + * @return boolean |
|
319 | 319 | */ |
320 | 320 | public function address2() { |
321 | 321 | return $this->get( 'ATT_address2' ); |
@@ -325,7 +325,7 @@ discard block |
||
325 | 325 | |
326 | 326 | /** |
327 | 327 | * get Attendee City |
328 | - * @return string |
|
328 | + * @return boolean |
|
329 | 329 | */ |
330 | 330 | public function city() { |
331 | 331 | return $this->get( 'ATT_city' ); |
@@ -335,7 +335,7 @@ discard block |
||
335 | 335 | |
336 | 336 | /** |
337 | 337 | * get Attendee State ID |
338 | - * @return string |
|
338 | + * @return boolean |
|
339 | 339 | */ |
340 | 340 | public function state_ID() { |
341 | 341 | return $this->get( 'STA_ID' ); |
@@ -392,7 +392,7 @@ discard block |
||
392 | 392 | |
393 | 393 | /** |
394 | 394 | * get Attendee Country ISO Code |
395 | - * @return string |
|
395 | + * @return boolean |
|
396 | 396 | */ |
397 | 397 | public function country_ID() { |
398 | 398 | return $this->get( 'CNT_ISO' ); |
@@ -440,7 +440,7 @@ discard block |
||
440 | 440 | |
441 | 441 | /** |
442 | 442 | * get Attendee Zip/Postal Code |
443 | - * @return string |
|
443 | + * @return boolean |
|
444 | 444 | */ |
445 | 445 | public function zip() { |
446 | 446 | return $this->get( 'ATT_zip' ); |
@@ -450,7 +450,7 @@ discard block |
||
450 | 450 | |
451 | 451 | /** |
452 | 452 | * get Attendee Email Address |
453 | - * @return string |
|
453 | + * @return boolean |
|
454 | 454 | */ |
455 | 455 | public function email() { |
456 | 456 | return $this->get( 'ATT_email' ); |
@@ -460,7 +460,7 @@ discard block |
||
460 | 460 | |
461 | 461 | /** |
462 | 462 | * get Attendee Phone # |
463 | - * @return string |
|
463 | + * @return boolean |
|
464 | 464 | */ |
465 | 465 | public function phone() { |
466 | 466 | return $this->get( 'ATT_phone' ); |
@@ -512,7 +512,7 @@ discard block |
||
512 | 512 | |
513 | 513 | /** |
514 | 514 | * returns any events attached to this attendee ($_Event property); |
515 | - * @return array |
|
515 | + * @return EE_Base_Class[] |
|
516 | 516 | */ |
517 | 517 | public function events() { |
518 | 518 | return $this->get_many_related( 'Event' ); |
@@ -522,7 +522,7 @@ discard block |
||
522 | 522 | * Gets the billing info array where keys match espresso_reg_page_billing_inputs(), |
523 | 523 | * and keys are their cleaned values. @see EE_Attendee::save_and_clean_billing_info_for_payment_method() which was used to save the billing info |
524 | 524 | * @param EE_Payment_Method $payment_method the _gateway_name property on the gateway class |
525 | - * @return EE_Form_Section_Proper |
|
525 | + * @return null|EE_Billing_Info_Form |
|
526 | 526 | */ |
527 | 527 | public function billing_info_for_payment_method($payment_method){ |
528 | 528 | $pm_type = $payment_method->type_obj(); |
@@ -367,7 +367,7 @@ discard block |
||
367 | 367 | public function state_name(){ |
368 | 368 | if( $this->state_obj() ){ |
369 | 369 | return $this->state_obj()->name(); |
370 | - }else{ |
|
370 | + } else{ |
|
371 | 371 | return __( 'Unknown', 'event_espresso' ); |
372 | 372 | } |
373 | 373 | } |
@@ -415,7 +415,7 @@ discard block |
||
415 | 415 | public function country_name(){ |
416 | 416 | if( $this->country_obj() ){ |
417 | 417 | return $this->country_obj()->name(); |
418 | - }else{ |
|
418 | + } else{ |
|
419 | 419 | return __( 'Unknown', 'event_espresso' ); |
420 | 420 | } |
421 | 421 | } |
@@ -547,7 +547,7 @@ discard block |
||
547 | 547 | public function get_billing_info_postmeta_name($payment_method){ |
548 | 548 | if( $payment_method->type_obj() instanceof EE_PMT_Base ){ |
549 | 549 | return 'billing_info_' . $payment_method->type_obj()->system_name(); |
550 | - }else{ |
|
550 | + } else{ |
|
551 | 551 | return NULL; |
552 | 552 | } |
553 | 553 | } |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
2 | - exit( 'No direct script access allowed' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | 3 | } |
4 | 4 | /** |
5 | 5 | * Event Espresso |
@@ -32,20 +32,20 @@ discard block |
||
32 | 32 | * @param bool $bydb |
33 | 33 | * @param string $timezone |
34 | 34 | */ |
35 | - protected function __construct( $fieldValues = NULL, $bydb = FALSE, $timezone = NULL ) { |
|
36 | - if ( !isset( $fieldValues[ 'ATT_full_name' ] ) ) { |
|
37 | - $fname = isset( $fieldValues[ 'ATT_fname' ] ) ? $fieldValues[ 'ATT_fname' ] . ' ' : ''; |
|
38 | - $lname = isset( $fieldValues[ 'ATT_lname' ] ) ? $fieldValues[ 'ATT_lname' ] : ''; |
|
39 | - $fieldValues[ 'ATT_full_name' ] = $fname . $lname; |
|
35 | + protected function __construct($fieldValues = NULL, $bydb = FALSE, $timezone = NULL) { |
|
36 | + if ( ! isset($fieldValues['ATT_full_name'])) { |
|
37 | + $fname = isset($fieldValues['ATT_fname']) ? $fieldValues['ATT_fname'].' ' : ''; |
|
38 | + $lname = isset($fieldValues['ATT_lname']) ? $fieldValues['ATT_lname'] : ''; |
|
39 | + $fieldValues['ATT_full_name'] = $fname.$lname; |
|
40 | 40 | } |
41 | - if ( !isset( $fieldValues[ 'ATT_slug' ] ) ) { |
|
41 | + if ( ! isset($fieldValues['ATT_slug'])) { |
|
42 | 42 | // $fieldValues['ATT_slug'] = sanitize_key(wp_generate_password(20)); |
43 | - $fieldValues[ 'ATT_slug' ] = sanitize_title( $fieldValues[ 'ATT_full_name' ] ); |
|
43 | + $fieldValues['ATT_slug'] = sanitize_title($fieldValues['ATT_full_name']); |
|
44 | 44 | } |
45 | - if ( !isset( $fieldValues[ 'ATT_short_bio' ] ) && isset( $fieldValues[ 'ATT_bio' ] ) ) { |
|
46 | - $fieldValues[ 'ATT_short_bio' ] = substr( $fieldValues[ 'ATT_bio' ], 0, 50 ); |
|
45 | + if ( ! isset($fieldValues['ATT_short_bio']) && isset($fieldValues['ATT_bio'])) { |
|
46 | + $fieldValues['ATT_short_bio'] = substr($fieldValues['ATT_bio'], 0, 50); |
|
47 | 47 | } |
48 | - parent::__construct( $fieldValues, $bydb, $timezone ); |
|
48 | + parent::__construct($fieldValues, $bydb, $timezone); |
|
49 | 49 | } |
50 | 50 | |
51 | 51 | |
@@ -55,10 +55,10 @@ discard block |
||
55 | 55 | * @param array $props_n_values |
56 | 56 | * @return EE_Attendee |
57 | 57 | */ |
58 | - public static function new_instance( $props_n_values = array() ) { |
|
58 | + public static function new_instance($props_n_values = array()) { |
|
59 | 59 | $classname = __CLASS__; |
60 | - $has_object = parent::_check_for_object( $props_n_values, $classname ); |
|
61 | - return $has_object ? $has_object : new self( $props_n_values ); |
|
60 | + $has_object = parent::_check_for_object($props_n_values, $classname); |
|
61 | + return $has_object ? $has_object : new self($props_n_values); |
|
62 | 62 | } |
63 | 63 | |
64 | 64 | |
@@ -67,8 +67,8 @@ discard block |
||
67 | 67 | * @param array $props_n_values |
68 | 68 | * @return EE_Attendee |
69 | 69 | */ |
70 | - public static function new_instance_from_db( $props_n_values = array() ) { |
|
71 | - return new self( $props_n_values, TRUE ); |
|
70 | + public static function new_instance_from_db($props_n_values = array()) { |
|
71 | + return new self($props_n_values, TRUE); |
|
72 | 72 | } |
73 | 73 | |
74 | 74 | |
@@ -79,8 +79,8 @@ discard block |
||
79 | 79 | * @access public |
80 | 80 | * @param string $fname |
81 | 81 | */ |
82 | - public function set_fname( $fname = '' ) { |
|
83 | - $this->set( 'ATT_fname', $fname ); |
|
82 | + public function set_fname($fname = '') { |
|
83 | + $this->set('ATT_fname', $fname); |
|
84 | 84 | } |
85 | 85 | |
86 | 86 | |
@@ -91,8 +91,8 @@ discard block |
||
91 | 91 | * @access public |
92 | 92 | * @param string $lname |
93 | 93 | */ |
94 | - public function set_lname( $lname = '' ) { |
|
95 | - $this->set( 'ATT_lname', $lname ); |
|
94 | + public function set_lname($lname = '') { |
|
95 | + $this->set('ATT_lname', $lname); |
|
96 | 96 | } |
97 | 97 | |
98 | 98 | |
@@ -103,8 +103,8 @@ discard block |
||
103 | 103 | * @access public |
104 | 104 | * @param string $address |
105 | 105 | */ |
106 | - public function set_address( $address = '' ) { |
|
107 | - $this->set( 'ATT_address', $address ); |
|
106 | + public function set_address($address = '') { |
|
107 | + $this->set('ATT_address', $address); |
|
108 | 108 | } |
109 | 109 | |
110 | 110 | |
@@ -115,8 +115,8 @@ discard block |
||
115 | 115 | * @access public |
116 | 116 | * @param string $address2 |
117 | 117 | */ |
118 | - public function set_address2( $address2 = '' ) { |
|
119 | - $this->set( 'ATT_address2', $address2 ); |
|
118 | + public function set_address2($address2 = '') { |
|
119 | + $this->set('ATT_address2', $address2); |
|
120 | 120 | } |
121 | 121 | |
122 | 122 | |
@@ -127,8 +127,8 @@ discard block |
||
127 | 127 | * @access public |
128 | 128 | * @param string $city |
129 | 129 | */ |
130 | - public function set_city( $city = '' ) { |
|
131 | - $this->set( 'ATT_city', $city ); |
|
130 | + public function set_city($city = '') { |
|
131 | + $this->set('ATT_city', $city); |
|
132 | 132 | } |
133 | 133 | |
134 | 134 | |
@@ -139,8 +139,8 @@ discard block |
||
139 | 139 | * @access public |
140 | 140 | * @param int $STA_ID |
141 | 141 | */ |
142 | - public function set_state( $STA_ID = 0 ) { |
|
143 | - $this->set( 'STA_ID', $STA_ID ); |
|
142 | + public function set_state($STA_ID = 0) { |
|
143 | + $this->set('STA_ID', $STA_ID); |
|
144 | 144 | } |
145 | 145 | |
146 | 146 | |
@@ -151,8 +151,8 @@ discard block |
||
151 | 151 | * @access public |
152 | 152 | * @param string $CNT_ISO |
153 | 153 | */ |
154 | - public function set_country( $CNT_ISO = '' ) { |
|
155 | - $this->set( 'CNT_ISO', $CNT_ISO ); |
|
154 | + public function set_country($CNT_ISO = '') { |
|
155 | + $this->set('CNT_ISO', $CNT_ISO); |
|
156 | 156 | } |
157 | 157 | |
158 | 158 | |
@@ -163,8 +163,8 @@ discard block |
||
163 | 163 | * @access public |
164 | 164 | * @param string $zip |
165 | 165 | */ |
166 | - public function set_zip( $zip = '' ) { |
|
167 | - $this->set( 'ATT_zip', $zip ); |
|
166 | + public function set_zip($zip = '') { |
|
167 | + $this->set('ATT_zip', $zip); |
|
168 | 168 | } |
169 | 169 | |
170 | 170 | |
@@ -175,8 +175,8 @@ discard block |
||
175 | 175 | * @access public |
176 | 176 | * @param string $email |
177 | 177 | */ |
178 | - public function set_email( $email = '' ) { |
|
179 | - $this->set( 'ATT_email', $email ); |
|
178 | + public function set_email($email = '') { |
|
179 | + $this->set('ATT_email', $email); |
|
180 | 180 | } |
181 | 181 | |
182 | 182 | |
@@ -187,8 +187,8 @@ discard block |
||
187 | 187 | * @access public |
188 | 188 | * @param string $phone |
189 | 189 | */ |
190 | - public function set_phone( $phone = '' ) { |
|
191 | - $this->set( 'ATT_phone', $phone ); |
|
190 | + public function set_phone($phone = '') { |
|
191 | + $this->set('ATT_phone', $phone); |
|
192 | 192 | } |
193 | 193 | |
194 | 194 | |
@@ -199,8 +199,8 @@ discard block |
||
199 | 199 | * @access public |
200 | 200 | * @param bool $ATT_deleted |
201 | 201 | */ |
202 | - public function set_deleted( $ATT_deleted = FALSE ) { |
|
203 | - $this->set( 'ATT_deleted', $ATT_deleted ); |
|
202 | + public function set_deleted($ATT_deleted = FALSE) { |
|
203 | + $this->set('ATT_deleted', $ATT_deleted); |
|
204 | 204 | } |
205 | 205 | |
206 | 206 | |
@@ -213,7 +213,7 @@ discard block |
||
213 | 213 | * @return int |
214 | 214 | */ |
215 | 215 | public function wp_user() { |
216 | - return $this->get( 'ATT_author' ); |
|
216 | + return $this->get('ATT_author'); |
|
217 | 217 | } |
218 | 218 | |
219 | 219 | |
@@ -224,7 +224,7 @@ discard block |
||
224 | 224 | * @return string |
225 | 225 | */ |
226 | 226 | public function fname() { |
227 | - return $this->get( 'ATT_fname' ); |
|
227 | + return $this->get('ATT_fname'); |
|
228 | 228 | } |
229 | 229 | |
230 | 230 | |
@@ -244,9 +244,9 @@ discard block |
||
244 | 244 | * @param bool $apply_html_entities |
245 | 245 | * @return string |
246 | 246 | */ |
247 | - public function full_name( $apply_html_entities = FALSE ) { |
|
248 | - $full_name = $this->fname() . ' ' . $this->lname(); |
|
249 | - return $apply_html_entities ? htmlentities( $full_name, ENT_QUOTES, 'UTF-8' ) : $full_name; |
|
247 | + public function full_name($apply_html_entities = FALSE) { |
|
248 | + $full_name = $this->fname().' '.$this->lname(); |
|
249 | + return $apply_html_entities ? htmlentities($full_name, ENT_QUOTES, 'UTF-8') : $full_name; |
|
250 | 250 | } |
251 | 251 | |
252 | 252 | |
@@ -257,7 +257,7 @@ discard block |
||
257 | 257 | * @return string |
258 | 258 | */ |
259 | 259 | public function lname() { |
260 | - return $this->get( 'ATT_lname' ); |
|
260 | + return $this->get('ATT_lname'); |
|
261 | 261 | } |
262 | 262 | |
263 | 263 | |
@@ -271,26 +271,26 @@ discard block |
||
271 | 271 | */ |
272 | 272 | public function full_address_as_array() { |
273 | 273 | $full_address_array = array(); |
274 | - $initial_address_fields = array( 'ATT_address', 'ATT_address2', 'ATT_city', ); |
|
275 | - foreach ( $initial_address_fields as $address_field_name ) { |
|
276 | - $address_fields_value = $this->get( $address_field_name ); |
|
277 | - if ( !empty( $address_fields_value ) ) { |
|
278 | - $full_address_array[ ] = $address_fields_value; |
|
274 | + $initial_address_fields = array('ATT_address', 'ATT_address2', 'ATT_city',); |
|
275 | + foreach ($initial_address_fields as $address_field_name) { |
|
276 | + $address_fields_value = $this->get($address_field_name); |
|
277 | + if ( ! empty($address_fields_value)) { |
|
278 | + $full_address_array[] = $address_fields_value; |
|
279 | 279 | } |
280 | 280 | } |
281 | 281 | //now handle state and country |
282 | 282 | $state_obj = $this->state_obj(); |
283 | - if ( !empty( $state_obj ) ) { |
|
284 | - $full_address_array[ ] = $state_obj->name(); |
|
283 | + if ( ! empty($state_obj)) { |
|
284 | + $full_address_array[] = $state_obj->name(); |
|
285 | 285 | } |
286 | 286 | $country_obj = $this->country_obj(); |
287 | - if ( !empty( $country_obj ) ) { |
|
288 | - $full_address_array[ ] = $country_obj->name(); |
|
287 | + if ( ! empty($country_obj)) { |
|
288 | + $full_address_array[] = $country_obj->name(); |
|
289 | 289 | } |
290 | 290 | //lastly get the xip |
291 | 291 | $zip_value = $this->zip(); |
292 | - if ( !empty( $zip_value ) ) { |
|
293 | - $full_address_array[ ] = $zip_value; |
|
292 | + if ( ! empty($zip_value)) { |
|
293 | + $full_address_array[] = $zip_value; |
|
294 | 294 | } |
295 | 295 | return $full_address_array; |
296 | 296 | } |
@@ -302,7 +302,7 @@ discard block |
||
302 | 302 | * @return string |
303 | 303 | */ |
304 | 304 | public function address() { |
305 | - return $this->get( 'ATT_address' ); |
|
305 | + return $this->get('ATT_address'); |
|
306 | 306 | } |
307 | 307 | |
308 | 308 | |
@@ -312,7 +312,7 @@ discard block |
||
312 | 312 | * @return string |
313 | 313 | */ |
314 | 314 | public function address2() { |
315 | - return $this->get( 'ATT_address2' ); |
|
315 | + return $this->get('ATT_address2'); |
|
316 | 316 | } |
317 | 317 | |
318 | 318 | |
@@ -322,7 +322,7 @@ discard block |
||
322 | 322 | * @return string |
323 | 323 | */ |
324 | 324 | public function city() { |
325 | - return $this->get( 'ATT_city' ); |
|
325 | + return $this->get('ATT_city'); |
|
326 | 326 | } |
327 | 327 | |
328 | 328 | |
@@ -332,7 +332,7 @@ discard block |
||
332 | 332 | * @return string |
333 | 333 | */ |
334 | 334 | public function state_ID() { |
335 | - return $this->get( 'STA_ID' ); |
|
335 | + return $this->get('STA_ID'); |
|
336 | 336 | } |
337 | 337 | |
338 | 338 | |
@@ -341,7 +341,7 @@ discard block |
||
341 | 341 | * @return string |
342 | 342 | */ |
343 | 343 | public function state_abbrev() { |
344 | - return $this->state_obj() instanceof EE_State ? $this->state_obj()->abbrev() : __( 'Unknown', 'event_espresso' ); |
|
344 | + return $this->state_obj() instanceof EE_State ? $this->state_obj()->abbrev() : __('Unknown', 'event_espresso'); |
|
345 | 345 | } |
346 | 346 | |
347 | 347 | |
@@ -351,18 +351,18 @@ discard block |
||
351 | 351 | * @return EE_State |
352 | 352 | */ |
353 | 353 | public function state_obj() { |
354 | - return $this->get_first_related( 'State' ); |
|
354 | + return $this->get_first_related('State'); |
|
355 | 355 | } |
356 | 356 | |
357 | 357 | /** |
358 | 358 | * Returns the state's name, otherwise 'Unknown' |
359 | 359 | * @return string |
360 | 360 | */ |
361 | - public function state_name(){ |
|
362 | - if( $this->state_obj() ){ |
|
361 | + public function state_name() { |
|
362 | + if ($this->state_obj()) { |
|
363 | 363 | return $this->state_obj()->name(); |
364 | - }else{ |
|
365 | - return __( 'Unknown', 'event_espresso' ); |
|
364 | + } else { |
|
365 | + return __('Unknown', 'event_espresso'); |
|
366 | 366 | } |
367 | 367 | } |
368 | 368 | |
@@ -375,7 +375,7 @@ discard block |
||
375 | 375 | * @return string |
376 | 376 | */ |
377 | 377 | public function state() { |
378 | - if ( apply_filters( 'FHEE__EEI_Address__state__use_abbreviation', true, $this->state_obj() ) ) { |
|
378 | + if (apply_filters('FHEE__EEI_Address__state__use_abbreviation', true, $this->state_obj())) { |
|
379 | 379 | return $this->state_abbrev(); |
380 | 380 | } else { |
381 | 381 | return $this->state_name(); |
@@ -389,7 +389,7 @@ discard block |
||
389 | 389 | * @return string |
390 | 390 | */ |
391 | 391 | public function country_ID() { |
392 | - return $this->get( 'CNT_ISO' ); |
|
392 | + return $this->get('CNT_ISO'); |
|
393 | 393 | } |
394 | 394 | |
395 | 395 | |
@@ -399,18 +399,18 @@ discard block |
||
399 | 399 | * @return EE_Country |
400 | 400 | */ |
401 | 401 | public function country_obj() { |
402 | - return $this->get_first_related( 'Country' ); |
|
402 | + return $this->get_first_related('Country'); |
|
403 | 403 | } |
404 | 404 | |
405 | 405 | /** |
406 | 406 | * Returns the country's name if known, otherwise 'Unknown' |
407 | 407 | * @return string |
408 | 408 | */ |
409 | - public function country_name(){ |
|
410 | - if( $this->country_obj() ){ |
|
409 | + public function country_name() { |
|
410 | + if ($this->country_obj()) { |
|
411 | 411 | return $this->country_obj()->name(); |
412 | - }else{ |
|
413 | - return __( 'Unknown', 'event_espresso' ); |
|
412 | + } else { |
|
413 | + return __('Unknown', 'event_espresso'); |
|
414 | 414 | } |
415 | 415 | } |
416 | 416 | |
@@ -423,7 +423,7 @@ discard block |
||
423 | 423 | * @return string |
424 | 424 | */ |
425 | 425 | public function country() { |
426 | - if ( apply_filters( 'FHEE__EEI_Address__country__use_abbreviation', true, $this->country_obj() ) ) { |
|
426 | + if (apply_filters('FHEE__EEI_Address__country__use_abbreviation', true, $this->country_obj())) { |
|
427 | 427 | return $this->country_ID(); |
428 | 428 | } else { |
429 | 429 | return $this->country_name(); |
@@ -437,7 +437,7 @@ discard block |
||
437 | 437 | * @return string |
438 | 438 | */ |
439 | 439 | public function zip() { |
440 | - return $this->get( 'ATT_zip' ); |
|
440 | + return $this->get('ATT_zip'); |
|
441 | 441 | } |
442 | 442 | |
443 | 443 | |
@@ -447,7 +447,7 @@ discard block |
||
447 | 447 | * @return string |
448 | 448 | */ |
449 | 449 | public function email() { |
450 | - return $this->get( 'ATT_email' ); |
|
450 | + return $this->get('ATT_email'); |
|
451 | 451 | } |
452 | 452 | |
453 | 453 | |
@@ -457,7 +457,7 @@ discard block |
||
457 | 457 | * @return string |
458 | 458 | */ |
459 | 459 | public function phone() { |
460 | - return $this->get( 'ATT_phone' ); |
|
460 | + return $this->get('ATT_phone'); |
|
461 | 461 | } |
462 | 462 | |
463 | 463 | |
@@ -467,7 +467,7 @@ discard block |
||
467 | 467 | * @return bool |
468 | 468 | */ |
469 | 469 | public function deleted() { |
470 | - return $this->get( 'ATT_deleted' ); |
|
470 | + return $this->get('ATT_deleted'); |
|
471 | 471 | } |
472 | 472 | |
473 | 473 | |
@@ -477,8 +477,8 @@ discard block |
||
477 | 477 | * @param array $query_params |
478 | 478 | * @return EE_Registration[] |
479 | 479 | */ |
480 | - public function get_registrations( $query_params = array() ) { |
|
481 | - return $this->get_many_related( 'Registration', $query_params ); |
|
480 | + public function get_registrations($query_params = array()) { |
|
481 | + return $this->get_many_related('Registration', $query_params); |
|
482 | 482 | } |
483 | 483 | |
484 | 484 | |
@@ -488,7 +488,7 @@ discard block |
||
488 | 488 | * @return EE_Registration |
489 | 489 | */ |
490 | 490 | public function get_most_recent_registration() { |
491 | - return $this->get_first_related( 'Registration', array( 'order_by' => array( 'REG_date' => 'DESC' ) ) ); //null, 'REG_date', 'DESC', '=', 'OBJECT_K'); |
|
491 | + return $this->get_first_related('Registration', array('order_by' => array('REG_date' => 'DESC'))); //null, 'REG_date', 'DESC', '=', 'OBJECT_K'); |
|
492 | 492 | } |
493 | 493 | |
494 | 494 | |
@@ -498,8 +498,8 @@ discard block |
||
498 | 498 | * @param int $event_id |
499 | 499 | * @return EE_Registration |
500 | 500 | */ |
501 | - public function get_most_recent_registration_for_event( $event_id ) { |
|
502 | - return $this->get_first_related( 'Registration', array(array( 'EVT_ID' => $event_id ), 'order_by' => array('REG_date' => 'DESC')));//, '=', 'OBJECT_K' ); |
|
501 | + public function get_most_recent_registration_for_event($event_id) { |
|
502 | + return $this->get_first_related('Registration', array(array('EVT_ID' => $event_id), 'order_by' => array('REG_date' => 'DESC'))); //, '=', 'OBJECT_K' ); |
|
503 | 503 | } |
504 | 504 | |
505 | 505 | |
@@ -509,7 +509,7 @@ discard block |
||
509 | 509 | * @return array |
510 | 510 | */ |
511 | 511 | public function events() { |
512 | - return $this->get_many_related( 'Event' ); |
|
512 | + return $this->get_many_related('Event'); |
|
513 | 513 | } |
514 | 514 | |
515 | 515 | /** |
@@ -518,17 +518,17 @@ discard block |
||
518 | 518 | * @param EE_Payment_Method $payment_method the _gateway_name property on the gateway class |
519 | 519 | * @return EE_Form_Section_Proper |
520 | 520 | */ |
521 | - public function billing_info_for_payment_method($payment_method){ |
|
521 | + public function billing_info_for_payment_method($payment_method) { |
|
522 | 522 | $pm_type = $payment_method->type_obj(); |
523 | - if( ! $pm_type instanceof EE_PMT_Base ){ |
|
523 | + if ( ! $pm_type instanceof EE_PMT_Base) { |
|
524 | 524 | return NULL; |
525 | 525 | } |
526 | - $billing_info = $this->get_post_meta( $this->get_billing_info_postmeta_name( $payment_method ), true ); |
|
527 | - if ( ! $billing_info){ |
|
526 | + $billing_info = $this->get_post_meta($this->get_billing_info_postmeta_name($payment_method), true); |
|
527 | + if ( ! $billing_info) { |
|
528 | 528 | return NULL; |
529 | 529 | } |
530 | 530 | $billing_form = $pm_type->billing_form(); |
531 | - $billing_form->receive_form_submission( array( $billing_form->name() => $billing_info ), FALSE ); |
|
531 | + $billing_form->receive_form_submission(array($billing_form->name() => $billing_info), FALSE); |
|
532 | 532 | return $billing_form; |
533 | 533 | } |
534 | 534 | |
@@ -538,10 +538,10 @@ discard block |
||
538 | 538 | * @param EE_Payment_Method $payment_method |
539 | 539 | * @return string |
540 | 540 | */ |
541 | - public function get_billing_info_postmeta_name($payment_method){ |
|
542 | - if( $payment_method->type_obj() instanceof EE_PMT_Base ){ |
|
543 | - return 'billing_info_' . $payment_method->type_obj()->system_name(); |
|
544 | - }else{ |
|
541 | + public function get_billing_info_postmeta_name($payment_method) { |
|
542 | + if ($payment_method->type_obj() instanceof EE_PMT_Base) { |
|
543 | + return 'billing_info_'.$payment_method->type_obj()->system_name(); |
|
544 | + } else { |
|
545 | 545 | return NULL; |
546 | 546 | } |
547 | 547 | } |
@@ -552,13 +552,13 @@ discard block |
||
552 | 552 | * @param EE_Payment_Method $payment_method |
553 | 553 | * @return boolean |
554 | 554 | */ |
555 | - public function save_and_clean_billing_info_for_payment_method($billing_form, $payment_method){ |
|
556 | - if( ! $billing_form instanceof EE_Billing_Attendee_Info_Form ){ |
|
557 | - EE_Error::add_error( __( 'Cannot save billing info because there is none.', 'event_espresso' ) ); |
|
555 | + public function save_and_clean_billing_info_for_payment_method($billing_form, $payment_method) { |
|
556 | + if ( ! $billing_form instanceof EE_Billing_Attendee_Info_Form) { |
|
557 | + EE_Error::add_error(__('Cannot save billing info because there is none.', 'event_espresso')); |
|
558 | 558 | return false; |
559 | 559 | } |
560 | 560 | $billing_form->clean_sensitive_data(); |
561 | - return update_post_meta($this->ID(), $this->get_billing_info_postmeta_name( $payment_method ), $billing_form->input_values( true ) ); |
|
561 | + return update_post_meta($this->ID(), $this->get_billing_info_postmeta_name($payment_method), $billing_form->input_values(true)); |
|
562 | 562 | } |
563 | 563 | |
564 | 564 | } |
@@ -51,7 +51,7 @@ discard block |
||
51 | 51 | |
52 | 52 | /** |
53 | 53 | * Gets the country name |
54 | - * @return string |
|
54 | + * @return boolean |
|
55 | 55 | */ |
56 | 56 | public function name() { |
57 | 57 | return $this->get( 'CNT_name' ); |
@@ -61,7 +61,7 @@ discard block |
||
61 | 61 | |
62 | 62 | /** |
63 | 63 | * gets the country's currency code |
64 | - * @return string |
|
64 | + * @return boolean |
|
65 | 65 | */ |
66 | 66 | public function currency_code() { |
67 | 67 | return $this->get( 'CNT_cur_code' ); |
@@ -82,7 +82,7 @@ discard block |
||
82 | 82 | |
83 | 83 | /** |
84 | 84 | * Currency name singular |
85 | - * @return string |
|
85 | + * @return boolean |
|
86 | 86 | */ |
87 | 87 | public function currency_name_single() { |
88 | 88 | return $this->get( 'CNT_cur_single' ); |
@@ -92,7 +92,7 @@ discard block |
||
92 | 92 | |
93 | 93 | /** |
94 | 94 | * Currency name plural |
95 | - * @return string |
|
95 | + * @return boolean |
|
96 | 96 | */ |
97 | 97 | public function currency_name_plural() { |
98 | 98 | return $this->get( 'CNT_cur_plural' ); |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | |
113 | 113 | /** |
114 | 114 | * currency_decimal_places : 2 = 0.00 3 = 0.000 |
115 | - * @return integer |
|
115 | + * @return boolean |
|
116 | 116 | */ |
117 | 117 | public function currency_decimal_places() { |
118 | 118 | return $this->get( 'CNT_cur_dec_plc' ); |
@@ -122,7 +122,7 @@ discard block |
||
122 | 122 | |
123 | 123 | /** |
124 | 124 | * currency_decimal_mark : (comma) ',' = 0,01 or (decimal) '.' = 0.01 |
125 | - * @return string |
|
125 | + * @return boolean |
|
126 | 126 | */ |
127 | 127 | public function currency_decimal_mark() { |
128 | 128 | return $this->get( 'CNT_cur_dec_mrk' ); |
@@ -132,7 +132,7 @@ discard block |
||
132 | 132 | |
133 | 133 | /** |
134 | 134 | * currency thousands separator: (comma) ',' = 1,000 or (decimal) '.' = 1.000 |
135 | - * @return string |
|
135 | + * @return boolean |
|
136 | 136 | */ |
137 | 137 | public function currency_thousands_separator() { |
138 | 138 | return $this->get( 'CNT_cur_thsnds' ); |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
2 | - exit( 'No direct script access allowed' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | 3 | } |
4 | 4 | /** |
5 | 5 | * Event Espresso |
@@ -30,9 +30,9 @@ discard block |
||
30 | 30 | * @param array $props_n_values |
31 | 31 | * @return EE_Country|mixed |
32 | 32 | */ |
33 | - public static function new_instance( $props_n_values = array() ) { |
|
34 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__ ); |
|
35 | - return $has_object ? $has_object : new self( $props_n_values ); |
|
33 | + public static function new_instance($props_n_values = array()) { |
|
34 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__); |
|
35 | + return $has_object ? $has_object : new self($props_n_values); |
|
36 | 36 | } |
37 | 37 | |
38 | 38 | |
@@ -41,8 +41,8 @@ discard block |
||
41 | 41 | * @param array $props_n_values |
42 | 42 | * @return EE_Country |
43 | 43 | */ |
44 | - public static function new_instance_from_db( $props_n_values = array() ) { |
|
45 | - return new self( $props_n_values, TRUE ); |
|
44 | + public static function new_instance_from_db($props_n_values = array()) { |
|
45 | + return new self($props_n_values, TRUE); |
|
46 | 46 | } |
47 | 47 | |
48 | 48 | |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | * @return string |
55 | 55 | */ |
56 | 56 | public function name() { |
57 | - return $this->get( 'CNT_name' ); |
|
57 | + return $this->get('CNT_name'); |
|
58 | 58 | } |
59 | 59 | |
60 | 60 | |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | * @return string |
65 | 65 | */ |
66 | 66 | public function currency_code() { |
67 | - return $this->get( 'CNT_cur_code' ); |
|
67 | + return $this->get('CNT_cur_code'); |
|
68 | 68 | } |
69 | 69 | |
70 | 70 | |
@@ -74,7 +74,7 @@ discard block |
||
74 | 74 | * @return string |
75 | 75 | */ |
76 | 76 | public function currency_sign() { |
77 | - $CNT_cur_sign = $this->get( 'CNT_cur_sign' ); |
|
77 | + $CNT_cur_sign = $this->get('CNT_cur_sign'); |
|
78 | 78 | return $CNT_cur_sign ? $CNT_cur_sign : '¤'; |
79 | 79 | } |
80 | 80 | |
@@ -85,7 +85,7 @@ discard block |
||
85 | 85 | * @return string |
86 | 86 | */ |
87 | 87 | public function currency_name_single() { |
88 | - return $this->get( 'CNT_cur_single' ); |
|
88 | + return $this->get('CNT_cur_single'); |
|
89 | 89 | } |
90 | 90 | |
91 | 91 | |
@@ -95,7 +95,7 @@ discard block |
||
95 | 95 | * @return string |
96 | 96 | */ |
97 | 97 | public function currency_name_plural() { |
98 | - return $this->get( 'CNT_cur_plural' ); |
|
98 | + return $this->get('CNT_cur_plural'); |
|
99 | 99 | } |
100 | 100 | |
101 | 101 | |
@@ -105,7 +105,7 @@ discard block |
||
105 | 105 | * @return boolean |
106 | 106 | */ |
107 | 107 | public function currency_sign_before() { |
108 | - return $this->get( 'CNT_cur_sign_b4' ); |
|
108 | + return $this->get('CNT_cur_sign_b4'); |
|
109 | 109 | } |
110 | 110 | |
111 | 111 | |
@@ -115,7 +115,7 @@ discard block |
||
115 | 115 | * @return integer |
116 | 116 | */ |
117 | 117 | public function currency_decimal_places() { |
118 | - return $this->get( 'CNT_cur_dec_plc' ); |
|
118 | + return $this->get('CNT_cur_dec_plc'); |
|
119 | 119 | } |
120 | 120 | |
121 | 121 | |
@@ -125,7 +125,7 @@ discard block |
||
125 | 125 | * @return string |
126 | 126 | */ |
127 | 127 | public function currency_decimal_mark() { |
128 | - return $this->get( 'CNT_cur_dec_mrk' ); |
|
128 | + return $this->get('CNT_cur_dec_mrk'); |
|
129 | 129 | } |
130 | 130 | |
131 | 131 | |
@@ -135,7 +135,7 @@ discard block |
||
135 | 135 | * @return string |
136 | 136 | */ |
137 | 137 | public function currency_thousands_separator() { |
138 | - return $this->get( 'CNT_cur_thsnds' ); |
|
138 | + return $this->get('CNT_cur_thsnds'); |
|
139 | 139 | } |
140 | 140 | } |
141 | 141 | /* End of file EE_Country.class.php */ |
@@ -287,7 +287,7 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
@@ -1,4 +1,4 @@ discard block |
||
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 | * |
@@ -41,31 +41,31 @@ discard block |
||
41 | 41 | global $wpdb; |
42 | 42 | |
43 | 43 | $this->_primary_keys = array( |
44 | - $wpdb->prefix . 'esp_answer' => array( 'ANS_ID' ), |
|
45 | - $wpdb->prefix . 'esp_attendee' => array( 'ATT_ID' ), |
|
46 | - $wpdb->prefix . 'esp_datetime' => array( 'DTT_ID' ), |
|
47 | - $wpdb->prefix . 'esp_event_question_group' => array( 'EQG_ID' ), |
|
48 | - $wpdb->prefix . 'esp_message_template' => array( 'MTP_ID' ), |
|
49 | - $wpdb->prefix . 'esp_payment' => array( 'PAY_ID' ), |
|
50 | - $wpdb->prefix . 'esp_price' => array( 'PRC_ID' ), |
|
51 | - $wpdb->prefix . 'esp_price_type' => array( 'PRT_ID' ), |
|
52 | - $wpdb->prefix . 'esp_question' => array( 'QST_ID' ), |
|
53 | - $wpdb->prefix . 'esp_question_group' => array( 'QSG_ID' ), |
|
54 | - $wpdb->prefix . 'esp_question_group_question' => array( 'QGQ_ID' ), |
|
55 | - $wpdb->prefix . 'esp_question_option' => array( 'QSO_ID' ), |
|
56 | - $wpdb->prefix . 'esp_registration' => array( 'REG_ID' ), |
|
57 | - $wpdb->prefix . 'esp_status' => array( 'STS_ID' ), |
|
58 | - $wpdb->prefix . 'esp_transaction' => array( 'TXN_ID' ), |
|
59 | - $wpdb->prefix . 'esp_transaction' => array( 'TXN_ID' ), |
|
60 | - $wpdb->prefix . 'events_detail' => array( 'id' ), |
|
61 | - $wpdb->prefix . 'events_category_detail' => array( 'id' ), |
|
62 | - $wpdb->prefix . 'events_category_rel' => array( 'id' ), |
|
63 | - $wpdb->prefix . 'events_venue' => array( 'id' ), |
|
64 | - $wpdb->prefix . 'events_venue_rel' => array( 'emeta_id' ), |
|
65 | - $wpdb->prefix . 'events_locale' => array( 'id' ), |
|
66 | - $wpdb->prefix . 'events_locale_rel' => array( 'id' ), |
|
67 | - $wpdb->prefix . 'events_personnel' => array( 'id' ), |
|
68 | - $wpdb->prefix . 'events_personnel_rel' => array( 'id' ), |
|
44 | + $wpdb->prefix.'esp_answer' => array('ANS_ID'), |
|
45 | + $wpdb->prefix.'esp_attendee' => array('ATT_ID'), |
|
46 | + $wpdb->prefix.'esp_datetime' => array('DTT_ID'), |
|
47 | + $wpdb->prefix.'esp_event_question_group' => array('EQG_ID'), |
|
48 | + $wpdb->prefix.'esp_message_template' => array('MTP_ID'), |
|
49 | + $wpdb->prefix.'esp_payment' => array('PAY_ID'), |
|
50 | + $wpdb->prefix.'esp_price' => array('PRC_ID'), |
|
51 | + $wpdb->prefix.'esp_price_type' => array('PRT_ID'), |
|
52 | + $wpdb->prefix.'esp_question' => array('QST_ID'), |
|
53 | + $wpdb->prefix.'esp_question_group' => array('QSG_ID'), |
|
54 | + $wpdb->prefix.'esp_question_group_question' => array('QGQ_ID'), |
|
55 | + $wpdb->prefix.'esp_question_option' => array('QSO_ID'), |
|
56 | + $wpdb->prefix.'esp_registration' => array('REG_ID'), |
|
57 | + $wpdb->prefix.'esp_status' => array('STS_ID'), |
|
58 | + $wpdb->prefix.'esp_transaction' => array('TXN_ID'), |
|
59 | + $wpdb->prefix.'esp_transaction' => array('TXN_ID'), |
|
60 | + $wpdb->prefix.'events_detail' => array('id'), |
|
61 | + $wpdb->prefix.'events_category_detail' => array('id'), |
|
62 | + $wpdb->prefix.'events_category_rel' => array('id'), |
|
63 | + $wpdb->prefix.'events_venue' => array('id'), |
|
64 | + $wpdb->prefix.'events_venue_rel' => array('emeta_id'), |
|
65 | + $wpdb->prefix.'events_locale' => array('id'), |
|
66 | + $wpdb->prefix.'events_locale_rel' => array('id'), |
|
67 | + $wpdb->prefix.'events_personnel' => array('id'), |
|
68 | + $wpdb->prefix.'events_personnel_rel' => array('id'), |
|
69 | 69 | ); |
70 | 70 | |
71 | 71 | } |
@@ -77,9 +77,9 @@ discard block |
||
77 | 77 | * @ access public |
78 | 78 | * @ return class instance |
79 | 79 | */ |
80 | - public static function instance ( ) { |
|
80 | + public static function instance( ) { |
|
81 | 81 | // check if class object is instantiated |
82 | - if ( self::$_instance === NULL or ! is_object( self::$_instance ) or ! ( self::$_instance instanceof EE_CSV )) { |
|
82 | + if (self::$_instance === NULL or ! is_object(self::$_instance) or ! (self::$_instance instanceof EE_CSV)) { |
|
83 | 83 | self::$_instance = new self(); |
84 | 84 | } |
85 | 85 | return self::$_instance; |
@@ -91,22 +91,22 @@ discard block |
||
91 | 91 | * @return string |
92 | 92 | * @throws EE_Error |
93 | 93 | */ |
94 | - private function read_unicode_file($file_path){ |
|
94 | + private function read_unicode_file($file_path) { |
|
95 | 95 | $fc = ""; |
96 | - $fh = fopen($file_path,"rb"); |
|
97 | - if( ! $fh ){ |
|
98 | - throw new EE_Error( sprintf( __("Cannot open file for read: %s<br>\n", 'event_espresso'), $file_path ) ); |
|
96 | + $fh = fopen($file_path, "rb"); |
|
97 | + if ( ! $fh) { |
|
98 | + throw new EE_Error(sprintf(__("Cannot open file for read: %s<br>\n", 'event_espresso'), $file_path)); |
|
99 | 99 | } |
100 | 100 | $flen = filesize($file_path); |
101 | 101 | $bc = fread($fh, $flen); |
102 | - for ($i=0; $i<$flen; $i++){ |
|
103 | - $c = substr($bc,$i,1); |
|
104 | - if ((ord($c) != 0) && (ord($c) != 13)){ |
|
105 | - $fc = $fc . $c; |
|
102 | + for ($i = 0; $i < $flen; $i++) { |
|
103 | + $c = substr($bc, $i, 1); |
|
104 | + if ((ord($c) != 0) && (ord($c) != 13)) { |
|
105 | + $fc = $fc.$c; |
|
106 | 106 | } |
107 | 107 | } |
108 | - if ((ord(substr($fc,0,1)) == 255) && (ord(substr($fc,1,1)) == 254)) |
|
109 | - $fc = substr($fc,2); |
|
108 | + if ((ord(substr($fc, 0, 1)) == 255) && (ord(substr($fc, 1, 1)) == 254)) |
|
109 | + $fc = substr($fc, 2); |
|
110 | 110 | return ($fc); |
111 | 111 | } |
112 | 112 | |
@@ -118,15 +118,15 @@ discard block |
||
118 | 118 | * @param string $path_to_file |
119 | 119 | * @return array of arrays. Top-level array has rows, second-level array has each item |
120 | 120 | */ |
121 | - public function import_csv_to_multi_dimensional_array($path_to_file){ |
|
121 | + public function import_csv_to_multi_dimensional_array($path_to_file) { |
|
122 | 122 | // needed to deal with Mac line endings |
123 | - ini_set('auto_detect_line_endings',TRUE); |
|
123 | + ini_set('auto_detect_line_endings', TRUE); |
|
124 | 124 | |
125 | 125 | // because fgetcsv does not correctly deal with backslashed quotes such as \" |
126 | 126 | // we'll read the file into a string |
127 | - $file_contents = $this->read_unicode_file( $path_to_file ); |
|
127 | + $file_contents = $this->read_unicode_file($path_to_file); |
|
128 | 128 | // replace backslashed quotes with CSV enclosures |
129 | - $file_contents = str_replace ( '\\"', '"""', $file_contents ); |
|
129 | + $file_contents = str_replace('\\"', '"""', $file_contents); |
|
130 | 130 | // HEY YOU! PUT THAT FILE BACK!!! |
131 | 131 | file_put_contents($path_to_file, $file_contents); |
132 | 132 | |
@@ -136,25 +136,25 @@ discard block |
||
136 | 136 | $csvarray = array(); |
137 | 137 | |
138 | 138 | // 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? |
139 | - if ( version_compare( PHP_VERSION, '5.3.0' ) < 0 ) { |
|
139 | + if (version_compare(PHP_VERSION, '5.3.0') < 0) { |
|
140 | 140 | |
141 | 141 | // PHP 5.2- version |
142 | 142 | |
143 | 143 | // loop through each row of the file |
144 | - while(($data = fgetcsv($file_handle, 0, ',', '"' )) !== FALSE){ |
|
145 | - $csvarray[]= $data; |
|
144 | + while (($data = fgetcsv($file_handle, 0, ',', '"')) !== FALSE) { |
|
145 | + $csvarray[] = $data; |
|
146 | 146 | } |
147 | - }else{ |
|
147 | + } else { |
|
148 | 148 | // loop through each row of the file |
149 | - while (( $data = fgetcsv( $file_handle, 0, ',', '"', '\\' )) !== FALSE ) { |
|
150 | - $csvarray[]=$data; |
|
149 | + while (($data = fgetcsv($file_handle, 0, ',', '"', '\\')) !== FALSE) { |
|
150 | + $csvarray[] = $data; |
|
151 | 151 | } |
152 | 152 | } |
153 | 153 | # Close the File. |
154 | 154 | fclose($file_handle); |
155 | 155 | return $csvarray; |
156 | - }else{ |
|
157 | - EE_Error::add_error( sprintf(__("An error occurred - the file: %s could not opened.", "event_espresso"),$path_to_file), __FILE__, __FUNCTION__, __LINE__ ); |
|
156 | + } else { |
|
157 | + EE_Error::add_error(sprintf(__("An error occurred - the file: %s could not opened.", "event_espresso"), $path_to_file), __FILE__, __FUNCTION__, __LINE__); |
|
158 | 158 | return false; |
159 | 159 | } |
160 | 160 | } |
@@ -184,9 +184,9 @@ discard block |
||
184 | 184 | * ... |
185 | 185 | * ) |
186 | 186 | */ |
187 | - public function import_csv_to_model_data_array( $path_to_file, $model_name = FALSE, $first_row_is_headers = TRUE ) { |
|
187 | + public function import_csv_to_model_data_array($path_to_file, $model_name = FALSE, $first_row_is_headers = TRUE) { |
|
188 | 188 | $multi_dimensional_array = $this->import_csv_to_multi_dimensional_array($path_to_file); |
189 | - if( ! $multi_dimensional_array ){ |
|
189 | + if ( ! $multi_dimensional_array) { |
|
190 | 190 | return false; |
191 | 191 | } |
192 | 192 | // gotta start somewhere |
@@ -195,9 +195,9 @@ discard block |
||
195 | 195 | $ee_formatted_data = array(); |
196 | 196 | // array to store headers (column names) |
197 | 197 | $headers = array(); |
198 | - foreach($multi_dimensional_array as $data){ |
|
198 | + foreach ($multi_dimensional_array as $data) { |
|
199 | 199 | // if first cell is MODEL, then second cell is the MODEL name |
200 | - if ( $data[0] == 'MODEL' ) { |
|
200 | + if ($data[0] == 'MODEL') { |
|
201 | 201 | $model_name = $data[1]; |
202 | 202 | //don't bother looking for model data in this row. The rest of this |
203 | 203 | //row should be blank |
@@ -207,7 +207,7 @@ discard block |
||
207 | 207 | $headers = array(); |
208 | 208 | continue; |
209 | 209 | } |
210 | - if( strpos( $data[0], EE_CSV::metadata_header ) !==FALSE ){ |
|
210 | + if (strpos($data[0], EE_CSV::metadata_header) !== FALSE) { |
|
211 | 211 | $model_name = EE_CSV::metadata_header; |
212 | 212 | //store like model data, we just won't try importing it etc. |
213 | 213 | $row = 1; |
@@ -220,31 +220,31 @@ discard block |
||
220 | 220 | |
221 | 221 | $model_entry = array(); |
222 | 222 | // loop through each column |
223 | - for ( $i=0; $i < $columns; $i++ ) { |
|
223 | + for ($i = 0; $i < $columns; $i++) { |
|
224 | 224 | |
225 | 225 | //replace csv_enclosures with backslashed quotes |
226 | - $data[$i] = str_replace ( '"""', '\\"', $data[$i] ); |
|
226 | + $data[$i] = str_replace('"""', '\\"', $data[$i]); |
|
227 | 227 | // do we need to grab the column names? |
228 | - if ( $row === 1){ |
|
229 | - if( $first_row_is_headers ) { |
|
228 | + if ($row === 1) { |
|
229 | + if ($first_row_is_headers) { |
|
230 | 230 | // store the column names to use for keys |
231 | 231 | $column_name = $data[$i]; |
232 | 232 | //check it's not blank... sometimes CSV editign programs adda bunch of empty columns onto the end... |
233 | - if(!$column_name){continue;} |
|
233 | + if ( ! $column_name) {continue; } |
|
234 | 234 | $matches = array(); |
235 | - if($model_name == EE_CSV::metadata_header){ |
|
235 | + if ($model_name == EE_CSV::metadata_header) { |
|
236 | 236 | $headers[$i] = $column_name; |
237 | - }else{ |
|
237 | + } else { |
|
238 | 238 | //now get the db table name from it (the part between square brackets) |
239 | - $success = preg_match('~(.*)\[(.*)\]~', $column_name,$matches); |
|
240 | - if (!$success){ |
|
241 | - 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__ ); |
|
239 | + $success = preg_match('~(.*)\[(.*)\]~', $column_name, $matches); |
|
240 | + if ( ! $success) { |
|
241 | + 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__); |
|
242 | 242 | return false; |
243 | 243 | } |
244 | 244 | $headers[$i] = $matches[2]; |
245 | 245 | } |
246 | 246 | |
247 | - }else{ |
|
247 | + } else { |
|
248 | 248 | // no column names means our final array will just use counters for keys |
249 | 249 | $model_entry[$headers[$i]] = $data[$i]; |
250 | 250 | $headers[$i] = $i; |
@@ -252,14 +252,14 @@ discard block |
||
252 | 252 | // and we need to store csv data |
253 | 253 | } else { |
254 | 254 | // this column isn' ta header, store it if there is a header for it |
255 | - if(isset($headers[$i])){ |
|
255 | + if (isset($headers[$i])) { |
|
256 | 256 | $model_entry[$headers[$i]] = $data[$i]; |
257 | 257 | } |
258 | 258 | } |
259 | 259 | |
260 | 260 | } |
261 | 261 | //save the row's data IF it's a non-header-row |
262 | - if( ! $first_row_is_headers || ($first_row_is_headers && $row > 1)){ |
|
262 | + if ( ! $first_row_is_headers || ($first_row_is_headers && $row > 1)) { |
|
263 | 263 | $ee_formatted_data[$model_name][] = $model_entry; |
264 | 264 | } |
265 | 265 | // advance to next row |
@@ -278,9 +278,9 @@ discard block |
||
278 | 278 | } |
279 | 279 | |
280 | 280 | |
281 | - public function save_csv_to_db( $csv_data_array, $model_name = FALSE ) { |
|
282 | - 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' ); |
|
283 | - return EE_Import::instance()->save_csv_data_array_to_db( $csv_data_array, $model_name ); |
|
281 | + public function save_csv_to_db($csv_data_array, $model_name = FALSE) { |
|
282 | + 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'); |
|
283 | + return EE_Import::instance()->save_csv_data_array_to_db($csv_data_array, $model_name); |
|
284 | 284 | } |
285 | 285 | |
286 | 286 | /** |
@@ -290,11 +290,11 @@ discard block |
||
290 | 290 | * @param string $new_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 | - public function begin_sending_csv($filename){ |
|
293 | + public function begin_sending_csv($filename) { |
|
294 | 294 | // grab file extension |
295 | 295 | $ext = substr(strrchr($filename, '.'), 1); |
296 | - if ( $ext == '.csv' or $ext == '.xls' ) { |
|
297 | - str_replace( $ext, '', $filename ); |
|
296 | + if ($ext == '.csv' or $ext == '.xls') { |
|
297 | + str_replace($ext, '', $filename); |
|
298 | 298 | } |
299 | 299 | $filename .= '.csv'; |
300 | 300 | |
@@ -325,12 +325,12 @@ discard block |
||
325 | 325 | * mentioning the version and timezone |
326 | 326 | * @param resource $filehandle |
327 | 327 | */ |
328 | - public function write_metadata_to_csv($filehandle){ |
|
328 | + public function write_metadata_to_csv($filehandle) { |
|
329 | 329 | EE_Registry::instance()->load_helper('DTT_Helper'); |
330 | - $data_row = array(EE_CSV::metadata_header);//do NOT translate because this exact string is used when importing |
|
330 | + $data_row = array(EE_CSV::metadata_header); //do NOT translate because this exact string is used when importing |
|
331 | 331 | $this->fputcsv2($filehandle, $data_row); |
332 | 332 | EE_Registry::instance()->load_helper('DTT_Helper'); |
333 | - $meta_data = array( 0=> array( |
|
333 | + $meta_data = array(0=> array( |
|
334 | 334 | 'version'=>espresso_version(), |
335 | 335 | 'timezone'=> EEH_DTT_Helper::get_timezone(), |
336 | 336 | 'time_of_export'=>current_time('mysql'), |
@@ -348,30 +348,30 @@ discard block |
||
348 | 348 | * then the first row we'd write to the CSV would be "EVT_ID,EVT_name,..." |
349 | 349 | * @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 | 350 | */ |
351 | - public function write_data_array_to_csv($filehandle, $data){ |
|
351 | + public function write_data_array_to_csv($filehandle, $data) { |
|
352 | 352 | EE_Registry::instance()->load_helper('Array'); |
353 | 353 | |
354 | 354 | |
355 | 355 | //determine if $data is actually a 2d array |
356 | - if ( $data && is_array($data) && is_array(EEH_Array::get_one_item_from_array($data))){ |
|
356 | + if ($data && is_array($data) && is_array(EEH_Array::get_one_item_from_array($data))) { |
|
357 | 357 | //make sure top level is numerically indexed, |
358 | 358 | |
359 | - if( EEH_Array::is_associative_array($data)){ |
|
360 | - 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)))); |
|
359 | + if (EEH_Array::is_associative_array($data)) { |
|
360 | + 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 | 361 | } |
362 | 362 | $item_in_top_level_array = EEH_Array::get_one_item_from_array($data); |
363 | 363 | //now, is the last item in the top-level array of $data an associative or numeric array? |
364 | - if(EEH_Array::is_associative_array($item_in_top_level_array)){ |
|
364 | + if (EEH_Array::is_associative_array($item_in_top_level_array)) { |
|
365 | 365 | //its associative, so we want to output its keys as column headers |
366 | 366 | $keys = array_keys($item_in_top_level_array); |
367 | 367 | echo $this->fputcsv2($filehandle, $keys); |
368 | 368 | } |
369 | 369 | //start writing data |
370 | - foreach($data as $data_row){ |
|
370 | + foreach ($data as $data_row) { |
|
371 | 371 | echo $this->fputcsv2($filehandle, $data_row); |
372 | 372 | } |
373 | 373 | return true; |
374 | - }else{ |
|
374 | + } else { |
|
375 | 375 | //no data TO write... so we can assume that's a success |
376 | 376 | return true; |
377 | 377 | } |
@@ -416,7 +416,7 @@ discard block |
||
416 | 416 | * Calls exit to prevent polluting the CSV file with other junk |
417 | 417 | * @param resource $fh filehandle where we're writing the CSV to |
418 | 418 | */ |
419 | - public function end_sending_csv($fh){ |
|
419 | + public function end_sending_csv($fh) { |
|
420 | 420 | fclose($fh); |
421 | 421 | exit(0); |
422 | 422 | } |
@@ -429,23 +429,23 @@ discard block |
||
429 | 429 | * has all the attributes o fthat model object (eg, the event's id, name, etc) |
430 | 430 | * @return boolean success |
431 | 431 | */ |
432 | - public function write_model_data_to_csv($filehandle,$model_data_array){ |
|
432 | + public function write_model_data_to_csv($filehandle, $model_data_array) { |
|
433 | 433 | $this->write_metadata_to_csv($filehandle); |
434 | - foreach($model_data_array as $model_name => $model_instance_arrays){ |
|
434 | + foreach ($model_data_array as $model_name => $model_instance_arrays) { |
|
435 | 435 | //first: output a special row stating the model |
436 | - echo $this->fputcsv2($filehandle,array('MODEL',$model_name)); |
|
436 | + echo $this->fputcsv2($filehandle, array('MODEL', $model_name)); |
|
437 | 437 | //if we have items to put in the CSV, do it normally |
438 | 438 | |
439 | - if( ! empty($model_instance_arrays) ){ |
|
439 | + if ( ! empty($model_instance_arrays)) { |
|
440 | 440 | $this->write_data_array_to_csv($filehandle, $model_instance_arrays); |
441 | - }else{ |
|
441 | + } else { |
|
442 | 442 | // echo "no data to write... so just write the headers"; |
443 | 443 | //so there's actually NO model objects for that model. |
444 | 444 | //probably still want to show the columns |
445 | 445 | $model = EE_Registry::instance()->load_model($model_name); |
446 | 446 | $column_names = array(); |
447 | - foreach($model->field_settings() as $field){ |
|
448 | - $column_names[$field->get_nicename()."[".$field->get_name()."]"] = null ; |
|
447 | + foreach ($model->field_settings() as $field) { |
|
448 | + $column_names[$field->get_nicename()."[".$field->get_name()."]"] = null; |
|
449 | 449 | } |
450 | 450 | $this->write_data_array_to_csv($filehandle, array($column_names)); |
451 | 451 | } |
@@ -459,7 +459,7 @@ discard block |
||
459 | 459 | * @param array $model_data_array 3d array, as described in EE_CSV::write_model_data_to_csv() |
460 | 460 | * @return bool | void writes CSV file to output and dies |
461 | 461 | */ |
462 | - public function export_multiple_model_data_to_csv($filename,$model_data_array){ |
|
462 | + public function export_multiple_model_data_to_csv($filename, $model_data_array) { |
|
463 | 463 | $filehandle = $this->begin_sending_csv($filename); |
464 | 464 | $this->write_model_data_to_csv($filehandle, $model_data_array); |
465 | 465 | $this->end_sending_csv($filehandle); |
@@ -471,15 +471,15 @@ discard block |
||
471 | 471 | * @param string $filename - name for newly created csv file |
472 | 472 | * @return TRUE on success, FALSE on fail |
473 | 473 | */ |
474 | - public function export_array_to_csv( $data = FALSE, $filename = FALSE ) { |
|
474 | + public function export_array_to_csv($data = FALSE, $filename = FALSE) { |
|
475 | 475 | |
476 | 476 | // no data file?? get outta here |
477 | - if ( ! $data or ! is_array( $data ) or empty( $data ) ) { |
|
477 | + if ( ! $data or ! is_array($data) or empty($data)) { |
|
478 | 478 | return FALSE; |
479 | 479 | } |
480 | 480 | |
481 | 481 | // no filename?? get outta here |
482 | - if ( ! $filename ) { |
|
482 | + if ( ! $filename) { |
|
483 | 483 | return FALSE; |
484 | 484 | } |
485 | 485 | |
@@ -505,11 +505,11 @@ discard block |
||
505 | 505 | * @param int $percent_of_max - desired percentage of the max upload_mb |
506 | 506 | * @return int KB |
507 | 507 | */ |
508 | - public function get_max_upload_size ( $percent_of_max = FALSE ) { |
|
508 | + public function get_max_upload_size($percent_of_max = FALSE) { |
|
509 | 509 | |
510 | - $max_upload = (int)(ini_get('upload_max_filesize')); |
|
511 | - $max_post = (int)(ini_get('post_max_size')); |
|
512 | - $memory_limit = (int)(ini_get('memory_limit')); |
|
510 | + $max_upload = (int) (ini_get('upload_max_filesize')); |
|
511 | + $max_post = (int) (ini_get('post_max_size')); |
|
512 | + $memory_limit = (int) (ini_get('memory_limit')); |
|
513 | 513 | |
514 | 514 | // determine the smallest of the three values from above |
515 | 515 | $upload_mb = min($max_upload, $max_post, $memory_limit); |
@@ -518,9 +518,9 @@ discard block |
||
518 | 518 | $upload_mb = $upload_mb * 1024; |
519 | 519 | |
520 | 520 | // don't want the full monty? then reduce the max uplaod size |
521 | - if ( $percent_of_max ) { |
|
521 | + if ($percent_of_max) { |
|
522 | 522 | // is percent_of_max like this -> 50 or like this -> 0.50 ? |
523 | - if ( $percent_of_max > 1 ) { |
|
523 | + if ($percent_of_max > 1) { |
|
524 | 524 | // chnages 50 to 0.50 |
525 | 525 | $percent_of_max = $percent_of_max / 100; |
526 | 526 | } |
@@ -542,17 +542,17 @@ discard block |
||
542 | 542 | * @param string $mysql_null - allows php NULL to be overridden with MySQl's insertable NULL value |
543 | 543 | * @return void |
544 | 544 | */ |
545 | - private function fputcsv2 ($fh, array $row, $delimiter = ',', $enclosure = '"', $mysql_null = FALSE) { |
|
545 | + private function fputcsv2($fh, array $row, $delimiter = ',', $enclosure = '"', $mysql_null = FALSE) { |
|
546 | 546 | //Allow user to filter the csv delimiter and enclosure for other countries csv standards |
547 | - $delimiter = apply_filters( 'FHEE__EE_CSV__fputcsv2__delimiter', $delimiter ); |
|
548 | - $enclosure = apply_filters( 'FHEE__EE_CSV__fputcsv2__enclosure', $enclosure ); |
|
547 | + $delimiter = apply_filters('FHEE__EE_CSV__fputcsv2__delimiter', $delimiter); |
|
548 | + $enclosure = apply_filters('FHEE__EE_CSV__fputcsv2__enclosure', $enclosure); |
|
549 | 549 | |
550 | 550 | $delimiter_esc = preg_quote($delimiter, '/'); |
551 | 551 | $enclosure_esc = preg_quote($enclosure, '/'); |
552 | 552 | |
553 | 553 | $output = array(); |
554 | 554 | foreach ($row as $field_value) { |
555 | - if(is_object($field_value) || is_array($field_value)){ |
|
555 | + if (is_object($field_value) || is_array($field_value)) { |
|
556 | 556 | $field_value = serialize($field_value); |
557 | 557 | } |
558 | 558 | if ($field_value === null && $mysql_null) { |
@@ -561,10 +561,10 @@ discard block |
||
561 | 561 | } |
562 | 562 | |
563 | 563 | $output[] = preg_match("/(?:${delimiter_esc}|${enclosure_esc}|\s)/", $field_value) ? |
564 | - ( $enclosure . str_replace($enclosure, $enclosure . $enclosure, $field_value) . $enclosure ) : $field_value; |
|
564 | + ($enclosure.str_replace($enclosure, $enclosure.$enclosure, $field_value).$enclosure) : $field_value; |
|
565 | 565 | } |
566 | 566 | |
567 | - fwrite($fh, join($delimiter, $output) . PHP_EOL); |
|
567 | + fwrite($fh, join($delimiter, $output).PHP_EOL); |
|
568 | 568 | } |
569 | 569 | |
570 | 570 |
@@ -1,4 +1,6 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
@@ -69,7 +69,7 @@ discard block |
||
69 | 69 | /** |
70 | 70 | * @Export Event Espresso data - routes export requests |
71 | 71 | * @access public |
72 | - * @return void | bool |
|
72 | + * @return false|null | bool |
|
73 | 73 | */ |
74 | 74 | public function export() { |
75 | 75 | |
@@ -605,7 +605,7 @@ discard block |
||
605 | 605 | * @recursive function for exporting table data and merging the results with the next results |
606 | 606 | * @access private |
607 | 607 | * @param array $models_to_export keys are model names (eg 'Event', 'Attendee', etc.) and values are arrays of query params like on EEM_Base::get_all |
608 | - * @return array on success, FALSE on fail |
|
608 | + * @return boolean on success, FALSE on fail |
|
609 | 609 | */ |
610 | 610 | private function _get_export_data_for_models( $models_to_export = array() ) { |
611 | 611 | $table_data = FALSE; |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
2 | -do_action( 'AHEE_log', __FILE__, __FUNCTION__, '' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
2 | +do_action('AHEE_log', __FILE__, __FUNCTION__, ''); |
|
3 | 3 | /** |
4 | 4 | * EE_Export class |
5 | 5 | * |
@@ -41,11 +41,11 @@ discard block |
||
41 | 41 | * @access private |
42 | 42 | * @param array $request_data |
43 | 43 | */ |
44 | - private function __construct( $request_data = array() ) { |
|
44 | + private function __construct($request_data = array()) { |
|
45 | 45 | $this->_req_data = $request_data; |
46 | - $this->today = date("Y-m-d",time()); |
|
47 | - require_once( EE_CLASSES . 'EE_CSV.class.php' ); |
|
48 | - $this->EE_CSV= EE_CSV::instance(); |
|
46 | + $this->today = date("Y-m-d", time()); |
|
47 | + require_once(EE_CLASSES.'EE_CSV.class.php'); |
|
48 | + $this->EE_CSV = EE_CSV::instance(); |
|
49 | 49 | } |
50 | 50 | |
51 | 51 | |
@@ -57,10 +57,10 @@ discard block |
||
57 | 57 | * @param array $request_data |
58 | 58 | * @return \EE_Export |
59 | 59 | */ |
60 | - public static function instance( $request_data = array() ) { |
|
60 | + public static function instance($request_data = array()) { |
|
61 | 61 | // check if class object is instantiated |
62 | - if ( self::$_instance === NULL or ! is_object( self::$_instance ) or ! ( self::$_instance instanceof EE_Export )) { |
|
63 | - self::$_instance = new self( $request_data ); |
|
62 | + if (self::$_instance === NULL or ! is_object(self::$_instance) or ! (self::$_instance instanceof EE_Export)) { |
|
63 | + self::$_instance = new self($request_data); |
|
64 | 64 | } |
65 | 65 | return self::$_instance; |
66 | 66 | } |
@@ -74,15 +74,15 @@ discard block |
||
74 | 74 | public function export() { |
75 | 75 | |
76 | 76 | // in case of bulk exports, the "actual" action will be in action2, but first check regular action for "export" keyword |
77 | - if ( isset( $this->_req_data['action'] ) && strpos( $this->_req_data['action'], 'export' ) === FALSE ) { |
|
77 | + if (isset($this->_req_data['action']) && strpos($this->_req_data['action'], 'export') === FALSE) { |
|
78 | 78 | // check if action2 has export action |
79 | - if ( isset( $this->_req_data['action2'] ) && strpos( $this->_req_data['action2'], 'export' ) !== FALSE ) { |
|
79 | + if (isset($this->_req_data['action2']) && strpos($this->_req_data['action2'], 'export') !== FALSE) { |
|
80 | 80 | // whoop! there it is! |
81 | 81 | $this->_req_data['action'] = $this->_req_data['action2']; |
82 | 82 | } |
83 | 83 | } |
84 | 84 | |
85 | - $this->_req_data['export'] = isset( $this->_req_data['export'] ) ? $this->_req_data['export'] : ''; |
|
85 | + $this->_req_data['export'] = isset($this->_req_data['export']) ? $this->_req_data['export'] : ''; |
|
86 | 86 | |
87 | 87 | switch ($this->_req_data['export']) { |
88 | 88 | case 'report': |
@@ -99,7 +99,7 @@ discard block |
||
99 | 99 | break; |
100 | 100 | |
101 | 101 | case 'registrations_report_for_event': |
102 | - $this->report_registrations_for_event( $this->_req_data['EVT_ID'] ); |
|
102 | + $this->report_registrations_for_event($this->_req_data['EVT_ID']); |
|
103 | 103 | break; |
104 | 104 | |
105 | 105 | case 'attendees': |
@@ -111,7 +111,7 @@ discard block |
||
111 | 111 | break; |
112 | 112 | |
113 | 113 | default: |
114 | - EE_Error::add_error(__('An error occurred! The requested export report could not be found.','event_espresso'), __FILE__, __FUNCTION__, __LINE__ ) ; |
|
114 | + EE_Error::add_error(__('An error occurred! The requested export report could not be found.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
115 | 115 | return FALSE; |
116 | 116 | break; |
117 | 117 | |
@@ -139,12 +139,12 @@ discard block |
||
139 | 139 | |
140 | 140 | $models_to_export = EE_Registry::instance()->non_abstract_db_models; |
141 | 141 | |
142 | - $table_data = $this->_get_export_data_for_models( array_keys( $models_to_export ) ); |
|
142 | + $table_data = $this->_get_export_data_for_models(array_keys($models_to_export)); |
|
143 | 143 | |
144 | - $filename = $this->generate_filename ( 'full-db-export' ); |
|
144 | + $filename = $this->generate_filename('full-db-export'); |
|
145 | 145 | |
146 | - if ( ! $this->EE_CSV->export_multiple_model_data_to_csv( $filename,$table_data )) { |
|
147 | - EE_Error::add_error(__("An error occurred and the Event details could not be exported from the database.", "event_espresso"), __FILE__, __FUNCTION__, __LINE__ ); |
|
146 | + if ( ! $this->EE_CSV->export_multiple_model_data_to_csv($filename, $table_data)) { |
|
147 | + EE_Error::add_error(__("An error occurred and the Event details could not be exported from the database.", "event_espresso"), __FILE__, __FUNCTION__, __LINE__); |
|
148 | 148 | } |
149 | 149 | } |
150 | 150 | |
@@ -152,7 +152,7 @@ discard block |
||
152 | 152 | * Downloads a CSV file with all the columns, but no data. This should be used for importing |
153 | 153 | * @return null kills execution |
154 | 154 | */ |
155 | - function export_sample(){ |
|
155 | + function export_sample() { |
|
156 | 156 | $event = EEM_Event::instance()->get_one(); |
157 | 157 | $this->_req_data['EVT_ID'] = $event->ID(); |
158 | 158 | $this->export_all_event_data(); |
@@ -178,23 +178,23 @@ discard block |
||
178 | 178 | $state_country_query_params = array(); |
179 | 179 | $question_group_query_params = array(); |
180 | 180 | $question_query_params = array(); |
181 | - if ( isset( $this->_req_data['EVT_ID'] )) { |
|
181 | + if (isset($this->_req_data['EVT_ID'])) { |
|
182 | 182 | // do we have an array of IDs ? |
183 | 183 | |
184 | - if ( is_array( $this->_req_data['EVT_ID'] )) { |
|
185 | - $EVT_IDs = array_map( 'sanitize_text_field', $this->_req_data['EVT_ID'] ); |
|
186 | - $value_to_equal = array('IN',$EVT_IDs); |
|
184 | + if (is_array($this->_req_data['EVT_ID'])) { |
|
185 | + $EVT_IDs = array_map('sanitize_text_field', $this->_req_data['EVT_ID']); |
|
186 | + $value_to_equal = array('IN', $EVT_IDs); |
|
187 | 187 | $filename = 'events'; |
188 | 188 | } else { |
189 | 189 | // generate regular where = clause |
190 | - $EVT_ID = absint( $this->_req_data['EVT_ID'] ); |
|
190 | + $EVT_ID = absint($this->_req_data['EVT_ID']); |
|
191 | 191 | $value_to_equal = $EVT_ID; |
192 | 192 | $event = EE_Registry::instance()->load_model('Event')->get_one_by_ID($EVT_ID); |
193 | 193 | |
194 | - $filename = 'event-' . ( $event instanceof EE_Event ? $event->slug() : __( 'unknown', 'event_espresso' ) ); |
|
194 | + $filename = 'event-'.($event instanceof EE_Event ? $event->slug() : __('unknown', 'event_espresso')); |
|
195 | 195 | |
196 | 196 | } |
197 | - $event_query_params[0]['EVT_ID'] =$value_to_equal; |
|
197 | + $event_query_params[0]['EVT_ID'] = $value_to_equal; |
|
198 | 198 | $related_models_query_params[0]['Event.EVT_ID'] = $value_to_equal; |
199 | 199 | $related_through_reg_query_params[0]['Registration.EVT_ID'] = $value_to_equal; |
200 | 200 | $datetime_ticket_query_params[0]['Datetime.EVT_ID'] = $value_to_equal; |
@@ -238,37 +238,37 @@ discard block |
||
238 | 238 | |
239 | 239 | ); |
240 | 240 | |
241 | - $model_data = $this->_get_export_data_for_models( $models_to_export ); |
|
241 | + $model_data = $this->_get_export_data_for_models($models_to_export); |
|
242 | 242 | |
243 | - $filename = $this->generate_filename ( $filename ); |
|
243 | + $filename = $this->generate_filename($filename); |
|
244 | 244 | |
245 | - if ( ! $this->EE_CSV->export_multiple_model_data_to_csv( $filename, $model_data )) { |
|
246 | - EE_Error::add_error(__("'An error occurred and the Event details could not be exported from the database.'", "event_espresso"), __FILE__, __FUNCTION__, __LINE__ ); |
|
245 | + if ( ! $this->EE_CSV->export_multiple_model_data_to_csv($filename, $model_data)) { |
|
246 | + EE_Error::add_error(__("'An error occurred and the Event details could not be exported from the database.'", "event_espresso"), __FILE__, __FUNCTION__, __LINE__); |
|
247 | 247 | } |
248 | 248 | } |
249 | 249 | |
250 | - function report_attendees(){ |
|
251 | - $attendee_rows = EEM_Attendee::instance()->get_all_wpdb_results( array( 'force_join' => array( 'State', 'Country' ) ) ); |
|
250 | + function report_attendees() { |
|
251 | + $attendee_rows = EEM_Attendee::instance()->get_all_wpdb_results(array('force_join' => array('State', 'Country'))); |
|
252 | 252 | $csv_data = array(); |
253 | - foreach( $attendee_rows as $attendee_row ){ |
|
253 | + foreach ($attendee_rows as $attendee_row) { |
|
254 | 254 | $csv_row = array(); |
255 | - foreach( EEM_Attendee::instance()->field_settings() as $field_name => $field_obj ){ |
|
256 | - if( $field_name == 'STA_ID' ){ |
|
257 | - $state_name_field = EEM_State::instance()->field_settings_for( 'STA_name' ); |
|
258 | - $csv_row[ __( 'State', 'event_espresso' ) ] = $attendee_row[ $state_name_field->get_qualified_column() ]; |
|
259 | - }elseif( $field_name == 'CNT_ISO' ){ |
|
260 | - $country_name_field = EEM_Country::instance()->field_settings_for( 'CNT_name' ); |
|
261 | - $csv_row[ __( 'Country', 'event_espresso' ) ] = $attendee_row[ $country_name_field->get_qualified_column() ]; |
|
262 | - }else{ |
|
263 | - $csv_row[ $field_obj->get_nicename() ] = $attendee_row[ $field_obj->get_qualified_column() ]; |
|
255 | + foreach (EEM_Attendee::instance()->field_settings() as $field_name => $field_obj) { |
|
256 | + if ($field_name == 'STA_ID') { |
|
257 | + $state_name_field = EEM_State::instance()->field_settings_for('STA_name'); |
|
258 | + $csv_row[__('State', 'event_espresso')] = $attendee_row[$state_name_field->get_qualified_column()]; |
|
259 | + }elseif ($field_name == 'CNT_ISO') { |
|
260 | + $country_name_field = EEM_Country::instance()->field_settings_for('CNT_name'); |
|
261 | + $csv_row[__('Country', 'event_espresso')] = $attendee_row[$country_name_field->get_qualified_column()]; |
|
262 | + } else { |
|
263 | + $csv_row[$field_obj->get_nicename()] = $attendee_row[$field_obj->get_qualified_column()]; |
|
264 | 264 | } |
265 | 265 | } |
266 | 266 | $csv_data[] = $csv_row; |
267 | 267 | } |
268 | 268 | |
269 | - $filename = $this->generate_filename ( 'contact-list-report' ); |
|
269 | + $filename = $this->generate_filename('contact-list-report'); |
|
270 | 270 | |
271 | - $handle = $this->EE_CSV->begin_sending_csv( $filename); |
|
271 | + $handle = $this->EE_CSV->begin_sending_csv($filename); |
|
272 | 272 | $this->EE_CSV->write_data_array_to_csv($handle, $csv_data); |
273 | 273 | $this->EE_CSV->end_sending_csv($handle); |
274 | 274 | } |
@@ -285,18 +285,18 @@ discard block |
||
285 | 285 | $countries_that_have_an_attendee = EEM_Country::instance()->get_all(array(0=>array('Attendee.ATT_ID'=>array('IS NOT NULL')))); |
286 | 286 | // $states_to_export_query_params |
287 | 287 | $models_to_export = array( |
288 | - 'Country'=>array(array('CNT_ISO'=>array('IN',array_keys($countries_that_have_an_attendee)))), |
|
289 | - 'State'=>array(array('STA_ID'=>array('IN',array_keys($states_that_have_an_attendee)))), |
|
288 | + 'Country'=>array(array('CNT_ISO'=>array('IN', array_keys($countries_that_have_an_attendee)))), |
|
289 | + 'State'=>array(array('STA_ID'=>array('IN', array_keys($states_that_have_an_attendee)))), |
|
290 | 290 | 'Attendee'=>array(), |
291 | 291 | ); |
292 | 292 | |
293 | 293 | |
294 | 294 | |
295 | - $model_data = $this->_get_export_data_for_models( $models_to_export ); |
|
296 | - $filename = $this->generate_filename ( 'all-attendees' ); |
|
295 | + $model_data = $this->_get_export_data_for_models($models_to_export); |
|
296 | + $filename = $this->generate_filename('all-attendees'); |
|
297 | 297 | |
298 | - if ( ! $this->EE_CSV->export_multiple_model_data_to_csv( $filename, $model_data )) { |
|
299 | - EE_Error::add_error(__('An error occurred and the Attendee data could not be exported from the database.','event_espresso'), __FILE__, __FUNCTION__, __LINE__ ); |
|
298 | + if ( ! $this->EE_CSV->export_multiple_model_data_to_csv($filename, $model_data)) { |
|
299 | + EE_Error::add_error(__('An error occurred and the Attendee data could not be exported from the database.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
300 | 300 | } |
301 | 301 | } |
302 | 302 | |
@@ -308,15 +308,15 @@ discard block |
||
308 | 308 | * @param boolean|string $pretty_schema true to display pretty, a string to use a specific "Schema", or false to NOT display pretty |
309 | 309 | * @return string |
310 | 310 | */ |
311 | - protected function _prepare_value_from_db_for_display( $model, $field_name, $raw_db_value, $pretty_schema = true ) { |
|
312 | - $field_obj = $model->field_settings_for( $field_name ); |
|
313 | - $value_on_model_obj = $field_obj->prepare_for_set_from_db( $raw_db_value ); |
|
314 | - if( $pretty_schema === true){ |
|
315 | - return $field_obj->prepare_for_pretty_echoing( $value_on_model_obj ); |
|
316 | - }elseif( is_string( $pretty_schema ) ) { |
|
317 | - return $field_obj->prepare_for_pretty_echoing($value_on_model_obj, $pretty_schema ); |
|
318 | - }else{ |
|
319 | - return $field_obj->prepare_for_get( $value_on_model_obj ); |
|
311 | + protected function _prepare_value_from_db_for_display($model, $field_name, $raw_db_value, $pretty_schema = true) { |
|
312 | + $field_obj = $model->field_settings_for($field_name); |
|
313 | + $value_on_model_obj = $field_obj->prepare_for_set_from_db($raw_db_value); |
|
314 | + if ($pretty_schema === true) { |
|
315 | + return $field_obj->prepare_for_pretty_echoing($value_on_model_obj); |
|
316 | + }elseif (is_string($pretty_schema)) { |
|
317 | + return $field_obj->prepare_for_pretty_echoing($value_on_model_obj, $pretty_schema); |
|
318 | + } else { |
|
319 | + return $field_obj->prepare_for_get($value_on_model_obj); |
|
320 | 320 | } |
321 | 321 | } |
322 | 322 | |
@@ -325,7 +325,7 @@ discard block |
||
325 | 325 | * and the questions associated with the registrations |
326 | 326 | * @param int $event_id |
327 | 327 | */ |
328 | - function report_registrations_for_event( $event_id = NULL ){ |
|
328 | + function report_registrations_for_event($event_id = NULL) { |
|
329 | 329 | $reg_fields_to_include = array( |
330 | 330 | 'TXN_ID', |
331 | 331 | 'ATT_ID', |
@@ -357,125 +357,125 @@ discard block |
||
357 | 357 | array( |
358 | 358 | 'OR' => array( |
359 | 359 | //don't include registrations from failed or abandoned transactions... |
360 | - 'Transaction.STS_ID' => array( 'NOT IN', array( EEM_Transaction::failed_status_code, EEM_Transaction::abandoned_status_code ) ), |
|
360 | + 'Transaction.STS_ID' => array('NOT IN', array(EEM_Transaction::failed_status_code, EEM_Transaction::abandoned_status_code)), |
|
361 | 361 | //unless the registration is approved, in which case include it regardless of transaction status |
362 | 362 | 'STS_ID' => EEM_Registration::status_id_approved |
363 | 363 | ), |
364 | - 'Ticket.TKT_deleted' => array( 'IN', array( true, false ) ) |
|
364 | + 'Ticket.TKT_deleted' => array('IN', array(true, false)) |
|
365 | 365 | ), |
366 | - 'order_by' => array('Transaction.TXN_ID'=>'asc','REG_count'=>'asc'), |
|
367 | - 'force_join' => array( 'Transaction', 'Ticket', 'Attendee' ) |
|
366 | + 'order_by' => array('Transaction.TXN_ID'=>'asc', 'REG_count'=>'asc'), |
|
367 | + 'force_join' => array('Transaction', 'Ticket', 'Attendee') |
|
368 | 368 | ), |
369 | 369 | $event_id |
370 | 370 | ); |
371 | - if( $event_id ){ |
|
372 | - $query_params[0]['EVT_ID'] = $event_id; |
|
373 | - }else{ |
|
374 | - $query_params[ 'force_join' ][] = 'Event'; |
|
371 | + if ($event_id) { |
|
372 | + $query_params[0]['EVT_ID'] = $event_id; |
|
373 | + } else { |
|
374 | + $query_params['force_join'][] = 'Event'; |
|
375 | 375 | } |
376 | - $registration_rows = $reg_model->get_all_wpdb_results( $query_params ); |
|
376 | + $registration_rows = $reg_model->get_all_wpdb_results($query_params); |
|
377 | 377 | //get all questions which relate to someone in this group |
378 | 378 | $registration_ids = array(); |
379 | - foreach( $registration_rows as $reg_row ) { |
|
380 | - $registration_ids[] = intval( $reg_row[ 'Registration.REG_ID'] ); |
|
379 | + foreach ($registration_rows as $reg_row) { |
|
380 | + $registration_ids[] = intval($reg_row['Registration.REG_ID']); |
|
381 | 381 | } |
382 | 382 | // EEM_Question::instance()->show_next_x_db_queries(); |
383 | - $questions_for_these_regs_rows = EEM_Question::instance()->get_all_wpdb_results(array(array('Answer.REG_ID'=>array('IN',$registration_ids)))); |
|
384 | - foreach($registration_rows as $reg_row){ |
|
385 | - if ( is_array( $reg_row ) ) { |
|
383 | + $questions_for_these_regs_rows = EEM_Question::instance()->get_all_wpdb_results(array(array('Answer.REG_ID'=>array('IN', $registration_ids)))); |
|
384 | + foreach ($registration_rows as $reg_row) { |
|
385 | + if (is_array($reg_row)) { |
|
386 | 386 | $reg_csv_array = array(); |
387 | - if( ! $event_id ){ |
|
387 | + if ( ! $event_id) { |
|
388 | 388 | //get the event's name and Id |
389 | - $reg_csv_array[ __( 'Event', 'event_espresso' ) ] = sprintf( __( '%1$s (%2$s)', 'event_espresso' ), $this->_prepare_value_from_db_for_display( EEM_Event::instance(), 'EVT_name', $reg_row[ 'Event_CPT.post_title'] ), $reg_row[ 'Event_CPT.ID' ] ); |
|
389 | + $reg_csv_array[__('Event', 'event_espresso')] = sprintf(__('%1$s (%2$s)', 'event_espresso'), $this->_prepare_value_from_db_for_display(EEM_Event::instance(), 'EVT_name', $reg_row['Event_CPT.post_title']), $reg_row['Event_CPT.ID']); |
|
390 | 390 | } |
391 | - $is_primary_reg = $reg_row[ 'Registration.REG_count' ] == '1' ? true : false; |
|
391 | + $is_primary_reg = $reg_row['Registration.REG_count'] == '1' ? true : false; |
|
392 | 392 | /*@var $reg_row EE_Registration */ |
393 | - foreach($reg_fields_to_include as $field_name){ |
|
393 | + foreach ($reg_fields_to_include as $field_name) { |
|
394 | 394 | $field = $reg_model->field_settings_for($field_name); |
395 | - if($field_name == 'REG_final_price'){ |
|
396 | - $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_final_price'], 'localized_float' ); |
|
397 | - }elseif( $field_name == 'REG_count' ){ |
|
398 | - $value = sprintf( __( '%s of %s', 'event_espresso' ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_count', $reg_row['Registration.REG_count'] ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_group_size', $reg_row['Registration.REG_group_size' ] ) ); |
|
399 | - }elseif( $field_name == 'REG_date' ) { |
|
400 | - $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_date'], 'no_html' ); |
|
401 | - }else{ |
|
402 | - $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ $field->get_qualified_column() ] ); |
|
395 | + if ($field_name == 'REG_final_price') { |
|
396 | + $value = $this->_prepare_value_from_db_for_display($reg_model, $field_name, $reg_row['Registration.REG_final_price'], 'localized_float'); |
|
397 | + }elseif ($field_name == 'REG_count') { |
|
398 | + $value = sprintf(__('%s of %s', 'event_espresso'), $this->_prepare_value_from_db_for_display($reg_model, 'REG_count', $reg_row['Registration.REG_count']), $this->_prepare_value_from_db_for_display($reg_model, 'REG_group_size', $reg_row['Registration.REG_group_size'])); |
|
399 | + }elseif ($field_name == 'REG_date') { |
|
400 | + $value = $this->_prepare_value_from_db_for_display($reg_model, $field_name, $reg_row['Registration.REG_date'], 'no_html'); |
|
401 | + } else { |
|
402 | + $value = $this->_prepare_value_from_db_for_display($reg_model, $field_name, $reg_row[$field->get_qualified_column()]); |
|
403 | 403 | } |
404 | 404 | $reg_csv_array[$this->_get_column_name_for_field($field)] = $value; |
405 | - if($field_name == 'REG_final_price'){ |
|
405 | + if ($field_name == 'REG_final_price') { |
|
406 | 406 | //add a column named Currency after the final price |
407 | 407 | $reg_csv_array[__("Currency", "event_espresso")] = EE_Config::instance()->currency->code; |
408 | 408 | } |
409 | 409 | } |
410 | 410 | //get pretty status |
411 | - $stati = EEM_Status::instance()->localized_status( array( |
|
412 | - $reg_row[ 'Registration.STS_ID' ] => __( 'unknown', 'event_espresso' ), |
|
413 | - $reg_row[ 'Transaction.STS_ID' ] => __( 'unknown', 'event_espresso' ) ), |
|
411 | + $stati = EEM_Status::instance()->localized_status(array( |
|
412 | + $reg_row['Registration.STS_ID'] => __('unknown', 'event_espresso'), |
|
413 | + $reg_row['Transaction.STS_ID'] => __('unknown', 'event_espresso') ), |
|
414 | 414 | FALSE, |
415 | - 'sentence' ); |
|
416 | - $reg_csv_array[__("Registration Status", 'event_espresso')] = $stati[ $reg_row[ 'Registration.STS_ID' ] ]; |
|
415 | + 'sentence'); |
|
416 | + $reg_csv_array[__("Registration Status", 'event_espresso')] = $stati[$reg_row['Registration.STS_ID']]; |
|
417 | 417 | //get pretty trnasaction status |
418 | - $reg_csv_array[__("Transaction Status", 'event_espresso')] = $stati[ $reg_row[ 'Transaction.STS_ID' ] ]; |
|
419 | - $reg_csv_array[ __( 'Transaction Amount Due', 'event_espresso' ) ] = $is_primary_reg ? $this->_prepare_value_from_db_for_display( EEM_Transaction::instance(), 'TXN_total', $reg_row[ 'Transaction.TXN_total' ], 'localized_float' ) : '0.00'; |
|
420 | - $reg_csv_array[ __( 'Amount Paid', 'event_espresso' )] = $is_primary_reg ? $this->_prepare_value_from_db_for_display( EEM_Transaction::instance(), 'TXN_paid', $reg_row[ 'Transaction.TXN_paid' ], 'localized_float' ) : '0.00'; |
|
418 | + $reg_csv_array[__("Transaction Status", 'event_espresso')] = $stati[$reg_row['Transaction.STS_ID']]; |
|
419 | + $reg_csv_array[__('Transaction Amount Due', 'event_espresso')] = $is_primary_reg ? $this->_prepare_value_from_db_for_display(EEM_Transaction::instance(), 'TXN_total', $reg_row['Transaction.TXN_total'], 'localized_float') : '0.00'; |
|
420 | + $reg_csv_array[__('Amount Paid', 'event_espresso')] = $is_primary_reg ? $this->_prepare_value_from_db_for_display(EEM_Transaction::instance(), 'TXN_paid', $reg_row['Transaction.TXN_paid'], 'localized_float') : '0.00'; |
|
421 | 421 | $payment_methods = array(); |
422 | 422 | $gateway_txn_ids_etc = array(); |
423 | 423 | $payment_times = array(); |
424 | - if( $is_primary_reg && $reg_row[ 'Transaction.TXN_ID' ] ){ |
|
424 | + if ($is_primary_reg && $reg_row['Transaction.TXN_ID']) { |
|
425 | 425 | $payments_info = EEM_Payment::instance()->get_all_wpdb_results( |
426 | 426 | array( |
427 | 427 | array( |
428 | - 'TXN_ID' => $reg_row[ 'Transaction.TXN_ID' ], |
|
428 | + 'TXN_ID' => $reg_row['Transaction.TXN_ID'], |
|
429 | 429 | 'STS_ID' => EEM_Payment::status_id_approved |
430 | 430 | ), |
431 | - 'force_join' => array( 'Payment_Method' ), |
|
431 | + 'force_join' => array('Payment_Method'), |
|
432 | 432 | |
433 | 433 | ), |
434 | 434 | ARRAY_A, |
435 | 435 | 'Payment_Method.PMD_admin_name as name, Payment.PAY_txn_id_chq_nmbr as gateway_txn_id, Payment.PAY_timestamp as payment_time' ); |
436 | 436 | |
437 | - foreach( $payments_info as $payment_method_and_gateway_txn_id ){ |
|
438 | - $payment_methods[] = isset( $payment_method_and_gateway_txn_id[ 'name' ] ) ? $payment_method_and_gateway_txn_id[ 'name' ] : __( 'Unknown', 'event_espresso' ); |
|
439 | - $gateway_txn_ids_etc[] = isset( $payment_method_and_gateway_txn_id[ 'gateway_txn_id' ] ) ? $payment_method_and_gateway_txn_id[ 'gateway_txn_id' ] : ''; |
|
440 | - $payment_times[] = isset( $payment_method_and_gateway_txn_id[ 'payment_time' ] ) ? $payment_method_and_gateway_txn_id[ 'payment_time' ] : ''; |
|
437 | + foreach ($payments_info as $payment_method_and_gateway_txn_id) { |
|
438 | + $payment_methods[] = isset($payment_method_and_gateway_txn_id['name']) ? $payment_method_and_gateway_txn_id['name'] : __('Unknown', 'event_espresso'); |
|
439 | + $gateway_txn_ids_etc[] = isset($payment_method_and_gateway_txn_id['gateway_txn_id']) ? $payment_method_and_gateway_txn_id['gateway_txn_id'] : ''; |
|
440 | + $payment_times[] = isset($payment_method_and_gateway_txn_id['payment_time']) ? $payment_method_and_gateway_txn_id['payment_time'] : ''; |
|
441 | 441 | } |
442 | 442 | |
443 | 443 | } |
444 | - $reg_csv_array[ __( 'Payment Date(s)', 'event_espresso' ) ] = implode( ',', $payment_times ); |
|
445 | - $reg_csv_array[ __( 'Payment Method(s)', 'event_espresso' ) ] = implode( ",", $payment_methods ); |
|
446 | - $reg_csv_array[ __( 'Gateway Transaction ID(s)', 'event_espresso' )] = implode( ',', $gateway_txn_ids_etc ); |
|
444 | + $reg_csv_array[__('Payment Date(s)', 'event_espresso')] = implode(',', $payment_times); |
|
445 | + $reg_csv_array[__('Payment Method(s)', 'event_espresso')] = implode(",", $payment_methods); |
|
446 | + $reg_csv_array[__('Gateway Transaction ID(s)', 'event_espresso')] = implode(',', $gateway_txn_ids_etc); |
|
447 | 447 | |
448 | 448 | //get whether or not the user has checked in |
449 | - $reg_csv_array[__("Check-Ins", "event_espresso")] = $reg_model->count_related( $reg_row[ 'Registration.REG_ID'] , 'Checkin' ); |
|
449 | + $reg_csv_array[__("Check-Ins", "event_espresso")] = $reg_model->count_related($reg_row['Registration.REG_ID'], 'Checkin'); |
|
450 | 450 | //get ticket of registration and its price |
451 | 451 | $ticket_model = EE_Registry::instance()->load_model('Ticket'); |
452 | - if( $reg_row[ 'Ticket.TKT_ID'] ) { |
|
453 | - $ticket_name = $this->_prepare_value_from_db_for_display( $ticket_model, 'TKT_name', $reg_row[ 'Ticket.TKT_name' ] ); |
|
452 | + if ($reg_row['Ticket.TKT_ID']) { |
|
453 | + $ticket_name = $this->_prepare_value_from_db_for_display($ticket_model, 'TKT_name', $reg_row['Ticket.TKT_name']); |
|
454 | 454 | $datetimes_strings = array(); |
455 | - foreach( EEM_Datetime::instance()->get_all( array( array( 'Ticket.TKT_ID' => $reg_row[ 'Ticket.TKT_ID' ] ), 'order_by' => array( 'DTT_EVT_start' => 'ASC' ), 'default_where_conditions' => 'none' ) ) as $datetime){ |
|
455 | + foreach (EEM_Datetime::instance()->get_all(array(array('Ticket.TKT_ID' => $reg_row['Ticket.TKT_ID']), 'order_by' => array('DTT_EVT_start' => 'ASC'), 'default_where_conditions' => 'none')) as $datetime) { |
|
456 | 456 | $datetimes_strings[] = $datetime->start_date_and_time(); |
457 | 457 | } |
458 | 458 | |
459 | 459 | } else { |
460 | - $ticket_name = __( 'Unknown', 'event_espresso' ); |
|
461 | - $datetimes_strings = array( __( 'Unknown', 'event_espresso' ) ); |
|
460 | + $ticket_name = __('Unknown', 'event_espresso'); |
|
461 | + $datetimes_strings = array(__('Unknown', 'event_espresso')); |
|
462 | 462 | } |
463 | 463 | $reg_csv_array[$ticket_model->field_settings_for('TKT_name')->get_nicename()] = $ticket_name; |
464 | 464 | $reg_csv_array[__("Datetimes of Ticket", "event_espresso")] = implode(", ", $datetimes_strings); |
465 | 465 | //get datetime(s) of registration |
466 | 466 | |
467 | 467 | //add attendee columns |
468 | - foreach($att_fields_to_include as $att_field_name){ |
|
468 | + foreach ($att_fields_to_include as $att_field_name) { |
|
469 | 469 | $field_obj = EEM_Attendee::instance()->field_settings_for($att_field_name); |
470 | - if( $reg_row[ 'Attendee_CPT.ID' ]){ |
|
471 | - if($att_field_name == 'STA_ID'){ |
|
472 | - $value = EEM_State::instance()->get_var( array( array( 'STA_ID' => $reg_row[ 'Attendee_Meta.STA_ID' ] ) ), 'STA_name' ); |
|
473 | - }elseif($att_field_name == 'CNT_ISO'){ |
|
474 | - $value = EEM_Country::instance()->get_var( array( array( 'CNT_ISO' => $reg_row[ 'Attendee_Meta.CNT_ISO' ] ) ), 'CNT_name' ); |
|
475 | - }else{ |
|
476 | - $value = $this->_prepare_value_from_db_for_display( EEM_Attendee::instance(), $att_field_name, $reg_row[ $field_obj->get_qualified_column() ] ); |
|
470 | + if ($reg_row['Attendee_CPT.ID']) { |
|
471 | + if ($att_field_name == 'STA_ID') { |
|
472 | + $value = EEM_State::instance()->get_var(array(array('STA_ID' => $reg_row['Attendee_Meta.STA_ID'])), 'STA_name'); |
|
473 | + }elseif ($att_field_name == 'CNT_ISO') { |
|
474 | + $value = EEM_Country::instance()->get_var(array(array('CNT_ISO' => $reg_row['Attendee_Meta.CNT_ISO'])), 'CNT_name'); |
|
475 | + } else { |
|
476 | + $value = $this->_prepare_value_from_db_for_display(EEM_Attendee::instance(), $att_field_name, $reg_row[$field_obj->get_qualified_column()]); |
|
477 | 477 | } |
478 | - }else{ |
|
478 | + } else { |
|
479 | 479 | $value = ''; |
480 | 480 | } |
481 | 481 | |
@@ -483,52 +483,52 @@ discard block |
||
483 | 483 | } |
484 | 484 | |
485 | 485 | //make sure each registration has the same questions in the same order |
486 | - foreach($questions_for_these_regs_rows as $question_row){ |
|
487 | - if( ! isset($reg_csv_array[$question_row[ 'Question.QST_admin_label']])){ |
|
488 | - $reg_csv_array[$question_row[ 'Question.QST_admin_label' ] ] = null; |
|
486 | + foreach ($questions_for_these_regs_rows as $question_row) { |
|
487 | + if ( ! isset($reg_csv_array[$question_row['Question.QST_admin_label']])) { |
|
488 | + $reg_csv_array[$question_row['Question.QST_admin_label']] = null; |
|
489 | 489 | } |
490 | 490 | } |
491 | 491 | //now fill out the questions THEY answered |
492 | - foreach( EEM_Answer::instance()->get_all_wpdb_results( array( array( 'REG_ID' => $reg_row[ 'Registration.REG_ID' ] ), 'force_join' => array( 'Question' ) ) ) as $answer_row){ |
|
492 | + foreach (EEM_Answer::instance()->get_all_wpdb_results(array(array('REG_ID' => $reg_row['Registration.REG_ID']), 'force_join' => array('Question'))) as $answer_row) { |
|
493 | 493 | /* @var $answer EE_Answer */ |
494 | - if( $answer_row[ 'Question.QST_ID' ] ){ |
|
495 | - $question_label = $this->_prepare_value_from_db_for_display( EEM_Question::instance(), 'QST_admin_label', $answer_row[ 'Question.QST_admin_label' ] ); |
|
496 | - }else{ |
|
497 | - $question_label = sprintf( __( 'Question $s', 'event_espresso' ), $answer_row[ 'Answer.QST_ID' ] ); |
|
494 | + if ($answer_row['Question.QST_ID']) { |
|
495 | + $question_label = $this->_prepare_value_from_db_for_display(EEM_Question::instance(), 'QST_admin_label', $answer_row['Question.QST_admin_label']); |
|
496 | + } else { |
|
497 | + $question_label = sprintf(__('Question $s', 'event_espresso'), $answer_row['Answer.QST_ID']); |
|
498 | 498 | } |
499 | - $reg_csv_array[ $question_label ] = $this->_prepare_value_from_db_for_display( EEM_Answer::instance(), 'ANS_value', $answer_row[ 'Answer.ANS_value' ] ); |
|
499 | + $reg_csv_array[$question_label] = $this->_prepare_value_from_db_for_display(EEM_Answer::instance(), 'ANS_value', $answer_row['Answer.ANS_value']); |
|
500 | 500 | } |
501 | - $registrations_csv_ready_array[] = apply_filters( 'FHEE__EE_Export__report_registrations__reg_csv_array', $reg_csv_array, $reg_row ); |
|
501 | + $registrations_csv_ready_array[] = apply_filters('FHEE__EE_Export__report_registrations__reg_csv_array', $reg_csv_array, $reg_row); |
|
502 | 502 | } |
503 | 503 | } |
504 | 504 | |
505 | 505 | //if we couldn't export anything, we want to at least show the column headers |
506 | - if(empty($registrations_csv_ready_array)){ |
|
506 | + if (empty($registrations_csv_ready_array)) { |
|
507 | 507 | $reg_csv_array = array(); |
508 | 508 | $model_and_fields_to_include = array( |
509 | 509 | 'Registration' => $reg_fields_to_include, |
510 | 510 | 'Attendee' => $att_fields_to_include |
511 | 511 | ); |
512 | - foreach($model_and_fields_to_include as $model_name => $field_list){ |
|
512 | + foreach ($model_and_fields_to_include as $model_name => $field_list) { |
|
513 | 513 | $model = EE_Registry::instance()->load_model($model_name); |
514 | - foreach($field_list as $field_name){ |
|
514 | + foreach ($field_list as $field_name) { |
|
515 | 515 | $field = $model->field_settings_for($field_name); |
516 | - $reg_csv_array[$this->_get_column_name_for_field($field)] = null;//$registration->get($field->get_name()); |
|
516 | + $reg_csv_array[$this->_get_column_name_for_field($field)] = null; //$registration->get($field->get_name()); |
|
517 | 517 | } |
518 | 518 | } |
519 | 519 | $registrations_csv_ready_array [] = $reg_csv_array; |
520 | 520 | } |
521 | - if( $event_id ){ |
|
522 | - $event_slug = EEM_Event::instance()->get_var( array( array( 'EVT_ID' => $event_id ) ), 'EVT_slug' ); |
|
523 | - if( ! $event_slug ) { |
|
524 | - $event_slug = __( 'unknown', 'event_espresso' ); |
|
521 | + if ($event_id) { |
|
522 | + $event_slug = EEM_Event::instance()->get_var(array(array('EVT_ID' => $event_id)), 'EVT_slug'); |
|
523 | + if ( ! $event_slug) { |
|
524 | + $event_slug = __('unknown', 'event_espresso'); |
|
525 | 525 | } |
526 | - }else{ |
|
527 | - $event_slug = __( 'all', 'event_espresso' ); |
|
526 | + } else { |
|
527 | + $event_slug = __('all', 'event_espresso'); |
|
528 | 528 | } |
529 | - $filename = sprintf( "registrations-for-%s", $event_slug ); |
|
529 | + $filename = sprintf("registrations-for-%s", $event_slug); |
|
530 | 530 | |
531 | - $handle = $this->EE_CSV->begin_sending_csv( $filename); |
|
531 | + $handle = $this->EE_CSV->begin_sending_csv($filename); |
|
532 | 532 | $this->EE_CSV->write_data_array_to_csv($handle, $registrations_csv_ready_array); |
533 | 533 | $this->EE_CSV->end_sending_csv($handle); |
534 | 534 | } |
@@ -538,7 +538,7 @@ discard block |
||
538 | 538 | * @param EE_Model_Field_Base $field |
539 | 539 | * @return string |
540 | 540 | */ |
541 | - protected function _get_column_name_for_field(EE_Model_Field_Base $field){ |
|
541 | + protected function _get_column_name_for_field(EE_Model_Field_Base $field) { |
|
542 | 542 | return $field->get_nicename()."[".$field->get_name()."]"; |
543 | 543 | } |
544 | 544 | |
@@ -551,17 +551,17 @@ discard block |
||
551 | 551 | function export_categories() { |
552 | 552 | // are any Event IDs set? |
553 | 553 | $query_params = array(); |
554 | - if ( isset( $this->_req_data['EVT_CAT_ID'] )) { |
|
554 | + if (isset($this->_req_data['EVT_CAT_ID'])) { |
|
555 | 555 | // do we have an array of IDs ? |
556 | - if ( is_array( $this->_req_data['EVT_CAT_ID'] )) { |
|
556 | + if (is_array($this->_req_data['EVT_CAT_ID'])) { |
|
557 | 557 | // generate an "IN (CSV)" where clause |
558 | - $EVT_CAT_IDs = array_map( 'sanitize_text_field', $this->_req_data['EVT_CAT_ID'] ); |
|
558 | + $EVT_CAT_IDs = array_map('sanitize_text_field', $this->_req_data['EVT_CAT_ID']); |
|
559 | 559 | $filename = 'event-categories'; |
560 | - $query_params[0]['term_taxonomy_id'] = array('IN',$EVT_CAT_IDs); |
|
560 | + $query_params[0]['term_taxonomy_id'] = array('IN', $EVT_CAT_IDs); |
|
561 | 561 | } else { |
562 | 562 | // generate regular where = clause |
563 | - $EVT_CAT_ID = absint( $this->_req_data['EVT_CAT_ID'] ); |
|
564 | - $filename = 'event-category#' . $EVT_CAT_ID; |
|
563 | + $EVT_CAT_ID = absint($this->_req_data['EVT_CAT_ID']); |
|
564 | + $filename = 'event-category#'.$EVT_CAT_ID; |
|
565 | 565 | $query_params[0]['term_taxonomy_id'] = $EVT_CAT_ID; |
566 | 566 | } |
567 | 567 | } else { |
@@ -573,11 +573,11 @@ discard block |
||
573 | 573 | 'Term_Taxonomy' => $query_params |
574 | 574 | ); |
575 | 575 | |
576 | - $table_data = $this->_get_export_data_for_models( $tables_to_export ); |
|
577 | - $filename = $this->generate_filename ( $filename ); |
|
576 | + $table_data = $this->_get_export_data_for_models($tables_to_export); |
|
577 | + $filename = $this->generate_filename($filename); |
|
578 | 578 | |
579 | - if ( ! $this->EE_CSV->export_multiple_model_data_to_csv( $filename, $table_data )) { |
|
580 | - EE_Error::add_error(__('An error occurred and the Category details could not be exported from the database.','event_espresso'), __FILE__, __FUNCTION__, __LINE__ ); |
|
579 | + if ( ! $this->EE_CSV->export_multiple_model_data_to_csv($filename, $table_data)) { |
|
580 | + EE_Error::add_error(__('An error occurred and the Category details could not be exported from the database.', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
581 | 581 | } |
582 | 582 | } |
583 | 583 | |
@@ -588,13 +588,13 @@ discard block |
||
588 | 588 | * @param string - export_name |
589 | 589 | * @return string on success, FALSE on fail |
590 | 590 | */ |
591 | - private function generate_filename ( $export_name = '' ) { |
|
592 | - if ( $export_name != '' ) { |
|
593 | - $filename = get_bloginfo('name') . '-' . $export_name; |
|
594 | - $filename = sanitize_key( $filename ) . '-' . $this->today; |
|
591 | + private function generate_filename($export_name = '') { |
|
592 | + if ($export_name != '') { |
|
593 | + $filename = get_bloginfo('name').'-'.$export_name; |
|
594 | + $filename = sanitize_key($filename).'-'.$this->today; |
|
595 | 595 | return $filename; |
596 | - } else { |
|
597 | - EE_Error::add_error(__("No filename was provided", "event_espresso"), __FILE__, __FUNCTION__, __LINE__ ); |
|
596 | + } else { |
|
597 | + EE_Error::add_error(__("No filename was provided", "event_espresso"), __FILE__, __FUNCTION__, __LINE__); |
|
598 | 598 | } |
599 | 599 | return false; |
600 | 600 | } |
@@ -607,12 +607,12 @@ discard block |
||
607 | 607 | * @param array $models_to_export keys are model names (eg 'Event', 'Attendee', etc.) and values are arrays of query params like on EEM_Base::get_all |
608 | 608 | * @return array on success, FALSE on fail |
609 | 609 | */ |
610 | - private function _get_export_data_for_models( $models_to_export = array() ) { |
|
610 | + private function _get_export_data_for_models($models_to_export = array()) { |
|
611 | 611 | $table_data = FALSE; |
612 | - if ( is_array( $models_to_export ) ) { |
|
613 | - foreach ( $models_to_export as $model_name => $query_params ) { |
|
612 | + if (is_array($models_to_export)) { |
|
613 | + foreach ($models_to_export as $model_name => $query_params) { |
|
614 | 614 | //check for a numerically-indexed array. in that case, $model_name is the value!! |
615 | - if(is_int($model_name)){ |
|
615 | + if (is_int($model_name)) { |
|
616 | 616 | $model_name = $query_params; |
617 | 617 | $query_params = array(); |
618 | 618 | } |
@@ -620,17 +620,17 @@ discard block |
||
620 | 620 | $model_objects = $model->get_all($query_params); |
621 | 621 | |
622 | 622 | $table_data[$model_name] = array(); |
623 | - foreach($model_objects as $model_object){ |
|
623 | + foreach ($model_objects as $model_object) { |
|
624 | 624 | $model_data_array = array(); |
625 | 625 | $fields = $model->field_settings(); |
626 | - foreach($fields as $field){ |
|
626 | + foreach ($fields as $field) { |
|
627 | 627 | $column_name = $field->get_nicename()."[".$field->get_name()."]"; |
628 | - if($field instanceof EE_Datetime_Field){ |
|
628 | + if ($field instanceof EE_Datetime_Field) { |
|
629 | 629 | // $field->set_date_format('Y-m-d'); |
630 | 630 | // $field->set_time_format('H:i:s'); |
631 | - $model_data_array[$column_name] = $model_object->get_datetime($field->get_name(),'Y-m-d','H:i:s'); |
|
631 | + $model_data_array[$column_name] = $model_object->get_datetime($field->get_name(), 'Y-m-d', 'H:i:s'); |
|
632 | 632 | } |
633 | - else{ |
|
633 | + else { |
|
634 | 634 | $model_data_array[$column_name] = $model_object->get($field->get_name()); |
635 | 635 | } |
636 | 636 | } |
@@ -1,4 +1,6 @@ discard block |
||
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 | do_action( 'AHEE_log', __FILE__, __FUNCTION__, '' ); |
3 | 5 | /** |
4 | 6 | * EE_Export class |
@@ -256,10 +258,10 @@ discard block |
||
256 | 258 | if( $field_name == 'STA_ID' ){ |
257 | 259 | $state_name_field = EEM_State::instance()->field_settings_for( 'STA_name' ); |
258 | 260 | $csv_row[ __( 'State', 'event_espresso' ) ] = $attendee_row[ $state_name_field->get_qualified_column() ]; |
259 | - }elseif( $field_name == 'CNT_ISO' ){ |
|
261 | + } elseif( $field_name == 'CNT_ISO' ){ |
|
260 | 262 | $country_name_field = EEM_Country::instance()->field_settings_for( 'CNT_name' ); |
261 | 263 | $csv_row[ __( 'Country', 'event_espresso' ) ] = $attendee_row[ $country_name_field->get_qualified_column() ]; |
262 | - }else{ |
|
264 | + } else{ |
|
263 | 265 | $csv_row[ $field_obj->get_nicename() ] = $attendee_row[ $field_obj->get_qualified_column() ]; |
264 | 266 | } |
265 | 267 | } |
@@ -313,9 +315,9 @@ discard block |
||
313 | 315 | $value_on_model_obj = $field_obj->prepare_for_set_from_db( $raw_db_value ); |
314 | 316 | if( $pretty_schema === true){ |
315 | 317 | return $field_obj->prepare_for_pretty_echoing( $value_on_model_obj ); |
316 | - }elseif( is_string( $pretty_schema ) ) { |
|
318 | + } elseif( is_string( $pretty_schema ) ) { |
|
317 | 319 | return $field_obj->prepare_for_pretty_echoing($value_on_model_obj, $pretty_schema ); |
318 | - }else{ |
|
320 | + } else{ |
|
319 | 321 | return $field_obj->prepare_for_get( $value_on_model_obj ); |
320 | 322 | } |
321 | 323 | } |
@@ -370,7 +372,7 @@ discard block |
||
370 | 372 | ); |
371 | 373 | if( $event_id ){ |
372 | 374 | $query_params[0]['EVT_ID'] = $event_id; |
373 | - }else{ |
|
375 | + } else{ |
|
374 | 376 | $query_params[ 'force_join' ][] = 'Event'; |
375 | 377 | } |
376 | 378 | $registration_rows = $reg_model->get_all_wpdb_results( $query_params ); |
@@ -394,11 +396,11 @@ discard block |
||
394 | 396 | $field = $reg_model->field_settings_for($field_name); |
395 | 397 | if($field_name == 'REG_final_price'){ |
396 | 398 | $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_final_price'], 'localized_float' ); |
397 | - }elseif( $field_name == 'REG_count' ){ |
|
399 | + } elseif( $field_name == 'REG_count' ){ |
|
398 | 400 | $value = sprintf( __( '%s of %s', 'event_espresso' ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_count', $reg_row['Registration.REG_count'] ), $this->_prepare_value_from_db_for_display( $reg_model, 'REG_group_size', $reg_row['Registration.REG_group_size' ] ) ); |
399 | - }elseif( $field_name == 'REG_date' ) { |
|
401 | + } elseif( $field_name == 'REG_date' ) { |
|
400 | 402 | $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ 'Registration.REG_date'], 'no_html' ); |
401 | - }else{ |
|
403 | + } else{ |
|
402 | 404 | $value = $this->_prepare_value_from_db_for_display( $reg_model, $field_name, $reg_row[ $field->get_qualified_column() ] ); |
403 | 405 | } |
404 | 406 | $reg_csv_array[$this->_get_column_name_for_field($field)] = $value; |
@@ -470,12 +472,12 @@ discard block |
||
470 | 472 | if( $reg_row[ 'Attendee_CPT.ID' ]){ |
471 | 473 | if($att_field_name == 'STA_ID'){ |
472 | 474 | $value = EEM_State::instance()->get_var( array( array( 'STA_ID' => $reg_row[ 'Attendee_Meta.STA_ID' ] ) ), 'STA_name' ); |
473 | - }elseif($att_field_name == 'CNT_ISO'){ |
|
475 | + } elseif($att_field_name == 'CNT_ISO'){ |
|
474 | 476 | $value = EEM_Country::instance()->get_var( array( array( 'CNT_ISO' => $reg_row[ 'Attendee_Meta.CNT_ISO' ] ) ), 'CNT_name' ); |
475 | - }else{ |
|
477 | + } else{ |
|
476 | 478 | $value = $this->_prepare_value_from_db_for_display( EEM_Attendee::instance(), $att_field_name, $reg_row[ $field_obj->get_qualified_column() ] ); |
477 | 479 | } |
478 | - }else{ |
|
480 | + } else{ |
|
479 | 481 | $value = ''; |
480 | 482 | } |
481 | 483 | |
@@ -493,7 +495,7 @@ discard block |
||
493 | 495 | /* @var $answer EE_Answer */ |
494 | 496 | if( $answer_row[ 'Question.QST_ID' ] ){ |
495 | 497 | $question_label = $this->_prepare_value_from_db_for_display( EEM_Question::instance(), 'QST_admin_label', $answer_row[ 'Question.QST_admin_label' ] ); |
496 | - }else{ |
|
498 | + } else{ |
|
497 | 499 | $question_label = sprintf( __( 'Question $s', 'event_espresso' ), $answer_row[ 'Answer.QST_ID' ] ); |
498 | 500 | } |
499 | 501 | $reg_csv_array[ $question_label ] = $this->_prepare_value_from_db_for_display( EEM_Answer::instance(), 'ANS_value', $answer_row[ 'Answer.ANS_value' ] ); |
@@ -523,7 +525,7 @@ discard block |
||
523 | 525 | if( ! $event_slug ) { |
524 | 526 | $event_slug = __( 'unknown', 'event_espresso' ); |
525 | 527 | } |
526 | - }else{ |
|
528 | + } else{ |
|
527 | 529 | $event_slug = __( 'all', 'event_espresso' ); |
528 | 530 | } |
529 | 531 | $filename = sprintf( "registrations-for-%s", $event_slug ); |
@@ -593,7 +595,7 @@ discard block |
||
593 | 595 | $filename = get_bloginfo('name') . '-' . $export_name; |
594 | 596 | $filename = sanitize_key( $filename ) . '-' . $this->today; |
595 | 597 | return $filename; |
596 | - } else { |
|
598 | + } else { |
|
597 | 599 | EE_Error::add_error(__("No filename was provided", "event_espresso"), __FILE__, __FUNCTION__, __LINE__ ); |
598 | 600 | } |
599 | 601 | return false; |
@@ -629,8 +631,7 @@ discard block |
||
629 | 631 | // $field->set_date_format('Y-m-d'); |
630 | 632 | // $field->set_time_format('H:i:s'); |
631 | 633 | $model_data_array[$column_name] = $model_object->get_datetime($field->get_name(),'Y-m-d','H:i:s'); |
632 | - } |
|
633 | - else{ |
|
634 | + } else{ |
|
634 | 635 | $model_data_array[$column_name] = $model_object->get($field->get_name()); |
635 | 636 | } |
636 | 637 | } |
@@ -49,7 +49,7 @@ discard block |
||
49 | 49 | |
50 | 50 | /** |
51 | 51 | * Gets FK_ID |
52 | - * @return int |
|
52 | + * @return boolean |
|
53 | 53 | */ |
54 | 54 | function FK_ID() { |
55 | 55 | return $this->get( 'FK_ID' ); |
@@ -60,7 +60,7 @@ discard block |
||
60 | 60 | /** |
61 | 61 | * Sets FK_ID |
62 | 62 | * @param int $FK_ID |
63 | - * @return boolean |
|
63 | + * @return boolean|null |
|
64 | 64 | */ |
65 | 65 | function set_FK_ID( $FK_ID ) { |
66 | 66 | $this->set( 'FK_ID', $FK_ID ); |
@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | |
71 | 71 | /** |
72 | 72 | * Gets model |
73 | - * @return string |
|
73 | + * @return boolean |
|
74 | 74 | */ |
75 | 75 | function model() { |
76 | 76 | return $this->get( 'EXM_model' ); |
@@ -81,7 +81,7 @@ discard block |
||
81 | 81 | /** |
82 | 82 | * Sets model |
83 | 83 | * @param string $model |
84 | - * @return boolean |
|
84 | + * @return boolean|null |
|
85 | 85 | */ |
86 | 86 | function set_model( $model ) { |
87 | 87 | $this->set( 'EXM_model', $model ); |
@@ -91,7 +91,7 @@ discard block |
||
91 | 91 | |
92 | 92 | /** |
93 | 93 | * Gets key |
94 | - * @return string |
|
94 | + * @return boolean |
|
95 | 95 | */ |
96 | 96 | function key() { |
97 | 97 | return $this->get( 'EXM_key' ); |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | /** |
103 | 103 | * Sets key |
104 | 104 | * @param string $key |
105 | - * @return boolean |
|
105 | + * @return boolean|null |
|
106 | 106 | */ |
107 | 107 | function set_key( $key ) { |
108 | 108 | $this->set( 'EXM_key', $key ); |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | |
113 | 113 | /** |
114 | 114 | * Gets value |
115 | - * @return string |
|
115 | + * @return boolean |
|
116 | 116 | */ |
117 | 117 | function value() { |
118 | 118 | return $this->get( 'EXM_value' ); |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | /** |
124 | 124 | * Sets value |
125 | 125 | * @param string $value |
126 | - * @return boolean |
|
126 | + * @return boolean|null |
|
127 | 127 | */ |
128 | 128 | function set_value( $value ) { |
129 | 129 | $this->set( 'EXM_value', $value ); |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
2 | - exit( 'No direct script access allowed' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | 3 | } |
4 | 4 | /** |
5 | 5 | * Event Espresso |
@@ -30,9 +30,9 @@ discard block |
||
30 | 30 | * @param array $props_n_values |
31 | 31 | * @return EE_Extra_Meta|mixed |
32 | 32 | */ |
33 | - public static function new_instance( $props_n_values = array() ) { |
|
34 | - $has_object = parent::_check_for_object( $props_n_values, __CLASS__ ); |
|
35 | - return $has_object ? $has_object : new self( $props_n_values ); |
|
33 | + public static function new_instance($props_n_values = array()) { |
|
34 | + $has_object = parent::_check_for_object($props_n_values, __CLASS__); |
|
35 | + return $has_object ? $has_object : new self($props_n_values); |
|
36 | 36 | } |
37 | 37 | |
38 | 38 | |
@@ -41,8 +41,8 @@ discard block |
||
41 | 41 | * @param array $props_n_values |
42 | 42 | * @return EE_Extra_Meta |
43 | 43 | */ |
44 | - public static function new_instance_from_db( $props_n_values = array() ) { |
|
45 | - return new self( $props_n_values, TRUE ); |
|
44 | + public static function new_instance_from_db($props_n_values = array()) { |
|
45 | + return new self($props_n_values, TRUE); |
|
46 | 46 | } |
47 | 47 | |
48 | 48 | |
@@ -52,7 +52,7 @@ discard block |
||
52 | 52 | * @return int |
53 | 53 | */ |
54 | 54 | function FK_ID() { |
55 | - return $this->get( 'FK_ID' ); |
|
55 | + return $this->get('FK_ID'); |
|
56 | 56 | } |
57 | 57 | |
58 | 58 | |
@@ -62,8 +62,8 @@ discard block |
||
62 | 62 | * @param int $FK_ID |
63 | 63 | * @return boolean |
64 | 64 | */ |
65 | - function set_FK_ID( $FK_ID ) { |
|
66 | - $this->set( 'FK_ID', $FK_ID ); |
|
65 | + function set_FK_ID($FK_ID) { |
|
66 | + $this->set('FK_ID', $FK_ID); |
|
67 | 67 | } |
68 | 68 | |
69 | 69 | |
@@ -73,7 +73,7 @@ discard block |
||
73 | 73 | * @return string |
74 | 74 | */ |
75 | 75 | function model() { |
76 | - return $this->get( 'EXM_model' ); |
|
76 | + return $this->get('EXM_model'); |
|
77 | 77 | } |
78 | 78 | |
79 | 79 | |
@@ -83,8 +83,8 @@ discard block |
||
83 | 83 | * @param string $model |
84 | 84 | * @return boolean |
85 | 85 | */ |
86 | - function set_model( $model ) { |
|
87 | - $this->set( 'EXM_model', $model ); |
|
86 | + function set_model($model) { |
|
87 | + $this->set('EXM_model', $model); |
|
88 | 88 | } |
89 | 89 | |
90 | 90 | |
@@ -94,7 +94,7 @@ discard block |
||
94 | 94 | * @return string |
95 | 95 | */ |
96 | 96 | function key() { |
97 | - return $this->get( 'EXM_key' ); |
|
97 | + return $this->get('EXM_key'); |
|
98 | 98 | } |
99 | 99 | |
100 | 100 | |
@@ -104,8 +104,8 @@ discard block |
||
104 | 104 | * @param string $key |
105 | 105 | * @return boolean |
106 | 106 | */ |
107 | - function set_key( $key ) { |
|
108 | - $this->set( 'EXM_key', $key ); |
|
107 | + function set_key($key) { |
|
108 | + $this->set('EXM_key', $key); |
|
109 | 109 | } |
110 | 110 | |
111 | 111 | |
@@ -115,7 +115,7 @@ discard block |
||
115 | 115 | * @return string |
116 | 116 | */ |
117 | 117 | function value() { |
118 | - return $this->get( 'EXM_value' ); |
|
118 | + return $this->get('EXM_value'); |
|
119 | 119 | } |
120 | 120 | |
121 | 121 | |
@@ -125,8 +125,8 @@ discard block |
||
125 | 125 | * @param string $value |
126 | 126 | * @return boolean |
127 | 127 | */ |
128 | - function set_value( $value ) { |
|
129 | - $this->set( 'EXM_value', $value ); |
|
128 | + function set_value($value) { |
|
129 | + $this->set('EXM_value', $value); |
|
130 | 130 | } |
131 | 131 | |
132 | 132 |