PHP BP_Groups_Group::get_group_extras方法代码示例

 function get_random($limit = null, $page = null, $user_id = 0, $search_terms = false, $populate_extras = true, $exclude = false)
 {
     global $wpdb, $bp;
     $pag_sql = $hidden_sql = $search_sql = $exclude_sql = '';
     if (!empty($limit) && !empty($page)) {
         $pag_sql = $wpdb->prepare(" LIMIT %d, %d", intval(($page - 1) * $limit), intval($limit));
     }
     if (!is_user_logged_in() || !bp_current_user_can('bp_moderate') && $user_id != bp_loggedin_user_id()) {
         $hidden_sql = "AND g.status != 'hidden'";
     }
     if (!empty($search_terms)) {
         $search_terms = like_escape($wpdb->escape($search_terms));
         $search_sql = " AND ( g.name LIKE '%%{$search_terms}%%' OR g.description LIKE '%%{$search_terms}%%' )";
     }
     if (!empty($exclude)) {
         $exclude = $wpdb->escape($exclude);
         $exclude_sql = " AND g.id NOT IN ({$exclude})";
     }
     if (!empty($user_id)) {
         $user_id = $wpdb->escape($user_id);
         $paged_groups = $wpdb->get_results("SELECT g.*, gm1.meta_value as total_member_count, gm2.meta_value as last_activity FROM {$bp->groups->table_name_groupmeta} gm1, {$bp->groups->table_name_groupmeta} gm2, {$bp->groups->table_name_members} m, {$bp->groups->table_name} g WHERE g.id = m.group_id AND g.id = gm1.group_id AND g.id = gm2.group_id AND gm2.meta_key = 'last_activity' AND gm1.meta_key = 'total_member_count' {$hidden_sql} {$search_sql} AND m.user_id = {$user_id} AND m.is_confirmed = 1 AND m.is_banned = 0 {$exclude_sql} ORDER BY rand() {$pag_sql}");
         $total_groups = $wpdb->get_var("SELECT COUNT(DISTINCT m.group_id) FROM {$bp->groups->table_name_members} m LEFT JOIN {$bp->groups->table_name_groupmeta} gm ON m.group_id = gm.group_id INNER JOIN {$bp->groups->table_name} g ON m.group_id = g.id WHERE gm.meta_key = 'last_activity'{$hidden_sql} {$search_sql} AND m.user_id = {$user_id} AND m.is_confirmed = 1 AND m.is_banned = 0 {$exclude_sql}");
     } else {
         $paged_groups = $wpdb->get_results("SELECT g.*, gm1.meta_value as total_member_count, gm2.meta_value as last_activity FROM {$bp->groups->table_name_groupmeta} gm1, {$bp->groups->table_name_groupmeta} gm2, {$bp->groups->table_name} g WHERE g.id = gm1.group_id AND g.id = gm2.group_id AND gm2.meta_key = 'last_activity' AND gm1.meta_key = 'total_member_count' {$hidden_sql} {$search_sql} {$exclude_sql} ORDER BY rand() {$pag_sql}");
         $total_groups = $wpdb->get_var("SELECT COUNT(DISTINCT g.id) FROM {$bp->groups->table_name_groupmeta} gm INNER JOIN {$bp->groups->table_name} g ON gm.group_id = g.id WHERE gm.meta_key = 'last_activity'{$hidden_sql} {$search_sql} {$exclude_sql}");
     }
     if (!empty($populate_extras)) {
         foreach ((array) $paged_groups as $group) {
             $group_ids[] = $group->id;
         }
         $group_ids = $wpdb->escape(join(',', (array) $group_ids));
         $paged_groups = BP_Groups_Group::get_group_extras($paged_groups, $group_ids, 'newest');
     }
     return array('groups' => $paged_groups, 'total' => $total_groups);
 }

function gtags_get_groups_by_tag($limit = null, $page = null, $user_id = false, $search_terms = false, $group_tag = null)
{
    global $wpdb, $bp;
    $hidden_sql = $search_sql = $tag_sql = $pag_sql = '';
    if ($limit && $page) {
        $pag_sql = $wpdb->prepare(" LIMIT %d, %d", intval(($page - 1) * $limit), intval($limit));
    }
    if (!is_user_logged_in()) {
        $hidden_sql = "AND g.status != 'hidden'";
    }
    if ($search_terms) {
        $search_terms = like_escape($wpdb->escape($search_terms));
        $search_sql = " AND ( g.name LIKE '%%{$search_terms}%%' OR g.description LIKE '%%{$search_terms}%%' )";
    }
    if ($group_tag) {
        $group_tag = like_escape($wpdb->escape($group_tag));
        $group_tag = stripslashes($group_tag);
        $tag_sql = " AND ( gm3.meta_value LIKE '%%{$group_tag}%%' )";
    }
    $paged_groups = $wpdb->get_results("SELECT g.*, gm1.meta_value as total_member_count, gm2.meta_value as last_activity, gm3.meta_value as gtags_group_tags FROM {$bp->groups->table_name_groupmeta} gm1, {$bp->groups->table_name_groupmeta} gm2, {$bp->groups->table_name_groupmeta} gm3, {$bp->groups->table_name} g WHERE g.id = gm1.group_id AND g.id = gm2.group_id AND g.id = gm3.group_id AND gm2.meta_key = 'last_activity' AND gm1.meta_key = 'total_member_count' AND gm3.meta_key = 'gtags_group_tags'  {$hidden_sql} {$search_sql} {$tag_sql} ORDER BY CONVERT(gm1.meta_value, SIGNED) DESC {$pag_sql}");
    // this is commented out because it doesn't really work due to the over-inclusive issue.
    //$total_groups = $wpdb->get_var( "SELECT COUNT(DISTINCT g.id) FROM {$bp->groups->table_name_groupmeta} gm1, {$bp->groups->table_name_groupmeta} gm2, {$bp->groups->table_name_groupmeta} gm3, {$bp->groups->table_name} g WHERE g.id = gm1.group_id AND g.id = gm2.group_id AND g.id = gm3.group_id AND gm2.meta_key = 'last_activity' AND gm1.meta_key = 'total_member_count' AND gm3.meta_key = 'gtags_group_tags' {$hidden_sql} {$search_sql} {$tag_sql}" );
    // loop through results and return only exact matches in comma separated list.
    $paged_groups2 = array();
    foreach ((array) $paged_groups as $group) {
        $items = explode(",", $group->gtags_group_tags);
        $match = false;
        foreach ($items as $item) {
            if (trim(strtolower($item)) == strtolower($group_tag)) {
                $match = true;
            }
        }
        if ($match == true) {
            $paged_groups2[] = $group;
        }
    }
    $total_groups = count($paged_groups2);
    // in place of the commented out code above
    foreach ((array) $paged_groups2 as $group) {
        $group_ids[] = $group->id;
    }
    $group_ids = $wpdb->escape(join(',', (array) $group_ids));
    $paged_groups2 = BP_Groups_Group::get_group_extras(&$paged_groups2, $group_ids, 'popular');
    return array('groups' => $paged_groups2, 'total' => $total_groups);
}

 /**
  * @group get_group_extras
  */
 public function test_get_group_extras_banned()
 {
     $u = $this->factory->user->create();
     $g = $this->factory->group->create();
     $member = new BP_Groups_Member();
     $member->group_id = $g;
     $member->user_id = $u;
     $member->date_modified = bp_core_current_time();
     $member->is_banned = true;
     $member->save();
     $paged_groups = array();
     $paged_groups[] = new stdClass();
     $paged_groups[0]->id = $g;
     $group_ids = array($g);
     $expected = array();
     foreach ($paged_groups as $key => $value) {
         $expected[$key] = new stdClass();
         $expected[$key]->id = $value->id;
         $expected[$key]->is_member = '0';
         $expected[$key]->is_invited = '0';
         $expected[$key]->is_pending = '0';
         $expected[$key]->is_banned = true;
     }
     $old_user = get_current_user_id();
     $this->set_current_user($u);
     $this->assertEquals($expected, BP_Groups_Group::get_group_extras($paged_groups, $group_ids));
     $this->set_current_user($old_user);
 }

 /**
  * Not declared as static in parent, but called statically
  */
 function get_group_extras($paged_groups, $group_ids, $type = false)
 {
     foreach ($paged_groups as $key => $group) {
         if (!isset($group->path)) {
             $paged_groups[$key]->path = self::get_path($group->id);
             $paged_groups[$key]->slug = $paged_groups[$key]->path;
         }
     }
     if (empty($group_ids)) {
         return $paged_groups;
     }
     return parent::get_group_extras($paged_groups, $group_ids, $type);
 }