Changeset 12993

Timestamp:

12/01/2023 07:43:06 AM (10 months ago)

Author:

dd32

Message:

Plugin Directory: Stats: Pending plugins can be in a 3rd state, pending but author not yet contacted.

See [12992].

File:

• sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/admin/tools/class-stats-report.php (modified) (2 diffs)

sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/admin/tools/class-stats-report.php

@@ -159 +159 @@
         $stats['in_queue_pending_why'] = $wpdb->get_row( $wpdb->prepare(
             'SELECT
-                SUM( IF( active = 0, 1, 0 ) ) AS `author`,
-                SUM( IF( active > 0, 1, 0 ) ) AS `reviewer`
+                SUM( IF( active = 0 AND closed > 0, 1, 0 ) ) AS `author`,
+                SUM( IF( active > 0, 1, 0 ) ) AS `reviewer`,
+                SUM( IF( active = 0 AND closed = 0, 1, 0 ) ) AS `noemail`
             FROM (
                 SELECT
@@ -441 +442 @@
             ?>
             </li>
+            <?php if ( $stats['in_queue_pending_why']['noemail'] ) : ?>
+                <li>
+                <?php
+                    /* translators: %d: number of pending plugins */
+                    printf(
+                        __( '&rarr; (pending; waiting on reviewer, email not yet sent)* : %d', 'wporg-plugins' ),
+                        esc_html( $stats['in_queue_pending_why']['noemail'] )
+                    );
+                ?>
+                </li>
+            <?php endif; ?>
         </ul>