php充值卡,ecshop 充值卡功能_懒人程序

/*显示页面的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模板里增加充值模板

我的易购卡span>h5>

{$lang.process_time}td>	{$lang.surplus_pro_type}td>	{$lang.money}td>	卡号td>	密码td>tr>
{$item.sj}td>	{$item.name}td>	{$item.num}td>	{$item.kid}td>	{$item.kpass}td>tr>
{$lang.current_surplus}{$surplus}td>tr>table> 添加充值卡span>h5> 卡号:td> td> 密码:td> td> td>tr>table>form>div>----------------------------------------------------------------------------------------------------------------------------------------------------------themes\default\library\user_menu.lbi我的充值卡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,`yes` int(11) NOT NULL,`uid` int(11) NOT NULL,`sj` varchar(20) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30; 管理员表CREATE TABLE IF NOT EXISTS `cz_admin` ( `id` int(11) NOT NULL AUTO_INCREMENT,`user` varchar(30) NOT NULL,`pass` varchar(32) NOT NULL,`date` varchar(20) NOT NULL,`ip` varchar(20) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=44;INSERT INTO `cz_admin` (`id`,`user`,`pass`,`date`,`ip`) VALUES(43,'admin','97e79218963eb72c92a249dd5a330142','1408952509','223.222.111.11'); 充值日志表CREATE TABLE IF NOT EXISTS `cz_logs` ( `id` int(11) NOT NULL AUTO_INCREMENT,`log` varchar(200) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15;INSERT INTO `cz_logs` (`id`,`log`) VALUES(13,'用户：528何金银|冲值金额：10元|卡类型：测试购物卡|时间：2015-1-15 12:27:18'),(14,'用户：528何金银|冲值金额：10元|卡类型：测试购物卡|时间：2015-1-15 12:30:30'); 充值卡类型表CREATE TABLE IF NOT EXISTS `cz_type` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT,`name` varchar(20) NOT NULL,`ksj` varchar(15) NOT NULL,`jsj` varchar(20) NOT NULL,`js` varchar(300) NOT NULL,`num` int(11) NOT NULL,PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5;INSERT INTO `cz_type` (`id`,`name`,`ksj`,`jsj`,`js`,`num`) VALUES(1,'测试购物卡','2015-1-1','2015-1-30','测试的1',100),(2,'测试购物卡','2015-1-1','2015-1-30','测试的2',50), 充值卡生成的后台是自己写的 没有集成到ecshop里 功能比较简单 代码就不发上来了。