@@ -1,6 +1,6 @@ |
||
1 | 1 | <?php //EEH_Debug_Tools::printr( $admin_reports, '$admin_reports' ); ?> |
2 | 2 | |
3 | -<?php foreach ( $admin_reports as $report) : ?> |
|
3 | +<?php foreach ($admin_reports as $report) : ?> |
|
4 | 4 | |
5 | 5 | <div id="<?php echo $report; ?>" class="admin-report-chart-dv" style="width:95%; min-height:420px; margin:20px 4% 40px 1%;"></div> |
6 | 6 |
@@ -1,5 +1,5 @@ |
||
1 | 1 | <div class="padding"> |
2 | - <p><?php _e( 'We need your help to continue maintaining and providing this plugin for free. You can help by leaving a positive review in the WordPress plugin directory. 5 star ratings bring Event Espresso Decaf to the attention of more users which increases our support and features for this version of Event Espresso.', 'event_espresso' ); ?></p> |
|
3 | - <p><?php _e( 'Rate it five stars today!', 'event_espresso' ); ?></p><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span> |
|
4 | - <p><a class="button button-primary" href="https://wordpress.org/plugins/event-espresso-decaf/"><?php _e( 'Rate It!', 'event_espresso' ); ?></a></p> |
|
2 | + <p><?php _e('We need your help to continue maintaining and providing this plugin for free. You can help by leaving a positive review in the WordPress plugin directory. 5 star ratings bring Event Espresso Decaf to the attention of more users which increases our support and features for this version of Event Espresso.', 'event_espresso'); ?></p> |
|
3 | + <p><?php _e('Rate it five stars today!', 'event_espresso'); ?></p><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span> |
|
4 | + <p><a class="button button-primary" href="https://wordpress.org/plugins/event-espresso-decaf/"><?php _e('Rate It!', 'event_espresso'); ?></a></p> |
|
5 | 5 | </div> |
6 | 6 | \ No newline at end of file |
@@ -3,8 +3,8 @@ |
||
3 | 3 | <span id="localized_status_save"><?php echo $localized_status_save; ?></span> |
4 | 4 | <span id="cur_stat_id"><?php echo $cur_status; ?></span> |
5 | 5 | <select name='ee_post_status' id='ee_post_status'> |
6 | - <?php foreach ( $statuses as $status => $label ) : ?> |
|
7 | - <option<?php selected( $cur_status, $status ); ?> value='<?php echo $status; ?>'><?php echo $label; ?></option> |
|
6 | + <?php foreach ($statuses as $status => $label) : ?> |
|
7 | + <option<?php selected($cur_status, $status); ?> value='<?php echo $status; ?>'><?php echo $label; ?></option> |
|
8 | 8 | <?php |
9 | 9 | endforeach; |
10 | 10 | ?> |
@@ -6,16 +6,16 @@ discard block |
||
6 | 6 | * Authorize.net AIM, Bank, Check, Invoice, Paypal Pro and Paypal Standard. |
7 | 7 | * |
8 | 8 | */ |
9 | -class EE_DMS_4_1_0_category_details extends EE_Data_Migration_Script_Stage{ |
|
9 | +class EE_DMS_4_1_0_category_details extends EE_Data_Migration_Script_Stage { |
|
10 | 10 | private $_old_table; |
11 | 11 | private $_new_table; |
12 | 12 | private $_new_term_table; |
13 | -function _migration_step($num_items=50){ |
|
13 | +function _migration_step($num_items = 50) { |
|
14 | 14 | global $wpdb; |
15 | 15 | $start_at_record = $this->count_records_migrated(); |
16 | - $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A); |
|
16 | + $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A); |
|
17 | 17 | $items_actually_migrated = 0; |
18 | - foreach($rows as $category_detail_row){ |
|
18 | + foreach ($rows as $category_detail_row) { |
|
19 | 19 | $term_and_taxonomy_ids = wp_insert_term( |
20 | 20 | stripslashes($category_detail_row['category_name']), |
21 | 21 | 'espresso_event_categories', |
@@ -23,8 +23,8 @@ discard block |
||
23 | 23 | 'description'=> stripslashes($category_detail_row['category_desc']), |
24 | 24 | 'slug'=>$category_detail_row['category_identifier'] |
25 | 25 | )); |
26 | - if($term_and_taxonomy_ids instanceof WP_Error){ |
|
27 | - $this->add_error(sprintf(__("Could not create WP Term_Taxonomy from old category: %s. The Error was: %s", "event_espresso"), $this->_json_encode($category_detail_row),$term_and_taxonomy_ids->get_error_message())); |
|
26 | + if ($term_and_taxonomy_ids instanceof WP_Error) { |
|
27 | + $this->add_error(sprintf(__("Could not create WP Term_Taxonomy from old category: %s. The Error was: %s", "event_espresso"), $this->_json_encode($category_detail_row), $term_and_taxonomy_ids->get_error_message())); |
|
28 | 28 | $items_actually_migrated++; |
29 | 29 | continue; |
30 | 30 | } |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | $this->get_migration_script()->set_mapping($this->_old_table, $category_detail_row['id'], $this->_new_table, $term_taxonomy_id); |
35 | 35 | $items_actually_migrated++; |
36 | 36 | } |
37 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
37 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
38 | 38 | $this->set_completed(); |
39 | 39 | } |
40 | 40 | return $items_actually_migrated; |
@@ -28,22 +28,22 @@ discard block |
||
28 | 28 | |
29 | 29 | * |
30 | 30 | */ |
31 | -class EE_DMS_4_1_0_event_category extends EE_Data_Migration_Script_Stage{ |
|
31 | +class EE_DMS_4_1_0_event_category extends EE_Data_Migration_Script_Stage { |
|
32 | 32 | private $_old_table; |
33 | 33 | private $_new_table; |
34 | - function _migration_step($num_items=50){ |
|
34 | + function _migration_step($num_items = 50) { |
|
35 | 35 | global $wpdb; |
36 | 36 | $start_at_record = $this->count_records_migrated(); |
37 | - $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A); |
|
37 | + $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A); |
|
38 | 38 | $items_actually_migrated = 0; |
39 | - foreach($rows as $event_venue_rel){ |
|
39 | + foreach ($rows as $event_venue_rel) { |
|
40 | 40 | $term_relation_id = $this->_add_relation_from_event_to_term_taxonomy($event_venue_rel); |
41 | - if($term_relation_id){ |
|
41 | + if ($term_relation_id) { |
|
42 | 42 | $this->get_migration_script()->set_mapping($this->_old_table, $event_venue_rel['id'], $this->_new_table, $term_relation_id); |
43 | 43 | } |
44 | 44 | $items_actually_migrated++; |
45 | 45 | } |
46 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
46 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
47 | 47 | $this->set_completed(); |
48 | 48 | } |
49 | 49 | return $items_actually_migrated; |
@@ -67,16 +67,16 @@ discard block |
||
67 | 67 | * @param array $old_event_cat_relation |
68 | 68 | * @return int |
69 | 69 | */ |
70 | - private function _add_relation_from_event_to_term_taxonomy($old_event_cat_relation){ |
|
70 | + private function _add_relation_from_event_to_term_taxonomy($old_event_cat_relation) { |
|
71 | 71 | global $wpdb; |
72 | 72 | $new_event_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_detail", intval($old_event_cat_relation['event_id']), $wpdb->prefix."posts"); |
73 | 73 | $new_term_taxonomy_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_category_detail", intval($old_event_cat_relation['cat_id']), $wpdb->prefix."term_taxonomy"); |
74 | - if( ! $new_event_id){ |
|
75 | - $this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"),$old_event_cat_relation['event_id'])); |
|
74 | + if ( ! $new_event_id) { |
|
75 | + $this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"), $old_event_cat_relation['event_id'])); |
|
76 | 76 | return 0; |
77 | 77 | } |
78 | - if( ! $new_term_taxonomy_id){ |
|
79 | - $this->add_error(sprintf(__("Could not find 4.1 term-taxonomy id for 3.1 category #%d.", "event_espresso"),$old_event_cat_relation['cat_id'])); |
|
78 | + if ( ! $new_term_taxonomy_id) { |
|
79 | + $this->add_error(sprintf(__("Could not find 4.1 term-taxonomy id for 3.1 category #%d.", "event_espresso"), $old_event_cat_relation['cat_id'])); |
|
80 | 80 | return 0; |
81 | 81 | } |
82 | 82 | $cols_n_values = array( |
@@ -85,19 +85,19 @@ discard block |
||
85 | 85 | 'term_order'=>0 |
86 | 86 | ); |
87 | 87 | $datatypes = array( |
88 | - '%d',//object_id |
|
89 | - '%d',//term_taxonomy_id |
|
90 | - '%d',//term_order |
|
88 | + '%d', //object_id |
|
89 | + '%d', //term_taxonomy_id |
|
90 | + '%d', //term_order |
|
91 | 91 | ); |
92 | - $success = $wpdb->insert($this->_new_table,$cols_n_values,$datatypes); |
|
93 | - if ( ! $success){ |
|
92 | + $success = $wpdb->insert($this->_new_table, $cols_n_values, $datatypes); |
|
93 | + if ( ! $success) { |
|
94 | 94 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_event_cat_relation, $this->_new_table, $cols_n_values, $datatypes)); |
95 | 95 | return 0; |
96 | - }else{ |
|
96 | + } else { |
|
97 | 97 | //increment the term-taxonomie's count |
98 | - $success = $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->term_taxonomy} SET count = count +1 WHERE term_taxonomy_id=%d", $new_term_taxonomy_id ) ); |
|
99 | - if( ! $success ){ |
|
100 | - $this->add_error(sprintf( __( 'Could not increment term_taxonomy\'s count because %s', 'event_espresso' ),$wpdb->last_error)); |
|
98 | + $success = $wpdb->query($wpdb->prepare("UPDATE {$wpdb->term_taxonomy} SET count = count +1 WHERE term_taxonomy_id=%d", $new_term_taxonomy_id)); |
|
99 | + if ( ! $success) { |
|
100 | + $this->add_error(sprintf(__('Could not increment term_taxonomy\'s count because %s', 'event_espresso'), $wpdb->last_error)); |
|
101 | 101 | } |
102 | 102 | } |
103 | 103 | return $wpdb->insert_id; |
@@ -12,8 +12,6 @@ |
||
12 | 12 | KEY `group_id` (`group_id`), |
13 | 13 | KEY `question_id` (`question_id`) |
14 | 14 | ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8$$ |
15 | - |
|
16 | - |
|
17 | 15 | * 4.1 question group question model's tables and fields: |
18 | 16 | $this->_tables = array( |
19 | 17 | 'Question_Group_Question'=>new EE_Primary_Table('esp_question_group_question','QGQ_ID') |
@@ -90,7 +90,7 @@ |
||
90 | 90 | //so in case teh IPN is arriving later, let's try to process an IPN! |
91 | 91 | if($_SERVER['REQUEST_METHOD'] == 'POST'){ |
92 | 92 | return $this->handle_ipn($_POST, $transaction ); |
93 | - }else{ |
|
93 | + } else{ |
|
94 | 94 | return parent::finalize_payment_for( $transaction ); |
95 | 95 | } |
96 | 96 | } |
@@ -25,9 +25,6 @@ |
||
25 | 25 | |
26 | 26 | ) |
27 | 27 | ); |
28 | - |
|
29 | - |
|
30 | - |
|
31 | 28 | * |
32 | 29 | */ |
33 | 30 | class EE_DMS_4_1_0_event_venue extends EE_Data_Migration_Script_Stage{ |
@@ -30,20 +30,20 @@ discard block |
||
30 | 30 | |
31 | 31 | * |
32 | 32 | */ |
33 | -class EE_DMS_4_1_0_event_venue extends EE_Data_Migration_Script_Stage{ |
|
33 | +class EE_DMS_4_1_0_event_venue extends EE_Data_Migration_Script_Stage { |
|
34 | 34 | private $_old_table; |
35 | 35 | private $_new_table; |
36 | - function _migration_step($num_items=50){ |
|
36 | + function _migration_step($num_items = 50) { |
|
37 | 37 | |
38 | 38 | global $wpdb; |
39 | 39 | $start_at_record = $this->count_records_migrated(); |
40 | - $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A); |
|
40 | + $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A); |
|
41 | 41 | $items_actually_migrated = 0; |
42 | - foreach($rows as $event_venue_rel){ |
|
42 | + foreach ($rows as $event_venue_rel) { |
|
43 | 43 | $this->_insert_new_event_to_venue_rel($event_venue_rel); |
44 | 44 | $items_actually_migrated++; |
45 | 45 | } |
46 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
46 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
47 | 47 | $this->set_completed(); |
48 | 48 | } |
49 | 49 | return $items_actually_migrated; |
@@ -67,26 +67,26 @@ discard block |
||
67 | 67 | * @param array $old_event_venue_rel |
68 | 68 | * @return int |
69 | 69 | */ |
70 | - private function _insert_new_event_to_venue_rel($old_event_venue_rel){ |
|
70 | + private function _insert_new_event_to_venue_rel($old_event_venue_rel) { |
|
71 | 71 | global $wpdb; |
72 | 72 | $new_event_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_detail", $old_event_venue_rel['event_id'], $wpdb->prefix."posts"); |
73 | 73 | $new_venue_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_venue", $old_event_venue_rel['venue_id'], $wpdb->prefix."posts"); |
74 | - if( ! $new_event_id){ |
|
75 | - $this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"),$old_event_venue_rel['event_id'])); |
|
74 | + if ( ! $new_event_id) { |
|
75 | + $this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"), $old_event_venue_rel['event_id'])); |
|
76 | 76 | return 0; |
77 | 77 | } |
78 | - if( ! $new_venue_id){ |
|
79 | - $this->add_error(sprintf(__("Could not find 4.1 venue id for 3.1 venue #%d.", "event_espresso"),$old_event_venue_rel['venue_id'])); |
|
78 | + if ( ! $new_venue_id) { |
|
79 | + $this->add_error(sprintf(__("Could not find 4.1 venue id for 3.1 venue #%d.", "event_espresso"), $old_event_venue_rel['venue_id'])); |
|
80 | 80 | return 0; |
81 | 81 | } |
82 | 82 | //first ensure there are no other relation entries for this event |
83 | 83 | //because although EE4 supports it, EE3 didn't really |
84 | - $wpdb->delete( $this->_new_table, |
|
84 | + $wpdb->delete($this->_new_table, |
|
85 | 85 | array( |
86 | 86 | 'EVT_ID' => $new_event_id, |
87 | 87 | ), |
88 | 88 | array( |
89 | - '%d',//EVT_ID |
|
89 | + '%d', //EVT_ID |
|
90 | 90 | )); |
91 | 91 | // echo "last query". $wpdb->last_query;die; |
92 | 92 | $cols_n_values = array( |
@@ -95,12 +95,12 @@ discard block |
||
95 | 95 | 'EVV_primary'=>true |
96 | 96 | ); |
97 | 97 | $datatypes = array( |
98 | - '%d',//EVT_ID |
|
99 | - '%d',//VNU_ID |
|
100 | - '%d',//EVT_primary |
|
98 | + '%d', //EVT_ID |
|
99 | + '%d', //VNU_ID |
|
100 | + '%d', //EVT_primary |
|
101 | 101 | ); |
102 | - $success = $wpdb->insert($this->_new_table,$cols_n_values,$datatypes); |
|
103 | - if ( ! $success){ |
|
102 | + $success = $wpdb->insert($this->_new_table, $cols_n_values, $datatypes); |
|
103 | + if ( ! $success) { |
|
104 | 104 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_event_venue_rel, $this->_new_table, $cols_n_values, $datatypes)); |
105 | 105 | return 0; |
106 | 106 | } |
@@ -36,7 +36,7 @@ discard block |
||
36 | 36 | ) |
37 | 37 | ); |
38 | 38 | */ |
39 | -class EE_DMS_4_1_0_line_items extends EE_Data_Migration_Script_Stage_Table{ |
|
39 | +class EE_DMS_4_1_0_line_items extends EE_Data_Migration_Script_Stage_Table { |
|
40 | 40 | private $_new_line_table; |
41 | 41 | private $_new_transaction_table; |
42 | 42 | private $_new_reg_table; |
@@ -52,21 +52,21 @@ discard block |
||
52 | 52 | |
53 | 53 | protected function _migrate_old_row($old_row) { |
54 | 54 | //insert line items if its a primary id |
55 | - if(intval($old_row['is_primary'])){ |
|
55 | + if (intval($old_row['is_primary'])) { |
|
56 | 56 | $txn_id = $this->get_migration_script()->get_mapping_new_pk($this->_old_table, $old_row['id'], $this->_new_transaction_table); |
57 | - if ( ! $txn_id ){ |
|
58 | - $this->add_error(sprintf(__("Could not find the transaction for the 3.1 attendee %d from row %s", "event_espresso"),$old_row['id'],$this->_json_encode($old_row))); |
|
57 | + if ( ! $txn_id) { |
|
58 | + $this->add_error(sprintf(__("Could not find the transaction for the 3.1 attendee %d from row %s", "event_espresso"), $old_row['id'], $this->_json_encode($old_row))); |
|
59 | 59 | return; |
60 | 60 | } |
61 | 61 | $txn = $this->_get_txn($txn_id); |
62 | - $new_line_items = $this->_insert_new_line_items($txn,$old_row); |
|
63 | - $this->get_migration_script()->set_mapping($this->_old_table,$old_row['id'],$this->_new_line_table,$new_line_items); |
|
62 | + $new_line_items = $this->_insert_new_line_items($txn, $old_row); |
|
63 | + $this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_line_table, $new_line_items); |
|
64 | 64 | } |
65 | 65 | } |
66 | 66 | |
67 | - private function _get_txn($txn_id){ |
|
67 | + private function _get_txn($txn_id) { |
|
68 | 68 | global $wpdb; |
69 | - $txn = $wpdb->get_row($wpdb->prepare("SELECT * FROM $this->_new_transaction_table WHERE TXN_ID=%d",$txn_id),ARRAY_A); |
|
69 | + $txn = $wpdb->get_row($wpdb->prepare("SELECT * FROM $this->_new_transaction_table WHERE TXN_ID=%d", $txn_id), ARRAY_A); |
|
70 | 70 | return $txn; |
71 | 71 | } |
72 | 72 | |
@@ -77,9 +77,9 @@ discard block |
||
77 | 77 | * @param array $transaction |
78 | 78 | * @return array new line item ids |
79 | 79 | */ |
80 | - private function _insert_new_line_items($transaction,$old_attendee){ |
|
80 | + private function _insert_new_line_items($transaction, $old_attendee) { |
|
81 | 81 | global $wpdb; |
82 | - $regs_on_this_transaction = $wpdb->get_results($wpdb->prepare("SELECT * FROM ".$this->_new_reg_table." WHERE TXN_ID=%d",$transaction['TXN_ID']),ARRAY_A); |
|
82 | + $regs_on_this_transaction = $wpdb->get_results($wpdb->prepare("SELECT * FROM ".$this->_new_reg_table." WHERE TXN_ID=%d", $transaction['TXN_ID']), ARRAY_A); |
|
83 | 83 | $new_line_item_ids = array(); |
84 | 84 | //create a totla line item |
85 | 85 | $total_line_item_id = $this->_insert_new_line_item(array( |
@@ -90,11 +90,11 @@ discard block |
||
90 | 90 | 'LIN_type'=>'total', |
91 | 91 | 'OBJ_ID'=>$transaction['TXN_ID'], |
92 | 92 | 'OBJ_type'=>'Transaction' |
93 | - ),$old_attendee); |
|
93 | + ), $old_attendee); |
|
94 | 94 | $new_line_item_ids[] = $total_line_item_id; |
95 | 95 | //create a subtotal line item |
96 | 96 | $reg_total = 0; |
97 | - foreach($regs_on_this_transaction as $new_reg){ |
|
97 | + foreach ($regs_on_this_transaction as $new_reg) { |
|
98 | 98 | $reg_total += floatval($new_reg['REG_final_price']); |
99 | 99 | } |
100 | 100 | $subtotal_line_item_id = $this->_insert_new_line_item(array( |
@@ -104,26 +104,26 @@ discard block |
||
104 | 104 | 'LIN_total'=>$reg_total, |
105 | 105 | 'LIN_parent'=>$total_line_item_id, |
106 | 106 | 'LIN_type'=>'sub-total', |
107 | - ),$old_attendee); |
|
107 | + ), $old_attendee); |
|
108 | 108 | $new_line_item_ids[] = $subtotal_line_item_id; |
109 | 109 | //group REGs by TKT_ID |
110 | 110 | $regs_by_tkt = array(); |
111 | - foreach($regs_on_this_transaction as $new_reg){ |
|
111 | + foreach ($regs_on_this_transaction as $new_reg) { |
|
112 | 112 | $regs_by_tkt[$new_reg['TKT_ID']][] = $new_reg; |
113 | 113 | } |
114 | 114 | |
115 | 115 | //create individual line items |
116 | 116 | |
117 | - foreach($regs_by_tkt as $ticket_id => $regs){ |
|
117 | + foreach ($regs_by_tkt as $ticket_id => $regs) { |
|
118 | 118 | $count = count($regs); |
119 | 119 | $line_total = 0; |
120 | - foreach($regs as $new_reg){ |
|
120 | + foreach ($regs as $new_reg) { |
|
121 | 121 | $line_total += $new_reg['REG_final_price']; |
122 | 122 | } |
123 | 123 | $a_reg = reset($regs); |
124 | 124 | $new_ticket = $this->_get_new_ticket_row($a_reg['TKT_ID']); |
125 | 125 | $reg_line_item_id = $this->_insert_new_line_item(array( |
126 | - 'LIN_code'=> md5( 'Ticket' . $ticket_id . time() ), |
|
126 | + 'LIN_code'=> md5('Ticket'.$ticket_id.time()), |
|
127 | 127 | 'TXN_ID'=>$transaction['TXN_ID'], |
128 | 128 | 'LIN_name'=>$new_ticket['TKT_name'], |
129 | 129 | 'LIN_unit_price'=>$a_reg['REG_final_price'], |
@@ -133,7 +133,7 @@ discard block |
||
133 | 133 | 'LIN_parent'=>$subtotal_line_item_id, |
134 | 134 | 'OBJ_ID'=>$ticket_id, |
135 | 135 | 'OBJ_type'=>'Ticket' |
136 | - ),$old_attendee); |
|
136 | + ), $old_attendee); |
|
137 | 137 | $new_line_item_ids[] = $reg_line_item_id; |
138 | 138 | } |
139 | 139 | |
@@ -147,13 +147,13 @@ discard block |
||
147 | 147 | * @param type $new_ticket_id |
148 | 148 | * @return array |
149 | 149 | */ |
150 | - private function _get_new_ticket_row($new_ticket_id){ |
|
150 | + private function _get_new_ticket_row($new_ticket_id) { |
|
151 | 151 | global $wpdb; |
152 | - $ticket_row = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".$wpdb->prefix."esp_ticket WHERE TKT_ID=%d",$new_ticket_id),ARRAY_A); |
|
152 | + $ticket_row = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".$wpdb->prefix."esp_ticket WHERE TKT_ID=%d", $new_ticket_id), ARRAY_A); |
|
153 | 153 | return $ticket_row; |
154 | 154 | } |
155 | 155 | |
156 | - private function _insert_new_line_item($cols_n_values,$old_attendee){ |
|
156 | + private function _insert_new_line_item($cols_n_values, $old_attendee) { |
|
157 | 157 | global $wpdb; |
158 | 158 | $default_cols_n_values = array( |
159 | 159 | 'LIN_code'=>'', |
@@ -171,25 +171,25 @@ discard block |
||
171 | 171 | 'OBJ_ID'=>null, |
172 | 172 | 'OBJ_type'=>null |
173 | 173 | ); |
174 | - $cols_n_values = array_merge($default_cols_n_values,$cols_n_values); |
|
174 | + $cols_n_values = array_merge($default_cols_n_values, $cols_n_values); |
|
175 | 175 | $datatypes = array( |
176 | - '%s',//LIN_code |
|
177 | - '%d',//TXN_ID |
|
178 | - '%s',//LIN_name |
|
179 | - '%s',//LIN_desc |
|
180 | - '%f',//LIN_unit_price |
|
181 | - '%f',//LIN_percent |
|
182 | - '%d',//LIN_is_taxable |
|
183 | - '%d',//LIN_order |
|
184 | - '%f',//LIN_total |
|
185 | - '%d',//LIN_quantity |
|
186 | - '%d',//LIN_parent |
|
187 | - '%s',//LIN_type |
|
188 | - '%d',//OBJ_ID |
|
189 | - '%s',//OBJ_type |
|
176 | + '%s', //LIN_code |
|
177 | + '%d', //TXN_ID |
|
178 | + '%s', //LIN_name |
|
179 | + '%s', //LIN_desc |
|
180 | + '%f', //LIN_unit_price |
|
181 | + '%f', //LIN_percent |
|
182 | + '%d', //LIN_is_taxable |
|
183 | + '%d', //LIN_order |
|
184 | + '%f', //LIN_total |
|
185 | + '%d', //LIN_quantity |
|
186 | + '%d', //LIN_parent |
|
187 | + '%s', //LIN_type |
|
188 | + '%d', //OBJ_ID |
|
189 | + '%s', //OBJ_type |
|
190 | 190 | ); |
191 | - $success = $wpdb->insert($this->_new_line_table,$cols_n_values,$datatypes); |
|
192 | - if ( ! $success){ |
|
191 | + $success = $wpdb->insert($this->_new_line_table, $cols_n_values, $datatypes); |
|
192 | + if ( ! $success) { |
|
193 | 193 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_reg_table, $cols_n_values, $datatypes)); |
194 | 194 | return 0; |
195 | 195 | } |
@@ -38,7 +38,7 @@ discard block |
||
38 | 38 | ); |
39 | 39 | * |
40 | 40 | */ |
41 | -class EE_DMS_4_1_0_question_groups extends EE_Data_Migration_Script_Stage{ |
|
41 | +class EE_DMS_4_1_0_question_groups extends EE_Data_Migration_Script_Stage { |
|
42 | 42 | private $_old_table; |
43 | 43 | private $_new_table; |
44 | 44 | /** |
@@ -49,19 +49,19 @@ discard block |
||
49 | 49 | * @var boolean |
50 | 50 | */ |
51 | 51 | private $_already_got_system_question_group_1 = false; |
52 | - function _migration_step($num_items=50){ |
|
52 | + function _migration_step($num_items = 50) { |
|
53 | 53 | |
54 | 54 | global $wpdb; |
55 | 55 | $start_at_record = $this->count_records_migrated(); |
56 | - $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A); |
|
56 | + $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A); |
|
57 | 57 | $items_actually_migrated = 0; |
58 | - foreach($rows as $question_group){ |
|
58 | + foreach ($rows as $question_group) { |
|
59 | 59 | $new_id = $this->_insert_new_question_group($question_group); |
60 | 60 | |
61 | 61 | $this->get_migration_script()->set_mapping($this->_old_table, $question_group['id'], $this->_new_table, $new_id); |
62 | 62 | $items_actually_migrated++; |
63 | 63 | } |
64 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
64 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
65 | 65 | $this->set_completed(); |
66 | 66 | } |
67 | 67 | return $items_actually_migrated; |
@@ -85,24 +85,24 @@ discard block |
||
85 | 85 | * @param array $old_question_group |
86 | 86 | * @return int |
87 | 87 | */ |
88 | - private function _insert_new_question_group($old_question_group){ |
|
88 | + private function _insert_new_question_group($old_question_group) { |
|
89 | 89 | global $wpdb; |
90 | 90 | //try to guess what the QST_system int should be... finding the Personal info system |
91 | 91 | //question group is quite easy. But in 3.1 address info WASN'T a system group, it just exitsed by default but |
92 | 92 | //could be easily removed. |
93 | - if($old_question_group['system_group'] && ! $this->_already_got_system_question_group_1()){ |
|
93 | + if ($old_question_group['system_group'] && ! $this->_already_got_system_question_group_1()) { |
|
94 | 94 | $guess_at_system_number = 1; |
95 | - }elseif($old_question_group['id'] == '2' && strpos($old_question_group['group_name'],'Address')!==FALSE){ |
|
95 | + }elseif ($old_question_group['id'] == '2' && strpos($old_question_group['group_name'], 'Address') !== FALSE) { |
|
96 | 96 | $guess_at_system_number = 2; |
97 | - }else{ |
|
97 | + } else { |
|
98 | 98 | $guess_at_system_number = 0; |
99 | 99 | } |
100 | 100 | //if the question group wasn't made by the normal admin, |
101 | 101 | //we'd like to keep track of who made it |
102 | - if(intval($old_question_group['wp_user'])!=1){ |
|
103 | - $username = $wpdb->get_var($wpdb->prepare("SELECT user_nicename FROM ".$wpdb->users." WHERE ID = %d",$old_question_group['wp_user'])); |
|
102 | + if (intval($old_question_group['wp_user']) != 1) { |
|
103 | + $username = $wpdb->get_var($wpdb->prepare("SELECT user_nicename FROM ".$wpdb->users." WHERE ID = %d", $old_question_group['wp_user'])); |
|
104 | 104 | $identifier = $old_question_group['group_identifier']."-by-".$username; |
105 | - }else{ |
|
105 | + } else { |
|
106 | 106 | $identifier = $old_question_group['group_identifier']; |
107 | 107 | } |
108 | 108 | $cols_n_values = array( |
@@ -116,17 +116,17 @@ discard block |
||
116 | 116 | 'QSG_deleted'=>false |
117 | 117 | ); |
118 | 118 | $datatypes = array( |
119 | - '%s',//QSG_name |
|
120 | - '%s',//QSG_identifier |
|
121 | - '%s',//QSG_desc |
|
122 | - '%d',//QSG_order |
|
123 | - '%d',//QSG_show_group_name |
|
124 | - '%d',//QSG_show_group_desc |
|
125 | - '%d',//QSG_system |
|
126 | - '%d',//QSG_deleted |
|
119 | + '%s', //QSG_name |
|
120 | + '%s', //QSG_identifier |
|
121 | + '%s', //QSG_desc |
|
122 | + '%d', //QSG_order |
|
123 | + '%d', //QSG_show_group_name |
|
124 | + '%d', //QSG_show_group_desc |
|
125 | + '%d', //QSG_system |
|
126 | + '%d', //QSG_deleted |
|
127 | 127 | ); |
128 | - $success = $wpdb->insert($this->_new_table,$cols_n_values,$datatypes); |
|
129 | - if ( ! $success){ |
|
128 | + $success = $wpdb->insert($this->_new_table, $cols_n_values, $datatypes); |
|
129 | + if ( ! $success) { |
|
130 | 130 | $this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_question_group, $this->_new_table, $cols_n_values, $datatypes)); |
131 | 131 | return 0; |
132 | 132 | } |
@@ -138,12 +138,12 @@ discard block |
||
138 | 138 | * @global type $wpdb |
139 | 139 | * @return boolean |
140 | 140 | */ |
141 | - private function _already_got_system_question_group_1(){ |
|
142 | - if( ! $this->_already_got_system_question_group_1 ){ |
|
141 | + private function _already_got_system_question_group_1() { |
|
142 | + if ( ! $this->_already_got_system_question_group_1) { |
|
143 | 143 | //check the db |
144 | 144 | global $wpdb; |
145 | 145 | $exists = $wpdb->get_var("SELECT COUNT(*) FROM {$this->_new_table} WHERE QSG_system=1"); |
146 | - if(intval($exists)>0){ |
|
146 | + if (intval($exists) > 0) { |
|
147 | 147 | $this->_already_got_system_question_group_1 = true; |
148 | 148 | } |
149 | 149 | } |
@@ -92,9 +92,9 @@ discard block |
||
92 | 92 | //could be easily removed. |
93 | 93 | if($old_question_group['system_group'] && ! $this->_already_got_system_question_group_1()){ |
94 | 94 | $guess_at_system_number = 1; |
95 | - }elseif($old_question_group['id'] == '2' && strpos($old_question_group['group_name'],'Address')!==FALSE){ |
|
95 | + } elseif($old_question_group['id'] == '2' && strpos($old_question_group['group_name'],'Address')!==FALSE){ |
|
96 | 96 | $guess_at_system_number = 2; |
97 | - }else{ |
|
97 | + } else{ |
|
98 | 98 | $guess_at_system_number = 0; |
99 | 99 | } |
100 | 100 | //if the question group wasn't made by the normal admin, |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | if(intval($old_question_group['wp_user'])!=1){ |
103 | 103 | $username = $wpdb->get_var($wpdb->prepare("SELECT user_nicename FROM ".$wpdb->users." WHERE ID = %d",$old_question_group['wp_user'])); |
104 | 104 | $identifier = $old_question_group['group_identifier']."-by-".$username; |
105 | - }else{ |
|
105 | + } else{ |
|
106 | 106 | $identifier = $old_question_group['group_identifier']; |
107 | 107 | } |
108 | 108 | $cols_n_values = array( |
@@ -2,8 +2,7 @@ |
||
2 | 2 | |
3 | 3 | /** |
4 | 4 | * Goes through all the posts and pages, and converts old shortcodes to new ones |
5 | - |
|
6 | -*/ |
|
5 | + */ |
|
7 | 6 | |
8 | 7 | class EE_DMS_4_1_0_shortcodes extends EE_Data_Migration_Script_Stage{ |
9 | 8 | function __construct() { |
@@ -5,7 +5,7 @@ discard block |
||
5 | 5 | |
6 | 6 | */ |
7 | 7 | |
8 | -class EE_DMS_4_1_0_shortcodes extends EE_Data_Migration_Script_Stage{ |
|
8 | +class EE_DMS_4_1_0_shortcodes extends EE_Data_Migration_Script_Stage { |
|
9 | 9 | function __construct() { |
10 | 10 | global $wpdb; |
11 | 11 | $this->_pretty_name = __("Shortcodes", "event_espresso"); |
@@ -15,13 +15,13 @@ discard block |
||
15 | 15 | protected function _migrate_old_row($old_row) { |
16 | 16 | $new_post_content = $this->_change_event_list_shortcode($old_row['post_content']); |
17 | 17 | global $wpdb; |
18 | - $wpdb->query($wpdb->prepare("UPDATE ".$this->_old_table." SET post_content=%s WHERE ID=%d",$new_post_content,$old_row['ID'])); |
|
18 | + $wpdb->query($wpdb->prepare("UPDATE ".$this->_old_table." SET post_content=%s WHERE ID=%d", $new_post_content, $old_row['ID'])); |
|
19 | 19 | $slug = $old_row['post_name']; |
20 | 20 | $matches = array(); |
21 | - $success = preg_match_all('(ESPRESSO_[^ \]]*)',$new_post_content,$matches);; |
|
22 | - if($success){ |
|
21 | + $success = preg_match_all('(ESPRESSO_[^ \]]*)', $new_post_content, $matches); ; |
|
22 | + if ($success) { |
|
23 | 23 | $shortcodes = $matches[0]; |
24 | - foreach($shortcodes as $shortcode){ |
|
24 | + foreach ($shortcodes as $shortcode) { |
|
25 | 25 | EE_Config::instance()->core->post_shortcodes[$slug][$shortcode] = $old_row['ID']; |
26 | 26 | EE_Config::instance()->core->post_shortcodes['posts'][$shortcode] = $old_row['ID']; |
27 | 27 | } |
@@ -41,20 +41,20 @@ discard block |
||
41 | 41 | * replaces [EVENT_LIST... with [ESPRESSO_EVENTS...] |
42 | 42 | * @param string $old_content |
43 | 43 | */ |
44 | - private function _change_event_list_shortcode($old_content){ |
|
45 | - return str_replace("[EVENT_LIST","[ESPRESSO_EVENTS",$old_content); |
|
44 | + private function _change_event_list_shortcode($old_content) { |
|
45 | + return str_replace("[EVENT_LIST", "[ESPRESSO_EVENTS", $old_content); |
|
46 | 46 | } |
47 | 47 | |
48 | - function _migration_step($num_items=50){ |
|
48 | + function _migration_step($num_items = 50) { |
|
49 | 49 | global $wpdb; |
50 | 50 | $start_at_record = $this->count_records_migrated(); |
51 | - $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table {$this->_sql_to_only_select_non_drafts()} LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A); |
|
51 | + $rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table {$this->_sql_to_only_select_non_drafts()} LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A); |
|
52 | 52 | $items_actually_migrated = 0; |
53 | - foreach($rows as $old_row){ |
|
53 | + foreach ($rows as $old_row) { |
|
54 | 54 | $this->_migrate_old_row($old_row); |
55 | 55 | $items_actually_migrated++; |
56 | 56 | } |
57 | - if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){ |
|
57 | + if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) { |
|
58 | 58 | $this->set_completed(); |
59 | 59 | } |
60 | 60 | return $items_actually_migrated; |
@@ -65,7 +65,7 @@ discard block |
||
65 | 65 | return $count; |
66 | 66 | } |
67 | 67 | |
68 | - private function _sql_to_only_select_non_drafts(){ |
|
68 | + private function _sql_to_only_select_non_drafts() { |
|
69 | 69 | return " WHERE post_type NOT IN ('revision','auto-draft') "; |
70 | 70 | } |
71 | 71 |