"TVDV", "UID"=>"sa", "PWD"=>"1382929319", "CharacterSet"=>"UTF-8");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
//echo "数据库连接成功.
";
}else{
echo "数据库连接失败!!
";
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"."
";
}else{
echo $id." NOT OK"."
";
}
/* printf_info(WxPayApi::refund($input));
if ($res['result_code']=="SUCCESS"){
echo "
订单退款完成";
} else {
echo "
".$res['err_code_des'];
}
//var_dump($x);
exit(); */
}
?>