ecshop后台会员列表中是没有会员等级的,有客户认为这样不太直观。下面我来给大家整理一下在会员列表中显示会员等级。
默认ecshop会员列表
1.打开admin/templates/users_list.htm文件
查找
{$lang.pay_points}在下面添加
{$lang.user_rank}查找
{$user.pay_points}在下方添加
{$user.rank_name}2.打开admin/users.php文件
查找$sql = "SELECT user_id, user_name, email, is_validated, user_money, frozen_money, rank_points, pay_points, reg_time ".
" FROM " . $GLOBALS['ecs']->table('users') . $ex_where .
" ORDER by " . $filter['sort_by'] . ' ' . $filter['sort_order'] .
" LIMIT " . $filter['start'] . ',' . $filter['page_size'];
修改为以下代码$sql= "SELECT user_id, user_name, email, is_validated, user_money, frozen_money, rank_points, pay_points, reg_time ,user_rank,r.rank_name as rank_name".
" FROM " . $GLOBALS['ecs']->table('users') ." as u "." left join ".$GLOBALS['ecs']->table('user_rank') .
" AS r ON u.user_rank = r.rank_id ". $ex_where ."ORDER by " . $filter['sort_by'] . ' ' . $filter['sort_order'] .
" LIMIT " . $filter['start'] . ',' . $filter['page_size'];
继续向下找到for ($i=0; $i
{
$user_list[$i]['reg_time'] = local_date($GLOBALS['_CFG']['date_format'], $user_list[$i]['reg_time']);
}
将其修改为以下代码for ($i=0; $i
{
$user_list[$i]['reg_time'] = local_date($GLOBALS['_CFG']['date_format'], $user_list[$i]['reg_time']);
if ($user_list[$i]['rank_name'] =='')
{
$user_list[$i]['rank_name'] ="非特殊等级";
}
}