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