function lists()
{
global $wpdb;
// pager
$pager = new mgm_pager();
// data
$data = array();
// search fields
$data['search_fields'] = array('' => __('Select', 'mgm'), 'id' => __('ID', 'mgm'), 'title' => __('Title', 'mgm'), 'filename' => __('Filename', 'mgm'), 'post_date' => __('Posted', 'mgm'), 'expire_dt' => __('Expires', 'mgm'));
// sort fields
$data['sort_fields'] = array('id' => __('ID', 'mgm'), 'title' => __('Title', 'mgm'), 'post_date' => __('Posted', 'mgm'), 'expire_dt' => __('Expires', 'mgm'));
// filter
$sql_filter = $data['search_field_name'] = $data['search_field_value'] = '';
// 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
// view data
$data['search_field_name'] = $_POST['search_field_name'];
//issue #1281
$data['search_field_value'] = htmlentities($_POST['search_field_value'], ENT_QUOTES, "UTF-8");
// for display
// by field
switch ($search_field_name) {
case 'id':
$sql_filter = " AND `id` = '" . (int) $search_field_value . "'";
break;
case 'title':
$sql_filter = " AND `title` LIKE '%{$search_field_value}%'";
break;
case 'filename':
$sql_filter = " AND (`filename` LIKE '%{$search_field_value}%' OR `real_filename` LIKE '%{$search_field_value}%')";
break;
case 'post_date':
// convert
$search_field_value = mgm_format_inputdate_to_mysql($search_field_value);
// set filter
$sql_filter = " AND DATE_FORMAT(`post_date`,'%Y-%m-%d') = '{$search_field_value}'";
break;
case 'expire_dt':
// convert
$search_field_value = mgm_format_inputdate_to_mysql($search_field_value);
// set filter
$sql_filter = " AND DATE_FORMAT(`expire_dt`,'%Y-%m-%d') = '{$search_field_value}'";
break;
}
}
// default
$sort_field = 'post_date';
// type
$sort_type = 'DESC';
// sort field
if (isset($_POST['sort_field'])) {
$sort_field = $_POST['sort_field'];
}
// sort type
if (isset($_POST['sort_type'])) {
$sort_type = $_POST['sort_type'];
}
// set
$data['sort_field'] = $sort_field;
// set
$data['sort_type'] = $sort_type;
// set
$sql_order_by = "ORDER BY `{$sort_field}` {$sort_type}";
// page limit
$data['page_limit'] = isset($_REQUEST['page_limit']) ? (int) $_REQUEST['page_limit'] : 10;
// 10
// page no
$data['page_no'] = isset($_REQUEST['page_no']) ? (int) $_REQUEST['page_no'] : 1;
// limit
$sql_limit = $pager->get_query_limit($data['page_limit']);
//sql
$sql = "SELECT SQL_CALC_FOUND_ROWS * FROM `" . TBL_MGM_DOWNLOAD . "` WHERE 1 {$sql_filter} {$sql_order_by} {$sql_limit}";
// downloads
$data['downloads'] = $wpdb->get_results($sql);
// log
// mgm_log($wpdb->last_query, __FUNCTION__);
// page url
$data['page_url'] = 'admin-ajax.php?action=mgm_admin_ajax_action&page=mgm/admin/downloads&method=lists';
// 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();
// search term
$search_term = '';
// search provided
if (!empty($data['search_field_value'])) {
$search_term = sprintf('where <b>%s</b> is <b>%s</b>', isset($data['search_fields'][$search_field_name]) ? $data['search_fields'][$search_field_name] : '', $data['search_field_value']);
}
// message
$data['message'] = sprintf(__('%d %s matched %s', 'mgm'), $data['row_count'], $data['row_count'] > 1 ? __('downloads', 'mgm') : __('download', 'mgm'), $search_term);
// load view
$this->load->template('downloads/lists', array('data' => $data));
}
/**
* 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 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;
}
private function _members_check_rebill_status()
{
global $current_user, $wpdb;
// extract
extract($_POST);
// init
$message = __('Member rebill status check failed', 'mgm');
$status = 'error';
// check
if (isset($current_user->ID) && $current_user->ID != 0 && is_numeric($current_user->ID)) {
// users check
if (isset($members) && !empty($members)) {
// define
if (!defined('DOING_QUERY_REBILL_STATUS')) {
define('DOING_QUERY_REBILL_STATUS', 'manual');
}
// ctr
$updated = 0;
// loop users
foreach ($members as $uid) {
//delete user
$uid = mgm_escape($uid);
// check
if ((int) $uid > 0) {
// get user
$user = new WP_User($uid);
// check
if (isset($user->ID) && (int) $user->ID > 0) {
// member data
$member = mgm_get_member($user->ID);
// reset disabled, force recheck
$member->last_payment_check = '';
// check
if (apply_filters('mgm_module_rebill_status', $user->ID, $member)) {
// update
$updated++;
}
// update
mgm_update_payment_check_state($user->ID, 'manual');
}
// unset
unset($user, $member);
}
}
// message
$item = $updated > 1 ? 'members' : 'member';
// set
if (!$updated) {
$message = sprintf(__('Error while updating %s rebill status.', 'mgm'), $item);
} elseif ($updated && count($members) != $updated) {
$message = sprintf(__('Partially updated rebill status of %d %s .', 'mgm'), $updated, $item);
} else {
$message = sprintf(__('Successfully updated rebill status of %d %s.', 'mgm'), $updated, $item);
$status = 'success';
}
}
}
// return
return array('status' => $status, 'message' => $message);
}
