https://docs./api_1/alipay.trade.query
<?php/* ** 功能：支付宝服务器异步通知页面* 版本：2.0* 修改日期：-11-01* 说明：* 以下代码只是为了方便商户测试而提供的样例代码，商户可以根据自己网站的需要，按照技术文档编写,并非一定要使用该代码。*************************页面功能说明************************** 创建该页面文件时，请留心该页面文件中无任何HTML代码及空格。* 该页面不能在本机电脑测试，请到服务器上做测试。请确保外部可以访问该页面。* 如果没有收到该页面返回的 success 信息，支付宝会在24小时内按一定的时间策略重发通知*/include('../../include/common.inc.php');include('../sdkFunction.php');require_once("alipay.config.php");require_once("wappay/service/AlipayTradeService.php");require_once("wappay/buildermodel/AlipayTradeQueryContentBuilder.php");$alipay_config['notify_url'] = '';if(CONF_MODE=='official'){$alipay_config['notify_url'] = '/sdk/alipay_v2/notify_url.php';}else{$alipay_config['notify_url'] = 'http://t./sdk/alipay_v2/notify_url.php';}$alipaySevice = new AlipayTradeService($alipay_config);function zfbHandle(){global $alipaySevice;$arr = $_POST;/* 实际验证过程建议商户添加以下校验。1、商户需要验证该通知数据中的out_trade_no是否为商户系统中创建的订单号，2、判断total_amount是否确实为该订单的实际金额（即商户订单创建时的金额），3、校验通知中的seller_id（或者seller_email) 是否为out_trade_no这笔单据的对应的操作方（有的时候，一个商户可能有多个seller_id/seller_email）4、验证app_id是否为该商户本身。*/$result = 1;if ($result) {//验证成功///请在这里加上商户的业务逻辑程序代//——请根据您的业务逻辑来编写程序（以下代码仅作参考）——//获取支付宝的通知返回参数，可参考技术文档中服务器异步通知参数列表//商户订单号$out_trade_no = $_POST['out_trade_no'];//支付宝交易号$trade_no = $_POST['trade_no'];//交易状态$trade_status = $_POST['trade_status'];//充值金额$amount = intval($_POST['total_amount']);if ($_POST['trade_status'] == 'TRADE_FINISHED') {//判断该笔订单是否在商户网站中已经做过处理//如果没有做过处理，根据订单号（out_trade_no）在商户网站的订单系统中查到该笔订单的详细，并执行商户的业务程序//请务必判断请求时的total_amount与通知时获取的total_fee为一致的//如果有做过处理，不执行商户的业务程序//注意：//退款日期超过可退款期限后（如三个月可退款），支付宝系统发送该交易状态通知} else if ($_POST['trade_status'] == 'TRADE_SUCCESS') {//判断该笔订单是否在商户网站中已经做过处理//如果没有做过处理，根据订单号（out_trade_no）在商户网站的订单系统中查到该笔订单的详细，并执行商户的业务程序//请务必判断请求时的total_amount与通知时获取的total_fee为一致的//如果有做过处理，不执行商户的业务程序//注意：//付款完成后，支付宝系统发送该交易状态通知$check_sql = "select amount,status from cy_pay where orderid='" . $_REQUEST['out_trade_no'] . "'";$check_rs = mysql_query($check_sql);$check_data = array();while ($check_row = mysql_fetch_assoc($check_rs)) {$check_data = $check_row;}//验证订单数额的一致性if ($check_data['amount'] == $amount) {$sql = "UPDATE cy_pay SET status=1,beizhu='" . $_REQUEST['trade_no'] . "' WHERE orderid='" . $_REQUEST['out_trade_no'] . "'";$rs = mysql_query($sql);//通知游戏方if ($rs) {$sql_info = "UPDATE cy_paycpinfo SET payflag=1 where orderid='" . $_REQUEST['out_trade_no'] . "'";$rs_info = mysql_query($sql_info);$sql_info = "select fcallbackurl,params,status,type from cy_paycpinfo where orderid='" . $_REQUEST['out_trade_no'] . "'";$rs_info = mysql_query($sql_info);$data = array();while ($row = mysql_fetch_assoc($rs_info)) {$data = $row;}$fcallbackurl = $data['fcallbackurl'];$params = $data['params'];$status = $data['status'];$device = $data['type'];if ($status == 0) {$i = 0;$result = true;while ($result) {$cp_rs = $alipaySevice->payback($fcallbackurl, $params, 'post');if ($cp_rs) {$time = time();$sql_cp = "UPDATE cy_paycpinfo SET status=1,update_time='" . $time . "' where orderid='" . $_REQUEST['out_trade_no'] . "'";$rs_cp = mysql_query($sql_cp);$result = false;} else {$i++;sleep(2);$result = true;}if ($i == 5) {$result = false;}}}//判断是否已录入$sql = "select * from cy_pay_ok where orderid='" . $_REQUEST['out_trade_no'] . "'";$has_info = mysql_query($sql);$has_data = array();while ($row = mysql_fetch_assoc($has_info)) {$has_data = $row;}if (!$has_data) {//录入pay_ok$sql_info = "select * from cy_pay where orderid='" . $_REQUEST['out_trade_no'] . "'";$rs_info = mysql_query($sql_info);$data = array();while ($row = mysql_fetch_assoc($rs_info)) {$data = $row;}//取渠道信息$cps_user_sql = "select id,username,agent,one_agent,one_username,second_agent,second_username from cy_ct_cps_user where agent='" . $data['regagent'] . "'";$cps_user_info = mysql_query($cps_user_sql);$cps_data = array();while ($row = mysql_fetch_assoc($cps_user_info)) {$cps_data = $row;}$data['second_agent'] = $cps_data['second_agent'];$data['second_username'] = $cps_data['second_username'];$data['one_agent'] = $cps_data['one_agent'];$data['one_username'] = $cps_data['one_username'];$data['agent_username'] = $cps_data['username'];//游戏名字$game_sql = "select id,name from cy_game where id='" . $data['gameid'] . "'";$game_info = mysql_query($game_sql);$game_data = array();while ($row = mysql_fetch_assoc($game_info)) {$game_data = $row;}$data['gamename'] = $game_data['name'];$sql = "insert into cy_pay_ok (orderid,amount,username,roleid,paytype,serverid,servername,gameid,gamename,ip,imeil,create_time,agent,regagent,agent_username,prvite,second_agent,second_username,one_agent,one_username,type,attach) value ('{$data['orderid']}','{$data['amount']}','{$data['username']}','{$data['roleid']}','{$data['paytype']}','{$data['serverid']}','{$data['servername']}','{$data['gameid']}','{$data['gamename']}','{$data['ip']}','{$data['imeil']}','{$data['create_time']}','{$data['agent']}','{$data['regagent']}','{$data['agent_username']}','{$data['prvite']}','{$data['second_agent']}','{$data['second_username']}','{$data['one_agent']}','{$data['one_username']}','{$device}','{$data['attach']}')";$rs = mysql_query($sql);}}}echo "success"; //请不要修改或删除}//——请根据您的业务逻辑来编写程序（以上代码仅作参考）——} else {//验证失败echo "fail"; //请不要修改或删除}}set_time_limit(0);$sql = "select id,orderid from cy_pay where (beizhu is null or beizhu='') and paytype='zfb' order by id desc limit 1";$info = mysql_query($sql);while ($row = mysql_fetch_assoc($info)) {$builder = new AlipayTradeQueryContentBuilder();$builder->setOutTradeNo($row['orderid']);$response = $alipaySevice->Query($builder);$res = json_decode(json_encode($response),true);$code = $res['code'];$tradeStatus = $res['trade_status'];if($res['code']==10000&&$tradeStatus=='TRADE_SUCCESS'){$_POST['out_trade_no'] = $res['out_trade_no'];$_POST['trade_no'] = $res['trade_no'];$_POST['trade_status'] = $res['trade_status'];$_POST['total_amount'] = $res['total_amount'];$_REQUEST = $_POST;zfbHandle();}}?>
