@@ -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 | 2 | |
| 3 | -if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
| 3 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
| 4 | 4 | exit('No direct script access allowed'); |
| 5 | 5 | } |
| 6 | 6 | |
@@ -13,7 +13,7 @@ discard block |
||
| 13 | 13 | * @author Brent Christensen |
| 14 | 14 | * |
| 15 | 15 | */ |
| 16 | -class EE_DMS_4_6_0_country_system_question extends EE_Data_Migration_Script_Stage_Table{ |
|
| 16 | +class EE_DMS_4_6_0_country_system_question extends EE_Data_Migration_Script_Stage_Table { |
|
| 17 | 17 | |
| 18 | 18 | |
| 19 | 19 | |
@@ -24,7 +24,7 @@ discard block |
||
| 24 | 24 | */ |
| 25 | 25 | public function __construct() { |
| 26 | 26 | global $wpdb; |
| 27 | - $this->_pretty_name = __( 'Country - System Question', 'event_espresso' ); |
|
| 27 | + $this->_pretty_name = __('Country - System Question', 'event_espresso'); |
|
| 28 | 28 | $this->_old_table = $wpdb->prefix.'esp_question'; |
| 29 | 29 | $this->_extra_where_sql = "WHERE QST_system = 'country'"; |
| 30 | 30 | parent::__construct(); |
@@ -37,21 +37,21 @@ discard block |
||
| 37 | 37 | * @param array $question an associative array where keys are column names and values are their values. |
| 38 | 38 | * @return null |
| 39 | 39 | */ |
| 40 | - protected function _migrate_old_row( $question ) { |
|
| 41 | - if ( $question['QST_ID'] && $question['QST_system'] == 'country' ) { |
|
| 40 | + protected function _migrate_old_row($question) { |
|
| 41 | + if ($question['QST_ID'] && $question['QST_system'] == 'country') { |
|
| 42 | 42 | global $wpdb; |
| 43 | 43 | $success = $wpdb->update( |
| 44 | 44 | $this->_old_table, |
| 45 | - array( 'QST_type' => 'COUNTRY' ), // data |
|
| 46 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
| 47 | - array( '%s' ), // data format |
|
| 48 | - array( '%d' ) // where format |
|
| 45 | + array('QST_type' => 'COUNTRY'), // data |
|
| 46 | + array('QST_ID' => $question['QST_ID']), // where |
|
| 47 | + array('%s'), // data format |
|
| 48 | + array('%d') // where format |
|
| 49 | 49 | ); |
| 50 | - if ( ! $success ) { |
|
| 50 | + if ( ! $success) { |
|
| 51 | 51 | $this->add_error( |
| 52 | 52 | sprintf( |
| 53 | - __( 'Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso' ), |
|
| 54 | - json_encode( $question['QST_system'] ), |
|
| 53 | + __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
| 54 | + json_encode($question['QST_system']), |
|
| 55 | 55 | $question['QST_ID'], |
| 56 | 56 | $wpdb->last_error |
| 57 | 57 | ) |
@@ -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 | |
@@ -14,7 +14,7 @@ discard block |
||
| 14 | 14 | * Migrates 4.1-4.5-style gateway settings (which were stores in EE_Config) |
| 15 | 15 | * to 4.6-style payment methods (which have their database table) |
| 16 | 16 | */ |
| 17 | -class EE_DMS_4_6_0_gateways extends EE_Data_Migration_Script_Stage{ |
|
| 17 | +class EE_DMS_4_6_0_gateways extends EE_Data_Migration_Script_Stage { |
|
| 18 | 18 | |
| 19 | 19 | protected $_new_table_name; |
| 20 | 20 | protected $_extra_meta_table_name; |
@@ -73,11 +73,11 @@ discard block |
||
| 73 | 73 | */ |
| 74 | 74 | protected function _migration_step($num_items_to_migrate = 50) { |
| 75 | 75 | $items_actually_migrated = 0; |
| 76 | - $gateways_to_deal_with = array_slice(EE_Config::instance()->gateway->payment_settings,$this->count_records_migrated(),$num_items_to_migrate); |
|
| 77 | - foreach($gateways_to_deal_with as $old_gateway_slug => $old_gateway_settings){ |
|
| 76 | + $gateways_to_deal_with = array_slice(EE_Config::instance()->gateway->payment_settings, $this->count_records_migrated(), $num_items_to_migrate); |
|
| 77 | + foreach ($gateways_to_deal_with as $old_gateway_slug => $old_gateway_settings) { |
|
| 78 | 78 | |
| 79 | - if( in_array( $old_gateway_slug, $this->_gateway_we_know_to_migrate ) ) { |
|
| 80 | - if( ! $old_gateway_settings){ |
|
| 79 | + if (in_array($old_gateway_slug, $this->_gateway_we_know_to_migrate)) { |
|
| 80 | + if ( ! $old_gateway_settings) { |
|
| 81 | 81 | //no settings existed for this gateway anyways... weird... |
| 82 | 82 | $items_actually_migrated++; |
| 83 | 83 | continue; |
@@ -86,16 +86,16 @@ discard block |
||
| 86 | 86 | $success = $this->_convert_gateway_settings( |
| 87 | 87 | $old_gateway_slug, |
| 88 | 88 | $old_gateway_settings, |
| 89 | - isset( EE_Config::instance()->gateway->active_gateways[ $old_gateway_slug ] ) ); |
|
| 90 | - if( $success ) { |
|
| 91 | - EE_Config::instance()->gateway->payment_settings[ $old_gateway_slug ] = 'Deprecated'; |
|
| 89 | + isset(EE_Config::instance()->gateway->active_gateways[$old_gateway_slug]) ); |
|
| 90 | + if ($success) { |
|
| 91 | + EE_Config::instance()->gateway->payment_settings[$old_gateway_slug] = 'Deprecated'; |
|
| 92 | 92 | } |
| 93 | 93 | } |
| 94 | 94 | $items_actually_migrated++; |
| 95 | 95 | } |
| 96 | 96 | |
| 97 | - EE_Config::instance()->update_espresso_config(false,false); |
|
| 98 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
| 97 | + EE_Config::instance()->update_espresso_config(false, false); |
|
| 98 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
| 99 | 99 | $this->set_completed(); |
| 100 | 100 | } |
| 101 | 101 | return $items_actually_migrated; |
@@ -108,22 +108,22 @@ discard block |
||
| 108 | 108 | * @param boolean $active indicates the gateway is currently active |
| 109 | 109 | * @return boolean success |
| 110 | 110 | */ |
| 111 | - protected function _convert_gateway_settings($old_gateway_slug,$old_gateway_settings,$active){ |
|
| 112 | - switch($old_gateway_slug){ |
|
| 111 | + protected function _convert_gateway_settings($old_gateway_slug, $old_gateway_settings, $active) { |
|
| 112 | + switch ($old_gateway_slug) { |
|
| 113 | 113 | case 'Aim': |
| 114 | 114 | $extra_meta_key_values = array( |
| 115 | 115 | 'login_id'=>$old_gateway_settings['authnet_aim_login_id'], |
| 116 | 116 | 'transaction_key'=>$old_gateway_settings['authnet_aim_transaction_key'], |
| 117 | 117 | 'test_transactions'=>$old_gateway_settings['test_transactions'] |
| 118 | 118 | ); |
| 119 | - $desc = __( 'Please provide the following billing information.', 'event_espresso' ); |
|
| 119 | + $desc = __('Please provide the following billing information.', 'event_espresso'); |
|
| 120 | 120 | break; |
| 121 | 121 | case 'Bank': |
| 122 | 122 | $extra_meta_key_values = array( |
| 123 | 123 | 'page_title'=>$old_gateway_settings['page_title'], |
| 124 | 124 | 'payment_instructions'=> |
| 125 | - sprintf( __('%1$s<br/>Name on Bank Account: %2$s<br/>Bank Account Number: %3$s<br/>Bank Name: %4$s<br/>Bank Address:%5$s', 'event_espresso'), $old_gateway_settings['bank_instructions'] , $old_gateway_settings['account_name'], $old_gateway_settings['account_number'], $old_gateway_settings['bank_name'], $old_gateway_settings['bank_address'] ) ); |
|
| 126 | - $desc = __( 'Make payment using an electronic funds transfer from your bank.', 'event_espresso' ); |
|
| 125 | + sprintf(__('%1$s<br/>Name on Bank Account: %2$s<br/>Bank Account Number: %3$s<br/>Bank Name: %4$s<br/>Bank Address:%5$s', 'event_espresso'), $old_gateway_settings['bank_instructions'], $old_gateway_settings['account_name'], $old_gateway_settings['account_number'], $old_gateway_settings['bank_name'], $old_gateway_settings['bank_address']) ); |
|
| 126 | + $desc = __('Make payment using an electronic funds transfer from your bank.', 'event_espresso'); |
|
| 127 | 127 | break; |
| 128 | 128 | case 'Check': |
| 129 | 129 | $extra_meta_key_values = array( |
@@ -131,7 +131,7 @@ discard block |
||
| 131 | 131 | 'payment_instructions'=>$old_gateway_settings['check_instructions'], |
| 132 | 132 | 'address_to_send_payment'=>$old_gateway_settings['payment_address'] |
| 133 | 133 | ); |
| 134 | - $desc = __( 'On the next page you will be given instructions on how to make a payment by check.', 'event_espresso' ); |
|
| 134 | + $desc = __('On the next page you will be given instructions on how to make a payment by check.', 'event_espresso'); |
|
| 135 | 135 | break; |
| 136 | 136 | case 'Invoice': |
| 137 | 137 | $extra_meta_key_values = array( |
@@ -139,23 +139,23 @@ discard block |
||
| 139 | 139 | 'pdf_payee_email' => $old_gateway_settings['template_invoice_email'], |
| 140 | 140 | 'pdf_payee_tax_number' => $old_gateway_settings['template_invoice_tax_number'], |
| 141 | 141 | 'pdf_payee_address' => $old_gateway_settings['template_invoice_address'], |
| 142 | - 'pdf_instructions' => $old_gateway_settings[ 'template_payment_instructions' ], |
|
| 143 | - 'pdf_logo_image' => $old_gateway_settings[ 'invoice_logo_url' ], |
|
| 144 | - 'page_confirmation_text' => isset( $old_gateway_settings[ 'page_instructions' ] ) ? $old_gateway_settings[ 'page_instructions' ] : '', |
|
| 145 | - 'page_extra_info' => isset( $old_gateway_settings[ 'payment_address' ] ) ? $old_gateway_settings[ 'payment_address' ] : '', |
|
| 142 | + 'pdf_instructions' => $old_gateway_settings['template_payment_instructions'], |
|
| 143 | + 'pdf_logo_image' => $old_gateway_settings['invoice_logo_url'], |
|
| 144 | + 'page_confirmation_text' => isset($old_gateway_settings['page_instructions']) ? $old_gateway_settings['page_instructions'] : '', |
|
| 145 | + 'page_extra_info' => isset($old_gateway_settings['payment_address']) ? $old_gateway_settings['payment_address'] : '', |
|
| 146 | 146 | 'legacy_invoice_css' => $old_gateway_settings['invoice_css'] |
| 147 | 147 | ); |
| 148 | 148 | //if they didnt want the invoiec gateway to show, pretend it was inactive |
| 149 | - if( ! $old_gateway_settings['show'] ){ |
|
| 149 | + if ( ! $old_gateway_settings['show']) { |
|
| 150 | 150 | $active = FALSE; |
| 151 | 151 | } |
| 152 | - $desc = __( 'On the next page you will be able to access your invoice and instructions on how to pay it.', 'event_espresso' ); |
|
| 152 | + $desc = __('On the next page you will be able to access your invoice and instructions on how to pay it.', 'event_espresso'); |
|
| 153 | 153 | break; |
| 154 | 154 | case 'Mijireh': |
| 155 | 155 | $extra_meta_key_values = array( |
| 156 | - 'access_key' => $old_gateway_settings[ 'access_key' ] |
|
| 156 | + 'access_key' => $old_gateway_settings['access_key'] |
|
| 157 | 157 | ); |
| 158 | - $desc = __( 'On the next page you will be able to enter your billing information to make the payment.', 'event_espresso' ); |
|
| 158 | + $desc = __('On the next page you will be able to enter your billing information to make the payment.', 'event_espresso'); |
|
| 159 | 159 | break; |
| 160 | 160 | case 'Paypal_Pro': |
| 161 | 161 | $extra_meta_key_values = array( |
@@ -164,31 +164,31 @@ discard block |
||
| 164 | 164 | 'signature'=>$old_gateway_settings['signature'], |
| 165 | 165 | 'credit_card_types'=>$old_gateway_settings['credit_cards'], |
| 166 | 166 | ); |
| 167 | - $desc = __( 'Please provide the following billing information.', 'event_espresso' ); |
|
| 167 | + $desc = __('Please provide the following billing information.', 'event_espresso'); |
|
| 168 | 168 | break; |
| 169 | 169 | case 'Paypal_Standard': |
| 170 | 170 | $extra_meta_key_values = array( |
| 171 | - 'paypal_id' => $old_gateway_settings[ 'paypal_id' ], |
|
| 172 | - 'image_url' => $old_gateway_settings[ 'image_url' ], |
|
| 173 | - 'shipping_details' => isset( $old_gateway_settings[ 'no_shipping' ] ) ? $old_gateway_settings[ 'no_shipping' ] : false, |
|
| 171 | + 'paypal_id' => $old_gateway_settings['paypal_id'], |
|
| 172 | + 'image_url' => $old_gateway_settings['image_url'], |
|
| 173 | + 'shipping_details' => isset($old_gateway_settings['no_shipping']) ? $old_gateway_settings['no_shipping'] : false, |
|
| 174 | 174 | |
| 175 | 175 | ); |
| 176 | - $desc = sprintf( __( 'After clicking \'Finalize Registration\', you will be forwarded to PayPal to make your payment. Make sure you return to this site in order to properly finalize your registration.', 'event_espresso' ), '<strong>','</strong>' ); |
|
| 176 | + $desc = sprintf(__('After clicking \'Finalize Registration\', you will be forwarded to PayPal to make your payment. Make sure you return to this site in order to properly finalize your registration.', 'event_espresso'), '<strong>', '</strong>'); |
|
| 177 | 177 | break; |
| 178 | 178 | default: |
| 179 | 179 | //if we don't recognize the payment method, just put everything in it into extra meta. At least this way its preserved somewhere |
| 180 | 180 | $extra_meta_key_values = $old_gateway_settings; |
| 181 | 181 | $desc = ''; |
| 182 | 182 | } |
| 183 | - $pretty_name = isset( $old_gateway_settings[ 'display_name' ] ) ? $old_gateway_settings[ 'display_name' ] : $old_gateway_slug; |
|
| 184 | - $offline_gateways = array( 'Bank', 'Check', 'Invoice' ); |
|
| 185 | - if( $active && in_array( $old_gateway_slug, $offline_gateways ) ) { |
|
| 186 | - $scope = array( 'CART', 'ADMIN'); |
|
| 187 | - }elseif( $active && ! in_array( $old_gateway_slug, $offline_gateways ) ) { |
|
| 188 | - $scope = array( 'CART' ); |
|
| 189 | - }elseif( ! $active && in_array($old_gateway_slug,$offline_gateways ) ) { |
|
| 190 | - $scope = array( 'ADMIN' ); |
|
| 191 | - }else{ |
|
| 183 | + $pretty_name = isset($old_gateway_settings['display_name']) ? $old_gateway_settings['display_name'] : $old_gateway_slug; |
|
| 184 | + $offline_gateways = array('Bank', 'Check', 'Invoice'); |
|
| 185 | + if ($active && in_array($old_gateway_slug, $offline_gateways)) { |
|
| 186 | + $scope = array('CART', 'ADMIN'); |
|
| 187 | + }elseif ($active && ! in_array($old_gateway_slug, $offline_gateways)) { |
|
| 188 | + $scope = array('CART'); |
|
| 189 | + }elseif ( ! $active && in_array($old_gateway_slug, $offline_gateways)) { |
|
| 190 | + $scope = array('ADMIN'); |
|
| 191 | + } else { |
|
| 192 | 192 | $scope = array(); |
| 193 | 193 | } |
| 194 | 194 | $payment_method_col_values = array( |
@@ -196,25 +196,25 @@ discard block |
||
| 196 | 196 | 'PMD_name' => $pretty_name, |
| 197 | 197 | 'PMD_desc' => $desc, |
| 198 | 198 | 'PMD_admin_name' => $pretty_name, |
| 199 | - 'PMD_slug' => sanitize_key( $old_gateway_slug ), |
|
| 200 | - 'PMD_debug_mode' => isset( $old_gateway_settings[ 'use_sandbox' ] ) ? $old_gateway_settings['use_sandbox'] : FALSE, |
|
| 201 | - 'PMD_button_url' => isset( $old_gateway_settings[ 'button_url' ] ) ? $old_gateway_settings[ 'button_url' ] : NULL, |
|
| 202 | - 'PMD_scope' => serialize( $scope ) |
|
| 199 | + 'PMD_slug' => sanitize_key($old_gateway_slug), |
|
| 200 | + 'PMD_debug_mode' => isset($old_gateway_settings['use_sandbox']) ? $old_gateway_settings['use_sandbox'] : FALSE, |
|
| 201 | + 'PMD_button_url' => isset($old_gateway_settings['button_url']) ? $old_gateway_settings['button_url'] : NULL, |
|
| 202 | + 'PMD_scope' => serialize($scope) |
|
| 203 | 203 | ); |
| 204 | 204 | $db_types = array( |
| 205 | - '%s',//PMD_type |
|
| 206 | - '%s',//PMD_name |
|
| 207 | - '%s',//PMD_desc |
|
| 208 | - '%s',//PMD_admin_name |
|
| 209 | - '%s',//PMD_slug |
|
| 210 | - '%d',//PMD_debug_mode |
|
| 211 | - '%s',//PMD_button_url |
|
| 212 | - '%s',//PMD_scope |
|
| 205 | + '%s', //PMD_type |
|
| 206 | + '%s', //PMD_name |
|
| 207 | + '%s', //PMD_desc |
|
| 208 | + '%s', //PMD_admin_name |
|
| 209 | + '%s', //PMD_slug |
|
| 210 | + '%d', //PMD_debug_mode |
|
| 211 | + '%s', //PMD_button_url |
|
| 212 | + '%s', //PMD_scope |
|
| 213 | 213 | ); |
| 214 | 214 | global $wpdb; |
| 215 | 215 | //first: check if it already exists |
| 216 | - $id = $wpdb->get_var( $wpdb->prepare( "SELECT PMD_ID FROM {$this->_new_table_name} WHERE PMD_slug=%s", $payment_method_col_values[ 'PMD_slug' ] ) ); |
|
| 217 | - if( $id ){ |
|
| 216 | + $id = $wpdb->get_var($wpdb->prepare("SELECT PMD_ID FROM {$this->_new_table_name} WHERE PMD_slug=%s", $payment_method_col_values['PMD_slug'])); |
|
| 217 | + if ($id) { |
|
| 218 | 218 | //just update that payment method instead of creating a new one |
| 219 | 219 | $success = $wpdb->update( |
| 220 | 220 | $this->_new_table_name, |
@@ -224,27 +224,27 @@ discard block |
||
| 224 | 224 | ), |
| 225 | 225 | $db_types, |
| 226 | 226 | array( |
| 227 | - '%d',//PMD_ID |
|
| 227 | + '%d', //PMD_ID |
|
| 228 | 228 | )); |
| 229 | - if( ! $success ){ |
|
| 230 | - $this->add_error(sprintf(__('Could not update payment method %d with properties %s because %s', "event_espresso"),$id,json_encode($payment_method_col_values),$wpdb->last_error)); |
|
| 229 | + if ( ! $success) { |
|
| 230 | + $this->add_error(sprintf(__('Could not update payment method %d with properties %s because %s', "event_espresso"), $id, json_encode($payment_method_col_values), $wpdb->last_error)); |
|
| 231 | 231 | } |
| 232 | - }else{ |
|
| 232 | + } else { |
|
| 233 | 233 | $success = $wpdb->insert( |
| 234 | 234 | $this->_new_table_name, |
| 235 | 235 | $payment_method_col_values, |
| 236 | 236 | $db_types); |
| 237 | - if ( ! $success ) { |
|
| 237 | + if ( ! $success) { |
|
| 238 | 238 | $this->add_error($wpdb->last_error); |
| 239 | 239 | return false; |
| 240 | - }else{ |
|
| 240 | + } else { |
|
| 241 | 241 | $id = $wpdb->insert_id; |
| 242 | 242 | } |
| 243 | 243 | } |
| 244 | 244 | |
| 245 | - if( $id ){ |
|
| 246 | - $this->_convert_extra_meta_values( $id, $extra_meta_key_values ); |
|
| 247 | - $this->get_migration_script()->set_mapping( 'EE_Gateway_Config', $old_gateway_slug, $this->_new_table_name, $id ); |
|
| 245 | + if ($id) { |
|
| 246 | + $this->_convert_extra_meta_values($id, $extra_meta_key_values); |
|
| 247 | + $this->get_migration_script()->set_mapping('EE_Gateway_Config', $old_gateway_slug, $this->_new_table_name, $id); |
|
| 248 | 248 | return true; |
| 249 | 249 | } |
| 250 | 250 | return false; |
@@ -258,26 +258,26 @@ discard block |
||
| 258 | 258 | * @param int $id |
| 259 | 259 | * @param array $extra_meta_key_values |
| 260 | 260 | */ |
| 261 | - private function _convert_extra_meta_values($id,$extra_meta_key_values){ |
|
| 261 | + private function _convert_extra_meta_values($id, $extra_meta_key_values) { |
|
| 262 | 262 | global $wpdb; |
| 263 | - foreach( $extra_meta_key_values as $key => $value ){ |
|
| 263 | + foreach ($extra_meta_key_values as $key => $value) { |
|
| 264 | 264 | $exm_args = array( |
| 265 | 265 | 'OBJ_ID'=>$id, |
| 266 | 266 | 'EXM_type'=>'Payment_Method', |
| 267 | 267 | 'EXM_key'=>$key, |
| 268 | - 'EXM_value'=> maybe_serialize($value ) |
|
| 268 | + 'EXM_value'=> maybe_serialize($value) |
|
| 269 | 269 | ); |
| 270 | 270 | $success = $wpdb->insert( |
| 271 | 271 | $this->_extra_meta_table_name, |
| 272 | 272 | $exm_args, |
| 273 | 273 | array( |
| 274 | - '%d',//OBJ_ID |
|
| 275 | - '%s',//EXM_type |
|
| 276 | - '%s',//EXM_key |
|
| 277 | - '%s',//EXM_value |
|
| 274 | + '%d', //OBJ_ID |
|
| 275 | + '%s', //EXM_type |
|
| 276 | + '%s', //EXM_key |
|
| 277 | + '%s', //EXM_value |
|
| 278 | 278 | )); |
| 279 | - if( ! $success ){ |
|
| 280 | - $this->add_error(sprintf(__('Could not insert extra meta key with values %s. %s', "event_espresso"),json_encode($exm_args),$wpdb->last_error)); |
|
| 279 | + if ( ! $success) { |
|
| 280 | + $this->add_error(sprintf(__('Could not insert extra meta key with values %s. %s', "event_espresso"), json_encode($exm_args), $wpdb->last_error)); |
|
| 281 | 281 | } |
| 282 | 282 | } |
| 283 | 283 | } |
@@ -184,11 +184,11 @@ discard block |
||
| 184 | 184 | $offline_gateways = array( 'Bank', 'Check', 'Invoice' ); |
| 185 | 185 | if( $active && in_array( $old_gateway_slug, $offline_gateways ) ) { |
| 186 | 186 | $scope = array( 'CART', 'ADMIN'); |
| 187 | - }elseif( $active && ! in_array( $old_gateway_slug, $offline_gateways ) ) { |
|
| 187 | + } elseif( $active && ! in_array( $old_gateway_slug, $offline_gateways ) ) { |
|
| 188 | 188 | $scope = array( 'CART' ); |
| 189 | - }elseif( ! $active && in_array($old_gateway_slug,$offline_gateways ) ) { |
|
| 189 | + } elseif( ! $active && in_array($old_gateway_slug,$offline_gateways ) ) { |
|
| 190 | 190 | $scope = array( 'ADMIN' ); |
| 191 | - }else{ |
|
| 191 | + } else{ |
|
| 192 | 192 | $scope = array(); |
| 193 | 193 | } |
| 194 | 194 | $payment_method_col_values = array( |
@@ -229,7 +229,7 @@ discard block |
||
| 229 | 229 | if( ! $success ){ |
| 230 | 230 | $this->add_error(sprintf(__('Could not update payment method %d with properties %s because %s', "event_espresso"),$id,json_encode($payment_method_col_values),$wpdb->last_error)); |
| 231 | 231 | } |
| 232 | - }else{ |
|
| 232 | + } else{ |
|
| 233 | 233 | $success = $wpdb->insert( |
| 234 | 234 | $this->_new_table_name, |
| 235 | 235 | $payment_method_col_values, |
@@ -237,7 +237,7 @@ discard block |
||
| 237 | 237 | if ( ! $success ) { |
| 238 | 238 | $this->add_error($wpdb->last_error); |
| 239 | 239 | return false; |
| 240 | - }else{ |
|
| 240 | + } else{ |
|
| 241 | 241 | $id = $wpdb->insert_id; |
| 242 | 242 | } |
| 243 | 243 | } |
@@ -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,37 +12,37 @@ discard block |
||
| 12 | 12 | * @author Mike Nelson |
| 13 | 13 | * |
| 14 | 14 | */ |
| 15 | -class EE_DMS_4_6_0_payments extends EE_Data_Migration_Script_Stage_Table{ |
|
| 15 | +class EE_DMS_4_6_0_payments extends EE_Data_Migration_Script_Stage_Table { |
|
| 16 | 16 | protected $_payment_method_table; |
| 17 | - function __construct(){ |
|
| 17 | + function __construct() { |
|
| 18 | 18 | global $wpdb; |
| 19 | - $this->_old_table = $wpdb->prefix . 'esp_payment'; |
|
| 20 | - $this->_payment_method_table = $wpdb->prefix . 'esp_payment_method'; |
|
| 19 | + $this->_old_table = $wpdb->prefix.'esp_payment'; |
|
| 20 | + $this->_payment_method_table = $wpdb->prefix.'esp_payment_method'; |
|
| 21 | 21 | $this->_pretty_name = __('Payment-Payment Method Relations', 'event_espresso'); |
| 22 | 22 | parent::__construct(); |
| 23 | 23 | } |
| 24 | - protected function _migrate_old_row( $payment_row ) { |
|
| 24 | + protected function _migrate_old_row($payment_row) { |
|
| 25 | 25 | global $wpdb; |
| 26 | 26 | //get the payment method's ID |
| 27 | - $PMD_ID = apply_filters( 'FHEE__EE_DMS_4_6_0_payments__migrate_old_row__PMD_ID', $this->_get_payment_method_id_by_gateway_name( $payment_row[ 'PAY_gateway' ], $payment_row[ 'PAY_method'] ) ); |
|
| 28 | - if( ! $PMD_ID ){ |
|
| 29 | - $this->add_error( sprintf( __( 'Could not find payment method with PMD_type = \'%1$s\' when migrating payment row %2$s so just assigned it an unknown payment method', 'event_espresso' ), $payment_row[ 'PAY_gateway' ], $this->_json_encode( $payment_row ) ) ); |
|
| 27 | + $PMD_ID = apply_filters('FHEE__EE_DMS_4_6_0_payments__migrate_old_row__PMD_ID', $this->_get_payment_method_id_by_gateway_name($payment_row['PAY_gateway'], $payment_row['PAY_method'])); |
|
| 28 | + if ( ! $PMD_ID) { |
|
| 29 | + $this->add_error(sprintf(__('Could not find payment method with PMD_type = \'%1$s\' when migrating payment row %2$s so just assigned it an unknown payment method', 'event_espresso'), $payment_row['PAY_gateway'], $this->_json_encode($payment_row))); |
|
| 30 | 30 | $PMD_ID = 0; |
| 31 | 31 | } |
| 32 | 32 | $new_values = array( |
| 33 | 33 | 'PMD_ID' => $PMD_ID, |
| 34 | - 'PAY_source' => ( $payment_row[ 'PAY_via_admin' ] ? 'ADMIN' : 'CART' ) ); |
|
| 35 | - $wheres = array( 'PAY_ID' => $payment_row[ 'PAY_ID' ] ); |
|
| 36 | - $new_value_datatypes = array( '%d', '%s' ); |
|
| 37 | - $where_datatypes = array( '%d' ); |
|
| 38 | - $success = $wpdb->update( $this->_old_table, |
|
| 34 | + 'PAY_source' => ($payment_row['PAY_via_admin'] ? 'ADMIN' : 'CART') ); |
|
| 35 | + $wheres = array('PAY_ID' => $payment_row['PAY_ID']); |
|
| 36 | + $new_value_datatypes = array('%d', '%s'); |
|
| 37 | + $where_datatypes = array('%d'); |
|
| 38 | + $success = $wpdb->update($this->_old_table, |
|
| 39 | 39 | $new_values, |
| 40 | 40 | $wheres, |
| 41 | 41 | $new_value_datatypes, |
| 42 | 42 | $where_datatypes |
| 43 | 43 | ); |
| 44 | - if( ! $success ){ |
|
| 45 | - $this->add_error( sprintf( __( 'Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso' ), $this->_json_encode( $new_values ), $this->_old_table, $this->_json_encode( $wheres ) ) ); |
|
| 44 | + if ( ! $success) { |
|
| 45 | + $this->add_error(sprintf(__('Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso'), $this->_json_encode($new_values), $this->_old_table, $this->_json_encode($wheres))); |
|
| 46 | 46 | } |
| 47 | 47 | } |
| 48 | 48 | /** |
@@ -60,11 +60,11 @@ discard block |
||
| 60 | 60 | * @param int $id |
| 61 | 61 | * @return string |
| 62 | 62 | */ |
| 63 | - protected function _get_payment_method_id_by_gateway_name( $gateway_name, $old_pay_method_column ){ |
|
| 63 | + protected function _get_payment_method_id_by_gateway_name($gateway_name, $old_pay_method_column) { |
|
| 64 | 64 | global $wpdb; |
| 65 | 65 | //convert from old known PAY_method values to their corresponding |
| 66 | 66 | //PMD_type or default PMD_name |
| 67 | - switch( $old_pay_method_column ) { |
|
| 67 | + switch ($old_pay_method_column) { |
|
| 68 | 68 | case 'PP': |
| 69 | 69 | $pmd_type = 'Paypal_Standard'; |
| 70 | 70 | break; |
@@ -92,8 +92,8 @@ discard block |
||
| 92 | 92 | default: |
| 93 | 93 | $pmd_type = $gateway_name; |
| 94 | 94 | } |
| 95 | - $pmd_name = str_replace( "_", " ", $pmd_type ); |
|
| 96 | - return $wpdb->get_var( $wpdb->prepare( "SELECT PMD_ID FROM " . $wpdb->prefix . "esp_payment_method WHERE PMD_type = %s OR PMD_name = %s", $pmd_type, $pmd_name ) ); |
|
| 95 | + $pmd_name = str_replace("_", " ", $pmd_type); |
|
| 96 | + return $wpdb->get_var($wpdb->prepare("SELECT PMD_ID FROM ".$wpdb->prefix."esp_payment_method WHERE PMD_type = %s OR PMD_name = %s", $pmd_type, $pmd_name)); |
|
| 97 | 97 | } |
| 98 | 98 | |
| 99 | 99 | |
@@ -49,7 +49,6 @@ |
||
| 49 | 49 | /** |
| 50 | 50 | * |
| 51 | 51 | * @global type $wpdb |
| 52 | - * @param int $id |
|
| 53 | 52 | * @return string |
| 54 | 53 | */ |
| 55 | 54 | protected function _get_payment_method_id_by_gateway_name( $gateway_name ){ |
@@ -26,7 +26,7 @@ discard block |
||
| 26 | 26 | */ |
| 27 | 27 | public function __construct() { |
| 28 | 28 | global $wpdb; |
| 29 | - $this->_pretty_name = __( 'Question Types', 'event_espresso' ); |
|
| 29 | + $this->_pretty_name = __('Question Types', 'event_espresso'); |
|
| 30 | 30 | $this->_old_table = $wpdb->prefix.'esp_question'; |
| 31 | 31 | $this->_question_type_conversions = array( |
| 32 | 32 | 'MULTIPLE' => 'CHECKBOX', |
@@ -35,8 +35,8 @@ discard block |
||
| 35 | 35 | //when fetching rows, because we automatically use a limit and offset |
| 36 | 36 | //rows counted before migrating any rows, need to ALSO be counted after a bunch of rows were counted |
| 37 | 37 | //so we need to include both the migrated rows as well as the non-migrated rows |
| 38 | - $QST_types_to_count = array_merge( array_keys( $this->_question_type_conversions ), $this->_question_type_conversions ); |
|
| 39 | - $this->_extra_where_sql = "WHERE QST_type IN ('" . implode( "', '", $QST_types_to_count ) . "')" ; |
|
| 38 | + $QST_types_to_count = array_merge(array_keys($this->_question_type_conversions), $this->_question_type_conversions); |
|
| 39 | + $this->_extra_where_sql = "WHERE QST_type IN ('".implode("', '", $QST_types_to_count)."')"; |
|
| 40 | 40 | parent::__construct(); |
| 41 | 41 | } |
| 42 | 42 | |
@@ -44,21 +44,21 @@ discard block |
||
| 44 | 44 | * @param array $question an associative array where keys are column names and values are their values. |
| 45 | 45 | * @return null |
| 46 | 46 | */ |
| 47 | - protected function _migrate_old_row( $question ) { |
|
| 47 | + protected function _migrate_old_row($question) { |
|
| 48 | 48 | global $wpdb; |
| 49 | - if ( $question['QST_ID'] && isset( $this->_question_type_conversions[ $question['QST_type'] ] )) { |
|
| 49 | + if ($question['QST_ID'] && isset($this->_question_type_conversions[$question['QST_type']])) { |
|
| 50 | 50 | $success = $wpdb->update( |
| 51 | 51 | $this->_old_table, |
| 52 | - array( 'QST_type' => $this->_question_type_conversions[ $question['QST_type'] ] ), // data |
|
| 53 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
| 54 | - array( '%s' ), // data format |
|
| 55 | - array( '%d' ) // where format |
|
| 52 | + array('QST_type' => $this->_question_type_conversions[$question['QST_type']]), // data |
|
| 53 | + array('QST_ID' => $question['QST_ID']), // where |
|
| 54 | + array('%s'), // data format |
|
| 55 | + array('%d') // where format |
|
| 56 | 56 | ); |
| 57 | - if ( ! $success ) { |
|
| 57 | + if ( ! $success) { |
|
| 58 | 58 | $this->add_error( |
| 59 | 59 | sprintf( |
| 60 | - __( 'Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso' ), |
|
| 61 | - json_encode( $question['QST_type'] ), |
|
| 60 | + __('Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
| 61 | + json_encode($question['QST_type']), |
|
| 62 | 62 | $question['QST_ID'], |
| 63 | 63 | $wpdb->last_error |
| 64 | 64 | ) |
@@ -1,6 +1,6 @@ discard block |
||
| 1 | 1 | <?php |
| 2 | 2 | |
| 3 | -if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
| 3 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
| 4 | 4 | exit('No direct script access allowed'); |
| 5 | 5 | } |
| 6 | 6 | |
@@ -13,7 +13,7 @@ discard block |
||
| 13 | 13 | * @author Brent Christensen |
| 14 | 14 | * |
| 15 | 15 | */ |
| 16 | -class EE_DMS_4_6_0_state_system_question extends EE_Data_Migration_Script_Stage_Table{ |
|
| 16 | +class EE_DMS_4_6_0_state_system_question extends EE_Data_Migration_Script_Stage_Table { |
|
| 17 | 17 | |
| 18 | 18 | |
| 19 | 19 | |
@@ -24,7 +24,7 @@ discard block |
||
| 24 | 24 | */ |
| 25 | 25 | public function __construct() { |
| 26 | 26 | global $wpdb; |
| 27 | - $this->_pretty_name = __( 'State - System Question', 'event_espresso' ); |
|
| 27 | + $this->_pretty_name = __('State - System Question', 'event_espresso'); |
|
| 28 | 28 | $this->_old_table = $wpdb->prefix.'esp_question'; |
| 29 | 29 | $this->_extra_where_sql = "WHERE QST_system = 'state'"; |
| 30 | 30 | parent::__construct(); |
@@ -37,21 +37,21 @@ discard block |
||
| 37 | 37 | * @param array $question an associative array where keys are column names and values are their values. |
| 38 | 38 | * @return null |
| 39 | 39 | */ |
| 40 | - protected function _migrate_old_row( $question ) { |
|
| 41 | - if ( $question['QST_ID'] && $question['QST_system'] == 'state' ) { |
|
| 40 | + protected function _migrate_old_row($question) { |
|
| 41 | + if ($question['QST_ID'] && $question['QST_system'] == 'state') { |
|
| 42 | 42 | global $wpdb; |
| 43 | 43 | $success = $wpdb->update( |
| 44 | 44 | $this->_old_table, |
| 45 | - array( 'QST_type' => 'STATE' ), // data |
|
| 46 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
| 47 | - array( '%s' ), // data format |
|
| 48 | - array( '%d' ) // where format |
|
| 45 | + array('QST_type' => 'STATE'), // data |
|
| 46 | + array('QST_ID' => $question['QST_ID']), // where |
|
| 47 | + array('%s'), // data format |
|
| 48 | + array('%d') // where format |
|
| 49 | 49 | ); |
| 50 | - if ( ! $success ) { |
|
| 50 | + if ( ! $success) { |
|
| 51 | 51 | $this->add_error( |
| 52 | 52 | sprintf( |
| 53 | - __( 'Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso' ), |
|
| 54 | - json_encode( $question['QST_system'] ), |
|
| 53 | + __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
| 54 | + json_encode($question['QST_system']), |
|
| 55 | 55 | $question['QST_ID'], |
| 56 | 56 | $wpdb->last_error |
| 57 | 57 | ) |
@@ -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 | ) |