Changeset 2036

Timestamp:

11/03/2015 07:18:51 PM (10 years ago)

Author:

kovshenin

Message:

WordCamp.org: Add search functionality to the payments dashboard.

Location:

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wordcamp-payments-network

Files:

• includes/class-list-table.php (modified) (4 diffs)
• wordcamp-payments-network.php (modified) (6 diffs)

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wordcamp-payments-network/includes/class-list-table.php

@@ -44 +44 @@
         ?>
         <style>
+        #wcp-list-table .search-box {
+            margin-top: 12px;
+        }
+
         #wcp-list-table .manage-column.column-payment {
             width: 30%;
@@ -67 +71 @@
         $limit = '';
 
+        $per_page = 10;
         $orderby = 'due';
         $order = 'asc';
@@ -82 +87 @@
         }
 
+        if ( ! empty( $_REQUEST['s'] ) ) {
+            $where .= $wpdb->prepare( " AND `keywords` LIKE %s ", '%' . $wpdb->esc_like( wp_unslash( $_REQUEST['s'] ) ) . '%' );
+        }
+
         if ( ! empty( $_REQUEST['orderby'] ) && in_array( $_REQUEST['orderby'], array_values( $this->get_sortable_columns() ) ) )
             $orderby = $_REQUEST['orderby'];
@@ -91 +100 @@
 
         $paged = isset( $_REQUEST['paged'] ) ? absint( $_REQUEST['paged'] ) : 1;
-        $per_page = 10;
 
         $limit .= sprintf( " LIMIT %d OFFSET %d ", $per_page, $per_page * ( $paged - 1 ) );

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wordcamp-payments-network/wordcamp-payments-network.php

@@ -12 +12 @@
 class WordCamp_Payments_Network_Tools {
     public static $list_table;
-    public static $db_version = 4;
+    public static $db_version = 6;
 
     /**
@@ -43 +43 @@
     public static function get_table_name() {
         global $wpdb;
-        return $wpdb->get_blog_prefix(0) . 'wordcamp_payments_index';
+        return $wpdb->get_blog_prefix(0) . 'wordcamp_payments_index';
     }
 
@@ -68 +68 @@
             post_id int(11) unsigned NOT NULL default '0',
             created int(11) unsigned NOT NULL default '0',
+            paid int(11) unsigned NOT NULL default '0',
             category varchar(255) NOT NULL default '',
             method varchar(255) NOT NULL default '',
             due int(11) unsigned NOT NULL default '0',
             status varchar(255) NOT NULL default '',
+            keywords text NOT NULL default '',
             PRIMARY KEY  (id),
             KEY blog_post_id (blog_id, post_id),
@@ -124 +126 @@
     public static function prepare_for_index( $request ) {
         $request = get_post( $request );
+        $categories = WCP_Payment_Request::get_payment_categories();
+
+        // All things search.
+        $keywords = array( $request->post_title );
+
+        $category_slug = get_post_meta( $request->ID, '_camppayments_payment_category', true );
+        if ( ! empty( $categories[ $category_slug ] ) )
+            $keywords[] = $categories[ $category_slug ];
+
+        $payment_method = get_post_meta( $request->ID, '_camppayments_payment_method', true );
+        if ( ! empty( $payment_method ) )
+            $keywords[] = $payment_method;
 
         return array(
@@ -133 +147 @@
             'due' => absint( get_post_meta( $request->ID, '_camppayments_due_by', true ) ),
             'status' => $request->post_status,
-            'method' => get_post_meta( $request->ID, '_camppayments_payment_method', true ),
-            'category' => get_post_meta( $request->ID, '_camppayments_payment_category', true ),
+            'method' => $payment_method,
+            'category' => $category_slug,
+            'keywords' => json_encode( $keywords ),
         );
     }
@@ -233 +248 @@
             <form id="posts-filter" action="" method="get">
                 <input type="hidden" name="page" value="wcp-dashboard" />
-                <input type="hidden" name="wcp-section" value="overdue" />
+                <input type="hidden" name="wcp-section" value="<?php echo esc_attr( self::get_current_tab() ); ?>" />
+                <?php self::$list_table->search_box( __( 'Search Payments', 'wordcamporg' ), 'wcp' ); ?>
                 <?php self::$list_table->display(); ?>
             </form>