function changeaccountno($inorout, $payfee, $paycardid, $memo, $paymode, $tabname, $transid) { $db = new DB_test(); $no = makeorderno("tb_payfeelist", "payfee", "payfee"); if ($inorout == "in") { $money = "fd_payfee_addmoney"; } if ($inorout == "out") { $money = "fd_payfee_lessmoney"; } $query = "insert into tb_payfeelist \n\t(fd_payfee_no,fd_payfee_inorout,{$money},fd_payfee_datetime,fd_payfee_paycardid,\n\tfd_payfee_memo,fd_payfee_paymode,fd_payfee_tabname,fd_payfee_transid)\n\tvalues\n\t('{$no}','{$inorout}','{$payfee}',now(),'{$paycardid}','{$memo}','{$paymode}','{$tabname}','{$transid}')"; $db->query($query); }
public function CreateOrder($msgBody, $authorId, $payType) { $now = time(); $logger = Logger::getLogger('mobilerecharge'); $logger->debug("开始创建手机充值订单({$now})"); $arrPayCard = GetPayCalcuInfo::readpaycardid($msgBody['paycardid'], $authorId); // ****** $logger->debug("正在创建手机充值订单({$now}) : paycardid(" . $msgBody['paycardid'] . "),authorId({$authorId} ),arrPayCard(" . print_r($arrPayCard, true) . ")"); $payCardId = $arrPayCard['paycardid']; // 刷卡器ID $cusId = $arrPayCard['cusid']; // 代理商ID $payfee = 0; // 利润 = 用户支付给通付宝的钱 - 通付宝从向上的进货价- 支付通道的费率 $query = "SELECT (fd_recham_paymoney - fd_recham_costmoney) AS payfee \n\t\t\t\tFROM tb_mobilerechamoney WHERE fd_recham_money = '" . $msgBody['rechargeMoney'] . "'"; $db = new DB_test(); $dataInDB = $db->get_all($query); if (is_array($dataInDB) && count($dataInDB) == 1) { $payfee = $dataInDB[0]['payfee']; $logger->debug("正在创建手机充值订单({$now}) : 用户支付给通付宝的钱 - 通付宝从向上的进货价 = ({$payfee})"); } else { $logger->error("正在创建手机充值订单({$now}) : 无法获取面额" . $msgBody['rechargeMoney'] . "元所对应的利润值"); } $payTypeFee = 0; // 转账费率 switch ($payType) { case "YiBao": $payTypeFee = YiBaoPay::GetPayFee($msgBody['payMoney']); break; case "upmp": $payTypeFee = BankPayInfoV3::GetPayFee($msgBody['payMoney']); break; } // ******** $cusfeeResult = getcusfenrun::get_cusfenrun($cusId, "mobilerecharge", $msgBody['payMoney'], 0, $payfee, 0, date("Y-m-d"), null, null); //$cusfeeResult = getcusfenrun :: get_cusfenrun($cusId, "mobilerecharge", $msgBody['payMoney'], $payTypeFee, $payfee, 0, date("Y-m-d"), null, null); $logger->debug("正在创建手机充值订单({$now}) : cusId({$cusId} ),cusfeeResult(" . print_r($cusfeeResult, true) . ")"); $cusfee = $cusfeeResult["cusfee"]; $cusfee = $cusfee > 0 ? $cusfee : 0; $logger->debug("正在创建手机充值订单({$now}) : 通付宝的利润({$payfee}), 代理商的利润({$cusfee})"); $orderNumber = "tfbmrc" . date("YmdHiss") . mt_rand(1000, 9999); // 创建通付宝订单号 $listno = makeorderno("mobilerechargelist", "mrclist", "mrc"); // ****** $sql = "INSERT INTO tb_mobilerechargelist(fd_mrclist_no, fd_mrclist_paycardid, fd_mrclist_cusid, \n\t\t\t\tfd_mrclist_cusfee, fd_mrclist_authorid, fd_mrclist_paydate, \n\t\t\t\tfd_mrclist_bkordernumber, fd_mrclist_sdcrid, fd_mrclist_payrq, fd_mrclist_paytypeid, \n\t\t\t\tfd_mrclist_paytype, fd_mrclist_rechamoney, fd_mrclist_bkmoney, fd_mrclist_rechaphone, \n\t\t\t\tfd_mrclist_paymoney, fd_mrclist_payfee, fd_mrclist_mobileprov, fd_mrclist_bankcardno, \n\t\t\t\tfd_mrclist_state, fd_mrclist_date, fd_mrclist_datetime) VALUES \n\t\t\t\t('{$listno}', '{$payCardId}', '{$cusId}', \n\t\t\t\t'{$cusfee}', '{$authorId}', NOW(), \n\t\t\t\t'{$orderNumber}', 3, '01', '1', \n\t\t\t\t'mobilerecharge', '" . $msgBody['rechargeMoney'] . "', '" . $msgBody['payMoney'] . "', '" . $msgBody['rechargePhone'] . "', \n\t\t\t\t'" . $msgBody['payMoney'] . "', '{$payfee}', '" . $msgBody['mobileProvince'] . "', '" . $msgBody['bankCardId'] . "', \n\t\t\t\t'0', NOW(), NOW());"; $logger->debug("正在创建手机充值订单({$now}) : ({$sql})"); $sql = auto_charset($sql, 'utf-8', 'gbk'); $db->query($sql); return $orderNumber; }
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; }
function payOrderRq() { global $weburl; $db = new DB_test(); $arr_header = $this->arr_header; $arr_body = $this->arr_body; $arr_channelinfo = $this->arr_channelinfo; $authorid = trim($arr_channelinfo['authorid']); $paytype = 'orderbuy'; $orderpaytypeid = trim($arr_body['orderpaytypeid']); $orderprodureid = trim($arr_body['orderprodureid']); //支付类型id $ordernum = trim($arr_body['ordernum']); //充值金额 $orderprice = trim(u2g($arr_body['orderprice'])); //实际支付金额 $ordermoney = trim(u2g($arr_body['ordermoney'])); //订单金额 $ordershaddressid = trim($arr_body['ordershaddressid']); //手机所属地区 $oredershaddress = trim(u2g($arr_body['oredershaddress'])); //银行卡号 $ordershman = trim(u2g($arr_body['ordershman'])); //银行卡关联id tb_banckcard.fd_bankcard_id $ordershphone = trim(u2g($arr_body['ordershphone'])); //认证信息 $orderfucardno = trim(u2g($arr_body['orderfucardno'])); //认证信息 $orderfucardbank = trim(u2g($arr_body['orderfucardbank'])); //认证信息 $ordermemo = trim(u2g($arr_body['ordermemo'])); //认证信息 $agentno = trim(u2g($arr_body['agentno'])); //认证信息 $orderpaytype = trim($arr_body['paytype']); $promoney = trim(u2g($arr_body['promoney'])); //认证信息 $yunmoney = trim(u2g($arr_body['yunmoney'])); //认证信息 $produrename = trim(u2g($arr_body['produrename'])); $bkmoney = $ordermoney; //promoney+yunmoney $rechabkcardno = makeorderno("orderglist", "orderlist", "orl"); $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $bkmoney, $orderfucardno); $bkntno = trim($arr_bkinfo['bkntno']); $sdcrid = trim($arr_bkinfo['sdcrid']); if ($agentno != "") { // $cusid =$this->checkcusagentno($agentno); $query = "select fd_cus_id as cusid from tb_customer where fd_cus_no = '{$agentno}'"; if ($db->execute($query)) { $arr_cusinfo = $db->get_one($query); $cusid = $arr_cusinfo['cusid']; } else { $arr_message = array("result" => "failure", "message" => "对不起,您填写的代理商代号错误,请重新填写!"); $retcode = "200"; //反馈状态 0 成功 200 自定义错误 $arr_msg['msgbody']['result'] = $arr_message['result']; $arr_msg['msgbody']['message'] = $arr_message['message']; $arr_msg['msgbody']['bkntno'] = $bkntno; $returnvalue = array("msgbody" => $arr_msg['msgbody']); $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue); return $returnval; exit; } } $datetime = date("Y-m-d H:i:s"); $date = date("Y-m-d"); //$bkmoney = $bkorderNumber = trim($arr_bkinfo['bkorderNumber']); $datadetailArray['fd_orderlist_paytype'] = $paytype; $datadetailArray['fd_orderlist_no'] = $listno; $datadetailArray['fd_orderlist_authorid'] = $authorid; $datadetailArray['fd_orderlist_bkntno'] = $bkntno; $datadetailArray['fd_orderlist_date'] = $date; $datadetailArray['fd_orderlist_payrq'] = '01'; //刚请求的交易码状态为01 $datadetailArray['fd_orderlist_bkordernumber'] = $bkorderNumber; $datadetailArray['fd_orderlist_sdcrid'] = $sdcrid; $datadetailArray['fd_orderlist_produreid'] = $orderprodureid; $datadetailArray['fd_orderlist_produrename'] = $produrename; $datadetailArray['fd_orderlist_cusid'] = $cusid; //分润代理商 $datadetailArray['fd_orderlist_num'] = $ordernum; $datadetailArray['fd_orderlist_price'] = $orderprice; $datadetailArray['fd_orderlist_promoney'] = $promoney; $datadetailArray['fd_orderlist_yunmoney'] = $yunmoney; $datadetailArray['fd_orderlist_ordermoney'] = $ordermoney; $datadetailArray['fd_orderlist_shaddressid'] = $ordershaddressid; $datadetailArray['fd_orderlist_shaddress'] = $oredershaddress; $datadetailArray['fd_orderlist_shman'] = $ordershman; $datadetailArray['fd_orderlist_shphone'] = $ordershphone; $datadetailArray['fd_orderlist_fucardno'] = $orderfucardno; $datadetailArray['fd_orderlist_fucardbank'] = $orderfucardbank; $datadetailArray['fd_orderlist_memo'] = $ordermemo; $datadetailArray['fd_orderlist_datetime'] = $datetime; $datadetailArray['fd_orderlist_agentno'] = $agentno; $db->insert("tb_orderglist", $datadetailArray); $listid = $db->insert_id(); $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; $returnvalue = array("msgbody" => $arr_msg['msgbody']); $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue); return $returnval; }
function RechaMoneyRq() { global $weburl; $db = new DB_test(); $arr_header = $this->arr_header; $arr_body = $this->arr_body; $arr_channelinfo = $this->arr_channelinfo; $authorid = trim($arr_channelinfo['authorid']); $paytype = 'qqrecharge'; $paycardid = trim($arr_body['paycardid']); $paytypeid = trim($arr_body['rechapaytypeid']); //支付类型id $rechamoney = trim($arr_body['rechamoney']); //充值金额 $rechapaymoney = trim(u2g($arr_body['rechapaymoney'])); //实际支付金额 $rechaqq = trim(u2g($arr_body['rechaqq'])); //充值手机号码 $qqhasrechamoney = $this->readQQhasRechamoney($rechaqq); $allqqremoney = $qqhasrechamoney + $rechamoney; if ($allqqremoney > 5000) { $retcode = "200"; $arr_msg['msgbody']['result'] = "failure"; $arr_msg['msgbody']['message'] = "对不起,每个QQ号码每天累计充值Q币数不能大于5000!"; $returnvalue = array("msgbody" => $arr_msg['msgbody']); $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue); return $returnval; } $rechaqqprov = trim($arr_body['rechaqqprov']); //手机所属地区 $rechabkcardno = trim(u2g($arr_body['rechabkcardno'])); //银行卡号 $rechabkcardid = trim($arr_body['rechabkcardid']); //银行卡关联id tb_banckcard.fd_bankcard_id $merReserved = trim(u2g($arr_body['merReserved'])); //认证信息 // $current = trim($arr_body['current']); //币种 // $paycardid = trim(GetPayCalcuInfo::readpaycardid($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 //$feebankid = getbankid($shoucardbank); //获得银行id返回string $onepayfee = $this->readRechacostmoney($rechamoney); $payfee = $onepayfee * $rechamoney; //金额也就是数量 $bkmoney = $rechapaymoney; $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $bkmoney, $rechabkcardno); $bkntno = trim($arr_bkinfo['bkntno']); $sdcrid = trim($arr_bkinfo['sdcrid']); $sdcrpayfee = substr($arr_bkinfo['sdcrpayfee'], 0, -1); //银联收取明盛浮动费率 $sdcrpayfeemoney = $bkmoney * $sdcrpayfee / 100 > $arr_bkinfo['minsdcrpayfee'] ? $bkmoney * $sdcrpayfee / 100 : $arr_bkinfo['minsdcrpayfee']; $paydate = date("Y-m-d H:i:s"); $today = date("Ymd"); //$bkmoney = $bkorderNumber = trim($arr_bkinfo['bkorderNumber']); $listno = makeorderno("qqrechargelist", "mrclist", "mrc"); $datadetailArray['fd_mrclist_no'] = $listno; $datadetailArray['fd_mrclist_paycardid'] = $paycardid; $datadetailArray['fd_mrclist_authorid'] = $authorid; $datadetailArray['fd_mrclist_bkntno'] = $bkntno; $datadetailArray['fd_mrclist_paydate'] = $paydate; $datadetailArray['fd_mrclist_payrq'] = '01'; //刚请求的交易码状态为01 $datadetailArray['fd_mrclist_paytypeid'] = $paytypeid; //手机充值支付类型 跟paytype 无任何关系 $datadetailArray['fd_mrclist_paytype'] = $paytype; //业务类型 $datadetailArray['fd_mrclist_bkordernumber'] = $bkorderNumber; $datadetailArray['fd_mrclist_sdcrpayfeemoney'] = $sdcrpayfeemoney; $datadetailArray['fd_mrclist_sdcrid'] = $sdcrid; $datadetailArray['fd_mrclist_rechamoney'] = $rechamoney; $datadetailArray['fd_mrclist_bkmoney'] = $bkmoney; $datadetailArray['fd_mrclist_qq'] = $rechaqq; $datadetailArray['fd_mrclist_paymoney'] = $rechapaymoney; $datadetailArray['fd_mrclist_payfee'] = $payfee; $datadetailArray['fd_mrclist_qqprov'] = u2g($rechaqqprov); $datadetailArray['fd_mrclist_bankcardno'] = $rechabkcardno; $datadetailArray['fd_mrclist_bankcardid'] = $rechabkcardid; $datadetailArray['fd_mrclist_bankcardbank'] = $rechabkcardname; $datadetailArray['fd_mrclist_date'] = $today; $datadetailArray['fd_mrclist_datetime'] = $paydate; $datadetailArray['fd_mrclist_cusid'] = $cusid; $db->insert("tb_qqrechargelist", $datadetailArray); $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; $returnvalue = array("msgbody" => $arr_msg['msgbody']); $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue); return $returnval; }
require "../include/common.inc.php"; require "../function/changecouponglide.php"; $db = new db_test(); $gourl = "tb_coupon_b.php"; $gotourl = $gourl . $tempurl; require "../include/alledit.1.php"; switch ($action) { case "delete": $query = "delete from tb_coupon where fd_coupon_id ='{$listid}' "; $db->query($query); require "../include/alledit.2.php"; echo "<script>alert('删除成功!');location.href='{$gourl}'</script>"; break; case "new": //编辑记录 $no = makeorderno("tb_coupon", "coupon", "cou"); $query = "insert into tb_coupon (fd_coupon_no,fd_coupon_money,fd_coupon_active,fd_coupon_datetime,fd_coupon_memo,fd_coupon_limitnum)\n\t\t\tvalues\n\t\t\t('{$no}','{$money}' ,'{$active}',now(),'{$memo}','{$limitnum}')"; $db->query($query); require "../include/alledit.2.php"; echo "<script>alert('保存成功!');location.href='{$gourl}'</script>"; break; case "edit": $query = "update tb_coupon set fd_coupon_no='{$no}',fd_coupon_money='{$money}',fd_coupon_active='{$active}',fd_coupon_limitnum = '{$limitnum}',\nfd_coupon_memo='{$memo}' where fd_coupon_id ='{$listid}' "; $db->query($query); require "../include/alledit.2.php"; echo "<script>alert('修改成功!');location.href='{$gourl}'</script>"; break; } $t = new Template(".", "keep"); $t->set_file("coupon", "coupon.html"); if (!empty($listid)) {
public function orderPayReq() { $db = new DB_test(); $arr_header = $this->arr_header; $arr_body = $this->arr_body; $arr_channelinfo = $this->arr_channelinfo; $orderid = g2u(trim($arr_body['orderid'])); $orderno = g2u(trim($arr_body['orderno'])); $paymoney = trim($arr_body['paymoney'] + 0); $fucardno = g2u(trim($arr_body['bankcardno'])); $bankname = g2u(trim($arr_body['bankname'])); $authorid = g2u(trim($arr_channelinfo['authorid'])); //$paycardid = u2g(trim(GetPayCalcuInfo::readpaycardid($arr_body['paycardid']))); //银行类型 $arr_message = array("result" => "success", "message" => "成功获取订单交易流水号!"); $arr_msg['msgbody']['result'] = $arr_message['result']; $arr_msg['msgbody']['message'] = $arr_message['message']; $bkmoney = $paymoney; $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $paymoney, $fucardno); $bkntno = trim($arr_bkinfo['bkntno']); $arr_feeinfo['bkordernumber'] = $bkorderNumber = $arr_bkinfo['bkorderNumber']; $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']; $paytype = 'order'; $arr_msg['msgbody']['bkntno'] = $bkntno; $ccgno = makeorderno("orderpayglist", "oplist", "opg"); $query = "insert into tb_orderpayglist(\n\t\t\t\t\t\t\t\t\tfd_oplist_no\t\t\t,fd_oplist_paycardid\t\t,fd_oplist_authorid\t,\n\t\t\t\t\t\t fd_oplist_paydate\t\t,fd_oplist_orderid \t\t,fd_oplist_fucardno\t,\n\t\t\t\t\t\t fd_oplist_bkntno\t\t,fd_oplist_payrq ,fd_oplist_paytype ,\n\t\t\t\t\t\t fd_oplist_current\t\t,fd_oplist_paymoney\t\t ,fd_oplist_payfee\t\t,\n\t\t\t\t\t\t fd_oplist_money\t\t,fd_oplist_orderno ,fd_oplist_shopid ,\n\t\t\t\t\t\t fd_oplist_fucardbank\t\t,fd_oplist_fucardmobile,\n\t\t\t\t\t\t fd_oplist_fucardman ,fd_oplist_feebankid ,fd_oplist_state ," . "fd_oplist_bkorderNumber,fd_oplist_sdcrid\t\t,fd_oplist_sdcrpayfeemoney \t\n\t\t\t\t\t\t )values\n\t\t\t\t\t\t\t\t ('{$ccgno}'\t\t,'{$paycardid}'\t,'{$authorid}'\t\t,\n\t\t\t\t\t\t\t\t '{$paydate}'\t\t,'{$orderid}'\t\t,'{$fucardno}'\t\t,\n\t\t\t\t\t\t\t\t '{$bkntno}'\t\t,'01'\t\t\t,'{$paytype}'\t\t\t,\n\t\t\t\t\t\t\t\t '{$current}'\t\t,'{$paymoney}'\t,'{$payfee}'\t\t\t,\n\t\t\t\t\t\t\t\t '{$paymoney}'\t\t,'{$orderno}'\t\t,'{$shopid}'\t\t\t,\n\t\t\t\t\t\t\t\t '{$fucardbank}'\t,'{$fucardmobile}',\n\t\t\t\t\t\t\t\t '{$fucardman}'\t\t,'{$feebankid}'\t,'0'," . "'{$bkorderNumber}' ,'{$sdcrid}' \t\t, '{$sdcrpayfeemoney}')"; $db->query($query); $returnvalue = array("msgbody" => $arr_msg['msgbody']); $retcode = "0"; //反馈状态 0 成功 200 自定义错误 $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue); return $returnval; }
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; }
function payagentOrderRq() { global $weburl; $db = new DB_test(); $arr_header = $this->arr_header; $arr_body = $this->arr_body; $arr_channelinfo = $this->arr_channelinfo; $authorid = trim($arr_channelinfo['authorid']); $agentid = trim($arr_channelinfo['agentid']); $paytype = 'agentbuy'; $orderprodureid = trim($arr_body['orderprodureid']); //支付类型id $ordernum = trim($arr_body['ordernum']); //充值金额 $orderprice = trim(u2g($arr_body['orderprice'])); //实际支付金额 $ordermoney = trim(u2g($arr_body['ordermoney'])); //订单金额 $orderfucardno = trim(u2g($arr_body['orderfucardno'])); //认证信息 $orderfucardbank = trim(u2g($arr_body['orderfucardbank'])); //认证信息 $ordermemo = trim(u2g($arr_body['ordermemo'])); //认证信息 $agentno = trim(u2g($arr_body['agentno'])); //认证信息 $arr_paycard = GetPayCalcuInfo::readpaycardid($arr_body['paycardid'], $authorid); //刷卡器设备号 $paycardid = $arr_paycard['paycardid']; //刷卡器id $cusid = trim($arr_paycard['cusid']); //代理商 $ordermemo = "自订刷卡器" . $ordernum; $bkmoney = $ordermoney; //promoney+yunmoney $paymoney = $ordermoney; $listno = makeorderno("salelist", "selt", "xs"); $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $bkmoney, $orderfucardno); $bkntno = trim($arr_bkinfo['bkntno']); $sdcrid = trim($arr_bkinfo['sdcrid']); $datetime = date("Y-m-d H:i:s"); $date = date("Y-m-d"); $bkorderNumber = trim($arr_bkinfo['bkorderNumber']); $type = "app"; //自订 $datadetailArray['fd_selt_paytype'] = $paytype; $datadetailArray['fd_selt_no'] = $listno; $datadetailArray['fd_selt_authorid'] = $authorid; $datadetailArray['fd_selt_bkntno'] = $bkntno; $datadetailArray['fd_selt_date'] = $date; $datadetailArray['fd_selt_payrq'] = '01'; //刚请求的交易码状态为01 $datadetailArray['fd_selt_bkordernumber'] = $bkorderNumber; $datadetailArray['fd_selt_sdcrid'] = $sdcrid; $datadetailArray['fd_selt_produreid'] = $orderprodureid; $datadetailArray['fd_selt_allquantity'] = $ordernum; $datadetailArray['fd_selt_saleprice'] = $orderprice; $datadetailArray['fd_selt_fucardno'] = $orderfucardno; $datadetailArray['fd_selt_fucardbank'] = $orderfucardbank; $datadetailArray['fd_selt_memo'] = u2g($ordermemo); $datadetailArray['fd_selt_datetime'] = $datetime; $datadetailArray['fd_selt_cusid'] = $agentid; //代理商id $datadetailArray['fd_selt_paymoney'] = $paymoney; //代理商id $datadetailArray['fd_selt_authorid'] = $authorid; //代理商id $datadetailArray['fd_selt_type'] = $type; $datadetailArray['fd_selt_skfs'] = '5'; //在线支付 $db->insert("tb_salelist", $datadetailArray); $listid = $db->insert_id(); $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; $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; }