File size: 11,976 Bytes
0d5b03e |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 |
<?php
/**
* 分账规则列表
**/
include("../includes/common.php");
$title='分账规则列表';
include './head.php';
if($islogin==1){}else exit("<script language='javascript'>window.location.href='./login.php';</script>");
?>
<div class="container" style="padding-top:70px;">
<div class="col-md-12">
<?php
$channels = $DB->getAll("SELECT id,name,plugin FROM pre_channel WHERE plugin IN ('alipay','alipaysl','alipayd','wxpayn','wxpaynp') ORDER BY id ASC");
$channel_select = '';
foreach($channels as $row){
$channel_select .= '<option value="'.$row['id'].'" plugin="'.$row['plugin'].'">'.$row['id'].'__'.$row['name'].'</option>';
}
$link = '';
$sql = " 1";
if(isset($_GET['value']) && !empty($_GET['value'])) {
$value=daddslashes($_GET['value']);
$sql .= " AND A.`{$_GET['column']}`='{$value}'";
$link .= '&column='.$_GET['column'].'&value='.urlencode($_GET['value']);
}
?>
<div class="modal" id="modal-store" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true" data-backdrop="static">
<div class="modal-dialog">
<div class="modal-content animated flipInX">
<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="modal-title">分账规则修改/添加</h4>
</div>
<div class="modal-body">
<form class="form-horizontal" id="form-store">
<input type="hidden" name="action" id="action"/>
<input type="hidden" name="id" id="id"/>
<div class="form-group">
<label class="col-sm-3 control-label no-padding-right">支付通道</label>
<div class="col-sm-9">
<select name="channel" id="channel" class="form-control" onchange="changeChannel()">
<option value="0">请选择支付通道</option><?php echo $channel_select; ?>
</select>
<font color="green">只支持alipay、alipaysl、wxpayn、wxpaynp支付插件</font>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label no-padding-right">商户ID</label>
<div class="col-sm-9">
<input type="text" class="form-control" name="uid" id="uid" placeholder="可留空,留空则为当前支付通道所有订单">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label no-padding-right">接收方账号</label>
<div class="col-sm-9">
<input type="text" class="form-control" name="account" id="account" placeholder="">
<font color="green" id="account_note"></font>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label no-padding-right">接收方姓名</label>
<div class="col-sm-9">
<input type="text" class="form-control" name="name" id="name" placeholder="可留空,不填写则不校验真实姓名">
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label no-padding-right">分账比例</label>
<div class="col-sm-9">
<div class="input-group"><input type="text" class="form-control" name="rate" id="rate" placeholder="填写1~100的数字"><span class="input-group-addon">%</span></div>
<font color="green">一般限制最高30%(微信还需要减去手续费,例如手续费是0.6%,则填写29.4%)</font>
</div>
</div>
<div class="form-group">
<label class="col-sm-3 control-label no-padding-right">订单最小金额</label>
<div class="col-sm-9">
<div class="input-group"><input type="text" class="form-control" name="minmoney" id="minmoney" placeholder="订单超过该金额才进行分账"><span class="input-group-addon">元</span></div>
</div>
</div>
</form>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-white" data-dismiss="modal">关闭</button>
<button type="button" class="btn btn-primary" id="store" onclick="save()">保存</button>
</div>
</div>
</div>
</div>
<div class="panel panel-info">
<div class="panel-heading"><h3 class="panel-title">分账规则列表</h3></div>
<div class="panel-body">
<form action="./ps_receiver.php" method="GET" class="form-inline">
<div class="form-group">
<label><b>搜索</b></label>
<select name="column" class="form-control" default="<?php echo @$_GET['column']?>"><option value="channel">通道ID</option><option value="uid">商户ID</option><option value="account">接收方账号</option><option value="name">接收方姓名</option></select>
<input type="text" class="form-control" name="value" placeholder="输入搜索内容" value="<?php echo @$_GET['value']?>">
<button type="submit" class="btn btn-primary"><i class="fa fa-search"></i> 搜索</button>
<a href="javascript:addframe()" class="btn btn-success"><i class="fa fa-plus"></i> 新增</a>
<a href="?" class="btn btn-default" title="刷新列表"><i class="fa fa-refresh"></i></a>
</div>
</form>
</div>
<div class="table-responsive">
<table class="table table-striped">
<thead><tr><th>ID</th><th>支付通道</th><th>商户ID</th><th>接收方账号/姓名</th><th>分账比例</th><th>状态</th><th>操作</th></tr></thead>
<tbody>
<?php
$numrows=$DB->getColumn("SELECT count(*) from pre_psreceiver A WHERE{$sql}");
$pagesize=15;
$pages=ceil($numrows/$pagesize);
$page=isset($_GET['page'])?intval($_GET['page']):1;
$offset=$pagesize*($page - 1);
$rs=$DB->query("SELECT A.*,B.name channelname FROM pre_psreceiver A LEFT JOIN pre_channel B ON A.channel=B.id WHERE{$sql} order by A.id desc limit $offset,$pagesize");
while($res = $rs->fetch())
{
echo '<tr><td><b>'.$res['id'].'</b></td><td>'.$res['channel'].'__'.$res['channelname'].'</td><td><a href="./ulist.php?my=search&column=uid&value='.$res['uid'].'" target="_blank">'.$res['uid'].'</a></td><td>'.$res['account'].($res['name']?'/'.$res['name']:'').'</td><td>'.$res['rate'].'</td><td>'.($res['status']==1?'<a class="btn btn-xs btn-success" onclick="setStatus('.$res['id'].',0)">已开启</a>':'<a class="btn btn-xs btn-warning" onclick="setStatus('.$res['id'].',1)">已关闭</a>').'</td><td><a class="btn btn-xs btn-info" onclick="editframe('.$res['id'].')">编辑</a> <a class="btn btn-xs btn-danger" onclick="delItem('.$res['id'].')">删除</a> <a href="./ps_order.php?rid='.$res['id'].'" target="_blank" class="btn btn-xs btn-default">订单</a></td></tr>';
}
?>
</tbody>
</table>
</div>
<?php
echo'<center><ul class="pagination">';
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
if ($page>1)
{
echo '<li><a href="ps_receiver.php?page='.$first.$link.'">首页</a></li>';
echo '<li><a href="ps_receiver.php?page='.$prev.$link.'">«</a></li>';
} else {
echo '<li class="disabled"><a>首页</a></li>';
echo '<li class="disabled"><a>«</a></li>';
}
$start=$page-10>1?$page-10:1;
$end=$page+10<$pages?$page+10:$pages;
for ($i=$start;$i<$page;$i++)
echo '<li><a href="ps_receiver.php?page='.$i.$link.'">'.$i .'</a></li>';
echo '<li class="disabled"><a>'.$page.'</a></li>';
for ($i=$page+1;$i<=$end;$i++)
echo '<li><a href="ps_receiver.php?page='.$i.$link.'">'.$i .'</a></li>';
if ($page<$pages)
{
echo '<li><a href="ps_receiver.php?page='.$next.$link.'">»</a></li>';
echo '<li><a href="ps_receiver.php?page='.$last.$link.'">尾页</a></li>';
} else {
echo '<li class="disabled"><a>»</a></li>';
echo '<li class="disabled"><a>尾页</a></li>';
}
echo'</ul></center>';
?>
</div>
</div>
</div>
<script src="<?php echo $cdnpublic?>layer/3.1.1/layer.min.js"></script>
<script>
function addframe(){
$("#modal-store").modal('show');
$("#modal-title").html("新增分账规则");
$("#action").val("add");
$("#id").val('');
$("#channel").val(0);
$("#uid").val('');
$("#account").val('');
$("#name").val('');
$("#rate").val('');
$("#minmoney").val('');
}
function changeChannel(){
var channel = parseInt($("#channel").val());
if(channel>0){
var plugin = $("#channel option:selected").attr('plugin');
if(plugin == 'wxpayn' || plugin == 'wxpaynp')
$("#account_note").text('需填写OpenId!获取地址,在微信打开:<?php echo $siteurl?>user/openid.php?channel='+channel);
else if(plugin == 'alipay' || plugin == 'alipaysl')
$("#account_note").text('支持填写支付宝UID(2088开头的16位数字)或支付宝账号');
else
$("#account_note").text('');
}else{
$("#account_note").text('');
}
}
function editframe(id){
var ii = layer.load(2, {shade:[0.1,'#fff']});
$.ajax({
type : 'GET',
url : 'ajax_profitsharing.php?act=get_receiver&id='+id,
dataType : 'json',
success : function(data) {
layer.close(ii);
if(data.code == 0){
$("#modal-store").modal('show');
$("#modal-title").html("修改分账规则");
$("#action").val("edit");
$("#id").val(data.data.id);
$("#channel").val(data.data.channel);
$("#uid").val(data.data.uid);
$("#account").val(data.data.account);
$("#name").val(data.data.name);
$("#rate").val(data.data.rate);
$("#minmoney").val(data.data.minmoney);
}else{
layer.alert(data.msg, {icon: 2})
}
},
error:function(data){
layer.close(ii);
layer.msg('服务器错误');
}
});
}
function save(){
if($("#channel").val()=='0'||$("#account").val()==''){
layer.alert('必填项不能为空!');return false;
}
var url = 'ajax_profitsharing.php?act=add_receiver';
if($("#action").val() == 'edit') url = 'ajax_profitsharing.php?act=edit_receiver';
var ii = layer.load(2, {shade:[0.1,'#fff']});
$.ajax({
type : 'POST',
url : url,
data : $("#form-store").serialize(),
dataType : 'json',
success : function(data) {
layer.close(ii);
if(data.code == 0){
layer.alert(data.msg,{
icon: 1,
closeBtn: false
}, function(){
window.location.reload()
});
}else{
layer.alert(data.msg, {icon: 2})
}
},
error:function(data){
layer.close(ii);
layer.msg('服务器错误');
}
});
}
function delItem(id) {
var confirmobj = layer.confirm('你确实要删除此分账规则吗?', {
btn: ['确定','取消'], icon:0
}, function(){
$.ajax({
type : 'POST',
url : 'ajax_profitsharing.php?act=del_receiver',
data : {id: id},
dataType : 'json',
success : function(data) {
if(data.code == 0){
window.location.reload()
}else{
layer.alert(data.msg, {icon: 2});
}
},
error:function(data){
layer.msg('服务器错误');
}
});
}, function(){
layer.close(confirmobj);
});
}
function setStatus(id,status) {
var ii = layer.load(2, {shade:[0.1,'#fff']});
$.ajax({
type : 'POST',
url : 'ajax_profitsharing.php?act=set_receiver',
data : {id:id, status:status},
dataType : 'json',
success : function(data) {
layer.close(ii);
if(data.code == 0){
layer.alert(data.msg, {icon: 1}, function(){layer.closeAll();window.location.reload()});
}else{
layer.alert(data.msg, {icon: 2});
}
},
error:function(data){
layer.close(ii);
layer.msg('服务器错误');
}
});
}
function getAll(id, obj){
var ii = layer.load();
$.ajax({
type : 'GET',
url : 'ajax_profitsharing.php?act=getMoney&id='+id,
dataType : 'json',
success : function(data) {
layer.close(ii);
if(data.code == 0){
$(obj).html(data.money);
}else{
layer.alert(data.msg, {icon: 2})
}
},
error:function(data){
layer.msg('服务器错误');
}
});
}
$(document).ready(function(){
var items = $("select[default]");
for (i = 0; i < items.length; i++) {
if($(items[i]).attr("default")!=''){
$(items[i]).val($(items[i]).attr("default"));
}
}
})
</script> |