コード例 #1
0
 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;
 }
コード例 #2
0
 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);
             }
         }
     }
 }
コード例 #3
0
 public function readagentorder()
 {
     $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']);
     //操作者
     $msgstart = trim($arr_body['msgstart']) + 0;
     $msgdisplay = trim($arr_body['msgdisplay']) + 0;
     $arr_orderstate = array("订单处理", "已收款", "已发货", "已收货", "已取消");
     $arr_orderstate = auto_charset($arr_orderstate, 'utf-8', 'gbk');
     if ($msgstart < 0) {
         $msgstart = 0;
     }
     $query = "select\n                  fd_selt_id as orderid ,fd_selt_date as orderdate ,fd_selt_state as orderstate, fd_selt_memo as ordermemo ,\n                  case\n                  when fd_selt_state ='0' then '" . $arr_orderstate[0] . "'\n                  when fd_selt_state ='1' then '" . $arr_orderstate[1] . "'" . "when fd_selt_state ='2' then '" . $arr_orderstate[2] . "'\n            when fd_selt_state ='9' then '" . $arr_orderstate[3] . "'\n        else '" . $arr_orderstate[4] . "' END  orderstate1\n        from tb_salelist where fd_selt_cusid = '{$agentid}'";
     $db->query($query);
     $msgallcount = $db->nf();
     $query = "select\n                  fd_selt_id as orderid ,fd_selt_date as orderdate , fd_selt_state as orderstate,fd_selt_memo as ordermemo ,\n                  case\n                  when fd_selt_state ='0' then '" . $arr_orderstate[0] . "'\n                  when fd_selt_state ='1' then '" . $arr_orderstate[1] . "'" . "when fd_selt_state ='2' then '" . $arr_orderstate[2] . "'\n            when fd_selt_state ='9' then '" . $arr_orderstate[3] . "'\n        else '" . $arr_orderstate[4] . "' END  orderstate1\n        from tb_salelist where fd_selt_cusid = '{$agentid}' order by fd_selt_id desc limit {$msgstart},{$msgdisplay} ";
     $db->query($query);
     $msgdiscount = $db->nf();
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     if (!$arr_msg) {
         $arr_message = array("result" => "success", "message" => "没有数据!");
         $retcode = "0";
         //反馈状态 0 成功 200 自定义错误
     } else {
         $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']['msgallcount'] = $msgallcount;
     $arr_msg['msgbody']['msgdiscount'] = $msgdiscount + $msgstart;
     $arr_proinfo = getcusfenrun::getagentprodure($agentid);
     $produrename = $arr_proinfo['agentprodure'];
     $nowprice = $arr_proinfo['agentprice'];
     $limitminnum = $arr_proinfo['limitminnum'];
     $limitmaxnum = $arr_proinfo['limitmaxnum'];
     $produreid = $arr_proinfo['agentprodureid'];
     $arr_msg['msgbody']['limitmaxnum'] = $limitmaxnum;
     $arr_msg['msgbody']['nowprice'] = $nowprice;
     $arr_msg['msgbody']['limitminnum'] = $limitminnum;
     $arr_msg['msgbody']['produreid'] = $produreid;
     $arr_msg['msgbody']['produrename'] = $produrename;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
コード例 #4
0
 public function bkordernumbertokey($bkordernumber, $transStatus)
 {
     $arr_merinfo = array();
     $arr_merinfo2 = array();
     //通付宝银行卡对银行卡业务
     $query = "select fd_agpm_sdcrid as sdcrid,fd_agpm_authorid as authorid ,fd_agpm_paytype as paytype,\nfd_agpm_paydate as paydate,fd_agpm_cusid as cusid ,fd_agpm_sdcrpayfeemoney as sdcrpayfeemoney,\n        fd_agpm_paycardid as paycardid,fd_agpm_payfee as payfee ,fd_agpm_paymoney as paymoney\n          from tb_agentpaymoneylist where fd_agpm_bkordernumber = '{$bkordernumber}' limit 1";
     if ($this->DB_test->execute($query)) {
         $arr_merinfo = $this->DB_test->get_one($query);
     }
     //订单付款业务
     $query = "select fd_oplist_sdcrid as sdcrid,fd_oplist_authorid as authorid ,fd_oplist_paytype as paytype,\n                fd_oplist_paydate as paydate ,\n        fd_oplist_paycardid as paycardid,fd_oplist_payfee as payfee ,fd_oplist_paymoney as paymoney    from tb_orderpayglist where 1 and  fd_oplist_bkordernumber = '{$bkordernumber}' limit 1";
     $this->DB_test->query($query);
     if ($this->DB_test->execute($query)) {
         $arr_merinfo = $this->DB_test->get_one($query);
     }
     //购买刷卡器业务
     $query = "select fd_orderlist_sdcrid as sdcrid,fd_orderlist_authorid as authorid ,\n                 fd_orderlist_paytype as paytype, fd_orderlist_paydate as paydate ,\n                 fd_orderlist_price as orderprice,fd_orderlist_num as ordernum,fd_orderlist_cusid as cusid,\n                fd_orderlist_paycardid as paycardid,fd_orderlist_payfee as payfee ,fd_orderlist_ordermoney as paymoney  from tb_orderglist where 1 and  fd_orderlist_bkordernumber = '{$bkordernumber}' limit 1";
     if ($this->DB_test->execute($query)) {
         $arr_merinfo = $this->DB_test->get_one($query);
     }
     //手机卡充值业务
     $query = "select fd_mrclist_sdcrid as sdcrid ,fd_mrclist_authorid as authorid ,\n               fd_mrclist_paytype as paytype,fd_mrclist_paydate as paydate ,fd_mrclist_cusid as cusid,\n               fd_mrclist_sdcrpayfeemoney as sdcrpayfeemoney,\n               fd_mrclist_paycardid as paycardid,fd_mrclist_payfee as payfee ,fd_mrclist_paymoney as paymoney\n               from tb_mobilerechargelist where 1  and  fd_mrclist_bkordernumber = '{$bkordernumber}' limit 1";
     if ($this->DB_test->execute($query)) {
         $arr_merinfo = $this->DB_test->get_one($query);
     }
     //qq充值业务
     $query = "select fd_mrclist_sdcrid as sdcrid ,fd_mrclist_authorid as authorid ,\n                 fd_mrclist_paytype as paytype,fd_mrclist_paydate as paydate ,\n\n               fd_mrclist_sdcrpayfeemoney as sdcrpayfeemoney,\n                 fd_mrclist_paycardid as paycardid ,fd_mrclist_payfee as payfee ,fd_mrclist_cusid as cusid,\n                 fd_mrclist_paymoney as paymoney from tb_qqrechargelist where 1 and\n                 fd_mrclist_bkordernumber = '{$bkordernumber}' limit 1";
     if ($this->DB_test->execute($query)) {
         $arr_merinfo = $this->DB_test->get_one($query);
     }
     //代理商购买刷卡器
     $query = "select fd_selt_sdcrid as sdcrid ,fd_selt_authorid as authorid ,\n               fd_selt_paytype as paytype,fd_selt_paydate as paydate ,fd_selt_cusid,\n        fd_selt_paycardid as paycardid ,fd_selt_payfee as payfee ,fd_selt_paymoney as paymoney from tb_salelist\n         where 1 and  fd_selt_bkordernumber = '{$bkordernumber}' limit 1";
     if ($this->DB_test->execute($query)) {
         $arr_merinfo = $this->DB_test->get_one($query);
     }
     //获取第一次刷卡器交易成功时间
     if ($transStatus == '00') {
         $paycardid = $arr_merinfo['paycardid'];
         $paydate = $arr_merinfo['paydate'];
         if ($arr_merinfo['paydate'] == '0000-00-00' or $arr_merinfo['paydate'] == '') {
             $paydate = date("Y-m-d");
             $arr_merinfo['paydate'] = date("Y-m-d");
         }
         $this->paycardfirstactive($paycardid, $paydate);
     }
     $arr_merinfo['bkordernumber'] = $bkordernumber;
     $arr_merinfo['payrq'] = $transStatus;
     //获取分润金额
     $arr_cusfee = getcusfenrun::get_cusfenrun($arr_merinfo['cusid'], $arr_merinfo['paytype'], $arr_merinfo['paymoney'], $arr_merinfo['sdcrpayfeemoney'], $arr_merinfo['payfee'], $arr_merinfo['feelirun'], $paydate, $arr_merinfo['orderprice'], $arr_merinfo['ordernum']);
     $arr_merinfo['cusfee'] = $arr_cusfee['cusfee'];
     $arr_merinfo['tfbfenrun'] = $arr_cusfee['tfbfenrun'];
     $dle = $this->insertintocusfee($arr_merinfo);
     //插入分润金额;
     //获取交易时银联的合约公司KEY
     $query = "select\n\t\t         fd_sdcr_merid as merid,fd_sdcr_securitykey as securitykey,\n\t\t         fd_sdcr_id as sdcrid,fd_sdcr_payfee as sdcrpayfee,fd_sdcr_tradeurl as tradeurl,\n\t\t\t\t fd_sdcr_queryurl as queryurl,fd_sdcr_minpayfee as minsdcrpayfee,fd_sdcr_agentfee as sdcragentfee from tb_sendcenter\n where fd_sdcr_id= '" . $arr_merinfo['sdcrid'] . "'";
     if ($this->DB_test->execute($query)) {
         $arr_merinfo2 = $this->DB_test->get_one($query);
     }
     $arr_retrunmerinfo = array_merge($arr_merinfo, $arr_merinfo2);
     return $arr_retrunmerinfo;
 }