/** * get members by membership type * * @param none * @return members * @verb GET * @action list * @url <site>/mgmapi/membership_types/:membership_type/members.<format> * @since 1.0 */ public function members_get($code = NULL) { // init $status = 'success'; $total_rows = 0; $membership_types = array(); // loop if ($types = mgm_get_all_membership_type()) { // loop foreach ($types as $type) { // code check if ($code) { if ($code != $type['code']) { continue; } } // name $name = mgm_stripslashes_deep($type['name']); $members = mgm_get_members_with('membership_type', $type['code'], NULL, 'count'); // set $membership_types[] = array('code' => $type['code'], 'name' => $name, 'members' => $members); } // total $total_rows = count($membership_types); } // base $data = array('total_rows' => $total_rows); // data if (!empty($code)) { // message $message = sprintf(__('Get members by membership type - %s response', 'mgm'), $code, count($membership_types)); // data if ($total_rows > 0) { $data = $data + array('membership_type' => array_shift($membership_types)); } } else { // message $message = sprintf(__('Get members by membership types response - %d membership type(s) found', 'mgm'), $total_rows); // data if ($total_rows > 0) { $data = $data + array('membership_types' => $membership_types); } } // response $response = array('status' => $status, 'message' => $message, 'data' => $data); // return return array($response, 200); }
function payment_history_export() { global $wpdb; // data $data = array(); // filter $sql_filter = $payment_type = ''; // check if (isset($_POST['search_field_name'])) { // issue#: 219 $search_field_name = $_POST['search_field_name']; // for sql $search_field_value = mgm_escape($_POST['search_field_value']); // for sql $search_field_value = trim($search_field_value); // by field switch ($search_field_name) { case 'username': // issue#: 347(LIKE SEARCH) $sql_filter = " AND user.user_login LIKE '%{$search_field_value}%'"; break; case 'id': $sql_filter = " AND user.ID = '" . (int) $search_field_value . "'"; break; case 'email': // issue#: 347(LIKE SEARCH) $sql_filter = " AND user.user_email LIKE '%{$search_field_value}%'"; break; case 'membership_type': // members $members = mgm_get_members_with('membership_type', $search_field_value); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND user.ID IN ({$members_in})"; break; case 'payment_type': $payment_type = $search_field_value; break; case 'first_name': case 'last_name': // members $members = mgm_get_members_with($search_field_name, $search_field_value); //check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND user.ID IN ({$members_in})"; break; } } if (!empty($payment_type)) { $con = " AND transaction.payment_type = '" . $payment_type . "' "; } else { $con = ''; } //payment success check $pay_succ = " AND transaction.status_text = 'Last payment was successful'"; $transaction_sql = "SELECT SQL_CALC_FOUND_ROWS * FROM " . TBL_MGM_TRANSACTION . " transaction LEFT JOIN {$wpdb->users} user ON transaction.user_id = user.ID "; $transaction_sql .= "WHERE transaction.module IS NOT NULL"; $transaction_sql .= $pay_succ; $transaction_sql .= $con; $transaction_sql .= $sql_filter; $transaction_sql .= " ORDER BY transaction.transaction_dt DESC {$sql_limit}"; $data['transactions'] = $wpdb->get_results($transaction_sql); $export_transactions = array(); if (count($data['transactions']) > 0) { foreach ($data['transactions'] as $tran_log) { $json_decoded = json_decode($tran_log->data); $user_obj = get_userdata($json_decoded->user_id); //empty obj $row = new stdClass(); if (!empty($user_obj)) { //export fields $row->id = $user_obj->ID; $row->username = $user_obj->user_login; $row->firstname = $user_obj->first_name; $row->lastname = $user_obj->last_name; $row->email = $user_obj->user_email; $row->payment_type = ucwords(str_replace('_', ' ', $tran_log->payment_type)); $row->module = ucwords($tran_log->module); $row->amount = $json_decoded->trial_on ? $json_decoded->trial_cost : $json_decoded->cost; $row->transaction_date = date(MGM_DATE_FORMAT_SHORT, strtotime($tran_log->transaction_dt)); } // cache $export_transactions[] = $row; // unset unset($row); } } // message $message = __('Error while exporting transactions. Could not find any transaction with requested search parameters.', 'mgm'); // default response $response = array('status' => 'error', 'message' => $message); // check if (count($export_transactions) > 0) { // success $success = count($export_transactions); // create if (mgm_post_var('export_format') == 'csv') { $filename = mgm_create_csv_file($export_transactions, 'export_transactions'); } else { $filename = mgm_create_xls_file($export_transactions, 'export_transactions'); } // src $file_src = MGM_FILES_EXPORT_URL . $filename; // message $response['message'] = sprintf(__('Successfully exported %d %s.', 'mgm'), $success, $success > 1 ? 'transactions' : 'transaction'); $response['status'] = 'success'; $response['src'] = $file_src; } // return response echo json_encode($response); exit; }
/** * get subscription packages * * @param int optional subscription id * @return subscription packages * @verb GET * @action list * @url <site>/mgmapi/subscription_packages.<format> * @url <site>/mgmapi/subscription_packages/:id.<format> * @since 1.0 */ public function members_get($id = NULL) { global $wpdb; // init $subscription_packages = array(); $total_rows = 0; $status = 'success'; // loop if ($packs = mgm_get_all_subscription_package()) { // loop foreach ($packs as $pack) { // id flter if ($id) { if ($id != $pack['id']) { continue; } } // membership type $membership_type = $pack['membership_type']; // description $description = mgm_stripslashes_deep($pack['description']); $members = mgm_get_members_with('membership_type', $pack['membership_type'], array('pack_id' => $pack['id']), 'count'); // set $subscription_packages[] = array('id' => $pack['id'], 'membership_type' => $membership_type, 'description' => $description, 'members' => $members); } // total $total_rows = count($subscription_packages); } // base $data = array('total_rows' => $total_rows); // data if ((int) $id > 0) { // message $message = sprintf(__('Get members of subscription package by id#%d response', 'mgm'), $id); // data if ($total_rows > 0) { $data = $data + array('subscription_packages' => array_shift($subscription_packages)); } } else { // message $message = sprintf(__('Get members of subscription packages response - %d subscription package(s) found', 'mgm'), $total_rows); // data if ($total_rows > 0) { $data = $data + array('subscription_packages' => $subscription_packages); } } // response $response = array('status' => 'success', 'message' => $message, 'data' => $data); // return return array($response, 200); }
/** * get count by pack */ function mgm_get_subscription_package_users_count($packages) { // init $_count = array(); // loop foreach ($packages as $package) { // with $u = mgm_get_members_with('membership_type', $package['membership_type'], array('pack_id' => $package['id'])); // count $_count[$package['id']] = count($u); } // return return $_count; }
/** * generate members list - short code content */ function mgm_generate_member_list($args = array()) { global $wpdb, $post; //issue #1327 $show_level = isset($args['show_level']) ? $args['show_level'] : null; $show_level_members = array(); if (!empty($show_level) && $show_level != null) { $show_level = explode(',', $show_level); $show_level_count = count($show_level); for ($i = 0; $i < $show_level_count; $i++) { $level_match_members = mgm_get_members_with('membership_type', $show_level[$i]); if (!empty($level_match_members)) { $show_level_members = array_merge($show_level_members, $level_match_members); } } if (!empty($show_level_members)) { $show_level_members = array_unique($show_level_members); } } // current url $current_url = get_permalink($post->ID); // append ? why? // if( !strpos($current_url,'?') !== false) $current_url = ($current_url . '?'); // echo $current_url; // init pager $pager = new mgm_pager(); // init data $data = $custom_search_fields = $custom_sort_fields = $custom_user_list = $user_list = array(); // css group $css_group = mgm_get_css_group(); // html $html = ''; // check if ($css_group != 'none') { // expand this if needed $css_link_format = '<link rel="stylesheet" href="%s" type="text/css" media="all" />'; $css_file = MGM_ASSETS_URL . 'css/' . $css_group . '/mgm.pages.css'; $html .= sprintf($css_link_format, $css_file); } // search fields $data['search_fields'] = array('' => __('Select', 'mgm'), 'username' => __('Username', 'mgm'), 'id' => __('User ID', 'mgm'), 'email' => __('User Email', 'mgm'), 'first_name' => __('First Name', 'mgm'), 'last_name' => __('Last Name', 'mgm'), 'membership_type' => __('Membership Type', 'mgm'), 'reg_date' => __('Registration Date', 'mgm'), 'last_payment' => __('Last Payment', 'mgm'), 'expire_date' => __('Expiration Date', 'mgm'), 'fee' => __('Fee', 'mgm'), 'status' => __('Status', 'mgm')); // sort fields $data['sort_fields'] = array('id' => __('User ID', 'mgm'), 'username' => __('Username', 'mgm'), 'email' => __('User Email', 'mgm'), 'reg_date' => __('Registration Date', 'mgm')); // order fields $data['order_fields'] = array('desc' => __('DESC', 'mgm'), 'asc' => __('ASC', 'mgm')); // custom_fields $custom_fields = mgm_get_class('member_custom_fields'); // getting custom fileds and skip the search fields if allready exists. foreach ($custom_fields->custom_fields as $custom_field) { if (!array_key_exists($custom_field['name'], $data['search_fields'])) { $custom_search_fields[$custom_field['name']] = $custom_field['label']; } } // getting custom fileds and skip the sort fields if allready exists. foreach ($custom_fields->custom_fields as $custom_field) { if (!array_key_exists($custom_field['name'], $data['sort_fields'])) { if ($custom_field['name'] != 'status') { $custom_sort_fields[$custom_field['name']] = $custom_field['label']; } } } // filter $sql_filter = $data['search_field_name'] = $data['search_field_value'] = ''; // field value if (isset($_REQUEST['query'])) { $search_field_value = $_REQUEST['query']; } else { $search_field_value = ''; } // field name if (isset($_REQUEST['by'])) { $search_field_name = $_REQUEST['by']; } else { $search_field_name = ''; } // sort field if (isset($_REQUEST['sort_field'])) { $sort_field_name = $_REQUEST['sort_field']; } else { $sort_field_name = ''; } // sort order type //order_type if (isset($_REQUEST['sort_order'])) { $sort_order_type = $_REQUEST['sort_order']; } else { $sort_order_type = ''; } // members $active_members = mgm_get_members_with('status', MGM_STATUS_ACTIVE); // wrongly called,use constant // check if (!empty($search_field_name)) { // clean $search_field_value = mgm_escape($search_field_value); // for sql $search_field_name = mgm_escape($search_field_name); // for sql // view data $data['search_field_name'] = $search_field_name; $data['search_field_value'] = trim($search_field_value); // current date $curr_date = mgm_get_current_datetime(); $current_date = $curr_date['timestamp']; // check if (array_key_exists($search_field_name, $custom_search_fields)) { // members $members = mgm_get_members_with_customfiled($search_field_name, $search_field_value); //issue #1327 if (!empty($show_level_members)) { $members = array_intersect($show_level_members, $members); } //check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; } else { // by field switch ($search_field_name) { case 'username': // issue#: 347(LIKE SEARCH) $filter = " AND `user_login` LIKE '%{$search_field_value}%'"; // matched $matched_members = mgm_get_members_with_sql_filter($filter); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'id': // filter $filter = " AND `ID` = '" . (int) $search_field_value . "'"; // match $matched_members = mgm_get_members_with_sql_filter($filter); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'email': // issue#: 347(LIKE SEARCH) $filter = " AND `user_email` LIKE '%{$search_field_value}%'"; // match $matched_members = mgm_get_members_with_sql_filter($filter); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'membership_type': // match $matched_members = mgm_get_members_with('membership_type', $search_field_value); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'reg_date': // check if (empty($search_field_value)) { $search_field_value = date('Y-m-d', $current_date); } // convert $search_field_value = mgm_format_inputdate_to_mysql($search_field_value); // set filter $filter = " AND DATE_FORMAT(`user_registered`,'%Y-%m-%d') = '{$search_field_value}'"; // match $matched_members = mgm_get_members_with_sql_filter($filter); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'last_payment': // check if (empty($search_field_value)) { $search_field_value = date('Y-m-d', $current_date); } // convert $search_field_value = mgm_format_inputdate_to_mysql($search_field_value); // match $matched_members = mgm_get_members_with('last_pay_date', $search_field_value); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'expire_date': // check if (empty($search_field_value)) { $search_field_value = date('Y-m-d', $current_date); } // convert $search_field_value = mgm_format_inputdate_to_mysql($search_field_value); // match $matched_members = mgm_get_members_with('expire_date', $search_field_value); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; case 'fee': // match $matched_members = mgm_get_members_with('amount', $search_field_value); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; /* case 'status': // members $members = mgm_get_members_with('status', $search_field_value); // check $members_in = (count($members)==0) ? 0 : (implode(',', $members)); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; */ /* case 'status': // members $members = mgm_get_members_with('status', $search_field_value); // check $members_in = (count($members)==0) ? 0 : (implode(',', $members)); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; */ case 'first_name': case 'last_name': // members $matched_members = mgm_get_members_with($search_field_name, $search_field_value); //issue #1327 if (!empty($show_level_members)) { $matched_members = array_intersect($show_level_members, $matched_members); } // common $members = array_intersect($active_members, $matched_members); // check $members_in = count($members) == 0 ? 0 : implode(',', $members); // set filter $sql_filter = " AND `ID` IN ({$members_in})"; break; } } } // filters via shortcode args $use_field = isset($args['use_field']) ? $args['use_field'] : null; $use_filter = isset($args['use_filter']) ? $args['use_filter'] : ''; $sort_by = isset($args['sort_by']) ? $args['sort_by'] : null; $sort_type = isset($args['sort_type']) ? $args['sort_type'] : null; // use shortcode field if (!empty($use_field)) { $use_field = explode(',', $use_field); } // use shortcode flter if (!empty($use_filter)) { $use_filter = explode(',', $use_filter); } // use shortcode sort if (!empty($sort_by)) { $sort_by = explode(',', $sort_by); } // use shortcode sort order if (!empty($sort_type)) { $sort_type = explode(',', $sort_type); } //setting up the default list fiedls if (empty($use_field)) { $use_field = array('image', 'first_name', 'last_name', 'email'); } // check length $use_field_len = count($use_field); //getting user fillter options from short code. $arr_filter_search = array(); if (!empty($use_filter)) { $use_filter_len = count($use_filter); for ($k = 0; $k < $use_filter_len; $k++) { if (array_key_exists($use_filter[$k], $data['search_fields'])) { $arr_filter_search[$use_filter[$k]] = $data['search_fields'][$use_filter[$k]]; } elseif (array_key_exists($use_filter[$k], $custom_search_fields)) { $arr_filter_search[$use_filter[$k]] = $custom_search_fields[$use_filter[$k]]; } } $data['search_fields'] = $arr_filter_search; } //getting sort by options from short code. $arr_sort_search = array(); if (!empty($sort_by)) { $use_sort_len = count($sort_by); for ($k = 0; $k < $use_sort_len; $k++) { if (array_key_exists($sort_by[$k], $data['sort_fields'])) { $arr_sort_search[$sort_by[$k]] = $data['sort_fields'][$sort_by[$k]]; } elseif (array_key_exists($sort_by[$k], $custom_sort_fields)) { $arr_sort_search[$sort_by[$k]] = $custom_sort_fields[$sort_by[$k]]; } } $data['sort_fields'] = $arr_sort_search; } //getting sort type options from short code. $arr_sort_type = array(); if (!empty($sort_type)) { $use_sort_type_len = count($sort_by); for ($k = 0; $k < $use_sort_type_len; $k++) { if (array_key_exists($sort_type[$k], $data['order_fields'])) { $arr_sort_type[$sort_type[$k]] = $data['order_fields'][$sort_type[$k]]; } } $data['order_fields'] = $arr_sort_type; } //issue #1301 //setting default sort order field as sort fields first value if (empty($sort_field_name)) { $sort_field_name = array_shift(array_keys($data['sort_fields'])); } //setting default sort order type as sort order fields first value if (empty($sort_order_type)) { $sort_order_type = array_shift(array_keys($data['order_fields'])); } //setting page limit $page_limit = isset($args['page_limit']) ? (int) $args['page_limit'] : 20; // page limit $data['page_limit'] = isset($_REQUEST['page_limit']) ? (int) $_REQUEST['page_limit'] : $page_limit; // page no $data['page_no'] = isset($_REQUEST['page_no']) ? (int) $_REQUEST['page_no'] : 1; // limit $sql_limit = $pager->get_query_limit($data['page_limit']); // order $sql_order = $data['sort_field'] = $data['sort_type'] = ''; // sort $sort_field_name = mgm_escape($sort_field_name); // for sql $sort_order_type = mgm_escape($sort_order_type); // for sql // check if (isset($sort_field_name)) { // set $data['sort_field'] = $sort_field_name; $data['sort_type'] = $sort_order_type; // init $custom_sort = false; // check if (array_key_exists($sort_field_name, $custom_sort_fields)) { $show_level_member = array_intersect($active_members, $show_level_members); // members $sql_order_by = mgm_userlist_customfield_sort($sort_field_name, $sort_order_type, $sql_filter, $show_level_member); // limit $lim = str_replace('LIMIT', '', $sql_limit); $lim = explode(',', $lim); // init $temp_array = array(); // loop for ($i = trim($lim[0]); $i < $lim[0] + $lim[1]; $i++) { if (!empty($sql_order_by[$i])) { $temp_array[] = $sql_order_by[$i]; } } //check for active members //$temp_array = array_intersect ($active_members,$temp_array); $in_order = count($temp_array) == 0 ? 0 : implode(',', $temp_array); // order //$in_order = implode(',',$temp_array); if (!empty($temp_array)) { // set $sql_order = " ORDER BY FIELD( ID, {$in_order} ) "; } else { $sql_order = ''; } // sql $sql = "SELECT * FROM `{$wpdb->users}` WHERE ID != 1 AND `ID` IN ({$in_order}) {$sql_order}"; // list $custom_user_list = $wpdb->get_results($sql); // flag $custom_sort = true; } else { // by name switch ($sort_field_name) { case 'username': $sql_order_by = "user_login"; break; case 'id': $sql_order_by = "ID"; break; case 'email': $sql_order_by = "user_email"; break; case 'membership_type': break; case 'reg_date': $sql_order_by = "user_registered"; break; } // set if (isset($sql_order_by)) { $sql_order = " ORDER BY {$sql_order_by} {$sort_order_type}"; } } } // default if (!isset($sql_order_by)) { $sql_order = " ORDER BY ID desc"; } //default active members ids if (empty($sql_filter)) { //issue #1327 if (!empty($show_level_members)) { // common $members = array_intersect($active_members, $show_level_members); $members_in = count($members) == 0 ? 0 : implode(',', $members); } else { $members_in = count($active_members) == 0 ? 0 : implode(',', $active_members); } // set filter $sql_filter = " AND `ID` IN ({$members_in})"; } // get members $sql = "SELECT SQL_CALC_FOUND_ROWS * FROM `{$wpdb->users}` WHERE ID != 1 {$sql_filter} {$sql_order} {$sql_limit}"; // users $user_list = $wpdb->get_results($sql); // echo $wpdb->last_query; // set if ($custom_sort) { $data['users'] = $custom_user_list; } else { $data['users'] = $user_list; } // page url $data['page_url'] = add_query_arg(array('query' => $search_field_value, 'by' => $search_field_name, 'sort_field' => $sort_field_name, 'sort_order' => $sort_order_type), $current_url); //$url.'query='.$search_field_value.'&by='.$search_field_name.'&sort_field='.$sort_field_name.'&order_type='.$order_type; // get page links $data['page_links'] = $pager->get_pager_links($data['page_url']); // total pages $data['page_count'] = $pager->get_page_count(); // total rows/results $data['row_count'] = $pager->get_row_count(); //sort by filed $sort_field_html = sprintf('<select id="sort_field" name="sort_field" class="width100px">%s</select>', mgm_make_combo_options($data['sort_fields'], $data['sort_field'], MGM_KEY_VALUE)); //order by asc/desc $sort_order_html = sprintf('<select id="sort_order" name="sort_order" class="width100px">%s</select>', mgm_make_combo_options($data['order_fields'], $data['sort_type'], MGM_KEY_VALUE)); //search by $search_by_html = sprintf('<select id="by" name="by" class="width100px">%s</select>', mgm_make_combo_options($data['search_fields'], $data['search_field_name'], MGM_KEY_VALUE)); //search box $html = '<div> <form method="get" action="' . $current_url . '"> <h5>' . __('Search Our Members', 'mgm') . ':</h5> <input type="text" id="query" name="query" value="' . $data['search_field_value'] . '" /> ' . __('in', 'mgm') . ' ' . $search_by_html . ' ' . __('sort by', 'mgm') . ' ' . $sort_field_html . ' ' . $sort_order_html . ' <input class="button" type="submit" id="submit" value="' . __('Submit', 'mgm') . '" /> <input type="hidden" name="search" id="search" value="search" /> </form> </div>'; $html .= '<div><table><tr>'; for ($i = 0; $i < $use_field_len; $i++) { $html .= sprintf('<th class="th_div mgm_text_align_left mgm_column_%s" id="mgm_column_%s"><label><b>%s</b></label></th>', $use_field[$i], $use_field[$i], ucwords(str_replace('_', ' ', $use_field[$i]))); } $html .= '</tr>'; $enable_public_profile = mgm_get_class('system')->get_setting('enable_public_profile'); if (!empty($data['users'])) { foreach ($data['users'] as $user) { // user object $user = get_userdata($user->ID); // mgm member object $member = mgm_get_member($user->ID); $html .= '<tr>'; for ($i = 0; $i < $use_field_len; $i++) { $app_user_filed = 'user_' . $use_field[$i]; if (isset($member->custom_fields->{$use_field}[$i]) || isset($user->{$use_field}[$i]) || isset($user->{$app_user_filed}) || $use_field[$i] == 'image') { if ($use_field[$i] == 'image') { //is_multisite,network_home_url $html .= sprintf('<td align="left" valign="top" class="mgm_%s_value">', $use_field[$i]); if (bool_from_yn($enable_public_profile)) { //$profile_url = add_query_arg(array('username'=>$user->user_login), site_url('userprofile')); $profile_url = network_site_url() . '/userprofile/?username='******'<a class="tern_wp_member_gravatar" href="%s">%s</a>', $profile_url, get_avatar($user->ID, 60)); } else { $html .= sprintf('<a href="javascript://">%s</a>', get_avatar($user->ID, 60)); } $html .= '</td>'; } else { //getting data from user object if (isset($user->{$use_field}[$i])) { $member->custom_fields->{$use_field}[$i] = $user->{$use_field}[$i]; } //getting data from user object if ($use_field[$i] == 'email') { $member->custom_fields->{$use_field}[$i] = $user->{$app_user_filed}; } // val unserialize $val = maybe_unserialize($member->custom_fields->{$use_field}[$i]); // array to string if (is_array($val)) { $val = implode(', ', $val); } // set $html .= sprintf('<td align="left" valign="top" class="mgm_%s_value"><b>%s</b></td>', $use_field[$i], $val); } } } $html .= '</tr>'; } } else { $html .= '<tr><td colspan="' . $use_field_len . '" align="center">' . __('No members found', 'mgm') . ' ...! </td></tr>'; } $html .= '</table></div><br/>'; $html .= '<div class="mgm_page_links_div">'; if ($data['page_links']) { $html .= '<div class="pager-wrap">' . $data['page_links'] . '</div><div class="clearfix"></div>'; } $html .= '</div><br/>'; //issue #1635 $users_list_html = '<div class="mgm_user_list_container">' . $html . '</div>'; return $users_list_html; }
function subscription_package_delete() { // extract extract($_POST); // get object $obj_sp = mgm_get_class('subscription_packs'); // empty $packs = array(); // flag $deleted = false; //pack associated active users count $pack_active_users_count = mgm_get_members_with('pack_id', $id, array('status' => MGM_STATUS_ACTIVE), 'count'); //check if ($pack_active_users_count == 0) { // loop foreach ($obj_sp->packs as $i => $pack) { // match if (isset($pack['id'])) { // new version 2.0 branch if ($pack['id'] == $id) { $deleted = true; continue; } } else { // old 1.0 branch without pack_id if ($i == $index) { $deleted = true; continue; } } // filter $packs[] = $pack; } } // update only when deleted if ($deleted) { // set $obj_sp->set_packs($packs); // update $obj_sp->save(); // message $message = sprintf(__('Successfully deleted subscription package #%d.', 'mgm'), $id); $status = 'success'; } else { if ($pack_active_users_count > 0) { $message = sprintf(__('There are active users and pack can not be deleted.', 'mgm'), $id); $status = 'error'; } else { $message = sprintf(__('Error while removing subscription package #%d. The package not found.', 'mgm'), $id); $status = 'error'; } } // return response echo json_encode(array('status' => $status, 'message' => $message)); exit; }