"TVDV", "UID"=>"sa", "PWD"=>"1382929319", "CharacterSet"=>"UTF-8");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
//echo "数据库连接成功.
";
}else{
echo "数据库连接失败!!
";
die( print_r( sqlsrv_errors(), true));
}
$key='apivcomcn20170421';
//初始化日志
$logHandler= new CLogFileHandler("../logs/".date('Y-m-d').'.log');
$log = Log::Init($logHandler, 15);
// var_dump($_REQUEST);exit;
$ShopOrdID = $_REQUEST["ShopOrdID"];
$url = "Check_Order.php?ShopOrdID=$ShopOrdID";
if(empty($_REQUEST["transaction_id"]) && empty($_REQUEST["out_trade_no"])){
echo "";exit;
}
if(isset($_REQUEST["transaction_id"]) && $_REQUEST["transaction_id"] != ""){
$transaction_id = $_REQUEST["transaction_id"];
$input = new WxPayOrderQuery();
$input->SetTransaction_id($transaction_id);
$result=WxPayApi::orderQuery($input);
$transaction_id = $result["transaction_id"];
$countid = 0;
$check_sql = "select count(id) as countid from dbo.userMoney where pay_transactionID='$transaction_id'";
$check_go = sqlsrv_query($conn,$check_sql);
while($checks = sqlsrv_fetch_array( $check_go, SQLSRV_FETCH_ASSOC) ) {
$countid = $checks["countid"];
}
// var_dump($countid);exit;
if($countid > 0){
echo "";exit;
}
if($countid == 0){
$method = "Order_PayNotify";
$total_fee = ($result["cash_fee"])/100;
$mch_id = $result["mch_id"];
$out_trade_no = $result["out_trade_no"];
$PayMono = urlencode("微信支付");
$arr = array("method"=>$method,"ShopOrdID"=>$ShopOrdID,"total_fee"=>$total_fee,"mch_id"=>$mch_id,"out_trade_no"=>$out_trade_no,"PayMono"=>$PayMono,"transaction_id"=>$transaction_id);
ksort($arr);
$i=0;
$stringA='';
foreach($arr as $k=>$v){
$stringA=$stringA.$k.$v;
}
$stringSignTemp=$stringA.$key;
$stringSignTemp=str_replace(" ", "%20", $stringSignTemp);
$sign=MD5($stringSignTemp);
$content = 'method='.$method.'&ShopOrdID='.$ShopOrdID.'&total_fee='.$total_fee.'&mch_id='.$mch_id.'&out_trade_no='.$out_trade_no.'&PayMono='.$PayMono.'&transaction_id='.$transaction_id;
$content .= '&Sign='.$sign;
$order_url='http://api.v.com.cn/order/?'.$content;
$order_url=str_replace(" ", "%20", $order_url);
// var_dump($url);exit;
$orderinfo=file_get_contents($order_url);
$orderinfo=json_decode($orderinfo,true);
// var_dump($orderinfo);exit;
if($orderinfo["result"] == 1){
echo "";exit;
}
}
}
if(isset($_REQUEST["out_trade_no"]) && $_REQUEST["out_trade_no"] != ""){
$out_trade_no = $_REQUEST["out_trade_no"];
$input = new WxPayOrderQuery();
$input->SetOut_trade_no($out_trade_no);
// printf_info(WxPayApi::orderQuery($input));
$result=WxPayApi::orderQuery($input);
// var_dump($result);exit();
$transaction_id = $result["transaction_id"];
$countid = 0;
$check_sql = "select count(id) as countid from dbo.userMoney where pay_transactionID='$transaction_id'";
$check_go = sqlsrv_query($conn,$check_sql);
while($checks = sqlsrv_fetch_array( $check_go, SQLSRV_FETCH_ASSOC) ) {
$countid = $checks["countid"];
}
// var_dump($countid);exit;
if($countid > 0){
echo "";exit;
}
if($countid == 0){
$method = "Order_PayNotify";
$total_fee = ($result["cash_fee"])/100;
$mch_id = $result["mch_id"];
$out_trade_no = $result["out_trade_no"];
$PayMono = urlencode("微信支付");
$arr = array("method"=>$method,"ShopOrdID"=>$ShopOrdID,"total_fee"=>$total_fee,"mch_id"=>$mch_id,"out_trade_no"=>$out_trade_no,"PayMono"=>$PayMono,"transaction_id"=>$transaction_id);
ksort($arr);
$i=0;
$stringA='';
foreach($arr as $k=>$v){
$stringA=$stringA.$k.$v;
}
$stringSignTemp=$stringA.$key;
$stringSignTemp=str_replace(" ", "%20", $stringSignTemp);
$sign=MD5($stringSignTemp);
$content = 'method='.$method.'&ShopOrdID='.$ShopOrdID.'&total_fee='.$total_fee.'&mch_id='.$mch_id.'&out_trade_no='.$out_trade_no.'&PayMono='.$PayMono.'&transaction_id='.$transaction_id;
$content .= '&Sign='.$sign;
$order_url='http://api.v.com.cn/order/?'.$content;
$order_url=str_replace(" ", "%20", $order_url);
// var_dump($url);exit;
$orderinfo=file_get_contents($order_url);
$orderinfo=json_decode($orderinfo,true);
if($orderinfo["result"] == 1){
echo "";exit;
}
}
}
?>