' .
_x( 'Groups', 'page-title', 'groups' ) .
sprintf(
'',
esc_attr__( 'Click to add a new group', 'groups' ),
esc_url( $current_url . '&action=add' )
) .
sprintf(
'
',
esc_attr__( 'Add', 'groups' ),
esc_url( GROUPS_PLUGIN_URL . 'images/add.png' )
) .
sprintf(
'%s',
esc_html__( 'New Group', 'groups' )
) .
'' .
'
';
$output .= Groups_Admin::render_messages();
$row_count = intval( groups_sanitize_post( 'row_count' ) ?? 0 );
if ($row_count <= 0) {
$row_count = Groups_Options::get_user_option( 'groups_per_page', GROUPS_GROUPS_PER_PAGE );
} else {
Groups_Options::update_user_option('groups_per_page', $row_count );
}
$offset = intval( groups_sanitize_get( 'offset' ) ?? 0 );
if ( $offset < 0 ) {
$offset = 0;
}
$paged = intval( groups_sanitize_request( 'paged' ) ?? 0 );
if ( $paged < 0 ) {
$paged = 0;
}
$orderby = groups_sanitize_get( 'orderby' );
switch ( $orderby ) {
case 'group_id' :
case 'name' :
case 'description' :
case 'members':
break;
default:
$orderby = 'name';
}
$order = groups_sanitize_get( 'order' );
switch ( $order ) {
case 'asc' :
case 'ASC' :
$switch_order = 'DESC';
break;
case 'desc' :
case 'DESC' :
$switch_order = 'ASC';
break;
default:
$order = 'ASC';
$switch_order = 'DESC';
}
$filters = array( " 1=%d " );
$filter_params = array( 1 );
if ( $group_id ) {
$filters[] = " $group_table.group_id = %d ";
$filter_params[] = $group_id;
}
if ( $group_name ) {
$filters[] = " $group_table.name LIKE %s ";
$filter_params[] = '%' . $wpdb->esc_like( $group_name ) . '%';
}
if ( !empty( $filters ) ) { // @phpstan-ignore empty.variable
$filters = " WHERE " . implode( " AND ", $filters );
} else {
$filters = '';
}
$count_query = $wpdb->prepare( "SELECT COUNT(*) FROM $group_table $filters", $filter_params ); // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
$count = $wpdb->get_var( $count_query ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
if ( $count > $row_count ) {
$paginate = true;
} else {
$paginate = false;
}
$pages = ceil ( $count / $row_count );
if ( $paged > $pages ) {
$paged = $pages;
}
if ( $paged != 0 ) {
$offset = ( $paged - 1 ) * $row_count;
}
switch ( $orderby ) {
case 'members':
$query = $wpdb->prepare(
// nosemgrep: audit.php.wp.security.sqli.input-in-sinks
"SELECT $group_table.*, COUNT($user_group_table.user_id) AS members " . // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
"FROM $group_table LEFT JOIN $user_group_table ON $group_table.group_id = $user_group_table.group_id " . // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
"$filters " . // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
"GROUP BY $group_table.group_id " . // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
"ORDER BY COUNT($user_group_table.user_id) $order " . // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
"LIMIT $row_count OFFSET $offset", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
$filter_params
);
break;
default:
$query = $wpdb->prepare(
// nosemgrep: audit.php.wp.security.sqli.input-in-sinks
"SELECT * FROM $group_table $filters ORDER BY $orderby $order LIMIT $row_count OFFSET $offset", // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQLPlaceholders.UnfinishedPrepare
$filter_params
);
}
/**
* Allows to modify the query for the groups table.
*
* @since 3.7.0
*
* @param string $query the query
*
* @return string
*/
$query = apply_filters( 'groups_admin_groups_query', $query );
// nosemgrep: audit.php.wp.security.sqli.input-in-sinks
$results = $wpdb->get_results( $query, OBJECT ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
/**
* Allows to modify the results for the groups table.
*
* @since 3.7.0
*
* @param object[] $results result to show
*
* @return object[]
*/
$results = apply_filters( 'groups_admin_groups_results', $results );
$columns = array(
'group_id' => array( 'label' => __( 'ID', 'groups' ), 'sortable' => true ),
'name' => array( 'label' => __( 'Group', 'groups' ), 'sortable' => true ),
'members' => array( 'label' => __( 'Members', 'groups' ), 'sortable' => true ),
'description' => array( 'label' => __( 'Description', 'groups' ), 'sortable' => true ),
'capabilities' => array( 'label' => __( 'Capabilities', 'groups' ), 'sortable' => false )
);
/**
* Allows to modify the columns of the groups table.
*
* @since 3.7.0
*
* @param array $columns maps column keys to column details; keys must be alphanumeric allowing also for underscores '_' and dashes '-', columns with invalid keys are removed; 'checkbox' is a reserved column key and must not be used
*
* @return array
*/
$columns = apply_filters( 'groups_admin_groups_columns', $columns );
unset( $columns['checkbox'] );
foreach ( $columns as $key => $column ) {
if ( preg_replace( '/[^a-zA-Z0-9_-]/', '', $key ) !== $key ) {
unset( $columns[$key] );
}
}
$column_count = count( $columns ) + 1;
$output .= '';
$filters_html = '
'; // .groups-overview
$output .= '';
$filters_html .= '';
$filters_html .= '
'; // .filters
/**
* Allows to process the HTML of the filters section of the groups table.
*
* @since 3.7.0
*
* @param string $filters_html markup
*
* @return string
*/
$output .= apply_filters( 'groups_admin_groups_filters_html', $filters_html );
$capability_table = _groups_get_tablename( "capability" );
// $group_capability_table = _groups_get_tablename( "group_capability" );
// capabilities select
// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
$capabilities = $wpdb->get_results( "SELECT * FROM $capability_table ORDER BY capability" );
$capabilities_select = sprintf(
'';
$capabilities_select .= Groups_UIE::render_select( '.select.capability' );
$output .= ''; // #groups-action
if ( $paginate ) {
require_once GROUPS_CORE_LIB . '/class-groups-pagination.php';
$pagination = new Groups_Pagination($count, null, $row_count);
$output .= '';
$output .= $pagination->pagination( 'bottom' );
$output .= '
';
}
$output .= '