public function authorMenuCount() { $db = new DB_test(); $arr_header = $this->arr_header; $arr_body = $this->arr_body; $arr_channelinfo = $this->arr_channelinfo; $appmnuid = $arr_body['appmnuid']; $authorid = $arr_channelinfo['authorid']; $query = "select fd_appmnuc_count as count from tb_appmenucout where fd_appmnuc_authorid = '{$authorid}'\n and fd_appmnuc_appmnuid = '{$appmnuid}' "; $db->query($query); if ($db->nf()) { $arr_val = $db->get_one($query); $count = $arr_val['count']; $querywhere = " fd_appmnuc_authorid = '{$authorid}'\n and fd_appmnuc_appmnuid = '{$appmnuid}'"; $dateArray['fd_appmnuc_count'] = $count + 1; $db->update("tb_appmenucout", $dateArray, $querywhere); } else { $dateArray['fd_appmnuc_authorid'] = $authorid; $dateArray['fd_appmnuc_appmnuid'] = $appmnuid; $dateArray['fd_appmnuc_count'] = $memo; $db->insert("tb_appmenucout", $dateArray); } $listid = $db->insert_id(); //取出刚插入的记录的主关键值的id $arr_message = array("result" => "success", "message" => "插入数据成功!", "retcode" => "0"); $retcode = "0"; //反馈状态 0 成功 200 自定义错误 $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; }
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; }
}*/ foreach ($arr_coupbkntno as $val) { if (checkagpminfo::checkagpmbkntno($val)) { foreach ($arr_coupval[$val] as $key => $value) { $query = "update tb_agentpaymoneylist set fd_agpm_" . $key . " = '{$value}' where fd_agpm_bkntno = '{$val}'"; $db->query($query); //echo $query."</br>"; } } else { foreach ($arr_coupval[$val] as $key => $value) { $apmgkey = "fd_agpm_" . $key; $arr_insert[$i][$apmgkey] = $value; } foreach ($arr_insert as $dataArray) { $db->insert('tb_agentpaymoneylist', $dataArray); } //$query = "insert into tb_agentpaymoneylist set fd_agpm_".$key." = '$value'"; //$db->query($query); } $i++; } class checkagpminfo { public static function checkagpmbkntno($bkntno) { $db = new DB_test(); $query = "select fd_agpm_bkntno as bkntno from tb_agentpaymoneylist where fd_agpm_bkntno = '{$bkntno}'"; //$query="select fd_agpm_bkntno as bkntno from tb_agentpaymoneylist where fd_agpm_bkntno = '201308212125170033372'"; $db->query($query); if ($db->nf()) {
public function YiBaoPayFeedback($payResult, $orderId) { if ($payResult["r1_Code"] == "1") { $db = new DB_test(); $query = "update tb_transfermoneyglist set fd_tfmglist_payrq ='00' ,fd_tfmglist_paydate = NOW(), fd_tfmglist_bkntno = '" . $payResult['r2_TrxId'] . "' where fd_tfmglist_bkordernumber = '{$orderId}'"; $db->query($query); $query = "update tb_agentpaymoneylist set fd_agpm_payrq = '00', fd_agpm_bkntno = '" . $payResult['r2_TrxId'] . "' where fd_agpm_bkordernumber = '{$orderId}'"; $db->query($query); $query = "select 1 from tb_cus_fenrunglist where 1 and fd_frlist_bkordernumber = '" . $orderId . "' limit 1"; if ($db->execute($query)) { } else { $query = "SELECT fd_tfmglist_authorid AS authorid, fd_author_cusid AS cusid, fd_tfmglist_paycardid AS paycardid, fd_tfmglist_paydate AS paydate, fd_tfmglist_paymoney AS paymoney, fd_tfmglist_payfee AS payfee, fd_tfmglist_sdcrpayfeemoney AS sdcrpayfeemoney, fd_tfmglist_paytype AS paytype, fd_tfmglist_sdcrpayfeemoney FROM tb_transfermoneyglist WHERE fd_tfmglist_bkordernumber = '{$orderId}'"; if ($db->execute($query)) { $arr_info = $db->get_one($query); $cusfee = 0; $tfbfenrun = 0; $cusfeeResult = getcusfenrun::get_cusfenrun($arr_info['cusid'], $arr_info['paytype'], $arr_info['payMoney'], $arr_info['fd_tfmglist_sdcrpayfeemoney'], $arr_info['fd_tfmglist_payfee'], 0, date("Y-m-d"), null, null); $cusfee = $cusfeeResult["cusfee"]; $tfbfenrun = $arr_cusfee['tfbfenrun']; unset($dateArray); $dateArray['fd_frlist_authorid'] = $arr_info['authorid']; $dateArray['fd_frlist_cusid'] = $arr_info['cusid']; $dateArray['fd_frlist_paycardid'] = $arr_info['paycardid']; $dateArray['fd_frlist_paydate'] = $arr_info['paydate']; $dateArray['fd_frlist_paymoney'] = $arr_info['paymoney']; $dateArray['fd_frlist_payfee'] = $arr_info['payfee']; $dateArray['fd_frlist_cusfee'] = $cusfee; $dateArray['fd_frlist_bkordernumber'] = $orderId; $dateArray['fd_frlist_payrq'] = '00'; $dateArray['fd_frlist_paytype'] = $arr_info['paytype']; $dateArray['fd_frlist_sdcrid'] = 3; $dateArray['fd_frlist_sdcrpayfeemoney'] = $arr_info['sdcrpayfeemoney']; $dateArray['fd_frlist_tfbfenrun'] = $tfbfenrun; $dateArray['fd_frlist_datetime'] = date("Y-m-d H:i:s"); $db->insert("tb_cus_fenrunglist", $dateArray); } } } }
private function customerProfit($orderInDB) { $logger = Logger::getLogger('gamerecharge'); $logger->debug("start customerProfit"); if (is_array($orderInDB) && count($orderInDB) == 1 && $orderInDB[0]['fd_grclist_cusid'] != null) { $profitArray = array(); $profitArray['fd_frlist_authorid'] = $orderInDB[0]['fd_grclist_authorid']; $profitArray['fd_frlist_cusid'] = $orderInDB[0]['fd_grclist_cusid']; $profitArray['fd_frlist_paycardid'] = $orderInDB[0]['fd_grclist_paycardid']; $profitArray['fd_frlist_paydate'] = date("Ymd"); $profitArray['fd_frlist_paymoney'] = $orderInDB[0]['fd_grclist_paymoney']; $profitArray['fd_frlist_payfee'] = $orderInDB[0]['fd_grclist_payfee']; $profitArray['fd_frlist_cusfee'] = $orderInDB[0]['fd_grclist_payfee'] * 0.27; $profitArray['fd_frlist_bkordernumber'] = $orderInDB[0]['fd_grclist_bkordernumber']; $profitArray['fd_frlist_payrq'] = '00'; $profitArray['fd_frlist_paytype'] = 'game'; $profitArray['fd_frlist_datetime'] = date("Y-m-d H:i:s"); $profitArray['fd_frlist_ifjsfenrun'] = 0; $profitArray['fd_frlist_sdcrid'] = $orderInDB[0]['fd_grclist_sdcrid']; $logger->debug("process customerProfit : " . print_r($profitArray, true)); $db = new DB_test(); $db->insert("tb_cus_fenrunglist", $profitArray); $logger->info("complete customerProfit : " . print_r($profitArray, true)); } }
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; }