Changeset 60711 for trunk/src/wp-includes/taxonomy.php

Timestamp:

09/05/2025 01:28:20 PM (3 months ago)

Author:

SergeyBiryukov

Message:

Taxonomy: Add update_term_count action that fires when term counts are updated.

This allows plugins to run custom queries only when a term count is actually updated and not on every update of terms or posts.

Follow-up to [60365], [60510].

Props leonidasmilossis, peterwilsoncc, mukesh27, rollybueno, SergeyBiryukov.
Fixes #63904.

File:

• trunk/src/wp-includes/taxonomy.php (modified) (3 diffs)

trunk/src/wp-includes/taxonomy.php

@@ -4176 +4176 @@
     $post_statuses = esc_sql( apply_filters( 'update_post_term_count_statuses', $post_statuses, $taxonomy ) );
 
-    foreach ( (array) $terms as $term ) {
+    foreach ( (array) $terms as $tt_id ) {
         $count = 0;
 
@@ -4182 +4182 @@
         if ( $check_attachments ) {
             // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders.QuotedDynamicPlaceholderGeneration
-            $count += (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->term_relationships, $wpdb->posts p1 WHERE p1.ID = $wpdb->term_relationships.object_id AND ( post_status IN ('" . implode( "', '", $post_statuses ) . "') OR ( post_status = 'inherit' AND post_parent > 0 AND ( SELECT post_status FROM $wpdb->posts WHERE ID = p1.post_parent ) IN ('" . implode( "', '", $post_statuses ) . "') ) ) AND post_type = 'attachment' AND term_taxonomy_id = %d", $term ) );
+            $count += (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->term_relationships, $wpdb->posts p1 WHERE p1.ID = $wpdb->term_relationships.object_id AND ( post_status IN ('" . implode( "', '", $post_statuses ) . "') OR ( post_status = 'inherit' AND post_parent > 0 AND ( SELECT post_status FROM $wpdb->posts WHERE ID = p1.post_parent ) IN ('" . implode( "', '", $post_statuses ) . "') ) ) AND post_type = 'attachment' AND term_taxonomy_id = %d", $tt_id ) );
         }
 
         if ( $object_types ) {
             // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders.QuotedDynamicPlaceholderGeneration
-            $count += (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->term_relationships, $wpdb->posts WHERE $wpdb->posts.ID = $wpdb->term_relationships.object_id AND post_status IN ('" . implode( "', '", $post_statuses ) . "') AND post_type IN ('" . implode( "', '", $object_types ) . "') AND term_taxonomy_id = %d", $term ) );
-        }
+            $count += (int) $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->term_relationships, $wpdb->posts WHERE $wpdb->posts.ID = $wpdb->term_relationships.object_id AND post_status IN ('" . implode( "', '", $post_statuses ) . "') AND post_type IN ('" . implode( "', '", $object_types ) . "') AND term_taxonomy_id = %d", $tt_id ) );
+        }
+
+        /**
+         * Fires when a term count is calculated, before it is updated in the database.
+         *
+         * @since 6.9.0
+         *
+         * @param int    $tt_id         Term taxonomy ID.
+         * @param string $taxonomy_name Taxonomy slug.
+         * @param int    $count         Term count.
+         */
+        do_action( 'update_term_count', $tt_id, $taxonomy->name, $count );
 
         /** This action is documented in wp-includes/taxonomy.php */
-        do_action( 'edit_term_taxonomy', $term, $taxonomy->name );
-        $wpdb->update( $wpdb->term_taxonomy, compact( 'count' ), array( 'term_taxonomy_id' => $term ) );
+        do_action( 'edit_term_taxonomy', $tt_id, $taxonomy->name );
+        $wpdb->update( $wpdb->term_taxonomy, compact( 'count' ), array( 'term_taxonomy_id' => $tt_id ) );
 
         /** This action is documented in wp-includes/taxonomy.php */
-        do_action( 'edited_term_taxonomy', $term, $taxonomy->name );
+        do_action( 'edited_term_taxonomy', $tt_id, $taxonomy->name );
     }
 }
@@ -4216 +4227 @@
     foreach ( (array) $terms as $term ) {
         $count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM $wpdb->term_relationships WHERE term_taxonomy_id = %d", $term ) );
+
+        /** This action is documented in wp-includes/taxonomy.php */
+        do_action( 'update_term_count', $term, $taxonomy->name, $count );
 
         /** This action is documented in wp-includes/taxonomy.php */