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 couponSale() { $db = new DB_test(); $arr_header = $this->arr_header; $arr_body = $this->arr_body; $arr_channelinfo = $this->arr_channelinfo; $authorid = $arr_channelinfo['authorid']; $couponid = trim($arr_body['couponid']); $paymoney = trim($arr_body['couponmoney']); //$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 $fucardno = trim($arr_body['creditcardno']); $fubank = trim(u2g($arr_body['creditbank'])); $fucardman = trim(u2g($arr_body['creditcardman'])); $fucardphone = trim(u2g($arr_body['creditcardphone'])); $paytype = 'coupon'; $req_appenv = trim($arr_header['req_appenv']); // echo "fdf"; $checkbankinfo = $this->checkshoubankinfo($authorid, $req_appenv); //检测我的银行卡信息有没填写 $arr_feeinfo = GetPayCalcuInfo::readPayFee($authorid, "", $paymoney, "", 5); //获取手续费信息返回array if (is_array($arr_feeinfo)) { $feemoney = $arr_feeinfo['feemoney']; } $allmoney = round($paymoney + $feemoney, 2); $arr_arrive = GetPayCalcuInfo::readarrive($arr_feeinfo['arriveid']); $paydate = date("Y-m-d H:i:s"); $arrivedate = GetPayCalcuInfo::getfeedate($paydate, $arr_feeinfo['addday']); $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; $payfee = $feemoney; $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $paymoney, $fucardno); $arr_authorinfo = AuToken::getauthorusername($authorid); $arr_feeinfo['shoucardno'] = $shoucardno = $arr_authorinfo['shoucardno']; $arr_feeinfo['shoucardmobile'] = $shoucardmobile = $arr_authorinfo['shoucardmobile']; $arr_feeinfo['shoucardbank'] = $shoucardbank = $arr_authorinfo['shoucardbank']; $arr_feeinfo['shoucardman'] = $shoucardman = $arr_authorinfo['shoucardman']; $bkntno = trim($arr_bkinfo['bkntno']); $arr_feeinfo['bkordernumber'] = $bkordernumber = $arr_bkinfo['bkorderNumber']; $arr_feeinfo['bkmoney'] = $bkmoney = $paymoney; $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']; $ccgno = makeorderno("couponsale", "couponsale", "cps"); $query = "insert into tb_couponsale\n\t\t\t\t\t(fd_couponsale_no\t,\tfd_couponsale_bkntno\t,\tfd_couponsale_couponno\t,\n\t\t\t\t\tfd_couponsale_paycardid,fd_couponsale_authorid ,\tfd_couponsale_money,\n\t\t\t\t\tfd_couponsale_rebuy,\tfd_couponsale_state,\t\tfd_couponsale_datetime,\n\t\t fd_couponsale_couponid,\tfd_couponsale_payrq,\t\tfd_couponsale_creditcardno,\n\t\t fd_couponsale_creditcardbank,fd_couponsale_creditcardman,fd_couponsale_creditcardphone," . "fd_couponsale_bkordernumber,fd_couponsale_sdcrid, fd_couponsale_sdcrpayfeemoney," . "fd_couponsale_paymoney , fd_couponsale_payfee , fd_couponsale_bkmoney ," . "fd_couponsale_shoucardno,fd_couponsale_shoucardman,fd_couponsale_shoucardbank," . "fd_couponsale_shoucardmobile\n\t\t )values\n\t\t\t\t\t('{$ccgno}'\t\t\t,\t'{$bkntno}'\t\t\t\t,\t'{$bkorderNumber}',\n\t\t\t\t\t'{$paycardid}'\t\t,\t'{$authorid}'\t\t\t\t,\t'{$paymoney}',\n\t\t\t\t\t'0'\t\t\t\t\t,\t'0'\t\t\t\t\t\t,\t now()\t\t ,\n\t\t\t\t\t'{$couponid}'\t\t\t,\t'01' \t\t\t\t\t, '{$fucardno}',\n\t\t\t\t\t'{$fubank}' , '{$fucardman}' , '{$fucardphone}' , " . "'{$bkordernumber}' , '{$sdcrid}' , '{$sdcrpayfeemoney}'," . "'{$paymoney}' , '{$payfee}' , '{$bkmoney}' ," . "'{$shoucardno}' , '{$shoucardman}' , '{$shoucardbank}' ," . "'{$shoucardmobile}' ) "; $db->query($query); $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'] = trim($bkntno); $returnvalue = array("msgbody" => $arr_msg['msgbody']); $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue); return $returnval; }
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; }