Changeset 2706

Timestamp:

03/08/2016 01:48:04 PM (11 years ago)

Author:

kovshenin

Message:

WordCamp Budgets: Index the date_paid field to reimbursement requests.

Location:

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

Files:

• reimbursement-requests-dashboard.php (modified) (4 diffs)
• wordcamp-budgets-dashboard.php (modified) (1 diff)

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wordcamp-payments-network/includes/reimbursement-requests-dashboard.php

@@ -5 +5 @@
 defined( 'WPINC' ) or die();
 
-const LATEST_DATABASE_VERSION = 1;
+const LATEST_DATABASE_VERSION = 2;
 
 if ( is_network_admin() ) {
@@ -154 +154 @@
                         request_id     int( 11 )        unsigned NOT NULL default '0',
                         date_requested int( 11 )        unsigned NOT NULL default '0',
+                        date_paid      int( 11 )        unsigned NOT NULL default '0',
                         request_title  varchar( 75 )             NOT NULL default '',
                         status         varchar( 30 )             NOT NULL default '',
@@ -160 +161 @@
                         amount         numeric( 10, 2 ) unsigned NOT NULL default '0',
 
-                        PRIMARY KEY (blog_id, request_id),
+                        PRIMARY KEY  (blog_id, request_id),
                         KEY status (status)
                 )
@@ -223 +224 @@
                 'request_id'     => $request_id,
                 'date_requested' => strtotime( $request->post_date_gmt ),
+                'date_paid'      => get_post_meta( $request_id, '_wcbrr_date_paid', true ),
                 'request_title'  => $request->post_title,
                 'status'         => $request->post_status,

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

@@ -61 +61 @@
                         <h1>Import/Export</h1>
 
-                        <?php do_action( 'admin_notices' ); ?>
                         <?php settings_errors(); ?>