Changeset 7376

Timestamp:

07/05/2018 10:39:54 PM (8 years ago)

Author:

coreymckrill

Message:

WordCamp Reports: Exclude specific sites from report results

Some sites are for testing purposes, and may contain data that would skew
report results if it was included.

Location:

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wordcamp-reports

Files:

• classes/report/class-payment-activity.php (modified) (1 diff)
• classes/report/class-sponsor-invoices.php (modified) (1 diff)
• classes/report/class-ticket-revenue.php (modified) (1 diff)
• index.php (modified) (1 diff)

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wordcamp-reports/classes/report/class-payment-activity.php

@@ -226 +226 @@
         $reimbursements_table = Reimbursement_Requests\get_index_table_name();
 
-        $extra_where = ( $this->wordcamp_site_id ) ? ' AND blog_id = ' . (int) $this->wordcamp_site_id : '';
+        if ( $this->wordcamp_site_id ) {
+            $extra_where = sprintf(
+                ' AND blog_id = %d',
+                intval( $this->wordcamp_site_id )
+            );
+        } else {
+            $extra_where = sprintf(
+                ' AND blog_id NOT IN ( %s )',
+                implode( ',', Reports\get_excluded_site_ids() )
+            );
+        }
 
         $index_query = $wpdb->prepare( "

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wordcamp-reports/classes/report/class-sponsor-invoices.php

@@ -233 +233 @@
             $where_clause[] = "blog_id = %d";
             $where_values[] = $this->wordcamp_site_id;
+        } else {
+            $where_clause[] = 'blog_id NOT IN ( %s )';
+            $where_values[] = implode( ',', Reports\get_excluded_site_ids() );
         }
 

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wordcamp-reports/classes/report/class-ticket-revenue.php

@@ -255 +255 @@
             $where_clause[] = 'blog_id = %d';
             $where_values[] = $this->wordcamp_site_id;
+        } else {
+            $where_clause[] = 'blog_id NOT IN ( %s )';
+            $where_values[] = implode( ',', Reports\get_excluded_site_ids() );
         }
 

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wordcamp-reports/index.php

@@ -311 +311 @@
 
 add_action( 'plugins_loaded', __NAMESPACE__ . '\register_file_exports' );
+
+/**
+ * A list of IDs for sites that should not be included in report results.
+ *
+ * @return array
+ */
+function get_excluded_site_ids() {
+    return array(
+        206, // 2016.testing
+        928, // 2017.testing
+    );
+}