您现在的位置是：首页 > cms教程 > Ecshop商城教程Ecshop商城教程

ecshop注册VIP推荐送现金的方法

友绿2023-11-14Ecshop商城教程已有人查阅

导读ecshop中的促销售功能还不是很完善，随着电子商务系统的发展和进步，越来越多的促销需求需要ecshop做的更灵活，这就造成了很大必要的对ecshop促销系统进行处理和重新开发

ecshop中的促销售功能还不是很完善，随着电子商务系统的发展和进步，越来越多的促销需求需要ecshop做的更灵活，这就造成了很大必要的对ecshop促销系统进行处理和重新开发．
1:模板user_clips.dwt增加以下代码。用来显示推荐的会员列表

{if $action=='list_fuwu'}
  <table width=" " border="0" cellpadding="5" cellspacing="1" bgcolor="#dddddd">
<tr align="center">
 <td bgcolor="#ffffff">会员ID</td>
 <td bgcolor="#ffffff">会员名称</td>

 <td bgcolor="#ffffff">注册时间</td>
</tr>
<!-- {foreach from=$my_comments key=level item=val name=affdb} -->
<tr align="center">
 <td bgcolor="#ffffff">{$val.user_id}</td>
 <td bgcolor="#ffffff">{$val.user_name}</td>

 <td bgcolor="#ffffff">{$val.reg_time}</td>
</tr>
<!-- {/foreach} -->
  </table>
<!-- #BeginLibraryItem "/library/pages.lbi" --><!-- #EndLibraryItem -->
{/if}

2:user.php中增加以下代码

elseif($action == 'list_fuwu'){
$rankid = intval($_REQUEST['rank_id']);
$parent_id = intval($_REQUEST['parent_id']);
if($parent_id && $rankid){
function get_comments($num,$start,$pid,$uk)
   {
 global $ecs;
 global $db;
 $sql ="  select  * from ".$ecs->table('users')." where parent_id = '$pid' and uk = '$uk' limit $start, $num";

$res = $db->getAll($sql);
  
return $res;
   }
   $sql = "SELECT COUNT(*) FROM ".$ecs->table('users')." where parent_id = '$parent_id' and uk = '$rankid'";
   $record_count = $GLOBALS['db']->getOne($sql);
   $page = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1;
  
   $pager = get_pager("user.php?act=list_fuwu&parent_id=$parent_id&rank_id=$rankid", array(), $record_count, $page, 10);
   $msg_lists = get_comments(10, $pager['start'],$parent_id, $rankid);
 if($msg_lists){
foreach($msg_lists as $k => $v){
$msg_lists[$k][reg_time] = date("Y-m-d",$v[reg_time]);
}
   }
   $GLOBALS['smarty']->assign('rand', mt_rand());
  
   $GLOBALS['smarty']->assign('pager', $pager);
   $GLOBALS['smarty']->assign('my_comments',$msg_lists);
   $smarty->display('user_clips.dwt');
}
}

3:user.php中增以下代码。用来计算服务费用

// 服务费用
elseif ($action == 'fuwu')
{
//####################
//统计推荐
//####################
$result = array();//推荐会员返回统计信息
$re = $db -> getAll("select rank_id,rank_name from ".$ecs->table('user_rank')." order by rank_id asc");
if($re){
  foreach($re as $k => $v){
   if($v['rank_name']){
$n = $v['rank_name'];
$result[$n]['money'] = 0;
//取得会员数量
$con = $db -> getOne("select count(*) c from ".$ecs->table('users')." where user_rank = ".$v[rank_id]." and parent_id =".$_SESSION['user_id']." and user_rank = uk");
//统计金额
//$string = '推荐'..'注册提成'
$ua = $db -> getAll("select user_name from ".$ecs->table('users')." where user_rank = ".$v[rank_id]." and parent_id =".$_SESSION['user_id']." and user_rank = uk");
if($ua){
foreach($ua as $k => $v){
 $string = '推荐'.$v[user_name].'注册提成';
 $money = $db -> getOne("select user_money from ".$ecs->table('account_log')." where change_desc = '$string'");
 $result[$n]['money']+= $money;//计算推荐金额
}
}
$result[$n]['num']  = $con;
$result[$n]['rank_id']  = $v['rank_id'];
   }
  }
}

//#################
//格式化金额
//#################
if($result){
  foreach($result as $k => $v){
   $result[$k]['money'] =  price_format($v['money'], false);
  }
}
$smarty -> assign('affdb',$result);
$smarty->assign('shopname', $_CFG['shop_name']);
$smarty->assign('userid', $user_id);
$smarty->assign('shopurl', $ecs->url());
$smarty->assign('logosrc', 'themes/' . $_CFG['template'] . '/images/logo.gif');
$smarty->display('user_clips.dwt');
}

4:admin/affliliate.php中的list中增加以下代码

//##################
//推荐VIP会员送现金
//##################
$re = $db -> getAll("select * from ".$ecs->table('user_rank')." order by rank_id");
$smarty -> assign('rank',$re);
//##################
//推荐VIP会员送现金
//##################

5:admin/affliliate.php中的updata增以下代码

if($_POST['rank'])
  $ar = array_combine($_POST['rn'],$_POST['rank']);
  if($ar){
   foreach($ar as $k => $v){
    $sql = " update ".$ecs->table('user_rank')." set qian = ".$v." where rank_id = $k";
    $db -> query($sql);
   }
  }
}

5：affliate.htm中增加以下代码

<tr>
<td align="right" class="label">推荐VIP会员送现金:</td>
<td>
{foreach from = $rank item = item}
  {$item.rank_name}:<input type="text" name="rank[]" value="{$item.qian}" size="3">
<input type="hidden" name="rn[]" value="{$item.rank_id}">
{/foreach}
</td>
 </tr>
6:user_clips.dwt中增加以下代码。用来列表推荐信息
<table width=" " border="0" cellpadding="5" cellspacing="1" bgcolor="#dddddd">
    <tr align="center">
 <td bgcolor="#ffffff">{$lang.affiliate_lever}</td>
 <td bgcolor="#ffffff">{$lang.affiliate_num}</td>
 <td bgcolor="#ffffff">提成金额</td>
    </tr>
    <!-- {foreach from=$affdb1 key=level item=val name=affdb} -->
    <tr align="center">
 <td bgcolor="#ffffff">{$level}</td>
 <td bgcolor="#ffffff"><a href="?act=list_fuwu&parent_id={$smarty.session.user_id}&rank_id={$val.rank_id}">{$val.num}</a></td>
 <td bgcolor="#ffffff">{$val.money}</td>
    </tr>
    <!-- {/foreach} -->
  </table>