Changeset 2623

Timestamp:

02/25/2016 11:38:02 PM (10 years ago)

Author:

kovshenin

Message:

WordCamp.org: Add an updated field to the payment requests index.

Location:

sites/branches/wcb-payment-request-statuses/wordcamp.org/public_html/wp-content/plugins/wordcamp-payments-network/includes

Files:

• payment-requests-dashboard.php (modified) (3 diffs)
• payment-requests-list-table.php (modified) (1 diff)

sites/branches/wcb-payment-request-statuses/wordcamp.org/public_html/wp-content/plugins/wordcamp-payments-network/includes/payment-requests-dashboard.php

@@ -3 +3 @@
 class Payment_Requests_Dashboard {
     public static $list_table;
-    public static $db_version = 6;
+    public static $db_version = 7;
     public static $import_results = null;
 
@@ -61 +61 @@
             post_id int(11) unsigned NOT NULL default '0',
             created int(11) unsigned NOT NULL default '0',
+            updated int(11) unsigned NOT NULL default '0',
             paid int(11) unsigned NOT NULL default '0',
             category varchar(255) NOT NULL default '',
@@ -153 +154 @@
         }
 
+        // One of these timestamps.
+        while ( true ) {
+            $updated_timestamp = absint( get_post_meta( $request->ID, '_wcb_updated_timestamp', time() ) );
+            if ( $updated_timestamp ) break;
+
+            $updated_timestamp = strtotime( $request->post_modified_gmt );
+            if ( $updated_timestamp ) break;
+
+            $updated_timestamp = strtotime( $request->post_date_gmt );
+            if ( $updated_timestamp ) break;
+
+            $updated_timestamp = strtotime( $request->post_date );
+            break;
+        }
+
         return array(
             'blog_id' => get_current_blog_id(),
             'post_id' => $request->ID,
             'created' => get_post_time( 'U', true, $request->ID ),
+            'updated' => $updated_timestamp,
             'paid'    => absint( get_post_meta( $request->ID, '_camppayments_date_vendor_paid', true ) ),
             'due' => absint( get_post_meta( $request->ID, '_camppayments_due_by', true ) ),

sites/branches/wcb-payment-request-statuses/wordcamp.org/public_html/wp-content/plugins/wordcamp-payments-network/includes/payment-requests-list-table.php

@@ -86 +86 @@
         } elseif ( 'paid' == $view ) {
             $where .= " AND `status` = 'wcb-paid' ";
-            $orderby = 'created';
+            $orderby = 'updated';
             $order = 'desc';
         } elseif ( 'incomplete' == $view ) {