Changeset 8308

Timestamp:

02/21/2019 06:15:09 PM (6 years ago)

Author:

iandunn

Message:

CampTix Admin Flags: Allow filtering Atendees screen by admin flag.

Fixes #2893
Props @dd32

File:

• sites/trunk/wordcamp.org/public_html/wp-content/plugins/camptix-admin-flags/addons/admin-flags.php (modified) (2 diffs)

sites/trunk/wordcamp.org/public_html/wp-content/plugins/camptix-admin-flags/addons/admin-flags.php

@@ -45 +45 @@
             add_filter( 'manage_tix_attendee_posts_columns', array( $this, 'add_custom_columns' ) );
             add_action( 'manage_tix_attendee_posts_custom_column', array( $this, 'render_custom_columns' ), 10, 2 );
+            add_filter( 'views_edit-tix_attendee', array( $this, 'add_custom_filters' ) );
+            add_filter( 'pre_get_posts', array( $this, 'add_custom_filters_post_filter' ) );
             add_action( 'admin_footer-edit.php', array( $this, 'render_client_side_templates' ) );
             add_action( 'wp_ajax_tix_admin_flag_toggle', array( $this, 'toggle_flag' ) );
@@ -299 +301 @@
                 break;
         }
+    }
+
+    /**
+     * Add custom views to the attendee listing post listing.
+     *
+     * @param array $views
+     *
+     * @return array
+     */
+    public function add_custom_filters( $views ) {
+        global $wpdb;
+
+        if ( empty( $GLOBALS['typenow'] ) || 'tix_attendee' !== $GLOBALS['typenow'] || empty( $this->flags ) ) {
+            return $views;
+        }
+
+        $meta_counts = $wpdb->get_results( "
+            SELECT meta_value, COUNT( post_id ) AS count
+            FROM {$wpdb->postmeta}
+            WHERE meta_key = 'camptix-admin-flag'
+            GROUP BY meta_value",
+            ARRAY_A
+        );
+        $meta_counts = wp_list_pluck( $meta_counts, 'count', 'meta_value' );
+
+        if ( ! $meta_counts ) {
+            return $views;
+        }
+
+        $currently_viewed_flag = empty( $_GET['camptix_flag'] ) ? false : wp_unslash( $_GET['camptix_flag'] );
+        $base_url              = add_query_arg( 'post_type', 'tix_attendee', 'edit.php' );
+
+        foreach ( $this->flags as $flag => $label ) {
+            $count = 0;
+            $class_html = '';
+            $url        = add_query_arg( 'camptix_flag', $flag, $base_url );
+
+            if ( $currently_viewed_flag && $currently_viewed_flag == $flag ) {
+                $class_html = ' class="current"';
+            }
+
+            if ( isset( $meta_counts[ $flag ] ) ) {
+                $count = $meta_counts[ $flag ];
+            }
+
+            $views[ $flag ] = sprintf(
+                '<a href="%s" %s>
+                    %s <span class="count">(%s)</span>
+                </a>',
+                esc_url( $url ),
+                $class_html,
+                $label,
+                number_format_i18n( $count )
+            );
+        }
+
+        return $views;
+    }
+
+    /**
+     * Filter the wp-admin post listing query to filter to admin flags.
+     *
+     * @param WP_Query $query
+     */
+    public function add_custom_filters_post_filter( $query ) {
+        $flag = empty( $_GET['camptix_flag'] ) ? false : wp_unslash( $_GET['camptix_flag'] );
+
+        if ( ! is_admin() || empty( $GLOBALS['typenow'] ) || 'tix_attendee' !== $GLOBALS['typenow'] ) {
+            return;
+        }
+
+        if ( ! isset( $this->flags[ $flag ] ) ) {
+            return;
+        }
+
+        if ( ! isset( $query->query_vars['meta_query'] ) ) {
+            $query->query_vars['meta_query'] = array();
+        }
+
+        $query->query_vars['meta_query'][] = array(
+            'key'     => 'camptix-admin-flag',
+            'value'   => $flag,
+            'compare' => '=',
+            'type'    => 'CHAR',
+        );
     }