public function checkRechaMoneyStatus()
{
$db = new DB_test();
$arr_header = $this->arr_header;
$arr_body = $this->arr_body;
$arr_channelinfo = $this->arr_channelinfo;
$bkntno = trim($arr_body['bkntno']);
//交易流水号
//$paycardid = trim(GetPayCalcuInfo::readpaycardid($arr_body['paycardid'])); //刷卡器设备号
$authorid = trim($arr_channelinfo['authorid']);
//authorid
$result = $arr_body['result'];
$nowdate = date("Y-m-d H:i:s");
//手机卡充值业务
$query = "select fd_mrclist_bkordernumber as bkordernumber,fd_mrclist_authorid as authorid ,\n fd_mrclist_date as orderdate ,DATE_FORMAT(fd_mrclist_date,'%Y%m%d') as orderTime,\n fd_mrclist_qq as qq\n from tb_qqrechargelist\n where 1 and fd_mrclist_bkntno = '{$bkntno}' and fd_mrclist_authorid = '{$authorid}' limit 1";
$arr_val = $db->get_one($query);
$orderNumber = $arr_val['bkordernumber'];
$orderTime = $arr_val['orderTime'];
$arr_returninfo = BankPayInfo::bankorderquery($authorid, '', $orderNumber, $orderTime);
$arr_returninfo = $this->Publiccls->xml_to_array($arr_returninfo);
// print_r($arr_returninfo);
// exit;
if (!is_array($arr_returninfo)) {
$arr_message = array("result" => "failure", "message" => "请等待,正在为您充值中!");
$retcode = "200";
//反馈状态 0 成功 200 自定义错误
} else {
$of_retcode = $arr_returninfo['orderinfo']['retcode'];
//欧飞接口1为成功 跟我们自己的成功 0
if ($of_retcode == 1) {
$retcode = 0;
//反馈状态 0 成功 200 自定义错误
$arr_message = array("result" => "success", "message" => $arr_returninfo['orderinfo']['err_msg']);
} else {
$retcode = $of_retcode;
//反馈状态 0 成功 200 自定义错误
$arr_message = array("result" => "failure", "message" => $arr_returninfo['orderinfo']['err_msg']);
}
}
$arr_msg['msgbody']['result'] = $arr_message['result'];
$arr_msg['msgbody']['message'] = $arr_message['message'];
$returnvalue = array("msgbody" => $arr_msg['msgbody']);
$returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
return $returnval;
}
public function orderPayrqStatus()
{
$db = new DB_test();
$arr_header = $this->arr_header;
$arr_body = $this->arr_body;
$arr_channelinfo = $this->arr_channelinfo;
$bkntno = trim($arr_body['bkntno']);
//交易流水号
//$paycardid = trim(GetPayCalcuInfo::readpaycardid($arr_body['paycardid'])); //刷卡器设备号
$authorid = trim($arr_channelinfo['authorid']);
//authorid
$result = $arr_body['result'];
$nowdate = date("Y-m-d H:i:s");
//手机卡充值业务
$query = "select fd_orderlist_bkordernumber as bkordernumber,fd_orderlist_authorid as authorid ,\n fd_orderlist_date as orderdate ,DATE_FORMAT(fd_orderlist_date,'%Y%m%d') as orderTime\n from tb_orderglist\n where 1 and fd_orderlist_bkntno = '{$bkntno}' and fd_orderlist_authorid = '{$authorid}' limit 1";
$arr_val = $db->get_one($query);
$orderNumber = $arr_val['bkordernumber'];
$orderTime = $arr_val['orderTime'];
$arr_returninfo = BankPayInfo::bankorderquery($authorid, '', $orderNumber, $orderTime);
$arr_returninfo = $this->Publiccls->xml_to_array($arr_returninfo);
if ($result == 'success') {
$retcode = 0;
//反馈状态 0 成功 200 自定义错误
$arr_message = array("result" => "success", "message" => "订单已支付完成");
} else {
$retcode = 0;
//反馈状态 0 成功 200 自定义错误
$arr_message = array("result" => "success", "message" => "交易已取消");
}
$arr_msg['msgbody']['result'] = $arr_message['result'];
$arr_msg['msgbody']['message'] = $arr_message['message'];
$returnvalue = array("msgbody" => $arr_msg['msgbody']);
$returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
return $returnval;
}
public function insertSupTransferMoney()
{
$db = new DB_test();
$arr_header = $this->arr_header;
$arr_body = $this->arr_body;
$arr_channelinfo = $this->arr_channelinfo;
$bkntno = trim($arr_body['bkntno']);
//银行交易流水号
$authorid = trim($arr_channelinfo['authorid']);
$nowdate = date("Y-m-d H:i:s");
$result = $arr_body['result'];
$query = "select fd_tfmglist_bkordernumber as bkordernumber,fd_tfmglist_authorid as authorid ,\n DATE_FORMAT(fd_tfmglist_paydate,'%Y%m%d') as orderTime\n from tb_transfermoneyglist\n where 1 and fd_tfmglist_bkntno = '{$bkntno}' and fd_tfmglist_authorid = '{$authorid}' limit 1";
$arr_val = $db->get_one($query);
$orderNumber = $arr_val['bkordernumber'];
$orderTime = $arr_val['orderTime'];
$arr_returninfo = BankPayInfo::bankorderquery($authorid, '', $orderNumber, $orderTime);
$arr_returninfo = $this->Publiccls->xml_to_array($arr_returninfo);
if ($result == 'success' && $bkntno != "") {
$query = "update tb_transfermoneyglist set fd_tfmglist_payrq ='00' ,fd_tfmglist_paydate ='{$nowdate}' \n\t\t\t\t\t where fd_tfmglist_bkntno = '{$bkntno}'";
$db->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq = '00' where fd_agpm_bkntno = '{$bkntno}'";
$db->query($query);
$arr_message = array("result" => "success", "message" => "支付成功!");
$retcode = "0";
//反馈状态 0 成功 200 自定义错误
} else {
if ($result == 'cancel') {
// $query = "update tb_transfermoneyglist set fd_tfmglist_payrq ='03' ,fd_tfmglist_paydate ='$nowdate'
// where fd_tfmglist_bkntno = '$bkntno'";
// $db->query($query);
// $query = "update tb_agentpaymoneylist set fd_agpm_payrq = '03' where fd_agpm_bkntno = '$bkntno'";
// $db->query($query);
$arr_message = array("result" => "success", "message" => "支付失败!");
$retcode = "200";
//反馈状态 0 成功 200 自定义错误
}
}
$arr_msg['msgbody']['result'] = $arr_message['result'];
$arr_msg['msgbody']['message'] = $arr_message['message'];
$returnvalue = array("msgbody" => array('result' => $arr_message['result'], "message" => $arr_message['message'], $arr_returninfo));
$returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
return $returnval;
}
