users; $include = array(); if ( count( $users ) > 0 ) { foreach( $users as $user ) { $include[] = $user->user->ID; } } else { // no results $include[] = 0; } $ids = implode( ',', wp_parse_id_list( $include ) ); $user_query->query_where .= " AND $wpdb->users.ID IN ($ids)"; } } } return $user_query; } /** * Enqueue scripts the group-actions. */ public static function admin_enqueue_scripts() { global $pagenow; if ( ( $pagenow == 'users.php' ) && empty( $_GET['page'] ) ) { Groups_UIE::enqueue( 'select' ); } } /** * Adds the group add/remove buttons after the last action box. */ public static function admin_head() { global $pagenow; if ( ( $pagenow == 'users.php' ) && empty( $_GET['page'] ) ) { // .subsubsub rule added because with views_users() the list can get long // icon distinguishes from role links echo ''; // group-actions echo ''; } } /** * Renders group actions in the users table's extra_tablenav(). */ public static function restrict_manage_users() { global $pagenow, $wpdb, $groups_select_user_groups_index; // We don't handle multiple instances so don't render another. if ( !isset( $groups_select_user_groups_index ) ) { $groups_select_user_groups_index = 0; } else { return ''; } $output = ''; if ( ( $pagenow == 'users.php' ) && empty( $_GET['page'] ) ) { $group_table = _groups_get_tablename( "group" ); // groups select $groups_table = _groups_get_tablename( 'group' ); if ( $groups = $wpdb->get_results( "SELECT * FROM $groups_table ORDER BY name" ) ) { $groups_select = sprintf( ''; } // group bulk actions added through extra_tablenav() $box = '
'; $box .= '
'; $box .= $groups_select; $box .= '
'; $box .= ''; $box .= sprintf( '', __( 'Apply', GROUPS_PLUGIN_DOMAIN ) ); $box .= '
'; $box = str_replace( '"', "'", $box ); $nonce = wp_nonce_field( 'user-group', 'bulk-user-group-nonce', true, false ); $nonce = str_replace( '"', "'", $nonce ); $box .= $nonce; $box .= ''; $output .= $box; $output .= Groups_UIE::render_select( '#user-groups' ); } echo $output; } /** * Hooked on filter in class-wp-list-table.php to add links that * filter by group. * @param array $views */ public static function views_users( $views ) { global $pagenow, $wpdb; if ( ( $pagenow == 'users.php' ) && empty( $_GET['page'] ) ) { $group_table = _groups_get_tablename( "group" ); $user_group_table = _groups_get_tablename( "user_group" ); $groups = $wpdb->get_results( "SELECT * FROM $group_table ORDER BY name" ); foreach( $groups as $group ) { $group = new Groups_Group( $group->group_id ); // Do not use $user_count = count( $group->users ); here, // as it creates a lot of unneccessary objects and can lead // to out of memory issues on large user bases. $user_count = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(user_id) FROM $user_group_table WHERE group_id = %d", Groups_Utility::id( $group->group_id ) ) ); $views[] = sprintf( '%s', esc_url( add_query_arg( 'group', $group->group_id, admin_url( 'users.php' ) ) ), sprintf( '%s Group', wp_filter_nohtml_kses( $group->name ) ), sprintf( '%s (%s)', wp_filter_nohtml_kses( $group->name ), $user_count ) ); } } return $views; } /** * Adds or removes users to/from groups. */ public static function load_users() { if ( current_user_can( GROUPS_ADMINISTER_GROUPS ) ) { $users = isset( $_REQUEST['users'] ) ? $_REQUEST['users'] : null; $action = null; if ( !empty( $_REQUEST['groups'] ) ) { if ( $_GET['groups-action'] == "add-group" ) { $action = 'add'; } else if ( $_GET['groups-action'] == "remove-group" ) { $action = 'remove'; } } if ( $users !== null && $action !== null ) { if ( wp_verify_nonce( $_REQUEST['bulk-user-group-nonce'], 'user-group' ) ) { foreach( $users as $user_id ) { switch ( $action ) { case 'add': $group_ids = isset( $_GET['group_ids'] ) ? $_GET['group_ids'] : null; if ( $group_ids !== null ) { foreach ( $group_ids as $group_id ) { if ( !Groups_User_Group::read( $user_id, $group_id ) ) { Groups_User_Group::create( array( 'user_id' => $user_id, 'group_id' => $group_id ) ); } } } break; case 'remove': $group_ids = isset( $_GET['group_ids'] ) ? $_GET['group_ids'] : null; if ( $group_ids !== null ) { foreach ( $group_ids as $group_id ) { if ( Groups_User_Group::read( $user_id, $group_id ) ) { Groups_User_Group::delete( $user_id, $group_id ); } } } break; } } $referer = wp_get_referer(); if ( $referer ) { $redirect_to = remove_query_arg( array( 'action', 'action2', 'add-to-group', 'bulk-user-group-nonce', 'group_id', 'new_role', 'remove-from-group', 'users' ), $referer ); wp_redirect( $redirect_to ); exit; } } } } } /** * Adds a new column to the users table to show the groups that users * belong to. * * @param array $column_headers * @return array column headers */ public static function manage_users_columns( $column_headers ) { $column_headers[self::GROUPS] = __( 'Groups', GROUPS_PLUGIN_DOMAIN ); return $column_headers; } /** * Renders custom column content. * * @param string $output * @param string $column_name * @param int $user_id * @return string custom column content */ public static function manage_users_custom_column( $output, $column_name, $user_id ) { switch ( $column_name ) { case self::GROUPS : $groups_user = new Groups_User( $user_id ); $groups = $groups_user->groups; if ( count( $groups ) > 0 ) { usort( $groups, array( __CLASS__, 'by_group_name' ) ); $output = ''; } else { $output .= __( '--', GROUPS_PLUGIN_DOMAIN ); } break; } return $output; } /** * usort helper * @param Groups_Group $o1 * @param Groups_Group $o2 * @return int strcmp result for group names */ public static function by_group_name( $o1, $o2 ) { return strcmp( $o1->name, $o2->name ); } } Groups_Admin_Users::init();