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 ) {