<?php
|
ini_set('date.timezone','Asia/Shanghai');
|
error_reporting(E_ERROR);
|
require_once "../lib/WxPay.Api.php";
|
$serverName = "120.24.159.70";//服务器的名字，本地localhost
|
$connectionInfo = array( "Database"=>"TVDV", "UID"=>"sa", "PWD"=>"1382929319", "CharacterSet"=>"UTF-8");
|
$conn = sqlsrv_connect( $serverName, $connectionInfo);
|
if( $conn ) {
|
//echo "数据库连接成功.<br />";
|
}else{
|
echo "数据库连接失败!!<br />";
|
die( print_r( sqlsrv_errors(), true));
|
}
|
$ids = explode(",",$_REQUEST["ids"]);
|
|
foreach($ids as $id){
|
$sql = "select UserID,strOrdIDMO,userMoney,mono from TVDV.dbo.userMoney where strOrdIDMO=$id and MoneyType=0 and mono like '微信支付%'";
|
// var_dump($sql);
|
$info_go = sqlsrv_query($conn,$sql);
|
|
while($infos = sqlsrv_fetch_array( $info_go, SQLSRV_FETCH_ASSOC) ) {
|
// var_dump($infos);
|
$info = $infos;
|
}
|
$transaction_id = str_replace("微信支付","",$info["mono"]);
|
// var_dump($transaction_id);
|
$userMoney = $info["userMoney"];
|
$total_fee = $userMoney*100;
|
$refund_fee = $userMoney*100;
|
$input = new WxPayRefund();
|
$input->SetTransaction_id($transaction_id);
|
$input->SetTotal_fee($total_fee);
|
$input->SetRefund_fee($refund_fee);
|
$input->SetOut_refund_no(WxPayConfig::MCHID.date("YmdHis"));
|
$input->SetOp_user_id(WxPayConfig::MCHID);
|
// var_dump($input);exit;
|
$res = WxPayApi::refund($input);
|
// var_dump($res);exit;
|
if ($res['result_code']=="SUCCESS"){
|
$insert_sql = "Insert into TVDV.dbo.userMoney (UserID,strOrdIDMO,UserMoney,mono,Operation,time1) values ('$id',$id,-$userMoney,'微信支付$transaction_id','系统',getdate())";
|
sqlsrv_query($conn,$insert_sql);
|
|
$update_sql = "update TVDV.dbo.ERP_ShopOrd set DiscountMoney=$userMoney,AcceptMoney=0 where ShopOrdID=$id";
|
sqlsrv_query($conn,$update_sql);
|
echo $id." OK"."<br />";
|
}else{
|
echo $id." NOT OK"."<br />";
|
}
|
/* printf_info(WxPayApi::refund($input));
|
if ($res['result_code']=="SUCCESS"){
|
echo "<br>订单退款完成";
|
} else {
|
echo "<br>".$res['err_code_des'];
|
}
|
//var_dump($x);
|
exit(); */
|
}
|
|
|
|
|
|
|
|
|
?>
|
