<?php  
include('../includes/common.php');
$title='卡密列表';
include('./head.php');
if ($islogin!=1) 
{
	exit('<script language=\'javascript\'>window.location.href=\'./login.php\';</script>');
}
echo '<style>
td{overflow: hidden;text-overflow: ellipsis;white-space: nowrap;max-width:360px;}
</style>
   <div class="col-sm-12 col-md-10 center-block" style="float: none;">
<div class="modal fade" align="left" id="search" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
 <div class="modal-dialog">
   <div class="modal-content">
     <div class="modal-header">
       <button type="button" class="close" data-dismiss="modal"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>
       <h4 class="modal-title" id="myModalLabel">搜索卡密</h4>
     </div>
     <div class="modal-body">
     <form action="fakakms.php" method="GET">
<input type="hidden" name="tid" value="';
;
error_reporting(0);
echo $_GET['tid'];
echo '"><br/>
<input type="text" class="form-control" name="kw" placeholder="请输入卡号或密码"><br/>
<input type="submit" class="btn btn-primary btn-block" value="搜索"></form>
</div>
     <div class="modal-footer">
       <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
     </div>
   </div>
 </div>
</div>
';
$rs=$DB->query('SELECT * FROM shua_class WHERE active=1 order by sort asc');
$select='<option value="0">请选择商品分类</option>';
while ($res=$DB->fetch($rs)) 
{
	$select .='<option value="'.$res['cid'].'">'.$res['name'].'</option>';
}
$my=(isset($_GET['my'])?$_GET['my']:NULL);
if ($my=='add') 
{
	if (isset($_GET['tid'])) 
	{
		$tid=intval($_GET['tid']);
		$row=$DB->get_row('select * from shua_tools where tid=\''.$tid.'\' limit 1');
		$shopname='<option value="'.$tid.'">'.$row['name'].'</option>';
		$cid=$row['cid'];
	}
	else 
	{
		$cid=0;
	}
	echo '<div class="block">
<div class="block-title"><h3 class="panel-title">添加卡密</h3></div>
<div class="">
<form action="./fakakms.php?my=add_submit" method="POST" onsubmit="return checkAdd()">
<input type="hidden" name="backurl" value="';
	echo $_SERVER['HTTP_REFERER'];
	echo '"/>
<div class="form-group">
	<div class="input-group">
		<span class="input-group-addon">
			选择商品
		</span>
		<select id="cid" class="form-control" default="';
	echo $cid;
	echo '">';
	echo $select;
	echo '</select>
		<select id="tid" name="tid" class="form-control" default="';
	echo $tid;
	echo '">';
	echo $shopname;
	echo '</select>
	</div>
</div>
<div class="form-group">
	<div class="input-group">
		<span class="input-group-addon">
			卡密列表
		</span>
		<textarea class="form-control" id="kms" name="kms" rows="8" placeholder="一行一张卡"></textarea>
	</div>
</div>
<div class="form-group">
	<div class="input-group">
		<span class="input-group-addon">
			分隔符
		</span>
		<input type="text" name="split" value="" class="form-control" placeholder="可自定义卡号和密码之间的分隔符，默认留空为空格"/>
	</div>
</div>
<div class="form-group">
	<div class="input-group">
		<span class="input-group-addon"><label><input id="is_check_repeat" name="is_check_repeat" type="checkbox" value="1">检查重复的卡密</label></span>
	</div>
</div>
<div class="form-group">
	<button type="submit" class="btn btn-primary btn-block">确认提交</button>
	<button type="reset" class="btn btn-default btn-block">重新填写</button>
</div>
</form>
</div>
<div class="panel-footer">
<span class="glyphicon glyphicon-info-sign"></span>
注意：卡密格式：卡号+空格+密码，一行一张卡，如：ABCDEFG 123456789<br/>
只有商品设置里面购买成功后的动作选择自动发卡，该商品才会显示在当前列表
</div>
</div>
<a href="';
	echo (isset($_SERVER['HTTP_REFERER'])?$_SERVER['HTTP_REFERER']:'fakalist.php');
	echo '" class="btn btn-default btn-block">>>返回发卡库存列表</a>
';
}
else 
{
	if ($my=='add_submit') 
	{
		$tid=intval($_POST['tid']);
		$kms=$_POST['kms'];
		$split=$_POST['split'];
		$is_check_repeat=$_POST['is_check_repeat'];
		if (($tid==NULL || $kms==NULL)) 
		{
			showmsg('请确保各项不能为空！',3);
		}
		else 
		{
			$kms=str_replace(array(0=>"\\r\\n",1=>"\\r",2=>"\\n"),'[br]',$kms);
			$match=explode('[br]',$kms);
			$c=0;
			foreach($match as $val)
			{
				if (empty($split)) 
				{
					$km_arr=explode(' ',$val);
				}
				else 
				{
					$km_arr=explode($split,$val);
				}
				$km=trim(daddslashes($km_arr[0]));
				$pw=trim(daddslashes($km_arr[1]));
				if ($km!='') 
				{
					if ($is_check_repeat==1) 
					{
						if (!$DB->get_row('select * from shua_faka where km=\''.$km.'\' limit 1')) 
						{
							$sql=$DB->query('INSERT INTO `shua_faka` (`tid`,`km`,`pw`,`addtime`) VALUES (\''.$tid.'\',\''.$km.'\',\''.$pw.'\',NOW())');
							if ($sql) 
							{
								$c=$c+1;
							}
							else 
							{
								showmsg('添加卡密失败！'.$DB->error());
							}
						}
					}
				}
			}
			showmsg('成功添加<b>'.$c.'</b>张卡密！<br/><br/><a href="'.$_POST['backurl'].'">>>返回发卡库存列表</a>',1);
		}
	}
	else 
	{
		if ($my=='del') 
		{
			$id=$_GET['id'];
			$sql=$DB->query('DELETE FROM shua_faka WHERE kid=\''.$id.'\'');
			exit('<script language=\'javascript\'>history.go(-1);</script>');
		}
		else 
		{
			if ($my=='qk') 
			{
				$tid=intval($_GET['tid']);
				echo '<div class="block">
<div class="block-title"><h3 class="panel-title">清空卡密</h3></div>
<div class=" box">
您确认要清空该商品的所有卡密吗？清空后无法恢复！<br><a href="./fakakms.php?my=qk2&tid='.$tid.'">确认</a> | <a href="javascript:history.back();">返回</a></div></div>';
			}
			else 
			{
				if ($my=='qk2') 
				{
					$tid=intval($_GET['tid']);
					echo '<div class="block">
<div class="block-title"><h3 class="panel-title">清空卡密</h3></div>
<div class=" box">';
					if ($DB->query('DELETE FROM shua_faka WHERE tid=\''.$tid.'\'')==true) 
					{
						echo '<div class="box">清空成功.</div>';
					}
					else 
					{
						echo '<div class="box">清空失败.</div>';
					}
					echo '<hr/><a href="./fakakms.php?tid='.$tid.'">>>返回卡密列表</a></div></div>';
				}
				else 
				{
					if ($my=='qkuse') 
					{
						$tid=intval($_GET['tid']);
						echo '<div class="block">
<div class="block-title"><h3 class="panel-title">清空卡密</h3></div>
<div class=" box">
您确认要清空所有卡密吗？清空后无法恢复！<br><a href="./fakakms.php?my=qkuse2&tid='.$tid.'">确认</a> | <a href="javascript:history.back();">返回</a></div></div>';
					}
					else 
					{
						if ($my=='qkuse2') 
						{
							$tid=intval($_GET['tid']);
							echo '<div class="block">
<div class="block-title"><h3 class="panel-title">清空卡密</h3></div>
<div class=" box">';
							if ($DB->query('DELETE FROM shua_faka WHERE tid=\''.$tid.'\' and orderid!=0')==true) 
							{
								echo '<div class="box">清空成功.</div>';
							}
							else 
							{
								echo '<div class="box">清空失败.</div>';
							}
							echo '<hr/><a href="./fakakms.php?tid='.$tid.'">>>返回卡密列表</a></div></div>';
						}
						else 
						{
							if ($my=='del2') 
							{
								$checkbox=$_POST['checkbox'];
								$i=0;
								foreach($checkbox as $kid)
								{
									$DB->query('DELETE FROM shua_faka WHERE kid=\''.$kid.'\' limit 1');
									$i=$i+1;
								}
								exit('<script language=\'javascript\'>alert(\'成功删除'.$i.'张卡密\');history.go(-1);</script>');
							}
							else 
							{
								if (isset($_GET['kw'])) 
								{
									$sql=' `tid`=\''.$tid.'\' and (`km`=\''.$_GET['kw'].'\' or `pw`=\''.$_GET['kw'].'\')';
									$link='&tid='.$tid.'&kw='.$_GET['kw'];
								}
								else 
								{
									if (isset($_GET['kid'])) 
									{
										$sql=' `kid`=\''.$_GET['kid'].'\'';
										$link='&kid='.$_GET['kid'];
									}
									else 
									{
										if (isset($_GET['orderid'])) 
										{
											$sql=' `orderid`=\''.$_GET['orderid'].'\'';
											$link='&orderid='.$_GET['orderid'];
										}
										else 
										{
											if (isset($_GET['tid'])) 
											{
												$tid=intval($_GET['tid']);
												$row=$DB->get_row('select * from shua_tools where tid=\''.$tid.'\' limit 1');
												if (!$row) 
												{
													showmsg('商品不存在',3);
												}
												$sql=' `tid`=\''.$tid.'\'';
												$link='&tid='.$tid;
											}
											else 
											{
												showmsg('商品不存在',3);
											}
										}
									}
								}
								$numrows=$DB->count('SELECT count(*) from shua_faka WHERE'.$sql);
								echo '<div class="block">
	<div class="block-title">
		<h2>';
								echo $row['name'];
								echo ' - 卡密库存列表</h2>
	</div>
	<div class="">
	<a href="fakakms.php?my=add&tid=';
								echo $tid;
								echo '" class="btn btn-success">加卡</a>
 <a href="fakakms.php?my=qk&tid=';
								echo $tid;
								echo '" class="btn btn-danger">清空</a>
 <a href="fakakms.php?my=qkuse&tid=';
								echo $tid;
								echo '" class="btn btn-danger">清空已使用</a>
 <a href="#" data-toggle="modal" data-target="#search" id="search" class="btn btn-primary">搜索</a>
 </div>
	<form name="form1" method="post" action="fakakms.php?my=del2">
     <div class="table-responsive">
       <table class="table table-striped">
         <thead><tr><th>卡号</th><th>密码</th><th>状态</th><th>添加时间</th><th>使用时间</th><th>操作</th></tr></thead>
         <tbody>
';
								$pagesize=30;
								$pages=intval($numrows/$pagesize);
								if ($numrows%$pagesize) 
								{
									$pages=$pages+1;
								}
								if (isset($_GET['page'])) 
								{
									$page=intval($_GET['page']);
								}
								else 
								{
									$page=1;
								}
								$offset=$pagesize*($page-1);
								$rs=$DB->query('SELECT * FROM shua_faka WHERE'.$sql.' order by kid desc limit '.$offset.','.$pagesize);
								while ($res=$DB->fetch($rs)) 
								{
									if ($res['usetime']==NULL) 
									{
										$isuse='<font color="green">未使用</font>';
									}
									else 
									{
										$isuse='<font color="red">已使用</font>('.$res['orderid'].')';
									}
									echo '<tr><td><input type="checkbox" name="checkbox[]" id="list1" value="'.$res['kid'].'" onClick="unselectall1()"><b>'.$res['km'].'</b></td><td>'.$res['pw'].'</td><td>'.$isuse.'</td><td>'.$res['addtime'].'</td><td>'.$res['usetime'].'</td><td><a href="./fakakms.php?my=del&id='.$res['kid'].'" class="btn btn-xs btn-danger" onclick="return confirm(\'你确实要删除此卡密吗？\');">删除</a></td></tr>';
								}
								echo '          </tbody>
       </table>
<input name="chkAll1" type="checkbox" id="chkAll1" onClick="this.value=check1(this.form.list1)" value="checkbox">&nbsp;全选&nbsp;
<input type="submit" name="Submit" value="删除选中">
</div>
</form>
';
								echo '<ul class="pagination">';
								$first=1;
								$prev=$page-1;
								$next=$page+1;
								$last=$pages;
								if ($page>1) 
								{
									echo '<li><a href="fakakms.php?page='.$first.$link.'">首页</a></li>';
									echo '<li><a href="fakakms.php?page='.$prev.$link.'">&laquo;</a></li>';
								}
								else 
								{
									echo '<li class="disabled"><a>首页</a></li>';
									echo '<li class="disabled"><a>&laquo;</a></li>';
								}
								$i=1;
								while ($i<$page) 
								{
									echo '<li><a href="fakakms.php?page='.$i.$link.'">'.$i.'</a></li>';
									$i=$i+1;
								}
								echo '<li class="disabled"><a>'.$page.'</a></li>';
								if ($pages>=10) 
								{
									$s=10;
								}
								else 
								{
									$s=$pages;
								}
								$i=$page+1;
								while ($i<=$s) 
								{
									echo '<li><a href="fakakms.php?page='.$i.$link.'">'.$i.'</a></li>';
									$i=$i+1;
								}
								echo '';
								if ($page<$pages) 
								{
									echo '<li><a href="fakakms.php?page='.$next.$link.'">&raquo;</a></li>';
									echo '<li><a href="fakakms.php?page='.$last.$link.'">尾页</a></li>';
								}
								else 
								{
									echo '<li class="disabled"><a>&raquo;</a></li>';
									echo '<li class="disabled"><a>尾页</a></li>';
								}
								echo '</ul>';
							}
						}
					}
				}
			}
		}
	}
}
echo '    </div>
 </div>
</div>
<script src="//cdn.staticfile.org/layer/2.3/layer.js"></script>
<script>
var checkflag1 = "false";
function check1(field) {
if (checkflag1 == "false") {
for (i = 0; i < field.length; i++) {
field[i].checked = true;}
checkflag1 = "true";
return "false"; }
else {
for (i = 0; i < field.length; i++) {
field[i].checked = false; }
checkflag1 = "false";
return "true"; }
}

function unselectall1()
{
   if(document.form1.chkAll1.checked){
	document.form1.chkAll1.checked = document.form1.chkAll1.checked&0;
	checkflag1 = "false";
   } 	
}

function checkAdd(){
	if($("#tid").val()==0||$("#tid").val()==null){
		layer.alert(\'请先选择商品\');return false;
	}
	if($("#kms").val()==\'\'){
		layer.alert(\'卡密列表不能为空\');return false;
	}
}
$(document).ready(function(){
	$("#cid").change(function () {
		var cid = $(this).val();
		var ii = layer.load(2, {shade:[0.1,\'#fff\']});
		$("#tid").empty();
		$("#tid").append(\'<option value="0">请选择商品</option>\');
		$.ajax({
			type : "GET",
			url : "./ajax.php?act=getfakatool&cid="+cid,
			dataType : \'json\',
			success : function(data) {
				layer.close(ii);
				if(data.code == 0){
					var num = 0;
					$.each(data.data, function (i, res) {
						$("#tid").append(\'<option value="\'+res.tid+\'">\'+res.name+\'</option>\');
						num++;
					});
					$("#tid").val(0);
					if(num==0 && cid!=0)$("#tid").html(\'<option value="0">该分类下没有发卡类商品</option>\');
				}else{
					layer.alert(data.msg);
				}
			},
			error:function(data){
				layer.msg(\'服务器错误\');
				return false;
			}
		});
	});
	var items = $("select[default]");
	for (i = 0; i < items.length; i++) {
		$(items[i]).val($(items[i]).attr("default")||0);
	}
});
</script>';
?>