api.php act orders,api.php · 深圳市龙岗区余生网络工作室/酷享云支付 - Gitee.com

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 endtimefetchColumn();

//$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);

?>

一键复制

编辑

Web IDE

原始数据

按行查看

历史

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值