%2$s', $is_global ? 'h2' : 'h3', __( 'Pending Activations', 'gravityformsuserregistration' ) );
?>
'DESC',
'order_by' => 'registered',
'page' => 1,
'per_page' => 10,
'get_total' => false,
'lead_id' => false,
)
)
);
if ( ! is_multisite() ) {
require_once( gf_user_registration()->get_base_path() . '/includes/signups.php' );
GFUserSignups::prep_signups_functionality();
}
$where = array();
if ( $form_id ) {
$where[] = $wpdb->prepare( 'l.form_id = %d', $form_id );
}
if ( $lead_id ) {
$where[] = $wpdb->prepare( 'l.id = %d', $lead_id );
}
$where[] = 's.active = 0';
$where = 'WHERE ' . implode( ' AND ', $where );
$order = "ORDER BY {$order_by} {$order}";
$offset = ( $page * $per_page ) - $per_page;
$limit_offset = $get_total ? '' : "LIMIT $per_page OFFSET $offset";
$method = $get_total ? 'get_var' : 'get_results';
if ( $form_id ) {
$entry_table = self::get_entry_table_name();
$entry_meta_table = self::get_entry_meta_table_name();
$entry_id_column = version_compare( self::get_gravityforms_db_version(), '2.3-dev-1', '<' ) ? 'lead_id' : 'entry_id';
$charset_db = empty( $wpdb->charset ) ? 'utf8mb4' : $wpdb->charset;
$collate = ! empty( $wpdb->collate ) ? " COLLATE {$wpdb->collate}" : '';
$activation_key_col = 's.activation_key';
$meta_value_col = 'lm.meta_value';
// Convert Charset only if necessary.
$activation_key_charset = self::get_column_charset( 'activation_key', $wpdb->signups );
$meta_value_charset = self::get_column_charset( 'meta_value', $entry_meta_table );
// Check if activation_key needs to be converted.
if ( $activation_key_charset !== $charset_db ) {
$activation_key_col = "CONVERT( s.activation_key USING {$charset_db} )";
}
// Check if meta_value needs to be converted.
if ( $meta_value_charset !== $charset_db ) {
$meta_value_col = "CONVERT( lm.meta_value USING {$charset_db} )";
}
$select = $get_total ? 'SELECT count(s.activation_key)' : 'SELECT s.*';
$sql = "
$select FROM {$entry_meta_table} lm
INNER JOIN {$wpdb->signups} s ON {$activation_key_col} = {$meta_value_col} {$collate} AND lm.meta_key = 'activation_key'
INNER JOIN {$entry_table} l ON l.id = lm.{$entry_id_column}
$where
$order
$limit_offset";
$results = $wpdb->$method( $sql );
} else {
$select = $get_total ? 'SELECT count(s.activation_key)' : 'SELECT s.*';
$results = $wpdb->$method(
"$select FROM $wpdb->signups s
$where
$order
$limit_offset"
);
}
return $results;
}
/**
* Get the character encoding for a column in a table.
*
* @since 4.6.2
*
* @param string $column_name Desired column to get charset.
* @param string $table_name Desired table in which column is present.
* @param string $db_name Desired database in which table is present.
*
* @return string|null
*/
public static function get_column_charset( $column_name, $table_name, $db_name = '' ) {
global $wpdb;
if ( '' === $db_name && defined( 'DB_NAME' ) ) {
$db_name = DB_NAME;
}
return $wpdb->get_var(
$wpdb->prepare(
'SELECT character_set_name FROM information_schema.`COLUMNS` WHERE table_schema = %s AND table_name = %s AND column_name = %s',
$db_name,
$table_name,
$column_name
)
);
}
/**
* Handle User activation form submission.
*/
public static function handle_submission() {
if ( ! wp_verify_nonce( rgpost( 'action_nonce' ), 'action' ) && ! check_admin_referer( 'action_nonce', 'action_nonce' ) ) {
die( 'You have failed...' );
}
require_once( gf_user_registration()->get_base_path() . '/includes/signups.php' );
GFUserSignups::prep_signups_functionality();
$action = rgpost( 'single_action' );
$action = ! $action ? rgpost( 'action' ) != -1 ? rgpost( 'action' ) : rgpost( 'action2' ) : $action;
$items = rgpost( 'item' ) ? array( rgpost( 'item' ) ) : rgpost( 'items' );
$messages = array();
$errors = array();
if ( empty( $items ) ) {
return;
}
foreach ( $items as $key ) {
switch ( $action ) {
case 'delete':
$success = GFUserSignups::delete_signup( $key );
if ( self::is_pending_activations_page() ) {
break;
}
if ( $success ) {
gf_user_registration()->add_message_once(
_n(
'User registration deleted.',
'User registrations deleted.',
count( $items ),
'gravityformsuserregistration'
)
);
} else {
gf_user_registration()->add_error_message_once(
_n(
'There was an issue deleting this user registration.',
'There was an issue deleting one or more selected user registrations.',
count( $items ),
'gravityformsuserregistration'
)
);
}
break;
case 'activate':
$userdata = GFUserSignups::activate_signup( $key );
if ( self::is_pending_activations_page() ) {
break;
}
if ( is_wp_error( $userdata ) ) {
$error = _n( 'There was an issue activating this item', 'There was an issue activating one or more selected items', count( $items ), 'gravityformsuserregistration' );
$error .= ': ' . $userdata->get_error_message();
gf_user_registration()->add_error_message_once( $error );
} else {
$message = _n( 'User activated.', 'Users activated.', count( $items ), 'gravityformsuserregistration' );
gf_user_registration()->add_message_once( $message );
}
break;
}
}
}
/**
* Display the "User(s) activated." WordPress admin notice on the pending activations screen.
*
* @since 4.7
*/
public function display_pending_activation_page_notices() {
$items = $this->get_activation_request_items();
$action = $this->get_pending_activation_action();
if ( empty( $items ) || empty( $action ) ) {
return;
}
if ( 'delete' === $action ) {
printf(
'
add_pending_activation_meta_box( array( 'entry' => $entry ) ) ?>
$entry['id'], 'get_total' => true ) ) > 0;
}
/**
* Include the activate user button in the sidebar of the entry detail page.
*
* @param array $meta_boxes The properties for the meta boxes.
* @param array $entry The entry currently being viewed/edited.
*
* @return array
*/
public function register_meta_box( $meta_boxes, $entry ) {
if ( $this->is_entry_pending_activation( $entry ) ) {
$meta_boxes['gf_user_pending_activation'] = array(
'title' => esc_html__( 'User Registration', 'gravityformsuserregistration' ),
'callback' => array( $this, 'add_pending_activation_meta_box' ),
'context' => 'side',
);
}
return $meta_boxes;
}
/**
* The callback used to echo the content to the gf_user_registration meta box.
*
* @param array $args An array containing the form and entry objects.
*/
public function add_pending_activation_meta_box( $args ) {
require_once( gf_user_registration()->get_base_path() . '/includes/signups.php' );
$entry_id = rgar( $args['entry'], 'id' );
$activation_key = GFUserSignups::get_lead_activation_key( $entry_id );
?>
%s %s', esc_html__( 'Pending Activation', 'gravityformsuserregistration' ), esc_html__( 'This entry created a user who is pending activation. Click the "Activate User" button to activate the user.', 'gravityformsuserregistration' ) ) ); ?>
get_gravityforms_db_version();
}
}
/**
* Returns an instance of the GF_Pending_Activations class
*
* @see GF_Pending_Activations::get_instance()
* @return GF_Pending_Activations
*/
function gf_pending_activations() {
return GF_Pending_Activations::get_instance();
}