public function EditKuaibkcard()
{
$db = new DB_test();
$arr_header = $this->arr_header;
$arr_body = $this->arr_body;
$arr_channelinfo = $this->arr_channelinfo;
$authorid = trim($arr_channelinfo['authorid']);
$bkcardid = trim($arr_body['bkcardid']);
$bkcardbankcode = trim($arr_body['bkcardbankid']);
$bkcardbank = trim($arr_body['bkcardbank']);
$bkcardno = trim($arr_body['bkcardno']);
$bkcardbankman = trim($arr_body['bkcardbankman']);
$bkcardbankphone = trim($arr_body['bkcardbankphone']);
$bkcardyxmonth = trim($arr_body['bkcardyxmonth']);
$bkcardyxyear = trim($arr_body['bkcardyxyear']);
$bkcardcvv = trim($arr_body['bkcardcvv']);
$bkcardidcard = trim($arr_body['bkcardidcard']);
$bkcardcardtype = trim($arr_body['bkcardcardtype']);
$bkcardisdefault = trim($arr_body['bkcardisdefault']);
$bkcardbankid = getbankid(u2g($bkcardbank));
if ($bkcardisdefault == 1) {
$query = "UPDATE tb_author_quickpaycard SET fd_bkcardisdefault = 0 WHERE fd_bkauthorid = " . $authorid;
$db->query($query);
}
$query = "UPDATE tb_author_quickpaycard SET fd_bkcardno = '{$bkcardno}',fd_bkcardbankid = '{$bkcardbankid}',fd_bkcardbankcode = '{$bkcardbankcode}',fd_bkcardbank = '{$bkcardbank}',fd_bkcardbankman = '{$bkcardbankman}',fd_bkcardbankphone = '{$bkcardbankphone}',fd_bkcardyxmonth = '{$bkcardyxmonth}',fd_bkcardyxyear = '{$bkcardyxyear}',fd_bkcardcvv = '{$bkcardcvv}',fd_bkcardidcard = '{$bkcardidcard}',fd_bkcardisdefault = '{$bkcardisdefault}',fd_bkcardcardtype = '{$bkcardcardtype}' WHERE fd_bkcardid = " . $bkcardid;
$db->query(auto_charset($query, 'utf-8', 'gbk'));
$retcode = "0";
$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 CreateOrder($requestBody, $authorId, $payChannel)
{
$logger = Logger::getLogger("transfermoney");
$logger->debug("开始创建转账付款订单");
// 调用外部函数******
$logger->debug("正在创建转账付款订单 : 调用函数GetPayCalcuInfo::readpaycardid，传入参数(" . $requestBody["cardReaderId"] . ", " . $authorId . ")");
$agentInfo = GetPayCalcuInfo::readpaycardid($requestBody["cardReaderId"], $authorId);
$logger->debug("正在创建转账付款订单 : 调用函数GetPayCalcuInfo::readpaycardid，返回的结果" . print_r($agentInfo, true));
// ******调用外部函数
$cardReaderId = $agentInfo["paycardid"];
// 刷卡器ID
$agentId = $agentInfo["cusid"];
// 代理商ID
$payChannelFee = 0;
switch ($payChannel) {
case "YiBao":
$payChannelFee = YiBaoPay::GetPayFee($requestBody['payMoney']);
break;
}
$orderId = "tfbtfs" . date("YmdHiss") . mt_rand(1000, 9999);
// 调用外部函数******
$orderListNumber = makeorderno("transfermoneyglist", "tfmglist", "tfs");
// ******调用外部函数
$payDate = date("Y-m-d H:i:s");
$feeMoney = 0;
// 调用外部函数******
$logger->debug("正在创建转账付款订单 : 调用函数getbankid，传入参数(" . $requestBody["receiveBankName"] . ")");
$receiveBankId = getbankid(u2g($requestBody["receiveBankName"]));
if ($receiveBankId == "") {
ErrorReponse::reponError(array("retcode" => "200", "retmsg" => "不支持的银行"));
}
$logger->debug("正在创建转账付款订单 : 调用函数getbankid，返回的结果" . $receiveBankId);
$logger->debug("正在创建转账付款订单 : 调用函数GetPayCalcuInfo :: readPayFee，传入参数({$authorId}, {$receiveBankId}, " . $requestBody['transferMoney'] . ", " . $requestBody['arriveId'] . ", 2, " . $requestBody["payType"] . ")");
$payChannelFeeInfo = GetPayCalcuInfo::readPayFee($authorId, $receiveBankId, $requestBody['transferMoney'], $requestBody['arriveId'], 2, $requestBody["payType"]);
$logger->debug("正在创建转账付款订单 : 调用函数GetPayCalcuInfo :: readPayFee，返回的结果" . print_r($payChannelFeeInfo, true));
if (is_array($payChannelFeeInfo)) {
$feeMoney = $payChannelFeeInfo["feemoney"];
}
$arriveDate = GetPayCalcuInfo::getfeedate($payDate, $payChannelFeeInfo['addday']);
$logger->debug("正在创建转账付款订单 : 调用函数GetPayCalcuInfo :: getfeedate，返回的结果" . $arriveDate);
// ******调用外部函数
$query = "INSERT INTO tb_transfermoneyglist (fd_tfmglist_no, fd_tfmglist_bkordernumber, fd_tfmglist_payrq, fd_tfmglist_paycardid, fd_tfmglist_authorid, fd_tfmglist_sdcrid, fd_tfmglist_sdcrpayfeemoney, fd_tfmglist_sdcragentfeemoney, fd_tfmglist_paytype, fd_tfmglist_paydate, fd_tfmglist_payfeedirct, fd_tfmglist_fucardno, fd_tfmglist_fucardbank, \n\t\tfd_tfmglist_fucardmobile, fd_tfmglist_fucardman, \n\t\tfd_tfmglist_shoucardno, fd_tfmglist_shoucardbank, \n\t\tfd_tfmglist_shoucardman, fd_tfmglist_shoucardmobile, fd_tfmglist_sendsms, fd_tfmglist_shoucardmemo, fd_tfmglist_current, fd_tfmglist_paymoney, fd_tfmglist_payfee, fd_tfmglist_money, fd_tfmglist_feebankid, fd_tfmglist_arrivedate, fd_tfmglist_arriveid, fd_tfmglist_state) VALUES \n\t\t('{$orderListNumber}', '{$orderId}', '01', \n\t\t'{$cardReaderId}', {$authorId}, 3, {$payChannelFee}, \n\t\t0.00, '" . $requestBody["payType"] . "', '{$payDate}', 'f', \n\t\t'" . $requestBody["sendBankCardId"] . "', '" . $requestBody["sendBankName"] . "', \n\t\t'" . $requestBody["sendPhone"] . "', '" . $requestBody["sendPersonName"] . "', \n\t\t'" . $requestBody["receiveBankCardId"] . "', '" . $requestBody["receiveBankName"] . "', \n\t\t'" . $requestBody["receivePersonName"] . "', '" . $requestBody["receivePhone"] . "', 0, '', \n\t\t'RMB', " . $requestBody["transferMoney"] . ", {$feeMoney}, " . $requestBody["payMoney"] . ", {$receiveBankId}, \n\t\t'{$arriveDate}', '" . $requestBody['arriveId'] . "', '0')";
$logger->debug("新增数据进 tb_transfermoneyglist 的sql" . $query);
$db = new DB_test();
$db->query(u2g($query));
return $orderId;
}
public function SuptransferMoneyRq()
{
$db = new DB_test();
$arr_header = $this->arr_header;
$arr_body = $this->arr_body;
$arr_channelinfo = $this->arr_channelinfo;
$authorid = trim($arr_channelinfo['authorid']);
$paymoney = trim($arr_body['paymoney']);
$shoucardno = trim($arr_body['shoucardno']);
//收款卡号
$shoucardmobile = trim($arr_body['shoucardmobile']);
//收款人手机
$shoucardman = trim(u2g($arr_body['shoucardman']));
//收款人姓名
$shoucardbank = trim(u2g($arr_body['shoucardbank']));
//收款银行
$fucardno = trim($arr_body['fucardno']);
//付款卡号
$fucardbank = trim(u2g($arr_body['fucardbank']));
//付款银行
$fucardmobile = trim($arr_body['fucardmobile']);
//付款人手机
$fucardman = trim(u2g($arr_body['fucardman']));
//付款人姓名
$current = trim($arr_body['current']);
//币种
//$paycardid = trim(GetPayCalcuInfo::readpaycardid($arr_body['paycardid'])); //刷卡器设备号
$arr_paycard = GetPayCalcuInfo::readpaycardid($arr_body['paycardid'], $authorid);
//刷卡器设备号
$paycardid = $arr_paycard['paycardid'];
//刷卡器id
$cusid = trim($arr_paycard['cusid']);
//代理商
$paycardkey = trim($arr_paycard['paycardkey']);
//刷卡器key
$payfee = trim($arr_body['payfee']);
//authorid
$money = trim($arr_body['money']);
//币种
$shoucardmemo = trim(u2g($arr_body['shoucardmemo']));
//刷卡器设备号
$sendsms = trim($arr_body['sendsms']);
//authorid
$arriveid = trim($arr_body['arriveid']);
//币种
$paytype = 'suptfmg';
$feebankid = getbankid($shoucardbank);
//获得银行id返回string
CheckPayQuota::readPayQuota($authorid, $paycardid, $paytype, $paymoney);
//调用判断额度使用情况
$arr_feeinfo = GetPayCalcuInfo::readPayFee($authorid, $feebankid, $paymoney, $arriveid, 2, $paytype);
//获取手续费信息返回array
if (is_array($arr_feeinfo)) {
$feemoney = $arr_feeinfo['feemoney'];
}
$paydate = date("Y-m-d H:i:s");
$arrivedate = GetPayCalcuInfo::getfeedate($paydate, $arr_feeinfo['addday']);
$allmoney = round($paymoney + $feemoney, 2);
$payfeedirct = $arr_feeinfo['defeedirct'];
if ($arr_feeinfo['defeedirct'] == 's') {
$bkmoney = $paymoney;
} else {
$bkmoney = $allmoney;
}
$arr_feeinfo['arrivedate'] = $arrivedate;
$arr_feeinfo['paydate'] = $paydate;
$arr_feeinfo['bkmoney'] = $bkmoney;
$arr_feeinfo['payfeedirct'] = $payfeedirct;
$arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $bkmoney, $fucardno);
$bkntno = trim($arr_bkinfo['bkntno']);
$arr_feeinfo['sdcrid'] = $sdcrid = trim($arr_bkinfo['sdcrid']);
$sdcrpayfee = substr($arr_bkinfo['sdcrpayfee'], 0, -1);
//银联收取明盛浮动费率
$arr_feeinfo['sdcrpayfeemoney'] = $sdcrpayfeemoney = $bkmoney * $sdcrpayfee / 100 > $arr_bkinfo['minsdcrpayfee'] ? $bkmoney * $sdcrpayfee / 100 : $arr_bkinfo['minsdcrpayfee'];
$arr_feeinfo['bkordernumber'] = $bkorderNumber = $arr_bkinfo['bkorderNumber'];
$ccgno = makeorderno("transfermoneyglist", "tfmglist", "tfs");
$query = "insert into tb_transfermoneyglist(\n\t\t\t\t\t\t\tfd_tfmglist_no\t\t\t,fd_tfmglist_paycardid\t\t,fd_tfmglist_authorid\t,\n\t\t\t\t fd_tfmglist_paydate\t\t,fd_tfmglist_shoucardno\t\t,fd_tfmglist_fucardno\t,\n\t\t\t\t fd_tfmglist_bkntno\t\t,fd_tfmglist_payrq ,fd_tfmglist_paytype ,\n\t\t\t\t fd_tfmglist_current\t\t,fd_tfmglist_paymoney\t\t,fd_tfmglist_payfee\t\t ,\n\t\t\t\t fd_tfmglist_money\t\t,fd_tfmglist_shoucardbank ,fd_tfmglist_shoucardman ,\n\t\t\t\t fd_tfmglist_shoucardmobile,fd_tfmglist_fucardbank\t,fd_tfmglist_fucardmobile,\n\t\t\t\t fd_tfmglist_fucardman ,fd_tfmglist_feebankid ,fd_tfmglist_state ,\t\n\t\t\t\t fd_tfmglist_shoucardmemo,fd_tfmglist_sendsms ,fd_tfmglist_arriveid , \t\n\t\t\t\t fd_tfmglist_arrivedate ,fd_tfmglist_payfeedirct ,fd_tfmglist_bkordernumber," . "fd_tfmglist_sdcrid,fd_tfmglist_sdcrpayfeemoney)values\n\t\t\t\t\t\t ('{$ccgno}'\t\t,'{$paycardid}'\t,'{$authorid}'\t\t,\n\t\t\t\t\t\t '{$paydate}'\t\t,'{$shoucardno}'\t,'{$fucardno}'\t\t,\n\t\t\t\t\t\t '{$bkntno}'\t\t,'01'\t\t\t,'{$paytype}'\t\t\t,\n\t\t\t\t\t\t '{$current}'\t\t,'{$paymoney}'\t,'{$feemoney}'\t\t\t,\n\t\t\t\t\t\t '{$allmoney}'\t\t\t,'{$shoucardbank}','{$shoucardman}'\t\t,\n\t\t\t\t\t\t '{$shoucardmobile}','{$fucardbank}'\t,'{$fucardmobile}'\t,\n\t\t\t\t\t\t '{$fucardman}'\t\t,'{$feebankid}'\t,'0'\t\t\t\t,\n\t\t\t\t\t\t '{$shoucardmemo}'\t,'{$feebankid}' ,'{$arriveid}' , " . "'{$arrivedate}' ,'{$payfeedirct}' ,'{$bkorderNumber}' ,'{$sdcrid}' ,'{$sdcrpayfeemoney}' )";
$db->query($query);
$listid = $db->insert_id();
//$listid = $db->insert_id();
$method = 'in';
$method = u2g($method);
$gettrue = AgentPayglist::insertPayglist($this->reqxmlcontext, $bkntno, $listid, $ccgno, $paytype, $method, $arr_feeinfo);
$arr_message = array("result" => "success", "message" => "获取成功!");
$retcode = "0";
//反馈状态 0 成功 200 自定义错误
$arr_msg['msgbody']['result'] = $arr_message['result'];
$arr_msg['msgbody']['message'] = $arr_message['message'];
$arr_msg['msgbody']['bkntno'] = $bkntno;
$arr_msg['msgbody']['feemoney'] = $feemoney;
$returnvalue = array("msgbody" => $arr_msg['msgbody']);
$returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
return $returnval;
}
/**
* @ignore
*/
function isBankmRec($accid, $trantype, $date, $name, $descript, $cheqnum, $totamt, $accinv, $amounts, $accids, $vats, $chrgvats)
{
# Date format
$date = explode("-", $date);
$date = "{$date['2']}-{$date['1']}-{$date['0']}";
if (isbank($accid)) {
$bankid = getbankid($accid);
# Record the payment record
db_connect();
$sql = "\n\t\t\tINSERT INTO cashbook (\n\t\t\t\tbankid, trantype, date, name, descript, cheqnum, \n\t\t\t\tamount, vat, chrgvat, banked, accids, amounts, \n\t\t\t\tchrgvats, vats, div\n\t\t\t) VALUES (\n\t\t\t\t'{$bankid}', '{$trantype}', '{$date}', '{$name}', '{$descript}', '{$cheqnum}', \n\t\t\t\t'{$totamt}', '0', 'nov', 'no', '{$accids}', '{$amounts}', \n\t\t\t\t'{$chrgvats}', '{$vats}', '" . USER_DIV . "'\n\t\t\t)";
$Rslt = db_exec($sql) or errDie("Unable to add bank payment to database.", SELF);
}
}
