Changeset 2706

Timestamp:

03/08/2016 01:48:04 PM (10 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(); ?>