Changeset 13401 for trunk/src/bp-messages/classes/class-bp-messages-thread.php

Timestamp:

01/08/2023 11:03:12 PM (21 months ago)

Author:

espellcaste

Message:

BP_Messages_Thread: return the total number of messages in a thread.

Introducing a new property $messages_total_count to the BP_Messages_Thread class which returns the total number of messages in a thread.

Closes ​https://github.com/buddypress/buddypress/pull/51
Fixews #8697

File:

• trunk/src/bp-messages/classes/class-bp-messages-thread.php (modified) (4 diffs)

trunk/src/bp-messages/classes/class-bp-messages-thread.php

@@ -27 +27 @@
 
     /**
-     * The current messages.
+     * The current messages in the message thread.
      *
      * @since 1.0.0
@@ -33 +33 @@
      */
     public $messages;
+
+    /**
+     * The current messages count in the message thread.
+     *
+     * @since 12.0.0
+     * @var int
+     */
+    public $messages_total_count;
 
     /**
@@ -189 +197 @@
             return false;
         }
+
+        // Messages total count.
+        $this->messages_total_count = self::get_total_thread_message_count( $this->thread_id );
 
         $last_message_index         = count( $this->messages ) - 1;
@@ -941 +952 @@
 
     /**
+     * Returns the total number of messages in a thread.
+     *
+     * @since 12.0.0
+     *
+     * @global wpdb $wpdb WordPress database object.
+     *
+     * @param integer $thread_id The message thread ID.
+     * @return integer Total thread message count
+     */
+    public static function get_total_thread_message_count( $thread_id ) {
+        global $wpdb;
+
+        $cache_key   = "{$thread_id}_bp_messages_thread_total_count";
+        $total_count = wp_cache_get( $cache_key, 'bp_messages_threads' );
+
+        if ( false === $total_count ) {
+            $bp = buddypress();
+
+            $total_count = (int) $wpdb->get_var(
+                $wpdb->prepare( "SELECT COUNT(id) FROM {$bp->messages->table_name_messages} WHERE thread_id = %d", $thread_id )
+            );
+
+            wp_cache_set( $cache_key, $total_count, 'bp_messages_threads' );
+        }
+
+        /**
+         * Thread messages count.
+         *
+         * @since 12.0.0
+         *
+         * @param integer $total_count Total thread messages count.
+         * @param integer $thread_id   ID of the thread.
+         */
+        return (int) apply_filters( 'messages_thread_get_total_message_count', $total_count, (int) $thread_id );
+    }
+
+    /**
      * Determine if the logged-in user is a sender of any message in a thread.
      *