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

Timestamp:

04/20/2017 12:56:53 AM (9 years ago)

Author:

dcavins

Message:

Add 'meta_id' orderby option to BP_Groups_Group::get().

Add meta_id orderby option to groups_get_groups() and its
underlying function BP_Groups_Group::get(). When searching for groups
by meta value, the found groups may now be ordered by the order in
which the found meta rows appear in the bp_groups_groupmeta table.

See #6014.

File:

• trunk/src/bp-groups/classes/class-bp-groups-group.php (modified) (4 diffs)

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

@@ -884 +884 @@
      *                                            Default: null.
      *     @type string       $orderby            Optional. Property to sort by. 'date_created', 'last_activity',
-     *                                            'total_member_count', 'name', 'random'. Default: 'date_created'.
+     *                                            'total_member_count', 'name', 'random', 'meta_id'.
+     *                                            Default: 'date_created'.
      *     @type string       $order              Optional. Sort order. 'ASC' or 'DESC'. Default: 'DESC'.
      *     @type int          $per_page           Optional. Number of items to return per page of results.
@@ -994 +995 @@
         $where_conditions = array();
 
-
         if ( ! empty( $r['status'] ) ) {
             if ( ! is_array( $r['status'] ) ) {
@@ -1139 +1139 @@
             $sql['from'] .= " JOIN {$bp->groups->table_name_groupmeta} gm_last_activity on ( g.id = gm_last_activity.group_id )";
             $where_conditions['last_activity'] = "gm_last_activity.meta_key = 'last_activity'";
+        }
+
+        // If 'meta_id' is the requested order, and there's no meta query, fall back to the default.
+        if ( 'meta_id' === $orderby && empty( $meta_query_sql['join'] ) ) {
+            $orderby = 'date_created';
         }
 
@@ -1443 +1448 @@
                 $order_by_term = 'rand()';
                 break;
+
+            case 'meta_id' :
+                $order_by_term = buddypress()->groups->table_name_groupmeta . '.id';
+                break;
         }