@@ -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; |
@@ -24,8 +24,6 @@ |
||
| 24 | 24 | 'term_taxonomy_id'=>new EE_Foreign_Key_Int_Field('term_taxonomy_id', __('Term (in context of a taxonomy) ID','event_espresso'), false, 0, 'Term_Taxonomy'), |
| 25 | 25 | 'term_order'=>new EE_Integer_Field('term_order', __('Term Order','event_espresso'), false, 0) |
| 26 | 26 | )); |
| 27 | - |
|
| 28 | - |
|
| 29 | 27 | * |
| 30 | 28 | */ |
| 31 | 29 | class EE_DMS_4_1_0_event_category extends EE_Data_Migration_Script_Stage{ |
@@ -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; |
@@ -93,7 +93,7 @@ |
||
| 93 | 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 | 98 | $success = $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->term_taxonomy} SET count = count +1 WHERE term_taxonomy_id=%d", $new_term_taxonomy_id ) ); |
| 99 | 99 | if( ! $success ){ |
@@ -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 | |
@@ -5,7 +5,7 @@ discard block |
||
| 5 | 5 | * The name is set to just be a string representation of the start date (in UTC time for now), and the description is just left blank |
| 6 | 6 | */ |
| 7 | 7 | |
| 8 | -class EE_DMS_4_2_0_datetime_fields extends EE_Data_Migration_Script_Stage_Table{ |
|
| 8 | +class EE_DMS_4_2_0_datetime_fields extends EE_Data_Migration_Script_Stage_Table { |
|
| 9 | 9 | function __construct() { |
| 10 | 10 | global $wpdb; |
| 11 | 11 | $this->_pretty_name = __("Datetime Fields", "event_espresso"); |
@@ -25,14 +25,14 @@ discard block |
||
| 25 | 25 | array( |
| 26 | 26 | 'DTT_ID'=>$old_row['DTT_ID']), |
| 27 | 27 | array( |
| 28 | - '%s',//DTT_name, |
|
| 29 | - '%s',//DTT_description |
|
| 28 | + '%s', //DTT_name, |
|
| 29 | + '%s', //DTT_description |
|
| 30 | 30 | ), |
| 31 | 31 | array( |
| 32 | - '%d',//DTT_ID |
|
| 32 | + '%d', //DTT_ID |
|
| 33 | 33 | )); |
| 34 | - if( FALSE === $updated ){ |
|
| 35 | - $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting DTT_name = '' and DTT_description = '' where DTT_ID = %d", 'event_espresso'),$old_row['QST_ID'])); |
|
| 34 | + if (FALSE === $updated) { |
|
| 35 | + $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting DTT_name = '' and DTT_description = '' where DTT_ID = %d", 'event_espresso'), $old_row['QST_ID'])); |
|
| 36 | 36 | } |
| 37 | 37 | //nothing to map really |
| 38 | 38 | } |