Changeset 7733

Timestamp:

10/16/2018 05:09:51 PM (6 years ago)

Author:

vedjain

Message:

WordCamp: Add log with with timestamp when status is changed.

This will allow us to query status changes within a given timeperiod. Also minor fixes in meetup public status list and meta keys.

Location:

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wcpt

Files:

• wcpt-event/class-event-admin.php (modified) (2 diffs)
• wcpt-meetup/class-meetup-admin.php (modified) (1 diff)
• wcpt-meetup/class-meetup-application.php (modified) (1 diff)

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wcpt/wcpt-event/class-event-admin.php

@@ -263 +263 @@
         $new_status = get_post_status_object( $new_status );
 
-        add_post_meta(
+        $log_id = add_post_meta(
             $post->ID, '_status_change', array(
                 'timestamp' => time(),
@@ -270 +270 @@
             )
         );
-    }
-
+        // Encoding $post_type and status_change meta ID in key so that we can fetch it if needed while simultaneously be able to have a where clause on value
+        // Because of the way MySQL works, it will still be able to use index on meta_key when searching, as long as we are querying just the prefix
+        if ( $log_id ) {
+            add_post_meta( $post->ID, "_status_change_log_$post->post_type $log_id", time() );
+        }
+    }
 
     /**

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wcpt/wcpt-meetup/class-meetup-admin.php

@@ -660 +660 @@
 
         /**
+         * List of meta keys that can be exposed publicly.
+         *
+         * @return array
+         */
+        public static function get_public_meta_keys() {
+            return array(
+                'Meetup URL',
+                'Meetup Location (From meetup.com)',
+                'Last meetup on',
+            );
+        }
+
+        /**
          * Schedule cron job for updating data from meetup API
          */

sites/trunk/wordcamp.org/public_html/wp-content/plugins/wcpt/wcpt-meetup/class-meetup-application.php

@@ -75 +75 @@
      */
     public static function get_public_post_statuses() {
-        return array( 'wcpt-mtp-nds-swag', 'wcpt-mtp-active', 'wcpt-mtp-dormant' );
+        return array( 'wcpt-mtp-nds-vet', 'wcpt-mtp-active', 'wcpt-mtp-dormant' );
     }