@@ -41,19 +41,19 @@ discard block |
||
41 | 41 | //foreach row that has an evt_id ..let's create an equivalent entry in the new event_messages_template table to link the message template to the event (since EVT_ID is no longer referenced in esp_message_template_groups ) |
42 | 42 | global $wpdb; |
43 | 43 | if ( $old_row['EVT_ID'] > 0 ) { |
44 | - //let's get the EVT for this id so we can update the custom name on the old row. |
|
45 | - $event_name = 'Custom Template for ' . $wpdb->get_var( $wpdb->prepare( "SELECT post_title from $wpdb->posts WHERE ID = %d", absint( $old_row['EVT_ID'] ) ) ); |
|
44 | + //let's get the EVT for this id so we can update the custom name on the old row. |
|
45 | + $event_name = 'Custom Template for ' . $wpdb->get_var( $wpdb->prepare( "SELECT post_title from $wpdb->posts WHERE ID = %d", absint( $old_row['EVT_ID'] ) ) ); |
|
46 | 46 | |
47 | - //update name |
|
48 | - $updated = $wpdb->update( |
|
49 | - $this->_old_table, |
|
50 | - array( |
|
51 | - 'MTP_name' =>$event_name |
|
52 | - ), |
|
53 | - array( 'GRP_ID' => (int) $old_row['GRP_ID'] ), |
|
54 | - array( '%s' ), |
|
55 | - array( '%d' ) |
|
56 | - ); |
|
47 | + //update name |
|
48 | + $updated = $wpdb->update( |
|
49 | + $this->_old_table, |
|
50 | + array( |
|
51 | + 'MTP_name' =>$event_name |
|
52 | + ), |
|
53 | + array( 'GRP_ID' => (int) $old_row['GRP_ID'] ), |
|
54 | + array( '%s' ), |
|
55 | + array( '%d' ) |
|
56 | + ); |
|
57 | 57 | |
58 | 58 | $inserted = $wpdb->insert( |
59 | 59 | $this->_emt_table, |
@@ -64,9 +64,9 @@ discard block |
||
64 | 64 | array( '%d', '%d' ) |
65 | 65 | ); |
66 | 66 | |
67 | - if ( FALSE === $updated ) { |
|
68 | - $this->add_error( sprintf( __("Error in updating the row in %s setting 'MTP_name = %s", 'event_espresso'), $this->_old_table, $event_name ) ); |
|
69 | - } |
|
67 | + if ( FALSE === $updated ) { |
|
68 | + $this->add_error( sprintf( __("Error in updating the row in %s setting 'MTP_name = %s", 'event_espresso'), $this->_old_table, $event_name ) ); |
|
69 | + } |
|
70 | 70 | |
71 | 71 | if ( FALSE === $inserted ) { |
72 | 72 | $this->add_error( sprintf( __("Error in inserting a row into setting EVT_ID = %d and GRP_ID = %d", "event_espresso"), $this->_emt_table, $old_row['EVT_ID'], $old_row['GRP_ID'] ) ); |
@@ -37,12 +37,12 @@ discard block |
||
37 | 37 | |
38 | 38 | |
39 | 39 | |
40 | - protected function _migrate_old_row( $old_row ) { |
|
40 | + protected function _migrate_old_row($old_row) { |
|
41 | 41 | //foreach row that has an evt_id ..let's create an equivalent entry in the new event_messages_template table to link the message template to the event (since EVT_ID is no longer referenced in esp_message_template_groups ) |
42 | 42 | global $wpdb; |
43 | - if ( $old_row['EVT_ID'] > 0 ) { |
|
43 | + if ($old_row['EVT_ID'] > 0) { |
|
44 | 44 | //let's get the EVT for this id so we can update the custom name on the old row. |
45 | - $event_name = 'Custom Template for ' . $wpdb->get_var( $wpdb->prepare( "SELECT post_title from $wpdb->posts WHERE ID = %d", absint( $old_row['EVT_ID'] ) ) ); |
|
45 | + $event_name = 'Custom Template for '.$wpdb->get_var($wpdb->prepare("SELECT post_title from $wpdb->posts WHERE ID = %d", absint($old_row['EVT_ID']))); |
|
46 | 46 | |
47 | 47 | //update name |
48 | 48 | $updated = $wpdb->update( |
@@ -50,9 +50,9 @@ discard block |
||
50 | 50 | array( |
51 | 51 | 'MTP_name' =>$event_name |
52 | 52 | ), |
53 | - array( 'GRP_ID' => (int) $old_row['GRP_ID'] ), |
|
54 | - array( '%s' ), |
|
55 | - array( '%d' ) |
|
53 | + array('GRP_ID' => (int) $old_row['GRP_ID']), |
|
54 | + array('%s'), |
|
55 | + array('%d') |
|
56 | 56 | ); |
57 | 57 | |
58 | 58 | $inserted = $wpdb->insert( |
@@ -61,15 +61,15 @@ discard block |
||
61 | 61 | 'EVT_ID' => (int) $old_row['EVT_ID'], |
62 | 62 | 'GRP_ID' => (int) $old_row['GRP_ID'], |
63 | 63 | ), |
64 | - array( '%d', '%d' ) |
|
64 | + array('%d', '%d') |
|
65 | 65 | ); |
66 | 66 | |
67 | - if ( FALSE === $updated ) { |
|
68 | - $this->add_error( sprintf( __("Error in updating the row in %s setting 'MTP_name = %s", 'event_espresso'), $this->_old_table, $event_name ) ); |
|
67 | + if (FALSE === $updated) { |
|
68 | + $this->add_error(sprintf(__("Error in updating the row in %s setting 'MTP_name = %s", 'event_espresso'), $this->_old_table, $event_name)); |
|
69 | 69 | } |
70 | 70 | |
71 | - if ( FALSE === $inserted ) { |
|
72 | - $this->add_error( sprintf( __("Error in inserting a row into setting EVT_ID = %d and GRP_ID = %d", "event_espresso"), $this->_emt_table, $old_row['EVT_ID'], $old_row['GRP_ID'] ) ); |
|
71 | + if (FALSE === $inserted) { |
|
72 | + $this->add_error(sprintf(__("Error in inserting a row into setting EVT_ID = %d and GRP_ID = %d", "event_espresso"), $this->_emt_table, $old_row['EVT_ID'], $old_row['GRP_ID'])); |
|
73 | 73 | } |
74 | 74 | } |
75 | 75 | } |
@@ -5,7 +5,9 @@ |
||
5 | 5 | * @subpackage migrations |
6 | 6 | * @since 4.3 |
7 | 7 | */ |
8 | - if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed'); |
|
8 | + if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
9 | + exit('No direct script access allowed'); |
|
10 | + } |
|
9 | 11 | |
10 | 12 | |
11 | 13 | /** |
@@ -19,12 +19,12 @@ |
||
19 | 19 | $updated = $wpdb->update($this->_old_table, |
20 | 20 | array('QSO_order'=>$old_row['QSO_ID']), |
21 | 21 | array('QSO_ID'=>$old_row['QSO_ID']), |
22 | - array('%d',//QSO_order |
|
22 | + array('%d', //QSO_order |
|
23 | 23 | ), |
24 | - array('%d',//QSO_ID |
|
24 | + array('%d', //QSO_ID |
|
25 | 25 | )); |
26 | - if ( FALSE === $updated ) { |
|
27 | - $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting QSO_order = %d where QSO_ID = %d", 'event_espresso'),$old_row['QSO_ID'],$old_row['QSO_ID'])); |
|
26 | + if (FALSE === $updated) { |
|
27 | + $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting QSO_order = %d where QSO_ID = %d", 'event_espresso'), $old_row['QSO_ID'], $old_row['QSO_ID'])); |
|
28 | 28 | } |
29 | 29 | } |
30 | 30 | } |
31 | 31 | \ No newline at end of file |
@@ -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 |
@@ -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,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,wp_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, wp_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"),wp_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"), wp_json_encode($exm_args), $wpdb->last_error)); |
|
281 | 281 | } |
282 | 282 | } |
283 | 283 | } |
@@ -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 ){ |