Changeset 11604 for trunk/src/bp-groups/classes/class-bp-groups-group.php

Timestamp:

06/21/2017 10:37:23 PM (9 years ago)

Author:

r-a-y

Message:

Groups: Add fine-grained querying of invite sent status in groups_get_invites_for_group().

This commit introduces a new $sent parameter to groups_get_invites_for_group()
and BP_Groups_Group::get_invites(). With this parameter, developers can
now query group invites by sent status or not.

See #7397.

File:

• trunk/src/bp-groups/classes/class-bp-groups-group.php (modified) (1 diff)

trunk/src/bp-groups/classes/class-bp-groups-group.php

@@ -753 +753 @@
          *
          * @since 1.6.0
-         *
-         * @param int $user_id ID of the inviting user.
-         * @param int $group_id ID of the group.
-         * @return array IDs of users who have been invited to the group by the
-         *               user but have not yet accepted.
-         */
-        public static function get_invites( $user_id, $group_id ) {
+         * @since 2.9.0 Added $sent as a parameter.
+         *
+         * @param  int      $user_id  ID of the inviting user.
+         * @param  int      $group_id ID of the group.
+         * @param  int|null $sent     Query for a specific invite sent status. If 0, this will query for users
+         *                            that haven't had an invite sent to them yet. If 1, this will query for
+         *                            users that have had an invite sent to them. If null, no invite status will
+         *                            queried. Default: null.
+         * @return array    IDs of users who have been invited to the group by the user but have not
+         *                  yet accepted.
+         */
+        public static function get_invites( $user_id, $group_id, $sent = null ) {
                 global $wpdb;
 
-                $bp = buddypress();
-
-                return $wpdb->get_col( $wpdb->prepare( "SELECT user_id FROM {$bp->groups->table_name_members} WHERE group_id = %d and is_confirmed = 0 AND inviter_id = %d", $group_id, $user_id ) );
+                $bp  = buddypress();
+                $sql = $wpdb->prepare( "SELECT user_id FROM {$bp->groups->table_name_members} WHERE group_id = %d and is_confirmed = 0 AND inviter_id = %d", $group_id, $user_id );
+
+                // Query for a specific invite sent status.
+                if ( ! is_null( $sent ) ) {
+                        $sql .= $wpdb->prepare( ' AND invite_sent = %d', $sent );
+                }
+
+                return $wpdb->get_col( $sql );
         }