最新消息: 新版网站上线了!!!

ecshop 充值卡功能

user.php
/* 显示页面的action列表 */
$ui_arr = array('register', 'login', 'profile',...      增加 cz
 
然后在下面代码处加入
if ($action == 'cz')//冲值
{
 
 if($_GET['a']=='add'){
  if (empty($_SESSION['user_id'])){ 
   show_message("该用户不存在。", '返回上一页', 'user.php?act=cz');
  }
  else{
   $k=strtoupper(substr($_POST['k'],0,8));
   $p=strtoupper(substr($_POST['p'],0,8));
   $row = $db -> getRow("SELECT * FROM cz_access  WHERE  `kid`='$k' and kpass='$p'");
   if (empty($row[id])){ show_message("卡号,密码不正确。", '返回上一页', 'user.php?act=cz');}
   if ($row[yes]>0){show_message("卡号已经被使用了。", '返回上一页', 'user.php?act=cz');}
   $r = $db -> getRow("SELECT num,name FROM cz_type  WHERE  id=".$row['type']);
   if(!(time()>=strtotime($r['ksj']) and strtotime(time()<=$r['jsj']))){show_message("该卡号不在使用范围之内。".$r['ksj']."--".$r['jsj'], '返回上一页', 'user.php?act=cz');}
   $db->query("update cz_access set yes=1,uid=".$_SESSION['user_id'].",sj='".date("Y-n-j G:i:s")."' where id=".$row['id']);
   log_account_change($_SESSION['user_id'],$r[num],0,0,0,'易购卡冲值');
   $db->query("insert into cz_logs (log) values ('用户:".$_SESSION['user_id'].$_SESSION['user_name']."|冲值金额:".$r[num]."元|卡类型:".$r['name']."|时间:".date("Y-n-j G:i:s")."') ");
   show_message("冲值成功。", '返回上一页', 'user.php?act=cz');
  }
 }
 include_once(ROOT_PATH .'includes/lib_clips.php');
 $info=get_user_default($user_id); 
 $smarty->assign('surplus', $info['surplus']);
 $sql = 'SELECT b.name,b.num,a.kid,a.kpass,a.sj FROM cz_access as a left join cz_type as b on a.type=b.id WHERE a.uid='.$user_id.' ORDER BY  a.sj desc';
    $list = $db->getAll($sql);
    $smarty->assign('list', $list);
 $smarty->display('user_transaction.dwt');
}
--------------------------------------------------------------------------------------------------------------------
themes\default\user_transaction.dwt     模板里增加充值模板
  <!-- {if $action eq "cz"} -->
    <h5 class="user-title"><span>我的易购卡</span></h5>
 <table width="100%" border="0" cellpadding="5" cellspacing="1" bgcolor="#EDD28B">
        <tr align="center">
          <td bgcolor="#ffffff">{$lang.process_time}</td>
          <td bgcolor="#ffffff">{$lang.surplus_pro_type}</td>
          <td bgcolor="#ffffff">{$lang.money}</td>
           <td bgcolor="#ffffff">卡号</td>
            <td bgcolor="#ffffff">密码</td>
        </tr>
        <!--{foreach from=$list item=item}-->
        <tr>
          <td align="center" bgcolor="#ffffff">{$item.sj}</td>
          <td align="center" bgcolor="#ffffff">{$item.name}</td>
          <td align="center" bgcolor="#ffffff">{$item.num}</td>
    <td align="center" bgcolor="#ffffff">{$item.kid}</td>
     <td align="center" bgcolor="#ffffff">{$item.kpass}</td>
        </tr>
        <!--{/foreach}-->
        <tr>
 <td colspan="7" align="right" bgcolor="#ffffff">{$lang.current_surplus}{$surplus}</td> </tr>      </table><br>
 <h5 class="user-title"><span>添加充值卡</span></h5>
 <div style="border:1px solid #EDD28B" class="box">
 <form name="form1" method="post" action="user.php?act=cz&a=add">
<table width="80%" border="0"> <tr>
    <td width="80" align="center">卡号:</td>
    <td width="23%"><input name="k" type="text" id="k" maxlength="8"  class="inputBg" ></td>
     <td width="80" align="center">密码:</td>
    <td width="39%"><input name="p" type="text" id="p" maxlength="8"  class="inputBg" ></td>
    <td width="23%">
      <input type="submit" name="button" id="button" value="冲 值" style="border:none;" class="bnt_blue_1">
    </td>  </tr></table></form>
</div>
<!-- {/if} -->
----------------------------------------------------------------------------------------------------------------------------------------------------------
themes\default\library\user_menu.lbi
<a href="user.php?act=cz"{if $action eq 'cz'}class="curs"{/if}>我的充值卡</a>
 
------------------------------------------------------------------------------------------------------------------------
数据库
 
充值卡表
CREATE TABLE IF NOT EXISTS `cz_access` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kid` varchar(10) NOT NULL,
  `kpass` varchar(10) NOT NULL,
  `type` int(11) NOT NULL
		
        
		-->
		
        

转载请注明:谷谷点程序 » ecshop 充值卡功能