代码拉取完成，页面将自动刷新
<?php
require './includes/common.php';
$act=isset($_GET['act'])?daddslashes($_GET['act']):null;
$url=daddslashes($_GET['url']);
$authcode=daddslashes($_GET['authcode']);
if($act=='add')
{
exit('{"code":-4,"msg":"当前接口仅作为备用接口使用"}');
$type=1;
$key = random(32);
$sds=$DB->exec("INSERT INTO `pay_user` (`key`, `url`, `addtime`, `type`, `active`) VALUES ('{$key}', '{$url}', '{$date}', '{$type}', '1')");
$pid=$DB->lastInsertId();
if($sds){
$result=array("code"=>1,"msg"=>"添加支付商户成功！","pid"=>$pid,"key"=>$key,"type"=>$type);
}else{
$result=array("code"=>-1,"msg"=>"添加支付商户失败！");
}
}
elseif($act=='apply')
{
$token=daddslashes($_GET['token']);
$row=$DB->query("SELECT * FROM panel_user WHERE token='{$token}' limit 1")->fetch();
if($row && $row['active']==1){
$type=0;
$key = random(32);
$sds=$DB->exec("INSERT INTO `pay_user` (`key`, `url`, `addtime`, `type`, `active`, `uid`) VALUES ('{$key}', '{$url}', '{$date}', '{$type}', '1', '{$row['id']}')");
$pid=$DB->lastInsertId();
if($sds){
$result=array("code"=>1,"msg"=>"添加支付商户成功！","pid"=>$pid,"key"=>$key,"type"=>$type);
}else{
$result=array("code"=>-1,"msg"=>"添加支付商户失败！");
}
}else{
$result=array("code"=>-1,"msg"=>"TOKEN ERROR");
}
}
elseif($act=='query')
{
$pid=intval($_GET['pid']);
$key=daddslashes($_GET['key']);
$row=$DB->query("SELECT * FROM pay_user WHERE id='{$pid}' limit 1")->fetch();
if($row){
if($key==$row['key']){
$orders=$DB->query("SELECT count(*) from pay_order WHERE pid={$pid}")->fetchColumn();
$lastday=date("Y-m-d",strtotime("-1 day")).' 00:00:00';
$today=date("Y-m-d").' 00:00:00';
$order_today=$DB->query("SELECT sum(money) from pay_order where pid={$pid} and status=1 and endtime>='$today'")->fetchColumn();
$order_lastday=$DB->query("SELECT sum(money) from pay_order where pid={$pid} and status=1 and endtime>='$lastday' and endtime<'$today'")->fetchColumn();
//$settle_money=$DB->query("SELECT sum(money) from pay_settle where pid={$pid} and status=1")->fetchColumn();
$result=array("code"=>1,"pid"=>$pid,"key"=>$key,"type"=>$row['settle_id'],"active"=>$row['active'],"qq"=>$row['qq'],"money"=>$row['money'],"account"=>$row['account'],"username"=>$row['username'],"settle_money"=>$conf['settle_money'],"settle_fee"=>$conf['settle_fee'],"money_rate"=>$conf['money_rate'],"orders"=>$orders,"order_today"=>$order_today,"order_lastday"=>$order_lastday,"settle_money"=>$settle_money);
}else{
$result=array("code"=>-2,"msg"=>"KEY校验失败");
}
}else{
$result=array("code"=>-3,"msg"=>"PID不存在");
}
}
elseif($act=='change')
{
$pid=intval($_GET['pid']);
$key=daddslashes($_GET['key']);
$stype=daddslashes($_GET['type']);
$account=daddslashes($_GET['account']);
$username=daddslashes($_GET['username']);
$row=$DB->query("SELECT * FROM pay_user WHERE id='{$pid}' limit 1")->fetch();
if($row){
if($key==$row['key']){
if($account==null || $username==null){
$result=array("code"=>-1,"msg"=>"保存错误,请确保每项都不为空!");
}elseif($row['type']!=2 && !empty($row['account']) && !empty($row['username']) && $row['account']!=$account){
$result=array("code"=>-1,"msg"=>"为保障您的资金安全，暂不支持直接修改结算账号信息，如需修改请联系QQ".$conf['web_qq']);
}else{
$type=1;
$sds=$DB->exec("update `pay_user` set `account`='{$account}',`username`='{$username}',`type`='{$type}',`settle_id`='{$stype}',`url`='{$url}' where id='{$pid}' limit 1");
if($sds>=0){
$result=array("code"=>1,"msg"=>"修改收款账号成功！","pid"=>$pid,"key"=>$key,"type"=>$type);
}else{
$result=array("code"=>-1,"msg"=>"修改收款账号失败！");
}
}
}else{
$result=array("code"=>-2,"msg"=>"KEY校验失败");
}
}else{
$result=array("code"=>-3,"msg"=>"PID不存在");
}
}
elseif($act=='settle')
{
$pid=intval($_GET['pid']);
$key=daddslashes($_GET['key']);
$limit=$_GET['limit']?intval($_GET['limit']):10;
$page=$_GET['page']?intval($_GET['page']):1;
$page=($page-1) * $limit;
if($limit>50)$limit=50;
$row=$DB->query("SELECT * FROM pay_user WHERE id='{$pid}' limit 1")->fetch();
if($row){
if($key==$row['key']){
$rs=$DB->query("SELECT * FROM pay_settle WHERE pid='{$pid}' order by id desc limit {$page},{$limit}");
while($row=$rs->fetch()){
$data[]=$row;
}
if($rs){
$result=array("code"=>1,"msg"=>"查询结算记录成功！","pid"=>$pid,"key"=>$key,"type"=>$type,"data"=>$data);
}else{
$result=array("code"=>-1,"msg"=>"查询结算记录失败！");
}
}else{
$result=array("code"=>-2,"msg"=>"KEY校验失败");
}
}else{
$result=array("code"=>-3,"msg"=>"PID不存在");
}
}
elseif($act=='order')
{
$pid=intval($_GET['pid']);
$key=daddslashes($_GET['key']);
$rs=$DB->query("SELECT * FROM pay_user WHERE id='{$pid}' limit 1")->fetch();
if($rs){
if($key==$row['key']){
$out_trade_no=daddslashes($_GET['out_trade_no']);
$row=$DB->query("SELECT * FROM pay_order WHERE out_trade_no='{$out_trade_no}' limit 1")->fetch();
if($row){
$result=array("code"=>1,"msg"=>"查询订单号成功！","trade_no"=>$row['trade_no'],"out_trade_no"=>$row['out_trade_no'],"type"=>$row['type'],"pid"=>$row['pid'],"addtime"=>$row['addtime'],"endtime"=>$row['endtime'],"name"=>$row['name'],"money"=>$row['money'],"status"=>$row['status']);
}else{
$result=array("code"=>-1,"msg"=>"订单号不存在");
}
}else{
$result=array("code"=>-2,"msg"=>"KEY校验失败");
}
}else{
$result=array("code"=>-3,"msg"=>"PID不存在");
}
}
elseif($act=='orders')
{
$pid=intval($_GET['pid']);
$key=daddslashes($_GET['key']);
$limit=$_GET['limit']?intval($_GET['limit']):10;
$page=$_GET['page']?intval($_GET['page']):1;
$page=($page-1) * $limit;
if($limit>50)$limit=50;
$row=$DB->query("SELECT * FROM pay_user WHERE id='{$pid}' limit 1")->fetch();
if($row){
if($key==$row['key']){
$rs=$DB->query("SELECT * FROM pay_order WHERE pid='{$pid}' order by trade_no desc limit {$page},{$limit}");
while($row=$rs->fetch()){
$data[]=$row;
}
if($rs){
$result=array("code"=>1,"msg"=>"查询订单记录成功！","data"=>$data);
}else{
$result=array("code"=>-1,"msg"=>"查询订单记录失败！");
}
}else{
$result=array("code"=>-2,"msg"=>"KEY校验失败");
}
}else{
$result=array("code"=>-3,"msg"=>"PID不存在");
}
}
elseif($act=='search_orders')
{
$pid=intval($_GET['pid']);
$key=daddslashes($_GET['key']);
$limit=$_GET['limit']?intval($_GET['limit']):10;
$page=$_GET['page']?intval($_GET['page']):1;
$page=($page-1) * $limit;
$type=$_GET['type']?$_GET['type']:"name";
$text=$_GET['text'];
if($limit>50)$limit=50;
$row=$DB->query("SELECT * FROM pay_user WHERE id='{$pid}' limit 1")->fetch();
if($row){
if($key==$row['key']){
if($type=="out_trade_no"){
$rs=$DB->query("SELECT * FROM pay_order WHERE out_trade_no LIKE '%{$text}%' order by trade_no desc limit {$page},{$limit}");
}elseif($type=="name"){
$rs=$DB->query("SELECT * FROM pay_order WHERE name LIKE '%{$text}%' order by trade_no desc limit {$page},{$limit}");
}
while($row=$rs->fetch()){
$data[]=$row;
}
if($rs){
$result=array("code"=>1,"msg"=>"搜索订单记录成功！","data"=>$data);
}else{
$result=array("code"=>-1,"msg"=>"搜索订单记录失败！");
}
}else{
$result=array("code"=>-2,"msg"=>"KEY校验失败");
}
}else{
$result=array("code"=>-3,"msg"=>"PID不存在");
}
}
else
{
$result=array("code"=>-5,"msg"=>"No Act!");
}
echo json_encode($result);
?>
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。