|
|
<?php
|
|
|
include("../includes/common.php");
|
|
|
if($islogin==1){}else exit("<script language='javascript'>window.location.href='./login.php';</script>");
|
|
|
$act=isset($_GET['act'])?daddslashes($_GET['act']):null;
|
|
|
|
|
|
if(!checkRefererHost())exit('{"code":403}');
|
|
|
|
|
|
@header('Content-Type: application/json; charset=UTF-8');
|
|
|
|
|
|
switch($act){
|
|
|
case 'settleList':
|
|
|
$sql=" 1=1";
|
|
|
if(isset($_POST['batch']) && !empty($_POST['batch'])) {
|
|
|
$batch = daddslashes($_POST['batch']);
|
|
|
$sql.=" AND `batch`='$batch'";
|
|
|
}
|
|
|
if(isset($_POST['uid']) && !empty($_POST['uid'])) {
|
|
|
$uid = intval($_POST['uid']);
|
|
|
$sql.=" AND `uid`='$uid'";
|
|
|
}
|
|
|
if(isset($_POST['type']) && !empty($_POST['type'])) {
|
|
|
$type = intval($_POST['type']);
|
|
|
$sql.=" AND `type`='$type'";
|
|
|
}
|
|
|
if(isset($_POST['dstatus']) && $_POST['dstatus']>-1) {
|
|
|
$dstatus = intval($_POST['dstatus']);
|
|
|
$sql.=" AND `status`={$dstatus}";
|
|
|
}
|
|
|
if(isset($_POST['value']) && !empty($_POST['value'])) {
|
|
|
$value = daddslashes($_POST['value']);
|
|
|
$sql.=" AND (`account` like '%{$value}%' OR `username` like '%{$value}%')";
|
|
|
}
|
|
|
$offset = intval($_POST['offset']);
|
|
|
$limit = intval($_POST['limit']);
|
|
|
$total = $DB->getColumn("SELECT count(*) from pre_settle WHERE{$sql}");
|
|
|
$list = $DB->getAll("SELECT * FROM pre_settle WHERE{$sql} order by id desc limit $offset,$limit");
|
|
|
|
|
|
exit(json_encode(['total'=>$total, 'rows'=>$list]));
|
|
|
break;
|
|
|
|
|
|
case 'create_batch':
|
|
|
$count=$DB->getColumn("SELECT count(*) from pre_settle where status=0");
|
|
|
if($count==0)exit('{"code":-1,"msg":"当前不存在待结算的记录"}');
|
|
|
$batch=date("Ymd").rand(111,999);
|
|
|
$allmoney = 0;
|
|
|
$rs=$DB->query("SELECT * from pre_settle where status=0");
|
|
|
while($row = $rs->fetch())
|
|
|
{
|
|
|
$DB->exec("UPDATE pre_settle SET batch='$batch',status=2 WHERE id='{$row['id']}'");
|
|
|
$allmoney+=$row['realmoney'];
|
|
|
}
|
|
|
$DB->insert('batch', ['batch'=>$batch, 'allmoney'=>$allmoney, 'count'=>$count, 'time'=>'NOW()', 'status'=>0]);
|
|
|
|
|
|
exit(json_encode(['code'=>0, 'msg'=>'succ', 'batch'=>$batch, 'count'=>$count, 'allmoney'=>$allmoney]));
|
|
|
break;
|
|
|
case 'complete_batch':
|
|
|
$batch=trim($_POST['batch']);
|
|
|
$DB->exec("UPDATE pre_settle SET status=1 WHERE batch='$batch'");
|
|
|
exit('{"code":0,"msg":"succ"}');
|
|
|
break;
|
|
|
case 'setSettleStatus':
|
|
|
$id=intval($_GET['id']);
|
|
|
$status=intval($_GET['status']);
|
|
|
if($status==4){
|
|
|
if($DB->exec("DELETE FROM pre_settle WHERE id='$id'"))
|
|
|
exit('{"code":200}');
|
|
|
else
|
|
|
exit('{"code":400,"msg":"删除记录失败！['.$DB->error().']"}');
|
|
|
}else{
|
|
|
if($status==1){
|
|
|
$sql = "update pre_settle set status='$status',endtime='$date',result=NULL where id='$id'";
|
|
|
|
|
|
$row = $DB->find('settle', 'uid,money,realmoney,account', ['id'=>$id]);
|
|
|
\lib\MsgNotice::send('settle', $row['uid'], ['money'=>$row['money'], 'realmoney'=>$row['realmoney'], 'time'=>date('Y-m-d H:i:s'), 'account'=>$row['account']]);
|
|
|
}else{
|
|
|
$sql = "update pre_settle set status='$status',endtime=NULL where id='$id'";
|
|
|
}
|
|
|
if($DB->exec($sql)!==false)
|
|
|
exit('{"code":200}');
|
|
|
else
|
|
|
exit('{"code":400,"msg":"修改记录失败！['.$DB->error().']"}');
|
|
|
}
|
|
|
break;
|
|
|
case 'opslist':
|
|
|
$status=$_POST['status'];
|
|
|
$checkbox=$_POST['checkbox'];
|
|
|
$i=0;
|
|
|
foreach($checkbox as $id){
|
|
|
if($status==4){
|
|
|
$sql = "DELETE FROM pre_settle WHERE id='$id'";
|
|
|
}elseif($status==1){
|
|
|
$sql = "update pre_settle set status='$status',endtime='$date',result=NULL where id='$id'";
|
|
|
}else{
|
|
|
$sql = "update pre_settle set status='$status',endtime=NULL where id='$id'";
|
|
|
}
|
|
|
$DB->exec($sql);
|
|
|
$i++;
|
|
|
}
|
|
|
exit('{"code":0,"msg":"成功改变'.$i.'条记录状态"}');
|
|
|
break;
|
|
|
case 'settle_result':
|
|
|
$id=intval($_POST['id']);
|
|
|
$row=$DB->getRow("select result from pre_settle where id='$id' limit 1");
|
|
|
if(!$row)
|
|
|
exit('{"code":-1,"msg":"当前结算记录不存在！"}');
|
|
|
$result = ['code'=>0,'msg'=>'succ','result'=>$row['result']];
|
|
|
exit(json_encode($result));
|
|
|
break;
|
|
|
case 'settle_setresult':
|
|
|
$id=intval($_POST['id']);
|
|
|
$result=trim($_POST['result']);
|
|
|
$row=$DB->getRow("select * from pre_settle where id='$id' limit 1");
|
|
|
if(!$row)
|
|
|
exit('{"code":-1,"msg":"当前结算记录不存在！"}');
|
|
|
$sds = $DB->exec("UPDATE pre_settle SET result='$result' WHERE id='$id'");
|
|
|
if($sds!==false)
|
|
|
exit('{"code":0,"msg":"修改成功！"}');
|
|
|
else
|
|
|
exit('{"code":-1,"msg":"修改失败！'.$DB->error().'"}');
|
|
|
break;
|
|
|
case 'settle_info':
|
|
|
$id=intval($_GET['id']);
|
|
|
$rows=$DB->getRow("select * from pre_settle where id='$id' limit 1");
|
|
|
if(!$rows)
|
|
|
exit('{"code":-1,"msg":"当前结算记录不存在！"}');
|
|
|
$data = '<div class="form-group"><div class="input-group"><div class="input-group-addon">结算方式</div><select class="form-control" id="pay_type" default="'.$rows['type'].'">'.($conf['settle_alipay']?'<option value="1">支付宝</option>':null).''.($conf['settle_wxpay']?'<option value="2">微信</option>':null).''.($conf['settle_qqpay']?'<option value="3">QQ钱包</option>':null).''.($conf['settle_bank']?'<option value="4">银行卡</option>':null).'</select></div></div>';
|
|
|
$data .= '<div class="form-group"><div class="input-group"><div class="input-group-addon">结算账号</div><input type="text" id="pay_account" value="'.$rows['account'].'" class="form-control" required/></div></div>';
|
|
|
$data .= '<div class="form-group"><div class="input-group"><div class="input-group-addon">真实姓名</div><input type="text" id="pay_name" value="'.$rows['username'].'" class="form-control" required/></div></div>';
|
|
|
$data .= '<input type="submit" id="save" onclick="saveInfo('.$id.')" class="btn btn-primary btn-block" value="保存">';
|
|
|
$result=array("code"=>0,"msg"=>"succ","data"=>$data,"pay_type"=>$rows['type']);
|
|
|
exit(json_encode($result));
|
|
|
break;
|
|
|
case 'settle_save':
|
|
|
$id=intval($_POST['id']);
|
|
|
$pay_type=intval($_POST['pay_type']);
|
|
|
$pay_account=htmlspecialchars(trim($_POST['pay_account']));
|
|
|
$pay_name=htmlspecialchars(trim($_POST['pay_name']));
|
|
|
$data = ['type'=>$pay_type, 'account'=>$pay_account, 'username'=>$pay_name];
|
|
|
if($DB->update('settle', $data, ['id'=>$id])!==false)
|
|
|
exit('{"code":0,"msg":"修改记录成功！"}');
|
|
|
else
|
|
|
exit('{"code":-1,"msg":"修改记录失败！'.$DB->error().'"}');
|
|
|
break;
|
|
|
case 'paypwd_check':
|
|
|
if(isset($_SESSION['paypwd']) && $_SESSION['paypwd']==$conf['admin_paypwd'])
|
|
|
exit('{"code":0,"msg":"ok"}');
|
|
|
else
|
|
|
exit('{"code":-1,"msg":"error"}');
|
|
|
break;
|
|
|
case 'paypwd_input':
|
|
|
$paypwd=trim($_POST['paypwd']);
|
|
|
if(!$conf['admin_paypwd'])exit('{"code":-1,"msg":"你还未设置支付密码"}');
|
|
|
if($paypwd == $conf['admin_paypwd']){
|
|
|
$_SESSION['paypwd'] = $paypwd;
|
|
|
exit('{"code":0,"msg":"ok"}');
|
|
|
}else{
|
|
|
exit('{"code":-1,"msg":"支付密码错误！"}');
|
|
|
}
|
|
|
break;
|
|
|
case 'paypwd_reset':
|
|
|
unset($_SESSION['paypwd']);
|
|
|
exit('{"code":0,"msg":"ok"}');
|
|
|
break;
|
|
|
|
|
|
case 'transfer':
|
|
|
$id = isset($_POST['id'])?intval($_POST['id']):exit('{"code":-1,"msg":"ID不能为空"}');
|
|
|
$type = isset($_POST['type'])?intval($_POST['type']):exit('{"code":-1,"msg":"type不能为空"}');
|
|
|
|
|
|
$payee_err_code = [
|
|
|
'PAYEE_NOT_EXIST','PAYEE_ACCOUNT_STATUS_ERROR','CARD_BIN_ERROR','PAYEE_CARD_INFO_ERROR','PERM_AML_NOT_REALNAME_REV','PAYEE_USER_INFO_ERROR','PAYEE_ACC_OCUPIED','PERMIT_NON_BANK_LIMIT_PAYEE','PAYEE_TRUSTEESHIP_ACC_OVER_LIMIT','PAYEE_ACCOUNT_NOT_EXSIT','PAYEE_USERINFO_STATUS_ERROR','TRUSTEESHIP_RECIEVE_QUOTA_LIMIT','EXCEED_LIMIT_UNRN_DM_AMOUNT','INVALID_CARDNO','RELEASE_USER_FORBBIDEN_RECIEVE','PAYEE_USER_TYPE_ERROR','PAYEE_NOT_RELNAME_CERTIFY','PERMIT_LIMIT_PAYEE',
|
|
|
|
|
|
'OPENID_ERROR','NAME_MISMATCH','V2_ACCOUNT_SIMPLE_BAN','MONEY_LIMIT','EXCEED_PAYEE_ACCOUNT_LIMIT','PAYEE_ACCOUNT_ABNORMAL','APPID_OR_OPENID_ERR',
|
|
|
|
|
|
'REALNAME_CHECK_ERROR','RE_USER_NAME_CHECK_ERROR','ERR_TJ_BLACK','USER_FROZEN','TRANSFER_FAIL','TRANSFER_FEE_LIMIT_ERROR',
|
|
|
|
|
|
'ACCOUNT_FROZEN','REAL_NAME_CHECK_FAIL','NAME_NOT_CORRECT','OPENID_INVALID','TRANSFER_QUOTA_EXCEED','DAY_RECEIVED_QUOTA_EXCEED','MONTH_RECEIVED_QUOTA_EXCEED','DAY_RECEIVED_COUNT_EXCEED','ID_CARD_NOT_CORRECT','ACCOUNT_NOT_EXIST','TRANSFER_RISK','REALNAME_ACCOUNT_RECEIVED_QUOTA_EXCEED','RECEIVE_ACCOUNT_NOT_PERMMIT','PAYEE_ACCOUNT_ABNORMAL','BLOCK_B2C_USERLIMITAMOUNT_BSRULE_MONTH','BLOCK_B2C_USERLIMITAMOUNT_MONTH',
|
|
|
];
|
|
|
|
|
|
if(!isset($_SESSION['paypwd']) || $_SESSION['paypwd']!==$conf['admin_paypwd'])exit('{"code":-1,"msg":"支付密码错误，请返回重新进入该页面"}');
|
|
|
|
|
|
$row=$DB->getRow("SELECT * FROM pre_settle WHERE id='{$id}' limit 1");
|
|
|
if(!$row)exit('{"code":-1,"msg":"记录不存在"}');
|
|
|
if($row['type']!=$type)exit('{"code":-1,"msg":"转账类型不正确"}');
|
|
|
|
|
|
if($row['transfer_status']==1)exit('{"code":0,"ret":2,"result":"转账订单号:'.$row['transfer_result'].' 支付时间:'.$row['transfer_date'].'"}');
|
|
|
|
|
|
if($type == 1){
|
|
|
$app = 'alipay';
|
|
|
$channel = \lib\Channel::get($conf['transfer_alipay']);
|
|
|
}elseif($type == 2){
|
|
|
$app = 'wxpay';
|
|
|
$channel = \lib\Channel::get($conf['transfer_wxpay']);
|
|
|
}elseif($type == 3){
|
|
|
$app = 'qqpay';
|
|
|
$channel = \lib\Channel::get($conf['transfer_qqpay']);
|
|
|
}elseif($type == 4){
|
|
|
$app = 'bank';
|
|
|
$channel = \lib\Channel::get($conf['transfer_bank']);
|
|
|
}
|
|
|
if(!$channel)exit('{"code":-1,"msg":"当前支付通道信息不存在"}');
|
|
|
|
|
|
$out_biz_no = date("Ymd").'000'.$id;
|
|
|
$result = \lib\Transfer::submit($app, $channel, $out_biz_no, $row['account'], $row['username'], $row['realmoney']);
|
|
|
|
|
|
if($result['code']==0){
|
|
|
$data['code']=0;
|
|
|
$data['ret']=1;
|
|
|
$data['result']='转账订单号:'.$result['orderid'].' 支付时间:'.$result['paydate'];
|
|
|
$DB->update('settle', ['status'=>1, 'endtime'=>'NOW()', 'transfer_status'=>1, 'transfer_result'=>$result["orderid"], 'transfer_date'=>$result["paydate"]], ['id'=>$id]);
|
|
|
|
|
|
\lib\MsgNotice::send('settle', $row['uid'], ['money'=>$row['money'], 'realmoney'=>$row['realmoney'], 'time'=>date('Y-m-d H:i:s'), 'account'=>$row['account']]);
|
|
|
} else {
|
|
|
if(in_array($result['errcode'], $payee_err_code)){
|
|
|
$data['code']=0;
|
|
|
$data['ret']=0;
|
|
|
$data['result']='转账失败 '.$result['msg'];
|
|
|
$DB->update('settle', ['status'=>3, 'result'=>$result["msg"], 'transfer_status'=>2, 'transfer_result'=>$data['result']], ['id'=>$id]);
|
|
|
}else{
|
|
|
$data['code']=-1;
|
|
|
$data['msg']=$result['msg'];
|
|
|
}
|
|
|
}
|
|
|
exit(json_encode($data));
|
|
|
break;
|
|
|
|
|
|
default:
|
|
|
exit('{"code":-4,"msg":"No Act"}');
|
|
|
break;
|
|
|
} |
