Changeset 13287

Timestamp:

03/06/2024 06:19:50 AM (23 months ago)

Author:

dd32

Message:

Plugin Directory: Support Threads: When a plugin has no threads in the last two months, reset the threads in the last 2 months meta values to 0.

Fixes #7506.

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/jobs/class-plugin-support-resolved.php (modified) (2 diffs)

sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/jobs/class-plugin-support-resolved.php

@@ -32 +32 @@
         $wpdb->set_blog_id( WPORG_SUPPORT_FORUMS_BLOGID );
         // phpcs:ignore WordPress.VIP.DirectDatabaseQuery
-        $results = $wpdb->get_results( $wpdb->prepare( "SELECT t.slug as plugin_slug, meta_value as resolved, count(*) as topic_count
-FROM {$wpdb->posts} p
-    JOIN {$wpdb->postmeta} pm ON (p.ID = pm.post_id AND pm.meta_key = 'topic_resolved')
-    JOIN {$wpdb->term_relationships} tr ON (p.ID = tr.object_id)
-    JOIN {$wpdb->term_taxonomy} tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = 'topic-plugin')
-    JOIN {$wpdb->terms} t ON (tt.term_id = t.term_id)
-WHERE
-    post_type = 'topic' AND
-    post_status = 'publish' AND
-    post_parent = (SELECT ID FROM {$wpdb->posts} WHERE post_type = 'forum' AND post_name = 'plugins-and-hacks') AND
-    post_date >= %s
-
-GROUP BY t.slug, meta_value", $time_limit ) );
+        $results = $wpdb->get_results( $wpdb->prepare(
+            "SELECT t.slug as plugin_slug, meta_value as resolved, count(*) as topic_count, max(p.post_date) AS most_recent_thread
+            FROM {$wpdb->posts} p
+                JOIN {$wpdb->postmeta} pm ON (p.ID = pm.post_id AND pm.meta_key = 'topic_resolved')
+                JOIN {$wpdb->term_relationships} tr ON (p.ID = tr.object_id)
+                JOIN {$wpdb->term_taxonomy} tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = 'topic-plugin')
+                JOIN {$wpdb->terms} t ON (tt.term_id = t.term_id)
+            WHERE
+                post_type = 'topic' AND
+                post_status = 'publish' AND
+                post_parent = (SELECT ID FROM {$wpdb->posts} WHERE post_type = 'forum' AND post_name = 'plugins-and-hacks') AND
+                post_date >= %s
+            
+            GROUP BY t.slug, meta_value",
+            $time_limit
+        ) );
         $wpdb->set_blog_id( WPORG_PLUGIN_DIRECTORY_BLOGID );
 
         foreach ( $results as $result ) {
-            if ( ! isset( $plugin_stats[ $result->plugin_slug ] ) ) {
-                $plugin_stats[ $result->plugin_slug ] = [
-                    'yes' => 0,
-                    'no'  => 0,
-                    'mu'  => 0,
-                ];
-            }
+            $plugin_stats[ $result->plugin_slug ] ??= [
+                'yes'                => 0,
+                'no'                 => 0,
+                'mu'                 => 0,
+                'most_recent_thread' => 0,
+            ];
 
-            $plugin_stats[ $result->plugin_slug ][ $result->resolved ] = (int) $result->topic_count;
+            $plugin_stats[ $result->plugin_slug ][ $result->resolved ]  = (int) $result->topic_count;
+            $plugin_stats[ $result->plugin_slug ]['most_recent_thread'] = max(
+                strtotime( $result->most_recent_thread ),
+                $plugin_stats[ $result->plugin_slug ]['most_recent_thread']
+            );
         }
 
@@ -68 +74 @@
                 update_post_meta( $plugin->ID, 'support_threads', wp_slash( $stats['yes'] + $stats['no'] ) );
                 update_post_meta( $plugin->ID, 'support_threads_resolved', wp_slash( $stats['yes'] ) );
+                update_post_meta( $plugin->ID, '_last_support_thread', wp_slash( $stats['most_recent_thread'] ) );
             }
 
             Manager::clear_memory_heavy_variables();
         }
+
+        // Find any plugin whose last support thread was before the above time cutoff and mark it as having no threads.
+        $plugins = get_posts( [
+            'post_type'      => 'plugin',
+            'post_status'    => 'publish',
+            'posts_per_page' => -1,
+            'fields'         => 'ids',
+            'meta_query'     => [
+                [
+                    [
+                        'key'     => '_last_support_thread',
+                        'compare' => '<',
+                        'value'   => strtotime( $time_limit ),
+                    ],
+                    'relation' => 'OR',
+                    [
+                        'key'     => '_last_support_thread',
+                        'compare' => 'NOT EXISTS',
+                    ],
+                ],
+                [
+                    'key'     => 'support_threads',
+                    'compare' => '>',
+                    'value'   => 0,
+                ],
+            ],
+        ] );
+
+        foreach ( $plugins as $plugin_id ) {
+            update_post_meta( $plugin_id, 'support_threads', 0 );
+            update_post_meta( $plugin_id, 'support_threads_resolved', 0 );
+        }
     }