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' ), 'birth_place' => SwpmUtils::_( 'Birth Place' ), ); } 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 ), 'subscription_starts' => array( 'subscription_starts', false ), 'account_state' => array( 'account_state', false ), 'last_accessed' => array( 'last_accessed', false ), 'birth_place' => array( 'birth_place', 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/View', $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(); $records_query_head = 'SELECT member_id,user_name,first_name,last_name,email,alias,subscription_starts,account_state,last_accessed,birth_place'; $count_query_head = 'SELECT COUNT(member_id)'; $query = ' '; $query .= ' 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' ); $status = esc_attr( $status );//Escape value $filters = array(); //Add the search parameter to the query if ( ! empty( $s ) ) { $s = sanitize_text_field( $s ); $s = trim( $s ); //Trim the input $s = esc_attr( $s ); $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 ) . "%' " . " OR birth_place 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->get_var( $count_query_head . $query ); //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( $records_query_head . $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'] = SwpmUtils::get_current_date_in_wp_zone();//date( 'Y-m-d' ); $member['subscription_starts'] = SwpmUtils::get_current_date_in_wp_zone();//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 ); $add_user_template_path = apply_filters('swpm_admin_registration_add_user_template_path', SIMPLE_WP_MEMBERSHIP_PATH . 'views/admin_add.php'); include_once $add_user_template_path; 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 ); $edit_user_template_path = apply_filters('swpm_admin_registration_edit_user_template_path', SIMPLE_WP_MEMBERSHIP_PATH . 'views/admin_edit.php'); include_once $edit_user_template_path; 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.' ); } self::delete_user_by_id( $record_id ); } echo '

Selected records deleted successfully!

'; return; } elseif ( 'bulk_active' === $current_action ) { $this->bulk_set_status( $members, 'active' ); } elseif ( 'bulk_active_notify' == $current_action ) { $this->bulk_set_status( $members, 'active', true ); } elseif ( 'bulk_inactive' == $current_action ) { $this->bulk_set_status( $members, 'inactive' ); } elseif ( 'bulk_pending' == $current_action ) { $this->bulk_set_status( $members, 'pending' ); } elseif ( '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' ); $headers = 'From: ' . $from_address . "\r\n"; foreach ($emails as $to_email) { //Send the activation email one by one to all the selected members. $subject = apply_filters( 'swpm_email_bulk_set_status_subject', $subject ); $body = apply_filters( 'swpm_email_bulk_set_status_body', $body ); $to_email = trim($to_email); SwpmMiscUtils::mail( $to_email, $subject, $body, $headers ); SwpmLog::log_simple_debug( 'Bulk activation email notification sent. Activation email sent to the following email: ' . $to_email, 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 ); self::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; self::delete_wp_user( $user_name ); //Deletes the WP User record self::delete_swpm_user_by_id( $id ); //Deletes the SWPM record } public static function delete_swpm_user_by_id( $id ) { self::delete_user_subs( $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; } } private static function delete_user_subs( $id ) { $member = SwpmMemberUtils::get_user_by_id( $id ); if ( ! $member ) { return false; } // let's check if Stripe subscription needs to be cancelled global $wpdb; $q = $wpdb->prepare( 'SELECT * FROM `' . $wpdb->prefix . 'swpm_payments_tbl` WHERE email = %s AND (gateway = "stripe" OR gateway = "stripe-sca-subs") AND subscr_id != ""', array( $member->email ) ); $res = $wpdb->get_results( $q, ARRAY_A ); if ( ! $res ) { return false; } foreach ( $res as $sub ) { if ( substr( $sub['subscr_id'], 0, 4 ) !== 'sub_' ) { //not Stripe subscription continue; } //let's find the payment button $q = $wpdb->prepare( "SELECT post_id FROM {$wpdb->prefix}postmeta WHERE meta_key='subscr_id' AND meta_value=%s", $sub['subscr_id'] ); $res_post = $wpdb->get_row( $q ); if ( ! $res_post ) { //no button found continue; } $button_id = get_post_meta( $res_post->post_id, 'payment_button_id', true ); $button = get_post( $button_id ); if ( ! $button ) { //no button found continue; } SwpmLog::log_simple_debug( 'Attempting to cancel Stripe Subscription ' . $sub['subscr_id'], true ); $is_live = get_post_meta( $button_id, 'is_live', true ); //API Keys $api_keys = SwpmMiscUtils::get_stripe_api_keys_from_payment_button( $button_id, $is_live ); //Include the Stripe library. SwpmMiscUtils::load_stripe_lib(); \Stripe\Stripe::setApiKey( $api_keys['secret'] ); $error = null; // Let's try to cancel subscription try { $sub = \Stripe\Subscription::retrieve( $sub['subscr_id'] ); $sub->cancel(); } catch ( Exception $e ) { SwpmLog::log_simple_debug( 'Error occurred during Stripe Subscription cancellation. ' . $e->getMessage(), false ); $body = $e->getJsonBody(); $error = $body['error']; $error_string = wp_json_encode( $error ); SwpmLog::log_simple_debug( 'Error details: ' . $error_string, false ); } if ( ! isset( $error ) ) { SwpmLog::log_simple_debug( 'Stripe Subscription has been cancelled.', true ); } } } 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; ?>

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 '
'; // } }