<?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">×</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">
<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
{
$match=explode("\n",$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 (!$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"> 全选
<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.'">«</a></li>';
}
else
{
echo '<li class="disabled"><a>首页</a></li>';
echo '<li class="disabled"><a>«</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.'">»</a></li>';
echo '<li><a href="fakakms.php?page='.$last.$link.'">尾页</a></li>';
}
else
{
echo '<li class="disabled"><a>»</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>';
?>
发表于 2019-1-31 20:09
|
发表于 2019-2-1 10:01
不喜勿喷
