|
|
<?php
|
|
|
|
|
|
|
|
|
|
|
|
include("../includes/common.php");
|
|
|
$title='批量结算';
|
|
|
include './head.php';
|
|
|
if($islogin==1){}else exit("<script language='javascript'>window.location.href='./login.php';</script>");
|
|
|
?>
|
|
|
<style>
|
|
|
img.logo{width:14px;height:14px;margin:0 5px 0 3px;}
|
|
|
</style>
|
|
|
<div class="container" style="padding-top:70px;">
|
|
|
<div class="col-xs-12 col-sm-10 col-lg-8 center-block" style="float: none;">
|
|
|
<div class="panel panel-primary">
|
|
|
<div class="panel-heading"><h3 class="panel-title">批量结算操作<span class="pull-right"><a href="javascript:createBatch()" class="btn btn-default btn-xs"><i class="fa fa-plus"></i> 生成结算批次</a></span></h3></div>
|
|
|
<table class="table table-striped">
|
|
|
<thead><tr><th>批次号</th><th>总金额</th><th>总数量</th><th>生成时间</th><th>操作</th></thead>
|
|
|
<tbody>
|
|
|
<?php
|
|
|
$pagesize=15;
|
|
|
$pages=ceil($numrows/$pagesize);
|
|
|
$page=isset($_GET['page'])?intval($_GET['page']):1;
|
|
|
$offset=$pagesize*($page - 1);
|
|
|
|
|
|
$rs=$DB->query("SELECT * FROM pre_batch order by time desc limit $offset,$pagesize");
|
|
|
while($res = $rs->fetch())
|
|
|
{
|
|
|
echo '<tr><td><b>'.$res['batch'].'</b></td><td>'.$res['allmoney'].'</td><td>'.$res['count'].'</td><td>'.$res['time'].'</td><td><a href="./slist.php?batch='.$res['batch'].'" class="btn btn-xs btn-info">结算列表</a> <a href="javascript:download_csv(\''.$res['batch'].'\')" class="btn btn-xs btn-warning">导出表格</a> <a href="javascript:transfer(\''.$res['batch'].'\')" class="btn btn-xs btn-success">批量转账</a> <a href="javascript:completeBatch(\''.$res['batch'].'\')" class="btn btn-xs btn-primary">改为完成</a></td></tr>';
|
|
|
}
|
|
|
?>
|
|
|
</tbody>
|
|
|
</table>
|
|
|
<?php
|
|
|
echo'<div class="text-center"><ul class="pagination">';
|
|
|
$first=1;
|
|
|
$prev=$page-1;
|
|
|
$next=$page+1;
|
|
|
$last=$pages;
|
|
|
if ($page>1)
|
|
|
{
|
|
|
echo '<li><a href="settle.php?page='.$first.$link.'">首页</a></li>';
|
|
|
echo '<li><a href="settle.php?page='.$prev.$link.'">«</a></li>';
|
|
|
} else {
|
|
|
echo '<li class="disabled"><a>首页</a></li>';
|
|
|
echo '<li class="disabled"><a>«</a></li>';
|
|
|
}
|
|
|
for ($i=1;$i<$page;$i++)
|
|
|
echo '<li><a href="settle.php?page='.$i.$link.'">'.$i .'</a></li>';
|
|
|
echo '<li class="disabled"><a>'.$page.'</a></li>';
|
|
|
if($pages>=10)$sss=$page+10;else $sss=$pages;
|
|
|
for ($i=$page+1;$i<=$sss;$i++)
|
|
|
echo '<li><a href="settle.php?page='.$i.$link.'">'.$i .'</a></li>';
|
|
|
echo '';
|
|
|
if ($page<$pages)
|
|
|
{
|
|
|
echo '<li><a href="settle.php?page='.$next.$link.'">»</a></li>';
|
|
|
echo '<li><a href="settle.php?page='.$last.$link.'">尾页</a></li>';
|
|
|
} else {
|
|
|
echo '<li class="disabled"><a>»</a></li>';
|
|
|
echo '<li class="disabled"><a>尾页</a></li>';
|
|
|
}
|
|
|
echo'</ul></div>';
|
|
|
|
|
|
?>
|
|
|
<div class="panel-footer">
|
|
|
<span class="glyphicon glyphicon-info-sign"></span> 结算标准：金额大于<?php echo $conf['settle_money']?>元，或主动申请的<br/><span class="glyphicon glyphicon-info-sign"></span> 点击 生成结算批次 之后会将所有"<font color="blue">待结算</font>"状态的记录更改为"<font color="orange">正在结算</font>"，通过转账接口转账之后会将状态更改为"<font color="green">已完成</font>"，如果是手动转账，需要手动将状态更改为"<font color="green">已完成</font>"
|
|
|
</div>
|
|
|
</div>
|
|
|
</div>
|
|
|
</div>
|
|
|
<script src="<?php echo $cdnpublic?>layer/3.1.1/layer.min.js"></script>
|
|
|
<script>
|
|
|
function createBatch(){
|
|
|
var confirmobj = layer.confirm('你确定要生成结算批次吗？', {
|
|
|
btn: ['确定','取消']
|
|
|
}, function(){
|
|
|
var ii = layer.load(2, {shade:[0.1,'#fff']});
|
|
|
$.ajax({
|
|
|
type : 'GET',
|
|
|
url : 'ajax_settle.php?act=create_batch',
|
|
|
dataType : 'json',
|
|
|
success : function(data) {
|
|
|
layer.close(ii);
|
|
|
if(data.code == 0){
|
|
|
layer.alert('生成结算批次成功！该批次总数量:'+data.count+'，总金额:'+data.allmoney, {
|
|
|
icon: 1,
|
|
|
closeBtn: false
|
|
|
},function(){
|
|
|
window.location.reload();
|
|
|
});
|
|
|
}else{
|
|
|
layer.alert(data.msg, {icon: 0})
|
|
|
}
|
|
|
},
|
|
|
error:function(data){
|
|
|
layer.msg('服务器错误');
|
|
|
return false;
|
|
|
}
|
|
|
});
|
|
|
}, function(){
|
|
|
layer.close(confirmobj);
|
|
|
});
|
|
|
}
|
|
|
function transfer(batch){
|
|
|
$.ajax({
|
|
|
type : 'GET',
|
|
|
url : 'ajax_settle.php?act=paypwd_check',
|
|
|
dataType : 'json',
|
|
|
success : function(data) {
|
|
|
if(data.code == 0){
|
|
|
var paymsg = '';
|
|
|
paymsg+='<a class="btn btn-default btn-block" href="transfer_batch.php?type=1&batch='+batch+'" style="margin-top:10px;"><img width="20" src="../assets/icon/alipay.ico" class="logo">支付宝批量转账</a>';
|
|
|
paymsg+='<a class="btn btn-default btn-block" href="transfer_batch.php?type=2&batch='+batch+'" style="margin-top:10px;"><img width="20" src="../assets/icon/wxpay.ico" class="logo">微信批量转账</a>';
|
|
|
paymsg+='<a class="btn btn-default btn-block" href="transfer_batch.php?type=3&batch='+batch+'" style="margin-top:10px;"><img width="20" src="../assets/icon/qqpay.ico" class="logo">QQ钱包批量转账</a>';
|
|
|
paymsg+='<a class="btn btn-default btn-block" href="transfer_batch.php?type=4&batch='+batch+'" style="margin-top:10px;"><img width="20" src="../assets/icon/bank.ico" class="logo">银行卡批量转账</a>';
|
|
|
layer.alert('<center>'+paymsg+'<hr><a class="btn btn-default btn-block" onclick="layer.closeAll()">关闭</a></center>',{
|
|
|
btn:[],
|
|
|
title:'请选择批量转账方式',
|
|
|
closeBtn: false,
|
|
|
shadeClose: true
|
|
|
});
|
|
|
}else{
|
|
|
layer.prompt({title: '请输入支付密码', value: '', formType: 1}, function(text, index){
|
|
|
$.ajax({
|
|
|
type : 'POST',
|
|
|
url : 'ajax_settle.php?act=paypwd_input',
|
|
|
data : {paypwd:text},
|
|
|
dataType : 'json',
|
|
|
success : function(data) {
|
|
|
if(data.code == 0){
|
|
|
transfer(batch);
|
|
|
}else{
|
|
|
layer.alert(data.msg, {icon: 2})
|
|
|
}
|
|
|
},
|
|
|
error:function(data){
|
|
|
layer.msg('服务器错误');
|
|
|
return false;
|
|
|
}
|
|
|
});
|
|
|
})
|
|
|
}
|
|
|
},
|
|
|
error:function(data){
|
|
|
layer.msg('服务器错误');
|
|
|
return false;
|
|
|
}
|
|
|
});
|
|
|
}
|
|
|
function completeBatch(batch){
|
|
|
var confirmobj = layer.confirm('是否将该批次所有结算记录状态改为已完成？', {
|
|
|
btn: ['确定','取消']
|
|
|
}, function(){
|
|
|
var ii = layer.load(2, {shade:[0.1,'#fff']});
|
|
|
$.ajax({
|
|
|
type : 'POST',
|
|
|
url : 'ajax_settle.php?act=complete_batch',
|
|
|
data : {batch: batch},
|
|
|
dataType : 'json',
|
|
|
success : function(data) {
|
|
|
layer.close(ii);
|
|
|
if(data.code == 0){
|
|
|
layer.alert(data.msg, {
|
|
|
icon: 1,
|
|
|
closeBtn: false
|
|
|
});
|
|
|
}else{
|
|
|
layer.alert(data.msg, {icon: 0})
|
|
|
}
|
|
|
},
|
|
|
error:function(data){
|
|
|
layer.msg('服务器错误');
|
|
|
return false;
|
|
|
}
|
|
|
});
|
|
|
}, function(){
|
|
|
layer.close(confirmobj);
|
|
|
});
|
|
|
}
|
|
|
function download_csv(batch){
|
|
|
var paymsg = '';
|
|
|
paymsg+='<a class="btn btn-default btn-block" href="download.php?act=settle&batch='+batch+'" style="margin-top:10px;">结算信息汇总表格</a>';
|
|
|
paymsg+='<a class="btn btn-default btn-block" href="download.php?act=settle&type=alipay&batch='+batch+'" style="margin-top:10px;">支付宝批量付款表格</a>';
|
|
|
paymsg+='<a class="btn btn-default btn-block" href="download.php?act=settle&type=mybank&batch='+batch+'" style="margin-top:10px;">网商银行批量转账表格</a>';
|
|
|
paymsg+='<a class="btn btn-default btn-block" href="download.php?act=settle&type=wxpay&batch='+batch+'" style="margin-top:10px;">微信批量转账到零钱表格</a>';
|
|
|
layer.alert('<center>'+paymsg+'<hr><a class="btn btn-default btn-block" onclick="layer.closeAll()">关闭</a></center>',{
|
|
|
btn:[],
|
|
|
title:'请选择CSV表格模板',
|
|
|
closeBtn: false,
|
|
|
shadeClose: true
|
|
|
});
|
|
|
}
|
|
|
</script> |
