SwpmUtils::_('Member'), 'plural' => SwpmUtils::_('Members'), 'ajax' => false )); } function get_columns() { return array( 'cb' => '' , 'member_id' => SwpmUtils::_('ID') , 'user_name' => SwpmUtils::_('Username') , 'first_name' => SwpmUtils::_('First Name') , 'last_name' => SwpmUtils::_('Last Name') , 'email' => SwpmUtils::_('Email') , 'alias' => SwpmUtils::_('Membership Level') , 'subscription_starts' => SwpmUtils::_('Access Starts') , 'account_state' => SwpmUtils::_('Account State') , 'last_accessed' => SwpmUtils::_('Last Login Date') ); } function get_sortable_columns() { return array( 'member_id' => array('member_id', true), //True means already sorted 'user_name' => array('user_name', false), 'first_name' => array('first_name', false), 'last_name' => array('last_name', false), 'email' => array('email', false), 'alias' => array('alias', false), 'account_state' => array('account_state', false), 'last_accessed' => array('last_accessed', false), ); } function get_bulk_actions() { $actions = array( 'bulk_delete' => SwpmUtils::_('Delete'), 'bulk_active' => SwpmUtils::_('Set Status to Active'), 'bulk_active_notify' => SwpmUtils::_('Set Status to Active and Notify'), 'bulk_inactive' => SwpmUtils::_('Set Status to Inactive'), 'bulk_pending' => SwpmUtils::_('Set Status to Pending'), 'bulk_expired' => SwpmUtils::_('Set Status to Expired'), ); return $actions; } function column_default($item, $column_name) { return $item[$column_name]; } function column_account_state($item) { $acc_state_str = ucfirst($item['account_state']); return SwpmUtils::_($acc_state_str); } function column_member_id($item) { $delete_swpmuser_nonce = wp_create_nonce('delete_swpmuser_admin_end'); $actions = array( 'edit' => sprintf('Edit', $item['member_id']), 'delete' => sprintf('Delete', $item['member_id'], $delete_swpmuser_nonce), ); return $item['member_id'] . $this->row_actions($actions); } function column_user_name($item) { $user_name = $item['user_name']; if (empty($user_name)) { $user_name = '[' . SwpmUtils::_('incomplete') . ']'; } return $user_name; } function column_cb($item) { return sprintf( '', $item['member_id'] ); } function prepare_items() { global $wpdb; $this->process_bulk_action(); $query = "SELECT * FROM " . $wpdb->prefix . "swpm_members_tbl"; $query .= " LEFT JOIN " . $wpdb->prefix . "swpm_membership_tbl"; $query .= " ON ( membership_level = id ) "; //Get the search string (if any) $s = filter_input(INPUT_GET, 's'); if (empty($s)) { $s = filter_input(INPUT_POST, 's'); } $status = filter_input(INPUT_GET, 'status'); $filters = array(); //Add the search parameter to the query if (!empty($s)) { $s = sanitize_text_field($s); $s = trim($s); //Trim the input $filters[] = "( user_name LIKE '%" . strip_tags($s) . "%' " . " OR first_name LIKE '%" . strip_tags($s) . "%' " . " OR last_name LIKE '%" . strip_tags($s) . "%' " . " OR email LIKE '%" . strip_tags($s) . "%' " . " OR address_city LIKE '%" . strip_tags($s) . "%' " . " OR address_state LIKE '%" . strip_tags($s) . "%' " . " OR country LIKE '%" . strip_tags($s) . "%' " . " OR company_name LIKE '%" . strip_tags($s) . "%' )"; } //Add account status filtering to the query if (!empty($status)) { if ($status == 'incomplete') { $filters[] = "user_name = ''"; } else { $filters[] = "account_state = '" . $status . "'"; } } //Add membership level filtering $membership_level = filter_input(INPUT_GET, 'membership_level', FILTER_SANITIZE_NUMBER_INT); if (!empty($membership_level)) { $filters[] = sprintf("membership_level = '%d'", $membership_level); } //Build the WHERE clause of the query string if (!empty($filters)) { $filter_str = ''; foreach ($filters as $ind => $filter) { $filter_str .= $ind === 0 ? $filter : " AND " . $filter; } $query .= "WHERE " . $filter_str; } //Build the orderby and order query parameters $orderby = filter_input(INPUT_GET, 'orderby'); $orderby = empty($orderby) ? 'member_id' : $orderby; $order = filter_input(INPUT_GET, 'order'); $order = empty($order) ? 'DESC' : $order; $sortable_columns = $this->get_sortable_columns(); $orderby = SwpmUtils::sanitize_value_by_array($orderby, $sortable_columns); $order = SwpmUtils::sanitize_value_by_array($order, array('DESC' => '1', 'ASC' => '1')); $query .= ' ORDER BY ' . $orderby . ' ' . $order; //Execute the query $totalitems = $wpdb->query($query); //return the total number of affected rows //Pagination setup $perpage = apply_filters('swpm_members_menu_items_per_page', 50); $paged = filter_input(INPUT_GET, 'paged'); if (empty($paged) || !is_numeric($paged) || $paged <= 0) { $paged = 1; } $totalpages = ceil($totalitems / $perpage); if (!empty($paged) && !empty($perpage)) { $offset = ($paged - 1) * $perpage; $query .= ' LIMIT ' . (int) $offset . ',' . (int) $perpage; } $this->set_pagination_args(array( "total_items" => $totalitems, "total_pages" => $totalpages, "per_page" => $perpage, )); $columns = $this->get_columns(); $hidden = array(); $sortable = $this->get_sortable_columns(); $this->_column_headers = array($columns, $hidden, $sortable); $this->items = $wpdb->get_results($query, ARRAY_A); } function get_user_count_by_account_state() { global $wpdb; $query = "SELECT count(member_id) AS count, account_state FROM " . $wpdb->prefix . "swpm_members_tbl GROUP BY account_state"; $result = $wpdb->get_results($query, ARRAY_A); $count = array(); $all = 0; foreach ($result as $row) { $count[$row["account_state"]] = $row["count"]; $all += intval($row['count']); } $count ["all"] = $all; $count_incomplete_query = "SELECT COUNT(*) FROM " . $wpdb->prefix . "swpm_members_tbl WHERE user_name = ''"; $count['incomplete'] = $wpdb->get_var($count_incomplete_query); return $count; } function no_items() { _e('No member found.', 'simple-membership'); } function process_form_request() { if (isset($_REQUEST['member_id'])) { //This is a member profile edit action $record_id = sanitize_text_field($_REQUEST['member_id']); if (!is_numeric($record_id)) { wp_die('Error! ID must be numeric.'); } return $this->edit(absint($record_id)); } //This is an profile add action. return $this->add(); } function add() { $form = apply_filters('swpm_admin_registration_form_override', ''); if (!empty($form)) { echo $form; return; } global $wpdb; $member = SwpmTransfer::$default_fields; $member['member_since'] = date('Y-m-d'); $member['subscription_starts'] = date('Y-m-d'); if (isset($_POST['createswpmuser'])) { $member = array_map('sanitize_text_field', $_POST); } extract($member, EXTR_SKIP); $query = "SELECT * FROM " . $wpdb->prefix . "swpm_membership_tbl WHERE id !=1 "; $levels = $wpdb->get_results($query, ARRAY_A); include_once(SIMPLE_WP_MEMBERSHIP_PATH . 'views/admin_add.php'); return false; } function edit($id) { global $wpdb; $id = absint($id); $query = "SELECT * FROM {$wpdb->prefix}swpm_members_tbl WHERE member_id = $id"; $member = $wpdb->get_row($query, ARRAY_A); if (isset($_POST["editswpmuser"])) { $_POST['user_name'] = sanitize_text_field($member['user_name']); $_POST['email'] = sanitize_email($member['email']); foreach ($_POST as $key => $value) { $key = sanitize_text_field($key); if ($key == 'email') { $member[$key] = sanitize_email($value); } else { $member[$key] = sanitize_text_field($value); } } } extract($member, EXTR_SKIP); $query = "SELECT * FROM " . $wpdb->prefix . "swpm_membership_tbl WHERE id !=1 "; $levels = $wpdb->get_results($query, ARRAY_A); include_once(SIMPLE_WP_MEMBERSHIP_PATH . 'views/admin_edit.php'); return false; } function process_bulk_action() { //Detect when a bulk action is being triggered... then perform the action. $members = isset($_REQUEST['members']) ? $_REQUEST['members'] : array(); $members = array_map('sanitize_text_field', $members); $current_action = $this->current_action(); if (!empty($current_action)) { //Bulk operation action. Lets make sure multiple records were selected before going ahead. if (empty($members)) { echo '

Error! You need to select multiple records to perform a bulk action!

'; return; } } else { //No bulk operation. return; } //perform the bulk operation according to the selection if ('bulk_delete' === $current_action) { foreach ($members as $record_id) { if (!is_numeric($record_id)) { wp_die('Error! ID must be numeric.'); } SwpmMembers::delete_user_by_id($record_id); } echo '

Selected records deleted successfully!

'; return; } else if ('bulk_active' === $current_action) { $this->bulk_set_status($members, 'active'); } else if ('bulk_active_notify' == $current_action) { $this->bulk_set_status($members, 'active', true); } else if ('bulk_inactive' == $current_action) { $this->bulk_set_status($members, 'inactive'); } else if ('bulk_pending' == $current_action) { $this->bulk_set_status($members, 'pending'); } else if ('bulk_expired' == $current_action) { $this->bulk_set_status($members, 'expired'); } echo '

Bulk operation completed successfully!

'; } function bulk_set_status($members, $status, $notify = false) { $ids = implode(',', array_map('absint', $members)); if (empty($ids)) { return; } global $wpdb; $query = "UPDATE " . $wpdb->prefix . "swpm_members_tbl " . " SET account_state = '" . $status . "' WHERE member_id in (" . $ids . ")"; $wpdb->query($query); if ($notify) { $settings = SwpmSettings::get_instance(); $emails = $wpdb->get_col("SELECT email FROM " . $wpdb->prefix . "swpm_members_tbl " . " WHERE member_id IN ( $ids ) "); $subject = $settings->get_value('bulk-activate-notify-mail-subject'); if (empty($subject)) { $subject = "Account Activated!"; } $body = $settings->get_value('bulk-activate-notify-mail-body'); if (empty($body)) { $body = "Hi, Your account has been activated successfully!"; } $from_address = $settings->get_value('email-from'); $to_email_list = implode(',', $emails); $headers = 'From: ' . $from_address . "\r\n"; $headers .= 'bcc: ' . $to_email_list . "\r\n"; $subject = apply_filters('swpm_email_bulk_set_status_subject', $subject); $body = apply_filters('swpm_email_bulk_set_status_body', $body); wp_mail(array()/* $email_list */, $subject, $body, $headers); SwpmLog::log_simple_debug("Bulk activation email notification sent. Activation email sent to the following email: " . $to_email_list, true); } } function delete() { if (isset($_REQUEST['member_id'])) { //Check we are on the admin end and user has management permission SwpmMiscUtils::check_user_permission_and_is_admin('member deletion by admin'); //Check nonce if (!isset($_REQUEST['delete_swpmuser_nonce']) || !wp_verify_nonce($_REQUEST['delete_swpmuser_nonce'], 'delete_swpmuser_admin_end')) { //Nonce check failed. wp_die(SwpmUtils::_("Error! Nonce verification failed for user delete from admin end.")); } $id = sanitize_text_field($_REQUEST['member_id']); $id = absint($id); SwpmMembers::delete_user_by_id($id); } } public static function delete_user_by_id($id) { if (!is_numeric($id)) { wp_die('Error! Member ID must be numeric.'); } $swpm_user = SwpmMemberUtils::get_user_by_id($id); $user_name = $swpm_user->user_name; SwpmMembers::delete_wp_user($user_name); //Deletes the WP User record SwpmMembers::delete_swpm_user_by_id($id); //Deletes the SWPM record } public static function delete_swpm_user_by_id($id) { global $wpdb; $query = "DELETE FROM " . $wpdb->prefix . "swpm_members_tbl WHERE member_id = $id"; $wpdb->query($query); } public static function delete_wp_user($user_name) { $wp_user_id = username_exists($user_name); if (empty($wp_user_id) || !is_numeric($wp_user_id)) { return; } if (!self::is_wp_super_user($wp_user_id)) { //Not an admin user so it is safe to delete this user. include_once(ABSPATH . 'wp-admin/includes/user.php'); wp_delete_user($wp_user_id, 1); //assigns all related to this user to admin. } else { //This is an admin user. So not going to delete the WP User record. SwpmTransfer::get_instance()->set('status', 'For safety, we do not allow deletion of any associated wordpress account with administrator role.'); return; } } public static function is_wp_super_user($wp_user_id) { $user_data = get_userdata($wp_user_id); if (empty($user_data)) { //Not an admin user if we can't find his data for the given ID. return false; } if (isset($user_data->wp_capabilities['administrator'])) {//Check capability //admin user return true; } if ($user_data->wp_user_level == 10) {//Check for old style wp user level //admin user return true; } //This is not an admin user return false; } function bulk_operation_menu() { echo '
'; if (isset($_REQUEST['swpm_bulk_change_level_process'])) { //Check nonce $swpm_bulk_change_level_nonce = filter_input(INPUT_POST, 'swpm_bulk_change_level_nonce'); if (!wp_verify_nonce($swpm_bulk_change_level_nonce, 'swpm_bulk_change_level_nonce_action')) { //Nonce check failed. wp_die(SwpmUtils::_("Error! Nonce security verification failed for Bulk Change Membership Level action. Clear cache and try again.")); } $errorMsg = ""; $from_level_id = sanitize_text_field($_REQUEST["swpm_bulk_change_level_from"]); $to_level_id = sanitize_text_field($_REQUEST['swpm_bulk_change_level_to']); if ($from_level_id == 'please_select' || $to_level_id == 'please_select') { $errorMsg = SwpmUtils::_('Error! Please select a membership level first.'); } if (empty($errorMsg)) {//No validation errors so go ahead $member_records = SwpmMemberUtils::get_all_members_of_a_level($from_level_id); if ($member_records) { foreach ($member_records as $row) { $member_id = $row->member_id; SwpmMemberUtils::update_membership_level($member_id, $to_level_id); } } } $message = ""; if (!empty($errorMsg)) { $message = $errorMsg; } else { $message = SwpmUtils::_('Membership level change operation completed successfully.'); } echo '

'; echo $message; echo '

'; } if (isset($_REQUEST['swpm_bulk_user_start_date_change_process'])) { //Check nonce $swpm_bulk_start_date_nonce = filter_input(INPUT_POST, 'swpm_bulk_start_date_nonce'); if (!wp_verify_nonce($swpm_bulk_start_date_nonce, 'swpm_bulk_start_date_nonce_action')) { //Nonce check failed. wp_die(SwpmUtils::_("Error! Nonce security verification failed for Bulk Change Access Starts Date action. Clear cache and try again.")); } $errorMsg = ""; $level_id = sanitize_text_field($_REQUEST["swpm_bulk_user_start_date_change_level"]); $new_date = sanitize_text_field($_REQUEST['swpm_bulk_user_start_date_change_date']); if ($level_id == 'please_select') { $errorMsg = SwpmUtils::_('Error! Please select a membership level first.'); } if (empty($errorMsg)) {//No validation errors so go ahead $member_records = SwpmMemberUtils::get_all_members_of_a_level($level_id); if ($member_records) { foreach ($member_records as $row) { $member_id = $row->member_id; SwpmMemberUtils::update_access_starts_date($member_id, $new_date); } } } $message = ""; if (!empty($errorMsg)) { $message = $errorMsg; } else { $message = SwpmUtils::_('Access starts date change operation successfully completed.'); } echo '

'; echo $message; echo '

'; } ?>

Access Starts Date: " />

'; // } function show_all_members() { ob_start(); $status = filter_input(INPUT_GET, 'status'); include_once(SIMPLE_WP_MEMBERSHIP_PATH . 'views/admin_members_list.php'); $output = ob_get_clean(); return $output; } function handle_main_members_admin_menu() { do_action('swpm_members_menu_start'); //Check current_user_can() or die. SwpmMiscUtils::check_user_permission_and_is_admin('Main Members Admin Menu'); $action = filter_input(INPUT_GET, 'member_action'); $action = empty($action) ? filter_input(INPUT_POST, 'action') : $action; $selected = $action; ?>

" href="admin.php?page=simple_wp_membership"> " href="admin.php?page=simple_wp_membership&member_action=add"> " href="admin.php?page=simple_wp_membership&member_action=bulk"> Edit Member'; } //Trigger hooks that allows an extension to add extra nav tabs in the members menu. do_action('swpm_members_menu_nav_tabs', $selected); $menu_tabs = apply_filters('swpm_members_additional_menu_tabs_array', array()); foreach ($menu_tabs as $member_action => $title) { ?>

'; // return; } //Switch case for the various different actions handled by the core plugin. switch ($action) { case 'members_list': //Show the members listing echo $this->show_all_members(); break; case 'add': //Process member profile add $this->process_form_request(); break; case 'edit': //Process member profile edit $this->process_form_request(); break; case 'bulk': //Handle the bulk operation menu $this->bulk_operation_menu(); break; default: //Show the members listing page by default. echo $this->show_all_members(); break; } echo '
'; // } }