@@ -21,12 +21,12 @@ |
||
21 | 21 | $updated = $wpdb->update($this->_old_table, |
22 | 22 | array('PRT_wp_user'=>$user_id), |
23 | 23 | array('PRT_ID'=>$old_row['PRT_ID']), |
24 | - array('%d',//PRT_wp_user |
|
24 | + array('%d', //PRT_wp_user |
|
25 | 25 | ), |
26 | - array('%d',//PRT_ID |
|
26 | + array('%d', //PRT_ID |
|
27 | 27 | )); |
28 | - if ( FALSE === $updated ) { |
|
29 | - $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRT_wp_user = %d where PRT_ID = %d", 'event_espresso'),$user_id,$old_row['PRT_ID'])); |
|
28 | + if (FALSE === $updated) { |
|
29 | + $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRT_wp_user = %d where PRT_ID = %d", 'event_espresso'), $user_id, $old_row['PRT_ID'])); |
|
30 | 30 | } |
31 | 31 | } |
32 | 32 | } |
@@ -21,12 +21,12 @@ |
||
21 | 21 | $updated = $wpdb->update($this->_old_table, |
22 | 22 | array('PRC_wp_user'=>$user_id), |
23 | 23 | array('PRC_ID'=>$old_row['PRC_ID']), |
24 | - array('%d',//PRC_wp_user |
|
24 | + array('%d', //PRC_wp_user |
|
25 | 25 | ), |
26 | - array('%d',//PRC_ID |
|
26 | + array('%d', //PRC_ID |
|
27 | 27 | )); |
28 | - if ( FALSE === $updated ) { |
|
29 | - $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRC_wp_user = %d where PRC_ID = %d", 'event_espresso'),$user_id,$old_row['PRC_ID'])); |
|
28 | + if (FALSE === $updated) { |
|
29 | + $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRC_wp_user = %d where PRC_ID = %d", 'event_espresso'), $user_id, $old_row['PRC_ID'])); |
|
30 | 30 | } |
31 | 31 | } |
32 | 32 | } |
@@ -21,12 +21,12 @@ |
||
21 | 21 | $updated = $wpdb->update($this->_old_table, |
22 | 22 | array('QSG_wp_user'=>$user_id), |
23 | 23 | array('QSG_ID'=>$old_row['QSG_ID']), |
24 | - array('%d',//QSG_wp_user |
|
24 | + array('%d', //QSG_wp_user |
|
25 | 25 | ), |
26 | - array('%d',//QSG_ID |
|
26 | + array('%d', //QSG_ID |
|
27 | 27 | )); |
28 | - if ( FALSE === $updated ) { |
|
29 | - $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting QSG_wp_user = %d where QSG_ID = %d", 'event_espresso'),$user_id,$old_row['QSG_ID'])); |
|
28 | + if (FALSE === $updated) { |
|
29 | + $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting QSG_wp_user = %d where QSG_ID = %d", 'event_espresso'), $user_id, $old_row['QSG_ID'])); |
|
30 | 30 | } |
31 | 31 | } |
32 | 32 | } |
@@ -21,12 +21,12 @@ |
||
21 | 21 | $updated = $wpdb->update($this->_old_table, |
22 | 22 | array('TKT_wp_user'=>$user_id), |
23 | 23 | array('TKT_ID'=>$old_row['TKT_ID']), |
24 | - array('%d',//TKT_wp_user |
|
24 | + array('%d', //TKT_wp_user |
|
25 | 25 | ), |
26 | - array('%d',//TKT_ID |
|
26 | + array('%d', //TKT_ID |
|
27 | 27 | )); |
28 | - if ( FALSE === $updated ) { |
|
29 | - $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting TKT_wp_user = %d where TKT_ID = %d", 'event_espresso'),$user_id,$old_row['TKT_ID'])); |
|
28 | + if (FALSE === $updated) { |
|
29 | + $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting TKT_wp_user = %d where TKT_ID = %d", 'event_espresso'), $user_id, $old_row['TKT_ID'])); |
|
30 | 30 | } |
31 | 31 | } |
32 | 32 | } |
@@ -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,24 +12,24 @@ discard block |
||
12 | 12 | * @author Mike Nelson |
13 | 13 | * |
14 | 14 | */ |
15 | -class EE_DMS_4_6_0_billing_info extends EE_Data_Migration_Script_Stage_Table{ |
|
16 | - function __construct(){ |
|
15 | +class EE_DMS_4_6_0_billing_info extends EE_Data_Migration_Script_Stage_Table { |
|
16 | + function __construct() { |
|
17 | 17 | global $wpdb; |
18 | 18 | $this->_old_table = $wpdb->postmeta; |
19 | 19 | $this->_pretty_name = __('Billing Info', 'event_espresso'); |
20 | 20 | $this->_extra_where_sql = "WHERE meta_key LIKE 'billing_info_%'"; |
21 | 21 | parent::__construct(); |
22 | 22 | } |
23 | - protected function _migrate_old_row( $old_row ) { |
|
23 | + protected function _migrate_old_row($old_row) { |
|
24 | 24 | $new_billing_info = array(); |
25 | - $old_billing_info = maybe_unserialize( $old_row[ 'meta_value' ] ); |
|
26 | - $gateway_name = str_replace( "billing_info_",'',$old_row[ 'meta_key' ] ); |
|
25 | + $old_billing_info = maybe_unserialize($old_row['meta_value']); |
|
26 | + $gateway_name = str_replace("billing_info_", '', $old_row['meta_key']); |
|
27 | 27 | $repetitive_prefix = '_reg-page-billing-'; |
28 | - $repetitive_suffix = "-" . $gateway_name; |
|
29 | - foreach( $old_billing_info as $old_input_name => $input_value ){ |
|
30 | - $old_input_name_important_part = str_replace( array( $repetitive_prefix, $repetitive_suffix ), array( '', ''), $old_input_name ); |
|
28 | + $repetitive_suffix = "-".$gateway_name; |
|
29 | + foreach ($old_billing_info as $old_input_name => $input_value) { |
|
30 | + $old_input_name_important_part = str_replace(array($repetitive_prefix, $repetitive_suffix), array('', ''), $old_input_name); |
|
31 | 31 | |
32 | - switch( $old_input_name_important_part ){ |
|
32 | + switch ($old_input_name_important_part) { |
|
33 | 33 | case 'fname': |
34 | 34 | $new_input_name = 'first_name'; |
35 | 35 | break; |
@@ -39,7 +39,7 @@ discard block |
||
39 | 39 | case 'state': |
40 | 40 | //we used to store the state's id ,but now we just store the name |
41 | 41 | $new_input_name = $old_input_name_important_part; |
42 | - $input_value = $this->_get_state_name_by_ID( $input_value ); |
|
42 | + $input_value = $this->_get_state_name_by_ID($input_value); |
|
43 | 43 | break; |
44 | 44 | case 'card-nmbr': |
45 | 45 | $new_input_name = 'credit_card'; |
@@ -62,9 +62,9 @@ discard block |
||
62 | 62 | $new_input_name = $old_input_name_important_part; |
63 | 63 | |
64 | 64 | } |
65 | - $new_billing_info[ $new_input_name ] = $input_value; |
|
65 | + $new_billing_info[$new_input_name] = $input_value; |
|
66 | 66 | } |
67 | - update_post_meta( $old_row[ 'post_id' ], $old_row[ 'meta_key' ], $new_billing_info ); |
|
67 | + update_post_meta($old_row['post_id'], $old_row['meta_key'], $new_billing_info); |
|
68 | 68 | } |
69 | 69 | /** |
70 | 70 | * |
@@ -72,9 +72,9 @@ discard block |
||
72 | 72 | * @param int $id |
73 | 73 | * @return string |
74 | 74 | */ |
75 | - protected function _get_state_name_by_ID( $id ){ |
|
75 | + protected function _get_state_name_by_ID($id) { |
|
76 | 76 | global $wpdb; |
77 | - return $wpdb->get_var( $wpdb->prepare( "SELECT STA_name FROM " . $wpdb->prefix . "esp_state WHERE STA_ID = %d", $id ) ); |
|
77 | + return $wpdb->get_var($wpdb->prepare("SELECT STA_name FROM ".$wpdb->prefix."esp_state WHERE STA_ID = %d", $id)); |
|
78 | 78 | } |
79 | 79 | |
80 | 80 |
@@ -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,20 +12,20 @@ discard block |
||
12 | 12 | * @author Brent Christensen |
13 | 13 | * |
14 | 14 | */ |
15 | -class EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price extends EE_Data_Migration_Script_Stage_Table{ |
|
15 | +class EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price extends EE_Data_Migration_Script_Stage_Table { |
|
16 | 16 | |
17 | 17 | protected $_ticket_table; |
18 | 18 | |
19 | 19 | protected $_line_item_table; |
20 | 20 | |
21 | - function __construct(){ |
|
21 | + function __construct() { |
|
22 | 22 | /** @type WPDB $wpdb */ |
23 | 23 | global $wpdb; |
24 | - $this->_pretty_name = __( 'Registration Final Price Tax Calculations', 'event_espresso' ); |
|
24 | + $this->_pretty_name = __('Registration Final Price Tax Calculations', 'event_espresso'); |
|
25 | 25 | // define tables |
26 | - $this->_old_table = $wpdb->prefix . 'esp_registration'; |
|
27 | - $this->_ticket_table = $wpdb->prefix . 'esp_ticket'; |
|
28 | - $this->_line_item_table = $wpdb->prefix . 'esp_line_item'; |
|
26 | + $this->_old_table = $wpdb->prefix.'esp_registration'; |
|
27 | + $this->_ticket_table = $wpdb->prefix.'esp_ticket'; |
|
28 | + $this->_line_item_table = $wpdb->prefix.'esp_line_item'; |
|
29 | 29 | parent::__construct(); |
30 | 30 | } |
31 | 31 | |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | global $wpdb; |
56 | 56 | $SQL = "SELECT count( reg.REG_ID ) "; |
57 | 57 | $SQL .= $this->_get_rest_of_sql_for_query(); |
58 | - $count = $wpdb->get_var( $SQL ); |
|
58 | + $count = $wpdb->get_var($SQL); |
|
59 | 59 | return $count; |
60 | 60 | } |
61 | 61 | |
@@ -67,13 +67,13 @@ discard block |
||
67 | 67 | * @param int $limit |
68 | 68 | * @return array of arrays like $wpdb->get_results($sql, ARRAY_A) |
69 | 69 | */ |
70 | - protected function _get_rows( $limit ) { |
|
70 | + protected function _get_rows($limit) { |
|
71 | 71 | /** @type WPDB $wpdb */ |
72 | 72 | global $wpdb; |
73 | 73 | $start_at_record = $this->count_records_migrated(); |
74 | 74 | $SQL = "SELECT reg.REG_ID, reg.REG_final_price, line.LIN_ID "; |
75 | 75 | $SQL .= $this->_get_rest_of_sql_for_query(); |
76 | - $SQL .= $wpdb->prepare( "LIMIT %d, %d", $start_at_record, $limit ); |
|
76 | + $SQL .= $wpdb->prepare("LIMIT %d, %d", $start_at_record, $limit); |
|
77 | 77 | |
78 | 78 | // produces something like: |
79 | 79 | /* |
@@ -93,7 +93,7 @@ discard block |
||
93 | 93 | LIMIT 1, 50 |
94 | 94 | */ |
95 | 95 | |
96 | - return $wpdb->get_results( $SQL, ARRAY_A ); |
|
96 | + return $wpdb->get_results($SQL, ARRAY_A); |
|
97 | 97 | } |
98 | 98 | |
99 | 99 | |
@@ -102,38 +102,38 @@ discard block |
||
102 | 102 | * @param array $row |
103 | 103 | * @return void |
104 | 104 | */ |
105 | - protected function _migrate_old_row( $row ) { |
|
105 | + protected function _migrate_old_row($row) { |
|
106 | 106 | /** @type WPDB $wpdb */ |
107 | 107 | global $wpdb; |
108 | 108 | // ensure all required values are present |
109 | - if ( ! isset( $row[ 'REG_ID' ], $row[ 'REG_final_price' ], $row[ 'LIN_ID' ] )) { |
|
109 | + if ( ! isset($row['REG_ID'], $row['REG_final_price'], $row['LIN_ID'])) { |
|
110 | 110 | $this->add_error( |
111 | 111 | sprintf( |
112 | - __( 'Invalid query results returned with the following data:%1$s REG_ID=%2$d, REG_final_price=%3$d, LIN_ID=%4$f. Error: "%5$s"', 'event_espresso' ), |
|
112 | + __('Invalid query results returned with the following data:%1$s REG_ID=%2$d, REG_final_price=%3$d, LIN_ID=%4$f. Error: "%5$s"', 'event_espresso'), |
|
113 | 113 | '<br />', |
114 | - isset( $row[ 'REG_ID' ] ) ? $row[ 'REG_ID' ] : '', |
|
115 | - isset( $row[ 'REG_final_price' ] ) ? $row[ 'REG_final_price' ] : '', |
|
116 | - isset( $row[ 'LIN_ID' ] ) ? $row[ 'LIN_ID' ] : '', |
|
114 | + isset($row['REG_ID']) ? $row['REG_ID'] : '', |
|
115 | + isset($row['REG_final_price']) ? $row['REG_final_price'] : '', |
|
116 | + isset($row['LIN_ID']) ? $row['LIN_ID'] : '', |
|
117 | 117 | $wpdb->last_error |
118 | 118 | ) |
119 | 119 | ); |
120 | 120 | return; |
121 | 121 | } |
122 | 122 | // get tax subtotal |
123 | - $tax_subtotal_line_item_ID = $this->_get_line_item_ID_for_tax_subtotal( $row['LIN_ID'] ); |
|
124 | - if ( ! $tax_subtotal_line_item_ID ) { |
|
123 | + $tax_subtotal_line_item_ID = $this->_get_line_item_ID_for_tax_subtotal($row['LIN_ID']); |
|
124 | + if ( ! $tax_subtotal_line_item_ID) { |
|
125 | 125 | $this->add_error( |
126 | 126 | sprintf( |
127 | - __( 'Invalid line item ID returned. Error: "%1$s"', 'event_espresso' ), |
|
127 | + __('Invalid line item ID returned. Error: "%1$s"', 'event_espresso'), |
|
128 | 128 | $wpdb->last_error |
129 | 129 | ) |
130 | 130 | ); |
131 | 131 | return; |
132 | 132 | } |
133 | 133 | // now get taxes |
134 | - $taxes = $this->_get_tax_amounts( $tax_subtotal_line_item_ID ); |
|
134 | + $taxes = $this->_get_tax_amounts($tax_subtotal_line_item_ID); |
|
135 | 135 | // apply taxes to registration final price |
136 | - $this->_apply_taxes( $row[ 'REG_ID' ], $row[ 'REG_final_price' ], $taxes ); |
|
136 | + $this->_apply_taxes($row['REG_ID'], $row['REG_final_price'], $taxes); |
|
137 | 137 | |
138 | 138 | } |
139 | 139 | |
@@ -145,14 +145,14 @@ discard block |
||
145 | 145 | * @param int $LIN_ID |
146 | 146 | * @return int |
147 | 147 | */ |
148 | - protected function _get_line_item_ID_for_tax_subtotal( $LIN_ID ) { |
|
148 | + protected function _get_line_item_ID_for_tax_subtotal($LIN_ID) { |
|
149 | 149 | /** @type WPDB $wpdb */ |
150 | 150 | global $wpdb; |
151 | 151 | $SQL = "SELECT LIN_ID "; |
152 | 152 | $SQL .= "FROM {$this->_line_item_table} "; |
153 | 153 | $SQL .= "WHERE LIN_parent = %d "; |
154 | 154 | $SQL .= "AND LIN_code = 'taxes'"; |
155 | - return $wpdb->get_var( $wpdb->prepare( $SQL, $LIN_ID ) ); |
|
155 | + return $wpdb->get_var($wpdb->prepare($SQL, $LIN_ID)); |
|
156 | 156 | } |
157 | 157 | |
158 | 158 | |
@@ -163,13 +163,13 @@ discard block |
||
163 | 163 | * @param int $LIN_ID |
164 | 164 | * @return array |
165 | 165 | */ |
166 | - protected function _get_tax_amounts( $LIN_ID ) { |
|
166 | + protected function _get_tax_amounts($LIN_ID) { |
|
167 | 167 | /** @type WPDB $wpdb */ |
168 | 168 | global $wpdb; |
169 | 169 | $SQL = "SELECT LIN_percent "; |
170 | 170 | $SQL .= "FROM {$this->_line_item_table} "; |
171 | 171 | $SQL .= "WHERE LIN_parent = %d"; |
172 | - return $wpdb->get_results( $wpdb->prepare( $SQL, $LIN_ID ), OBJECT_K ); |
|
172 | + return $wpdb->get_results($wpdb->prepare($SQL, $LIN_ID), OBJECT_K); |
|
173 | 173 | } |
174 | 174 | |
175 | 175 | |
@@ -182,14 +182,14 @@ discard block |
||
182 | 182 | * @param array $taxes |
183 | 183 | * @return void |
184 | 184 | */ |
185 | - protected function _apply_taxes( $REG_ID = 0, $final_price = 0.00, $taxes = array() ) { |
|
186 | - if ( is_array( $taxes ) && ! empty( $taxes ) ) { |
|
185 | + protected function _apply_taxes($REG_ID = 0, $final_price = 0.00, $taxes = array()) { |
|
186 | + if (is_array($taxes) && ! empty($taxes)) { |
|
187 | 187 | $total_taxes = 0; |
188 | - foreach ( $taxes as $tax ) { |
|
189 | - $total_taxes += $final_price * ( $tax->LIN_percent / 100 ); |
|
188 | + foreach ($taxes as $tax) { |
|
189 | + $total_taxes += $final_price * ($tax->LIN_percent / 100); |
|
190 | 190 | } |
191 | 191 | $final_price += $total_taxes; |
192 | - $this->_update_registration_final_price( $REG_ID, $final_price ); |
|
192 | + $this->_update_registration_final_price($REG_ID, $final_price); |
|
193 | 193 | } |
194 | 194 | } |
195 | 195 | |
@@ -202,20 +202,20 @@ discard block |
||
202 | 202 | * @param float $REG_final_price |
203 | 203 | * @return void |
204 | 204 | */ |
205 | - protected function _update_registration_final_price( $REG_ID = 0, $REG_final_price = 0.00 ) { |
|
205 | + protected function _update_registration_final_price($REG_ID = 0, $REG_final_price = 0.00) { |
|
206 | 206 | /** @type WPDB $wpdb */ |
207 | 207 | global $wpdb; |
208 | 208 | $success = $wpdb->update( |
209 | 209 | $this->_old_table, |
210 | - array( 'REG_final_price' => $REG_final_price ), // data |
|
211 | - array( 'REG_ID' => $REG_ID ), // where |
|
212 | - array( '%f' ), // data format |
|
213 | - array( '%d' ) // where format |
|
210 | + array('REG_final_price' => $REG_final_price), // data |
|
211 | + array('REG_ID' => $REG_ID), // where |
|
212 | + array('%f'), // data format |
|
213 | + array('%d') // where format |
|
214 | 214 | ); |
215 | - if ( $success === false ) { |
|
215 | + if ($success === false) { |
|
216 | 216 | $this->add_error( |
217 | 217 | sprintf( |
218 | - __( 'Could not update registration final price value for registration ID=%1$d because "%2$s"', 'event_espresso' ), |
|
218 | + __('Could not update registration final price value for registration ID=%1$d because "%2$s"', 'event_espresso'), |
|
219 | 219 | $REG_ID, |
220 | 220 | $wpdb->last_error |
221 | 221 | ) |
@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | -if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
3 | 3 | exit('No direct script access allowed'); |
4 | 4 | } |
5 | 5 | |
@@ -13,7 +13,7 @@ discard block |
||
13 | 13 | * |
14 | 14 | * Migrates line items that used to have LIN_code="tickets" to "pre-tax-total" |
15 | 15 | */ |
16 | -class EE_DMS_4_8_0_pretax_totals extends EE_Data_Migration_Script_Stage{ |
|
16 | +class EE_DMS_4_8_0_pretax_totals extends EE_Data_Migration_Script_Stage { |
|
17 | 17 | |
18 | 18 | protected $_line_item_table_name; |
19 | 19 | |
@@ -53,10 +53,10 @@ discard block |
||
53 | 53 | global $wpdb; |
54 | 54 | $rows_updated = $wpdb->update( |
55 | 55 | $this->_line_item_table_name, |
56 | - array( 'LIN_code' => 'pre-tax-subtotal' ), |
|
57 | - array( 'LIN_code' => 'tickets' ), |
|
58 | - array( '%s' ), |
|
59 | - array( '%s' ) ); |
|
56 | + array('LIN_code' => 'pre-tax-subtotal'), |
|
57 | + array('LIN_code' => 'tickets'), |
|
58 | + array('%s'), |
|
59 | + array('%s') ); |
|
60 | 60 | $this->set_completed(); |
61 | 61 | return 1; |
62 | 62 | } |
@@ -21,12 +21,12 @@ |
||
21 | 21 | protected $_old_table; |
22 | 22 | |
23 | 23 | /** |
24 | - * Set in the constructor to add this sql to both the counting query in |
|
25 | - * EE_Data_Migration_Script_Stage_Table::_count_records_to_migrate() and |
|
26 | - * EE_Data_Migration_Script_Stage_Table::_get_rows(). |
|
27 | - * Eg "where column_name like '%some_value%'" |
|
28 | - * @var string |
|
29 | - */ |
|
24 | + * Set in the constructor to add this sql to both the counting query in |
|
25 | + * EE_Data_Migration_Script_Stage_Table::_count_records_to_migrate() and |
|
26 | + * EE_Data_Migration_Script_Stage_Table::_get_rows(). |
|
27 | + * Eg "where column_name like '%some_value%'" |
|
28 | + * @var string |
|
29 | + */ |
|
30 | 30 | protected $_extra_where_sql; |
31 | 31 | |
32 | 32 |
@@ -41,14 +41,14 @@ discard block |
||
41 | 41 | * @param int $num_items |
42 | 42 | * @return int number of items ACTUALLY migrated |
43 | 43 | */ |
44 | - function _migration_step($num_items=50){ |
|
45 | - $rows = $this->_get_rows( $num_items ); |
|
44 | + function _migration_step($num_items = 50) { |
|
45 | + $rows = $this->_get_rows($num_items); |
|
46 | 46 | $items_actually_migrated = 0; |
47 | - foreach($rows as $old_row){ |
|
47 | + foreach ($rows as $old_row) { |
|
48 | 48 | $this->_migrate_old_row($old_row); |
49 | 49 | $items_actually_migrated++; |
50 | 50 | } |
51 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
51 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
52 | 52 | $this->set_completed(); |
53 | 53 | } |
54 | 54 | return $items_actually_migrated; |
@@ -60,11 +60,11 @@ discard block |
||
60 | 60 | * @param int $limit |
61 | 61 | * @return array of arrays like $wpdb->get_results($sql, ARRAY_A) |
62 | 62 | */ |
63 | - protected function _get_rows( $limit ){ |
|
63 | + protected function _get_rows($limit) { |
|
64 | 64 | global $wpdb; |
65 | 65 | $start_at_record = $this->count_records_migrated(); |
66 | - $query = "SELECT * FROM {$this->_old_table} {$this->_extra_where_sql} " . $wpdb->prepare("LIMIT %d, %d",$start_at_record,$limit); |
|
67 | - return $wpdb->get_results($query,ARRAY_A); |
|
66 | + $query = "SELECT * FROM {$this->_old_table} {$this->_extra_where_sql} ".$wpdb->prepare("LIMIT %d, %d", $start_at_record, $limit); |
|
67 | + return $wpdb->get_results($query, ARRAY_A); |
|
68 | 68 | } |
69 | 69 | |
70 | 70 | |
@@ -75,8 +75,8 @@ discard block |
||
75 | 75 | */ |
76 | 76 | function _count_records_to_migrate() { |
77 | 77 | global $wpdb; |
78 | - $query = "SELECT COUNT(*) FROM {$this->_old_table} {$this->_extra_where_sql}"; |
|
79 | - $count = $wpdb->get_var( $query ); |
|
78 | + $query = "SELECT COUNT(*) FROM {$this->_old_table} {$this->_extra_where_sql}"; |
|
79 | + $count = $wpdb->get_var($query); |
|
80 | 80 | return $count; |
81 | 81 | } |
82 | 82 |
@@ -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 |
@@ -77,7 +77,7 @@ |
||
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 ); |